ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2021-01-05 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
897722 | 897722 | 2021-01-05 | Autauga | Alabama | 1001 | 4546 | 50 |
897723 | 897723 | 2021-01-05 | Baldwin | Alabama | 1003 | 14440 | 169 |
897724 | 897724 | 2021-01-05 | Barbour | Alabama | 1005 | 1575 | 33 |
897725 | 897725 | 2021-01-05 | Bibb | Alabama | 1007 | 1923 | 46 |
897726 | 897726 | 2021-01-05 | Blount | Alabama | 1009 | 4849 | 63 |
897727 | 897727 | 2021-01-05 | Bullock | Alabama | 1011 | 920 | 22 |
897728 | 897728 | 2021-01-05 | Butler | Alabama | 1013 | 1574 | 45 |
897729 | 897729 | 2021-01-05 | Calhoun | Alabama | 1015 | 9975 | 157 |
897730 | 897730 | 2021-01-05 | Chambers | Alabama | 1017 | 2474 | 63 |
897731 | 897731 | 2021-01-05 | Cherokee | Alabama | 1019 | 1454 | 22 |
897732 | 897732 | 2021-01-05 | Chilton | Alabama | 1021 | 3085 | 54 |
897733 | 897733 | 2021-01-05 | Choctaw | Alabama | 1023 | 493 | 22 |
897734 | 897734 | 2021-01-05 | Clarke | Alabama | 1025 | 2483 | 26 |
897735 | 897735 | 2021-01-05 | Clay | Alabama | 1027 | 1179 | 34 |
897736 | 897736 | 2021-01-05 | Cleburne | Alabama | 1029 | 1060 | 16 |
897737 | 897737 | 2021-01-05 | Coffee | Alabama | 1031 | 3788 | 38 |
897738 | 897738 | 2021-01-05 | Colbert | Alabama | 1033 | 4818 | 60 |
897739 | 897739 | 2021-01-05 | Conecuh | Alabama | 1035 | 880 | 17 |
897740 | 897740 | 2021-01-05 | Coosa | Alabama | 1037 | 545 | 7 |
897741 | 897741 | 2021-01-05 | Covington | Alabama | 1039 | 3007 | 40 |
897742 | 897742 | 2021-01-05 | Crenshaw | Alabama | 1041 | 1025 | 36 |
897743 | 897743 | 2021-01-05 | Cullman | Alabama | 1043 | 7370 | 78 |
897744 | 897744 | 2021-01-05 | Dale | Alabama | 1045 | 3491 | 64 |
897745 | 897745 | 2021-01-05 | Dallas | Alabama | 1047 | 2867 | 44 |
897746 | 897746 | 2021-01-05 | DeKalb | Alabama | 1049 | 7070 | 61 |
897747 | 897747 | 2021-01-05 | Elmore | Alabama | 1051 | 6958 | 83 |
897748 | 897748 | 2021-01-05 | Escambia | Alabama | 1053 | 2819 | 34 |
897749 | 897749 | 2021-01-05 | Etowah | Alabama | 1055 | 10465 | 96 |
897750 | 897750 | 2021-01-05 | Fayette | Alabama | 1057 | 1487 | 20 |
897751 | 897751 | 2021-01-05 | Franklin | Alabama | 1059 | 3355 | 38 |
897752 | 897752 | 2021-01-05 | Geneva | Alabama | 1061 | 1771 | 20 |
897753 | 897753 | 2021-01-05 | Greene | Alabama | 1063 | 700 | 20 |
897754 | 897754 | 2021-01-05 | Hale | Alabama | 1065 | 1528 | 33 |
897755 | 897755 | 2021-01-05 | Henry | Alabama | 1067 | 1322 | 8 |
897756 | 897756 | 2021-01-05 | Houston | Alabama | 1069 | 7698 | 64 |
897757 | 897757 | 2021-01-05 | Jackson | Alabama | 1071 | 5324 | 34 |
897758 | 897758 | 2021-01-05 | Jefferson | Alabama | 1073 | 55344 | 725 |
897759 | 897759 | 2021-01-05 | Lamar | Alabama | 1075 | 1083 | 15 |
897760 | 897760 | 2021-01-05 | Lauderdale | Alabama | 1077 | 6766 | 70 |
897761 | 897761 | 2021-01-05 | Lawrence | Alabama | 1079 | 2149 | 43 |
897762 | 897762 | 2021-01-05 | Lee | Alabama | 1081 | 10765 | 75 |
897763 | 897763 | 2021-01-05 | Limestone | Alabama | 1083 | 7132 | 58 |
897764 | 897764 | 2021-01-05 | Lowndes | Alabama | 1085 | 995 | 32 |
897765 | 897765 | 2021-01-05 | Macon | Alabama | 1087 | 1041 | 30 |
897766 | 897766 | 2021-01-05 | Madison | Alabama | 1089 | 23840 | 179 |
897767 | 897767 | 2021-01-05 | Marengo | Alabama | 1091 | 1848 | 26 |
897768 | 897768 | 2021-01-05 | Marion | Alabama | 1093 | 2190 | 43 |
897769 | 897769 | 2021-01-05 | Marshall | Alabama | 1095 | 9401 | 86 |
897770 | 897770 | 2021-01-05 | Mobile | Alabama | 1097 | 27099 | 511 |
897771 | 897771 | 2021-01-05 | Monroe | Alabama | 1099 | 1271 | 11 |
897772 | 897772 | 2021-01-05 | Montgomery | Alabama | 1101 | 17061 | 276 |
897773 | 897773 | 2021-01-05 | Morgan | Alabama | 1103 | 11118 | 90 |
897774 | 897774 | 2021-01-05 | Perry | Alabama | 1105 | 890 | 10 |
897775 | 897775 | 2021-01-05 | Pickens | Alabama | 1107 | 1798 | 26 |
897776 | 897776 | 2021-01-05 | Pike | Alabama | 1109 | 2073 | 23 |
897777 | 897777 | 2021-01-05 | Randolph | Alabama | 1111 | 1290 | 30 |
897778 | 897778 | 2021-01-05 | Russell | Alabama | 1113 | 2903 | 6 |
897779 | 897779 | 2021-01-05 | Shelby | Alabama | 1117 | 16622 | 103 |
897780 | 897780 | 2021-01-05 | St. Clair | Alabama | 1115 | 6873 | 73 |
897781 | 897781 | 2021-01-05 | Sumter | Alabama | 1119 | 874 | 24 |
897782 | 897782 | 2021-01-05 | Talladega | Alabama | 1121 | 5466 | 77 |
897783 | 897783 | 2021-01-05 | Tallapoosa | Alabama | 1123 | 2464 | 98 |
897784 | 897784 | 2021-01-05 | Tuscaloosa | Alabama | 1125 | 19288 | 218 |
897785 | 897785 | 2021-01-05 | Walker | Alabama | 1127 | 5421 | 138 |
897786 | 897786 | 2021-01-05 | Washington | Alabama | 1129 | 1244 | 24 |
897787 | 897787 | 2021-01-05 | Wilcox | Alabama | 1131 | 904 | 19 |
897788 | 897788 | 2021-01-05 | Winston | Alabama | 1133 | 2062 | 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);