ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 48, fips = 1017 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
761426 | 761426 | 2020-11-24 | Chambers | Alabama | 1017 | 1714 | 48 |
758181 | 758181 | 2020-11-23 | Chambers | Alabama | 1017 | 1680 | 48 |
754934 | 754934 | 2020-11-22 | Chambers | Alabama | 1017 | 1675 | 48 |
751688 | 751688 | 2020-11-21 | Chambers | Alabama | 1017 | 1669 | 48 |
748442 | 748442 | 2020-11-20 | Chambers | Alabama | 1017 | 1663 | 48 |
745196 | 745196 | 2020-11-19 | Chambers | Alabama | 1017 | 1641 | 48 |
741949 | 741949 | 2020-11-18 | Chambers | Alabama | 1017 | 1620 | 48 |
738702 | 738702 | 2020-11-17 | Chambers | Alabama | 1017 | 1595 | 48 |
735458 | 735458 | 2020-11-16 | Chambers | Alabama | 1017 | 1572 | 48 |
732212 | 732212 | 2020-11-15 | Chambers | Alabama | 1017 | 1570 | 48 |
728967 | 728967 | 2020-11-14 | Chambers | Alabama | 1017 | 1556 | 48 |
725724 | 725724 | 2020-11-13 | Chambers | Alabama | 1017 | 1545 | 48 |
722481 | 722481 | 2020-11-12 | Chambers | Alabama | 1017 | 1514 | 48 |
719238 | 719238 | 2020-11-11 | Chambers | Alabama | 1017 | 1508 | 48 |
715995 | 715995 | 2020-11-10 | Chambers | Alabama | 1017 | 1507 | 48 |
712751 | 712751 | 2020-11-09 | Chambers | Alabama | 1017 | 1489 | 48 |
709507 | 709507 | 2020-11-08 | Chambers | Alabama | 1017 | 1485 | 48 |
706263 | 706263 | 2020-11-07 | Chambers | Alabama | 1017 | 1483 | 48 |
703020 | 703020 | 2020-11-06 | Chambers | Alabama | 1017 | 1469 | 48 |
699777 | 699777 | 2020-11-05 | Chambers | Alabama | 1017 | 1461 | 48 |
696533 | 696533 | 2020-11-04 | Chambers | Alabama | 1017 | 1449 | 48 |
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);