ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Cass", fips = 27021 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535756 | 535756 | 2020-09-15 | Cass | Minnesota | 27021 | 118 | 3 |
532521 | 532521 | 2020-09-14 | Cass | Minnesota | 27021 | 119 | 3 |
529285 | 529285 | 2020-09-13 | Cass | Minnesota | 27021 | 118 | 3 |
526049 | 526049 | 2020-09-12 | Cass | Minnesota | 27021 | 113 | 3 |
522813 | 522813 | 2020-09-11 | Cass | Minnesota | 27021 | 112 | 3 |
519576 | 519576 | 2020-09-10 | Cass | Minnesota | 27021 | 110 | 3 |
516341 | 516341 | 2020-09-09 | Cass | Minnesota | 27021 | 112 | 3 |
513107 | 513107 | 2020-09-08 | Cass | Minnesota | 27021 | 112 | 3 |
509875 | 509875 | 2020-09-07 | Cass | Minnesota | 27021 | 109 | 3 |
506642 | 506642 | 2020-09-06 | Cass | Minnesota | 27021 | 108 | 3 |
503409 | 503409 | 2020-09-05 | Cass | Minnesota | 27021 | 105 | 3 |
500175 | 500175 | 2020-09-04 | Cass | Minnesota | 27021 | 105 | 3 |
496941 | 496941 | 2020-09-03 | Cass | Minnesota | 27021 | 105 | 3 |
493708 | 493708 | 2020-09-02 | Cass | Minnesota | 27021 | 105 | 3 |
490474 | 490474 | 2020-09-01 | Cass | Minnesota | 27021 | 105 | 3 |
487241 | 487241 | 2020-08-31 | Cass | Minnesota | 27021 | 105 | 3 |
484007 | 484007 | 2020-08-30 | Cass | Minnesota | 27021 | 103 | 3 |
480772 | 480772 | 2020-08-29 | Cass | Minnesota | 27021 | 103 | 3 |
477540 | 477540 | 2020-08-28 | Cass | Minnesota | 27021 | 99 | 3 |
474307 | 474307 | 2020-08-27 | Cass | Minnesota | 27021 | 99 | 3 |
471075 | 471075 | 2020-08-26 | Cass | Minnesota | 27021 | 98 | 3 |
467845 | 467845 | 2020-08-25 | Cass | Minnesota | 27021 | 93 | 3 |
464616 | 464616 | 2020-08-24 | Cass | Minnesota | 27021 | 92 | 3 |
461385 | 461385 | 2020-08-23 | Cass | Minnesota | 27021 | 89 | 3 |
458158 | 458158 | 2020-08-22 | Cass | Minnesota | 27021 | 89 | 3 |
454930 | 454930 | 2020-08-21 | Cass | Minnesota | 27021 | 88 | 3 |
451702 | 451702 | 2020-08-20 | Cass | Minnesota | 27021 | 86 | 3 |
448474 | 448474 | 2020-08-19 | Cass | Minnesota | 27021 | 84 | 3 |
445248 | 445248 | 2020-08-18 | Cass | Minnesota | 27021 | 83 | 3 |
442022 | 442022 | 2020-08-17 | Cass | Minnesota | 27021 | 81 | 3 |
438795 | 438795 | 2020-08-16 | Cass | Minnesota | 27021 | 80 | 3 |
435570 | 435570 | 2020-08-15 | Cass | Minnesota | 27021 | 79 | 3 |
432344 | 432344 | 2020-08-14 | Cass | Minnesota | 27021 | 79 | 3 |
429117 | 429117 | 2020-08-13 | Cass | Minnesota | 27021 | 80 | 2 |
425893 | 425893 | 2020-08-12 | Cass | Minnesota | 27021 | 76 | 2 |
422671 | 422671 | 2020-08-11 | Cass | Minnesota | 27021 | 74 | 2 |
419449 | 419449 | 2020-08-10 | Cass | Minnesota | 27021 | 73 | 2 |
416228 | 416228 | 2020-08-09 | Cass | Minnesota | 27021 | 72 | 2 |
413008 | 413008 | 2020-08-08 | Cass | Minnesota | 27021 | 69 | 2 |
409788 | 409788 | 2020-08-07 | Cass | Minnesota | 27021 | 70 | 2 |
406568 | 406568 | 2020-08-06 | Cass | Minnesota | 27021 | 71 | 2 |
403350 | 403350 | 2020-08-05 | Cass | Minnesota | 27021 | 66 | 2 |
400133 | 400133 | 2020-08-04 | Cass | Minnesota | 27021 | 62 | 2 |
396919 | 396919 | 2020-08-03 | Cass | Minnesota | 27021 | 58 | 2 |
393703 | 393703 | 2020-08-02 | Cass | Minnesota | 27021 | 58 | 2 |
390486 | 390486 | 2020-08-01 | Cass | Minnesota | 27021 | 57 | 2 |
387269 | 387269 | 2020-07-31 | Cass | Minnesota | 27021 | 54 | 2 |
384051 | 384051 | 2020-07-30 | Cass | Minnesota | 27021 | 50 | 2 |
380834 | 380834 | 2020-07-29 | Cass | Minnesota | 27021 | 46 | 2 |
377617 | 377617 | 2020-07-28 | Cass | Minnesota | 27021 | 45 | 2 |
374402 | 374402 | 2020-07-27 | Cass | Minnesota | 27021 | 43 | 2 |
371190 | 371190 | 2020-07-26 | Cass | Minnesota | 27021 | 43 | 2 |
367980 | 367980 | 2020-07-25 | Cass | Minnesota | 27021 | 41 | 2 |
364773 | 364773 | 2020-07-24 | Cass | Minnesota | 27021 | 35 | 2 |
361566 | 361566 | 2020-07-23 | Cass | Minnesota | 27021 | 36 | 2 |
358361 | 358361 | 2020-07-22 | Cass | Minnesota | 27021 | 33 | 2 |
355158 | 355158 | 2020-07-21 | Cass | Minnesota | 27021 | 34 | 2 |
351956 | 351956 | 2020-07-20 | Cass | Minnesota | 27021 | 32 | 2 |
348756 | 348756 | 2020-07-19 | Cass | Minnesota | 27021 | 33 | 2 |
345555 | 345555 | 2020-07-18 | Cass | Minnesota | 27021 | 29 | 2 |
342355 | 342355 | 2020-07-17 | Cass | Minnesota | 27021 | 28 | 2 |
339159 | 339159 | 2020-07-16 | Cass | Minnesota | 27021 | 26 | 2 |
335963 | 335963 | 2020-07-15 | Cass | Minnesota | 27021 | 22 | 2 |
332770 | 332770 | 2020-07-14 | Cass | Minnesota | 27021 | 21 | 2 |
329583 | 329583 | 2020-07-13 | Cass | Minnesota | 27021 | 20 | 2 |
326397 | 326397 | 2020-07-12 | Cass | Minnesota | 27021 | 19 | 2 |
323214 | 323214 | 2020-07-11 | Cass | Minnesota | 27021 | 19 | 2 |
320035 | 320035 | 2020-07-10 | Cass | Minnesota | 27021 | 19 | 2 |
316860 | 316860 | 2020-07-09 | Cass | Minnesota | 27021 | 19 | 2 |
313686 | 313686 | 2020-07-08 | Cass | Minnesota | 27021 | 19 | 2 |
310516 | 310516 | 2020-07-07 | Cass | Minnesota | 27021 | 16 | 2 |
307348 | 307348 | 2020-07-06 | Cass | Minnesota | 27021 | 16 | 2 |
304181 | 304181 | 2020-07-05 | Cass | Minnesota | 27021 | 15 | 2 |
301017 | 301017 | 2020-07-04 | Cass | Minnesota | 27021 | 15 | 2 |
297854 | 297854 | 2020-07-03 | Cass | Minnesota | 27021 | 15 | 2 |
294696 | 294696 | 2020-07-02 | Cass | Minnesota | 27021 | 14 | 2 |
291542 | 291542 | 2020-07-01 | Cass | Minnesota | 27021 | 12 | 2 |
288391 | 288391 | 2020-06-30 | Cass | Minnesota | 27021 | 13 | 2 |
285241 | 285241 | 2020-06-29 | Cass | Minnesota | 27021 | 12 | 2 |
282096 | 282096 | 2020-06-28 | Cass | Minnesota | 27021 | 12 | 2 |
278948 | 278948 | 2020-06-27 | Cass | Minnesota | 27021 | 11 | 2 |
275800 | 275800 | 2020-06-26 | Cass | Minnesota | 27021 | 11 | 2 |
272657 | 272657 | 2020-06-25 | Cass | Minnesota | 27021 | 11 | 2 |
269520 | 269520 | 2020-06-24 | Cass | Minnesota | 27021 | 11 | 2 |
266387 | 266387 | 2020-06-23 | Cass | Minnesota | 27021 | 11 | 2 |
263261 | 263261 | 2020-06-22 | Cass | Minnesota | 27021 | 12 | 2 |
260132 | 260132 | 2020-06-21 | Cass | Minnesota | 27021 | 12 | 2 |
257006 | 257006 | 2020-06-20 | Cass | Minnesota | 27021 | 12 | 2 |
253886 | 253886 | 2020-06-19 | Cass | Minnesota | 27021 | 12 | 2 |
250771 | 250771 | 2020-06-18 | Cass | Minnesota | 27021 | 12 | 2 |
247659 | 247659 | 2020-06-17 | Cass | Minnesota | 27021 | 11 | 2 |
244546 | 244546 | 2020-06-16 | Cass | Minnesota | 27021 | 11 | 2 |
241435 | 241435 | 2020-06-15 | Cass | Minnesota | 27021 | 11 | 2 |
238326 | 238326 | 2020-06-14 | Cass | Minnesota | 27021 | 11 | 2 |
235219 | 235219 | 2020-06-13 | Cass | Minnesota | 27021 | 11 | 2 |
232114 | 232114 | 2020-06-12 | Cass | Minnesota | 27021 | 11 | 2 |
229010 | 229010 | 2020-06-11 | Cass | Minnesota | 27021 | 11 | 2 |
225908 | 225908 | 2020-06-10 | Cass | Minnesota | 27021 | 11 | 2 |
222810 | 222810 | 2020-06-09 | Cass | Minnesota | 27021 | 12 | 2 |
219715 | 219715 | 2020-06-08 | Cass | Minnesota | 27021 | 12 | 2 |
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);