ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 27123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175584 | 2175584 | 2022-02-02 | Ramsey | Minnesota | 27123 | 116735 | 1253 |
2172331 | 2172331 | 2022-02-01 | Ramsey | Minnesota | 27123 | 115859 | 1247 |
2169078 | 2169078 | 2022-01-31 | Ramsey | Minnesota | 27123 | 114533 | 1240 |
2165823 | 2165823 | 2022-01-30 | Ramsey | Minnesota | 27123 | 113269 | 1238 |
2162568 | 2162568 | 2022-01-29 | Ramsey | Minnesota | 27123 | 113269 | 1238 |
2159313 | 2159313 | 2022-01-28 | Ramsey | Minnesota | 27123 | 113269 | 1238 |
2156059 | 2156059 | 2022-01-27 | Ramsey | Minnesota | 27123 | 112428 | 1230 |
2152806 | 2152806 | 2022-01-26 | Ramsey | Minnesota | 27123 | 110187 | 1219 |
2149554 | 2149554 | 2022-01-25 | Ramsey | Minnesota | 27123 | 108945 | 1212 |
2146302 | 2146302 | 2022-01-24 | Ramsey | Minnesota | 27123 | 106676 | 1205 |
2143047 | 2143047 | 2022-01-23 | Ramsey | Minnesota | 27123 | 105569 | 1201 |
2139792 | 2139792 | 2022-01-22 | Ramsey | Minnesota | 27123 | 105569 | 1201 |
2136536 | 2136536 | 2022-01-21 | Ramsey | Minnesota | 27123 | 105569 | 1201 |
2133284 | 2133284 | 2022-01-20 | Ramsey | Minnesota | 27123 | 103109 | 1193 |
2130031 | 2130031 | 2022-01-19 | Ramsey | Minnesota | 27123 | 101870 | 1181 |
2126777 | 2126777 | 2022-01-18 | Ramsey | Minnesota | 27123 | 98579 | 1176 |
2123525 | 2123525 | 2022-01-17 | Ramsey | Minnesota | 27123 | 97537 | 1174 |
2120273 | 2120273 | 2022-01-16 | Ramsey | Minnesota | 27123 | 97537 | 1174 |
2117021 | 2117021 | 2022-01-15 | Ramsey | Minnesota | 27123 | 97537 | 1174 |
2113770 | 2113770 | 2022-01-14 | Ramsey | Minnesota | 27123 | 97537 | 1174 |
2110518 | 2110518 | 2022-01-13 | Ramsey | Minnesota | 27123 | 96274 | 1172 |
2107267 | 2107267 | 2022-01-12 | Ramsey | Minnesota | 27123 | 94608 | 1166 |
2104016 | 2104016 | 2022-01-11 | Ramsey | Minnesota | 27123 | 93699 | 1162 |
2100765 | 2100765 | 2022-01-10 | Ramsey | Minnesota | 27123 | 90778 | 1158 |
2097514 | 2097514 | 2022-01-09 | Ramsey | Minnesota | 27123 | 89495 | 1154 |
2094262 | 2094262 | 2022-01-08 | Ramsey | Minnesota | 27123 | 89495 | 1154 |
2091010 | 2091010 | 2022-01-07 | Ramsey | Minnesota | 27123 | 89495 | 1154 |
2087759 | 2087759 | 2022-01-06 | Ramsey | Minnesota | 27123 | 88614 | 1149 |
2084507 | 2084507 | 2022-01-05 | Ramsey | Minnesota | 27123 | 87732 | 1146 |
2081255 | 2081255 | 2022-01-04 | Ramsey | Minnesota | 27123 | 87308 | 1136 |
2078003 | 2078003 | 2022-01-03 | Ramsey | Minnesota | 27123 | 85048 | 1132 |
2074752 | 2074752 | 2022-01-02 | Ramsey | Minnesota | 27123 | 84152 | 1129 |
2071501 | 2071501 | 2022-01-01 | Ramsey | Minnesota | 27123 | 84152 | 1129 |
2068250 | 2068250 | 2021-12-31 | Ramsey | Minnesota | 27123 | 84152 | 1129 |
2064999 | 2064999 | 2021-12-30 | Ramsey | Minnesota | 27123 | 84152 | 1129 |
2061749 | 2061749 | 2021-12-29 | Ramsey | Minnesota | 27123 | 83285 | 1123 |
2058500 | 2058500 | 2021-12-28 | Ramsey | Minnesota | 27123 | 82636 | 1117 |
2055251 | 2055251 | 2021-12-27 | Ramsey | Minnesota | 27123 | 81551 | 1112 |
2052001 | 2052001 | 2021-12-26 | Ramsey | Minnesota | 27123 | 81204 | 1111 |
2048751 | 2048751 | 2021-12-25 | Ramsey | Minnesota | 27123 | 81204 | 1111 |
2045501 | 2045501 | 2021-12-24 | Ramsey | Minnesota | 27123 | 81204 | 1111 |
2042251 | 2042251 | 2021-12-23 | Ramsey | Minnesota | 27123 | 81204 | 1111 |
2039002 | 2039002 | 2021-12-22 | Ramsey | Minnesota | 27123 | 80878 | 1106 |
2035752 | 2035752 | 2021-12-21 | Ramsey | Minnesota | 27123 | 80650 | 1103 |
2032502 | 2032502 | 2021-12-20 | Ramsey | Minnesota | 27123 | 79951 | 1100 |
2029251 | 2029251 | 2021-12-19 | Ramsey | Minnesota | 27123 | 79628 | 1096 |
2026000 | 2026000 | 2021-12-18 | Ramsey | Minnesota | 27123 | 79628 | 1096 |
2022749 | 2022749 | 2021-12-17 | Ramsey | Minnesota | 27123 | 79628 | 1096 |
2019498 | 2019498 | 2021-12-16 | Ramsey | Minnesota | 27123 | 79306 | 1090 |
2016248 | 2016248 | 2021-12-15 | Ramsey | Minnesota | 27123 | 78942 | 1086 |
2012997 | 2012997 | 2021-12-14 | Ramsey | Minnesota | 27123 | 78738 | 1082 |
2009746 | 2009746 | 2021-12-13 | Ramsey | Minnesota | 27123 | 77901 | 1076 |
2006495 | 2006495 | 2021-12-12 | Ramsey | Minnesota | 27123 | 77579 | 1069 |
2003244 | 2003244 | 2021-12-11 | Ramsey | Minnesota | 27123 | 77579 | 1069 |
1999994 | 1999994 | 2021-12-10 | Ramsey | Minnesota | 27123 | 77579 | 1069 |
1996743 | 1996743 | 2021-12-09 | Ramsey | Minnesota | 27123 | 77216 | 1065 |
1993492 | 1993492 | 2021-12-08 | Ramsey | Minnesota | 27123 | 76885 | 1065 |
1990241 | 1990241 | 2021-12-07 | Ramsey | Minnesota | 27123 | 76644 | 1059 |
1986991 | 1986991 | 2021-12-06 | Ramsey | Minnesota | 27123 | 75496 | 1054 |
1983741 | 1983741 | 2021-12-05 | Ramsey | Minnesota | 27123 | 74981 | 1054 |
1980491 | 1980491 | 2021-12-04 | Ramsey | Minnesota | 27123 | 74981 | 1054 |
1977241 | 1977241 | 2021-12-03 | Ramsey | Minnesota | 27123 | 74981 | 1054 |
1973991 | 1973991 | 2021-12-02 | Ramsey | Minnesota | 27123 | 74470 | 1052 |
1970742 | 1970742 | 2021-12-01 | Ramsey | Minnesota | 27123 | 73971 | 1046 |
1967492 | 1967492 | 2021-11-30 | Ramsey | Minnesota | 27123 | 73678 | 1043 |
1964240 | 1964240 | 2021-11-29 | Ramsey | Minnesota | 27123 | 72634 | 1043 |
1960989 | 1960989 | 2021-11-28 | Ramsey | Minnesota | 27123 | 72270 | 1040 |
1957738 | 1957738 | 2021-11-27 | Ramsey | Minnesota | 27123 | 72270 | 1040 |
1954487 | 1954487 | 2021-11-26 | Ramsey | Minnesota | 27123 | 72270 | 1040 |
1951236 | 1951236 | 2021-11-25 | Ramsey | Minnesota | 27123 | 72008 | 1036 |
1947985 | 1947985 | 2021-11-24 | Ramsey | Minnesota | 27123 | 72008 | 1036 |
1944734 | 1944734 | 2021-11-23 | Ramsey | Minnesota | 27123 | 71727 | 1034 |
1941483 | 1941483 | 2021-11-22 | Ramsey | Minnesota | 27123 | 70883 | 1030 |
1938233 | 1938233 | 2021-11-21 | Ramsey | Minnesota | 27123 | 70528 | 1029 |
1934983 | 1934983 | 2021-11-20 | Ramsey | Minnesota | 27123 | 70528 | 1029 |
1931733 | 1931733 | 2021-11-19 | Ramsey | Minnesota | 27123 | 70528 | 1029 |
1928482 | 1928482 | 2021-11-18 | Ramsey | Minnesota | 27123 | 70175 | 1025 |
1925232 | 1925232 | 2021-11-17 | Ramsey | Minnesota | 27123 | 69808 | 1020 |
1921983 | 1921983 | 2021-11-16 | Ramsey | Minnesota | 27123 | 69557 | 1017 |
1918733 | 1918733 | 2021-11-15 | Ramsey | Minnesota | 27123 | 68757 | 1012 |
1915483 | 1915483 | 2021-11-14 | Ramsey | Minnesota | 27123 | 68368 | 1012 |
1912233 | 1912233 | 2021-11-13 | Ramsey | Minnesota | 27123 | 68368 | 1012 |
1908983 | 1908983 | 2021-11-12 | Ramsey | Minnesota | 27123 | 68368 | 1012 |
1905734 | 1905734 | 2021-11-11 | Ramsey | Minnesota | 27123 | 68049 | 1009 |
1902485 | 1902485 | 2021-11-10 | Ramsey | Minnesota | 27123 | 67640 | 1007 |
1899235 | 1899235 | 2021-11-09 | Ramsey | Minnesota | 27123 | 67269 | 1003 |
1895985 | 1895985 | 2021-11-08 | Ramsey | Minnesota | 27123 | 66735 | 1002 |
1892735 | 1892735 | 2021-11-07 | Ramsey | Minnesota | 27123 | 66439 | 1003 |
1889485 | 1889485 | 2021-11-06 | Ramsey | Minnesota | 27123 | 66439 | 1003 |
1886235 | 1886235 | 2021-11-05 | Ramsey | Minnesota | 27123 | 66439 | 1003 |
1882986 | 1882986 | 2021-11-04 | Ramsey | Minnesota | 27123 | 66245 | 1000 |
1879737 | 1879737 | 2021-11-03 | Ramsey | Minnesota | 27123 | 65997 | 999 |
1876488 | 1876488 | 2021-11-02 | Ramsey | Minnesota | 27123 | 65800 | 995 |
1873239 | 1873239 | 2021-11-01 | Ramsey | Minnesota | 27123 | 65279 | 995 |
1869990 | 1869990 | 2021-10-31 | Ramsey | Minnesota | 27123 | 64420 | 993 |
1866741 | 1866741 | 2021-10-30 | Ramsey | Minnesota | 27123 | 64420 | 993 |
1863492 | 1863492 | 2021-10-29 | Ramsey | Minnesota | 27123 | 64420 | 993 |
1860243 | 1860243 | 2021-10-28 | Ramsey | Minnesota | 27123 | 64216 | 991 |
1856994 | 1856994 | 2021-10-27 | Ramsey | Minnesota | 27123 | 64089 | 986 |
1853745 | 1853745 | 2021-10-26 | Ramsey | Minnesota | 27123 | 63983 | 985 |
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);