ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rankin" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918667 | 918667 | 2021-01-11 | Rankin | Mississippi | 28121 | 10084 | 189 |
915422 | 915422 | 2021-01-10 | Rankin | Mississippi | 28121 | 9979 | 187 |
912177 | 912177 | 2021-01-09 | Rankin | Mississippi | 28121 | 9872 | 186 |
908932 | 908932 | 2021-01-08 | Rankin | Mississippi | 28121 | 9663 | 180 |
905686 | 905686 | 2021-01-07 | Rankin | Mississippi | 28121 | 9465 | 179 |
902441 | 902441 | 2021-01-06 | Rankin | Mississippi | 28121 | 9361 | 178 |
899196 | 899196 | 2021-01-05 | Rankin | Mississippi | 28121 | 9228 | 175 |
895951 | 895951 | 2021-01-04 | Rankin | Mississippi | 28121 | 9202 | 171 |
892704 | 892704 | 2021-01-03 | Rankin | Mississippi | 28121 | 9139 | 171 |
889458 | 889458 | 2021-01-02 | Rankin | Mississippi | 28121 | 9086 | 169 |
886212 | 886212 | 2021-01-01 | Rankin | Mississippi | 28121 | 8957 | 168 |
882967 | 882967 | 2020-12-31 | Rankin | Mississippi | 28121 | 8793 | 165 |
879722 | 879722 | 2020-12-30 | Rankin | Mississippi | 28121 | 8671 | 163 |
876477 | 876477 | 2020-12-29 | Rankin | Mississippi | 28121 | 8510 | 163 |
873232 | 873232 | 2020-12-28 | Rankin | Mississippi | 28121 | 8449 | 161 |
869987 | 869987 | 2020-12-27 | Rankin | Mississippi | 28121 | 8350 | 157 |
866742 | 866742 | 2020-12-26 | Rankin | Mississippi | 28121 | 8284 | 156 |
863497 | 863497 | 2020-12-25 | Rankin | Mississippi | 28121 | 8256 | 156 |
860252 | 860252 | 2020-12-24 | Rankin | Mississippi | 28121 | 8197 | 156 |
857007 | 857007 | 2020-12-23 | Rankin | Mississippi | 28121 | 8116 | 155 |
853762 | 853762 | 2020-12-22 | Rankin | Mississippi | 28121 | 8020 | 149 |
850517 | 850517 | 2020-12-21 | Rankin | Mississippi | 28121 | 7952 | 143 |
847272 | 847272 | 2020-12-20 | Rankin | Mississippi | 28121 | 7902 | 143 |
844026 | 844026 | 2020-12-19 | Rankin | Mississippi | 28121 | 7795 | 143 |
840781 | 840781 | 2020-12-18 | Rankin | Mississippi | 28121 | 7741 | 142 |
837536 | 837536 | 2020-12-17 | Rankin | Mississippi | 28121 | 7636 | 140 |
834290 | 834290 | 2020-12-16 | Rankin | Mississippi | 28121 | 7542 | 136 |
831043 | 831043 | 2020-12-15 | Rankin | Mississippi | 28121 | 7366 | 132 |
827797 | 827797 | 2020-12-14 | Rankin | Mississippi | 28121 | 7285 | 129 |
824550 | 824550 | 2020-12-13 | Rankin | Mississippi | 28121 | 7254 | 129 |
821304 | 821304 | 2020-12-12 | Rankin | Mississippi | 28121 | 7188 | 128 |
818058 | 818058 | 2020-12-11 | Rankin | Mississippi | 28121 | 7036 | 122 |
814812 | 814812 | 2020-12-10 | Rankin | Mississippi | 28121 | 6886 | 118 |
811567 | 811567 | 2020-12-09 | Rankin | Mississippi | 28121 | 6785 | 117 |
808322 | 808322 | 2020-12-08 | Rankin | Mississippi | 28121 | 6645 | 117 |
805077 | 805077 | 2020-12-07 | Rankin | Mississippi | 28121 | 6589 | 116 |
801832 | 801832 | 2020-12-06 | Rankin | Mississippi | 28121 | 6544 | 116 |
798587 | 798587 | 2020-12-05 | Rankin | Mississippi | 28121 | 6422 | 115 |
795342 | 795342 | 2020-12-04 | Rankin | Mississippi | 28121 | 6303 | 114 |
792097 | 792097 | 2020-12-03 | Rankin | Mississippi | 28121 | 6130 | 112 |
788852 | 788852 | 2020-12-02 | Rankin | Mississippi | 28121 | 6057 | 107 |
785607 | 785607 | 2020-12-01 | Rankin | Mississippi | 28121 | 5887 | 106 |
782363 | 782363 | 2020-11-30 | Rankin | Mississippi | 28121 | 5805 | 103 |
779117 | 779117 | 2020-11-29 | Rankin | Mississippi | 28121 | 5705 | 103 |
775872 | 775872 | 2020-11-28 | Rankin | Mississippi | 28121 | 5588 | 103 |
772627 | 772627 | 2020-11-27 | Rankin | Mississippi | 28121 | 5462 | 102 |
769382 | 769382 | 2020-11-26 | Rankin | Mississippi | 28121 | 5417 | 102 |
766136 | 766136 | 2020-11-25 | Rankin | Mississippi | 28121 | 5319 | 100 |
762891 | 762891 | 2020-11-24 | Rankin | Mississippi | 28121 | 5285 | 98 |
759646 | 759646 | 2020-11-23 | Rankin | Mississippi | 28121 | 5237 | 96 |
756399 | 756399 | 2020-11-22 | Rankin | Mississippi | 28121 | 5219 | 96 |
753153 | 753153 | 2020-11-21 | Rankin | Mississippi | 28121 | 5187 | 96 |
749907 | 749907 | 2020-11-20 | Rankin | Mississippi | 28121 | 5078 | 95 |
746661 | 746661 | 2020-11-19 | Rankin | Mississippi | 28121 | 5038 | 94 |
743414 | 743414 | 2020-11-18 | Rankin | Mississippi | 28121 | 4954 | 93 |
740167 | 740167 | 2020-11-17 | Rankin | Mississippi | 28121 | 4833 | 91 |
736923 | 736923 | 2020-11-16 | Rankin | Mississippi | 28121 | 4798 | 90 |
733677 | 733677 | 2020-11-15 | Rankin | Mississippi | 28121 | 4784 | 90 |
730432 | 730432 | 2020-11-14 | Rankin | Mississippi | 28121 | 4744 | 90 |
727189 | 727189 | 2020-11-13 | Rankin | Mississippi | 28121 | 4702 | 89 |
723946 | 723946 | 2020-11-12 | Rankin | Mississippi | 28121 | 4640 | 89 |
720703 | 720703 | 2020-11-11 | Rankin | Mississippi | 28121 | 4586 | 89 |
717460 | 717460 | 2020-11-10 | Rankin | Mississippi | 28121 | 4515 | 89 |
714216 | 714216 | 2020-11-09 | Rankin | Mississippi | 28121 | 4477 | 89 |
710972 | 710972 | 2020-11-08 | Rankin | Mississippi | 28121 | 4444 | 89 |
707728 | 707728 | 2020-11-07 | Rankin | Mississippi | 28121 | 4414 | 89 |
704485 | 704485 | 2020-11-06 | Rankin | Mississippi | 28121 | 4373 | 88 |
701243 | 701243 | 2020-11-05 | Rankin | Mississippi | 28121 | 4309 | 88 |
697999 | 697999 | 2020-11-04 | Rankin | Mississippi | 28121 | 4258 | 88 |
694756 | 694756 | 2020-11-03 | Rankin | Mississippi | 28121 | 4218 | 88 |
691514 | 691514 | 2020-11-02 | Rankin | Mississippi | 28121 | 4192 | 86 |
688269 | 688269 | 2020-11-01 | Rankin | Mississippi | 28121 | 4187 | 86 |
685025 | 685025 | 2020-10-31 | Rankin | Mississippi | 28121 | 4188 | 86 |
681782 | 681782 | 2020-10-30 | Rankin | Mississippi | 28121 | 4171 | 86 |
678538 | 678538 | 2020-10-29 | Rankin | Mississippi | 28121 | 4123 | 86 |
675296 | 675296 | 2020-10-28 | Rankin | Mississippi | 28121 | 4046 | 86 |
672053 | 672053 | 2020-10-27 | Rankin | Mississippi | 28121 | 4016 | 86 |
668811 | 668811 | 2020-10-26 | Rankin | Mississippi | 28121 | 3982 | 86 |
665567 | 665567 | 2020-10-25 | Rankin | Mississippi | 28121 | 3940 | 86 |
662322 | 662322 | 2020-10-24 | Rankin | Mississippi | 28121 | 3940 | 86 |
659078 | 659078 | 2020-10-23 | Rankin | Mississippi | 28121 | 3894 | 86 |
655833 | 655833 | 2020-10-22 | Rankin | Mississippi | 28121 | 3881 | 86 |
652588 | 652588 | 2020-10-21 | Rankin | Mississippi | 28121 | 3859 | 86 |
649343 | 649343 | 2020-10-20 | Rankin | Mississippi | 28121 | 3837 | 86 |
646099 | 646099 | 2020-10-19 | Rankin | Mississippi | 28121 | 3808 | 86 |
642852 | 642852 | 2020-10-18 | Rankin | Mississippi | 28121 | 3800 | 86 |
639605 | 639605 | 2020-10-17 | Rankin | Mississippi | 28121 | 3800 | 86 |
636359 | 636359 | 2020-10-16 | Rankin | Mississippi | 28121 | 3773 | 86 |
633113 | 633113 | 2020-10-15 | Rankin | Mississippi | 28121 | 3728 | 86 |
629868 | 629868 | 2020-10-14 | Rankin | Mississippi | 28121 | 3658 | 86 |
626624 | 626624 | 2020-10-13 | Rankin | Mississippi | 28121 | 3630 | 84 |
623382 | 623382 | 2020-10-12 | Rankin | Mississippi | 28121 | 3595 | 83 |
620139 | 620139 | 2020-10-11 | Rankin | Mississippi | 28121 | 3594 | 83 |
616897 | 616897 | 2020-10-10 | Rankin | Mississippi | 28121 | 3592 | 83 |
613656 | 613656 | 2020-10-09 | Rankin | Mississippi | 28121 | 3563 | 83 |
610414 | 610414 | 2020-10-08 | Rankin | Mississippi | 28121 | 3529 | 83 |
607172 | 607172 | 2020-10-07 | Rankin | Mississippi | 28121 | 3507 | 82 |
603929 | 603929 | 2020-10-06 | Rankin | Mississippi | 28121 | 3491 | 80 |
600687 | 600687 | 2020-10-05 | Rankin | Mississippi | 28121 | 3458 | 80 |
597444 | 597444 | 2020-10-04 | Rankin | Mississippi | 28121 | 3446 | 80 |
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);