EU Inter-country Supply Table At Basic Prices (2018-2021)
Eurostat code: naio_10_fcp_s3 ยท (2018 - 2021)
@eurostat.naio_10_fcp_s3
Eurostat code: naio_10_fcp_s3 ยท (2018 - 2021)
@eurostat.naio_10_fcp_s3
CREATE TABLE raw (
"freq" VARCHAR,
"nace_r2" VARCHAR,
"cpa2_1" VARCHAR,
"c_dest" VARCHAR,
"unit" VARCHAR,
"c_orig" VARCHAR,
"n_2018" DOUBLE,
"n_2019" DOUBLE,
"n_2020" DOUBLE,
"n_2021" DOUBLE
);
CREATE TABLE tidy (
"freq" VARCHAR,
"nace_r2" VARCHAR,
"cpa2_1" VARCHAR,
"c_dest" VARCHAR,
"unit" VARCHAR,
"c_orig" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);
Anyone who has the link will be able to view this.