Search found 124 matches

by EPO / PATSTAT Support
Mon Feb 04, 2019 6:31 pm
Forum: PATSTAT Product Line
Topic: missing prior_appln_id
Replies: 5
Views: 798

Re: missing prior_appln_id

Hello Clem, your observation is correct in as such that a lot of applications are removed when you furhter join your initial query with the tls204_appln_prior table. This means that all applications that do not have a priority will be removed from your result list. In fact, your final result of "DIS...
by EPO / PATSTAT Support
Mon Feb 04, 2019 5:09 pm
Forum: PATSTAT Product Line
Topic: What does it mean when DOCDB is 0 (zero)?
Replies: 3
Views: 295

Re: What does it mean when DOCDB is 0 (zero)?

Hello Brian, Up to the 2016 Spring "vintage", we did not assign family identifications to replenished applications. They all had the default value 0 and you can also observe that they all have an appln_id > 900000000 (+ 0) . The result was that this created a very big family which always ended up on...
by EPO / PATSTAT Support
Mon Feb 04, 2019 5:01 pm
Forum: PATSTAT Product Line
Topic: What does it mean when DOCDB is 0 (zero)?
Replies: 3
Views: 295

Re: What does it mean when DOCDB is 0 (zero)?

Hi Brian, For the vintage :-) 2016 Spring Edition the Data Catalog explains the attribute DOCDB_FAMILY_ID like this: Domain: Number 0 … 999 999 999; A value 0 indicates that the application does not belong to any DOCDB family. This is only the case for the dummy application (APPLN_ID = 0) and for ar...
by EPO / PATSTAT Support
Mon Feb 04, 2019 4:50 pm
Forum: PATSTAT Product Line
Topic: International application ID as link to earlier PCT filing
Replies: 0
Views: 233

International application ID as link to earlier PCT filing

Users have to be careful when using the internat_appln_id attribute as sole indicator for an earlier PCT application. For most patent authorities this works fine but for some countries the internat_appln_id is not available or data is incomplete. An example is Columbia, PATSTAT (2018b) contains 12.6...
by EPO / PATSTAT Support
Thu Jan 31, 2019 9:41 am
Forum: PATSTAT Product Line
Topic: R script for loading PATSTAT global (Autumn Edition 2018) into PostgreSQL
Replies: 1
Views: 355

Re: R script for loading PATSTAT global (Autumn Edition 2018) into PostgreSQL

Hello Daniel,
many thanks for sharing your work with the community.
Geert BOEDT
by EPO / PATSTAT Support
Tue Jan 29, 2019 5:18 pm
Forum: PATSTAT Product Line
Topic: missing prior_appln_id
Replies: 5
Views: 798

Re: missing prior_appln_id

Hi,
Can you please provide some specific examples, so I can have a look?
And with which version of PATSTAT are you working?

Best regards,
Martin / EPO PATSTAT
by EPO / PATSTAT Support
Mon Jan 28, 2019 10:55 am
Forum: PATSTAT Product Line
Topic: EPO patents - information on securities agreements
Replies: 1
Views: 249

Re: EPO patents - information on securities agreements

Hello Dahe, no such indicators are available for European patents and I am not aware about any proxies that could be used to identify such patents. As far as I know, only the US patent office provides register information on cases where IP is used as security. The GB office has some information in t...
by EPO / PATSTAT Support
Thu Jan 24, 2019 5:58 pm
Forum: PATSTAT Product Line
Topic: Issue with Collecting Patent Data
Replies: 12
Views: 1000

Re: Issue with Collecting Patent Data

Hello Wei, these are NOT dummy publications or applications. Artificial applications or publications will have an appln_id or publn_id > 900000000. The EPO has to adapt the number formats so that they become distinct and unique in order to keep the data base coherent. These adapted numbers are appln...
by EPO / PATSTAT Support
Thu Jan 24, 2019 2:59 pm
Forum: PATSTAT Product Line
Topic: Identifying patents based on citation from different technological fields
Replies: 1
Views: 270

Re: Identifying patents based on citation from different technological fields

Hello Torben,
your attached pictures suggest that you are looking for 3 groups of cited documents that have no common technological field. Correct ?
Do you have access to PATSTAT Global on a local server ?
Geert BOEDT
by EPO / PATSTAT Support
Thu Jan 17, 2019 5:58 pm
Forum: PATSTAT Product Line
Topic: Issue with Collecting Patent Data
Replies: 12
Views: 1000

Re: Issue with Collecting Patent Data

Hello Wei, the fact that you JOIN your data with the tls212_citation table implies that only cited publications ar retained. Many of them have not been cited, so they will not be included in your data sample. This is the nature of relational data bases. You can avoid this by using a LEFT JOIN, which...