ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 17111 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535083 | 535083 | 2020-09-15 | McHenry | Illinois | 17111 | 4339 | 119 |
531848 | 531848 | 2020-09-14 | McHenry | Illinois | 17111 | 4342 | 119 |
528611 | 528611 | 2020-09-13 | McHenry | Illinois | 17111 | 4326 | 118 |
525375 | 525375 | 2020-09-12 | McHenry | Illinois | 17111 | 4303 | 118 |
522139 | 522139 | 2020-09-11 | McHenry | Illinois | 17111 | 4271 | 118 |
518902 | 518902 | 2020-09-10 | McHenry | Illinois | 17111 | 4242 | 118 |
515667 | 515667 | 2020-09-09 | McHenry | Illinois | 17111 | 4226 | 118 |
512434 | 512434 | 2020-09-08 | McHenry | Illinois | 17111 | 4221 | 118 |
509201 | 509201 | 2020-09-07 | McHenry | Illinois | 17111 | 4174 | 118 |
505969 | 505969 | 2020-09-06 | McHenry | Illinois | 17111 | 4150 | 118 |
502735 | 502735 | 2020-09-05 | McHenry | Illinois | 17111 | 4125 | 118 |
499501 | 499501 | 2020-09-04 | McHenry | Illinois | 17111 | 4078 | 118 |
496268 | 496268 | 2020-09-03 | McHenry | Illinois | 17111 | 3986 | 117 |
493034 | 493034 | 2020-09-02 | McHenry | Illinois | 17111 | 3968 | 117 |
489801 | 489801 | 2020-09-01 | McHenry | Illinois | 17111 | 3938 | 117 |
486568 | 486568 | 2020-08-31 | McHenry | Illinois | 17111 | 3912 | 117 |
483333 | 483333 | 2020-08-30 | McHenry | Illinois | 17111 | 3891 | 117 |
480099 | 480099 | 2020-08-29 | McHenry | Illinois | 17111 | 3850 | 117 |
476866 | 476866 | 2020-08-28 | McHenry | Illinois | 17111 | 3843 | 117 |
473633 | 473633 | 2020-08-27 | McHenry | Illinois | 17111 | 3807 | 116 |
470401 | 470401 | 2020-08-26 | McHenry | Illinois | 17111 | 3741 | 116 |
467172 | 467172 | 2020-08-25 | McHenry | Illinois | 17111 | 3722 | 115 |
463943 | 463943 | 2020-08-24 | McHenry | Illinois | 17111 | 3680 | 115 |
460714 | 460714 | 2020-08-23 | McHenry | Illinois | 17111 | 3591 | 115 |
457487 | 457487 | 2020-08-22 | McHenry | Illinois | 17111 | 3591 | 115 |
454259 | 454259 | 2020-08-21 | McHenry | Illinois | 17111 | 3591 | 115 |
451031 | 451031 | 2020-08-20 | McHenry | Illinois | 17111 | 3560 | 115 |
447803 | 447803 | 2020-08-19 | McHenry | Illinois | 17111 | 3531 | 115 |
444576 | 444576 | 2020-08-18 | McHenry | Illinois | 17111 | 3509 | 115 |
441350 | 441350 | 2020-08-17 | McHenry | Illinois | 17111 | 3474 | 115 |
438124 | 438124 | 2020-08-16 | McHenry | Illinois | 17111 | 3400 | 115 |
434898 | 434898 | 2020-08-15 | McHenry | Illinois | 17111 | 3400 | 115 |
431673 | 431673 | 2020-08-14 | McHenry | Illinois | 17111 | 3400 | 115 |
428445 | 428445 | 2020-08-13 | McHenry | Illinois | 17111 | 3370 | 115 |
425221 | 425221 | 2020-08-12 | McHenry | Illinois | 17111 | 3342 | 115 |
422000 | 422000 | 2020-08-11 | McHenry | Illinois | 17111 | 3314 | 115 |
418777 | 418777 | 2020-08-10 | McHenry | Illinois | 17111 | 3218 | 115 |
415556 | 415556 | 2020-08-09 | McHenry | Illinois | 17111 | 3189 | 115 |
412336 | 412336 | 2020-08-08 | McHenry | Illinois | 17111 | 3189 | 115 |
409117 | 409117 | 2020-08-07 | McHenry | Illinois | 17111 | 3189 | 115 |
405897 | 405897 | 2020-08-06 | McHenry | Illinois | 17111 | 3118 | 115 |
402679 | 402679 | 2020-08-05 | McHenry | Illinois | 17111 | 3077 | 115 |
399463 | 399463 | 2020-08-04 | McHenry | Illinois | 17111 | 3050 | 115 |
396247 | 396247 | 2020-08-03 | McHenry | Illinois | 17111 | 3021 | 115 |
393031 | 393031 | 2020-08-02 | McHenry | Illinois | 17111 | 2941 | 114 |
389814 | 389814 | 2020-08-01 | McHenry | Illinois | 17111 | 2934 | 114 |
386597 | 386597 | 2020-07-31 | McHenry | Illinois | 17111 | 2934 | 114 |
383379 | 383379 | 2020-07-30 | McHenry | Illinois | 17111 | 2898 | 113 |
380162 | 380162 | 2020-07-29 | McHenry | Illinois | 17111 | 2835 | 113 |
376945 | 376945 | 2020-07-28 | McHenry | Illinois | 17111 | 2797 | 113 |
373730 | 373730 | 2020-07-27 | McHenry | Illinois | 17111 | 2759 | 113 |
370518 | 370518 | 2020-07-26 | McHenry | Illinois | 17111 | 2694 | 111 |
367308 | 367308 | 2020-07-25 | McHenry | Illinois | 17111 | 2681 | 111 |
364101 | 364101 | 2020-07-24 | McHenry | Illinois | 17111 | 2681 | 111 |
360894 | 360894 | 2020-07-23 | McHenry | Illinois | 17111 | 2654 | 111 |
357689 | 357689 | 2020-07-22 | McHenry | Illinois | 17111 | 2608 | 110 |
354487 | 354487 | 2020-07-21 | McHenry | Illinois | 17111 | 2565 | 109 |
351285 | 351285 | 2020-07-20 | McHenry | Illinois | 17111 | 2538 | 108 |
348085 | 348085 | 2020-07-19 | McHenry | Illinois | 17111 | 2463 | 107 |
344884 | 344884 | 2020-07-18 | McHenry | Illinois | 17111 | 2446 | 107 |
341684 | 341684 | 2020-07-17 | McHenry | Illinois | 17111 | 2418 | 106 |
338488 | 338488 | 2020-07-16 | McHenry | Illinois | 17111 | 2418 | 105 |
335292 | 335292 | 2020-07-15 | McHenry | Illinois | 17111 | 2418 | 105 |
332099 | 332099 | 2020-07-14 | McHenry | Illinois | 17111 | 2381 | 105 |
328912 | 328912 | 2020-07-13 | McHenry | Illinois | 17111 | 2361 | 103 |
325726 | 325726 | 2020-07-12 | McHenry | Illinois | 17111 | 2303 | 103 |
322545 | 322545 | 2020-07-11 | McHenry | Illinois | 17111 | 2303 | 103 |
319366 | 319366 | 2020-07-10 | McHenry | Illinois | 17111 | 2296 | 103 |
316193 | 316193 | 2020-07-09 | McHenry | Illinois | 17111 | 2274 | 103 |
313019 | 313019 | 2020-07-08 | McHenry | Illinois | 17111 | 2246 | 103 |
309849 | 309849 | 2020-07-07 | McHenry | Illinois | 17111 | 2211 | 100 |
306681 | 306681 | 2020-07-06 | McHenry | Illinois | 17111 | 2196 | 99 |
303516 | 303516 | 2020-07-05 | McHenry | Illinois | 17111 | 2115 | 97 |
300352 | 300352 | 2020-07-04 | McHenry | Illinois | 17111 | 2103 | 97 |
297190 | 297190 | 2020-07-03 | McHenry | Illinois | 17111 | 2088 | 97 |
294033 | 294033 | 2020-07-02 | McHenry | Illinois | 17111 | 2074 | 97 |
290879 | 290879 | 2020-07-01 | McHenry | Illinois | 17111 | 2061 | 97 |
287729 | 287729 | 2020-06-30 | McHenry | Illinois | 17111 | 2032 | 97 |
284580 | 284580 | 2020-06-29 | McHenry | Illinois | 17111 | 2010 | 97 |
281435 | 281435 | 2020-06-28 | McHenry | Illinois | 17111 | 1999 | 97 |
278287 | 278287 | 2020-06-27 | McHenry | Illinois | 17111 | 1991 | 97 |
275139 | 275139 | 2020-06-26 | McHenry | Illinois | 17111 | 1975 | 96 |
271997 | 271997 | 2020-06-25 | McHenry | Illinois | 17111 | 1949 | 95 |
268860 | 268860 | 2020-06-24 | McHenry | Illinois | 17111 | 1937 | 93 |
265730 | 265730 | 2020-06-23 | McHenry | Illinois | 17111 | 1922 | 92 |
262602 | 262602 | 2020-06-22 | McHenry | Illinois | 17111 | 1921 | 91 |
259475 | 259475 | 2020-06-21 | McHenry | Illinois | 17111 | 1911 | 91 |
256349 | 256349 | 2020-06-20 | McHenry | Illinois | 17111 | 1898 | 91 |
253229 | 253229 | 2020-06-19 | McHenry | Illinois | 17111 | 1891 | 89 |
250114 | 250114 | 2020-06-18 | McHenry | Illinois | 17111 | 1884 | 89 |
247002 | 247002 | 2020-06-17 | McHenry | Illinois | 17111 | 1872 | 88 |
243889 | 243889 | 2020-06-16 | McHenry | Illinois | 17111 | 1864 | 86 |
240778 | 240778 | 2020-06-15 | McHenry | Illinois | 17111 | 1856 | 85 |
237670 | 237670 | 2020-06-14 | McHenry | Illinois | 17111 | 1849 | 85 |
234563 | 234563 | 2020-06-13 | McHenry | Illinois | 17111 | 1829 | 85 |
231457 | 231457 | 2020-06-12 | McHenry | Illinois | 17111 | 1810 | 85 |
228354 | 228354 | 2020-06-11 | McHenry | Illinois | 17111 | 1788 | 84 |
225252 | 225252 | 2020-06-10 | McHenry | Illinois | 17111 | 1776 | 84 |
222157 | 222157 | 2020-06-09 | McHenry | Illinois | 17111 | 1752 | 84 |
219062 | 219062 | 2020-06-08 | McHenry | Illinois | 17111 | 1744 | 83 |
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);