ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
742 rows where county = "Grant" and state = "Minnesota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
107993 | 107993 | 2020-05-02 | Grant | Minnesota | 27051 | 1 | 0 |
110864 | 110864 | 2020-05-03 | Grant | Minnesota | 27051 | 1 | 0 |
113743 | 113743 | 2020-05-04 | Grant | Minnesota | 27051 | 1 | 0 |
116624 | 116624 | 2020-05-05 | Grant | Minnesota | 27051 | 1 | 0 |
119584 | 119584 | 2020-05-06 | Grant | Minnesota | 27051 | 1 | 0 |
122557 | 122557 | 2020-05-07 | Grant | Minnesota | 27051 | 1 | 0 |
125539 | 125539 | 2020-05-08 | Grant | Minnesota | 27051 | 2 | 0 |
128526 | 128526 | 2020-05-09 | Grant | Minnesota | 27051 | 2 | 0 |
131516 | 131516 | 2020-05-10 | Grant | Minnesota | 27051 | 2 | 0 |
134507 | 134507 | 2020-05-11 | Grant | Minnesota | 27051 | 2 | 0 |
137497 | 137497 | 2020-05-12 | Grant | Minnesota | 27051 | 2 | 0 |
140491 | 140491 | 2020-05-13 | Grant | Minnesota | 27051 | 2 | 0 |
143486 | 143486 | 2020-05-14 | Grant | Minnesota | 27051 | 2 | 0 |
146486 | 146486 | 2020-05-15 | Grant | Minnesota | 27051 | 2 | 0 |
149491 | 149491 | 2020-05-16 | Grant | Minnesota | 27051 | 2 | 0 |
152502 | 152502 | 2020-05-17 | Grant | Minnesota | 27051 | 2 | 0 |
155516 | 155516 | 2020-05-18 | Grant | Minnesota | 27051 | 2 | 0 |
158534 | 158534 | 2020-05-19 | Grant | Minnesota | 27051 | 2 | 0 |
161560 | 161560 | 2020-05-20 | Grant | Minnesota | 27051 | 2 | 0 |
164589 | 164589 | 2020-05-21 | Grant | Minnesota | 27051 | 2 | 0 |
167625 | 167625 | 2020-05-22 | Grant | Minnesota | 27051 | 2 | 0 |
170662 | 170662 | 2020-05-23 | Grant | Minnesota | 27051 | 2 | 0 |
173704 | 173704 | 2020-05-24 | Grant | Minnesota | 27051 | 2 | 0 |
176747 | 176747 | 2020-05-25 | Grant | Minnesota | 27051 | 2 | 0 |
179791 | 179791 | 2020-05-26 | Grant | Minnesota | 27051 | 3 | 0 |
182837 | 182837 | 2020-05-27 | Grant | Minnesota | 27051 | 3 | 0 |
185892 | 185892 | 2020-05-28 | Grant | Minnesota | 27051 | 3 | 0 |
188950 | 188950 | 2020-05-29 | Grant | Minnesota | 27051 | 4 | 0 |
192014 | 192014 | 2020-05-30 | Grant | Minnesota | 27051 | 4 | 0 |
195082 | 195082 | 2020-05-31 | Grant | Minnesota | 27051 | 4 | 0 |
198153 | 198153 | 2020-06-01 | Grant | Minnesota | 27051 | 4 | 0 |
201226 | 201226 | 2020-06-02 | Grant | Minnesota | 27051 | 4 | 0 |
204303 | 204303 | 2020-06-03 | Grant | Minnesota | 27051 | 4 | 0 |
207384 | 207384 | 2020-06-04 | Grant | Minnesota | 27051 | 4 | 0 |
210465 | 210465 | 2020-06-05 | Grant | Minnesota | 27051 | 4 | 0 |
213549 | 213549 | 2020-06-06 | Grant | Minnesota | 27051 | 4 | 0 |
216637 | 216637 | 2020-06-07 | Grant | Minnesota | 27051 | 5 | 0 |
219729 | 219729 | 2020-06-08 | Grant | Minnesota | 27051 | 5 | 0 |
222824 | 222824 | 2020-06-09 | Grant | Minnesota | 27051 | 5 | 0 |
225922 | 225922 | 2020-06-10 | Grant | Minnesota | 27051 | 6 | 0 |
229024 | 229024 | 2020-06-11 | Grant | Minnesota | 27051 | 6 | 0 |
232128 | 232128 | 2020-06-12 | Grant | Minnesota | 27051 | 6 | 0 |
235234 | 235234 | 2020-06-13 | Grant | Minnesota | 27051 | 6 | 0 |
238341 | 238341 | 2020-06-14 | Grant | Minnesota | 27051 | 6 | 0 |
241450 | 241450 | 2020-06-15 | Grant | Minnesota | 27051 | 6 | 0 |
244561 | 244561 | 2020-06-16 | Grant | Minnesota | 27051 | 6 | 0 |
247674 | 247674 | 2020-06-17 | Grant | Minnesota | 27051 | 6 | 0 |
250786 | 250786 | 2020-06-18 | Grant | Minnesota | 27051 | 6 | 0 |
253901 | 253901 | 2020-06-19 | Grant | Minnesota | 27051 | 6 | 0 |
257021 | 257021 | 2020-06-20 | Grant | Minnesota | 27051 | 6 | 0 |
260147 | 260147 | 2020-06-21 | Grant | Minnesota | 27051 | 6 | 0 |
263276 | 263276 | 2020-06-22 | Grant | Minnesota | 27051 | 6 | 0 |
266402 | 266402 | 2020-06-23 | Grant | Minnesota | 27051 | 6 | 0 |
269535 | 269535 | 2020-06-24 | Grant | Minnesota | 27051 | 6 | 0 |
272672 | 272672 | 2020-06-25 | Grant | Minnesota | 27051 | 6 | 0 |
275815 | 275815 | 2020-06-26 | Grant | Minnesota | 27051 | 6 | 0 |
278963 | 278963 | 2020-06-27 | Grant | Minnesota | 27051 | 6 | 0 |
282111 | 282111 | 2020-06-28 | Grant | Minnesota | 27051 | 6 | 0 |
285256 | 285256 | 2020-06-29 | Grant | Minnesota | 27051 | 6 | 0 |
288406 | 288406 | 2020-06-30 | Grant | Minnesota | 27051 | 6 | 0 |
291557 | 291557 | 2020-07-01 | Grant | Minnesota | 27051 | 8 | 0 |
294711 | 294711 | 2020-07-02 | Grant | Minnesota | 27051 | 10 | 0 |
297869 | 297869 | 2020-07-03 | Grant | Minnesota | 27051 | 10 | 0 |
301032 | 301032 | 2020-07-04 | Grant | Minnesota | 27051 | 10 | 0 |
304196 | 304196 | 2020-07-05 | Grant | Minnesota | 27051 | 11 | 0 |
307363 | 307363 | 2020-07-06 | Grant | Minnesota | 27051 | 12 | 0 |
310531 | 310531 | 2020-07-07 | Grant | Minnesota | 27051 | 17 | 0 |
313701 | 313701 | 2020-07-08 | Grant | Minnesota | 27051 | 17 | 0 |
316875 | 316875 | 2020-07-09 | Grant | Minnesota | 27051 | 22 | 0 |
320050 | 320050 | 2020-07-10 | Grant | Minnesota | 27051 | 24 | 0 |
323229 | 323229 | 2020-07-11 | Grant | Minnesota | 27051 | 25 | 0 |
326412 | 326412 | 2020-07-12 | Grant | Minnesota | 27051 | 32 | 0 |
329598 | 329598 | 2020-07-13 | Grant | Minnesota | 27051 | 32 | 0 |
332785 | 332785 | 2020-07-14 | Grant | Minnesota | 27051 | 31 | 0 |
335978 | 335978 | 2020-07-15 | Grant | Minnesota | 27051 | 31 | 1 |
339174 | 339174 | 2020-07-16 | Grant | Minnesota | 27051 | 32 | 1 |
342370 | 342370 | 2020-07-17 | Grant | Minnesota | 27051 | 32 | 1 |
345570 | 345570 | 2020-07-18 | Grant | Minnesota | 27051 | 33 | 1 |
348771 | 348771 | 2020-07-19 | Grant | Minnesota | 27051 | 33 | 1 |
351971 | 351971 | 2020-07-20 | Grant | Minnesota | 27051 | 33 | 1 |
355173 | 355173 | 2020-07-21 | Grant | Minnesota | 27051 | 33 | 1 |
358376 | 358376 | 2020-07-22 | Grant | Minnesota | 27051 | 33 | 1 |
361581 | 361581 | 2020-07-23 | Grant | Minnesota | 27051 | 33 | 1 |
364788 | 364788 | 2020-07-24 | Grant | Minnesota | 27051 | 35 | 1 |
367995 | 367995 | 2020-07-25 | Grant | Minnesota | 27051 | 36 | 1 |
371205 | 371205 | 2020-07-26 | Grant | Minnesota | 27051 | 38 | 1 |
374417 | 374417 | 2020-07-27 | Grant | Minnesota | 27051 | 41 | 1 |
377632 | 377632 | 2020-07-28 | Grant | Minnesota | 27051 | 41 | 1 |
380849 | 380849 | 2020-07-29 | Grant | Minnesota | 27051 | 43 | 1 |
384066 | 384066 | 2020-07-30 | Grant | Minnesota | 27051 | 44 | 1 |
387284 | 387284 | 2020-07-31 | Grant | Minnesota | 27051 | 44 | 1 |
390501 | 390501 | 2020-08-01 | Grant | Minnesota | 27051 | 48 | 1 |
393718 | 393718 | 2020-08-02 | Grant | Minnesota | 27051 | 49 | 1 |
396934 | 396934 | 2020-08-03 | Grant | Minnesota | 27051 | 49 | 1 |
400148 | 400148 | 2020-08-04 | Grant | Minnesota | 27051 | 51 | 1 |
403365 | 403365 | 2020-08-05 | Grant | Minnesota | 27051 | 52 | 1 |
406583 | 406583 | 2020-08-06 | Grant | Minnesota | 27051 | 52 | 3 |
409803 | 409803 | 2020-08-07 | Grant | Minnesota | 27051 | 53 | 3 |
413023 | 413023 | 2020-08-08 | Grant | Minnesota | 27051 | 53 | 3 |
416243 | 416243 | 2020-08-09 | Grant | Minnesota | 27051 | 55 | 3 |
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);