Penn World Table
@owid.penn_world_table_national_accounts
@owid.penn_world_table_national_accounts
PWT version 10.01 is a database with information on relative levels of income, output, input and productivity, covering 183 countries between 1950 and 2019.
CREATE TABLE owid_penn_world_table_national_accounts_1 (
"country" VARCHAR,
"year" INTEGER,
"v_c" FLOAT,
"v_i" FLOAT,
"v_g" FLOAT,
"v_x" FLOAT,
"v_m" FLOAT,
"v_gdp" FLOAT,
"q_c" FLOAT,
"q_i" FLOAT,
"q_g" FLOAT,
"q_x" FLOAT,
"q_m" FLOAT,
"q_gdp" FLOAT,
"pop" FLOAT,
"xr" FLOAT,
"xr2" FLOAT,
"v_gfcf" FLOAT,
"q_gfcf" FLOAT,
"emp" FLOAT,
"avh" FLOAT
);CREATE TABLE owid_penn_world_table_national_accounts_2 (
"country" VARCHAR,
"year" INTEGER,
"v_c" FLOAT,
"v_i" FLOAT,
"v_g" FLOAT,
"v_x" FLOAT,
"v_m" FLOAT,
"v_gdp" FLOAT,
"q_c" FLOAT,
"q_i" FLOAT,
"q_g" FLOAT,
"q_x" FLOAT,
"q_m" FLOAT,
"q_gdp" FLOAT,
"pop" FLOAT,
"xr" FLOAT,
"xr2" FLOAT,
"v_gfcf" FLOAT,
"q_gfcf" FLOAT,
"emp" FLOAT,
"avh" FLOAT
);Anyone who has the link will be able to view this.