Baselight

US Unemployment Rate By County, 1990-2016

Thanks to the US Department of Labor's Bureau of Labor Statistics

@kaggle.jayrav13_unemployment_by_county_us

Output
@kaggle.jayrav13_unemployment_by_county_us.output

  • 2.12 MB
  • 885548 rows
  • 5 columns
year

Year

month

Month

state

State

county

County

rate

Rate

2015FebruaryMississippiNewton County6.1
2015FebruaryMississippiPanola County9.4
2015FebruaryMississippiMonroe County7.9
2015FebruaryMississippiHinds County6.1
2015FebruaryMississippiKemper County10.6
2015FebruaryMississippiCalhoun County6.9
2015FebruaryMississippiClarke County7.9
2015FebruaryMississippiJefferson County14.3
2015FebruaryMississippiMadison County4.5
2015FebruaryMississippiSharkey County11.1

CREATE TABLE output (
  "year" BIGINT,
  "month" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "rate" DOUBLE
);

Share link

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