ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Wabasha" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636290 | 636290 | 2020-10-16 | Wabasha | Minnesota | 27157 | 303 | 0 |
633044 | 633044 | 2020-10-15 | Wabasha | Minnesota | 27157 | 285 | 0 |
629799 | 629799 | 2020-10-14 | Wabasha | Minnesota | 27157 | 283 | 0 |
626555 | 626555 | 2020-10-13 | Wabasha | Minnesota | 27157 | 279 | 0 |
623313 | 623313 | 2020-10-12 | Wabasha | Minnesota | 27157 | 273 | 0 |
620070 | 620070 | 2020-10-11 | Wabasha | Minnesota | 27157 | 271 | 0 |
616828 | 616828 | 2020-10-10 | Wabasha | Minnesota | 27157 | 264 | 0 |
613587 | 613587 | 2020-10-09 | Wabasha | Minnesota | 27157 | 261 | 0 |
610345 | 610345 | 2020-10-08 | Wabasha | Minnesota | 27157 | 248 | 0 |
607103 | 607103 | 2020-10-07 | Wabasha | Minnesota | 27157 | 244 | 0 |
603860 | 603860 | 2020-10-06 | Wabasha | Minnesota | 27157 | 241 | 0 |
600618 | 600618 | 2020-10-05 | Wabasha | Minnesota | 27157 | 232 | 0 |
597375 | 597375 | 2020-10-04 | Wabasha | Minnesota | 27157 | 229 | 0 |
594134 | 594134 | 2020-10-03 | Wabasha | Minnesota | 27157 | 224 | 0 |
590893 | 590893 | 2020-10-02 | Wabasha | Minnesota | 27157 | 216 | 0 |
587652 | 587652 | 2020-10-01 | Wabasha | Minnesota | 27157 | 214 | 0 |
584412 | 584412 | 2020-09-30 | Wabasha | Minnesota | 27157 | 208 | 0 |
581171 | 581171 | 2020-09-29 | Wabasha | Minnesota | 27157 | 206 | 0 |
577930 | 577930 | 2020-09-28 | Wabasha | Minnesota | 27157 | 202 | 0 |
574689 | 574689 | 2020-09-27 | Wabasha | Minnesota | 27157 | 201 | 0 |
571446 | 571446 | 2020-09-26 | Wabasha | Minnesota | 27157 | 196 | 0 |
568204 | 568204 | 2020-09-25 | Wabasha | Minnesota | 27157 | 188 | 0 |
564964 | 564964 | 2020-09-24 | Wabasha | Minnesota | 27157 | 183 | 0 |
561724 | 561724 | 2020-09-23 | Wabasha | Minnesota | 27157 | 180 | 0 |
558487 | 558487 | 2020-09-22 | Wabasha | Minnesota | 27157 | 181 | 0 |
555250 | 555250 | 2020-09-21 | Wabasha | Minnesota | 27157 | 180 | 0 |
552012 | 552012 | 2020-09-20 | Wabasha | Minnesota | 27157 | 174 | 0 |
548773 | 548773 | 2020-09-19 | Wabasha | Minnesota | 27157 | 170 | 0 |
545535 | 545535 | 2020-09-18 | Wabasha | Minnesota | 27157 | 166 | 0 |
542298 | 542298 | 2020-09-17 | Wabasha | Minnesota | 27157 | 164 | 0 |
539062 | 539062 | 2020-09-16 | Wabasha | Minnesota | 27157 | 157 | 0 |
535825 | 535825 | 2020-09-15 | Wabasha | Minnesota | 27157 | 154 | 0 |
532590 | 532590 | 2020-09-14 | Wabasha | Minnesota | 27157 | 152 | 0 |
529354 | 529354 | 2020-09-13 | Wabasha | Minnesota | 27157 | 151 | 0 |
526118 | 526118 | 2020-09-12 | Wabasha | Minnesota | 27157 | 145 | 0 |
522882 | 522882 | 2020-09-11 | Wabasha | Minnesota | 27157 | 143 | 0 |
519645 | 519645 | 2020-09-10 | Wabasha | Minnesota | 27157 | 140 | 0 |
516410 | 516410 | 2020-09-09 | Wabasha | Minnesota | 27157 | 138 | 0 |
513176 | 513176 | 2020-09-08 | Wabasha | Minnesota | 27157 | 134 | 0 |
509944 | 509944 | 2020-09-07 | Wabasha | Minnesota | 27157 | 134 | 0 |
506711 | 506711 | 2020-09-06 | Wabasha | Minnesota | 27157 | 133 | 0 |
503478 | 503478 | 2020-09-05 | Wabasha | Minnesota | 27157 | 131 | 0 |
500244 | 500244 | 2020-09-04 | Wabasha | Minnesota | 27157 | 129 | 0 |
497010 | 497010 | 2020-09-03 | Wabasha | Minnesota | 27157 | 129 | 0 |
493777 | 493777 | 2020-09-02 | Wabasha | Minnesota | 27157 | 125 | 0 |
490543 | 490543 | 2020-09-01 | Wabasha | Minnesota | 27157 | 124 | 0 |
487310 | 487310 | 2020-08-31 | Wabasha | Minnesota | 27157 | 123 | 0 |
484076 | 484076 | 2020-08-30 | Wabasha | Minnesota | 27157 | 122 | 0 |
480841 | 480841 | 2020-08-29 | Wabasha | Minnesota | 27157 | 120 | 0 |
477609 | 477609 | 2020-08-28 | Wabasha | Minnesota | 27157 | 117 | 0 |
474376 | 474376 | 2020-08-27 | Wabasha | Minnesota | 27157 | 115 | 0 |
471144 | 471144 | 2020-08-26 | Wabasha | Minnesota | 27157 | 113 | 0 |
467914 | 467914 | 2020-08-25 | Wabasha | Minnesota | 27157 | 111 | 0 |
464685 | 464685 | 2020-08-24 | Wabasha | Minnesota | 27157 | 111 | 0 |
461454 | 461454 | 2020-08-23 | Wabasha | Minnesota | 27157 | 109 | 0 |
458227 | 458227 | 2020-08-22 | Wabasha | Minnesota | 27157 | 107 | 0 |
454999 | 454999 | 2020-08-21 | Wabasha | Minnesota | 27157 | 107 | 0 |
451771 | 451771 | 2020-08-20 | Wabasha | Minnesota | 27157 | 107 | 0 |
448543 | 448543 | 2020-08-19 | Wabasha | Minnesota | 27157 | 103 | 0 |
445317 | 445317 | 2020-08-18 | Wabasha | Minnesota | 27157 | 101 | 0 |
442091 | 442091 | 2020-08-17 | Wabasha | Minnesota | 27157 | 101 | 0 |
438864 | 438864 | 2020-08-16 | Wabasha | Minnesota | 27157 | 101 | 0 |
435639 | 435639 | 2020-08-15 | Wabasha | Minnesota | 27157 | 99 | 0 |
432413 | 432413 | 2020-08-14 | Wabasha | Minnesota | 27157 | 97 | 0 |
429186 | 429186 | 2020-08-13 | Wabasha | Minnesota | 27157 | 93 | 0 |
425962 | 425962 | 2020-08-12 | Wabasha | Minnesota | 27157 | 92 | 0 |
422740 | 422740 | 2020-08-11 | Wabasha | Minnesota | 27157 | 93 | 0 |
419518 | 419518 | 2020-08-10 | Wabasha | Minnesota | 27157 | 92 | 0 |
416297 | 416297 | 2020-08-09 | Wabasha | Minnesota | 27157 | 92 | 0 |
413077 | 413077 | 2020-08-08 | Wabasha | Minnesota | 27157 | 91 | 0 |
409857 | 409857 | 2020-08-07 | Wabasha | Minnesota | 27157 | 88 | 0 |
406637 | 406637 | 2020-08-06 | Wabasha | Minnesota | 27157 | 87 | 0 |
403419 | 403419 | 2020-08-05 | Wabasha | Minnesota | 27157 | 84 | 0 |
400202 | 400202 | 2020-08-04 | Wabasha | Minnesota | 27157 | 82 | 0 |
396988 | 396988 | 2020-08-03 | Wabasha | Minnesota | 27157 | 81 | 0 |
393772 | 393772 | 2020-08-02 | Wabasha | Minnesota | 27157 | 78 | 0 |
390555 | 390555 | 2020-08-01 | Wabasha | Minnesota | 27157 | 78 | 0 |
387338 | 387338 | 2020-07-31 | Wabasha | Minnesota | 27157 | 78 | 0 |
384120 | 384120 | 2020-07-30 | Wabasha | Minnesota | 27157 | 74 | 0 |
380903 | 380903 | 2020-07-29 | Wabasha | Minnesota | 27157 | 74 | 0 |
377686 | 377686 | 2020-07-28 | Wabasha | Minnesota | 27157 | 70 | 0 |
374471 | 374471 | 2020-07-27 | Wabasha | Minnesota | 27157 | 66 | 0 |
371259 | 371259 | 2020-07-26 | Wabasha | Minnesota | 27157 | 65 | 0 |
368049 | 368049 | 2020-07-25 | Wabasha | Minnesota | 27157 | 65 | 0 |
364841 | 364841 | 2020-07-24 | Wabasha | Minnesota | 27157 | 64 | 0 |
361634 | 361634 | 2020-07-23 | Wabasha | Minnesota | 27157 | 63 | 0 |
358429 | 358429 | 2020-07-22 | Wabasha | Minnesota | 27157 | 59 | 0 |
355226 | 355226 | 2020-07-21 | Wabasha | Minnesota | 27157 | 56 | 0 |
352024 | 352024 | 2020-07-20 | Wabasha | Minnesota | 27157 | 55 | 0 |
348824 | 348824 | 2020-07-19 | Wabasha | Minnesota | 27157 | 56 | 0 |
345623 | 345623 | 2020-07-18 | Wabasha | Minnesota | 27157 | 50 | 0 |
342423 | 342423 | 2020-07-17 | Wabasha | Minnesota | 27157 | 50 | 0 |
339227 | 339227 | 2020-07-16 | Wabasha | Minnesota | 27157 | 49 | 0 |
336031 | 336031 | 2020-07-15 | Wabasha | Minnesota | 27157 | 46 | 0 |
332838 | 332838 | 2020-07-14 | Wabasha | Minnesota | 27157 | 44 | 0 |
329651 | 329651 | 2020-07-13 | Wabasha | Minnesota | 27157 | 43 | 0 |
326465 | 326465 | 2020-07-12 | Wabasha | Minnesota | 27157 | 39 | 0 |
323282 | 323282 | 2020-07-11 | Wabasha | Minnesota | 27157 | 38 | 0 |
320103 | 320103 | 2020-07-10 | Wabasha | Minnesota | 27157 | 35 | 0 |
316928 | 316928 | 2020-07-09 | Wabasha | Minnesota | 27157 | 34 | 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);