Dataset: Countries

This table contains time series data for 10765 statistical variables for location: Portugal (Data Commons location id: country/PRT).

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	import_name Import Name	provenance_domain Provenance Domain	datacommons_url Datacommons Url
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	1990	107999.94907368	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	2008	129962.201042413	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	2004	145486.925915852	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	2018	64473.1961380898	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	1998	142769.947087754	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	1991	93050.4399718436	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	1983	69240.1504398927	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	2014	85468.5965940573	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	2017	86998.4286818346	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A
country/PRT	Portugal	EuropeanUnion	European Union	eia/INTL.68-2-TJ.A	2020	71033.1123680738	EIA_International	eia.gov	https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.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/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

1990

107999.94907368

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

country/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

2008

129962.201042413

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

country/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

2004

145486.925915852

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

country/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

2018

64473.1961380898

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

country/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

1998

142769.947087754

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

country/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

1991

93050.4399718436

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

country/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

1983

69240.1504398927

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

country/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

2014

85468.5965940573

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

country/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

2017

86998.4286818346

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

country/PRT

Portugal

EuropeanUnion

European Union

eia/INTL.68-2-TJ.A

2020

71033.1123680738

EIA_International

eia.gov

https://datacommons.org/browser/country/PRT?statVar=eia/INTL.68-2-TJ.A

CREATE TABLE portugal_country_prt ( "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

Portugal - Time Series For Statistical Variables

@datacommons.countries.portugal_country_prt

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