ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Franklin" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054939 | 1054939 | 2021-02-22 | Franklin | Mississippi | 28037 | 750 | 19 |
1051692 | 1051692 | 2021-02-21 | Franklin | Mississippi | 28037 | 750 | 19 |
1048445 | 1048445 | 2021-02-20 | Franklin | Mississippi | 28037 | 750 | 19 |
1045199 | 1045199 | 2021-02-19 | Franklin | Mississippi | 28037 | 750 | 19 |
1041954 | 1041954 | 2021-02-18 | Franklin | Mississippi | 28037 | 750 | 19 |
1038709 | 1038709 | 2021-02-17 | Franklin | Mississippi | 28037 | 750 | 19 |
1035464 | 1035464 | 2021-02-16 | Franklin | Mississippi | 28037 | 748 | 19 |
1032219 | 1032219 | 2021-02-15 | Franklin | Mississippi | 28037 | 747 | 19 |
1028972 | 1028972 | 2021-02-14 | Franklin | Mississippi | 28037 | 745 | 19 |
1025726 | 1025726 | 2021-02-13 | Franklin | Mississippi | 28037 | 743 | 19 |
1022481 | 1022481 | 2021-02-12 | Franklin | Mississippi | 28037 | 739 | 19 |
1019236 | 1019236 | 2021-02-11 | Franklin | Mississippi | 28037 | 737 | 19 |
1015991 | 1015991 | 2021-02-10 | Franklin | Mississippi | 28037 | 736 | 19 |
1012746 | 1012746 | 2021-02-09 | Franklin | Mississippi | 28037 | 737 | 19 |
1009501 | 1009501 | 2021-02-08 | Franklin | Mississippi | 28037 | 735 | 19 |
1006254 | 1006254 | 2021-02-07 | Franklin | Mississippi | 28037 | 735 | 19 |
1003008 | 1003008 | 2021-02-06 | Franklin | Mississippi | 28037 | 733 | 19 |
999763 | 999763 | 2021-02-05 | Franklin | Mississippi | 28037 | 730 | 19 |
996517 | 996517 | 2021-02-04 | Franklin | Mississippi | 28037 | 726 | 19 |
993271 | 993271 | 2021-02-03 | Franklin | Mississippi | 28037 | 726 | 19 |
990025 | 990025 | 2021-02-02 | Franklin | Mississippi | 28037 | 725 | 19 |
986778 | 986778 | 2021-02-01 | Franklin | Mississippi | 28037 | 723 | 19 |
983531 | 983531 | 2021-01-31 | Franklin | Mississippi | 28037 | 722 | 19 |
980285 | 980285 | 2021-01-30 | Franklin | Mississippi | 28037 | 719 | 18 |
977039 | 977039 | 2021-01-29 | Franklin | Mississippi | 28037 | 716 | 17 |
973794 | 973794 | 2021-01-28 | Franklin | Mississippi | 28037 | 715 | 17 |
970549 | 970549 | 2021-01-27 | Franklin | Mississippi | 28037 | 715 | 17 |
967304 | 967304 | 2021-01-26 | Franklin | Mississippi | 28037 | 710 | 17 |
964060 | 964060 | 2021-01-25 | Franklin | Mississippi | 28037 | 707 | 17 |
960815 | 960815 | 2021-01-24 | Franklin | Mississippi | 28037 | 706 | 17 |
957569 | 957569 | 2021-01-23 | Franklin | Mississippi | 28037 | 699 | 17 |
954324 | 954324 | 2021-01-22 | Franklin | Mississippi | 28037 | 696 | 17 |
951079 | 951079 | 2021-01-21 | Franklin | Mississippi | 28037 | 687 | 16 |
947833 | 947833 | 2021-01-20 | Franklin | Mississippi | 28037 | 671 | 15 |
944586 | 944586 | 2021-01-19 | Franklin | Mississippi | 28037 | 667 | 15 |
941341 | 941341 | 2021-01-18 | Franklin | Mississippi | 28037 | 666 | 15 |
938096 | 938096 | 2021-01-17 | Franklin | Mississippi | 28037 | 664 | 15 |
934851 | 934851 | 2021-01-16 | Franklin | Mississippi | 28037 | 658 | 15 |
931606 | 931606 | 2021-01-15 | Franklin | Mississippi | 28037 | 653 | 15 |
928361 | 928361 | 2021-01-14 | Franklin | Mississippi | 28037 | 646 | 13 |
925115 | 925115 | 2021-01-13 | Franklin | Mississippi | 28037 | 643 | 13 |
921870 | 921870 | 2021-01-12 | Franklin | Mississippi | 28037 | 640 | 13 |
918625 | 918625 | 2021-01-11 | Franklin | Mississippi | 28037 | 640 | 12 |
915380 | 915380 | 2021-01-10 | Franklin | Mississippi | 28037 | 639 | 12 |
912135 | 912135 | 2021-01-09 | Franklin | Mississippi | 28037 | 638 | 12 |
908890 | 908890 | 2021-01-08 | Franklin | Mississippi | 28037 | 629 | 12 |
905644 | 905644 | 2021-01-07 | Franklin | Mississippi | 28037 | 624 | 11 |
902399 | 902399 | 2021-01-06 | Franklin | Mississippi | 28037 | 620 | 11 |
899154 | 899154 | 2021-01-05 | Franklin | Mississippi | 28037 | 618 | 9 |
895909 | 895909 | 2021-01-04 | Franklin | Mississippi | 28037 | 610 | 9 |
892662 | 892662 | 2021-01-03 | Franklin | Mississippi | 28037 | 603 | 9 |
889416 | 889416 | 2021-01-02 | Franklin | Mississippi | 28037 | 601 | 9 |
886170 | 886170 | 2021-01-01 | Franklin | Mississippi | 28037 | 596 | 9 |
882925 | 882925 | 2020-12-31 | Franklin | Mississippi | 28037 | 586 | 9 |
879680 | 879680 | 2020-12-30 | Franklin | Mississippi | 28037 | 578 | 8 |
876435 | 876435 | 2020-12-29 | Franklin | Mississippi | 28037 | 574 | 8 |
873190 | 873190 | 2020-12-28 | Franklin | Mississippi | 28037 | 562 | 7 |
869945 | 869945 | 2020-12-27 | Franklin | Mississippi | 28037 | 559 | 7 |
866700 | 866700 | 2020-12-26 | Franklin | Mississippi | 28037 | 557 | 7 |
863455 | 863455 | 2020-12-25 | Franklin | Mississippi | 28037 | 556 | 7 |
860210 | 860210 | 2020-12-24 | Franklin | Mississippi | 28037 | 550 | 7 |
856965 | 856965 | 2020-12-23 | Franklin | Mississippi | 28037 | 544 | 6 |
853720 | 853720 | 2020-12-22 | Franklin | Mississippi | 28037 | 531 | 6 |
850475 | 850475 | 2020-12-21 | Franklin | Mississippi | 28037 | 520 | 6 |
847230 | 847230 | 2020-12-20 | Franklin | Mississippi | 28037 | 518 | 6 |
843984 | 843984 | 2020-12-19 | Franklin | Mississippi | 28037 | 515 | 6 |
840739 | 840739 | 2020-12-18 | Franklin | Mississippi | 28037 | 501 | 6 |
837494 | 837494 | 2020-12-17 | Franklin | Mississippi | 28037 | 491 | 6 |
834248 | 834248 | 2020-12-16 | Franklin | Mississippi | 28037 | 475 | 6 |
831001 | 831001 | 2020-12-15 | Franklin | Mississippi | 28037 | 470 | 6 |
827755 | 827755 | 2020-12-14 | Franklin | Mississippi | 28037 | 467 | 6 |
824508 | 824508 | 2020-12-13 | Franklin | Mississippi | 28037 | 446 | 6 |
821262 | 821262 | 2020-12-12 | Franklin | Mississippi | 28037 | 441 | 6 |
818016 | 818016 | 2020-12-11 | Franklin | Mississippi | 28037 | 436 | 6 |
814770 | 814770 | 2020-12-10 | Franklin | Mississippi | 28037 | 426 | 6 |
811525 | 811525 | 2020-12-09 | Franklin | Mississippi | 28037 | 423 | 6 |
808280 | 808280 | 2020-12-08 | Franklin | Mississippi | 28037 | 406 | 6 |
805035 | 805035 | 2020-12-07 | Franklin | Mississippi | 28037 | 405 | 6 |
801790 | 801790 | 2020-12-06 | Franklin | Mississippi | 28037 | 402 | 6 |
798545 | 798545 | 2020-12-05 | Franklin | Mississippi | 28037 | 394 | 6 |
795300 | 795300 | 2020-12-04 | Franklin | Mississippi | 28037 | 386 | 6 |
792055 | 792055 | 2020-12-03 | Franklin | Mississippi | 28037 | 372 | 6 |
788810 | 788810 | 2020-12-02 | Franklin | Mississippi | 28037 | 363 | 5 |
785565 | 785565 | 2020-12-01 | Franklin | Mississippi | 28037 | 355 | 5 |
782321 | 782321 | 2020-11-30 | Franklin | Mississippi | 28037 | 353 | 5 |
779075 | 779075 | 2020-11-29 | Franklin | Mississippi | 28037 | 348 | 5 |
775830 | 775830 | 2020-11-28 | Franklin | Mississippi | 28037 | 339 | 5 |
772585 | 772585 | 2020-11-27 | Franklin | Mississippi | 28037 | 336 | 5 |
769340 | 769340 | 2020-11-26 | Franklin | Mississippi | 28037 | 334 | 5 |
766094 | 766094 | 2020-11-25 | Franklin | Mississippi | 28037 | 326 | 5 |
762849 | 762849 | 2020-11-24 | Franklin | Mississippi | 28037 | 323 | 5 |
759604 | 759604 | 2020-11-23 | Franklin | Mississippi | 28037 | 318 | 5 |
756357 | 756357 | 2020-11-22 | Franklin | Mississippi | 28037 | 315 | 5 |
753111 | 753111 | 2020-11-21 | Franklin | Mississippi | 28037 | 313 | 4 |
749865 | 749865 | 2020-11-20 | Franklin | Mississippi | 28037 | 308 | 4 |
746619 | 746619 | 2020-11-19 | Franklin | Mississippi | 28037 | 299 | 4 |
743372 | 743372 | 2020-11-18 | Franklin | Mississippi | 28037 | 297 | 4 |
740125 | 740125 | 2020-11-17 | Franklin | Mississippi | 28037 | 289 | 4 |
736881 | 736881 | 2020-11-16 | Franklin | Mississippi | 28037 | 282 | 4 |
733635 | 733635 | 2020-11-15 | Franklin | Mississippi | 28037 | 278 | 4 |
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);