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 461
- Sussex 455
- Kent 454
- Unknown 429
state 1
- Delaware · 1,799 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417447 | 1417447 | 2021-06-14 | Kent | Delaware | 10001 | 18175 | 346 |
1417448 | 1417448 | 2021-06-14 | New Castle | Delaware | 10003 | 64842 | 836 |
1417449 | 1417449 | 2021-06-14 | Sussex | Delaware | 10005 | 26135 | 497 |
1417450 | 1417450 | 2021-06-14 | Unknown | Delaware | 227 | 0 | |
1414201 | 1414201 | 2021-06-13 | Kent | Delaware | 10001 | 18175 | 346 |
1414202 | 1414202 | 2021-06-13 | New Castle | Delaware | 10003 | 64823 | 836 |
1414203 | 1414203 | 2021-06-13 | Sussex | Delaware | 10005 | 26133 | 497 |
1414204 | 1414204 | 2021-06-13 | Unknown | Delaware | 227 | 0 | |
1410956 | 1410956 | 2021-06-12 | Kent | Delaware | 10001 | 18172 | 346 |
1410957 | 1410957 | 2021-06-12 | New Castle | Delaware | 10003 | 64802 | 836 |
1410958 | 1410958 | 2021-06-12 | Sussex | Delaware | 10005 | 26121 | 497 |
1410959 | 1410959 | 2021-06-12 | Unknown | Delaware | 227 | 0 | |
1407711 | 1407711 | 2021-06-11 | Kent | Delaware | 10001 | 18168 | 346 |
1407712 | 1407712 | 2021-06-11 | New Castle | Delaware | 10003 | 64784 | 836 |
1407713 | 1407713 | 2021-06-11 | Sussex | Delaware | 10005 | 26117 | 497 |
1407714 | 1407714 | 2021-06-11 | Unknown | Delaware | 227 | 0 | |
1404465 | 1404465 | 2021-06-10 | Kent | Delaware | 10001 | 18164 | 346 |
1404466 | 1404466 | 2021-06-10 | New Castle | Delaware | 10003 | 64761 | 836 |
1404467 | 1404467 | 2021-06-10 | Sussex | Delaware | 10005 | 26106 | 497 |
1404468 | 1404468 | 2021-06-10 | Unknown | Delaware | 227 | 0 | |
1401220 | 1401220 | 2021-06-09 | Kent | Delaware | 10001 | 18159 | 345 |
1401221 | 1401221 | 2021-06-09 | New Castle | Delaware | 10003 | 64742 | 835 |
1401222 | 1401222 | 2021-06-09 | Sussex | Delaware | 10005 | 26097 | 497 |
1401223 | 1401223 | 2021-06-09 | Unknown | Delaware | 227 | 0 | |
1397975 | 1397975 | 2021-06-08 | Kent | Delaware | 10001 | 18155 | 345 |
1397976 | 1397976 | 2021-06-08 | New Castle | Delaware | 10003 | 64726 | 835 |
1397977 | 1397977 | 2021-06-08 | Sussex | Delaware | 10005 | 26081 | 497 |
1397978 | 1397978 | 2021-06-08 | Unknown | Delaware | 226 | 0 | |
1394728 | 1394728 | 2021-06-07 | Kent | Delaware | 10001 | 18153 | 345 |
1394729 | 1394729 | 2021-06-07 | New Castle | Delaware | 10003 | 64716 | 835 |
1394730 | 1394730 | 2021-06-07 | Sussex | Delaware | 10005 | 26072 | 497 |
1394731 | 1394731 | 2021-06-07 | Unknown | Delaware | 226 | 0 | |
1391483 | 1391483 | 2021-06-06 | Kent | Delaware | 10001 | 18150 | 345 |
1391484 | 1391484 | 2021-06-06 | New Castle | Delaware | 10003 | 64690 | 835 |
1391485 | 1391485 | 2021-06-06 | Sussex | Delaware | 10005 | 26060 | 497 |
1391486 | 1391486 | 2021-06-06 | Unknown | Delaware | 226 | 0 | |
1388238 | 1388238 | 2021-06-05 | Kent | Delaware | 10001 | 18143 | 345 |
1388239 | 1388239 | 2021-06-05 | New Castle | Delaware | 10003 | 64656 | 835 |
1388240 | 1388240 | 2021-06-05 | Sussex | Delaware | 10005 | 26045 | 497 |
1388241 | 1388241 | 2021-06-05 | Unknown | Delaware | 226 | 0 | |
1384993 | 1384993 | 2021-06-04 | Kent | Delaware | 10001 | 18129 | 345 |
1384994 | 1384994 | 2021-06-04 | New Castle | Delaware | 10003 | 64631 | 832 |
1384995 | 1384995 | 2021-06-04 | Sussex | Delaware | 10005 | 26019 | 497 |
1384996 | 1384996 | 2021-06-04 | Unknown | Delaware | 226 | 0 | |
1381747 | 1381747 | 2021-06-03 | Kent | Delaware | 10001 | 18126 | 344 |
1381748 | 1381748 | 2021-06-03 | New Castle | Delaware | 10003 | 64608 | 828 |
1381749 | 1381749 | 2021-06-03 | Sussex | Delaware | 10005 | 25997 | 496 |
1381750 | 1381750 | 2021-06-03 | Unknown | Delaware | 226 | 0 | |
1378502 | 1378502 | 2021-06-02 | Kent | Delaware | 10001 | 18120 | 344 |
1378503 | 1378503 | 2021-06-02 | New Castle | Delaware | 10003 | 64578 | 827 |
1378504 | 1378504 | 2021-06-02 | Sussex | Delaware | 10005 | 25987 | 495 |
1378505 | 1378505 | 2021-06-02 | Unknown | Delaware | 226 | 0 | |
1375256 | 1375256 | 2021-06-01 | Kent | Delaware | 10001 | 18118 | 344 |
1375257 | 1375257 | 2021-06-01 | New Castle | Delaware | 10003 | 64566 | 824 |
1375258 | 1375258 | 2021-06-01 | Sussex | Delaware | 10005 | 25984 | 493 |
1375259 | 1375259 | 2021-06-01 | Unknown | Delaware | 226 | 0 | |
1372011 | 1372011 | 2021-05-31 | Kent | Delaware | 10001 | 18113 | 344 |
1372012 | 1372012 | 2021-05-31 | New Castle | Delaware | 10003 | 64555 | 824 |
1372013 | 1372013 | 2021-05-31 | Sussex | Delaware | 10005 | 25972 | 493 |
1372014 | 1372014 | 2021-05-31 | Unknown | Delaware | 226 | 0 | |
1368766 | 1368766 | 2021-05-30 | Kent | Delaware | 10001 | 18108 | 344 |
1368767 | 1368767 | 2021-05-30 | New Castle | Delaware | 10003 | 64524 | 824 |
1368768 | 1368768 | 2021-05-30 | Sussex | Delaware | 10005 | 25963 | 493 |
1368769 | 1368769 | 2021-05-30 | Unknown | Delaware | 226 | 0 | |
1365520 | 1365520 | 2021-05-29 | Kent | Delaware | 10001 | 18103 | 344 |
1365521 | 1365521 | 2021-05-29 | New Castle | Delaware | 10003 | 64504 | 824 |
1365522 | 1365522 | 2021-05-29 | Sussex | Delaware | 10005 | 25937 | 493 |
1365523 | 1365523 | 2021-05-29 | Unknown | Delaware | 226 | 0 | |
1362274 | 1362274 | 2021-05-28 | Kent | Delaware | 10001 | 18094 | 343 |
1362275 | 1362275 | 2021-05-28 | New Castle | Delaware | 10003 | 64448 | 824 |
1362276 | 1362276 | 2021-05-28 | Sussex | Delaware | 10005 | 25915 | 493 |
1362277 | 1362277 | 2021-05-28 | Unknown | Delaware | 224 | 0 | |
1359027 | 1359027 | 2021-05-27 | Kent | Delaware | 10001 | 18087 | 343 |
1359028 | 1359028 | 2021-05-27 | New Castle | Delaware | 10003 | 64396 | 824 |
1359029 | 1359029 | 2021-05-27 | Sussex | Delaware | 10005 | 25900 | 493 |
1359030 | 1359030 | 2021-05-27 | Unknown | Delaware | 224 | 0 | |
1355781 | 1355781 | 2021-05-26 | Kent | Delaware | 10001 | 18077 | 343 |
1355782 | 1355782 | 2021-05-26 | New Castle | Delaware | 10003 | 64351 | 824 |
1355783 | 1355783 | 2021-05-26 | Sussex | Delaware | 10005 | 25881 | 493 |
1355784 | 1355784 | 2021-05-26 | Unknown | Delaware | 223 | 0 | |
1352535 | 1352535 | 2021-05-25 | Kent | Delaware | 10001 | 18065 | 343 |
1352536 | 1352536 | 2021-05-25 | New Castle | Delaware | 10003 | 64329 | 824 |
1352537 | 1352537 | 2021-05-25 | Sussex | Delaware | 10005 | 25866 | 493 |
1352538 | 1352538 | 2021-05-25 | Unknown | Delaware | 223 | 0 | |
1349289 | 1349289 | 2021-05-24 | Kent | Delaware | 10001 | 18060 | 343 |
1349290 | 1349290 | 2021-05-24 | New Castle | Delaware | 10003 | 64279 | 823 |
1349291 | 1349291 | 2021-05-24 | Sussex | Delaware | 10005 | 25847 | 493 |
1349292 | 1349292 | 2021-05-24 | Unknown | Delaware | 223 | 0 | |
1346042 | 1346042 | 2021-05-23 | Kent | Delaware | 10001 | 18053 | 343 |
1346043 | 1346043 | 2021-05-23 | New Castle | Delaware | 10003 | 64248 | 823 |
1346044 | 1346044 | 2021-05-23 | Sussex | Delaware | 10005 | 25841 | 493 |
1346045 | 1346045 | 2021-05-23 | Unknown | Delaware | 223 | 0 | |
1342794 | 1342794 | 2021-05-22 | Kent | Delaware | 10001 | 18045 | 343 |
1342795 | 1342795 | 2021-05-22 | New Castle | Delaware | 10003 | 64183 | 823 |
1342796 | 1342796 | 2021-05-22 | Sussex | Delaware | 10005 | 25829 | 493 |
1342797 | 1342797 | 2021-05-22 | Unknown | Delaware | 223 | 0 | |
1339546 | 1339546 | 2021-05-21 | Kent | Delaware | 10001 | 18034 | 343 |
1339547 | 1339547 | 2021-05-21 | New Castle | Delaware | 10003 | 64107 | 822 |
1339548 | 1339548 | 2021-05-21 | Sussex | Delaware | 10005 | 25802 | 489 |
1339549 | 1339549 | 2021-05-21 | Unknown | Delaware | 223 | 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);