States
State-Level Statistical Variables
@datacommons.states
Tennessee - Time Series For Statistical Variables
@datacommons.states.tennessee_geoid_47
This table contains time series data for 80372 statistical variables for location: Tennessee (Data Commons location id: geoId/47).
- 31.19 MB
- 4701479 rows
- 12 columns
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/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2016 | 1255.92 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | |
| geoId/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2014 | 1000.192 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | |
| geoId/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2012 | 352.44 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | |
| geoId/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2011 | 465.728 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | |
| geoId/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2015 | 1211.212 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | |
| geoId/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2010 | 276.1 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | |
| geoId/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2018 | 1454.2 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | |
| geoId/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2013 | 732.5 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | |
| geoId/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2019 | 1184.16 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | |
| geoId/47 | Tennessee | country/USA | United States | Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino | 2017 | 1536.078 | CensusACS5yrSurveySubjectTable | CensusACS5YearSurvey_SubjectTables_S0506 | census.gov | https://datacommons.org/browser/geoId/47?statVar=Count_Person_ForeignBorn_PlaceOfBirthCentralAmericaExceptMexico_WhiteAloneNotHispanicOrLatino |
CREATE TABLE tennessee_geoid_47 (
"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
);