Search found 157 matches

by EPO / PATSTAT Support
Wed Jan 15, 2020 2:00 pm
Forum: PATSTAT Product Line
Topic: Missing data on inventor Origin
Replies: 2
Views: 179

Re: Missing data on inventor Origin

Hello Ucindami, indeed, replenishment via the priority filings or the family members is the best approach to add the missing country codes. The EPO will make available any country information it receives from the respective national patent offices. And we will not replenish any person country data o...
by EPO / PATSTAT Support
Tue Dec 10, 2019 9:27 am
Forum: PATSTAT Product Line
Topic: countrow for PATSTAT Global
Replies: 1
Views: 139

Re: countrow for PATSTAT Global

Hello Patty,
the easiest check is to do a record count on all of the tables.
In the attached file you will find the SQL query and the results is should show for PATSTAT Autumn 2019 - with the understanding that you loaded all tables and files.
TestScripts.zip
(1.29 KiB) Downloaded 8 times
by EPO / PATSTAT Support
Wed Dec 04, 2019 5:24 pm
Forum: PATSTAT Product Line
Topic: Mapping Inpadoc legal event data
Replies: 0
Views: 733

Mapping Inpadoc legal event data

The TLS231_INPADOC_LEGAL_EVENT table contains a whopping 280 million records covering legal status from 59 patent authorities using 3.712 different legal event codes. Researchers need to have a good understanding of the meaning of those codes before using them. But equally important is to understand...
by EPO / PATSTAT Support
Mon Nov 25, 2019 12:58 pm
Forum: PATSTAT Product Line
Topic: Including variables without ID in the table
Replies: 3
Views: 1009

Re: Including variables without ID in the table

Hello Richard, table TLS214_NPL_PUBLN can be linked to TLS212_CITATION via the attribute NPL_PUBLN_ID. Here is a query that extract all citation information (exept the citation categories) from a single patent applications. SELECT citing.appln_id, citing.publn_auth, citing.publn_nr, citing.publn_kin...
by EPO / PATSTAT Support
Tue Nov 12, 2019 5:06 pm
Forum: PATSTAT Product Line
Topic: Including variables without ID in the table
Replies: 3
Views: 1009

Re: Including variables without ID in the table

Hello Richard, "Connecting" or "linking" tables in PATSTAT is done via the different kinds of SQL "JOIN" s. A JOIN clause is used to combine rows from two or more tables, based on (a) related column(s) between them. This "related column" is very often the primary key or a combination of "foreign key...
by EPO / PATSTAT Support
Mon Nov 04, 2019 3:05 pm
Forum: PATSTAT Product Line
Topic: Counting domestic patents applied internationally
Replies: 6
Views: 3419

Re: Counting domestic patents applied internationally

1980 was the first year EP patents were granted. select year(publn_date) grant_date , count(appln_id) #_applications from tls211_pat_publn where publn_kind = 'B1' and publn_auth = 'EP' group by year(publn_date) order by year(publn_date) So it makes sense that no renewal fees records are available fr...
by EPO / PATSTAT Support
Mon Nov 04, 2019 2:06 pm
Forum: PATSTAT Product Line
Topic: PCT route, international patents and the EP application authority
Replies: 1
Views: 1019

Re: PCT route, international patents and the EP application authority

Hello Ucindami, your questions are rather related to the patent application & granting procedure. A good introduction to the general rules for EP and PCT (international) applications are the "Guide for applicants", which you can find at this link: http://documents.epo.org/projects/babylon/eponet.nsf...
by EPO / PATSTAT Support
Fri Oct 25, 2019 10:52 am
Forum: PATSTAT Product Line
Topic: triadic patents -query help
Replies: 5
Views: 2748

Re: triadic patents -query help

Hello Thomas, the concept of OECD triadic families is not based on EPO (DocDB % INPADOC) patent families. For more information on the OECD approach, kindly have a look at the attached documents: OECD Triadic patent families methodology.pdf OECD Triadic Patent Families - Sept 2017.pdf Replicating the...
by EPO / PATSTAT Support
Tue Oct 22, 2019 5:20 pm
Forum: PATSTAT Product Line
Topic: Counting domestic patents applied internationally
Replies: 6
Views: 3419

Re: Counting domestic patents applied internationally

"My intention is to capture the level of innovation at the country level." Many researchers are using the first priority filing to measure innovative capacity. But it does not work for EP and WO applications (or other regional offices) where no priority was filed. ... In which case they mostly use t...
by EPO / PATSTAT Support
Fri Oct 18, 2019 1:25 pm
Forum: PATSTAT Product Line
Topic: PATSTAT user day presentations & training material
Replies: 0
Views: 1415

PATSTAT user day presentations & training material

Here are the files of the presentations and the training material from the PATSTAT user day which took place on 25/09/2019 User Day Martin_Kracker_PATSTAT2019_StatusReport.pdf Linda_Andersson_Combining_full_text_search_and_Statistics.pdf Gianluca_Tarasconi_Patent_applicant_time_series.pdf Geert_Boed...