ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Washington" and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636085 | 636085 | 2020-10-16 | Washington | Maine | 23029 | 20 | 0 |
632839 | 632839 | 2020-10-15 | Washington | Maine | 23029 | 20 | 0 |
629594 | 629594 | 2020-10-14 | Washington | Maine | 23029 | 20 | 0 |
626350 | 626350 | 2020-10-13 | Washington | Maine | 23029 | 20 | 0 |
623108 | 623108 | 2020-10-12 | Washington | Maine | 23029 | 20 | 0 |
619865 | 619865 | 2020-10-11 | Washington | Maine | 23029 | 20 | 0 |
616623 | 616623 | 2020-10-10 | Washington | Maine | 23029 | 20 | 0 |
613382 | 613382 | 2020-10-09 | Washington | Maine | 23029 | 20 | 0 |
610140 | 610140 | 2020-10-08 | Washington | Maine | 23029 | 20 | 0 |
606898 | 606898 | 2020-10-07 | Washington | Maine | 23029 | 20 | 0 |
603655 | 603655 | 2020-10-06 | Washington | Maine | 23029 | 20 | 0 |
600413 | 600413 | 2020-10-05 | Washington | Maine | 23029 | 20 | 0 |
597170 | 597170 | 2020-10-04 | Washington | Maine | 23029 | 19 | 0 |
593929 | 593929 | 2020-10-03 | Washington | Maine | 23029 | 18 | 0 |
590688 | 590688 | 2020-10-02 | Washington | Maine | 23029 | 18 | 0 |
587447 | 587447 | 2020-10-01 | Washington | Maine | 23029 | 16 | 0 |
584207 | 584207 | 2020-09-30 | Washington | Maine | 23029 | 16 | 0 |
580966 | 580966 | 2020-09-29 | Washington | Maine | 23029 | 16 | 0 |
577725 | 577725 | 2020-09-28 | Washington | Maine | 23029 | 16 | 0 |
574484 | 574484 | 2020-09-27 | Washington | Maine | 23029 | 16 | 0 |
571241 | 571241 | 2020-09-26 | Washington | Maine | 23029 | 16 | 0 |
567999 | 567999 | 2020-09-25 | Washington | Maine | 23029 | 16 | 0 |
564759 | 564759 | 2020-09-24 | Washington | Maine | 23029 | 16 | 0 |
561519 | 561519 | 2020-09-23 | Washington | Maine | 23029 | 16 | 0 |
558282 | 558282 | 2020-09-22 | Washington | Maine | 23029 | 15 | 0 |
555045 | 555045 | 2020-09-21 | Washington | Maine | 23029 | 15 | 0 |
551807 | 551807 | 2020-09-20 | Washington | Maine | 23029 | 15 | 0 |
548568 | 548568 | 2020-09-19 | Washington | Maine | 23029 | 15 | 0 |
545330 | 545330 | 2020-09-18 | Washington | Maine | 23029 | 15 | 0 |
542093 | 542093 | 2020-09-17 | Washington | Maine | 23029 | 15 | 0 |
538857 | 538857 | 2020-09-16 | Washington | Maine | 23029 | 15 | 0 |
535620 | 535620 | 2020-09-15 | Washington | Maine | 23029 | 15 | 0 |
532385 | 532385 | 2020-09-14 | Washington | Maine | 23029 | 15 | 0 |
529149 | 529149 | 2020-09-13 | Washington | Maine | 23029 | 15 | 0 |
525913 | 525913 | 2020-09-12 | Washington | Maine | 23029 | 15 | 0 |
522677 | 522677 | 2020-09-11 | Washington | Maine | 23029 | 15 | 0 |
519440 | 519440 | 2020-09-10 | Washington | Maine | 23029 | 15 | 0 |
516205 | 516205 | 2020-09-09 | Washington | Maine | 23029 | 15 | 0 |
512971 | 512971 | 2020-09-08 | Washington | Maine | 23029 | 15 | 0 |
509739 | 509739 | 2020-09-07 | Washington | Maine | 23029 | 15 | 0 |
506506 | 506506 | 2020-09-06 | Washington | Maine | 23029 | 15 | 0 |
503273 | 503273 | 2020-09-05 | Washington | Maine | 23029 | 15 | 0 |
500039 | 500039 | 2020-09-04 | Washington | Maine | 23029 | 15 | 0 |
496805 | 496805 | 2020-09-03 | Washington | Maine | 23029 | 15 | 0 |
493572 | 493572 | 2020-09-02 | Washington | Maine | 23029 | 15 | 0 |
490338 | 490338 | 2020-09-01 | Washington | Maine | 23029 | 15 | 0 |
487105 | 487105 | 2020-08-31 | Washington | Maine | 23029 | 15 | 0 |
483871 | 483871 | 2020-08-30 | Washington | Maine | 23029 | 15 | 0 |
480636 | 480636 | 2020-08-29 | Washington | Maine | 23029 | 15 | 0 |
477404 | 477404 | 2020-08-28 | Washington | Maine | 23029 | 15 | 0 |
474171 | 474171 | 2020-08-27 | Washington | Maine | 23029 | 15 | 0 |
470939 | 470939 | 2020-08-26 | Washington | Maine | 23029 | 15 | 0 |
467709 | 467709 | 2020-08-25 | Washington | Maine | 23029 | 15 | 0 |
464480 | 464480 | 2020-08-24 | Washington | Maine | 23029 | 15 | 0 |
461249 | 461249 | 2020-08-23 | Washington | Maine | 23029 | 15 | 0 |
458022 | 458022 | 2020-08-22 | Washington | Maine | 23029 | 15 | 0 |
454794 | 454794 | 2020-08-21 | Washington | Maine | 23029 | 15 | 0 |
451566 | 451566 | 2020-08-20 | Washington | Maine | 23029 | 15 | 0 |
448338 | 448338 | 2020-08-19 | Washington | Maine | 23029 | 15 | 0 |
445112 | 445112 | 2020-08-18 | Washington | Maine | 23029 | 15 | 0 |
441886 | 441886 | 2020-08-17 | Washington | Maine | 23029 | 15 | 0 |
438659 | 438659 | 2020-08-16 | Washington | Maine | 23029 | 14 | 0 |
435434 | 435434 | 2020-08-15 | Washington | Maine | 23029 | 14 | 0 |
432208 | 432208 | 2020-08-14 | Washington | Maine | 23029 | 14 | 0 |
428981 | 428981 | 2020-08-13 | Washington | Maine | 23029 | 13 | 0 |
425757 | 425757 | 2020-08-12 | Washington | Maine | 23029 | 13 | 0 |
422535 | 422535 | 2020-08-11 | Washington | Maine | 23029 | 13 | 0 |
419313 | 419313 | 2020-08-10 | Washington | Maine | 23029 | 13 | 0 |
416092 | 416092 | 2020-08-09 | Washington | Maine | 23029 | 13 | 0 |
412872 | 412872 | 2020-08-08 | Washington | Maine | 23029 | 12 | 0 |
409652 | 409652 | 2020-08-07 | Washington | Maine | 23029 | 12 | 0 |
406432 | 406432 | 2020-08-06 | Washington | Maine | 23029 | 12 | 0 |
403214 | 403214 | 2020-08-05 | Washington | Maine | 23029 | 12 | 0 |
399997 | 399997 | 2020-08-04 | Washington | Maine | 23029 | 12 | 0 |
396783 | 396783 | 2020-08-03 | Washington | Maine | 23029 | 9 | 0 |
393567 | 393567 | 2020-08-02 | Washington | Maine | 23029 | 9 | 0 |
390350 | 390350 | 2020-08-01 | Washington | Maine | 23029 | 8 | 0 |
387133 | 387133 | 2020-07-31 | Washington | Maine | 23029 | 7 | 0 |
383915 | 383915 | 2020-07-30 | Washington | Maine | 23029 | 7 | 0 |
380698 | 380698 | 2020-07-29 | Washington | Maine | 23029 | 7 | 0 |
377481 | 377481 | 2020-07-28 | Washington | Maine | 23029 | 7 | 0 |
374266 | 374266 | 2020-07-27 | Washington | Maine | 23029 | 7 | 0 |
371054 | 371054 | 2020-07-26 | Washington | Maine | 23029 | 7 | 0 |
367844 | 367844 | 2020-07-25 | Washington | Maine | 23029 | 5 | 0 |
364637 | 364637 | 2020-07-24 | Washington | Maine | 23029 | 5 | 0 |
361430 | 361430 | 2020-07-23 | Washington | Maine | 23029 | 6 | 0 |
358225 | 358225 | 2020-07-22 | Washington | Maine | 23029 | 6 | 0 |
355022 | 355022 | 2020-07-21 | Washington | Maine | 23029 | 6 | 0 |
351820 | 351820 | 2020-07-20 | Washington | Maine | 23029 | 6 | 0 |
348620 | 348620 | 2020-07-19 | Washington | Maine | 23029 | 6 | 0 |
345419 | 345419 | 2020-07-18 | Washington | Maine | 23029 | 5 | 0 |
342219 | 342219 | 2020-07-17 | Washington | Maine | 23029 | 5 | 0 |
339023 | 339023 | 2020-07-16 | Washington | Maine | 23029 | 5 | 0 |
335827 | 335827 | 2020-07-15 | Washington | Maine | 23029 | 5 | 0 |
332634 | 332634 | 2020-07-14 | Washington | Maine | 23029 | 4 | 0 |
329447 | 329447 | 2020-07-13 | Washington | Maine | 23029 | 5 | 0 |
326261 | 326261 | 2020-07-12 | Washington | Maine | 23029 | 5 | 0 |
323078 | 323078 | 2020-07-11 | Washington | Maine | 23029 | 5 | 0 |
319899 | 319899 | 2020-07-10 | Washington | Maine | 23029 | 5 | 0 |
316724 | 316724 | 2020-07-09 | Washington | Maine | 23029 | 5 | 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);