ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 10005 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174515 | 2174515 | 2022-02-02 | Sussex | Delaware | 10005 | 58885 | 761 |
2171262 | 2171262 | 2022-02-01 | Sussex | Delaware | 10005 | 58760 | 757 |
2168009 | 2168009 | 2022-01-31 | Sussex | Delaware | 10005 | 58688 | 756 |
2164754 | 2164754 | 2022-01-30 | Sussex | Delaware | 10005 | 58587 | 756 |
2161499 | 2161499 | 2022-01-29 | Sussex | Delaware | 10005 | 58391 | 756 |
2158243 | 2158243 | 2022-01-28 | Sussex | Delaware | 10005 | 58178 | 746 |
2154990 | 2154990 | 2022-01-27 | Sussex | Delaware | 10005 | 57822 | 743 |
2151737 | 2151737 | 2022-01-26 | Sussex | Delaware | 10005 | 57361 | 743 |
2148485 | 2148485 | 2022-01-25 | Sussex | Delaware | 10005 | 57129 | 742 |
2145233 | 2145233 | 2022-01-24 | Sussex | Delaware | 10005 | 56905 | 738 |
2141978 | 2141978 | 2022-01-23 | Sussex | Delaware | 10005 | 56571 | 738 |
2138723 | 2138723 | 2022-01-22 | Sussex | Delaware | 10005 | 56204 | 738 |
2135467 | 2135467 | 2022-01-21 | Sussex | Delaware | 10005 | 55486 | 736 |
2132215 | 2132215 | 2022-01-20 | Sussex | Delaware | 10005 | 55028 | 735 |
2128962 | 2128962 | 2022-01-19 | Sussex | Delaware | 10005 | 54531 | 732 |
2125708 | 2125708 | 2022-01-18 | Sussex | Delaware | 10005 | 54224 | 725 |
2122456 | 2122456 | 2022-01-17 | Sussex | Delaware | 10005 | 54011 | 725 |
2119204 | 2119204 | 2022-01-16 | Sussex | Delaware | 10005 | 53512 | 725 |
2115952 | 2115952 | 2022-01-15 | Sussex | Delaware | 10005 | 52805 | 725 |
2112701 | 2112701 | 2022-01-14 | Sussex | Delaware | 10005 | 51952 | 718 |
2109449 | 2109449 | 2022-01-13 | Sussex | Delaware | 10005 | 51137 | 712 |
2106198 | 2106198 | 2022-01-12 | Sussex | Delaware | 10005 | 50147 | 712 |
2102947 | 2102947 | 2022-01-11 | Sussex | Delaware | 10005 | 49315 | 711 |
2099696 | 2099696 | 2022-01-10 | Sussex | Delaware | 10005 | 48863 | 707 |
2096445 | 2096445 | 2022-01-09 | Sussex | Delaware | 10005 | 48355 | 707 |
2093193 | 2093193 | 2022-01-08 | Sussex | Delaware | 10005 | 47640 | 707 |
2089941 | 2089941 | 2022-01-07 | Sussex | Delaware | 10005 | 46989 | 697 |
2086690 | 2086690 | 2022-01-06 | Sussex | Delaware | 10005 | 46508 | 681 |
2083438 | 2083438 | 2022-01-05 | Sussex | Delaware | 10005 | 46085 | 681 |
2080186 | 2080186 | 2022-01-04 | Sussex | Delaware | 10005 | 45857 | 681 |
2076934 | 2076934 | 2022-01-03 | Sussex | Delaware | 10005 | 45253 | 681 |
2073683 | 2073683 | 2022-01-02 | Sussex | Delaware | 10005 | 44896 | 681 |
2070432 | 2070432 | 2022-01-01 | Sussex | Delaware | 10005 | 44129 | 681 |
2067181 | 2067181 | 2021-12-31 | Sussex | Delaware | 10005 | 43548 | 681 |
2063930 | 2063930 | 2021-12-30 | Sussex | Delaware | 10005 | 42695 | 681 |
2060680 | 2060680 | 2021-12-29 | Sussex | Delaware | 10005 | 42304 | 679 |
2057431 | 2057431 | 2021-12-28 | Sussex | Delaware | 10005 | 42029 | 676 |
2054182 | 2054182 | 2021-12-27 | Sussex | Delaware | 10005 | 41920 | 673 |
2050932 | 2050932 | 2021-12-26 | Sussex | Delaware | 10005 | 41826 | 673 |
2047682 | 2047682 | 2021-12-25 | Sussex | Delaware | 10005 | 41545 | 673 |
2044432 | 2044432 | 2021-12-24 | Sussex | Delaware | 10005 | 41279 | 673 |
2041183 | 2041183 | 2021-12-23 | Sussex | Delaware | 10005 | 41041 | 670 |
2037933 | 2037933 | 2021-12-22 | Sussex | Delaware | 10005 | 40814 | 669 |
2034683 | 2034683 | 2021-12-21 | Sussex | Delaware | 10005 | 40627 | 669 |
2031433 | 2031433 | 2021-12-20 | Sussex | Delaware | 10005 | 40508 | 667 |
2028182 | 2028182 | 2021-12-19 | Sussex | Delaware | 10005 | 40374 | 667 |
2024931 | 2024931 | 2021-12-18 | Sussex | Delaware | 10005 | 40184 | 667 |
2021680 | 2021680 | 2021-12-17 | Sussex | Delaware | 10005 | 39987 | 666 |
2018429 | 2018429 | 2021-12-16 | Sussex | Delaware | 10005 | 39782 | 665 |
2015179 | 2015179 | 2021-12-15 | Sussex | Delaware | 10005 | 39562 | 664 |
2011928 | 2011928 | 2021-12-14 | Sussex | Delaware | 10005 | 39423 | 664 |
2008677 | 2008677 | 2021-12-13 | Sussex | Delaware | 10005 | 39329 | 660 |
2005426 | 2005426 | 2021-12-12 | Sussex | Delaware | 10005 | 39229 | 660 |
2002175 | 2002175 | 2021-12-11 | Sussex | Delaware | 10005 | 39052 | 660 |
1998925 | 1998925 | 2021-12-10 | Sussex | Delaware | 10005 | 38922 | 660 |
1995674 | 1995674 | 2021-12-09 | Sussex | Delaware | 10005 | 38747 | 660 |
1992423 | 1992423 | 2021-12-08 | Sussex | Delaware | 10005 | 38557 | 660 |
1989172 | 1989172 | 2021-12-07 | Sussex | Delaware | 10005 | 38414 | 660 |
1985922 | 1985922 | 2021-12-06 | Sussex | Delaware | 10005 | 38364 | 655 |
1982672 | 1982672 | 2021-12-05 | Sussex | Delaware | 10005 | 38225 | 655 |
1979422 | 1979422 | 2021-12-04 | Sussex | Delaware | 10005 | 38097 | 655 |
1976172 | 1976172 | 2021-12-03 | Sussex | Delaware | 10005 | 37938 | 655 |
1972923 | 1972923 | 2021-12-02 | Sussex | Delaware | 10005 | 37777 | 653 |
1969673 | 1969673 | 2021-12-01 | Sussex | Delaware | 10005 | 37610 | 653 |
1966423 | 1966423 | 2021-11-30 | Sussex | Delaware | 10005 | 37513 | 653 |
1963171 | 1963171 | 2021-11-29 | Sussex | Delaware | 10005 | 37457 | 650 |
1959920 | 1959920 | 2021-11-28 | Sussex | Delaware | 10005 | 37407 | 650 |
1956669 | 1956669 | 2021-11-27 | Sussex | Delaware | 10005 | 37349 | 650 |
1953418 | 1953418 | 2021-11-26 | Sussex | Delaware | 10005 | 37297 | 650 |
1950167 | 1950167 | 2021-11-25 | Sussex | Delaware | 10005 | 37202 | 650 |
1946916 | 1946916 | 2021-11-24 | Sussex | Delaware | 10005 | 37062 | 647 |
1943665 | 1943665 | 2021-11-23 | Sussex | Delaware | 10005 | 37010 | 647 |
1940415 | 1940415 | 2021-11-22 | Sussex | Delaware | 10005 | 36955 | 647 |
1937165 | 1937165 | 2021-11-21 | Sussex | Delaware | 10005 | 36907 | 647 |
1933915 | 1933915 | 2021-11-20 | Sussex | Delaware | 10005 | 36846 | 647 |
1930663 | 1930663 | 2021-11-19 | Sussex | Delaware | 10005 | 36461 | 646 |
1927413 | 1927413 | 2021-11-18 | Sussex | Delaware | 10005 | 36400 | 646 |
1924163 | 1924163 | 2021-11-17 | Sussex | Delaware | 10005 | 36372 | 642 |
1920914 | 1920914 | 2021-11-16 | Sussex | Delaware | 10005 | 36348 | 642 |
1917664 | 1917664 | 2021-11-15 | Sussex | Delaware | 10005 | 36345 | 642 |
1914414 | 1914414 | 2021-11-14 | Sussex | Delaware | 10005 | 36318 | 642 |
1911164 | 1911164 | 2021-11-13 | Sussex | Delaware | 10005 | 36261 | 642 |
1907915 | 1907915 | 2021-11-12 | Sussex | Delaware | 10005 | 36186 | 639 |
1904666 | 1904666 | 2021-11-11 | Sussex | Delaware | 10005 | 36103 | 639 |
1901416 | 1901416 | 2021-11-10 | Sussex | Delaware | 10005 | 36056 | 639 |
1898166 | 1898166 | 2021-11-09 | Sussex | Delaware | 10005 | 36009 | 639 |
1894916 | 1894916 | 2021-11-08 | Sussex | Delaware | 10005 | 35992 | 638 |
1891666 | 1891666 | 2021-11-07 | Sussex | Delaware | 10005 | 35949 | 638 |
1888416 | 1888416 | 2021-11-06 | Sussex | Delaware | 10005 | 35886 | 638 |
1885166 | 1885166 | 2021-11-05 | Sussex | Delaware | 10005 | 35771 | 633 |
1881917 | 1881917 | 2021-11-04 | Sussex | Delaware | 10005 | 35771 | 633 |
1878668 | 1878668 | 2021-11-03 | Sussex | Delaware | 10005 | 35693 | 633 |
1875419 | 1875419 | 2021-11-02 | Sussex | Delaware | 10005 | 35627 | 633 |
1872170 | 1872170 | 2021-11-01 | Sussex | Delaware | 10005 | 35610 | 630 |
1868921 | 1868921 | 2021-10-31 | Sussex | Delaware | 10005 | 35560 | 630 |
1865672 | 1865672 | 2021-10-30 | Sussex | Delaware | 10005 | 35495 | 630 |
1862423 | 1862423 | 2021-10-29 | Sussex | Delaware | 10005 | 35419 | 630 |
1859174 | 1859174 | 2021-10-28 | Sussex | Delaware | 10005 | 35330 | 622 |
1855925 | 1855925 | 2021-10-27 | Sussex | Delaware | 10005 | 35252 | 621 |
1852676 | 1852676 | 2021-10-26 | Sussex | Delaware | 10005 | 35198 | 621 |
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);