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

84 rows where "date" is on date 2020-05-19 and state = "Minnesota" sorted by date descending

✎ View and edit SQL

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

state 1

  • Minnesota · 84 ✖
Link rowid date ▲ county state fips cases deaths
158510 158510 2020-05-19 Aitkin Minnesota 27001 4 0
158511 158511 2020-05-19 Anoka Minnesota 27003 919 42
158512 158512 2020-05-19 Becker Minnesota 27005 32 0
158513 158513 2020-05-19 Beltrami Minnesota 27007 9 0
158514 158514 2020-05-19 Benton Minnesota 27009 142 2
158515 158515 2020-05-19 Big Stone Minnesota 27011 3 0
158516 158516 2020-05-19 Blue Earth Minnesota 27013 93 0
158517 158517 2020-05-19 Brown Minnesota 27015 10 2
158518 158518 2020-05-19 Carlton Minnesota 27017 67 0
158519 158519 2020-05-19 Carver Minnesota 27019 128 2
158520 158520 2020-05-19 Cass Minnesota 27021 11 2
158521 158521 2020-05-19 Chippewa Minnesota 27023 34 0
158522 158522 2020-05-19 Chisago Minnesota 27025 38 1
158523 158523 2020-05-19 Clay Minnesota 27027 318 21
158524 158524 2020-05-19 Clearwater Minnesota 27029 2 0
158525 158525 2020-05-19 Cottonwood Minnesota 27033 59 0
158526 158526 2020-05-19 Crow Wing Minnesota 27035 30 1
158527 158527 2020-05-19 Dakota Minnesota 27037 841 25
158528 158528 2020-05-19 Dodge Minnesota 27039 39 0
158529 158529 2020-05-19 Douglas Minnesota 27041 23 0
158530 158530 2020-05-19 Faribault Minnesota 27043 11 0
158531 158531 2020-05-19 Fillmore Minnesota 27045 17 1
158532 158532 2020-05-19 Freeborn Minnesota 27047 63 0
158533 158533 2020-05-19 Goodhue Minnesota 27049 36 0
158534 158534 2020-05-19 Grant Minnesota 27051 2 0
158535 158535 2020-05-19 Hennepin Minnesota 27053 5650 476
158536 158536 2020-05-19 Houston Minnesota 27055 2 0
158537 158537 2020-05-19 Isanti Minnesota 27059 19 0
158538 158538 2020-05-19 Itasca Minnesota 27061 49 6
158539 158539 2020-05-19 Jackson Minnesota 27063 36 0
158540 158540 2020-05-19 Kanabec Minnesota 27065 9 1
158541 158541 2020-05-19 Kandiyohi Minnesota 27067 420 1
158542 158542 2020-05-19 Kittson Minnesota 27069 1 0
158543 158543 2020-05-19 Koochiching Minnesota 27071 5 0
158544 158544 2020-05-19 Lac qui Parle Minnesota 27073 3 0
158545 158545 2020-05-19 Lake Minnesota 27075 1 0
158546 158546 2020-05-19 Le Sueur Minnesota 27079 36 1
158547 158547 2020-05-19 Lincoln Minnesota 27081 4 0
158548 158548 2020-05-19 Lyon Minnesota 27083 26 0
158549 158549 2020-05-19 Mahnomen Minnesota 27087 5 1
158550 158550 2020-05-19 Marshall Minnesota 27089 8 0
158551 158551 2020-05-19 Martin Minnesota 27091 123 5
158552 158552 2020-05-19 McLeod Minnesota 27085 18 0
158553 158553 2020-05-19 Meeker Minnesota 27093 38 0
158554 158554 2020-05-19 Mille Lacs Minnesota 27095 13 1
158555 158555 2020-05-19 Morrison Minnesota 27097 29 0
158556 158556 2020-05-19 Mower Minnesota 27099 72 0
158557 158557 2020-05-19 Murray Minnesota 27101 33 0
158558 158558 2020-05-19 Nicollet Minnesota 27103 43 3
158559 158559 2020-05-19 Nobles Minnesota 27105 1394 2
158560 158560 2020-05-19 Norman Minnesota 27107 11 0
158561 158561 2020-05-19 Olmsted Minnesota 27109 479 10
158562 158562 2020-05-19 Otter Tail Minnesota 27111 51 0
158563 158563 2020-05-19 Pennington Minnesota 27113 3 0
158564 158564 2020-05-19 Pine Minnesota 27115 83 0
158565 158565 2020-05-19 Pipestone Minnesota 27117 10 0
158566 158566 2020-05-19 Polk Minnesota 27119 56 2
158567 158567 2020-05-19 Pope Minnesota 27121 5 0
158568 158568 2020-05-19 Ramsey Minnesota 27123 1720 74
158569 158569 2020-05-19 Red Lake Minnesota 27125 3 0
158570 158570 2020-05-19 Redwood Minnesota 27127 3 0
158571 158571 2020-05-19 Renville Minnesota 27129 5 0
158572 158572 2020-05-19 Rice Minnesota 27131 270 2
158573 158573 2020-05-19 Rock Minnesota 27133 20 0
158574 158574 2020-05-19 Roseau Minnesota 27135 1 0
158575 158575 2020-05-19 Scott Minnesota 27139 271 1
158576 158576 2020-05-19 Sherburne Minnesota 27141 164 2
158577 158577 2020-05-19 Sibley Minnesota 27143 10 0
158578 158578 2020-05-19 St. Louis Minnesota 27137 107 13
158579 158579 2020-05-19 Stearns Minnesota 27145 1782 10
158580 158580 2020-05-19 Steele Minnesota 27147 115 0
158581 158581 2020-05-19 Swift Minnesota 27151 13 0
158582 158582 2020-05-19 Todd Minnesota 27153 87 0
158583 158583 2020-05-19 Traverse Minnesota 27155 3 0
158584 158584 2020-05-19 Unknown Minnesota   44 9
158585 158585 2020-05-19 Wabasha Minnesota 27157 16 0
158586 158586 2020-05-19 Wadena Minnesota 27159 6 0
158587 158587 2020-05-19 Waseca Minnesota 27161 21 0
158588 158588 2020-05-19 Washington Minnesota 27163 398 19
158589 158589 2020-05-19 Watonwan Minnesota 27165 41 0
158590 158590 2020-05-19 Wilkin Minnesota 27167 11 3
158591 158591 2020-05-19 Winona Minnesota 27169 75 15
158592 158592 2020-05-19 Wright Minnesota 27171 182 1
158593 158593 2020-05-19 Yellow Medicine Minnesota 27173 4 0

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