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 349
- Sussex 343
- Kent 342
- Unknown 317
state 1
- Delaware · 1,351 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053823 | 1053823 | 2021-02-22 | Kent | Delaware | 10001 | 14136 | 287 |
1053824 | 1053824 | 2021-02-22 | New Castle | Delaware | 10003 | 48396 | 661 |
1053825 | 1053825 | 2021-02-22 | Sussex | Delaware | 10005 | 22368 | 420 |
1053826 | 1053826 | 2021-02-22 | Unknown | Delaware | 190 | 0 | |
1050576 | 1050576 | 2021-02-21 | Kent | Delaware | 10001 | 14089 | 287 |
1050577 | 1050577 | 2021-02-21 | New Castle | Delaware | 10003 | 48142 | 660 |
1050578 | 1050578 | 2021-02-21 | Sussex | Delaware | 10005 | 22311 | 420 |
1050579 | 1050579 | 2021-02-21 | Unknown | Delaware | 190 | 0 | |
1047329 | 1047329 | 2021-02-20 | Kent | Delaware | 10001 | 14042 | 287 |
1047330 | 1047330 | 2021-02-20 | New Castle | Delaware | 10003 | 48047 | 659 |
1047331 | 1047331 | 2021-02-20 | Sussex | Delaware | 10005 | 22253 | 420 |
1047332 | 1047332 | 2021-02-20 | Unknown | Delaware | 189 | 0 | |
1044084 | 1044084 | 2021-02-19 | Kent | Delaware | 10001 | 13956 | 281 |
1044085 | 1044085 | 2021-02-19 | New Castle | Delaware | 10003 | 47842 | 644 |
1044086 | 1044086 | 2021-02-19 | Sussex | Delaware | 10005 | 22195 | 418 |
1044087 | 1044087 | 2021-02-19 | Unknown | Delaware | 188 | 0 | |
1040839 | 1040839 | 2021-02-18 | Kent | Delaware | 10001 | 13906 | 280 |
1040840 | 1040840 | 2021-02-18 | New Castle | Delaware | 10003 | 47608 | 634 |
1040841 | 1040841 | 2021-02-18 | Sussex | Delaware | 10005 | 22148 | 412 |
1040842 | 1040842 | 2021-02-18 | Unknown | Delaware | 190 | 0 | |
1037594 | 1037594 | 2021-02-17 | Kent | Delaware | 10001 | 13832 | 278 |
1037595 | 1037595 | 2021-02-17 | New Castle | Delaware | 10003 | 47465 | 629 |
1037596 | 1037596 | 2021-02-17 | Sussex | Delaware | 10005 | 22095 | 409 |
1037597 | 1037597 | 2021-02-17 | Unknown | Delaware | 189 | 0 | |
1034349 | 1034349 | 2021-02-16 | Kent | Delaware | 10001 | 13786 | 272 |
1034350 | 1034350 | 2021-02-16 | New Castle | Delaware | 10003 | 47349 | 617 |
1034351 | 1034351 | 2021-02-16 | Sussex | Delaware | 10005 | 22046 | 402 |
1034352 | 1034352 | 2021-02-16 | Unknown | Delaware | 188 | 0 | |
1031103 | 1031103 | 2021-02-15 | Kent | Delaware | 10001 | 13756 | 272 |
1031104 | 1031104 | 2021-02-15 | New Castle | Delaware | 10003 | 47278 | 614 |
1031105 | 1031105 | 2021-02-15 | Sussex | Delaware | 10005 | 22017 | 397 |
1031106 | 1031106 | 2021-02-15 | Unknown | Delaware | 188 | 0 | |
1027856 | 1027856 | 2021-02-14 | Kent | Delaware | 10001 | 13736 | 272 |
1027857 | 1027857 | 2021-02-14 | New Castle | Delaware | 10003 | 47134 | 614 |
1027858 | 1027858 | 2021-02-14 | Sussex | Delaware | 10005 | 21945 | 397 |
1027859 | 1027859 | 2021-02-14 | Unknown | Delaware | 188 | 0 | |
1024611 | 1024611 | 2021-02-13 | Kent | Delaware | 10001 | 13678 | 271 |
1024612 | 1024612 | 2021-02-13 | New Castle | Delaware | 10003 | 46949 | 614 |
1024613 | 1024613 | 2021-02-13 | Sussex | Delaware | 10005 | 21858 | 397 |
1024614 | 1024614 | 2021-02-13 | Unknown | Delaware | 187 | 0 | |
1021366 | 1021366 | 2021-02-12 | Kent | Delaware | 10001 | 13623 | 267 |
1021367 | 1021367 | 2021-02-12 | New Castle | Delaware | 10003 | 46681 | 610 |
1021368 | 1021368 | 2021-02-12 | Sussex | Delaware | 10005 | 21773 | 392 |
1021369 | 1021369 | 2021-02-12 | Unknown | Delaware | 186 | 0 | |
1018121 | 1018121 | 2021-02-11 | Kent | Delaware | 10001 | 13552 | 266 |
1018122 | 1018122 | 2021-02-11 | New Castle | Delaware | 10003 | 46455 | 605 |
1018123 | 1018123 | 2021-02-11 | Sussex | Delaware | 10005 | 21683 | 391 |
1018124 | 1018124 | 2021-02-11 | Unknown | Delaware | 185 | 0 | |
1014876 | 1014876 | 2021-02-10 | Kent | Delaware | 10001 | 13470 | 263 |
1014877 | 1014877 | 2021-02-10 | New Castle | Delaware | 10003 | 46237 | 591 |
1014878 | 1014878 | 2021-02-10 | Sussex | Delaware | 10005 | 21570 | 391 |
1014879 | 1014879 | 2021-02-10 | Unknown | Delaware | 184 | 0 | |
1011631 | 1011631 | 2021-02-09 | Kent | Delaware | 10001 | 13418 | 259 |
1011632 | 1011632 | 2021-02-09 | New Castle | Delaware | 10003 | 46076 | 575 |
1011633 | 1011633 | 2021-02-09 | Sussex | Delaware | 10005 | 21532 | 387 |
1011634 | 1011634 | 2021-02-09 | Unknown | Delaware | 184 | 0 | |
1008385 | 1008385 | 2021-02-08 | Kent | Delaware | 10001 | 13371 | 255 |
1008386 | 1008386 | 2021-02-08 | New Castle | Delaware | 10003 | 45935 | 570 |
1008387 | 1008387 | 2021-02-08 | Sussex | Delaware | 10005 | 21442 | 383 |
1008388 | 1008388 | 2021-02-08 | Unknown | Delaware | 183 | 0 | |
1005139 | 1005139 | 2021-02-07 | Kent | Delaware | 10001 | 13330 | 255 |
1005140 | 1005140 | 2021-02-07 | New Castle | Delaware | 10003 | 45742 | 570 |
1005141 | 1005141 | 2021-02-07 | Sussex | Delaware | 10005 | 21339 | 383 |
1005142 | 1005142 | 2021-02-07 | Unknown | Delaware | 183 | 0 | |
1001893 | 1001893 | 2021-02-06 | Kent | Delaware | 10001 | 13216 | 252 |
1001894 | 1001894 | 2021-02-06 | New Castle | Delaware | 10003 | 45277 | 569 |
1001895 | 1001895 | 2021-02-06 | Sussex | Delaware | 10005 | 21158 | 381 |
1001896 | 1001896 | 2021-02-06 | Unknown | Delaware | 181 | 0 | |
998647 | 998647 | 2021-02-05 | Kent | Delaware | 10001 | 13162 | 249 |
998648 | 998648 | 2021-02-05 | New Castle | Delaware | 10003 | 45112 | 566 |
998649 | 998649 | 2021-02-05 | Sussex | Delaware | 10005 | 21092 | 376 |
998650 | 998650 | 2021-02-05 | Unknown | Delaware | 180 | 0 | |
995401 | 995401 | 2021-02-04 | Kent | Delaware | 10001 | 13096 | 215 |
995402 | 995402 | 2021-02-04 | New Castle | Delaware | 10003 | 44932 | 563 |
995403 | 995403 | 2021-02-04 | Sussex | Delaware | 10005 | 21018 | 357 |
995404 | 995404 | 2021-02-04 | Unknown | Delaware | 179 | 0 | |
992155 | 992155 | 2021-02-03 | Kent | Delaware | 10001 | 13031 | 213 |
992156 | 992156 | 2021-02-03 | New Castle | Delaware | 10003 | 44833 | 561 |
992157 | 992157 | 2021-02-03 | Sussex | Delaware | 10005 | 20940 | 356 |
992158 | 992158 | 2021-02-03 | Unknown | Delaware | 178 | 0 | |
988909 | 988909 | 2021-02-02 | Kent | Delaware | 10001 | 12964 | 206 |
988910 | 988910 | 2021-02-02 | New Castle | Delaware | 10003 | 44683 | 553 |
988911 | 988911 | 2021-02-02 | Sussex | Delaware | 10005 | 20867 | 349 |
988912 | 988912 | 2021-02-02 | Unknown | Delaware | 182 | 0 | |
985662 | 985662 | 2021-02-01 | Kent | Delaware | 10001 | 12918 | 203 |
985663 | 985663 | 2021-02-01 | New Castle | Delaware | 10003 | 44570 | 549 |
985664 | 985664 | 2021-02-01 | Sussex | Delaware | 10005 | 20824 | 349 |
985665 | 985665 | 2021-02-01 | Unknown | Delaware | 183 | 0 | |
982415 | 982415 | 2021-01-31 | Kent | Delaware | 10001 | 12821 | 202 |
982416 | 982416 | 2021-01-31 | New Castle | Delaware | 10003 | 44340 | 540 |
982417 | 982417 | 2021-01-31 | Sussex | Delaware | 10005 | 20728 | 348 |
982418 | 982418 | 2021-01-31 | Unknown | Delaware | 182 | 0 | |
979169 | 979169 | 2021-01-30 | Kent | Delaware | 10001 | 12746 | 199 |
979170 | 979170 | 2021-01-30 | New Castle | Delaware | 10003 | 44073 | 538 |
979171 | 979171 | 2021-01-30 | Sussex | Delaware | 10005 | 20550 | 344 |
979172 | 979172 | 2021-01-30 | Unknown | Delaware | 182 | 0 | |
975924 | 975924 | 2021-01-29 | Kent | Delaware | 10001 | 12634 | 197 |
975925 | 975925 | 2021-01-29 | New Castle | Delaware | 10003 | 43763 | 538 |
975926 | 975926 | 2021-01-29 | Sussex | Delaware | 10005 | 20361 | 343 |
975927 | 975927 | 2021-01-29 | Unknown | Delaware | 177 | 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);