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 220
- Sussex 214
- Kent 213
- Unknown 188
state 1
- Delaware · 835 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635202 | 635202 | 2020-10-16 | Kent | Delaware | 10001 | 3285 | 119 |
635203 | 635203 | 2020-10-16 | New Castle | Delaware | 10003 | 11958 | 330 |
635204 | 635204 | 2020-10-16 | Sussex | Delaware | 10005 | 7390 | 213 |
635205 | 635205 | 2020-10-16 | Unknown | Delaware | 91 | 0 | |
631956 | 631956 | 2020-10-15 | Kent | Delaware | 10001 | 3272 | 119 |
631957 | 631957 | 2020-10-15 | New Castle | Delaware | 10003 | 11851 | 330 |
631958 | 631958 | 2020-10-15 | Sussex | Delaware | 10005 | 7346 | 212 |
631959 | 631959 | 2020-10-15 | Unknown | Delaware | 91 | 0 | |
628712 | 628712 | 2020-10-14 | Kent | Delaware | 10001 | 3259 | 119 |
628713 | 628713 | 2020-10-14 | New Castle | Delaware | 10003 | 11787 | 329 |
628714 | 628714 | 2020-10-14 | Sussex | Delaware | 10005 | 7328 | 212 |
628715 | 628715 | 2020-10-14 | Unknown | Delaware | 91 | 0 | |
625469 | 625469 | 2020-10-13 | Kent | Delaware | 10001 | 3254 | 119 |
625470 | 625470 | 2020-10-13 | New Castle | Delaware | 10003 | 11747 | 328 |
625471 | 625471 | 2020-10-13 | Sussex | Delaware | 10005 | 7302 | 212 |
625472 | 625472 | 2020-10-13 | Unknown | Delaware | 91 | 0 | |
622226 | 622226 | 2020-10-12 | Kent | Delaware | 10001 | 3243 | 119 |
622227 | 622227 | 2020-10-12 | New Castle | Delaware | 10003 | 11688 | 326 |
622228 | 622228 | 2020-10-12 | Sussex | Delaware | 10005 | 7267 | 211 |
622229 | 622229 | 2020-10-12 | Unknown | Delaware | 91 | 0 | |
618983 | 618983 | 2020-10-11 | Kent | Delaware | 10001 | 3225 | 118 |
618984 | 618984 | 2020-10-11 | New Castle | Delaware | 10003 | 11593 | 325 |
618985 | 618985 | 2020-10-11 | Sussex | Delaware | 10005 | 7221 | 211 |
618986 | 618986 | 2020-10-11 | Unknown | Delaware | 91 | 0 | |
615741 | 615741 | 2020-10-10 | Kent | Delaware | 10001 | 3212 | 118 |
615742 | 615742 | 2020-10-10 | New Castle | Delaware | 10003 | 11507 | 325 |
615743 | 615743 | 2020-10-10 | Sussex | Delaware | 10005 | 7188 | 210 |
615744 | 615744 | 2020-10-10 | Unknown | Delaware | 91 | 0 | |
612500 | 612500 | 2020-10-09 | Kent | Delaware | 10001 | 3190 | 118 |
612501 | 612501 | 2020-10-09 | New Castle | Delaware | 10003 | 11399 | 323 |
612502 | 612502 | 2020-10-09 | Sussex | Delaware | 10005 | 7148 | 210 |
612503 | 612503 | 2020-10-09 | Unknown | Delaware | 90 | 0 | |
609258 | 609258 | 2020-10-08 | Kent | Delaware | 10001 | 3183 | 118 |
609259 | 609259 | 2020-10-08 | New Castle | Delaware | 10003 | 11297 | 323 |
609260 | 609260 | 2020-10-08 | Sussex | Delaware | 10005 | 7112 | 210 |
609261 | 609261 | 2020-10-08 | Unknown | Delaware | 90 | 0 | |
606015 | 606015 | 2020-10-07 | Kent | Delaware | 10001 | 3178 | 118 |
606016 | 606016 | 2020-10-07 | New Castle | Delaware | 10003 | 11216 | 321 |
606017 | 606017 | 2020-10-07 | Sussex | Delaware | 10005 | 7066 | 210 |
606018 | 606018 | 2020-10-07 | Unknown | Delaware | 90 | 0 | |
602773 | 602773 | 2020-10-06 | Kent | Delaware | 10001 | 3167 | 118 |
602774 | 602774 | 2020-10-06 | New Castle | Delaware | 10003 | 11159 | 318 |
602775 | 602775 | 2020-10-06 | Sussex | Delaware | 10005 | 7050 | 210 |
602776 | 602776 | 2020-10-06 | Unknown | Delaware | 90 | 0 | |
599530 | 599530 | 2020-10-05 | Kent | Delaware | 10001 | 3162 | 118 |
599531 | 599531 | 2020-10-05 | New Castle | Delaware | 10003 | 11087 | 317 |
599532 | 599532 | 2020-10-05 | Sussex | Delaware | 10005 | 7024 | 210 |
599533 | 599533 | 2020-10-05 | Unknown | Delaware | 90 | 0 | |
596287 | 596287 | 2020-10-04 | Kent | Delaware | 10001 | 3152 | 118 |
596288 | 596288 | 2020-10-04 | New Castle | Delaware | 10003 | 11005 | 317 |
596289 | 596289 | 2020-10-04 | Sussex | Delaware | 10005 | 6996 | 210 |
596290 | 596290 | 2020-10-04 | Unknown | Delaware | 90 | 0 | |
593045 | 593045 | 2020-10-03 | Kent | Delaware | 10001 | 3137 | 118 |
593046 | 593046 | 2020-10-03 | New Castle | Delaware | 10003 | 10936 | 317 |
593047 | 593047 | 2020-10-03 | Sussex | Delaware | 10005 | 6962 | 210 |
593048 | 593048 | 2020-10-03 | Unknown | Delaware | 90 | 0 | |
589805 | 589805 | 2020-10-02 | Kent | Delaware | 10001 | 3121 | 118 |
589806 | 589806 | 2020-10-02 | New Castle | Delaware | 10003 | 10813 | 317 |
589807 | 589807 | 2020-10-02 | Sussex | Delaware | 10005 | 6913 | 207 |
589808 | 589808 | 2020-10-02 | Unknown | Delaware | 90 | 0 | |
586564 | 586564 | 2020-10-01 | Kent | Delaware | 10001 | 2969 | 117 |
586565 | 586565 | 2020-10-01 | New Castle | Delaware | 10003 | 10520 | 312 |
586566 | 586566 | 2020-10-01 | Sussex | Delaware | 10005 | 6807 | 207 |
586567 | 586567 | 2020-10-01 | Unknown | Delaware | 491 | 0 | |
583324 | 583324 | 2020-09-30 | Kent | Delaware | 10001 | 2963 | 117 |
583325 | 583325 | 2020-09-30 | New Castle | Delaware | 10003 | 10368 | 312 |
583326 | 583326 | 2020-09-30 | Sussex | Delaware | 10005 | 6791 | 207 |
583327 | 583327 | 2020-09-30 | Unknown | Delaware | 491 | 0 | |
580085 | 580085 | 2020-09-29 | Kent | Delaware | 10001 | 2949 | 117 |
580086 | 580086 | 2020-09-29 | New Castle | Delaware | 10003 | 10309 | 312 |
580087 | 580087 | 2020-09-29 | Sussex | Delaware | 10005 | 6782 | 206 |
580088 | 580088 | 2020-09-29 | Unknown | Delaware | 491 | 0 | |
576844 | 576844 | 2020-09-28 | Kent | Delaware | 10001 | 2937 | 116 |
576845 | 576845 | 2020-09-28 | New Castle | Delaware | 10003 | 10198 | 312 |
576846 | 576846 | 2020-09-28 | Sussex | Delaware | 10005 | 6761 | 206 |
576847 | 576847 | 2020-09-28 | Unknown | Delaware | 493 | 0 | |
573601 | 573601 | 2020-09-27 | Kent | Delaware | 10001 | 2925 | 116 |
573602 | 573602 | 2020-09-27 | New Castle | Delaware | 10003 | 10106 | 311 |
573603 | 573603 | 2020-09-27 | Sussex | Delaware | 10005 | 6740 | 206 |
573604 | 573604 | 2020-09-27 | Unknown | Delaware | 489 | 0 | |
570359 | 570359 | 2020-09-26 | Kent | Delaware | 10001 | 2911 | 116 |
570360 | 570360 | 2020-09-26 | New Castle | Delaware | 10003 | 10029 | 311 |
570361 | 570361 | 2020-09-26 | Sussex | Delaware | 10005 | 6727 | 206 |
570362 | 570362 | 2020-09-26 | Unknown | Delaware | 489 | 0 | |
567117 | 567117 | 2020-09-25 | Kent | Delaware | 10001 | 2905 | 116 |
567118 | 567118 | 2020-09-25 | New Castle | Delaware | 10003 | 9975 | 310 |
567119 | 567119 | 2020-09-25 | Sussex | Delaware | 10005 | 6718 | 205 |
567120 | 567120 | 2020-09-25 | Unknown | Delaware | 487 | 0 | |
563877 | 563877 | 2020-09-24 | Kent | Delaware | 10001 | 2903 | 116 |
563878 | 563878 | 2020-09-24 | New Castle | Delaware | 10003 | 9865 | 310 |
563879 | 563879 | 2020-09-24 | Sussex | Delaware | 10005 | 6691 | 204 |
563880 | 563880 | 2020-09-24 | Unknown | Delaware | 488 | 0 | |
560637 | 560637 | 2020-09-23 | Kent | Delaware | 10001 | 2898 | 115 |
560638 | 560638 | 2020-09-23 | New Castle | Delaware | 10003 | 9777 | 310 |
560639 | 560639 | 2020-09-23 | Sussex | Delaware | 10005 | 6673 | 204 |
560640 | 560640 | 2020-09-23 | Unknown | Delaware | 482 | 0 | |
557401 | 557401 | 2020-09-22 | Kent | Delaware | 10001 | 2882 | 115 |
557402 | 557402 | 2020-09-22 | New Castle | Delaware | 10003 | 9731 | 310 |
557403 | 557403 | 2020-09-22 | Sussex | Delaware | 10005 | 6666 | 203 |
557404 | 557404 | 2020-09-22 | Unknown | Delaware | 482 | 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);