ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Warren" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
729843 | 729843 | 2020-11-14 | Warren | Iowa | 19181 | 2120 | 9 |
726600 | 726600 | 2020-11-13 | Warren | Iowa | 19181 | 2056 | 9 |
723357 | 723357 | 2020-11-12 | Warren | Iowa | 19181 | 1967 | 9 |
720114 | 720114 | 2020-11-11 | Warren | Iowa | 19181 | 1889 | 9 |
716871 | 716871 | 2020-11-10 | Warren | Iowa | 19181 | 1833 | 9 |
713627 | 713627 | 2020-11-09 | Warren | Iowa | 19181 | 1783 | 9 |
710383 | 710383 | 2020-11-08 | Warren | Iowa | 19181 | 1726 | 9 |
707139 | 707139 | 2020-11-07 | Warren | Iowa | 19181 | 1640 | 9 |
703896 | 703896 | 2020-11-06 | Warren | Iowa | 19181 | 1577 | 9 |
700654 | 700654 | 2020-11-05 | Warren | Iowa | 19181 | 1557 | 9 |
697410 | 697410 | 2020-11-04 | Warren | Iowa | 19181 | 1497 | 8 |
694168 | 694168 | 2020-11-03 | Warren | Iowa | 19181 | 1464 | 8 |
690925 | 690925 | 2020-11-02 | Warren | Iowa | 19181 | 1451 | 7 |
687680 | 687680 | 2020-11-01 | Warren | Iowa | 19181 | 1440 | 7 |
684436 | 684436 | 2020-10-31 | Warren | Iowa | 19181 | 1394 | 7 |
681193 | 681193 | 2020-10-30 | Warren | Iowa | 19181 | 1351 | 7 |
677950 | 677950 | 2020-10-29 | Warren | Iowa | 19181 | 1319 | 7 |
674707 | 674707 | 2020-10-28 | Warren | Iowa | 19181 | 1296 | 7 |
671465 | 671465 | 2020-10-27 | Warren | Iowa | 19181 | 1277 | 7 |
668222 | 668222 | 2020-10-26 | Warren | Iowa | 19181 | 1261 | 7 |
664978 | 664978 | 2020-10-25 | Warren | Iowa | 19181 | 1247 | 7 |
661733 | 661733 | 2020-10-24 | Warren | Iowa | 19181 | 1216 | 7 |
658489 | 658489 | 2020-10-23 | Warren | Iowa | 19181 | 1204 | 7 |
655244 | 655244 | 2020-10-22 | Warren | Iowa | 19181 | 1194 | 7 |
651999 | 651999 | 2020-10-21 | Warren | Iowa | 19181 | 1172 | 6 |
648755 | 648755 | 2020-10-20 | Warren | Iowa | 19181 | 1159 | 6 |
645510 | 645510 | 2020-10-19 | Warren | Iowa | 19181 | 1149 | 6 |
642263 | 642263 | 2020-10-18 | Warren | Iowa | 19181 | 1143 | 6 |
639016 | 639016 | 2020-10-17 | Warren | Iowa | 19181 | 1136 | 6 |
635770 | 635770 | 2020-10-16 | Warren | Iowa | 19181 | 1126 | 6 |
632524 | 632524 | 2020-10-15 | Warren | Iowa | 19181 | 1108 | 6 |
629280 | 629280 | 2020-10-14 | Warren | Iowa | 19181 | 1095 | 6 |
626037 | 626037 | 2020-10-13 | Warren | Iowa | 19181 | 1079 | 6 |
622795 | 622795 | 2020-10-12 | Warren | Iowa | 19181 | 1065 | 6 |
619551 | 619551 | 2020-10-11 | Warren | Iowa | 19181 | 1061 | 6 |
616309 | 616309 | 2020-10-10 | Warren | Iowa | 19181 | 1045 | 6 |
613068 | 613068 | 2020-10-09 | Warren | Iowa | 19181 | 1033 | 6 |
609826 | 609826 | 2020-10-08 | Warren | Iowa | 19181 | 1023 | 6 |
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);