Baselight
Sign In

Counties

County-Level Data for Regional Insights

@datacommons.counties

Sumter County - Time Series For Statistical Variables
@datacommons.counties.sumter_county_geoid_45085

This table contains time series data for 44041 statistical variables for location: Sumter County (Data Commons location id: geoId/45085).

  • 39.52 MB
  • 4345354 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/45085Sumter CountygeoId/45South Carolinadc/7vx4y1td2er0720020.0046681184P6YOpportunityInsightsOutcomesopportunityinsights.orghttps://datacommons.org/browser/geoId/45085?statVar=dc/7vx4y1td2er07
geoId/45085Sumter CountygeoId/45South CarolinaMedian_Earnings_Person_EducationalAttainmentLessThanHighSchoolGraduate_Female201112246CensusACS5yrSurveySubjectTableCensusACS5YearSurvey_SubjectTables_S2001census.govhttps://datacommons.org/browser/geoId/45085?statVar=Median_Earnings_Person_EducationalAttainmentLessThanHighSchoolGraduate_Female
geoId/45085Sumter CountygeoId/45South CarolinaMedian_Earnings_Person_EducationalAttainmentLessThanHighSchoolGraduate_Female201010228CensusACS5yrSurveySubjectTableCensusACS5YearSurvey_SubjectTables_S2001census.govhttps://datacommons.org/browser/geoId/45085?statVar=Median_Earnings_Person_EducationalAttainmentLessThanHighSchoolGraduate_Female
geoId/45085Sumter CountygeoId/45South CarolinaMedian_Earnings_Person_EducationalAttainmentLessThanHighSchoolGraduate_Female201213413CensusACS5yrSurveySubjectTableCensusACS5YearSurvey_SubjectTables_S2001census.govhttps://datacommons.org/browser/geoId/45085?statVar=Median_Earnings_Person_EducationalAttainmentLessThanHighSchoolGraduate_Female
geoId/45085Sumter CountygeoId/45South CarolinaCount_Person_18OrMoreYears_Civilian_NonInstitutionalized201677297CensusACS5yrSurveySubjectTableCensusACS5YearSurvey_SubjectTables_S2701census.govhttps://datacommons.org/browser/geoId/45085?statVar=Count_Person_18OrMoreYears_Civilian_NonInstitutionalized
geoId/45085Sumter CountygeoId/45South CarolinaCount_Person_18OrMoreYears_Civilian_NonInstitutionalized201476944CensusACS5yrSurveySubjectTableCensusACS5YearSurvey_SubjectTables_S2701census.govhttps://datacommons.org/browser/geoId/45085?statVar=Count_Person_18OrMoreYears_Civilian_NonInstitutionalized
geoId/45085Sumter CountygeoId/45South CarolinaCount_Person_18OrMoreYears_Civilian_NonInstitutionalized201376531CensusACS5yrSurveySubjectTableCensusACS5YearSurvey_SubjectTables_S2701census.govhttps://datacommons.org/browser/geoId/45085?statVar=Count_Person_18OrMoreYears_Civilian_NonInstitutionalized
geoId/45085Sumter CountygeoId/45South CarolinaCount_Person_18OrMoreYears_Civilian_NonInstitutionalized201577286CensusACS5yrSurveySubjectTableCensusACS5YearSurvey_SubjectTables_S2701census.govhttps://datacommons.org/browser/geoId/45085?statVar=Count_Person_18OrMoreYears_Civilian_NonInstitutionalized
geoId/45085Sumter CountygeoId/45South CarolinaCount_Person_18OrMoreYears_Civilian_NonInstitutionalized201275701CensusACS5yrSurveySubjectTableCensusACS5YearSurvey_SubjectTables_S2701census.govhttps://datacommons.org/browser/geoId/45085?statVar=Count_Person_18OrMoreYears_Civilian_NonInstitutionalized
geoId/45085Sumter CountygeoId/45South Carolinadc/k75yehj9s97k6202232CensusACS5yrSurveyCensusACS5YearSurveycensus.govhttps://datacommons.org/browser/geoId/45085?statVar=dc/k75yehj9s97k6

CREATE TABLE sumter_county_geoid_45085 (
  "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.