ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
256 rows where deaths = 16 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clarke 30
- Fayette 28
- DeKalb 17
- Randolph 16
- Franklin 15
- Greene 15
- Cleburne 14
- Geneva 11
- Bullock 10
- Blount 7
- Cherokee 7
- Chilton 7
- Pike 7
- Lamar 6
- Limestone 6
- Conecuh 5
- Talladega 5
- Tuscaloosa 5
- Bibb 3
- Chambers 3
- Dale 3
- Escambia 3
- Etowah 3
- Marengo 3
- Marion 3
- Russell 3
- Autauga 2
- Baldwin 2
- Shelby 2
- Tallapoosa 2
- …
state 1
- Alabama · 256 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
972418 | 972418 | 2021-01-28 | Russell | Alabama | 1113 | 3675 | 16 |
969173 | 969173 | 2021-01-27 | Russell | Alabama | 1113 | 3642 | 16 |
965929 | 965929 | 2021-01-26 | Russell | Alabama | 1113 | 3628 | 16 |
917230 | 917230 | 2021-01-11 | Lamar | Alabama | 1075 | 1146 | 16 |
913985 | 913985 | 2021-01-10 | Lamar | Alabama | 1075 | 1137 | 16 |
910740 | 910740 | 2021-01-09 | Lamar | Alabama | 1075 | 1132 | 16 |
907495 | 907495 | 2021-01-08 | Lamar | Alabama | 1075 | 1124 | 16 |
904249 | 904249 | 2021-01-07 | Lamar | Alabama | 1075 | 1114 | 16 |
901004 | 901004 | 2021-01-06 | Lamar | Alabama | 1075 | 1098 | 16 |
897736 | 897736 | 2021-01-05 | Cleburne | Alabama | 1029 | 1060 | 16 |
894490 | 894490 | 2021-01-04 | Cleburne | Alabama | 1029 | 1049 | 16 |
891244 | 891244 | 2021-01-03 | Cleburne | Alabama | 1029 | 1048 | 16 |
887997 | 887997 | 2021-01-02 | Cleburne | Alabama | 1029 | 1046 | 16 |
884752 | 884752 | 2021-01-01 | Cleburne | Alabama | 1029 | 1036 | 16 |
881507 | 881507 | 2020-12-31 | Cleburne | Alabama | 1029 | 1026 | 16 |
878262 | 878262 | 2020-12-30 | Cleburne | Alabama | 1029 | 1011 | 16 |
875017 | 875017 | 2020-12-29 | Cleburne | Alabama | 1029 | 1005 | 16 |
871772 | 871772 | 2020-12-28 | Cleburne | Alabama | 1029 | 999 | 16 |
868527 | 868527 | 2020-12-27 | Cleburne | Alabama | 1029 | 995 | 16 |
865282 | 865282 | 2020-12-26 | Cleburne | Alabama | 1029 | 993 | 16 |
862037 | 862037 | 2020-12-25 | Cleburne | Alabama | 1029 | 991 | 16 |
858792 | 858792 | 2020-12-24 | Cleburne | Alabama | 1029 | 986 | 16 |
855547 | 855547 | 2020-12-23 | Cleburne | Alabama | 1029 | 977 | 16 |
855550 | 855550 | 2020-12-23 | Conecuh | Alabama | 1035 | 817 | 16 |
852305 | 852305 | 2020-12-22 | Conecuh | Alabama | 1035 | 814 | 16 |
852318 | 852318 | 2020-12-22 | Geneva | Alabama | 1061 | 1521 | 16 |
849060 | 849060 | 2020-12-21 | Conecuh | Alabama | 1035 | 809 | 16 |
849073 | 849073 | 2020-12-21 | Geneva | Alabama | 1061 | 1497 | 16 |
845815 | 845815 | 2020-12-20 | Conecuh | Alabama | 1035 | 807 | 16 |
845828 | 845828 | 2020-12-20 | Geneva | Alabama | 1061 | 1488 | 16 |
842569 | 842569 | 2020-12-19 | Conecuh | Alabama | 1035 | 805 | 16 |
842582 | 842582 | 2020-12-19 | Geneva | Alabama | 1061 | 1483 | 16 |
839337 | 839337 | 2020-12-18 | Geneva | Alabama | 1061 | 1471 | 16 |
836092 | 836092 | 2020-12-17 | Geneva | Alabama | 1061 | 1453 | 16 |
832846 | 832846 | 2020-12-16 | Geneva | Alabama | 1061 | 1437 | 16 |
829597 | 829597 | 2020-12-15 | Fayette | Alabama | 1057 | 1199 | 16 |
829599 | 829599 | 2020-12-15 | Geneva | Alabama | 1061 | 1427 | 16 |
829623 | 829623 | 2020-12-15 | Pike | Alabama | 1109 | 1754 | 16 |
826351 | 826351 | 2020-12-14 | Fayette | Alabama | 1057 | 1176 | 16 |
826353 | 826353 | 2020-12-14 | Geneva | Alabama | 1061 | 1417 | 16 |
826377 | 826377 | 2020-12-14 | Pike | Alabama | 1109 | 1741 | 16 |
823104 | 823104 | 2020-12-13 | Fayette | Alabama | 1057 | 1168 | 16 |
823106 | 823106 | 2020-12-13 | Geneva | Alabama | 1061 | 1409 | 16 |
823130 | 823130 | 2020-12-13 | Pike | Alabama | 1109 | 1737 | 16 |
819858 | 819858 | 2020-12-12 | Fayette | Alabama | 1057 | 1160 | 16 |
819860 | 819860 | 2020-12-12 | Geneva | Alabama | 1061 | 1398 | 16 |
819884 | 819884 | 2020-12-12 | Pike | Alabama | 1109 | 1731 | 16 |
816612 | 816612 | 2020-12-11 | Fayette | Alabama | 1057 | 1143 | 16 |
816638 | 816638 | 2020-12-11 | Pike | Alabama | 1109 | 1723 | 16 |
813366 | 813366 | 2020-12-10 | Fayette | Alabama | 1057 | 1117 | 16 |
813392 | 813392 | 2020-12-10 | Pike | Alabama | 1109 | 1712 | 16 |
810122 | 810122 | 2020-12-09 | Fayette | Alabama | 1057 | 1099 | 16 |
810148 | 810148 | 2020-12-09 | Pike | Alabama | 1109 | 1697 | 16 |
806877 | 806877 | 2020-12-08 | Fayette | Alabama | 1057 | 1083 | 16 |
803632 | 803632 | 2020-12-07 | Fayette | Alabama | 1057 | 1069 | 16 |
800387 | 800387 | 2020-12-06 | Fayette | Alabama | 1057 | 1061 | 16 |
797142 | 797142 | 2020-12-05 | Fayette | Alabama | 1057 | 1045 | 16 |
793897 | 793897 | 2020-12-04 | Fayette | Alabama | 1057 | 1022 | 16 |
790652 | 790652 | 2020-12-03 | Fayette | Alabama | 1057 | 999 | 16 |
787407 | 787407 | 2020-12-02 | Fayette | Alabama | 1057 | 963 | 16 |
784163 | 784163 | 2020-12-01 | Fayette | Alabama | 1057 | 946 | 16 |
780918 | 780918 | 2020-11-30 | Fayette | Alabama | 1057 | 925 | 16 |
777672 | 777672 | 2020-11-29 | Fayette | Alabama | 1057 | 922 | 16 |
774427 | 774427 | 2020-11-28 | Fayette | Alabama | 1057 | 916 | 16 |
771182 | 771182 | 2020-11-27 | Fayette | Alabama | 1057 | 898 | 16 |
767936 | 767936 | 2020-11-26 | Fayette | Alabama | 1057 | 893 | 16 |
764691 | 764691 | 2020-11-25 | Fayette | Alabama | 1057 | 873 | 16 |
761446 | 761446 | 2020-11-24 | Fayette | Alabama | 1057 | 862 | 16 |
758201 | 758201 | 2020-11-23 | Fayette | Alabama | 1057 | 844 | 16 |
754954 | 754954 | 2020-11-22 | Fayette | Alabama | 1057 | 831 | 16 |
751708 | 751708 | 2020-11-21 | Fayette | Alabama | 1057 | 818 | 16 |
748462 | 748462 | 2020-11-20 | Fayette | Alabama | 1057 | 800 | 16 |
745216 | 745216 | 2020-11-19 | Fayette | Alabama | 1057 | 782 | 16 |
741950 | 741950 | 2020-11-18 | Cherokee | Alabama | 1019 | 935 | 16 |
741969 | 741969 | 2020-11-18 | Fayette | Alabama | 1057 | 766 | 16 |
712746 | 712746 | 2020-11-09 | Bibb | Alabama | 1007 | 932 | 16 |
709502 | 709502 | 2020-11-08 | Bibb | Alabama | 1007 | 926 | 16 |
706258 | 706258 | 2020-11-07 | Bibb | Alabama | 1007 | 924 | 16 |
703067 | 703067 | 2020-11-06 | Randolph | Alabama | 1111 | 883 | 16 |
699824 | 699824 | 2020-11-05 | Randolph | Alabama | 1111 | 879 | 16 |
696580 | 696580 | 2020-11-04 | Randolph | Alabama | 1111 | 876 | 16 |
693338 | 693338 | 2020-11-03 | Randolph | Alabama | 1111 | 871 | 16 |
690095 | 690095 | 2020-11-02 | Randolph | Alabama | 1111 | 870 | 16 |
686850 | 686850 | 2020-11-01 | Randolph | Alabama | 1111 | 865 | 16 |
683606 | 683606 | 2020-10-31 | Randolph | Alabama | 1111 | 859 | 16 |
680339 | 680339 | 2020-10-30 | Greene | Alabama | 1063 | 346 | 16 |
680363 | 680363 | 2020-10-30 | Randolph | Alabama | 1111 | 853 | 16 |
677096 | 677096 | 2020-10-29 | Greene | Alabama | 1063 | 345 | 16 |
677120 | 677120 | 2020-10-29 | Randolph | Alabama | 1111 | 846 | 16 |
673853 | 673853 | 2020-10-28 | Greene | Alabama | 1063 | 346 | 16 |
673877 | 673877 | 2020-10-28 | Randolph | Alabama | 1111 | 843 | 16 |
670611 | 670611 | 2020-10-27 | Greene | Alabama | 1063 | 346 | 16 |
670635 | 670635 | 2020-10-27 | Randolph | Alabama | 1111 | 835 | 16 |
667368 | 667368 | 2020-10-26 | Greene | Alabama | 1063 | 346 | 16 |
667392 | 667392 | 2020-10-26 | Randolph | Alabama | 1111 | 829 | 16 |
664123 | 664123 | 2020-10-25 | Greene | Alabama | 1063 | 342 | 16 |
664147 | 664147 | 2020-10-25 | Randolph | Alabama | 1111 | 827 | 16 |
660879 | 660879 | 2020-10-24 | Greene | Alabama | 1063 | 342 | 16 |
660903 | 660903 | 2020-10-24 | Randolph | Alabama | 1111 | 823 | 16 |
657635 | 657635 | 2020-10-23 | Greene | Alabama | 1063 | 342 | 16 |
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);