Baselight

Inter-Country Supply Flatfile

Joint Research Centre

@ecjrc.n_493550d7_543a_4ad6_b7df_f9f346903ae1

Supply Flatfile
@ecjrc.n_493550d7_543a_4ad6_b7df_f9f346903ae1.supply_flatfile

  • 1.35 MB
  • 1724448 rows
  • 8 columns
icsuprow

IcsupRow

icsupcol

IcsupCol

refarea

RefArea

rowpi

RowPi

counterpartarea

CounterpartArea

colpi

ColPi

unit

Unit

obsvalue

ObsValue

AR_CPA_A01_AAR_A01_AARCPA_A01_AARA01_Amillion EURO194.299
AR_CPA_A01_AAR_A01_BARCPA_A01_AARA01_Bmillion EURO12.285
AR_CPA_A01_AAR_A01_CARCPA_A01_AARA01_Cmillion EURO8.371
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 EURO60.504
AR_CPA_A01_AAR_A01_JARCPA_A01_AARA01_Jmillion EURO246.534

CREATE TABLE supply_flatfile (
  "icsuprow" VARCHAR,
  "icsupcol" 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.