ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 79 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 |
---|---|---|---|---|---|---|---|
347443 | 347443 | 2020-07-19 | Cleburne | Alabama | 1029 | 79 | 1 |
306065 | 306065 | 2020-07-06 | Lamar | Alabama | 1075 | 79 | 1 |
299730 | 299730 | 2020-07-04 | Geneva | Alabama | 1061 | 79 | 0 |
261999 | 261999 | 2020-06-22 | Lawrence | Alabama | 1079 | 79 | 0 |
246412 | 246412 | 2020-06-17 | Perry | Alabama | 1105 | 79 | 0 |
243299 | 243299 | 2020-06-16 | Perry | Alabama | 1105 | 79 | 0 |
224660 | 224660 | 2020-06-10 | Monroe | Alabama | 1099 | 79 | 2 |
212310 | 212310 | 2020-06-06 | Washington | Alabama | 1129 | 79 | 6 |
209164 | 209164 | 2020-06-05 | Bibb | Alabama | 1007 | 79 | 1 |
209187 | 209187 | 2020-06-05 | Escambia | Alabama | 1053 | 79 | 3 |
206082 | 206082 | 2020-06-04 | Bibb | Alabama | 1007 | 79 | 1 |
203003 | 203003 | 2020-06-03 | Bibb | Alabama | 1007 | 79 | 1 |
199927 | 199927 | 2020-06-02 | Bibb | Alabama | 1007 | 79 | 1 |
196854 | 196854 | 2020-06-01 | Bibb | Alabama | 1007 | 79 | 1 |
154243 | 154243 | 2020-05-18 | Chilton | Alabama | 1021 | 79 | 1 |
148214 | 148214 | 2020-05-16 | Barbour | Alabama | 1005 | 79 | 1 |
145211 | 145211 | 2020-05-15 | Barbour | Alabama | 1005 | 79 | 1 |
145240 | 145240 | 2020-05-15 | Greene | Alabama | 1063 | 79 | 4 |
145241 | 145241 | 2020-05-15 | Hale | Alabama | 1065 | 79 | 2 |
142226 | 142226 | 2020-05-14 | Colbert | Alabama | 1033 | 79 | 2 |
142242 | 142242 | 2020-05-14 | Hale | Alabama | 1065 | 79 | 2 |
130299 | 130299 | 2020-05-10 | Russell | Alabama | 1113 | 79 | 0 |
124326 | 124326 | 2020-05-08 | St. Clair | Alabama | 1115 | 79 | 1 |
121326 | 121326 | 2020-05-07 | Lauderdale | Alabama | 1077 | 79 | 2 |
112534 | 112534 | 2020-05-04 | Pike | Alabama | 1109 | 79 | 0 |
112535 | 112535 | 2020-05-04 | Randolph | Alabama | 1111 | 79 | 4 |
109629 | 109629 | 2020-05-03 | DeKalb | Alabama | 1049 | 79 | 2 |
92516 | 92516 | 2020-04-27 | Elmore | Alabama | 1051 | 79 | 1 |
92525 | 92525 | 2020-04-27 | Houston | Alabama | 1069 | 79 | 3 |
89698 | 89698 | 2020-04-26 | Elmore | Alabama | 1051 | 79 | 1 |
38145 | 38145 | 2020-04-07 | Tuscaloosa | Alabama | 1125 | 79 | 0 |
17733 | 17733 | 2020-03-29 | Shelby | Alabama | 1117 | 79 | 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);