ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 27103 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
607075 | 607075 | 2020-10-07 | Nicollet | Minnesota | 27103 | 607 | 17 |
603832 | 603832 | 2020-10-06 | Nicollet | Minnesota | 27103 | 602 | 17 |
600590 | 600590 | 2020-10-05 | Nicollet | Minnesota | 27103 | 594 | 17 |
597347 | 597347 | 2020-10-04 | Nicollet | Minnesota | 27103 | 589 | 17 |
594106 | 594106 | 2020-10-03 | Nicollet | Minnesota | 27103 | 583 | 17 |
590865 | 590865 | 2020-10-02 | Nicollet | Minnesota | 27103 | 570 | 17 |
587624 | 587624 | 2020-10-01 | Nicollet | Minnesota | 27103 | 562 | 17 |
584384 | 584384 | 2020-09-30 | Nicollet | Minnesota | 27103 | 553 | 17 |
581143 | 581143 | 2020-09-29 | Nicollet | Minnesota | 27103 | 547 | 17 |
577902 | 577902 | 2020-09-28 | Nicollet | Minnesota | 27103 | 545 | 17 |
574661 | 574661 | 2020-09-27 | Nicollet | Minnesota | 27103 | 542 | 17 |
571418 | 571418 | 2020-09-26 | Nicollet | Minnesota | 27103 | 540 | 16 |
568176 | 568176 | 2020-09-25 | Nicollet | Minnesota | 27103 | 529 | 16 |
564936 | 564936 | 2020-09-24 | Nicollet | Minnesota | 27103 | 521 | 16 |
561696 | 561696 | 2020-09-23 | Nicollet | Minnesota | 27103 | 515 | 16 |
558459 | 558459 | 2020-09-22 | Nicollet | Minnesota | 27103 | 513 | 16 |
555222 | 555222 | 2020-09-21 | Nicollet | Minnesota | 27103 | 504 | 16 |
551984 | 551984 | 2020-09-20 | Nicollet | Minnesota | 27103 | 499 | 16 |
548745 | 548745 | 2020-09-19 | Nicollet | Minnesota | 27103 | 496 | 16 |
545507 | 545507 | 2020-09-18 | Nicollet | Minnesota | 27103 | 495 | 16 |
542270 | 542270 | 2020-09-17 | Nicollet | Minnesota | 27103 | 487 | 16 |
539034 | 539034 | 2020-09-16 | Nicollet | Minnesota | 27103 | 484 | 16 |
535797 | 535797 | 2020-09-15 | Nicollet | Minnesota | 27103 | 484 | 16 |
532562 | 532562 | 2020-09-14 | Nicollet | Minnesota | 27103 | 479 | 16 |
529326 | 529326 | 2020-09-13 | Nicollet | Minnesota | 27103 | 476 | 16 |
526090 | 526090 | 2020-09-12 | Nicollet | Minnesota | 27103 | 474 | 16 |
522854 | 522854 | 2020-09-11 | Nicollet | Minnesota | 27103 | 471 | 16 |
519617 | 519617 | 2020-09-10 | Nicollet | Minnesota | 27103 | 469 | 16 |
516382 | 516382 | 2020-09-09 | Nicollet | Minnesota | 27103 | 461 | 15 |
513148 | 513148 | 2020-09-08 | Nicollet | Minnesota | 27103 | 459 | 15 |
509916 | 509916 | 2020-09-07 | Nicollet | Minnesota | 27103 | 457 | 15 |
506683 | 506683 | 2020-09-06 | Nicollet | Minnesota | 27103 | 456 | 15 |
503450 | 503450 | 2020-09-05 | Nicollet | Minnesota | 27103 | 455 | 15 |
500216 | 500216 | 2020-09-04 | Nicollet | Minnesota | 27103 | 452 | 15 |
496982 | 496982 | 2020-09-03 | Nicollet | Minnesota | 27103 | 449 | 15 |
493749 | 493749 | 2020-09-02 | Nicollet | Minnesota | 27103 | 445 | 15 |
490515 | 490515 | 2020-09-01 | Nicollet | Minnesota | 27103 | 442 | 15 |
487282 | 487282 | 2020-08-31 | Nicollet | Minnesota | 27103 | 442 | 15 |
484048 | 484048 | 2020-08-30 | Nicollet | Minnesota | 27103 | 438 | 15 |
480813 | 480813 | 2020-08-29 | Nicollet | Minnesota | 27103 | 436 | 15 |
477581 | 477581 | 2020-08-28 | Nicollet | Minnesota | 27103 | 427 | 15 |
474348 | 474348 | 2020-08-27 | Nicollet | Minnesota | 27103 | 423 | 15 |
471116 | 471116 | 2020-08-26 | Nicollet | Minnesota | 27103 | 413 | 15 |
467886 | 467886 | 2020-08-25 | Nicollet | Minnesota | 27103 | 413 | 14 |
464657 | 464657 | 2020-08-24 | Nicollet | Minnesota | 27103 | 412 | 14 |
461426 | 461426 | 2020-08-23 | Nicollet | Minnesota | 27103 | 408 | 14 |
458199 | 458199 | 2020-08-22 | Nicollet | Minnesota | 27103 | 404 | 14 |
454971 | 454971 | 2020-08-21 | Nicollet | Minnesota | 27103 | 402 | 14 |
451743 | 451743 | 2020-08-20 | Nicollet | Minnesota | 27103 | 396 | 13 |
448515 | 448515 | 2020-08-19 | Nicollet | Minnesota | 27103 | 386 | 13 |
445289 | 445289 | 2020-08-18 | Nicollet | Minnesota | 27103 | 384 | 13 |
442063 | 442063 | 2020-08-17 | Nicollet | Minnesota | 27103 | 378 | 13 |
438836 | 438836 | 2020-08-16 | Nicollet | Minnesota | 27103 | 375 | 13 |
435611 | 435611 | 2020-08-15 | Nicollet | Minnesota | 27103 | 371 | 13 |
432385 | 432385 | 2020-08-14 | Nicollet | Minnesota | 27103 | 363 | 13 |
429158 | 429158 | 2020-08-13 | Nicollet | Minnesota | 27103 | 356 | 13 |
425934 | 425934 | 2020-08-12 | Nicollet | Minnesota | 27103 | 351 | 13 |
422712 | 422712 | 2020-08-11 | Nicollet | Minnesota | 27103 | 347 | 13 |
419490 | 419490 | 2020-08-10 | Nicollet | Minnesota | 27103 | 342 | 13 |
416269 | 416269 | 2020-08-09 | Nicollet | Minnesota | 27103 | 337 | 13 |
413049 | 413049 | 2020-08-08 | Nicollet | Minnesota | 27103 | 333 | 13 |
409829 | 409829 | 2020-08-07 | Nicollet | Minnesota | 27103 | 329 | 13 |
406609 | 406609 | 2020-08-06 | Nicollet | Minnesota | 27103 | 329 | 13 |
403391 | 403391 | 2020-08-05 | Nicollet | Minnesota | 27103 | 322 | 13 |
400174 | 400174 | 2020-08-04 | Nicollet | Minnesota | 27103 | 320 | 13 |
396960 | 396960 | 2020-08-03 | Nicollet | Minnesota | 27103 | 312 | 13 |
393744 | 393744 | 2020-08-02 | Nicollet | Minnesota | 27103 | 307 | 13 |
390527 | 390527 | 2020-08-01 | Nicollet | Minnesota | 27103 | 303 | 13 |
387310 | 387310 | 2020-07-31 | Nicollet | Minnesota | 27103 | 298 | 13 |
384092 | 384092 | 2020-07-30 | Nicollet | Minnesota | 27103 | 287 | 13 |
380875 | 380875 | 2020-07-29 | Nicollet | Minnesota | 27103 | 281 | 13 |
377658 | 377658 | 2020-07-28 | Nicollet | Minnesota | 27103 | 271 | 13 |
374443 | 374443 | 2020-07-27 | Nicollet | Minnesota | 27103 | 270 | 13 |
371231 | 371231 | 2020-07-26 | Nicollet | Minnesota | 27103 | 266 | 13 |
368021 | 368021 | 2020-07-25 | Nicollet | Minnesota | 27103 | 262 | 13 |
364813 | 364813 | 2020-07-24 | Nicollet | Minnesota | 27103 | 252 | 13 |
361606 | 361606 | 2020-07-23 | Nicollet | Minnesota | 27103 | 249 | 13 |
358401 | 358401 | 2020-07-22 | Nicollet | Minnesota | 27103 | 243 | 13 |
355198 | 355198 | 2020-07-21 | Nicollet | Minnesota | 27103 | 238 | 13 |
351996 | 351996 | 2020-07-20 | Nicollet | Minnesota | 27103 | 226 | 13 |
348796 | 348796 | 2020-07-19 | Nicollet | Minnesota | 27103 | 225 | 13 |
345595 | 345595 | 2020-07-18 | Nicollet | Minnesota | 27103 | 220 | 13 |
342395 | 342395 | 2020-07-17 | Nicollet | Minnesota | 27103 | 218 | 13 |
339199 | 339199 | 2020-07-16 | Nicollet | Minnesota | 27103 | 219 | 13 |
336003 | 336003 | 2020-07-15 | Nicollet | Minnesota | 27103 | 215 | 13 |
332810 | 332810 | 2020-07-14 | Nicollet | Minnesota | 27103 | 212 | 12 |
329623 | 329623 | 2020-07-13 | Nicollet | Minnesota | 27103 | 207 | 12 |
326437 | 326437 | 2020-07-12 | Nicollet | Minnesota | 27103 | 206 | 12 |
323254 | 323254 | 2020-07-11 | Nicollet | Minnesota | 27103 | 203 | 12 |
320075 | 320075 | 2020-07-10 | Nicollet | Minnesota | 27103 | 191 | 12 |
316900 | 316900 | 2020-07-09 | Nicollet | Minnesota | 27103 | 187 | 12 |
313726 | 313726 | 2020-07-08 | Nicollet | Minnesota | 27103 | 176 | 12 |
310556 | 310556 | 2020-07-07 | Nicollet | Minnesota | 27103 | 173 | 12 |
307388 | 307388 | 2020-07-06 | Nicollet | Minnesota | 27103 | 169 | 12 |
304221 | 304221 | 2020-07-05 | Nicollet | Minnesota | 27103 | 166 | 12 |
301057 | 301057 | 2020-07-04 | Nicollet | Minnesota | 27103 | 159 | 12 |
297894 | 297894 | 2020-07-03 | Nicollet | Minnesota | 27103 | 159 | 12 |
294736 | 294736 | 2020-07-02 | Nicollet | Minnesota | 27103 | 155 | 12 |
291582 | 291582 | 2020-07-01 | Nicollet | Minnesota | 27103 | 149 | 12 |
288431 | 288431 | 2020-06-30 | Nicollet | Minnesota | 27103 | 144 | 12 |
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);