ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17119 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535077 | 535077 | 2020-09-15 | Madison | Illinois | 17119 | 5020 | 122 |
531842 | 531842 | 2020-09-14 | Madison | Illinois | 17119 | 4965 | 121 |
528605 | 528605 | 2020-09-13 | Madison | Illinois | 17119 | 4908 | 119 |
525369 | 525369 | 2020-09-12 | Madison | Illinois | 17119 | 4872 | 118 |
522133 | 522133 | 2020-09-11 | Madison | Illinois | 17119 | 4780 | 117 |
518896 | 518896 | 2020-09-10 | Madison | Illinois | 17119 | 4693 | 115 |
515661 | 515661 | 2020-09-09 | Madison | Illinois | 17119 | 4631 | 113 |
512428 | 512428 | 2020-09-08 | Madison | Illinois | 17119 | 4585 | 108 |
509195 | 509195 | 2020-09-07 | Madison | Illinois | 17119 | 4536 | 108 |
505963 | 505963 | 2020-09-06 | Madison | Illinois | 17119 | 4498 | 108 |
502729 | 502729 | 2020-09-05 | Madison | Illinois | 17119 | 4448 | 108 |
499495 | 499495 | 2020-09-04 | Madison | Illinois | 17119 | 4380 | 105 |
496262 | 496262 | 2020-09-03 | Madison | Illinois | 17119 | 4219 | 103 |
493028 | 493028 | 2020-09-02 | Madison | Illinois | 17119 | 4182 | 101 |
489795 | 489795 | 2020-09-01 | Madison | Illinois | 17119 | 4102 | 100 |
486562 | 486562 | 2020-08-31 | Madison | Illinois | 17119 | 4040 | 98 |
483327 | 483327 | 2020-08-30 | Madison | Illinois | 17119 | 3982 | 98 |
480093 | 480093 | 2020-08-29 | Madison | Illinois | 17119 | 3956 | 97 |
476860 | 476860 | 2020-08-28 | Madison | Illinois | 17119 | 3868 | 95 |
473627 | 473627 | 2020-08-27 | Madison | Illinois | 17119 | 3818 | 95 |
470395 | 470395 | 2020-08-26 | Madison | Illinois | 17119 | 3752 | 93 |
467166 | 467166 | 2020-08-25 | Madison | Illinois | 17119 | 3666 | 92 |
463937 | 463937 | 2020-08-24 | Madison | Illinois | 17119 | 3606 | 91 |
460708 | 460708 | 2020-08-23 | Madison | Illinois | 17119 | 3562 | 91 |
457481 | 457481 | 2020-08-22 | Madison | Illinois | 17119 | 3503 | 91 |
454253 | 454253 | 2020-08-21 | Madison | Illinois | 17119 | 3441 | 90 |
451025 | 451025 | 2020-08-20 | Madison | Illinois | 17119 | 3366 | 88 |
447797 | 447797 | 2020-08-19 | Madison | Illinois | 17119 | 3289 | 87 |
444570 | 444570 | 2020-08-18 | Madison | Illinois | 17119 | 3241 | 87 |
441344 | 441344 | 2020-08-17 | Madison | Illinois | 17119 | 3152 | 85 |
438118 | 438118 | 2020-08-16 | Madison | Illinois | 17119 | 3111 | 85 |
434892 | 434892 | 2020-08-15 | Madison | Illinois | 17119 | 3051 | 85 |
431667 | 431667 | 2020-08-14 | Madison | Illinois | 17119 | 2969 | 85 |
428439 | 428439 | 2020-08-13 | Madison | Illinois | 17119 | 2855 | 82 |
425215 | 425215 | 2020-08-12 | Madison | Illinois | 17119 | 2777 | 78 |
421994 | 421994 | 2020-08-11 | Madison | Illinois | 17119 | 2702 | 78 |
418771 | 418771 | 2020-08-10 | Madison | Illinois | 17119 | 2634 | 77 |
415550 | 415550 | 2020-08-09 | Madison | Illinois | 17119 | 2591 | 77 |
412330 | 412330 | 2020-08-08 | Madison | Illinois | 17119 | 2530 | 77 |
409111 | 409111 | 2020-08-07 | Madison | Illinois | 17119 | 2470 | 77 |
405891 | 405891 | 2020-08-06 | Madison | Illinois | 17119 | 2410 | 74 |
402673 | 402673 | 2020-08-05 | Madison | Illinois | 17119 | 2320 | 73 |
399457 | 399457 | 2020-08-04 | Madison | Illinois | 17119 | 2266 | 73 |
396241 | 396241 | 2020-08-03 | Madison | Illinois | 17119 | 2222 | 73 |
393025 | 393025 | 2020-08-02 | Madison | Illinois | 17119 | 2186 | 73 |
389808 | 389808 | 2020-08-01 | Madison | Illinois | 17119 | 2137 | 72 |
386591 | 386591 | 2020-07-31 | Madison | Illinois | 17119 | 2099 | 72 |
383373 | 383373 | 2020-07-30 | Madison | Illinois | 17119 | 2047 | 72 |
380156 | 380156 | 2020-07-29 | Madison | Illinois | 17119 | 1975 | 72 |
376939 | 376939 | 2020-07-28 | Madison | Illinois | 17119 | 1942 | 72 |
373724 | 373724 | 2020-07-27 | Madison | Illinois | 17119 | 1915 | 72 |
370512 | 370512 | 2020-07-26 | Madison | Illinois | 17119 | 1840 | 71 |
367302 | 367302 | 2020-07-25 | Madison | Illinois | 17119 | 1762 | 71 |
364095 | 364095 | 2020-07-24 | Madison | Illinois | 17119 | 1701 | 71 |
360888 | 360888 | 2020-07-23 | Madison | Illinois | 17119 | 1655 | 71 |
357683 | 357683 | 2020-07-22 | Madison | Illinois | 17119 | 1604 | 71 |
354481 | 354481 | 2020-07-21 | Madison | Illinois | 17119 | 1544 | 71 |
351279 | 351279 | 2020-07-20 | Madison | Illinois | 17119 | 1534 | 71 |
348079 | 348079 | 2020-07-19 | Madison | Illinois | 17119 | 1478 | 71 |
344878 | 344878 | 2020-07-18 | Madison | Illinois | 17119 | 1457 | 71 |
341678 | 341678 | 2020-07-17 | Madison | Illinois | 17119 | 1413 | 71 |
338482 | 338482 | 2020-07-16 | Madison | Illinois | 17119 | 1368 | 71 |
335286 | 335286 | 2020-07-15 | Madison | Illinois | 17119 | 1318 | 71 |
332093 | 332093 | 2020-07-14 | Madison | Illinois | 17119 | 1285 | 71 |
328906 | 328906 | 2020-07-13 | Madison | Illinois | 17119 | 1258 | 71 |
325720 | 325720 | 2020-07-12 | Madison | Illinois | 17119 | 1198 | 70 |
322539 | 322539 | 2020-07-11 | Madison | Illinois | 17119 | 1167 | 70 |
319360 | 319360 | 2020-07-10 | Madison | Illinois | 17119 | 1134 | 70 |
316187 | 316187 | 2020-07-09 | Madison | Illinois | 17119 | 1111 | 70 |
313013 | 313013 | 2020-07-08 | Madison | Illinois | 17119 | 1090 | 70 |
309843 | 309843 | 2020-07-07 | Madison | Illinois | 17119 | 1062 | 70 |
306675 | 306675 | 2020-07-06 | Madison | Illinois | 17119 | 1043 | 70 |
303510 | 303510 | 2020-07-05 | Madison | Illinois | 17119 | 1036 | 69 |
300346 | 300346 | 2020-07-04 | Madison | Illinois | 17119 | 1007 | 69 |
297184 | 297184 | 2020-07-03 | Madison | Illinois | 17119 | 993 | 69 |
294027 | 294027 | 2020-07-02 | Madison | Illinois | 17119 | 974 | 69 |
290873 | 290873 | 2020-07-01 | Madison | Illinois | 17119 | 960 | 69 |
287723 | 287723 | 2020-06-30 | Madison | Illinois | 17119 | 939 | 68 |
284574 | 284574 | 2020-06-29 | Madison | Illinois | 17119 | 931 | 68 |
281429 | 281429 | 2020-06-28 | Madison | Illinois | 17119 | 917 | 68 |
278281 | 278281 | 2020-06-27 | Madison | Illinois | 17119 | 903 | 68 |
275133 | 275133 | 2020-06-26 | Madison | Illinois | 17119 | 892 | 68 |
271991 | 271991 | 2020-06-25 | Madison | Illinois | 17119 | 877 | 68 |
268854 | 268854 | 2020-06-24 | Madison | Illinois | 17119 | 852 | 68 |
265724 | 265724 | 2020-06-23 | Madison | Illinois | 17119 | 829 | 67 |
262596 | 262596 | 2020-06-22 | Madison | Illinois | 17119 | 816 | 67 |
259469 | 259469 | 2020-06-21 | Madison | Illinois | 17119 | 813 | 66 |
256343 | 256343 | 2020-06-20 | Madison | Illinois | 17119 | 802 | 66 |
253223 | 253223 | 2020-06-19 | Madison | Illinois | 17119 | 790 | 66 |
250108 | 250108 | 2020-06-18 | Madison | Illinois | 17119 | 771 | 66 |
246996 | 246996 | 2020-06-17 | Madison | Illinois | 17119 | 752 | 66 |
243883 | 243883 | 2020-06-16 | Madison | Illinois | 17119 | 740 | 66 |
240772 | 240772 | 2020-06-15 | Madison | Illinois | 17119 | 733 | 66 |
237664 | 237664 | 2020-06-14 | Madison | Illinois | 17119 | 720 | 65 |
234557 | 234557 | 2020-06-13 | Madison | Illinois | 17119 | 707 | 65 |
231451 | 231451 | 2020-06-12 | Madison | Illinois | 17119 | 686 | 65 |
228348 | 228348 | 2020-06-11 | Madison | Illinois | 17119 | 682 | 65 |
225246 | 225246 | 2020-06-10 | Madison | Illinois | 17119 | 665 | 65 |
222151 | 222151 | 2020-06-09 | Madison | Illinois | 17119 | 652 | 65 |
219056 | 219056 | 2020-06-08 | Madison | Illinois | 17119 | 644 | 65 |
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);