ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Franklin" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917222 | 917222 | 2021-01-11 | Franklin | Alabama | 1059 | 3552 | 39 |
913977 | 913977 | 2021-01-10 | Franklin | Alabama | 1059 | 3530 | 39 |
910732 | 910732 | 2021-01-09 | Franklin | Alabama | 1059 | 3514 | 39 |
907487 | 907487 | 2021-01-08 | Franklin | Alabama | 1059 | 3462 | 39 |
904241 | 904241 | 2021-01-07 | Franklin | Alabama | 1059 | 3418 | 39 |
900996 | 900996 | 2021-01-06 | Franklin | Alabama | 1059 | 3383 | 39 |
897751 | 897751 | 2021-01-05 | Franklin | Alabama | 1059 | 3355 | 38 |
894505 | 894505 | 2021-01-04 | Franklin | Alabama | 1059 | 3340 | 38 |
891259 | 891259 | 2021-01-03 | Franklin | Alabama | 1059 | 3336 | 38 |
888012 | 888012 | 2021-01-02 | Franklin | Alabama | 1059 | 3317 | 37 |
884767 | 884767 | 2021-01-01 | Franklin | Alabama | 1059 | 3300 | 37 |
881522 | 881522 | 2020-12-31 | Franklin | Alabama | 1059 | 3270 | 37 |
878277 | 878277 | 2020-12-30 | Franklin | Alabama | 1059 | 3233 | 36 |
875032 | 875032 | 2020-12-29 | Franklin | Alabama | 1059 | 3185 | 36 |
871787 | 871787 | 2020-12-28 | Franklin | Alabama | 1059 | 3169 | 36 |
868542 | 868542 | 2020-12-27 | Franklin | Alabama | 1059 | 3151 | 36 |
865297 | 865297 | 2020-12-26 | Franklin | Alabama | 1059 | 3135 | 36 |
862052 | 862052 | 2020-12-25 | Franklin | Alabama | 1059 | 3129 | 36 |
858807 | 858807 | 2020-12-24 | Franklin | Alabama | 1059 | 3106 | 36 |
855562 | 855562 | 2020-12-23 | Franklin | Alabama | 1059 | 3083 | 36 |
852317 | 852317 | 2020-12-22 | Franklin | Alabama | 1059 | 3046 | 36 |
849072 | 849072 | 2020-12-21 | Franklin | Alabama | 1059 | 3033 | 36 |
845827 | 845827 | 2020-12-20 | Franklin | Alabama | 1059 | 3021 | 36 |
842581 | 842581 | 2020-12-19 | Franklin | Alabama | 1059 | 3011 | 36 |
839336 | 839336 | 2020-12-18 | Franklin | Alabama | 1059 | 2978 | 36 |
836091 | 836091 | 2020-12-17 | Franklin | Alabama | 1059 | 2953 | 35 |
832845 | 832845 | 2020-12-16 | Franklin | Alabama | 1059 | 2923 | 34 |
829598 | 829598 | 2020-12-15 | Franklin | Alabama | 1059 | 2896 | 34 |
826352 | 826352 | 2020-12-14 | Franklin | Alabama | 1059 | 2872 | 34 |
823105 | 823105 | 2020-12-13 | Franklin | Alabama | 1059 | 2865 | 34 |
819859 | 819859 | 2020-12-12 | Franklin | Alabama | 1059 | 2848 | 34 |
816613 | 816613 | 2020-12-11 | Franklin | Alabama | 1059 | 2828 | 34 |
813367 | 813367 | 2020-12-10 | Franklin | Alabama | 1059 | 2808 | 34 |
810123 | 810123 | 2020-12-09 | Franklin | Alabama | 1059 | 2781 | 34 |
806878 | 806878 | 2020-12-08 | Franklin | Alabama | 1059 | 2735 | 34 |
803633 | 803633 | 2020-12-07 | Franklin | Alabama | 1059 | 2700 | 34 |
800388 | 800388 | 2020-12-06 | Franklin | Alabama | 1059 | 2694 | 34 |
797143 | 797143 | 2020-12-05 | Franklin | Alabama | 1059 | 2685 | 34 |
793898 | 793898 | 2020-12-04 | Franklin | Alabama | 1059 | 2655 | 34 |
790653 | 790653 | 2020-12-03 | Franklin | Alabama | 1059 | 2626 | 34 |
787408 | 787408 | 2020-12-02 | Franklin | Alabama | 1059 | 2597 | 34 |
784164 | 784164 | 2020-12-01 | Franklin | Alabama | 1059 | 2574 | 34 |
780919 | 780919 | 2020-11-30 | Franklin | Alabama | 1059 | 2564 | 34 |
777673 | 777673 | 2020-11-29 | Franklin | Alabama | 1059 | 2542 | 33 |
774428 | 774428 | 2020-11-28 | Franklin | Alabama | 1059 | 2526 | 33 |
771183 | 771183 | 2020-11-27 | Franklin | Alabama | 1059 | 2510 | 33 |
767937 | 767937 | 2020-11-26 | Franklin | Alabama | 1059 | 2502 | 33 |
764692 | 764692 | 2020-11-25 | Franklin | Alabama | 1059 | 2478 | 33 |
761447 | 761447 | 2020-11-24 | Franklin | Alabama | 1059 | 2462 | 33 |
758202 | 758202 | 2020-11-23 | Franklin | Alabama | 1059 | 2448 | 33 |
754955 | 754955 | 2020-11-22 | Franklin | Alabama | 1059 | 2436 | 33 |
751709 | 751709 | 2020-11-21 | Franklin | Alabama | 1059 | 2420 | 33 |
748463 | 748463 | 2020-11-20 | Franklin | Alabama | 1059 | 2394 | 33 |
745217 | 745217 | 2020-11-19 | Franklin | Alabama | 1059 | 2380 | 33 |
741970 | 741970 | 2020-11-18 | Franklin | Alabama | 1059 | 2362 | 33 |
738723 | 738723 | 2020-11-17 | Franklin | Alabama | 1059 | 2351 | 33 |
735479 | 735479 | 2020-11-16 | Franklin | Alabama | 1059 | 2344 | 33 |
732233 | 732233 | 2020-11-15 | Franklin | Alabama | 1059 | 2336 | 33 |
728988 | 728988 | 2020-11-14 | Franklin | Alabama | 1059 | 2320 | 33 |
725745 | 725745 | 2020-11-13 | Franklin | Alabama | 1059 | 2309 | 33 |
722502 | 722502 | 2020-11-12 | Franklin | Alabama | 1059 | 2286 | 33 |
719259 | 719259 | 2020-11-11 | Franklin | Alabama | 1059 | 2281 | 33 |
716016 | 716016 | 2020-11-10 | Franklin | Alabama | 1059 | 2261 | 34 |
712772 | 712772 | 2020-11-09 | Franklin | Alabama | 1059 | 2257 | 34 |
709528 | 709528 | 2020-11-08 | Franklin | Alabama | 1059 | 2250 | 34 |
706284 | 706284 | 2020-11-07 | Franklin | Alabama | 1059 | 2245 | 33 |
703041 | 703041 | 2020-11-06 | Franklin | Alabama | 1059 | 2232 | 33 |
699798 | 699798 | 2020-11-05 | Franklin | Alabama | 1059 | 2219 | 32 |
696554 | 696554 | 2020-11-04 | Franklin | Alabama | 1059 | 2202 | 32 |
693312 | 693312 | 2020-11-03 | Franklin | Alabama | 1059 | 2192 | 32 |
690069 | 690069 | 2020-11-02 | Franklin | Alabama | 1059 | 2189 | 32 |
686824 | 686824 | 2020-11-01 | Franklin | Alabama | 1059 | 2185 | 32 |
683580 | 683580 | 2020-10-31 | Franklin | Alabama | 1059 | 2120 | 32 |
680337 | 680337 | 2020-10-30 | Franklin | Alabama | 1059 | 2107 | 32 |
677094 | 677094 | 2020-10-29 | Franklin | Alabama | 1059 | 2094 | 32 |
673851 | 673851 | 2020-10-28 | Franklin | Alabama | 1059 | 2077 | 32 |
670609 | 670609 | 2020-10-27 | Franklin | Alabama | 1059 | 2064 | 32 |
667366 | 667366 | 2020-10-26 | Franklin | Alabama | 1059 | 2061 | 31 |
664121 | 664121 | 2020-10-25 | Franklin | Alabama | 1059 | 2055 | 31 |
660877 | 660877 | 2020-10-24 | Franklin | Alabama | 1059 | 2052 | 31 |
657633 | 657633 | 2020-10-23 | Franklin | Alabama | 1059 | 2032 | 31 |
654388 | 654388 | 2020-10-22 | Franklin | Alabama | 1059 | 2021 | 31 |
651143 | 651143 | 2020-10-21 | Franklin | Alabama | 1059 | 2017 | 31 |
647899 | 647899 | 2020-10-20 | Franklin | Alabama | 1059 | 1997 | 31 |
644654 | 644654 | 2020-10-19 | Franklin | Alabama | 1059 | 1991 | 31 |
641406 | 641406 | 2020-10-18 | Franklin | Alabama | 1059 | 1981 | 31 |
638159 | 638159 | 2020-10-17 | Franklin | Alabama | 1059 | 1974 | 31 |
634914 | 634914 | 2020-10-16 | Franklin | Alabama | 1059 | 1952 | 31 |
631669 | 631669 | 2020-10-15 | Franklin | Alabama | 1059 | 1928 | 31 |
628425 | 628425 | 2020-10-14 | Franklin | Alabama | 1059 | 1916 | 30 |
625182 | 625182 | 2020-10-13 | Franklin | Alabama | 1059 | 1900 | 30 |
621939 | 621939 | 2020-10-12 | Franklin | Alabama | 1059 | 1896 | 30 |
618696 | 618696 | 2020-10-11 | Franklin | Alabama | 1059 | 1891 | 30 |
615454 | 615454 | 2020-10-10 | Franklin | Alabama | 1059 | 1886 | 30 |
612213 | 612213 | 2020-10-09 | Franklin | Alabama | 1059 | 1872 | 30 |
608971 | 608971 | 2020-10-08 | Franklin | Alabama | 1059 | 1871 | 30 |
605728 | 605728 | 2020-10-07 | Franklin | Alabama | 1059 | 1868 | 30 |
602486 | 602486 | 2020-10-06 | Franklin | Alabama | 1059 | 1856 | 30 |
599243 | 599243 | 2020-10-05 | Franklin | Alabama | 1059 | 1850 | 30 |
596000 | 596000 | 2020-10-04 | Franklin | Alabama | 1059 | 1842 | 30 |
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);