Search found 440 matches
- Wed Apr 17, 2024 3:56 pm
- Forum: PATSTAT Product Line
- Topic: Countries (Publication) Query
- Replies: 1
- Views: 691
Patents on "coffee" from MX applicants.
Using appln_auth = 'MX' is about patents filed at the Mexican patent office. Using the person country is about applicants (or inventors) that have their place of business in Mexico. One can of course also combine the 2 conditions. "Patents about coffee" might need some fine tuning, but IPC...
- Wed Apr 17, 2024 3:38 pm
- Forum: PATSTAT Product Line
- Topic: Understanding results of number of patent applications
- Replies: 5
- Views: 3142
Re: Understanding results of number of patent applications
@ i.dijkstra.8 There are no functional restrictions exept for the download volumes and the limitation to 1 month free use. Your first query works fine. (no errors) The second one had a small error due to inconsistent use of the tls201_appln alias (t1). From a concept point of view, if you want to me...
- Wed Apr 17, 2024 2:17 pm
- Forum: PATSTAT Product Line
- Topic: Understanding results of number of patent applications
- Replies: 5
- Views: 3142
Re: Understanding results of number of patent applications
@khanhhienbi, you can count distinct docdb families, but then you will loose the granularity of knowing where the patents were filed. It is 2 different things: number of families is a proxy for "number of inventions". Family size is an indication of the geographical scope of where the inve...
- Wed Apr 17, 2024 2:06 pm
- Forum: PATSTAT Product Line
- Topic: Counting countries where the same patent has been registered
- Replies: 3
- Views: 623
Re: Counting countries where the same patent has been registered
For details explanation about the docdb_family_size, kindly see that PATSTAT data catalog. The "logics" in the query are not 100% correct, because a patent family can have patents filed in different years; and the family members will be filed (mostly) in different countries. So having the ...
- Wed Apr 17, 2024 1:10 pm
- Forum: PATSTAT Product Line
- Topic: Searching by keywords in abstract and title
- Replies: 4
- Views: 717
Re: Searching by keywords in abstract and title
Espacenet has a limitation in the download of 500 families. You can use the family number in PATSTAT via the docdb_fam_id in tls201_appln. If you want to have more then 500 then you will need to chunk it up in ESPACENET. I mostly use the "Earliest publication date (family)" in the filter t...
- Wed Apr 17, 2024 12:53 pm
- Forum: PATSTAT Product Line
- Topic: Changing column from country of origin to city of origin
- Replies: 5
- Views: 840
Re: Changing column from country of origin to city of origin
Using WHERE LEFT(cpc_class_symbol, 3) = 'Y02' OR LEFT(cpc_class_symbol, 4) IN ('Y02A', 'Y02B', 'Y02C', 'Y02D', 'Y02E', 'Y02P', 'Y02T', 'Y02W') is overlapping; the LEFT(cpc_class_symbol, 4) will not add anything as you allready take all "Y02"s. But the reason for the limited number of resul...
- Wed Apr 17, 2024 11:26 am
- Forum: PATSTAT Product Line
- Topic: Comparison Triadic Patent Count and JPO/EPO/USTPO Patent Applications
- Replies: 3
- Views: 713
Re: Comparison Triadic Patent Count and JPO/EPO/USTPO Patent Applications
No, your query does not take into account any triadic concept. The concept "where does innovation takes place" often uses the country where a priority (or first filing) was filed. Some researchers would use the country of the inventors to answer "where does innovation take place"...
- Tue Apr 09, 2024 3:27 pm
- Forum: PATSTAT Product Line
- Topic: Datatype change of tls212_citation.cited_npl_publn_id
- Replies: 2
- Views: 1280
Re: Datatype change of tls212_citation.cited_npl_publn_id
Hello, the change was not so unexpected :) It happened for the 2021 Spring release. The [cited_npl_publn_id] attribute should indeed be 32 characters long, NOT integer. The data catalog indicates this also in the Modification History for the [cited_npl_publn_id] but also in the "(7) History of ...
- Thu Apr 04, 2024 11:15 am
- Forum: PATSTAT Product Line
- Topic: URGENT Assistance Needed for Master's Thesis Data Retrieval
- Replies: 1
- Views: 512
Re: URGENT Assistance Needed for Master's Thesis Data Retrieval
You could use something like this: SELECT DISTINCT a.appln_filing_year, a.appln_id, a.appln_auth, a.appln_nr, a.appln_kind, a.appln_filing_date, STRING_AGG (CPC.cpc_class_symbol, '; ') CPC_GROUP FROM tls201_appln a JOIN tls225_docdb_fam_cpc CPC ON a.docdb_family_id = CPC.docdb_family_id WHERE left(c...
- Thu Apr 04, 2024 10:51 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT GLOBAL Frontfile vs Single edition
- Replies: 4
- Views: 832
Re: PATSTAT GLOBAL Frontfile vs Single edition
The service fee (150 euro) for PATSTAT Global (or any of the data sets on the download platform) is abolished for 2024 subscriptions. But you still need to register to get access to the platform. (user_id, password, etc...) PATSTAT is produced 2 times per year. We are currently working on the Spring...