ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
743 rows where county = "Wayne" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386823 | 386823 | 2020-07-31 | Wayne | Iowa | 19185 | 15 | 1 |
383605 | 383605 | 2020-07-30 | Wayne | Iowa | 19185 | 15 | 1 |
380388 | 380388 | 2020-07-29 | Wayne | Iowa | 19185 | 14 | 1 |
377171 | 377171 | 2020-07-28 | Wayne | Iowa | 19185 | 14 | 1 |
373956 | 373956 | 2020-07-27 | Wayne | Iowa | 19185 | 14 | 1 |
370744 | 370744 | 2020-07-26 | Wayne | Iowa | 19185 | 14 | 1 |
367534 | 367534 | 2020-07-25 | Wayne | Iowa | 19185 | 13 | 1 |
364327 | 364327 | 2020-07-24 | Wayne | Iowa | 19185 | 13 | 1 |
361120 | 361120 | 2020-07-23 | Wayne | Iowa | 19185 | 12 | 1 |
357915 | 357915 | 2020-07-22 | Wayne | Iowa | 19185 | 11 | 1 |
354713 | 354713 | 2020-07-21 | Wayne | Iowa | 19185 | 11 | 1 |
351511 | 351511 | 2020-07-20 | Wayne | Iowa | 19185 | 11 | 1 |
348311 | 348311 | 2020-07-19 | Wayne | Iowa | 19185 | 11 | 1 |
345110 | 345110 | 2020-07-18 | Wayne | Iowa | 19185 | 11 | 1 |
341910 | 341910 | 2020-07-17 | Wayne | Iowa | 19185 | 11 | 1 |
338714 | 338714 | 2020-07-16 | Wayne | Iowa | 19185 | 11 | 1 |
335518 | 335518 | 2020-07-15 | Wayne | Iowa | 19185 | 11 | 1 |
332325 | 332325 | 2020-07-14 | Wayne | Iowa | 19185 | 11 | 0 |
329138 | 329138 | 2020-07-13 | Wayne | Iowa | 19185 | 11 | 0 |
325952 | 325952 | 2020-07-12 | Wayne | Iowa | 19185 | 11 | 0 |
322771 | 322771 | 2020-07-11 | Wayne | Iowa | 19185 | 11 | 0 |
319592 | 319592 | 2020-07-10 | Wayne | Iowa | 19185 | 11 | 0 |
316419 | 316419 | 2020-07-09 | Wayne | Iowa | 19185 | 10 | 0 |
313245 | 313245 | 2020-07-08 | Wayne | Iowa | 19185 | 10 | 0 |
310075 | 310075 | 2020-07-07 | Wayne | Iowa | 19185 | 10 | 0 |
306907 | 306907 | 2020-07-06 | Wayne | Iowa | 19185 | 10 | 0 |
303742 | 303742 | 2020-07-05 | Wayne | Iowa | 19185 | 10 | 0 |
300578 | 300578 | 2020-07-04 | Wayne | Iowa | 19185 | 10 | 0 |
297416 | 297416 | 2020-07-03 | Wayne | Iowa | 19185 | 10 | 0 |
294258 | 294258 | 2020-07-02 | Wayne | Iowa | 19185 | 9 | 0 |
291104 | 291104 | 2020-07-01 | Wayne | Iowa | 19185 | 8 | 0 |
287954 | 287954 | 2020-06-30 | Wayne | Iowa | 19185 | 8 | 0 |
284805 | 284805 | 2020-06-29 | Wayne | Iowa | 19185 | 8 | 0 |
281660 | 281660 | 2020-06-28 | Wayne | Iowa | 19185 | 8 | 0 |
278512 | 278512 | 2020-06-27 | Wayne | Iowa | 19185 | 8 | 0 |
275364 | 275364 | 2020-06-26 | Wayne | Iowa | 19185 | 7 | 0 |
272222 | 272222 | 2020-06-25 | Wayne | Iowa | 19185 | 7 | 0 |
269085 | 269085 | 2020-06-24 | Wayne | Iowa | 19185 | 7 | 0 |
265955 | 265955 | 2020-06-23 | Wayne | Iowa | 19185 | 6 | 0 |
262827 | 262827 | 2020-06-22 | Wayne | Iowa | 19185 | 5 | 0 |
259700 | 259700 | 2020-06-21 | Wayne | Iowa | 19185 | 5 | 0 |
256574 | 256574 | 2020-06-20 | Wayne | Iowa | 19185 | 5 | 0 |
253454 | 253454 | 2020-06-19 | Wayne | Iowa | 19185 | 5 | 0 |
250339 | 250339 | 2020-06-18 | Wayne | Iowa | 19185 | 5 | 0 |
247227 | 247227 | 2020-06-17 | Wayne | Iowa | 19185 | 5 | 0 |
244114 | 244114 | 2020-06-16 | Wayne | Iowa | 19185 | 5 | 0 |
241003 | 241003 | 2020-06-15 | Wayne | Iowa | 19185 | 5 | 0 |
237895 | 237895 | 2020-06-14 | Wayne | Iowa | 19185 | 4 | 0 |
234788 | 234788 | 2020-06-13 | Wayne | Iowa | 19185 | 4 | 0 |
231682 | 231682 | 2020-06-12 | Wayne | Iowa | 19185 | 4 | 0 |
228579 | 228579 | 2020-06-11 | Wayne | Iowa | 19185 | 4 | 0 |
225477 | 225477 | 2020-06-10 | Wayne | Iowa | 19185 | 4 | 0 |
222382 | 222382 | 2020-06-09 | Wayne | Iowa | 19185 | 3 | 0 |
219287 | 219287 | 2020-06-08 | Wayne | Iowa | 19185 | 2 | 0 |
216195 | 216195 | 2020-06-07 | Wayne | Iowa | 19185 | 2 | 0 |
213108 | 213108 | 2020-06-06 | Wayne | Iowa | 19185 | 2 | 0 |
210023 | 210023 | 2020-06-05 | Wayne | Iowa | 19185 | 1 | 0 |
206942 | 206942 | 2020-06-04 | Wayne | Iowa | 19185 | 1 | 0 |
203861 | 203861 | 2020-06-03 | Wayne | Iowa | 19185 | 1 | 0 |
200785 | 200785 | 2020-06-02 | Wayne | Iowa | 19185 | 1 | 0 |
197713 | 197713 | 2020-06-01 | Wayne | Iowa | 19185 | 1 | 0 |
194643 | 194643 | 2020-05-31 | Wayne | Iowa | 19185 | 1 | 0 |
191575 | 191575 | 2020-05-30 | Wayne | Iowa | 19185 | 1 | 0 |
188511 | 188511 | 2020-05-29 | Wayne | Iowa | 19185 | 1 | 0 |
185453 | 185453 | 2020-05-28 | Wayne | Iowa | 19185 | 1 | 0 |
182399 | 182399 | 2020-05-27 | Wayne | Iowa | 19185 | 1 | 0 |
179354 | 179354 | 2020-05-26 | Wayne | Iowa | 19185 | 1 | 0 |
176310 | 176310 | 2020-05-25 | Wayne | Iowa | 19185 | 1 | 0 |
173266 | 173266 | 2020-05-24 | Wayne | Iowa | 19185 | 1 | 0 |
170225 | 170225 | 2020-05-23 | Wayne | Iowa | 19185 | 1 | 0 |
167187 | 167187 | 2020-05-22 | Wayne | Iowa | 19185 | 1 | 0 |
164155 | 164155 | 2020-05-21 | Wayne | Iowa | 19185 | 1 | 0 |
161126 | 161126 | 2020-05-20 | Wayne | Iowa | 19185 | 1 | 0 |
158101 | 158101 | 2020-05-19 | Wayne | Iowa | 19185 | 1 | 0 |
155084 | 155084 | 2020-05-18 | Wayne | Iowa | 19185 | 1 | 0 |
152072 | 152072 | 2020-05-17 | Wayne | Iowa | 19185 | 1 | 0 |
149061 | 149061 | 2020-05-16 | Wayne | Iowa | 19185 | 1 | 0 |
146057 | 146057 | 2020-05-15 | Wayne | Iowa | 19185 | 1 | 0 |
143057 | 143057 | 2020-05-14 | Wayne | Iowa | 19185 | 1 | 0 |
140061 | 140061 | 2020-05-13 | Wayne | Iowa | 19185 | 1 | 0 |
137068 | 137068 | 2020-05-12 | Wayne | Iowa | 19185 | 1 | 0 |
134078 | 134078 | 2020-05-11 | Wayne | Iowa | 19185 | 1 | 0 |
131087 | 131087 | 2020-05-10 | Wayne | Iowa | 19185 | 1 | 0 |
128097 | 128097 | 2020-05-09 | Wayne | Iowa | 19185 | 1 | 0 |
125110 | 125110 | 2020-05-08 | Wayne | Iowa | 19185 | 1 | 0 |
122128 | 122128 | 2020-05-07 | Wayne | Iowa | 19185 | 1 | 0 |
119158 | 119158 | 2020-05-06 | Wayne | Iowa | 19185 | 1 | 0 |
116197 | 116197 | 2020-05-05 | Wayne | Iowa | 19185 | 1 | 0 |
113315 | 113315 | 2020-05-04 | Wayne | Iowa | 19185 | 1 | 0 |
110440 | 110440 | 2020-05-03 | Wayne | Iowa | 19185 | 1 | 0 |
107569 | 107569 | 2020-05-02 | Wayne | Iowa | 19185 | 1 | 0 |
104704 | 104704 | 2020-05-01 | Wayne | Iowa | 19185 | 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);