Counties
County-Level Data for Regional Insights
@datacommons.counties
County-Level Data for Regional Insights
@datacommons.counties
This table contains time series data for 31442 statistical variables for location: Rockbridge County (Data Commons location id: geoId/51163).
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/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2006-09 | 203 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 | |
geoId/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2003-03 | 148 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 | |
geoId/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2022-05 | 72 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 | |
geoId/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2015-11 | 100 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 | |
geoId/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2001-01 | 142 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 | |
geoId/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2007-11 | 179 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 | |
geoId/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2012-06 | 214 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 | |
geoId/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2004-02 | 129 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 | |
geoId/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2018-01 | 48 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 | |
geoId/51163 | Rockbridge County | geoId/51 | Virginia | dc/el1p9rft1v8z6 | 2015-06 | 127 | P1M | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/51163?statVar=dc/el1p9rft1v8z6 |
CREATE TABLE rockbridge_county_geoid_51163 (
"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.