ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where "date" is on date 2020-04-10 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
45798 | 45798 | 2020-04-10 | Autauga | Alabama | 1001 | 17 | 1 |
45799 | 45799 | 2020-04-10 | Baldwin | Alabama | 1003 | 59 | 1 |
45800 | 45800 | 2020-04-10 | Barbour | Alabama | 1005 | 9 | 0 |
45801 | 45801 | 2020-04-10 | Bibb | Alabama | 1007 | 11 | 0 |
45802 | 45802 | 2020-04-10 | Blount | Alabama | 1009 | 12 | 0 |
45803 | 45803 | 2020-04-10 | Bullock | Alabama | 1011 | 4 | 0 |
45804 | 45804 | 2020-04-10 | Butler | Alabama | 1013 | 3 | 0 |
45805 | 45805 | 2020-04-10 | Calhoun | Alabama | 1015 | 54 | 0 |
45806 | 45806 | 2020-04-10 | Chambers | Alabama | 1017 | 171 | 8 |
45807 | 45807 | 2020-04-10 | Cherokee | Alabama | 1019 | 7 | 0 |
45808 | 45808 | 2020-04-10 | Chilton | Alabama | 1021 | 27 | 0 |
45809 | 45809 | 2020-04-10 | Choctaw | Alabama | 1023 | 7 | 0 |
45810 | 45810 | 2020-04-10 | Clarke | Alabama | 1025 | 13 | 0 |
45811 | 45811 | 2020-04-10 | Clay | Alabama | 1027 | 11 | 0 |
45812 | 45812 | 2020-04-10 | Cleburne | Alabama | 1029 | 12 | 0 |
45813 | 45813 | 2020-04-10 | Coffee | Alabama | 1031 | 14 | 0 |
45814 | 45814 | 2020-04-10 | Colbert | Alabama | 1033 | 8 | 1 |
45815 | 45815 | 2020-04-10 | Conecuh | Alabama | 1035 | 3 | 0 |
45816 | 45816 | 2020-04-10 | Coosa | Alabama | 1037 | 10 | 0 |
45817 | 45817 | 2020-04-10 | Covington | Alabama | 1039 | 10 | 0 |
45818 | 45818 | 2020-04-10 | Crenshaw | Alabama | 1041 | 2 | 0 |
45819 | 45819 | 2020-04-10 | Cullman | Alabama | 1043 | 30 | 1 |
45820 | 45820 | 2020-04-10 | Dale | Alabama | 1045 | 6 | 0 |
45821 | 45821 | 2020-04-10 | Dallas | Alabama | 1047 | 11 | 0 |
45822 | 45822 | 2020-04-10 | DeKalb | Alabama | 1049 | 18 | 0 |
45823 | 45823 | 2020-04-10 | Elmore | Alabama | 1051 | 30 | 0 |
45824 | 45824 | 2020-04-10 | Escambia | Alabama | 1053 | 6 | 0 |
45825 | 45825 | 2020-04-10 | Etowah | Alabama | 1055 | 64 | 5 |
45826 | 45826 | 2020-04-10 | Fayette | Alabama | 1057 | 2 | 0 |
45827 | 45827 | 2020-04-10 | Franklin | Alabama | 1059 | 8 | 0 |
45828 | 45828 | 2020-04-10 | Greene | Alabama | 1063 | 13 | 0 |
45829 | 45829 | 2020-04-10 | Hale | Alabama | 1065 | 7 | 0 |
45830 | 45830 | 2020-04-10 | Henry | Alabama | 1067 | 10 | 0 |
45831 | 45831 | 2020-04-10 | Houston | Alabama | 1069 | 33 | 1 |
45832 | 45832 | 2020-04-10 | Jackson | Alabama | 1071 | 22 | 2 |
45833 | 45833 | 2020-04-10 | Jefferson | Alabama | 1073 | 555 | 14 |
45834 | 45834 | 2020-04-10 | Lamar | Alabama | 1075 | 7 | 0 |
45835 | 45835 | 2020-04-10 | Lauderdale | Alabama | 1077 | 20 | 3 |
45836 | 45836 | 2020-04-10 | Lawrence | Alabama | 1079 | 8 | 0 |
45837 | 45837 | 2020-04-10 | Lee | Alabama | 1081 | 215 | 6 |
45838 | 45838 | 2020-04-10 | Limestone | Alabama | 1083 | 36 | 0 |
45839 | 45839 | 2020-04-10 | Lowndes | Alabama | 1085 | 12 | 0 |
45840 | 45840 | 2020-04-10 | Macon | Alabama | 1087 | 9 | 1 |
45841 | 45841 | 2020-04-10 | Madison | Alabama | 1089 | 177 | 3 |
45842 | 45842 | 2020-04-10 | Marengo | Alabama | 1091 | 15 | 1 |
45843 | 45843 | 2020-04-10 | Marion | Alabama | 1093 | 39 | 3 |
45844 | 45844 | 2020-04-10 | Marshall | Alabama | 1095 | 72 | 2 |
45845 | 45845 | 2020-04-10 | Mobile | Alabama | 1097 | 382 | 11 |
45846 | 45846 | 2020-04-10 | Monroe | Alabama | 1099 | 6 | 1 |
45847 | 45847 | 2020-04-10 | Montgomery | Alabama | 1101 | 92 | 4 |
45848 | 45848 | 2020-04-10 | Morgan | Alabama | 1103 | 36 | 0 |
45849 | 45849 | 2020-04-10 | Perry | Alabama | 1105 | 3 | 0 |
45850 | 45850 | 2020-04-10 | Pickens | Alabama | 1107 | 19 | 0 |
45851 | 45851 | 2020-04-10 | Pike | Alabama | 1109 | 18 | 0 |
45852 | 45852 | 2020-04-10 | Randolph | Alabama | 1111 | 22 | 3 |
45853 | 45853 | 2020-04-10 | Russell | Alabama | 1113 | 20 | 0 |
45854 | 45854 | 2020-04-10 | Shelby | Alabama | 1117 | 185 | 5 |
45855 | 45855 | 2020-04-10 | St. Clair | Alabama | 1115 | 37 | 0 |
45856 | 45856 | 2020-04-10 | Sumter | Alabama | 1119 | 18 | 0 |
45857 | 45857 | 2020-04-10 | Talladega | Alabama | 1121 | 32 | 0 |
45858 | 45858 | 2020-04-10 | Tallapoosa | Alabama | 1123 | 53 | 2 |
45859 | 45859 | 2020-04-10 | Tuscaloosa | Alabama | 1125 | 91 | 0 |
45860 | 45860 | 2020-04-10 | Walker | Alabama | 1127 | 72 | 0 |
45861 | 45861 | 2020-04-10 | Washington | Alabama | 1129 | 11 | 1 |
45862 | 45862 | 2020-04-10 | Wilcox | Alabama | 1131 | 18 | 0 |
45863 | 45863 | 2020-04-10 | Winston | Alabama | 1133 | 4 | 0 |
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);