European patent applications?

[nico.rasters]

Eurostat publishes some data regarding "European patent applications".

European patent applications refer to applications filed directly under the EPC or to applications filed under the Patent Cooperation Treaty (PCT) and designated to the EPO (Euro-PCT).
Patent applications are counted according to the year in which they are filed and are assigned to a country according to the inventor’s place of residence, using fractional counting if there are multiple inventors.

In the OECD Patent Statistics Manual they say that:

A European patent application can originate from:
i) direct filing to the EPO without a priority claim (i.e. first filing)
ii) extension of an earlier national patent application (within 12 months of first filing)
iii) from an international application filed using the PCT procedure
The first two categories are known as “Euro-direct” while the third is known as “Euro-PCT”.

But of course nobody bothers to post the actual PATSTAT queries.

Are the following queries correct?

Direct filing to the EPO without a priority claim (i.e. first filing)
The assumption here is that "direct filing to the EPO" equals `appln_auth`="EP"
SELECT `tls201_appln`.*
FROM `tls201_appln`
LEFT OUTER JOIN `tls204_appln_prior` ON `tls201_appln`.`appln_id` = `tls204_appln_prior`.`appln_id`
LEFT OUTER JOIN `tls205_tech_rel` ON `tls201_appln`.`appln_id` = `tls205_tech_rel`.`appln_id`
LEFT OUTER JOIN `tls216_appln_contn` ON `tls201_appln`.`appln_id` = `tls216_appln_contn`.`appln_id`
WHERE `appln_auth` = "EP"
AND `appln_kind` = "A"
AND `tls204_appln_prior`.`appln_id` IS NULL
AND `tls205_tech_rel`.`appln_id` IS NULL
AND `tls216_appln_contn`.`appln_id`IS NULL;

extension of an earlier national patent application (within 12 months of first filing)
I assume that these national applications have to be in EPC contracting states, taking into account their date of entry? E.g. Belgium on 7 october 1977, Hungary on 1 January 2003, Malta on 1 March 2007.
What is meant by extension? What is a "national application"? Does this national application have to be the first filing?

National applications are generally filed at a national patent office, such as the United Kingdom Patent Office, to obtain a patent in the country of that office. The application may either be filed directly at that office, or may result from a regional application or from an international application under the Patent Cooperation Treaty (PCT), once it enters the national phase.

Suppose we try to find all EP patent applications that have a priority filing in Malta.
SELECT `tls201_appln`.*
FROM `tls201_appln`
LEFT OUTER JOIN `tls204_appln_prior` ON `tls201_appln`.`appln_id` = `tls204_appln_prior`.`appln_id`
LEFT OUTER JOIN `tls205_tech_rel` ON `tls201_appln`.`appln_id` = `tls205_tech_rel`.`appln_id`
LEFT OUTER JOIN `tls216_appln_contn` ON `tls201_appln`.`appln_id` = `tls216_appln_contn`.`appln_id`
WHERE `appln_auth` = "EP"
AND `appln_kind` = "A"
AND (`tls204_appln_prior`.`prior_appln_id` IN (SELECT `appln_id` FROM `tls201_appln` WHERE `appln_auth`="MA" AND `appln_kind`="A" AND `appln_filing_date`>="2007-03-01")
OR `tls205_tech_rel`.`tech_rel_appln_id` IN (SELECT `appln_id` FROM `tls201_appln` WHERE `appln_auth`="MA" AND `appln_kind`="A" AND `appln_filing_date`>="2007-03-01")
OR `tls216_appln_contn`.`parent_appln_id`IN (SELECT `appln_id` FROM `tls201_appln` WHERE `appln_auth`="MA" AND `appln_kind`="A" AND `appln_filing_date`>="2007-03-01"));

We find one patent with appln_id=274119781, appln_filing_date=2009-07-09, and internat_appln_id=58082778. That international patent turns out to be a PCT application with the WIPO (with the same filing date). The appln_filing_date of the priority Maltese patent is 2009-06-24, which is less than 12 months of the EP patent). So this patent meets the criteria.

Rinse and repeat for all contracting states?

from an international application filed using the PCT procedure
PCT applications have APPLN_KIND="W", and international applications are found by INTERNAT_APPLN_ID.

I guess we need EP patents that refer to the PCT applications through the internat_appln_id field.
Gianluca wrote something about EURO-PCTs on http://rawpatentdata.blogspot.nl/2010/1 ... ering.html which seems to confirm this assumption.

SELECT EP.*
FROM `tls201_appln` AS EP
INNER JOIN `tls201_appln` AS PCT ON EP.`internat_appln_id` = PCT.`appln_id`
WHERE EP.`appln_auth`="EP" AND EP.`appln_kind`="A" AND PCT.`appln_kind`="W";

I would very much appreciate some feedback on all of this.

[nico.rasters]

For example, what query was used to get the numbers as reported on http://www.epo.org/about-us/annual-repo ... lings.html?