Wednesday, October 11, 2017

MySQL upload scripts for EEE-PPAT 2017a

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)

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