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 |
---|---|---|---|---|---|---|---|
1054317 | 1054317 | 2021-02-22 | Cerro Gordo | Iowa | 19033 | 4939 | 80 |
1051070 | 1051070 | 2021-02-21 | Cerro Gordo | Iowa | 19033 | 4939 | 79 |
1047823 | 1047823 | 2021-02-20 | Cerro Gordo | Iowa | 19033 | 4939 | 79 |
1044578 | 1044578 | 2021-02-19 | Cerro Gordo | Iowa | 19033 | 4939 | 79 |
1041333 | 1041333 | 2021-02-18 | Cerro Gordo | Iowa | 19033 | 4934 | 79 |
1038088 | 1038088 | 2021-02-17 | Cerro Gordo | Iowa | 19033 | 4933 | 79 |
1034843 | 1034843 | 2021-02-16 | Cerro Gordo | Iowa | 19033 | 4932 | 79 |
1031597 | 1031597 | 2021-02-15 | Cerro Gordo | Iowa | 19033 | 4927 | 79 |
1028350 | 1028350 | 2021-02-14 | Cerro Gordo | Iowa | 19033 | 4922 | 79 |
1025105 | 1025105 | 2021-02-13 | Cerro Gordo | Iowa | 19033 | 4922 | 79 |
1021860 | 1021860 | 2021-02-12 | Cerro Gordo | Iowa | 19033 | 4919 | 79 |
1018615 | 1018615 | 2021-02-11 | Cerro Gordo | Iowa | 19033 | 4911 | 79 |
1015370 | 1015370 | 2021-02-10 | Cerro Gordo | Iowa | 19033 | 4911 | 77 |
1012125 | 1012125 | 2021-02-09 | Cerro Gordo | Iowa | 19033 | 4898 | 77 |
1008879 | 1008879 | 2021-02-08 | Cerro Gordo | Iowa | 19033 | 4879 | 76 |
1005633 | 1005633 | 2021-02-07 | Cerro Gordo | Iowa | 19033 | 4877 | 76 |
1002387 | 1002387 | 2021-02-06 | Cerro Gordo | Iowa | 19033 | 4871 | 76 |
999141 | 999141 | 2021-02-05 | Cerro Gordo | Iowa | 19033 | 4864 | 76 |
995895 | 995895 | 2021-02-04 | Cerro Gordo | Iowa | 19033 | 4856 | 76 |
992649 | 992649 | 2021-02-03 | Cerro Gordo | Iowa | 19033 | 4847 | 76 |
989403 | 989403 | 2021-02-02 | Cerro Gordo | Iowa | 19033 | 4825 | 74 |
986156 | 986156 | 2021-02-01 | Cerro Gordo | Iowa | 19033 | 4818 | 74 |
982909 | 982909 | 2021-01-31 | Cerro Gordo | Iowa | 19033 | 4814 | 74 |
979663 | 979663 | 2021-01-30 | Cerro Gordo | Iowa | 19033 | 4806 | 73 |
976417 | 976417 | 2021-01-29 | Cerro Gordo | Iowa | 19033 | 4795 | 72 |
973172 | 973172 | 2021-01-28 | Cerro Gordo | Iowa | 19033 | 4789 | 72 |
969927 | 969927 | 2021-01-27 | Cerro Gordo | Iowa | 19033 | 4776 | 72 |
966683 | 966683 | 2021-01-26 | Cerro Gordo | Iowa | 19033 | 4761 | 72 |
963438 | 963438 | 2021-01-25 | Cerro Gordo | Iowa | 19033 | 4743 | 72 |
960193 | 960193 | 2021-01-24 | Cerro Gordo | Iowa | 19033 | 4735 | 72 |
956947 | 956947 | 2021-01-23 | Cerro Gordo | Iowa | 19033 | 4725 | 72 |
953702 | 953702 | 2021-01-22 | Cerro Gordo | Iowa | 19033 | 4714 | 72 |
950457 | 950457 | 2021-01-21 | Cerro Gordo | Iowa | 19033 | 4699 | 72 |
947211 | 947211 | 2021-01-20 | Cerro Gordo | Iowa | 19033 | 4678 | 71 |
943964 | 943964 | 2021-01-19 | Cerro Gordo | Iowa | 19033 | 4667 | 68 |
940719 | 940719 | 2021-01-18 | Cerro Gordo | Iowa | 19033 | 4647 | 68 |
937474 | 937474 | 2021-01-17 | Cerro Gordo | Iowa | 19033 | 4635 | 68 |
934229 | 934229 | 2021-01-16 | Cerro Gordo | Iowa | 19033 | 4629 | 68 |
930984 | 930984 | 2021-01-15 | Cerro Gordo | Iowa | 19033 | 4619 | 66 |
927739 | 927739 | 2021-01-14 | Cerro Gordo | Iowa | 19033 | 4587 | 66 |
924493 | 924493 | 2021-01-13 | Cerro Gordo | Iowa | 19033 | 4566 | 65 |
921248 | 921248 | 2021-01-12 | Cerro Gordo | Iowa | 19033 | 4529 | 65 |
918003 | 918003 | 2021-01-11 | Cerro Gordo | Iowa | 19033 | 4528 | 64 |
914758 | 914758 | 2021-01-10 | Cerro Gordo | Iowa | 19033 | 4516 | 64 |
911513 | 911513 | 2021-01-09 | Cerro Gordo | Iowa | 19033 | 4500 | 64 |
908268 | 908268 | 2021-01-08 | Cerro Gordo | Iowa | 19033 | 4488 | 64 |
905022 | 905022 | 2021-01-07 | Cerro Gordo | Iowa | 19033 | 4463 | 63 |
901777 | 901777 | 2021-01-06 | Cerro Gordo | Iowa | 19033 | 4428 | 63 |
898532 | 898532 | 2021-01-05 | Cerro Gordo | Iowa | 19033 | 4401 | 63 |
895287 | 895287 | 2021-01-04 | Cerro Gordo | Iowa | 19033 | 4376 | 63 |
892040 | 892040 | 2021-01-03 | Cerro Gordo | Iowa | 19033 | 4361 | 62 |
888794 | 888794 | 2021-01-02 | Cerro Gordo | Iowa | 19033 | 4358 | 62 |
885548 | 885548 | 2021-01-01 | Cerro Gordo | Iowa | 19033 | 4353 | 62 |
882303 | 882303 | 2020-12-31 | Cerro Gordo | Iowa | 19033 | 4329 | 62 |
879058 | 879058 | 2020-12-30 | Cerro Gordo | Iowa | 19033 | 4309 | 61 |
875813 | 875813 | 2020-12-29 | Cerro Gordo | Iowa | 19033 | 4293 | 61 |
872568 | 872568 | 2020-12-28 | Cerro Gordo | Iowa | 19033 | 4279 | 59 |
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 |
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);