Patents with at least one inventor from Brussels

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

ironmathyu5
Posts: 1
Joined: Sat May 09, 2020 7:34 pm

Patents with at least one inventor from Brussels

Post by ironmathyu5 » Sat May 09, 2020 7:50 pm

Dear Madam/Sir,

i m PhD student and nowadays working with patents.
My focused is to identify all patents with at least one inventor from Brussels for period of 1990-2015.
I did a double search in order to get all information.
The first search method i used option of searching by city name with different variations of Brussels spelling in Patstat. Some how i got only patents from USPTO office.

For the second method i used search by country code BE, and with inventor addresses i searched Brussels (all spelling variations) and also include postal code and municipalities of Brussels. I got data from EPO and USPTO, but number of observations from USPTO were way less as i received from my first method of search. However, i compared data from USPTO and merged to data sets with excluding duplicates.
My questions are:

where i can find information at least about Brussels patents?
How i can check reliability of my data?
and if there any specialist who can make a look to my simple outcome from my data?

thank you very much for any suggestion or help

Best regards


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

Re: Patents with at least one inventor from Brussels

Post by EPO / PATSTAT Support » Wed May 13, 2020 4:21 pm

Hello ,
the easiest approach would be to use the NUTS codes available in the tls904_nuts table and linkable to the tls206_person table.
The first step is to define "Brussels"; the wider "provincial level" the region or the capital.
The query below gives you an overview of all Belgian NUTS codes.
Once you have decided what NUTS codes to include, then you can use the second query -adapted to your needs- to list the patents that have been filed at the EPO.

Code: Select all

SELECT nuts
      ,nuts_level
      ,nuts_label
  FROM tls904_nuts
  where nuts like 'be%'
  order by nuts_level

Code: Select all

SELECT psn_name,tls904_nuts.nuts ,nuts_label, tls201_appln.appln_id,
tls201_appln.appln_auth+tls201_appln.appln_nr application, 
tls201_appln.appln_filing_date
  FROM tls201_appln join tls207_pers_appln on tls201_appln.appln_id = tls207_pers_appln.appln_id
   join tls206_person  on tls206_person.person_id = tls207_pers_appln.person_id  
   join tls904_nuts on tls904_nuts.nuts = tls206_person.nuts
    where invt_seq_nr > 0 
	and appln_filing_year between 1990 and 2015
	and (left(tls904_nuts.nuts,4) = 'BE10')
	and appln_auth = 'EP'
group by psn_name,tls904_nuts.nuts ,  nuts_label, tls201_appln.appln_id
,tls201_appln.appln_auth+tls201_appln.appln_nr, tls201_appln.appln_filing_date
order by  psn_name, appln_filing_date, tls201_appln.appln_id
If you have access to PATSTAT Global, then you could also look for patents filed outside the EPO by using wildcard (text) searches on the address field because for those cases where no NUTS codes were (or could be) assigned. There is room for improvement here by adding names of "other parts of Brussels" manually.

Code: Select all

SELECT psn_name,tls904_nuts.nuts ,nuts_label, tls201_appln.appln_id,
tls201_appln.appln_auth+tls201_appln.appln_nr application
, tls201_appln.appln_filing_date, person_address
  FROM tls201_appln join tls207_pers_appln on tls201_appln.appln_id = tls207_pers_appln.appln_id
   join tls206_person  on tls206_person.person_id = tls207_pers_appln.person_id  
   join tls904_nuts on tls904_nuts.nuts = tls206_person.nuts
    where invt_seq_nr > 0 
	and appln_filing_year between 1990 and 2015
	and person_ctry_code ='BE'
	and appln_auth <> 'EP'
	and (person_address like '%bruss%' or person_address  like '%brux%')
group by psn_name ,tls904_nuts.nuts ,  nuts_label, tls201_appln.appln_id
,tls201_appln.appln_auth+tls201_appln.appln_nr
,tls201_appln.appln_filing_date,person_address
order by  psn_name, appln_filing_date, tls201_appln.appln_id

(no data will be returned in PATSTAT Online on the above query because addresses were removed from natural persons - which is in principle always the case for inventors.)
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply