Baselight

Inter-Country Use Flatfile

Joint Research Centre

@ecjrc.n_1946d725_91e8_4d86_9361_9e2e262b222b

Use Flatfile
@ecjrc.n_1946d725_91e8_4d86_9361_9e2e262b222b.use_flatfile

  • 198.8 MB
  • 81669734 rows
  • 8 columns
icuserow

IcuseRow

icusecol

IcuseCol

refarea

RefArea

rowpi

RowPi

counterpartarea

CounterpartArea

colpi

ColPi

unit

Unit

obsvalue

ObsValue

AR_CPA_A01_AAR_A01_AARCPA_A01_AARA01_Amillion EURO6.398
AR_CPA_A01_AAR_A01_BARCPA_A01_AARA01_Bmillion EURO
AR_CPA_A01_AAR_A01_CARCPA_A01_AARA01_Cmillion EURO
AR_CPA_A01_AAR_A01_DARCPA_A01_AARA01_Dmillion EURO
AR_CPA_A01_AAR_A01_EARCPA_A01_AARA01_Emillion EURO
AR_CPA_A01_AAR_A01_FARCPA_A01_AARA01_Fmillion EURO
AR_CPA_A01_AAR_A01_GARCPA_A01_AARA01_Gmillion EURO
AR_CPA_A01_AAR_A01_HARCPA_A01_AARA01_Hmillion EURO
AR_CPA_A01_AAR_A01_IARCPA_A01_AARA01_Imillion EURO1.95
AR_CPA_A01_AAR_A01_JARCPA_A01_AARA01_Jmillion EURO8.88

CREATE TABLE use_flatfile (
  "icuserow" VARCHAR,
  "icusecol" VARCHAR,
  "refarea" VARCHAR,
  "rowpi" VARCHAR,
  "counterpartarea" VARCHAR,
  "colpi" VARCHAR,
  "unit" VARCHAR,
  "obsvalue" DOUBLE
);

Share link

Anyone who has the link will be able to view this.