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 2020-11-09 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
712743 | 712743 | 2020-11-09 | Autauga | Alabama | 1001 | 2304 | 30 |
712744 | 712744 | 2020-11-09 | Baldwin | Alabama | 1003 | 7263 | 83 |
712745 | 712745 | 2020-11-09 | Barbour | Alabama | 1005 | 1098 | 9 |
712746 | 712746 | 2020-11-09 | Bibb | Alabama | 1007 | 932 | 16 |
712747 | 712747 | 2020-11-09 | Blount | Alabama | 1009 | 2335 | 26 |
712748 | 712748 | 2020-11-09 | Bullock | Alabama | 1011 | 664 | 17 |
712749 | 712749 | 2020-11-09 | Butler | Alabama | 1013 | 1054 | 41 |
712750 | 712750 | 2020-11-09 | Calhoun | Alabama | 1015 | 5217 | 67 |
712751 | 712751 | 2020-11-09 | Chambers | Alabama | 1017 | 1489 | 48 |
712752 | 712752 | 2020-11-09 | Cherokee | Alabama | 1019 | 845 | 15 |
712753 | 712753 | 2020-11-09 | Chilton | Alabama | 1021 | 2018 | 35 |
712754 | 712754 | 2020-11-09 | Choctaw | Alabama | 1023 | 407 | 12 |
712755 | 712755 | 2020-11-09 | Clarke | Alabama | 1025 | 1449 | 18 |
712756 | 712756 | 2020-11-09 | Clay | Alabama | 1027 | 817 | 13 |
712757 | 712757 | 2020-11-09 | Cleburne | Alabama | 1029 | 629 | 11 |
712758 | 712758 | 2020-11-09 | Coffee | Alabama | 1031 | 2000 | 12 |
712759 | 712759 | 2020-11-09 | Colbert | Alabama | 1033 | 2479 | 33 |
712760 | 712760 | 2020-11-09 | Conecuh | Alabama | 1035 | 607 | 13 |
712761 | 712761 | 2020-11-09 | Coosa | Alabama | 1037 | 236 | 3 |
712762 | 712762 | 2020-11-09 | Covington | Alabama | 1039 | 1944 | 32 |
712763 | 712763 | 2020-11-09 | Crenshaw | Alabama | 1041 | 648 | 30 |
712764 | 712764 | 2020-11-09 | Cullman | Alabama | 1043 | 3246 | 27 |
712765 | 712765 | 2020-11-09 | Dale | Alabama | 1045 | 2057 | 55 |
712766 | 712766 | 2020-11-09 | Dallas | Alabama | 1047 | 1987 | 27 |
712767 | 712767 | 2020-11-09 | DeKalb | Alabama | 1049 | 3911 | 32 |
712768 | 712768 | 2020-11-09 | Elmore | Alabama | 1051 | 3477 | 59 |
712769 | 712769 | 2020-11-09 | Escambia | Alabama | 1053 | 1830 | 31 |
712770 | 712770 | 2020-11-09 | Etowah | Alabama | 1055 | 4925 | 58 |
712771 | 712771 | 2020-11-09 | Fayette | Alabama | 1057 | 678 | 15 |
712772 | 712772 | 2020-11-09 | Franklin | Alabama | 1059 | 2257 | 34 |
712773 | 712773 | 2020-11-09 | Geneva | Alabama | 1061 | 1032 | 8 |
712774 | 712774 | 2020-11-09 | Greene | Alabama | 1063 | 362 | 17 |
712775 | 712775 | 2020-11-09 | Hale | Alabama | 1065 | 833 | 30 |
712776 | 712776 | 2020-11-09 | Henry | Alabama | 1067 | 782 | 6 |
712777 | 712777 | 2020-11-09 | Houston | Alabama | 1069 | 4516 | 36 |
712778 | 712778 | 2020-11-09 | Jackson | Alabama | 1071 | 2491 | 22 |
712779 | 712779 | 2020-11-09 | Jefferson | Alabama | 1073 | 26003 | 403 |
712780 | 712780 | 2020-11-09 | Lamar | Alabama | 1075 | 559 | 7 |
712781 | 712781 | 2020-11-09 | Lauderdale | Alabama | 1077 | 2963 | 47 |
712782 | 712782 | 2020-11-09 | Lawrence | Alabama | 1079 | 1007 | 35 |
712783 | 712783 | 2020-11-09 | Lee | Alabama | 1081 | 6926 | 65 |
712784 | 712784 | 2020-11-09 | Limestone | Alabama | 1083 | 3380 | 37 |
712785 | 712785 | 2020-11-09 | Lowndes | Alabama | 1085 | 745 | 29 |
712786 | 712786 | 2020-11-09 | Macon | Alabama | 1087 | 612 | 20 |
712787 | 712787 | 2020-11-09 | Madison | Alabama | 1089 | 10459 | 105 |
712788 | 712788 | 2020-11-09 | Marengo | Alabama | 1091 | 1099 | 24 |
712789 | 712789 | 2020-11-09 | Marion | Alabama | 1093 | 1215 | 31 |
712790 | 712790 | 2020-11-09 | Marshall | Alabama | 1095 | 4864 | 53 |
712791 | 712791 | 2020-11-09 | Mobile | Alabama | 1097 | 17807 | 328 |
712792 | 712792 | 2020-11-09 | Monroe | Alabama | 1099 | 692 | 10 |
712793 | 712793 | 2020-11-09 | Montgomery | Alabama | 1101 | 11175 | 219 |
712794 | 712794 | 2020-11-09 | Morgan | Alabama | 1103 | 4924 | 40 |
712795 | 712795 | 2020-11-09 | Perry | Alabama | 1105 | 619 | 6 |
712796 | 712796 | 2020-11-09 | Pickens | Alabama | 1107 | 1008 | 18 |
712797 | 712797 | 2020-11-09 | Pike | Alabama | 1109 | 1431 | 14 |
712798 | 712798 | 2020-11-09 | Randolph | Alabama | 1111 | 895 | 18 |
712799 | 712799 | 2020-11-09 | Russell | Alabama | 1113 | 2022 | 3 |
712800 | 712800 | 2020-11-09 | Shelby | Alabama | 1117 | 8319 | 71 |
712801 | 712801 | 2020-11-09 | St. Clair | Alabama | 1115 | 3499 | 52 |
712802 | 712802 | 2020-11-09 | Sumter | Alabama | 1119 | 510 | 21 |
712803 | 712803 | 2020-11-09 | Talladega | Alabama | 1121 | 2953 | 40 |
712804 | 712804 | 2020-11-09 | Tallapoosa | Alabama | 1123 | 1486 | 87 |
712805 | 712805 | 2020-11-09 | Tuscaloosa | Alabama | 1125 | 11260 | 146 |
712806 | 712806 | 2020-11-09 | Walker | Alabama | 1127 | 3152 | 96 |
712807 | 712807 | 2020-11-09 | Washington | Alabama | 1129 | 818 | 12 |
712808 | 712808 | 2020-11-09 | Wilcox | Alabama | 1131 | 593 | 12 |
712809 | 712809 | 2020-11-09 | Winston | Alabama | 1133 | 1043 | 14 |
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);