ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Greene" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921872 | 921872 | 2021-01-12 | Greene | Mississippi | 28041 | 1071 | 29 |
918627 | 918627 | 2021-01-11 | Greene | Mississippi | 28041 | 1059 | 28 |
915382 | 915382 | 2021-01-10 | Greene | Mississippi | 28041 | 1051 | 27 |
912137 | 912137 | 2021-01-09 | Greene | Mississippi | 28041 | 1045 | 27 |
908892 | 908892 | 2021-01-08 | Greene | Mississippi | 28041 | 1031 | 27 |
905646 | 905646 | 2021-01-07 | Greene | Mississippi | 28041 | 1023 | 27 |
902401 | 902401 | 2021-01-06 | Greene | Mississippi | 28041 | 1019 | 27 |
899156 | 899156 | 2021-01-05 | Greene | Mississippi | 28041 | 1009 | 27 |
895911 | 895911 | 2021-01-04 | Greene | Mississippi | 28041 | 1005 | 26 |
892664 | 892664 | 2021-01-03 | Greene | Mississippi | 28041 | 1001 | 25 |
889418 | 889418 | 2021-01-02 | Greene | Mississippi | 28041 | 997 | 25 |
886172 | 886172 | 2021-01-01 | Greene | Mississippi | 28041 | 996 | 25 |
882927 | 882927 | 2020-12-31 | Greene | Mississippi | 28041 | 988 | 25 |
879682 | 879682 | 2020-12-30 | Greene | Mississippi | 28041 | 980 | 25 |
876437 | 876437 | 2020-12-29 | Greene | Mississippi | 28041 | 968 | 25 |
873192 | 873192 | 2020-12-28 | Greene | Mississippi | 28041 | 965 | 25 |
869947 | 869947 | 2020-12-27 | Greene | Mississippi | 28041 | 957 | 25 |
866702 | 866702 | 2020-12-26 | Greene | Mississippi | 28041 | 955 | 25 |
863457 | 863457 | 2020-12-25 | Greene | Mississippi | 28041 | 954 | 25 |
860212 | 860212 | 2020-12-24 | Greene | Mississippi | 28041 | 952 | 25 |
856967 | 856967 | 2020-12-23 | Greene | Mississippi | 28041 | 949 | 25 |
853722 | 853722 | 2020-12-22 | Greene | Mississippi | 28041 | 942 | 25 |
850477 | 850477 | 2020-12-21 | Greene | Mississippi | 28041 | 937 | 25 |
847232 | 847232 | 2020-12-20 | Greene | Mississippi | 28041 | 923 | 25 |
843986 | 843986 | 2020-12-19 | Greene | Mississippi | 28041 | 910 | 25 |
840741 | 840741 | 2020-12-18 | Greene | Mississippi | 28041 | 904 | 25 |
837496 | 837496 | 2020-12-17 | Greene | Mississippi | 28041 | 894 | 25 |
834250 | 834250 | 2020-12-16 | Greene | Mississippi | 28041 | 890 | 25 |
831003 | 831003 | 2020-12-15 | Greene | Mississippi | 28041 | 888 | 25 |
827757 | 827757 | 2020-12-14 | Greene | Mississippi | 28041 | 869 | 25 |
824510 | 824510 | 2020-12-13 | Greene | Mississippi | 28041 | 862 | 25 |
821264 | 821264 | 2020-12-12 | Greene | Mississippi | 28041 | 838 | 24 |
818018 | 818018 | 2020-12-11 | Greene | Mississippi | 28041 | 824 | 24 |
814772 | 814772 | 2020-12-10 | Greene | Mississippi | 28041 | 817 | 24 |
811527 | 811527 | 2020-12-09 | Greene | Mississippi | 28041 | 809 | 23 |
808282 | 808282 | 2020-12-08 | Greene | Mississippi | 28041 | 717 | 23 |
805037 | 805037 | 2020-12-07 | Greene | Mississippi | 28041 | 680 | 23 |
801792 | 801792 | 2020-12-06 | Greene | Mississippi | 28041 | 670 | 23 |
798547 | 798547 | 2020-12-05 | Greene | Mississippi | 28041 | 666 | 23 |
795302 | 795302 | 2020-12-04 | Greene | Mississippi | 28041 | 660 | 23 |
792057 | 792057 | 2020-12-03 | Greene | Mississippi | 28041 | 630 | 22 |
788812 | 788812 | 2020-12-02 | Greene | Mississippi | 28041 | 624 | 22 |
785567 | 785567 | 2020-12-01 | Greene | Mississippi | 28041 | 615 | 22 |
782323 | 782323 | 2020-11-30 | Greene | Mississippi | 28041 | 612 | 22 |
779077 | 779077 | 2020-11-29 | Greene | Mississippi | 28041 | 608 | 22 |
775832 | 775832 | 2020-11-28 | Greene | Mississippi | 28041 | 603 | 22 |
772587 | 772587 | 2020-11-27 | Greene | Mississippi | 28041 | 600 | 22 |
769342 | 769342 | 2020-11-26 | Greene | Mississippi | 28041 | 597 | 22 |
766096 | 766096 | 2020-11-25 | Greene | Mississippi | 28041 | 584 | 22 |
762851 | 762851 | 2020-11-24 | Greene | Mississippi | 28041 | 584 | 22 |
759606 | 759606 | 2020-11-23 | Greene | Mississippi | 28041 | 584 | 22 |
756359 | 756359 | 2020-11-22 | Greene | Mississippi | 28041 | 582 | 22 |
753113 | 753113 | 2020-11-21 | Greene | Mississippi | 28041 | 581 | 22 |
749867 | 749867 | 2020-11-20 | Greene | Mississippi | 28041 | 573 | 22 |
746621 | 746621 | 2020-11-19 | Greene | Mississippi | 28041 | 567 | 22 |
743374 | 743374 | 2020-11-18 | Greene | Mississippi | 28041 | 564 | 20 |
740127 | 740127 | 2020-11-17 | Greene | Mississippi | 28041 | 560 | 20 |
736883 | 736883 | 2020-11-16 | Greene | Mississippi | 28041 | 559 | 19 |
733637 | 733637 | 2020-11-15 | Greene | Mississippi | 28041 | 557 | 19 |
730392 | 730392 | 2020-11-14 | Greene | Mississippi | 28041 | 554 | 19 |
727149 | 727149 | 2020-11-13 | Greene | Mississippi | 28041 | 543 | 19 |
723906 | 723906 | 2020-11-12 | Greene | Mississippi | 28041 | 534 | 19 |
720663 | 720663 | 2020-11-11 | Greene | Mississippi | 28041 | 526 | 19 |
717420 | 717420 | 2020-11-10 | Greene | Mississippi | 28041 | 520 | 19 |
714176 | 714176 | 2020-11-09 | Greene | Mississippi | 28041 | 511 | 19 |
710932 | 710932 | 2020-11-08 | Greene | Mississippi | 28041 | 511 | 19 |
707688 | 707688 | 2020-11-07 | Greene | Mississippi | 28041 | 511 | 19 |
704445 | 704445 | 2020-11-06 | Greene | Mississippi | 28041 | 507 | 18 |
701203 | 701203 | 2020-11-05 | Greene | Mississippi | 28041 | 503 | 18 |
697959 | 697959 | 2020-11-04 | Greene | Mississippi | 28041 | 494 | 18 |
694716 | 694716 | 2020-11-03 | Greene | Mississippi | 28041 | 491 | 18 |
691474 | 691474 | 2020-11-02 | Greene | Mississippi | 28041 | 489 | 18 |
688229 | 688229 | 2020-11-01 | Greene | Mississippi | 28041 | 488 | 18 |
684985 | 684985 | 2020-10-31 | Greene | Mississippi | 28041 | 487 | 18 |
681742 | 681742 | 2020-10-30 | Greene | Mississippi | 28041 | 482 | 18 |
678498 | 678498 | 2020-10-29 | Greene | Mississippi | 28041 | 482 | 18 |
675256 | 675256 | 2020-10-28 | Greene | Mississippi | 28041 | 481 | 18 |
672013 | 672013 | 2020-10-27 | Greene | Mississippi | 28041 | 479 | 18 |
668771 | 668771 | 2020-10-26 | Greene | Mississippi | 28041 | 478 | 18 |
665527 | 665527 | 2020-10-25 | Greene | Mississippi | 28041 | 478 | 18 |
662282 | 662282 | 2020-10-24 | Greene | Mississippi | 28041 | 478 | 18 |
659038 | 659038 | 2020-10-23 | Greene | Mississippi | 28041 | 473 | 18 |
655793 | 655793 | 2020-10-22 | Greene | Mississippi | 28041 | 469 | 18 |
652548 | 652548 | 2020-10-21 | Greene | Mississippi | 28041 | 459 | 18 |
649303 | 649303 | 2020-10-20 | Greene | Mississippi | 28041 | 455 | 18 |
646059 | 646059 | 2020-10-19 | Greene | Mississippi | 28041 | 453 | 17 |
642812 | 642812 | 2020-10-18 | Greene | Mississippi | 28041 | 447 | 17 |
639565 | 639565 | 2020-10-17 | Greene | Mississippi | 28041 | 447 | 17 |
636319 | 636319 | 2020-10-16 | Greene | Mississippi | 28041 | 444 | 17 |
633073 | 633073 | 2020-10-15 | Greene | Mississippi | 28041 | 443 | 17 |
629828 | 629828 | 2020-10-14 | Greene | Mississippi | 28041 | 439 | 17 |
626584 | 626584 | 2020-10-13 | Greene | Mississippi | 28041 | 428 | 17 |
623342 | 623342 | 2020-10-12 | Greene | Mississippi | 28041 | 426 | 17 |
620099 | 620099 | 2020-10-11 | Greene | Mississippi | 28041 | 426 | 17 |
616857 | 616857 | 2020-10-10 | Greene | Mississippi | 28041 | 426 | 17 |
613616 | 613616 | 2020-10-09 | Greene | Mississippi | 28041 | 424 | 17 |
610374 | 610374 | 2020-10-08 | Greene | Mississippi | 28041 | 423 | 17 |
607132 | 607132 | 2020-10-07 | Greene | Mississippi | 28041 | 417 | 17 |
603889 | 603889 | 2020-10-06 | Greene | Mississippi | 28041 | 414 | 17 |
600647 | 600647 | 2020-10-05 | Greene | Mississippi | 28041 | 405 | 17 |
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);