ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Wright" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418541 | 1418541 | 2021-06-14 | Wright | Minnesota | 27171 | 16404 | 148 |
1415296 | 1415296 | 2021-06-13 | Wright | Minnesota | 27171 | 16400 | 148 |
1412050 | 1412050 | 2021-06-12 | Wright | Minnesota | 27171 | 16399 | 148 |
1408805 | 1408805 | 2021-06-11 | Wright | Minnesota | 27171 | 16394 | 148 |
1405560 | 1405560 | 2021-06-10 | Wright | Minnesota | 27171 | 16385 | 147 |
1402314 | 1402314 | 2021-06-09 | Wright | Minnesota | 27171 | 16382 | 147 |
1399069 | 1399069 | 2021-06-08 | Wright | Minnesota | 27171 | 16380 | 146 |
1395823 | 1395823 | 2021-06-07 | Wright | Minnesota | 27171 | 16377 | 146 |
1392577 | 1392577 | 2021-06-06 | Wright | Minnesota | 27171 | 16372 | 146 |
1389332 | 1389332 | 2021-06-05 | Wright | Minnesota | 27171 | 16365 | 146 |
1386087 | 1386087 | 2021-06-04 | Wright | Minnesota | 27171 | 16360 | 144 |
1382842 | 1382842 | 2021-06-03 | Wright | Minnesota | 27171 | 16356 | 143 |
1379596 | 1379596 | 2021-06-02 | Wright | Minnesota | 27171 | 16346 | 143 |
1376351 | 1376351 | 2021-06-01 | Wright | Minnesota | 27171 | 16345 | 143 |
1373105 | 1373105 | 2021-05-31 | Wright | Minnesota | 27171 | 16340 | 143 |
1369860 | 1369860 | 2021-05-30 | Wright | Minnesota | 27171 | 16340 | 143 |
1366614 | 1366614 | 2021-05-29 | Wright | Minnesota | 27171 | 16334 | 143 |
1363368 | 1363368 | 2021-05-28 | Wright | Minnesota | 27171 | 16323 | 143 |
1360121 | 1360121 | 2021-05-27 | Wright | Minnesota | 27171 | 16317 | 143 |
1356875 | 1356875 | 2021-05-26 | Wright | Minnesota | 27171 | 16305 | 142 |
1353629 | 1353629 | 2021-05-25 | Wright | Minnesota | 27171 | 16291 | 142 |
1350383 | 1350383 | 2021-05-24 | Wright | Minnesota | 27171 | 16285 | 142 |
1347137 | 1347137 | 2021-05-23 | Wright | Minnesota | 27171 | 16268 | 142 |
1343889 | 1343889 | 2021-05-22 | Wright | Minnesota | 27171 | 16253 | 142 |
1340640 | 1340640 | 2021-05-21 | Wright | Minnesota | 27171 | 16229 | 142 |
1337393 | 1337393 | 2021-05-20 | Wright | Minnesota | 27171 | 16198 | 141 |
1334146 | 1334146 | 2021-05-19 | Wright | Minnesota | 27171 | 16173 | 141 |
1330899 | 1330899 | 2021-05-18 | Wright | Minnesota | 27171 | 16161 | 141 |
1327652 | 1327652 | 2021-05-17 | Wright | Minnesota | 27171 | 16136 | 140 |
1324406 | 1324406 | 2021-05-16 | Wright | Minnesota | 27171 | 16121 | 140 |
1321160 | 1321160 | 2021-05-15 | Wright | Minnesota | 27171 | 16082 | 140 |
1317914 | 1317914 | 2021-05-14 | Wright | Minnesota | 27171 | 16034 | 140 |
1314666 | 1314666 | 2021-05-13 | Wright | Minnesota | 27171 | 16009 | 139 |
1311420 | 1311420 | 2021-05-12 | Wright | Minnesota | 27171 | 15968 | 139 |
1308173 | 1308173 | 2021-05-11 | Wright | Minnesota | 27171 | 15943 | 139 |
1304927 | 1304927 | 2021-05-10 | Wright | Minnesota | 27171 | 15909 | 139 |
1301681 | 1301681 | 2021-05-09 | Wright | Minnesota | 27171 | 15873 | 139 |
1298433 | 1298433 | 2021-05-08 | Wright | Minnesota | 27171 | 15835 | 137 |
1295187 | 1295187 | 2021-05-07 | Wright | Minnesota | 27171 | 15800 | 137 |
1291941 | 1291941 | 2021-05-06 | Wright | Minnesota | 27171 | 15771 | 136 |
1288695 | 1288695 | 2021-05-05 | Wright | Minnesota | 27171 | 15722 | 135 |
1285449 | 1285449 | 2021-05-04 | Wright | Minnesota | 27171 | 15685 | 135 |
1282203 | 1282203 | 2021-05-03 | Wright | Minnesota | 27171 | 15651 | 135 |
1278956 | 1278956 | 2021-05-02 | Wright | Minnesota | 27171 | 15624 | 135 |
1275709 | 1275709 | 2021-05-01 | Wright | Minnesota | 27171 | 15567 | 135 |
1272462 | 1272462 | 2021-04-30 | Wright | Minnesota | 27171 | 15494 | 135 |
1269215 | 1269215 | 2021-04-29 | Wright | Minnesota | 27171 | 15428 | 134 |
1265968 | 1265968 | 2021-04-28 | Wright | Minnesota | 27171 | 15356 | 132 |
1262721 | 1262721 | 2021-04-27 | Wright | Minnesota | 27171 | 15309 | 132 |
1259474 | 1259474 | 2021-04-26 | Wright | Minnesota | 27171 | 15268 | 131 |
1256227 | 1256227 | 2021-04-25 | Wright | Minnesota | 27171 | 15234 | 131 |
1252980 | 1252980 | 2021-04-24 | Wright | Minnesota | 27171 | 15169 | 131 |
1249733 | 1249733 | 2021-04-23 | Wright | Minnesota | 27171 | 15091 | 130 |
1246486 | 1246486 | 2021-04-22 | Wright | Minnesota | 27171 | 15030 | 130 |
1243239 | 1243239 | 2021-04-21 | Wright | Minnesota | 27171 | 14964 | 128 |
1239992 | 1239992 | 2021-04-20 | Wright | Minnesota | 27171 | 14909 | 127 |
1236745 | 1236745 | 2021-04-19 | Wright | Minnesota | 27171 | 14862 | 127 |
1233498 | 1233498 | 2021-04-18 | Wright | Minnesota | 27171 | 14818 | 127 |
1230250 | 1230250 | 2021-04-17 | Wright | Minnesota | 27171 | 14764 | 127 |
1227002 | 1227002 | 2021-04-16 | Wright | Minnesota | 27171 | 14700 | 126 |
1223754 | 1223754 | 2021-04-15 | Wright | Minnesota | 27171 | 14643 | 125 |
1220507 | 1220507 | 2021-04-14 | Wright | Minnesota | 27171 | 14561 | 125 |
1217259 | 1217259 | 2021-04-13 | Wright | Minnesota | 27171 | 14510 | 125 |
1214012 | 1214012 | 2021-04-12 | Wright | Minnesota | 27171 | 14440 | 124 |
1210764 | 1210764 | 2021-04-11 | Wright | Minnesota | 27171 | 14374 | 124 |
1207515 | 1207515 | 2021-04-10 | Wright | Minnesota | 27171 | 14317 | 124 |
1204267 | 1204267 | 2021-04-09 | Wright | Minnesota | 27171 | 14242 | 124 |
1201019 | 1201019 | 2021-04-08 | Wright | Minnesota | 27171 | 14144 | 124 |
1197770 | 1197770 | 2021-04-07 | Wright | Minnesota | 27171 | 14053 | 123 |
1194521 | 1194521 | 2021-04-06 | Wright | Minnesota | 27171 | 13974 | 123 |
1191272 | 1191272 | 2021-04-05 | Wright | Minnesota | 27171 | 13886 | 123 |
1188024 | 1188024 | 2021-04-04 | Wright | Minnesota | 27171 | 13826 | 123 |
1184777 | 1184777 | 2021-04-03 | Wright | Minnesota | 27171 | 13826 | 123 |
1181531 | 1181531 | 2021-04-02 | Wright | Minnesota | 27171 | 13748 | 123 |
1178284 | 1178284 | 2021-04-01 | Wright | Minnesota | 27171 | 13637 | 123 |
1175037 | 1175037 | 2021-03-31 | Wright | Minnesota | 27171 | 13558 | 122 |
1171790 | 1171790 | 2021-03-30 | Wright | Minnesota | 27171 | 13496 | 121 |
1168542 | 1168542 | 2021-03-29 | Wright | Minnesota | 27171 | 13439 | 121 |
1165294 | 1165294 | 2021-03-28 | Wright | Minnesota | 27171 | 13393 | 121 |
1162046 | 1162046 | 2021-03-27 | Wright | Minnesota | 27171 | 13331 | 121 |
1158798 | 1158798 | 2021-03-26 | Wright | Minnesota | 27171 | 13271 | 120 |
1155551 | 1155551 | 2021-03-25 | Wright | Minnesota | 27171 | 13225 | 120 |
1152304 | 1152304 | 2021-03-24 | Wright | Minnesota | 27171 | 13168 | 120 |
1149057 | 1149057 | 2021-03-23 | Wright | Minnesota | 27171 | 13131 | 120 |
1145810 | 1145810 | 2021-03-22 | Wright | Minnesota | 27171 | 13097 | 120 |
1142563 | 1142563 | 2021-03-21 | Wright | Minnesota | 27171 | 13074 | 120 |
1139316 | 1139316 | 2021-03-20 | Wright | Minnesota | 27171 | 13044 | 120 |
1136070 | 1136070 | 2021-03-19 | Wright | Minnesota | 27171 | 12997 | 120 |
1132824 | 1132824 | 2021-03-18 | Wright | Minnesota | 27171 | 12949 | 120 |
1129576 | 1129576 | 2021-03-17 | Wright | Minnesota | 27171 | 12899 | 120 |
1126329 | 1126329 | 2021-03-16 | Wright | Minnesota | 27171 | 12865 | 119 |
1123083 | 1123083 | 2021-03-15 | Wright | Minnesota | 27171 | 12842 | 119 |
1119836 | 1119836 | 2021-03-14 | Wright | Minnesota | 27171 | 12822 | 119 |
1116589 | 1116589 | 2021-03-13 | Wright | Minnesota | 27171 | 12791 | 119 |
1113343 | 1113343 | 2021-03-12 | Wright | Minnesota | 27171 | 12764 | 119 |
1110097 | 1110097 | 2021-03-11 | Wright | Minnesota | 27171 | 12737 | 119 |
1106851 | 1106851 | 2021-03-10 | Wright | Minnesota | 27171 | 12707 | 118 |
1103605 | 1103605 | 2021-03-09 | Wright | Minnesota | 27171 | 12690 | 118 |
1100359 | 1100359 | 2021-03-08 | Wright | Minnesota | 27171 | 12650 | 116 |
1097112 | 1097112 | 2021-03-07 | Wright | Minnesota | 27171 | 12635 | 116 |
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);