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
This dataset provides a comprehensive analysis of international trade in the creative economy, including experimental estimates and detailed matrices for selected economies. The dataset is particularly useful for researchers, policymakers, and industry analysts interested in understanding the dynamics of the global creative economy.
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,
"us_at_current_prices_in_millions_footnote" VARCHAR -- US$ At Current Prices In Millions Footnote,
"us_at_current_prices_in_millions_missing_value" VARCHAR -- US$ At Current Prices In Millions Missing Value,
"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,
"us_at_current_prices_in_millions_footnote" VARCHAR -- US$ At Current Prices In Millions Footnote,
"us_at_current_prices_in_millions_missing_value" VARCHAR -- US$ At Current Prices In Millions Missing Value,
"growth_rate_year_on_year" DOUBLE -- Growth Rate, Year-on-year,
"growth_rate_year_on_year_footnote" VARCHAR -- Growth Rate, Year-on-year Footnote,
"growth_rate_year_on_year_missing_value" VARCHAR -- Growth Rate, Year-on-year Missing Value,
"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,
"us_at_current_prices_in_millions_footnote" VARCHAR -- US$ At Current Prices In Millions Footnote,
"us_at_current_prices_in_millions_missing_value" VARCHAR -- US$ At Current Prices In Millions Missing Value,
"growth_rate_year_on_year" DOUBLE -- Growth Rate, Year-on-year,
"growth_rate_year_on_year_footnote" VARCHAR -- Growth Rate, Year-on-year Footnote,
"growth_rate_year_on_year_missing_value" VARCHAR -- Growth Rate, Year-on-year Missing Value,
"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.