Baselight

Countries

Global Country-Level Statistics

@datacommons.countries

Afghanistan - Time Series For Statistical Variables
@datacommons.countries.afghanistan_country_afg

This table contains time series data for 5284 statistical variables for location: Afghanistan (Data Commons location id: country/AFG).

  • 1.79 MB
  • 205495 rows
  • 12 columns
place_id

Place Id

place_name

Place Name

parent_place_id

Parent Place Id

parent_place_name

Parent Place Name

variable

Variable

date

Date

value

Value

measurement_method

Measurement Method

observation_period

Observation Period

import_name

Import Name

provenance_domain

Provenance Domain

datacommons_url

Datacommons Url

country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A19840.0738161868725965EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A
country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A20070.121198199450221EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A
country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A19920.00399006378841145EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A
country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A19910.0468832551696551EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A
country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A19890.0633422677312703EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A
country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A20040.016957774494241EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A
country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A20120.618459185882021EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A
country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A19990.000498757407969372EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A
country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A19860.079801284817542EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A
country/AFGAfghanistanSouthernAsiaSouthern Asiaeia/INTL.7-1-MTOE.A19880.0688286082682463EIA_Internationaleia.govhttps://datacommons.org/browser/country/AFG?statVar=eia/INTL.7-1-MTOE.A

CREATE TABLE afghanistan_country_afg (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);

Share link

Anyone who has the link will be able to view this.