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-04-17 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
64617 | 64617 | 2020-04-17 | Autauga | Alabama | 1001 | 26 | 2 |
64618 | 64618 | 2020-04-17 | Baldwin | Alabama | 1003 | 103 | 2 |
64619 | 64619 | 2020-04-17 | Barbour | Alabama | 1005 | 15 | 0 |
64620 | 64620 | 2020-04-17 | Bibb | Alabama | 1007 | 23 | 0 |
64621 | 64621 | 2020-04-17 | Blount | Alabama | 1009 | 20 | 0 |
64622 | 64622 | 2020-04-17 | Bullock | Alabama | 1011 | 8 | 0 |
64623 | 64623 | 2020-04-17 | Butler | Alabama | 1013 | 16 | 0 |
64624 | 64624 | 2020-04-17 | Calhoun | Alabama | 1015 | 63 | 2 |
64625 | 64625 | 2020-04-17 | Chambers | Alabama | 1017 | 236 | 11 |
64626 | 64626 | 2020-04-17 | Cherokee | Alabama | 1019 | 12 | 0 |
64627 | 64627 | 2020-04-17 | Chilton | Alabama | 1021 | 37 | 0 |
64628 | 64628 | 2020-04-17 | Choctaw | Alabama | 1023 | 13 | 0 |
64629 | 64629 | 2020-04-17 | Clarke | Alabama | 1025 | 24 | 0 |
64630 | 64630 | 2020-04-17 | Clay | Alabama | 1027 | 14 | 0 |
64631 | 64631 | 2020-04-17 | Cleburne | Alabama | 1029 | 12 | 0 |
64632 | 64632 | 2020-04-17 | Coffee | Alabama | 1031 | 50 | 0 |
64633 | 64633 | 2020-04-17 | Colbert | Alabama | 1033 | 13 | 1 |
64634 | 64634 | 2020-04-17 | Conecuh | Alabama | 1035 | 8 | 0 |
64635 | 64635 | 2020-04-17 | Coosa | Alabama | 1037 | 20 | 1 |
64636 | 64636 | 2020-04-17 | Covington | Alabama | 1039 | 19 | 1 |
64637 | 64637 | 2020-04-17 | Crenshaw | Alabama | 1041 | 5 | 0 |
64638 | 64638 | 2020-04-17 | Cullman | Alabama | 1043 | 53 | 1 |
64639 | 64639 | 2020-04-17 | Dale | Alabama | 1045 | 14 | 0 |
64640 | 64640 | 2020-04-17 | Dallas | Alabama | 1047 | 21 | 2 |
64641 | 64641 | 2020-04-17 | DeKalb | Alabama | 1049 | 34 | 2 |
64642 | 64642 | 2020-04-17 | Elmore | Alabama | 1051 | 54 | 1 |
64643 | 64643 | 2020-04-17 | Escambia | Alabama | 1053 | 14 | 0 |
64644 | 64644 | 2020-04-17 | Etowah | Alabama | 1055 | 88 | 8 |
64645 | 64645 | 2020-04-17 | Fayette | Alabama | 1057 | 4 | 0 |
64646 | 64646 | 2020-04-17 | Franklin | Alabama | 1059 | 18 | 1 |
64647 | 64647 | 2020-04-17 | Geneva | Alabama | 1061 | 2 | 0 |
64648 | 64648 | 2020-04-17 | Greene | Alabama | 1063 | 24 | 0 |
64649 | 64649 | 2020-04-17 | Hale | Alabama | 1065 | 22 | 0 |
64650 | 64650 | 2020-04-17 | Henry | Alabama | 1067 | 16 | 0 |
64651 | 64651 | 2020-04-17 | Houston | Alabama | 1069 | 64 | 3 |
64652 | 64652 | 2020-04-17 | Jackson | Alabama | 1071 | 32 | 2 |
64653 | 64653 | 2020-04-17 | Jefferson | Alabama | 1073 | 645 | 24 |
64654 | 64654 | 2020-04-17 | Lamar | Alabama | 1075 | 7 | 0 |
64655 | 64655 | 2020-04-17 | Lauderdale | Alabama | 1077 | 23 | 4 |
64656 | 64656 | 2020-04-17 | Lawrence | Alabama | 1079 | 8 | 0 |
64657 | 64657 | 2020-04-17 | Lee | Alabama | 1081 | 300 | 13 |
64658 | 64658 | 2020-04-17 | Limestone | Alabama | 1083 | 40 | 0 |
64659 | 64659 | 2020-04-17 | Lowndes | Alabama | 1085 | 25 | 0 |
64660 | 64660 | 2020-04-17 | Macon | Alabama | 1087 | 24 | 2 |
64661 | 64661 | 2020-04-17 | Madison | Alabama | 1089 | 216 | 4 |
64662 | 64662 | 2020-04-17 | Marengo | Alabama | 1091 | 24 | 1 |
64663 | 64663 | 2020-04-17 | Marion | Alabama | 1093 | 62 | 5 |
64664 | 64664 | 2020-04-17 | Marshall | Alabama | 1095 | 123 | 4 |
64665 | 64665 | 2020-04-17 | Mobile | Alabama | 1097 | 627 | 25 |
64666 | 64666 | 2020-04-17 | Monroe | Alabama | 1099 | 7 | 1 |
64667 | 64667 | 2020-04-17 | Montgomery | Alabama | 1101 | 207 | 5 |
64668 | 64668 | 2020-04-17 | Morgan | Alabama | 1103 | 47 | 0 |
64669 | 64669 | 2020-04-17 | Perry | Alabama | 1105 | 9 | 0 |
64670 | 64670 | 2020-04-17 | Pickens | Alabama | 1107 | 32 | 0 |
64671 | 64671 | 2020-04-17 | Pike | Alabama | 1109 | 29 | 0 |
64672 | 64672 | 2020-04-17 | Randolph | Alabama | 1111 | 51 | 4 |
64673 | 64673 | 2020-04-17 | Russell | Alabama | 1113 | 35 | 0 |
64674 | 64674 | 2020-04-17 | Shelby | Alabama | 1117 | 248 | 8 |
64675 | 64675 | 2020-04-17 | St. Clair | Alabama | 1115 | 52 | 0 |
64676 | 64676 | 2020-04-17 | Sumter | Alabama | 1119 | 33 | 0 |
64677 | 64677 | 2020-04-17 | Talladega | Alabama | 1121 | 42 | 1 |
64678 | 64678 | 2020-04-17 | Tallapoosa | Alabama | 1123 | 160 | 9 |
64679 | 64679 | 2020-04-17 | Tuscaloosa | Alabama | 1125 | 153 | 0 |
64680 | 64680 | 2020-04-17 | Walker | Alabama | 1127 | 83 | 0 |
64681 | 64681 | 2020-04-17 | Washington | Alabama | 1129 | 14 | 1 |
64682 | 64682 | 2020-04-17 | Wilcox | Alabama | 1131 | 40 | 0 |
64683 | 64683 | 2020-04-17 | Winston | Alabama | 1133 | 9 | 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);