ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
742 rows where county = "Grant" and fips = 27051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535771 | 535771 | 2020-09-15 | Grant | Minnesota | 27051 | 57 | 4 |
532536 | 532536 | 2020-09-14 | Grant | Minnesota | 27051 | 57 | 4 |
529300 | 529300 | 2020-09-13 | Grant | Minnesota | 27051 | 58 | 4 |
526064 | 526064 | 2020-09-12 | Grant | Minnesota | 27051 | 57 | 4 |
522828 | 522828 | 2020-09-11 | Grant | Minnesota | 27051 | 56 | 4 |
519591 | 519591 | 2020-09-10 | Grant | Minnesota | 27051 | 56 | 4 |
516356 | 516356 | 2020-09-09 | Grant | Minnesota | 27051 | 56 | 4 |
513122 | 513122 | 2020-09-08 | Grant | Minnesota | 27051 | 56 | 4 |
509890 | 509890 | 2020-09-07 | Grant | Minnesota | 27051 | 56 | 4 |
506657 | 506657 | 2020-09-06 | Grant | Minnesota | 27051 | 56 | 4 |
503424 | 503424 | 2020-09-05 | Grant | Minnesota | 27051 | 56 | 4 |
500190 | 500190 | 2020-09-04 | Grant | Minnesota | 27051 | 56 | 4 |
496956 | 496956 | 2020-09-03 | Grant | Minnesota | 27051 | 55 | 4 |
493723 | 493723 | 2020-09-02 | Grant | Minnesota | 27051 | 55 | 4 |
490489 | 490489 | 2020-09-01 | Grant | Minnesota | 27051 | 55 | 4 |
487256 | 487256 | 2020-08-31 | Grant | Minnesota | 27051 | 55 | 4 |
484022 | 484022 | 2020-08-30 | Grant | Minnesota | 27051 | 55 | 4 |
480787 | 480787 | 2020-08-29 | Grant | Minnesota | 27051 | 55 | 4 |
477555 | 477555 | 2020-08-28 | Grant | Minnesota | 27051 | 55 | 4 |
474322 | 474322 | 2020-08-27 | Grant | Minnesota | 27051 | 55 | 4 |
471090 | 471090 | 2020-08-26 | Grant | Minnesota | 27051 | 55 | 4 |
467860 | 467860 | 2020-08-25 | Grant | Minnesota | 27051 | 55 | 4 |
464631 | 464631 | 2020-08-24 | Grant | Minnesota | 27051 | 55 | 4 |
461400 | 461400 | 2020-08-23 | Grant | Minnesota | 27051 | 55 | 4 |
458173 | 458173 | 2020-08-22 | Grant | Minnesota | 27051 | 55 | 4 |
454945 | 454945 | 2020-08-21 | Grant | Minnesota | 27051 | 55 | 4 |
451717 | 451717 | 2020-08-20 | Grant | Minnesota | 27051 | 55 | 4 |
448489 | 448489 | 2020-08-19 | Grant | Minnesota | 27051 | 55 | 4 |
445263 | 445263 | 2020-08-18 | Grant | Minnesota | 27051 | 57 | 4 |
442037 | 442037 | 2020-08-17 | Grant | Minnesota | 27051 | 57 | 4 |
438810 | 438810 | 2020-08-16 | Grant | Minnesota | 27051 | 57 | 4 |
435585 | 435585 | 2020-08-15 | Grant | Minnesota | 27051 | 57 | 4 |
432359 | 432359 | 2020-08-14 | Grant | Minnesota | 27051 | 57 | 4 |
429132 | 429132 | 2020-08-13 | Grant | Minnesota | 27051 | 56 | 3 |
425908 | 425908 | 2020-08-12 | Grant | Minnesota | 27051 | 56 | 3 |
422686 | 422686 | 2020-08-11 | Grant | Minnesota | 27051 | 56 | 3 |
419464 | 419464 | 2020-08-10 | Grant | Minnesota | 27051 | 56 | 3 |
416243 | 416243 | 2020-08-09 | Grant | Minnesota | 27051 | 55 | 3 |
413023 | 413023 | 2020-08-08 | Grant | Minnesota | 27051 | 53 | 3 |
409803 | 409803 | 2020-08-07 | Grant | Minnesota | 27051 | 53 | 3 |
406583 | 406583 | 2020-08-06 | Grant | Minnesota | 27051 | 52 | 3 |
403365 | 403365 | 2020-08-05 | Grant | Minnesota | 27051 | 52 | 1 |
400148 | 400148 | 2020-08-04 | Grant | Minnesota | 27051 | 51 | 1 |
396934 | 396934 | 2020-08-03 | Grant | Minnesota | 27051 | 49 | 1 |
393718 | 393718 | 2020-08-02 | Grant | Minnesota | 27051 | 49 | 1 |
390501 | 390501 | 2020-08-01 | Grant | Minnesota | 27051 | 48 | 1 |
387284 | 387284 | 2020-07-31 | Grant | Minnesota | 27051 | 44 | 1 |
384066 | 384066 | 2020-07-30 | Grant | Minnesota | 27051 | 44 | 1 |
380849 | 380849 | 2020-07-29 | Grant | Minnesota | 27051 | 43 | 1 |
377632 | 377632 | 2020-07-28 | Grant | Minnesota | 27051 | 41 | 1 |
374417 | 374417 | 2020-07-27 | Grant | Minnesota | 27051 | 41 | 1 |
371205 | 371205 | 2020-07-26 | Grant | Minnesota | 27051 | 38 | 1 |
367995 | 367995 | 2020-07-25 | Grant | Minnesota | 27051 | 36 | 1 |
364788 | 364788 | 2020-07-24 | Grant | Minnesota | 27051 | 35 | 1 |
361581 | 361581 | 2020-07-23 | Grant | Minnesota | 27051 | 33 | 1 |
358376 | 358376 | 2020-07-22 | Grant | Minnesota | 27051 | 33 | 1 |
355173 | 355173 | 2020-07-21 | Grant | Minnesota | 27051 | 33 | 1 |
351971 | 351971 | 2020-07-20 | Grant | Minnesota | 27051 | 33 | 1 |
348771 | 348771 | 2020-07-19 | Grant | Minnesota | 27051 | 33 | 1 |
345570 | 345570 | 2020-07-18 | Grant | Minnesota | 27051 | 33 | 1 |
342370 | 342370 | 2020-07-17 | Grant | Minnesota | 27051 | 32 | 1 |
339174 | 339174 | 2020-07-16 | Grant | Minnesota | 27051 | 32 | 1 |
335978 | 335978 | 2020-07-15 | Grant | Minnesota | 27051 | 31 | 1 |
332785 | 332785 | 2020-07-14 | Grant | Minnesota | 27051 | 31 | 0 |
329598 | 329598 | 2020-07-13 | Grant | Minnesota | 27051 | 32 | 0 |
326412 | 326412 | 2020-07-12 | Grant | Minnesota | 27051 | 32 | 0 |
323229 | 323229 | 2020-07-11 | Grant | Minnesota | 27051 | 25 | 0 |
320050 | 320050 | 2020-07-10 | Grant | Minnesota | 27051 | 24 | 0 |
316875 | 316875 | 2020-07-09 | Grant | Minnesota | 27051 | 22 | 0 |
313701 | 313701 | 2020-07-08 | Grant | Minnesota | 27051 | 17 | 0 |
310531 | 310531 | 2020-07-07 | Grant | Minnesota | 27051 | 17 | 0 |
307363 | 307363 | 2020-07-06 | Grant | Minnesota | 27051 | 12 | 0 |
304196 | 304196 | 2020-07-05 | Grant | Minnesota | 27051 | 11 | 0 |
301032 | 301032 | 2020-07-04 | Grant | Minnesota | 27051 | 10 | 0 |
297869 | 297869 | 2020-07-03 | Grant | Minnesota | 27051 | 10 | 0 |
294711 | 294711 | 2020-07-02 | Grant | Minnesota | 27051 | 10 | 0 |
291557 | 291557 | 2020-07-01 | Grant | Minnesota | 27051 | 8 | 0 |
288406 | 288406 | 2020-06-30 | Grant | Minnesota | 27051 | 6 | 0 |
285256 | 285256 | 2020-06-29 | Grant | Minnesota | 27051 | 6 | 0 |
282111 | 282111 | 2020-06-28 | Grant | Minnesota | 27051 | 6 | 0 |
278963 | 278963 | 2020-06-27 | Grant | Minnesota | 27051 | 6 | 0 |
275815 | 275815 | 2020-06-26 | Grant | Minnesota | 27051 | 6 | 0 |
272672 | 272672 | 2020-06-25 | Grant | Minnesota | 27051 | 6 | 0 |
269535 | 269535 | 2020-06-24 | Grant | Minnesota | 27051 | 6 | 0 |
266402 | 266402 | 2020-06-23 | Grant | Minnesota | 27051 | 6 | 0 |
263276 | 263276 | 2020-06-22 | Grant | Minnesota | 27051 | 6 | 0 |
260147 | 260147 | 2020-06-21 | Grant | Minnesota | 27051 | 6 | 0 |
257021 | 257021 | 2020-06-20 | Grant | Minnesota | 27051 | 6 | 0 |
253901 | 253901 | 2020-06-19 | Grant | Minnesota | 27051 | 6 | 0 |
250786 | 250786 | 2020-06-18 | Grant | Minnesota | 27051 | 6 | 0 |
247674 | 247674 | 2020-06-17 | Grant | Minnesota | 27051 | 6 | 0 |
244561 | 244561 | 2020-06-16 | Grant | Minnesota | 27051 | 6 | 0 |
241450 | 241450 | 2020-06-15 | Grant | Minnesota | 27051 | 6 | 0 |
238341 | 238341 | 2020-06-14 | Grant | Minnesota | 27051 | 6 | 0 |
235234 | 235234 | 2020-06-13 | Grant | Minnesota | 27051 | 6 | 0 |
232128 | 232128 | 2020-06-12 | Grant | Minnesota | 27051 | 6 | 0 |
229024 | 229024 | 2020-06-11 | Grant | Minnesota | 27051 | 6 | 0 |
225922 | 225922 | 2020-06-10 | Grant | Minnesota | 27051 | 6 | 0 |
222824 | 222824 | 2020-06-09 | Grant | Minnesota | 27051 | 5 | 0 |
219729 | 219729 | 2020-06-08 | Grant | Minnesota | 27051 | 5 | 0 |
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);