ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Washington" and state = "Vermont" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637800 | 637800 | 2020-10-16 | Washington | Vermont | 50023 | 94 | 2 |
634555 | 634555 | 2020-10-15 | Washington | Vermont | 50023 | 92 | 2 |
631310 | 631310 | 2020-10-14 | Washington | Vermont | 50023 | 90 | 2 |
628066 | 628066 | 2020-10-13 | Washington | Vermont | 50023 | 89 | 2 |
624823 | 624823 | 2020-10-12 | Washington | Vermont | 50023 | 86 | 2 |
621580 | 621580 | 2020-10-11 | Washington | Vermont | 50023 | 82 | 2 |
618337 | 618337 | 2020-10-10 | Washington | Vermont | 50023 | 82 | 2 |
615095 | 615095 | 2020-10-09 | Washington | Vermont | 50023 | 81 | 2 |
611854 | 611854 | 2020-10-08 | Washington | Vermont | 50023 | 81 | 2 |
608612 | 608612 | 2020-10-07 | Washington | Vermont | 50023 | 78 | 2 |
605369 | 605369 | 2020-10-06 | Washington | Vermont | 50023 | 78 | 2 |
602127 | 602127 | 2020-10-05 | Washington | Vermont | 50023 | 78 | 2 |
598884 | 598884 | 2020-10-04 | Washington | Vermont | 50023 | 78 | 2 |
595641 | 595641 | 2020-10-03 | Washington | Vermont | 50023 | 78 | 2 |
592399 | 592399 | 2020-10-02 | Washington | Vermont | 50023 | 78 | 2 |
589159 | 589159 | 2020-10-01 | Washington | Vermont | 50023 | 78 | 2 |
585918 | 585918 | 2020-09-30 | Washington | Vermont | 50023 | 78 | 2 |
582678 | 582678 | 2020-09-29 | Washington | Vermont | 50023 | 78 | 2 |
579439 | 579439 | 2020-09-28 | Washington | Vermont | 50023 | 78 | 2 |
576198 | 576198 | 2020-09-27 | Washington | Vermont | 50023 | 77 | 2 |
572954 | 572954 | 2020-09-26 | Washington | Vermont | 50023 | 77 | 2 |
569712 | 569712 | 2020-09-25 | Washington | Vermont | 50023 | 77 | 2 |
566471 | 566471 | 2020-09-24 | Washington | Vermont | 50023 | 77 | 2 |
563230 | 563230 | 2020-09-23 | Washington | Vermont | 50023 | 77 | 2 |
559991 | 559991 | 2020-09-22 | Washington | Vermont | 50023 | 77 | 2 |
556755 | 556755 | 2020-09-21 | Washington | Vermont | 50023 | 77 | 2 |
553518 | 553518 | 2020-09-20 | Washington | Vermont | 50023 | 76 | 2 |
550279 | 550279 | 2020-09-19 | Washington | Vermont | 50023 | 76 | 2 |
547040 | 547040 | 2020-09-18 | Washington | Vermont | 50023 | 76 | 2 |
543803 | 543803 | 2020-09-17 | Washington | Vermont | 50023 | 76 | 2 |
540567 | 540567 | 2020-09-16 | Washington | Vermont | 50023 | 76 | 2 |
537330 | 537330 | 2020-09-15 | Washington | Vermont | 50023 | 76 | 2 |
534094 | 534094 | 2020-09-14 | Washington | Vermont | 50023 | 74 | 2 |
530859 | 530859 | 2020-09-13 | Washington | Vermont | 50023 | 71 | 2 |
527622 | 527622 | 2020-09-12 | Washington | Vermont | 50023 | 69 | 2 |
524386 | 524386 | 2020-09-11 | Washington | Vermont | 50023 | 66 | 2 |
521150 | 521150 | 2020-09-10 | Washington | Vermont | 50023 | 64 | 2 |
517913 | 517913 | 2020-09-09 | Washington | Vermont | 50023 | 64 | 2 |
514678 | 514678 | 2020-09-08 | Washington | Vermont | 50023 | 64 | 2 |
511445 | 511445 | 2020-09-07 | Washington | Vermont | 50023 | 64 | 2 |
508212 | 508212 | 2020-09-06 | Washington | Vermont | 50023 | 64 | 2 |
504980 | 504980 | 2020-09-05 | Washington | Vermont | 50023 | 64 | 2 |
501746 | 501746 | 2020-09-04 | Washington | Vermont | 50023 | 63 | 2 |
498512 | 498512 | 2020-09-03 | Washington | Vermont | 50023 | 63 | 2 |
495279 | 495279 | 2020-09-02 | Washington | Vermont | 50023 | 62 | 2 |
492045 | 492045 | 2020-09-01 | Washington | Vermont | 50023 | 62 | 2 |
488812 | 488812 | 2020-08-31 | Washington | Vermont | 50023 | 62 | 2 |
485579 | 485579 | 2020-08-30 | Washington | Vermont | 50023 | 62 | 2 |
482344 | 482344 | 2020-08-29 | Washington | Vermont | 50023 | 62 | 2 |
479110 | 479110 | 2020-08-28 | Washington | Vermont | 50023 | 62 | 2 |
475877 | 475877 | 2020-08-27 | Washington | Vermont | 50023 | 61 | 2 |
472644 | 472644 | 2020-08-26 | Washington | Vermont | 50023 | 61 | 2 |
469412 | 469412 | 2020-08-25 | Washington | Vermont | 50023 | 61 | 2 |
466183 | 466183 | 2020-08-24 | Washington | Vermont | 50023 | 61 | 2 |
462954 | 462954 | 2020-08-23 | Washington | Vermont | 50023 | 60 | 2 |
459725 | 459725 | 2020-08-22 | Washington | Vermont | 50023 | 60 | 2 |
456498 | 456498 | 2020-08-21 | Washington | Vermont | 50023 | 59 | 2 |
453270 | 453270 | 2020-08-20 | Washington | Vermont | 50023 | 59 | 2 |
450042 | 450042 | 2020-08-19 | Washington | Vermont | 50023 | 59 | 2 |
446814 | 446814 | 2020-08-18 | Washington | Vermont | 50023 | 58 | 2 |
443587 | 443587 | 2020-08-17 | Washington | Vermont | 50023 | 58 | 2 |
440361 | 440361 | 2020-08-16 | Washington | Vermont | 50023 | 58 | 2 |
437135 | 437135 | 2020-08-15 | Washington | Vermont | 50023 | 58 | 2 |
433909 | 433909 | 2020-08-14 | Washington | Vermont | 50023 | 57 | 2 |
430684 | 430684 | 2020-08-13 | Washington | Vermont | 50023 | 57 | 2 |
427456 | 427456 | 2020-08-12 | Washington | Vermont | 50023 | 57 | 2 |
424232 | 424232 | 2020-08-11 | Washington | Vermont | 50023 | 53 | 2 |
421011 | 421011 | 2020-08-10 | Washington | Vermont | 50023 | 53 | 2 |
417790 | 417790 | 2020-08-09 | Washington | Vermont | 50023 | 53 | 2 |
414569 | 414569 | 2020-08-08 | Washington | Vermont | 50023 | 53 | 2 |
411349 | 411349 | 2020-08-07 | Washington | Vermont | 50023 | 53 | 2 |
408130 | 408130 | 2020-08-06 | Washington | Vermont | 50023 | 53 | 2 |
404910 | 404910 | 2020-08-05 | Washington | Vermont | 50023 | 52 | 2 |
401692 | 401692 | 2020-08-04 | Washington | Vermont | 50023 | 50 | 2 |
398476 | 398476 | 2020-08-03 | Washington | Vermont | 50023 | 49 | 2 |
395260 | 395260 | 2020-08-02 | Washington | Vermont | 50023 | 49 | 2 |
392044 | 392044 | 2020-08-01 | Washington | Vermont | 50023 | 47 | 2 |
388827 | 388827 | 2020-07-31 | Washington | Vermont | 50023 | 47 | 2 |
385610 | 385610 | 2020-07-30 | Washington | Vermont | 50023 | 47 | 2 |
382392 | 382392 | 2020-07-29 | Washington | Vermont | 50023 | 47 | 1 |
379175 | 379175 | 2020-07-28 | Washington | Vermont | 50023 | 47 | 1 |
375959 | 375959 | 2020-07-27 | Washington | Vermont | 50023 | 47 | 1 |
372745 | 372745 | 2020-07-26 | Washington | Vermont | 50023 | 47 | 1 |
369533 | 369533 | 2020-07-25 | Washington | Vermont | 50023 | 47 | 1 |
366324 | 366324 | 2020-07-24 | Washington | Vermont | 50023 | 46 | 1 |
363118 | 363118 | 2020-07-23 | Washington | Vermont | 50023 | 45 | 1 |
359911 | 359911 | 2020-07-22 | Washington | Vermont | 50023 | 45 | 1 |
356706 | 356706 | 2020-07-21 | Washington | Vermont | 50023 | 45 | 1 |
353503 | 353503 | 2020-07-20 | Washington | Vermont | 50023 | 45 | 1 |
350301 | 350301 | 2020-07-19 | Washington | Vermont | 50023 | 45 | 1 |
347100 | 347100 | 2020-07-18 | Washington | Vermont | 50023 | 45 | 1 |
343900 | 343900 | 2020-07-17 | Washington | Vermont | 50023 | 44 | 1 |
340701 | 340701 | 2020-07-16 | Washington | Vermont | 50023 | 44 | 1 |
337505 | 337505 | 2020-07-15 | Washington | Vermont | 50023 | 44 | 1 |
334310 | 334310 | 2020-07-14 | Washington | Vermont | 50023 | 43 | 1 |
331117 | 331117 | 2020-07-13 | Washington | Vermont | 50023 | 43 | 1 |
327931 | 327931 | 2020-07-12 | Washington | Vermont | 50023 | 43 | 1 |
324746 | 324746 | 2020-07-11 | Washington | Vermont | 50023 | 43 | 1 |
321565 | 321565 | 2020-07-10 | Washington | Vermont | 50023 | 42 | 1 |
318386 | 318386 | 2020-07-09 | Washington | Vermont | 50023 | 42 | 1 |
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);