ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 19179 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054391 | 1054391 | 2021-02-22 | Wapello | Iowa | 19179 | 3877 | 106 |
1051144 | 1051144 | 2021-02-21 | Wapello | Iowa | 19179 | 3877 | 105 |
1047897 | 1047897 | 2021-02-20 | Wapello | Iowa | 19179 | 3877 | 105 |
1044652 | 1044652 | 2021-02-19 | Wapello | Iowa | 19179 | 3877 | 105 |
1041407 | 1041407 | 2021-02-18 | Wapello | Iowa | 19179 | 3863 | 105 |
1038162 | 1038162 | 2021-02-17 | Wapello | Iowa | 19179 | 3849 | 105 |
1034917 | 1034917 | 2021-02-16 | Wapello | Iowa | 19179 | 3825 | 105 |
1031671 | 1031671 | 2021-02-15 | Wapello | Iowa | 19179 | 3818 | 105 |
1028424 | 1028424 | 2021-02-14 | Wapello | Iowa | 19179 | 3806 | 105 |
1025179 | 1025179 | 2021-02-13 | Wapello | Iowa | 19179 | 3796 | 105 |
1021934 | 1021934 | 2021-02-12 | Wapello | Iowa | 19179 | 3789 | 105 |
1018689 | 1018689 | 2021-02-11 | Wapello | Iowa | 19179 | 3775 | 103 |
1015444 | 1015444 | 2021-02-10 | Wapello | Iowa | 19179 | 3765 | 103 |
1012199 | 1012199 | 2021-02-09 | Wapello | Iowa | 19179 | 3714 | 103 |
1008953 | 1008953 | 2021-02-08 | Wapello | Iowa | 19179 | 3667 | 103 |
1005707 | 1005707 | 2021-02-07 | Wapello | Iowa | 19179 | 3659 | 103 |
1002461 | 1002461 | 2021-02-06 | Wapello | Iowa | 19179 | 3650 | 103 |
999215 | 999215 | 2021-02-05 | Wapello | Iowa | 19179 | 3643 | 102 |
995969 | 995969 | 2021-02-04 | Wapello | Iowa | 19179 | 3639 | 101 |
992723 | 992723 | 2021-02-03 | Wapello | Iowa | 19179 | 3624 | 100 |
989477 | 989477 | 2021-02-02 | Wapello | Iowa | 19179 | 3615 | 100 |
986230 | 986230 | 2021-02-01 | Wapello | Iowa | 19179 | 3601 | 100 |
982983 | 982983 | 2021-01-31 | Wapello | Iowa | 19179 | 3590 | 100 |
979737 | 979737 | 2021-01-30 | Wapello | Iowa | 19179 | 3587 | 98 |
976491 | 976491 | 2021-01-29 | Wapello | Iowa | 19179 | 3575 | 98 |
973246 | 973246 | 2021-01-28 | Wapello | Iowa | 19179 | 3565 | 98 |
970001 | 970001 | 2021-01-27 | Wapello | Iowa | 19179 | 3551 | 98 |
966757 | 966757 | 2021-01-26 | Wapello | Iowa | 19179 | 3530 | 98 |
963512 | 963512 | 2021-01-25 | Wapello | Iowa | 19179 | 3516 | 98 |
960267 | 960267 | 2021-01-24 | Wapello | Iowa | 19179 | 3507 | 98 |
957021 | 957021 | 2021-01-23 | Wapello | Iowa | 19179 | 3498 | 98 |
953776 | 953776 | 2021-01-22 | Wapello | Iowa | 19179 | 3484 | 98 |
950531 | 950531 | 2021-01-21 | Wapello | Iowa | 19179 | 3475 | 98 |
947285 | 947285 | 2021-01-20 | Wapello | Iowa | 19179 | 3465 | 98 |
944038 | 944038 | 2021-01-19 | Wapello | Iowa | 19179 | 3441 | 98 |
940793 | 940793 | 2021-01-18 | Wapello | Iowa | 19179 | 3423 | 98 |
937548 | 937548 | 2021-01-17 | Wapello | Iowa | 19179 | 3416 | 98 |
934303 | 934303 | 2021-01-16 | Wapello | Iowa | 19179 | 3407 | 98 |
931058 | 931058 | 2021-01-15 | Wapello | Iowa | 19179 | 3400 | 97 |
927813 | 927813 | 2021-01-14 | Wapello | Iowa | 19179 | 3367 | 96 |
924567 | 924567 | 2021-01-13 | Wapello | Iowa | 19179 | 3350 | 96 |
921322 | 921322 | 2021-01-12 | Wapello | Iowa | 19179 | 3318 | 95 |
918077 | 918077 | 2021-01-11 | Wapello | Iowa | 19179 | 3307 | 93 |
914832 | 914832 | 2021-01-10 | Wapello | Iowa | 19179 | 3295 | 93 |
911587 | 911587 | 2021-01-09 | Wapello | Iowa | 19179 | 3286 | 93 |
908342 | 908342 | 2021-01-08 | Wapello | Iowa | 19179 | 3266 | 93 |
905096 | 905096 | 2021-01-07 | Wapello | Iowa | 19179 | 3256 | 93 |
901851 | 901851 | 2021-01-06 | Wapello | Iowa | 19179 | 3221 | 93 |
898606 | 898606 | 2021-01-05 | Wapello | Iowa | 19179 | 3184 | 93 |
895361 | 895361 | 2021-01-04 | Wapello | Iowa | 19179 | 3160 | 93 |
892114 | 892114 | 2021-01-03 | Wapello | Iowa | 19179 | 3154 | 92 |
888868 | 888868 | 2021-01-02 | Wapello | Iowa | 19179 | 3148 | 92 |
885622 | 885622 | 2021-01-01 | Wapello | Iowa | 19179 | 3144 | 91 |
882377 | 882377 | 2020-12-31 | Wapello | Iowa | 19179 | 3133 | 90 |
879132 | 879132 | 2020-12-30 | Wapello | Iowa | 19179 | 3121 | 90 |
875887 | 875887 | 2020-12-29 | Wapello | Iowa | 19179 | 3092 | 90 |
872642 | 872642 | 2020-12-28 | Wapello | Iowa | 19179 | 3078 | 90 |
869397 | 869397 | 2020-12-27 | Wapello | Iowa | 19179 | 3061 | 90 |
866152 | 866152 | 2020-12-26 | Wapello | Iowa | 19179 | 3042 | 90 |
862907 | 862907 | 2020-12-25 | Wapello | Iowa | 19179 | 3042 | 90 |
859662 | 859662 | 2020-12-24 | Wapello | Iowa | 19179 | 3034 | 90 |
856417 | 856417 | 2020-12-23 | Wapello | Iowa | 19179 | 3014 | 90 |
853172 | 853172 | 2020-12-22 | Wapello | Iowa | 19179 | 2995 | 90 |
849927 | 849927 | 2020-12-21 | Wapello | Iowa | 19179 | 2982 | 90 |
846682 | 846682 | 2020-12-20 | Wapello | Iowa | 19179 | 2977 | 90 |
843436 | 843436 | 2020-12-19 | Wapello | Iowa | 19179 | 2967 | 89 |
840191 | 840191 | 2020-12-18 | Wapello | Iowa | 19179 | 2941 | 89 |
836946 | 836946 | 2020-12-17 | Wapello | Iowa | 19179 | 2905 | 89 |
833700 | 833700 | 2020-12-16 | Wapello | Iowa | 19179 | 2896 | 88 |
830453 | 830453 | 2020-12-15 | Wapello | Iowa | 19179 | 2873 | 88 |
827207 | 827207 | 2020-12-14 | Wapello | Iowa | 19179 | 2863 | 87 |
823960 | 823960 | 2020-12-13 | Wapello | Iowa | 19179 | 2854 | 87 |
820714 | 820714 | 2020-12-12 | Wapello | Iowa | 19179 | 2835 | 87 |
817468 | 817468 | 2020-12-11 | Wapello | Iowa | 19179 | 2822 | 87 |
814222 | 814222 | 2020-12-10 | Wapello | Iowa | 19179 | 2794 | 86 |
810977 | 810977 | 2020-12-09 | Wapello | Iowa | 19179 | 2784 | 85 |
807732 | 807732 | 2020-12-08 | Wapello | Iowa | 19179 | 2754 | 83 |
804487 | 804487 | 2020-12-07 | Wapello | Iowa | 19179 | 2750 | 72 |
801242 | 801242 | 2020-12-06 | Wapello | Iowa | 19179 | 2739 | 72 |
797997 | 797997 | 2020-12-05 | Wapello | Iowa | 19179 | 2713 | 72 |
794752 | 794752 | 2020-12-04 | Wapello | Iowa | 19179 | 2697 | 72 |
791507 | 791507 | 2020-12-03 | Wapello | Iowa | 19179 | 2649 | 72 |
788262 | 788262 | 2020-12-02 | Wapello | Iowa | 19179 | 2637 | 72 |
785018 | 785018 | 2020-12-01 | Wapello | Iowa | 19179 | 2585 | 72 |
781773 | 781773 | 2020-11-30 | Wapello | Iowa | 19179 | 2572 | 72 |
778527 | 778527 | 2020-11-29 | Wapello | Iowa | 19179 | 2558 | 72 |
775282 | 775282 | 2020-11-28 | Wapello | Iowa | 19179 | 2550 | 71 |
772037 | 772037 | 2020-11-27 | Wapello | Iowa | 19179 | 2514 | 71 |
768792 | 768792 | 2020-11-26 | Wapello | Iowa | 19179 | 2511 | 71 |
765546 | 765546 | 2020-11-25 | Wapello | Iowa | 19179 | 2486 | 71 |
762301 | 762301 | 2020-11-24 | Wapello | Iowa | 19179 | 2440 | 71 |
759056 | 759056 | 2020-11-23 | Wapello | Iowa | 19179 | 2428 | 71 |
755809 | 755809 | 2020-11-22 | Wapello | Iowa | 19179 | 2399 | 71 |
752563 | 752563 | 2020-11-21 | Wapello | Iowa | 19179 | 2371 | 71 |
749317 | 749317 | 2020-11-20 | Wapello | Iowa | 19179 | 2328 | 71 |
746071 | 746071 | 2020-11-19 | Wapello | Iowa | 19179 | 2275 | 70 |
742824 | 742824 | 2020-11-18 | Wapello | Iowa | 19179 | 2241 | 70 |
739577 | 739577 | 2020-11-17 | Wapello | Iowa | 19179 | 2212 | 70 |
736333 | 736333 | 2020-11-16 | Wapello | Iowa | 19179 | 2162 | 69 |
733087 | 733087 | 2020-11-15 | Wapello | Iowa | 19179 | 2147 | 69 |
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);