ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 27157 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921843 | 921843 | 2021-01-12 | Wabasha | Minnesota | 27157 | 1644 | 2 |
918598 | 918598 | 2021-01-11 | Wabasha | Minnesota | 27157 | 1631 | 2 |
915353 | 915353 | 2021-01-10 | Wabasha | Minnesota | 27157 | 1628 | 2 |
912108 | 912108 | 2021-01-09 | Wabasha | Minnesota | 27157 | 1625 | 2 |
908863 | 908863 | 2021-01-08 | Wabasha | Minnesota | 27157 | 1609 | 2 |
905617 | 905617 | 2021-01-07 | Wabasha | Minnesota | 27157 | 1592 | 2 |
902372 | 902372 | 2021-01-06 | Wabasha | Minnesota | 27157 | 1581 | 2 |
899127 | 899127 | 2021-01-05 | Wabasha | Minnesota | 27157 | 1568 | 2 |
895882 | 895882 | 2021-01-04 | Wabasha | Minnesota | 27157 | 1559 | 2 |
892635 | 892635 | 2021-01-03 | Wabasha | Minnesota | 27157 | 1521 | 2 |
889389 | 889389 | 2021-01-02 | Wabasha | Minnesota | 27157 | 1509 | 2 |
886143 | 886143 | 2021-01-01 | Wabasha | Minnesota | 27157 | 1500 | 2 |
882898 | 882898 | 2020-12-31 | Wabasha | Minnesota | 27157 | 1500 | 2 |
879653 | 879653 | 2020-12-30 | Wabasha | Minnesota | 27157 | 1484 | 2 |
876408 | 876408 | 2020-12-29 | Wabasha | Minnesota | 27157 | 1472 | 2 |
873163 | 873163 | 2020-12-28 | Wabasha | Minnesota | 27157 | 1465 | 2 |
869918 | 869918 | 2020-12-27 | Wabasha | Minnesota | 27157 | 1462 | 2 |
866673 | 866673 | 2020-12-26 | Wabasha | Minnesota | 27157 | 1452 | 2 |
863428 | 863428 | 2020-12-25 | Wabasha | Minnesota | 27157 | 1441 | 2 |
860183 | 860183 | 2020-12-24 | Wabasha | Minnesota | 27157 | 1441 | 2 |
856938 | 856938 | 2020-12-23 | Wabasha | Minnesota | 27157 | 1434 | 2 |
853693 | 853693 | 2020-12-22 | Wabasha | Minnesota | 27157 | 1423 | 2 |
850448 | 850448 | 2020-12-21 | Wabasha | Minnesota | 27157 | 1415 | 2 |
847203 | 847203 | 2020-12-20 | Wabasha | Minnesota | 27157 | 1405 | 2 |
843957 | 843957 | 2020-12-19 | Wabasha | Minnesota | 27157 | 1393 | 2 |
840712 | 840712 | 2020-12-18 | Wabasha | Minnesota | 27157 | 1374 | 2 |
837467 | 837467 | 2020-12-17 | Wabasha | Minnesota | 27157 | 1374 | 2 |
834221 | 834221 | 2020-12-16 | Wabasha | Minnesota | 27157 | 1366 | 2 |
830974 | 830974 | 2020-12-15 | Wabasha | Minnesota | 27157 | 1352 | 2 |
827728 | 827728 | 2020-12-14 | Wabasha | Minnesota | 27157 | 1347 | 2 |
824481 | 824481 | 2020-12-13 | Wabasha | Minnesota | 27157 | 1334 | 2 |
821235 | 821235 | 2020-12-12 | Wabasha | Minnesota | 27157 | 1318 | 2 |
817989 | 817989 | 2020-12-11 | Wabasha | Minnesota | 27157 | 1301 | 2 |
814743 | 814743 | 2020-12-10 | Wabasha | Minnesota | 27157 | 1269 | 2 |
811498 | 811498 | 2020-12-09 | Wabasha | Minnesota | 27157 | 1244 | 2 |
808253 | 808253 | 2020-12-08 | Wabasha | Minnesota | 27157 | 1227 | 1 |
805008 | 805008 | 2020-12-07 | Wabasha | Minnesota | 27157 | 1216 | 1 |
801763 | 801763 | 2020-12-06 | Wabasha | Minnesota | 27157 | 1185 | 1 |
798518 | 798518 | 2020-12-05 | Wabasha | Minnesota | 27157 | 1167 | 1 |
795273 | 795273 | 2020-12-04 | Wabasha | Minnesota | 27157 | 1143 | 1 |
792028 | 792028 | 2020-12-03 | Wabasha | Minnesota | 27157 | 1130 | 1 |
788783 | 788783 | 2020-12-02 | Wabasha | Minnesota | 27157 | 1104 | 1 |
785538 | 785538 | 2020-12-01 | Wabasha | Minnesota | 27157 | 1087 | 1 |
782294 | 782294 | 2020-11-30 | Wabasha | Minnesota | 27157 | 1078 | 1 |
779048 | 779048 | 2020-11-29 | Wabasha | Minnesota | 27157 | 1056 | 1 |
775803 | 775803 | 2020-11-28 | Wabasha | Minnesota | 27157 | 1030 | 1 |
772558 | 772558 | 2020-11-27 | Wabasha | Minnesota | 27157 | 994 | 1 |
769313 | 769313 | 2020-11-26 | Wabasha | Minnesota | 27157 | 961 | 1 |
766067 | 766067 | 2020-11-25 | Wabasha | Minnesota | 27157 | 961 | 1 |
762822 | 762822 | 2020-11-24 | Wabasha | Minnesota | 27157 | 935 | 1 |
759577 | 759577 | 2020-11-23 | Wabasha | Minnesota | 27157 | 912 | 1 |
756330 | 756330 | 2020-11-22 | Wabasha | Minnesota | 27157 | 896 | 1 |
753084 | 753084 | 2020-11-21 | Wabasha | Minnesota | 27157 | 862 | 1 |
749838 | 749838 | 2020-11-20 | Wabasha | Minnesota | 27157 | 835 | 1 |
746592 | 746592 | 2020-11-19 | Wabasha | Minnesota | 27157 | 801 | 1 |
743345 | 743345 | 2020-11-18 | Wabasha | Minnesota | 27157 | 780 | 1 |
740098 | 740098 | 2020-11-17 | Wabasha | Minnesota | 27157 | 755 | 1 |
736854 | 736854 | 2020-11-16 | Wabasha | Minnesota | 27157 | 722 | 1 |
733608 | 733608 | 2020-11-15 | Wabasha | Minnesota | 27157 | 686 | 1 |
730363 | 730363 | 2020-11-14 | Wabasha | Minnesota | 27157 | 606 | 1 |
727120 | 727120 | 2020-11-13 | Wabasha | Minnesota | 27157 | 587 | 1 |
723877 | 723877 | 2020-11-12 | Wabasha | Minnesota | 27157 | 587 | 2 |
720634 | 720634 | 2020-11-11 | Wabasha | Minnesota | 27157 | 564 | 1 |
717391 | 717391 | 2020-11-10 | Wabasha | Minnesota | 27157 | 555 | 1 |
714147 | 714147 | 2020-11-09 | Wabasha | Minnesota | 27157 | 551 | 1 |
710903 | 710903 | 2020-11-08 | Wabasha | Minnesota | 27157 | 544 | 1 |
707659 | 707659 | 2020-11-07 | Wabasha | Minnesota | 27157 | 535 | 1 |
704416 | 704416 | 2020-11-06 | Wabasha | Minnesota | 27157 | 515 | 1 |
701174 | 701174 | 2020-11-05 | Wabasha | Minnesota | 27157 | 497 | 1 |
697930 | 697930 | 2020-11-04 | Wabasha | Minnesota | 27157 | 472 | 1 |
694687 | 694687 | 2020-11-03 | Wabasha | Minnesota | 27157 | 459 | 1 |
691445 | 691445 | 2020-11-02 | Wabasha | Minnesota | 27157 | 454 | 1 |
688200 | 688200 | 2020-11-01 | Wabasha | Minnesota | 27157 | 446 | 1 |
684956 | 684956 | 2020-10-31 | Wabasha | Minnesota | 27157 | 435 | 1 |
681713 | 681713 | 2020-10-30 | Wabasha | Minnesota | 27157 | 428 | 1 |
678469 | 678469 | 2020-10-29 | Wabasha | Minnesota | 27157 | 414 | 1 |
675227 | 675227 | 2020-10-28 | Wabasha | Minnesota | 27157 | 405 | 0 |
671984 | 671984 | 2020-10-27 | Wabasha | Minnesota | 27157 | 397 | 0 |
668742 | 668742 | 2020-10-26 | Wabasha | Minnesota | 27157 | 384 | 0 |
665498 | 665498 | 2020-10-25 | Wabasha | Minnesota | 27157 | 378 | 0 |
662253 | 662253 | 2020-10-24 | Wabasha | Minnesota | 27157 | 370 | 0 |
659009 | 659009 | 2020-10-23 | Wabasha | Minnesota | 27157 | 359 | 0 |
655764 | 655764 | 2020-10-22 | Wabasha | Minnesota | 27157 | 343 | 0 |
652519 | 652519 | 2020-10-21 | Wabasha | Minnesota | 27157 | 332 | 0 |
649274 | 649274 | 2020-10-20 | Wabasha | Minnesota | 27157 | 327 | 0 |
646030 | 646030 | 2020-10-19 | Wabasha | Minnesota | 27157 | 323 | 0 |
642783 | 642783 | 2020-10-18 | Wabasha | Minnesota | 27157 | 320 | 0 |
639536 | 639536 | 2020-10-17 | Wabasha | Minnesota | 27157 | 310 | 0 |
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 |
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);