ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 7 and fips = 29005 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 |
---|---|---|---|---|---|---|---|
1925343 | 1925343 | 2021-11-17 | Atchison | Missouri | 29005 | 746 | 7 |
1922094 | 1922094 | 2021-11-16 | Atchison | Missouri | 29005 | 731 | 7 |
1918844 | 1918844 | 2021-11-15 | Atchison | Missouri | 29005 | 728 | 7 |
1915594 | 1915594 | 2021-11-14 | Atchison | Missouri | 29005 | 727 | 7 |
1912344 | 1912344 | 2021-11-13 | Atchison | Missouri | 29005 | 727 | 7 |
1909094 | 1909094 | 2021-11-12 | Atchison | Missouri | 29005 | 720 | 7 |
1905845 | 1905845 | 2021-11-11 | Atchison | Missouri | 29005 | 702 | 7 |
1902596 | 1902596 | 2021-11-10 | Atchison | Missouri | 29005 | 702 | 7 |
1899346 | 1899346 | 2021-11-09 | Atchison | Missouri | 29005 | 689 | 7 |
1896096 | 1896096 | 2021-11-08 | Atchison | Missouri | 29005 | 687 | 7 |
1892846 | 1892846 | 2021-11-07 | Atchison | Missouri | 29005 | 687 | 7 |
1889596 | 1889596 | 2021-11-06 | Atchison | Missouri | 29005 | 687 | 7 |
1886346 | 1886346 | 2021-11-05 | Atchison | Missouri | 29005 | 685 | 7 |
1883097 | 1883097 | 2021-11-04 | Atchison | Missouri | 29005 | 680 | 7 |
1879848 | 1879848 | 2021-11-03 | Atchison | Missouri | 29005 | 680 | 7 |
1876599 | 1876599 | 2021-11-02 | Atchison | Missouri | 29005 | 674 | 7 |
1873350 | 1873350 | 2021-11-01 | Atchison | Missouri | 29005 | 674 | 7 |
1870101 | 1870101 | 2021-10-31 | Atchison | Missouri | 29005 | 674 | 7 |
1866852 | 1866852 | 2021-10-30 | Atchison | Missouri | 29005 | 674 | 7 |
1863603 | 1863603 | 2021-10-29 | Atchison | Missouri | 29005 | 673 | 7 |
1860354 | 1860354 | 2021-10-28 | Atchison | Missouri | 29005 | 672 | 7 |
1857105 | 1857105 | 2021-10-27 | Atchison | Missouri | 29005 | 670 | 7 |
1853856 | 1853856 | 2021-10-26 | Atchison | Missouri | 29005 | 669 | 7 |
1850607 | 1850607 | 2021-10-25 | Atchison | Missouri | 29005 | 669 | 7 |
1847357 | 1847357 | 2021-10-24 | Atchison | Missouri | 29005 | 669 | 7 |
1844107 | 1844107 | 2021-10-23 | Atchison | Missouri | 29005 | 669 | 7 |
1840857 | 1840857 | 2021-10-22 | Atchison | Missouri | 29005 | 669 | 7 |
1837608 | 1837608 | 2021-10-21 | Atchison | Missouri | 29005 | 666 | 7 |
1834359 | 1834359 | 2021-10-20 | Atchison | Missouri | 29005 | 665 | 7 |
1831110 | 1831110 | 2021-10-19 | Atchison | Missouri | 29005 | 665 | 7 |
1827861 | 1827861 | 2021-10-18 | Atchison | Missouri | 29005 | 660 | 7 |
1824612 | 1824612 | 2021-10-17 | Atchison | Missouri | 29005 | 660 | 7 |
1821363 | 1821363 | 2021-10-16 | Atchison | Missouri | 29005 | 660 | 7 |
1818114 | 1818114 | 2021-10-15 | Atchison | Missouri | 29005 | 655 | 7 |
1814865 | 1814865 | 2021-10-14 | Atchison | Missouri | 29005 | 650 | 7 |
1811617 | 1811617 | 2021-10-13 | Atchison | Missouri | 29005 | 649 | 7 |
1808368 | 1808368 | 2021-10-12 | Atchison | Missouri | 29005 | 647 | 7 |
1805117 | 1805117 | 2021-10-11 | Atchison | Missouri | 29005 | 646 | 7 |
1801868 | 1801868 | 2021-10-10 | Atchison | Missouri | 29005 | 646 | 7 |
1798619 | 1798619 | 2021-10-09 | Atchison | Missouri | 29005 | 646 | 7 |
1795370 | 1795370 | 2021-10-08 | Atchison | Missouri | 29005 | 641 | 7 |
1792121 | 1792121 | 2021-10-07 | Atchison | Missouri | 29005 | 639 | 7 |
1788872 | 1788872 | 2021-10-06 | Atchison | Missouri | 29005 | 638 | 7 |
1785624 | 1785624 | 2021-10-05 | Atchison | Missouri | 29005 | 632 | 7 |
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);