Search found 227 matches

by EPO / PATSTAT Support
Mon Jul 13, 2020 3:21 pm
Forum: PATSTAT Product Line
Topic: Time window to control forward-citations
Replies: 4
Views: 934

Re: Time window to control forward-citations

Hello Eduardo, the methodology in "An introduction to the Patstat database with example queries - Query8" introduction_to_PATSTAT_database_with_example_queries_en.pdf is based on calculating the difference between the earliest publication of an application and the earliest publication date of its fo...
by EPO / PATSTAT Support
Wed Jul 01, 2020 2:44 pm
Forum: PATSTAT Product Line
Topic: Firm/Nr of Patents/ Forward Citations
Replies: 1
Views: 736

Re: Firm/Nr of Patents/ Forward Citations

Hello Anuisa, Firm numbers are not available in PATSTAT. On the topic of "forward citations", there are plenty of forum posts with example queries that cover that topic. I also would recommend you to have a look at self learning material on the PATSTAT webpages: https://www.epo.org/searching-for-pat...
by EPO / PATSTAT Support
Wed Jul 01, 2020 8:48 am
Forum: PATSTAT Product Line
Topic: Search Database with ISIN code
Replies: 1
Views: 709

Re: Search Database with ISIN code

Hello Anisa, PATSTAT does not contain ISIN or any other means of formal identification through codes for the patent applicants. That kind of information is not collected by the EPO. One has to keep in mind that even "natural persons" who do not have a VAT or company registration number can apply for...
by EPO / PATSTAT Support
Fri Jun 26, 2020 2:46 pm
Forum: PATSTAT Product Line
Topic: Patent fractional count and forward citations
Replies: 2
Views: 605

Re: Patent fractional count and forward citations

Dear Simone, If you can live with the "family based" forward citations, then simply take the nb_citing_docdb_fam attribute. "Application based" data would involve using the tls211 and tls212 tables and then "grouping" the data at application level. This is quasi impossible to do via PATSTAT Online a...
by EPO / PATSTAT Support
Mon Jun 22, 2020 12:53 pm
Forum: PATSTAT Product Line
Topic: Definition of inventor
Replies: 1
Views: 2120

Re: Definition of inventor

Dear John123, Distinguishing in PATSTAT between applicant and inventor is fairly easy by means of the tls207 (for applications) or tls227 (for publications) in combination with the tls206_person table. PATSTAT users have the full freedom to direct their search to only consider applicants, inventors ...
by EPO / PATSTAT Support
Mon Jun 22, 2020 10:12 am
Forum: PATSTAT Product Line
Topic: NUTS 2 based data - example using Germany
Replies: 0
Views: 778

NUTS 2 based data - example using Germany

Many users are asking how to create NUTS 2 based tables -similar to what Eurostat used to do-. NUTS based data at the lower levels (2-3) can only be created for persons (applicants and inventors) where there is good address data available. In the person table you will find the most granular NUTS cod...
by EPO / PATSTAT Support
Fri Jun 19, 2020 1:02 pm
Forum: PATSTAT Product Line
Topic: Search codes for transnational cooperation patents
Replies: 5
Views: 1538

Re: Search codes for transnational cooperation patents

Hello Faery, I assume you mean something like this (to be adapted by you): select tls206_person.person_ctry_code Applt_CTRY, count(distinct(case when per.person_ctry_code = 'CN' and tls206_person.person_ctry_code <> 'CN' then tls201_appln.appln_id end)) as 'CN', count(distinct(case when per.person_c...
by EPO / PATSTAT Support
Fri Jun 19, 2020 11:41 am
Forum: PATSTAT Product Line
Topic: Technological weight for CPC (CPC/IPC concordance)
Replies: 1
Views: 465

Re: Technological weight for CPC (CPC/IPC concordance)

Dear Vanessa, CPC classifications are assigned at family level and you will not find duplicates. (CPC is also not -yet-published on the published patent document.) IPC is a bit different, they are published and can change between the publication instances. We group them and de-duplicate them at appl...
by EPO / PATSTAT Support
Fri Jun 19, 2020 10:23 am
Forum: PATSTAT Product Line
Topic: Patents not found at Patstat
Replies: 1
Views: 674

Re: Patents not found at Patstat

Hello, Generally spoken: PATSTAT is produced 2 times per year, in Spring and Autumn. Those releases are based on data extractions carried out in January and July (mostly). So any publication or data being added to our databases between January 2020 and now will not be available in the current PATSTA...
by EPO / PATSTAT Support
Fri Jun 19, 2020 10:07 am
Forum: PATSTAT Product Line
Topic: US Patents per company and year - SQL issue
Replies: 1
Views: 901

Re: US Patents per company and year - SQL issue

Dear Katharina, your query is fine, and it is indeed good practice to question results when they do not seem to fit the expected pattern. In this case, the applicant "Microsoft Corp" is being phased out - and replaced by "MICROSOFT TECHNOLOGY LICENSING" as the main applicant name used by Microsoft t...