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-09-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 |
---|---|---|---|---|---|---|---|
1699655 | 1699655 | 2021-09-09 | Autauga | Alabama | 1001 | 9145 | 119 |
1699656 | 1699656 | 2021-09-09 | Baldwin | Alabama | 1003 | 34536 | 402 |
1699657 | 1699657 | 2021-09-09 | Barbour | Alabama | 1005 | 3243 | 65 |
1699658 | 1699658 | 2021-09-09 | Bibb | Alabama | 1007 | 3727 | 74 |
1699659 | 1699659 | 2021-09-09 | Blount | Alabama | 1009 | 9048 | 147 |
1699660 | 1699660 | 2021-09-09 | Bullock | Alabama | 1011 | 1434 | 42 |
1699661 | 1699661 | 2021-09-09 | Butler | Alabama | 1013 | 2952 | 76 |
1699662 | 1699662 | 2021-09-09 | Calhoun | Alabama | 1015 | 18910 | 356 |
1699663 | 1699663 | 2021-09-09 | Chambers | Alabama | 1017 | 4994 | 127 |
1699664 | 1699664 | 2021-09-09 | Cherokee | Alabama | 1019 | 2662 | 49 |
1699665 | 1699665 | 2021-09-09 | Chilton | Alabama | 1021 | 5965 | 123 |
1699666 | 1699666 | 2021-09-09 | Choctaw | Alabama | 1023 | 708 | 25 |
1699667 | 1699667 | 2021-09-09 | Clarke | Alabama | 1025 | 4382 | 68 |
1699668 | 1699668 | 2021-09-09 | Clay | Alabama | 1027 | 2113 | 60 |
1699669 | 1699669 | 2021-09-09 | Cleburne | Alabama | 1029 | 2003 | 46 |
1699670 | 1699670 | 2021-09-09 | Coffee | Alabama | 1031 | 8333 | 148 |
1699671 | 1699671 | 2021-09-09 | Colbert | Alabama | 1033 | 8039 | 158 |
1699672 | 1699672 | 2021-09-09 | Conecuh | Alabama | 1035 | 1665 | 36 |
1699673 | 1699673 | 2021-09-09 | Coosa | Alabama | 1037 | 1528 | 31 |
1699674 | 1699674 | 2021-09-09 | Covington | Alabama | 1039 | 6033 | 152 |
1699675 | 1699675 | 2021-09-09 | Crenshaw | Alabama | 1041 | 2205 | 62 |
1699676 | 1699676 | 2021-09-09 | Cullman | Alabama | 1043 | 13198 | 224 |
1699677 | 1699677 | 2021-09-09 | Dale | Alabama | 1045 | 7940 | 139 |
1699678 | 1699678 | 2021-09-09 | Dallas | Alabama | 1047 | 4472 | 171 |
1699679 | 1699679 | 2021-09-09 | DeKalb | Alabama | 1049 | 11416 | 214 |
1699680 | 1699680 | 2021-09-09 | Elmore | Alabama | 1051 | 13485 | 235 |
1699681 | 1699681 | 2021-09-09 | Escambia | Alabama | 1053 | 6065 | 96 |
1699682 | 1699682 | 2021-09-09 | Etowah | Alabama | 1055 | 17962 | 400 |
1699683 | 1699683 | 2021-09-09 | Fayette | Alabama | 1057 | 2593 | 66 |
1699684 | 1699684 | 2021-09-09 | Franklin | Alabama | 1059 | 5490 | 91 |
1699685 | 1699685 | 2021-09-09 | Geneva | Alabama | 1061 | 3986 | 96 |
1699686 | 1699686 | 2021-09-09 | Greene | Alabama | 1063 | 1170 | 40 |
1699687 | 1699687 | 2021-09-09 | Hale | Alabama | 1065 | 2786 | 81 |
1699688 | 1699688 | 2021-09-09 | Henry | Alabama | 1067 | 2791 | 48 |
1699689 | 1699689 | 2021-09-09 | Houston | Alabama | 1069 | 15488 | 327 |
1699690 | 1699690 | 2021-09-09 | Jackson | Alabama | 1071 | 8662 | 131 |
1699691 | 1699691 | 2021-09-09 | Jefferson | Alabama | 1073 | 105851 | 1687 |
1699692 | 1699692 | 2021-09-09 | Lamar | Alabama | 1075 | 1777 | 38 |
1699693 | 1699693 | 2021-09-09 | Lauderdale | Alabama | 1077 | 12500 | 261 |
1699694 | 1699694 | 2021-09-09 | Lawrence | Alabama | 1079 | 3922 | 100 |
1699695 | 1699695 | 2021-09-09 | Lee | Alabama | 1081 | 21019 | 198 |
1699696 | 1699696 | 2021-09-09 | Limestone | Alabama | 1083 | 13351 | 175 |
1699697 | 1699697 | 2021-09-09 | Lowndes | Alabama | 1085 | 1651 | 55 |
1699698 | 1699698 | 2021-09-09 | Macon | Alabama | 1087 | 2054 | 54 |
1699699 | 1699699 | 2021-09-09 | Madison | Alabama | 1089 | 46133 | 557 |
1699700 | 1699700 | 2021-09-09 | Marengo | Alabama | 1091 | 3111 | 75 |
1699701 | 1699701 | 2021-09-09 | Marion | Alabama | 1093 | 4332 | 112 |
1699702 | 1699702 | 2021-09-09 | Marshall | Alabama | 1095 | 16531 | 249 |
1699703 | 1699703 | 2021-09-09 | Mobile | Alabama | 1097 | 67486 | 1111 |
1699704 | 1699704 | 2021-09-09 | Monroe | Alabama | 1099 | 2967 | 44 |
1699705 | 1699705 | 2021-09-09 | Montgomery | Alabama | 1101 | 31559 | 640 |
1699706 | 1699706 | 2021-09-09 | Morgan | Alabama | 1103 | 18448 | 306 |
1699707 | 1699707 | 2021-09-09 | Perry | Alabama | 1105 | 1301 | 30 |
1699708 | 1699708 | 2021-09-09 | Pickens | Alabama | 1107 | 2896 | 64 |
1699709 | 1699709 | 2021-09-09 | Pike | Alabama | 1109 | 4214 | 86 |
1699710 | 1699710 | 2021-09-09 | Randolph | Alabama | 1111 | 2747 | 54 |
1699711 | 1699711 | 2021-09-09 | Russell | Alabama | 1113 | 5716 | 51 |
1699712 | 1699712 | 2021-09-09 | Shelby | Alabama | 1117 | 33849 | 279 |
1699713 | 1699713 | 2021-09-09 | St. Clair | Alabama | 1115 | 14218 | 263 |
1699714 | 1699714 | 2021-09-09 | Sumter | Alabama | 1119 | 1205 | 35 |
1699715 | 1699715 | 2021-09-09 | Talladega | Alabama | 1121 | 11572 | 196 |
1699716 | 1699716 | 2021-09-09 | Tallapoosa | Alabama | 1123 | 5976 | 163 |
1699717 | 1699717 | 2021-09-09 | Tuscaloosa | Alabama | 1125 | 31649 | 489 |
1699718 | 1699718 | 2021-09-09 | Walker | Alabama | 1127 | 9638 | 300 |
1699719 | 1699719 | 2021-09-09 | Washington | Alabama | 1129 | 2369 | 43 |
1699720 | 1699720 | 2021-09-09 | Wilcox | Alabama | 1131 | 1501 | 33 |
1699721 | 1699721 | 2021-09-09 | Winston | Alabama | 1133 | 3846 | 79 |
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);