Dataset: Counties

This table contains time series data for 30088 statistical variables for location: Yellow Medicine County (Data Commons location id: geoId/27173).

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/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2019-12	18	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5
geoId/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2016-09	14	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5
geoId/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2005-09	15	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5
geoId/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2020-12	16	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5
geoId/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2017-05	15	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5
geoId/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2004-07	23	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5
geoId/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2001-07	21	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5
geoId/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2004-01	22	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5
geoId/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2021-10	12	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5
geoId/27173	Yellow Medicine County	geoId/27	Minnesota	dc/v7r13fknfsem5	2014-07	20	P1M	BLS_QCEW	bls.gov	https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

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

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2019-12

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

geoId/27173

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2016-09

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

geoId/27173

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2005-09

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

geoId/27173

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2020-12

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

geoId/27173

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2017-05

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

geoId/27173

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2004-07

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

geoId/27173

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2001-07

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

geoId/27173

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2004-01

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

geoId/27173

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2021-10

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

geoId/27173

Yellow Medicine County

geoId/27

Minnesota

dc/v7r13fknfsem5

2014-07

P1M

BLS_QCEW

bls.gov

https://datacommons.org/browser/geoId/27173?statVar=dc/v7r13fknfsem5

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

Yellow Medicine County - Time Series For Statistical Variables

@datacommons.counties.yellow_medicine_county_geoid_27173

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