ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
743 rows where county = "Unknown" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921320 | 921320 | 2021-01-12 | Unknown | Iowa | 861 | 0 | |
918075 | 918075 | 2021-01-11 | Unknown | Iowa | 857 | 0 | |
914830 | 914830 | 2021-01-10 | Unknown | Iowa | 848 | 0 | |
911585 | 911585 | 2021-01-09 | Unknown | Iowa | 843 | 0 | |
908340 | 908340 | 2021-01-08 | Unknown | Iowa | 834 | 0 | |
905094 | 905094 | 2021-01-07 | Unknown | Iowa | 828 | 0 | |
901849 | 901849 | 2021-01-06 | Unknown | Iowa | 809 | 0 | |
898604 | 898604 | 2021-01-05 | Unknown | Iowa | 805 | 0 | |
895359 | 895359 | 2021-01-04 | Unknown | Iowa | 780 | 0 | |
892112 | 892112 | 2021-01-03 | Unknown | Iowa | 762 | 0 | |
888866 | 888866 | 2021-01-02 | Unknown | Iowa | 756 | 0 | |
885620 | 885620 | 2021-01-01 | Unknown | Iowa | 751 | 0 | |
882375 | 882375 | 2020-12-31 | Unknown | Iowa | 694 | 0 | |
879130 | 879130 | 2020-12-30 | Unknown | Iowa | 669 | 0 | |
875885 | 875885 | 2020-12-29 | Unknown | Iowa | 656 | 0 | |
872640 | 872640 | 2020-12-28 | Unknown | Iowa | 638 | 1 | |
869395 | 869395 | 2020-12-27 | Unknown | Iowa | 624 | 1 | |
866150 | 866150 | 2020-12-26 | Unknown | Iowa | 620 | 1 | |
862905 | 862905 | 2020-12-25 | Unknown | Iowa | 620 | 1 | |
859660 | 859660 | 2020-12-24 | Unknown | Iowa | 615 | 1 | |
856415 | 856415 | 2020-12-23 | Unknown | Iowa | 580 | 1 | |
853170 | 853170 | 2020-12-22 | Unknown | Iowa | 541 | 1 | |
849925 | 849925 | 2020-12-21 | Unknown | Iowa | 492 | 1 | |
846680 | 846680 | 2020-12-20 | Unknown | Iowa | 460 | 1 | |
843434 | 843434 | 2020-12-19 | Unknown | Iowa | 451 | 1 | |
840189 | 840189 | 2020-12-18 | Unknown | Iowa | 461 | 1 | |
836944 | 836944 | 2020-12-17 | Unknown | Iowa | 466 | 1 | |
833698 | 833698 | 2020-12-16 | Unknown | Iowa | 492 | 1 | |
830451 | 830451 | 2020-12-15 | Unknown | Iowa | 569 | 1 | |
827205 | 827205 | 2020-12-14 | Unknown | Iowa | 616 | 0 | |
823958 | 823958 | 2020-12-13 | Unknown | Iowa | 608 | 0 | |
820712 | 820712 | 2020-12-12 | Unknown | Iowa | 605 | 0 | |
817466 | 817466 | 2020-12-11 | Unknown | Iowa | 593 | 0 | |
814220 | 814220 | 2020-12-10 | Unknown | Iowa | 720 | 0 | |
810975 | 810975 | 2020-12-09 | Unknown | Iowa | 753 | 0 | |
807730 | 807730 | 2020-12-08 | Unknown | Iowa | 734 | 0 | |
804485 | 804485 | 2020-12-07 | Unknown | Iowa | 733 | 0 | |
801240 | 801240 | 2020-12-06 | Unknown | Iowa | 733 | 0 | |
797995 | 797995 | 2020-12-05 | Unknown | Iowa | 736 | 0 | |
794750 | 794750 | 2020-12-04 | Unknown | Iowa | 723 | 0 | |
791505 | 791505 | 2020-12-03 | Unknown | Iowa | 709 | 0 | |
788260 | 788260 | 2020-12-02 | Unknown | Iowa | 705 | 0 | |
785016 | 785016 | 2020-12-01 | Unknown | Iowa | 696 | 0 | |
781771 | 781771 | 2020-11-30 | Unknown | Iowa | 695 | 0 | |
778525 | 778525 | 2020-11-29 | Unknown | Iowa | 668 | 0 | |
775280 | 775280 | 2020-11-28 | Unknown | Iowa | 662 | 0 | |
772035 | 772035 | 2020-11-27 | Unknown | Iowa | 647 | 0 | |
768790 | 768790 | 2020-11-26 | Unknown | Iowa | 632 | 0 | |
765544 | 765544 | 2020-11-25 | Unknown | Iowa | 617 | 0 | |
762299 | 762299 | 2020-11-24 | Unknown | Iowa | 596 | 1 | |
759054 | 759054 | 2020-11-23 | Unknown | Iowa | 594 | 0 | |
755807 | 755807 | 2020-11-22 | Unknown | Iowa | 581 | 0 | |
752561 | 752561 | 2020-11-21 | Unknown | Iowa | 558 | 0 | |
749315 | 749315 | 2020-11-20 | Unknown | Iowa | 533 | 0 | |
746069 | 746069 | 2020-11-19 | Unknown | Iowa | 519 | 0 | |
742822 | 742822 | 2020-11-18 | Unknown | Iowa | 497 | 0 | |
739575 | 739575 | 2020-11-17 | Unknown | Iowa | 468 | 0 | |
736331 | 736331 | 2020-11-16 | Unknown | Iowa | 545 | 0 | |
733085 | 733085 | 2020-11-15 | Unknown | Iowa | 539 | 0 | |
729840 | 729840 | 2020-11-14 | Unknown | Iowa | 514 | 0 | |
726597 | 726597 | 2020-11-13 | Unknown | Iowa | 445 | 0 | |
723354 | 723354 | 2020-11-12 | Unknown | Iowa | 433 | 0 | |
720111 | 720111 | 2020-11-11 | Unknown | Iowa | 352 | 0 | |
716868 | 716868 | 2020-11-10 | Unknown | Iowa | 282 | 0 | |
713624 | 713624 | 2020-11-09 | Unknown | Iowa | 285 | 0 | |
710380 | 710380 | 2020-11-08 | Unknown | Iowa | 244 | 0 | |
707136 | 707136 | 2020-11-07 | Unknown | Iowa | 276 | 0 | |
703893 | 703893 | 2020-11-06 | Unknown | Iowa | 134 | 0 | |
700651 | 700651 | 2020-11-05 | Unknown | Iowa | 126 | 0 | |
697407 | 697407 | 2020-11-04 | Unknown | Iowa | 100 | 0 | |
694165 | 694165 | 2020-11-03 | Unknown | Iowa | 78 | 0 | |
690922 | 690922 | 2020-11-02 | Unknown | Iowa | 54 | 0 | |
687677 | 687677 | 2020-11-01 | Unknown | Iowa | 47 | 0 | |
684433 | 684433 | 2020-10-31 | Unknown | Iowa | 35 | 0 | |
681190 | 681190 | 2020-10-30 | Unknown | Iowa | 9 | 0 | |
677947 | 677947 | 2020-10-29 | Unknown | Iowa | 8 | 0 | |
674704 | 674704 | 2020-10-28 | Unknown | Iowa | 12 | 0 | |
671462 | 671462 | 2020-10-27 | Unknown | Iowa | 17 | 0 | |
668219 | 668219 | 2020-10-26 | Unknown | Iowa | 11 | 0 | |
664975 | 664975 | 2020-10-25 | Unknown | Iowa | 26 | 0 | |
661730 | 661730 | 2020-10-24 | Unknown | Iowa | 15 | 0 | |
658486 | 658486 | 2020-10-23 | Unknown | Iowa | 9 | 0 | |
655241 | 655241 | 2020-10-22 | Unknown | Iowa | 14 | 0 | |
651996 | 651996 | 2020-10-21 | Unknown | Iowa | 13 | 0 | |
648752 | 648752 | 2020-10-20 | Unknown | Iowa | 5 | 0 | |
645507 | 645507 | 2020-10-19 | Unknown | Iowa | 21 | 0 | |
642260 | 642260 | 2020-10-18 | Unknown | Iowa | 25 | 0 | |
639013 | 639013 | 2020-10-17 | Unknown | Iowa | 25 | 0 | |
635767 | 635767 | 2020-10-16 | Unknown | Iowa | 15 | 0 | |
632521 | 632521 | 2020-10-15 | Unknown | Iowa | 7 | 0 | |
629277 | 629277 | 2020-10-14 | Unknown | Iowa | 11 | 0 | |
626034 | 626034 | 2020-10-13 | Unknown | Iowa | 11 | 0 | |
622792 | 622792 | 2020-10-12 | Unknown | Iowa | 10 | 0 | |
619548 | 619548 | 2020-10-11 | Unknown | Iowa | 24 | 0 | |
616306 | 616306 | 2020-10-10 | Unknown | Iowa | 14 | 0 | |
613065 | 613065 | 2020-10-09 | Unknown | Iowa | 8 | 0 | |
609823 | 609823 | 2020-10-08 | Unknown | Iowa | 9 | 0 | |
606580 | 606580 | 2020-10-07 | Unknown | Iowa | 7 | 0 | |
603338 | 603338 | 2020-10-06 | Unknown | Iowa | 2 | 0 | |
600095 | 600095 | 2020-10-05 | Unknown | Iowa | 3 | 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);