States
State-Level Statistical Variables
@datacommons.states
State-Level Statistical Variables
@datacommons.states
This table contains time series data for 76113 statistical variables for location: Oklahoma (Data Commons location id: geoId/40).
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/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2019 | 397 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 | |
geoId/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2017 | 357 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 | |
geoId/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2015 | 371 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 | |
geoId/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2023 | 338 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 | |
geoId/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2022 | 295 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 | |
geoId/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2020 | 328 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 | |
geoId/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2013 | 449 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 | |
geoId/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2012 | 412 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 | |
geoId/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2021 | 343 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 | |
geoId/40 | Oklahoma | country/USA | United States | dc/23wdn5l22n3f7 | 2018 | 437 | CensusACS5yrSurvey | CensusACS5YearSurvey | census.gov | https://datacommons.org/browser/geoId/40?statVar=dc/23wdn5l22n3f7 |
CREATE TABLE oklahoma_geoid_40 (
"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.