ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2022-01-19" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2130058 | 2130058 | 2022-01-19 | Adams | Mississippi | 28001 | 5798 | 125 |
2130059 | 2130059 | 2022-01-19 | Alcorn | Mississippi | 28003 | 7972 | 122 |
2130060 | 2130060 | 2022-01-19 | Amite | Mississippi | 28005 | 2673 | 59 |
2130061 | 2130061 | 2022-01-19 | Attala | Mississippi | 28007 | 4054 | 91 |
2130062 | 2130062 | 2022-01-19 | Benton | Mississippi | 28009 | 1925 | 42 |
2130063 | 2130063 | 2022-01-19 | Bolivar | Mississippi | 28011 | 7880 | 157 |
2130064 | 2130064 | 2022-01-19 | Calhoun | Mississippi | 28013 | 3845 | 52 |
2130065 | 2130065 | 2022-01-19 | Carroll | Mississippi | 28015 | 2242 | 42 |
2130066 | 2130066 | 2022-01-19 | Chickasaw | Mississippi | 28017 | 4533 | 79 |
2130067 | 2130067 | 2022-01-19 | Choctaw | Mississippi | 28019 | 1667 | 27 |
2130068 | 2130068 | 2022-01-19 | Claiborne | Mississippi | 28021 | 1871 | 42 |
2130069 | 2130069 | 2022-01-19 | Clarke | Mississippi | 28023 | 3564 | 96 |
2130070 | 2130070 | 2022-01-19 | Clay | Mississippi | 28025 | 4370 | 78 |
2130071 | 2130071 | 2022-01-19 | Coahoma | Mississippi | 28027 | 5575 | 116 |
2130072 | 2130072 | 2022-01-19 | Copiah | Mississippi | 28029 | 5964 | 96 |
2130073 | 2130073 | 2022-01-19 | Covington | Mississippi | 28031 | 6147 | 98 |
2130074 | 2130074 | 2022-01-19 | DeSoto | Mississippi | 28033 | 42900 | 473 |
2130075 | 2130075 | 2022-01-19 | Forrest | Mississippi | 28035 | 17773 | 268 |
2130076 | 2130076 | 2022-01-19 | Franklin | Mississippi | 28037 | 1606 | 34 |
2130077 | 2130077 | 2022-01-19 | George | Mississippi | 28039 | 6100 | 80 |
2130078 | 2130078 | 2022-01-19 | Greene | Mississippi | 28041 | 2613 | 50 |
2130079 | 2130079 | 2022-01-19 | Grenada | Mississippi | 28043 | 4735 | 113 |
2130080 | 2130080 | 2022-01-19 | Hancock | Mississippi | 28045 | 9815 | 141 |
2130081 | 2130081 | 2022-01-19 | Harrison | Mississippi | 28047 | 43432 | 576 |
2130082 | 2130082 | 2022-01-19 | Hinds | Mississippi | 28049 | 46338 | 679 |
2130083 | 2130083 | 2022-01-19 | Holmes | Mississippi | 28051 | 3791 | 94 |
2130084 | 2130084 | 2022-01-19 | Humphreys | Mississippi | 28053 | 1730 | 39 |
2130085 | 2130085 | 2022-01-19 | Issaquena | Mississippi | 28055 | 218 | 7 |
2130086 | 2130086 | 2022-01-19 | Itawamba | Mississippi | 28057 | 6063 | 115 |
2130087 | 2130087 | 2022-01-19 | Jackson | Mississippi | 28059 | 31446 | 398 |
2130088 | 2130088 | 2022-01-19 | Jasper | Mississippi | 28061 | 4080 | 66 |
2130089 | 2130089 | 2022-01-19 | Jefferson | Mississippi | 28063 | 1265 | 35 |
2130090 | 2130090 | 2022-01-19 | Jefferson Davis | Mississippi | 28065 | 2480 | 43 |
2130091 | 2130091 | 2022-01-19 | Jones | Mississippi | 28067 | 17499 | 251 |
2130092 | 2130092 | 2022-01-19 | Kemper | Mississippi | 28069 | 1823 | 42 |
2130093 | 2130093 | 2022-01-19 | Lafayette | Mississippi | 28071 | 12172 | 152 |
2130094 | 2130094 | 2022-01-19 | Lamar | Mississippi | 28073 | 14201 | 142 |
2130095 | 2130095 | 2022-01-19 | Lauderdale | Mississippi | 28075 | 15732 | 326 |
2130096 | 2130096 | 2022-01-19 | Lawrence | Mississippi | 28077 | 2928 | 44 |
2130097 | 2130097 | 2022-01-19 | Leake | Mississippi | 28079 | 5244 | 92 |
2130098 | 2130098 | 2022-01-19 | Lee | Mississippi | 28081 | 22721 | 255 |
2130099 | 2130099 | 2022-01-19 | Leflore | Mississippi | 28083 | 6700 | 145 |
2130100 | 2130100 | 2022-01-19 | Lincoln | Mississippi | 28085 | 6754 | 141 |
2130101 | 2130101 | 2022-01-19 | Lowndes | Mississippi | 28087 | 14509 | 203 |
2130102 | 2130102 | 2022-01-19 | Madison | Mississippi | 28089 | 20476 | 289 |
2130103 | 2130103 | 2022-01-19 | Marion | Mississippi | 28091 | 5709 | 122 |
2130104 | 2130104 | 2022-01-19 | Marshall | Mississippi | 28093 | 8419 | 150 |
2130105 | 2130105 | 2022-01-19 | Monroe | Mississippi | 28095 | 9108 | 186 |
2130106 | 2130106 | 2022-01-19 | Montgomery | Mississippi | 28097 | 2587 | 61 |
2130107 | 2130107 | 2022-01-19 | Neshoba | Mississippi | 28099 | 8575 | 211 |
2130108 | 2130108 | 2022-01-19 | Newton | Mississippi | 28101 | 4798 | 86 |
2130109 | 2130109 | 2022-01-19 | Noxubee | Mississippi | 28103 | 2355 | 46 |
2130110 | 2130110 | 2022-01-19 | Oktibbeha | Mississippi | 28105 | 8996 | 141 |
2130111 | 2130111 | 2022-01-19 | Panola | Mississippi | 28107 | 8968 | 141 |
2130112 | 2130112 | 2022-01-19 | Pearl River | Mississippi | 28109 | 12244 | 248 |
2130113 | 2130113 | 2022-01-19 | Perry | Mississippi | 28111 | 2547 | 57 |
2130114 | 2130114 | 2022-01-19 | Pike | Mississippi | 28113 | 7648 | 160 |
2130115 | 2130115 | 2022-01-19 | Pontotoc | Mississippi | 28115 | 8583 | 118 |
2130116 | 2130116 | 2022-01-19 | Prentiss | Mississippi | 28117 | 6653 | 89 |
2130117 | 2130117 | 2022-01-19 | Quitman | Mississippi | 28119 | 1389 | 28 |
2130118 | 2130118 | 2022-01-19 | Rankin | Mississippi | 28121 | 30112 | 419 |
2130119 | 2130119 | 2022-01-19 | Scott | Mississippi | 28123 | 5804 | 101 |
2130120 | 2130120 | 2022-01-19 | Sharkey | Mississippi | 28125 | 777 | 21 |
2130121 | 2130121 | 2022-01-19 | Simpson | Mississippi | 28127 | 5831 | 121 |
2130122 | 2130122 | 2022-01-19 | Smith | Mississippi | 28129 | 3357 | 57 |
2130123 | 2130123 | 2022-01-19 | Stone | Mississippi | 28131 | 4461 | 67 |
2130124 | 2130124 | 2022-01-19 | Sunflower | Mississippi | 28133 | 5236 | 111 |
2130125 | 2130125 | 2022-01-19 | Tallahatchie | Mississippi | 28135 | 2772 | 53 |
2130126 | 2130126 | 2022-01-19 | Tate | Mississippi | 28137 | 6047 | 125 |
2130127 | 2130127 | 2022-01-19 | Tippah | Mississippi | 28139 | 5991 | 89 |
2130128 | 2130128 | 2022-01-19 | Tishomingo | Mississippi | 28141 | 4889 | 99 |
2130129 | 2130129 | 2022-01-19 | Tunica | Mississippi | 28143 | 2241 | 41 |
2130130 | 2130130 | 2022-01-19 | Union | Mississippi | 28145 | 7985 | 101 |
2130131 | 2130131 | 2022-01-19 | Walthall | Mississippi | 28147 | 2889 | 70 |
2130132 | 2130132 | 2022-01-19 | Warren | Mississippi | 28149 | 8825 | 184 |
2130133 | 2130133 | 2022-01-19 | Washington | Mississippi | 28151 | 8959 | 171 |
2130134 | 2130134 | 2022-01-19 | Wayne | Mississippi | 28153 | 4904 | 73 |
2130135 | 2130135 | 2022-01-19 | Webster | Mississippi | 28155 | 2630 | 51 |
2130136 | 2130136 | 2022-01-19 | Wilkinson | Mississippi | 28157 | 1656 | 40 |
2130137 | 2130137 | 2022-01-19 | Winston | Mississippi | 28159 | 4148 | 95 |
2130138 | 2130138 | 2022-01-19 | Yalobusha | Mississippi | 28161 | 3330 | 48 |
2130139 | 2130139 | 2022-01-19 | Yazoo | Mississippi | 28163 | 6897 | 94 |
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);