ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Carroll" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921859 | 921859 | 2021-01-12 | Carroll | Mississippi | 28015 | 1016 | 20 |
918614 | 918614 | 2021-01-11 | Carroll | Mississippi | 28015 | 1011 | 20 |
915369 | 915369 | 2021-01-10 | Carroll | Mississippi | 28015 | 1011 | 20 |
912124 | 912124 | 2021-01-09 | Carroll | Mississippi | 28015 | 1003 | 18 |
908879 | 908879 | 2021-01-08 | Carroll | Mississippi | 28015 | 987 | 18 |
905633 | 905633 | 2021-01-07 | Carroll | Mississippi | 28015 | 977 | 18 |
902388 | 902388 | 2021-01-06 | Carroll | Mississippi | 28015 | 964 | 18 |
899143 | 899143 | 2021-01-05 | Carroll | Mississippi | 28015 | 959 | 18 |
895898 | 895898 | 2021-01-04 | Carroll | Mississippi | 28015 | 952 | 18 |
892651 | 892651 | 2021-01-03 | Carroll | Mississippi | 28015 | 949 | 18 |
889405 | 889405 | 2021-01-02 | Carroll | Mississippi | 28015 | 940 | 18 |
886159 | 886159 | 2021-01-01 | Carroll | Mississippi | 28015 | 936 | 18 |
882914 | 882914 | 2020-12-31 | Carroll | Mississippi | 28015 | 932 | 18 |
879669 | 879669 | 2020-12-30 | Carroll | Mississippi | 28015 | 924 | 18 |
876424 | 876424 | 2020-12-29 | Carroll | Mississippi | 28015 | 916 | 18 |
873179 | 873179 | 2020-12-28 | Carroll | Mississippi | 28015 | 915 | 18 |
869934 | 869934 | 2020-12-27 | Carroll | Mississippi | 28015 | 911 | 17 |
866689 | 866689 | 2020-12-26 | Carroll | Mississippi | 28015 | 910 | 17 |
863444 | 863444 | 2020-12-25 | Carroll | Mississippi | 28015 | 910 | 17 |
860199 | 860199 | 2020-12-24 | Carroll | Mississippi | 28015 | 904 | 17 |
856954 | 856954 | 2020-12-23 | Carroll | Mississippi | 28015 | 898 | 17 |
853709 | 853709 | 2020-12-22 | Carroll | Mississippi | 28015 | 896 | 17 |
850464 | 850464 | 2020-12-21 | Carroll | Mississippi | 28015 | 892 | 17 |
847219 | 847219 | 2020-12-20 | Carroll | Mississippi | 28015 | 892 | 17 |
843973 | 843973 | 2020-12-19 | Carroll | Mississippi | 28015 | 886 | 17 |
840728 | 840728 | 2020-12-18 | Carroll | Mississippi | 28015 | 883 | 17 |
837483 | 837483 | 2020-12-17 | Carroll | Mississippi | 28015 | 873 | 17 |
834237 | 834237 | 2020-12-16 | Carroll | Mississippi | 28015 | 863 | 17 |
830990 | 830990 | 2020-12-15 | Carroll | Mississippi | 28015 | 855 | 17 |
827744 | 827744 | 2020-12-14 | Carroll | Mississippi | 28015 | 851 | 17 |
824497 | 824497 | 2020-12-13 | Carroll | Mississippi | 28015 | 844 | 17 |
821251 | 821251 | 2020-12-12 | Carroll | Mississippi | 28015 | 842 | 17 |
818005 | 818005 | 2020-12-11 | Carroll | Mississippi | 28015 | 836 | 17 |
814759 | 814759 | 2020-12-10 | Carroll | Mississippi | 28015 | 829 | 15 |
811514 | 811514 | 2020-12-09 | Carroll | Mississippi | 28015 | 819 | 15 |
808269 | 808269 | 2020-12-08 | Carroll | Mississippi | 28015 | 813 | 15 |
805024 | 805024 | 2020-12-07 | Carroll | Mississippi | 28015 | 806 | 15 |
801779 | 801779 | 2020-12-06 | Carroll | Mississippi | 28015 | 802 | 15 |
798534 | 798534 | 2020-12-05 | Carroll | Mississippi | 28015 | 795 | 15 |
795289 | 795289 | 2020-12-04 | Carroll | Mississippi | 28015 | 781 | 15 |
792044 | 792044 | 2020-12-03 | Carroll | Mississippi | 28015 | 763 | 15 |
788799 | 788799 | 2020-12-02 | Carroll | Mississippi | 28015 | 755 | 15 |
785554 | 785554 | 2020-12-01 | Carroll | Mississippi | 28015 | 741 | 15 |
782310 | 782310 | 2020-11-30 | Carroll | Mississippi | 28015 | 740 | 15 |
779064 | 779064 | 2020-11-29 | Carroll | Mississippi | 28015 | 738 | 15 |
775819 | 775819 | 2020-11-28 | Carroll | Mississippi | 28015 | 724 | 15 |
772574 | 772574 | 2020-11-27 | Carroll | Mississippi | 28015 | 721 | 15 |
769329 | 769329 | 2020-11-26 | Carroll | Mississippi | 28015 | 714 | 15 |
766083 | 766083 | 2020-11-25 | Carroll | Mississippi | 28015 | 706 | 14 |
762838 | 762838 | 2020-11-24 | Carroll | Mississippi | 28015 | 706 | 14 |
759593 | 759593 | 2020-11-23 | Carroll | Mississippi | 28015 | 705 | 14 |
756346 | 756346 | 2020-11-22 | Carroll | Mississippi | 28015 | 701 | 14 |
753100 | 753100 | 2020-11-21 | Carroll | Mississippi | 28015 | 698 | 14 |
749854 | 749854 | 2020-11-20 | Carroll | Mississippi | 28015 | 680 | 14 |
746608 | 746608 | 2020-11-19 | Carroll | Mississippi | 28015 | 671 | 14 |
743361 | 743361 | 2020-11-18 | Carroll | Mississippi | 28015 | 664 | 13 |
740114 | 740114 | 2020-11-17 | Carroll | Mississippi | 28015 | 655 | 13 |
736870 | 736870 | 2020-11-16 | Carroll | Mississippi | 28015 | 651 | 13 |
733624 | 733624 | 2020-11-15 | Carroll | Mississippi | 28015 | 648 | 13 |
730379 | 730379 | 2020-11-14 | Carroll | Mississippi | 28015 | 643 | 13 |
727136 | 727136 | 2020-11-13 | Carroll | Mississippi | 28015 | 624 | 13 |
723893 | 723893 | 2020-11-12 | Carroll | Mississippi | 28015 | 615 | 13 |
720650 | 720650 | 2020-11-11 | Carroll | Mississippi | 28015 | 607 | 13 |
717407 | 717407 | 2020-11-10 | Carroll | Mississippi | 28015 | 590 | 13 |
714163 | 714163 | 2020-11-09 | Carroll | Mississippi | 28015 | 576 | 13 |
710919 | 710919 | 2020-11-08 | Carroll | Mississippi | 28015 | 573 | 13 |
707675 | 707675 | 2020-11-07 | Carroll | Mississippi | 28015 | 568 | 13 |
704432 | 704432 | 2020-11-06 | Carroll | Mississippi | 28015 | 557 | 12 |
701190 | 701190 | 2020-11-05 | Carroll | Mississippi | 28015 | 552 | 12 |
697946 | 697946 | 2020-11-04 | Carroll | Mississippi | 28015 | 541 | 12 |
694703 | 694703 | 2020-11-03 | Carroll | Mississippi | 28015 | 535 | 12 |
691461 | 691461 | 2020-11-02 | Carroll | Mississippi | 28015 | 532 | 12 |
688216 | 688216 | 2020-11-01 | Carroll | Mississippi | 28015 | 531 | 12 |
684972 | 684972 | 2020-10-31 | Carroll | Mississippi | 28015 | 526 | 12 |
681729 | 681729 | 2020-10-30 | Carroll | Mississippi | 28015 | 515 | 12 |
678485 | 678485 | 2020-10-29 | Carroll | Mississippi | 28015 | 509 | 12 |
675243 | 675243 | 2020-10-28 | Carroll | Mississippi | 28015 | 503 | 12 |
672000 | 672000 | 2020-10-27 | Carroll | Mississippi | 28015 | 497 | 12 |
668758 | 668758 | 2020-10-26 | Carroll | Mississippi | 28015 | 493 | 12 |
665514 | 665514 | 2020-10-25 | Carroll | Mississippi | 28015 | 493 | 12 |
662269 | 662269 | 2020-10-24 | Carroll | Mississippi | 28015 | 493 | 12 |
659025 | 659025 | 2020-10-23 | Carroll | Mississippi | 28015 | 480 | 12 |
655780 | 655780 | 2020-10-22 | Carroll | Mississippi | 28015 | 476 | 12 |
652535 | 652535 | 2020-10-21 | Carroll | Mississippi | 28015 | 468 | 12 |
649290 | 649290 | 2020-10-20 | Carroll | Mississippi | 28015 | 463 | 12 |
646046 | 646046 | 2020-10-19 | Carroll | Mississippi | 28015 | 460 | 12 |
642799 | 642799 | 2020-10-18 | Carroll | Mississippi | 28015 | 458 | 12 |
639552 | 639552 | 2020-10-17 | Carroll | Mississippi | 28015 | 458 | 12 |
636306 | 636306 | 2020-10-16 | Carroll | Mississippi | 28015 | 453 | 12 |
633060 | 633060 | 2020-10-15 | Carroll | Mississippi | 28015 | 449 | 12 |
629815 | 629815 | 2020-10-14 | Carroll | Mississippi | 28015 | 346 | 12 |
626571 | 626571 | 2020-10-13 | Carroll | Mississippi | 28015 | 343 | 12 |
623329 | 623329 | 2020-10-12 | Carroll | Mississippi | 28015 | 343 | 12 |
620086 | 620086 | 2020-10-11 | Carroll | Mississippi | 28015 | 343 | 12 |
616844 | 616844 | 2020-10-10 | Carroll | Mississippi | 28015 | 343 | 12 |
613603 | 613603 | 2020-10-09 | Carroll | Mississippi | 28015 | 341 | 12 |
610361 | 610361 | 2020-10-08 | Carroll | Mississippi | 28015 | 337 | 12 |
607119 | 607119 | 2020-10-07 | Carroll | Mississippi | 28015 | 336 | 12 |
603876 | 603876 | 2020-10-06 | Carroll | Mississippi | 28015 | 333 | 12 |
600634 | 600634 | 2020-10-05 | Carroll | Mississippi | 28015 | 332 | 12 |
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);