ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,070 rows where state = "Iowa" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 19103 797
- 19155 796
- 19027 793
- 19085 792
- 19049 791
- 19005 790
- 19153 790
- 19001 788
- 19013 788
- 19183 787
- 19191 787
- 19061 786
- 19139 786
- 19065 784
- 19087 784
- 19113 784
- 19169 784
- 19033 783
- 19109 783
- 19157 783
- 19163 783
- 19167 783
- 19171 783
- 19193 783
- 19081 782
- 19179 782
- 19019 781
- 19031 781
- 19099 781
- 19181 781
- …
county >30
- Johnson 797
- Pottawattamie 796
- Carroll 793
- Harrison 792
- Dallas 791
- Allamakee 790
- Polk 790
- Adair 788
- Black Hawk 788
- Washington 787
- Winneshiek 787
- Dubuque 786
- Muscatine 786
- Fayette 784
- Henry 784
- Linn 784
- Story 784
- Cerro Gordo 783
- Kossuth 783
- Poweshiek 783
- Scott 783
- Sioux 783
- Tama 783
- Woodbury 783
- Hancock 782
- Wapello 782
- Buchanan 781
- Cedar 781
- Jasper 781
- Warren 781
- …
state 1
- Iowa · 77,070 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
797 | 797 | 2020-03-08 | Johnson | Iowa | 19103 | 3 | 0 |
918 | 918 | 2020-03-09 | Johnson | Iowa | 19103 | 7 | 0 |
919 | 919 | 2020-03-09 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1063 | 1063 | 2020-03-10 | Johnson | Iowa | 19103 | 12 | 0 |
1064 | 1064 | 2020-03-10 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1241 | 1241 | 2020-03-11 | Johnson | Iowa | 19103 | 13 | 0 |
1242 | 1242 | 2020-03-11 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1455 | 1455 | 2020-03-12 | Carroll | Iowa | 19027 | 1 | 0 |
1456 | 1456 | 2020-03-12 | Johnson | Iowa | 19103 | 14 | 0 |
1457 | 1457 | 2020-03-12 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1726 | 1726 | 2020-03-13 | Carroll | Iowa | 19027 | 1 | 0 |
1727 | 1727 | 2020-03-13 | Harrison | Iowa | 19085 | 1 | 0 |
1728 | 1728 | 2020-03-13 | Johnson | Iowa | 19103 | 14 | 0 |
1729 | 1729 | 2020-03-13 | Pottawattamie | Iowa | 19155 | 1 | 0 |
2059 | 2059 | 2020-03-14 | Carroll | Iowa | 19027 | 1 | 0 |
2060 | 2060 | 2020-03-14 | Dallas | Iowa | 19049 | 1 | 0 |
2061 | 2061 | 2020-03-14 | Harrison | Iowa | 19085 | 1 | 0 |
2062 | 2062 | 2020-03-14 | Johnson | Iowa | 19103 | 14 | 0 |
2063 | 2063 | 2020-03-14 | Pottawattamie | Iowa | 19155 | 1 | 0 |
2453 | 2453 | 2020-03-15 | Allamakee | Iowa | 19005 | 2 | 0 |
2454 | 2454 | 2020-03-15 | Carroll | Iowa | 19027 | 1 | 0 |
2455 | 2455 | 2020-03-15 | Dallas | Iowa | 19049 | 1 | 0 |
2456 | 2456 | 2020-03-15 | Harrison | Iowa | 19085 | 1 | 0 |
2457 | 2457 | 2020-03-15 | Johnson | Iowa | 19103 | 15 | 0 |
2458 | 2458 | 2020-03-15 | Polk | Iowa | 19153 | 1 | 0 |
2459 | 2459 | 2020-03-15 | Pottawattamie | Iowa | 19155 | 1 | 0 |
2898 | 2898 | 2020-03-16 | Allamakee | Iowa | 19005 | 2 | 0 |
2899 | 2899 | 2020-03-16 | Carroll | Iowa | 19027 | 1 | 0 |
2900 | 2900 | 2020-03-16 | Dallas | Iowa | 19049 | 1 | 0 |
2901 | 2901 | 2020-03-16 | Harrison | Iowa | 19085 | 1 | 0 |
2902 | 2902 | 2020-03-16 | Johnson | Iowa | 19103 | 15 | 0 |
2903 | 2903 | 2020-03-16 | Polk | Iowa | 19153 | 1 | 0 |
2904 | 2904 | 2020-03-16 | Pottawattamie | Iowa | 19155 | 1 | 0 |
3389 | 3389 | 2020-03-17 | Adair | Iowa | 19001 | 1 | 0 |
3390 | 3390 | 2020-03-17 | Allamakee | Iowa | 19005 | 2 | 0 |
3391 | 3391 | 2020-03-17 | Black Hawk | Iowa | 19013 | 1 | 0 |
3392 | 3392 | 2020-03-17 | Carroll | Iowa | 19027 | 1 | 0 |
3393 | 3393 | 2020-03-17 | Dallas | Iowa | 19049 | 3 | 0 |
3394 | 3394 | 2020-03-17 | Harrison | Iowa | 19085 | 1 | 0 |
3395 | 3395 | 2020-03-17 | Johnson | Iowa | 19103 | 18 | 0 |
3396 | 3396 | 2020-03-17 | Polk | Iowa | 19153 | 1 | 0 |
3397 | 3397 | 2020-03-17 | Pottawattamie | Iowa | 19155 | 1 | 0 |
3963 | 3963 | 2020-03-18 | Adair | Iowa | 19001 | 1 | 0 |
3964 | 3964 | 2020-03-18 | Allamakee | Iowa | 19005 | 2 | 0 |
3965 | 3965 | 2020-03-18 | Black Hawk | Iowa | 19013 | 1 | 0 |
3966 | 3966 | 2020-03-18 | Carroll | Iowa | 19027 | 1 | 0 |
3967 | 3967 | 2020-03-18 | Dallas | Iowa | 19049 | 5 | 0 |
3968 | 3968 | 2020-03-18 | Harrison | Iowa | 19085 | 1 | 0 |
3969 | 3969 | 2020-03-18 | Johnson | Iowa | 19103 | 21 | 0 |
3970 | 3970 | 2020-03-18 | Polk | Iowa | 19153 | 3 | 0 |
3971 | 3971 | 2020-03-18 | Pottawattamie | Iowa | 19155 | 1 | 0 |
3972 | 3972 | 2020-03-18 | Washington | Iowa | 19183 | 1 | 0 |
3973 | 3973 | 2020-03-18 | Winneshiek | Iowa | 19191 | 1 | 0 |
4642 | 4642 | 2020-03-19 | Adair | Iowa | 19001 | 1 | 0 |
4643 | 4643 | 2020-03-19 | Allamakee | Iowa | 19005 | 2 | 0 |
4644 | 4644 | 2020-03-19 | Black Hawk | Iowa | 19013 | 1 | 0 |
4645 | 4645 | 2020-03-19 | Carroll | Iowa | 19027 | 1 | 0 |
4646 | 4646 | 2020-03-19 | Dallas | Iowa | 19049 | 5 | 0 |
4647 | 4647 | 2020-03-19 | Dubuque | Iowa | 19061 | 1 | 0 |
4648 | 4648 | 2020-03-19 | Harrison | Iowa | 19085 | 1 | 0 |
4649 | 4649 | 2020-03-19 | Johnson | Iowa | 19103 | 22 | 0 |
4650 | 4650 | 2020-03-19 | Muscatine | Iowa | 19139 | 1 | 0 |
4651 | 4651 | 2020-03-19 | Polk | Iowa | 19153 | 6 | 0 |
4652 | 4652 | 2020-03-19 | Pottawattamie | Iowa | 19155 | 1 | 0 |
4653 | 4653 | 2020-03-19 | Washington | Iowa | 19183 | 1 | 0 |
4654 | 4654 | 2020-03-19 | Winneshiek | Iowa | 19191 | 1 | 0 |
5453 | 5453 | 2020-03-20 | Adair | Iowa | 19001 | 1 | 0 |
5454 | 5454 | 2020-03-20 | Allamakee | Iowa | 19005 | 3 | 0 |
5455 | 5455 | 2020-03-20 | Black Hawk | Iowa | 19013 | 1 | 0 |
5456 | 5456 | 2020-03-20 | Carroll | Iowa | 19027 | 1 | 0 |
5457 | 5457 | 2020-03-20 | Dallas | Iowa | 19049 | 5 | 0 |
5458 | 5458 | 2020-03-20 | Dubuque | Iowa | 19061 | 1 | 0 |
5459 | 5459 | 2020-03-20 | Harrison | Iowa | 19085 | 1 | 0 |
5460 | 5460 | 2020-03-20 | Johnson | Iowa | 19103 | 22 | 0 |
5461 | 5461 | 2020-03-20 | Muscatine | Iowa | 19139 | 1 | 0 |
5462 | 5462 | 2020-03-20 | Polk | Iowa | 19153 | 6 | 0 |
5463 | 5463 | 2020-03-20 | Pottawattamie | Iowa | 19155 | 1 | 0 |
5464 | 5464 | 2020-03-20 | Washington | Iowa | 19183 | 1 | 0 |
5465 | 5465 | 2020-03-20 | Winneshiek | Iowa | 19191 | 1 | 0 |
6394 | 6394 | 2020-03-21 | Adair | Iowa | 19001 | 1 | 0 |
6395 | 6395 | 2020-03-21 | Allamakee | Iowa | 19005 | 5 | 0 |
6396 | 6396 | 2020-03-21 | Black Hawk | Iowa | 19013 | 3 | 0 |
6397 | 6397 | 2020-03-21 | Carroll | Iowa | 19027 | 1 | 0 |
6398 | 6398 | 2020-03-21 | Dallas | Iowa | 19049 | 5 | 0 |
6399 | 6399 | 2020-03-21 | Dubuque | Iowa | 19061 | 2 | 0 |
6400 | 6400 | 2020-03-21 | Fayette | Iowa | 19065 | 1 | 0 |
6401 | 6401 | 2020-03-21 | Harrison | Iowa | 19085 | 1 | 0 |
6402 | 6402 | 2020-03-21 | Henry | Iowa | 19087 | 1 | 0 |
6403 | 6403 | 2020-03-21 | Johnson | Iowa | 19103 | 27 | 0 |
6404 | 6404 | 2020-03-21 | Linn | Iowa | 19113 | 3 | 0 |
6405 | 6405 | 2020-03-21 | Muscatine | Iowa | 19139 | 2 | 0 |
6406 | 6406 | 2020-03-21 | Polk | Iowa | 19153 | 10 | 0 |
6407 | 6407 | 2020-03-21 | Pottawattamie | Iowa | 19155 | 2 | 0 |
6408 | 6408 | 2020-03-21 | Story | Iowa | 19169 | 1 | 0 |
6409 | 6409 | 2020-03-21 | Washington | Iowa | 19183 | 2 | 0 |
6410 | 6410 | 2020-03-21 | Winneshiek | Iowa | 19191 | 1 | 0 |
7454 | 7454 | 2020-03-22 | Adair | Iowa | 19001 | 1 | 0 |
7455 | 7455 | 2020-03-22 | Allamakee | Iowa | 19005 | 5 | 0 |
7456 | 7456 | 2020-03-22 | Black Hawk | Iowa | 19013 | 3 | 0 |
7457 | 7457 | 2020-03-22 | Carroll | Iowa | 19027 | 1 | 0 |
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);