ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

88 rows where date = "2020-11-14" and state = "Minnesota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Minnesota · 88 ✖
Link rowid date ▲ county state fips cases deaths
730284 730284 2020-11-14 Aitkin Minnesota 27001 458 12
730285 730285 2020-11-14 Anoka Minnesota 27003 15539 188
730286 730286 2020-11-14 Becker Minnesota 27005 1253 4
730287 730287 2020-11-14 Beltrami Minnesota 27007 1471 13
730288 730288 2020-11-14 Benton Minnesota 27009 1987 28
730289 730289 2020-11-14 Big Stone Minnesota 27011 233 1
730290 730290 2020-11-14 Blue Earth Minnesota 27013 2890 10
730291 730291 2020-11-14 Brown Minnesota 27015 752 5
730292 730292 2020-11-14 Carlton Minnesota 27017 1108 8
730293 730293 2020-11-14 Carver Minnesota 27019 2889 9
730294 730294 2020-11-14 Cass Minnesota 27021 888 8
730295 730295 2020-11-14 Chippewa Minnesota 27023 636 6
730296 730296 2020-11-14 Chisago Minnesota 27025 2208 4
730297 730297 2020-11-14 Clay Minnesota 27027 3693 50
730298 730298 2020-11-14 Clearwater Minnesota 27029 296 3
730299 730299 2020-11-14 Cook Minnesota 27031 40 0
730300 730300 2020-11-14 Cottonwood Minnesota 27033 494 0
730301 730301 2020-11-14 Crow Wing Minnesota 27035 2332 25
730302 730302 2020-11-14 Dakota Minnesota 27037 15081 158
730303 730303 2020-11-14 Dodge Minnesota 27039 541 0
730304 730304 2020-11-14 Douglas Minnesota 27041 1575 16
730305 730305 2020-11-14 Faribault Minnesota 27043 354 0
730306 730306 2020-11-14 Fillmore Minnesota 27045 423 0
730307 730307 2020-11-14 Freeborn Minnesota 27047 995 5
730308 730308 2020-11-14 Goodhue Minnesota 27049 1106 20
730309 730309 2020-11-14 Grant Minnesota 27051 167 5
730310 730310 2020-11-14 Hennepin Minnesota 27053 49262 1039
730311 730311 2020-11-14 Houston Minnesota 27055 456 2
730312 730312 2020-11-14 Hubbard Minnesota 27057 754 14
730313 730313 2020-11-14 Isanti Minnesota 27059 1209 10
730314 730314 2020-11-14 Itasca Minnesota 27061 1291 19
730315 730315 2020-11-14 Jackson Minnesota 27063 314 1
730316 730316 2020-11-14 Kanabec Minnesota 27065 400 11
730317 730317 2020-11-14 Kandiyohi Minnesota 27067 2609 9
730318 730318 2020-11-14 Kittson Minnesota 27069 127 1
730319 730319 2020-11-14 Koochiching Minnesota 27071 256 5
730320 730320 2020-11-14 Lac qui Parle Minnesota 27073 228 3
730321 730321 2020-11-14 Lake Minnesota 27075 220 1
730322 730322 2020-11-14 Lake of the Woods Minnesota 27077 70 1
730323 730323 2020-11-14 Le Sueur Minnesota 27079 959 7
730324 730324 2020-11-14 Lincoln Minnesota 27081 256 1
730325 730325 2020-11-14 Lyon Minnesota 27083 1503 7
730326 730326 2020-11-14 Mahnomen Minnesota 27087 179 3
730327 730327 2020-11-14 Marshall Minnesota 27089 308 6
730328 730328 2020-11-14 Martin Minnesota 27091 775 19
730329 730329 2020-11-14 McLeod Minnesota 27085 1181 6
730330 730330 2020-11-14 Meeker Minnesota 27093 703 5
730331 730331 2020-11-14 Mille Lacs Minnesota 27095 1018 26
730332 730332 2020-11-14 Morrison Minnesota 27097 1348 16
730333 730333 2020-11-14 Mower Minnesota 27099 1752 21
730334 730334 2020-11-14 Murray Minnesota 27101 424 3
730335 730335 2020-11-14 Nicollet Minnesota 27103 1088 21
730336 730336 2020-11-14 Nobles Minnesota 27105 2755 25
730337 730337 2020-11-14 Norman Minnesota 27107 245 5
730338 730338 2020-11-14 Olmsted Minnesota 27109 4643 30
730339 730339 2020-11-14 Otter Tail Minnesota 27111 1795 11
730340 730340 2020-11-14 Pennington Minnesota 27113 375 3
730341 730341 2020-11-14 Pine Minnesota 27115 891 4
730342 730342 2020-11-14 Pipestone Minnesota 27117 533 17
730343 730343 2020-11-14 Polk Minnesota 27119 1638 17
730344 730344 2020-11-14 Pope Minnesota 27121 344 0
730345 730345 2020-11-14 Ramsey Minnesota 27123 20698 429
730346 730346 2020-11-14 Red Lake Minnesota 27125 136 3
730347 730347 2020-11-14 Redwood Minnesota 27127 520 15
730348 730348 2020-11-14 Renville Minnesota 27129 490 14
730349 730349 2020-11-14 Rice Minnesota 27131 2600 23
730350 730350 2020-11-14 Rock Minnesota 27133 489 9
730351 730351 2020-11-14 Roseau Minnesota 27135 681 1
730352 730352 2020-11-14 Scott Minnesota 27139 5596 49
730353 730353 2020-11-14 Sherburne Minnesota 27141 3810 30
730354 730354 2020-11-14 Sibley Minnesota 27143 440 3
730355 730355 2020-11-14 St. Louis Minnesota 27137 5402 83
730356 730356 2020-11-14 Stearns Minnesota 27145 9724 71
730357 730357 2020-11-14 Steele Minnesota 27147 1138 5
730358 730358 2020-11-14 Stevens Minnesota 27149 338 1
730359 730359 2020-11-14 Swift Minnesota 27151 369 3
730360 730360 2020-11-14 Todd Minnesota 27153 1389 12
730361 730361 2020-11-14 Traverse Minnesota 27155 95 0
730362 730362 2020-11-14 Unknown Minnesota   379 56
730363 730363 2020-11-14 Wabasha Minnesota 27157 606 1
730364 730364 2020-11-14 Wadena Minnesota 27159 504 6
730365 730365 2020-11-14 Waseca Minnesota 27161 1048 10
730366 730366 2020-11-14 Washington Minnesota 27163 10119 94
730367 730367 2020-11-14 Watonwan Minnesota 27165 653 4
730368 730368 2020-11-14 Wilkin Minnesota 27167 244 4
730369 730369 2020-11-14 Winona Minnesota 27169 1986 22
730370 730370 2020-11-14 Wright Minnesota 27171 4863 27
730371 730371 2020-11-14 Yellow Medicine Minnesota 27173 449 8

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);