ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Dodge" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921783 | 921783 | 2021-01-12 | Dodge | Minnesota | 27039 | 1285 | 4 |
918538 | 918538 | 2021-01-11 | Dodge | Minnesota | 27039 | 1274 | 4 |
915293 | 915293 | 2021-01-10 | Dodge | Minnesota | 27039 | 1273 | 4 |
912048 | 912048 | 2021-01-09 | Dodge | Minnesota | 27039 | 1273 | 4 |
908803 | 908803 | 2021-01-08 | Dodge | Minnesota | 27039 | 1254 | 4 |
905557 | 905557 | 2021-01-07 | Dodge | Minnesota | 27039 | 1245 | 4 |
902312 | 902312 | 2021-01-06 | Dodge | Minnesota | 27039 | 1233 | 4 |
899067 | 899067 | 2021-01-05 | Dodge | Minnesota | 27039 | 1210 | 4 |
895822 | 895822 | 2021-01-04 | Dodge | Minnesota | 27039 | 1205 | 4 |
892575 | 892575 | 2021-01-03 | Dodge | Minnesota | 27039 | 1186 | 4 |
889329 | 889329 | 2021-01-02 | Dodge | Minnesota | 27039 | 1184 | 4 |
886083 | 886083 | 2021-01-01 | Dodge | Minnesota | 27039 | 1175 | 4 |
882838 | 882838 | 2020-12-31 | Dodge | Minnesota | 27039 | 1175 | 4 |
879593 | 879593 | 2020-12-30 | Dodge | Minnesota | 27039 | 1159 | 4 |
876348 | 876348 | 2020-12-29 | Dodge | Minnesota | 27039 | 1151 | 4 |
873103 | 873103 | 2020-12-28 | Dodge | Minnesota | 27039 | 1148 | 4 |
869858 | 869858 | 2020-12-27 | Dodge | Minnesota | 27039 | 1145 | 4 |
866613 | 866613 | 2020-12-26 | Dodge | Minnesota | 27039 | 1138 | 4 |
863368 | 863368 | 2020-12-25 | Dodge | Minnesota | 27039 | 1136 | 3 |
860123 | 860123 | 2020-12-24 | Dodge | Minnesota | 27039 | 1136 | 3 |
856878 | 856878 | 2020-12-23 | Dodge | Minnesota | 27039 | 1132 | 3 |
853633 | 853633 | 2020-12-22 | Dodge | Minnesota | 27039 | 1129 | 3 |
850388 | 850388 | 2020-12-21 | Dodge | Minnesota | 27039 | 1127 | 3 |
847143 | 847143 | 2020-12-20 | Dodge | Minnesota | 27039 | 1124 | 3 |
843897 | 843897 | 2020-12-19 | Dodge | Minnesota | 27039 | 1106 | 3 |
840652 | 840652 | 2020-12-18 | Dodge | Minnesota | 27039 | 1092 | 3 |
837407 | 837407 | 2020-12-17 | Dodge | Minnesota | 27039 | 1087 | 3 |
834161 | 834161 | 2020-12-16 | Dodge | Minnesota | 27039 | 1077 | 3 |
830914 | 830914 | 2020-12-15 | Dodge | Minnesota | 27039 | 1062 | 3 |
827668 | 827668 | 2020-12-14 | Dodge | Minnesota | 27039 | 1058 | 3 |
824421 | 824421 | 2020-12-13 | Dodge | Minnesota | 27039 | 1049 | 3 |
821175 | 821175 | 2020-12-12 | Dodge | Minnesota | 27039 | 1037 | 1 |
817929 | 817929 | 2020-12-11 | Dodge | Minnesota | 27039 | 1026 | 1 |
814683 | 814683 | 2020-12-10 | Dodge | Minnesota | 27039 | 1017 | 1 |
811438 | 811438 | 2020-12-09 | Dodge | Minnesota | 27039 | 1008 | 1 |
808193 | 808193 | 2020-12-08 | Dodge | Minnesota | 27039 | 993 | 1 |
804948 | 804948 | 2020-12-07 | Dodge | Minnesota | 27039 | 988 | 1 |
801703 | 801703 | 2020-12-06 | Dodge | Minnesota | 27039 | 980 | 1 |
798458 | 798458 | 2020-12-05 | Dodge | Minnesota | 27039 | 967 | 1 |
795213 | 795213 | 2020-12-04 | Dodge | Minnesota | 27039 | 940 | 1 |
791968 | 791968 | 2020-12-03 | Dodge | Minnesota | 27039 | 931 | 1 |
788723 | 788723 | 2020-12-02 | Dodge | Minnesota | 27039 | 911 | 0 |
785478 | 785478 | 2020-12-01 | Dodge | Minnesota | 27039 | 888 | 0 |
782234 | 782234 | 2020-11-30 | Dodge | Minnesota | 27039 | 870 | 0 |
778988 | 778988 | 2020-11-29 | Dodge | Minnesota | 27039 | 860 | 0 |
775743 | 775743 | 2020-11-28 | Dodge | Minnesota | 27039 | 838 | 0 |
772498 | 772498 | 2020-11-27 | Dodge | Minnesota | 27039 | 823 | 0 |
769253 | 769253 | 2020-11-26 | Dodge | Minnesota | 27039 | 806 | 0 |
766007 | 766007 | 2020-11-25 | Dodge | Minnesota | 27039 | 806 | 0 |
762762 | 762762 | 2020-11-24 | Dodge | Minnesota | 27039 | 798 | 0 |
759517 | 759517 | 2020-11-23 | Dodge | Minnesota | 27039 | 785 | 0 |
756270 | 756270 | 2020-11-22 | Dodge | Minnesota | 27039 | 777 | 0 |
753024 | 753024 | 2020-11-21 | Dodge | Minnesota | 27039 | 752 | 0 |
749778 | 749778 | 2020-11-20 | Dodge | Minnesota | 27039 | 741 | 0 |
746532 | 746532 | 2020-11-19 | Dodge | Minnesota | 27039 | 723 | 0 |
743285 | 743285 | 2020-11-18 | Dodge | Minnesota | 27039 | 699 | 0 |
740038 | 740038 | 2020-11-17 | Dodge | Minnesota | 27039 | 688 | 0 |
736794 | 736794 | 2020-11-16 | Dodge | Minnesota | 27039 | 672 | 0 |
733548 | 733548 | 2020-11-15 | Dodge | Minnesota | 27039 | 639 | 0 |
730303 | 730303 | 2020-11-14 | Dodge | Minnesota | 27039 | 541 | 0 |
727060 | 727060 | 2020-11-13 | Dodge | Minnesota | 27039 | 525 | 0 |
723817 | 723817 | 2020-11-12 | Dodge | Minnesota | 27039 | 519 | 0 |
720574 | 720574 | 2020-11-11 | Dodge | Minnesota | 27039 | 510 | 0 |
717331 | 717331 | 2020-11-10 | Dodge | Minnesota | 27039 | 502 | 0 |
714087 | 714087 | 2020-11-09 | Dodge | Minnesota | 27039 | 500 | 0 |
710843 | 710843 | 2020-11-08 | Dodge | Minnesota | 27039 | 500 | 0 |
707599 | 707599 | 2020-11-07 | Dodge | Minnesota | 27039 | 496 | 0 |
704356 | 704356 | 2020-11-06 | Dodge | Minnesota | 27039 | 484 | 0 |
701114 | 701114 | 2020-11-05 | Dodge | Minnesota | 27039 | 473 | 0 |
697870 | 697870 | 2020-11-04 | Dodge | Minnesota | 27039 | 463 | 0 |
694627 | 694627 | 2020-11-03 | Dodge | Minnesota | 27039 | 450 | 0 |
691385 | 691385 | 2020-11-02 | Dodge | Minnesota | 27039 | 443 | 0 |
688140 | 688140 | 2020-11-01 | Dodge | Minnesota | 27039 | 432 | 0 |
684896 | 684896 | 2020-10-31 | Dodge | Minnesota | 27039 | 424 | 0 |
681653 | 681653 | 2020-10-30 | Dodge | Minnesota | 27039 | 420 | 0 |
678409 | 678409 | 2020-10-29 | Dodge | Minnesota | 27039 | 413 | 0 |
675167 | 675167 | 2020-10-28 | Dodge | Minnesota | 27039 | 405 | 0 |
671924 | 671924 | 2020-10-27 | Dodge | Minnesota | 27039 | 404 | 0 |
668682 | 668682 | 2020-10-26 | Dodge | Minnesota | 27039 | 394 | 0 |
665438 | 665438 | 2020-10-25 | Dodge | Minnesota | 27039 | 394 | 0 |
662193 | 662193 | 2020-10-24 | Dodge | Minnesota | 27039 | 392 | 0 |
658949 | 658949 | 2020-10-23 | Dodge | Minnesota | 27039 | 386 | 0 |
655704 | 655704 | 2020-10-22 | Dodge | Minnesota | 27039 | 379 | 0 |
652459 | 652459 | 2020-10-21 | Dodge | Minnesota | 27039 | 370 | 0 |
649214 | 649214 | 2020-10-20 | Dodge | Minnesota | 27039 | 366 | 0 |
645970 | 645970 | 2020-10-19 | Dodge | Minnesota | 27039 | 362 | 0 |
642723 | 642723 | 2020-10-18 | Dodge | Minnesota | 27039 | 360 | 0 |
639476 | 639476 | 2020-10-17 | Dodge | Minnesota | 27039 | 353 | 0 |
636230 | 636230 | 2020-10-16 | Dodge | Minnesota | 27039 | 349 | 0 |
632984 | 632984 | 2020-10-15 | Dodge | Minnesota | 27039 | 340 | 0 |
629739 | 629739 | 2020-10-14 | Dodge | Minnesota | 27039 | 341 | 0 |
626495 | 626495 | 2020-10-13 | Dodge | Minnesota | 27039 | 338 | 0 |
623253 | 623253 | 2020-10-12 | Dodge | Minnesota | 27039 | 338 | 0 |
620010 | 620010 | 2020-10-11 | Dodge | Minnesota | 27039 | 334 | 0 |
616768 | 616768 | 2020-10-10 | Dodge | Minnesota | 27039 | 331 | 0 |
613527 | 613527 | 2020-10-09 | Dodge | Minnesota | 27039 | 319 | 0 |
610285 | 610285 | 2020-10-08 | Dodge | Minnesota | 27039 | 305 | 0 |
607043 | 607043 | 2020-10-07 | Dodge | Minnesota | 27039 | 296 | 0 |
603800 | 603800 | 2020-10-06 | Dodge | Minnesota | 27039 | 289 | 0 |
600558 | 600558 | 2020-10-05 | Dodge | Minnesota | 27039 | 283 | 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);