ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 37059 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111065 | 2111065 | 2022-01-13 | Davie | North Carolina | 37059 | 8417 | 82 |
2107813 | 2107813 | 2022-01-12 | Davie | North Carolina | 37059 | 8259 | 82 |
2104562 | 2104562 | 2022-01-11 | Davie | North Carolina | 37059 | 8189 | 82 |
2101311 | 2101311 | 2022-01-10 | Davie | North Carolina | 37059 | 8155 | 82 |
2098060 | 2098060 | 2022-01-09 | Davie | North Carolina | 37059 | 7984 | 82 |
2094808 | 2094808 | 2022-01-08 | Davie | North Carolina | 37059 | 7984 | 82 |
2091556 | 2091556 | 2022-01-07 | Davie | North Carolina | 37059 | 7984 | 82 |
2088305 | 2088305 | 2022-01-06 | Davie | North Carolina | 37059 | 7888 | 82 |
2085053 | 2085053 | 2022-01-05 | Davie | North Carolina | 37059 | 7821 | 82 |
2081801 | 2081801 | 2022-01-04 | Davie | North Carolina | 37059 | 7764 | 82 |
2078549 | 2078549 | 2022-01-03 | Davie | North Carolina | 37059 | 7727 | 82 |
2075298 | 2075298 | 2022-01-02 | Davie | North Carolina | 37059 | 7602 | 82 |
2072047 | 2072047 | 2022-01-01 | Davie | North Carolina | 37059 | 7602 | 82 |
2068796 | 2068796 | 2021-12-31 | Davie | North Carolina | 37059 | 7602 | 82 |
2065545 | 2065545 | 2021-12-30 | Davie | North Carolina | 37059 | 7550 | 82 |
2062295 | 2062295 | 2021-12-29 | Davie | North Carolina | 37059 | 7466 | 82 |
2059046 | 2059046 | 2021-12-28 | Davie | North Carolina | 37059 | 7445 | 82 |
2055797 | 2055797 | 2021-12-27 | Davie | North Carolina | 37059 | 7289 | 82 |
2052547 | 2052547 | 2021-12-26 | Davie | North Carolina | 37059 | 7289 | 82 |
2049297 | 2049297 | 2021-12-25 | Davie | North Carolina | 37059 | 7289 | 82 |
2046047 | 2046047 | 2021-12-24 | Davie | North Carolina | 37059 | 7289 | 82 |
2042797 | 2042797 | 2021-12-23 | Davie | North Carolina | 37059 | 7289 | 82 |
2039548 | 2039548 | 2021-12-22 | Davie | North Carolina | 37059 | 7289 | 82 |
2036298 | 2036298 | 2021-12-21 | Davie | North Carolina | 37059 | 7265 | 82 |
2033048 | 2033048 | 2021-12-20 | Davie | North Carolina | 37059 | 7246 | 82 |
2029798 | 2029798 | 2021-12-19 | Davie | North Carolina | 37059 | 7152 | 82 |
2026547 | 2026547 | 2021-12-18 | Davie | North Carolina | 37059 | 7152 | 82 |
2023296 | 2023296 | 2021-12-17 | Davie | North Carolina | 37059 | 7152 | 82 |
2020045 | 2020045 | 2021-12-16 | Davie | North Carolina | 37059 | 7110 | 82 |
2016794 | 2016794 | 2021-12-15 | Davie | North Carolina | 37059 | 7087 | 82 |
2013544 | 2013544 | 2021-12-14 | Davie | North Carolina | 37059 | 7066 | 82 |
2010293 | 2010293 | 2021-12-13 | Davie | North Carolina | 37059 | 7059 | 82 |
2007042 | 2007042 | 2021-12-12 | Davie | North Carolina | 37059 | 6973 | 82 |
2003791 | 2003791 | 2021-12-11 | Davie | North Carolina | 37059 | 6973 | 82 |
2000540 | 2000540 | 2021-12-10 | Davie | North Carolina | 37059 | 6973 | 82 |
1997290 | 1997290 | 2021-12-09 | Davie | North Carolina | 37059 | 6945 | 82 |
1994039 | 1994039 | 2021-12-08 | Davie | North Carolina | 37059 | 6920 | 82 |
1990788 | 1990788 | 2021-12-07 | Davie | North Carolina | 37059 | 6894 | 82 |
1987537 | 1987537 | 2021-12-06 | Davie | North Carolina | 37059 | 6876 | 81 |
1984287 | 1984287 | 2021-12-05 | Davie | North Carolina | 37059 | 6820 | 81 |
1981037 | 1981037 | 2021-12-04 | Davie | North Carolina | 37059 | 6820 | 81 |
1977787 | 1977787 | 2021-12-03 | Davie | North Carolina | 37059 | 6820 | 81 |
1974537 | 1974537 | 2021-12-02 | Davie | North Carolina | 37059 | 6804 | 81 |
1971288 | 1971288 | 2021-12-01 | Davie | North Carolina | 37059 | 6769 | 81 |
1968038 | 1968038 | 2021-11-30 | Davie | North Carolina | 37059 | 6751 | 81 |
1964787 | 1964787 | 2021-11-29 | Davie | North Carolina | 37059 | 6736 | 81 |
1961535 | 1961535 | 2021-11-28 | Davie | North Carolina | 37059 | 6677 | 81 |
1958284 | 1958284 | 2021-11-27 | Davie | North Carolina | 37059 | 6677 | 81 |
1955033 | 1955033 | 2021-11-26 | Davie | North Carolina | 37059 | 6677 | 81 |
1951782 | 1951782 | 2021-11-25 | Davie | North Carolina | 37059 | 6677 | 81 |
1948531 | 1948531 | 2021-11-24 | Davie | North Carolina | 37059 | 6677 | 81 |
1945280 | 1945280 | 2021-11-23 | Davie | North Carolina | 37059 | 6669 | 81 |
1942029 | 1942029 | 2021-11-22 | Davie | North Carolina | 37059 | 6660 | 81 |
1938779 | 1938779 | 2021-11-21 | Davie | North Carolina | 37059 | 6630 | 80 |
1935529 | 1935529 | 2021-11-20 | Davie | North Carolina | 37059 | 6630 | 80 |
1932279 | 1932279 | 2021-11-19 | Davie | North Carolina | 37059 | 6630 | 80 |
1929028 | 1929028 | 2021-11-18 | Davie | North Carolina | 37059 | 6611 | 80 |
1925778 | 1925778 | 2021-11-17 | Davie | North Carolina | 37059 | 6602 | 80 |
1922529 | 1922529 | 2021-11-16 | Davie | North Carolina | 37059 | 6590 | 80 |
1919279 | 1919279 | 2021-11-15 | Davie | North Carolina | 37059 | 6585 | 80 |
1916029 | 1916029 | 2021-11-14 | Davie | North Carolina | 37059 | 6561 | 80 |
1912779 | 1912779 | 2021-11-13 | Davie | North Carolina | 37059 | 6561 | 80 |
1909529 | 1909529 | 2021-11-12 | Davie | North Carolina | 37059 | 6561 | 80 |
1906280 | 1906280 | 2021-11-11 | Davie | North Carolina | 37059 | 6538 | 80 |
1903031 | 1903031 | 2021-11-10 | Davie | North Carolina | 37059 | 6538 | 80 |
1899781 | 1899781 | 2021-11-09 | Davie | North Carolina | 37059 | 6534 | 80 |
1896531 | 1896531 | 2021-11-08 | Davie | North Carolina | 37059 | 6529 | 80 |
1893281 | 1893281 | 2021-11-07 | Davie | North Carolina | 37059 | 6499 | 76 |
1890031 | 1890031 | 2021-11-06 | Davie | North Carolina | 37059 | 6499 | 76 |
1886781 | 1886781 | 2021-11-05 | Davie | North Carolina | 37059 | 6499 | 76 |
1883532 | 1883532 | 2021-11-04 | Davie | North Carolina | 37059 | 6494 | 76 |
1880283 | 1880283 | 2021-11-03 | Davie | North Carolina | 37059 | 6480 | 76 |
1877034 | 1877034 | 2021-11-02 | Davie | North Carolina | 37059 | 6471 | 76 |
1873785 | 1873785 | 2021-11-01 | Davie | North Carolina | 37059 | 6464 | 76 |
1870536 | 1870536 | 2021-10-31 | Davie | North Carolina | 37059 | 6435 | 76 |
1867287 | 1867287 | 2021-10-30 | Davie | North Carolina | 37059 | 6435 | 76 |
1864038 | 1864038 | 2021-10-29 | Davie | North Carolina | 37059 | 6435 | 76 |
1860789 | 1860789 | 2021-10-28 | Davie | North Carolina | 37059 | 6421 | 76 |
1857540 | 1857540 | 2021-10-27 | Davie | North Carolina | 37059 | 6408 | 76 |
1854291 | 1854291 | 2021-10-26 | Davie | North Carolina | 37059 | 6392 | 75 |
1851042 | 1851042 | 2021-10-25 | Davie | North Carolina | 37059 | 6381 | 75 |
1847792 | 1847792 | 2021-10-24 | Davie | North Carolina | 37059 | 6358 | 73 |
1844542 | 1844542 | 2021-10-23 | Davie | North Carolina | 37059 | 6358 | 73 |
1841292 | 1841292 | 2021-10-22 | Davie | North Carolina | 37059 | 6358 | 73 |
1838043 | 1838043 | 2021-10-21 | Davie | North Carolina | 37059 | 6347 | 73 |
1834794 | 1834794 | 2021-10-20 | Davie | North Carolina | 37059 | 6335 | 73 |
1831545 | 1831545 | 2021-10-19 | Davie | North Carolina | 37059 | 6322 | 73 |
1828296 | 1828296 | 2021-10-18 | Davie | North Carolina | 37059 | 6315 | 71 |
1825047 | 1825047 | 2021-10-17 | Davie | North Carolina | 37059 | 6286 | 70 |
1821798 | 1821798 | 2021-10-16 | Davie | North Carolina | 37059 | 6286 | 70 |
1818549 | 1818549 | 2021-10-15 | Davie | North Carolina | 37059 | 6286 | 70 |
1815300 | 1815300 | 2021-10-14 | Davie | North Carolina | 37059 | 6269 | 70 |
1812052 | 1812052 | 2021-10-13 | Davie | North Carolina | 37059 | 6251 | 68 |
1808803 | 1808803 | 2021-10-12 | Davie | North Carolina | 37059 | 6238 | 68 |
1805552 | 1805552 | 2021-10-11 | Davie | North Carolina | 37059 | 6226 | 68 |
1802303 | 1802303 | 2021-10-10 | Davie | North Carolina | 37059 | 6152 | 67 |
1799054 | 1799054 | 2021-10-09 | Davie | North Carolina | 37059 | 6152 | 67 |
1795805 | 1795805 | 2021-10-08 | Davie | North Carolina | 37059 | 6152 | 67 |
1792556 | 1792556 | 2021-10-07 | Davie | North Carolina | 37059 | 6112 | 67 |
1789307 | 1789307 | 2021-10-06 | Davie | North Carolina | 37059 | 6088 | 66 |
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);