ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Warren" and fips = 19181 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054392 | 1054392 | 2021-02-22 | Warren | Iowa | 19181 | 5002 | 70 |
1051145 | 1051145 | 2021-02-21 | Warren | Iowa | 19181 | 5002 | 69 |
1047898 | 1047898 | 2021-02-20 | Warren | Iowa | 19181 | 5002 | 69 |
1044653 | 1044653 | 2021-02-19 | Warren | Iowa | 19181 | 5002 | 69 |
1041408 | 1041408 | 2021-02-18 | Warren | Iowa | 19181 | 5001 | 69 |
1038163 | 1038163 | 2021-02-17 | Warren | Iowa | 19181 | 4981 | 69 |
1034918 | 1034918 | 2021-02-16 | Warren | Iowa | 19181 | 4965 | 69 |
1031672 | 1031672 | 2021-02-15 | Warren | Iowa | 19181 | 4958 | 67 |
1028425 | 1028425 | 2021-02-14 | Warren | Iowa | 19181 | 4947 | 67 |
1025180 | 1025180 | 2021-02-13 | Warren | Iowa | 19181 | 4943 | 67 |
1021935 | 1021935 | 2021-02-12 | Warren | Iowa | 19181 | 4935 | 67 |
1018690 | 1018690 | 2021-02-11 | Warren | Iowa | 19181 | 4909 | 67 |
1015445 | 1015445 | 2021-02-10 | Warren | Iowa | 19181 | 4903 | 67 |
1012200 | 1012200 | 2021-02-09 | Warren | Iowa | 19181 | 4888 | 66 |
1008954 | 1008954 | 2021-02-08 | Warren | Iowa | 19181 | 4870 | 66 |
1005708 | 1005708 | 2021-02-07 | Warren | Iowa | 19181 | 4856 | 66 |
1002462 | 1002462 | 2021-02-06 | Warren | Iowa | 19181 | 4854 | 66 |
999216 | 999216 | 2021-02-05 | Warren | Iowa | 19181 | 4847 | 64 |
995970 | 995970 | 2021-02-04 | Warren | Iowa | 19181 | 4839 | 62 |
992724 | 992724 | 2021-02-03 | Warren | Iowa | 19181 | 4819 | 60 |
989478 | 989478 | 2021-02-02 | Warren | Iowa | 19181 | 4791 | 59 |
986231 | 986231 | 2021-02-01 | Warren | Iowa | 19181 | 4773 | 59 |
982984 | 982984 | 2021-01-31 | Warren | Iowa | 19181 | 4754 | 59 |
979738 | 979738 | 2021-01-30 | Warren | Iowa | 19181 | 4745 | 49 |
976492 | 976492 | 2021-01-29 | Warren | Iowa | 19181 | 4708 | 45 |
973247 | 973247 | 2021-01-28 | Warren | Iowa | 19181 | 4692 | 41 |
970002 | 970002 | 2021-01-27 | Warren | Iowa | 19181 | 4670 | 39 |
966758 | 966758 | 2021-01-26 | Warren | Iowa | 19181 | 4639 | 39 |
963513 | 963513 | 2021-01-25 | Warren | Iowa | 19181 | 4613 | 39 |
960268 | 960268 | 2021-01-24 | Warren | Iowa | 19181 | 4593 | 39 |
957022 | 957022 | 2021-01-23 | Warren | Iowa | 19181 | 4580 | 39 |
953777 | 953777 | 2021-01-22 | Warren | Iowa | 19181 | 4561 | 39 |
950532 | 950532 | 2021-01-21 | Warren | Iowa | 19181 | 4519 | 39 |
947286 | 947286 | 2021-01-20 | Warren | Iowa | 19181 | 4490 | 38 |
944039 | 944039 | 2021-01-19 | Warren | Iowa | 19181 | 4439 | 38 |
940794 | 940794 | 2021-01-18 | Warren | Iowa | 19181 | 4406 | 38 |
937549 | 937549 | 2021-01-17 | Warren | Iowa | 19181 | 4388 | 38 |
934304 | 934304 | 2021-01-16 | Warren | Iowa | 19181 | 4375 | 38 |
931059 | 931059 | 2021-01-15 | Warren | Iowa | 19181 | 4362 | 37 |
927814 | 927814 | 2021-01-14 | Warren | Iowa | 19181 | 4306 | 37 |
924568 | 924568 | 2021-01-13 | Warren | Iowa | 19181 | 4274 | 37 |
921323 | 921323 | 2021-01-12 | Warren | Iowa | 19181 | 4221 | 37 |
918078 | 918078 | 2021-01-11 | Warren | Iowa | 19181 | 4158 | 37 |
914833 | 914833 | 2021-01-10 | Warren | Iowa | 19181 | 4128 | 37 |
911588 | 911588 | 2021-01-09 | Warren | Iowa | 19181 | 4123 | 37 |
908343 | 908343 | 2021-01-08 | Warren | Iowa | 19181 | 4081 | 37 |
905097 | 905097 | 2021-01-07 | Warren | Iowa | 19181 | 4057 | 37 |
901852 | 901852 | 2021-01-06 | Warren | Iowa | 19181 | 4009 | 37 |
898607 | 898607 | 2021-01-05 | Warren | Iowa | 19181 | 3956 | 34 |
895362 | 895362 | 2021-01-04 | Warren | Iowa | 19181 | 3913 | 34 |
892115 | 892115 | 2021-01-03 | Warren | Iowa | 19181 | 3872 | 34 |
888869 | 888869 | 2021-01-02 | Warren | Iowa | 19181 | 3846 | 34 |
885623 | 885623 | 2021-01-01 | Warren | Iowa | 19181 | 3836 | 34 |
882378 | 882378 | 2020-12-31 | Warren | Iowa | 19181 | 3810 | 34 |
879133 | 879133 | 2020-12-30 | Warren | Iowa | 19181 | 3760 | 33 |
875888 | 875888 | 2020-12-29 | Warren | Iowa | 19181 | 3725 | 33 |
872643 | 872643 | 2020-12-28 | Warren | Iowa | 19181 | 3685 | 33 |
869398 | 869398 | 2020-12-27 | Warren | Iowa | 19181 | 3659 | 33 |
866153 | 866153 | 2020-12-26 | Warren | Iowa | 19181 | 3653 | 33 |
862908 | 862908 | 2020-12-25 | Warren | Iowa | 19181 | 3646 | 33 |
859663 | 859663 | 2020-12-24 | Warren | Iowa | 19181 | 3629 | 33 |
856418 | 856418 | 2020-12-23 | Warren | Iowa | 19181 | 3589 | 30 |
853173 | 853173 | 2020-12-22 | Warren | Iowa | 19181 | 3559 | 29 |
849928 | 849928 | 2020-12-21 | Warren | Iowa | 19181 | 3526 | 28 |
846683 | 846683 | 2020-12-20 | Warren | Iowa | 19181 | 3501 | 28 |
843437 | 843437 | 2020-12-19 | Warren | Iowa | 19181 | 3500 | 28 |
840192 | 840192 | 2020-12-18 | Warren | Iowa | 19181 | 3442 | 26 |
836947 | 836947 | 2020-12-17 | Warren | Iowa | 19181 | 3403 | 26 |
833701 | 833701 | 2020-12-16 | Warren | Iowa | 19181 | 3373 | 25 |
830454 | 830454 | 2020-12-15 | Warren | Iowa | 19181 | 3317 | 25 |
827208 | 827208 | 2020-12-14 | Warren | Iowa | 19181 | 3286 | 25 |
823961 | 823961 | 2020-12-13 | Warren | Iowa | 19181 | 3275 | 24 |
820715 | 820715 | 2020-12-12 | Warren | Iowa | 19181 | 3248 | 24 |
817469 | 817469 | 2020-12-11 | Warren | Iowa | 19181 | 3231 | 24 |
814223 | 814223 | 2020-12-10 | Warren | Iowa | 19181 | 3182 | 23 |
810978 | 810978 | 2020-12-09 | Warren | Iowa | 19181 | 3139 | 21 |
807733 | 807733 | 2020-12-08 | Warren | Iowa | 19181 | 3103 | 20 |
804488 | 804488 | 2020-12-07 | Warren | Iowa | 19181 | 3092 | 17 |
801243 | 801243 | 2020-12-06 | Warren | Iowa | 19181 | 3081 | 17 |
797998 | 797998 | 2020-12-05 | Warren | Iowa | 19181 | 3056 | 17 |
794753 | 794753 | 2020-12-04 | Warren | Iowa | 19181 | 3006 | 17 |
791508 | 791508 | 2020-12-03 | Warren | Iowa | 19181 | 2941 | 15 |
788263 | 788263 | 2020-12-02 | Warren | Iowa | 19181 | 2917 | 14 |
785019 | 785019 | 2020-12-01 | Warren | Iowa | 19181 | 2873 | 14 |
781774 | 781774 | 2020-11-30 | Warren | Iowa | 19181 | 2832 | 14 |
778528 | 778528 | 2020-11-29 | Warren | Iowa | 19181 | 2818 | 14 |
775283 | 775283 | 2020-11-28 | Warren | Iowa | 19181 | 2796 | 11 |
772038 | 772038 | 2020-11-27 | Warren | Iowa | 19181 | 2765 | 11 |
768793 | 768793 | 2020-11-26 | Warren | Iowa | 19181 | 2740 | 11 |
765547 | 765547 | 2020-11-25 | Warren | Iowa | 19181 | 2705 | 10 |
762302 | 762302 | 2020-11-24 | Warren | Iowa | 19181 | 2648 | 10 |
759057 | 759057 | 2020-11-23 | Warren | Iowa | 19181 | 2585 | 10 |
755810 | 755810 | 2020-11-22 | Warren | Iowa | 19181 | 2546 | 10 |
752564 | 752564 | 2020-11-21 | Warren | Iowa | 19181 | 2492 | 10 |
749318 | 749318 | 2020-11-20 | Warren | Iowa | 19181 | 2453 | 9 |
746072 | 746072 | 2020-11-19 | Warren | Iowa | 19181 | 2377 | 9 |
742825 | 742825 | 2020-11-18 | Warren | Iowa | 19181 | 2328 | 9 |
739578 | 739578 | 2020-11-17 | Warren | Iowa | 19181 | 2278 | 9 |
736334 | 736334 | 2020-11-16 | Warren | Iowa | 19181 | 2217 | 9 |
733088 | 733088 | 2020-11-15 | Warren | Iowa | 19181 | 2161 | 9 |
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);