Dataset: States

This table contains time series data for 68556 statistical variables for location: Montana (Data Commons location id: geoId/30).

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	observation_period Observation Period	import_name Import Name	provenance_domain Provenance Domain	datacommons_url Datacommons Url
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	1995-03	19554902	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	2015-09	49693923	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	1992-09	16677329	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	2013-09	43101079	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	2007-12	49744968	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	2004-12	40058100	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	2016-06	52758887	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	2001-12	30379326	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	2020-09	67780521	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93
geoId/30	Montana	country/USA	United States	dc/kdlhfe13lpj93	2018-06	54569568	P3M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

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

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

1995-03

19554902

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

2015-09

49693923

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

1992-09

16677329

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

2013-09

43101079

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

2007-12

49744968

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

2004-12

40058100

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

2016-06

52758887

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

2001-12

30379326

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

2020-09

67780521

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

geoId/30

Montana

country/USA

United States

dc/kdlhfe13lpj93

2018-06

54569568

P3M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/30?statVar=dc/kdlhfe13lpj93

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

States

Table List

Montana - Time Series For Statistical Variables

@datacommons.states.montana_geoid_30

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