Counties

County-Level Data for Regional Insights

@datacommons.counties

Table List

3390 tables(117.53 GB)

results for

Mercer County - Time Series For Statistical Variables

@datacommons.counties.mercer_county_geoid_34021

This table contains time series data for 58230 statistical variables for location: Mercer County (Data Commons location id: geoId/34021).

45.8 MB
5306500 rows
12 columns

place_id Place Id	place_name Place Name	parent_place_id Parent Place Id	parent_place_name Parent Place Name	variable Variable	date Date	value Value	measurement_method Measurement Method	observation_period Observation Period	import_name Import Name	provenance_domain Provenance Domain	datacommons_url Datacommons Url
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2009	10443	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2013	10383	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2000	12354	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2001	11472	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2011	10329	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2007	10642	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2005	11061	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2015	10248	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2008	10591	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino
geoId/34021	Mercer County	geoId/34	New Jersey	Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino	2003	11321	CensusPEPSurvey_PartialAggregate_Race2000Onwards	P1Y	USCensusPEP_AgeSexRaceHispanicOrigin	census.gov	https://datacommons.org/browser/geoId/34021?statVar=Count_Person_25To29Years_WhiteAloneNotHispanicOrLatino


CREATE TABLE mercer_county_geoid_34021 (
  "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
);