Baselight
Sign In

States

State-Level Statistical Variables

@datacommons.states

West Virginia - Time Series For Statistical Variables
@datacommons.states.west_virginia_geoid_54

This table contains time series data for 70895 statistical variables for location: West Virginia (Data Commons location id: geoId/54).

  • 22.55 MB
  • 3446569 rows
  • 12 columns
place_id

Place Id

place_name

Place Name

parent_place_id

Parent Place Id

parent_place_name

Parent Place Name

variable

Variable

date

Date

value

Value

measurement_method

Measurement Method

observation_period

Observation Period

import_name

Import Name

provenance_domain

Provenance Domain

datacommons_url

Datacommons Url

geoId/54West Virginiacountry/USAUnited StatesPercent_Student_Male_SchoolGrade12_Reading201349.49005942NCES_NationalAssessmentOfEducationalProgressNCES_NationsReportCarded.govhttps://datacommons.org/browser/geoId/54?statVar=Percent_Student_Male_SchoolGrade12_Reading
geoId/54West Virginiacountry/USAUnited Statesdc/5ds5sr3f2yxdf200290USEconomicCensuscensus.govhttps://datacommons.org/browser/geoId/54?statVar=dc/5ds5sr3f2yxdf
geoId/54West Virginiacountry/USAUnited Statesdc/5ds5sr3f2yxdf201287USEconomicCensuscensus.govhttps://datacommons.org/browser/geoId/54?statVar=dc/5ds5sr3f2yxdf
geoId/54West Virginiacountry/USAUnited Statesdc/5ds5sr3f2yxdf200794USEconomicCensuscensus.govhttps://datacommons.org/browser/geoId/54?statVar=dc/5ds5sr3f2yxdf
geoId/54West Virginiacountry/USAUnited StatesCount_CriminalIncidents_BiasMotivationReligion_IsHateCrime_Buddhism_VictimTypePerson20181P1YFBIHateCrimefbi.govhttps://datacommons.org/browser/geoId/54?statVar=Count_CriminalIncidents_BiasMotivationReligion_IsHateCrime_Buddhism_VictimTypePerson
geoId/54West Virginiacountry/USAUnited Statesdc/ckg1p35fzmmz7201599CensusACS5yrSurveyCensusACS5YearSurveycensus.govhttps://datacommons.org/browser/geoId/54?statVar=dc/ckg1p35fzmmz7
geoId/54West Virginiacountry/USAUnited Statesdc/ckg1p35fzmmz7201293CensusACS5yrSurveyCensusACS5YearSurveycensus.govhttps://datacommons.org/browser/geoId/54?statVar=dc/ckg1p35fzmmz7
geoId/54West Virginiacountry/USAUnited Statesdc/ckg1p35fzmmz7201489CensusACS5yrSurveyCensusACS5YearSurveycensus.govhttps://datacommons.org/browser/geoId/54?statVar=dc/ckg1p35fzmmz7
geoId/54West Virginiacountry/USAUnited Statesdc/ckg1p35fzmmz7201396CensusACS5yrSurveyCensusACS5YearSurveycensus.govhttps://datacommons.org/browser/geoId/54?statVar=dc/ckg1p35fzmmz7
geoId/54West Virginiacountry/USAUnited Statesdc/ckg1p35fzmmz7201162CensusACS5yrSurveyCensusACS5YearSurveycensus.govhttps://datacommons.org/browser/geoId/54?statVar=dc/ckg1p35fzmmz7

CREATE TABLE west_virginia_geoid_54 (
  "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
);

Share link

Anyone who has the link will be able to view this.