How to retrieve the correct set of applications ?

[Geert Boedt]

Sometimes PATSTAT user have problems defining the correct conditions to be used in the SQL query to retrieve a specific subset of patent filings.
For example: you need to retrieve all PCT applications that were filed at the European patent office, or you want to find all EP applications that originate from an earlier PCT filing (so called regional phase of a PCT). Retrieving such sets of patent applications comes down to a correct combination of the attributes: appln_auth, appln_kind and internat_appln_id.

The attached table gives an overview of possible combinations for EP and IB (International Bureau) filings. Similar combinations can be used for other filing authorities. One major aspect one has to keep in mind when working with PATSTAT, and which is rather different from many other data bases, is that PCT filings are identified through the condition appln_kind = 'W'. The application authority for those filings is the office where the PCT was filed. Those applications will always have publications that have the condition publn_auth = 'WO'.
The information in the attached table has also been pre-aggregated into the attributes INT_PHASE, REG_PHASE and NAT_PHASE in the TLS201_APPLN table.

routes.xlsx

(18.63 KiB) Downloaded 251 times