ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,663 rows where deaths = 3 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Appanoose 197
- Clayton 178
- Clarke 125
- Crawford 66
- Union 63
- Humboldt 60
- Sioux 56
- Henry 53
- Jackson 50
- Floyd 49
- Adams 48
- Jones 44
- Hamilton 42
- Delaware 37
- Wayne 32
- Guthrie 30
- Butler 27
- Calhoun 25
- Clay 25
- Worth 23
- Story 22
- Allamakee 19
- Boone 18
- Lucas 16
- Decatur 15
- Dickinson 15
- Fremont 15
- Mills 15
- Madison 14
- Lyon 13
- …
state 1
- Iowa · 1,663 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054302 | 1054302 | 2021-02-22 | Adams | Iowa | 19003 | 317 | 3 |
1051055 | 1051055 | 2021-02-21 | Adams | Iowa | 19003 | 317 | 3 |
1047808 | 1047808 | 2021-02-20 | Adams | Iowa | 19003 | 317 | 3 |
1044563 | 1044563 | 2021-02-19 | Adams | Iowa | 19003 | 317 | 3 |
1041318 | 1041318 | 2021-02-18 | Adams | Iowa | 19003 | 317 | 3 |
1038073 | 1038073 | 2021-02-17 | Adams | Iowa | 19003 | 317 | 3 |
1034828 | 1034828 | 2021-02-16 | Adams | Iowa | 19003 | 317 | 3 |
1031582 | 1031582 | 2021-02-15 | Adams | Iowa | 19003 | 317 | 3 |
1028335 | 1028335 | 2021-02-14 | Adams | Iowa | 19003 | 317 | 3 |
1025090 | 1025090 | 2021-02-13 | Adams | Iowa | 19003 | 316 | 3 |
1021845 | 1021845 | 2021-02-12 | Adams | Iowa | 19003 | 316 | 3 |
1018600 | 1018600 | 2021-02-11 | Adams | Iowa | 19003 | 313 | 3 |
1015355 | 1015355 | 2021-02-10 | Adams | Iowa | 19003 | 313 | 3 |
1012110 | 1012110 | 2021-02-09 | Adams | Iowa | 19003 | 313 | 3 |
1008864 | 1008864 | 2021-02-08 | Adams | Iowa | 19003 | 313 | 3 |
1005618 | 1005618 | 2021-02-07 | Adams | Iowa | 19003 | 313 | 3 |
1002372 | 1002372 | 2021-02-06 | Adams | Iowa | 19003 | 313 | 3 |
999126 | 999126 | 2021-02-05 | Adams | Iowa | 19003 | 312 | 3 |
995880 | 995880 | 2021-02-04 | Adams | Iowa | 19003 | 311 | 3 |
992634 | 992634 | 2021-02-03 | Adams | Iowa | 19003 | 310 | 3 |
989388 | 989388 | 2021-02-02 | Adams | Iowa | 19003 | 309 | 3 |
986141 | 986141 | 2021-02-01 | Adams | Iowa | 19003 | 309 | 3 |
982894 | 982894 | 2021-01-31 | Adams | Iowa | 19003 | 308 | 3 |
979648 | 979648 | 2021-01-30 | Adams | Iowa | 19003 | 308 | 3 |
976402 | 976402 | 2021-01-29 | Adams | Iowa | 19003 | 306 | 3 |
973157 | 973157 | 2021-01-28 | Adams | Iowa | 19003 | 305 | 3 |
969912 | 969912 | 2021-01-27 | Adams | Iowa | 19003 | 302 | 3 |
966668 | 966668 | 2021-01-26 | Adams | Iowa | 19003 | 302 | 3 |
963423 | 963423 | 2021-01-25 | Adams | Iowa | 19003 | 302 | 3 |
960178 | 960178 | 2021-01-24 | Adams | Iowa | 19003 | 300 | 3 |
956932 | 956932 | 2021-01-23 | Adams | Iowa | 19003 | 299 | 3 |
953687 | 953687 | 2021-01-22 | Adams | Iowa | 19003 | 298 | 3 |
950442 | 950442 | 2021-01-21 | Adams | Iowa | 19003 | 298 | 3 |
947196 | 947196 | 2021-01-20 | Adams | Iowa | 19003 | 297 | 3 |
947293 | 947293 | 2021-01-20 | Worth | Iowa | 19195 | 613 | 3 |
943949 | 943949 | 2021-01-19 | Adams | Iowa | 19003 | 296 | 3 |
944046 | 944046 | 2021-01-19 | Worth | Iowa | 19195 | 611 | 3 |
940704 | 940704 | 2021-01-18 | Adams | Iowa | 19003 | 295 | 3 |
940801 | 940801 | 2021-01-18 | Worth | Iowa | 19195 | 606 | 3 |
937459 | 937459 | 2021-01-17 | Adams | Iowa | 19003 | 295 | 3 |
937556 | 937556 | 2021-01-17 | Worth | Iowa | 19195 | 599 | 3 |
934214 | 934214 | 2021-01-16 | Adams | Iowa | 19003 | 295 | 3 |
934311 | 934311 | 2021-01-16 | Worth | Iowa | 19195 | 598 | 3 |
930969 | 930969 | 2021-01-15 | Adams | Iowa | 19003 | 293 | 3 |
931066 | 931066 | 2021-01-15 | Worth | Iowa | 19195 | 594 | 3 |
927724 | 927724 | 2021-01-14 | Adams | Iowa | 19003 | 292 | 3 |
927821 | 927821 | 2021-01-14 | Worth | Iowa | 19195 | 587 | 3 |
924478 | 924478 | 2021-01-13 | Adams | Iowa | 19003 | 291 | 3 |
924575 | 924575 | 2021-01-13 | Worth | Iowa | 19195 | 584 | 3 |
921233 | 921233 | 2021-01-12 | Adams | Iowa | 19003 | 288 | 3 |
921330 | 921330 | 2021-01-12 | Worth | Iowa | 19195 | 580 | 3 |
917988 | 917988 | 2021-01-11 | Adams | Iowa | 19003 | 288 | 3 |
918085 | 918085 | 2021-01-11 | Worth | Iowa | 19195 | 578 | 3 |
914743 | 914743 | 2021-01-10 | Adams | Iowa | 19003 | 288 | 3 |
914840 | 914840 | 2021-01-10 | Worth | Iowa | 19195 | 574 | 3 |
911498 | 911498 | 2021-01-09 | Adams | Iowa | 19003 | 288 | 3 |
911595 | 911595 | 2021-01-09 | Worth | Iowa | 19195 | 566 | 3 |
908253 | 908253 | 2021-01-08 | Adams | Iowa | 19003 | 285 | 3 |
908350 | 908350 | 2021-01-08 | Worth | Iowa | 19195 | 564 | 3 |
905007 | 905007 | 2021-01-07 | Adams | Iowa | 19003 | 281 | 3 |
905104 | 905104 | 2021-01-07 | Worth | Iowa | 19195 | 560 | 3 |
901762 | 901762 | 2021-01-06 | Adams | Iowa | 19003 | 275 | 3 |
901859 | 901859 | 2021-01-06 | Worth | Iowa | 19195 | 549 | 3 |
898614 | 898614 | 2021-01-05 | Worth | Iowa | 19195 | 540 | 3 |
895369 | 895369 | 2021-01-04 | Worth | Iowa | 19195 | 536 | 3 |
892122 | 892122 | 2021-01-03 | Worth | Iowa | 19195 | 535 | 3 |
888876 | 888876 | 2021-01-02 | Worth | Iowa | 19195 | 533 | 3 |
885630 | 885630 | 2021-01-01 | Worth | Iowa | 19195 | 528 | 3 |
882313 | 882313 | 2020-12-31 | Decatur | Iowa | 19053 | 429 | 3 |
882385 | 882385 | 2020-12-31 | Worth | Iowa | 19195 | 521 | 3 |
879068 | 879068 | 2020-12-30 | Decatur | Iowa | 19053 | 425 | 3 |
879140 | 879140 | 2020-12-30 | Worth | Iowa | 19195 | 516 | 3 |
875823 | 875823 | 2020-12-29 | Decatur | Iowa | 19053 | 422 | 3 |
875895 | 875895 | 2020-12-29 | Worth | Iowa | 19195 | 511 | 3 |
872578 | 872578 | 2020-12-28 | Decatur | Iowa | 19053 | 417 | 3 |
869333 | 869333 | 2020-12-27 | Decatur | Iowa | 19053 | 414 | 3 |
866088 | 866088 | 2020-12-26 | Decatur | Iowa | 19053 | 414 | 3 |
862843 | 862843 | 2020-12-25 | Decatur | Iowa | 19053 | 412 | 3 |
859598 | 859598 | 2020-12-24 | Decatur | Iowa | 19053 | 411 | 3 |
856353 | 856353 | 2020-12-23 | Decatur | Iowa | 19053 | 408 | 3 |
853108 | 853108 | 2020-12-22 | Decatur | Iowa | 19053 | 395 | 3 |
849863 | 849863 | 2020-12-21 | Decatur | Iowa | 19053 | 393 | 3 |
846618 | 846618 | 2020-12-20 | Decatur | Iowa | 19053 | 393 | 3 |
843372 | 843372 | 2020-12-19 | Decatur | Iowa | 19053 | 393 | 3 |
840127 | 840127 | 2020-12-18 | Decatur | Iowa | 19053 | 392 | 3 |
836882 | 836882 | 2020-12-17 | Decatur | Iowa | 19053 | 388 | 3 |
814203 | 814203 | 2020-12-10 | Osceola | Iowa | 19143 | 582 | 3 |
810923 | 810923 | 2020-12-09 | Greene | Iowa | 19073 | 569 | 3 |
810958 | 810958 | 2020-12-09 | Osceola | Iowa | 19143 | 570 | 3 |
810962 | 810962 | 2020-12-09 | Pocahontas | Iowa | 19151 | 620 | 3 |
807713 | 807713 | 2020-12-08 | Osceola | Iowa | 19143 | 565 | 3 |
807717 | 807717 | 2020-12-08 | Pocahontas | Iowa | 19151 | 616 | 3 |
804401 | 804401 | 2020-12-07 | Audubon | Iowa | 19009 | 314 | 3 |
804432 | 804432 | 2020-12-07 | Fremont | Iowa | 19071 | 404 | 3 |
804483 | 804483 | 2020-12-07 | Taylor | Iowa | 19173 | 483 | 3 |
801156 | 801156 | 2020-12-06 | Audubon | Iowa | 19009 | 313 | 3 |
801187 | 801187 | 2020-12-06 | Fremont | Iowa | 19071 | 398 | 3 |
801238 | 801238 | 2020-12-06 | Taylor | Iowa | 19173 | 483 | 3 |
797942 | 797942 | 2020-12-05 | Fremont | Iowa | 19071 | 395 | 3 |
797993 | 797993 | 2020-12-05 | Taylor | Iowa | 19173 | 483 | 3 |
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);