States
State-Level Statistical Variables
@datacommons.states
Connecticut - Time Series For Statistical Variables
@datacommons.states.connecticut_geoid_09
This table contains time series data for 75904 statistical variables for location: Connecticut (Data Commons location id: geoId/09).
- 27.26 MB
- 4174752 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/09 | Connecticut | country/USA | United States | Median_AssessmentScore_Student_SchoolGrade8_Suburb_Reading_LiteraryExperienceScale | 2019 | 274.2289993 | NCES_NationalAssessmentOfEducationalProgress | NCES_NationsReportCard | ed.gov | https://datacommons.org/browser/geoId/09?statVar=Median_AssessmentScore_Student_SchoolGrade8_Suburb_Reading_LiteraryExperienceScale | |
| geoId/09 | Connecticut | country/USA | United States | Median_AssessmentScore_Student_SchoolGrade8_Suburb_Reading_LiteraryExperienceScale | 2022 | 269.4390015 | NCES_NationalAssessmentOfEducationalProgress | NCES_NationsReportCard | ed.gov | https://datacommons.org/browser/geoId/09?statVar=Median_AssessmentScore_Student_SchoolGrade8_Suburb_Reading_LiteraryExperienceScale | |
| geoId/09 | Connecticut | country/USA | United States | Median_AssessmentScore_Student_SchoolGrade8_Suburb_Reading_LiteraryExperienceScale | 2017 | 278.8595001 | NCES_NationalAssessmentOfEducationalProgress | NCES_NationsReportCard | ed.gov | https://datacommons.org/browser/geoId/09?statVar=Median_AssessmentScore_Student_SchoolGrade8_Suburb_Reading_LiteraryExperienceScale | |
| geoId/09 | Connecticut | country/USA | United States | Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | 2016 | 42 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/09?statVar=Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | |
| geoId/09 | Connecticut | country/USA | United States | Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | 2012 | 14 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/09?statVar=Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | |
| geoId/09 | Connecticut | country/USA | United States | Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | 2019 | 40 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/09?statVar=Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | |
| geoId/09 | Connecticut | country/USA | United States | Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | 2018 | 48 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/09?statVar=Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | |
| geoId/09 | Connecticut | country/USA | United States | Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | 2020 | 30 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/09?statVar=Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | |
| geoId/09 | Connecticut | country/USA | United States | Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | 2022 | 24 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/09?statVar=Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | |
| geoId/09 | Connecticut | country/USA | United States | Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar | 2015 | 32 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/09?statVar=Count_Household_HouseholderRaceNativeHawaiianOrOtherPacificIslanderAlone_IncomeOf20000To24999USDollar |
CREATE TABLE connecticut_geoid_09 (
"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
);