dear all
trying to select east Germany inventors @ EPO (DD) I found a very small number of them (about 359) compared to the high number of DD applications existing before 1990
I was wondering whether there could be some tipe of bias (political, geographic) in the data or if DD country code had been converted to DE
thanks in advance for any help (select query below)
SELECT
t1.APPLN_AUTH,
t6.PERSON_CTRY_CODE,
Count(DISTINCT t1.APPLN_ID) AS Count_APPLN_ID
FROM
patstat.tls207_pers_appln t7
INNER JOIN patstat.tls201_appln t1 ON t1.APPLN_ID = t7.APPLN_ID
INNER JOIN patstat.tls206_person t6 ON t7.PERSON_ID = t6.PERSON_ID
WHERE
t1.APPLN_AUTH = 'EP' AND
t7.INVT_SEQ_NR > 0 AND
t6.PERSON_CTRY_CODE = 'DD'
GROUP BY
t1.APPLN_AUTH,
t6.PERSON_CTRY_CODE
East Germany inventors @ EPO
-
- Posts: 63
- Joined: Mon Nov 09, 2009 8:48 pm
- Location: Italy
- Contact:
-
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: East Germany inventors @ EPO
Hello Gianluca,
Interesting question.
But a proof could be to check for EP applications (filed between 1979 - 1990) that have a DD priority, but no DD inventors/applicants. And then compare applicant/inventors countries.
Just an idea.
Geert
Interesting question.
But a proof could be to check for EP applications (filed between 1979 - 1990) that have a DD priority, but no DD inventors/applicants. And then compare applicant/inventors countries.
Just an idea.
Geert
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org
-
- Posts: 63
- Joined: Mon Nov 09, 2009 8:48 pm
- Location: Italy
- Contact:
Re: East Germany inventors @ EPO
Actually what I did was to investigate the families with first filing @ DD and at least one EPO patent; it seems only 476 of them exist...(checking all families with at least one DD would probably get filing from west Germany extended to DDR) so it's likely to be a political issue...
-
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: East Germany inventors @ EPO
Or a financial one...
I looked at all EP applications that had a DD priority that was filed before the German reunification (1990)
This was the query I used:
The majority have effectively a DD person country code for the inventors and applicants.
But there are some exeptions; notably: "Akademie der Wissenschaften der DDR" has DE as country code.
If you look at an application in detail (https://register.epo.org/application?nu ... 6&tab=main) you can see that that printed document effectively shows DD, but as PATSTAT uses the EP Register person data, any changes that were registered will trickle through into PATSTAT. Strangely enough there is no mention in the Register on that change, but maybe "mass changes" are not registered as an event.
I looked at all EP applications that had a DD priority that was filed before the German reunification (1990)
This was the query I used:
Code: Select all
SELECT distinct app.[appln_id]
,app.[appln_auth]
,app.[appln_nr]
,app.[appln_kind]
,app.[appln_filing_date]
,app.[appln_nr_original]
,prior.[appln_id]
,prior.[appln_auth]
,prior.[appln_nr]
,prior.[appln_kind]
,prior.[appln_filing_date]
,prior.[appln_nr_original]
,prior.[ipr_type]
,prior.[receiving_office]
,invt_seq_nr
,applt_seq_nr
,person_name
,person_address
,person_ctry_code
FROM [tls201_appln] app
join [tls204_appln_prior] on app.appln_id = tls204_appln_prior.appln_id
join [tls201_appln] prior on tls204_appln_prior.prior_appln_id = prior.appln_id
join tls207_pers_appln on app.appln_id = tls207_pers_appln.appln_id
join tls206_person on tls207_pers_appln.person_id = tls206_person.person_id
where app.appln_auth = 'EP' and prior.appln_auth = 'dd' and prior.appln_filing_year < 1990
order by app.appln_id, applt_seq_nr, invt_seq_nr
But there are some exeptions; notably: "Akademie der Wissenschaften der DDR" has DE as country code.
If you look at an application in detail (https://register.epo.org/application?nu ... 6&tab=main) you can see that that printed document effectively shows DD, but as PATSTAT uses the EP Register person data, any changes that were registered will trickle through into PATSTAT. Strangely enough there is no mention in the Register on that change, but maybe "mass changes" are not registered as an event.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org
-
- Posts: 63
- Joined: Mon Nov 09, 2009 8:48 pm
- Location: Italy
- Contact: