ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-03-15" 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 |
---|---|---|---|---|---|---|---|
1121671 | 1121671 | 2021-03-15 | Autauga | Alabama | 1001 | 6471 | 95 |
1121672 | 1121672 | 2021-03-15 | Baldwin | Alabama | 1003 | 20210 | 294 |
1121673 | 1121673 | 2021-03-15 | Barbour | Alabama | 1005 | 2195 | 53 |
1121674 | 1121674 | 2021-03-15 | Bibb | Alabama | 1007 | 2499 | 58 |
1121675 | 1121675 | 2021-03-15 | Blount | Alabama | 1009 | 6353 | 129 |
1121676 | 1121676 | 2021-03-15 | Bullock | Alabama | 1011 | 1193 | 39 |
1121677 | 1121677 | 2021-03-15 | Butler | Alabama | 1013 | 2066 | 66 |
1121678 | 1121678 | 2021-03-15 | Calhoun | Alabama | 1015 | 14105 | 301 |
1121679 | 1121679 | 2021-03-15 | Chambers | Alabama | 1017 | 3457 | 112 |
1121680 | 1121680 | 2021-03-15 | Cherokee | Alabama | 1019 | 1791 | 42 |
1121681 | 1121681 | 2021-03-15 | Chilton | Alabama | 1021 | 3976 | 106 |
1121682 | 1121682 | 2021-03-15 | Choctaw | Alabama | 1023 | 575 | 23 |
1121683 | 1121683 | 2021-03-15 | Clarke | Alabama | 1025 | 3467 | 56 |
1121684 | 1121684 | 2021-03-15 | Clay | Alabama | 1027 | 1477 | 54 |
1121685 | 1121685 | 2021-03-15 | Cleburne | Alabama | 1029 | 1436 | 41 |
1121686 | 1121686 | 2021-03-15 | Coffee | Alabama | 1031 | 5333 | 105 |
1121687 | 1121687 | 2021-03-15 | Colbert | Alabama | 1033 | 6097 | 125 |
1121688 | 1121688 | 2021-03-15 | Conecuh | Alabama | 1035 | 1081 | 25 |
1121689 | 1121689 | 2021-03-15 | Coosa | Alabama | 1037 | 940 | 24 |
1121690 | 1121690 | 2021-03-15 | Covington | Alabama | 1039 | 4019 | 108 |
1121691 | 1121691 | 2021-03-15 | Crenshaw | Alabama | 1041 | 1489 | 55 |
1121692 | 1121692 | 2021-03-15 | Cullman | Alabama | 1043 | 9224 | 184 |
1121693 | 1121693 | 2021-03-15 | Dale | Alabama | 1045 | 4718 | 108 |
1121694 | 1121694 | 2021-03-15 | Dallas | Alabama | 1047 | 3495 | 144 |
1121695 | 1121695 | 2021-03-15 | DeKalb | Alabama | 1049 | 8667 | 178 |
1121696 | 1121696 | 2021-03-15 | Elmore | Alabama | 1051 | 9716 | 196 |
1121697 | 1121697 | 2021-03-15 | Escambia | Alabama | 1053 | 3828 | 73 |
1121698 | 1121698 | 2021-03-15 | Etowah | Alabama | 1055 | 13545 | 335 |
1121699 | 1121699 | 2021-03-15 | Fayette | Alabama | 1057 | 2042 | 58 |
1121700 | 1121700 | 2021-03-15 | Franklin | Alabama | 1059 | 4171 | 82 |
1121701 | 1121701 | 2021-03-15 | Geneva | Alabama | 1061 | 2424 | 71 |
1121702 | 1121702 | 2021-03-15 | Greene | Alabama | 1063 | 889 | 32 |
1121703 | 1121703 | 2021-03-15 | Hale | Alabama | 1065 | 2136 | 72 |
1121704 | 1121704 | 2021-03-15 | Henry | Alabama | 1067 | 1845 | 42 |
1121705 | 1121705 | 2021-03-15 | Houston | Alabama | 1069 | 10227 | 267 |
1121706 | 1121706 | 2021-03-15 | Jackson | Alabama | 1071 | 6654 | 105 |
1121707 | 1121707 | 2021-03-15 | Jefferson | Alabama | 1073 | 73525 | 1425 |
1121708 | 1121708 | 2021-03-15 | Lamar | Alabama | 1075 | 1365 | 33 |
1121709 | 1121709 | 2021-03-15 | Lauderdale | Alabama | 1077 | 8962 | 216 |
1121710 | 1121710 | 2021-03-15 | Lawrence | Alabama | 1079 | 2903 | 92 |
1121711 | 1121711 | 2021-03-15 | Lee | Alabama | 1081 | 15197 | 163 |
1121712 | 1121712 | 2021-03-15 | Limestone | Alabama | 1083 | 9632 | 142 |
1121713 | 1121713 | 2021-03-15 | Lowndes | Alabama | 1085 | 1350 | 52 |
1121714 | 1121714 | 2021-03-15 | Macon | Alabama | 1087 | 1497 | 45 |
1121715 | 1121715 | 2021-03-15 | Madison | Alabama | 1089 | 33013 | 479 |
1121716 | 1121716 | 2021-03-15 | Marengo | Alabama | 1091 | 2476 | 58 |
1121717 | 1121717 | 2021-03-15 | Marion | Alabama | 1093 | 3011 | 98 |
1121718 | 1121718 | 2021-03-15 | Marshall | Alabama | 1095 | 11767 | 217 |
1121719 | 1121719 | 2021-03-15 | Mobile | Alabama | 1097 | 36932 | 755 |
1121720 | 1121720 | 2021-03-15 | Monroe | Alabama | 1099 | 1687 | 39 |
1121721 | 1121721 | 2021-03-15 | Montgomery | Alabama | 1101 | 23260 | 537 |
1121722 | 1121722 | 2021-03-15 | Morgan | Alabama | 1103 | 14013 | 258 |
1121723 | 1121723 | 2021-03-15 | Perry | Alabama | 1105 | 1075 | 27 |
1121724 | 1121724 | 2021-03-15 | Pickens | Alabama | 1107 | 2309 | 57 |
1121725 | 1121725 | 2021-03-15 | Pike | Alabama | 1109 | 2980 | 74 |
1121726 | 1121726 | 2021-03-15 | Randolph | Alabama | 1111 | 1709 | 41 |
1121727 | 1121727 | 2021-03-15 | Russell | Alabama | 1113 | 4138 | 34 |
1121728 | 1121728 | 2021-03-15 | Shelby | Alabama | 1117 | 22624 | 226 |
1121729 | 1121729 | 2021-03-15 | St. Clair | Alabama | 1115 | 9230 | 230 |
1121730 | 1121730 | 2021-03-15 | Sumter | Alabama | 1119 | 1018 | 31 |
1121731 | 1121731 | 2021-03-15 | Talladega | Alabama | 1121 | 7804 | 167 |
1121732 | 1121732 | 2021-03-15 | Tallapoosa | Alabama | 1123 | 3807 | 143 |
1121733 | 1121733 | 2021-03-15 | Tuscaloosa | Alabama | 1125 | 24607 | 431 |
1121734 | 1121734 | 2021-03-15 | Walker | Alabama | 1127 | 6973 | 268 |
1121735 | 1121735 | 2021-03-15 | Washington | Alabama | 1129 | 1627 | 38 |
1121736 | 1121736 | 2021-03-15 | Wilcox | Alabama | 1131 | 1248 | 26 |
1121737 | 1121737 | 2021-03-15 | Winston | Alabama | 1133 | 2679 | 69 |
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);