ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where "date" is on date 2020-12-01 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
785547 | 785547 | 2020-12-01 | Adams | Mississippi | 28001 | 1447 | 52 |
785548 | 785548 | 2020-12-01 | Alcorn | Mississippi | 28003 | 1556 | 28 |
785549 | 785549 | 2020-12-01 | Amite | Mississippi | 28005 | 566 | 15 |
785550 | 785550 | 2020-12-01 | Attala | Mississippi | 28007 | 1193 | 34 |
785551 | 785551 | 2020-12-01 | Benton | Mississippi | 28009 | 500 | 18 |
785552 | 785552 | 2020-12-01 | Bolivar | Mississippi | 28011 | 2443 | 84 |
785553 | 785553 | 2020-12-01 | Calhoun | Mississippi | 28013 | 787 | 13 |
785554 | 785554 | 2020-12-01 | Carroll | Mississippi | 28015 | 741 | 15 |
785555 | 785555 | 2020-12-01 | Chickasaw | Mississippi | 28017 | 1094 | 32 |
785556 | 785556 | 2020-12-01 | Choctaw | Mississippi | 28019 | 361 | 7 |
785557 | 785557 | 2020-12-01 | Claiborne | Mississippi | 28021 | 589 | 16 |
785558 | 785558 | 2020-12-01 | Clarke | Mississippi | 28023 | 936 | 53 |
785559 | 785559 | 2020-12-01 | Clay | Mississippi | 28025 | 947 | 27 |
785560 | 785560 | 2020-12-01 | Coahoma | Mississippi | 28027 | 1527 | 43 |
785561 | 785561 | 2020-12-01 | Copiah | Mississippi | 28029 | 1679 | 40 |
785562 | 785562 | 2020-12-01 | Covington | Mississippi | 28031 | 1286 | 39 |
785563 | 785563 | 2020-12-01 | DeSoto | Mississippi | 28033 | 10409 | 104 |
785564 | 785564 | 2020-12-01 | Forrest | Mississippi | 28035 | 3897 | 86 |
785565 | 785565 | 2020-12-01 | Franklin | Mississippi | 28037 | 355 | 5 |
785566 | 785566 | 2020-12-01 | George | Mississippi | 28039 | 1283 | 25 |
785567 | 785567 | 2020-12-01 | Greene | Mississippi | 28041 | 615 | 22 |
785568 | 785568 | 2020-12-01 | Grenada | Mississippi | 28043 | 1433 | 45 |
785569 | 785569 | 2020-12-01 | Hancock | Mississippi | 28045 | 1243 | 41 |
785570 | 785570 | 2020-12-01 | Harrison | Mississippi | 28047 | 7313 | 112 |
785571 | 785571 | 2020-12-01 | Hinds | Mississippi | 28049 | 10279 | 202 |
785572 | 785572 | 2020-12-01 | Holmes | Mississippi | 28051 | 1334 | 61 |
785573 | 785573 | 2020-12-01 | Humphreys | Mississippi | 28053 | 547 | 19 |
785574 | 785574 | 2020-12-01 | Issaquena | Mississippi | 28055 | 120 | 4 |
785575 | 785575 | 2020-12-01 | Itawamba | Mississippi | 28057 | 1576 | 35 |
785576 | 785576 | 2020-12-01 | Jackson | Mississippi | 28059 | 6566 | 128 |
785577 | 785577 | 2020-12-01 | Jasper | Mississippi | 28061 | 852 | 23 |
785578 | 785578 | 2020-12-01 | Jefferson | Mississippi | 28063 | 371 | 12 |
785579 | 785579 | 2020-12-01 | Jefferson Davis | Mississippi | 28065 | 590 | 17 |
785580 | 785580 | 2020-12-01 | Jones | Mississippi | 28067 | 3690 | 88 |
785581 | 785581 | 2020-12-01 | Kemper | Mississippi | 28069 | 450 | 18 |
785582 | 785582 | 2020-12-01 | Lafayette | Mississippi | 28071 | 3382 | 53 |
785583 | 785583 | 2020-12-01 | Lamar | Mississippi | 28073 | 2978 | 50 |
785584 | 785584 | 2020-12-01 | Lauderdale | Mississippi | 28075 | 3594 | 147 |
785585 | 785585 | 2020-12-01 | Lawrence | Mississippi | 28077 | 738 | 14 |
785586 | 785586 | 2020-12-01 | Leake | Mississippi | 28079 | 1397 | 44 |
785587 | 785587 | 2020-12-01 | Lee | Mississippi | 28081 | 5294 | 96 |
785588 | 785588 | 2020-12-01 | Leflore | Mississippi | 28083 | 2085 | 91 |
785589 | 785589 | 2020-12-01 | Lincoln | Mississippi | 28085 | 1973 | 66 |
785590 | 785590 | 2020-12-01 | Lowndes | Mississippi | 28087 | 2470 | 64 |
785591 | 785591 | 2020-12-01 | Madison | Mississippi | 28089 | 5014 | 107 |
785592 | 785592 | 2020-12-01 | Marion | Mississippi | 28091 | 1194 | 46 |
785593 | 785593 | 2020-12-01 | Marshall | Mississippi | 28093 | 2228 | 51 |
785594 | 785594 | 2020-12-01 | Monroe | Mississippi | 28095 | 2067 | 78 |
785595 | 785595 | 2020-12-01 | Montgomery | Mississippi | 28097 | 769 | 26 |
785596 | 785596 | 2020-12-01 | Neshoba | Mississippi | 28099 | 2249 | 121 |
785597 | 785597 | 2020-12-01 | Newton | Mississippi | 28101 | 1082 | 29 |
785598 | 785598 | 2020-12-01 | Noxubee | Mississippi | 28103 | 727 | 17 |
785599 | 785599 | 2020-12-01 | Oktibbeha | Mississippi | 28105 | 2523 | 62 |
785600 | 785600 | 2020-12-01 | Panola | Mississippi | 28107 | 2326 | 53 |
785601 | 785601 | 2020-12-01 | Pearl River | Mississippi | 28109 | 1553 | 68 |
785602 | 785602 | 2020-12-01 | Perry | Mississippi | 28111 | 683 | 26 |
785603 | 785603 | 2020-12-01 | Pike | Mississippi | 28113 | 1653 | 59 |
785604 | 785604 | 2020-12-01 | Pontotoc | Mississippi | 28115 | 2042 | 31 |
785605 | 785605 | 2020-12-01 | Prentiss | Mississippi | 28117 | 1513 | 31 |
785606 | 785606 | 2020-12-01 | Quitman | Mississippi | 28119 | 500 | 7 |
785607 | 785607 | 2020-12-01 | Rankin | Mississippi | 28121 | 5887 | 106 |
785608 | 785608 | 2020-12-01 | Scott | Mississippi | 28123 | 1594 | 30 |
785609 | 785609 | 2020-12-01 | Sharkey | Mississippi | 28125 | 324 | 17 |
785610 | 785610 | 2020-12-01 | Simpson | Mississippi | 28127 | 1526 | 53 |
785611 | 785611 | 2020-12-01 | Smith | Mississippi | 28129 | 732 | 16 |
785612 | 785612 | 2020-12-01 | Stone | Mississippi | 28131 | 806 | 15 |
785613 | 785613 | 2020-12-01 | Sunflower | Mississippi | 28133 | 1926 | 55 |
785614 | 785614 | 2020-12-01 | Tallahatchie | Mississippi | 28135 | 981 | 27 |
785615 | 785615 | 2020-12-01 | Tate | Mississippi | 28137 | 1777 | 51 |
785616 | 785616 | 2020-12-01 | Tippah | Mississippi | 28139 | 1284 | 30 |
785617 | 785617 | 2020-12-01 | Tishomingo | Mississippi | 28141 | 1124 | 43 |
785618 | 785618 | 2020-12-01 | Tunica | Mississippi | 28143 | 626 | 19 |
785619 | 785619 | 2020-12-01 | Union | Mississippi | 28145 | 1719 | 26 |
785620 | 785620 | 2020-12-01 | Walthall | Mississippi | 28147 | 776 | 29 |
785621 | 785621 | 2020-12-01 | Warren | Mississippi | 28149 | 1802 | 58 |
785622 | 785622 | 2020-12-01 | Washington | Mississippi | 28151 | 3246 | 108 |
785623 | 785623 | 2020-12-01 | Wayne | Mississippi | 28153 | 1213 | 23 |
785624 | 785624 | 2020-12-01 | Webster | Mississippi | 28155 | 467 | 14 |
785625 | 785625 | 2020-12-01 | Wilkinson | Mississippi | 28157 | 405 | 22 |
785626 | 785626 | 2020-12-01 | Winston | Mississippi | 28159 | 1255 | 26 |
785627 | 785627 | 2020-12-01 | Yalobusha | Mississippi | 28161 | 731 | 28 |
785628 | 785628 | 2020-12-01 | Yazoo | Mississippi | 28163 | 1601 | 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);