Exporter Dynamics Database – Indicators At Country-Year Level
Export Performance, Firm Characteristics, and Market Dynamics Across 70 Countries (1997-2014)
@worldbank.exporter_dynamics_database_indicators_at_country_year_level
Export Performance, Firm Characteristics, and Market Dynamics Across 70 Countries (1997-2014)
@worldbank.exporter_dynamics_database_indicators_at_country_year_level
The Exporter Dynamics Database is the first database providing indicators for close to 70 countries over the period 1997-2014 on the basic characteristics of their exporting firms, their concentration and diversification, their dynamics in terms of entry, exit and survival, and the unit prices of the goods they trade.
This particular sub-database provides indicators at the country-year level, all are calculated based on exporter-level customs data for each country.
CREATE TABLE a1 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a10i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a10ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a10iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a10iv (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a10v (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a11i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a11ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a11iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a11iv (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a11v (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a12i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a12ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a12iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a12iv (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a12v (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a2 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a3 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a4 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a5 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a6i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a6ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a6iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a6iv (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a6v (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a7i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a7ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a7iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a7iv (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a7v (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a8i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a8ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a8iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a8iv (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a8v (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a9i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a9ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a9iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a9iv (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE a9v (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b1 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b2i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b2ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b2iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b3i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b3ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b3iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b4i (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b4ii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE b4iii (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);Anyone who has the link will be able to view this.