Search found 232 matches

by EPO / PATSTAT Support
Tue Feb 16, 2021 6:26 pm
Forum: PATSTAT Product Line
Topic: Duplicate Application ID
Replies: 2
Views: 55

Re: Duplicate Application ID

Hello Athimet, from a syntax point of view, your query is correct. From a logical & data aggregation point of view, there is room for improvement. There are duplicate records because of the combination of tables you have joined in the FROM clause in your query. You should in principle not join any t...
by EPO / PATSTAT Support
Fri Dec 18, 2020 1:12 pm
Forum: PATSTAT Product Line
Topic: IPC classification - How to get the number of patent applications in Biotechnology
Replies: 1
Views: 236

Re: IPC classification - How to get the number of patent applications in Biotechnology

Hello Khanhhienbi, The criteria of using one or the other IPC or CPC classification codes to define a certain technology sector or fields lies with the researcher. It is rather difficult to draw strict lines between the various fields simply based on the classification codes, and there are "grey" ar...
by EPO / PATSTAT Support
Mon Dec 14, 2020 3:05 pm
Forum: PATSTAT Product Line
Topic: Patent Fractional Count at NUTS-2 level
Replies: 2
Views: 208

Re: Patent Fractional Count at NUTS-2 level

Hello Simone, NUTS codes are constructed according to a hierarchical system based on the number of digits. For Italy you can retrieve all the NUTS codes via the query below: SELECT nuts ,[nuts_level] ,[nuts_label] FROM [patstat2020b].[dbo].[tls904_nuts] where nuts like 'IT%' order by nuts NUTS_Italy...
by EPO / PATSTAT Support
Mon Dec 14, 2020 11:21 am
Forum: PATSTAT Product Line
Topic: How to load/use PATSTAT data in R?
Replies: 1
Views: 153

Re: How to load/use PATSTAT data in R?

Hello MrQuicky,
I can not help you with R,
but at this link you will find sample scripts for loading PATSTAT on a MySQL platform.

patstat-2019b-mysql-upload-scripts-8627 ... 590#p24590
by EPO / PATSTAT Support
Wed Dec 02, 2020 8:46 am
Forum: PATSTAT Product Line
Topic: PATSTAT: Aren't all application in tls201 included in tls209?
Replies: 1
Views: 187

Re: PATSTAT: Aren't all application in tls201 included in tls209?

Hello, your queries are correct. I assume that the reason for missing IPC codes is that those patents simply have not been classified, so nothing wrong with the data as such. The WIPO guide gives some information on the IPC history and when it entered into force. wipo_guide_ipc_2020.pdf I don't know...
by EPO / PATSTAT Support
Tue Nov 10, 2020 9:52 am
Forum: PATSTAT Product Line
Topic: Help with SQL query - How to count the number of patent applications of a specific company
Replies: 1
Views: 269

Re: Help with SQL query - How to count the number of patent applications of a specific company

Hello khanhhienbi, first a couple of observations: Patents that have been filed between '2016-01-01' and '2020-01-01' will mostly not be granted yet. It easily takes 3 to 4 years for a patent to become granted. So I have widened the scope, but you can easily adapt it to your needs. If you want to "c...
by EPO / PATSTAT Support
Fri Nov 06, 2020 2:06 pm
Forum: PATSTAT Product Line
Topic: PATSTAT release Autumn 2020 is available for download
Replies: 0
Views: 400

PATSTAT release Autumn 2020 is available for download

PATSTAT 2020 Autumn edition Dear PATSTAT subscriber, The 2020 Autumn edition has been tested, found sound, and is now ready for download https://publication.epo.org/raw-data/authentication?action=2 . Do not hesitate to contact us in case you encounter any problems when uploading the new data files....
by EPO / PATSTAT Support
Wed Oct 28, 2020 11:41 am
Forum: PATSTAT Product Line
Topic: X-categorized citations
Replies: 2
Views: 276

Re: X-categorized citations

Hello Val, there is a small logical mistake in your query. The tls215_citn_categ should be joined via 2 attributes in order to link the correct citation category to the citations: t6.pat_publn_id = t12.pat_publn_id and t6.citn_id = t12.citn_id So observe that the join is NOT via t6.cited_pat_publn_i...
by EPO / PATSTAT Support
Tue Sep 29, 2020 4:58 pm
Forum: PATSTAT Product Line
Topic: IPC classification
Replies: 2
Views: 641

Re: IPC classification, F and L, Schmoch technology scheme

Dear Eduardo, That is a whole lot of questions in one go, so let me tackle them one by one. On question 1) In PATSTAT, we have pre-calculated the weighted technology shares for the each application based on the classification picture of each individual patent. Not on the position. This allows for mo...
by EPO / PATSTAT Support
Fri Sep 25, 2020 10:13 am
Forum: PATSTAT Product Line
Topic: PSN_ID changed?
Replies: 3
Views: 1090

Filing date on divisional applications & new person_id's

Hello Tim, I would say that your question touches on 2 different but related issues. a) how is it possible that patent applications having a filing year < 2010 were not in PATSTAT2015 b) and the person_id's from those applications do not appear neither in the PATSTAT2015-but suddenly appear in a lat...