Dataset: Countries

This table contains time series data for 11309 statistical variables for location: Spain (Data Commons location id: country/ESP).

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/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	2005	1209	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male
country/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	2016	770	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male
country/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	2014	802	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male
country/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	2002	1187	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male
country/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	1997	1295	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male
country/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	2000	1158	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male
country/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	2012	922	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male
country/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	1994	1602	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male
country/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	2008	1139	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male
country/ESP	Spain	EuropeanUnion	European Union	Count_Death_Upto4Years_Male	2021	569	OECDRegionalStatistics	P1Y	OECDRegionalDemography	oecd.org	https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

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

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

2005

1209

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

country/ESP

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

2016

770

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

country/ESP

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

2014

802

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

country/ESP

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

2002

1187

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

country/ESP

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

1997

1295

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

country/ESP

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

2000

1158

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

country/ESP

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

2012

922

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

country/ESP

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

1994

1602

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

country/ESP

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

2008

1139

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

country/ESP

Spain

EuropeanUnion

European Union

Count_Death_Upto4Years_Male

2021

569

OECDRegionalStatistics

P1Y

OECDRegionalDemography

oecd.org

https://datacommons.org/browser/country/ESP?statVar=Count_Death_Upto4Years_Male

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

Spain - Time Series For Statistical Variables

@datacommons.countries.spain_country_esp

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