ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "DeSoto" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636315 | 636315 | 2020-10-16 | DeSoto | Mississippi | 28033 | 6495 | 77 |
633069 | 633069 | 2020-10-15 | DeSoto | Mississippi | 28033 | 6401 | 77 |
629824 | 629824 | 2020-10-14 | DeSoto | Mississippi | 28033 | 6302 | 77 |
626580 | 626580 | 2020-10-13 | DeSoto | Mississippi | 28033 | 6238 | 75 |
623338 | 623338 | 2020-10-12 | DeSoto | Mississippi | 28033 | 6189 | 75 |
620095 | 620095 | 2020-10-11 | DeSoto | Mississippi | 28033 | 6148 | 75 |
616853 | 616853 | 2020-10-10 | DeSoto | Mississippi | 28033 | 6123 | 75 |
613612 | 613612 | 2020-10-09 | DeSoto | Mississippi | 28033 | 6076 | 74 |
610370 | 610370 | 2020-10-08 | DeSoto | Mississippi | 28033 | 6019 | 72 |
607128 | 607128 | 2020-10-07 | DeSoto | Mississippi | 28033 | 5994 | 71 |
603885 | 603885 | 2020-10-06 | DeSoto | Mississippi | 28033 | 5947 | 70 |
600643 | 600643 | 2020-10-05 | DeSoto | Mississippi | 28033 | 5825 | 70 |
597400 | 597400 | 2020-10-04 | DeSoto | Mississippi | 28033 | 5811 | 70 |
594159 | 594159 | 2020-10-03 | DeSoto | Mississippi | 28033 | 5789 | 69 |
590918 | 590918 | 2020-10-02 | DeSoto | Mississippi | 28033 | 5752 | 68 |
587677 | 587677 | 2020-10-01 | DeSoto | Mississippi | 28033 | 5724 | 66 |
584437 | 584437 | 2020-09-30 | DeSoto | Mississippi | 28033 | 5694 | 64 |
581196 | 581196 | 2020-09-29 | DeSoto | Mississippi | 28033 | 5678 | 63 |
577955 | 577955 | 2020-09-28 | DeSoto | Mississippi | 28033 | 5650 | 61 |
574714 | 574714 | 2020-09-27 | DeSoto | Mississippi | 28033 | 5623 | 61 |
571471 | 571471 | 2020-09-26 | DeSoto | Mississippi | 28033 | 5594 | 60 |
568229 | 568229 | 2020-09-25 | DeSoto | Mississippi | 28033 | 5565 | 59 |
564989 | 564989 | 2020-09-24 | DeSoto | Mississippi | 28033 | 5521 | 59 |
561749 | 561749 | 2020-09-23 | DeSoto | Mississippi | 28033 | 5477 | 59 |
558512 | 558512 | 2020-09-22 | DeSoto | Mississippi | 28033 | 5448 | 59 |
555275 | 555275 | 2020-09-21 | DeSoto | Mississippi | 28033 | 5425 | 55 |
552037 | 552037 | 2020-09-20 | DeSoto | Mississippi | 28033 | 5411 | 55 |
548798 | 548798 | 2020-09-19 | DeSoto | Mississippi | 28033 | 5393 | 55 |
545560 | 545560 | 2020-09-18 | DeSoto | Mississippi | 28033 | 5354 | 55 |
542323 | 542323 | 2020-09-17 | DeSoto | Mississippi | 28033 | 5321 | 53 |
539087 | 539087 | 2020-09-16 | DeSoto | Mississippi | 28033 | 5276 | 53 |
535850 | 535850 | 2020-09-15 | DeSoto | Mississippi | 28033 | 5224 | 53 |
532615 | 532615 | 2020-09-14 | DeSoto | Mississippi | 28033 | 5173 | 53 |
529379 | 529379 | 2020-09-13 | DeSoto | Mississippi | 28033 | 5154 | 53 |
526143 | 526143 | 2020-09-12 | DeSoto | Mississippi | 28033 | 5129 | 53 |
522907 | 522907 | 2020-09-11 | DeSoto | Mississippi | 28033 | 5091 | 54 |
519670 | 519670 | 2020-09-10 | DeSoto | Mississippi | 28033 | 5020 | 54 |
516435 | 516435 | 2020-09-09 | DeSoto | Mississippi | 28033 | 4984 | 51 |
513201 | 513201 | 2020-09-08 | DeSoto | Mississippi | 28033 | 4953 | 50 |
509969 | 509969 | 2020-09-07 | DeSoto | Mississippi | 28033 | 4931 | 50 |
506736 | 506736 | 2020-09-06 | DeSoto | Mississippi | 28033 | 4911 | 50 |
503503 | 503503 | 2020-09-05 | DeSoto | Mississippi | 28033 | 4870 | 48 |
500269 | 500269 | 2020-09-04 | DeSoto | Mississippi | 28033 | 4823 | 48 |
497035 | 497035 | 2020-09-03 | DeSoto | Mississippi | 28033 | 4757 | 48 |
493802 | 493802 | 2020-09-02 | DeSoto | Mississippi | 28033 | 4713 | 48 |
490568 | 490568 | 2020-09-01 | DeSoto | Mississippi | 28033 | 4671 | 45 |
487335 | 487335 | 2020-08-31 | DeSoto | Mississippi | 28033 | 4624 | 44 |
484101 | 484101 | 2020-08-30 | DeSoto | Mississippi | 28033 | 4585 | 43 |
480866 | 480866 | 2020-08-29 | DeSoto | Mississippi | 28033 | 4548 | 43 |
477634 | 477634 | 2020-08-28 | DeSoto | Mississippi | 28033 | 4509 | 43 |
474401 | 474401 | 2020-08-27 | DeSoto | Mississippi | 28033 | 4456 | 43 |
471169 | 471169 | 2020-08-26 | DeSoto | Mississippi | 28033 | 4421 | 41 |
467939 | 467939 | 2020-08-25 | DeSoto | Mississippi | 28033 | 4365 | 41 |
464710 | 464710 | 2020-08-24 | DeSoto | Mississippi | 28033 | 4320 | 38 |
461479 | 461479 | 2020-08-23 | DeSoto | Mississippi | 28033 | 4279 | 38 |
458252 | 458252 | 2020-08-22 | DeSoto | Mississippi | 28033 | 4238 | 38 |
455024 | 455024 | 2020-08-21 | DeSoto | Mississippi | 28033 | 4185 | 37 |
451796 | 451796 | 2020-08-20 | DeSoto | Mississippi | 28033 | 4143 | 37 |
448568 | 448568 | 2020-08-19 | DeSoto | Mississippi | 28033 | 4079 | 35 |
445342 | 445342 | 2020-08-18 | DeSoto | Mississippi | 28033 | 3983 | 34 |
442116 | 442116 | 2020-08-17 | DeSoto | Mississippi | 28033 | 3913 | 34 |
438889 | 438889 | 2020-08-16 | DeSoto | Mississippi | 28033 | 3911 | 34 |
435664 | 435664 | 2020-08-15 | DeSoto | Mississippi | 28033 | 3888 | 34 |
432438 | 432438 | 2020-08-14 | DeSoto | Mississippi | 28033 | 3832 | 33 |
429211 | 429211 | 2020-08-13 | DeSoto | Mississippi | 28033 | 3796 | 32 |
425987 | 425987 | 2020-08-12 | DeSoto | Mississippi | 28033 | 3753 | 31 |
422765 | 422765 | 2020-08-11 | DeSoto | Mississippi | 28033 | 3710 | 31 |
419543 | 419543 | 2020-08-10 | DeSoto | Mississippi | 28033 | 3680 | 31 |
416322 | 416322 | 2020-08-09 | DeSoto | Mississippi | 28033 | 3658 | 31 |
413102 | 413102 | 2020-08-08 | DeSoto | Mississippi | 28033 | 3632 | 30 |
409882 | 409882 | 2020-08-07 | DeSoto | Mississippi | 28033 | 3574 | 30 |
406662 | 406662 | 2020-08-06 | DeSoto | Mississippi | 28033 | 3523 | 28 |
403444 | 403444 | 2020-08-05 | DeSoto | Mississippi | 28033 | 3472 | 27 |
400227 | 400227 | 2020-08-04 | DeSoto | Mississippi | 28033 | 3387 | 27 |
397013 | 397013 | 2020-08-03 | DeSoto | Mississippi | 28033 | 3326 | 27 |
393797 | 393797 | 2020-08-02 | DeSoto | Mississippi | 28033 | 3280 | 27 |
390580 | 390580 | 2020-08-01 | DeSoto | Mississippi | 28033 | 3215 | 27 |
387363 | 387363 | 2020-07-31 | DeSoto | Mississippi | 28033 | 3113 | 26 |
384145 | 384145 | 2020-07-30 | DeSoto | Mississippi | 28033 | 3062 | 26 |
380928 | 380928 | 2020-07-29 | DeSoto | Mississippi | 28033 | 2784 | 23 |
377711 | 377711 | 2020-07-28 | DeSoto | Mississippi | 28033 | 2784 | 23 |
374496 | 374496 | 2020-07-27 | DeSoto | Mississippi | 28033 | 2784 | 23 |
371284 | 371284 | 2020-07-26 | DeSoto | Mississippi | 28033 | 2784 | 23 |
368074 | 368074 | 2020-07-25 | DeSoto | Mississippi | 28033 | 2784 | 23 |
364866 | 364866 | 2020-07-24 | DeSoto | Mississippi | 28033 | 2746 | 21 |
361659 | 361659 | 2020-07-23 | DeSoto | Mississippi | 28033 | 2668 | 21 |
358454 | 358454 | 2020-07-22 | DeSoto | Mississippi | 28033 | 2619 | 20 |
355251 | 355251 | 2020-07-21 | DeSoto | Mississippi | 28033 | 2474 | 20 |
352049 | 352049 | 2020-07-20 | DeSoto | Mississippi | 28033 | 2394 | 20 |
348849 | 348849 | 2020-07-19 | DeSoto | Mississippi | 28033 | 2347 | 20 |
345648 | 345648 | 2020-07-18 | DeSoto | Mississippi | 28033 | 2265 | 20 |
342448 | 342448 | 2020-07-17 | DeSoto | Mississippi | 28033 | 2220 | 20 |
339252 | 339252 | 2020-07-16 | DeSoto | Mississippi | 28033 | 2171 | 20 |
336056 | 336056 | 2020-07-15 | DeSoto | Mississippi | 28033 | 2112 | 20 |
332863 | 332863 | 2020-07-14 | DeSoto | Mississippi | 28033 | 2050 | 20 |
329676 | 329676 | 2020-07-13 | DeSoto | Mississippi | 28033 | 2009 | 20 |
326490 | 326490 | 2020-07-12 | DeSoto | Mississippi | 28033 | 1959 | 20 |
323307 | 323307 | 2020-07-11 | DeSoto | Mississippi | 28033 | 1900 | 19 |
320128 | 320128 | 2020-07-10 | DeSoto | Mississippi | 28033 | 1865 | 19 |
316953 | 316953 | 2020-07-09 | DeSoto | Mississippi | 28033 | 1818 | 18 |
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);