ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Ramsey" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1850496 | 1850496 | 2021-10-25 | Ramsey | Minnesota | 27123 | 63557 | 983 |
1847246 | 1847246 | 2021-10-24 | Ramsey | Minnesota | 27123 | 63444 | 980 |
1843996 | 1843996 | 2021-10-23 | Ramsey | Minnesota | 27123 | 63444 | 980 |
1840746 | 1840746 | 2021-10-22 | Ramsey | Minnesota | 27123 | 63444 | 980 |
1837497 | 1837497 | 2021-10-21 | Ramsey | Minnesota | 27123 | 63323 | 978 |
1834248 | 1834248 | 2021-10-20 | Ramsey | Minnesota | 27123 | 63195 | 978 |
1830999 | 1830999 | 2021-10-19 | Ramsey | Minnesota | 27123 | 63091 | 977 |
1827750 | 1827750 | 2021-10-18 | Ramsey | Minnesota | 27123 | 62763 | 976 |
1824501 | 1824501 | 2021-10-17 | Ramsey | Minnesota | 27123 | 62614 | 972 |
1821252 | 1821252 | 2021-10-16 | Ramsey | Minnesota | 27123 | 62614 | 972 |
1818003 | 1818003 | 2021-10-15 | Ramsey | Minnesota | 27123 | 62614 | 972 |
1814754 | 1814754 | 2021-10-14 | Ramsey | Minnesota | 27123 | 62446 | 971 |
1811506 | 1811506 | 2021-10-13 | Ramsey | Minnesota | 27123 | 62280 | 969 |
1808257 | 1808257 | 2021-10-12 | Ramsey | Minnesota | 27123 | 62157 | 966 |
1805006 | 1805006 | 2021-10-11 | Ramsey | Minnesota | 27123 | 61674 | 964 |
1801757 | 1801757 | 2021-10-10 | Ramsey | Minnesota | 27123 | 61496 | 964 |
1798508 | 1798508 | 2021-10-09 | Ramsey | Minnesota | 27123 | 61496 | 964 |
1795259 | 1795259 | 2021-10-08 | Ramsey | Minnesota | 27123 | 61496 | 964 |
1792010 | 1792010 | 2021-10-07 | Ramsey | Minnesota | 27123 | 61278 | 963 |
1788761 | 1788761 | 2021-10-06 | Ramsey | Minnesota | 27123 | 61158 | 960 |
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);