ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28157 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054999 | 1054999 | 2021-02-22 | Wilkinson | Mississippi | 28157 | 621 | 26 |
1051752 | 1051752 | 2021-02-21 | Wilkinson | Mississippi | 28157 | 621 | 26 |
1048505 | 1048505 | 2021-02-20 | Wilkinson | Mississippi | 28157 | 619 | 26 |
1045259 | 1045259 | 2021-02-19 | Wilkinson | Mississippi | 28157 | 619 | 26 |
1042014 | 1042014 | 2021-02-18 | Wilkinson | Mississippi | 28157 | 619 | 26 |
1038769 | 1038769 | 2021-02-17 | Wilkinson | Mississippi | 28157 | 618 | 26 |
1035524 | 1035524 | 2021-02-16 | Wilkinson | Mississippi | 28157 | 618 | 26 |
1032279 | 1032279 | 2021-02-15 | Wilkinson | Mississippi | 28157 | 617 | 26 |
1029032 | 1029032 | 2021-02-14 | Wilkinson | Mississippi | 28157 | 617 | 26 |
1025786 | 1025786 | 2021-02-13 | Wilkinson | Mississippi | 28157 | 617 | 26 |
1022541 | 1022541 | 2021-02-12 | Wilkinson | Mississippi | 28157 | 616 | 26 |
1019296 | 1019296 | 2021-02-11 | Wilkinson | Mississippi | 28157 | 614 | 26 |
1016051 | 1016051 | 2021-02-10 | Wilkinson | Mississippi | 28157 | 613 | 25 |
1012806 | 1012806 | 2021-02-09 | Wilkinson | Mississippi | 28157 | 613 | 25 |
1009561 | 1009561 | 2021-02-08 | Wilkinson | Mississippi | 28157 | 613 | 25 |
1006314 | 1006314 | 2021-02-07 | Wilkinson | Mississippi | 28157 | 613 | 25 |
1003068 | 1003068 | 2021-02-06 | Wilkinson | Mississippi | 28157 | 613 | 25 |
999823 | 999823 | 2021-02-05 | Wilkinson | Mississippi | 28157 | 611 | 25 |
996577 | 996577 | 2021-02-04 | Wilkinson | Mississippi | 28157 | 608 | 25 |
993331 | 993331 | 2021-02-03 | Wilkinson | Mississippi | 28157 | 607 | 25 |
990085 | 990085 | 2021-02-02 | Wilkinson | Mississippi | 28157 | 607 | 25 |
986838 | 986838 | 2021-02-01 | Wilkinson | Mississippi | 28157 | 607 | 25 |
983591 | 983591 | 2021-01-31 | Wilkinson | Mississippi | 28157 | 606 | 25 |
980345 | 980345 | 2021-01-30 | Wilkinson | Mississippi | 28157 | 606 | 25 |
977099 | 977099 | 2021-01-29 | Wilkinson | Mississippi | 28157 | 606 | 25 |
973854 | 973854 | 2021-01-28 | Wilkinson | Mississippi | 28157 | 603 | 25 |
970609 | 970609 | 2021-01-27 | Wilkinson | Mississippi | 28157 | 603 | 25 |
967364 | 967364 | 2021-01-26 | Wilkinson | Mississippi | 28157 | 601 | 25 |
964120 | 964120 | 2021-01-25 | Wilkinson | Mississippi | 28157 | 599 | 25 |
960875 | 960875 | 2021-01-24 | Wilkinson | Mississippi | 28157 | 598 | 25 |
957629 | 957629 | 2021-01-23 | Wilkinson | Mississippi | 28157 | 598 | 25 |
954384 | 954384 | 2021-01-22 | Wilkinson | Mississippi | 28157 | 596 | 25 |
951139 | 951139 | 2021-01-21 | Wilkinson | Mississippi | 28157 | 588 | 25 |
947893 | 947893 | 2021-01-20 | Wilkinson | Mississippi | 28157 | 588 | 25 |
944646 | 944646 | 2021-01-19 | Wilkinson | Mississippi | 28157 | 587 | 25 |
941401 | 941401 | 2021-01-18 | Wilkinson | Mississippi | 28157 | 584 | 25 |
938156 | 938156 | 2021-01-17 | Wilkinson | Mississippi | 28157 | 583 | 25 |
934911 | 934911 | 2021-01-16 | Wilkinson | Mississippi | 28157 | 583 | 25 |
931666 | 931666 | 2021-01-15 | Wilkinson | Mississippi | 28157 | 581 | 25 |
928421 | 928421 | 2021-01-14 | Wilkinson | Mississippi | 28157 | 574 | 24 |
925175 | 925175 | 2021-01-13 | Wilkinson | Mississippi | 28157 | 571 | 24 |
921930 | 921930 | 2021-01-12 | Wilkinson | Mississippi | 28157 | 563 | 24 |
918685 | 918685 | 2021-01-11 | Wilkinson | Mississippi | 28157 | 560 | 24 |
915440 | 915440 | 2021-01-10 | Wilkinson | Mississippi | 28157 | 560 | 24 |
912195 | 912195 | 2021-01-09 | Wilkinson | Mississippi | 28157 | 558 | 24 |
908950 | 908950 | 2021-01-08 | Wilkinson | Mississippi | 28157 | 556 | 24 |
905704 | 905704 | 2021-01-07 | Wilkinson | Mississippi | 28157 | 552 | 24 |
902459 | 902459 | 2021-01-06 | Wilkinson | Mississippi | 28157 | 542 | 24 |
899214 | 899214 | 2021-01-05 | Wilkinson | Mississippi | 28157 | 541 | 24 |
895969 | 895969 | 2021-01-04 | Wilkinson | Mississippi | 28157 | 538 | 24 |
892722 | 892722 | 2021-01-03 | Wilkinson | Mississippi | 28157 | 536 | 24 |
889476 | 889476 | 2021-01-02 | Wilkinson | Mississippi | 28157 | 535 | 23 |
886230 | 886230 | 2021-01-01 | Wilkinson | Mississippi | 28157 | 533 | 23 |
882985 | 882985 | 2020-12-31 | Wilkinson | Mississippi | 28157 | 532 | 23 |
879740 | 879740 | 2020-12-30 | Wilkinson | Mississippi | 28157 | 527 | 23 |
876495 | 876495 | 2020-12-29 | Wilkinson | Mississippi | 28157 | 523 | 23 |
873250 | 873250 | 2020-12-28 | Wilkinson | Mississippi | 28157 | 516 | 23 |
870005 | 870005 | 2020-12-27 | Wilkinson | Mississippi | 28157 | 512 | 23 |
866760 | 866760 | 2020-12-26 | Wilkinson | Mississippi | 28157 | 511 | 22 |
863515 | 863515 | 2020-12-25 | Wilkinson | Mississippi | 28157 | 511 | 22 |
860270 | 860270 | 2020-12-24 | Wilkinson | Mississippi | 28157 | 511 | 22 |
857025 | 857025 | 2020-12-23 | Wilkinson | Mississippi | 28157 | 507 | 22 |
853780 | 853780 | 2020-12-22 | Wilkinson | Mississippi | 28157 | 502 | 22 |
850535 | 850535 | 2020-12-21 | Wilkinson | Mississippi | 28157 | 499 | 22 |
847290 | 847290 | 2020-12-20 | Wilkinson | Mississippi | 28157 | 498 | 22 |
844044 | 844044 | 2020-12-19 | Wilkinson | Mississippi | 28157 | 496 | 22 |
840799 | 840799 | 2020-12-18 | Wilkinson | Mississippi | 28157 | 494 | 22 |
837554 | 837554 | 2020-12-17 | Wilkinson | Mississippi | 28157 | 489 | 22 |
834308 | 834308 | 2020-12-16 | Wilkinson | Mississippi | 28157 | 487 | 22 |
831061 | 831061 | 2020-12-15 | Wilkinson | Mississippi | 28157 | 486 | 22 |
827815 | 827815 | 2020-12-14 | Wilkinson | Mississippi | 28157 | 482 | 22 |
824568 | 824568 | 2020-12-13 | Wilkinson | Mississippi | 28157 | 480 | 22 |
821322 | 821322 | 2020-12-12 | Wilkinson | Mississippi | 28157 | 478 | 22 |
818076 | 818076 | 2020-12-11 | Wilkinson | Mississippi | 28157 | 474 | 22 |
814830 | 814830 | 2020-12-10 | Wilkinson | Mississippi | 28157 | 467 | 22 |
811585 | 811585 | 2020-12-09 | Wilkinson | Mississippi | 28157 | 461 | 22 |
808340 | 808340 | 2020-12-08 | Wilkinson | Mississippi | 28157 | 455 | 22 |
805095 | 805095 | 2020-12-07 | Wilkinson | Mississippi | 28157 | 450 | 22 |
801850 | 801850 | 2020-12-06 | Wilkinson | Mississippi | 28157 | 441 | 22 |
798605 | 798605 | 2020-12-05 | Wilkinson | Mississippi | 28157 | 434 | 22 |
795360 | 795360 | 2020-12-04 | Wilkinson | Mississippi | 28157 | 425 | 22 |
792115 | 792115 | 2020-12-03 | Wilkinson | Mississippi | 28157 | 413 | 22 |
788870 | 788870 | 2020-12-02 | Wilkinson | Mississippi | 28157 | 407 | 22 |
785625 | 785625 | 2020-12-01 | Wilkinson | Mississippi | 28157 | 405 | 22 |
782381 | 782381 | 2020-11-30 | Wilkinson | Mississippi | 28157 | 404 | 22 |
779135 | 779135 | 2020-11-29 | Wilkinson | Mississippi | 28157 | 401 | 22 |
775890 | 775890 | 2020-11-28 | Wilkinson | Mississippi | 28157 | 398 | 22 |
772645 | 772645 | 2020-11-27 | Wilkinson | Mississippi | 28157 | 394 | 22 |
769400 | 769400 | 2020-11-26 | Wilkinson | Mississippi | 28157 | 387 | 22 |
766154 | 766154 | 2020-11-25 | Wilkinson | Mississippi | 28157 | 387 | 22 |
762909 | 762909 | 2020-11-24 | Wilkinson | Mississippi | 28157 | 386 | 22 |
759664 | 759664 | 2020-11-23 | Wilkinson | Mississippi | 28157 | 384 | 22 |
756417 | 756417 | 2020-11-22 | Wilkinson | Mississippi | 28157 | 384 | 22 |
753171 | 753171 | 2020-11-21 | Wilkinson | Mississippi | 28157 | 383 | 22 |
749925 | 749925 | 2020-11-20 | Wilkinson | Mississippi | 28157 | 368 | 22 |
746679 | 746679 | 2020-11-19 | Wilkinson | Mississippi | 28157 | 365 | 22 |
743432 | 743432 | 2020-11-18 | Wilkinson | Mississippi | 28157 | 364 | 22 |
740185 | 740185 | 2020-11-17 | Wilkinson | Mississippi | 28157 | 363 | 22 |
736941 | 736941 | 2020-11-16 | Wilkinson | Mississippi | 28157 | 360 | 22 |
733695 | 733695 | 2020-11-15 | Wilkinson | Mississippi | 28157 | 360 | 22 |
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);