Search found 155 matches

by EPO / PATSTAT Support
Tue Nov 12, 2019 5:06 pm
Forum: PATSTAT Product Line
Topic: Including variables without ID in the table
Replies: 2
Views: 481

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: 1511

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: 144

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: 2001

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: 1511

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: 500

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...
by EPO / PATSTAT Support
Thu Oct 17, 2019 1:28 pm
Forum: PATSTAT Product Line
Topic: Number of patents per Country, per IPC code, per Year
Replies: 4
Views: 200

Re: Number of patents per Country, per IPC code, per Year

Here is a sample query that gives you the number of applications filed in your specified list of countries for applicants that have "US" as country code. You can further extend it to your needs. SELECT psn_name, left(ipc_class_symbol,3) IPC, COUNT(distinct(case when year(appln_filing_date) = 2000 th...
by EPO / PATSTAT Support
Wed Oct 16, 2019 10:49 am
Forum: PATSTAT Product Line
Topic: Number of patents per Country, per IPC code, per Year
Replies: 4
Views: 200

Re: Number of patents per Country, per IPC code, per Year

Hello Micvollaro,
For question 1: how do you define "US patents"? Are you thinking about the geographical coverage reflected in the patent family, or the fact that "the applicant" is US based. (Or any other definition ?)
Similar to question 2: what is your definition of a domestic patent ?
by EPO / PATSTAT Support
Wed Oct 16, 2019 8:12 am
Forum: Linked open EP data/open EP bulk data
Topic: New version of “EP full-text data for text analytics” available
Replies: 0
Views: 2562

New version of “EP full-text data for text analytics” available

This product is a bulk data set consisting of XML-tagged titles, abstracts, descriptions, claims and search reports covering all EP publications, designed to facilitate natural language processing work and linkable to PATSTAT. A new version has been recently released, which contains all EP publicati...
by EPO / PATSTAT Support
Tue Oct 15, 2019 11:39 am
Forum: PATSTAT Product Line
Topic: Counting domestic patents applied internationally
Replies: 6
Views: 1511

Re: Counting domestic patents applied internationally

Hello Ucindami, your forum post touches upon a number of different issues. The attribute: "application authority" (appln_auth) defines the territorial area where the patent is applied for. If the the code is a real country code: DE, US, JP,.... then the patent is applied for in that country and nowh...