ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where county = "Moniteau" and deaths = 27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1009634 | 1009634 | 2021-02-08 | Moniteau | Missouri | 29135 | 1669 | 27 |
1006387 | 1006387 | 2021-02-07 | Moniteau | Missouri | 29135 | 1669 | 27 |
1003141 | 1003141 | 2021-02-06 | Moniteau | Missouri | 29135 | 1667 | 27 |
999896 | 999896 | 2021-02-05 | Moniteau | Missouri | 29135 | 1663 | 27 |
996650 | 996650 | 2021-02-04 | Moniteau | Missouri | 29135 | 1662 | 27 |
993404 | 993404 | 2021-02-03 | Moniteau | Missouri | 29135 | 1659 | 27 |
990158 | 990158 | 2021-02-02 | Moniteau | Missouri | 29135 | 1658 | 27 |
986911 | 986911 | 2021-02-01 | Moniteau | Missouri | 29135 | 1656 | 27 |
983664 | 983664 | 2021-01-31 | Moniteau | Missouri | 29135 | 1655 | 27 |
980418 | 980418 | 2021-01-30 | Moniteau | Missouri | 29135 | 1652 | 27 |
977172 | 977172 | 2021-01-29 | Moniteau | Missouri | 29135 | 1649 | 27 |
973927 | 973927 | 2021-01-28 | Moniteau | Missouri | 29135 | 1646 | 27 |
970682 | 970682 | 2021-01-27 | Moniteau | Missouri | 29135 | 1644 | 27 |
967437 | 967437 | 2021-01-26 | Moniteau | Missouri | 29135 | 1643 | 27 |
964193 | 964193 | 2021-01-25 | Moniteau | Missouri | 29135 | 1641 | 27 |
960948 | 960948 | 2021-01-24 | Moniteau | Missouri | 29135 | 1640 | 27 |
957702 | 957702 | 2021-01-23 | Moniteau | Missouri | 29135 | 1638 | 27 |
954457 | 954457 | 2021-01-22 | Moniteau | Missouri | 29135 | 1634 | 27 |
951212 | 951212 | 2021-01-21 | Moniteau | Missouri | 29135 | 1630 | 27 |
947966 | 947966 | 2021-01-20 | Moniteau | Missouri | 29135 | 1623 | 27 |
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);