Global ICT Sector Core Indicators
Insights into Trends and Dynamics Shaping the Digital Economy
@kaggle.programmerrdai_global_ict_sector_core_indicators
Insights into Trends and Dynamics Shaping the Digital Economy
@kaggle.programmerrdai_global_ict_sector_core_indicators
CREATE TABLE us_digitallydeliverableservices (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"flow" BIGINT,
"flow_label" VARCHAR,
"category" VARCHAR,
"category_label" VARCHAR,
"us_dollars_at_current_prices_in_millions" DOUBLE,
"us_dollars_at_current_prices_in_millions_footnote" VARCHAR,
"us_dollars_at_current_prices_in_millions_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,
"percentage_of_total_digitally_deliverable_services" DOUBLE,
"percentage_of_total_digitally_deliverable_services_footnote" VARCHAR,
"percentage_of_total_digitally_deliverable_services_mis_ffeafc31" VARCHAR,
"percentage_change_year_on_year" DOUBLE,
"percentage_change_year_on_year_footnote" VARCHAR,
"percentage_change_year_on_year_missing_value" VARCHAR
);
CREATE TABLE us_ictgoodsshare (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"partner" BIGINT,
"partner_label" VARCHAR,
"flow" BIGINT,
"flow_label" VARCHAR,
"ictgoodscategory" VARCHAR,
"ictgoodscategory_label" VARCHAR,
"percentage_of_total_merchandise_trade" DOUBLE,
"percentage_of_total_merchandise_trade_footnote" VARCHAR,
"percentage_of_total_merchandise_trade_missing_value" VARCHAR
);
CREATE TABLE us_ictgoodsvalue (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"partner" VARCHAR,
"partner_label" VARCHAR,
"flow" BIGINT,
"flow_label" VARCHAR,
"ictgoodscategory" VARCHAR,
"ictgoodscategory_label" VARCHAR,
"us_dollars_at_current_prices_in_millions" DOUBLE,
"us_dollars_at_current_prices_in_millions_footnote" VARCHAR,
"us_dollars_at_current_prices_in_millions_missing_value" VARCHAR
);
CREATE TABLE us_ictproductionsector_20230712035512 (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"variable" BIGINT,
"variable_label" VARCHAR,
"percentage_of_total_business_sector" DOUBLE,
"percentage_of_total_business_sector_footnote" VARCHAR,
"percentage_of_total_business_sector_missing_value" VARCHAR
);
CREATE TABLE us_ictuseeconactivity (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"useofict" BIGINT,
"useofict_label" VARCHAR,
"economicactivity" VARCHAR,
"economicactivity_label" VARCHAR,
"percentage" DOUBLE,
"percentage_footnote" VARCHAR,
"percentage_missing_value" VARCHAR
);
CREATE TABLE us_ictuseeconactivity_isic4_20230704050612 (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"useofict" BIGINT,
"useofict_label" VARCHAR,
"economicactivity" VARCHAR,
"economicactivity_label" VARCHAR,
"percentage" DOUBLE,
"percentage_footnote" VARCHAR,
"percentage_missing_value" VARCHAR
);
CREATE TABLE us_ictuseenterprsize_20230704051456 (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"useofict" BIGINT,
"useofict_label" VARCHAR,
"enterprisesize" BIGINT,
"enterprisesize_label" VARCHAR,
"percentage" DOUBLE,
"percentage_footnote" VARCHAR,
"percentage_missing_value" VARCHAR
);
CREATE TABLE us_ictuselocation_20230704052354 (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"useofict" BIGINT,
"useofict_label" VARCHAR,
"locationtype" BIGINT,
"locationtype_label" VARCHAR,
"percentage" DOUBLE,
"percentage_footnote" VARCHAR,
"percentage_missing_value" VARCHAR
);
CREATE TABLE us_tradeservict_20230904045147 (
"year" BIGINT,
"economy" BIGINT,
"economy_label" VARCHAR,
"flow" BIGINT,
"flow_label" VARCHAR,
"us_dollars_at_current_prices_in_millions" DOUBLE,
"us_dollars_at_current_prices_in_millions_footnote" VARCHAR,
"us_dollars_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_of_total_trade_in_services" DOUBLE,
"percentage_of_total_trade_in_services_footnote" VARCHAR,
"percentage_of_total_trade_in_services_missing_value" VARCHAR,
"growth_rate_over_previous_period" DOUBLE,
"growth_rate_over_previous_period_footnote" VARCHAR,
"growth_rate_over_previous_period_missing_value" VARCHAR
);
Anyone who has the link will be able to view this.