Global Creative Economy Trade Data
Comprehensive Insights into International Trade of Creative Services and Goods
@kaggle.programmerrdai_global_creative_economy_trade_data
Comprehensive Insights into International Trade of Creative Services and Goods
@kaggle.programmerrdai_global_creative_economy_trade_data
CREATE TABLE us_creativegoodsgr (
"period" BIGINT,
"period_label" VARCHAR,
"economy" BIGINT,
"economy_label" VARCHAR,
"partner" VARCHAR,
"partner_label" VARCHAR,
"flow" BIGINT,
"flow_label" VARCHAR,
"product" VARCHAR,
"product_label" VARCHAR,
"annual_average_growth_rate" DOUBLE,
"annual_average_growth_rate_footnote" VARCHAR,
"annual_average_growth_rate_missing_value" VARCHAR
);
CREATE TABLE us_creativegoodsindex (
"year" BIGINT,
"flow" BIGINT,
"flow_label" VARCHAR,
"product" VARCHAR,
"product_label" VARCHAR,
"concentration_index" DOUBLE,
"concentration_index_footnote" VARCHAR,
"concentration_index_missing_value" VARCHAR
);
CREATE TABLE us_creativegoodsvalue (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"partner" VARCHAR,
"partner_label" VARCHAR,
"flow" BIGINT,
"flow_label" VARCHAR,
"product" VARCHAR,
"product_label" VARCHAR,
"us_at_current_prices_in_millions" DOUBLE,
"us_at_current_prices_in_millions_footnote" VARCHAR,
"us_at_current_prices_in_millions_missing_value" VARCHAR,
"percentage_of_total_world" DOUBLE,
"percentage_of_total_world_footnote" VARCHAR,
"percentage_of_total_world_missing_value" VARCHAR,
"percentage_by_destination" DOUBLE,
"percentage_by_destination_footnote" VARCHAR,
"percentage_by_destination_missing_value" VARCHAR
);
CREATE TABLE us_creativeserv_group_e (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"creativeservice" VARCHAR,
"creativeservice_label" VARCHAR,
"us_at_current_prices_in_millions" DOUBLE,
"us_at_current_prices_in_millions_footnote" VARCHAR,
"us_at_current_prices_in_millions_missing_value" VARCHAR,
"growth_rate_year_on_year" DOUBLE,
"growth_rate_year_on_year_footnote" VARCHAR,
"growth_rate_year_on_year_missing_value" VARCHAR,
"percentage_of_total_trade_in_services" DOUBLE,
"percentage_of_total_trade_in_services_footnote" VARCHAR,
"percentage_of_total_trade_in_services_missing_value" VARCHAR
);
CREATE TABLE us_creativeserv_indiv_tot (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"flow" BIGINT,
"flow_label" VARCHAR,
"us_at_current_prices_in_millions" DOUBLE,
"us_at_current_prices_in_millions_footnote" VARCHAR,
"us_at_current_prices_in_millions_missing_value" VARCHAR,
"growth_rate_year_on_year" DOUBLE,
"growth_rate_year_on_year_footnote" VARCHAR,
"growth_rate_year_on_year_missing_value" VARCHAR,
"percentage_of_total_trade_in_services" DOUBLE,
"percentage_of_total_trade_in_services_footnote" VARCHAR,
"percentage_of_total_trade_in_services_missing_value" VARCHAR
);
Anyone who has the link will be able to view this.