Dataset: Natural Earth - Large Scale Data (1:10m Cultural Vectors)

About this Dataset

Natural Earth - Large Scale Data (1:10m Cultural Vectors)

There are 258 countries in the world. Greenland as separate from Denmark. Most users will want this file instead of sovereign states, though some users will want map units instead when distinguishing overseas regions of France.

Natural Earth shows de facto boundaries by default according to who controls the territory, versus de jure. Optional point-of-view (POV) variants are available for several dozen countries in the next section.

Countries distinguish between metropolitan (homeland) and independent and semi-independent portions of sovereign states. If you want to see the dependent overseas regions broken out (like in ISO codes, see France for example), use map units instead.

Each country is coded with a world region that roughly follows the United Nations setup.

Countries are coded with standard ISO and FIPS codes. French INSEE codes are also included.

Includes some thematic data from the United Nations, U.S. Central Intelligence Agency, and elsewhere.

This is the most detailed. Suitable for making zoomed-in maps of countries and regions. Show the world on a large wall poster:

1:10,000,000
1″ = 158 miles
1 cm = 100 km

All users of Natural Earth are highly encouraged to read about data sources and manipulation in the Data Creation section.

Tables

Natural Earth - Large Scale Data (1:10m Cultural Vectors)

@owid.nat_earth_110.owid_nat_earth_110

101.48 MB
258 rows
171 columns


CREATE TABLE owid_nat_earth_110 (
  "name" VARCHAR,
  "featurecla" VARCHAR,
  "scalerank" INTEGER,
  "labelrank" INTEGER,
  "sovereignt" VARCHAR,
  "sov_a3" VARCHAR,
  "adm0_dif" INTEGER,
  "level" INTEGER,
  "type" VARCHAR,
  "tlc" INTEGER,
  "admin" VARCHAR,
  "adm0_a3" VARCHAR,
  "geou_dif" INTEGER,
  "geounit" VARCHAR,
  "gu_a3" VARCHAR,
  "su_dif" INTEGER,
  "subunit" VARCHAR,
  "su_a3" VARCHAR,
  "brk_diff" INTEGER,
  "name_long" VARCHAR,
  "brk_a3" VARCHAR,
  "brk_name" VARCHAR,
  "brk_group" VARCHAR,
  "abbrev" VARCHAR,
  "postal" VARCHAR,
  "formal_en" VARCHAR,
  "formal_fr" VARCHAR,
  "name_ciawf" VARCHAR,
  "note_adm0" VARCHAR,
  "note_brk" VARCHAR,
  "name_sort" VARCHAR,
  "name_alt" VARCHAR,
  "mapcolor7" INTEGER,
  "mapcolor8" INTEGER,
  "mapcolor9" INTEGER,
  "mapcolor13" INTEGER,
  "pop_est" UINTEGER,
  "pop_rank" INTEGER,
  "pop_year" INTEGER,
  "gdp_md" INTEGER,
  "gdp_year" INTEGER,
  "economy" VARCHAR,
  "income_grp" VARCHAR,
  "fips_10" VARCHAR,
  "iso_a2" VARCHAR,
  "iso_a2_eh" VARCHAR,
  "iso_a3" VARCHAR,
  "iso_a3_eh" VARCHAR,
  "iso_n3" INTEGER,
  "iso_n3_eh" INTEGER,
  "un_a3" INTEGER,
  "wb_a2" VARCHAR,
  "wb_a3" VARCHAR,
  "woe_id" INTEGER,
  "woe_id_eh" INTEGER,
  "woe_note" VARCHAR,
  "adm0_iso" VARCHAR,
  "adm0_diff" INTEGER,
  "adm0_tlc" VARCHAR,
  "adm0_a3_us" VARCHAR,
  "adm0_a3_fr" VARCHAR,
  "adm0_a3_ru" VARCHAR,
  "adm0_a3_es" VARCHAR,
  "adm0_a3_cn" VARCHAR,
  "adm0_a3_tw" VARCHAR,
  "adm0_a3_in" VARCHAR,
  "adm0_a3_np" VARCHAR,
  "adm0_a3_pk" VARCHAR,
  "adm0_a3_de" VARCHAR,
  "adm0_a3_gb" VARCHAR,
  "adm0_a3_br" VARCHAR,
  "adm0_a3_il" VARCHAR,
  "adm0_a3_ps" VARCHAR,
  "adm0_a3_sa" VARCHAR,
  "adm0_a3_eg" VARCHAR,
  "adm0_a3_ma" VARCHAR,
  "adm0_a3_pt" VARCHAR,
  "adm0_a3_ar" VARCHAR,
  "adm0_a3_jp" VARCHAR,
  "adm0_a3_ko" VARCHAR,
  "adm0_a3_vn" VARCHAR,
  "adm0_a3_tr" VARCHAR,
  "adm0_a3_id" VARCHAR,
  "adm0_a3_pl" VARCHAR,
  "adm0_a3_gr" VARCHAR,
  "adm0_a3_it" VARCHAR,
  "adm0_a3_nl" VARCHAR,
  "adm0_a3_se" VARCHAR,
  "adm0_a3_bd" VARCHAR,
  "adm0_a3_ua" VARCHAR,
  "adm0_a3_un" INTEGER,
  "adm0_a3_wb" INTEGER,
  "continent" VARCHAR,
  "region_un" VARCHAR,
  "subregion" VARCHAR,
  "region_wb" VARCHAR,
  "name_len" INTEGER,
  "long_len" INTEGER,
  "abbrev_len" INTEGER,
  "tiny" INTEGER
);