ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 19131 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 |
---|---|---|---|---|---|---|---|
24550 | 24550 | 2020-04-01 | Mitchell | Iowa | 19131 | 2 | 0 |
26792 | 26792 | 2020-04-02 | Mitchell | Iowa | 19131 | 2 | 0 |
29105 | 29105 | 2020-04-03 | Mitchell | Iowa | 19131 | 2 | 0 |
31477 | 31477 | 2020-04-04 | Mitchell | Iowa | 19131 | 2 | 0 |
33890 | 33890 | 2020-04-05 | Mitchell | Iowa | 19131 | 2 | 0 |
36346 | 36346 | 2020-04-06 | Mitchell | Iowa | 19131 | 2 | 0 |
38847 | 38847 | 2020-04-07 | Mitchell | Iowa | 19131 | 2 | 0 |
41393 | 41393 | 2020-04-08 | Mitchell | Iowa | 19131 | 2 | 0 |
43969 | 43969 | 2020-04-09 | Mitchell | Iowa | 19131 | 2 | 0 |
46574 | 46574 | 2020-04-10 | Mitchell | Iowa | 19131 | 2 | 0 |
49208 | 49208 | 2020-04-11 | Mitchell | Iowa | 19131 | 2 | 0 |
51872 | 51872 | 2020-04-12 | Mitchell | Iowa | 19131 | 2 | 0 |
54554 | 54554 | 2020-04-13 | Mitchell | Iowa | 19131 | 2 | 0 |
57247 | 57247 | 2020-04-14 | Mitchell | Iowa | 19131 | 2 | 0 |
59955 | 59955 | 2020-04-15 | Mitchell | Iowa | 19131 | 2 | 0 |
62676 | 62676 | 2020-04-16 | Mitchell | Iowa | 19131 | 2 | 0 |
65410 | 65410 | 2020-04-17 | Mitchell | Iowa | 19131 | 2 | 0 |
68159 | 68159 | 2020-04-18 | Mitchell | Iowa | 19131 | 2 | 0 |
70921 | 70921 | 2020-04-19 | Mitchell | Iowa | 19131 | 2 | 0 |
73692 | 73692 | 2020-04-20 | Mitchell | Iowa | 19131 | 2 | 0 |
76471 | 76471 | 2020-04-21 | Mitchell | Iowa | 19131 | 2 | 0 |
79255 | 79255 | 2020-04-22 | Mitchell | Iowa | 19131 | 2 | 0 |
82048 | 82048 | 2020-04-23 | Mitchell | Iowa | 19131 | 2 | 0 |
84848 | 84848 | 2020-04-24 | Mitchell | Iowa | 19131 | 2 | 0 |
87658 | 87658 | 2020-04-25 | Mitchell | Iowa | 19131 | 2 | 0 |
90474 | 90474 | 2020-04-26 | Mitchell | Iowa | 19131 | 2 | 0 |
93293 | 93293 | 2020-04-27 | Mitchell | Iowa | 19131 | 2 | 0 |
96125 | 96125 | 2020-04-28 | Mitchell | Iowa | 19131 | 2 | 0 |
98970 | 98970 | 2020-04-29 | Mitchell | Iowa | 19131 | 2 | 0 |
101821 | 101821 | 2020-04-30 | Mitchell | Iowa | 19131 | 2 | 0 |
104679 | 104679 | 2020-05-01 | Mitchell | Iowa | 19131 | 3 | 0 |
107544 | 107544 | 2020-05-02 | Mitchell | Iowa | 19131 | 3 | 0 |
110414 | 110414 | 2020-05-03 | Mitchell | Iowa | 19131 | 3 | 0 |
113289 | 113289 | 2020-05-04 | Mitchell | Iowa | 19131 | 3 | 0 |
116172 | 116172 | 2020-05-05 | Mitchell | Iowa | 19131 | 3 | 0 |
119132 | 119132 | 2020-05-06 | Mitchell | Iowa | 19131 | 3 | 0 |
122102 | 122102 | 2020-05-07 | Mitchell | Iowa | 19131 | 3 | 0 |
125083 | 125083 | 2020-05-08 | Mitchell | Iowa | 19131 | 3 | 0 |
128070 | 128070 | 2020-05-09 | Mitchell | Iowa | 19131 | 3 | 0 |
131061 | 131061 | 2020-05-10 | Mitchell | Iowa | 19131 | 3 | 0 |
134051 | 134051 | 2020-05-11 | Mitchell | Iowa | 19131 | 3 | 0 |
137041 | 137041 | 2020-05-12 | Mitchell | Iowa | 19131 | 3 | 0 |
140034 | 140034 | 2020-05-13 | Mitchell | Iowa | 19131 | 3 | 0 |
143030 | 143030 | 2020-05-14 | Mitchell | Iowa | 19131 | 3 | 0 |
146030 | 146030 | 2020-05-15 | Mitchell | Iowa | 19131 | 4 | 0 |
149034 | 149034 | 2020-05-16 | Mitchell | Iowa | 19131 | 4 | 0 |
152045 | 152045 | 2020-05-17 | Mitchell | Iowa | 19131 | 4 | 0 |
155057 | 155057 | 2020-05-18 | Mitchell | Iowa | 19131 | 4 | 0 |
158073 | 158073 | 2020-05-19 | Mitchell | Iowa | 19131 | 4 | 0 |
161099 | 161099 | 2020-05-20 | Mitchell | Iowa | 19131 | 4 | 0 |
164127 | 164127 | 2020-05-21 | Mitchell | Iowa | 19131 | 5 | 0 |
167160 | 167160 | 2020-05-22 | Mitchell | Iowa | 19131 | 5 | 0 |
170197 | 170197 | 2020-05-23 | Mitchell | Iowa | 19131 | 5 | 0 |
173238 | 173238 | 2020-05-24 | Mitchell | Iowa | 19131 | 4 | 0 |
176282 | 176282 | 2020-05-25 | Mitchell | Iowa | 19131 | 4 | 0 |
179326 | 179326 | 2020-05-26 | Mitchell | Iowa | 19131 | 4 | 0 |
182371 | 182371 | 2020-05-27 | Mitchell | Iowa | 19131 | 5 | 0 |
185425 | 185425 | 2020-05-28 | Mitchell | Iowa | 19131 | 5 | 0 |
188483 | 188483 | 2020-05-29 | Mitchell | Iowa | 19131 | 4 | 0 |
191548 | 191548 | 2020-05-30 | Mitchell | Iowa | 19131 | 4 | 0 |
194615 | 194615 | 2020-05-31 | Mitchell | Iowa | 19131 | 4 | 0 |
197685 | 197685 | 2020-06-01 | Mitchell | Iowa | 19131 | 4 | 0 |
200758 | 200758 | 2020-06-02 | Mitchell | Iowa | 19131 | 4 | 0 |
203834 | 203834 | 2020-06-03 | Mitchell | Iowa | 19131 | 4 | 0 |
206914 | 206914 | 2020-06-04 | Mitchell | Iowa | 19131 | 4 | 0 |
209995 | 209995 | 2020-06-05 | Mitchell | Iowa | 19131 | 4 | 0 |
213080 | 213080 | 2020-06-06 | Mitchell | Iowa | 19131 | 4 | 0 |
216167 | 216167 | 2020-06-07 | Mitchell | Iowa | 19131 | 4 | 0 |
219259 | 219259 | 2020-06-08 | Mitchell | Iowa | 19131 | 5 | 0 |
222354 | 222354 | 2020-06-09 | Mitchell | Iowa | 19131 | 5 | 0 |
225449 | 225449 | 2020-06-10 | Mitchell | Iowa | 19131 | 6 | 0 |
228551 | 228551 | 2020-06-11 | Mitchell | Iowa | 19131 | 6 | 0 |
231654 | 231654 | 2020-06-12 | Mitchell | Iowa | 19131 | 6 | 0 |
234760 | 234760 | 2020-06-13 | Mitchell | Iowa | 19131 | 7 | 0 |
237867 | 237867 | 2020-06-14 | Mitchell | Iowa | 19131 | 7 | 0 |
240975 | 240975 | 2020-06-15 | Mitchell | Iowa | 19131 | 8 | 0 |
244086 | 244086 | 2020-06-16 | Mitchell | Iowa | 19131 | 8 | 0 |
247199 | 247199 | 2020-06-17 | Mitchell | Iowa | 19131 | 9 | 0 |
250311 | 250311 | 2020-06-18 | Mitchell | Iowa | 19131 | 8 | 0 |
253426 | 253426 | 2020-06-19 | Mitchell | Iowa | 19131 | 9 | 0 |
256546 | 256546 | 2020-06-20 | Mitchell | Iowa | 19131 | 8 | 0 |
259672 | 259672 | 2020-06-21 | Mitchell | Iowa | 19131 | 8 | 0 |
262799 | 262799 | 2020-06-22 | Mitchell | Iowa | 19131 | 9 | 0 |
265927 | 265927 | 2020-06-23 | Mitchell | Iowa | 19131 | 9 | 0 |
269057 | 269057 | 2020-06-24 | Mitchell | Iowa | 19131 | 9 | 0 |
272194 | 272194 | 2020-06-25 | Mitchell | Iowa | 19131 | 15 | 0 |
275336 | 275336 | 2020-06-26 | Mitchell | Iowa | 19131 | 16 | 0 |
278484 | 278484 | 2020-06-27 | Mitchell | Iowa | 19131 | 16 | 0 |
281632 | 281632 | 2020-06-28 | Mitchell | Iowa | 19131 | 21 | 0 |
284777 | 284777 | 2020-06-29 | Mitchell | Iowa | 19131 | 22 | 0 |
287926 | 287926 | 2020-06-30 | Mitchell | Iowa | 19131 | 24 | 0 |
291076 | 291076 | 2020-07-01 | Mitchell | Iowa | 19131 | 28 | 0 |
294230 | 294230 | 2020-07-02 | Mitchell | Iowa | 19131 | 34 | 0 |
297388 | 297388 | 2020-07-03 | Mitchell | Iowa | 19131 | 37 | 0 |
300550 | 300550 | 2020-07-04 | Mitchell | Iowa | 19131 | 37 | 0 |
303714 | 303714 | 2020-07-05 | Mitchell | Iowa | 19131 | 37 | 0 |
306879 | 306879 | 2020-07-06 | Mitchell | Iowa | 19131 | 39 | 0 |
310047 | 310047 | 2020-07-07 | Mitchell | Iowa | 19131 | 41 | 0 |
313217 | 313217 | 2020-07-08 | Mitchell | Iowa | 19131 | 41 | 0 |
316391 | 316391 | 2020-07-09 | Mitchell | Iowa | 19131 | 43 | 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);