ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Clay" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387272 | 387272 | 2020-07-31 | Clay | Minnesota | 27027 | 740 | 39 |
384054 | 384054 | 2020-07-30 | Clay | Minnesota | 27027 | 734 | 39 |
380837 | 380837 | 2020-07-29 | Clay | Minnesota | 27027 | 725 | 39 |
377620 | 377620 | 2020-07-28 | Clay | Minnesota | 27027 | 717 | 39 |
374405 | 374405 | 2020-07-27 | Clay | Minnesota | 27027 | 707 | 39 |
371193 | 371193 | 2020-07-26 | Clay | Minnesota | 27027 | 703 | 39 |
367983 | 367983 | 2020-07-25 | Clay | Minnesota | 27027 | 697 | 39 |
364776 | 364776 | 2020-07-24 | Clay | Minnesota | 27027 | 692 | 39 |
361569 | 361569 | 2020-07-23 | Clay | Minnesota | 27027 | 686 | 39 |
358364 | 358364 | 2020-07-22 | Clay | Minnesota | 27027 | 679 | 39 |
355161 | 355161 | 2020-07-21 | Clay | Minnesota | 27027 | 678 | 39 |
351959 | 351959 | 2020-07-20 | Clay | Minnesota | 27027 | 669 | 39 |
348759 | 348759 | 2020-07-19 | Clay | Minnesota | 27027 | 668 | 38 |
345558 | 345558 | 2020-07-18 | Clay | Minnesota | 27027 | 658 | 38 |
342358 | 342358 | 2020-07-17 | Clay | Minnesota | 27027 | 650 | 38 |
339162 | 339162 | 2020-07-16 | Clay | Minnesota | 27027 | 638 | 38 |
335966 | 335966 | 2020-07-15 | Clay | Minnesota | 27027 | 632 | 38 |
332773 | 332773 | 2020-07-14 | Clay | Minnesota | 27027 | 627 | 38 |
329586 | 329586 | 2020-07-13 | Clay | Minnesota | 27027 | 620 | 38 |
326400 | 326400 | 2020-07-12 | Clay | Minnesota | 27027 | 613 | 38 |
323217 | 323217 | 2020-07-11 | Clay | Minnesota | 27027 | 612 | 38 |
320038 | 320038 | 2020-07-10 | Clay | Minnesota | 27027 | 601 | 38 |
316863 | 316863 | 2020-07-09 | Clay | Minnesota | 27027 | 598 | 38 |
313689 | 313689 | 2020-07-08 | Clay | Minnesota | 27027 | 595 | 38 |
310519 | 310519 | 2020-07-07 | Clay | Minnesota | 27027 | 591 | 38 |
307351 | 307351 | 2020-07-06 | Clay | Minnesota | 27027 | 587 | 38 |
304184 | 304184 | 2020-07-05 | Clay | Minnesota | 27027 | 587 | 38 |
301020 | 301020 | 2020-07-04 | Clay | Minnesota | 27027 | 585 | 38 |
297857 | 297857 | 2020-07-03 | Clay | Minnesota | 27027 | 585 | 38 |
294699 | 294699 | 2020-07-02 | Clay | Minnesota | 27027 | 580 | 37 |
291545 | 291545 | 2020-07-01 | Clay | Minnesota | 27027 | 576 | 37 |
288394 | 288394 | 2020-06-30 | Clay | Minnesota | 27027 | 563 | 37 |
285244 | 285244 | 2020-06-29 | Clay | Minnesota | 27027 | 560 | 37 |
282099 | 282099 | 2020-06-28 | Clay | Minnesota | 27027 | 557 | 37 |
278951 | 278951 | 2020-06-27 | Clay | Minnesota | 27027 | 556 | 37 |
275803 | 275803 | 2020-06-26 | Clay | Minnesota | 27027 | 545 | 37 |
272660 | 272660 | 2020-06-25 | Clay | Minnesota | 27027 | 537 | 37 |
269523 | 269523 | 2020-06-24 | Clay | Minnesota | 27027 | 537 | 37 |
266390 | 266390 | 2020-06-23 | Clay | Minnesota | 27027 | 530 | 37 |
263264 | 263264 | 2020-06-22 | Clay | Minnesota | 27027 | 528 | 37 |
260135 | 260135 | 2020-06-21 | Clay | Minnesota | 27027 | 526 | 37 |
257009 | 257009 | 2020-06-20 | Clay | Minnesota | 27027 | 522 | 37 |
253889 | 253889 | 2020-06-19 | Clay | Minnesota | 27027 | 521 | 37 |
250774 | 250774 | 2020-06-18 | Clay | Minnesota | 27027 | 516 | 37 |
247662 | 247662 | 2020-06-17 | Clay | Minnesota | 27027 | 512 | 37 |
244549 | 244549 | 2020-06-16 | Clay | Minnesota | 27027 | 506 | 37 |
241438 | 241438 | 2020-06-15 | Clay | Minnesota | 27027 | 506 | 36 |
238329 | 238329 | 2020-06-14 | Clay | Minnesota | 27027 | 504 | 36 |
235222 | 235222 | 2020-06-13 | Clay | Minnesota | 27027 | 507 | 36 |
232117 | 232117 | 2020-06-12 | Clay | Minnesota | 27027 | 503 | 36 |
229013 | 229013 | 2020-06-11 | Clay | Minnesota | 27027 | 499 | 31 |
225911 | 225911 | 2020-06-10 | Clay | Minnesota | 27027 | 490 | 31 |
222813 | 222813 | 2020-06-09 | Clay | Minnesota | 27027 | 481 | 30 |
219718 | 219718 | 2020-06-08 | Clay | Minnesota | 27027 | 469 | 30 |
216626 | 216626 | 2020-06-07 | Clay | Minnesota | 27027 | 462 | 30 |
213538 | 213538 | 2020-06-06 | Clay | Minnesota | 27027 | 457 | 30 |
210454 | 210454 | 2020-06-05 | Clay | Minnesota | 27027 | 449 | 30 |
207373 | 207373 | 2020-06-04 | Clay | Minnesota | 27027 | 441 | 29 |
204292 | 204292 | 2020-06-03 | Clay | Minnesota | 27027 | 435 | 29 |
201215 | 201215 | 2020-06-02 | Clay | Minnesota | 27027 | 430 | 29 |
198142 | 198142 | 2020-06-01 | Clay | Minnesota | 27027 | 427 | 28 |
195071 | 195071 | 2020-05-31 | Clay | Minnesota | 27027 | 423 | 28 |
192003 | 192003 | 2020-05-30 | Clay | Minnesota | 27027 | 424 | 26 |
188939 | 188939 | 2020-05-29 | Clay | Minnesota | 27027 | 420 | 25 |
185881 | 185881 | 2020-05-28 | Clay | Minnesota | 27027 | 416 | 25 |
182826 | 182826 | 2020-05-27 | Clay | Minnesota | 27027 | 406 | 25 |
179780 | 179780 | 2020-05-26 | Clay | Minnesota | 27027 | 386 | 25 |
176736 | 176736 | 2020-05-25 | Clay | Minnesota | 27027 | 373 | 24 |
173693 | 173693 | 2020-05-24 | Clay | Minnesota | 27027 | 366 | 23 |
170651 | 170651 | 2020-05-23 | Clay | Minnesota | 27027 | 361 | 23 |
167614 | 167614 | 2020-05-22 | Clay | Minnesota | 27027 | 356 | 22 |
164578 | 164578 | 2020-05-21 | Clay | Minnesota | 27027 | 344 | 22 |
161549 | 161549 | 2020-05-20 | Clay | Minnesota | 27027 | 328 | 21 |
158523 | 158523 | 2020-05-19 | Clay | Minnesota | 27027 | 318 | 21 |
155505 | 155505 | 2020-05-18 | Clay | Minnesota | 27027 | 310 | 20 |
152491 | 152491 | 2020-05-17 | Clay | Minnesota | 27027 | 293 | 20 |
149480 | 149480 | 2020-05-16 | Clay | Minnesota | 27027 | 291 | 19 |
146475 | 146475 | 2020-05-15 | Clay | Minnesota | 27027 | 279 | 18 |
143475 | 143475 | 2020-05-14 | Clay | Minnesota | 27027 | 273 | 18 |
140480 | 140480 | 2020-05-13 | Clay | Minnesota | 27027 | 254 | 17 |
137486 | 137486 | 2020-05-12 | Clay | Minnesota | 27027 | 254 | 17 |
134496 | 134496 | 2020-05-11 | Clay | Minnesota | 27027 | 247 | 17 |
131505 | 131505 | 2020-05-10 | Clay | Minnesota | 27027 | 235 | 17 |
128515 | 128515 | 2020-05-09 | Clay | Minnesota | 27027 | 233 | 16 |
125528 | 125528 | 2020-05-08 | Clay | Minnesota | 27027 | 229 | 15 |
122546 | 122546 | 2020-05-07 | Clay | Minnesota | 27027 | 222 | 15 |
119573 | 119573 | 2020-05-06 | Clay | Minnesota | 27027 | 215 | 14 |
116613 | 116613 | 2020-05-05 | Clay | Minnesota | 27027 | 201 | 14 |
113732 | 113732 | 2020-05-04 | Clay | Minnesota | 27027 | 190 | 13 |
110853 | 110853 | 2020-05-03 | Clay | Minnesota | 27027 | 176 | 13 |
107982 | 107982 | 2020-05-02 | Clay | Minnesota | 27027 | 169 | 13 |
105118 | 105118 | 2020-05-01 | Clay | Minnesota | 27027 | 165 | 11 |
102258 | 102258 | 2020-04-30 | Clay | Minnesota | 27027 | 157 | 11 |
99406 | 99406 | 2020-04-29 | Clay | Minnesota | 27027 | 152 | 10 |
96560 | 96560 | 2020-04-28 | Clay | Minnesota | 27027 | 149 | 10 |
93725 | 93725 | 2020-04-27 | Clay | Minnesota | 27027 | 131 | 9 |
90904 | 90904 | 2020-04-26 | Clay | Minnesota | 27027 | 125 | 9 |
88088 | 88088 | 2020-04-25 | Clay | Minnesota | 27027 | 113 | 7 |
85278 | 85278 | 2020-04-24 | Clay | Minnesota | 27027 | 100 | 4 |
82474 | 82474 | 2020-04-23 | Clay | Minnesota | 27027 | 84 | 4 |
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);