ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Union" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918074 | 918074 | 2021-01-11 | Union | Iowa | 19175 | 1064 | 20 |
914829 | 914829 | 2021-01-10 | Union | Iowa | 19175 | 1062 | 20 |
911584 | 911584 | 2021-01-09 | Union | Iowa | 19175 | 1060 | 19 |
908339 | 908339 | 2021-01-08 | Union | Iowa | 19175 | 1055 | 19 |
905093 | 905093 | 2021-01-07 | Union | Iowa | 19175 | 1053 | 19 |
901848 | 901848 | 2021-01-06 | Union | Iowa | 19175 | 1048 | 19 |
898603 | 898603 | 2021-01-05 | Union | Iowa | 19175 | 1039 | 19 |
895358 | 895358 | 2021-01-04 | Union | Iowa | 19175 | 1037 | 19 |
892111 | 892111 | 2021-01-03 | Union | Iowa | 19175 | 1035 | 19 |
888865 | 888865 | 2021-01-02 | Union | Iowa | 19175 | 1035 | 19 |
885619 | 885619 | 2021-01-01 | Union | Iowa | 19175 | 1034 | 19 |
882374 | 882374 | 2020-12-31 | Union | Iowa | 19175 | 1027 | 19 |
879129 | 879129 | 2020-12-30 | Union | Iowa | 19175 | 1023 | 18 |
875884 | 875884 | 2020-12-29 | Union | Iowa | 19175 | 1012 | 18 |
872639 | 872639 | 2020-12-28 | Union | Iowa | 19175 | 1006 | 16 |
869394 | 869394 | 2020-12-27 | Union | Iowa | 19175 | 1004 | 16 |
866149 | 866149 | 2020-12-26 | Union | Iowa | 19175 | 1003 | 16 |
862904 | 862904 | 2020-12-25 | Union | Iowa | 19175 | 1001 | 16 |
859659 | 859659 | 2020-12-24 | Union | Iowa | 19175 | 999 | 16 |
856414 | 856414 | 2020-12-23 | Union | Iowa | 19175 | 994 | 16 |
853169 | 853169 | 2020-12-22 | Union | Iowa | 19175 | 977 | 16 |
849924 | 849924 | 2020-12-21 | Union | Iowa | 19175 | 973 | 16 |
846679 | 846679 | 2020-12-20 | Union | Iowa | 19175 | 971 | 16 |
843433 | 843433 | 2020-12-19 | Union | Iowa | 19175 | 969 | 16 |
840188 | 840188 | 2020-12-18 | Union | Iowa | 19175 | 963 | 13 |
836943 | 836943 | 2020-12-17 | Union | Iowa | 19175 | 966 | 13 |
833697 | 833697 | 2020-12-16 | Union | Iowa | 19175 | 958 | 12 |
830450 | 830450 | 2020-12-15 | Union | Iowa | 19175 | 948 | 12 |
827204 | 827204 | 2020-12-14 | Union | Iowa | 19175 | 944 | 11 |
823957 | 823957 | 2020-12-13 | Union | Iowa | 19175 | 944 | 10 |
820711 | 820711 | 2020-12-12 | Union | Iowa | 19175 | 938 | 10 |
817465 | 817465 | 2020-12-11 | Union | Iowa | 19175 | 928 | 9 |
814219 | 814219 | 2020-12-10 | Union | Iowa | 19175 | 924 | 9 |
810974 | 810974 | 2020-12-09 | Union | Iowa | 19175 | 917 | 9 |
807729 | 807729 | 2020-12-08 | Union | Iowa | 19175 | 899 | 9 |
804484 | 804484 | 2020-12-07 | Union | Iowa | 19175 | 897 | 8 |
801239 | 801239 | 2020-12-06 | Union | Iowa | 19175 | 892 | 8 |
797994 | 797994 | 2020-12-05 | Union | Iowa | 19175 | 885 | 8 |
794749 | 794749 | 2020-12-04 | Union | Iowa | 19175 | 866 | 8 |
791504 | 791504 | 2020-12-03 | Union | Iowa | 19175 | 843 | 7 |
788259 | 788259 | 2020-12-02 | Union | Iowa | 19175 | 816 | 6 |
785015 | 785015 | 2020-12-01 | Union | Iowa | 19175 | 788 | 6 |
781770 | 781770 | 2020-11-30 | Union | Iowa | 19175 | 779 | 6 |
778524 | 778524 | 2020-11-29 | Union | Iowa | 19175 | 770 | 6 |
775279 | 775279 | 2020-11-28 | Union | Iowa | 19175 | 767 | 6 |
772034 | 772034 | 2020-11-27 | Union | Iowa | 19175 | 757 | 6 |
768789 | 768789 | 2020-11-26 | Union | Iowa | 19175 | 754 | 6 |
765543 | 765543 | 2020-11-25 | Union | Iowa | 19175 | 739 | 6 |
762298 | 762298 | 2020-11-24 | Union | Iowa | 19175 | 716 | 6 |
759053 | 759053 | 2020-11-23 | Union | Iowa | 19175 | 709 | 6 |
755806 | 755806 | 2020-11-22 | Union | Iowa | 19175 | 686 | 6 |
752560 | 752560 | 2020-11-21 | Union | Iowa | 19175 | 676 | 6 |
749314 | 749314 | 2020-11-20 | Union | Iowa | 19175 | 656 | 6 |
746068 | 746068 | 2020-11-19 | Union | Iowa | 19175 | 639 | 6 |
742821 | 742821 | 2020-11-18 | Union | Iowa | 19175 | 611 | 6 |
739574 | 739574 | 2020-11-17 | Union | Iowa | 19175 | 578 | 6 |
736330 | 736330 | 2020-11-16 | Union | Iowa | 19175 | 563 | 6 |
733084 | 733084 | 2020-11-15 | Union | Iowa | 19175 | 555 | 6 |
729839 | 729839 | 2020-11-14 | Union | Iowa | 19175 | 546 | 6 |
726596 | 726596 | 2020-11-13 | Union | Iowa | 19175 | 500 | 6 |
723353 | 723353 | 2020-11-12 | Union | Iowa | 19175 | 459 | 6 |
720110 | 720110 | 2020-11-11 | Union | Iowa | 19175 | 444 | 6 |
716867 | 716867 | 2020-11-10 | Union | Iowa | 19175 | 399 | 6 |
713623 | 713623 | 2020-11-09 | Union | Iowa | 19175 | 391 | 6 |
710379 | 710379 | 2020-11-08 | Union | Iowa | 19175 | 375 | 6 |
707135 | 707135 | 2020-11-07 | Union | Iowa | 19175 | 350 | 6 |
703892 | 703892 | 2020-11-06 | Union | Iowa | 19175 | 336 | 6 |
700650 | 700650 | 2020-11-05 | Union | Iowa | 19175 | 323 | 6 |
697406 | 697406 | 2020-11-04 | Union | Iowa | 19175 | 314 | 6 |
694164 | 694164 | 2020-11-03 | Union | Iowa | 19175 | 301 | 6 |
690921 | 690921 | 2020-11-02 | Union | Iowa | 19175 | 291 | 6 |
687676 | 687676 | 2020-11-01 | Union | Iowa | 19175 | 291 | 5 |
684432 | 684432 | 2020-10-31 | Union | Iowa | 19175 | 285 | 5 |
681189 | 681189 | 2020-10-30 | Union | Iowa | 19175 | 274 | 5 |
677946 | 677946 | 2020-10-29 | Union | Iowa | 19175 | 265 | 5 |
674703 | 674703 | 2020-10-28 | Union | Iowa | 19175 | 264 | 5 |
671461 | 671461 | 2020-10-27 | Union | Iowa | 19175 | 258 | 4 |
668218 | 668218 | 2020-10-26 | Union | Iowa | 19175 | 231 | 4 |
664974 | 664974 | 2020-10-25 | Union | Iowa | 19175 | 232 | 4 |
661729 | 661729 | 2020-10-24 | Union | Iowa | 19175 | 229 | 4 |
658485 | 658485 | 2020-10-23 | Union | Iowa | 19175 | 223 | 4 |
655240 | 655240 | 2020-10-22 | Union | Iowa | 19175 | 219 | 4 |
651995 | 651995 | 2020-10-21 | Union | Iowa | 19175 | 217 | 4 |
648751 | 648751 | 2020-10-20 | Union | Iowa | 19175 | 216 | 4 |
645506 | 645506 | 2020-10-19 | Union | Iowa | 19175 | 209 | 4 |
642259 | 642259 | 2020-10-18 | Union | Iowa | 19175 | 208 | 3 |
639012 | 639012 | 2020-10-17 | Union | Iowa | 19175 | 208 | 3 |
635766 | 635766 | 2020-10-16 | Union | Iowa | 19175 | 204 | 3 |
632520 | 632520 | 2020-10-15 | Union | Iowa | 19175 | 202 | 3 |
629276 | 629276 | 2020-10-14 | Union | Iowa | 19175 | 198 | 3 |
626033 | 626033 | 2020-10-13 | Union | Iowa | 19175 | 191 | 3 |
622791 | 622791 | 2020-10-12 | Union | Iowa | 19175 | 190 | 3 |
619547 | 619547 | 2020-10-11 | Union | Iowa | 19175 | 189 | 3 |
616305 | 616305 | 2020-10-10 | Union | Iowa | 19175 | 177 | 3 |
613064 | 613064 | 2020-10-09 | Union | Iowa | 19175 | 177 | 3 |
609822 | 609822 | 2020-10-08 | Union | Iowa | 19175 | 174 | 3 |
606579 | 606579 | 2020-10-07 | Union | Iowa | 19175 | 160 | 3 |
603337 | 603337 | 2020-10-06 | Union | Iowa | 19175 | 158 | 3 |
600094 | 600094 | 2020-10-05 | Union | Iowa | 19175 | 155 | 3 |
596852 | 596852 | 2020-10-04 | Union | Iowa | 19175 | 152 | 3 |
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);