ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Lincoln" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387389 | 387389 | 2020-07-31 | Lincoln | Mississippi | 28085 | 730 | 38 |
384171 | 384171 | 2020-07-30 | Lincoln | Mississippi | 28085 | 716 | 38 |
380954 | 380954 | 2020-07-29 | Lincoln | Mississippi | 28085 | 698 | 38 |
377737 | 377737 | 2020-07-28 | Lincoln | Mississippi | 28085 | 688 | 38 |
374522 | 374522 | 2020-07-27 | Lincoln | Mississippi | 28085 | 681 | 38 |
371310 | 371310 | 2020-07-26 | Lincoln | Mississippi | 28085 | 681 | 38 |
368100 | 368100 | 2020-07-25 | Lincoln | Mississippi | 28085 | 661 | 38 |
364892 | 364892 | 2020-07-24 | Lincoln | Mississippi | 28085 | 649 | 38 |
361685 | 361685 | 2020-07-23 | Lincoln | Mississippi | 28085 | 640 | 37 |
358480 | 358480 | 2020-07-22 | Lincoln | Mississippi | 28085 | 622 | 37 |
355277 | 355277 | 2020-07-21 | Lincoln | Mississippi | 28085 | 618 | 36 |
352075 | 352075 | 2020-07-20 | Lincoln | Mississippi | 28085 | 602 | 36 |
348875 | 348875 | 2020-07-19 | Lincoln | Mississippi | 28085 | 593 | 36 |
345674 | 345674 | 2020-07-18 | Lincoln | Mississippi | 28085 | 590 | 35 |
342474 | 342474 | 2020-07-17 | Lincoln | Mississippi | 28085 | 570 | 36 |
339278 | 339278 | 2020-07-16 | Lincoln | Mississippi | 28085 | 561 | 36 |
336082 | 336082 | 2020-07-15 | Lincoln | Mississippi | 28085 | 544 | 36 |
332889 | 332889 | 2020-07-14 | Lincoln | Mississippi | 28085 | 541 | 36 |
329702 | 329702 | 2020-07-13 | Lincoln | Mississippi | 28085 | 538 | 35 |
326516 | 326516 | 2020-07-12 | Lincoln | Mississippi | 28085 | 533 | 35 |
323333 | 323333 | 2020-07-11 | Lincoln | Mississippi | 28085 | 529 | 35 |
320154 | 320154 | 2020-07-10 | Lincoln | Mississippi | 28085 | 519 | 35 |
316979 | 316979 | 2020-07-09 | Lincoln | Mississippi | 28085 | 509 | 35 |
313805 | 313805 | 2020-07-08 | Lincoln | Mississippi | 28085 | 492 | 34 |
310635 | 310635 | 2020-07-07 | Lincoln | Mississippi | 28085 | 484 | 34 |
307467 | 307467 | 2020-07-06 | Lincoln | Mississippi | 28085 | 466 | 34 |
304300 | 304300 | 2020-07-05 | Lincoln | Mississippi | 28085 | 460 | 34 |
301136 | 301136 | 2020-07-04 | Lincoln | Mississippi | 28085 | 454 | 34 |
297973 | 297973 | 2020-07-03 | Lincoln | Mississippi | 28085 | 443 | 34 |
294815 | 294815 | 2020-07-02 | Lincoln | Mississippi | 28085 | 437 | 34 |
291661 | 291661 | 2020-07-01 | Lincoln | Mississippi | 28085 | 435 | 34 |
288510 | 288510 | 2020-06-30 | Lincoln | Mississippi | 28085 | 434 | 34 |
285360 | 285360 | 2020-06-29 | Lincoln | Mississippi | 28085 | 430 | 33 |
282215 | 282215 | 2020-06-28 | Lincoln | Mississippi | 28085 | 422 | 33 |
279067 | 279067 | 2020-06-27 | Lincoln | Mississippi | 28085 | 420 | 33 |
275919 | 275919 | 2020-06-26 | Lincoln | Mississippi | 28085 | 413 | 32 |
272776 | 272776 | 2020-06-25 | Lincoln | Mississippi | 28085 | 411 | 32 |
269638 | 269638 | 2020-06-24 | Lincoln | Mississippi | 28085 | 396 | 32 |
266505 | 266505 | 2020-06-23 | Lincoln | Mississippi | 28085 | 384 | 32 |
263379 | 263379 | 2020-06-22 | Lincoln | Mississippi | 28085 | 378 | 32 |
260250 | 260250 | 2020-06-21 | Lincoln | Mississippi | 28085 | 330 | 32 |
257124 | 257124 | 2020-06-20 | Lincoln | Mississippi | 28085 | 330 | 32 |
254004 | 254004 | 2020-06-19 | Lincoln | Mississippi | 28085 | 330 | 32 |
250889 | 250889 | 2020-06-18 | Lincoln | Mississippi | 28085 | 330 | 32 |
247777 | 247777 | 2020-06-17 | Lincoln | Mississippi | 28085 | 330 | 32 |
244664 | 244664 | 2020-06-16 | Lincoln | Mississippi | 28085 | 329 | 32 |
241553 | 241553 | 2020-06-15 | Lincoln | Mississippi | 28085 | 327 | 32 |
238444 | 238444 | 2020-06-14 | Lincoln | Mississippi | 28085 | 324 | 32 |
235337 | 235337 | 2020-06-13 | Lincoln | Mississippi | 28085 | 320 | 32 |
232231 | 232231 | 2020-06-12 | Lincoln | Mississippi | 28085 | 316 | 32 |
229127 | 229127 | 2020-06-11 | Lincoln | Mississippi | 28085 | 314 | 32 |
226025 | 226025 | 2020-06-10 | Lincoln | Mississippi | 28085 | 314 | 32 |
222927 | 222927 | 2020-06-09 | Lincoln | Mississippi | 28085 | 308 | 32 |
219832 | 219832 | 2020-06-08 | Lincoln | Mississippi | 28085 | 300 | 32 |
216740 | 216740 | 2020-06-07 | Lincoln | Mississippi | 28085 | 289 | 32 |
213652 | 213652 | 2020-06-06 | Lincoln | Mississippi | 28085 | 286 | 32 |
210568 | 210568 | 2020-06-05 | Lincoln | Mississippi | 28085 | 281 | 31 |
207487 | 207487 | 2020-06-04 | Lincoln | Mississippi | 28085 | 280 | 31 |
204406 | 204406 | 2020-06-03 | Lincoln | Mississippi | 28085 | 278 | 29 |
201329 | 201329 | 2020-06-02 | Lincoln | Mississippi | 28085 | 270 | 29 |
198256 | 198256 | 2020-06-01 | Lincoln | Mississippi | 28085 | 266 | 29 |
195185 | 195185 | 2020-05-31 | Lincoln | Mississippi | 28085 | 263 | 29 |
192117 | 192117 | 2020-05-30 | Lincoln | Mississippi | 28085 | 256 | 28 |
189053 | 189053 | 2020-05-29 | Lincoln | Mississippi | 28085 | 250 | 27 |
185995 | 185995 | 2020-05-28 | Lincoln | Mississippi | 28085 | 250 | 24 |
182939 | 182939 | 2020-05-27 | Lincoln | Mississippi | 28085 | 250 | 22 |
179893 | 179893 | 2020-05-26 | Lincoln | Mississippi | 28085 | 248 | 21 |
176849 | 176849 | 2020-05-25 | Lincoln | Mississippi | 28085 | 245 | 20 |
173806 | 173806 | 2020-05-24 | Lincoln | Mississippi | 28085 | 243 | 20 |
170764 | 170764 | 2020-05-23 | Lincoln | Mississippi | 28085 | 238 | 20 |
167726 | 167726 | 2020-05-22 | Lincoln | Mississippi | 28085 | 231 | 19 |
164690 | 164690 | 2020-05-21 | Lincoln | Mississippi | 28085 | 224 | 19 |
161661 | 161661 | 2020-05-20 | Lincoln | Mississippi | 28085 | 222 | 18 |
158635 | 158635 | 2020-05-19 | Lincoln | Mississippi | 28085 | 218 | 18 |
155617 | 155617 | 2020-05-18 | Lincoln | Mississippi | 28085 | 218 | 18 |
152603 | 152603 | 2020-05-17 | Lincoln | Mississippi | 28085 | 217 | 18 |
149592 | 149592 | 2020-05-16 | Lincoln | Mississippi | 28085 | 202 | 18 |
146587 | 146587 | 2020-05-15 | Lincoln | Mississippi | 28085 | 197 | 17 |
143587 | 143587 | 2020-05-14 | Lincoln | Mississippi | 28085 | 194 | 16 |
140592 | 140592 | 2020-05-13 | Lincoln | Mississippi | 28085 | 191 | 15 |
137598 | 137598 | 2020-05-12 | Lincoln | Mississippi | 28085 | 189 | 14 |
134608 | 134608 | 2020-05-11 | Lincoln | Mississippi | 28085 | 186 | 14 |
131617 | 131617 | 2020-05-10 | Lincoln | Mississippi | 28085 | 186 | 14 |
128627 | 128627 | 2020-05-09 | Lincoln | Mississippi | 28085 | 184 | 13 |
125640 | 125640 | 2020-05-08 | Lincoln | Mississippi | 28085 | 179 | 12 |
122658 | 122658 | 2020-05-07 | Lincoln | Mississippi | 28085 | 179 | 12 |
119684 | 119684 | 2020-05-06 | Lincoln | Mississippi | 28085 | 166 | 12 |
116724 | 116724 | 2020-05-05 | Lincoln | Mississippi | 28085 | 155 | 12 |
113842 | 113842 | 2020-05-04 | Lincoln | Mississippi | 28085 | 154 | 11 |
110963 | 110963 | 2020-05-03 | Lincoln | Mississippi | 28085 | 151 | 11 |
108092 | 108092 | 2020-05-02 | Lincoln | Mississippi | 28085 | 150 | 11 |
105227 | 105227 | 2020-05-01 | Lincoln | Mississippi | 28085 | 143 | 11 |
102366 | 102366 | 2020-04-30 | Lincoln | Mississippi | 28085 | 141 | 10 |
99514 | 99514 | 2020-04-29 | Lincoln | Mississippi | 28085 | 141 | 9 |
96668 | 96668 | 2020-04-28 | Lincoln | Mississippi | 28085 | 136 | 9 |
93832 | 93832 | 2020-04-27 | Lincoln | Mississippi | 28085 | 136 | 9 |
91011 | 91011 | 2020-04-26 | Lincoln | Mississippi | 28085 | 136 | 9 |
88195 | 88195 | 2020-04-25 | Lincoln | Mississippi | 28085 | 136 | 8 |
85385 | 85385 | 2020-04-24 | Lincoln | Mississippi | 28085 | 132 | 7 |
82581 | 82581 | 2020-04-23 | Lincoln | Mississippi | 28085 | 125 | 7 |
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);