Counties
County-Level Data for Regional Insights
@datacommons.counties
County-Level Data for Regional Insights
@datacommons.counties
This table contains time series data for 56723 statistical variables for location: Hamilton County (Data Commons location id: geoId/47065).
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/47065 | Hamilton County | geoId/47 | Tennessee | dc/071sl2806vvd | 2011 | 88034000 | CensusCBPSurvey | CensusCountyBusinessPatterns | census.gov | https://datacommons.org/browser/geoId/47065?statVar=dc/071sl2806vvd | |
geoId/47065 | Hamilton County | geoId/47 | Tennessee | dc/071sl2806vvd | 2016 | 125370000 | CensusCBPSurvey | CensusCountyBusinessPatterns | census.gov | https://datacommons.org/browser/geoId/47065?statVar=dc/071sl2806vvd | |
geoId/47065 | Hamilton County | geoId/47 | Tennessee | dc/071sl2806vvd | 2014 | 162070000 | CensusCBPSurvey | CensusCountyBusinessPatterns | census.gov | https://datacommons.org/browser/geoId/47065?statVar=dc/071sl2806vvd | |
geoId/47065 | Hamilton County | geoId/47 | Tennessee | dc/071sl2806vvd | 2013 | 156771000 | CensusCBPSurvey | CensusCountyBusinessPatterns | census.gov | https://datacommons.org/browser/geoId/47065?statVar=dc/071sl2806vvd | |
geoId/47065 | Hamilton County | geoId/47 | Tennessee | dc/071sl2806vvd | 2015 | 123123000 | CensusCBPSurvey | CensusCountyBusinessPatterns | census.gov | https://datacommons.org/browser/geoId/47065?statVar=dc/071sl2806vvd | |
geoId/47065 | Hamilton County | geoId/47 | Tennessee | dc/071sl2806vvd | 2010 | 56549000 | CensusCBPSurvey | CensusCountyBusinessPatterns | census.gov | https://datacommons.org/browser/geoId/47065?statVar=dc/071sl2806vvd | |
geoId/47065 | Hamilton County | geoId/47 | Tennessee | dc/071sl2806vvd | 2012 | 139719000 | CensusCBPSurvey | CensusCountyBusinessPatterns | census.gov | https://datacommons.org/browser/geoId/47065?statVar=dc/071sl2806vvd | |
geoId/47065 | Hamilton County | geoId/47 | Tennessee | dc/071sl2806vvd | 2009 | 50902000 | CensusCBPSurvey | CensusCountyBusinessPatterns | census.gov | https://datacommons.org/browser/geoId/47065?statVar=dc/071sl2806vvd | |
geoId/47065 | Hamilton County | geoId/47 | Tennessee | Count_Person_Employed_NAICSInformation_ForeignBorn_PlaceOfBirthEurope | 2013 | 4.731 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0503 | census.gov | https://datacommons.org/browser/geoId/47065?statVar=Count_Person_Employed_NAICSInformation_ForeignBorn_PlaceOfBirthEurope | |
geoId/47065 | Hamilton County | geoId/47 | Tennessee | Count_Person_Employed_NAICSInformation_ForeignBorn_PlaceOfBirthEurope | 2018 | 13.497 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0503 | census.gov | https://datacommons.org/browser/geoId/47065?statVar=Count_Person_Employed_NAICSInformation_ForeignBorn_PlaceOfBirthEurope |
CREATE TABLE hamilton_county_geoid_47065 (
"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.