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 553
- Sussex 547
- Kent 546
- Unknown 521
state 1
- Delaware · 2,167 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716210 | 1716210 | 2021-09-14 | Kent | Delaware | 10001 | 21996 | 393 |
1716211 | 1716211 | 2021-09-14 | New Castle | Delaware | 10003 | 72930 | 947 |
1716212 | 1716212 | 2021-09-14 | Sussex | Delaware | 10005 | 30630 | 562 |
1716213 | 1716213 | 2021-09-14 | Unknown | Delaware | 242 | 0 | |
1712964 | 1712964 | 2021-09-13 | Kent | Delaware | 10001 | 21965 | 393 |
1712965 | 1712965 | 2021-09-13 | New Castle | Delaware | 10003 | 72781 | 946 |
1712966 | 1712966 | 2021-09-13 | Sussex | Delaware | 10005 | 30560 | 561 |
1712967 | 1712967 | 2021-09-13 | Unknown | Delaware | 243 | 0 | |
1709717 | 1709717 | 2021-09-12 | Kent | Delaware | 10001 | 21882 | 393 |
1709718 | 1709718 | 2021-09-12 | New Castle | Delaware | 10003 | 72576 | 946 |
1709719 | 1709719 | 2021-09-12 | Sussex | Delaware | 10005 | 30406 | 561 |
1709720 | 1709720 | 2021-09-12 | Unknown | Delaware | 241 | 0 | |
1706470 | 1706470 | 2021-09-11 | Kent | Delaware | 10001 | 21786 | 393 |
1706471 | 1706471 | 2021-09-11 | New Castle | Delaware | 10003 | 72267 | 946 |
1706472 | 1706472 | 2021-09-11 | Sussex | Delaware | 10005 | 30280 | 561 |
1706473 | 1706473 | 2021-09-11 | Unknown | Delaware | 242 | 0 | |
1703222 | 1703222 | 2021-09-10 | Kent | Delaware | 10001 | 21652 | 393 |
1703223 | 1703223 | 2021-09-10 | New Castle | Delaware | 10003 | 71938 | 946 |
1703224 | 1703224 | 2021-09-10 | Sussex | Delaware | 10005 | 30125 | 561 |
1703225 | 1703225 | 2021-09-10 | Unknown | Delaware | 243 | 0 | |
1699972 | 1699972 | 2021-09-09 | Kent | Delaware | 10001 | 21504 | 393 |
1699973 | 1699973 | 2021-09-09 | New Castle | Delaware | 10003 | 71594 | 946 |
1699974 | 1699974 | 2021-09-09 | Sussex | Delaware | 10005 | 29969 | 561 |
1699975 | 1699975 | 2021-09-09 | Unknown | Delaware | 241 | 0 | |
1696723 | 1696723 | 2021-09-08 | Kent | Delaware | 10001 | 21393 | 392 |
1696724 | 1696724 | 2021-09-08 | New Castle | Delaware | 10003 | 71452 | 941 |
1696725 | 1696725 | 2021-09-08 | Sussex | Delaware | 10005 | 29870 | 561 |
1696726 | 1696726 | 2021-09-08 | Unknown | Delaware | 241 | 0 | |
1693475 | 1693475 | 2021-09-07 | Kent | Delaware | 10001 | 21350 | 392 |
1693476 | 1693476 | 2021-09-07 | New Castle | Delaware | 10003 | 71325 | 940 |
1693477 | 1693477 | 2021-09-07 | Sussex | Delaware | 10005 | 29801 | 559 |
1693478 | 1693478 | 2021-09-07 | Unknown | Delaware | 242 | 0 | |
1690226 | 1690226 | 2021-09-06 | Kent | Delaware | 10001 | 21273 | 392 |
1690227 | 1690227 | 2021-09-06 | New Castle | Delaware | 10003 | 71154 | 940 |
1690228 | 1690228 | 2021-09-06 | Sussex | Delaware | 10005 | 29702 | 559 |
1690229 | 1690229 | 2021-09-06 | Unknown | Delaware | 241 | 0 | |
1686976 | 1686976 | 2021-09-05 | Kent | Delaware | 10001 | 21219 | 392 |
1686977 | 1686977 | 2021-09-05 | New Castle | Delaware | 10003 | 71033 | 940 |
1686978 | 1686978 | 2021-09-05 | Sussex | Delaware | 10005 | 29619 | 559 |
1686979 | 1686979 | 2021-09-05 | Unknown | Delaware | 240 | 0 | |
1683726 | 1683726 | 2021-09-04 | Kent | Delaware | 10001 | 21131 | 392 |
1683727 | 1683727 | 2021-09-04 | New Castle | Delaware | 10003 | 70857 | 940 |
1683728 | 1683728 | 2021-09-04 | Sussex | Delaware | 10005 | 29515 | 559 |
1683729 | 1683729 | 2021-09-04 | Unknown | Delaware | 241 | 0 | |
1680475 | 1680475 | 2021-09-03 | Kent | Delaware | 10001 | 21002 | 392 |
1680476 | 1680476 | 2021-09-03 | New Castle | Delaware | 10003 | 70664 | 937 |
1680477 | 1680477 | 2021-09-03 | Sussex | Delaware | 10005 | 29378 | 559 |
1680478 | 1680478 | 2021-09-03 | Unknown | Delaware | 239 | 0 | |
1677227 | 1677227 | 2021-09-02 | Kent | Delaware | 10001 | 20867 | 392 |
1677228 | 1677228 | 2021-09-02 | New Castle | Delaware | 10003 | 70381 | 937 |
1677229 | 1677229 | 2021-09-02 | Sussex | Delaware | 10005 | 29239 | 559 |
1677230 | 1677230 | 2021-09-02 | Unknown | Delaware | 240 | 0 | |
1673980 | 1673980 | 2021-09-01 | Kent | Delaware | 10001 | 20730 | 392 |
1673981 | 1673981 | 2021-09-01 | New Castle | Delaware | 10003 | 70118 | 936 |
1673982 | 1673982 | 2021-09-01 | Sussex | Delaware | 10005 | 29094 | 559 |
1673983 | 1673983 | 2021-09-01 | Unknown | Delaware | 238 | 0 | |
1670732 | 1670732 | 2021-08-31 | Kent | Delaware | 10001 | 20649 | 390 |
1670733 | 1670733 | 2021-08-31 | New Castle | Delaware | 10003 | 69966 | 933 |
1670734 | 1670734 | 2021-08-31 | Sussex | Delaware | 10005 | 28999 | 557 |
1670735 | 1670735 | 2021-08-31 | Unknown | Delaware | 238 | 0 | |
1667485 | 1667485 | 2021-08-30 | Kent | Delaware | 10001 | 20596 | 389 |
1667486 | 1667486 | 2021-08-30 | New Castle | Delaware | 10003 | 69877 | 932 |
1667487 | 1667487 | 2021-08-30 | Sussex | Delaware | 10005 | 28910 | 556 |
1667488 | 1667488 | 2021-08-30 | Unknown | Delaware | 237 | 0 | |
1664238 | 1664238 | 2021-08-29 | Kent | Delaware | 10001 | 20516 | 389 |
1664239 | 1664239 | 2021-08-29 | New Castle | Delaware | 10003 | 69660 | 932 |
1664240 | 1664240 | 2021-08-29 | Sussex | Delaware | 10005 | 28813 | 556 |
1664241 | 1664241 | 2021-08-29 | Unknown | Delaware | 237 | 0 | |
1660990 | 1660990 | 2021-08-28 | Kent | Delaware | 10001 | 20459 | 389 |
1660991 | 1660991 | 2021-08-28 | New Castle | Delaware | 10003 | 69507 | 932 |
1660992 | 1660992 | 2021-08-28 | Sussex | Delaware | 10005 | 28724 | 556 |
1660993 | 1660993 | 2021-08-28 | Unknown | Delaware | 236 | 0 | |
1657742 | 1657742 | 2021-08-27 | Kent | Delaware | 10001 | 20340 | 388 |
1657743 | 1657743 | 2021-08-27 | New Castle | Delaware | 10003 | 69360 | 931 |
1657744 | 1657744 | 2021-08-27 | Sussex | Delaware | 10005 | 28609 | 556 |
1657745 | 1657745 | 2021-08-27 | Unknown | Delaware | 235 | 0 | |
1654494 | 1654494 | 2021-08-26 | Kent | Delaware | 10001 | 20208 | 388 |
1654495 | 1654495 | 2021-08-26 | New Castle | Delaware | 10003 | 69101 | 929 |
1654496 | 1654496 | 2021-08-26 | Sussex | Delaware | 10005 | 28474 | 555 |
1654497 | 1654497 | 2021-08-26 | Unknown | Delaware | 233 | 0 | |
1651247 | 1651247 | 2021-08-25 | Kent | Delaware | 10001 | 20114 | 388 |
1651248 | 1651248 | 2021-08-25 | New Castle | Delaware | 10003 | 68878 | 928 |
1651249 | 1651249 | 2021-08-25 | Sussex | Delaware | 10005 | 28362 | 553 |
1651250 | 1651250 | 2021-08-25 | Unknown | Delaware | 233 | 0 | |
1647998 | 1647998 | 2021-08-24 | Kent | Delaware | 10001 | 20020 | 387 |
1647999 | 1647999 | 2021-08-24 | New Castle | Delaware | 10003 | 68740 | 921 |
1648000 | 1648000 | 2021-08-24 | Sussex | Delaware | 10005 | 28253 | 549 |
1648001 | 1648001 | 2021-08-24 | Unknown | Delaware | 233 | 0 | |
1644750 | 1644750 | 2021-08-23 | Kent | Delaware | 10001 | 19988 | 387 |
1644751 | 1644751 | 2021-08-23 | New Castle | Delaware | 10003 | 68630 | 918 |
1644752 | 1644752 | 2021-08-23 | Sussex | Delaware | 10005 | 28199 | 549 |
1644753 | 1644753 | 2021-08-23 | Unknown | Delaware | 234 | 0 | |
1641500 | 1641500 | 2021-08-22 | Kent | Delaware | 10001 | 19942 | 387 |
1641501 | 1641501 | 2021-08-22 | New Castle | Delaware | 10003 | 68493 | 918 |
1641502 | 1641502 | 2021-08-22 | Sussex | Delaware | 10005 | 28102 | 549 |
1641503 | 1641503 | 2021-08-22 | Unknown | Delaware | 234 | 0 | |
1638250 | 1638250 | 2021-08-21 | Kent | Delaware | 10001 | 19866 | 387 |
1638251 | 1638251 | 2021-08-21 | New Castle | Delaware | 10003 | 68353 | 918 |
1638252 | 1638252 | 2021-08-21 | Sussex | Delaware | 10005 | 28009 | 549 |
1638253 | 1638253 | 2021-08-21 | Unknown | Delaware | 233 | 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);