ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Coahoma", fips = 28027 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054934 | 1054934 | 2021-02-22 | Coahoma | Mississippi | 28027 | 2722 | 65 |
1051687 | 1051687 | 2021-02-21 | Coahoma | Mississippi | 28027 | 2722 | 65 |
1048440 | 1048440 | 2021-02-20 | Coahoma | Mississippi | 28027 | 2722 | 65 |
1045194 | 1045194 | 2021-02-19 | Coahoma | Mississippi | 28027 | 2718 | 65 |
1041949 | 1041949 | 2021-02-18 | Coahoma | Mississippi | 28027 | 2714 | 65 |
1038704 | 1038704 | 2021-02-17 | Coahoma | Mississippi | 28027 | 2712 | 65 |
1035459 | 1035459 | 2021-02-16 | Coahoma | Mississippi | 28027 | 2708 | 65 |
1032214 | 1032214 | 2021-02-15 | Coahoma | Mississippi | 28027 | 2707 | 65 |
1028967 | 1028967 | 2021-02-14 | Coahoma | Mississippi | 28027 | 2700 | 65 |
1025721 | 1025721 | 2021-02-13 | Coahoma | Mississippi | 28027 | 2695 | 65 |
1022476 | 1022476 | 2021-02-12 | Coahoma | Mississippi | 28027 | 2682 | 65 |
1019231 | 1019231 | 2021-02-11 | Coahoma | Mississippi | 28027 | 2663 | 61 |
1015986 | 1015986 | 2021-02-10 | Coahoma | Mississippi | 28027 | 2657 | 61 |
1012741 | 1012741 | 2021-02-09 | Coahoma | Mississippi | 28027 | 2654 | 61 |
1009496 | 1009496 | 2021-02-08 | Coahoma | Mississippi | 28027 | 2650 | 59 |
1006249 | 1006249 | 2021-02-07 | Coahoma | Mississippi | 28027 | 2642 | 59 |
1003003 | 1003003 | 2021-02-06 | Coahoma | Mississippi | 28027 | 2633 | 59 |
999758 | 999758 | 2021-02-05 | Coahoma | Mississippi | 28027 | 2625 | 58 |
996512 | 996512 | 2021-02-04 | Coahoma | Mississippi | 28027 | 2614 | 58 |
993266 | 993266 | 2021-02-03 | Coahoma | Mississippi | 28027 | 2600 | 58 |
990020 | 990020 | 2021-02-02 | Coahoma | Mississippi | 28027 | 2593 | 58 |
986773 | 986773 | 2021-02-01 | Coahoma | Mississippi | 28027 | 2593 | 57 |
983526 | 983526 | 2021-01-31 | Coahoma | Mississippi | 28027 | 2590 | 57 |
980280 | 980280 | 2021-01-30 | Coahoma | Mississippi | 28027 | 2581 | 57 |
977034 | 977034 | 2021-01-29 | Coahoma | Mississippi | 28027 | 2574 | 56 |
973789 | 973789 | 2021-01-28 | Coahoma | Mississippi | 28027 | 2552 | 56 |
970544 | 970544 | 2021-01-27 | Coahoma | Mississippi | 28027 | 2536 | 56 |
967299 | 967299 | 2021-01-26 | Coahoma | Mississippi | 28027 | 2524 | 55 |
964055 | 964055 | 2021-01-25 | Coahoma | Mississippi | 28027 | 2515 | 55 |
960810 | 960810 | 2021-01-24 | Coahoma | Mississippi | 28027 | 2497 | 55 |
957564 | 957564 | 2021-01-23 | Coahoma | Mississippi | 28027 | 2480 | 54 |
954319 | 954319 | 2021-01-22 | Coahoma | Mississippi | 28027 | 2459 | 54 |
951074 | 951074 | 2021-01-21 | Coahoma | Mississippi | 28027 | 2436 | 54 |
947828 | 947828 | 2021-01-20 | Coahoma | Mississippi | 28027 | 2422 | 54 |
944581 | 944581 | 2021-01-19 | Coahoma | Mississippi | 28027 | 2410 | 54 |
941336 | 941336 | 2021-01-18 | Coahoma | Mississippi | 28027 | 2337 | 54 |
938091 | 938091 | 2021-01-17 | Coahoma | Mississippi | 28027 | 2300 | 54 |
934846 | 934846 | 2021-01-16 | Coahoma | Mississippi | 28027 | 2285 | 54 |
931601 | 931601 | 2021-01-15 | Coahoma | Mississippi | 28027 | 2231 | 54 |
928356 | 928356 | 2021-01-14 | Coahoma | Mississippi | 28027 | 2190 | 54 |
925110 | 925110 | 2021-01-13 | Coahoma | Mississippi | 28027 | 2185 | 54 |
921865 | 921865 | 2021-01-12 | Coahoma | Mississippi | 28027 | 2169 | 54 |
918620 | 918620 | 2021-01-11 | Coahoma | Mississippi | 28027 | 2146 | 53 |
915375 | 915375 | 2021-01-10 | Coahoma | Mississippi | 28027 | 2133 | 53 |
912130 | 912130 | 2021-01-09 | Coahoma | Mississippi | 28027 | 2119 | 53 |
908885 | 908885 | 2021-01-08 | Coahoma | Mississippi | 28027 | 2092 | 53 |
905639 | 905639 | 2021-01-07 | Coahoma | Mississippi | 28027 | 2076 | 53 |
902394 | 902394 | 2021-01-06 | Coahoma | Mississippi | 28027 | 2044 | 52 |
899149 | 899149 | 2021-01-05 | Coahoma | Mississippi | 28027 | 2026 | 52 |
895904 | 895904 | 2021-01-04 | Coahoma | Mississippi | 28027 | 2014 | 52 |
892657 | 892657 | 2021-01-03 | Coahoma | Mississippi | 28027 | 2002 | 52 |
889411 | 889411 | 2021-01-02 | Coahoma | Mississippi | 28027 | 1991 | 52 |
886165 | 886165 | 2021-01-01 | Coahoma | Mississippi | 28027 | 1971 | 52 |
882920 | 882920 | 2020-12-31 | Coahoma | Mississippi | 28027 | 1955 | 52 |
879675 | 879675 | 2020-12-30 | Coahoma | Mississippi | 28027 | 1941 | 52 |
876430 | 876430 | 2020-12-29 | Coahoma | Mississippi | 28027 | 1927 | 52 |
873185 | 873185 | 2020-12-28 | Coahoma | Mississippi | 28027 | 1924 | 52 |
869940 | 869940 | 2020-12-27 | Coahoma | Mississippi | 28027 | 1901 | 51 |
866695 | 866695 | 2020-12-26 | Coahoma | Mississippi | 28027 | 1897 | 51 |
863450 | 863450 | 2020-12-25 | Coahoma | Mississippi | 28027 | 1892 | 51 |
860205 | 860205 | 2020-12-24 | Coahoma | Mississippi | 28027 | 1884 | 51 |
856960 | 856960 | 2020-12-23 | Coahoma | Mississippi | 28027 | 1865 | 51 |
853715 | 853715 | 2020-12-22 | Coahoma | Mississippi | 28027 | 1846 | 51 |
850470 | 850470 | 2020-12-21 | Coahoma | Mississippi | 28027 | 1835 | 48 |
847225 | 847225 | 2020-12-20 | Coahoma | Mississippi | 28027 | 1824 | 48 |
843979 | 843979 | 2020-12-19 | Coahoma | Mississippi | 28027 | 1804 | 48 |
840734 | 840734 | 2020-12-18 | Coahoma | Mississippi | 28027 | 1795 | 48 |
837489 | 837489 | 2020-12-17 | Coahoma | Mississippi | 28027 | 1780 | 47 |
834243 | 834243 | 2020-12-16 | Coahoma | Mississippi | 28027 | 1769 | 47 |
830996 | 830996 | 2020-12-15 | Coahoma | Mississippi | 28027 | 1754 | 47 |
827750 | 827750 | 2020-12-14 | Coahoma | Mississippi | 28027 | 1742 | 47 |
824503 | 824503 | 2020-12-13 | Coahoma | Mississippi | 28027 | 1727 | 47 |
821257 | 821257 | 2020-12-12 | Coahoma | Mississippi | 28027 | 1715 | 47 |
818011 | 818011 | 2020-12-11 | Coahoma | Mississippi | 28027 | 1702 | 47 |
814765 | 814765 | 2020-12-10 | Coahoma | Mississippi | 28027 | 1689 | 46 |
811520 | 811520 | 2020-12-09 | Coahoma | Mississippi | 28027 | 1672 | 46 |
808275 | 808275 | 2020-12-08 | Coahoma | Mississippi | 28027 | 1644 | 46 |
805030 | 805030 | 2020-12-07 | Coahoma | Mississippi | 28027 | 1635 | 46 |
801785 | 801785 | 2020-12-06 | Coahoma | Mississippi | 28027 | 1618 | 46 |
798540 | 798540 | 2020-12-05 | Coahoma | Mississippi | 28027 | 1610 | 46 |
795295 | 795295 | 2020-12-04 | Coahoma | Mississippi | 28027 | 1600 | 44 |
792050 | 792050 | 2020-12-03 | Coahoma | Mississippi | 28027 | 1578 | 44 |
788805 | 788805 | 2020-12-02 | Coahoma | Mississippi | 28027 | 1559 | 43 |
785560 | 785560 | 2020-12-01 | Coahoma | Mississippi | 28027 | 1527 | 43 |
782316 | 782316 | 2020-11-30 | Coahoma | Mississippi | 28027 | 1519 | 43 |
779070 | 779070 | 2020-11-29 | Coahoma | Mississippi | 28027 | 1510 | 43 |
775825 | 775825 | 2020-11-28 | Coahoma | Mississippi | 28027 | 1505 | 43 |
772580 | 772580 | 2020-11-27 | Coahoma | Mississippi | 28027 | 1501 | 43 |
769335 | 769335 | 2020-11-26 | Coahoma | Mississippi | 28027 | 1495 | 43 |
766089 | 766089 | 2020-11-25 | Coahoma | Mississippi | 28027 | 1487 | 43 |
762844 | 762844 | 2020-11-24 | Coahoma | Mississippi | 28027 | 1474 | 43 |
759599 | 759599 | 2020-11-23 | Coahoma | Mississippi | 28027 | 1473 | 42 |
756352 | 756352 | 2020-11-22 | Coahoma | Mississippi | 28027 | 1467 | 42 |
753106 | 753106 | 2020-11-21 | Coahoma | Mississippi | 28027 | 1460 | 40 |
749860 | 749860 | 2020-11-20 | Coahoma | Mississippi | 28027 | 1442 | 40 |
746614 | 746614 | 2020-11-19 | Coahoma | Mississippi | 28027 | 1429 | 40 |
743367 | 743367 | 2020-11-18 | Coahoma | Mississippi | 28027 | 1421 | 40 |
740120 | 740120 | 2020-11-17 | Coahoma | Mississippi | 28027 | 1402 | 40 |
736876 | 736876 | 2020-11-16 | Coahoma | Mississippi | 28027 | 1383 | 40 |
733630 | 733630 | 2020-11-15 | Coahoma | Mississippi | 28027 | 1377 | 40 |
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);