Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
-
ap506
- Posts: 2
- Joined: Tue Aug 05, 2014 3:25 pm
Post
by ap506 » Tue Aug 05, 2014 3:31 pm
Hello to all and my apologies if this has been asked/answered before.
I am doing my master's thesis and I am looking to extract triadic patent data regarding renewable energy technologies for the UK for the last 30 years. I have found the IPCs from previously published papers but I am unable to find the correct command from the User's Manual in order to extract the data from PATSTAT.
Could someone please help me towards this. I would really really appreciate it.
Thank you
-
nico.rasters
- Posts: 140
- Joined: Wed Jul 08, 2009 5:51 pm
-
Contact:
Post
by nico.rasters » Fri Aug 08, 2014 3:34 pm
An example:
SELECT `tls201_appln`.`appln_id`
, YEAR(`tls201_appln`.`appln_filing_date`) AS appln_filing_year
, `tls201_appln`.`appln_auth`
, `tls209_appln_ipc`.`ipc_class_symbol`
, `tls206_person`.*
, `tls207_pers_appln`.*
FROM `tls201_appln`
INNER JOIN `tls209_appln_ipc` ON `tls201_appln`.`appln_id` = `tls209_appln_ipc`.`appln_id`
INNER JOIN `tls207_pers_appln` ON `tls201_appln`.`appln_id` = `tls207_pers_appln`.`appln_id`
INNER JOIN `tls206_person` ON `tls207_pers_appln`.`person_id` = `tls206_person`.`person_id`
WHERE `tls201_appln`.`appln_auth`="GB"
AND YEAR(`tls201_appln`.`appln_filing_date`) BETWEEN 1985 AND 2014
AND `tls209_appln_ipc`.`ipc_class_symbol` = "F02B 43/08";
________________________________________
Nico Doranov
Data Manager
Daigu Academic Services & Data Stewardship
http://www.daigu.nl/
-
ap506
- Posts: 2
- Joined: Tue Aug 05, 2014 3:25 pm
Post
by ap506 » Mon Aug 11, 2014 12:07 pm
The issue is now resolved thanx to the much appreciated and indeed valuable help of Mr. Rasters. This guy is amazing! Thank you very very much.
