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
This comprehensive dataset offers annual insights into core indicators within the Information and Communication Technology (ICT) sector, facilitating analysis and understanding of key trends and dynamics shaping the global digital landscape. Spanning various dimensions of ICT activities, the dataset includes bilateral trade flows by ICT goods categories, the share of ICT goods as a percentage of total trade, core indicators on ICT use in business by location type, enterprise size class, and industrial classification of economic activity (both ISIC Rev. 4 and ISIC Rev. 3.1), as well as international trade in digitally-deliverable services and ICT services. Researchers, policymakers, and analysts can leverage this dataset to explore the interplay between ICT development, trade dynamics, and business adoption across different sectors and geographic regions.
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 Of Total Digitally Deliverable Services Missing Value,
"percentage_change_year_on_year" DOUBLE -- Percentage Change (year-on-year),
"percentage_change_year_on_year_footnote" VARCHAR -- Percentage Change (year-on-year) Footnote,
"percentage_change_year_on_year_missing_value" VARCHAR -- Percentage Change (year-on-year) Missing Value
);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),
"growth_rate_over_previous_period_footnote" VARCHAR -- Growth Rate (over Previous Period) Footnote,
"growth_rate_over_previous_period_missing_value" VARCHAR -- Growth Rate (over Previous Period) Missing Value
);Anyone who has the link will be able to view this.