ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where deaths = 13, fips = 1055 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 |
---|---|---|---|---|---|---|---|
312393 | 312393 | 2020-07-08 | Etowah | Alabama | 1055 | 845 | 13 |
309224 | 309224 | 2020-07-07 | Etowah | Alabama | 1055 | 801 | 13 |
306055 | 306055 | 2020-07-06 | Etowah | Alabama | 1055 | 760 | 13 |
302891 | 302891 | 2020-07-05 | Etowah | Alabama | 1055 | 749 | 13 |
299727 | 299727 | 2020-07-04 | Etowah | Alabama | 1055 | 737 | 13 |
296565 | 296565 | 2020-07-03 | Etowah | Alabama | 1055 | 717 | 13 |
293410 | 293410 | 2020-07-02 | Etowah | Alabama | 1055 | 653 | 13 |
290257 | 290257 | 2020-07-01 | Etowah | Alabama | 1055 | 634 | 13 |
287107 | 287107 | 2020-06-30 | Etowah | Alabama | 1055 | 615 | 13 |
283961 | 283961 | 2020-06-29 | Etowah | Alabama | 1055 | 605 | 13 |
280815 | 280815 | 2020-06-28 | Etowah | Alabama | 1055 | 559 | 13 |
277667 | 277667 | 2020-06-27 | Etowah | Alabama | 1055 | 555 | 13 |
274519 | 274519 | 2020-06-26 | Etowah | Alabama | 1055 | 529 | 13 |
271379 | 271379 | 2020-06-25 | Etowah | Alabama | 1055 | 493 | 13 |
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);