ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Nicollet" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194486 | 1194486 | 2021-04-06 | Nicollet | Minnesota | 27103 | 2917 | 42 |
1191237 | 1191237 | 2021-04-05 | Nicollet | Minnesota | 27103 | 2882 | 42 |
1187989 | 1187989 | 2021-04-04 | Nicollet | Minnesota | 27103 | 2877 | 42 |
1184742 | 1184742 | 2021-04-03 | Nicollet | Minnesota | 27103 | 2877 | 42 |
1181496 | 1181496 | 2021-04-02 | Nicollet | Minnesota | 27103 | 2868 | 42 |
1178249 | 1178249 | 2021-04-01 | Nicollet | Minnesota | 27103 | 2860 | 42 |
1175002 | 1175002 | 2021-03-31 | Nicollet | Minnesota | 27103 | 2840 | 42 |
1171755 | 1171755 | 2021-03-30 | Nicollet | Minnesota | 27103 | 2831 | 42 |
1168507 | 1168507 | 2021-03-29 | Nicollet | Minnesota | 27103 | 2820 | 42 |
1165259 | 1165259 | 2021-03-28 | Nicollet | Minnesota | 27103 | 2807 | 42 |
1162011 | 1162011 | 2021-03-27 | Nicollet | Minnesota | 27103 | 2799 | 42 |
1158763 | 1158763 | 2021-03-26 | Nicollet | Minnesota | 27103 | 2791 | 42 |
1155516 | 1155516 | 2021-03-25 | Nicollet | Minnesota | 27103 | 2780 | 42 |
1152269 | 1152269 | 2021-03-24 | Nicollet | Minnesota | 27103 | 2768 | 42 |
1149022 | 1149022 | 2021-03-23 | Nicollet | Minnesota | 27103 | 2762 | 42 |
1145775 | 1145775 | 2021-03-22 | Nicollet | Minnesota | 27103 | 2756 | 42 |
1142528 | 1142528 | 2021-03-21 | Nicollet | Minnesota | 27103 | 2743 | 42 |
1139281 | 1139281 | 2021-03-20 | Nicollet | Minnesota | 27103 | 2736 | 42 |
1136035 | 1136035 | 2021-03-19 | Nicollet | Minnesota | 27103 | 2732 | 42 |
1132789 | 1132789 | 2021-03-18 | Nicollet | Minnesota | 27103 | 2722 | 42 |
1129541 | 1129541 | 2021-03-17 | Nicollet | Minnesota | 27103 | 2718 | 42 |
1126294 | 1126294 | 2021-03-16 | Nicollet | Minnesota | 27103 | 2717 | 42 |
1123048 | 1123048 | 2021-03-15 | Nicollet | Minnesota | 27103 | 2707 | 42 |
1119801 | 1119801 | 2021-03-14 | Nicollet | Minnesota | 27103 | 2703 | 42 |
1116554 | 1116554 | 2021-03-13 | Nicollet | Minnesota | 27103 | 2691 | 42 |
1113308 | 1113308 | 2021-03-12 | Nicollet | Minnesota | 27103 | 2684 | 42 |
1110062 | 1110062 | 2021-03-11 | Nicollet | Minnesota | 27103 | 2675 | 42 |
1106816 | 1106816 | 2021-03-10 | Nicollet | Minnesota | 27103 | 2666 | 42 |
1103570 | 1103570 | 2021-03-09 | Nicollet | Minnesota | 27103 | 2654 | 42 |
1100324 | 1100324 | 2021-03-08 | Nicollet | Minnesota | 27103 | 2639 | 41 |
1097077 | 1097077 | 2021-03-07 | Nicollet | Minnesota | 27103 | 2633 | 41 |
1093830 | 1093830 | 2021-03-06 | Nicollet | Minnesota | 27103 | 2624 | 41 |
1090584 | 1090584 | 2021-03-05 | Nicollet | Minnesota | 27103 | 2615 | 41 |
1087339 | 1087339 | 2021-03-04 | Nicollet | Minnesota | 27103 | 2604 | 41 |
1084094 | 1084094 | 2021-03-03 | Nicollet | Minnesota | 27103 | 2592 | 41 |
1080848 | 1080848 | 2021-03-02 | Nicollet | Minnesota | 27103 | 2586 | 41 |
1077602 | 1077602 | 2021-03-01 | Nicollet | Minnesota | 27103 | 2581 | 41 |
1074356 | 1074356 | 2021-02-28 | Nicollet | Minnesota | 27103 | 2570 | 41 |
1071110 | 1071110 | 2021-02-27 | Nicollet | Minnesota | 27103 | 2560 | 41 |
1067865 | 1067865 | 2021-02-26 | Nicollet | Minnesota | 27103 | 2546 | 41 |
1064620 | 1064620 | 2021-02-25 | Nicollet | Minnesota | 27103 | 2531 | 41 |
1061376 | 1061376 | 2021-02-24 | Nicollet | Minnesota | 27103 | 2523 | 41 |
1058130 | 1058130 | 2021-02-23 | Nicollet | Minnesota | 27103 | 2512 | 41 |
1054884 | 1054884 | 2021-02-22 | Nicollet | Minnesota | 27103 | 2509 | 41 |
1051637 | 1051637 | 2021-02-21 | Nicollet | Minnesota | 27103 | 2500 | 41 |
1048390 | 1048390 | 2021-02-20 | Nicollet | Minnesota | 27103 | 2480 | 41 |
1045144 | 1045144 | 2021-02-19 | Nicollet | Minnesota | 27103 | 2473 | 41 |
1041899 | 1041899 | 2021-02-18 | Nicollet | Minnesota | 27103 | 2467 | 41 |
1038654 | 1038654 | 2021-02-17 | Nicollet | Minnesota | 27103 | 2464 | 40 |
1035409 | 1035409 | 2021-02-16 | Nicollet | Minnesota | 27103 | 2459 | 40 |
1032164 | 1032164 | 2021-02-15 | Nicollet | Minnesota | 27103 | 2457 | 40 |
1028917 | 1028917 | 2021-02-14 | Nicollet | Minnesota | 27103 | 2453 | 40 |
1025671 | 1025671 | 2021-02-13 | Nicollet | Minnesota | 27103 | 2440 | 40 |
1022426 | 1022426 | 2021-02-12 | Nicollet | Minnesota | 27103 | 2433 | 40 |
1019181 | 1019181 | 2021-02-11 | Nicollet | Minnesota | 27103 | 2427 | 40 |
1015936 | 1015936 | 2021-02-10 | Nicollet | Minnesota | 27103 | 2413 | 40 |
1012691 | 1012691 | 2021-02-09 | Nicollet | Minnesota | 27103 | 2408 | 40 |
1009446 | 1009446 | 2021-02-08 | Nicollet | Minnesota | 27103 | 2379 | 40 |
1006199 | 1006199 | 2021-02-07 | Nicollet | Minnesota | 27103 | 2375 | 40 |
1002953 | 1002953 | 2021-02-06 | Nicollet | Minnesota | 27103 | 2364 | 40 |
999708 | 999708 | 2021-02-05 | Nicollet | Minnesota | 27103 | 2359 | 40 |
996462 | 996462 | 2021-02-04 | Nicollet | Minnesota | 27103 | 2355 | 40 |
993216 | 993216 | 2021-02-03 | Nicollet | Minnesota | 27103 | 2349 | 40 |
989970 | 989970 | 2021-02-02 | Nicollet | Minnesota | 27103 | 2347 | 40 |
986723 | 986723 | 2021-02-01 | Nicollet | Minnesota | 27103 | 2337 | 40 |
983476 | 983476 | 2021-01-31 | Nicollet | Minnesota | 27103 | 2334 | 40 |
980230 | 980230 | 2021-01-30 | Nicollet | Minnesota | 27103 | 2329 | 39 |
976984 | 976984 | 2021-01-29 | Nicollet | Minnesota | 27103 | 2323 | 39 |
973739 | 973739 | 2021-01-28 | Nicollet | Minnesota | 27103 | 2319 | 39 |
970494 | 970494 | 2021-01-27 | Nicollet | Minnesota | 27103 | 2309 | 39 |
967249 | 967249 | 2021-01-26 | Nicollet | Minnesota | 27103 | 2309 | 38 |
964005 | 964005 | 2021-01-25 | Nicollet | Minnesota | 27103 | 2305 | 38 |
960760 | 960760 | 2021-01-24 | Nicollet | Minnesota | 27103 | 2294 | 38 |
957514 | 957514 | 2021-01-23 | Nicollet | Minnesota | 27103 | 2279 | 38 |
954269 | 954269 | 2021-01-22 | Nicollet | Minnesota | 27103 | 2275 | 37 |
951024 | 951024 | 2021-01-21 | Nicollet | Minnesota | 27103 | 2264 | 37 |
947778 | 947778 | 2021-01-20 | Nicollet | Minnesota | 27103 | 2254 | 36 |
944531 | 944531 | 2021-01-19 | Nicollet | Minnesota | 27103 | 2246 | 36 |
941286 | 941286 | 2021-01-18 | Nicollet | Minnesota | 27103 | 2240 | 36 |
938041 | 938041 | 2021-01-17 | Nicollet | Minnesota | 27103 | 2238 | 36 |
934796 | 934796 | 2021-01-16 | Nicollet | Minnesota | 27103 | 2233 | 36 |
931551 | 931551 | 2021-01-15 | Nicollet | Minnesota | 27103 | 2226 | 36 |
928306 | 928306 | 2021-01-14 | Nicollet | Minnesota | 27103 | 2221 | 36 |
925060 | 925060 | 2021-01-13 | Nicollet | Minnesota | 27103 | 2211 | 36 |
921815 | 921815 | 2021-01-12 | Nicollet | Minnesota | 27103 | 2200 | 36 |
918570 | 918570 | 2021-01-11 | Nicollet | Minnesota | 27103 | 2196 | 36 |
915325 | 915325 | 2021-01-10 | Nicollet | Minnesota | 27103 | 2192 | 36 |
912080 | 912080 | 2021-01-09 | Nicollet | Minnesota | 27103 | 2186 | 36 |
908835 | 908835 | 2021-01-08 | Nicollet | Minnesota | 27103 | 2169 | 35 |
905589 | 905589 | 2021-01-07 | Nicollet | Minnesota | 27103 | 2150 | 35 |
902344 | 902344 | 2021-01-06 | Nicollet | Minnesota | 27103 | 2137 | 34 |
899099 | 899099 | 2021-01-05 | Nicollet | Minnesota | 27103 | 2127 | 33 |
895854 | 895854 | 2021-01-04 | Nicollet | Minnesota | 27103 | 2114 | 33 |
892607 | 892607 | 2021-01-03 | Nicollet | Minnesota | 27103 | 2102 | 33 |
889361 | 889361 | 2021-01-02 | Nicollet | Minnesota | 27103 | 2089 | 32 |
886115 | 886115 | 2021-01-01 | Nicollet | Minnesota | 27103 | 2073 | 32 |
882870 | 882870 | 2020-12-31 | Nicollet | Minnesota | 27103 | 2073 | 32 |
879625 | 879625 | 2020-12-30 | Nicollet | Minnesota | 27103 | 2064 | 30 |
876380 | 876380 | 2020-12-29 | Nicollet | Minnesota | 27103 | 2053 | 30 |
873135 | 873135 | 2020-12-28 | Nicollet | Minnesota | 27103 | 2043 | 30 |
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);