ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where deaths = 149 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501056 | 2501056 | 2022-05-13 | Simpson | Mississippi | 28127 | 7026 | 149 |
2497798 | 2497798 | 2022-05-12 | Simpson | Mississippi | 28127 | 7026 | 149 |
2494540 | 2494540 | 2022-05-11 | Simpson | Mississippi | 28127 | 7026 | 149 |
2491282 | 2491282 | 2022-05-10 | Simpson | Mississippi | 28127 | 7026 | 149 |
2488025 | 2488025 | 2022-05-09 | Simpson | Mississippi | 28127 | 7026 | 149 |
2484767 | 2484767 | 2022-05-08 | Simpson | Mississippi | 28127 | 7018 | 149 |
2481509 | 2481509 | 2022-05-07 | Simpson | Mississippi | 28127 | 7018 | 149 |
2478251 | 2478251 | 2022-05-06 | Simpson | Mississippi | 28127 | 7018 | 149 |
2474993 | 2474993 | 2022-05-05 | Simpson | Mississippi | 28127 | 7018 | 149 |
2471736 | 2471736 | 2022-05-04 | Simpson | Mississippi | 28127 | 7018 | 149 |
2468480 | 2468480 | 2022-05-03 | Simpson | Mississippi | 28127 | 7018 | 149 |
2465225 | 2465225 | 2022-05-02 | Simpson | Mississippi | 28127 | 7018 | 149 |
2282927 | 2282927 | 2022-03-07 | Alcorn | Mississippi | 28003 | 9889 | 149 |
2279674 | 2279674 | 2022-03-06 | Alcorn | Mississippi | 28003 | 9883 | 149 |
2276421 | 2276421 | 2022-03-05 | Alcorn | Mississippi | 28003 | 9883 | 149 |
2273168 | 2273168 | 2022-03-04 | Alcorn | Mississippi | 28003 | 9883 | 149 |
2269937 | 2269937 | 2022-03-03 | Hancock | Mississippi | 28045 | 12141 | 149 |
2266684 | 2266684 | 2022-03-02 | Hancock | Mississippi | 28045 | 12139 | 149 |
2175663 | 2175663 | 2022-02-02 | Oktibbeha | Mississippi | 28105 | 10048 | 149 |
2169146 | 2169146 | 2022-01-31 | Leflore | Mississippi | 28083 | 7032 | 149 |
2126839 | 2126839 | 2022-01-18 | Lafayette | Mississippi | 28071 | 11980 | 149 |
2123587 | 2123587 | 2022-01-17 | Lafayette | Mississippi | 28071 | 11520 | 149 |
2120335 | 2120335 | 2022-01-16 | Lafayette | Mississippi | 28071 | 11520 | 149 |
2117083 | 2117083 | 2022-01-15 | Lafayette | Mississippi | 28071 | 11520 | 149 |
2113832 | 2113832 | 2022-01-14 | Lafayette | Mississippi | 28071 | 11520 | 149 |
2110580 | 2110580 | 2022-01-13 | Lafayette | Mississippi | 28071 | 11309 | 149 |
2107340 | 2107340 | 2022-01-12 | Marshall | Mississippi | 28093 | 7907 | 149 |
2104089 | 2104089 | 2022-01-11 | Marshall | Mississippi | 28093 | 7842 | 149 |
2100838 | 2100838 | 2022-01-10 | Marshall | Mississippi | 28093 | 7785 | 149 |
2097587 | 2097587 | 2022-01-09 | Marshall | Mississippi | 28093 | 7600 | 149 |
2094335 | 2094335 | 2022-01-08 | Marshall | Mississippi | 28093 | 7600 | 149 |
2091083 | 2091083 | 2022-01-07 | Marshall | Mississippi | 28093 | 7600 | 149 |
2087832 | 2087832 | 2022-01-06 | Marshall | Mississippi | 28093 | 7555 | 149 |
1691398 | 1691398 | 2021-09-06 | Warren | Mississippi | 28149 | 6172 | 149 |
1551696 | 1551696 | 2021-07-25 | Pearl River | Mississippi | 28109 | 4915 | 149 |
1548449 | 1548449 | 2021-07-24 | Pearl River | Mississippi | 28109 | 4915 | 149 |
1545202 | 1545202 | 2021-07-23 | Pearl River | Mississippi | 28109 | 4915 | 149 |
1541954 | 1541954 | 2021-07-22 | Pearl River | Mississippi | 28109 | 4889 | 149 |
1538707 | 1538707 | 2021-07-21 | Pearl River | Mississippi | 28109 | 4871 | 149 |
1535460 | 1535460 | 2021-07-20 | Pearl River | Mississippi | 28109 | 4847 | 149 |
1532212 | 1532212 | 2021-07-19 | Pearl River | Mississippi | 28109 | 4833 | 149 |
1528965 | 1528965 | 2021-07-18 | Pearl River | Mississippi | 28109 | 4787 | 149 |
1525718 | 1525718 | 2021-07-17 | Pearl River | Mississippi | 28109 | 4787 | 149 |
1522471 | 1522471 | 2021-07-16 | Pearl River | Mississippi | 28109 | 4787 | 149 |
1421831 | 1421831 | 2021-06-15 | Lowndes | Mississippi | 28087 | 6498 | 149 |
1418586 | 1418586 | 2021-06-14 | Lowndes | Mississippi | 28087 | 6498 | 149 |
1415341 | 1415341 | 2021-06-13 | Lowndes | Mississippi | 28087 | 6488 | 149 |
1412095 | 1412095 | 2021-06-12 | Lowndes | Mississippi | 28087 | 6488 | 149 |
1408850 | 1408850 | 2021-06-11 | Lowndes | Mississippi | 28087 | 6488 | 149 |
1405605 | 1405605 | 2021-06-10 | Lowndes | Mississippi | 28087 | 6486 | 149 |
1402359 | 1402359 | 2021-06-09 | Lowndes | Mississippi | 28087 | 6475 | 149 |
1399114 | 1399114 | 2021-06-08 | Lowndes | Mississippi | 28087 | 6475 | 149 |
1395868 | 1395868 | 2021-06-07 | Lowndes | Mississippi | 28087 | 6472 | 149 |
1392622 | 1392622 | 2021-06-06 | Lowndes | Mississippi | 28087 | 6457 | 149 |
1389377 | 1389377 | 2021-06-05 | Lowndes | Mississippi | 28087 | 6457 | 149 |
1386132 | 1386132 | 2021-06-04 | Lowndes | Mississippi | 28087 | 6457 | 149 |
1382887 | 1382887 | 2021-06-03 | Lowndes | Mississippi | 28087 | 6455 | 149 |
1379641 | 1379641 | 2021-06-02 | Lowndes | Mississippi | 28087 | 6448 | 149 |
1376396 | 1376396 | 2021-06-01 | Lowndes | Mississippi | 28087 | 6447 | 149 |
1373150 | 1373150 | 2021-05-31 | Lowndes | Mississippi | 28087 | 6446 | 149 |
1278975 | 1278975 | 2021-05-02 | Forrest | Mississippi | 28035 | 7620 | 149 |
1275728 | 1275728 | 2021-05-01 | Forrest | Mississippi | 28035 | 7620 | 149 |
1272481 | 1272481 | 2021-04-30 | Forrest | Mississippi | 28035 | 7620 | 149 |
1269234 | 1269234 | 2021-04-29 | Forrest | Mississippi | 28035 | 7617 | 149 |
1265987 | 1265987 | 2021-04-28 | Forrest | Mississippi | 28035 | 7614 | 149 |
1262740 | 1262740 | 2021-04-27 | Forrest | Mississippi | 28035 | 7609 | 149 |
1259493 | 1259493 | 2021-04-26 | Forrest | Mississippi | 28035 | 7607 | 149 |
1256246 | 1256246 | 2021-04-25 | Forrest | Mississippi | 28035 | 7595 | 149 |
1252999 | 1252999 | 2021-04-24 | Forrest | Mississippi | 28035 | 7595 | 149 |
1249752 | 1249752 | 2021-04-23 | Forrest | Mississippi | 28035 | 7595 | 149 |
1246505 | 1246505 | 2021-04-22 | Forrest | Mississippi | 28035 | 7585 | 149 |
1243258 | 1243258 | 2021-04-21 | Forrest | Mississippi | 28035 | 7573 | 149 |
1240011 | 1240011 | 2021-04-20 | Forrest | Mississippi | 28035 | 7562 | 149 |
1236764 | 1236764 | 2021-04-19 | Forrest | Mississippi | 28035 | 7554 | 149 |
1233517 | 1233517 | 2021-04-18 | Forrest | Mississippi | 28035 | 7551 | 149 |
1230269 | 1230269 | 2021-04-17 | Forrest | Mississippi | 28035 | 7551 | 149 |
1106886 | 1106886 | 2021-03-10 | Jones | Mississippi | 28067 | 8066 | 149 |
1103640 | 1103640 | 2021-03-09 | Jones | Mississippi | 28067 | 8052 | 149 |
986800 | 986800 | 2021-02-01 | Lee | Mississippi | 28081 | 9289 | 149 |
983553 | 983553 | 2021-01-31 | Lee | Mississippi | 28081 | 9279 | 149 |
980307 | 980307 | 2021-01-30 | Lee | Mississippi | 28081 | 9264 | 149 |
977061 | 977061 | 2021-01-29 | Lee | Mississippi | 28081 | 9241 | 149 |
973816 | 973816 | 2021-01-28 | Lee | Mississippi | 28081 | 9202 | 149 |
970571 | 970571 | 2021-01-27 | Lee | Mississippi | 28081 | 9160 | 149 |
928392 | 928392 | 2021-01-14 | Neshoba | Mississippi | 28099 | 3310 | 149 |
925146 | 925146 | 2021-01-13 | Neshoba | Mississippi | 28099 | 3282 | 149 |
921901 | 921901 | 2021-01-12 | Neshoba | Mississippi | 28099 | 3250 | 149 |
908916 | 908916 | 2021-01-08 | Madison | Mississippi | 28089 | 7723 | 149 |
905642 | 905642 | 2021-01-07 | DeSoto | Mississippi | 28033 | 15775 | 149 |
853762 | 853762 | 2020-12-22 | Rankin | Mississippi | 28121 | 8020 | 149 |
795319 | 795319 | 2020-12-04 | Lauderdale | Mississippi | 28075 | 3754 | 149 |
529387 | 529387 | 2020-09-13 | Hinds | Mississippi | 28049 | 6816 | 149 |
526151 | 526151 | 2020-09-12 | Hinds | Mississippi | 28049 | 6804 | 149 |
522915 | 522915 | 2020-09-11 | Hinds | Mississippi | 28049 | 6781 | 149 |
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);