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 |
---|---|---|---|---|---|---|---|
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 |
869890 | 869890 | 2020-12-27 | Nicollet | Minnesota | 27103 | 2042 | 30 |
866645 | 866645 | 2020-12-26 | Nicollet | Minnesota | 27103 | 2027 | 30 |
863400 | 863400 | 2020-12-25 | Nicollet | Minnesota | 27103 | 2008 | 30 |
860155 | 860155 | 2020-12-24 | Nicollet | Minnesota | 27103 | 2008 | 30 |
856910 | 856910 | 2020-12-23 | Nicollet | Minnesota | 27103 | 2002 | 30 |
853665 | 853665 | 2020-12-22 | Nicollet | Minnesota | 27103 | 1984 | 30 |
850420 | 850420 | 2020-12-21 | Nicollet | Minnesota | 27103 | 1975 | 30 |
847175 | 847175 | 2020-12-20 | Nicollet | Minnesota | 27103 | 1970 | 30 |
843929 | 843929 | 2020-12-19 | Nicollet | Minnesota | 27103 | 1959 | 30 |
840684 | 840684 | 2020-12-18 | Nicollet | Minnesota | 27103 | 1949 | 30 |
837439 | 837439 | 2020-12-17 | Nicollet | Minnesota | 27103 | 1941 | 30 |
834193 | 834193 | 2020-12-16 | Nicollet | Minnesota | 27103 | 1924 | 30 |
830946 | 830946 | 2020-12-15 | Nicollet | Minnesota | 27103 | 1914 | 30 |
827700 | 827700 | 2020-12-14 | Nicollet | Minnesota | 27103 | 1906 | 30 |
824453 | 824453 | 2020-12-13 | Nicollet | Minnesota | 27103 | 1899 | 30 |
821207 | 821207 | 2020-12-12 | Nicollet | Minnesota | 27103 | 1883 | 30 |
817961 | 817961 | 2020-12-11 | Nicollet | Minnesota | 27103 | 1876 | 29 |
814715 | 814715 | 2020-12-10 | Nicollet | Minnesota | 27103 | 1867 | 27 |
811470 | 811470 | 2020-12-09 | Nicollet | Minnesota | 27103 | 1848 | 27 |
808225 | 808225 | 2020-12-08 | Nicollet | Minnesota | 27103 | 1828 | 27 |
804980 | 804980 | 2020-12-07 | Nicollet | Minnesota | 27103 | 1823 | 27 |
801735 | 801735 | 2020-12-06 | Nicollet | Minnesota | 27103 | 1803 | 27 |
798490 | 798490 | 2020-12-05 | Nicollet | Minnesota | 27103 | 1788 | 27 |
795245 | 795245 | 2020-12-04 | Nicollet | Minnesota | 27103 | 1749 | 26 |
792000 | 792000 | 2020-12-03 | Nicollet | Minnesota | 27103 | 1721 | 26 |
788755 | 788755 | 2020-12-02 | Nicollet | Minnesota | 27103 | 1694 | 26 |
785510 | 785510 | 2020-12-01 | Nicollet | Minnesota | 27103 | 1655 | 26 |
782266 | 782266 | 2020-11-30 | Nicollet | Minnesota | 27103 | 1640 | 26 |
779020 | 779020 | 2020-11-29 | Nicollet | Minnesota | 27103 | 1625 | 25 |
775775 | 775775 | 2020-11-28 | Nicollet | Minnesota | 27103 | 1587 | 25 |
772530 | 772530 | 2020-11-27 | Nicollet | Minnesota | 27103 | 1549 | 25 |
769285 | 769285 | 2020-11-26 | Nicollet | Minnesota | 27103 | 1508 | 23 |
766039 | 766039 | 2020-11-25 | Nicollet | Minnesota | 27103 | 1508 | 23 |
762794 | 762794 | 2020-11-24 | Nicollet | Minnesota | 27103 | 1482 | 23 |
759549 | 759549 | 2020-11-23 | Nicollet | Minnesota | 27103 | 1465 | 23 |
756302 | 756302 | 2020-11-22 | Nicollet | Minnesota | 27103 | 1445 | 23 |
753056 | 753056 | 2020-11-21 | Nicollet | Minnesota | 27103 | 1388 | 23 |
749810 | 749810 | 2020-11-20 | Nicollet | Minnesota | 27103 | 1361 | 22 |
746564 | 746564 | 2020-11-19 | Nicollet | Minnesota | 27103 | 1328 | 22 |
743317 | 743317 | 2020-11-18 | Nicollet | Minnesota | 27103 | 1261 | 22 |
740070 | 740070 | 2020-11-17 | Nicollet | Minnesota | 27103 | 1246 | 21 |
736826 | 736826 | 2020-11-16 | Nicollet | Minnesota | 27103 | 1214 | 21 |
733580 | 733580 | 2020-11-15 | Nicollet | Minnesota | 27103 | 1162 | 21 |
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);