ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Waseca" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- …
state 1
- Minnesota · 396 ✖
fips 1
- 27161 396
county 1
- Waseca · 396 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1220502 | 1220502 | 2021-04-14 | Waseca | Minnesota | 27161 | 2287 | 20 |
1217254 | 1217254 | 2021-04-13 | Waseca | Minnesota | 27161 | 2280 | 20 |
1214007 | 1214007 | 2021-04-12 | Waseca | Minnesota | 27161 | 2278 | 20 |
1210759 | 1210759 | 2021-04-11 | Waseca | Minnesota | 27161 | 2268 | 20 |
1207510 | 1207510 | 2021-04-10 | Waseca | Minnesota | 27161 | 2258 | 20 |
1204262 | 1204262 | 2021-04-09 | Waseca | Minnesota | 27161 | 2253 | 20 |
1201014 | 1201014 | 2021-04-08 | Waseca | Minnesota | 27161 | 2248 | 20 |
1197765 | 1197765 | 2021-04-07 | Waseca | Minnesota | 27161 | 2247 | 20 |
1194516 | 1194516 | 2021-04-06 | Waseca | Minnesota | 27161 | 2244 | 20 |
1191267 | 1191267 | 2021-04-05 | Waseca | Minnesota | 27161 | 2227 | 20 |
1188019 | 1188019 | 2021-04-04 | Waseca | Minnesota | 27161 | 2226 | 20 |
1184772 | 1184772 | 2021-04-03 | Waseca | Minnesota | 27161 | 2226 | 20 |
1181526 | 1181526 | 2021-04-02 | Waseca | Minnesota | 27161 | 2219 | 20 |
1178279 | 1178279 | 2021-04-01 | Waseca | Minnesota | 27161 | 2214 | 20 |
1175032 | 1175032 | 2021-03-31 | Waseca | Minnesota | 27161 | 2211 | 20 |
1171785 | 1171785 | 2021-03-30 | Waseca | Minnesota | 27161 | 2202 | 20 |
1168537 | 1168537 | 2021-03-29 | Waseca | Minnesota | 27161 | 2199 | 20 |
1165289 | 1165289 | 2021-03-28 | Waseca | Minnesota | 27161 | 2194 | 20 |
1162041 | 1162041 | 2021-03-27 | Waseca | Minnesota | 27161 | 2189 | 20 |
1158793 | 1158793 | 2021-03-26 | Waseca | Minnesota | 27161 | 2182 | 20 |
1155546 | 1155546 | 2021-03-25 | Waseca | Minnesota | 27161 | 2174 | 20 |
1152299 | 1152299 | 2021-03-24 | Waseca | Minnesota | 27161 | 2166 | 19 |
1149052 | 1149052 | 2021-03-23 | Waseca | Minnesota | 27161 | 2165 | 19 |
1145805 | 1145805 | 2021-03-22 | Waseca | Minnesota | 27161 | 2160 | 19 |
1142558 | 1142558 | 2021-03-21 | Waseca | Minnesota | 27161 | 2157 | 19 |
1139311 | 1139311 | 2021-03-20 | Waseca | Minnesota | 27161 | 2150 | 19 |
1136065 | 1136065 | 2021-03-19 | Waseca | Minnesota | 27161 | 2147 | 19 |
1132819 | 1132819 | 2021-03-18 | Waseca | Minnesota | 27161 | 2143 | 19 |
1129571 | 1129571 | 2021-03-17 | Waseca | Minnesota | 27161 | 2142 | 19 |
1126324 | 1126324 | 2021-03-16 | Waseca | Minnesota | 27161 | 2138 | 19 |
1123078 | 1123078 | 2021-03-15 | Waseca | Minnesota | 27161 | 2137 | 19 |
1119831 | 1119831 | 2021-03-14 | Waseca | Minnesota | 27161 | 2135 | 19 |
1116584 | 1116584 | 2021-03-13 | Waseca | Minnesota | 27161 | 2132 | 19 |
1113338 | 1113338 | 2021-03-12 | Waseca | Minnesota | 27161 | 2130 | 19 |
1110092 | 1110092 | 2021-03-11 | Waseca | Minnesota | 27161 | 2130 | 19 |
1106846 | 1106846 | 2021-03-10 | Waseca | Minnesota | 27161 | 2133 | 19 |
1103600 | 1103600 | 2021-03-09 | Waseca | Minnesota | 27161 | 2129 | 19 |
1100354 | 1100354 | 2021-03-08 | Waseca | Minnesota | 27161 | 2115 | 17 |
1097107 | 1097107 | 2021-03-07 | Waseca | Minnesota | 27161 | 2112 | 17 |
1093860 | 1093860 | 2021-03-06 | Waseca | Minnesota | 27161 | 2104 | 17 |
1090614 | 1090614 | 2021-03-05 | Waseca | Minnesota | 27161 | 2101 | 17 |
1087369 | 1087369 | 2021-03-04 | Waseca | Minnesota | 27161 | 2097 | 17 |
1084124 | 1084124 | 2021-03-03 | Waseca | Minnesota | 27161 | 2093 | 17 |
1080878 | 1080878 | 2021-03-02 | Waseca | Minnesota | 27161 | 2087 | 17 |
1077632 | 1077632 | 2021-03-01 | Waseca | Minnesota | 27161 | 2089 | 17 |
1074386 | 1074386 | 2021-02-28 | Waseca | Minnesota | 27161 | 2088 | 17 |
1071140 | 1071140 | 2021-02-27 | Waseca | Minnesota | 27161 | 2086 | 17 |
1067895 | 1067895 | 2021-02-26 | Waseca | Minnesota | 27161 | 2079 | 17 |
1064650 | 1064650 | 2021-02-25 | Waseca | Minnesota | 27161 | 2073 | 17 |
1061406 | 1061406 | 2021-02-24 | Waseca | Minnesota | 27161 | 2069 | 17 |
1058160 | 1058160 | 2021-02-23 | Waseca | Minnesota | 27161 | 2063 | 17 |
1054914 | 1054914 | 2021-02-22 | Waseca | Minnesota | 27161 | 2060 | 17 |
1051667 | 1051667 | 2021-02-21 | Waseca | Minnesota | 27161 | 2057 | 17 |
1048420 | 1048420 | 2021-02-20 | Waseca | Minnesota | 27161 | 2052 | 17 |
1045174 | 1045174 | 2021-02-19 | Waseca | Minnesota | 27161 | 2049 | 17 |
1041929 | 1041929 | 2021-02-18 | Waseca | Minnesota | 27161 | 2044 | 17 |
1038684 | 1038684 | 2021-02-17 | Waseca | Minnesota | 27161 | 2040 | 17 |
1035439 | 1035439 | 2021-02-16 | Waseca | Minnesota | 27161 | 2039 | 17 |
1032194 | 1032194 | 2021-02-15 | Waseca | Minnesota | 27161 | 2035 | 17 |
1028947 | 1028947 | 2021-02-14 | Waseca | Minnesota | 27161 | 2031 | 17 |
1025701 | 1025701 | 2021-02-13 | Waseca | Minnesota | 27161 | 2025 | 17 |
1022456 | 1022456 | 2021-02-12 | Waseca | Minnesota | 27161 | 2022 | 17 |
1019211 | 1019211 | 2021-02-11 | Waseca | Minnesota | 27161 | 2015 | 17 |
1015966 | 1015966 | 2021-02-10 | Waseca | Minnesota | 27161 | 2009 | 17 |
1012721 | 1012721 | 2021-02-09 | Waseca | Minnesota | 27161 | 2001 | 17 |
1009476 | 1009476 | 2021-02-08 | Waseca | Minnesota | 27161 | 2000 | 17 |
1006229 | 1006229 | 2021-02-07 | Waseca | Minnesota | 27161 | 1996 | 17 |
1002983 | 1002983 | 2021-02-06 | Waseca | Minnesota | 27161 | 1992 | 17 |
999738 | 999738 | 2021-02-05 | Waseca | Minnesota | 27161 | 1989 | 16 |
996492 | 996492 | 2021-02-04 | Waseca | Minnesota | 27161 | 1976 | 16 |
993246 | 993246 | 2021-02-03 | Waseca | Minnesota | 27161 | 1971 | 16 |
990000 | 990000 | 2021-02-02 | Waseca | Minnesota | 27161 | 1970 | 16 |
986753 | 986753 | 2021-02-01 | Waseca | Minnesota | 27161 | 1971 | 16 |
983506 | 983506 | 2021-01-31 | Waseca | Minnesota | 27161 | 1968 | 16 |
980260 | 980260 | 2021-01-30 | Waseca | Minnesota | 27161 | 1963 | 16 |
977014 | 977014 | 2021-01-29 | Waseca | Minnesota | 27161 | 1956 | 16 |
973769 | 973769 | 2021-01-28 | Waseca | Minnesota | 27161 | 1952 | 16 |
970524 | 970524 | 2021-01-27 | Waseca | Minnesota | 27161 | 1940 | 16 |
967279 | 967279 | 2021-01-26 | Waseca | Minnesota | 27161 | 1939 | 16 |
964035 | 964035 | 2021-01-25 | Waseca | Minnesota | 27161 | 1933 | 16 |
960790 | 960790 | 2021-01-24 | Waseca | Minnesota | 27161 | 1932 | 16 |
957544 | 957544 | 2021-01-23 | Waseca | Minnesota | 27161 | 1928 | 16 |
954299 | 954299 | 2021-01-22 | Waseca | Minnesota | 27161 | 1919 | 16 |
951054 | 951054 | 2021-01-21 | Waseca | Minnesota | 27161 | 1907 | 16 |
947808 | 947808 | 2021-01-20 | Waseca | Minnesota | 27161 | 1901 | 16 |
944561 | 944561 | 2021-01-19 | Waseca | Minnesota | 27161 | 1893 | 16 |
941316 | 941316 | 2021-01-18 | Waseca | Minnesota | 27161 | 1889 | 16 |
938071 | 938071 | 2021-01-17 | Waseca | Minnesota | 27161 | 1889 | 16 |
934826 | 934826 | 2021-01-16 | Waseca | Minnesota | 27161 | 1888 | 16 |
931581 | 931581 | 2021-01-15 | Waseca | Minnesota | 27161 | 1880 | 15 |
928336 | 928336 | 2021-01-14 | Waseca | Minnesota | 27161 | 1875 | 15 |
925090 | 925090 | 2021-01-13 | Waseca | Minnesota | 27161 | 1873 | 15 |
921845 | 921845 | 2021-01-12 | Waseca | Minnesota | 27161 | 1868 | 15 |
918600 | 918600 | 2021-01-11 | Waseca | Minnesota | 27161 | 1864 | 16 |
915355 | 915355 | 2021-01-10 | Waseca | Minnesota | 27161 | 1860 | 16 |
912110 | 912110 | 2021-01-09 | Waseca | Minnesota | 27161 | 1856 | 16 |
908865 | 908865 | 2021-01-08 | Waseca | Minnesota | 27161 | 1836 | 16 |
905619 | 905619 | 2021-01-07 | Waseca | Minnesota | 27161 | 1825 | 16 |
902374 | 902374 | 2021-01-06 | Waseca | Minnesota | 27161 | 1811 | 16 |
899129 | 899129 | 2021-01-05 | Waseca | Minnesota | 27161 | 1806 | 15 |
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);