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 392
- Sussex 386
- Kent 385
- Unknown 360
state 1
- Delaware · 1,523 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193426 | 1193426 | 2021-04-06 | Kent | Delaware | 10001 | 15863 | 323 |
1193427 | 1193427 | 2021-04-06 | New Castle | Delaware | 10003 | 56715 | 781 |
1193428 | 1193428 | 2021-04-06 | Sussex | Delaware | 10005 | 24025 | 463 |
1193429 | 1193429 | 2021-04-06 | Unknown | Delaware | 203 | 0 | |
1190176 | 1190176 | 2021-04-05 | Kent | Delaware | 10001 | 15843 | 323 |
1190177 | 1190177 | 2021-04-05 | New Castle | Delaware | 10003 | 56541 | 781 |
1190178 | 1190178 | 2021-04-05 | Sussex | Delaware | 10005 | 23989 | 462 |
1190179 | 1190179 | 2021-04-05 | Unknown | Delaware | 204 | 0 | |
1186929 | 1186929 | 2021-04-04 | Kent | Delaware | 10001 | 15806 | 323 |
1186930 | 1186930 | 2021-04-04 | New Castle | Delaware | 10003 | 56411 | 781 |
1186931 | 1186931 | 2021-04-04 | Sussex | Delaware | 10005 | 23955 | 462 |
1186932 | 1186932 | 2021-04-04 | Unknown | Delaware | 204 | 0 | |
1183682 | 1183682 | 2021-04-03 | Kent | Delaware | 10001 | 15748 | 323 |
1183683 | 1183683 | 2021-04-03 | New Castle | Delaware | 10003 | 56201 | 781 |
1183684 | 1183684 | 2021-04-03 | Sussex | Delaware | 10005 | 23924 | 461 |
1183685 | 1183685 | 2021-04-03 | Unknown | Delaware | 204 | 0 | |
1180435 | 1180435 | 2021-04-02 | Kent | Delaware | 10001 | 15662 | 323 |
1180436 | 1180436 | 2021-04-02 | New Castle | Delaware | 10003 | 55871 | 781 |
1180437 | 1180437 | 2021-04-02 | Sussex | Delaware | 10005 | 23852 | 461 |
1180438 | 1180438 | 2021-04-02 | Unknown | Delaware | 205 | 0 | |
1177188 | 1177188 | 2021-04-01 | Kent | Delaware | 10001 | 15595 | 323 |
1177189 | 1177189 | 2021-04-01 | New Castle | Delaware | 10003 | 55599 | 778 |
1177190 | 1177190 | 2021-04-01 | Sussex | Delaware | 10005 | 23788 | 458 |
1177191 | 1177191 | 2021-04-01 | Unknown | Delaware | 206 | 0 | |
1173941 | 1173941 | 2021-03-31 | Kent | Delaware | 10001 | 15527 | 323 |
1173942 | 1173942 | 2021-03-31 | New Castle | Delaware | 10003 | 55327 | 778 |
1173943 | 1173943 | 2021-03-31 | Sussex | Delaware | 10005 | 23744 | 458 |
1173944 | 1173944 | 2021-03-31 | Unknown | Delaware | 204 | 0 | |
1170694 | 1170694 | 2021-03-30 | Kent | Delaware | 10001 | 15462 | 323 |
1170695 | 1170695 | 2021-03-30 | New Castle | Delaware | 10003 | 55191 | 778 |
1170696 | 1170696 | 2021-03-30 | Sussex | Delaware | 10005 | 23717 | 458 |
1170697 | 1170697 | 2021-03-30 | Unknown | Delaware | 203 | 0 | |
1167446 | 1167446 | 2021-03-29 | Kent | Delaware | 10001 | 15444 | 322 |
1167447 | 1167447 | 2021-03-29 | New Castle | Delaware | 10003 | 55064 | 775 |
1167448 | 1167448 | 2021-03-29 | Sussex | Delaware | 10005 | 23691 | 455 |
1167449 | 1167449 | 2021-03-29 | Unknown | Delaware | 203 | 0 | |
1164198 | 1164198 | 2021-03-28 | Kent | Delaware | 10001 | 15393 | 322 |
1164199 | 1164199 | 2021-03-28 | New Castle | Delaware | 10003 | 54815 | 767 |
1164200 | 1164200 | 2021-03-28 | Sussex | Delaware | 10005 | 23651 | 455 |
1164201 | 1164201 | 2021-03-28 | Unknown | Delaware | 203 | 0 | |
1160950 | 1160950 | 2021-03-27 | Kent | Delaware | 10001 | 15338 | 322 |
1160951 | 1160951 | 2021-03-27 | New Castle | Delaware | 10003 | 54554 | 767 |
1160952 | 1160952 | 2021-03-27 | Sussex | Delaware | 10005 | 23606 | 455 |
1160953 | 1160953 | 2021-03-27 | Unknown | Delaware | 203 | 0 | |
1157702 | 1157702 | 2021-03-26 | Kent | Delaware | 10001 | 15256 | 322 |
1157703 | 1157703 | 2021-03-26 | New Castle | Delaware | 10003 | 54318 | 761 |
1157704 | 1157704 | 2021-03-26 | Sussex | Delaware | 10005 | 23548 | 453 |
1157705 | 1157705 | 2021-03-26 | Unknown | Delaware | 203 | 0 | |
1154455 | 1154455 | 2021-03-25 | Kent | Delaware | 10001 | 15206 | 322 |
1154456 | 1154456 | 2021-03-25 | New Castle | Delaware | 10003 | 54110 | 761 |
1154457 | 1154457 | 2021-03-25 | Sussex | Delaware | 10005 | 23521 | 453 |
1154458 | 1154458 | 2021-03-25 | Unknown | Delaware | 201 | 0 | |
1151208 | 1151208 | 2021-03-24 | Kent | Delaware | 10001 | 15170 | 322 |
1151209 | 1151209 | 2021-03-24 | New Castle | Delaware | 10003 | 53966 | 760 |
1151210 | 1151210 | 2021-03-24 | Sussex | Delaware | 10005 | 23482 | 453 |
1151211 | 1151211 | 2021-03-24 | Unknown | Delaware | 201 | 0 | |
1147961 | 1147961 | 2021-03-23 | Kent | Delaware | 10001 | 15134 | 322 |
1147962 | 1147962 | 2021-03-23 | New Castle | Delaware | 10003 | 53818 | 760 |
1147963 | 1147963 | 2021-03-23 | Sussex | Delaware | 10005 | 23456 | 453 |
1147964 | 1147964 | 2021-03-23 | Unknown | Delaware | 201 | 0 | |
1144714 | 1144714 | 2021-03-22 | Kent | Delaware | 10001 | 15118 | 320 |
1144715 | 1144715 | 2021-03-22 | New Castle | Delaware | 10003 | 53672 | 759 |
1144716 | 1144716 | 2021-03-22 | Sussex | Delaware | 10005 | 23438 | 452 |
1144717 | 1144717 | 2021-03-22 | Unknown | Delaware | 201 | 0 | |
1141467 | 1141467 | 2021-03-21 | Kent | Delaware | 10001 | 15102 | 320 |
1141468 | 1141468 | 2021-03-21 | New Castle | Delaware | 10003 | 53561 | 757 |
1141469 | 1141469 | 2021-03-21 | Sussex | Delaware | 10005 | 23423 | 452 |
1141470 | 1141470 | 2021-03-21 | Unknown | Delaware | 201 | 0 | |
1138221 | 1138221 | 2021-03-20 | Kent | Delaware | 10001 | 15039 | 318 |
1138222 | 1138222 | 2021-03-20 | New Castle | Delaware | 10003 | 53323 | 756 |
1138223 | 1138223 | 2021-03-20 | Sussex | Delaware | 10005 | 23379 | 452 |
1138224 | 1138224 | 2021-03-20 | Unknown | Delaware | 201 | 0 | |
1134975 | 1134975 | 2021-03-19 | Kent | Delaware | 10001 | 14979 | 318 |
1134976 | 1134976 | 2021-03-19 | New Castle | Delaware | 10003 | 53148 | 753 |
1134977 | 1134977 | 2021-03-19 | Sussex | Delaware | 10005 | 23308 | 451 |
1134978 | 1134978 | 2021-03-19 | Unknown | Delaware | 200 | 0 | |
1131728 | 1131728 | 2021-03-18 | Kent | Delaware | 10001 | 14949 | 317 |
1131729 | 1131729 | 2021-03-18 | New Castle | Delaware | 10003 | 52986 | 749 |
1131730 | 1131730 | 2021-03-18 | Sussex | Delaware | 10005 | 23291 | 451 |
1131731 | 1131731 | 2021-03-18 | Unknown | Delaware | 199 | 0 | |
1128480 | 1128480 | 2021-03-17 | Kent | Delaware | 10001 | 14913 | 317 |
1128481 | 1128481 | 2021-03-17 | New Castle | Delaware | 10003 | 52763 | 748 |
1128482 | 1128482 | 2021-03-17 | Sussex | Delaware | 10005 | 23248 | 451 |
1128483 | 1128483 | 2021-03-17 | Unknown | Delaware | 199 | 0 | |
1125234 | 1125234 | 2021-03-16 | Kent | Delaware | 10001 | 14863 | 316 |
1125235 | 1125235 | 2021-03-16 | New Castle | Delaware | 10003 | 52512 | 747 |
1125236 | 1125236 | 2021-03-16 | Sussex | Delaware | 10005 | 23176 | 451 |
1125237 | 1125237 | 2021-03-16 | Unknown | Delaware | 200 | 0 | |
1121988 | 1121988 | 2021-03-15 | Kent | Delaware | 10001 | 14844 | 315 |
1121989 | 1121989 | 2021-03-15 | New Castle | Delaware | 10003 | 52413 | 746 |
1121990 | 1121990 | 2021-03-15 | Sussex | Delaware | 10005 | 23158 | 450 |
1121991 | 1121991 | 2021-03-15 | Unknown | Delaware | 199 | 0 | |
1118741 | 1118741 | 2021-03-14 | Kent | Delaware | 10001 | 14829 | 312 |
1118742 | 1118742 | 2021-03-14 | New Castle | Delaware | 10003 | 52228 | 746 |
1118743 | 1118743 | 2021-03-14 | Sussex | Delaware | 10005 | 23125 | 449 |
1118744 | 1118744 | 2021-03-14 | Unknown | Delaware | 199 | 0 | |
1115494 | 1115494 | 2021-03-13 | Kent | Delaware | 10001 | 14800 | 311 |
1115495 | 1115495 | 2021-03-13 | New Castle | Delaware | 10003 | 52084 | 745 |
1115496 | 1115496 | 2021-03-13 | Sussex | Delaware | 10005 | 23073 | 448 |
1115497 | 1115497 | 2021-03-13 | Unknown | Delaware | 199 | 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);