Dataset: Countries

This table contains time series data for 6007 statistical variables for location: Switzerland (Data Commons location id: country/CHE).

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/CHE	Switzerland	WesternEurope	Western Europe	sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M	2020	9.78333	SDG_C_G		UN_SDG	un.org	https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M
country/CHE	Switzerland	WesternEurope	Western Europe	sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M	2013	9.25417	SDG_C_G		UN_SDG	un.org	https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M
country/CHE	Switzerland	WesternEurope	Western Europe	sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M	2004	9.34583	SDG_C_G		UN_SDG	un.org	https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M
country/CHE	Switzerland	WesternEurope	Western Europe	sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M	2010	8.525	SDG_C_G		UN_SDG	un.org	https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M
country/CHE	Switzerland	WesternEurope	Western Europe	sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M	2000	8.675	SDG_C_G		UN_SDG	un.org	https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M
country/CHE	Switzerland	WesternEurope	Western Europe	sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M	2016	9.32917	SDG_C_G		UN_SDG	un.org	https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M
country/CHE	Switzerland	WesternEurope	Western Europe	sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M	2007	9.47083	SDG_C_G		UN_SDG	un.org	https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M
country/CHE	Switzerland	WesternEurope	Western Europe	worldBank/UIS_REPR_1_G2_F	1990	1.95924997329712	WorldBank_EdStats_CSV	P1Y	WorldBankDatasets	worldbank.org	https://datacommons.org/browser/country/CHE?statVar=worldBank/UIS_REPR_1_G2_F
country/CHE	Switzerland	WesternEurope	Western Europe	worldBank/UIS_REPR_1_G2_F	1988	1.96183001995087	WorldBank_EdStats_CSV	P1Y	WorldBankDatasets	worldbank.org	https://datacommons.org/browser/country/CHE?statVar=worldBank/UIS_REPR_1_G2_F
country/CHE	Switzerland	WesternEurope	Western Europe	worldBank/UIS_REPR_1_G2_F	1986	2.10372996330261	WorldBank_EdStats_CSV	P1Y	WorldBankDatasets	worldbank.org	https://datacommons.org/browser/country/CHE?statVar=worldBank/UIS_REPR_1_G2_F

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

Switzerland

WesternEurope

Western Europe

sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

2020

9.78333

SDG_C_G

UN_SDG

un.org

https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

country/CHE

Switzerland

WesternEurope

Western Europe

sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

2013

9.25417

SDG_C_G

UN_SDG

un.org

https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

country/CHE

Switzerland

WesternEurope

Western Europe

sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

2004

9.34583

SDG_C_G

UN_SDG

un.org

https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

country/CHE

Switzerland

WesternEurope

Western Europe

sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

2010

8.525

SDG_C_G

UN_SDG

un.org

https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

country/CHE

Switzerland

WesternEurope

Western Europe

sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

2000

8.675

SDG_C_G

UN_SDG

un.org

https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

country/CHE

Switzerland

WesternEurope

Western Europe

sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

2016

9.32917

SDG_C_G

UN_SDG

un.org

https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

country/CHE

Switzerland

WesternEurope

Western Europe

sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

2007

9.47083

SDG_C_G

UN_SDG

un.org

https://datacommons.org/browser/country/CHE?statVar=sdg/SL_DOM_TSPDDC.AGE--Y55T64__SEX--M

country/CHE

Switzerland

WesternEurope

Western Europe

worldBank/UIS_REPR_1_G2_F

1990

1.95924997329712

WorldBank_EdStats_CSV

P1Y

WorldBankDatasets

worldbank.org

https://datacommons.org/browser/country/CHE?statVar=worldBank/UIS_REPR_1_G2_F

country/CHE

Switzerland

WesternEurope

Western Europe

worldBank/UIS_REPR_1_G2_F

1988

1.96183001995087

WorldBank_EdStats_CSV

P1Y

WorldBankDatasets

worldbank.org

https://datacommons.org/browser/country/CHE?statVar=worldBank/UIS_REPR_1_G2_F

country/CHE

Switzerland

WesternEurope

Western Europe

worldBank/UIS_REPR_1_G2_F

1986

2.10372996330261

WorldBank_EdStats_CSV

P1Y

WorldBankDatasets

worldbank.org

https://datacommons.org/browser/country/CHE?statVar=worldBank/UIS_REPR_1_G2_F

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

Switzerland - Time Series For Statistical Variables

@datacommons.countries.switzerland_country_che

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