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 189
- Sussex 183
- Kent 182
- Unknown 157
state 1
- Delaware · 711 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534739 | 534739 | 2020-09-15 | Kent | Delaware | 10001 | 2815 | 113 |
534740 | 534740 | 2020-09-15 | New Castle | Delaware | 10003 | 9262 | 306 |
534741 | 534741 | 2020-09-15 | Sussex | Delaware | 10005 | 6567 | 199 |
534742 | 534742 | 2020-09-15 | Unknown | Delaware | 493 | 0 | |
531504 | 531504 | 2020-09-14 | Kent | Delaware | 10001 | 2802 | 113 |
531505 | 531505 | 2020-09-14 | New Castle | Delaware | 10003 | 9146 | 306 |
531506 | 531506 | 2020-09-14 | Sussex | Delaware | 10005 | 6519 | 198 |
531507 | 531507 | 2020-09-14 | Unknown | Delaware | 470 | 0 | |
528267 | 528267 | 2020-09-13 | Kent | Delaware | 10001 | 2788 | 113 |
528268 | 528268 | 2020-09-13 | New Castle | Delaware | 10003 | 9092 | 305 |
528269 | 528269 | 2020-09-13 | Sussex | Delaware | 10005 | 6504 | 197 |
528270 | 528270 | 2020-09-13 | Unknown | Delaware | 465 | 0 | |
525031 | 525031 | 2020-09-12 | Kent | Delaware | 10001 | 2782 | 111 |
525032 | 525032 | 2020-09-12 | New Castle | Delaware | 10003 | 8989 | 305 |
525033 | 525033 | 2020-09-12 | Sussex | Delaware | 10005 | 6491 | 197 |
525034 | 525034 | 2020-09-12 | Unknown | Delaware | 464 | 0 | |
521795 | 521795 | 2020-09-11 | Kent | Delaware | 10001 | 2747 | 111 |
521796 | 521796 | 2020-09-11 | New Castle | Delaware | 10003 | 8880 | 305 |
521797 | 521797 | 2020-09-11 | Sussex | Delaware | 10005 | 6471 | 197 |
521798 | 521798 | 2020-09-11 | Unknown | Delaware | 461 | 0 | |
518558 | 518558 | 2020-09-10 | Kent | Delaware | 10001 | 2744 | 111 |
518559 | 518559 | 2020-09-10 | New Castle | Delaware | 10003 | 8805 | 305 |
518560 | 518560 | 2020-09-10 | Sussex | Delaware | 10005 | 6456 | 197 |
518561 | 518561 | 2020-09-10 | Unknown | Delaware | 461 | 0 | |
515323 | 515323 | 2020-09-09 | Kent | Delaware | 10001 | 2727 | 110 |
515324 | 515324 | 2020-09-09 | New Castle | Delaware | 10003 | 8694 | 303 |
515325 | 515325 | 2020-09-09 | Sussex | Delaware | 10005 | 6432 | 196 |
515326 | 515326 | 2020-09-09 | Unknown | Delaware | 455 | 0 | |
512090 | 512090 | 2020-09-08 | Kent | Delaware | 10001 | 2727 | 110 |
512091 | 512091 | 2020-09-08 | New Castle | Delaware | 10003 | 8694 | 303 |
512092 | 512092 | 2020-09-08 | Sussex | Delaware | 10005 | 6432 | 196 |
512093 | 512093 | 2020-09-08 | Unknown | Delaware | 455 | 0 | |
508857 | 508857 | 2020-09-07 | Kent | Delaware | 10001 | 2720 | 110 |
508858 | 508858 | 2020-09-07 | New Castle | Delaware | 10003 | 8656 | 303 |
508859 | 508859 | 2020-09-07 | Sussex | Delaware | 10005 | 6420 | 196 |
508860 | 508860 | 2020-09-07 | Unknown | Delaware | 453 | 0 | |
505625 | 505625 | 2020-09-06 | Kent | Delaware | 10001 | 2712 | 110 |
505626 | 505626 | 2020-09-06 | New Castle | Delaware | 10003 | 8601 | 303 |
505627 | 505627 | 2020-09-06 | Sussex | Delaware | 10005 | 6396 | 196 |
505628 | 505628 | 2020-09-06 | Unknown | Delaware | 334 | 0 | |
502391 | 502391 | 2020-09-05 | Kent | Delaware | 10001 | 2699 | 110 |
502392 | 502392 | 2020-09-05 | New Castle | Delaware | 10003 | 8516 | 302 |
502393 | 502393 | 2020-09-05 | Sussex | Delaware | 10005 | 6374 | 196 |
502394 | 502394 | 2020-09-05 | Unknown | Delaware | 303 | 0 | |
499157 | 499157 | 2020-09-04 | Kent | Delaware | 10001 | 2678 | 110 |
499158 | 499158 | 2020-09-04 | New Castle | Delaware | 10003 | 8415 | 301 |
499159 | 499159 | 2020-09-04 | Sussex | Delaware | 10005 | 6365 | 195 |
499160 | 499160 | 2020-09-04 | Unknown | Delaware | 294 | 0 | |
495924 | 495924 | 2020-09-03 | Kent | Delaware | 10001 | 2655 | 110 |
495925 | 495925 | 2020-09-03 | New Castle | Delaware | 10003 | 8360 | 301 |
495926 | 495926 | 2020-09-03 | Sussex | Delaware | 10005 | 6346 | 195 |
495927 | 495927 | 2020-09-03 | Unknown | Delaware | 292 | 0 | |
492690 | 492690 | 2020-09-02 | Kent | Delaware | 10001 | 2639 | 110 |
492691 | 492691 | 2020-09-02 | New Castle | Delaware | 10003 | 8285 | 301 |
492692 | 492692 | 2020-09-02 | Sussex | Delaware | 10005 | 6335 | 195 |
492693 | 492693 | 2020-09-02 | Unknown | Delaware | 290 | 0 | |
489457 | 489457 | 2020-09-01 | Kent | Delaware | 10001 | 2639 | 110 |
489458 | 489458 | 2020-09-01 | New Castle | Delaware | 10003 | 8250 | 300 |
489459 | 489459 | 2020-09-01 | Sussex | Delaware | 10005 | 6357 | 195 |
489460 | 489460 | 2020-09-01 | Unknown | Delaware | 289 | 0 | |
486224 | 486224 | 2020-08-31 | Kent | Delaware | 10001 | 2624 | 110 |
486225 | 486225 | 2020-08-31 | New Castle | Delaware | 10003 | 8190 | 300 |
486226 | 486226 | 2020-08-31 | Sussex | Delaware | 10005 | 6330 | 195 |
486227 | 486227 | 2020-08-31 | Unknown | Delaware | 285 | 0 | |
482989 | 482989 | 2020-08-30 | Kent | Delaware | 10001 | 2608 | 109 |
482990 | 482990 | 2020-08-30 | New Castle | Delaware | 10003 | 8139 | 300 |
482991 | 482991 | 2020-08-30 | Sussex | Delaware | 10005 | 6317 | 195 |
482992 | 482992 | 2020-08-30 | Unknown | Delaware | 279 | 0 | |
479755 | 479755 | 2020-08-29 | Kent | Delaware | 10001 | 2612 | 109 |
479756 | 479756 | 2020-08-29 | New Castle | Delaware | 10003 | 8109 | 300 |
479757 | 479757 | 2020-08-29 | Sussex | Delaware | 10005 | 6350 | 195 |
479758 | 479758 | 2020-08-29 | Unknown | Delaware | 278 | 0 | |
476522 | 476522 | 2020-08-28 | Kent | Delaware | 10001 | 2578 | 109 |
476523 | 476523 | 2020-08-28 | New Castle | Delaware | 10003 | 7989 | 300 |
476524 | 476524 | 2020-08-28 | Sussex | Delaware | 10005 | 6237 | 195 |
476525 | 476525 | 2020-08-28 | Unknown | Delaware | 279 | 0 | |
473289 | 473289 | 2020-08-27 | Kent | Delaware | 10001 | 2566 | 109 |
473290 | 473290 | 2020-08-27 | New Castle | Delaware | 10003 | 7927 | 300 |
473291 | 473291 | 2020-08-27 | Sussex | Delaware | 10005 | 6208 | 195 |
473292 | 473292 | 2020-08-27 | Unknown | Delaware | 275 | 0 | |
470057 | 470057 | 2020-08-26 | Kent | Delaware | 10001 | 2560 | 109 |
470058 | 470058 | 2020-08-26 | New Castle | Delaware | 10003 | 7925 | 300 |
470059 | 470059 | 2020-08-26 | Sussex | Delaware | 10005 | 6225 | 195 |
470060 | 470060 | 2020-08-26 | Unknown | Delaware | 276 | 0 | |
466828 | 466828 | 2020-08-25 | Kent | Delaware | 10001 | 2556 | 109 |
466829 | 466829 | 2020-08-25 | New Castle | Delaware | 10003 | 7890 | 299 |
466830 | 466830 | 2020-08-25 | Sussex | Delaware | 10005 | 6239 | 195 |
466831 | 466831 | 2020-08-25 | Unknown | Delaware | 277 | 0 | |
463599 | 463599 | 2020-08-24 | Kent | Delaware | 10001 | 2553 | 109 |
463600 | 463600 | 2020-08-24 | New Castle | Delaware | 10003 | 7865 | 299 |
463601 | 463601 | 2020-08-24 | Sussex | Delaware | 10005 | 6249 | 196 |
463602 | 463602 | 2020-08-24 | Unknown | Delaware | 275 | 0 | |
460370 | 460370 | 2020-08-23 | Kent | Delaware | 10001 | 2551 | 109 |
460371 | 460371 | 2020-08-23 | New Castle | Delaware | 10003 | 7826 | 297 |
460372 | 460372 | 2020-08-23 | Sussex | Delaware | 10005 | 6245 | 194 |
460373 | 460373 | 2020-08-23 | Unknown | Delaware | 273 | 0 | |
457143 | 457143 | 2020-08-22 | Kent | Delaware | 10001 | 2543 | 109 |
457144 | 457144 | 2020-08-22 | New Castle | Delaware | 10003 | 7771 | 297 |
457145 | 457145 | 2020-08-22 | Sussex | Delaware | 10005 | 6242 | 194 |
457146 | 457146 | 2020-08-22 | Unknown | Delaware | 272 | 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);