ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 28045 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
740129 | 740129 | 2020-11-17 | Hancock | Mississippi | 28045 | 1082 | 35 |
736885 | 736885 | 2020-11-16 | Hancock | Mississippi | 28045 | 1071 | 34 |
733639 | 733639 | 2020-11-15 | Hancock | Mississippi | 28045 | 1068 | 34 |
730394 | 730394 | 2020-11-14 | Hancock | Mississippi | 28045 | 1060 | 34 |
727151 | 727151 | 2020-11-13 | Hancock | Mississippi | 28045 | 1037 | 34 |
723908 | 723908 | 2020-11-12 | Hancock | Mississippi | 28045 | 1008 | 34 |
720665 | 720665 | 2020-11-11 | Hancock | Mississippi | 28045 | 1003 | 33 |
717422 | 717422 | 2020-11-10 | Hancock | Mississippi | 28045 | 984 | 33 |
714178 | 714178 | 2020-11-09 | Hancock | Mississippi | 28045 | 977 | 33 |
710934 | 710934 | 2020-11-08 | Hancock | Mississippi | 28045 | 972 | 33 |
707690 | 707690 | 2020-11-07 | Hancock | Mississippi | 28045 | 965 | 33 |
704447 | 704447 | 2020-11-06 | Hancock | Mississippi | 28045 | 949 | 33 |
701205 | 701205 | 2020-11-05 | Hancock | Mississippi | 28045 | 933 | 32 |
697961 | 697961 | 2020-11-04 | Hancock | Mississippi | 28045 | 921 | 31 |
694718 | 694718 | 2020-11-03 | Hancock | Mississippi | 28045 | 917 | 31 |
691476 | 691476 | 2020-11-02 | Hancock | Mississippi | 28045 | 900 | 30 |
688231 | 688231 | 2020-11-01 | Hancock | Mississippi | 28045 | 898 | 30 |
684987 | 684987 | 2020-10-31 | Hancock | Mississippi | 28045 | 892 | 29 |
681744 | 681744 | 2020-10-30 | Hancock | Mississippi | 28045 | 883 | 29 |
678500 | 678500 | 2020-10-29 | Hancock | Mississippi | 28045 | 881 | 28 |
675258 | 675258 | 2020-10-28 | Hancock | Mississippi | 28045 | 868 | 28 |
672015 | 672015 | 2020-10-27 | Hancock | Mississippi | 28045 | 859 | 28 |
668773 | 668773 | 2020-10-26 | Hancock | Mississippi | 28045 | 850 | 28 |
665529 | 665529 | 2020-10-25 | Hancock | Mississippi | 28045 | 840 | 28 |
662284 | 662284 | 2020-10-24 | Hancock | Mississippi | 28045 | 840 | 28 |
659040 | 659040 | 2020-10-23 | Hancock | Mississippi | 28045 | 816 | 28 |
655795 | 655795 | 2020-10-22 | Hancock | Mississippi | 28045 | 798 | 27 |
652550 | 652550 | 2020-10-21 | Hancock | Mississippi | 28045 | 787 | 27 |
649305 | 649305 | 2020-10-20 | Hancock | Mississippi | 28045 | 781 | 27 |
646061 | 646061 | 2020-10-19 | Hancock | Mississippi | 28045 | 769 | 27 |
642814 | 642814 | 2020-10-18 | Hancock | Mississippi | 28045 | 765 | 27 |
639567 | 639567 | 2020-10-17 | Hancock | Mississippi | 28045 | 765 | 27 |
636321 | 636321 | 2020-10-16 | Hancock | Mississippi | 28045 | 739 | 27 |
633075 | 633075 | 2020-10-15 | Hancock | Mississippi | 28045 | 722 | 27 |
629830 | 629830 | 2020-10-14 | Hancock | Mississippi | 28045 | 706 | 27 |
626586 | 626586 | 2020-10-13 | Hancock | Mississippi | 28045 | 701 | 27 |
623344 | 623344 | 2020-10-12 | Hancock | Mississippi | 28045 | 696 | 26 |
620101 | 620101 | 2020-10-11 | Hancock | Mississippi | 28045 | 688 | 26 |
616859 | 616859 | 2020-10-10 | Hancock | Mississippi | 28045 | 687 | 26 |
613618 | 613618 | 2020-10-09 | Hancock | Mississippi | 28045 | 672 | 25 |
610376 | 610376 | 2020-10-08 | Hancock | Mississippi | 28045 | 663 | 25 |
607134 | 607134 | 2020-10-07 | Hancock | Mississippi | 28045 | 648 | 25 |
603891 | 603891 | 2020-10-06 | Hancock | Mississippi | 28045 | 639 | 23 |
600649 | 600649 | 2020-10-05 | Hancock | Mississippi | 28045 | 624 | 22 |
597406 | 597406 | 2020-10-04 | Hancock | Mississippi | 28045 | 622 | 22 |
594165 | 594165 | 2020-10-03 | Hancock | Mississippi | 28045 | 617 | 22 |
590924 | 590924 | 2020-10-02 | Hancock | Mississippi | 28045 | 610 | 22 |
587683 | 587683 | 2020-10-01 | Hancock | Mississippi | 28045 | 607 | 22 |
584443 | 584443 | 2020-09-30 | Hancock | Mississippi | 28045 | 598 | 22 |
581202 | 581202 | 2020-09-29 | Hancock | Mississippi | 28045 | 595 | 22 |
577961 | 577961 | 2020-09-28 | Hancock | Mississippi | 28045 | 590 | 22 |
574720 | 574720 | 2020-09-27 | Hancock | Mississippi | 28045 | 588 | 22 |
571477 | 571477 | 2020-09-26 | Hancock | Mississippi | 28045 | 587 | 22 |
568235 | 568235 | 2020-09-25 | Hancock | Mississippi | 28045 | 582 | 22 |
564995 | 564995 | 2020-09-24 | Hancock | Mississippi | 28045 | 577 | 21 |
561755 | 561755 | 2020-09-23 | Hancock | Mississippi | 28045 | 572 | 21 |
558518 | 558518 | 2020-09-22 | Hancock | Mississippi | 28045 | 569 | 21 |
555281 | 555281 | 2020-09-21 | Hancock | Mississippi | 28045 | 564 | 21 |
552043 | 552043 | 2020-09-20 | Hancock | Mississippi | 28045 | 561 | 21 |
548804 | 548804 | 2020-09-19 | Hancock | Mississippi | 28045 | 561 | 21 |
545566 | 545566 | 2020-09-18 | Hancock | Mississippi | 28045 | 557 | 20 |
542329 | 542329 | 2020-09-17 | Hancock | Mississippi | 28045 | 554 | 20 |
539093 | 539093 | 2020-09-16 | Hancock | Mississippi | 28045 | 544 | 20 |
535856 | 535856 | 2020-09-15 | Hancock | Mississippi | 28045 | 542 | 20 |
532621 | 532621 | 2020-09-14 | Hancock | Mississippi | 28045 | 540 | 20 |
529385 | 529385 | 2020-09-13 | Hancock | Mississippi | 28045 | 538 | 20 |
526149 | 526149 | 2020-09-12 | Hancock | Mississippi | 28045 | 537 | 20 |
522913 | 522913 | 2020-09-11 | Hancock | Mississippi | 28045 | 538 | 20 |
519676 | 519676 | 2020-09-10 | Hancock | Mississippi | 28045 | 529 | 20 |
516441 | 516441 | 2020-09-09 | Hancock | Mississippi | 28045 | 526 | 20 |
513207 | 513207 | 2020-09-08 | Hancock | Mississippi | 28045 | 520 | 20 |
509975 | 509975 | 2020-09-07 | Hancock | Mississippi | 28045 | 517 | 20 |
506742 | 506742 | 2020-09-06 | Hancock | Mississippi | 28045 | 515 | 20 |
503509 | 503509 | 2020-09-05 | Hancock | Mississippi | 28045 | 513 | 20 |
500275 | 500275 | 2020-09-04 | Hancock | Mississippi | 28045 | 510 | 20 |
497041 | 497041 | 2020-09-03 | Hancock | Mississippi | 28045 | 508 | 20 |
493808 | 493808 | 2020-09-02 | Hancock | Mississippi | 28045 | 502 | 20 |
490574 | 490574 | 2020-09-01 | Hancock | Mississippi | 28045 | 501 | 20 |
487341 | 487341 | 2020-08-31 | Hancock | Mississippi | 28045 | 495 | 20 |
484107 | 484107 | 2020-08-30 | Hancock | Mississippi | 28045 | 490 | 20 |
480872 | 480872 | 2020-08-29 | Hancock | Mississippi | 28045 | 487 | 18 |
477640 | 477640 | 2020-08-28 | Hancock | Mississippi | 28045 | 480 | 18 |
474407 | 474407 | 2020-08-27 | Hancock | Mississippi | 28045 | 472 | 18 |
471175 | 471175 | 2020-08-26 | Hancock | Mississippi | 28045 | 466 | 18 |
467945 | 467945 | 2020-08-25 | Hancock | Mississippi | 28045 | 463 | 18 |
464716 | 464716 | 2020-08-24 | Hancock | Mississippi | 28045 | 457 | 18 |
461485 | 461485 | 2020-08-23 | Hancock | Mississippi | 28045 | 454 | 18 |
458258 | 458258 | 2020-08-22 | Hancock | Mississippi | 28045 | 450 | 18 |
455030 | 455030 | 2020-08-21 | Hancock | Mississippi | 28045 | 448 | 18 |
451802 | 451802 | 2020-08-20 | Hancock | Mississippi | 28045 | 442 | 17 |
448574 | 448574 | 2020-08-19 | Hancock | Mississippi | 28045 | 436 | 17 |
445348 | 445348 | 2020-08-18 | Hancock | Mississippi | 28045 | 432 | 17 |
442122 | 442122 | 2020-08-17 | Hancock | Mississippi | 28045 | 432 | 16 |
438895 | 438895 | 2020-08-16 | Hancock | Mississippi | 28045 | 425 | 15 |
435670 | 435670 | 2020-08-15 | Hancock | Mississippi | 28045 | 422 | 15 |
432444 | 432444 | 2020-08-14 | Hancock | Mississippi | 28045 | 419 | 15 |
429217 | 429217 | 2020-08-13 | Hancock | Mississippi | 28045 | 414 | 15 |
425993 | 425993 | 2020-08-12 | Hancock | Mississippi | 28045 | 409 | 15 |
422771 | 422771 | 2020-08-11 | Hancock | Mississippi | 28045 | 402 | 14 |
419549 | 419549 | 2020-08-10 | Hancock | Mississippi | 28045 | 395 | 14 |
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);