ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-08-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 |
---|---|---|---|---|---|---|---|
440691 | 440691 | 2020-08-17 | Autauga | Alabama | 1001 | 1274 | 23 |
440692 | 440692 | 2020-08-17 | Baldwin | Alabama | 1003 | 3960 | 32 |
440693 | 440693 | 2020-08-17 | Barbour | Alabama | 1005 | 672 | 6 |
440694 | 440694 | 2020-08-17 | Bibb | Alabama | 1007 | 488 | 6 |
440695 | 440695 | 2020-08-17 | Blount | Alabama | 1009 | 1008 | 5 |
440696 | 440696 | 2020-08-17 | Bullock | Alabama | 1011 | 504 | 14 |
440697 | 440697 | 2020-08-17 | Butler | Alabama | 1013 | 814 | 37 |
440698 | 440698 | 2020-08-17 | Calhoun | Alabama | 1015 | 2055 | 23 |
440699 | 440699 | 2020-08-17 | Chambers | Alabama | 1017 | 928 | 38 |
440700 | 440700 | 2020-08-17 | Cherokee | Alabama | 1019 | 340 | 9 |
440701 | 440701 | 2020-08-17 | Chilton | Alabama | 1021 | 920 | 12 |
440702 | 440702 | 2020-08-17 | Choctaw | Alabama | 1023 | 304 | 12 |
440703 | 440703 | 2020-08-17 | Clarke | Alabama | 1025 | 875 | 10 |
440704 | 440704 | 2020-08-17 | Clay | Alabama | 1027 | 317 | 5 |
440705 | 440705 | 2020-08-17 | Cleburne | Alabama | 1029 | 138 | 1 |
440706 | 440706 | 2020-08-17 | Coffee | Alabama | 1031 | 868 | 6 |
440707 | 440707 | 2020-08-17 | Colbert | Alabama | 1033 | 1304 | 18 |
440708 | 440708 | 2020-08-17 | Conecuh | Alabama | 1035 | 433 | 10 |
440709 | 440709 | 2020-08-17 | Coosa | Alabama | 1037 | 122 | 3 |
440710 | 440710 | 2020-08-17 | Covington | Alabama | 1039 | 937 | 24 |
440711 | 440711 | 2020-08-17 | Crenshaw | Alabama | 1041 | 390 | 10 |
440712 | 440712 | 2020-08-17 | Cullman | Alabama | 1043 | 1395 | 12 |
440713 | 440713 | 2020-08-17 | Dale | Alabama | 1045 | 914 | 30 |
440714 | 440714 | 2020-08-17 | Dallas | Alabama | 1047 | 1482 | 25 |
440715 | 440715 | 2020-08-17 | DeKalb | Alabama | 1049 | 1962 | 17 |
440716 | 440716 | 2020-08-17 | Elmore | Alabama | 1051 | 1914 | 41 |
440717 | 440717 | 2020-08-17 | Escambia | Alabama | 1053 | 1250 | 17 |
440718 | 440718 | 2020-08-17 | Etowah | Alabama | 1055 | 2384 | 36 |
440719 | 440719 | 2020-08-17 | Fayette | Alabama | 1057 | 264 | 5 |
440720 | 440720 | 2020-08-17 | Franklin | Alabama | 1059 | 1377 | 22 |
440721 | 440721 | 2020-08-17 | Geneva | Alabama | 1061 | 308 | 3 |
440722 | 440722 | 2020-08-17 | Greene | Alabama | 1063 | 263 | 13 |
440723 | 440723 | 2020-08-17 | Hale | Alabama | 1065 | 519 | 26 |
440724 | 440724 | 2020-08-17 | Henry | Alabama | 1067 | 293 | 4 |
440725 | 440725 | 2020-08-17 | Houston | Alabama | 1069 | 1594 | 15 |
440726 | 440726 | 2020-08-17 | Jackson | Alabama | 1071 | 1168 | 7 |
440727 | 440727 | 2020-08-17 | Jefferson | Alabama | 1073 | 14379 | 264 |
440728 | 440728 | 2020-08-17 | Lamar | Alabama | 1075 | 255 | 2 |
440729 | 440729 | 2020-08-17 | Lauderdale | Alabama | 1077 | 1257 | 21 |
440730 | 440730 | 2020-08-17 | Lawrence | Alabama | 1079 | 383 | 3 |
440731 | 440731 | 2020-08-17 | Lee | Alabama | 1081 | 3029 | 51 |
440732 | 440732 | 2020-08-17 | Limestone | Alabama | 1083 | 1486 | 14 |
440733 | 440733 | 2020-08-17 | Lowndes | Alabama | 1085 | 595 | 26 |
440734 | 440734 | 2020-08-17 | Macon | Alabama | 1087 | 366 | 15 |
440735 | 440735 | 2020-08-17 | Madison | Alabama | 1089 | 5872 | 42 |
440736 | 440736 | 2020-08-17 | Marengo | Alabama | 1091 | 604 | 18 |
440737 | 440737 | 2020-08-17 | Marion | Alabama | 1093 | 659 | 27 |
440738 | 440738 | 2020-08-17 | Marshall | Alabama | 1095 | 3348 | 39 |
440739 | 440739 | 2020-08-17 | Mobile | Alabama | 1097 | 11177 | 233 |
440740 | 440740 | 2020-08-17 | Monroe | Alabama | 1099 | 501 | 7 |
440741 | 440741 | 2020-08-17 | Montgomery | Alabama | 1101 | 7317 | 156 |
440742 | 440742 | 2020-08-17 | Morgan | Alabama | 1103 | 2563 | 23 |
440743 | 440743 | 2020-08-17 | Perry | Alabama | 1105 | 491 | 4 |
440744 | 440744 | 2020-08-17 | Pickens | Alabama | 1107 | 457 | 11 |
440745 | 440745 | 2020-08-17 | Pike | Alabama | 1109 | 791 | 8 |
440746 | 440746 | 2020-08-17 | Randolph | Alabama | 1111 | 432 | 12 |
440747 | 440747 | 2020-08-17 | Russell | Alabama | 1113 | 1445 | 2 |
440748 | 440748 | 2020-08-17 | Shelby | Alabama | 1117 | 3760 | 40 |
440749 | 440749 | 2020-08-17 | St. Clair | Alabama | 1115 | 1535 | 23 |
440750 | 440750 | 2020-08-17 | Sumter | Alabama | 1119 | 385 | 19 |
440751 | 440751 | 2020-08-17 | Talladega | Alabama | 1121 | 1432 | 16 |
440752 | 440752 | 2020-08-17 | Tallapoosa | Alabama | 1123 | 973 | 80 |
440753 | 440753 | 2020-08-17 | Tuscaloosa | Alabama | 1125 | 4639 | 88 |
440754 | 440754 | 2020-08-17 | Walker | Alabama | 1127 | 1684 | 69 |
440755 | 440755 | 2020-08-17 | Washington | Alabama | 1129 | 479 | 14 |
440756 | 440756 | 2020-08-17 | Wilcox | Alabama | 1131 | 476 | 10 |
440757 | 440757 | 2020-08-17 | Winston | Alabama | 1133 | 496 | 11 |
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);