ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 28047 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387370 | 387370 | 2020-07-31 | Harrison | Mississippi | 28047 | 2048 | 31 |
384152 | 384152 | 2020-07-30 | Harrison | Mississippi | 28047 | 1982 | 29 |
380935 | 380935 | 2020-07-29 | Harrison | Mississippi | 28047 | 1944 | 27 |
377718 | 377718 | 2020-07-28 | Harrison | Mississippi | 28047 | 1868 | 27 |
374503 | 374503 | 2020-07-27 | Harrison | Mississippi | 28047 | 1824 | 26 |
371291 | 371291 | 2020-07-26 | Harrison | Mississippi | 28047 | 1810 | 26 |
368081 | 368081 | 2020-07-25 | Harrison | Mississippi | 28047 | 1774 | 25 |
364873 | 364873 | 2020-07-24 | Harrison | Mississippi | 28047 | 1694 | 22 |
361666 | 361666 | 2020-07-23 | Harrison | Mississippi | 28047 | 1628 | 21 |
358461 | 358461 | 2020-07-22 | Harrison | Mississippi | 28047 | 1573 | 21 |
355258 | 355258 | 2020-07-21 | Harrison | Mississippi | 28047 | 1521 | 20 |
352056 | 352056 | 2020-07-20 | Harrison | Mississippi | 28047 | 1456 | 18 |
348856 | 348856 | 2020-07-19 | Harrison | Mississippi | 28047 | 1387 | 18 |
345655 | 345655 | 2020-07-18 | Harrison | Mississippi | 28047 | 1356 | 18 |
342455 | 342455 | 2020-07-17 | Harrison | Mississippi | 28047 | 1370 | 18 |
339259 | 339259 | 2020-07-16 | Harrison | Mississippi | 28047 | 1305 | 17 |
336063 | 336063 | 2020-07-15 | Harrison | Mississippi | 28047 | 1260 | 17 |
332870 | 332870 | 2020-07-14 | Harrison | Mississippi | 28047 | 1231 | 16 |
329683 | 329683 | 2020-07-13 | Harrison | Mississippi | 28047 | 1183 | 16 |
326497 | 326497 | 2020-07-12 | Harrison | Mississippi | 28047 | 1177 | 16 |
323314 | 323314 | 2020-07-11 | Harrison | Mississippi | 28047 | 1136 | 16 |
320135 | 320135 | 2020-07-10 | Harrison | Mississippi | 28047 | 1096 | 15 |
316960 | 316960 | 2020-07-09 | Harrison | Mississippi | 28047 | 1040 | 14 |
313786 | 313786 | 2020-07-08 | Harrison | Mississippi | 28047 | 1003 | 12 |
310616 | 310616 | 2020-07-07 | Harrison | Mississippi | 28047 | 969 | 11 |
307448 | 307448 | 2020-07-06 | Harrison | Mississippi | 28047 | 933 | 11 |
304281 | 304281 | 2020-07-05 | Harrison | Mississippi | 28047 | 912 | 11 |
301117 | 301117 | 2020-07-04 | Harrison | Mississippi | 28047 | 886 | 10 |
297954 | 297954 | 2020-07-03 | Harrison | Mississippi | 28047 | 842 | 10 |
294796 | 294796 | 2020-07-02 | Harrison | Mississippi | 28047 | 794 | 10 |
291642 | 291642 | 2020-07-01 | Harrison | Mississippi | 28047 | 744 | 8 |
288491 | 288491 | 2020-06-30 | Harrison | Mississippi | 28047 | 719 | 8 |
285341 | 285341 | 2020-06-29 | Harrison | Mississippi | 28047 | 688 | 7 |
282196 | 282196 | 2020-06-28 | Harrison | Mississippi | 28047 | 642 | 7 |
279048 | 279048 | 2020-06-27 | Harrison | Mississippi | 28047 | 634 | 7 |
275900 | 275900 | 2020-06-26 | Harrison | Mississippi | 28047 | 607 | 7 |
272757 | 272757 | 2020-06-25 | Harrison | Mississippi | 28047 | 562 | 7 |
269620 | 269620 | 2020-06-24 | Harrison | Mississippi | 28047 | 514 | 7 |
266487 | 266487 | 2020-06-23 | Harrison | Mississippi | 28047 | 499 | 7 |
263361 | 263361 | 2020-06-22 | Harrison | Mississippi | 28047 | 464 | 7 |
260232 | 260232 | 2020-06-21 | Harrison | Mississippi | 28047 | 393 | 7 |
257106 | 257106 | 2020-06-20 | Harrison | Mississippi | 28047 | 393 | 7 |
253986 | 253986 | 2020-06-19 | Harrison | Mississippi | 28047 | 393 | 7 |
250871 | 250871 | 2020-06-18 | Harrison | Mississippi | 28047 | 393 | 7 |
247759 | 247759 | 2020-06-17 | Harrison | Mississippi | 28047 | 393 | 7 |
244646 | 244646 | 2020-06-16 | Harrison | Mississippi | 28047 | 377 | 7 |
241535 | 241535 | 2020-06-15 | Harrison | Mississippi | 28047 | 367 | 7 |
238426 | 238426 | 2020-06-14 | Harrison | Mississippi | 28047 | 344 | 7 |
235319 | 235319 | 2020-06-13 | Harrison | Mississippi | 28047 | 335 | 7 |
232213 | 232213 | 2020-06-12 | Harrison | Mississippi | 28047 | 319 | 7 |
229109 | 229109 | 2020-06-11 | Harrison | Mississippi | 28047 | 311 | 7 |
226007 | 226007 | 2020-06-10 | Harrison | Mississippi | 28047 | 311 | 7 |
222909 | 222909 | 2020-06-09 | Harrison | Mississippi | 28047 | 299 | 7 |
219814 | 219814 | 2020-06-08 | Harrison | Mississippi | 28047 | 288 | 7 |
216722 | 216722 | 2020-06-07 | Harrison | Mississippi | 28047 | 281 | 7 |
213634 | 213634 | 2020-06-06 | Harrison | Mississippi | 28047 | 274 | 7 |
210550 | 210550 | 2020-06-05 | Harrison | Mississippi | 28047 | 268 | 7 |
207469 | 207469 | 2020-06-04 | Harrison | Mississippi | 28047 | 269 | 7 |
204388 | 204388 | 2020-06-03 | Harrison | Mississippi | 28047 | 265 | 7 |
201311 | 201311 | 2020-06-02 | Harrison | Mississippi | 28047 | 263 | 7 |
198238 | 198238 | 2020-06-01 | Harrison | Mississippi | 28047 | 261 | 7 |
195167 | 195167 | 2020-05-31 | Harrison | Mississippi | 28047 | 258 | 7 |
192099 | 192099 | 2020-05-30 | Harrison | Mississippi | 28047 | 257 | 7 |
189035 | 189035 | 2020-05-29 | Harrison | Mississippi | 28047 | 251 | 7 |
185977 | 185977 | 2020-05-28 | Harrison | Mississippi | 28047 | 247 | 7 |
182921 | 182921 | 2020-05-27 | Harrison | Mississippi | 28047 | 245 | 7 |
179875 | 179875 | 2020-05-26 | Harrison | Mississippi | 28047 | 237 | 6 |
176831 | 176831 | 2020-05-25 | Harrison | Mississippi | 28047 | 237 | 6 |
173788 | 173788 | 2020-05-24 | Harrison | Mississippi | 28047 | 234 | 6 |
170746 | 170746 | 2020-05-23 | Harrison | Mississippi | 28047 | 231 | 6 |
167708 | 167708 | 2020-05-22 | Harrison | Mississippi | 28047 | 230 | 6 |
164672 | 164672 | 2020-05-21 | Harrison | Mississippi | 28047 | 224 | 6 |
161643 | 161643 | 2020-05-20 | Harrison | Mississippi | 28047 | 220 | 6 |
158617 | 158617 | 2020-05-19 | Harrison | Mississippi | 28047 | 218 | 6 |
155599 | 155599 | 2020-05-18 | Harrison | Mississippi | 28047 | 216 | 6 |
152585 | 152585 | 2020-05-17 | Harrison | Mississippi | 28047 | 215 | 6 |
149574 | 149574 | 2020-05-16 | Harrison | Mississippi | 28047 | 215 | 6 |
146569 | 146569 | 2020-05-15 | Harrison | Mississippi | 28047 | 214 | 6 |
143569 | 143569 | 2020-05-14 | Harrison | Mississippi | 28047 | 223 | 6 |
140574 | 140574 | 2020-05-13 | Harrison | Mississippi | 28047 | 210 | 6 |
137580 | 137580 | 2020-05-12 | Harrison | Mississippi | 28047 | 201 | 6 |
134590 | 134590 | 2020-05-11 | Harrison | Mississippi | 28047 | 198 | 6 |
131599 | 131599 | 2020-05-10 | Harrison | Mississippi | 28047 | 198 | 6 |
128609 | 128609 | 2020-05-09 | Harrison | Mississippi | 28047 | 198 | 6 |
125622 | 125622 | 2020-05-08 | Harrison | Mississippi | 28047 | 193 | 6 |
122640 | 122640 | 2020-05-07 | Harrison | Mississippi | 28047 | 188 | 6 |
119666 | 119666 | 2020-05-06 | Harrison | Mississippi | 28047 | 187 | 6 |
116706 | 116706 | 2020-05-05 | Harrison | Mississippi | 28047 | 186 | 6 |
113824 | 113824 | 2020-05-04 | Harrison | Mississippi | 28047 | 184 | 6 |
110945 | 110945 | 2020-05-03 | Harrison | Mississippi | 28047 | 181 | 6 |
108074 | 108074 | 2020-05-02 | Harrison | Mississippi | 28047 | 181 | 6 |
105209 | 105209 | 2020-05-01 | Harrison | Mississippi | 28047 | 177 | 6 |
102348 | 102348 | 2020-04-30 | Harrison | Mississippi | 28047 | 174 | 6 |
99496 | 99496 | 2020-04-29 | Harrison | Mississippi | 28047 | 171 | 6 |
96650 | 96650 | 2020-04-28 | Harrison | Mississippi | 28047 | 166 | 6 |
93814 | 93814 | 2020-04-27 | Harrison | Mississippi | 28047 | 159 | 6 |
90993 | 90993 | 2020-04-26 | Harrison | Mississippi | 28047 | 158 | 6 |
88177 | 88177 | 2020-04-25 | Harrison | Mississippi | 28047 | 158 | 6 |
85367 | 85367 | 2020-04-24 | Harrison | Mississippi | 28047 | 157 | 6 |
82563 | 82563 | 2020-04-23 | Harrison | Mississippi | 28047 | 152 | 6 |
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);