ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 19121 and state = "Iowa" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
24547 | 24547 | 2020-04-01 | Madison | Iowa | 19121 | 1 | 0 |
26789 | 26789 | 2020-04-02 | Madison | Iowa | 19121 | 1 | 0 |
29102 | 29102 | 2020-04-03 | Madison | Iowa | 19121 | 1 | 0 |
31473 | 31473 | 2020-04-04 | Madison | Iowa | 19121 | 1 | 0 |
33886 | 33886 | 2020-04-05 | Madison | Iowa | 19121 | 1 | 0 |
36341 | 36341 | 2020-04-06 | Madison | Iowa | 19121 | 1 | 0 |
38842 | 38842 | 2020-04-07 | Madison | Iowa | 19121 | 1 | 0 |
41388 | 41388 | 2020-04-08 | Madison | Iowa | 19121 | 1 | 0 |
43964 | 43964 | 2020-04-09 | Madison | Iowa | 19121 | 1 | 0 |
46569 | 46569 | 2020-04-10 | Madison | Iowa | 19121 | 1 | 0 |
49203 | 49203 | 2020-04-11 | Madison | Iowa | 19121 | 2 | 1 |
51867 | 51867 | 2020-04-12 | Madison | Iowa | 19121 | 2 | 1 |
54549 | 54549 | 2020-04-13 | Madison | Iowa | 19121 | 2 | 1 |
57242 | 57242 | 2020-04-14 | Madison | Iowa | 19121 | 3 | 1 |
59950 | 59950 | 2020-04-15 | Madison | Iowa | 19121 | 3 | 1 |
62671 | 62671 | 2020-04-16 | Madison | Iowa | 19121 | 3 | 1 |
65405 | 65405 | 2020-04-17 | Madison | Iowa | 19121 | 3 | 1 |
68154 | 68154 | 2020-04-18 | Madison | Iowa | 19121 | 3 | 1 |
70916 | 70916 | 2020-04-19 | Madison | Iowa | 19121 | 3 | 1 |
73687 | 73687 | 2020-04-20 | Madison | Iowa | 19121 | 3 | 1 |
76466 | 76466 | 2020-04-21 | Madison | Iowa | 19121 | 4 | 1 |
79250 | 79250 | 2020-04-22 | Madison | Iowa | 19121 | 4 | 1 |
82043 | 82043 | 2020-04-23 | Madison | Iowa | 19121 | 3 | 1 |
84843 | 84843 | 2020-04-24 | Madison | Iowa | 19121 | 3 | 1 |
87653 | 87653 | 2020-04-25 | Madison | Iowa | 19121 | 3 | 1 |
90469 | 90469 | 2020-04-26 | Madison | Iowa | 19121 | 3 | 1 |
93288 | 93288 | 2020-04-27 | Madison | Iowa | 19121 | 3 | 1 |
96120 | 96120 | 2020-04-28 | Madison | Iowa | 19121 | 4 | 1 |
98965 | 98965 | 2020-04-29 | Madison | Iowa | 19121 | 5 | 1 |
101816 | 101816 | 2020-04-30 | Madison | Iowa | 19121 | 5 | 1 |
104674 | 104674 | 2020-05-01 | Madison | Iowa | 19121 | 8 | 1 |
107539 | 107539 | 2020-05-02 | Madison | Iowa | 19121 | 8 | 1 |
110409 | 110409 | 2020-05-03 | Madison | Iowa | 19121 | 9 | 1 |
113284 | 113284 | 2020-05-04 | Madison | Iowa | 19121 | 9 | 1 |
116167 | 116167 | 2020-05-05 | Madison | Iowa | 19121 | 9 | 1 |
119127 | 119127 | 2020-05-06 | Madison | Iowa | 19121 | 10 | 1 |
122097 | 122097 | 2020-05-07 | Madison | Iowa | 19121 | 10 | 1 |
125078 | 125078 | 2020-05-08 | Madison | Iowa | 19121 | 10 | 1 |
128065 | 128065 | 2020-05-09 | Madison | Iowa | 19121 | 11 | 1 |
131056 | 131056 | 2020-05-10 | Madison | Iowa | 19121 | 11 | 1 |
134046 | 134046 | 2020-05-11 | Madison | Iowa | 19121 | 11 | 1 |
137036 | 137036 | 2020-05-12 | Madison | Iowa | 19121 | 12 | 1 |
140029 | 140029 | 2020-05-13 | Madison | Iowa | 19121 | 13 | 1 |
143025 | 143025 | 2020-05-14 | Madison | Iowa | 19121 | 13 | 1 |
146025 | 146025 | 2020-05-15 | Madison | Iowa | 19121 | 14 | 1 |
149029 | 149029 | 2020-05-16 | Madison | Iowa | 19121 | 16 | 1 |
152040 | 152040 | 2020-05-17 | Madison | Iowa | 19121 | 16 | 1 |
155052 | 155052 | 2020-05-18 | Madison | Iowa | 19121 | 16 | 1 |
158068 | 158068 | 2020-05-19 | Madison | Iowa | 19121 | 16 | 1 |
161094 | 161094 | 2020-05-20 | Madison | Iowa | 19121 | 20 | 1 |
164122 | 164122 | 2020-05-21 | Madison | Iowa | 19121 | 21 | 1 |
167155 | 167155 | 2020-05-22 | Madison | Iowa | 19121 | 21 | 1 |
170192 | 170192 | 2020-05-23 | Madison | Iowa | 19121 | 21 | 1 |
173233 | 173233 | 2020-05-24 | Madison | Iowa | 19121 | 24 | 1 |
176277 | 176277 | 2020-05-25 | Madison | Iowa | 19121 | 24 | 1 |
179321 | 179321 | 2020-05-26 | Madison | Iowa | 19121 | 25 | 1 |
182366 | 182366 | 2020-05-27 | Madison | Iowa | 19121 | 25 | 1 |
185420 | 185420 | 2020-05-28 | Madison | Iowa | 19121 | 27 | 1 |
188478 | 188478 | 2020-05-29 | Madison | Iowa | 19121 | 27 | 1 |
191543 | 191543 | 2020-05-30 | Madison | Iowa | 19121 | 28 | 2 |
194610 | 194610 | 2020-05-31 | Madison | Iowa | 19121 | 29 | 2 |
197680 | 197680 | 2020-06-01 | Madison | Iowa | 19121 | 29 | 2 |
200753 | 200753 | 2020-06-02 | Madison | Iowa | 19121 | 30 | 2 |
203829 | 203829 | 2020-06-03 | Madison | Iowa | 19121 | 29 | 2 |
206909 | 206909 | 2020-06-04 | Madison | Iowa | 19121 | 29 | 2 |
209990 | 209990 | 2020-06-05 | Madison | Iowa | 19121 | 29 | 2 |
213075 | 213075 | 2020-06-06 | Madison | Iowa | 19121 | 29 | 2 |
216162 | 216162 | 2020-06-07 | Madison | Iowa | 19121 | 29 | 2 |
219254 | 219254 | 2020-06-08 | Madison | Iowa | 19121 | 29 | 2 |
222349 | 222349 | 2020-06-09 | Madison | Iowa | 19121 | 29 | 2 |
225444 | 225444 | 2020-06-10 | Madison | Iowa | 19121 | 30 | 2 |
228546 | 228546 | 2020-06-11 | Madison | Iowa | 19121 | 32 | 2 |
231649 | 231649 | 2020-06-12 | Madison | Iowa | 19121 | 31 | 2 |
234755 | 234755 | 2020-06-13 | Madison | Iowa | 19121 | 34 | 2 |
237862 | 237862 | 2020-06-14 | Madison | Iowa | 19121 | 34 | 2 |
240970 | 240970 | 2020-06-15 | Madison | Iowa | 19121 | 34 | 2 |
244081 | 244081 | 2020-06-16 | Madison | Iowa | 19121 | 34 | 2 |
247194 | 247194 | 2020-06-17 | Madison | Iowa | 19121 | 34 | 2 |
250306 | 250306 | 2020-06-18 | Madison | Iowa | 19121 | 34 | 2 |
253421 | 253421 | 2020-06-19 | Madison | Iowa | 19121 | 34 | 2 |
256541 | 256541 | 2020-06-20 | Madison | Iowa | 19121 | 34 | 2 |
259667 | 259667 | 2020-06-21 | Madison | Iowa | 19121 | 35 | 2 |
262794 | 262794 | 2020-06-22 | Madison | Iowa | 19121 | 35 | 2 |
265922 | 265922 | 2020-06-23 | Madison | Iowa | 19121 | 35 | 2 |
269052 | 269052 | 2020-06-24 | Madison | Iowa | 19121 | 35 | 2 |
272189 | 272189 | 2020-06-25 | Madison | Iowa | 19121 | 35 | 2 |
275331 | 275331 | 2020-06-26 | Madison | Iowa | 19121 | 35 | 2 |
278479 | 278479 | 2020-06-27 | Madison | Iowa | 19121 | 36 | 2 |
281627 | 281627 | 2020-06-28 | Madison | Iowa | 19121 | 37 | 2 |
284772 | 284772 | 2020-06-29 | Madison | Iowa | 19121 | 37 | 2 |
287921 | 287921 | 2020-06-30 | Madison | Iowa | 19121 | 37 | 2 |
291071 | 291071 | 2020-07-01 | Madison | Iowa | 19121 | 38 | 2 |
294225 | 294225 | 2020-07-02 | Madison | Iowa | 19121 | 40 | 2 |
297383 | 297383 | 2020-07-03 | Madison | Iowa | 19121 | 43 | 2 |
300545 | 300545 | 2020-07-04 | Madison | Iowa | 19121 | 46 | 2 |
303709 | 303709 | 2020-07-05 | Madison | Iowa | 19121 | 47 | 2 |
306874 | 306874 | 2020-07-06 | Madison | Iowa | 19121 | 48 | 2 |
310042 | 310042 | 2020-07-07 | Madison | Iowa | 19121 | 48 | 2 |
313212 | 313212 | 2020-07-08 | Madison | Iowa | 19121 | 50 | 2 |
316386 | 316386 | 2020-07-09 | Madison | Iowa | 19121 | 51 | 2 |
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);