East Germany inventors @ EPO

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

gianluca.tarasconi
Posts: 63
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy
Contact:

East Germany inventors @ EPO

Post by gianluca.tarasconi » Wed Mar 28, 2018 8:42 am

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


EPO / PATSTAT Support
Posts: 426
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: East Germany inventors @ EPO

Post by EPO / PATSTAT Support » Thu Mar 29, 2018 4:15 pm

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
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


gianluca.tarasconi
Posts: 63
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy
Contact:

Re: East Germany inventors @ EPO

Post by gianluca.tarasconi » Thu Mar 29, 2018 6:18 pm

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...


EPO / PATSTAT Support
Posts: 426
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: East Germany inventors @ EPO

Post by EPO / PATSTAT Support » Fri Apr 06, 2018 3:47 pm

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:

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 
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.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


gianluca.tarasconi
Posts: 63
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy
Contact:

Re: East Germany inventors @ EPO

Post by gianluca.tarasconi » Fri Apr 06, 2018 4:04 pm

interesting

thanks


Post Reply