ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,558 rows where county = "Iowa" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
14553 | 14553 | 2020-03-27 | Iowa | Iowa | 19095 | 1 | 0 |
16357 | 16357 | 2020-03-28 | Iowa | Iowa | 19095 | 1 | 0 |
18262 | 18262 | 2020-03-29 | Iowa | Iowa | 19095 | 2 | 0 |
12337 | 12337 | 2020-03-25 | Iowa | Wisconsin | 55049 | 3 | 0 |
13991 | 13991 | 2020-03-26 | Iowa | Wisconsin | 55049 | 3 | 0 |
15763 | 15763 | 2020-03-27 | Iowa | Wisconsin | 55049 | 3 | 0 |
17643 | 17643 | 2020-03-28 | Iowa | Wisconsin | 55049 | 3 | 0 |
19612 | 19612 | 2020-03-29 | Iowa | Wisconsin | 55049 | 3 | 0 |
20271 | 20271 | 2020-03-30 | Iowa | Iowa | 19095 | 3 | 0 |
21682 | 21682 | 2020-03-30 | Iowa | Wisconsin | 55049 | 3 | 0 |
23834 | 23834 | 2020-03-31 | Iowa | Wisconsin | 55049 | 3 | 0 |
26054 | 26054 | 2020-04-01 | Iowa | Wisconsin | 55049 | 3 | 0 |
28347 | 28347 | 2020-04-02 | Iowa | Wisconsin | 55049 | 3 | 0 |
30702 | 30702 | 2020-04-03 | Iowa | Wisconsin | 55049 | 3 | 0 |
33103 | 33103 | 2020-04-04 | Iowa | Wisconsin | 55049 | 3 | 0 |
35542 | 35542 | 2020-04-05 | Iowa | Wisconsin | 55049 | 3 | 0 |
38028 | 38028 | 2020-04-06 | Iowa | Wisconsin | 55049 | 3 | 0 |
22367 | 22367 | 2020-03-31 | Iowa | Iowa | 19095 | 4 | 0 |
40569 | 40569 | 2020-04-07 | Iowa | Wisconsin | 55049 | 4 | 0 |
43141 | 43141 | 2020-04-08 | Iowa | Wisconsin | 55049 | 4 | 0 |
45738 | 45738 | 2020-04-09 | Iowa | Wisconsin | 55049 | 4 | 0 |
48366 | 48366 | 2020-04-10 | Iowa | Wisconsin | 55049 | 4 | 0 |
51026 | 51026 | 2020-04-11 | Iowa | Wisconsin | 55049 | 4 | 0 |
24539 | 24539 | 2020-04-01 | Iowa | Iowa | 19095 | 5 | 0 |
26780 | 26780 | 2020-04-02 | Iowa | Iowa | 19095 | 5 | 0 |
29091 | 29091 | 2020-04-03 | Iowa | Iowa | 19095 | 5 | 0 |
53703 | 53703 | 2020-04-12 | Iowa | Wisconsin | 55049 | 5 | 0 |
56394 | 56394 | 2020-04-13 | Iowa | Wisconsin | 55049 | 5 | 0 |
59101 | 59101 | 2020-04-14 | Iowa | Wisconsin | 55049 | 5 | 0 |
61820 | 61820 | 2020-04-15 | Iowa | Wisconsin | 55049 | 5 | 0 |
64553 | 64553 | 2020-04-16 | Iowa | Wisconsin | 55049 | 5 | 0 |
31461 | 31461 | 2020-04-04 | Iowa | Iowa | 19095 | 6 | 0 |
33874 | 33874 | 2020-04-05 | Iowa | Iowa | 19095 | 6 | 0 |
36329 | 36329 | 2020-04-06 | Iowa | Iowa | 19095 | 6 | 0 |
38830 | 38830 | 2020-04-07 | Iowa | Iowa | 19095 | 6 | 0 |
41376 | 41376 | 2020-04-08 | Iowa | Iowa | 19095 | 6 | 0 |
67301 | 67301 | 2020-04-17 | Iowa | Wisconsin | 55049 | 6 | 0 |
70063 | 70063 | 2020-04-18 | Iowa | Wisconsin | 55049 | 6 | 0 |
72832 | 72832 | 2020-04-19 | Iowa | Wisconsin | 55049 | 6 | 0 |
75608 | 75608 | 2020-04-20 | Iowa | Wisconsin | 55049 | 6 | 0 |
43952 | 43952 | 2020-04-09 | Iowa | Iowa | 19095 | 7 | 0 |
46557 | 46557 | 2020-04-10 | Iowa | Iowa | 19095 | 7 | 0 |
49191 | 49191 | 2020-04-11 | Iowa | Iowa | 19095 | 7 | 0 |
51855 | 51855 | 2020-04-12 | Iowa | Iowa | 19095 | 7 | 0 |
54537 | 54537 | 2020-04-13 | Iowa | Iowa | 19095 | 7 | 0 |
57230 | 57230 | 2020-04-14 | Iowa | Iowa | 19095 | 7 | 0 |
59938 | 59938 | 2020-04-15 | Iowa | Iowa | 19095 | 7 | 0 |
78391 | 78391 | 2020-04-21 | Iowa | Wisconsin | 55049 | 7 | 0 |
81184 | 81184 | 2020-04-22 | Iowa | Wisconsin | 55049 | 7 | 0 |
83985 | 83985 | 2020-04-23 | Iowa | Wisconsin | 55049 | 7 | 0 |
86792 | 86792 | 2020-04-24 | Iowa | Wisconsin | 55049 | 7 | 0 |
89608 | 89608 | 2020-04-25 | Iowa | Wisconsin | 55049 | 7 | 0 |
92426 | 92426 | 2020-04-26 | Iowa | Wisconsin | 55049 | 7 | 0 |
95256 | 95256 | 2020-04-27 | Iowa | Wisconsin | 55049 | 7 | 0 |
98101 | 98101 | 2020-04-28 | Iowa | Wisconsin | 55049 | 7 | 0 |
100951 | 100951 | 2020-04-29 | Iowa | Wisconsin | 55049 | 7 | 0 |
103806 | 103806 | 2020-04-30 | Iowa | Wisconsin | 55049 | 7 | 0 |
106670 | 106670 | 2020-05-01 | Iowa | Wisconsin | 55049 | 7 | 0 |
109539 | 109539 | 2020-05-02 | Iowa | Wisconsin | 55049 | 7 | 0 |
112414 | 112414 | 2020-05-03 | Iowa | Wisconsin | 55049 | 7 | 0 |
115297 | 115297 | 2020-05-04 | Iowa | Wisconsin | 55049 | 7 | 0 |
118256 | 118256 | 2020-05-05 | Iowa | Wisconsin | 55049 | 7 | 0 |
62659 | 62659 | 2020-04-16 | Iowa | Iowa | 19095 | 8 | 0 |
65393 | 65393 | 2020-04-17 | Iowa | Iowa | 19095 | 8 | 0 |
68142 | 68142 | 2020-04-18 | Iowa | Iowa | 19095 | 10 | 0 |
121222 | 121222 | 2020-05-06 | Iowa | Wisconsin | 55049 | 10 | 0 |
124202 | 124202 | 2020-05-07 | Iowa | Wisconsin | 55049 | 10 | 0 |
127187 | 127187 | 2020-05-08 | Iowa | Wisconsin | 55049 | 10 | 0 |
130177 | 130177 | 2020-05-09 | Iowa | Wisconsin | 55049 | 10 | 0 |
133167 | 133167 | 2020-05-10 | Iowa | Wisconsin | 55049 | 10 | 0 |
136157 | 136157 | 2020-05-11 | Iowa | Wisconsin | 55049 | 10 | 0 |
139148 | 139148 | 2020-05-12 | Iowa | Wisconsin | 55049 | 10 | 0 |
142144 | 142144 | 2020-05-13 | Iowa | Wisconsin | 55049 | 10 | 0 |
145142 | 145142 | 2020-05-14 | Iowa | Wisconsin | 55049 | 11 | 0 |
148145 | 148145 | 2020-05-15 | Iowa | Wisconsin | 55049 | 11 | 0 |
151154 | 151154 | 2020-05-16 | Iowa | Wisconsin | 55049 | 11 | 0 |
154166 | 154166 | 2020-05-17 | Iowa | Wisconsin | 55049 | 11 | 0 |
157182 | 157182 | 2020-05-18 | Iowa | Wisconsin | 55049 | 11 | 0 |
160206 | 160206 | 2020-05-19 | Iowa | Wisconsin | 55049 | 11 | 0 |
163234 | 163234 | 2020-05-20 | Iowa | Wisconsin | 55049 | 11 | 0 |
166263 | 166263 | 2020-05-21 | Iowa | Wisconsin | 55049 | 11 | 0 |
169299 | 169299 | 2020-05-22 | Iowa | Wisconsin | 55049 | 11 | 0 |
172340 | 172340 | 2020-05-23 | Iowa | Wisconsin | 55049 | 11 | 0 |
175383 | 175383 | 2020-05-24 | Iowa | Wisconsin | 55049 | 11 | 0 |
70904 | 70904 | 2020-04-19 | Iowa | Iowa | 19095 | 12 | 0 |
178428 | 178428 | 2020-05-25 | Iowa | Wisconsin | 55049 | 12 | 0 |
181472 | 181472 | 2020-05-26 | Iowa | Wisconsin | 55049 | 12 | 0 |
184523 | 184523 | 2020-05-27 | Iowa | Wisconsin | 55049 | 12 | 0 |
73675 | 73675 | 2020-04-20 | Iowa | Iowa | 19095 | 13 | 0 |
76454 | 76454 | 2020-04-21 | Iowa | Iowa | 19095 | 13 | 0 |
79238 | 79238 | 2020-04-22 | Iowa | Iowa | 19095 | 13 | 0 |
82031 | 82031 | 2020-04-23 | Iowa | Iowa | 19095 | 13 | 0 |
84831 | 84831 | 2020-04-24 | Iowa | Iowa | 19095 | 14 | 0 |
187580 | 187580 | 2020-05-28 | Iowa | Wisconsin | 55049 | 14 | 0 |
190644 | 190644 | 2020-05-29 | Iowa | Wisconsin | 55049 | 15 | 0 |
87641 | 87641 | 2020-04-25 | Iowa | Iowa | 19095 | 16 | 0 |
193710 | 193710 | 2020-05-30 | Iowa | Wisconsin | 55049 | 16 | 0 |
196780 | 196780 | 2020-05-31 | Iowa | Wisconsin | 55049 | 16 | 0 |
199853 | 199853 | 2020-06-01 | Iowa | Wisconsin | 55049 | 16 | 0 |
202929 | 202929 | 2020-06-02 | Iowa | Wisconsin | 55049 | 16 | 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);