ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28079 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064696 | 1064696 | 2021-02-25 | Leake | Mississippi | 28079 | 2517 | 70 |
1061452 | 1061452 | 2021-02-24 | Leake | Mississippi | 28079 | 2513 | 70 |
1058206 | 1058206 | 2021-02-23 | Leake | Mississippi | 28079 | 2508 | 70 |
1054960 | 1054960 | 2021-02-22 | Leake | Mississippi | 28079 | 2505 | 70 |
1051713 | 1051713 | 2021-02-21 | Leake | Mississippi | 28079 | 2505 | 70 |
1048466 | 1048466 | 2021-02-20 | Leake | Mississippi | 28079 | 2505 | 70 |
1045220 | 1045220 | 2021-02-19 | Leake | Mississippi | 28079 | 2505 | 69 |
1041975 | 1041975 | 2021-02-18 | Leake | Mississippi | 28079 | 2504 | 69 |
1038730 | 1038730 | 2021-02-17 | Leake | Mississippi | 28079 | 2504 | 69 |
1035485 | 1035485 | 2021-02-16 | Leake | Mississippi | 28079 | 2501 | 69 |
1032240 | 1032240 | 2021-02-15 | Leake | Mississippi | 28079 | 2496 | 69 |
1028993 | 1028993 | 2021-02-14 | Leake | Mississippi | 28079 | 2494 | 69 |
1025747 | 1025747 | 2021-02-13 | Leake | Mississippi | 28079 | 2485 | 69 |
1022502 | 1022502 | 2021-02-12 | Leake | Mississippi | 28079 | 2482 | 69 |
1019257 | 1019257 | 2021-02-11 | Leake | Mississippi | 28079 | 2481 | 69 |
1016012 | 1016012 | 2021-02-10 | Leake | Mississippi | 28079 | 2479 | 69 |
1012767 | 1012767 | 2021-02-09 | Leake | Mississippi | 28079 | 2476 | 69 |
1009522 | 1009522 | 2021-02-08 | Leake | Mississippi | 28079 | 2469 | 68 |
1006275 | 1006275 | 2021-02-07 | Leake | Mississippi | 28079 | 2469 | 68 |
1003029 | 1003029 | 2021-02-06 | Leake | Mississippi | 28079 | 2466 | 68 |
999784 | 999784 | 2021-02-05 | Leake | Mississippi | 28079 | 2460 | 68 |
996538 | 996538 | 2021-02-04 | Leake | Mississippi | 28079 | 2455 | 68 |
993292 | 993292 | 2021-02-03 | Leake | Mississippi | 28079 | 2448 | 68 |
990046 | 990046 | 2021-02-02 | Leake | Mississippi | 28079 | 2446 | 68 |
986799 | 986799 | 2021-02-01 | Leake | Mississippi | 28079 | 2439 | 68 |
983552 | 983552 | 2021-01-31 | Leake | Mississippi | 28079 | 2435 | 68 |
980306 | 980306 | 2021-01-30 | Leake | Mississippi | 28079 | 2424 | 68 |
977060 | 977060 | 2021-01-29 | Leake | Mississippi | 28079 | 2405 | 68 |
973815 | 973815 | 2021-01-28 | Leake | Mississippi | 28079 | 2395 | 67 |
970570 | 970570 | 2021-01-27 | Leake | Mississippi | 28079 | 2393 | 67 |
967325 | 967325 | 2021-01-26 | Leake | Mississippi | 28079 | 2389 | 67 |
964081 | 964081 | 2021-01-25 | Leake | Mississippi | 28079 | 2384 | 67 |
960836 | 960836 | 2021-01-24 | Leake | Mississippi | 28079 | 2381 | 67 |
957590 | 957590 | 2021-01-23 | Leake | Mississippi | 28079 | 2373 | 67 |
954345 | 954345 | 2021-01-22 | Leake | Mississippi | 28079 | 2361 | 67 |
951100 | 951100 | 2021-01-21 | Leake | Mississippi | 28079 | 2343 | 67 |
947854 | 947854 | 2021-01-20 | Leake | Mississippi | 28079 | 2329 | 66 |
944607 | 944607 | 2021-01-19 | Leake | Mississippi | 28079 | 2317 | 65 |
941362 | 941362 | 2021-01-18 | Leake | Mississippi | 28079 | 2311 | 64 |
938117 | 938117 | 2021-01-17 | Leake | Mississippi | 28079 | 2305 | 64 |
934872 | 934872 | 2021-01-16 | Leake | Mississippi | 28079 | 2295 | 64 |
931627 | 931627 | 2021-01-15 | Leake | Mississippi | 28079 | 2278 | 64 |
928382 | 928382 | 2021-01-14 | Leake | Mississippi | 28079 | 2267 | 64 |
925136 | 925136 | 2021-01-13 | Leake | Mississippi | 28079 | 2254 | 64 |
921891 | 921891 | 2021-01-12 | Leake | Mississippi | 28079 | 2239 | 64 |
918646 | 918646 | 2021-01-11 | Leake | Mississippi | 28079 | 2223 | 63 |
915401 | 915401 | 2021-01-10 | Leake | Mississippi | 28079 | 2215 | 62 |
912156 | 912156 | 2021-01-09 | Leake | Mississippi | 28079 | 2211 | 60 |
908911 | 908911 | 2021-01-08 | Leake | Mississippi | 28079 | 2196 | 60 |
905665 | 905665 | 2021-01-07 | Leake | Mississippi | 28079 | 2174 | 60 |
902420 | 902420 | 2021-01-06 | Leake | Mississippi | 28079 | 2145 | 60 |
899175 | 899175 | 2021-01-05 | Leake | Mississippi | 28079 | 2128 | 59 |
895930 | 895930 | 2021-01-04 | Leake | Mississippi | 28079 | 2122 | 58 |
892683 | 892683 | 2021-01-03 | Leake | Mississippi | 28079 | 2104 | 58 |
889437 | 889437 | 2021-01-02 | Leake | Mississippi | 28079 | 2081 | 57 |
886191 | 886191 | 2021-01-01 | Leake | Mississippi | 28079 | 2069 | 57 |
882946 | 882946 | 2020-12-31 | Leake | Mississippi | 28079 | 2049 | 51 |
879701 | 879701 | 2020-12-30 | Leake | Mississippi | 28079 | 2016 | 51 |
876456 | 876456 | 2020-12-29 | Leake | Mississippi | 28079 | 2004 | 50 |
873211 | 873211 | 2020-12-28 | Leake | Mississippi | 28079 | 1979 | 50 |
869966 | 869966 | 2020-12-27 | Leake | Mississippi | 28079 | 1952 | 49 |
866721 | 866721 | 2020-12-26 | Leake | Mississippi | 28079 | 1930 | 49 |
863476 | 863476 | 2020-12-25 | Leake | Mississippi | 28079 | 1910 | 49 |
860231 | 860231 | 2020-12-24 | Leake | Mississippi | 28079 | 1883 | 49 |
856986 | 856986 | 2020-12-23 | Leake | Mississippi | 28079 | 1846 | 49 |
853741 | 853741 | 2020-12-22 | Leake | Mississippi | 28079 | 1809 | 48 |
850496 | 850496 | 2020-12-21 | Leake | Mississippi | 28079 | 1785 | 46 |
847251 | 847251 | 2020-12-20 | Leake | Mississippi | 28079 | 1777 | 46 |
844005 | 844005 | 2020-12-19 | Leake | Mississippi | 28079 | 1750 | 45 |
840760 | 840760 | 2020-12-18 | Leake | Mississippi | 28079 | 1737 | 45 |
837515 | 837515 | 2020-12-17 | Leake | Mississippi | 28079 | 1698 | 45 |
834269 | 834269 | 2020-12-16 | Leake | Mississippi | 28079 | 1662 | 45 |
831022 | 831022 | 2020-12-15 | Leake | Mississippi | 28079 | 1647 | 45 |
827776 | 827776 | 2020-12-14 | Leake | Mississippi | 28079 | 1635 | 45 |
824529 | 824529 | 2020-12-13 | Leake | Mississippi | 28079 | 1627 | 45 |
821283 | 821283 | 2020-12-12 | Leake | Mississippi | 28079 | 1606 | 45 |
818037 | 818037 | 2020-12-11 | Leake | Mississippi | 28079 | 1575 | 45 |
814791 | 814791 | 2020-12-10 | Leake | Mississippi | 28079 | 1542 | 45 |
811546 | 811546 | 2020-12-09 | Leake | Mississippi | 28079 | 1521 | 45 |
808301 | 808301 | 2020-12-08 | Leake | Mississippi | 28079 | 1502 | 45 |
805056 | 805056 | 2020-12-07 | Leake | Mississippi | 28079 | 1497 | 45 |
801811 | 801811 | 2020-12-06 | Leake | Mississippi | 28079 | 1490 | 45 |
798566 | 798566 | 2020-12-05 | Leake | Mississippi | 28079 | 1481 | 44 |
795321 | 795321 | 2020-12-04 | Leake | Mississippi | 28079 | 1462 | 44 |
792076 | 792076 | 2020-12-03 | Leake | Mississippi | 28079 | 1433 | 44 |
788831 | 788831 | 2020-12-02 | Leake | Mississippi | 28079 | 1418 | 44 |
785586 | 785586 | 2020-12-01 | Leake | Mississippi | 28079 | 1397 | 44 |
782342 | 782342 | 2020-11-30 | Leake | Mississippi | 28079 | 1394 | 44 |
779096 | 779096 | 2020-11-29 | Leake | Mississippi | 28079 | 1383 | 44 |
775851 | 775851 | 2020-11-28 | Leake | Mississippi | 28079 | 1349 | 44 |
772606 | 772606 | 2020-11-27 | Leake | Mississippi | 28079 | 1335 | 43 |
769361 | 769361 | 2020-11-26 | Leake | Mississippi | 28079 | 1332 | 43 |
766115 | 766115 | 2020-11-25 | Leake | Mississippi | 28079 | 1319 | 43 |
762870 | 762870 | 2020-11-24 | Leake | Mississippi | 28079 | 1318 | 43 |
759625 | 759625 | 2020-11-23 | Leake | Mississippi | 28079 | 1316 | 43 |
756378 | 756378 | 2020-11-22 | Leake | Mississippi | 28079 | 1316 | 43 |
753132 | 753132 | 2020-11-21 | Leake | Mississippi | 28079 | 1312 | 43 |
749886 | 749886 | 2020-11-20 | Leake | Mississippi | 28079 | 1292 | 43 |
746640 | 746640 | 2020-11-19 | Leake | Mississippi | 28079 | 1286 | 43 |
743393 | 743393 | 2020-11-18 | Leake | Mississippi | 28079 | 1271 | 43 |
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);