Counties
County-Level Data for Regional Insights
@datacommons.counties
County-Level Data for Regional Insights
@datacommons.counties
This table contains time series data for 29959 statistical variables for location: Spencer County (Data Commons location id: geoId/18147).
place_idPlace Id | place_namePlace Name | parent_place_idParent Place Id | parent_place_nameParent Place Name | variableVariable | dateDate | valueValue | measurement_methodMeasurement Method | observation_periodObservation Period | import_nameImport Name | provenance_domainProvenance Domain | datacommons_urlDatacommons Url |
---|---|---|---|---|---|---|---|---|---|---|---|
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2023-09 | 20038 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 | |
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2021-03 | 19198 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 | |
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2024-03 | 21657 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 | |
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2018-12 | 36487 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 | |
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2001-09 | 38126 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 | |
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2001-12 | 41666 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 | |
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2022-12 | 26522 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 | |
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2015-06 | 52859 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 | |
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2018-06 | 33123 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 | |
geoId/18147 | Spencer County | geoId/18 | Indiana | dc/sry7tlmfvcbs7 | 2019-09 | 31535 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/18147?statVar=dc/sry7tlmfvcbs7 |
CREATE TABLE spencer_county_geoid_18147 (
"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
);
Anyone who has the link will be able to view this.