Dataset: Counties

This table contains time series data for 52019 statistical variables for location: Washington County (Data Commons location id: geoId/27163).

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/27163	Washington County	geoId/27	Minnesota	dc/4exp28eszf777	2012	42		USEconomicCensus	census.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/4exp28eszf777
geoId/27163	Washington County	geoId/27	Minnesota	dc/p399z10w43vyh	2002-02	27	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh
geoId/27163	Washington County	geoId/27	Minnesota	dc/p399z10w43vyh	2009-12	95	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh
geoId/27163	Washington County	geoId/27	Minnesota	dc/p399z10w43vyh	2015-05	149	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh
geoId/27163	Washington County	geoId/27	Minnesota	dc/p399z10w43vyh	2008-01	107	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh
geoId/27163	Washington County	geoId/27	Minnesota	dc/p399z10w43vyh	2009-06	96	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh
geoId/27163	Washington County	geoId/27	Minnesota	dc/p399z10w43vyh	2010-07	102	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh
geoId/27163	Washington County	geoId/27	Minnesota	dc/p399z10w43vyh	2009-07	90	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh
geoId/27163	Washington County	geoId/27	Minnesota	dc/p399z10w43vyh	2013-12	138	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh
geoId/27163	Washington County	geoId/27	Minnesota	dc/p399z10w43vyh	2006-12	116	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

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

Washington County

geoId/27

Minnesota

dc/4exp28eszf777

2012

USEconomicCensus

census.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/4exp28eszf777

geoId/27163

Washington County

geoId/27

Minnesota

dc/p399z10w43vyh

2002-02

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

geoId/27163

Washington County

geoId/27

Minnesota

dc/p399z10w43vyh

2009-12

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

geoId/27163

Washington County

geoId/27

Minnesota

dc/p399z10w43vyh

2015-05

149

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

geoId/27163

Washington County

geoId/27

Minnesota

dc/p399z10w43vyh

2008-01

107

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

geoId/27163

Washington County

geoId/27

Minnesota

dc/p399z10w43vyh

2009-06

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

geoId/27163

Washington County

geoId/27

Minnesota

dc/p399z10w43vyh

2010-07

102

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

geoId/27163

Washington County

geoId/27

Minnesota

dc/p399z10w43vyh

2009-07

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

geoId/27163

Washington County

geoId/27

Minnesota

dc/p399z10w43vyh

2013-12

138

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

geoId/27163

Washington County

geoId/27

Minnesota

dc/p399z10w43vyh

2006-12

116

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27163?statVar=dc/p399z10w43vyh

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

Counties

Table List

Washington County - Time Series For Statistical Variables

@datacommons.counties.washington_county_geoid_27163

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