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 |
---|---|---|---|---|---|---|---|
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 |
730390 | 730390 | 2020-11-14 | Franklin | Mississippi | 28037 | 275 | 4 |
727147 | 727147 | 2020-11-13 | Franklin | Mississippi | 28037 | 274 | 3 |
723904 | 723904 | 2020-11-12 | Franklin | Mississippi | 28037 | 271 | 3 |
720661 | 720661 | 2020-11-11 | Franklin | Mississippi | 28037 | 267 | 3 |
717418 | 717418 | 2020-11-10 | Franklin | Mississippi | 28037 | 266 | 3 |
714174 | 714174 | 2020-11-09 | Franklin | Mississippi | 28037 | 264 | 3 |
710930 | 710930 | 2020-11-08 | Franklin | Mississippi | 28037 | 262 | 3 |
707686 | 707686 | 2020-11-07 | Franklin | Mississippi | 28037 | 261 | 3 |
704443 | 704443 | 2020-11-06 | Franklin | Mississippi | 28037 | 260 | 3 |
701201 | 701201 | 2020-11-05 | Franklin | Mississippi | 28037 | 260 | 3 |
697957 | 697957 | 2020-11-04 | Franklin | Mississippi | 28037 | 259 | 3 |
694714 | 694714 | 2020-11-03 | Franklin | Mississippi | 28037 | 259 | 3 |
691472 | 691472 | 2020-11-02 | Franklin | Mississippi | 28037 | 258 | 3 |
688227 | 688227 | 2020-11-01 | Franklin | Mississippi | 28037 | 258 | 3 |
684983 | 684983 | 2020-10-31 | Franklin | Mississippi | 28037 | 256 | 3 |
681740 | 681740 | 2020-10-30 | Franklin | Mississippi | 28037 | 253 | 3 |
678496 | 678496 | 2020-10-29 | Franklin | Mississippi | 28037 | 253 | 3 |
675254 | 675254 | 2020-10-28 | Franklin | Mississippi | 28037 | 251 | 3 |
672011 | 672011 | 2020-10-27 | Franklin | Mississippi | 28037 | 248 | 3 |
668769 | 668769 | 2020-10-26 | Franklin | Mississippi | 28037 | 246 | 3 |
665525 | 665525 | 2020-10-25 | Franklin | Mississippi | 28037 | 242 | 3 |
662280 | 662280 | 2020-10-24 | Franklin | Mississippi | 28037 | 242 | 3 |
659036 | 659036 | 2020-10-23 | Franklin | Mississippi | 28037 | 240 | 3 |
655791 | 655791 | 2020-10-22 | Franklin | Mississippi | 28037 | 237 | 3 |
652546 | 652546 | 2020-10-21 | Franklin | Mississippi | 28037 | 237 | 3 |
649301 | 649301 | 2020-10-20 | Franklin | Mississippi | 28037 | 237 | 3 |
646057 | 646057 | 2020-10-19 | Franklin | Mississippi | 28037 | 230 | 3 |
642810 | 642810 | 2020-10-18 | Franklin | Mississippi | 28037 | 228 | 3 |
639563 | 639563 | 2020-10-17 | Franklin | Mississippi | 28037 | 228 | 3 |
636317 | 636317 | 2020-10-16 | Franklin | Mississippi | 28037 | 223 | 3 |
633071 | 633071 | 2020-10-15 | Franklin | Mississippi | 28037 | 220 | 3 |
629826 | 629826 | 2020-10-14 | Franklin | Mississippi | 28037 | 213 | 3 |
626582 | 626582 | 2020-10-13 | Franklin | Mississippi | 28037 | 212 | 3 |
623340 | 623340 | 2020-10-12 | Franklin | Mississippi | 28037 | 212 | 3 |
620097 | 620097 | 2020-10-11 | Franklin | Mississippi | 28037 | 211 | 3 |
616855 | 616855 | 2020-10-10 | Franklin | Mississippi | 28037 | 211 | 3 |
613614 | 613614 | 2020-10-09 | Franklin | Mississippi | 28037 | 209 | 3 |
610372 | 610372 | 2020-10-08 | Franklin | Mississippi | 28037 | 207 | 3 |
607130 | 607130 | 2020-10-07 | Franklin | Mississippi | 28037 | 206 | 3 |
603887 | 603887 | 2020-10-06 | Franklin | Mississippi | 28037 | 206 | 3 |
600645 | 600645 | 2020-10-05 | Franklin | Mississippi | 28037 | 204 | 3 |
597402 | 597402 | 2020-10-04 | Franklin | Mississippi | 28037 | 204 | 3 |
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);