Search found 216 matches

by EPO / PATSTAT Support
Fri Jun 19, 2020 10:23 am
Forum: PATSTAT Product Line
Topic: Patents not found at Patstat
Replies: 1
Views: 296

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

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...
by EPO / PATSTAT Support
Fri Jun 12, 2020 9:25 pm
Forum: PATSTAT Product Line
Topic: Combining CPC-classes & keywords
Replies: 1
Views: 372

Re: Combining CPC-classes & keywords

Hello Lennart, there were a couple of brackets missing in your WHERE clause. SELECT DISTINCT tls201_appln.docdb_family_id, earliest_filing_year, tls206_person.person_ctry_code, CPC.CPCgrouped FROM tls201_appln JOIN TLS203_APPLN_ABSTR ON tls201_appln.appln_id = TLS203_APPLN_ABSTR.appln_id JOIN tls207...
by EPO / PATSTAT Support
Wed Jun 10, 2020 4:10 pm
Forum: PATSTAT Product Line
Topic: Problem: CPC-classes, applicants & DOCDB families
Replies: 9
Views: 599

Re: Problem: CPC-classes, applicants & DOCDB families

Hello Lennart, your analysis is correct; family members can have different spellings in the applicant name, the number of applicants can be different (that is why we took MAX); it could in principle even be different companies, and also the presence of a country code will lead to "different persons"...
by EPO / PATSTAT Support
Wed Jun 03, 2020 10:00 pm
Forum: PATSTAT Product Line
Topic: Problem: CPC-classes, applicants & DOCDB families
Replies: 9
Views: 599

Re: Problem: CPC-classes, applicants & DOCDB families

1) If you remove the "and (invt_seq_nr = 0)", you will get all the applicants back. It basically excludes many of the "natural persons" from the applicant list, namely the ones that are applicants. 2) CPC codes can be assigned by multiple offices and that can create duplicates. De-duplicating is ver...
by EPO / PATSTAT Support
Wed Jun 03, 2020 6:53 pm
Forum: PATSTAT Product Line
Topic: Problem: CPC-classes, applicants & DOCDB families
Replies: 9
Views: 599

Re: Problem: CPC-classes, applicants & DOCDB families

I adapted the query; PATSTAT Online is a bit particular about using renaming columns in tables.
by EPO / PATSTAT Support
Wed Jun 03, 2020 3:22 pm
Forum: PATSTAT Product Line
Topic: Problem: CPC-classes, applicants & DOCDB families
Replies: 9
Views: 599

Re: Problem: CPC-classes, applicants & DOCDB families

Hello Lennart, I took the freedom to correct the cpc codes in your query, the blanks should be added like this 'Y04S 30/14' and not 'Y04S30 /14' Ideally you would have access to a full PATSTAT data base instead of PATSTAT Online. That would allow you to create intermediate tables that contain data a...
by EPO / PATSTAT Support
Wed Jun 03, 2020 12:09 pm
Forum: PATSTAT Product Line
Topic: Forward citations and coverage
Replies: 2
Views: 427

Re: Forward citations and coverage

Hello Alexis, On 1) your query looks fine. When I do such counts, I would take just the first 2 applications, and manually check if the forward citations are effectively counted as you want them. On 2) coverage of the citation information is documented in the REFI publication which you can find at t...
by EPO / PATSTAT Support
Tue Jun 02, 2020 12:28 pm
Forum: PATSTAT Product Line
Topic: Problem: CPC-classes, applicants & DOCDB families
Replies: 9
Views: 599

Re: Problem: CPC-classes, applicants & DOCDB families

Hello Lennart, there is a small typo in your query; CPC codes need to have 8 characters before the / . This means that one has to add "spaces" to make it 8 characters. See query below, I also used the STRING_AGG function and a GROUP BY to reduce the number of rows, and de_duplicate the CPC codes. Bu...
by EPO / PATSTAT Support
Mon May 25, 2020 9:12 am
Forum: PATSTAT Product Line
Topic: the first application of each DOCDB_FAMILY_ID
Replies: 1
Views: 404

Re: the first application of each DOCDB_FAMILY_ID

Hello Darwin, For the majority of the DocDB families, the "earliest_appln_id" will refer to one and the same application for all family members. In the complete PATSTAT database (2020a) there are 185.919 out of 76.458.745 (0.2%) DocDB families that have more then 1 "earliest_appln_id" in the family....