ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "McHenry" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635546 | 635546 | 2020-10-16 | McHenry | Illinois | 17111 | 5506 | 125 |
632300 | 632300 | 2020-10-15 | McHenry | Illinois | 17111 | 5409 | 125 |
629056 | 629056 | 2020-10-14 | McHenry | Illinois | 17111 | 5347 | 124 |
625813 | 625813 | 2020-10-13 | McHenry | Illinois | 17111 | 5297 | 124 |
622571 | 622571 | 2020-10-12 | McHenry | Illinois | 17111 | 5226 | 124 |
619327 | 619327 | 2020-10-11 | McHenry | Illinois | 17111 | 5178 | 124 |
616085 | 616085 | 2020-10-10 | McHenry | Illinois | 17111 | 5140 | 124 |
612844 | 612844 | 2020-10-09 | McHenry | Illinois | 17111 | 5085 | 124 |
609602 | 609602 | 2020-10-08 | McHenry | Illinois | 17111 | 5029 | 124 |
606359 | 606359 | 2020-10-07 | McHenry | Illinois | 17111 | 4986 | 124 |
603117 | 603117 | 2020-10-06 | McHenry | Illinois | 17111 | 4929 | 124 |
599874 | 599874 | 2020-10-05 | McHenry | Illinois | 17111 | 4897 | 123 |
596632 | 596632 | 2020-10-04 | McHenry | Illinois | 17111 | 4854 | 123 |
593390 | 593390 | 2020-10-03 | McHenry | Illinois | 17111 | 4816 | 123 |
590149 | 590149 | 2020-10-02 | McHenry | Illinois | 17111 | 4792 | 123 |
586908 | 586908 | 2020-10-01 | McHenry | Illinois | 17111 | 4760 | 123 |
583668 | 583668 | 2020-09-30 | McHenry | Illinois | 17111 | 4730 | 122 |
580429 | 580429 | 2020-09-29 | McHenry | Illinois | 17111 | 4701 | 122 |
577188 | 577188 | 2020-09-28 | McHenry | Illinois | 17111 | 4696 | 122 |
573946 | 573946 | 2020-09-27 | McHenry | Illinois | 17111 | 4654 | 122 |
570703 | 570703 | 2020-09-26 | McHenry | Illinois | 17111 | 4640 | 122 |
567461 | 567461 | 2020-09-25 | McHenry | Illinois | 17111 | 4609 | 122 |
564221 | 564221 | 2020-09-24 | McHenry | Illinois | 17111 | 4579 | 122 |
560981 | 560981 | 2020-09-23 | McHenry | Illinois | 17111 | 4534 | 122 |
557745 | 557745 | 2020-09-22 | McHenry | Illinois | 17111 | 4516 | 122 |
554508 | 554508 | 2020-09-21 | McHenry | Illinois | 17111 | 4498 | 120 |
551269 | 551269 | 2020-09-20 | McHenry | Illinois | 17111 | 4473 | 120 |
548030 | 548030 | 2020-09-19 | McHenry | Illinois | 17111 | 4452 | 120 |
544792 | 544792 | 2020-09-18 | McHenry | Illinois | 17111 | 4417 | 120 |
541556 | 541556 | 2020-09-17 | McHenry | Illinois | 17111 | 4389 | 119 |
538319 | 538319 | 2020-09-16 | McHenry | Illinois | 17111 | 4361 | 119 |
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 |
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);