ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where date = "2020-03-27" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
fips >30
county >30
- Adams 1
- Bureau 1
- Champaign 1
- Christian 1
- Clinton 1
- Cook 1
- Cumberland 1
- DeKalb 1
- Douglas 1
- DuPage 1
- Franklin 1
- Grundy 1
- Henry 1
- Iroquois 1
- Jackson 1
- Jo Daviess 1
- Kane 1
- Kankakee 1
- Kendall 1
- LaSalle 1
- Lake 1
- Livingston 1
- Madison 1
- Marshall 1
- McHenry 1
- McLean 1
- Monroe 1
- Morgan 1
- Peoria 1
- Rock Island 1
- …
state 1
- Illinois · 40 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14423 | 14423 | 2020-03-27 | Adams | Illinois | 17001 | 1 | 0 |
14424 | 14424 | 2020-03-27 | Bureau | Illinois | 17011 | 1 | 0 |
14425 | 14425 | 2020-03-27 | Champaign | Illinois | 17019 | 10 | 0 |
14426 | 14426 | 2020-03-27 | Christian | Illinois | 17021 | 1 | 0 |
14427 | 14427 | 2020-03-27 | Clinton | Illinois | 17027 | 5 | 0 |
14428 | 14428 | 2020-03-27 | Cook | Illinois | 17031 | 2239 | 20 |
14429 | 14429 | 2020-03-27 | Cumberland | Illinois | 17035 | 1 | 0 |
14430 | 14430 | 2020-03-27 | DeKalb | Illinois | 17037 | 4 | 0 |
14431 | 14431 | 2020-03-27 | Douglas | Illinois | 17041 | 1 | 0 |
14432 | 14432 | 2020-03-27 | DuPage | Illinois | 17043 | 199 | 6 |
14433 | 14433 | 2020-03-27 | Franklin | Illinois | 17055 | 1 | 0 |
14434 | 14434 | 2020-03-27 | Grundy | Illinois | 17063 | 2 | 0 |
14435 | 14435 | 2020-03-27 | Henry | Illinois | 17073 | 1 | 0 |
14436 | 14436 | 2020-03-27 | Iroquois | Illinois | 17075 | 1 | 0 |
14437 | 14437 | 2020-03-27 | Jackson | Illinois | 17077 | 1 | 0 |
14438 | 14438 | 2020-03-27 | Jo Daviess | Illinois | 17085 | 1 | 0 |
14439 | 14439 | 2020-03-27 | Kane | Illinois | 17089 | 77 | 2 |
14440 | 14440 | 2020-03-27 | Kankakee | Illinois | 17091 | 17 | 0 |
14441 | 14441 | 2020-03-27 | Kendall | Illinois | 17093 | 8 | 0 |
14442 | 14442 | 2020-03-27 | LaSalle | Illinois | 17099 | 3 | 0 |
14443 | 14443 | 2020-03-27 | Lake | Illinois | 17097 | 230 | 2 |
14444 | 14444 | 2020-03-27 | Livingston | Illinois | 17105 | 2 | 0 |
14445 | 14445 | 2020-03-27 | Madison | Illinois | 17119 | 8 | 0 |
14446 | 14446 | 2020-03-27 | Marshall | Illinois | 17123 | 1 | 0 |
14447 | 14447 | 2020-03-27 | McHenry | Illinois | 17111 | 45 | 1 |
14448 | 14448 | 2020-03-27 | McLean | Illinois | 17113 | 10 | 1 |
14449 | 14449 | 2020-03-27 | Monroe | Illinois | 17133 | 3 | 0 |
14450 | 14450 | 2020-03-27 | Morgan | Illinois | 17137 | 1 | 0 |
14451 | 14451 | 2020-03-27 | Peoria | Illinois | 17143 | 6 | 0 |
14452 | 14452 | 2020-03-27 | Rock Island | Illinois | 17161 | 4 | 0 |
14453 | 14453 | 2020-03-27 | Sangamon | Illinois | 17167 | 7 | 1 |
14454 | 14454 | 2020-03-27 | St. Clair | Illinois | 17163 | 15 | 1 |
14455 | 14455 | 2020-03-27 | Stephenson | Illinois | 17177 | 2 | 0 |
14456 | 14456 | 2020-03-27 | Tazewell | Illinois | 17179 | 2 | 0 |
14457 | 14457 | 2020-03-27 | Washington | Illinois | 17189 | 1 | 0 |
14458 | 14458 | 2020-03-27 | Whiteside | Illinois | 17195 | 2 | 0 |
14459 | 14459 | 2020-03-27 | Will | Illinois | 17197 | 104 | 3 |
14460 | 14460 | 2020-03-27 | Williamson | Illinois | 17199 | 1 | 0 |
14461 | 14461 | 2020-03-27 | Winnebago | Illinois | 17201 | 8 | 0 |
14462 | 14462 | 2020-03-27 | Woodford | Illinois | 17203 | 3 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);