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
);Anyone who has the link will be able to view this.