ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Yazoo" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387428 | 387428 | 2020-07-31 | Yazoo | Mississippi | 28163 | 757 | 11 |
384210 | 384210 | 2020-07-30 | Yazoo | Mississippi | 28163 | 747 | 11 |
380994 | 380994 | 2020-07-29 | Yazoo | Mississippi | 28163 | 726 | 11 |
377777 | 377777 | 2020-07-28 | Yazoo | Mississippi | 28163 | 717 | 11 |
374562 | 374562 | 2020-07-27 | Yazoo | Mississippi | 28163 | 694 | 9 |
371350 | 371350 | 2020-07-26 | Yazoo | Mississippi | 28163 | 689 | 9 |
368139 | 368139 | 2020-07-25 | Yazoo | Mississippi | 28163 | 688 | 9 |
364931 | 364931 | 2020-07-24 | Yazoo | Mississippi | 28163 | 673 | 9 |
361724 | 361724 | 2020-07-23 | Yazoo | Mississippi | 28163 | 664 | 8 |
358519 | 358519 | 2020-07-22 | Yazoo | Mississippi | 28163 | 653 | 8 |
355316 | 355316 | 2020-07-21 | Yazoo | Mississippi | 28163 | 640 | 7 |
352114 | 352114 | 2020-07-20 | Yazoo | Mississippi | 28163 | 619 | 7 |
348914 | 348914 | 2020-07-19 | Yazoo | Mississippi | 28163 | 610 | 7 |
345713 | 345713 | 2020-07-18 | Yazoo | Mississippi | 28163 | 603 | 7 |
342513 | 342513 | 2020-07-17 | Yazoo | Mississippi | 28163 | 597 | 7 |
339317 | 339317 | 2020-07-16 | Yazoo | Mississippi | 28163 | 587 | 7 |
336121 | 336121 | 2020-07-15 | Yazoo | Mississippi | 28163 | 584 | 7 |
332928 | 332928 | 2020-07-14 | Yazoo | Mississippi | 28163 | 574 | 7 |
329741 | 329741 | 2020-07-13 | Yazoo | Mississippi | 28163 | 566 | 7 |
326555 | 326555 | 2020-07-12 | Yazoo | Mississippi | 28163 | 560 | 7 |
323372 | 323372 | 2020-07-11 | Yazoo | Mississippi | 28163 | 553 | 6 |
320193 | 320193 | 2020-07-10 | Yazoo | Mississippi | 28163 | 548 | 6 |
317018 | 317018 | 2020-07-09 | Yazoo | Mississippi | 28163 | 543 | 6 |
313844 | 313844 | 2020-07-08 | Yazoo | Mississippi | 28163 | 533 | 6 |
310674 | 310674 | 2020-07-07 | Yazoo | Mississippi | 28163 | 523 | 6 |
307506 | 307506 | 2020-07-06 | Yazoo | Mississippi | 28163 | 513 | 6 |
304339 | 304339 | 2020-07-05 | Yazoo | Mississippi | 28163 | 509 | 6 |
301175 | 301175 | 2020-07-04 | Yazoo | Mississippi | 28163 | 505 | 6 |
298012 | 298012 | 2020-07-03 | Yazoo | Mississippi | 28163 | 493 | 6 |
294854 | 294854 | 2020-07-02 | Yazoo | Mississippi | 28163 | 478 | 6 |
291700 | 291700 | 2020-07-01 | Yazoo | Mississippi | 28163 | 473 | 6 |
288549 | 288549 | 2020-06-30 | Yazoo | Mississippi | 28163 | 467 | 6 |
285399 | 285399 | 2020-06-29 | Yazoo | Mississippi | 28163 | 454 | 6 |
282254 | 282254 | 2020-06-28 | Yazoo | Mississippi | 28163 | 445 | 6 |
279106 | 279106 | 2020-06-27 | Yazoo | Mississippi | 28163 | 444 | 6 |
275958 | 275958 | 2020-06-26 | Yazoo | Mississippi | 28163 | 441 | 6 |
272815 | 272815 | 2020-06-25 | Yazoo | Mississippi | 28163 | 426 | 6 |
269677 | 269677 | 2020-06-24 | Yazoo | Mississippi | 28163 | 412 | 6 |
266544 | 266544 | 2020-06-23 | Yazoo | Mississippi | 28163 | 407 | 6 |
263418 | 263418 | 2020-06-22 | Yazoo | Mississippi | 28163 | 395 | 6 |
260290 | 260290 | 2020-06-21 | Yazoo | Mississippi | 28163 | 354 | 6 |
257164 | 257164 | 2020-06-20 | Yazoo | Mississippi | 28163 | 354 | 6 |
254044 | 254044 | 2020-06-19 | Yazoo | Mississippi | 28163 | 354 | 6 |
250929 | 250929 | 2020-06-18 | Yazoo | Mississippi | 28163 | 354 | 6 |
247816 | 247816 | 2020-06-17 | Yazoo | Mississippi | 28163 | 354 | 6 |
244703 | 244703 | 2020-06-16 | Yazoo | Mississippi | 28163 | 350 | 6 |
241592 | 241592 | 2020-06-15 | Yazoo | Mississippi | 28163 | 348 | 6 |
238483 | 238483 | 2020-06-14 | Yazoo | Mississippi | 28163 | 348 | 6 |
235376 | 235376 | 2020-06-13 | Yazoo | Mississippi | 28163 | 347 | 6 |
232270 | 232270 | 2020-06-12 | Yazoo | Mississippi | 28163 | 337 | 6 |
229166 | 229166 | 2020-06-11 | Yazoo | Mississippi | 28163 | 329 | 6 |
226064 | 226064 | 2020-06-10 | Yazoo | Mississippi | 28163 | 329 | 6 |
222966 | 222966 | 2020-06-09 | Yazoo | Mississippi | 28163 | 321 | 6 |
219871 | 219871 | 2020-06-08 | Yazoo | Mississippi | 28163 | 310 | 6 |
216779 | 216779 | 2020-06-07 | Yazoo | Mississippi | 28163 | 301 | 5 |
213691 | 213691 | 2020-06-06 | Yazoo | Mississippi | 28163 | 300 | 5 |
210607 | 210607 | 2020-06-05 | Yazoo | Mississippi | 28163 | 298 | 5 |
207526 | 207526 | 2020-06-04 | Yazoo | Mississippi | 28163 | 296 | 4 |
204445 | 204445 | 2020-06-03 | Yazoo | Mississippi | 28163 | 291 | 4 |
201368 | 201368 | 2020-06-02 | Yazoo | Mississippi | 28163 | 286 | 4 |
198295 | 198295 | 2020-06-01 | Yazoo | Mississippi | 28163 | 283 | 4 |
195224 | 195224 | 2020-05-31 | Yazoo | Mississippi | 28163 | 281 | 4 |
192156 | 192156 | 2020-05-30 | Yazoo | Mississippi | 28163 | 273 | 4 |
189092 | 189092 | 2020-05-29 | Yazoo | Mississippi | 28163 | 239 | 4 |
186034 | 186034 | 2020-05-28 | Yazoo | Mississippi | 28163 | 227 | 4 |
182978 | 182978 | 2020-05-27 | Yazoo | Mississippi | 28163 | 223 | 3 |
179932 | 179932 | 2020-05-26 | Yazoo | Mississippi | 28163 | 221 | 2 |
176888 | 176888 | 2020-05-25 | Yazoo | Mississippi | 28163 | 219 | 2 |
173845 | 173845 | 2020-05-24 | Yazoo | Mississippi | 28163 | 215 | 2 |
170803 | 170803 | 2020-05-23 | Yazoo | Mississippi | 28163 | 204 | 2 |
167765 | 167765 | 2020-05-22 | Yazoo | Mississippi | 28163 | 198 | 2 |
164729 | 164729 | 2020-05-21 | Yazoo | Mississippi | 28163 | 194 | 2 |
161700 | 161700 | 2020-05-20 | Yazoo | Mississippi | 28163 | 194 | 2 |
158674 | 158674 | 2020-05-19 | Yazoo | Mississippi | 28163 | 192 | 2 |
155656 | 155656 | 2020-05-18 | Yazoo | Mississippi | 28163 | 190 | 2 |
152642 | 152642 | 2020-05-17 | Yazoo | Mississippi | 28163 | 188 | 2 |
149631 | 149631 | 2020-05-16 | Yazoo | Mississippi | 28163 | 182 | 2 |
146626 | 146626 | 2020-05-15 | Yazoo | Mississippi | 28163 | 180 | 2 |
143626 | 143626 | 2020-05-14 | Yazoo | Mississippi | 28163 | 176 | 2 |
140631 | 140631 | 2020-05-13 | Yazoo | Mississippi | 28163 | 171 | 2 |
137637 | 137637 | 2020-05-12 | Yazoo | Mississippi | 28163 | 169 | 2 |
134647 | 134647 | 2020-05-11 | Yazoo | Mississippi | 28163 | 169 | 2 |
131656 | 131656 | 2020-05-10 | Yazoo | Mississippi | 28163 | 164 | 2 |
128666 | 128666 | 2020-05-09 | Yazoo | Mississippi | 28163 | 162 | 2 |
125679 | 125679 | 2020-05-08 | Yazoo | Mississippi | 28163 | 162 | 2 |
122697 | 122697 | 2020-05-07 | Yazoo | Mississippi | 28163 | 154 | 2 |
119723 | 119723 | 2020-05-06 | Yazoo | Mississippi | 28163 | 155 | 2 |
116763 | 116763 | 2020-05-05 | Yazoo | Mississippi | 28163 | 154 | 2 |
113881 | 113881 | 2020-05-04 | Yazoo | Mississippi | 28163 | 151 | 2 |
111002 | 111002 | 2020-05-03 | Yazoo | Mississippi | 28163 | 147 | 2 |
108131 | 108131 | 2020-05-02 | Yazoo | Mississippi | 28163 | 144 | 1 |
105266 | 105266 | 2020-05-01 | Yazoo | Mississippi | 28163 | 139 | 1 |
102405 | 102405 | 2020-04-30 | Yazoo | Mississippi | 28163 | 135 | 1 |
99553 | 99553 | 2020-04-29 | Yazoo | Mississippi | 28163 | 134 | 1 |
96707 | 96707 | 2020-04-28 | Yazoo | Mississippi | 28163 | 129 | 1 |
93871 | 93871 | 2020-04-27 | Yazoo | Mississippi | 28163 | 126 | 1 |
91050 | 91050 | 2020-04-26 | Yazoo | Mississippi | 28163 | 122 | 1 |
88234 | 88234 | 2020-04-25 | Yazoo | Mississippi | 28163 | 120 | 1 |
85424 | 85424 | 2020-04-24 | Yazoo | Mississippi | 28163 | 117 | 1 |
82620 | 82620 | 2020-04-23 | Yazoo | Mississippi | 28163 | 110 | 1 |
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);