Dear all,
As promised during the Patstat user meeting at the OECD in Paris, I am happy to share the MySQL code used in "The worldwide count of priority patents: A new indicator of inventive activity" forthcoming in Research Policy.
In short, the script selects priority patent applications filed worldwide and allocate them according to the inventor (or applicant) country of residence. The script also contains a routine to replenish missing country information for inventors (or applicants).
Both the paper and the MySQL source code are available at the following URL: URL-link
Hope it helps. I am happy to answer any questions you may have.
Gaétan de Rassenfosse
Worldwide count of priority filings
-
- Posts: 2
- Joined: Wed Mar 06, 2013 8:01 pm
Re: Worldwide count of priority filings
I NEED A PATENT STATISTIC IN SQL : IF A PATENT WAS APPLIED FOR IN ANOTHER COUNTRY AND 11 OR 12 MONTHS AFTER THE PRIORITY DATE THE PATENT WAS FILED WITH THE EPO, HOW LONG ON THE AVERAGE DOES IT TAKE TO RECEIVE A SEARCH REPORT (A1 AND/OR A3)? I WOULD LIKE TO HAVE THE SHORTEST TIME, LONGEST TIME, AND AVERAGE TIME FOR SAMPLE OF ABOUT 1000 RECENT PATENT APPLICATIONS. (ITS SUPPOSE TO TAKE 6 MONTHS BUT I IMAGINE IF YOU FILE SO LATE IN THE 12 MONTHS YOUR ALLOWED, IT WILLTAKE MUCH LONGER)CAN YOU HELP? JOHN
-
- Posts: 140
- Joined: Wed Jul 08, 2009 5:51 pm
- Contact:
Re: Worldwide count of priority filings
Thank you very much for making this practical example available to the community.
Using priority counts has always been my preferred method to count patents, but as the OECD Patent Statistics Manual focuses on using PCT counts or families I was never sure whether it was an acceptable solution. So I'm happy to see other people use it as well.
Btw, I also have come up with an algorithm to replenish missing data. I'll compare it with yours and post my findings here.
Using priority counts has always been my preferred method to count patents, but as the OECD Patent Statistics Manual focuses on using PCT counts or families I was never sure whether it was an acceptable solution. So I'm happy to see other people use it as well.
Btw, I also have come up with an algorithm to replenish missing data. I'll compare it with yours and post my findings here.
________________________________________
Nico Doranov
Data Manager
Daigu Academic Services & Data Stewardship
http://www.daigu.nl/
Nico Doranov
Data Manager
Daigu Academic Services & Data Stewardship
http://www.daigu.nl/