ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28043 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064678 | 1064678 | 2021-02-25 | Grenada | Mississippi | 28043 | 2458 | 76 |
1061434 | 1061434 | 2021-02-24 | Grenada | Mississippi | 28043 | 2446 | 76 |
1058188 | 1058188 | 2021-02-23 | Grenada | Mississippi | 28043 | 2445 | 76 |
1054942 | 1054942 | 2021-02-22 | Grenada | Mississippi | 28043 | 2443 | 75 |
1051695 | 1051695 | 2021-02-21 | Grenada | Mississippi | 28043 | 2440 | 75 |
1048448 | 1048448 | 2021-02-20 | Grenada | Mississippi | 28043 | 2439 | 75 |
1045202 | 1045202 | 2021-02-19 | Grenada | Mississippi | 28043 | 2438 | 75 |
1041957 | 1041957 | 2021-02-18 | Grenada | Mississippi | 28043 | 2437 | 75 |
1038712 | 1038712 | 2021-02-17 | Grenada | Mississippi | 28043 | 2437 | 75 |
1035467 | 1035467 | 2021-02-16 | Grenada | Mississippi | 28043 | 2431 | 75 |
1032222 | 1032222 | 2021-02-15 | Grenada | Mississippi | 28043 | 2422 | 74 |
1028975 | 1028975 | 2021-02-14 | Grenada | Mississippi | 28043 | 2419 | 74 |
1025729 | 1025729 | 2021-02-13 | Grenada | Mississippi | 28043 | 2411 | 74 |
1022484 | 1022484 | 2021-02-12 | Grenada | Mississippi | 28043 | 2396 | 74 |
1019239 | 1019239 | 2021-02-11 | Grenada | Mississippi | 28043 | 2363 | 74 |
1015994 | 1015994 | 2021-02-10 | Grenada | Mississippi | 28043 | 2362 | 74 |
1012749 | 1012749 | 2021-02-09 | Grenada | Mississippi | 28043 | 2357 | 74 |
1009504 | 1009504 | 2021-02-08 | Grenada | Mississippi | 28043 | 2352 | 74 |
1006257 | 1006257 | 2021-02-07 | Grenada | Mississippi | 28043 | 2342 | 74 |
1003011 | 1003011 | 2021-02-06 | Grenada | Mississippi | 28043 | 2334 | 74 |
999766 | 999766 | 2021-02-05 | Grenada | Mississippi | 28043 | 2327 | 74 |
996520 | 996520 | 2021-02-04 | Grenada | Mississippi | 28043 | 2323 | 74 |
993274 | 993274 | 2021-02-03 | Grenada | Mississippi | 28043 | 2315 | 74 |
990028 | 990028 | 2021-02-02 | Grenada | Mississippi | 28043 | 2306 | 74 |
986781 | 986781 | 2021-02-01 | Grenada | Mississippi | 28043 | 2305 | 74 |
983534 | 983534 | 2021-01-31 | Grenada | Mississippi | 28043 | 2298 | 74 |
980288 | 980288 | 2021-01-30 | Grenada | Mississippi | 28043 | 2287 | 74 |
977042 | 977042 | 2021-01-29 | Grenada | Mississippi | 28043 | 2280 | 74 |
973797 | 973797 | 2021-01-28 | Grenada | Mississippi | 28043 | 2266 | 74 |
970552 | 970552 | 2021-01-27 | Grenada | Mississippi | 28043 | 2258 | 74 |
967307 | 967307 | 2021-01-26 | Grenada | Mississippi | 28043 | 2246 | 73 |
964063 | 964063 | 2021-01-25 | Grenada | Mississippi | 28043 | 2242 | 72 |
960818 | 960818 | 2021-01-24 | Grenada | Mississippi | 28043 | 2239 | 72 |
957572 | 957572 | 2021-01-23 | Grenada | Mississippi | 28043 | 2232 | 72 |
954327 | 954327 | 2021-01-22 | Grenada | Mississippi | 28043 | 2224 | 71 |
951082 | 951082 | 2021-01-21 | Grenada | Mississippi | 28043 | 2211 | 71 |
947836 | 947836 | 2021-01-20 | Grenada | Mississippi | 28043 | 2206 | 71 |
944589 | 944589 | 2021-01-19 | Grenada | Mississippi | 28043 | 2194 | 71 |
941344 | 941344 | 2021-01-18 | Grenada | Mississippi | 28043 | 2184 | 70 |
938099 | 938099 | 2021-01-17 | Grenada | Mississippi | 28043 | 2177 | 70 |
934854 | 934854 | 2021-01-16 | Grenada | Mississippi | 28043 | 2170 | 70 |
931609 | 931609 | 2021-01-15 | Grenada | Mississippi | 28043 | 2157 | 70 |
928364 | 928364 | 2021-01-14 | Grenada | Mississippi | 28043 | 2139 | 70 |
925118 | 925118 | 2021-01-13 | Grenada | Mississippi | 28043 | 2123 | 69 |
921873 | 921873 | 2021-01-12 | Grenada | Mississippi | 28043 | 2116 | 69 |
918628 | 918628 | 2021-01-11 | Grenada | Mississippi | 28043 | 2107 | 67 |
915383 | 915383 | 2021-01-10 | Grenada | Mississippi | 28043 | 2101 | 67 |
912138 | 912138 | 2021-01-09 | Grenada | Mississippi | 28043 | 2082 | 67 |
908893 | 908893 | 2021-01-08 | Grenada | Mississippi | 28043 | 2066 | 65 |
905647 | 905647 | 2021-01-07 | Grenada | Mississippi | 28043 | 2056 | 65 |
902402 | 902402 | 2021-01-06 | Grenada | Mississippi | 28043 | 2041 | 65 |
899157 | 899157 | 2021-01-05 | Grenada | Mississippi | 28043 | 2023 | 65 |
895912 | 895912 | 2021-01-04 | Grenada | Mississippi | 28043 | 2010 | 64 |
892665 | 892665 | 2021-01-03 | Grenada | Mississippi | 28043 | 2005 | 63 |
889419 | 889419 | 2021-01-02 | Grenada | Mississippi | 28043 | 1988 | 63 |
886173 | 886173 | 2021-01-01 | Grenada | Mississippi | 28043 | 1978 | 62 |
882928 | 882928 | 2020-12-31 | Grenada | Mississippi | 28043 | 1962 | 62 |
879683 | 879683 | 2020-12-30 | Grenada | Mississippi | 28043 | 1949 | 62 |
876438 | 876438 | 2020-12-29 | Grenada | Mississippi | 28043 | 1941 | 62 |
873193 | 873193 | 2020-12-28 | Grenada | Mississippi | 28043 | 1926 | 61 |
869948 | 869948 | 2020-12-27 | Grenada | Mississippi | 28043 | 1921 | 61 |
866703 | 866703 | 2020-12-26 | Grenada | Mississippi | 28043 | 1910 | 60 |
863458 | 863458 | 2020-12-25 | Grenada | Mississippi | 28043 | 1910 | 60 |
860213 | 860213 | 2020-12-24 | Grenada | Mississippi | 28043 | 1900 | 60 |
856968 | 856968 | 2020-12-23 | Grenada | Mississippi | 28043 | 1883 | 59 |
853723 | 853723 | 2020-12-22 | Grenada | Mississippi | 28043 | 1873 | 58 |
850478 | 850478 | 2020-12-21 | Grenada | Mississippi | 28043 | 1853 | 54 |
847233 | 847233 | 2020-12-20 | Grenada | Mississippi | 28043 | 1840 | 54 |
843987 | 843987 | 2020-12-19 | Grenada | Mississippi | 28043 | 1824 | 54 |
840742 | 840742 | 2020-12-18 | Grenada | Mississippi | 28043 | 1807 | 53 |
837497 | 837497 | 2020-12-17 | Grenada | Mississippi | 28043 | 1779 | 53 |
834251 | 834251 | 2020-12-16 | Grenada | Mississippi | 28043 | 1748 | 51 |
831004 | 831004 | 2020-12-15 | Grenada | Mississippi | 28043 | 1729 | 51 |
827758 | 827758 | 2020-12-14 | Grenada | Mississippi | 28043 | 1702 | 51 |
824511 | 824511 | 2020-12-13 | Grenada | Mississippi | 28043 | 1675 | 51 |
821265 | 821265 | 2020-12-12 | Grenada | Mississippi | 28043 | 1651 | 50 |
818019 | 818019 | 2020-12-11 | Grenada | Mississippi | 28043 | 1607 | 49 |
814773 | 814773 | 2020-12-10 | Grenada | Mississippi | 28043 | 1587 | 49 |
811528 | 811528 | 2020-12-09 | Grenada | Mississippi | 28043 | 1558 | 49 |
808283 | 808283 | 2020-12-08 | Grenada | Mississippi | 28043 | 1542 | 48 |
805038 | 805038 | 2020-12-07 | Grenada | Mississippi | 28043 | 1532 | 45 |
801793 | 801793 | 2020-12-06 | Grenada | Mississippi | 28043 | 1521 | 45 |
798548 | 798548 | 2020-12-05 | Grenada | Mississippi | 28043 | 1507 | 45 |
795303 | 795303 | 2020-12-04 | Grenada | Mississippi | 28043 | 1495 | 45 |
792058 | 792058 | 2020-12-03 | Grenada | Mississippi | 28043 | 1471 | 45 |
788813 | 788813 | 2020-12-02 | Grenada | Mississippi | 28043 | 1454 | 45 |
785568 | 785568 | 2020-12-01 | Grenada | Mississippi | 28043 | 1433 | 45 |
782324 | 782324 | 2020-11-30 | Grenada | Mississippi | 28043 | 1428 | 45 |
779078 | 779078 | 2020-11-29 | Grenada | Mississippi | 28043 | 1414 | 45 |
775833 | 775833 | 2020-11-28 | Grenada | Mississippi | 28043 | 1409 | 45 |
772588 | 772588 | 2020-11-27 | Grenada | Mississippi | 28043 | 1406 | 45 |
769343 | 769343 | 2020-11-26 | Grenada | Mississippi | 28043 | 1388 | 45 |
766097 | 766097 | 2020-11-25 | Grenada | Mississippi | 28043 | 1377 | 45 |
762852 | 762852 | 2020-11-24 | Grenada | Mississippi | 28043 | 1369 | 45 |
759607 | 759607 | 2020-11-23 | Grenada | Mississippi | 28043 | 1363 | 44 |
756360 | 756360 | 2020-11-22 | Grenada | Mississippi | 28043 | 1358 | 44 |
753114 | 753114 | 2020-11-21 | Grenada | Mississippi | 28043 | 1354 | 44 |
749868 | 749868 | 2020-11-20 | Grenada | Mississippi | 28043 | 1340 | 44 |
746622 | 746622 | 2020-11-19 | Grenada | Mississippi | 28043 | 1327 | 44 |
743375 | 743375 | 2020-11-18 | Grenada | Mississippi | 28043 | 1321 | 44 |
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);