ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 2, fips = 1115 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 |
---|---|---|---|---|---|---|---|
318772 | 318772 | 2020-07-10 | St. Clair | Alabama | 1115 | 499 | 2 |
315599 | 315599 | 2020-07-09 | St. Clair | Alabama | 1115 | 481 | 2 |
312424 | 312424 | 2020-07-08 | St. Clair | Alabama | 1115 | 452 | 2 |
309255 | 309255 | 2020-07-07 | St. Clair | Alabama | 1115 | 426 | 2 |
306086 | 306086 | 2020-07-06 | St. Clair | Alabama | 1115 | 412 | 2 |
302922 | 302922 | 2020-07-05 | St. Clair | Alabama | 1115 | 392 | 2 |
299758 | 299758 | 2020-07-04 | St. Clair | Alabama | 1115 | 376 | 2 |
296596 | 296596 | 2020-07-03 | St. Clair | Alabama | 1115 | 357 | 2 |
293441 | 293441 | 2020-07-02 | St. Clair | Alabama | 1115 | 329 | 2 |
290288 | 290288 | 2020-07-01 | St. Clair | Alabama | 1115 | 314 | 2 |
287138 | 287138 | 2020-06-30 | St. Clair | Alabama | 1115 | 302 | 2 |
283992 | 283992 | 2020-06-29 | St. Clair | Alabama | 1115 | 285 | 2 |
280846 | 280846 | 2020-06-28 | St. Clair | Alabama | 1115 | 257 | 2 |
277698 | 277698 | 2020-06-27 | St. Clair | Alabama | 1115 | 255 | 2 |
274550 | 274550 | 2020-06-26 | St. Clair | Alabama | 1115 | 245 | 2 |
271410 | 271410 | 2020-06-25 | St. Clair | Alabama | 1115 | 236 | 2 |
268276 | 268276 | 2020-06-24 | St. Clair | Alabama | 1115 | 227 | 2 |
265147 | 265147 | 2020-06-23 | St. Clair | Alabama | 1115 | 218 | 2 |
262018 | 262018 | 2020-06-22 | St. Clair | Alabama | 1115 | 212 | 2 |
258891 | 258891 | 2020-06-21 | St. Clair | Alabama | 1115 | 209 | 2 |
255764 | 255764 | 2020-06-20 | St. Clair | Alabama | 1115 | 204 | 2 |
252645 | 252645 | 2020-06-19 | St. Clair | Alabama | 1115 | 201 | 2 |
249530 | 249530 | 2020-06-18 | St. Clair | Alabama | 1115 | 190 | 2 |
246418 | 246418 | 2020-06-17 | St. Clair | Alabama | 1115 | 188 | 2 |
243305 | 243305 | 2020-06-16 | St. Clair | Alabama | 1115 | 184 | 2 |
240194 | 240194 | 2020-06-15 | St. Clair | Alabama | 1115 | 181 | 2 |
237086 | 237086 | 2020-06-14 | St. Clair | Alabama | 1115 | 178 | 2 |
233979 | 233979 | 2020-06-13 | St. Clair | Alabama | 1115 | 175 | 2 |
230874 | 230874 | 2020-06-12 | St. Clair | Alabama | 1115 | 166 | 2 |
227770 | 227770 | 2020-06-11 | St. Clair | Alabama | 1115 | 161 | 2 |
224669 | 224669 | 2020-06-10 | St. Clair | Alabama | 1115 | 157 | 2 |
221573 | 221573 | 2020-06-09 | St. Clair | Alabama | 1115 | 149 | 2 |
218481 | 218481 | 2020-06-08 | St. Clair | Alabama | 1115 | 149 | 2 |
215391 | 215391 | 2020-06-07 | St. Clair | Alabama | 1115 | 148 | 2 |
212304 | 212304 | 2020-06-06 | St. Clair | Alabama | 1115 | 146 | 2 |
209219 | 209219 | 2020-06-05 | St. Clair | Alabama | 1115 | 145 | 2 |
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);