Search found 96 matches

by mkracker
Thu Jun 08, 2017 6:54 am
Forum: PATSTAT Product Line
Topic: Searching for help concerning PATSTAT query
Replies: 7
Views: 2743

Re: Searching for help concerning PATSTAT query

Hi Constance,

Just add "and granted = 1" to the WHERE clause of your query.
Look up attribute GRANTED in the Data Catalog for more details.

Best regards,
Martin / EPO
by mkracker
Wed May 24, 2017 2:32 pm
Forum: PATSTAT Product Line
Topic: NPL references cited in patent literature
Replies: 4
Views: 1298

Re: NPL references cited in patent literature

Dear Joachim, Thanks for the specific example, which was publication US 7067501 B2. In short: PATSTAT gets its data more or less indirectly from the US office. I have no reason to believe that information gets lost on the way because the 6 NPLs listed by the applicant in the US form "Information Dis...
by mkracker
Tue May 23, 2017 2:05 pm
Forum: PATSTAT Product Line
Topic: NPL references cited in patent literature
Replies: 4
Views: 1298

Re: NPL references cited in patent literature

Dear Joachim, Actually, your assumption is not correct. NPLs can be cited in any phase of the patent procedure. Just check attribute CITN_ORIGIN in table TLS212_CITATION. select citn_origin, count(*) as freq from tls212_citation where cited_npl_publn_id > 0 group by citn_origin order by freq desc Th...
by mkracker
Tue May 23, 2017 9:49 am
Forum: PATSTAT Product Line
Topic: Querying utility models in France
Replies: 2
Views: 830

Re: Querying utility models in France

Dear Carmen, Your approach comes close. Unfortunately it does not work for France, because for FR there is no distinction in the type of application APPLN_KIND between patents and utility models. However, utility models can be identified by the kind of publications that are published. In the “Kind c...
by mkracker
Fri Jan 13, 2017 8:43 am
Forum: PATSTAT Product Line
Topic: Help with SQL query_caunt applications per Country
Replies: 3
Views: 2175

Re: Help with SQL query_caunt applications per Country

I think there are two major issues in what you do: Firstly, your queries do not return applications , but records as defined in your query. In your queries you join the application table with TLS207, which has a record for every person (applicant or inventor) of an application. Consequently, if an a...
by mkracker
Thu Jan 12, 2017 9:18 am
Forum: PATSTAT Product Line
Topic: MS SQL Server - Loading script
Replies: 1
Views: 1083

Re: MS SQL Server - Loading script

I just want to point out that in the PATSTAT documentation there is a document (also attached here: HintsForDataLoading_v1.3.pdf which contains several links to forum entries or other websites where PATSTAT users kindly made their loading scripts for MySQL, Oracle or PostgreSQL available. Not all mi...
by mkracker
Tue Jan 10, 2017 8:51 am
Forum: PATSTAT Product Line
Topic: representative document of patent family
Replies: 1
Views: 834

Re: representative document of patent family

Hi Björn, No, there is no definition of a "representative publication" in PATSTAT. But you can define your own representative, using your own rules. These rules may be similar to the ones in Espacenet or totally different, whatever best suits your needs. I would do it like this: Add 2 columns to the...
by mkracker
Wed Dec 21, 2016 11:33 am
Forum: PATSTAT Product Line
Topic: SPCs classified as patents
Replies: 1
Views: 642

Re: SPCs classified as patents

The EPO does not receive many SPC publications from other offices, consequently you will find publications in PATSTAT only for some countries. Much more complete SPC data can be found in PATSTAT Legal Status (table TLS221_INPADOC_PRS), so I encourage you to have a look there. As an outlook to the 20...
by mkracker
Tue Dec 13, 2016 8:37 am
Forum: PATSTAT Product Line
Topic: PATSTAT 2016 Autumn - TLS215_CITN_CATEG corrupt data?
Replies: 3
Views: 900

Re: PATSTAT 2016 Autumn - TLS215_CITN_CATEG corrupt data?

Hi, Thank you for reporting these data errors. Your observation confirms the rule that no database is completely correct, not even PATSTAT ;) . In fact, the citations are taken from EPOs REFI and DOCDB databases, which contains data collected from more than 80 patent offices around the world in a va...
by mkracker
Wed Nov 30, 2016 4:57 pm
Forum: PATSTAT Product Line
Topic: PATSTAT autumn 2016 checksums
Replies: 1
Views: 680

Re: PATSTAT autumn 2016 checksums

Dear Rachie, The problems with the files delivered on USB memory sticks which affected some users were due to the file system used (NTFS). Consequently we will change the file system to FAT32 for future deliveries. For the download from our Raw Data Platform we already provide a checksum. And as you...