ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 19033 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
869323 | 869323 | 2020-12-27 | Cerro Gordo | Iowa | 19033 | 4258 | 59 |
866078 | 866078 | 2020-12-26 | Cerro Gordo | Iowa | 19033 | 4243 | 59 |
862833 | 862833 | 2020-12-25 | Cerro Gordo | Iowa | 19033 | 4238 | 59 |
859588 | 859588 | 2020-12-24 | Cerro Gordo | Iowa | 19033 | 4227 | 59 |
856343 | 856343 | 2020-12-23 | Cerro Gordo | Iowa | 19033 | 4216 | 59 |
853098 | 853098 | 2020-12-22 | Cerro Gordo | Iowa | 19033 | 4191 | 59 |
849853 | 849853 | 2020-12-21 | Cerro Gordo | Iowa | 19033 | 4175 | 56 |
846608 | 846608 | 2020-12-20 | Cerro Gordo | Iowa | 19033 | 4164 | 56 |
843362 | 843362 | 2020-12-19 | Cerro Gordo | Iowa | 19033 | 4146 | 55 |
840117 | 840117 | 2020-12-18 | Cerro Gordo | Iowa | 19033 | 4127 | 55 |
836872 | 836872 | 2020-12-17 | Cerro Gordo | Iowa | 19033 | 4085 | 55 |
833626 | 833626 | 2020-12-16 | Cerro Gordo | Iowa | 19033 | 4063 | 52 |
830379 | 830379 | 2020-12-15 | Cerro Gordo | Iowa | 19033 | 4030 | 51 |
827133 | 827133 | 2020-12-14 | Cerro Gordo | Iowa | 19033 | 4009 | 49 |
823886 | 823886 | 2020-12-13 | Cerro Gordo | Iowa | 19033 | 4004 | 49 |
820640 | 820640 | 2020-12-12 | Cerro Gordo | Iowa | 19033 | 3978 | 49 |
817394 | 817394 | 2020-12-11 | Cerro Gordo | Iowa | 19033 | 3970 | 49 |
814148 | 814148 | 2020-12-10 | Cerro Gordo | Iowa | 19033 | 3937 | 48 |
810903 | 810903 | 2020-12-09 | Cerro Gordo | Iowa | 19033 | 3901 | 47 |
807658 | 807658 | 2020-12-08 | Cerro Gordo | Iowa | 19033 | 3859 | 43 |
804413 | 804413 | 2020-12-07 | Cerro Gordo | Iowa | 19033 | 3854 | 52 |
801168 | 801168 | 2020-12-06 | Cerro Gordo | Iowa | 19033 | 3835 | 52 |
797923 | 797923 | 2020-12-05 | Cerro Gordo | Iowa | 19033 | 3784 | 52 |
794678 | 794678 | 2020-12-04 | Cerro Gordo | Iowa | 19033 | 3755 | 52 |
791433 | 791433 | 2020-12-03 | Cerro Gordo | Iowa | 19033 | 3732 | 52 |
788188 | 788188 | 2020-12-02 | Cerro Gordo | Iowa | 19033 | 3676 | 49 |
784944 | 784944 | 2020-12-01 | Cerro Gordo | Iowa | 19033 | 3625 | 48 |
781699 | 781699 | 2020-11-30 | Cerro Gordo | Iowa | 19033 | 3590 | 46 |
778453 | 778453 | 2020-11-29 | Cerro Gordo | Iowa | 19033 | 3571 | 44 |
775208 | 775208 | 2020-11-28 | Cerro Gordo | Iowa | 19033 | 3515 | 44 |
771963 | 771963 | 2020-11-27 | Cerro Gordo | Iowa | 19033 | 3496 | 44 |
768718 | 768718 | 2020-11-26 | Cerro Gordo | Iowa | 19033 | 3426 | 44 |
765472 | 765472 | 2020-11-25 | Cerro Gordo | Iowa | 19033 | 3406 | 44 |
762227 | 762227 | 2020-11-24 | Cerro Gordo | Iowa | 19033 | 3323 | 42 |
758982 | 758982 | 2020-11-23 | Cerro Gordo | Iowa | 19033 | 3265 | 41 |
755735 | 755735 | 2020-11-22 | Cerro Gordo | Iowa | 19033 | 3230 | 41 |
752489 | 752489 | 2020-11-21 | Cerro Gordo | Iowa | 19033 | 3195 | 41 |
749243 | 749243 | 2020-11-20 | Cerro Gordo | Iowa | 19033 | 3110 | 38 |
745997 | 745997 | 2020-11-19 | Cerro Gordo | Iowa | 19033 | 3017 | 38 |
742750 | 742750 | 2020-11-18 | Cerro Gordo | Iowa | 19033 | 2924 | 37 |
739503 | 739503 | 2020-11-17 | Cerro Gordo | Iowa | 19033 | 2827 | 35 |
736259 | 736259 | 2020-11-16 | Cerro Gordo | Iowa | 19033 | 2725 | 33 |
733013 | 733013 | 2020-11-15 | Cerro Gordo | Iowa | 19033 | 2665 | 32 |
729768 | 729768 | 2020-11-14 | Cerro Gordo | Iowa | 19033 | 2592 | 32 |
726525 | 726525 | 2020-11-13 | Cerro Gordo | Iowa | 19033 | 2482 | 31 |
723282 | 723282 | 2020-11-12 | Cerro Gordo | Iowa | 19033 | 2376 | 31 |
720039 | 720039 | 2020-11-11 | Cerro Gordo | Iowa | 19033 | 2305 | 31 |
716796 | 716796 | 2020-11-10 | Cerro Gordo | Iowa | 19033 | 2192 | 31 |
713552 | 713552 | 2020-11-09 | Cerro Gordo | Iowa | 19033 | 2149 | 31 |
710308 | 710308 | 2020-11-08 | Cerro Gordo | Iowa | 19033 | 2044 | 30 |
707064 | 707064 | 2020-11-07 | Cerro Gordo | Iowa | 19033 | 1990 | 30 |
703821 | 703821 | 2020-11-06 | Cerro Gordo | Iowa | 19033 | 1901 | 29 |
700579 | 700579 | 2020-11-05 | Cerro Gordo | Iowa | 19033 | 1830 | 29 |
697335 | 697335 | 2020-11-04 | Cerro Gordo | Iowa | 19033 | 1722 | 27 |
694093 | 694093 | 2020-11-03 | Cerro Gordo | Iowa | 19033 | 1686 | 27 |
690850 | 690850 | 2020-11-02 | Cerro Gordo | Iowa | 19033 | 1657 | 27 |
687605 | 687605 | 2020-11-01 | Cerro Gordo | Iowa | 19033 | 1603 | 27 |
684361 | 684361 | 2020-10-31 | Cerro Gordo | Iowa | 19033 | 1590 | 27 |
681118 | 681118 | 2020-10-30 | Cerro Gordo | Iowa | 19033 | 1549 | 27 |
677875 | 677875 | 2020-10-29 | Cerro Gordo | Iowa | 19033 | 1505 | 27 |
674632 | 674632 | 2020-10-28 | Cerro Gordo | Iowa | 19033 | 1463 | 27 |
671390 | 671390 | 2020-10-27 | Cerro Gordo | Iowa | 19033 | 1409 | 27 |
668147 | 668147 | 2020-10-26 | Cerro Gordo | Iowa | 19033 | 1377 | 26 |
664903 | 664903 | 2020-10-25 | Cerro Gordo | Iowa | 19033 | 1362 | 25 |
661658 | 661658 | 2020-10-24 | Cerro Gordo | Iowa | 19033 | 1354 | 25 |
658414 | 658414 | 2020-10-23 | Cerro Gordo | Iowa | 19033 | 1320 | 25 |
655169 | 655169 | 2020-10-22 | Cerro Gordo | Iowa | 19033 | 1311 | 25 |
651924 | 651924 | 2020-10-21 | Cerro Gordo | Iowa | 19033 | 1280 | 23 |
648680 | 648680 | 2020-10-20 | Cerro Gordo | Iowa | 19033 | 1263 | 23 |
645435 | 645435 | 2020-10-19 | Cerro Gordo | Iowa | 19033 | 1250 | 23 |
642188 | 642188 | 2020-10-18 | Cerro Gordo | Iowa | 19033 | 1222 | 23 |
638941 | 638941 | 2020-10-17 | Cerro Gordo | Iowa | 19033 | 1220 | 23 |
635695 | 635695 | 2020-10-16 | Cerro Gordo | Iowa | 19033 | 1218 | 23 |
632449 | 632449 | 2020-10-15 | Cerro Gordo | Iowa | 19033 | 1209 | 23 |
629205 | 629205 | 2020-10-14 | Cerro Gordo | Iowa | 19033 | 1201 | 23 |
625962 | 625962 | 2020-10-13 | Cerro Gordo | Iowa | 19033 | 1193 | 23 |
622720 | 622720 | 2020-10-12 | Cerro Gordo | Iowa | 19033 | 1182 | 23 |
619476 | 619476 | 2020-10-11 | Cerro Gordo | Iowa | 19033 | 1180 | 23 |
616234 | 616234 | 2020-10-10 | Cerro Gordo | Iowa | 19033 | 1175 | 23 |
612993 | 612993 | 2020-10-09 | Cerro Gordo | Iowa | 19033 | 1172 | 23 |
609751 | 609751 | 2020-10-08 | Cerro Gordo | Iowa | 19033 | 1167 | 23 |
606508 | 606508 | 2020-10-07 | Cerro Gordo | Iowa | 19033 | 1124 | 23 |
603266 | 603266 | 2020-10-06 | Cerro Gordo | Iowa | 19033 | 1119 | 23 |
600023 | 600023 | 2020-10-05 | Cerro Gordo | Iowa | 19033 | 1113 | 23 |
596781 | 596781 | 2020-10-04 | Cerro Gordo | Iowa | 19033 | 1109 | 23 |
593539 | 593539 | 2020-10-03 | Cerro Gordo | Iowa | 19033 | 1105 | 23 |
590298 | 590298 | 2020-10-02 | Cerro Gordo | Iowa | 19033 | 1105 | 23 |
587057 | 587057 | 2020-10-01 | Cerro Gordo | Iowa | 19033 | 1101 | 23 |
583817 | 583817 | 2020-09-30 | Cerro Gordo | Iowa | 19033 | 1076 | 22 |
580578 | 580578 | 2020-09-29 | Cerro Gordo | Iowa | 19033 | 1064 | 21 |
577337 | 577337 | 2020-09-28 | Cerro Gordo | Iowa | 19033 | 1059 | 21 |
574095 | 574095 | 2020-09-27 | Cerro Gordo | Iowa | 19033 | 1058 | 21 |
570852 | 570852 | 2020-09-26 | Cerro Gordo | Iowa | 19033 | 1057 | 21 |
567610 | 567610 | 2020-09-25 | Cerro Gordo | Iowa | 19033 | 1051 | 21 |
564370 | 564370 | 2020-09-24 | Cerro Gordo | Iowa | 19033 | 1018 | 21 |
561130 | 561130 | 2020-09-23 | Cerro Gordo | Iowa | 19033 | 1017 | 21 |
557894 | 557894 | 2020-09-22 | Cerro Gordo | Iowa | 19033 | 1008 | 21 |
554657 | 554657 | 2020-09-21 | Cerro Gordo | Iowa | 19033 | 1002 | 21 |
551418 | 551418 | 2020-09-20 | Cerro Gordo | Iowa | 19033 | 996 | 21 |
548179 | 548179 | 2020-09-19 | Cerro Gordo | Iowa | 19033 | 993 | 21 |
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);