ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Washington", fips = 27163 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387341 | 387341 | 2020-07-31 | Washington | Minnesota | 27163 | 1817 | 43 |
384123 | 384123 | 2020-07-30 | Washington | Minnesota | 27163 | 1792 | 43 |
380906 | 380906 | 2020-07-29 | Washington | Minnesota | 27163 | 1760 | 43 |
377689 | 377689 | 2020-07-28 | Washington | Minnesota | 27163 | 1723 | 42 |
374474 | 374474 | 2020-07-27 | Washington | Minnesota | 27163 | 1700 | 41 |
371262 | 371262 | 2020-07-26 | Washington | Minnesota | 27163 | 1672 | 41 |
368052 | 368052 | 2020-07-25 | Washington | Minnesota | 27163 | 1631 | 41 |
364844 | 364844 | 2020-07-24 | Washington | Minnesota | 27163 | 1597 | 41 |
361637 | 361637 | 2020-07-23 | Washington | Minnesota | 27163 | 1572 | 41 |
358432 | 358432 | 2020-07-22 | Washington | Minnesota | 27163 | 1550 | 40 |
355229 | 355229 | 2020-07-21 | Washington | Minnesota | 27163 | 1515 | 40 |
352027 | 352027 | 2020-07-20 | Washington | Minnesota | 27163 | 1465 | 40 |
348827 | 348827 | 2020-07-19 | Washington | Minnesota | 27163 | 1458 | 40 |
345626 | 345626 | 2020-07-18 | Washington | Minnesota | 27163 | 1422 | 40 |
342426 | 342426 | 2020-07-17 | Washington | Minnesota | 27163 | 1402 | 40 |
339230 | 339230 | 2020-07-16 | Washington | Minnesota | 27163 | 1369 | 40 |
336034 | 336034 | 2020-07-15 | Washington | Minnesota | 27163 | 1344 | 41 |
332841 | 332841 | 2020-07-14 | Washington | Minnesota | 27163 | 1324 | 41 |
329654 | 329654 | 2020-07-13 | Washington | Minnesota | 27163 | 1306 | 41 |
326468 | 326468 | 2020-07-12 | Washington | Minnesota | 27163 | 1283 | 41 |
323285 | 323285 | 2020-07-11 | Washington | Minnesota | 27163 | 1255 | 41 |
320106 | 320106 | 2020-07-10 | Washington | Minnesota | 27163 | 1228 | 40 |
316931 | 316931 | 2020-07-09 | Washington | Minnesota | 27163 | 1190 | 40 |
313757 | 313757 | 2020-07-08 | Washington | Minnesota | 27163 | 1163 | 40 |
310587 | 310587 | 2020-07-07 | Washington | Minnesota | 27163 | 1137 | 40 |
307419 | 307419 | 2020-07-06 | Washington | Minnesota | 27163 | 1114 | 40 |
304252 | 304252 | 2020-07-05 | Washington | Minnesota | 27163 | 1082 | 40 |
301088 | 301088 | 2020-07-04 | Washington | Minnesota | 27163 | 1069 | 40 |
297925 | 297925 | 2020-07-03 | Washington | Minnesota | 27163 | 1069 | 40 |
294767 | 294767 | 2020-07-02 | Washington | Minnesota | 27163 | 1048 | 40 |
291613 | 291613 | 2020-07-01 | Washington | Minnesota | 27163 | 1025 | 40 |
288462 | 288462 | 2020-06-30 | Washington | Minnesota | 27163 | 1008 | 40 |
285312 | 285312 | 2020-06-29 | Washington | Minnesota | 27163 | 995 | 40 |
282167 | 282167 | 2020-06-28 | Washington | Minnesota | 27163 | 984 | 40 |
279019 | 279019 | 2020-06-27 | Washington | Minnesota | 27163 | 968 | 40 |
275871 | 275871 | 2020-06-26 | Washington | Minnesota | 27163 | 948 | 39 |
272728 | 272728 | 2020-06-25 | Washington | Minnesota | 27163 | 926 | 39 |
269591 | 269591 | 2020-06-24 | Washington | Minnesota | 27163 | 917 | 39 |
266458 | 266458 | 2020-06-23 | Washington | Minnesota | 27163 | 905 | 38 |
263332 | 263332 | 2020-06-22 | Washington | Minnesota | 27163 | 898 | 38 |
260203 | 260203 | 2020-06-21 | Washington | Minnesota | 27163 | 885 | 38 |
257077 | 257077 | 2020-06-20 | Washington | Minnesota | 27163 | 868 | 38 |
253957 | 253957 | 2020-06-19 | Washington | Minnesota | 27163 | 843 | 37 |
250842 | 250842 | 2020-06-18 | Washington | Minnesota | 27163 | 833 | 37 |
247730 | 247730 | 2020-06-17 | Washington | Minnesota | 27163 | 826 | 37 |
244617 | 244617 | 2020-06-16 | Washington | Minnesota | 27163 | 802 | 37 |
241506 | 241506 | 2020-06-15 | Washington | Minnesota | 27163 | 799 | 37 |
238397 | 238397 | 2020-06-14 | Washington | Minnesota | 27163 | 796 | 37 |
235290 | 235290 | 2020-06-13 | Washington | Minnesota | 27163 | 787 | 37 |
232184 | 232184 | 2020-06-12 | Washington | Minnesota | 27163 | 766 | 36 |
229080 | 229080 | 2020-06-11 | Washington | Minnesota | 27163 | 748 | 36 |
225978 | 225978 | 2020-06-10 | Washington | Minnesota | 27163 | 735 | 36 |
222880 | 222880 | 2020-06-09 | Washington | Minnesota | 27163 | 732 | 36 |
219785 | 219785 | 2020-06-08 | Washington | Minnesota | 27163 | 731 | 37 |
216693 | 216693 | 2020-06-07 | Washington | Minnesota | 27163 | 721 | 37 |
213605 | 213605 | 2020-06-06 | Washington | Minnesota | 27163 | 712 | 37 |
210521 | 210521 | 2020-06-05 | Washington | Minnesota | 27163 | 700 | 35 |
207440 | 207440 | 2020-06-04 | Washington | Minnesota | 27163 | 680 | 34 |
204359 | 204359 | 2020-06-03 | Washington | Minnesota | 27163 | 670 | 33 |
201282 | 201282 | 2020-06-02 | Washington | Minnesota | 27163 | 658 | 32 |
198209 | 198209 | 2020-06-01 | Washington | Minnesota | 27163 | 645 | 32 |
195138 | 195138 | 2020-05-31 | Washington | Minnesota | 27163 | 636 | 32 |
192070 | 192070 | 2020-05-30 | Washington | Minnesota | 27163 | 617 | 31 |
189006 | 189006 | 2020-05-29 | Washington | Minnesota | 27163 | 598 | 31 |
185948 | 185948 | 2020-05-28 | Washington | Minnesota | 27163 | 576 | 30 |
182892 | 182892 | 2020-05-27 | Washington | Minnesota | 27163 | 562 | 30 |
179846 | 179846 | 2020-05-26 | Washington | Minnesota | 27163 | 553 | 29 |
176802 | 176802 | 2020-05-25 | Washington | Minnesota | 27163 | 527 | 29 |
173759 | 173759 | 2020-05-24 | Washington | Minnesota | 27163 | 506 | 26 |
170717 | 170717 | 2020-05-23 | Washington | Minnesota | 27163 | 485 | 25 |
167679 | 167679 | 2020-05-22 | Washington | Minnesota | 27163 | 453 | 25 |
164643 | 164643 | 2020-05-21 | Washington | Minnesota | 27163 | 431 | 23 |
161614 | 161614 | 2020-05-20 | Washington | Minnesota | 27163 | 414 | 21 |
158588 | 158588 | 2020-05-19 | Washington | Minnesota | 27163 | 398 | 19 |
155570 | 155570 | 2020-05-18 | Washington | Minnesota | 27163 | 378 | 19 |
152556 | 152556 | 2020-05-17 | Washington | Minnesota | 27163 | 363 | 18 |
149545 | 149545 | 2020-05-16 | Washington | Minnesota | 27163 | 326 | 18 |
146540 | 146540 | 2020-05-15 | Washington | Minnesota | 27163 | 305 | 18 |
143540 | 143540 | 2020-05-14 | Washington | Minnesota | 27163 | 282 | 18 |
140545 | 140545 | 2020-05-13 | Washington | Minnesota | 27163 | 266 | 16 |
137551 | 137551 | 2020-05-12 | Washington | Minnesota | 27163 | 266 | 16 |
134561 | 134561 | 2020-05-11 | Washington | Minnesota | 27163 | 256 | 15 |
131570 | 131570 | 2020-05-10 | Washington | Minnesota | 27163 | 247 | 15 |
128580 | 128580 | 2020-05-09 | Washington | Minnesota | 27163 | 231 | 14 |
125593 | 125593 | 2020-05-08 | Washington | Minnesota | 27163 | 211 | 12 |
122611 | 122611 | 2020-05-07 | Washington | Minnesota | 27163 | 193 | 12 |
119637 | 119637 | 2020-05-06 | Washington | Minnesota | 27163 | 181 | 12 |
116677 | 116677 | 2020-05-05 | Washington | Minnesota | 27163 | 162 | 12 |
113795 | 113795 | 2020-05-04 | Washington | Minnesota | 27163 | 152 | 12 |
110916 | 110916 | 2020-05-03 | Washington | Minnesota | 27163 | 146 | 12 |
108045 | 108045 | 2020-05-02 | Washington | Minnesota | 27163 | 142 | 12 |
105180 | 105180 | 2020-05-01 | Washington | Minnesota | 27163 | 133 | 11 |
102319 | 102319 | 2020-04-30 | Washington | Minnesota | 27163 | 131 | 10 |
99467 | 99467 | 2020-04-29 | Washington | Minnesota | 27163 | 120 | 9 |
96621 | 96621 | 2020-04-28 | Washington | Minnesota | 27163 | 117 | 9 |
93785 | 93785 | 2020-04-27 | Washington | Minnesota | 27163 | 114 | 8 |
90964 | 90964 | 2020-04-26 | Washington | Minnesota | 27163 | 113 | 8 |
88148 | 88148 | 2020-04-25 | Washington | Minnesota | 27163 | 112 | 7 |
85338 | 85338 | 2020-04-24 | Washington | Minnesota | 27163 | 107 | 7 |
82534 | 82534 | 2020-04-23 | Washington | Minnesota | 27163 | 100 | 7 |
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);