ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Madison" and fips = 13195 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
907942 | 907942 | 2021-01-08 | Madison | Georgia | 13195 | 2113 | 26 |
904696 | 904696 | 2021-01-07 | Madison | Georgia | 13195 | 2074 | 24 |
901451 | 901451 | 2021-01-06 | Madison | Georgia | 13195 | 2031 | 24 |
898206 | 898206 | 2021-01-05 | Madison | Georgia | 13195 | 2008 | 24 |
894961 | 894961 | 2021-01-04 | Madison | Georgia | 13195 | 1960 | 24 |
891714 | 891714 | 2021-01-03 | Madison | Georgia | 13195 | 1945 | 24 |
888467 | 888467 | 2021-01-02 | Madison | Georgia | 13195 | 1912 | 24 |
885222 | 885222 | 2021-01-01 | Madison | Georgia | 13195 | 1885 | 24 |
881977 | 881977 | 2020-12-31 | Madison | Georgia | 13195 | 1861 | 23 |
878732 | 878732 | 2020-12-30 | Madison | Georgia | 13195 | 1810 | 23 |
875487 | 875487 | 2020-12-29 | Madison | Georgia | 13195 | 1795 | 23 |
872242 | 872242 | 2020-12-28 | Madison | Georgia | 13195 | 1753 | 23 |
868997 | 868997 | 2020-12-27 | Madison | Georgia | 13195 | 1748 | 23 |
865752 | 865752 | 2020-12-26 | Madison | Georgia | 13195 | 1737 | 23 |
862507 | 862507 | 2020-12-25 | Madison | Georgia | 13195 | 1725 | 22 |
859262 | 859262 | 2020-12-24 | Madison | Georgia | 13195 | 1714 | 22 |
856017 | 856017 | 2020-12-23 | Madison | Georgia | 13195 | 1672 | 22 |
852772 | 852772 | 2020-12-22 | Madison | Georgia | 13195 | 1648 | 22 |
849527 | 849527 | 2020-12-21 | Madison | Georgia | 13195 | 1627 | 22 |
846282 | 846282 | 2020-12-20 | Madison | Georgia | 13195 | 1609 | 22 |
843036 | 843036 | 2020-12-19 | Madison | Georgia | 13195 | 1583 | 22 |
839791 | 839791 | 2020-12-18 | Madison | Georgia | 13195 | 1572 | 22 |
836546 | 836546 | 2020-12-17 | Madison | Georgia | 13195 | 1560 | 22 |
833300 | 833300 | 2020-12-16 | Madison | Georgia | 13195 | 1524 | 22 |
830053 | 830053 | 2020-12-15 | Madison | Georgia | 13195 | 1499 | 22 |
826807 | 826807 | 2020-12-14 | Madison | Georgia | 13195 | 1467 | 23 |
823560 | 823560 | 2020-12-13 | Madison | Georgia | 13195 | 1448 | 22 |
820314 | 820314 | 2020-12-12 | Madison | Georgia | 13195 | 1415 | 21 |
817068 | 817068 | 2020-12-11 | Madison | Georgia | 13195 | 1399 | 21 |
813822 | 813822 | 2020-12-10 | Madison | Georgia | 13195 | 1380 | 21 |
810578 | 810578 | 2020-12-09 | Madison | Georgia | 13195 | 1357 | 20 |
807333 | 807333 | 2020-12-08 | Madison | Georgia | 13195 | 1335 | 19 |
804088 | 804088 | 2020-12-07 | Madison | Georgia | 13195 | 1313 | 19 |
800843 | 800843 | 2020-12-06 | Madison | Georgia | 13195 | 1293 | 19 |
797598 | 797598 | 2020-12-05 | Madison | Georgia | 13195 | 1283 | 19 |
794353 | 794353 | 2020-12-04 | Madison | Georgia | 13195 | 1259 | 19 |
791108 | 791108 | 2020-12-03 | Madison | Georgia | 13195 | 1231 | 19 |
787863 | 787863 | 2020-12-02 | Madison | Georgia | 13195 | 1210 | 19 |
784619 | 784619 | 2020-12-01 | Madison | Georgia | 13195 | 1181 | 19 |
781374 | 781374 | 2020-11-30 | Madison | Georgia | 13195 | 1163 | 19 |
778128 | 778128 | 2020-11-29 | Madison | Georgia | 13195 | 1153 | 19 |
774883 | 774883 | 2020-11-28 | Madison | Georgia | 13195 | 1151 | 19 |
771638 | 771638 | 2020-11-27 | Madison | Georgia | 13195 | 1143 | 19 |
768393 | 768393 | 2020-11-26 | Madison | Georgia | 13195 | 1128 | 19 |
765147 | 765147 | 2020-11-25 | Madison | Georgia | 13195 | 1115 | 19 |
761902 | 761902 | 2020-11-24 | Madison | Georgia | 13195 | 1106 | 19 |
758657 | 758657 | 2020-11-23 | Madison | Georgia | 13195 | 1094 | 19 |
755410 | 755410 | 2020-11-22 | Madison | Georgia | 13195 | 1088 | 19 |
752164 | 752164 | 2020-11-21 | Madison | Georgia | 13195 | 1079 | 18 |
748918 | 748918 | 2020-11-20 | Madison | Georgia | 13195 | 1052 | 18 |
745672 | 745672 | 2020-11-19 | Madison | Georgia | 13195 | 1041 | 18 |
742425 | 742425 | 2020-11-18 | Madison | Georgia | 13195 | 1023 | 17 |
739178 | 739178 | 2020-11-17 | Madison | Georgia | 13195 | 1019 | 17 |
735934 | 735934 | 2020-11-16 | Madison | Georgia | 13195 | 1010 | 17 |
732688 | 732688 | 2020-11-15 | Madison | Georgia | 13195 | 1010 | 17 |
729443 | 729443 | 2020-11-14 | Madison | Georgia | 13195 | 1002 | 17 |
726200 | 726200 | 2020-11-13 | Madison | Georgia | 13195 | 996 | 17 |
722957 | 722957 | 2020-11-12 | Madison | Georgia | 13195 | 991 | 17 |
719714 | 719714 | 2020-11-11 | Madison | Georgia | 13195 | 981 | 17 |
716471 | 716471 | 2020-11-10 | Madison | Georgia | 13195 | 975 | 17 |
713227 | 713227 | 2020-11-09 | Madison | Georgia | 13195 | 967 | 17 |
709983 | 709983 | 2020-11-08 | Madison | Georgia | 13195 | 957 | 17 |
706739 | 706739 | 2020-11-07 | Madison | Georgia | 13195 | 951 | 16 |
703496 | 703496 | 2020-11-06 | Madison | Georgia | 13195 | 946 | 16 |
700253 | 700253 | 2020-11-05 | Madison | Georgia | 13195 | 934 | 16 |
697009 | 697009 | 2020-11-04 | Madison | Georgia | 13195 | 927 | 16 |
693767 | 693767 | 2020-11-03 | Madison | Georgia | 13195 | 916 | 11 |
690524 | 690524 | 2020-11-02 | Madison | Georgia | 13195 | 907 | 11 |
687279 | 687279 | 2020-11-01 | Madison | Georgia | 13195 | 894 | 11 |
684035 | 684035 | 2020-10-31 | Madison | Georgia | 13195 | 891 | 11 |
680792 | 680792 | 2020-10-30 | Madison | Georgia | 13195 | 878 | 11 |
677549 | 677549 | 2020-10-29 | Madison | Georgia | 13195 | 877 | 11 |
674306 | 674306 | 2020-10-28 | Madison | Georgia | 13195 | 868 | 11 |
671064 | 671064 | 2020-10-27 | Madison | Georgia | 13195 | 866 | 11 |
667821 | 667821 | 2020-10-26 | Madison | Georgia | 13195 | 862 | 11 |
664576 | 664576 | 2020-10-25 | Madison | Georgia | 13195 | 845 | 11 |
661332 | 661332 | 2020-10-24 | Madison | Georgia | 13195 | 839 | 11 |
658088 | 658088 | 2020-10-23 | Madison | Georgia | 13195 | 836 | 11 |
654843 | 654843 | 2020-10-22 | Madison | Georgia | 13195 | 834 | 11 |
651598 | 651598 | 2020-10-21 | Madison | Georgia | 13195 | 831 | 11 |
648354 | 648354 | 2020-10-20 | Madison | Georgia | 13195 | 822 | 11 |
645109 | 645109 | 2020-10-19 | Madison | Georgia | 13195 | 820 | 11 |
641861 | 641861 | 2020-10-18 | Madison | Georgia | 13195 | 817 | 11 |
638614 | 638614 | 2020-10-17 | Madison | Georgia | 13195 | 815 | 11 |
635369 | 635369 | 2020-10-16 | Madison | Georgia | 13195 | 813 | 11 |
632123 | 632123 | 2020-10-15 | Madison | Georgia | 13195 | 808 | 11 |
628879 | 628879 | 2020-10-14 | Madison | Georgia | 13195 | 806 | 11 |
625636 | 625636 | 2020-10-13 | Madison | Georgia | 13195 | 802 | 10 |
622393 | 622393 | 2020-10-12 | Madison | Georgia | 13195 | 801 | 10 |
619150 | 619150 | 2020-10-11 | Madison | Georgia | 13195 | 793 | 10 |
615908 | 615908 | 2020-10-10 | Madison | Georgia | 13195 | 790 | 9 |
612667 | 612667 | 2020-10-09 | Madison | Georgia | 13195 | 788 | 9 |
609425 | 609425 | 2020-10-08 | Madison | Georgia | 13195 | 782 | 9 |
606182 | 606182 | 2020-10-07 | Madison | Georgia | 13195 | 781 | 9 |
602940 | 602940 | 2020-10-06 | Madison | Georgia | 13195 | 778 | 8 |
599697 | 599697 | 2020-10-05 | Madison | Georgia | 13195 | 775 | 8 |
596454 | 596454 | 2020-10-04 | Madison | Georgia | 13195 | 714 | 8 |
593212 | 593212 | 2020-10-03 | Madison | Georgia | 13195 | 713 | 8 |
589972 | 589972 | 2020-10-02 | Madison | Georgia | 13195 | 710 | 8 |
586731 | 586731 | 2020-10-01 | Madison | Georgia | 13195 | 706 | 8 |
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);