Counties
County-Level Data for Regional Insights
@datacommons.counties
County-Level Data for Regional Insights
@datacommons.counties
This table contains time series data for 26453 statistical variables for location: Ringgold County (Data Commons location id: geoId/19159).
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/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 1992-03 | 147675 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb | |
geoId/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 2017-06 | 403392 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb | |
geoId/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 2003-12 | 266420 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb | |
geoId/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 1992-06 | 183646 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb | |
geoId/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 2020-06 | 436293 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb | |
geoId/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 1993-03 | 159002 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb | |
geoId/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 2006-09 | 394662 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb | |
geoId/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 2010-09 | 525013 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb | |
geoId/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 2015-09 | 379461 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb | |
geoId/19159 | Ringgold County | geoId/19 | Iowa | dc/w24d8ztq8l9yb | 2008-03 | 350574 | P3M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/19159?statVar=dc/w24d8ztq8l9yb |
CREATE TABLE ringgold_county_geoid_19159 (
"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.