ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 107 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
690716 | 690716 | 2020-11-02 | Putnam | Illinois | 17155 | 107 | 0 |
687471 | 687471 | 2020-11-01 | Putnam | Illinois | 17155 | 107 | 0 |
671263 | 671263 | 2020-10-27 | Scott | Illinois | 17171 | 107 | 0 |
667965 | 667965 | 2020-10-26 | Gallatin | Illinois | 17059 | 107 | 2 |
668020 | 668020 | 2020-10-26 | Scott | Illinois | 17171 | 107 | 0 |
664696 | 664696 | 2020-10-25 | Brown | Illinois | 17009 | 107 | 0 |
664721 | 664721 | 2020-10-25 | Gallatin | Illinois | 17059 | 107 | 2 |
661451 | 661451 | 2020-10-24 | Brown | Illinois | 17009 | 107 | 0 |
661470 | 661470 | 2020-10-24 | Edwards | Illinois | 17047 | 107 | 0 |
641978 | 641978 | 2020-10-18 | Alexander | Illinois | 17003 | 107 | 1 |
580393 | 580393 | 2020-09-29 | Ford | Illinois | 17053 | 107 | 5 |
567459 | 567459 | 2020-09-25 | Massac | Illinois | 17127 | 107 | 2 |
538321 | 538321 | 2020-09-16 | Menard | Illinois | 17129 | 107 | 0 |
525372 | 525372 | 2020-09-12 | Mason | Illinois | 17125 | 107 | 1 |
518868 | 518868 | 2020-09-10 | Fulton | Illinois | 17057 | 107 | 0 |
473614 | 473614 | 2020-08-27 | Johnson | Illinois | 17087 | 107 | 0 |
467186 | 467186 | 2020-08-25 | Pulaski | Illinois | 17153 | 107 | 1 |
463883 | 463883 | 2020-08-24 | Bond | Illinois | 17005 | 107 | 3 |
460669 | 460669 | 2020-08-23 | Cumberland | Illinois | 17035 | 107 | 3 |
380127 | 380127 | 2020-07-29 | Franklin | Illinois | 17055 | 107 | 0 |
360889 | 360889 | 2020-07-23 | Marion | Illinois | 17121 | 107 | 0 |
354492 | 354492 | 2020-07-21 | Montgomery | Illinois | 17135 | 107 | 1 |
328901 | 328901 | 2020-07-13 | Lee | Illinois | 17103 | 107 | 2 |
328911 | 328911 | 2020-07-13 | McDonough | Illinois | 17109 | 107 | 15 |
325715 | 325715 | 2020-07-12 | Lee | Illinois | 17103 | 107 | 2 |
309827 | 309827 | 2020-07-07 | Jefferson | Illinois | 17081 | 107 | 17 |
306659 | 306659 | 2020-07-06 | Jefferson | Illinois | 17081 | 107 | 17 |
303494 | 303494 | 2020-07-05 | Jefferson | Illinois | 17081 | 107 | 17 |
294011 | 294011 | 2020-07-02 | Jefferson | Illinois | 17081 | 107 | 17 |
290857 | 290857 | 2020-07-01 | Jefferson | Illinois | 17081 | 107 | 17 |
287707 | 287707 | 2020-06-30 | Jefferson | Illinois | 17081 | 107 | 17 |
284558 | 284558 | 2020-06-29 | Jefferson | Illinois | 17081 | 107 | 17 |
268838 | 268838 | 2020-06-24 | Jefferson | Illinois | 17081 | 107 | 17 |
228339 | 228339 | 2020-06-11 | Knox | Illinois | 17095 | 107 | 0 |
206687 | 206687 | 2020-06-04 | Grundy | Illinois | 17063 | 107 | 2 |
142813 | 142813 | 2020-05-14 | Iroquois | Illinois | 17075 | 107 | 3 |
113109 | 113109 | 2020-05-04 | Peoria | Illinois | 17143 | 107 | 3 |
101610 | 101610 | 2020-04-30 | Jackson | Illinois | 17077 | 107 | 7 |
93056 | 93056 | 2020-04-27 | Champaign | Illinois | 17019 | 107 | 6 |
3361 | 3361 | 2020-03-17 | Cook | Illinois | 17031 | 107 | 1 |
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);