ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Washington" and fips = 29221 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922046 | 922046 | 2021-01-12 | Washington | Missouri | 29221 | 1934 | 41 |
918801 | 918801 | 2021-01-11 | Washington | Missouri | 29221 | 1930 | 41 |
915556 | 915556 | 2021-01-10 | Washington | Missouri | 29221 | 1917 | 41 |
912311 | 912311 | 2021-01-09 | Washington | Missouri | 29221 | 1906 | 41 |
909066 | 909066 | 2021-01-08 | Washington | Missouri | 29221 | 1894 | 41 |
905820 | 905820 | 2021-01-07 | Washington | Missouri | 29221 | 1870 | 41 |
902575 | 902575 | 2021-01-06 | Washington | Missouri | 29221 | 1838 | 41 |
899330 | 899330 | 2021-01-05 | Washington | Missouri | 29221 | 1836 | 41 |
896085 | 896085 | 2021-01-04 | Washington | Missouri | 29221 | 1825 | 39 |
892838 | 892838 | 2021-01-03 | Washington | Missouri | 29221 | 1825 | 39 |
889592 | 889592 | 2021-01-02 | Washington | Missouri | 29221 | 1811 | 39 |
886346 | 886346 | 2021-01-01 | Washington | Missouri | 29221 | 1798 | 39 |
883101 | 883101 | 2020-12-31 | Washington | Missouri | 29221 | 1780 | 39 |
879856 | 879856 | 2020-12-30 | Washington | Missouri | 29221 | 1766 | 39 |
876611 | 876611 | 2020-12-29 | Washington | Missouri | 29221 | 1749 | 39 |
873366 | 873366 | 2020-12-28 | Washington | Missouri | 29221 | 1735 | 39 |
870121 | 870121 | 2020-12-27 | Washington | Missouri | 29221 | 1726 | 39 |
866876 | 866876 | 2020-12-26 | Washington | Missouri | 29221 | 1724 | 39 |
863631 | 863631 | 2020-12-25 | Washington | Missouri | 29221 | 1720 | 39 |
860386 | 860386 | 2020-12-24 | Washington | Missouri | 29221 | 1714 | 36 |
857141 | 857141 | 2020-12-23 | Washington | Missouri | 29221 | 1700 | 36 |
853896 | 853896 | 2020-12-22 | Washington | Missouri | 29221 | 1691 | 35 |
850651 | 850651 | 2020-12-21 | Washington | Missouri | 29221 | 1682 | 34 |
847406 | 847406 | 2020-12-20 | Washington | Missouri | 29221 | 1671 | 34 |
844160 | 844160 | 2020-12-19 | Washington | Missouri | 29221 | 1661 | 34 |
840915 | 840915 | 2020-12-18 | Washington | Missouri | 29221 | 1652 | 34 |
837670 | 837670 | 2020-12-17 | Washington | Missouri | 29221 | 1640 | 34 |
834424 | 834424 | 2020-12-16 | Washington | Missouri | 29221 | 1632 | 34 |
831177 | 831177 | 2020-12-15 | Washington | Missouri | 29221 | 1625 | 32 |
827931 | 827931 | 2020-12-14 | Washington | Missouri | 29221 | 1615 | 31 |
824684 | 824684 | 2020-12-13 | Washington | Missouri | 29221 | 1613 | 28 |
821438 | 821438 | 2020-12-12 | Washington | Missouri | 29221 | 1609 | 27 |
818192 | 818192 | 2020-12-11 | Washington | Missouri | 29221 | 1587 | 27 |
814946 | 814946 | 2020-12-10 | Washington | Missouri | 29221 | 1587 | 27 |
811701 | 811701 | 2020-12-09 | Washington | Missouri | 29221 | 1564 | 27 |
808456 | 808456 | 2020-12-08 | Washington | Missouri | 29221 | 1564 | 27 |
805211 | 805211 | 2020-12-07 | Washington | Missouri | 29221 | 1555 | 27 |
801966 | 801966 | 2020-12-06 | Washington | Missouri | 29221 | 1540 | 27 |
798721 | 798721 | 2020-12-05 | Washington | Missouri | 29221 | 1528 | 22 |
795476 | 795476 | 2020-12-04 | Washington | Missouri | 29221 | 1522 | 22 |
792231 | 792231 | 2020-12-03 | Washington | Missouri | 29221 | 1517 | 22 |
788986 | 788986 | 2020-12-02 | Washington | Missouri | 29221 | 1490 | 22 |
785741 | 785741 | 2020-12-01 | Washington | Missouri | 29221 | 1475 | 23 |
782497 | 782497 | 2020-11-30 | Washington | Missouri | 29221 | 1450 | 23 |
779251 | 779251 | 2020-11-29 | Washington | Missouri | 29221 | 1417 | 23 |
776006 | 776006 | 2020-11-28 | Washington | Missouri | 29221 | 1411 | 23 |
772761 | 772761 | 2020-11-27 | Washington | Missouri | 29221 | 1408 | 23 |
769516 | 769516 | 2020-11-26 | Washington | Missouri | 29221 | 1396 | 23 |
766270 | 766270 | 2020-11-25 | Washington | Missouri | 29221 | 1377 | 23 |
763025 | 763025 | 2020-11-24 | Washington | Missouri | 29221 | 1353 | 23 |
759780 | 759780 | 2020-11-23 | Washington | Missouri | 29221 | 1334 | 22 |
756533 | 756533 | 2020-11-22 | Washington | Missouri | 29221 | 1323 | 22 |
753287 | 753287 | 2020-11-21 | Washington | Missouri | 29221 | 1299 | 22 |
750041 | 750041 | 2020-11-20 | Washington | Missouri | 29221 | 1256 | 22 |
746795 | 746795 | 2020-11-19 | Washington | Missouri | 29221 | 1222 | 22 |
743548 | 743548 | 2020-11-18 | Washington | Missouri | 29221 | 1189 | 22 |
740301 | 740301 | 2020-11-17 | Washington | Missouri | 29221 | 1172 | 22 |
737057 | 737057 | 2020-11-16 | Washington | Missouri | 29221 | 1157 | 21 |
733811 | 733811 | 2020-11-15 | Washington | Missouri | 29221 | 1135 | 21 |
730566 | 730566 | 2020-11-14 | Washington | Missouri | 29221 | 1135 | 21 |
727323 | 727323 | 2020-11-13 | Washington | Missouri | 29221 | 1022 | 21 |
724080 | 724080 | 2020-11-12 | Washington | Missouri | 29221 | 997 | 21 |
720837 | 720837 | 2020-11-11 | Washington | Missouri | 29221 | 977 | 20 |
717594 | 717594 | 2020-11-10 | Washington | Missouri | 29221 | 969 | 20 |
714350 | 714350 | 2020-11-09 | Washington | Missouri | 29221 | 931 | 20 |
711106 | 711106 | 2020-11-08 | Washington | Missouri | 29221 | 915 | 20 |
707862 | 707862 | 2020-11-07 | Washington | Missouri | 29221 | 889 | 20 |
704619 | 704619 | 2020-11-06 | Washington | Missouri | 29221 | 820 | 20 |
701377 | 701377 | 2020-11-05 | Washington | Missouri | 29221 | 795 | 20 |
698133 | 698133 | 2020-11-04 | Washington | Missouri | 29221 | 766 | 20 |
694890 | 694890 | 2020-11-03 | Washington | Missouri | 29221 | 754 | 20 |
691648 | 691648 | 2020-11-02 | Washington | Missouri | 29221 | 741 | 20 |
688403 | 688403 | 2020-11-01 | Washington | Missouri | 29221 | 728 | 20 |
685159 | 685159 | 2020-10-31 | Washington | Missouri | 29221 | 723 | 20 |
681916 | 681916 | 2020-10-30 | Washington | Missouri | 29221 | 702 | 19 |
678672 | 678672 | 2020-10-29 | Washington | Missouri | 29221 | 688 | 19 |
675430 | 675430 | 2020-10-28 | Washington | Missouri | 29221 | 673 | 19 |
672187 | 672187 | 2020-10-27 | Washington | Missouri | 29221 | 667 | 18 |
668945 | 668945 | 2020-10-26 | Washington | Missouri | 29221 | 662 | 18 |
665701 | 665701 | 2020-10-25 | Washington | Missouri | 29221 | 659 | 18 |
662456 | 662456 | 2020-10-24 | Washington | Missouri | 29221 | 638 | 18 |
659212 | 659212 | 2020-10-23 | Washington | Missouri | 29221 | 623 | 17 |
655967 | 655967 | 2020-10-22 | Washington | Missouri | 29221 | 617 | 16 |
652722 | 652722 | 2020-10-21 | Washington | Missouri | 29221 | 605 | 16 |
649477 | 649477 | 2020-10-20 | Washington | Missouri | 29221 | 601 | 16 |
646233 | 646233 | 2020-10-19 | Washington | Missouri | 29221 | 601 | 16 |
642987 | 642987 | 2020-10-18 | Washington | Missouri | 29221 | 596 | 14 |
639739 | 639739 | 2020-10-17 | Washington | Missouri | 29221 | 581 | 14 |
636493 | 636493 | 2020-10-16 | Washington | Missouri | 29221 | 573 | 11 |
633247 | 633247 | 2020-10-15 | Washington | Missouri | 29221 | 561 | 11 |
630002 | 630002 | 2020-10-14 | Washington | Missouri | 29221 | 551 | 11 |
626758 | 626758 | 2020-10-13 | Washington | Missouri | 29221 | 544 | 12 |
623516 | 623516 | 2020-10-12 | Washington | Missouri | 29221 | 544 | 12 |
620273 | 620273 | 2020-10-11 | Washington | Missouri | 29221 | 544 | 12 |
617031 | 617031 | 2020-10-10 | Washington | Missouri | 29221 | 544 | 12 |
613790 | 613790 | 2020-10-09 | Washington | Missouri | 29221 | 522 | 11 |
610548 | 610548 | 2020-10-08 | Washington | Missouri | 29221 | 508 | 11 |
607306 | 607306 | 2020-10-07 | Washington | Missouri | 29221 | 504 | 11 |
604063 | 604063 | 2020-10-06 | Washington | Missouri | 29221 | 501 | 11 |
600821 | 600821 | 2020-10-05 | Washington | Missouri | 29221 | 494 | 11 |
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);