ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 27039 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093798 | 1093798 | 2021-03-06 | Dodge | Minnesota | 27039 | 1540 | 4 |
1090552 | 1090552 | 2021-03-05 | Dodge | Minnesota | 27039 | 1538 | 4 |
1087307 | 1087307 | 2021-03-04 | Dodge | Minnesota | 27039 | 1535 | 4 |
1084062 | 1084062 | 2021-03-03 | Dodge | Minnesota | 27039 | 1529 | 4 |
1080816 | 1080816 | 2021-03-02 | Dodge | Minnesota | 27039 | 1522 | 4 |
1077570 | 1077570 | 2021-03-01 | Dodge | Minnesota | 27039 | 1521 | 4 |
1074324 | 1074324 | 2021-02-28 | Dodge | Minnesota | 27039 | 1521 | 4 |
1071078 | 1071078 | 2021-02-27 | Dodge | Minnesota | 27039 | 1515 | 4 |
1067833 | 1067833 | 2021-02-26 | Dodge | Minnesota | 27039 | 1515 | 4 |
1064588 | 1064588 | 2021-02-25 | Dodge | Minnesota | 27039 | 1514 | 4 |
1061344 | 1061344 | 2021-02-24 | Dodge | Minnesota | 27039 | 1512 | 4 |
1058098 | 1058098 | 2021-02-23 | Dodge | Minnesota | 27039 | 1511 | 4 |
1054852 | 1054852 | 2021-02-22 | Dodge | Minnesota | 27039 | 1511 | 4 |
1051605 | 1051605 | 2021-02-21 | Dodge | Minnesota | 27039 | 1510 | 4 |
1048358 | 1048358 | 2021-02-20 | Dodge | Minnesota | 27039 | 1505 | 4 |
1045112 | 1045112 | 2021-02-19 | Dodge | Minnesota | 27039 | 1505 | 4 |
1041867 | 1041867 | 2021-02-18 | Dodge | Minnesota | 27039 | 1501 | 4 |
1038622 | 1038622 | 2021-02-17 | Dodge | Minnesota | 27039 | 1495 | 4 |
1035377 | 1035377 | 2021-02-16 | Dodge | Minnesota | 27039 | 1492 | 4 |
1032132 | 1032132 | 2021-02-15 | Dodge | Minnesota | 27039 | 1489 | 4 |
1028885 | 1028885 | 2021-02-14 | Dodge | Minnesota | 27039 | 1488 | 4 |
1025639 | 1025639 | 2021-02-13 | Dodge | Minnesota | 27039 | 1485 | 4 |
1022394 | 1022394 | 2021-02-12 | Dodge | Minnesota | 27039 | 1480 | 4 |
1019149 | 1019149 | 2021-02-11 | Dodge | Minnesota | 27039 | 1479 | 4 |
1015904 | 1015904 | 2021-02-10 | Dodge | Minnesota | 27039 | 1475 | 4 |
1012659 | 1012659 | 2021-02-09 | Dodge | Minnesota | 27039 | 1469 | 4 |
1009414 | 1009414 | 2021-02-08 | Dodge | Minnesota | 27039 | 1465 | 4 |
1006167 | 1006167 | 2021-02-07 | Dodge | Minnesota | 27039 | 1463 | 4 |
1002921 | 1002921 | 2021-02-06 | Dodge | Minnesota | 27039 | 1454 | 4 |
999676 | 999676 | 2021-02-05 | Dodge | Minnesota | 27039 | 1451 | 4 |
996430 | 996430 | 2021-02-04 | Dodge | Minnesota | 27039 | 1447 | 4 |
993184 | 993184 | 2021-02-03 | Dodge | Minnesota | 27039 | 1443 | 4 |
989938 | 989938 | 2021-02-02 | Dodge | Minnesota | 27039 | 1436 | 4 |
986691 | 986691 | 2021-02-01 | Dodge | Minnesota | 27039 | 1435 | 4 |
983444 | 983444 | 2021-01-31 | Dodge | Minnesota | 27039 | 1432 | 4 |
980198 | 980198 | 2021-01-30 | Dodge | Minnesota | 27039 | 1425 | 4 |
976952 | 976952 | 2021-01-29 | Dodge | Minnesota | 27039 | 1423 | 4 |
973707 | 973707 | 2021-01-28 | Dodge | Minnesota | 27039 | 1416 | 4 |
970462 | 970462 | 2021-01-27 | Dodge | Minnesota | 27039 | 1407 | 4 |
967217 | 967217 | 2021-01-26 | Dodge | Minnesota | 27039 | 1401 | 4 |
963973 | 963973 | 2021-01-25 | Dodge | Minnesota | 27039 | 1397 | 4 |
960728 | 960728 | 2021-01-24 | Dodge | Minnesota | 27039 | 1393 | 4 |
957482 | 957482 | 2021-01-23 | Dodge | Minnesota | 27039 | 1386 | 4 |
954237 | 954237 | 2021-01-22 | Dodge | Minnesota | 27039 | 1371 | 4 |
950992 | 950992 | 2021-01-21 | Dodge | Minnesota | 27039 | 1362 | 4 |
947746 | 947746 | 2021-01-20 | Dodge | Minnesota | 27039 | 1354 | 4 |
944499 | 944499 | 2021-01-19 | Dodge | Minnesota | 27039 | 1347 | 4 |
941254 | 941254 | 2021-01-18 | Dodge | Minnesota | 27039 | 1343 | 4 |
938009 | 938009 | 2021-01-17 | Dodge | Minnesota | 27039 | 1338 | 4 |
934764 | 934764 | 2021-01-16 | Dodge | Minnesota | 27039 | 1330 | 4 |
931519 | 931519 | 2021-01-15 | Dodge | Minnesota | 27039 | 1324 | 4 |
928274 | 928274 | 2021-01-14 | Dodge | Minnesota | 27039 | 1313 | 4 |
925028 | 925028 | 2021-01-13 | Dodge | Minnesota | 27039 | 1300 | 4 |
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 |
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);