MacroEconomic Monthly 50 Countries,17000 Series
MacroEconomic Monthly with > 50 countries and17000 series from OECD, 2010-2023 M
@kaggle.pawankumark_macroeconomic_monthly_50_countries17000_series
MacroEconomic Monthly with > 50 countries and17000 series from OECD, 2010-2023 M
@kaggle.pawankumark_macroeconomic_monthly_50_countries17000_series
CREATE TABLE med_merged (
"unnamed_0" BIGINT,
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE med_all_features (
"unnamed_0" TIMESTAMP,
"deu_odmnto01_ixob" DOUBLE,
"deu_odmnto01_ixobsa" DOUBLE,
"swe_odmnto01_ixobsa" DOUBLE,
"deu_slmncn01_ixob" DOUBLE,
"deu_slmncn01_ixobsa" DOUBLE,
"aut_prmnto01_ixob" DOUBLE,
"aut_prmnto01_ixobsa" DOUBLE,
"aut_prmnto01_gpsa" DOUBLE,
"bel_prmnto01_ixob" DOUBLE,
"bel_prmnto01_ixobsa" DOUBLE,
"bel_prmnto01_gpsa" DOUBLE,
"can_prmnto01_ixob" DOUBLE,
"can_prmnto01_ixobsa" DOUBLE,
"can_prmnto01_ml" DOUBLE,
"can_prmnto01_mlsa" DOUBLE,
"can_prmnto01_gpsa" DOUBLE,
"cze_prmnto01_ixob" DOUBLE,
"cze_prmnto01_ixobsa" DOUBLE,
"cze_prmnto01_gpsa" DOUBLE,
"dnk_prmnto01_ixob" DOUBLE,
"dnk_prmnto01_ixobsa" DOUBLE,
"dnk_prmnto01_gpsa" DOUBLE,
"fin_prmnto01_ixob" DOUBLE,
"fin_prmnto01_ixobsa" DOUBLE,
"fin_prmnto01_gpsa" DOUBLE,
"fra_prmnto01_ixob" DOUBLE,
"fra_prmnto01_ixobsa" DOUBLE,
"fra_prmnto01_gpsa" DOUBLE,
"deu_prmnto01_ixob" DOUBLE,
"deu_prmnto01_ixobsa" DOUBLE,
"deu_prmnto01_gpsa" DOUBLE,
"grc_prmnto01_ixob" DOUBLE,
"grc_prmnto01_ixobsa" DOUBLE,
"grc_prmnto01_gpsa" DOUBLE,
"hun_prmnto01_ixob" DOUBLE,
"hun_prmnto01_ixobsa" DOUBLE,
"hun_prmnto01_gpsa" DOUBLE,
"isl_prmnto01_ixob" DOUBLE,
"isl_prmnto01_ixobsa" DOUBLE,
"isl_prmnto01_ml" DOUBLE,
"isl_prmnto01_mlsa" DOUBLE,
"isl_prmnto01_gpsa" DOUBLE,
"isl_prmnto01_gysa" DOUBLE,
"irl_prmnto01_ixob" DOUBLE,
"irl_prmnto01_ixobsa" DOUBLE,
"irl_prmnto01_gpsa" DOUBLE,
"ita_prmnto01_ixob" DOUBLE,
"ita_prmnto01_ixobsa" DOUBLE,
"ita_prmnto01_gpsa" DOUBLE,
"jpn_prmnto01_ixob" DOUBLE,
"jpn_prmnto01_ixobsa" DOUBLE,
"jpn_prmnto01_gpsa" DOUBLE,
"kor_prmnto01_ixob" DOUBLE,
"kor_prmnto01_ixobsa" DOUBLE,
"kor_prmnto01_gpsa" DOUBLE,
"lux_prmnto01_ixob" DOUBLE,
"lux_prmnto01_ixobsa" DOUBLE,
"lux_prmnto01_gpsa" DOUBLE,
"mex_prmnto01_ixob" DOUBLE,
"mex_prmnto01_ixobsa" DOUBLE,
"mex_prmnto01_gpsa" DOUBLE,
"nld_prmnto01_ixob" DOUBLE,
"nld_prmnto01_ixobsa" DOUBLE,
"nld_prmnto01_gpsa" DOUBLE,
"nor_prmnto01_ixob" DOUBLE,
"nor_prmnto01_ixobsa" DOUBLE,
"nor_prmnto01_gpsa" DOUBLE,
"pol_prmnto01_ixob" DOUBLE,
"pol_prmnto01_ixobsa" DOUBLE,
"pol_prmnto01_gpsa" DOUBLE,
"prt_prmnto01_ixob" DOUBLE,
"prt_prmnto01_ixobsa" DOUBLE,
"prt_prmnto01_gpsa" DOUBLE,
"svk_prmnto01_ixob" DOUBLE,
"svk_prmnto01_ixobsa" DOUBLE,
"svk_prmnto01_gpsa" DOUBLE,
"esp_prmnto01_ixob" DOUBLE,
"esp_prmnto01_ixobsa" DOUBLE,
"esp_prmnto01_gpsa" DOUBLE,
"swe_prmnto01_ixob" DOUBLE,
"swe_prmnto01_ixobsa" DOUBLE,
"swe_prmnto01_gpsa" DOUBLE,
"tur_prmnto01_ixob" DOUBLE,
"tur_prmnto01_ixobsa" DOUBLE,
"tur_prmnto01_gpsa" DOUBLE,
"gbr_prmnto01_ixob" DOUBLE,
"gbr_prmnto01_ixobsa" DOUBLE,
"gbr_prmnto01_gpsa" DOUBLE,
"usa_prmnto01_ixob" DOUBLE,
"usa_prmnto01_ixobsa" DOUBLE,
"usa_prmnto01_gpsa" DOUBLE,
"bra_prmnto01_ixob" DOUBLE,
"bra_prmnto01_ixobsa" DOUBLE,
"bra_prmnto01_gpsa" DOUBLE,
"chl_prmnto01_ixob" DOUBLE,
"chl_prmnto01_ixobsa" DOUBLE,
"chl_prmnto01_gpsa" DOUBLE,
"chl_prmnto01_gysa" DOUBLE,
"est_prmnto01_ixob" DOUBLE
);
CREATE TABLE p8 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p5_2 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p7 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p6 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p5_3 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p5_1_1 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p4 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p2 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p3 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p5_1_2 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p5_1_3 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
CREATE TABLE p1 (
"location" VARCHAR,
"country" VARCHAR,
"subject" VARCHAR,
"subject_fda041" VARCHAR,
"measure" VARCHAR,
"measure_277efb" VARCHAR,
"frequency" VARCHAR,
"frequency_659f01" VARCHAR,
"time" TIMESTAMP,
"time_660678" VARCHAR,
"unit_code" VARCHAR,
"unit" VARCHAR,
"powercode_code" BIGINT,
"powercode" VARCHAR,
"reference_period_code" VARCHAR,
"reference_period" VARCHAR,
"value" DOUBLE,
"flag_codes" VARCHAR,
"flags" VARCHAR
);
Anyone who has the link will be able to view this.