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-17 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936664 | 936664 | 2021-01-17 | Autauga | Alabama | 1001 | 5184 | 55 |
936665 | 936665 | 2021-01-17 | Baldwin | Alabama | 1003 | 16251 | 182 |
936666 | 936666 | 2021-01-17 | Barbour | Alabama | 1005 | 1729 | 36 |
936667 | 936667 | 2021-01-17 | Bibb | Alabama | 1007 | 2151 | 47 |
936668 | 936668 | 2021-01-17 | Blount | Alabama | 1009 | 5304 | 83 |
936669 | 936669 | 2021-01-17 | Bullock | Alabama | 1011 | 990 | 28 |
936670 | 936670 | 2021-01-17 | Butler | Alabama | 1013 | 1696 | 58 |
936671 | 936671 | 2021-01-17 | Calhoun | Alabama | 1015 | 11122 | 200 |
936672 | 936672 | 2021-01-17 | Chambers | Alabama | 1017 | 2827 | 69 |
936673 | 936673 | 2021-01-17 | Cherokee | Alabama | 1019 | 1603 | 30 |
936674 | 936674 | 2021-01-17 | Chilton | Alabama | 1021 | 3361 | 65 |
936675 | 936675 | 2021-01-17 | Choctaw | Alabama | 1023 | 512 | 24 |
936676 | 936676 | 2021-01-17 | Clarke | Alabama | 1025 | 2814 | 33 |
936677 | 936677 | 2021-01-17 | Clay | Alabama | 1027 | 1261 | 45 |
936678 | 936678 | 2021-01-17 | Cleburne | Alabama | 1029 | 1174 | 23 |
936679 | 936679 | 2021-01-17 | Coffee | Alabama | 1031 | 4410 | 56 |
936680 | 936680 | 2021-01-17 | Colbert | Alabama | 1033 | 5320 | 73 |
936681 | 936681 | 2021-01-17 | Conecuh | Alabama | 1035 | 944 | 20 |
936682 | 936682 | 2021-01-17 | Coosa | Alabama | 1037 | 605 | 15 |
936683 | 936683 | 2021-01-17 | Covington | Alabama | 1039 | 3272 | 68 |
936684 | 936684 | 2021-01-17 | Crenshaw | Alabama | 1041 | 1187 | 44 |
936685 | 936685 | 2021-01-17 | Cullman | Alabama | 1043 | 8023 | 105 |
936686 | 936686 | 2021-01-17 | Dale | Alabama | 1045 | 3961 | 81 |
936687 | 936687 | 2021-01-17 | Dallas | Alabama | 1047 | 3031 | 96 |
936688 | 936688 | 2021-01-17 | DeKalb | Alabama | 1049 | 7683 | 97 |
936689 | 936689 | 2021-01-17 | Elmore | Alabama | 1051 | 7836 | 101 |
936690 | 936690 | 2021-01-17 | Escambia | Alabama | 1053 | 3168 | 42 |
936691 | 936691 | 2021-01-17 | Etowah | Alabama | 1055 | 11735 | 168 |
936692 | 936692 | 2021-01-17 | Fayette | Alabama | 1057 | 1682 | 26 |
936693 | 936693 | 2021-01-17 | Franklin | Alabama | 1059 | 3662 | 48 |
936694 | 936694 | 2021-01-17 | Geneva | Alabama | 1061 | 2014 | 35 |
936695 | 936695 | 2021-01-17 | Greene | Alabama | 1063 | 760 | 23 |
936696 | 936696 | 2021-01-17 | Hale | Alabama | 1065 | 1758 | 42 |
936697 | 936697 | 2021-01-17 | Henry | Alabama | 1067 | 1536 | 21 |
936698 | 936698 | 2021-01-17 | Houston | Alabama | 1069 | 8598 | 148 |
936699 | 936699 | 2021-01-17 | Jackson | Alabama | 1071 | 5803 | 41 |
936700 | 936700 | 2021-01-17 | Jefferson | Alabama | 1073 | 62039 | 921 |
936701 | 936701 | 2021-01-17 | Lamar | Alabama | 1075 | 1180 | 19 |
936702 | 936702 | 2021-01-17 | Lauderdale | Alabama | 1077 | 7546 | 83 |
936703 | 936703 | 2021-01-17 | Lawrence | Alabama | 1079 | 2436 | 47 |
936704 | 936704 | 2021-01-17 | Lee | Alabama | 1081 | 12465 | 101 |
936705 | 936705 | 2021-01-17 | Limestone | Alabama | 1083 | 8002 | 74 |
936706 | 936706 | 2021-01-17 | Lowndes | Alabama | 1085 | 1103 | 35 |
936707 | 936707 | 2021-01-17 | Macon | Alabama | 1087 | 1147 | 35 |
936708 | 936708 | 2021-01-17 | Madison | Alabama | 1089 | 27052 | 186 |
936709 | 936709 | 2021-01-17 | Marengo | Alabama | 1091 | 1990 | 29 |
936710 | 936710 | 2021-01-17 | Marion | Alabama | 1093 | 2456 | 50 |
936711 | 936711 | 2021-01-17 | Marshall | Alabama | 1095 | 10191 | 107 |
936712 | 936712 | 2021-01-17 | Mobile | Alabama | 1097 | 30225 | 548 |
936713 | 936713 | 2021-01-17 | Monroe | Alabama | 1099 | 1452 | 17 |
936714 | 936714 | 2021-01-17 | Montgomery | Alabama | 1101 | 18978 | 305 |
936715 | 936715 | 2021-01-17 | Morgan | Alabama | 1103 | 12233 | 113 |
936716 | 936716 | 2021-01-17 | Perry | Alabama | 1105 | 974 | 19 |
936717 | 936717 | 2021-01-17 | Pickens | Alabama | 1107 | 1965 | 31 |
936718 | 936718 | 2021-01-17 | Pike | Alabama | 1109 | 2487 | 29 |
936719 | 936719 | 2021-01-17 | Randolph | Alabama | 1111 | 1398 | 35 |
936720 | 936720 | 2021-01-17 | Russell | Alabama | 1113 | 3303 | 10 |
936721 | 936721 | 2021-01-17 | Shelby | Alabama | 1117 | 18504 | 114 |
936722 | 936722 | 2021-01-17 | St. Clair | Alabama | 1115 | 7535 | 120 |
936723 | 936723 | 2021-01-17 | Sumter | Alabama | 1119 | 890 | 26 |
936724 | 936724 | 2021-01-17 | Talladega | Alabama | 1121 | 6166 | 108 |
936725 | 936725 | 2021-01-17 | Tallapoosa | Alabama | 1123 | 2616 | 107 |
936726 | 936726 | 2021-01-17 | Tuscaloosa | Alabama | 1125 | 20728 | 267 |
936727 | 936727 | 2021-01-17 | Walker | Alabama | 1127 | 5897 | 174 |
936728 | 936728 | 2021-01-17 | Washington | Alabama | 1129 | 1376 | 26 |
936729 | 936729 | 2021-01-17 | Wilcox | Alabama | 1131 | 1031 | 21 |
936730 | 936730 | 2021-01-17 | Winston | Alabama | 1133 | 2266 | 35 |
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);