States
State-Level Statistical Variables
@datacommons.states
State-Level Statistical Variables
@datacommons.states
This table contains time series data for 91386 statistical variables for location: California (Data Commons location id: geoId/06).
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/06 | California | country/USA | United States | dc/1c86jw51twj79 | 2012 | 3261 | USEconomicCensus | census.gov | https://datacommons.org/browser/geoId/06?statVar=dc/1c86jw51twj79 | ||
geoId/06 | California | country/USA | United States | dc/1c86jw51twj79 | 2002 | 3985 | USEconomicCensus | census.gov | https://datacommons.org/browser/geoId/06?statVar=dc/1c86jw51twj79 | ||
geoId/06 | California | country/USA | United States | dc/1c86jw51twj79 | 2017 | 3359 | USEconomicCensus | census.gov | https://datacommons.org/browser/geoId/06?statVar=dc/1c86jw51twj79 | ||
geoId/06 | California | country/USA | United States | dc/1c86jw51twj79 | 2007 | 3793 | USEconomicCensus | census.gov | https://datacommons.org/browser/geoId/06?statVar=dc/1c86jw51twj79 | ||
geoId/06 | California | country/USA | United States | Percent_Student_SchoolGrade4_PublicSchool_Science_PhysicalScienceScale | 2015 | 100 | NCES_NationalAssessmentOfEducationalProgress | NCES_NationsReportCard | ed.gov | https://datacommons.org/browser/geoId/06?statVar=Percent_Student_SchoolGrade4_PublicSchool_Science_PhysicalScienceScale | |
geoId/06 | California | country/USA | United States | Count_Person_15OrMoreYears_Civilian_InternetUsageAtCafeteria_IsInternetUser | 2015-07 | 5953881 | Commerce_NTIA | commerce.gov | https://datacommons.org/browser/geoId/06?statVar=Count_Person_15OrMoreYears_Civilian_InternetUsageAtCafeteria_IsInternetUser | ||
geoId/06 | California | country/USA | United States | Count_Person_15OrMoreYears_Civilian_InternetUsageAtCafeteria_IsInternetUser | 2017-11 | 6065959 | Commerce_NTIA | commerce.gov | https://datacommons.org/browser/geoId/06?statVar=Count_Person_15OrMoreYears_Civilian_InternetUsageAtCafeteria_IsInternetUser | ||
geoId/06 | California | country/USA | United States | Count_Person_15OrMoreYears_Civilian_InternetUsageAtCafeteria_IsInternetUser | 2019-11 | 6326966 | Commerce_NTIA | commerce.gov | https://datacommons.org/browser/geoId/06?statVar=Count_Person_15OrMoreYears_Civilian_InternetUsageAtCafeteria_IsInternetUser | ||
geoId/06 | California | country/USA | United States | Count_Person_15OrMoreYears_Civilian_InternetUsageAtCafeteria_IsInternetUser | 2021-11 | 4172034 | Commerce_NTIA | commerce.gov | https://datacommons.org/browser/geoId/06?statVar=Count_Person_15OrMoreYears_Civilian_InternetUsageAtCafeteria_IsInternetUser | ||
geoId/06 | California | country/USA | United States | dc/n2jvhzrwj6k9h | 2012 | 1139 | USEconomicCensus | census.gov | https://datacommons.org/browser/geoId/06?statVar=dc/n2jvhzrwj6k9h |
CREATE TABLE california_geoid_06 (
"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.