Search found 440 matches
- Tue Dec 07, 2021 4:38 pm
- Forum: PATSTAT Product Line
- Topic: Counting domestic patents applied internationally
- Replies: 12
- Views: 19297
Re: Counting domestic patents applied internationally
The PGFP codes are the easiest proxy to identify whether or not a granted European Patent entered the national phase. (Legally it is a bit more complicated, but PGFP does the job for nearly all different cases.)
- Tue Dec 07, 2021 4:22 pm
- Forum: PATSTAT Product Line
- Topic: Family issue
- Replies: 1
- Views: 6292
Re: Family issue
Hello Eduardo, The DOCDB patent family concept is based on a couple of rules from which the main one says: patents having the same priorities belong to the same family. But the fact is that, it happens that the priority information is not correct. This is sometimes reflected by looking at the pdf (p...
- Tue Dec 07, 2021 12:40 am
- Forum: PATSTAT Product Line
- Topic: Searching with climate-friendly Y02 classification
- Replies: 1
- Views: 1930
Re: Searching with climate-friendly Y02 classification
See this post: https://forums.epo.org/sql-queries-to-create-simple-applicant-year-based-table-10588 , and adapt the classifications codes to what you need. Be careful with spaces and characters when you write the CPC codes; there should allways be 8 digits before the "/" symbol. In most ca...
- Tue Nov 30, 2021 8:27 pm
- Forum: PATSTAT Product Line
- Topic: Help with SQL query - How to merge patent's applicants table with number of patent applications table
- Replies: 2
- Views: 1998
Re: Help with SQL query - How to merge patent's applicants table with number of patent applications table
Hello khanhhienbi, the two tables are very different, and it is not clear how you would want them "combined". The first one is a list of patents, the second one an aggregated table on total number of filings per year. How would a combined table look like ? About the queries, not sure why y...
- Wed Nov 24, 2021 12:27 pm
- Forum: PATSTAT Product Line
- Topic: Please help a student to make a query : D
- Replies: 1
- Views: 1209
Re: Please help a student to make a query : D
Such query would generate more then 2 million records, even when only taking the "first applicant" in account for those applications where there are multiple applicants. Here is a query that gives you the results for application filed in 2015. The free trial lets you only download 10.000 r...
- Mon Nov 15, 2021 4:22 pm
- Forum: PATSTAT Product Line
- Topic: count forward citations
- Replies: 6
- Views: 3305
Re: count forward citations
Family-family citations count is a pre-aggregated value in the tls201_appn table with the name: nb_citing_docdb_fam . So you don't need to do any calculations. This is the query that shows you the number for the same application as above. SELECT app.appln_auth, app.appln_nr ,app.appln_kind, app.appl...
- Fri Nov 12, 2021 4:05 pm
- Forum: PATSTAT Product Line
- Topic: count forward citations
- Replies: 6
- Views: 3305
Re: count forward citations
Keep in mind that your query ONLY looks at forward citations linked to the publication of the grant - the so called B document-. Examiner praxis is to rather cite the earliest publication, which is the A document (or even a priority filing). Researchers who use citations to measure for example techn...
- Thu Nov 11, 2021 12:16 pm
- Forum: PATSTAT Product Line
- Topic: count forward citations
- Replies: 6
- Views: 3305
Re: count forward citations
Hello Muyang, as far as I can see, your query is correct, apart from a mistake in one of the ipc_class_symbol and a bracket that is not needed. Observe that I removed the embedded wild card in the classification codes;it can lead to errors because of the way the IPC classification hierarchy is forme...
- Thu Nov 04, 2021 6:37 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT 2023 Autumn release edition ready for download
- Replies: 0
- Views: 11659
PATSTAT 2023 Autumn release edition ready for download
Dear PATSTAT subscriber, The 2023 Autumn edition has been tested, found sound, and is now ready for download. The bulk data extraction was done end of July 2023, so for the major patent authorities, patents published until the end of 2022 should be complete. PATSTAT Online databases have not yet bee...
- Tue Nov 02, 2021 3:39 pm
- Forum: PATSTAT Product Line
- Topic: Missing person information in [dbo].[tls206_person]?
- Replies: 3
- Views: 3429
Re: Missing person information in [dbo].[tls206_person]?
I assume you are using a corrupt data set, or maybe a PATSTAT extraction where that data was not included due to the download criteria.