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-09-22 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
558496 | 558496 | 2020-09-22 | Adams | Mississippi | 28001 | 922 | 36 |
558497 | 558497 | 2020-09-22 | Alcorn | Mississippi | 28003 | 776 | 11 |
558498 | 558498 | 2020-09-22 | Amite | Mississippi | 28005 | 314 | 10 |
558499 | 558499 | 2020-09-22 | Attala | Mississippi | 28007 | 643 | 25 |
558500 | 558500 | 2020-09-22 | Benton | Mississippi | 28009 | 223 | 2 |
558501 | 558501 | 2020-09-22 | Bolivar | Mississippi | 28011 | 1797 | 65 |
558502 | 558502 | 2020-09-22 | Calhoun | Mississippi | 28013 | 507 | 12 |
558503 | 558503 | 2020-09-22 | Carroll | Mississippi | 28015 | 314 | 12 |
558504 | 558504 | 2020-09-22 | Chickasaw | Mississippi | 28017 | 662 | 24 |
558505 | 558505 | 2020-09-22 | Choctaw | Mississippi | 28019 | 180 | 6 |
558506 | 558506 | 2020-09-22 | Claiborne | Mississippi | 28021 | 456 | 16 |
558507 | 558507 | 2020-09-22 | Clarke | Mississippi | 28023 | 563 | 42 |
558508 | 558508 | 2020-09-22 | Clay | Mississippi | 28025 | 582 | 17 |
558509 | 558509 | 2020-09-22 | Coahoma | Mississippi | 28027 | 1136 | 27 |
558510 | 558510 | 2020-09-22 | Copiah | Mississippi | 28029 | 1164 | 33 |
558511 | 558511 | 2020-09-22 | Covington | Mississippi | 28031 | 808 | 22 |
558512 | 558512 | 2020-09-22 | DeSoto | Mississippi | 28033 | 5448 | 59 |
558513 | 558513 | 2020-09-22 | Forrest | Mississippi | 28035 | 2409 | 71 |
558514 | 558514 | 2020-09-22 | Franklin | Mississippi | 28037 | 191 | 3 |
558515 | 558515 | 2020-09-22 | George | Mississippi | 28039 | 755 | 13 |
558516 | 558516 | 2020-09-22 | Greene | Mississippi | 28041 | 354 | 17 |
558517 | 558517 | 2020-09-22 | Grenada | Mississippi | 28043 | 1068 | 35 |
558518 | 558518 | 2020-09-22 | Hancock | Mississippi | 28045 | 569 | 21 |
558519 | 558519 | 2020-09-22 | Harrison | Mississippi | 28047 | 3780 | 73 |
558520 | 558520 | 2020-09-22 | Hinds | Mississippi | 28049 | 7017 | 157 |
558521 | 558521 | 2020-09-22 | Holmes | Mississippi | 28051 | 1094 | 58 |
558522 | 558522 | 2020-09-22 | Humphreys | Mississippi | 28053 | 374 | 15 |
558523 | 558523 | 2020-09-22 | Issaquena | Mississippi | 28055 | 103 | 3 |
558524 | 558524 | 2020-09-22 | Itawamba | Mississippi | 28057 | 780 | 21 |
558525 | 558525 | 2020-09-22 | Jackson | Mississippi | 28059 | 3418 | 69 |
558526 | 558526 | 2020-09-22 | Jasper | Mississippi | 28061 | 559 | 15 |
558527 | 558527 | 2020-09-22 | Jefferson | Mississippi | 28063 | 243 | 9 |
558528 | 558528 | 2020-09-22 | Jefferson Davis | Mississippi | 28065 | 329 | 11 |
558529 | 558529 | 2020-09-22 | Jones | Mississippi | 28067 | 2438 | 78 |
558530 | 558530 | 2020-09-22 | Kemper | Mississippi | 28069 | 286 | 15 |
558531 | 558531 | 2020-09-22 | Lafayette | Mississippi | 28071 | 2116 | 39 |
558532 | 558532 | 2020-09-22 | Lamar | Mississippi | 28073 | 1639 | 34 |
558533 | 558533 | 2020-09-22 | Lauderdale | Mississippi | 28075 | 2015 | 124 |
558534 | 558534 | 2020-09-22 | Lawrence | Mississippi | 28077 | 427 | 12 |
558535 | 558535 | 2020-09-22 | Leake | Mississippi | 28079 | 941 | 38 |
558536 | 558536 | 2020-09-22 | Lee | Mississippi | 28081 | 2633 | 68 |
558537 | 558537 | 2020-09-22 | Leflore | Mississippi | 28083 | 1377 | 81 |
558538 | 558538 | 2020-09-22 | Lincoln | Mississippi | 28085 | 1073 | 53 |
558539 | 558539 | 2020-09-22 | Lowndes | Mississippi | 28087 | 1412 | 57 |
558540 | 558540 | 2020-09-22 | Madison | Mississippi | 28089 | 3218 | 86 |
558541 | 558541 | 2020-09-22 | Marion | Mississippi | 28091 | 842 | 34 |
558542 | 558542 | 2020-09-22 | Marshall | Mississippi | 28093 | 1080 | 15 |
558543 | 558543 | 2020-09-22 | Monroe | Mississippi | 28095 | 1199 | 66 |
558544 | 558544 | 2020-09-22 | Montgomery | Mississippi | 28097 | 458 | 21 |
558545 | 558545 | 2020-09-22 | Neshoba | Mississippi | 28099 | 1548 | 104 |
558546 | 558546 | 2020-09-22 | Newton | Mississippi | 28101 | 761 | 23 |
558547 | 558547 | 2020-09-22 | Noxubee | Mississippi | 28103 | 545 | 15 |
558548 | 558548 | 2020-09-22 | Oktibbeha | Mississippi | 28105 | 1759 | 50 |
558549 | 558549 | 2020-09-22 | Panola | Mississippi | 28107 | 1449 | 27 |
558550 | 558550 | 2020-09-22 | Pearl River | Mississippi | 28109 | 869 | 52 |
558551 | 558551 | 2020-09-22 | Perry | Mississippi | 28111 | 413 | 18 |
558552 | 558552 | 2020-09-22 | Pike | Mississippi | 28113 | 1217 | 49 |
558553 | 558553 | 2020-09-22 | Pontotoc | Mississippi | 28115 | 1241 | 16 |
558554 | 558554 | 2020-09-22 | Prentiss | Mississippi | 28117 | 826 | 17 |
558555 | 558555 | 2020-09-22 | Quitman | Mississippi | 28119 | 375 | 5 |
558556 | 558556 | 2020-09-22 | Rankin | Mississippi | 28121 | 3202 | 76 |
558557 | 558557 | 2020-09-22 | Scott | Mississippi | 28123 | 1168 | 25 |
558558 | 558558 | 2020-09-22 | Sharkey | Mississippi | 28125 | 263 | 13 |
558559 | 558559 | 2020-09-22 | Simpson | Mississippi | 28127 | 1015 | 44 |
558560 | 558560 | 2020-09-22 | Smith | Mississippi | 28129 | 526 | 14 |
558561 | 558561 | 2020-09-22 | Stone | Mississippi | 28131 | 360 | 12 |
558562 | 558562 | 2020-09-22 | Sunflower | Mississippi | 28133 | 1429 | 45 |
558563 | 558563 | 2020-09-22 | Tallahatchie | Mississippi | 28135 | 762 | 21 |
558564 | 558564 | 2020-09-22 | Tate | Mississippi | 28137 | 958 | 37 |
558565 | 558565 | 2020-09-22 | Tippah | Mississippi | 28139 | 650 | 17 |
558566 | 558566 | 2020-09-22 | Tishomingo | Mississippi | 28141 | 665 | 37 |
558567 | 558567 | 2020-09-22 | Tunica | Mississippi | 28143 | 481 | 13 |
558568 | 558568 | 2020-09-22 | Union | Mississippi | 28145 | 983 | 24 |
558569 | 558569 | 2020-09-22 | Walthall | Mississippi | 28147 | 595 | 25 |
558570 | 558570 | 2020-09-22 | Warren | Mississippi | 28149 | 1382 | 50 |
558571 | 558571 | 2020-09-22 | Washington | Mississippi | 28151 | 2186 | 71 |
558572 | 558572 | 2020-09-22 | Wayne | Mississippi | 28153 | 877 | 21 |
558573 | 558573 | 2020-09-22 | Webster | Mississippi | 28155 | 332 | 13 |
558574 | 558574 | 2020-09-22 | Wilkinson | Mississippi | 28157 | 301 | 18 |
558575 | 558575 | 2020-09-22 | Winston | Mississippi | 28159 | 731 | 19 |
558576 | 558576 | 2020-09-22 | Yalobusha | Mississippi | 28161 | 419 | 14 |
558577 | 558577 | 2020-09-22 | Yazoo | Mississippi | 28163 | 1041 | 30 |
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);