Dataset: Countries

This table contains time series data for 1770 statistical variables for location: Guam (Data Commons location id: country/GUM).

place_id Place Id	place_name Place Name	parent_place_id Parent Place Id	parent_place_name Parent Place Name	variable Variable	date Date	import_name Import Name	provenance_domain Provenance Domain	datacommons_url Datacommons Url
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	1996	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	1999	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	2002	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	2018	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	1986	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	2006	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	2009	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	1997	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	1988	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A
country/GUM	Guam	oceania	Oceania	eia/INTL.14-2-MTOE.A	2015	EIA_International	eia.gov	https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

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/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

1996

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

country/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

1999

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

country/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

2002

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

country/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

2018

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

country/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

1986

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

country/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

2006

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

country/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

2009

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

country/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

1997

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

country/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

1988

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

country/GUM

Guam

oceania

Oceania

eia/INTL.14-2-MTOE.A

2015

EIA_International

eia.gov

https://datacommons.org/browser/country/GUM?statVar=eia/INTL.14-2-MTOE.A

CREATE TABLE guam_country_gum ( "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 );

Countries

Table List

Guam - Time Series For Statistical Variables

@datacommons.countries.guam_country_gum

place_id

place_name

parent_place_id

parent_place_name

variable

date

value

measurement_method

observation_period

import_name

provenance_domain

datacommons_url

Share link