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 2020-05-03 and state = "Alabama" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
109605 | 109605 | 2020-05-03 | Autauga | Alabama | 1001 | 48 | 3 |
109606 | 109606 | 2020-05-03 | Baldwin | Alabama | 1003 | 187 | 4 |
109607 | 109607 | 2020-05-03 | Barbour | Alabama | 1005 | 45 | 1 |
109608 | 109608 | 2020-05-03 | Bibb | Alabama | 1007 | 43 | 0 |
109609 | 109609 | 2020-05-03 | Blount | Alabama | 1009 | 40 | 0 |
109610 | 109610 | 2020-05-03 | Bullock | Alabama | 1011 | 14 | 0 |
109611 | 109611 | 2020-05-03 | Butler | Alabama | 1013 | 105 | 1 |
109612 | 109612 | 2020-05-03 | Calhoun | Alabama | 1015 | 105 | 3 |
109613 | 109613 | 2020-05-03 | Chambers | Alabama | 1017 | 300 | 21 |
109614 | 109614 | 2020-05-03 | Cherokee | Alabama | 1019 | 16 | 0 |
109615 | 109615 | 2020-05-03 | Chilton | Alabama | 1021 | 57 | 1 |
109616 | 109616 | 2020-05-03 | Choctaw | Alabama | 1023 | 49 | 0 |
109617 | 109617 | 2020-05-03 | Clarke | Alabama | 1025 | 42 | 1 |
109618 | 109618 | 2020-05-03 | Clay | Alabama | 1027 | 22 | 1 |
109619 | 109619 | 2020-05-03 | Cleburne | Alabama | 1029 | 12 | 1 |
109620 | 109620 | 2020-05-03 | Coffee | Alabama | 1031 | 130 | 0 |
109621 | 109621 | 2020-05-03 | Colbert | Alabama | 1033 | 41 | 2 |
109622 | 109622 | 2020-05-03 | Conecuh | Alabama | 1035 | 9 | 0 |
109623 | 109623 | 2020-05-03 | Coosa | Alabama | 1037 | 30 | 1 |
109624 | 109624 | 2020-05-03 | Covington | Alabama | 1039 | 45 | 1 |
109625 | 109625 | 2020-05-03 | Crenshaw | Alabama | 1041 | 23 | 0 |
109626 | 109626 | 2020-05-03 | Cullman | Alabama | 1043 | 58 | 0 |
109627 | 109627 | 2020-05-03 | Dale | Alabama | 1045 | 34 | 0 |
109628 | 109628 | 2020-05-03 | Dallas | Alabama | 1047 | 59 | 3 |
109629 | 109629 | 2020-05-03 | DeKalb | Alabama | 1049 | 79 | 2 |
109630 | 109630 | 2020-05-03 | Elmore | Alabama | 1051 | 103 | 2 |
109631 | 109631 | 2020-05-03 | Escambia | Alabama | 1053 | 31 | 2 |
109632 | 109632 | 2020-05-03 | Etowah | Alabama | 1055 | 143 | 10 |
109633 | 109633 | 2020-05-03 | Fayette | Alabama | 1057 | 6 | 0 |
109634 | 109634 | 2020-05-03 | Franklin | Alabama | 1059 | 132 | 0 |
109635 | 109635 | 2020-05-03 | Geneva | Alabama | 1061 | 10 | 0 |
109636 | 109636 | 2020-05-03 | Greene | Alabama | 1063 | 58 | 1 |
109637 | 109637 | 2020-05-03 | Hale | Alabama | 1065 | 52 | 2 |
109638 | 109638 | 2020-05-03 | Henry | Alabama | 1067 | 27 | 1 |
109639 | 109639 | 2020-05-03 | Houston | Alabama | 1069 | 95 | 4 |
109640 | 109640 | 2020-05-03 | Jackson | Alabama | 1071 | 50 | 2 |
109641 | 109641 | 2020-05-03 | Jefferson | Alabama | 1073 | 969 | 48 |
109642 | 109642 | 2020-05-03 | Lamar | Alabama | 1075 | 11 | 0 |
109643 | 109643 | 2020-05-03 | Lauderdale | Alabama | 1077 | 61 | 2 |
109644 | 109644 | 2020-05-03 | Lawrence | Alabama | 1079 | 14 | 0 |
109645 | 109645 | 2020-05-03 | Lee | Alabama | 1081 | 400 | 28 |
109646 | 109646 | 2020-05-03 | Limestone | Alabama | 1083 | 45 | 0 |
109647 | 109647 | 2020-05-03 | Lowndes | Alabama | 1085 | 71 | 1 |
109648 | 109648 | 2020-05-03 | Macon | Alabama | 1087 | 40 | 2 |
109649 | 109649 | 2020-05-03 | Madison | Alabama | 1089 | 234 | 4 |
109650 | 109650 | 2020-05-03 | Marengo | Alabama | 1091 | 58 | 3 |
109651 | 109651 | 2020-05-03 | Marion | Alabama | 1093 | 83 | 6 |
109652 | 109652 | 2020-05-03 | Marshall | Alabama | 1095 | 342 | 7 |
109653 | 109653 | 2020-05-03 | Mobile | Alabama | 1097 | 1198 | 62 |
109654 | 109654 | 2020-05-03 | Monroe | Alabama | 1099 | 13 | 1 |
109655 | 109655 | 2020-05-03 | Montgomery | Alabama | 1101 | 409 | 7 |
109656 | 109656 | 2020-05-03 | Morgan | Alabama | 1103 | 74 | 0 |
109657 | 109657 | 2020-05-03 | Perry | Alabama | 1105 | 15 | 0 |
109658 | 109658 | 2020-05-03 | Pickens | Alabama | 1107 | 55 | 2 |
109659 | 109659 | 2020-05-03 | Pike | Alabama | 1109 | 75 | 0 |
109660 | 109660 | 2020-05-03 | Randolph | Alabama | 1111 | 77 | 4 |
109661 | 109661 | 2020-05-03 | Russell | Alabama | 1113 | 61 | 0 |
109662 | 109662 | 2020-05-03 | Shelby | Alabama | 1117 | 327 | 13 |
109663 | 109663 | 2020-05-03 | St. Clair | Alabama | 1115 | 76 | 0 |
109664 | 109664 | 2020-05-03 | Sumter | Alabama | 1119 | 77 | 3 |
109665 | 109665 | 2020-05-03 | Talladega | Alabama | 1121 | 65 | 2 |
109666 | 109666 | 2020-05-03 | Tallapoosa | Alabama | 1123 | 295 | 18 |
109667 | 109667 | 2020-05-03 | Tuscaloosa | Alabama | 1125 | 218 | 2 |
109668 | 109668 | 2020-05-03 | Walker | Alabama | 1127 | 99 | 0 |
109669 | 109669 | 2020-05-03 | Washington | Alabama | 1129 | 38 | 2 |
109670 | 109670 | 2020-05-03 | Wilcox | Alabama | 1131 | 72 | 3 |
109671 | 109671 | 2020-05-03 | Winston | Alabama | 1133 | 16 | 0 |
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);