ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Washington" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921324 | 921324 | 2021-01-12 | Washington | Iowa | 19183 | 2097 | 31 |
918079 | 918079 | 2021-01-11 | Washington | Iowa | 19183 | 2087 | 30 |
914834 | 914834 | 2021-01-10 | Washington | Iowa | 19183 | 2074 | 30 |
911589 | 911589 | 2021-01-09 | Washington | Iowa | 19183 | 2068 | 29 |
908344 | 908344 | 2021-01-08 | Washington | Iowa | 19183 | 2056 | 29 |
905098 | 905098 | 2021-01-07 | Washington | Iowa | 19183 | 2033 | 29 |
901853 | 901853 | 2021-01-06 | Washington | Iowa | 19183 | 1995 | 29 |
898608 | 898608 | 2021-01-05 | Washington | Iowa | 19183 | 1976 | 29 |
895363 | 895363 | 2021-01-04 | Washington | Iowa | 19183 | 1959 | 29 |
892116 | 892116 | 2021-01-03 | Washington | Iowa | 19183 | 1903 | 28 |
888870 | 888870 | 2021-01-02 | Washington | Iowa | 19183 | 1897 | 28 |
885624 | 885624 | 2021-01-01 | Washington | Iowa | 19183 | 1893 | 28 |
882379 | 882379 | 2020-12-31 | Washington | Iowa | 19183 | 1882 | 28 |
879134 | 879134 | 2020-12-30 | Washington | Iowa | 19183 | 1873 | 28 |
875889 | 875889 | 2020-12-29 | Washington | Iowa | 19183 | 1865 | 28 |
872644 | 872644 | 2020-12-28 | Washington | Iowa | 19183 | 1844 | 27 |
869399 | 869399 | 2020-12-27 | Washington | Iowa | 19183 | 1820 | 27 |
866154 | 866154 | 2020-12-26 | Washington | Iowa | 19183 | 1816 | 27 |
862909 | 862909 | 2020-12-25 | Washington | Iowa | 19183 | 1810 | 27 |
859664 | 859664 | 2020-12-24 | Washington | Iowa | 19183 | 1805 | 27 |
856419 | 856419 | 2020-12-23 | Washington | Iowa | 19183 | 1798 | 27 |
853174 | 853174 | 2020-12-22 | Washington | Iowa | 19183 | 1780 | 27 |
849929 | 849929 | 2020-12-21 | Washington | Iowa | 19183 | 1758 | 27 |
846684 | 846684 | 2020-12-20 | Washington | Iowa | 19183 | 1744 | 27 |
843438 | 843438 | 2020-12-19 | Washington | Iowa | 19183 | 1742 | 27 |
840193 | 840193 | 2020-12-18 | Washington | Iowa | 19183 | 1720 | 26 |
836948 | 836948 | 2020-12-17 | Washington | Iowa | 19183 | 1690 | 26 |
833702 | 833702 | 2020-12-16 | Washington | Iowa | 19183 | 1663 | 26 |
830455 | 830455 | 2020-12-15 | Washington | Iowa | 19183 | 1635 | 26 |
827209 | 827209 | 2020-12-14 | Washington | Iowa | 19183 | 1631 | 24 |
823962 | 823962 | 2020-12-13 | Washington | Iowa | 19183 | 1626 | 23 |
820716 | 820716 | 2020-12-12 | Washington | Iowa | 19183 | 1617 | 23 |
817470 | 817470 | 2020-12-11 | Washington | Iowa | 19183 | 1606 | 23 |
814224 | 814224 | 2020-12-10 | Washington | Iowa | 19183 | 1591 | 23 |
810979 | 810979 | 2020-12-09 | Washington | Iowa | 19183 | 1573 | 22 |
807734 | 807734 | 2020-12-08 | Washington | Iowa | 19183 | 1551 | 21 |
804489 | 804489 | 2020-12-07 | Washington | Iowa | 19183 | 1550 | 16 |
801244 | 801244 | 2020-12-06 | Washington | Iowa | 19183 | 1537 | 16 |
797999 | 797999 | 2020-12-05 | Washington | Iowa | 19183 | 1531 | 16 |
794754 | 794754 | 2020-12-04 | Washington | Iowa | 19183 | 1520 | 16 |
791509 | 791509 | 2020-12-03 | Washington | Iowa | 19183 | 1501 | 16 |
788264 | 788264 | 2020-12-02 | Washington | Iowa | 19183 | 1497 | 15 |
785020 | 785020 | 2020-12-01 | Washington | Iowa | 19183 | 1468 | 15 |
781775 | 781775 | 2020-11-30 | Washington | Iowa | 19183 | 1460 | 15 |
778529 | 778529 | 2020-11-29 | Washington | Iowa | 19183 | 1414 | 14 |
775284 | 775284 | 2020-11-28 | Washington | Iowa | 19183 | 1403 | 14 |
772039 | 772039 | 2020-11-27 | Washington | Iowa | 19183 | 1381 | 14 |
768794 | 768794 | 2020-11-26 | Washington | Iowa | 19183 | 1374 | 14 |
765548 | 765548 | 2020-11-25 | Washington | Iowa | 19183 | 1369 | 14 |
762303 | 762303 | 2020-11-24 | Washington | Iowa | 19183 | 1359 | 13 |
759058 | 759058 | 2020-11-23 | Washington | Iowa | 19183 | 1310 | 13 |
755811 | 755811 | 2020-11-22 | Washington | Iowa | 19183 | 1265 | 13 |
752565 | 752565 | 2020-11-21 | Washington | Iowa | 19183 | 1251 | 13 |
749319 | 749319 | 2020-11-20 | Washington | Iowa | 19183 | 1233 | 12 |
746073 | 746073 | 2020-11-19 | Washington | Iowa | 19183 | 1213 | 12 |
742826 | 742826 | 2020-11-18 | Washington | Iowa | 19183 | 1184 | 12 |
739579 | 739579 | 2020-11-17 | Washington | Iowa | 19183 | 1148 | 12 |
736335 | 736335 | 2020-11-16 | Washington | Iowa | 19183 | 1125 | 12 |
733089 | 733089 | 2020-11-15 | Washington | Iowa | 19183 | 1085 | 12 |
729844 | 729844 | 2020-11-14 | Washington | Iowa | 19183 | 1074 | 12 |
726601 | 726601 | 2020-11-13 | Washington | Iowa | 19183 | 1058 | 12 |
723358 | 723358 | 2020-11-12 | Washington | Iowa | 19183 | 1019 | 12 |
720115 | 720115 | 2020-11-11 | Washington | Iowa | 19183 | 972 | 12 |
716872 | 716872 | 2020-11-10 | Washington | Iowa | 19183 | 948 | 12 |
713628 | 713628 | 2020-11-09 | Washington | Iowa | 19183 | 912 | 12 |
710384 | 710384 | 2020-11-08 | Washington | Iowa | 19183 | 869 | 12 |
707140 | 707140 | 2020-11-07 | Washington | Iowa | 19183 | 848 | 12 |
703897 | 703897 | 2020-11-06 | Washington | Iowa | 19183 | 828 | 12 |
700655 | 700655 | 2020-11-05 | Washington | Iowa | 19183 | 815 | 12 |
697411 | 697411 | 2020-11-04 | Washington | Iowa | 19183 | 787 | 12 |
694169 | 694169 | 2020-11-03 | Washington | Iowa | 19183 | 773 | 12 |
690926 | 690926 | 2020-11-02 | Washington | Iowa | 19183 | 756 | 12 |
687681 | 687681 | 2020-11-01 | Washington | Iowa | 19183 | 729 | 12 |
684437 | 684437 | 2020-10-31 | Washington | Iowa | 19183 | 720 | 12 |
681194 | 681194 | 2020-10-30 | Washington | Iowa | 19183 | 712 | 12 |
677951 | 677951 | 2020-10-29 | Washington | Iowa | 19183 | 696 | 11 |
674708 | 674708 | 2020-10-28 | Washington | Iowa | 19183 | 680 | 11 |
671466 | 671466 | 2020-10-27 | Washington | Iowa | 19183 | 667 | 11 |
668223 | 668223 | 2020-10-26 | Washington | Iowa | 19183 | 662 | 11 |
664979 | 664979 | 2020-10-25 | Washington | Iowa | 19183 | 653 | 11 |
661734 | 661734 | 2020-10-24 | Washington | Iowa | 19183 | 650 | 11 |
658490 | 658490 | 2020-10-23 | Washington | Iowa | 19183 | 638 | 11 |
655245 | 655245 | 2020-10-22 | Washington | Iowa | 19183 | 629 | 11 |
652000 | 652000 | 2020-10-21 | Washington | Iowa | 19183 | 619 | 11 |
648756 | 648756 | 2020-10-20 | Washington | Iowa | 19183 | 611 | 11 |
645511 | 645511 | 2020-10-19 | Washington | Iowa | 19183 | 610 | 11 |
642264 | 642264 | 2020-10-18 | Washington | Iowa | 19183 | 606 | 11 |
639017 | 639017 | 2020-10-17 | Washington | Iowa | 19183 | 601 | 11 |
635771 | 635771 | 2020-10-16 | Washington | Iowa | 19183 | 595 | 11 |
632525 | 632525 | 2020-10-15 | Washington | Iowa | 19183 | 586 | 11 |
629281 | 629281 | 2020-10-14 | Washington | Iowa | 19183 | 579 | 11 |
626038 | 626038 | 2020-10-13 | Washington | Iowa | 19183 | 570 | 11 |
622796 | 622796 | 2020-10-12 | Washington | Iowa | 19183 | 561 | 11 |
619552 | 619552 | 2020-10-11 | Washington | Iowa | 19183 | 555 | 11 |
616310 | 616310 | 2020-10-10 | Washington | Iowa | 19183 | 555 | 11 |
613069 | 613069 | 2020-10-09 | Washington | Iowa | 19183 | 548 | 11 |
609827 | 609827 | 2020-10-08 | Washington | Iowa | 19183 | 543 | 11 |
606584 | 606584 | 2020-10-07 | Washington | Iowa | 19183 | 540 | 11 |
603342 | 603342 | 2020-10-06 | Washington | Iowa | 19183 | 531 | 11 |
600099 | 600099 | 2020-10-05 | Washington | Iowa | 19183 | 522 | 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);