ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Madison" and fips = 36053 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
909327 | 909327 | 2021-01-08 | Madison | New York | 36053 | 2682 | 72 |
906082 | 906082 | 2021-01-07 | Madison | New York | 36053 | 2602 | 71 |
902836 | 902836 | 2021-01-06 | Madison | New York | 36053 | 2553 | 71 |
899591 | 899591 | 2021-01-05 | Madison | New York | 36053 | 2482 | 71 |
896346 | 896346 | 2021-01-04 | Madison | New York | 36053 | 2458 | 69 |
893100 | 893100 | 2021-01-03 | Madison | New York | 36053 | 2417 | 68 |
889854 | 889854 | 2021-01-02 | Madison | New York | 36053 | 2377 | 66 |
886607 | 886607 | 2021-01-01 | Madison | New York | 36053 | 2337 | 66 |
883362 | 883362 | 2020-12-31 | Madison | New York | 36053 | 2289 | 66 |
880117 | 880117 | 2020-12-30 | Madison | New York | 36053 | 2240 | 65 |
876872 | 876872 | 2020-12-29 | Madison | New York | 36053 | 2186 | 64 |
873627 | 873627 | 2020-12-28 | Madison | New York | 36053 | 2150 | 60 |
870382 | 870382 | 2020-12-27 | Madison | New York | 36053 | 2106 | 59 |
867137 | 867137 | 2020-12-26 | Madison | New York | 36053 | 2083 | 58 |
863892 | 863892 | 2020-12-25 | Madison | New York | 36053 | 2059 | 56 |
860647 | 860647 | 2020-12-24 | Madison | New York | 36053 | 2017 | 54 |
857402 | 857402 | 2020-12-23 | Madison | New York | 36053 | 1953 | 50 |
854157 | 854157 | 2020-12-22 | Madison | New York | 36053 | 1912 | 45 |
850912 | 850912 | 2020-12-21 | Madison | New York | 36053 | 1897 | 43 |
847667 | 847667 | 2020-12-20 | Madison | New York | 36053 | 1865 | 40 |
844422 | 844422 | 2020-12-19 | Madison | New York | 36053 | 1820 | 38 |
841176 | 841176 | 2020-12-18 | Madison | New York | 36053 | 1761 | 36 |
837931 | 837931 | 2020-12-17 | Madison | New York | 36053 | 1724 | 33 |
834685 | 834685 | 2020-12-16 | Madison | New York | 36053 | 1684 | 31 |
831439 | 831439 | 2020-12-15 | Madison | New York | 36053 | 1621 | 27 |
828192 | 828192 | 2020-12-14 | Madison | New York | 36053 | 1592 | 25 |
824946 | 824946 | 2020-12-13 | Madison | New York | 36053 | 1572 | 23 |
821699 | 821699 | 2020-12-12 | Madison | New York | 36053 | 1505 | 19 |
818453 | 818453 | 2020-12-11 | Madison | New York | 36053 | 1463 | 16 |
815207 | 815207 | 2020-12-10 | Madison | New York | 36053 | 1381 | 15 |
811962 | 811962 | 2020-12-09 | Madison | New York | 36053 | 1325 | 15 |
808717 | 808717 | 2020-12-08 | Madison | New York | 36053 | 1256 | 14 |
805472 | 805472 | 2020-12-07 | Madison | New York | 36053 | 1209 | 13 |
802227 | 802227 | 2020-12-06 | Madison | New York | 36053 | 1179 | 12 |
798982 | 798982 | 2020-12-05 | Madison | New York | 36053 | 1127 | 12 |
795737 | 795737 | 2020-12-04 | Madison | New York | 36053 | 1080 | 12 |
792492 | 792492 | 2020-12-03 | Madison | New York | 36053 | 1043 | 11 |
789247 | 789247 | 2020-12-02 | Madison | New York | 36053 | 992 | 11 |
786002 | 786002 | 2020-12-01 | Madison | New York | 36053 | 963 | 11 |
782758 | 782758 | 2020-11-30 | Madison | New York | 36053 | 951 | 11 |
779512 | 779512 | 2020-11-29 | Madison | New York | 36053 | 944 | 11 |
776267 | 776267 | 2020-11-28 | Madison | New York | 36053 | 913 | 11 |
773022 | 773022 | 2020-11-27 | Madison | New York | 36053 | 898 | 11 |
769777 | 769777 | 2020-11-26 | Madison | New York | 36053 | 878 | 11 |
766531 | 766531 | 2020-11-25 | Madison | New York | 36053 | 861 | 11 |
763286 | 763286 | 2020-11-24 | Madison | New York | 36053 | 836 | 11 |
760041 | 760041 | 2020-11-23 | Madison | New York | 36053 | 821 | 11 |
756795 | 756795 | 2020-11-22 | Madison | New York | 36053 | 797 | 10 |
753548 | 753548 | 2020-11-21 | Madison | New York | 36053 | 795 | 10 |
750302 | 750302 | 2020-11-20 | Madison | New York | 36053 | 776 | 10 |
747056 | 747056 | 2020-11-19 | Madison | New York | 36053 | 766 | 10 |
743810 | 743810 | 2020-11-18 | Madison | New York | 36053 | 753 | 10 |
740563 | 740563 | 2020-11-17 | Madison | New York | 36053 | 739 | 10 |
737318 | 737318 | 2020-11-16 | Madison | New York | 36053 | 727 | 10 |
734074 | 734074 | 2020-11-15 | Madison | New York | 36053 | 718 | 9 |
730828 | 730828 | 2020-11-14 | Madison | New York | 36053 | 709 | 9 |
727584 | 727584 | 2020-11-13 | Madison | New York | 36053 | 696 | 9 |
724340 | 724340 | 2020-11-12 | Madison | New York | 36053 | 684 | 9 |
721097 | 721097 | 2020-11-11 | Madison | New York | 36053 | 672 | 9 |
717854 | 717854 | 2020-11-10 | Madison | New York | 36053 | 666 | 9 |
714611 | 714611 | 2020-11-09 | Madison | New York | 36053 | 658 | 9 |
711367 | 711367 | 2020-11-08 | Madison | New York | 36053 | 652 | 9 |
708123 | 708123 | 2020-11-07 | Madison | New York | 36053 | 643 | 9 |
704880 | 704880 | 2020-11-06 | Madison | New York | 36053 | 627 | 9 |
701637 | 701637 | 2020-11-05 | Madison | New York | 36053 | 616 | 9 |
698393 | 698393 | 2020-11-04 | Madison | New York | 36053 | 609 | 9 |
695150 | 695150 | 2020-11-03 | Madison | New York | 36053 | 601 | 9 |
691908 | 691908 | 2020-11-02 | Madison | New York | 36053 | 597 | 9 |
688664 | 688664 | 2020-11-01 | Madison | New York | 36053 | 593 | 9 |
685419 | 685419 | 2020-10-31 | Madison | New York | 36053 | 584 | 9 |
682176 | 682176 | 2020-10-30 | Madison | New York | 36053 | 577 | 9 |
678933 | 678933 | 2020-10-29 | Madison | New York | 36053 | 570 | 9 |
675690 | 675690 | 2020-10-28 | Madison | New York | 36053 | 565 | 9 |
672447 | 672447 | 2020-10-27 | Madison | New York | 36053 | 563 | 9 |
669205 | 669205 | 2020-10-26 | Madison | New York | 36053 | 559 | 9 |
665961 | 665961 | 2020-10-25 | Madison | New York | 36053 | 559 | 9 |
662716 | 662716 | 2020-10-24 | Madison | New York | 36053 | 557 | 9 |
659472 | 659472 | 2020-10-23 | Madison | New York | 36053 | 552 | 9 |
656228 | 656228 | 2020-10-22 | Madison | New York | 36053 | 545 | 9 |
652983 | 652983 | 2020-10-21 | Madison | New York | 36053 | 541 | 9 |
649738 | 649738 | 2020-10-20 | Madison | New York | 36053 | 537 | 9 |
646494 | 646494 | 2020-10-19 | Madison | New York | 36053 | 536 | 9 |
643248 | 643248 | 2020-10-18 | Madison | New York | 36053 | 533 | 9 |
640000 | 640000 | 2020-10-17 | Madison | New York | 36053 | 531 | 9 |
636754 | 636754 | 2020-10-16 | Madison | New York | 36053 | 528 | 9 |
633508 | 633508 | 2020-10-15 | Madison | New York | 36053 | 521 | 9 |
630263 | 630263 | 2020-10-14 | Madison | New York | 36053 | 517 | 9 |
627019 | 627019 | 2020-10-13 | Madison | New York | 36053 | 515 | 9 |
623777 | 623777 | 2020-10-12 | Madison | New York | 36053 | 511 | 9 |
620534 | 620534 | 2020-10-11 | Madison | New York | 36053 | 511 | 9 |
617292 | 617292 | 2020-10-10 | Madison | New York | 36053 | 509 | 9 |
614050 | 614050 | 2020-10-09 | Madison | New York | 36053 | 509 | 9 |
610809 | 610809 | 2020-10-08 | Madison | New York | 36053 | 505 | 9 |
607567 | 607567 | 2020-10-07 | Madison | New York | 36053 | 505 | 9 |
604324 | 604324 | 2020-10-06 | Madison | New York | 36053 | 505 | 9 |
601082 | 601082 | 2020-10-05 | Madison | New York | 36053 | 503 | 9 |
597839 | 597839 | 2020-10-04 | Madison | New York | 36053 | 503 | 9 |
594596 | 594596 | 2020-10-03 | Madison | New York | 36053 | 503 | 9 |
591355 | 591355 | 2020-10-02 | Madison | New York | 36053 | 501 | 9 |
588114 | 588114 | 2020-10-01 | Madison | New York | 36053 | 498 | 9 |
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);