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-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 |
---|---|---|---|---|---|---|---|
910703 | 910703 | 2021-01-09 | Autauga | Alabama | 1001 | 4847 | 53 |
910704 | 910704 | 2021-01-09 | Baldwin | Alabama | 1003 | 15202 | 173 |
910705 | 910705 | 2021-01-09 | Barbour | Alabama | 1005 | 1648 | 35 |
910706 | 910706 | 2021-01-09 | Bibb | Alabama | 1007 | 2038 | 48 |
910707 | 910707 | 2021-01-09 | Blount | Alabama | 1009 | 5047 | 77 |
910708 | 910708 | 2021-01-09 | Bullock | Alabama | 1011 | 950 | 28 |
910709 | 910709 | 2021-01-09 | Butler | Alabama | 1013 | 1625 | 55 |
910710 | 910710 | 2021-01-09 | Calhoun | Alabama | 1015 | 10453 | 168 |
910711 | 910711 | 2021-01-09 | Chambers | Alabama | 1017 | 2620 | 63 |
910712 | 910712 | 2021-01-09 | Cherokee | Alabama | 1019 | 1523 | 24 |
910713 | 910713 | 2021-01-09 | Chilton | Alabama | 1021 | 3237 | 54 |
910714 | 910714 | 2021-01-09 | Choctaw | Alabama | 1023 | 500 | 22 |
910715 | 910715 | 2021-01-09 | Clarke | Alabama | 1025 | 2619 | 26 |
910716 | 910716 | 2021-01-09 | Clay | Alabama | 1027 | 1223 | 35 |
910717 | 910717 | 2021-01-09 | Cleburne | Alabama | 1029 | 1117 | 17 |
910718 | 910718 | 2021-01-09 | Coffee | Alabama | 1031 | 4106 | 42 |
910719 | 910719 | 2021-01-09 | Colbert | Alabama | 1033 | 5054 | 61 |
910720 | 910720 | 2021-01-09 | Conecuh | Alabama | 1035 | 905 | 18 |
910721 | 910721 | 2021-01-09 | Coosa | Alabama | 1037 | 578 | 9 |
910722 | 910722 | 2021-01-09 | Covington | Alabama | 1039 | 3145 | 43 |
910723 | 910723 | 2021-01-09 | Crenshaw | Alabama | 1041 | 1119 | 36 |
910724 | 910724 | 2021-01-09 | Cullman | Alabama | 1043 | 7666 | 78 |
910725 | 910725 | 2021-01-09 | Dale | Alabama | 1045 | 3687 | 64 |
910726 | 910726 | 2021-01-09 | Dallas | Alabama | 1047 | 2916 | 44 |
910727 | 910727 | 2021-01-09 | DeKalb | Alabama | 1049 | 7352 | 62 |
910728 | 910728 | 2021-01-09 | Elmore | Alabama | 1051 | 7334 | 85 |
910729 | 910729 | 2021-01-09 | Escambia | Alabama | 1053 | 2953 | 34 |
910730 | 910730 | 2021-01-09 | Etowah | Alabama | 1055 | 11058 | 106 |
910731 | 910731 | 2021-01-09 | Fayette | Alabama | 1057 | 1561 | 21 |
910732 | 910732 | 2021-01-09 | Franklin | Alabama | 1059 | 3514 | 39 |
910733 | 910733 | 2021-01-09 | Geneva | Alabama | 1061 | 1882 | 23 |
910734 | 910734 | 2021-01-09 | Greene | Alabama | 1063 | 726 | 20 |
910735 | 910735 | 2021-01-09 | Hale | Alabama | 1065 | 1656 | 41 |
910736 | 910736 | 2021-01-09 | Henry | Alabama | 1067 | 1424 | 10 |
910737 | 910737 | 2021-01-09 | Houston | Alabama | 1069 | 8112 | 72 |
910738 | 910738 | 2021-01-09 | Jackson | Alabama | 1071 | 5567 | 34 |
910739 | 910739 | 2021-01-09 | Jefferson | Alabama | 1073 | 58394 | 784 |
910740 | 910740 | 2021-01-09 | Lamar | Alabama | 1075 | 1132 | 16 |
910741 | 910741 | 2021-01-09 | Lauderdale | Alabama | 1077 | 7149 | 72 |
910742 | 910742 | 2021-01-09 | Lawrence | Alabama | 1079 | 2315 | 44 |
910743 | 910743 | 2021-01-09 | Lee | Alabama | 1081 | 11498 | 79 |
910744 | 910744 | 2021-01-09 | Limestone | Alabama | 1083 | 7548 | 60 |
910745 | 910745 | 2021-01-09 | Lowndes | Alabama | 1085 | 1046 | 34 |
910746 | 910746 | 2021-01-09 | Macon | Alabama | 1087 | 1082 | 35 |
910747 | 910747 | 2021-01-09 | Madison | Alabama | 1089 | 25219 | 177 |
910748 | 910748 | 2021-01-09 | Marengo | Alabama | 1091 | 1934 | 27 |
910749 | 910749 | 2021-01-09 | Marion | Alabama | 1093 | 2304 | 46 |
910750 | 910750 | 2021-01-09 | Marshall | Alabama | 1095 | 9819 | 92 |
910751 | 910751 | 2021-01-09 | Mobile | Alabama | 1097 | 28266 | 523 |
910752 | 910752 | 2021-01-09 | Monroe | Alabama | 1099 | 1378 | 12 |
910753 | 910753 | 2021-01-09 | Montgomery | Alabama | 1101 | 17916 | 282 |
910754 | 910754 | 2021-01-09 | Morgan | Alabama | 1103 | 11634 | 104 |
910755 | 910755 | 2021-01-09 | Perry | Alabama | 1105 | 925 | 19 |
910756 | 910756 | 2021-01-09 | Pickens | Alabama | 1107 | 1877 | 31 |
910757 | 910757 | 2021-01-09 | Pike | Alabama | 1109 | 2328 | 23 |
910758 | 910758 | 2021-01-09 | Randolph | Alabama | 1111 | 1334 | 32 |
910759 | 910759 | 2021-01-09 | Russell | Alabama | 1113 | 3052 | 7 |
910760 | 910760 | 2021-01-09 | Shelby | Alabama | 1117 | 17449 | 106 |
910761 | 910761 | 2021-01-09 | St. Clair | Alabama | 1115 | 7167 | 115 |
910762 | 910762 | 2021-01-09 | Sumter | Alabama | 1119 | 887 | 26 |
910763 | 910763 | 2021-01-09 | Talladega | Alabama | 1121 | 5766 | 109 |
910764 | 910764 | 2021-01-09 | Tallapoosa | Alabama | 1123 | 2540 | 107 |
910765 | 910765 | 2021-01-09 | Tuscaloosa | Alabama | 1125 | 20062 | 267 |
910766 | 910766 | 2021-01-09 | Walker | Alabama | 1127 | 5714 | 170 |
910767 | 910767 | 2021-01-09 | Washington | Alabama | 1129 | 1312 | 26 |
910768 | 910768 | 2021-01-09 | Wilcox | Alabama | 1131 | 964 | 20 |
910769 | 910769 | 2021-01-09 | Winston | Alabama | 1133 | 2175 | 34 |
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);