EEE-PPAT table is an extension of the PERSON TABLE (TLS206) produced by ECOOM (Catholic University of Leuven) and Eurostat. The extension concerns sector allocation and name harmonization of applicants.
2017a version contains 54430027 records, but it has improvements for standard names and sector, compared to PATSTAT ediction.
Here below how sector allocation changes (note sector '' is for inventors/individual that have no allocation)
It can be required at no cost by contacting technoinfo@ecoom.be
MySql script I created for uploading the table can be downloaded here
2017a version contains 54430027 records, but it has improvements for standard names and sector, compared to PATSTAT ediction.
Here below how sector allocation changes (note sector '' is for inventors/individual that have no allocation)
sector
|
patstat
|
eee-ppat
|
''
|
33318859
|
34172988
|
COMPANY
|
6189243
|
6350640
|
COMPANY GOV NON-PROFIT
|
58411
|
59098
|
COMPANY GOV NON-PROFIT UNIVERSITY
|
145
|
147
|
COMPANY HOSPITAL
|
884
|
876
|
COMPANY INDIVIDUAL
|
6
|
|
COMPANY UNIVERSITY
|
870
|
872
|
GOV NON-PROFIT
|
242180
|
249389
|
GOV NON-PROFIT HOSPITAL
|
15
|
17
|
GOV NON-PROFIT UNIVERSITY
|
8606
|
8752
|
HOSPITAL
|
12433
|
12650
|
INDIVIDUAL
|
11352954
|
11482216
|
UNIVERSITY
|
134947
|
143446
|
UNIVERSITY HOSPITAL
|
5
|
8
|
UNKNOWN
|
3110475
|
1948916
|
It can be required at no cost by contacting technoinfo@ecoom.be
MySql script I created for uploading the table can be downloaded here
No comments:
Post a Comment