ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 87 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
632242 | 632242 | 2020-10-15 | Brown | Illinois | 17009 | 87 | 0 |
632261 | 632261 | 2020-10-15 | Edwards | Illinois | 17047 | 87 | 0 |
619297 | 619297 | 2020-10-11 | Hamilton | Illinois | 17065 | 87 | 2 |
616055 | 616055 | 2020-10-10 | Hamilton | Illinois | 17065 | 87 | 2 |
590088 | 590088 | 2020-10-02 | Alexander | Illinois | 17003 | 87 | 1 |
586847 | 586847 | 2020-10-01 | Alexander | Illinois | 17003 | 87 | 1 |
541520 | 541520 | 2020-09-17 | Ford | Illinois | 17053 | 87 | 4 |
541554 | 541554 | 2020-09-17 | Massac | Illinois | 17127 | 87 | 2 |
538275 | 538275 | 2020-09-16 | De Witt | Illinois | 17039 | 87 | 1 |
538317 | 538317 | 2020-09-16 | Massac | Illinois | 17127 | 87 | 2 |
489798 | 489798 | 2020-09-01 | Mason | Illinois | 17125 | 87 | 1 |
463931 | 463931 | 2020-08-24 | Lawrence | Illinois | 17101 | 87 | 0 |
457464 | 457464 | 2020-08-22 | Jasper | Illinois | 17079 | 87 | 7 |
457520 | 457520 | 2020-08-22 | Washington | Illinois | 17189 | 87 | 1 |
454240 | 454240 | 2020-08-21 | Johnson | Illinois | 17087 | 87 | 0 |
450999 | 450999 | 2020-08-20 | Greene | Illinois | 17061 | 87 | 0 |
451012 | 451012 | 2020-08-20 | Johnson | Illinois | 17087 | 87 | 0 |
447766 | 447766 | 2020-08-19 | Fayette | Illinois | 17051 | 87 | 3 |
441385 | 441385 | 2020-08-17 | White | Illinois | 17193 | 87 | 0 |
425170 | 425170 | 2020-08-12 | Clark | Illinois | 17023 | 87 | 2 |
421949 | 421949 | 2020-08-11 | Clark | Illinois | 17023 | 87 | 2 |
399454 | 399454 | 2020-08-04 | Logan | Illinois | 17107 | 87 | 0 |
367318 | 367318 | 2020-07-25 | Perry | Illinois | 17145 | 87 | 1 |
348099 | 348099 | 2020-07-19 | Pulaski | Illinois | 17153 | 87 | 0 |
341679 | 341679 | 2020-07-17 | Marion | Illinois | 17121 | 87 | 0 |
338502 | 338502 | 2020-07-16 | Pulaski | Illinois | 17153 | 87 | 0 |
287667 | 287667 | 2020-06-30 | Adams | Illinois | 17001 | 87 | 1 |
243926 | 243926 | 2020-06-16 | Williamson | Illinois | 17199 | 87 | 3 |
191351 | 191351 | 2020-05-30 | McDonough | Illinois | 17109 | 87 | 11 |
188286 | 188286 | 2020-05-29 | McDonough | Illinois | 17109 | 87 | 8 |
169971 | 169971 | 2020-05-23 | Grundy | Illinois | 17063 | 87 | 2 |
151835 | 151835 | 2020-05-17 | Knox | Illinois | 17095 | 87 | 0 |
151854 | 151854 | 2020-05-17 | Monroe | Illinois | 17133 | 87 | 11 |
113078 | 113078 | 2020-05-04 | Jefferson | Illinois | 17081 | 87 | 15 |
104523 | 104523 | 2020-05-01 | Whiteside | Illinois | 17195 | 87 | 6 |
90296 | 90296 | 2020-04-26 | Ogle | Illinois | 17141 | 87 | 1 |
84663 | 84663 | 2020-04-24 | McLean | Illinois | 17113 | 87 | 3 |
81863 | 81863 | 2020-04-23 | McLean | Illinois | 17113 | 87 | 3 |
54326 | 54326 | 2020-04-13 | Champaign | Illinois | 17019 | 87 | 2 |
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);