Dataset: Penn World Table (GGDC, 2021)

About this Dataset

Penn World Table (GGDC, 2021)

Penn World Table is a database with information on GDP and its composition, employment, productivity and trade, covering 183 countries between 1950 and 2019.

Tables

Penn World Table

@owid.penn_world_table.owid_penn_world_table

2.86 MB
14262 rows
57 columns


CREATE TABLE owid_penn_world_table (
  "index" BIGINT,
  "country" VARCHAR,
  "year" INTEGER,
  "rgdpe" BIGINT,
  "rgdpo" BIGINT,
  "pop" FLOAT,
  "emp" FLOAT,
  "avh" FLOAT,
  "hc" FLOAT,
  "ccon" BIGINT,
  "cda" BIGINT,
  "cgdpe" BIGINT,
  "cgdpo" BIGINT,
  "cn" BIGINT,
  "ck" FLOAT,
  "ctfp" FLOAT,
  "cwtfp" FLOAT,
  "rgdpna" BIGINT,
  "rconna" BIGINT,
  "rdana" BIGINT,
  "rnna" BIGINT,
  "rkna" FLOAT,
  "rtfpna" FLOAT,
  "rwtfpna" FLOAT,
  "labsh" FLOAT,
  "irr" FLOAT,
  "delta" FLOAT,
  "xr" FLOAT,
  "pl_con" FLOAT,
  "pl_da" FLOAT,
  "pl_gdpo" FLOAT,
  "i_cig" VARCHAR,
  "i_xm" VARCHAR,
  "i_xr" VARCHAR,
  "i_irr" VARCHAR,
  "cor_exp" FLOAT,
  "statcap" FLOAT,
  "csh_c" FLOAT,
  "csh_i" FLOAT,
  "csh_g" FLOAT,
  "csh_x" FLOAT,
  "csh_m" FLOAT,
  "csh_r" FLOAT,
  "pl_c" FLOAT,
  "pl_i" FLOAT,
  "pl_g" FLOAT,
  "pl_x" FLOAT,
  "pl_m" FLOAT,
  "pl_n" FLOAT,
  "pl_k" FLOAT,
  "rgdpe_pc" FLOAT,
  "rgdpo_pc" FLOAT,
  "cgdpe_pc" FLOAT,
  "cgdpo_pc" FLOAT,
  "rgdpna_pc" FLOAT,
  "productivity" FLOAT,
  "trade_openness" FLOAT
);