PCT applications will have "WO" in combination with a value in the receiving_office in PATSTAT2018a.
This can lead to un-expected results when using "old queries". You might need to adapt them.
Take the following query:
Code: Select all
SELECT distinct appln_id, appln_auth, appln_nr, appln_kind, appln_filing_date
FROM tls201_appln
where appln_filing_year = 2012
and appln_auth = 'NL'
order by appln_id
To obtain the same result as before, one could use a query such as this:
Code: Select all
SELECT distinct appln_id, appln_auth, appln_nr, appln_kind, appln_filing_date
FROM tls201_appln
where appln_filing_year = 2012
and (appln_auth = 'NL' or receiving_office ='NL')
order by appln_id