Counties
County-Level Data for Regional Insights
@datacommons.counties
County-Level Data for Regional Insights
@datacommons.counties
This table contains time series data for 32715 statistical variables for location: Franklin County (Data Commons location id: geoId/17055).
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/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2001-04 | 22 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c | |
geoId/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2002-09 | 20 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c | |
geoId/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2007-02 | 17 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c | |
geoId/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2006-07 | 17 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c | |
geoId/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2004-12 | 16 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c | |
geoId/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2006-02 | 18 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c | |
geoId/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2003-01 | 19 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c | |
geoId/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2007-08 | 19 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c | |
geoId/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2006-06 | 17 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c | |
geoId/17055 | Franklin County | geoId/17 | Illinois | dc/f72vswe7vrp5c | 2003-07 | 19 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/17055?statVar=dc/f72vswe7vrp5c |
CREATE TABLE franklin_county_geoid_17055 (
"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.