ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Madison" and fips = 21151 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635957 | 635957 | 2020-10-16 | Madison | Kentucky | 21151 | 2116 | 11 |
632711 | 632711 | 2020-10-15 | Madison | Kentucky | 21151 | 2105 | 9 |
629467 | 629467 | 2020-10-14 | Madison | Kentucky | 21151 | 2091 | 9 |
626223 | 626223 | 2020-10-13 | Madison | Kentucky | 21151 | 2069 | 9 |
622981 | 622981 | 2020-10-12 | Madison | Kentucky | 21151 | 2037 | 7 |
619737 | 619737 | 2020-10-11 | Madison | Kentucky | 21151 | 2025 | 7 |
616495 | 616495 | 2020-10-10 | Madison | Kentucky | 21151 | 1994 | 7 |
613254 | 613254 | 2020-10-09 | Madison | Kentucky | 21151 | 1981 | 7 |
610012 | 610012 | 2020-10-08 | Madison | Kentucky | 21151 | 1967 | 7 |
606770 | 606770 | 2020-10-07 | Madison | Kentucky | 21151 | 1951 | 7 |
603528 | 603528 | 2020-10-06 | Madison | Kentucky | 21151 | 1941 | 7 |
600285 | 600285 | 2020-10-05 | Madison | Kentucky | 21151 | 1913 | 7 |
597043 | 597043 | 2020-10-04 | Madison | Kentucky | 21151 | 1909 | 7 |
593801 | 593801 | 2020-10-03 | Madison | Kentucky | 21151 | 1891 | 7 |
590560 | 590560 | 2020-10-02 | Madison | Kentucky | 21151 | 1873 | 7 |
587319 | 587319 | 2020-10-01 | Madison | Kentucky | 21151 | 1851 | 7 |
584079 | 584079 | 2020-09-30 | Madison | Kentucky | 21151 | 1809 | 7 |
580839 | 580839 | 2020-09-29 | Madison | Kentucky | 21151 | 1784 | 7 |
577598 | 577598 | 2020-09-28 | Madison | Kentucky | 21151 | 1761 | 7 |
574356 | 574356 | 2020-09-27 | Madison | Kentucky | 21151 | 1750 | 7 |
571113 | 571113 | 2020-09-26 | Madison | Kentucky | 21151 | 1730 | 7 |
567871 | 567871 | 2020-09-25 | Madison | Kentucky | 21151 | 1724 | 7 |
564631 | 564631 | 2020-09-24 | Madison | Kentucky | 21151 | 1696 | 6 |
561391 | 561391 | 2020-09-23 | Madison | Kentucky | 21151 | 1681 | 6 |
558155 | 558155 | 2020-09-22 | Madison | Kentucky | 21151 | 1670 | 6 |
554918 | 554918 | 2020-09-21 | Madison | Kentucky | 21151 | 1632 | 6 |
551679 | 551679 | 2020-09-20 | Madison | Kentucky | 21151 | 1615 | 6 |
548440 | 548440 | 2020-09-19 | Madison | Kentucky | 21151 | 1601 | 6 |
545202 | 545202 | 2020-09-18 | Madison | Kentucky | 21151 | 1537 | 6 |
541966 | 541966 | 2020-09-17 | Madison | Kentucky | 21151 | 1503 | 6 |
538730 | 538730 | 2020-09-16 | Madison | Kentucky | 21151 | 1470 | 4 |
535493 | 535493 | 2020-09-15 | Madison | Kentucky | 21151 | 1438 | 4 |
532258 | 532258 | 2020-09-14 | Madison | Kentucky | 21151 | 1406 | 4 |
529021 | 529021 | 2020-09-13 | Madison | Kentucky | 21151 | 1398 | 4 |
525785 | 525785 | 2020-09-12 | Madison | Kentucky | 21151 | 1388 | 4 |
522549 | 522549 | 2020-09-11 | Madison | Kentucky | 21151 | 1363 | 4 |
519312 | 519312 | 2020-09-10 | Madison | Kentucky | 21151 | 1316 | 4 |
516077 | 516077 | 2020-09-09 | Madison | Kentucky | 21151 | 1268 | 4 |
512844 | 512844 | 2020-09-08 | Madison | Kentucky | 21151 | 1245 | 4 |
509612 | 509612 | 2020-09-07 | Madison | Kentucky | 21151 | 1234 | 4 |
506379 | 506379 | 2020-09-06 | Madison | Kentucky | 21151 | 1232 | 4 |
503145 | 503145 | 2020-09-05 | Madison | Kentucky | 21151 | 1228 | 4 |
499912 | 499912 | 2020-09-04 | Madison | Kentucky | 21151 | 1196 | 3 |
496678 | 496678 | 2020-09-03 | Madison | Kentucky | 21151 | 1174 | 3 |
493445 | 493445 | 2020-09-02 | Madison | Kentucky | 21151 | 1107 | 3 |
490211 | 490211 | 2020-09-01 | Madison | Kentucky | 21151 | 1085 | 3 |
486978 | 486978 | 2020-08-31 | Madison | Kentucky | 21151 | 1020 | 3 |
483743 | 483743 | 2020-08-30 | Madison | Kentucky | 21151 | 1001 | 3 |
480509 | 480509 | 2020-08-29 | Madison | Kentucky | 21151 | 964 | 3 |
477276 | 477276 | 2020-08-28 | Madison | Kentucky | 21151 | 937 | 3 |
474043 | 474043 | 2020-08-27 | Madison | Kentucky | 21151 | 881 | 3 |
470811 | 470811 | 2020-08-26 | Madison | Kentucky | 21151 | 859 | 2 |
467582 | 467582 | 2020-08-25 | Madison | Kentucky | 21151 | 828 | 2 |
464353 | 464353 | 2020-08-24 | Madison | Kentucky | 21151 | 805 | 2 |
461122 | 461122 | 2020-08-23 | Madison | Kentucky | 21151 | 757 | 2 |
457895 | 457895 | 2020-08-22 | Madison | Kentucky | 21151 | 757 | 2 |
454667 | 454667 | 2020-08-21 | Madison | Kentucky | 21151 | 716 | 2 |
451439 | 451439 | 2020-08-20 | Madison | Kentucky | 21151 | 709 | 1 |
448211 | 448211 | 2020-08-19 | Madison | Kentucky | 21151 | 696 | 1 |
444984 | 444984 | 2020-08-18 | Madison | Kentucky | 21151 | 686 | 1 |
441758 | 441758 | 2020-08-17 | Madison | Kentucky | 21151 | 676 | 1 |
438531 | 438531 | 2020-08-16 | Madison | Kentucky | 21151 | 630 | 1 |
435306 | 435306 | 2020-08-15 | Madison | Kentucky | 21151 | 630 | 1 |
432081 | 432081 | 2020-08-14 | Madison | Kentucky | 21151 | 623 | 1 |
428853 | 428853 | 2020-08-13 | Madison | Kentucky | 21151 | 603 | 1 |
425629 | 425629 | 2020-08-12 | Madison | Kentucky | 21151 | 583 | 1 |
422408 | 422408 | 2020-08-11 | Madison | Kentucky | 21151 | 549 | 1 |
419186 | 419186 | 2020-08-10 | Madison | Kentucky | 21151 | 516 | 1 |
415965 | 415965 | 2020-08-09 | Madison | Kentucky | 21151 | 505 | 1 |
412745 | 412745 | 2020-08-08 | Madison | Kentucky | 21151 | 492 | 1 |
409525 | 409525 | 2020-08-07 | Madison | Kentucky | 21151 | 456 | 1 |
406305 | 406305 | 2020-08-06 | Madison | Kentucky | 21151 | 444 | 1 |
403087 | 403087 | 2020-08-05 | Madison | Kentucky | 21151 | 426 | 1 |
399870 | 399870 | 2020-08-04 | Madison | Kentucky | 21151 | 411 | 1 |
396655 | 396655 | 2020-08-03 | Madison | Kentucky | 21151 | 396 | 1 |
393439 | 393439 | 2020-08-02 | Madison | Kentucky | 21151 | 383 | 1 |
390222 | 390222 | 2020-08-01 | Madison | Kentucky | 21151 | 380 | 1 |
387005 | 387005 | 2020-07-31 | Madison | Kentucky | 21151 | 370 | 1 |
383787 | 383787 | 2020-07-30 | Madison | Kentucky | 21151 | 344 | 1 |
380570 | 380570 | 2020-07-29 | Madison | Kentucky | 21151 | 338 | 1 |
377353 | 377353 | 2020-07-28 | Madison | Kentucky | 21151 | 331 | 1 |
374138 | 374138 | 2020-07-27 | Madison | Kentucky | 21151 | 312 | 1 |
370926 | 370926 | 2020-07-26 | Madison | Kentucky | 21151 | 308 | 1 |
367716 | 367716 | 2020-07-25 | Madison | Kentucky | 21151 | 305 | 1 |
364509 | 364509 | 2020-07-24 | Madison | Kentucky | 21151 | 299 | 1 |
361302 | 361302 | 2020-07-23 | Madison | Kentucky | 21151 | 295 | 1 |
358097 | 358097 | 2020-07-22 | Madison | Kentucky | 21151 | 287 | 1 |
354894 | 354894 | 2020-07-21 | Madison | Kentucky | 21151 | 280 | 1 |
351692 | 351692 | 2020-07-20 | Madison | Kentucky | 21151 | 258 | 1 |
348492 | 348492 | 2020-07-19 | Madison | Kentucky | 21151 | 258 | 1 |
345291 | 345291 | 2020-07-18 | Madison | Kentucky | 21151 | 254 | 1 |
342091 | 342091 | 2020-07-17 | Madison | Kentucky | 21151 | 250 | 1 |
338895 | 338895 | 2020-07-16 | Madison | Kentucky | 21151 | 232 | 1 |
335699 | 335699 | 2020-07-15 | Madison | Kentucky | 21151 | 221 | 1 |
332506 | 332506 | 2020-07-14 | Madison | Kentucky | 21151 | 210 | 1 |
329319 | 329319 | 2020-07-13 | Madison | Kentucky | 21151 | 193 | 1 |
326133 | 326133 | 2020-07-12 | Madison | Kentucky | 21151 | 187 | 1 |
322950 | 322950 | 2020-07-11 | Madison | Kentucky | 21151 | 183 | 1 |
319771 | 319771 | 2020-07-10 | Madison | Kentucky | 21151 | 178 | 1 |
316596 | 316596 | 2020-07-09 | Madison | Kentucky | 21151 | 169 | 1 |
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);