ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 19019 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386739 | 386739 | 2020-07-31 | Buchanan | Iowa | 19019 | 105 | 1 |
383521 | 383521 | 2020-07-30 | Buchanan | Iowa | 19019 | 103 | 1 |
380304 | 380304 | 2020-07-29 | Buchanan | Iowa | 19019 | 95 | 1 |
377087 | 377087 | 2020-07-28 | Buchanan | Iowa | 19019 | 94 | 1 |
373872 | 373872 | 2020-07-27 | Buchanan | Iowa | 19019 | 91 | 1 |
370660 | 370660 | 2020-07-26 | Buchanan | Iowa | 19019 | 90 | 1 |
367450 | 367450 | 2020-07-25 | Buchanan | Iowa | 19019 | 88 | 1 |
364243 | 364243 | 2020-07-24 | Buchanan | Iowa | 19019 | 87 | 1 |
361036 | 361036 | 2020-07-23 | Buchanan | Iowa | 19019 | 84 | 1 |
357831 | 357831 | 2020-07-22 | Buchanan | Iowa | 19019 | 81 | 1 |
354629 | 354629 | 2020-07-21 | Buchanan | Iowa | 19019 | 77 | 1 |
351427 | 351427 | 2020-07-20 | Buchanan | Iowa | 19019 | 76 | 1 |
348227 | 348227 | 2020-07-19 | Buchanan | Iowa | 19019 | 74 | 1 |
345026 | 345026 | 2020-07-18 | Buchanan | Iowa | 19019 | 71 | 1 |
341826 | 341826 | 2020-07-17 | Buchanan | Iowa | 19019 | 69 | 1 |
338630 | 338630 | 2020-07-16 | Buchanan | Iowa | 19019 | 68 | 1 |
335434 | 335434 | 2020-07-15 | Buchanan | Iowa | 19019 | 66 | 1 |
332241 | 332241 | 2020-07-14 | Buchanan | Iowa | 19019 | 66 | 1 |
329054 | 329054 | 2020-07-13 | Buchanan | Iowa | 19019 | 65 | 1 |
325868 | 325868 | 2020-07-12 | Buchanan | Iowa | 19019 | 65 | 1 |
322687 | 322687 | 2020-07-11 | Buchanan | Iowa | 19019 | 63 | 1 |
319508 | 319508 | 2020-07-10 | Buchanan | Iowa | 19019 | 62 | 1 |
316335 | 316335 | 2020-07-09 | Buchanan | Iowa | 19019 | 61 | 1 |
313161 | 313161 | 2020-07-08 | Buchanan | Iowa | 19019 | 60 | 1 |
309991 | 309991 | 2020-07-07 | Buchanan | Iowa | 19019 | 60 | 1 |
306823 | 306823 | 2020-07-06 | Buchanan | Iowa | 19019 | 55 | 1 |
303658 | 303658 | 2020-07-05 | Buchanan | Iowa | 19019 | 54 | 1 |
300494 | 300494 | 2020-07-04 | Buchanan | Iowa | 19019 | 50 | 1 |
297332 | 297332 | 2020-07-03 | Buchanan | Iowa | 19019 | 50 | 1 |
294174 | 294174 | 2020-07-02 | Buchanan | Iowa | 19019 | 51 | 1 |
291020 | 291020 | 2020-07-01 | Buchanan | Iowa | 19019 | 47 | 1 |
287870 | 287870 | 2020-06-30 | Buchanan | Iowa | 19019 | 45 | 1 |
284721 | 284721 | 2020-06-29 | Buchanan | Iowa | 19019 | 44 | 1 |
281576 | 281576 | 2020-06-28 | Buchanan | Iowa | 19019 | 43 | 1 |
278428 | 278428 | 2020-06-27 | Buchanan | Iowa | 19019 | 42 | 1 |
275280 | 275280 | 2020-06-26 | Buchanan | Iowa | 19019 | 42 | 1 |
272138 | 272138 | 2020-06-25 | Buchanan | Iowa | 19019 | 41 | 1 |
269001 | 269001 | 2020-06-24 | Buchanan | Iowa | 19019 | 42 | 1 |
265871 | 265871 | 2020-06-23 | Buchanan | Iowa | 19019 | 40 | 1 |
262743 | 262743 | 2020-06-22 | Buchanan | Iowa | 19019 | 38 | 1 |
259616 | 259616 | 2020-06-21 | Buchanan | Iowa | 19019 | 37 | 1 |
256490 | 256490 | 2020-06-20 | Buchanan | Iowa | 19019 | 37 | 1 |
253370 | 253370 | 2020-06-19 | Buchanan | Iowa | 19019 | 37 | 1 |
250255 | 250255 | 2020-06-18 | Buchanan | Iowa | 19019 | 36 | 1 |
247143 | 247143 | 2020-06-17 | Buchanan | Iowa | 19019 | 35 | 1 |
244030 | 244030 | 2020-06-16 | Buchanan | Iowa | 19019 | 35 | 1 |
240919 | 240919 | 2020-06-15 | Buchanan | Iowa | 19019 | 35 | 1 |
237811 | 237811 | 2020-06-14 | Buchanan | Iowa | 19019 | 35 | 1 |
234704 | 234704 | 2020-06-13 | Buchanan | Iowa | 19019 | 35 | 1 |
231598 | 231598 | 2020-06-12 | Buchanan | Iowa | 19019 | 34 | 1 |
228495 | 228495 | 2020-06-11 | Buchanan | Iowa | 19019 | 34 | 1 |
225393 | 225393 | 2020-06-10 | Buchanan | Iowa | 19019 | 34 | 1 |
222298 | 222298 | 2020-06-09 | Buchanan | Iowa | 19019 | 34 | 1 |
219203 | 219203 | 2020-06-08 | Buchanan | Iowa | 19019 | 34 | 1 |
216111 | 216111 | 2020-06-07 | Buchanan | Iowa | 19019 | 34 | 1 |
213024 | 213024 | 2020-06-06 | Buchanan | Iowa | 19019 | 34 | 1 |
209939 | 209939 | 2020-06-05 | Buchanan | Iowa | 19019 | 34 | 1 |
206858 | 206858 | 2020-06-04 | Buchanan | Iowa | 19019 | 33 | 0 |
203778 | 203778 | 2020-06-03 | Buchanan | Iowa | 19019 | 33 | 0 |
200702 | 200702 | 2020-06-02 | Buchanan | Iowa | 19019 | 33 | 0 |
197629 | 197629 | 2020-06-01 | Buchanan | Iowa | 19019 | 33 | 0 |
194559 | 194559 | 2020-05-31 | Buchanan | Iowa | 19019 | 33 | 0 |
191492 | 191492 | 2020-05-30 | Buchanan | Iowa | 19019 | 33 | 0 |
188427 | 188427 | 2020-05-29 | Buchanan | Iowa | 19019 | 32 | 0 |
185369 | 185369 | 2020-05-28 | Buchanan | Iowa | 19019 | 32 | 0 |
182315 | 182315 | 2020-05-27 | Buchanan | Iowa | 19019 | 31 | 0 |
179271 | 179271 | 2020-05-26 | Buchanan | Iowa | 19019 | 31 | 0 |
176227 | 176227 | 2020-05-25 | Buchanan | Iowa | 19019 | 32 | 0 |
173183 | 173183 | 2020-05-24 | Buchanan | Iowa | 19019 | 32 | 0 |
170142 | 170142 | 2020-05-23 | Buchanan | Iowa | 19019 | 31 | 0 |
167105 | 167105 | 2020-05-22 | Buchanan | Iowa | 19019 | 31 | 0 |
164072 | 164072 | 2020-05-21 | Buchanan | Iowa | 19019 | 30 | 0 |
161044 | 161044 | 2020-05-20 | Buchanan | Iowa | 19019 | 29 | 0 |
158018 | 158018 | 2020-05-19 | Buchanan | Iowa | 19019 | 26 | 0 |
155002 | 155002 | 2020-05-18 | Buchanan | Iowa | 19019 | 26 | 0 |
151990 | 151990 | 2020-05-17 | Buchanan | Iowa | 19019 | 26 | 0 |
148980 | 148980 | 2020-05-16 | Buchanan | Iowa | 19019 | 26 | 0 |
145976 | 145976 | 2020-05-15 | Buchanan | Iowa | 19019 | 26 | 0 |
142976 | 142976 | 2020-05-14 | Buchanan | Iowa | 19019 | 24 | 0 |
139980 | 139980 | 2020-05-13 | Buchanan | Iowa | 19019 | 24 | 0 |
136988 | 136988 | 2020-05-12 | Buchanan | Iowa | 19019 | 23 | 0 |
133999 | 133999 | 2020-05-11 | Buchanan | Iowa | 19019 | 23 | 0 |
131009 | 131009 | 2020-05-10 | Buchanan | Iowa | 19019 | 23 | 0 |
128018 | 128018 | 2020-05-09 | Buchanan | Iowa | 19019 | 23 | 0 |
125031 | 125031 | 2020-05-08 | Buchanan | Iowa | 19019 | 23 | 0 |
122051 | 122051 | 2020-05-07 | Buchanan | Iowa | 19019 | 22 | 0 |
119081 | 119081 | 2020-05-06 | Buchanan | Iowa | 19019 | 22 | 0 |
116121 | 116121 | 2020-05-05 | Buchanan | Iowa | 19019 | 22 | 0 |
113238 | 113238 | 2020-05-04 | Buchanan | Iowa | 19019 | 20 | 0 |
110363 | 110363 | 2020-05-03 | Buchanan | Iowa | 19019 | 20 | 0 |
107493 | 107493 | 2020-05-02 | Buchanan | Iowa | 19019 | 19 | 0 |
104628 | 104628 | 2020-05-01 | Buchanan | Iowa | 19019 | 18 | 0 |
101772 | 101772 | 2020-04-30 | Buchanan | Iowa | 19019 | 17 | 0 |
98921 | 98921 | 2020-04-29 | Buchanan | Iowa | 19019 | 16 | 0 |
96077 | 96077 | 2020-04-28 | Buchanan | Iowa | 19019 | 14 | 0 |
93245 | 93245 | 2020-04-27 | Buchanan | Iowa | 19019 | 12 | 0 |
90426 | 90426 | 2020-04-26 | Buchanan | Iowa | 19019 | 12 | 0 |
87610 | 87610 | 2020-04-25 | Buchanan | Iowa | 19019 | 12 | 0 |
84800 | 84800 | 2020-04-24 | Buchanan | Iowa | 19019 | 13 | 0 |
82000 | 82000 | 2020-04-23 | Buchanan | Iowa | 19019 | 11 | 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);