ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where cases = 45 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
687469 | 687469 | 2020-11-01 | Pope | Illinois | 17151 | 45 | 1 |
564163 | 564163 | 2020-09-24 | Brown | Illinois | 17009 | 45 | 0 |
557766 | 557766 | 2020-09-22 | Schuyler | Illinois | 17169 | 45 | 0 |
528636 | 528636 | 2020-09-13 | Stark | Illinois | 17175 | 45 | 1 |
505930 | 505930 | 2020-09-06 | Edwards | Illinois | 17047 | 45 | 0 |
502696 | 502696 | 2020-09-05 | Edwards | Illinois | 17047 | 45 | 0 |
499462 | 499462 | 2020-09-04 | Edwards | Illinois | 17047 | 45 | 0 |
496207 | 496207 | 2020-09-03 | Alexander | Illinois | 17003 | 45 | 1 |
496238 | 496238 | 2020-09-03 | Hamilton | Illinois | 17065 | 45 | 0 |
496241 | 496241 | 2020-09-03 | Henderson | Illinois | 17071 | 45 | 0 |
492973 | 492973 | 2020-09-02 | Alexander | Illinois | 17003 | 45 | 0 |
493004 | 493004 | 2020-09-02 | Hamilton | Illinois | 17065 | 45 | 0 |
493007 | 493007 | 2020-09-02 | Henderson | Illinois | 17071 | 45 | 0 |
489771 | 489771 | 2020-09-01 | Hamilton | Illinois | 17065 | 45 | 0 |
489774 | 489774 | 2020-09-01 | Henderson | Illinois | 17071 | 45 | 0 |
486538 | 486538 | 2020-08-31 | Hamilton | Illinois | 17065 | 45 | 0 |
486541 | 486541 | 2020-08-31 | Henderson | Illinois | 17071 | 45 | 0 |
483303 | 483303 | 2020-08-30 | Hamilton | Illinois | 17065 | 45 | 0 |
483355 | 483355 | 2020-08-30 | Scott | Illinois | 17171 | 45 | 0 |
480069 | 480069 | 2020-08-29 | Hamilton | Illinois | 17065 | 45 | 0 |
480121 | 480121 | 2020-08-29 | Scott | Illinois | 17171 | 45 | 0 |
476888 | 476888 | 2020-08-28 | Scott | Illinois | 17171 | 45 | 0 |
444574 | 444574 | 2020-08-18 | Massac | Illinois | 17127 | 45 | 0 |
441348 | 441348 | 2020-08-17 | Massac | Illinois | 17127 | 45 | 0 |
438090 | 438090 | 2020-08-16 | Fulton | Illinois | 17057 | 45 | 0 |
409105 | 409105 | 2020-08-07 | Lawrence | Illinois | 17101 | 45 | 0 |
409114 | 409114 | 2020-08-07 | Mason | Illinois | 17125 | 45 | 0 |
405894 | 405894 | 2020-08-06 | Mason | Illinois | 17125 | 45 | 0 |
402643 | 402643 | 2020-08-05 | Ford | Illinois | 17053 | 45 | 1 |
402646 | 402646 | 2020-08-05 | Gallatin | Illinois | 17059 | 45 | 1 |
399430 | 399430 | 2020-08-04 | Gallatin | Illinois | 17059 | 45 | 0 |
396214 | 396214 | 2020-08-03 | Gallatin | Illinois | 17059 | 45 | 0 |
392976 | 392976 | 2020-08-02 | Carroll | Illinois | 17015 | 45 | 3 |
392998 | 392998 | 2020-08-02 | Gallatin | Illinois | 17059 | 45 | 0 |
389816 | 389816 | 2020-08-01 | Menard | Illinois | 17129 | 45 | 0 |
383319 | 383319 | 2020-07-30 | Bond | Illinois | 17005 | 45 | 2 |
348104 | 348104 | 2020-07-19 | Saline | Illinois | 17165 | 45 | 0 |
338437 | 338437 | 2020-07-16 | Clark | Illinois | 17023 | 45 | 0 |
335241 | 335241 | 2020-07-15 | Clark | Illinois | 17023 | 45 | 0 |
332078 | 332078 | 2020-07-14 | Jersey | Illinois | 17083 | 45 | 1 |
322510 | 322510 | 2020-07-11 | Franklin | Illinois | 17055 | 45 | 0 |
303464 | 303464 | 2020-07-05 | Christian | Illinois | 17021 | 45 | 5 |
300300 | 300300 | 2020-07-04 | Christian | Illinois | 17021 | 45 | 5 |
300332 | 300332 | 2020-07-04 | Jo Daviess | Illinois | 17085 | 45 | 1 |
297138 | 297138 | 2020-07-03 | Christian | Illinois | 17021 | 45 | 5 |
293981 | 293981 | 2020-07-02 | Christian | Illinois | 17021 | 45 | 5 |
294013 | 294013 | 2020-07-02 | Jo Daviess | Illinois | 17085 | 45 | 1 |
294038 | 294038 | 2020-07-02 | Montgomery | Illinois | 17135 | 45 | 0 |
290869 | 290869 | 2020-07-01 | Livingston | Illinois | 17105 | 45 | 2 |
275097 | 275097 | 2020-06-26 | Douglas | Illinois | 17041 | 45 | 0 |
271955 | 271955 | 2020-06-25 | Douglas | Illinois | 17041 | 45 | 0 |
246940 | 246940 | 2020-06-17 | Adams | Illinois | 17001 | 45 | 1 |
246995 | 246995 | 2020-06-17 | Macoupin | Illinois | 17117 | 45 | 3 |
243827 | 243827 | 2020-06-16 | Adams | Illinois | 17001 | 45 | 1 |
243882 | 243882 | 2020-06-16 | Macoupin | Illinois | 17117 | 45 | 2 |
240771 | 240771 | 2020-06-15 | Macoupin | Illinois | 17117 | 45 | 2 |
237608 | 237608 | 2020-06-14 | Adams | Illinois | 17001 | 45 | 1 |
237663 | 237663 | 2020-06-14 | Macoupin | Illinois | 17117 | 45 | 2 |
234501 | 234501 | 2020-06-13 | Adams | Illinois | 17001 | 45 | 1 |
231395 | 231395 | 2020-06-12 | Adams | Illinois | 17001 | 45 | 1 |
228292 | 228292 | 2020-06-11 | Adams | Illinois | 17001 | 45 | 1 |
225190 | 225190 | 2020-06-10 | Adams | Illinois | 17001 | 45 | 1 |
222095 | 222095 | 2020-06-09 | Adams | Illinois | 17001 | 45 | 1 |
219000 | 219000 | 2020-06-08 | Adams | Illinois | 17001 | 45 | 1 |
197466 | 197466 | 2020-06-01 | Jasper | Illinois | 17079 | 45 | 7 |
197482 | 197482 | 2020-06-01 | Macoupin | Illinois | 17117 | 45 | 2 |
194396 | 194396 | 2020-05-31 | Jasper | Illinois | 17079 | 45 | 7 |
194412 | 194412 | 2020-05-31 | Macoupin | Illinois | 17117 | 45 | 2 |
191329 | 191329 | 2020-05-30 | Jasper | Illinois | 17079 | 45 | 7 |
191345 | 191345 | 2020-05-30 | Macoupin | Illinois | 17117 | 45 | 2 |
188264 | 188264 | 2020-05-29 | Jasper | Illinois | 17079 | 45 | 7 |
188280 | 188280 | 2020-05-29 | Macoupin | Illinois | 17117 | 45 | 2 |
185206 | 185206 | 2020-05-28 | Jasper | Illinois | 17079 | 45 | 7 |
182152 | 182152 | 2020-05-27 | Jasper | Illinois | 17079 | 45 | 7 |
179108 | 179108 | 2020-05-26 | Jasper | Illinois | 17079 | 45 | 7 |
176064 | 176064 | 2020-05-25 | Jasper | Illinois | 17079 | 45 | 7 |
173020 | 173020 | 2020-05-24 | Jasper | Illinois | 17079 | 45 | 7 |
169979 | 169979 | 2020-05-23 | Jasper | Illinois | 17079 | 45 | 7 |
166942 | 166942 | 2020-05-22 | Jasper | Illinois | 17079 | 45 | 7 |
163871 | 163871 | 2020-05-21 | Adams | Illinois | 17001 | 45 | 1 |
163909 | 163909 | 2020-05-21 | Jasper | Illinois | 17079 | 45 | 7 |
160881 | 160881 | 2020-05-20 | Jasper | Illinois | 17079 | 45 | 7 |
157855 | 157855 | 2020-05-19 | Jasper | Illinois | 17079 | 45 | 7 |
154839 | 154839 | 2020-05-18 | Jasper | Illinois | 17079 | 45 | 7 |
151827 | 151827 | 2020-05-17 | Jasper | Illinois | 17079 | 45 | 7 |
145815 | 145815 | 2020-05-15 | Jasper | Illinois | 17079 | 45 | 7 |
142815 | 142815 | 2020-05-14 | Jasper | Illinois | 17079 | 45 | 7 |
139819 | 139819 | 2020-05-13 | Jasper | Illinois | 17079 | 45 | 7 |
113124 | 113124 | 2020-05-04 | Tazewell | Illinois | 17179 | 45 | 3 |
110202 | 110202 | 2020-05-03 | Jasper | Illinois | 17079 | 45 | 5 |
107332 | 107332 | 2020-05-02 | Jasper | Illinois | 17079 | 45 | 5 |
104513 | 104513 | 2020-05-01 | Stephenson | Illinois | 17177 | 45 | 0 |
101608 | 101608 | 2020-04-30 | Henry | Illinois | 17073 | 45 | 0 |
101658 | 101658 | 2020-04-30 | Tazewell | Illinois | 17179 | 45 | 3 |
79102 | 79102 | 2020-04-22 | Whiteside | Illinois | 17195 | 45 | 3 |
73462 | 73462 | 2020-04-20 | Clinton | Illinois | 17027 | 45 | 0 |
70692 | 70692 | 2020-04-19 | Clinton | Illinois | 17027 | 45 | 0 |
57058 | 57058 | 2020-04-14 | Macon | Illinois | 17115 | 45 | 3 |
14447 | 14447 | 2020-03-27 | McHenry | Illinois | 17111 | 45 | 1 |
3926 | 3926 | 2020-03-18 | DuPage | Illinois | 17043 | 45 | 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);