Hello Gauthier, this is not really a PATSTAT issue so you will not find anything on the use of apostrophes in the PATSTAT data catalog. Your issue is about how SQL (and the database setup) deal with quotes and apostrophes. When the text itself contains an apostrophe, then it conflicts with the apost...

Hello Elisa, if you want to have "extra rows" indicating the respective weights assigned to the nace code 21, then you simply add it in the the SELECT clause and also in the GROUP BY clause. SELECT list.nace2_code, list.nace2_descr, n.weight, COUNT(distinct(case when a.earliest_filing_year...

Hello Jan, In a concept of a relational database, joining extra table will normally always lead to an increased number of result rows when the joined tables contains matching records from the "original query". An example: if patent A cites B (one time) and A has 2 IPC codes and B has 3 IPC...

Hello Elisa, your worries are 100% justified. You will indeed count all patents for each single family member. With the assumption that those family members will have the same NACE classification codes; but that is to be expected for family members. To avoid this you have the count unique docdb_fami...

Hello Jan, kindly find hereby a couple of observations and comments: a) your query specifies the dates: "where a.appln_filing_date between '1990-01-01' and '2017-12-31' ", so not 31.12.2020 as what you wrote. There are also duplicate applications in you result because you added the followi...

On your second question (PATSTAT): The country-publication filter stands for patent application at that agency. Is that correct? Using PATSTAT, How can I use all agencies, and at the same time, the patent is only counted once? The country of publication always matches an originating application. And...

Hello Waka, a condition such as appln_auth = 'MX' will give only patents that were filed in Mexico -most of them in fact not filed by Mexican applicants, but rather large multinationals that want to protect their inventions in Mexico-. If you want to only retrieve patents filed in Mexico by Mexican ...

"New" report on SEPs by JRC for EC, using PATSTAT (and more).

Hello Marcastell, the earliest_filing_date is "The earliest date of the filing dates of the application itself, its international application, its Paris Convention priority applications, the applications with which it is related via technical relations and its application continuations." W...

Dear Elisa, the PATSTAT data base is based on the data available in publications of patent documents. For EP patent applications: that means that when there is a "change of ownership" before a (later) publication, the new applicant will be published. So the EP(A1) publication can have a di...