EEE-PPAT table is an extension of the PERSON TABLE (TLS206) produced by ECOOM (Catholic University of Leuven) and Eurostat (see here). The extension concerns sector allocation and name harmonization of applicants.
October 2013 ediction contains 44730405 records, but it has standardized names and sectors for 15.291.352 legal person (not for individuals).
It can be required at no cost by contacting technoinfo@ecoom.be
MySql script I created for uploading the table can be downloaded here
October 2013 ediction contains 44730405 records, but it has standardized names and sectors for 15.291.352 legal person (not for individuals).
It can be required at no cost by contacting technoinfo@ecoom.be
MySql script I created for uploading the table can be downloaded here
2 comments:
Hi Gianluca, thank you for your code. Using your code I get errors like
"1366 Incorrect integer value: 'Blake, Adam P.' for column 'DOC_STD_NAME_ID' at row 6597821
1366 Incorrect integer value: 'BLAKE, ADAM, P.' for column 'PAT_CNT' at row 6597821
1262 Row 6597821 was truncated; it contained more data than there were input columns
1366 Incorrect integer value: 'Roberts, Alan' for column 'DOC_STD_NAME_ID' at row 6645690
1366 Incorrect integer value: 'ROBERTS, ALAN' for column 'PAT_CNT' at row 6645690
1262 Row 6645690 was truncated; it contained more data than there were input columns"
and I do not get why. I digged into the csv file with another editor and I the lines looks good, with no compiling errors.
Have you any hint?
It is not a fatal issue, since I get 64 warnings and consequent truncations only, but still I am not satisfied.
hi
some records may have incorrect separator that is why, probably, some fields shift
Post a Comment