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
Patents with at least one inventor from Brussels
-
- Posts: 1
- Joined: Sat May 09, 2020 7:34 pm
-
- Posts: 425
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Patents with at least one inventor from Brussels
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.
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.
(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.)
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
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
EPO - Vienna
patstat @ epo.org