ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Unknown" and state = "Delaware" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
354148 | 354148 | 2020-07-21 | Unknown | Delaware | 158 | 0 | |
357351 | 357351 | 2020-07-22 | Unknown | Delaware | 161 | 0 | |
360556 | 360556 | 2020-07-23 | Unknown | Delaware | 163 | 0 | |
363763 | 363763 | 2020-07-24 | Unknown | Delaware | 184 | 0 | |
366970 | 366970 | 2020-07-25 | Unknown | Delaware | 182 | 0 | |
370180 | 370180 | 2020-07-26 | Unknown | Delaware | 187 | 0 | |
373392 | 373392 | 2020-07-27 | Unknown | Delaware | 192 | 0 | |
376606 | 376606 | 2020-07-28 | Unknown | Delaware | 192 | 0 | |
379823 | 379823 | 2020-07-29 | Unknown | Delaware | 203 | 0 | |
383040 | 383040 | 2020-07-30 | Unknown | Delaware | 212 | 0 | |
386258 | 386258 | 2020-07-31 | Unknown | Delaware | 219 | 0 | |
389475 | 389475 | 2020-08-01 | Unknown | Delaware | 221 | 0 | |
392692 | 392692 | 2020-08-02 | Unknown | Delaware | 226 | 0 | |
395908 | 395908 | 2020-08-03 | Unknown | Delaware | 229 | 0 | |
399124 | 399124 | 2020-08-04 | Unknown | Delaware | 232 | 0 | |
402340 | 402340 | 2020-08-05 | Unknown | Delaware | 238 | 0 | |
405558 | 405558 | 2020-08-06 | Unknown | Delaware | 240 | 0 | |
408778 | 408778 | 2020-08-07 | Unknown | Delaware | 244 | 0 | |
411997 | 411997 | 2020-08-08 | Unknown | Delaware | 243 | 0 | |
415217 | 415217 | 2020-08-09 | Unknown | Delaware | 243 | 0 | |
418438 | 418438 | 2020-08-10 | Unknown | Delaware | 249 | 0 | |
421659 | 421659 | 2020-08-11 | Unknown | Delaware | 250 | 0 | |
424880 | 424880 | 2020-08-12 | Unknown | Delaware | 256 | 0 | |
428104 | 428104 | 2020-08-13 | Unknown | Delaware | 258 | 0 | |
431332 | 431332 | 2020-08-14 | Unknown | Delaware | 260 | 0 | |
434557 | 434557 | 2020-08-15 | Unknown | Delaware | 259 | 0 | |
437783 | 437783 | 2020-08-16 | Unknown | Delaware | 261 | 0 | |
441009 | 441009 | 2020-08-17 | Unknown | Delaware | 263 | 0 | |
444235 | 444235 | 2020-08-18 | Unknown | Delaware | 264 | 0 | |
447462 | 447462 | 2020-08-19 | Unknown | Delaware | 264 | 0 | |
450690 | 450690 | 2020-08-20 | Unknown | Delaware | 267 | 0 | |
453918 | 453918 | 2020-08-21 | Unknown | Delaware | 269 | 0 | |
457146 | 457146 | 2020-08-22 | Unknown | Delaware | 272 | 0 | |
460373 | 460373 | 2020-08-23 | Unknown | Delaware | 273 | 0 | |
463602 | 463602 | 2020-08-24 | Unknown | Delaware | 275 | 0 | |
466831 | 466831 | 2020-08-25 | Unknown | Delaware | 277 | 0 | |
470060 | 470060 | 2020-08-26 | Unknown | Delaware | 276 | 0 | |
473292 | 473292 | 2020-08-27 | Unknown | Delaware | 275 | 0 | |
476525 | 476525 | 2020-08-28 | Unknown | Delaware | 279 | 0 | |
479758 | 479758 | 2020-08-29 | Unknown | Delaware | 278 | 0 | |
482992 | 482992 | 2020-08-30 | Unknown | Delaware | 279 | 0 | |
486227 | 486227 | 2020-08-31 | Unknown | Delaware | 285 | 0 | |
489460 | 489460 | 2020-09-01 | Unknown | Delaware | 289 | 0 | |
492693 | 492693 | 2020-09-02 | Unknown | Delaware | 290 | 0 | |
495927 | 495927 | 2020-09-03 | Unknown | Delaware | 292 | 0 | |
499160 | 499160 | 2020-09-04 | Unknown | Delaware | 294 | 0 | |
502394 | 502394 | 2020-09-05 | Unknown | Delaware | 303 | 0 | |
505628 | 505628 | 2020-09-06 | Unknown | Delaware | 334 | 0 | |
508860 | 508860 | 2020-09-07 | Unknown | Delaware | 453 | 0 | |
512093 | 512093 | 2020-09-08 | Unknown | Delaware | 455 | 0 | |
515326 | 515326 | 2020-09-09 | Unknown | Delaware | 455 | 0 | |
518561 | 518561 | 2020-09-10 | Unknown | Delaware | 461 | 0 | |
521798 | 521798 | 2020-09-11 | Unknown | Delaware | 461 | 0 | |
525034 | 525034 | 2020-09-12 | Unknown | Delaware | 464 | 0 | |
528270 | 528270 | 2020-09-13 | Unknown | Delaware | 465 | 0 | |
531507 | 531507 | 2020-09-14 | Unknown | Delaware | 470 | 0 | |
534742 | 534742 | 2020-09-15 | Unknown | Delaware | 493 | 0 | |
537978 | 537978 | 2020-09-16 | Unknown | Delaware | 478 | 0 | |
541215 | 541215 | 2020-09-17 | Unknown | Delaware | 479 | 0 | |
544451 | 544451 | 2020-09-18 | Unknown | Delaware | 477 | 0 | |
547689 | 547689 | 2020-09-19 | Unknown | Delaware | 476 | 0 | |
550928 | 550928 | 2020-09-20 | Unknown | Delaware | 480 | 0 | |
554167 | 554167 | 2020-09-21 | Unknown | Delaware | 480 | 0 | |
557404 | 557404 | 2020-09-22 | Unknown | Delaware | 482 | 0 | |
560640 | 560640 | 2020-09-23 | Unknown | Delaware | 482 | 0 | |
563880 | 563880 | 2020-09-24 | Unknown | Delaware | 488 | 0 | |
567120 | 567120 | 2020-09-25 | Unknown | Delaware | 487 | 0 | |
570362 | 570362 | 2020-09-26 | Unknown | Delaware | 489 | 0 | |
573604 | 573604 | 2020-09-27 | Unknown | Delaware | 489 | 0 | |
576847 | 576847 | 2020-09-28 | Unknown | Delaware | 493 | 0 | |
580088 | 580088 | 2020-09-29 | Unknown | Delaware | 491 | 0 | |
583327 | 583327 | 2020-09-30 | Unknown | Delaware | 491 | 0 | |
586567 | 586567 | 2020-10-01 | Unknown | Delaware | 491 | 0 | |
589808 | 589808 | 2020-10-02 | Unknown | Delaware | 90 | 0 | |
593048 | 593048 | 2020-10-03 | Unknown | Delaware | 90 | 0 | |
596290 | 596290 | 2020-10-04 | Unknown | Delaware | 90 | 0 | |
599533 | 599533 | 2020-10-05 | Unknown | Delaware | 90 | 0 | |
602776 | 602776 | 2020-10-06 | Unknown | Delaware | 90 | 0 | |
606018 | 606018 | 2020-10-07 | Unknown | Delaware | 90 | 0 | |
609261 | 609261 | 2020-10-08 | Unknown | Delaware | 90 | 0 | |
612503 | 612503 | 2020-10-09 | Unknown | Delaware | 90 | 0 | |
615744 | 615744 | 2020-10-10 | Unknown | Delaware | 91 | 0 | |
618986 | 618986 | 2020-10-11 | Unknown | Delaware | 91 | 0 | |
622229 | 622229 | 2020-10-12 | Unknown | Delaware | 91 | 0 | |
625472 | 625472 | 2020-10-13 | Unknown | Delaware | 91 | 0 | |
628715 | 628715 | 2020-10-14 | Unknown | Delaware | 91 | 0 | |
631959 | 631959 | 2020-10-15 | Unknown | Delaware | 91 | 0 | |
635205 | 635205 | 2020-10-16 | Unknown | Delaware | 91 | 0 | |
638450 | 638450 | 2020-10-17 | Unknown | Delaware | 91 | 0 | |
641697 | 641697 | 2020-10-18 | Unknown | Delaware | 91 | 0 | |
644945 | 644945 | 2020-10-19 | Unknown | Delaware | 91 | 0 | |
648190 | 648190 | 2020-10-20 | Unknown | Delaware | 91 | 0 | |
651434 | 651434 | 2020-10-21 | Unknown | Delaware | 91 | 0 | |
654679 | 654679 | 2020-10-22 | Unknown | Delaware | 91 | 0 | |
657924 | 657924 | 2020-10-23 | Unknown | Delaware | 91 | 0 | |
661168 | 661168 | 2020-10-24 | Unknown | Delaware | 91 | 0 | |
664412 | 664412 | 2020-10-25 | Unknown | Delaware | 91 | 0 | |
667657 | 667657 | 2020-10-26 | Unknown | Delaware | 91 | 0 | |
670900 | 670900 | 2020-10-27 | Unknown | Delaware | 91 | 0 | |
674142 | 674142 | 2020-10-28 | Unknown | Delaware | 91 | 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);