Search found 232 matches

by EPO / PATSTAT Support
Tue May 12, 2020 9:07 am
Forum: PATSTAT Product Line
Topic: Search codes for transnational cooperation patents
Replies: 5
Views: 1713

Re: Search codes for transnational cooperation patents

Hello Faery, is your network applicant or inventor based (or both) ? Your query looks for Chinese inventors (or inventors/applicants) co-filing with non-Chinese applicants . I assume you want to build some kind of matrix, what is in the columns, rows and the intersections ? You also did not limit yo...
by EPO / PATSTAT Support
Thu May 07, 2020 4:28 pm
Forum: PATSTAT Product Line
Topic: appln_filing_date or earlist_appln_date
Replies: 3
Views: 721

Re: appln_filing_date or earlist_appln_date

Hello Darwin, I meant, you can use the fact that 1 application belonging to a family has been granted as a proxy for "success of the family". There is no such pre-aggregated attribute ready made in PATSTAT; this is something users can do themselves. Here is a short query that gives for a set of fami...
by EPO / PATSTAT Support
Thu May 07, 2020 12:39 pm
Forum: PATSTAT Product Line
Topic: appln_filing_date or earlist_appln_date
Replies: 3
Views: 721

Re: appln_filing_date or earlist_appln_date

Hello Darwin, most researchers will use the erliest priority date of a family as the "closest to when the invention happened". In PATSTAT we have the attribute "earliest_filing_date" (used in tandem with the earliest_filing_id) , which is however application and not family based. In principle, one c...
by EPO / PATSTAT Support
Wed May 06, 2020 3:25 pm
Forum: PATSTAT Product Line
Topic: PATSTAT 2020a Spring edition ready for download.
Replies: 0
Views: 875

PATSTAT 2020a Spring edition ready for download.

Dear PATSTAT subscriber, The 2020 Spring edition has been tested, found sound, and is now ready for download. Do not hesitate to contact us via patstat @ epo.org in case you encounter any problems when uploading the new data files. Questions regarding shipping, subscription, pricing or invoicing can...
by EPO / PATSTAT Support
Mon May 04, 2020 10:58 am
Forum: PATSTAT Product Line
Topic: Non-patent-literature, encoding error?
Replies: 2
Views: 615

Re: Non-patent-literature, encoding error?

Hello Elisa, the data is correct; that NPL document has been cited in the Chinese search report, and no translation is currently available. (In fact, there are 2 CN NPLs cited.) With the query below you retrieve from PATSTAT all the citations from the CN application that cites that NPL. There are 3 ...
by EPO / PATSTAT Support
Wed Apr 29, 2020 11:56 am
Forum: PATSTAT Product Line
Topic: Patent count yearly per company
Replies: 3
Views: 682

Re: Patent count yearly per company

Here is a sample query that calculates a citation ratio. The ratio makes use of the pre-aggregated attribute "tls201_appln.nb_citing_docdb_fam". This attribute takes into account all citations to ALL family members of the EP applications. (See data catalog: DataCatalog_Global_v5.14.pdf Researchers w...
by EPO / PATSTAT Support
Tue Apr 28, 2020 9:29 am
Forum: PATSTAT Product Line
Topic: Multiple companies
Replies: 3
Views: 926

Re: Multiple companies

Hello Rutger, doing an analysis on a user-defined list of 3000 companies is not possible in PATSTAT Online because users can not upload their own list to our hosted data base. Options are: you purchase PATSTAT and install it on a local server. Or you find a "best common denominator in the patent dat...
by EPO / PATSTAT Support
Tue Apr 28, 2020 8:59 am
Forum: PATSTAT Product Line
Topic: Patent count yearly per company
Replies: 3
Views: 682

Re: Patent count yearly per company

Hello Rutger, how would you calculate that indicator. For each application year ? Forward citations are available as a pre-aggregated attribute; one could make the sum and then normalise it over the number of applications - arriving at some kind of index that shows a "citation ratio". Or do you have...
by EPO / PATSTAT Support
Tue Apr 07, 2020 10:25 am
Forum: PATSTAT Product Line
Topic: PATSTAT GLOBAL - REGISTER difference
Replies: 3
Views: 1629

Re: PATSTAT GLOBAL - REGISTER difference

Hello Mark, PATSTAT Global and PATSTAT Register do not contain the same data - but there is an overlap-. To have a good overview on the differences, I would recommend you to have a closer look at the data base model in the PATSTAT Global and PATSTAT Register data catalogs. You find them in the docum...
by EPO / PATSTAT Support
Mon Apr 06, 2020 7:28 pm
Forum: PATSTAT Product Line
Topic: Query Help for UK Patent Data
Replies: 4
Views: 4357

Re: Query Help for UK Patent Data

Hello Luca, kindly keep in mind that we do not have the resources to support individual researchers with drafting SQL queries for their research project. Many of your questions have been dealt with in previous forum posts, or are rather "SQL" syntax related. I took the freedom to answer a couple of ...