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 cases
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 |
---|---|---|---|---|---|---|---|
79273 | 79273 | 2020-04-22 | Unknown | Iowa | 0 | 2 | |
84866 | 84866 | 2020-04-24 | Unknown | Iowa | 0 | 1 | |
919 | 919 | 2020-03-09 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1064 | 1064 | 2020-03-10 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1242 | 1242 | 2020-03-11 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1455 | 1455 | 2020-03-12 | Carroll | Iowa | 19027 | 1 | 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 |
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 |
2063 | 2063 | 2020-03-14 | Pottawattamie | Iowa | 19155 | 1 | 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 |
2458 | 2458 | 2020-03-15 | Polk | Iowa | 19153 | 1 | 0 |
2459 | 2459 | 2020-03-15 | Pottawattamie | Iowa | 19155 | 1 | 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 |
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 |
3391 | 3391 | 2020-03-17 | Black Hawk | Iowa | 19013 | 1 | 0 |
3392 | 3392 | 2020-03-17 | Carroll | Iowa | 19027 | 1 | 0 |
3394 | 3394 | 2020-03-17 | Harrison | Iowa | 19085 | 1 | 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 |
3965 | 3965 | 2020-03-18 | Black Hawk | Iowa | 19013 | 1 | 0 |
3966 | 3966 | 2020-03-18 | Carroll | Iowa | 19027 | 1 | 0 |
3968 | 3968 | 2020-03-18 | Harrison | Iowa | 19085 | 1 | 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 |
4644 | 4644 | 2020-03-19 | Black Hawk | Iowa | 19013 | 1 | 0 |
4645 | 4645 | 2020-03-19 | Carroll | Iowa | 19027 | 1 | 0 |
4647 | 4647 | 2020-03-19 | Dubuque | Iowa | 19061 | 1 | 0 |
4648 | 4648 | 2020-03-19 | Harrison | Iowa | 19085 | 1 | 0 |
4650 | 4650 | 2020-03-19 | Muscatine | Iowa | 19139 | 1 | 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 |
5455 | 5455 | 2020-03-20 | Black Hawk | Iowa | 19013 | 1 | 0 |
5456 | 5456 | 2020-03-20 | Carroll | Iowa | 19027 | 1 | 0 |
5458 | 5458 | 2020-03-20 | Dubuque | Iowa | 19061 | 1 | 0 |
5459 | 5459 | 2020-03-20 | Harrison | Iowa | 19085 | 1 | 0 |
5461 | 5461 | 2020-03-20 | Muscatine | Iowa | 19139 | 1 | 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 |
6397 | 6397 | 2020-03-21 | Carroll | Iowa | 19027 | 1 | 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 |
6408 | 6408 | 2020-03-21 | Story | Iowa | 19169 | 1 | 0 |
6410 | 6410 | 2020-03-21 | Winneshiek | Iowa | 19191 | 1 | 0 |
7454 | 7454 | 2020-03-22 | Adair | Iowa | 19001 | 1 | 0 |
7457 | 7457 | 2020-03-22 | Carroll | Iowa | 19027 | 1 | 0 |
7461 | 7461 | 2020-03-22 | Fayette | Iowa | 19065 | 1 | 0 |
7463 | 7463 | 2020-03-22 | Henry | Iowa | 19087 | 1 | 0 |
7465 | 7465 | 2020-03-22 | Kossuth | Iowa | 19109 | 1 | 0 |
7470 | 7470 | 2020-03-22 | Poweshiek | Iowa | 19157 | 1 | 0 |
7471 | 7471 | 2020-03-22 | Scott | Iowa | 19163 | 1 | 0 |
7472 | 7472 | 2020-03-22 | Sioux | Iowa | 19167 | 1 | 0 |
7473 | 7473 | 2020-03-22 | Story | Iowa | 19169 | 1 | 0 |
7476 | 7476 | 2020-03-22 | Winneshiek | Iowa | 19191 | 1 | 0 |
7477 | 7477 | 2020-03-22 | Woodbury | Iowa | 19193 | 1 | 0 |
8612 | 8612 | 2020-03-23 | Adair | Iowa | 19001 | 1 | 0 |
8615 | 8615 | 2020-03-23 | Carroll | Iowa | 19027 | 1 | 0 |
8619 | 8619 | 2020-03-23 | Fayette | Iowa | 19065 | 1 | 0 |
8622 | 8622 | 2020-03-23 | Henry | Iowa | 19087 | 1 | 0 |
8624 | 8624 | 2020-03-23 | Kossuth | Iowa | 19109 | 1 | 0 |
8629 | 8629 | 2020-03-23 | Poweshiek | Iowa | 19157 | 1 | 0 |
8630 | 8630 | 2020-03-23 | Scott | Iowa | 19163 | 1 | 0 |
8631 | 8631 | 2020-03-23 | Sioux | Iowa | 19167 | 1 | 0 |
8632 | 8632 | 2020-03-23 | Story | Iowa | 19169 | 1 | 0 |
8634 | 8634 | 2020-03-23 | Wapello | Iowa | 19179 | 1 | 0 |
8636 | 8636 | 2020-03-23 | Winneshiek | Iowa | 19191 | 1 | 0 |
9888 | 9888 | 2020-03-24 | Adair | Iowa | 19001 | 1 | 0 |
9891 | 9891 | 2020-03-24 | Buchanan | Iowa | 19019 | 1 | 0 |
9892 | 9892 | 2020-03-24 | Carroll | Iowa | 19027 | 1 | 0 |
9893 | 9893 | 2020-03-24 | Cedar | Iowa | 19031 | 1 | 0 |
9897 | 9897 | 2020-03-24 | Fayette | Iowa | 19065 | 1 | 0 |
9900 | 9900 | 2020-03-24 | Henry | Iowa | 19087 | 1 | 0 |
9901 | 9901 | 2020-03-24 | Jasper | Iowa | 19099 | 1 | 0 |
9903 | 9903 | 2020-03-24 | Kossuth | Iowa | 19109 | 1 | 0 |
9909 | 9909 | 2020-03-24 | Scott | Iowa | 19163 | 1 | 0 |
9910 | 9910 | 2020-03-24 | Sioux | Iowa | 19167 | 1 | 0 |
9913 | 9913 | 2020-03-24 | Wapello | Iowa | 19179 | 1 | 0 |
9914 | 9914 | 2020-03-24 | Warren | Iowa | 19181 | 1 | 0 |
9916 | 9916 | 2020-03-24 | Winneshiek | Iowa | 19191 | 1 | 0 |
11284 | 11284 | 2020-03-25 | Adair | Iowa | 19001 | 1 | 0 |
11288 | 11288 | 2020-03-25 | Buchanan | Iowa | 19019 | 1 | 0 |
11289 | 11289 | 2020-03-25 | 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);