ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
676 rows where deaths = 7 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Bremer 104
- Greene 43
- Monroe 35
- Henry 26
- Dickinson 25
- Audubon 20
- Calhoun 20
- Lee 20
- Johnson 18
- Montgomery 18
- Clarke 17
- Howard 15
- Hardin 14
- Washington 14
- Hancock 13
- Keokuk 13
- Lucas 13
- O'Brien 13
- Ringgold 13
- Lyon 12
- Warren 12
- Wayne 12
- Sac 11
- Des Moines 10
- Tama 10
- Mills 9
- Osceola 9
- Worth 9
- Adams 7
- Emmet 7
- …
state 1
- Iowa · 676 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1875897 | 1875897 | 2021-11-02 | Adams | Iowa | 19003 | 520 | 7 |
1872648 | 1872648 | 2021-11-01 | Adams | Iowa | 19003 | 520 | 7 |
1869399 | 1869399 | 2021-10-31 | Adams | Iowa | 19003 | 520 | 7 |
1866150 | 1866150 | 2021-10-30 | Adams | Iowa | 19003 | 520 | 7 |
1862901 | 1862901 | 2021-10-29 | Adams | Iowa | 19003 | 520 | 7 |
1859652 | 1859652 | 2021-10-28 | Adams | Iowa | 19003 | 520 | 7 |
1856403 | 1856403 | 2021-10-27 | Adams | Iowa | 19003 | 520 | 7 |
1086855 | 1086855 | 2021-03-04 | Worth | Iowa | 19195 | 666 | 7 |
1083609 | 1083609 | 2021-03-03 | Worth | Iowa | 19195 | 664 | 7 |
1080363 | 1080363 | 2021-03-02 | Worth | Iowa | 19195 | 661 | 7 |
1077118 | 1077118 | 2021-03-01 | Worth | Iowa | 19195 | 659 | 7 |
1073872 | 1073872 | 2021-02-28 | Worth | Iowa | 19195 | 655 | 7 |
1070626 | 1070626 | 2021-02-27 | Worth | Iowa | 19195 | 655 | 7 |
1067381 | 1067381 | 2021-02-26 | Worth | Iowa | 19195 | 655 | 7 |
1064136 | 1064136 | 2021-02-25 | Worth | Iowa | 19195 | 655 | 7 |
1060891 | 1060891 | 2021-02-24 | Worth | Iowa | 19195 | 650 | 7 |
1015380 | 1015380 | 2021-02-10 | Decatur | Iowa | 19053 | 531 | 7 |
1012135 | 1012135 | 2021-02-09 | Decatur | Iowa | 19053 | 531 | 7 |
1008889 | 1008889 | 2021-02-08 | Decatur | Iowa | 19053 | 526 | 7 |
1005643 | 1005643 | 2021-02-07 | Decatur | Iowa | 19053 | 526 | 7 |
1002397 | 1002397 | 2021-02-06 | Decatur | Iowa | 19053 | 526 | 7 |
999151 | 999151 | 2021-02-05 | Decatur | Iowa | 19053 | 526 | 7 |
979683 | 979683 | 2021-01-30 | Greene | Iowa | 19073 | 702 | 7 |
976437 | 976437 | 2021-01-29 | Greene | Iowa | 19073 | 700 | 7 |
973192 | 973192 | 2021-01-28 | Greene | Iowa | 19073 | 700 | 7 |
969947 | 969947 | 2021-01-27 | Greene | Iowa | 19073 | 699 | 7 |
966703 | 966703 | 2021-01-26 | Greene | Iowa | 19073 | 698 | 7 |
963458 | 963458 | 2021-01-25 | Greene | Iowa | 19073 | 697 | 7 |
960213 | 960213 | 2021-01-24 | Greene | Iowa | 19073 | 697 | 7 |
956967 | 956967 | 2021-01-23 | Greene | Iowa | 19073 | 697 | 7 |
953705 | 953705 | 2021-01-22 | Clarke | Iowa | 19039 | 808 | 7 |
953722 | 953722 | 2021-01-22 | Greene | Iowa | 19073 | 697 | 7 |
950460 | 950460 | 2021-01-21 | Clarke | Iowa | 19039 | 801 | 7 |
950477 | 950477 | 2021-01-21 | Greene | Iowa | 19073 | 697 | 7 |
947214 | 947214 | 2021-01-20 | Clarke | Iowa | 19039 | 798 | 7 |
947231 | 947231 | 2021-01-20 | Greene | Iowa | 19073 | 694 | 7 |
943967 | 943967 | 2021-01-19 | Clarke | Iowa | 19039 | 795 | 7 |
943984 | 943984 | 2021-01-19 | Greene | Iowa | 19073 | 692 | 7 |
940722 | 940722 | 2021-01-18 | Clarke | Iowa | 19039 | 792 | 7 |
940739 | 940739 | 2021-01-18 | Greene | Iowa | 19073 | 691 | 7 |
937477 | 937477 | 2021-01-17 | Clarke | Iowa | 19039 | 784 | 7 |
937494 | 937494 | 2021-01-17 | Greene | Iowa | 19073 | 688 | 7 |
934232 | 934232 | 2021-01-16 | Clarke | Iowa | 19039 | 781 | 7 |
934249 | 934249 | 2021-01-16 | Greene | Iowa | 19073 | 688 | 7 |
930987 | 930987 | 2021-01-15 | Clarke | Iowa | 19039 | 775 | 7 |
931004 | 931004 | 2021-01-15 | Greene | Iowa | 19073 | 686 | 7 |
927742 | 927742 | 2021-01-14 | Clarke | Iowa | 19039 | 771 | 7 |
927759 | 927759 | 2021-01-14 | Greene | Iowa | 19073 | 683 | 7 |
924496 | 924496 | 2021-01-13 | Clarke | Iowa | 19039 | 767 | 7 |
924513 | 924513 | 2021-01-13 | Greene | Iowa | 19073 | 676 | 7 |
921251 | 921251 | 2021-01-12 | Clarke | Iowa | 19039 | 760 | 7 |
921268 | 921268 | 2021-01-12 | Greene | Iowa | 19073 | 674 | 7 |
918006 | 918006 | 2021-01-11 | Clarke | Iowa | 19039 | 746 | 7 |
918023 | 918023 | 2021-01-11 | Greene | Iowa | 19073 | 669 | 7 |
914761 | 914761 | 2021-01-10 | Clarke | Iowa | 19039 | 739 | 7 |
914778 | 914778 | 2021-01-10 | Greene | Iowa | 19073 | 668 | 7 |
911516 | 911516 | 2021-01-09 | Clarke | Iowa | 19039 | 737 | 7 |
911533 | 911533 | 2021-01-09 | Greene | Iowa | 19073 | 668 | 7 |
908271 | 908271 | 2021-01-08 | Clarke | Iowa | 19039 | 737 | 7 |
908288 | 908288 | 2021-01-08 | Greene | Iowa | 19073 | 666 | 7 |
905025 | 905025 | 2021-01-07 | Clarke | Iowa | 19039 | 734 | 7 |
905042 | 905042 | 2021-01-07 | Greene | Iowa | 19073 | 665 | 7 |
901780 | 901780 | 2021-01-06 | Clarke | Iowa | 19039 | 726 | 7 |
901797 | 901797 | 2021-01-06 | Greene | Iowa | 19073 | 662 | 7 |
898520 | 898520 | 2021-01-05 | Audubon | Iowa | 19009 | 395 | 7 |
898552 | 898552 | 2021-01-05 | Greene | Iowa | 19073 | 660 | 7 |
895275 | 895275 | 2021-01-04 | Audubon | Iowa | 19009 | 391 | 7 |
895307 | 895307 | 2021-01-04 | Greene | Iowa | 19073 | 655 | 7 |
892028 | 892028 | 2021-01-03 | Audubon | Iowa | 19009 | 385 | 7 |
892060 | 892060 | 2021-01-03 | Greene | Iowa | 19073 | 649 | 7 |
888782 | 888782 | 2021-01-02 | Audubon | Iowa | 19009 | 385 | 7 |
888814 | 888814 | 2021-01-02 | Greene | Iowa | 19073 | 648 | 7 |
885536 | 885536 | 2021-01-01 | Audubon | Iowa | 19009 | 384 | 7 |
885568 | 885568 | 2021-01-01 | Greene | Iowa | 19073 | 648 | 7 |
885611 | 885611 | 2021-01-01 | Ringgold | Iowa | 19159 | 367 | 7 |
882291 | 882291 | 2020-12-31 | Audubon | Iowa | 19009 | 381 | 7 |
882323 | 882323 | 2020-12-31 | Greene | Iowa | 19073 | 648 | 7 |
882345 | 882345 | 2020-12-31 | Lucas | Iowa | 19117 | 575 | 7 |
882366 | 882366 | 2020-12-31 | Ringgold | Iowa | 19159 | 365 | 7 |
879046 | 879046 | 2020-12-30 | Audubon | Iowa | 19009 | 369 | 7 |
879078 | 879078 | 2020-12-30 | Greene | Iowa | 19073 | 645 | 7 |
879100 | 879100 | 2020-12-30 | Lucas | Iowa | 19117 | 570 | 7 |
879113 | 879113 | 2020-12-30 | Osceola | Iowa | 19143 | 611 | 7 |
879121 | 879121 | 2020-12-30 | Ringgold | Iowa | 19159 | 361 | 7 |
875801 | 875801 | 2020-12-29 | Audubon | Iowa | 19009 | 368 | 7 |
875833 | 875833 | 2020-12-29 | Greene | Iowa | 19073 | 644 | 7 |
875855 | 875855 | 2020-12-29 | Lucas | Iowa | 19117 | 563 | 7 |
875868 | 875868 | 2020-12-29 | Osceola | Iowa | 19143 | 608 | 7 |
875876 | 875876 | 2020-12-29 | Ringgold | Iowa | 19159 | 356 | 7 |
872556 | 872556 | 2020-12-28 | Audubon | Iowa | 19009 | 368 | 7 |
872588 | 872588 | 2020-12-28 | Greene | Iowa | 19073 | 636 | 7 |
872610 | 872610 | 2020-12-28 | Lucas | Iowa | 19117 | 549 | 7 |
872623 | 872623 | 2020-12-28 | Osceola | Iowa | 19143 | 608 | 7 |
872631 | 872631 | 2020-12-28 | Ringgold | Iowa | 19159 | 354 | 7 |
869311 | 869311 | 2020-12-27 | Audubon | Iowa | 19009 | 364 | 7 |
869343 | 869343 | 2020-12-27 | Greene | Iowa | 19073 | 634 | 7 |
869365 | 869365 | 2020-12-27 | Lucas | Iowa | 19117 | 539 | 7 |
869378 | 869378 | 2020-12-27 | Osceola | Iowa | 19143 | 607 | 7 |
869386 | 869386 | 2020-12-27 | Ringgold | Iowa | 19159 | 352 | 7 |
866066 | 866066 | 2020-12-26 | Audubon | Iowa | 19009 | 363 | 7 |
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);