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 694
- Sussex 688
- Kent 687
- Unknown 662
state 1
- Delaware · 2,731 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174513 | 2174513 | 2022-02-02 | Kent | Delaware | 10001 | 47920 | 560 |
2174514 | 2174514 | 2022-02-02 | New Castle | Delaware | 10003 | 141217 | 1231 |
2174515 | 2174515 | 2022-02-02 | Sussex | Delaware | 10005 | 58885 | 761 |
2174516 | 2174516 | 2022-02-02 | Unknown | Delaware | 888 | 0 | |
2171260 | 2171260 | 2022-02-01 | Kent | Delaware | 10001 | 47771 | 558 |
2171261 | 2171261 | 2022-02-01 | New Castle | Delaware | 10003 | 141029 | 1229 |
2171262 | 2171262 | 2022-02-01 | Sussex | Delaware | 10005 | 58760 | 757 |
2171263 | 2171263 | 2022-02-01 | Unknown | Delaware | 887 | 0 | |
2168007 | 2168007 | 2022-01-31 | Kent | Delaware | 10001 | 47695 | 551 |
2168008 | 2168008 | 2022-01-31 | New Castle | Delaware | 10003 | 140842 | 1224 |
2168009 | 2168009 | 2022-01-31 | Sussex | Delaware | 10005 | 58688 | 756 |
2168010 | 2168010 | 2022-01-31 | Unknown | Delaware | 886 | 0 | |
2164752 | 2164752 | 2022-01-30 | Kent | Delaware | 10001 | 47598 | 551 |
2164753 | 2164753 | 2022-01-30 | New Castle | Delaware | 10003 | 140567 | 1224 |
2164754 | 2164754 | 2022-01-30 | Sussex | Delaware | 10005 | 58587 | 756 |
2164755 | 2164755 | 2022-01-30 | Unknown | Delaware | 886 | 0 | |
2161497 | 2161497 | 2022-01-29 | Kent | Delaware | 10001 | 47434 | 551 |
2161498 | 2161498 | 2022-01-29 | New Castle | Delaware | 10003 | 140248 | 1224 |
2161499 | 2161499 | 2022-01-29 | Sussex | Delaware | 10005 | 58391 | 756 |
2161500 | 2161500 | 2022-01-29 | Unknown | Delaware | 886 | 0 | |
2158241 | 2158241 | 2022-01-28 | Kent | Delaware | 10001 | 47198 | 538 |
2158242 | 2158242 | 2022-01-28 | New Castle | Delaware | 10003 | 139775 | 1214 |
2158243 | 2158243 | 2022-01-28 | Sussex | Delaware | 10005 | 58178 | 746 |
2158244 | 2158244 | 2022-01-28 | Unknown | Delaware | 886 | 0 | |
2154988 | 2154988 | 2022-01-27 | Kent | Delaware | 10001 | 46908 | 538 |
2154989 | 2154989 | 2022-01-27 | New Castle | Delaware | 10003 | 139117 | 1213 |
2154990 | 2154990 | 2022-01-27 | Sussex | Delaware | 10005 | 57822 | 743 |
2154991 | 2154991 | 2022-01-27 | Unknown | Delaware | 883 | 0 | |
2151735 | 2151735 | 2022-01-26 | Kent | Delaware | 10001 | 46583 | 537 |
2151736 | 2151736 | 2022-01-26 | New Castle | Delaware | 10003 | 138376 | 1213 |
2151737 | 2151737 | 2022-01-26 | Sussex | Delaware | 10005 | 57361 | 743 |
2151738 | 2151738 | 2022-01-26 | Unknown | Delaware | 882 | 0 | |
2148483 | 2148483 | 2022-01-25 | Kent | Delaware | 10001 | 46314 | 537 |
2148484 | 2148484 | 2022-01-25 | New Castle | Delaware | 10003 | 138002 | 1210 |
2148485 | 2148485 | 2022-01-25 | Sussex | Delaware | 10005 | 57129 | 742 |
2148486 | 2148486 | 2022-01-25 | Unknown | Delaware | 879 | 0 | |
2145231 | 2145231 | 2022-01-24 | Kent | Delaware | 10001 | 46093 | 537 |
2145232 | 2145232 | 2022-01-24 | New Castle | Delaware | 10003 | 137494 | 1205 |
2145233 | 2145233 | 2022-01-24 | Sussex | Delaware | 10005 | 56905 | 738 |
2145234 | 2145234 | 2022-01-24 | Unknown | Delaware | 875 | 0 | |
2141976 | 2141976 | 2022-01-23 | Kent | Delaware | 10001 | 45910 | 537 |
2141977 | 2141977 | 2022-01-23 | New Castle | Delaware | 10003 | 136824 | 1205 |
2141978 | 2141978 | 2022-01-23 | Sussex | Delaware | 10005 | 56571 | 738 |
2141979 | 2141979 | 2022-01-23 | Unknown | Delaware | 874 | 0 | |
2138721 | 2138721 | 2022-01-22 | Kent | Delaware | 10001 | 45510 | 536 |
2138722 | 2138722 | 2022-01-22 | New Castle | Delaware | 10003 | 135915 | 1206 |
2138723 | 2138723 | 2022-01-22 | Sussex | Delaware | 10005 | 56204 | 738 |
2138724 | 2138724 | 2022-01-22 | Unknown | Delaware | 872 | 0 | |
2135465 | 2135465 | 2022-01-21 | Kent | Delaware | 10001 | 44848 | 522 |
2135466 | 2135466 | 2022-01-21 | New Castle | Delaware | 10003 | 134821 | 1199 |
2135467 | 2135467 | 2022-01-21 | Sussex | Delaware | 10005 | 55486 | 736 |
2135468 | 2135468 | 2022-01-21 | Unknown | Delaware | 867 | 0 | |
2132213 | 2132213 | 2022-01-20 | Kent | Delaware | 10001 | 44311 | 522 |
2132214 | 2132214 | 2022-01-20 | New Castle | Delaware | 10003 | 133641 | 1193 |
2132215 | 2132215 | 2022-01-20 | Sussex | Delaware | 10005 | 55028 | 735 |
2132216 | 2132216 | 2022-01-20 | Unknown | Delaware | 863 | 0 | |
2128960 | 2128960 | 2022-01-19 | Kent | Delaware | 10001 | 43874 | 522 |
2128961 | 2128961 | 2022-01-19 | New Castle | Delaware | 10003 | 132866 | 1186 |
2128962 | 2128962 | 2022-01-19 | Sussex | Delaware | 10005 | 54531 | 732 |
2128963 | 2128963 | 2022-01-19 | Unknown | Delaware | 861 | 0 | |
2125706 | 2125706 | 2022-01-18 | Kent | Delaware | 10001 | 43674 | 522 |
2125707 | 2125707 | 2022-01-18 | New Castle | Delaware | 10003 | 132118 | 1177 |
2125708 | 2125708 | 2022-01-18 | Sussex | Delaware | 10005 | 54224 | 725 |
2125709 | 2125709 | 2022-01-18 | Unknown | Delaware | 860 | 0 | |
2122454 | 2122454 | 2022-01-17 | Kent | Delaware | 10001 | 43544 | 522 |
2122455 | 2122455 | 2022-01-17 | New Castle | Delaware | 10003 | 131345 | 1177 |
2122456 | 2122456 | 2022-01-17 | Sussex | Delaware | 10005 | 54011 | 725 |
2122457 | 2122457 | 2022-01-17 | Unknown | Delaware | 859 | 0 | |
2119202 | 2119202 | 2022-01-16 | Kent | Delaware | 10001 | 42958 | 522 |
2119203 | 2119203 | 2022-01-16 | New Castle | Delaware | 10003 | 130278 | 1177 |
2119204 | 2119204 | 2022-01-16 | Sussex | Delaware | 10005 | 53512 | 725 |
2119205 | 2119205 | 2022-01-16 | Unknown | Delaware | 846 | 0 | |
2115950 | 2115950 | 2022-01-15 | Kent | Delaware | 10001 | 42478 | 522 |
2115951 | 2115951 | 2022-01-15 | New Castle | Delaware | 10003 | 128976 | 1177 |
2115952 | 2115952 | 2022-01-15 | Sussex | Delaware | 10005 | 52805 | 725 |
2115953 | 2115953 | 2022-01-15 | Unknown | Delaware | 835 | 0 | |
2112699 | 2112699 | 2022-01-14 | Kent | Delaware | 10001 | 41752 | 519 |
2112700 | 2112700 | 2022-01-14 | New Castle | Delaware | 10003 | 127278 | 1159 |
2112701 | 2112701 | 2022-01-14 | Sussex | Delaware | 10005 | 51952 | 718 |
2112702 | 2112702 | 2022-01-14 | Unknown | Delaware | 829 | 0 | |
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 |
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);