Search found 440 matches
- Mon Oct 02, 2023 4:35 pm
- Forum: PATSTAT Product Line
- Topic: How to match Patstat data with WIPO IP Statistics
- Replies: 1
- Views: 3849
Re: How to match Patstat data with WIPO IP Statistics
Hello Jens, Your best source for information on how the WIPO statistics are created is WIPO. It's rather difficult to replicate or reverse engineer a statistical method without knowing exactly how and what. If we would be looking at the EPO filings: "Direct applications" would be applicati...
- Mon Sep 25, 2023 12:28 pm
- Forum: PATSTAT Product Line
- Topic: Delay registration PATSTAT Spring 2023
- Replies: 1
- Views: 3196
Re: Delay registration PATSTAT Spring 2023
Correct, it generally takes 18 months before filed applications are published. (Except for patents filed at the CN patent office.) Additionally, you selected granted patents; at the EPO it takes on average 3.5 years between the application and the grant; so that also gives a "drop" for the...
- Mon Sep 25, 2023 9:28 am
- Forum: PATSTAT Product Line
- Topic: Patent applications by country by year and/or quarter.
- Replies: 3
- Views: 4718
Re: Patent applications by country by year and/or quarter.
Pure SQL questions are a bit outside the scope of this forum, but here is one way to do it: SELECT concat (appln_filing_year, '-', DATEPART(QUARTER,[appln_filing_date])) as quarter, count(appln_id) FROM tls201_appln where appln_auth ='FI' and appln_filing_year between 2000 and 2010 group by concat (...
- Thu Sep 14, 2023 4:34 pm
- Forum: PATSTAT Product Line
- Topic: Patstat Automn 2023
- Replies: 1
- Views: 8633
Re: Patstat Automn 2023
Normally somewhere in November, but there is no date set yet.
This can vary depending on the outcome of the test procedures, which is quite a lengthy and elaborate process.
This can vary depending on the outcome of the test procedures, which is quite a lengthy and elaborate process.
- Wed Aug 23, 2023 9:22 am
- Forum: PATSTAT Product Line
- Topic: Can we get claims or abstract of multiple patents in single API request
- Replies: 2
- Views: 3272
Re: Can we get claims or abstract of multiple patents in single API request
PATSTAT can only provide you titles and abstracts. (no claims) There is no API service, but you can extract data (limited) via PATSTAT Online. Abstracts and titles will be in English, or in the original language when no English title is available. Here is an example query, but there are many differe...
- Tue Aug 22, 2023 3:52 pm
- Forum: PATSTAT Product Line
- Topic: How to get the annual citation data for docdb families
- Replies: 4
- Views: 9401
Re: How to get the annual citation data for docdb families
Hello Humpherry, the short answer is: yes, it is wrong (not the SQL syntax as such) but because your query will double count all the family members depending on the number of family members. Have a look at the results from below query, you can see that there are 5 family members, they all have the s...
- Thu Aug 10, 2023 9:02 am
- Forum: PATSTAT Product Line
- Topic: Replacement for appln_nr_epodoc
- Replies: 2
- Views: 3836
Replacement for appln_nr_epodoc
Hello Lionpat, Only using the application number will not work. The answer depends a bit on what you want to do and what you need it for. The appln_nr_epodoc attribute will be part of the data again in the next release. It might however still become obsolete in future releases. The obvious replaceme...
- Thu Jul 27, 2023 5:14 pm
- Forum: PATSTAT Product Line
- Topic: Rows to columns: Listing inventors and applicants in the same row
- Replies: 1
- Views: 3058
Re: Rows to columns: Listing inventors and applicants in the same row
Hello Paulo, I assume you are using PATSTAT Online, which does not allow to make functions, procedures or dynamic SQL. Basically, what you are doing is de-normalising the (relational) data. Have a look at the query below; you can expand it to cover as many applicants or inventors you need (currently...
- Wed Jun 14, 2023 9:31 am
- Forum: PATSTAT Product Line
- Topic: Count of European patent applications
- Replies: 1
- Views: 3410
Re: Count of European patent applications
Hello Alexis, it is in principle impossible to reproduce the filing figures published by the EPO, using PATSTAT. The data is based on applications (including applications that have been withdrawn - witdrawels before publication are NOT in PATSTAT, and nowhere else for that matter, except in EPO stat...
- Wed Jun 07, 2023 11:42 am
- Forum: PATSTAT Product Line
- Topic: generate list of EP applications having at least one X-citation
- Replies: 1
- Views: 1910
Re: generate list of EP applications having at least one X-citation
A bit reworked, have a look and check. The list does not include cited NPL ! select distinct t1.appln_id,t1.appln_auth+t1.appln_nr+t1.appln_kind application, t1.appln_filing_date filing_date, t5.publn_auth+t5.publn_nr+t5.publn_kind citing_publication, t5.publn_date citing_publication_date, t10.publn...