ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
702 rows where deaths = 5 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Guthrie 67
- Montgomery 53
- Fremont 39
- Carroll 31
- Henry 30
- Webster 25
- Bremer 21
- Allamakee 20
- Lee 20
- Plymouth 16
- Lucas 15
- Warren 15
- Winneshiek 15
- Buchanan 14
- Cedar 13
- Des Moines 13
- Harrison 13
- Humboldt 13
- Jackson 12
- Van Buren 12
- Sac 11
- Dickinson 10
- Polk 10
- Washington 10
- Lyon 9
- Osceola 9
- Boone 8
- Crawford 8
- Hardin 8
- Monroe 8
- …
state 1
- Iowa · 702 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1853154 | 1853154 | 2021-10-26 | Adams | Iowa | 19003 | 509 | 5 |
1849905 | 1849905 | 2021-10-25 | Adams | Iowa | 19003 | 509 | 5 |
1846655 | 1846655 | 2021-10-24 | Adams | Iowa | 19003 | 509 | 5 |
1843405 | 1843405 | 2021-10-23 | Adams | Iowa | 19003 | 509 | 5 |
1840155 | 1840155 | 2021-10-22 | Adams | Iowa | 19003 | 509 | 5 |
1836906 | 1836906 | 2021-10-21 | Adams | Iowa | 19003 | 509 | 5 |
1833657 | 1833657 | 2021-10-20 | Adams | Iowa | 19003 | 509 | 5 |
992659 | 992659 | 2021-02-03 | Decatur | Iowa | 19053 | 524 | 5 |
989413 | 989413 | 2021-02-02 | Decatur | Iowa | 19053 | 520 | 5 |
986166 | 986166 | 2021-02-01 | Decatur | Iowa | 19053 | 514 | 5 |
982919 | 982919 | 2021-01-31 | Decatur | Iowa | 19053 | 509 | 5 |
931003 | 931003 | 2021-01-15 | Fremont | Iowa | 19071 | 502 | 5 |
927758 | 927758 | 2021-01-14 | Fremont | Iowa | 19071 | 500 | 5 |
924512 | 924512 | 2021-01-13 | Fremont | Iowa | 19071 | 500 | 5 |
921267 | 921267 | 2021-01-12 | Fremont | Iowa | 19071 | 491 | 5 |
918022 | 918022 | 2021-01-11 | Fremont | Iowa | 19071 | 486 | 5 |
914777 | 914777 | 2021-01-10 | Fremont | Iowa | 19071 | 484 | 5 |
911532 | 911532 | 2021-01-09 | Fremont | Iowa | 19071 | 484 | 5 |
908287 | 908287 | 2021-01-08 | Fremont | Iowa | 19071 | 483 | 5 |
905041 | 905041 | 2021-01-07 | Fremont | Iowa | 19071 | 480 | 5 |
901796 | 901796 | 2021-01-06 | Fremont | Iowa | 19071 | 480 | 5 |
898551 | 898551 | 2021-01-05 | Fremont | Iowa | 19071 | 475 | 5 |
895306 | 895306 | 2021-01-04 | Fremont | Iowa | 19071 | 473 | 5 |
892059 | 892059 | 2021-01-03 | Fremont | Iowa | 19071 | 473 | 5 |
888813 | 888813 | 2021-01-02 | Fremont | Iowa | 19071 | 473 | 5 |
885567 | 885567 | 2021-01-01 | Fremont | Iowa | 19071 | 472 | 5 |
882322 | 882322 | 2020-12-31 | Fremont | Iowa | 19071 | 467 | 5 |
879077 | 879077 | 2020-12-30 | Fremont | Iowa | 19071 | 466 | 5 |
875832 | 875832 | 2020-12-29 | Fremont | Iowa | 19071 | 461 | 5 |
872587 | 872587 | 2020-12-28 | Fremont | Iowa | 19071 | 457 | 5 |
869342 | 869342 | 2020-12-27 | Fremont | Iowa | 19071 | 454 | 5 |
866097 | 866097 | 2020-12-26 | Fremont | Iowa | 19071 | 454 | 5 |
862852 | 862852 | 2020-12-25 | Fremont | Iowa | 19071 | 454 | 5 |
859607 | 859607 | 2020-12-24 | Fremont | Iowa | 19071 | 454 | 5 |
856362 | 856362 | 2020-12-23 | Fremont | Iowa | 19071 | 451 | 5 |
853117 | 853117 | 2020-12-22 | Fremont | Iowa | 19071 | 448 | 5 |
849872 | 849872 | 2020-12-21 | Fremont | Iowa | 19071 | 445 | 5 |
846627 | 846627 | 2020-12-20 | Fremont | Iowa | 19071 | 442 | 5 |
843381 | 843381 | 2020-12-19 | Fremont | Iowa | 19071 | 442 | 5 |
843417 | 843417 | 2020-12-19 | Osceola | Iowa | 19143 | 600 | 5 |
843419 | 843419 | 2020-12-19 | Palo Alto | Iowa | 19147 | 779 | 5 |
840136 | 840136 | 2020-12-18 | Fremont | Iowa | 19071 | 438 | 5 |
840172 | 840172 | 2020-12-18 | Osceola | Iowa | 19143 | 599 | 5 |
836891 | 836891 | 2020-12-17 | Fremont | Iowa | 19071 | 433 | 5 |
836927 | 836927 | 2020-12-17 | Osceola | Iowa | 19143 | 598 | 5 |
833645 | 833645 | 2020-12-16 | Fremont | Iowa | 19071 | 433 | 5 |
833681 | 833681 | 2020-12-16 | Osceola | Iowa | 19143 | 597 | 5 |
830398 | 830398 | 2020-12-15 | Fremont | Iowa | 19071 | 429 | 5 |
830434 | 830434 | 2020-12-15 | Osceola | Iowa | 19143 | 593 | 5 |
827152 | 827152 | 2020-12-14 | Fremont | Iowa | 19071 | 426 | 5 |
827188 | 827188 | 2020-12-14 | Osceola | Iowa | 19143 | 590 | 5 |
827196 | 827196 | 2020-12-14 | Ringgold | Iowa | 19159 | 312 | 5 |
823905 | 823905 | 2020-12-13 | Fremont | Iowa | 19071 | 424 | 5 |
823941 | 823941 | 2020-12-13 | Osceola | Iowa | 19143 | 589 | 5 |
823949 | 823949 | 2020-12-13 | Ringgold | Iowa | 19159 | 307 | 5 |
820659 | 820659 | 2020-12-12 | Fremont | Iowa | 19071 | 421 | 5 |
820695 | 820695 | 2020-12-12 | Osceola | Iowa | 19143 | 589 | 5 |
820703 | 820703 | 2020-12-12 | Ringgold | Iowa | 19159 | 306 | 5 |
817413 | 817413 | 2020-12-11 | Fremont | Iowa | 19071 | 419 | 5 |
817449 | 817449 | 2020-12-11 | Osceola | Iowa | 19143 | 585 | 5 |
817457 | 817457 | 2020-12-11 | Ringgold | Iowa | 19159 | 302 | 5 |
814167 | 814167 | 2020-12-10 | Fremont | Iowa | 19071 | 412 | 5 |
814168 | 814168 | 2020-12-10 | Greene | Iowa | 19073 | 572 | 5 |
814211 | 814211 | 2020-12-10 | Ringgold | Iowa | 19159 | 298 | 5 |
810922 | 810922 | 2020-12-09 | Fremont | Iowa | 19071 | 408 | 5 |
807677 | 807677 | 2020-12-08 | Fremont | Iowa | 19071 | 404 | 5 |
804457 | 804457 | 2020-12-07 | Madison | Iowa | 19121 | 778 | 5 |
804469 | 804469 | 2020-12-07 | Page | Iowa | 19145 | 1233 | 5 |
804470 | 804470 | 2020-12-07 | Palo Alto | Iowa | 19147 | 701 | 5 |
804486 | 804486 | 2020-12-07 | Van Buren | Iowa | 19177 | 408 | 5 |
801212 | 801212 | 2020-12-06 | Madison | Iowa | 19121 | 775 | 5 |
801224 | 801224 | 2020-12-06 | Page | Iowa | 19145 | 1218 | 5 |
801225 | 801225 | 2020-12-06 | Palo Alto | Iowa | 19147 | 695 | 5 |
801241 | 801241 | 2020-12-06 | Van Buren | Iowa | 19177 | 406 | 5 |
797967 | 797967 | 2020-12-05 | Madison | Iowa | 19121 | 767 | 5 |
797979 | 797979 | 2020-12-05 | Page | Iowa | 19145 | 1202 | 5 |
797980 | 797980 | 2020-12-05 | Palo Alto | Iowa | 19147 | 692 | 5 |
797996 | 797996 | 2020-12-05 | Van Buren | Iowa | 19177 | 385 | 5 |
794722 | 794722 | 2020-12-04 | Madison | Iowa | 19121 | 758 | 5 |
794734 | 794734 | 2020-12-04 | Page | Iowa | 19145 | 1199 | 5 |
794735 | 794735 | 2020-12-04 | Palo Alto | Iowa | 19147 | 679 | 5 |
794751 | 794751 | 2020-12-04 | Van Buren | Iowa | 19177 | 384 | 5 |
791435 | 791435 | 2020-12-03 | Chickasaw | Iowa | 19037 | 919 | 5 |
791437 | 791437 | 2020-12-03 | Clay | Iowa | 19041 | 1250 | 5 |
791462 | 791462 | 2020-12-03 | Humboldt | Iowa | 19091 | 812 | 5 |
791467 | 791467 | 2020-12-03 | Jefferson | Iowa | 19101 | 763 | 5 |
791477 | 791477 | 2020-12-03 | Madison | Iowa | 19121 | 727 | 5 |
791489 | 791489 | 2020-12-03 | Page | Iowa | 19145 | 1192 | 5 |
791506 | 791506 | 2020-12-03 | Van Buren | Iowa | 19177 | 381 | 5 |
788217 | 788217 | 2020-12-02 | Humboldt | Iowa | 19091 | 801 | 5 |
788261 | 788261 | 2020-12-02 | Van Buren | Iowa | 19177 | 375 | 5 |
784973 | 784973 | 2020-12-01 | Humboldt | Iowa | 19091 | 795 | 5 |
784993 | 784993 | 2020-12-01 | Mitchell | Iowa | 19131 | 811 | 5 |
785017 | 785017 | 2020-12-01 | Van Buren | Iowa | 19177 | 365 | 5 |
781728 | 781728 | 2020-11-30 | Humboldt | Iowa | 19091 | 785 | 5 |
781748 | 781748 | 2020-11-30 | Mitchell | Iowa | 19131 | 803 | 5 |
781772 | 781772 | 2020-11-30 | Van Buren | Iowa | 19177 | 361 | 5 |
778458 | 778458 | 2020-11-29 | Clayton | Iowa | 19043 | 1117 | 5 |
778482 | 778482 | 2020-11-29 | Humboldt | Iowa | 19091 | 771 | 5 |
778526 | 778526 | 2020-11-29 | Van Buren | Iowa | 19177 | 358 | 5 |
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);