ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
657 rows where deaths = 6 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Lucas 101
- Warren 45
- Bremer 44
- Dickinson 35
- Monroe 32
- Union 31
- Clarke 29
- Hancock 21
- Grundy 17
- Hamilton 15
- Allamakee 14
- Fremont 13
- Johnson 13
- Lee 13
- Wayne 13
- Audubon 9
- Butler 8
- Calhoun 8
- Fayette 8
- Greene 8
- Henry 7
- Howard 7
- Plymouth 7
- Benton 6
- Buchanan 6
- Des Moines 6
- Mills 6
- Winneshiek 6
- Wright 6
- Appanoose 5
- …
state 1
- Iowa · 657 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1057645 | 1057645 | 2021-02-23 | Worth | Iowa | 19195 | 650 | 6 |
995905 | 995905 | 2021-02-04 | Decatur | Iowa | 19053 | 526 | 6 |
973191 | 973191 | 2021-01-28 | Fremont | Iowa | 19071 | 530 | 6 |
969946 | 969946 | 2021-01-27 | Fremont | Iowa | 19071 | 529 | 6 |
966702 | 966702 | 2021-01-26 | Fremont | Iowa | 19071 | 529 | 6 |
963457 | 963457 | 2021-01-25 | Fremont | Iowa | 19071 | 527 | 6 |
960212 | 960212 | 2021-01-24 | Fremont | Iowa | 19071 | 524 | 6 |
956966 | 956966 | 2021-01-23 | Fremont | Iowa | 19071 | 524 | 6 |
953721 | 953721 | 2021-01-22 | Fremont | Iowa | 19071 | 524 | 6 |
950476 | 950476 | 2021-01-21 | Fremont | Iowa | 19071 | 520 | 6 |
947230 | 947230 | 2021-01-20 | Fremont | Iowa | 19071 | 517 | 6 |
943983 | 943983 | 2021-01-19 | Fremont | Iowa | 19071 | 512 | 6 |
940738 | 940738 | 2021-01-18 | Fremont | Iowa | 19071 | 508 | 6 |
937493 | 937493 | 2021-01-17 | Fremont | Iowa | 19071 | 504 | 6 |
934248 | 934248 | 2021-01-16 | Fremont | Iowa | 19071 | 503 | 6 |
898535 | 898535 | 2021-01-05 | Clarke | Iowa | 19039 | 719 | 6 |
895290 | 895290 | 2021-01-04 | Clarke | Iowa | 19039 | 702 | 6 |
892043 | 892043 | 2021-01-03 | Clarke | Iowa | 19039 | 698 | 6 |
888797 | 888797 | 2021-01-02 | Clarke | Iowa | 19039 | 693 | 6 |
885551 | 885551 | 2021-01-01 | Clarke | Iowa | 19039 | 690 | 6 |
882306 | 882306 | 2020-12-31 | Clarke | Iowa | 19039 | 687 | 6 |
879061 | 879061 | 2020-12-30 | Clarke | Iowa | 19039 | 681 | 6 |
875816 | 875816 | 2020-12-29 | Clarke | Iowa | 19039 | 674 | 6 |
872571 | 872571 | 2020-12-28 | Clarke | Iowa | 19039 | 663 | 6 |
869326 | 869326 | 2020-12-27 | Clarke | Iowa | 19039 | 653 | 6 |
866081 | 866081 | 2020-12-26 | Clarke | Iowa | 19039 | 650 | 6 |
862836 | 862836 | 2020-12-25 | Clarke | Iowa | 19039 | 646 | 6 |
859591 | 859591 | 2020-12-24 | Clarke | Iowa | 19039 | 645 | 6 |
856346 | 856346 | 2020-12-23 | Clarke | Iowa | 19039 | 626 | 6 |
853101 | 853101 | 2020-12-22 | Clarke | Iowa | 19039 | 608 | 6 |
849856 | 849856 | 2020-12-21 | Clarke | Iowa | 19039 | 596 | 6 |
849908 | 849908 | 2020-12-21 | Osceola | Iowa | 19143 | 602 | 6 |
849910 | 849910 | 2020-12-21 | Palo Alto | Iowa | 19147 | 781 | 6 |
846611 | 846611 | 2020-12-20 | Clarke | Iowa | 19039 | 593 | 6 |
846663 | 846663 | 2020-12-20 | Osceola | Iowa | 19143 | 600 | 6 |
846665 | 846665 | 2020-12-20 | Palo Alto | Iowa | 19147 | 779 | 6 |
843365 | 843365 | 2020-12-19 | Clarke | Iowa | 19039 | 590 | 6 |
843421 | 843421 | 2020-12-19 | Pocahontas | Iowa | 19151 | 669 | 6 |
843425 | 843425 | 2020-12-19 | Ringgold | Iowa | 19159 | 338 | 6 |
840120 | 840120 | 2020-12-18 | Clarke | Iowa | 19039 | 578 | 6 |
840137 | 840137 | 2020-12-18 | Greene | Iowa | 19073 | 611 | 6 |
840159 | 840159 | 2020-12-18 | Lucas | Iowa | 19117 | 454 | 6 |
840176 | 840176 | 2020-12-18 | Pocahontas | Iowa | 19151 | 668 | 6 |
840180 | 840180 | 2020-12-18 | Ringgold | Iowa | 19159 | 334 | 6 |
836875 | 836875 | 2020-12-17 | Clarke | Iowa | 19039 | 571 | 6 |
836892 | 836892 | 2020-12-17 | Greene | Iowa | 19073 | 603 | 6 |
836914 | 836914 | 2020-12-17 | Lucas | Iowa | 19117 | 441 | 6 |
836931 | 836931 | 2020-12-17 | Pocahontas | Iowa | 19151 | 662 | 6 |
836935 | 836935 | 2020-12-17 | Ringgold | Iowa | 19159 | 333 | 6 |
833614 | 833614 | 2020-12-16 | Audubon | Iowa | 19009 | 340 | 6 |
833629 | 833629 | 2020-12-16 | Clarke | Iowa | 19039 | 565 | 6 |
833646 | 833646 | 2020-12-16 | Greene | Iowa | 19073 | 601 | 6 |
833668 | 833668 | 2020-12-16 | Lucas | Iowa | 19117 | 434 | 6 |
833689 | 833689 | 2020-12-16 | Ringgold | Iowa | 19159 | 320 | 6 |
830367 | 830367 | 2020-12-15 | Audubon | Iowa | 19009 | 334 | 6 |
830382 | 830382 | 2020-12-15 | Clarke | Iowa | 19039 | 556 | 6 |
830399 | 830399 | 2020-12-15 | Greene | Iowa | 19073 | 597 | 6 |
830421 | 830421 | 2020-12-15 | Lucas | Iowa | 19117 | 410 | 6 |
830442 | 830442 | 2020-12-15 | Ringgold | Iowa | 19159 | 319 | 6 |
827121 | 827121 | 2020-12-14 | Audubon | Iowa | 19009 | 328 | 6 |
827136 | 827136 | 2020-12-14 | Clarke | Iowa | 19039 | 551 | 6 |
827153 | 827153 | 2020-12-14 | Greene | Iowa | 19073 | 585 | 6 |
827175 | 827175 | 2020-12-14 | Lucas | Iowa | 19117 | 401 | 6 |
823874 | 823874 | 2020-12-13 | Audubon | Iowa | 19009 | 327 | 6 |
823889 | 823889 | 2020-12-13 | Clarke | Iowa | 19039 | 550 | 6 |
823906 | 823906 | 2020-12-13 | Greene | Iowa | 19073 | 582 | 6 |
823928 | 823928 | 2020-12-13 | Lucas | Iowa | 19117 | 396 | 6 |
820628 | 820628 | 2020-12-12 | Audubon | Iowa | 19009 | 327 | 6 |
820643 | 820643 | 2020-12-12 | Clarke | Iowa | 19039 | 546 | 6 |
820660 | 820660 | 2020-12-12 | Greene | Iowa | 19073 | 581 | 6 |
820682 | 820682 | 2020-12-12 | Lucas | Iowa | 19117 | 391 | 6 |
817382 | 817382 | 2020-12-11 | Audubon | Iowa | 19009 | 326 | 6 |
817397 | 817397 | 2020-12-11 | Clarke | Iowa | 19039 | 544 | 6 |
817414 | 817414 | 2020-12-11 | Greene | Iowa | 19073 | 577 | 6 |
817436 | 817436 | 2020-12-11 | Lucas | Iowa | 19117 | 390 | 6 |
814136 | 814136 | 2020-12-10 | Audubon | Iowa | 19009 | 321 | 6 |
814151 | 814151 | 2020-12-10 | Clarke | Iowa | 19039 | 540 | 6 |
814190 | 814190 | 2020-12-10 | Lucas | Iowa | 19117 | 382 | 6 |
810891 | 810891 | 2020-12-09 | Audubon | Iowa | 19009 | 318 | 6 |
810906 | 810906 | 2020-12-09 | Clarke | Iowa | 19039 | 534 | 6 |
810945 | 810945 | 2020-12-09 | Lucas | Iowa | 19117 | 375 | 6 |
810947 | 810947 | 2020-12-09 | Madison | Iowa | 19121 | 791 | 6 |
807646 | 807646 | 2020-12-08 | Audubon | Iowa | 19009 | 315 | 6 |
807661 | 807661 | 2020-12-08 | Clarke | Iowa | 19039 | 528 | 6 |
807700 | 807700 | 2020-12-08 | Lucas | Iowa | 19117 | 370 | 6 |
807702 | 807702 | 2020-12-08 | Madison | Iowa | 19121 | 779 | 6 |
807714 | 807714 | 2020-12-08 | Page | Iowa | 19145 | 1235 | 6 |
804415 | 804415 | 2020-12-07 | Chickasaw | Iowa | 19037 | 934 | 6 |
804442 | 804442 | 2020-12-07 | Humboldt | Iowa | 19091 | 837 | 6 |
804447 | 804447 | 2020-12-07 | Jefferson | Iowa | 19101 | 796 | 6 |
804455 | 804455 | 2020-12-07 | Lucas | Iowa | 19117 | 370 | 6 |
801170 | 801170 | 2020-12-06 | Chickasaw | Iowa | 19037 | 930 | 6 |
801197 | 801197 | 2020-12-06 | Humboldt | Iowa | 19091 | 831 | 6 |
801202 | 801202 | 2020-12-06 | Jefferson | Iowa | 19101 | 788 | 6 |
801210 | 801210 | 2020-12-06 | Lucas | Iowa | 19117 | 363 | 6 |
797925 | 797925 | 2020-12-05 | Chickasaw | Iowa | 19037 | 929 | 6 |
797927 | 797927 | 2020-12-05 | Clay | Iowa | 19041 | 1292 | 6 |
797952 | 797952 | 2020-12-05 | Humboldt | Iowa | 19091 | 829 | 6 |
797957 | 797957 | 2020-12-05 | Jefferson | Iowa | 19101 | 780 | 6 |
797965 | 797965 | 2020-12-05 | Lucas | Iowa | 19117 | 358 | 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);