ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 19 and fips = 51036 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 |
---|---|---|---|---|---|---|---|
1848805 | 1848805 | 2021-10-24 | Charles City | Virginia | 51036 | 674 | 19 |
1845555 | 1845555 | 2021-10-23 | Charles City | Virginia | 51036 | 674 | 19 |
1842305 | 1842305 | 2021-10-22 | Charles City | Virginia | 51036 | 674 | 19 |
1839056 | 1839056 | 2021-10-21 | Charles City | Virginia | 51036 | 674 | 19 |
1835807 | 1835807 | 2021-10-20 | Charles City | Virginia | 51036 | 675 | 19 |
1832558 | 1832558 | 2021-10-19 | Charles City | Virginia | 51036 | 675 | 19 |
1829309 | 1829309 | 2021-10-18 | Charles City | Virginia | 51036 | 674 | 19 |
1826060 | 1826060 | 2021-10-17 | Charles City | Virginia | 51036 | 670 | 19 |
1822811 | 1822811 | 2021-10-16 | Charles City | Virginia | 51036 | 670 | 19 |
1819562 | 1819562 | 2021-10-15 | Charles City | Virginia | 51036 | 670 | 19 |
1816313 | 1816313 | 2021-10-14 | Charles City | Virginia | 51036 | 669 | 19 |
1813065 | 1813065 | 2021-10-13 | Charles City | Virginia | 51036 | 662 | 19 |
1809816 | 1809816 | 2021-10-12 | Charles City | Virginia | 51036 | 660 | 19 |
1806566 | 1806566 | 2021-10-11 | Charles City | Virginia | 51036 | 653 | 19 |
1803316 | 1803316 | 2021-10-10 | Charles City | Virginia | 51036 | 653 | 19 |
1800067 | 1800067 | 2021-10-09 | Charles City | Virginia | 51036 | 653 | 19 |
1796818 | 1796818 | 2021-10-08 | Charles City | Virginia | 51036 | 653 | 19 |
1793569 | 1793569 | 2021-10-07 | Charles City | Virginia | 51036 | 653 | 19 |
1790320 | 1790320 | 2021-10-06 | Charles City | Virginia | 51036 | 653 | 19 |
1787072 | 1787072 | 2021-10-05 | Charles City | Virginia | 51036 | 653 | 19 |
1783823 | 1783823 | 2021-10-04 | Charles City | Virginia | 51036 | 653 | 19 |
1780574 | 1780574 | 2021-10-03 | Charles City | Virginia | 51036 | 649 | 19 |
1777324 | 1777324 | 2021-10-02 | Charles City | Virginia | 51036 | 649 | 19 |
1774074 | 1774074 | 2021-10-01 | Charles City | Virginia | 51036 | 649 | 19 |
1770824 | 1770824 | 2021-09-30 | Charles City | Virginia | 51036 | 645 | 19 |
1767575 | 1767575 | 2021-09-29 | Charles City | Virginia | 51036 | 644 | 19 |
1764326 | 1764326 | 2021-09-28 | Charles City | Virginia | 51036 | 642 | 19 |
1761077 | 1761077 | 2021-09-27 | Charles City | Virginia | 51036 | 641 | 19 |
1757829 | 1757829 | 2021-09-26 | Charles City | Virginia | 51036 | 639 | 19 |
1754581 | 1754581 | 2021-09-25 | Charles City | Virginia | 51036 | 639 | 19 |
1751333 | 1751333 | 2021-09-24 | Charles City | Virginia | 51036 | 639 | 19 |
1748084 | 1748084 | 2021-09-23 | Charles City | Virginia | 51036 | 637 | 19 |
1744834 | 1744834 | 2021-09-22 | Charles City | Virginia | 51036 | 632 | 19 |
1741585 | 1741585 | 2021-09-21 | Charles City | Virginia | 51036 | 632 | 19 |
1738336 | 1738336 | 2021-09-20 | Charles City | Virginia | 51036 | 632 | 19 |
1735087 | 1735087 | 2021-09-19 | Charles City | Virginia | 51036 | 622 | 19 |
1731837 | 1731837 | 2021-09-18 | Charles City | Virginia | 51036 | 622 | 19 |
1728587 | 1728587 | 2021-09-17 | Charles City | Virginia | 51036 | 622 | 19 |
1725337 | 1725337 | 2021-09-16 | Charles City | Virginia | 51036 | 622 | 19 |
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);