Counties
County-Level Data for Regional Insights
@datacommons.counties
County-Level Data for Regional Insights
@datacommons.counties
This table contains time series data for 33248 statistical variables for location: Pike County (Data Commons location id: geoId/01109).
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/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 2015 | 52609 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | |
geoId/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 1990 | 21999 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | |
geoId/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 2019 | 59824 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | |
geoId/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 2013 | 46405 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | |
geoId/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 1997 | 29658 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | |
geoId/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 2020 | 63080 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | |
geoId/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 2011 | 42340 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | |
geoId/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 2004 | 36535 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | |
geoId/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 1991 | 22395 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | |
geoId/01109 | Pike County | geoId/01 | Alabama | WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance | 1995 | 24586 | P1Y | BLS_QCEW | bls.gov | https://datacommons.org/browser/geoId/01109?statVar=WagesAnnual_Worker_PrivatelyOwnedEstablishment_NAICSFinanceInsurance |
CREATE TABLE pike_county_geoid_01109 (
"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.