ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,131 rows where state = "Delaware" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 4
- New Castle 674
- Sussex 668
- Kent 667
- Unknown 642
state 1
- Delaware · 2,651 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109447 | 2109447 | 2022-01-13 | Kent | Delaware | 10001 | 40997 | 512 |
2109448 | 2109448 | 2022-01-13 | New Castle | Delaware | 10003 | 125537 | 1156 |
2109449 | 2109449 | 2022-01-13 | Sussex | Delaware | 10005 | 51137 | 712 |
2109450 | 2109450 | 2022-01-13 | Unknown | Delaware | 815 | 0 | |
2106196 | 2106196 | 2022-01-12 | Kent | Delaware | 10001 | 40005 | 512 |
2106197 | 2106197 | 2022-01-12 | New Castle | Delaware | 10003 | 123038 | 1153 |
2106198 | 2106198 | 2022-01-12 | Sussex | Delaware | 10005 | 50147 | 712 |
2106199 | 2106199 | 2022-01-12 | Unknown | Delaware | 803 | 0 | |
2102945 | 2102945 | 2022-01-11 | Kent | Delaware | 10001 | 39333 | 512 |
2102946 | 2102946 | 2022-01-11 | New Castle | Delaware | 10003 | 121001 | 1150 |
2102947 | 2102947 | 2022-01-11 | Sussex | Delaware | 10005 | 49315 | 711 |
2102948 | 2102948 | 2022-01-11 | Unknown | Delaware | 788 | 0 | |
2099694 | 2099694 | 2022-01-10 | Kent | Delaware | 10001 | 38971 | 512 |
2099695 | 2099695 | 2022-01-10 | New Castle | Delaware | 10003 | 119730 | 1146 |
2099696 | 2099696 | 2022-01-10 | Sussex | Delaware | 10005 | 48863 | 707 |
2099697 | 2099697 | 2022-01-10 | Unknown | Delaware | 776 | 0 | |
2096443 | 2096443 | 2022-01-09 | Kent | Delaware | 10001 | 38537 | 512 |
2096444 | 2096444 | 2022-01-09 | New Castle | Delaware | 10003 | 117976 | 1146 |
2096445 | 2096445 | 2022-01-09 | Sussex | Delaware | 10005 | 48355 | 707 |
2096446 | 2096446 | 2022-01-09 | Unknown | Delaware | 772 | 0 | |
2093191 | 2093191 | 2022-01-08 | Kent | Delaware | 10001 | 37953 | 512 |
2093192 | 2093192 | 2022-01-08 | New Castle | Delaware | 10003 | 115882 | 1146 |
2093193 | 2093193 | 2022-01-08 | Sussex | Delaware | 10005 | 47640 | 707 |
2093194 | 2093194 | 2022-01-08 | Unknown | Delaware | 761 | 0 | |
2089939 | 2089939 | 2022-01-07 | Kent | Delaware | 10001 | 37076 | 503 |
2089940 | 2089940 | 2022-01-07 | New Castle | Delaware | 10003 | 113698 | 1130 |
2089941 | 2089941 | 2022-01-07 | Sussex | Delaware | 10005 | 46989 | 697 |
2089942 | 2089942 | 2022-01-07 | Unknown | Delaware | 744 | 0 | |
2086688 | 2086688 | 2022-01-06 | Kent | Delaware | 10001 | 36519 | 493 |
2086689 | 2086689 | 2022-01-06 | New Castle | Delaware | 10003 | 111837 | 1112 |
2086690 | 2086690 | 2022-01-06 | Sussex | Delaware | 10005 | 46508 | 681 |
2086691 | 2086691 | 2022-01-06 | Unknown | Delaware | 736 | 0 | |
2083436 | 2083436 | 2022-01-05 | Kent | Delaware | 10001 | 36166 | 493 |
2083437 | 2083437 | 2022-01-05 | New Castle | Delaware | 10003 | 109986 | 1112 |
2083438 | 2083438 | 2022-01-05 | Sussex | Delaware | 10005 | 46085 | 681 |
2083439 | 2083439 | 2022-01-05 | Unknown | Delaware | 731 | 0 | |
2080184 | 2080184 | 2022-01-04 | Kent | Delaware | 10001 | 36002 | 493 |
2080185 | 2080185 | 2022-01-04 | New Castle | Delaware | 10003 | 109060 | 1112 |
2080186 | 2080186 | 2022-01-04 | Sussex | Delaware | 10005 | 45857 | 681 |
2080187 | 2080187 | 2022-01-04 | Unknown | Delaware | 730 | 0 | |
2076932 | 2076932 | 2022-01-03 | Kent | Delaware | 10001 | 35647 | 493 |
2076933 | 2076933 | 2022-01-03 | New Castle | Delaware | 10003 | 107755 | 1112 |
2076934 | 2076934 | 2022-01-03 | Sussex | Delaware | 10005 | 45253 | 681 |
2076935 | 2076935 | 2022-01-03 | Unknown | Delaware | 727 | 0 | |
2073681 | 2073681 | 2022-01-02 | Kent | Delaware | 10001 | 35219 | 493 |
2073682 | 2073682 | 2022-01-02 | New Castle | Delaware | 10003 | 106161 | 1112 |
2073683 | 2073683 | 2022-01-02 | Sussex | Delaware | 10005 | 44896 | 681 |
2073684 | 2073684 | 2022-01-02 | Unknown | Delaware | 720 | 0 | |
2070430 | 2070430 | 2022-01-01 | Kent | Delaware | 10001 | 34609 | 493 |
2070431 | 2070431 | 2022-01-01 | New Castle | Delaware | 10003 | 104426 | 1112 |
2070432 | 2070432 | 2022-01-01 | Sussex | Delaware | 10005 | 44129 | 681 |
2070433 | 2070433 | 2022-01-01 | Unknown | Delaware | 716 | 0 | |
2067179 | 2067179 | 2021-12-31 | Kent | Delaware | 10001 | 34199 | 493 |
2067180 | 2067180 | 2021-12-31 | New Castle | Delaware | 10003 | 101913 | 1112 |
2067181 | 2067181 | 2021-12-31 | Sussex | Delaware | 10005 | 43548 | 681 |
2067182 | 2067182 | 2021-12-31 | Unknown | Delaware | 706 | 0 | |
2063928 | 2063928 | 2021-12-30 | Kent | Delaware | 10001 | 33461 | 493 |
2063929 | 2063929 | 2021-12-30 | New Castle | Delaware | 10003 | 100020 | 1112 |
2063930 | 2063930 | 2021-12-30 | Sussex | Delaware | 10005 | 42695 | 681 |
2063931 | 2063931 | 2021-12-30 | Unknown | Delaware | 687 | 0 | |
2060678 | 2060678 | 2021-12-29 | Kent | Delaware | 10001 | 33104 | 493 |
2060679 | 2060679 | 2021-12-29 | New Castle | Delaware | 10003 | 98819 | 1111 |
2060680 | 2060680 | 2021-12-29 | Sussex | Delaware | 10005 | 42304 | 679 |
2060681 | 2060681 | 2021-12-29 | Unknown | Delaware | 682 | 0 | |
2057429 | 2057429 | 2021-12-28 | Kent | Delaware | 10001 | 32879 | 493 |
2057430 | 2057430 | 2021-12-28 | New Castle | Delaware | 10003 | 98237 | 1107 |
2057431 | 2057431 | 2021-12-28 | Sussex | Delaware | 10005 | 42029 | 676 |
2057432 | 2057432 | 2021-12-28 | Unknown | Delaware | 679 | 0 | |
2054180 | 2054180 | 2021-12-27 | Kent | Delaware | 10001 | 32734 | 493 |
2054181 | 2054181 | 2021-12-27 | New Castle | Delaware | 10003 | 97915 | 1105 |
2054182 | 2054182 | 2021-12-27 | Sussex | Delaware | 10005 | 41920 | 673 |
2054183 | 2054183 | 2021-12-27 | Unknown | Delaware | 689 | 0 | |
2050930 | 2050930 | 2021-12-26 | Kent | Delaware | 10001 | 32682 | 493 |
2050931 | 2050931 | 2021-12-26 | New Castle | Delaware | 10003 | 97631 | 1105 |
2050932 | 2050932 | 2021-12-26 | Sussex | Delaware | 10005 | 41826 | 673 |
2050933 | 2050933 | 2021-12-26 | Unknown | Delaware | 688 | 0 | |
2047680 | 2047680 | 2021-12-25 | Kent | Delaware | 10001 | 32509 | 493 |
2047681 | 2047681 | 2021-12-25 | New Castle | Delaware | 10003 | 96862 | 1105 |
2047682 | 2047682 | 2021-12-25 | Sussex | Delaware | 10005 | 41545 | 673 |
2047683 | 2047683 | 2021-12-25 | Unknown | Delaware | 647 | 0 | |
2044430 | 2044430 | 2021-12-24 | Kent | Delaware | 10001 | 32155 | 493 |
2044431 | 2044431 | 2021-12-24 | New Castle | Delaware | 10003 | 95970 | 1105 |
2044432 | 2044432 | 2021-12-24 | Sussex | Delaware | 10005 | 41279 | 673 |
2044433 | 2044433 | 2021-12-24 | Unknown | Delaware | 605 | 0 | |
2041181 | 2041181 | 2021-12-23 | Kent | Delaware | 10001 | 31866 | 489 |
2041182 | 2041182 | 2021-12-23 | New Castle | Delaware | 10003 | 95144 | 1096 |
2041183 | 2041183 | 2021-12-23 | Sussex | Delaware | 10005 | 41041 | 670 |
2041184 | 2041184 | 2021-12-23 | Unknown | Delaware | 580 | 0 | |
2037931 | 2037931 | 2021-12-22 | Kent | Delaware | 10001 | 31582 | 485 |
2037932 | 2037932 | 2021-12-22 | New Castle | Delaware | 10003 | 94520 | 1095 |
2037933 | 2037933 | 2021-12-22 | Sussex | Delaware | 10005 | 40814 | 669 |
2037934 | 2037934 | 2021-12-22 | Unknown | Delaware | 577 | 0 | |
2034681 | 2034681 | 2021-12-21 | Kent | Delaware | 10001 | 31398 | 485 |
2034682 | 2034682 | 2021-12-21 | New Castle | Delaware | 10003 | 94218 | 1095 |
2034683 | 2034683 | 2021-12-21 | Sussex | Delaware | 10005 | 40627 | 669 |
2034684 | 2034684 | 2021-12-21 | Unknown | Delaware | 577 | 0 | |
2031431 | 2031431 | 2021-12-20 | Kent | Delaware | 10001 | 31283 | 484 |
2031432 | 2031432 | 2021-12-20 | New Castle | Delaware | 10003 | 93921 | 1091 |
2031433 | 2031433 | 2021-12-20 | Sussex | Delaware | 10005 | 40508 | 667 |
2031434 | 2031434 | 2021-12-20 | Unknown | Delaware | 580 | 0 |
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);