ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where deaths = 2 and fips = 29107 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 |
---|---|---|---|---|---|---|---|
587798 | 587798 | 2020-10-01 | Lafayette | Missouri | 29107 | 555 | 2 |
584558 | 584558 | 2020-09-30 | Lafayette | Missouri | 29107 | 552 | 2 |
581317 | 581317 | 2020-09-29 | Lafayette | Missouri | 29107 | 533 | 2 |
578076 | 578076 | 2020-09-28 | Lafayette | Missouri | 29107 | 533 | 2 |
574835 | 574835 | 2020-09-27 | Lafayette | Missouri | 29107 | 529 | 2 |
571592 | 571592 | 2020-09-26 | Lafayette | Missouri | 29107 | 509 | 2 |
568350 | 568350 | 2020-09-25 | Lafayette | Missouri | 29107 | 497 | 2 |
565110 | 565110 | 2020-09-24 | Lafayette | Missouri | 29107 | 489 | 2 |
561870 | 561870 | 2020-09-23 | Lafayette | Missouri | 29107 | 486 | 2 |
558633 | 558633 | 2020-09-22 | Lafayette | Missouri | 29107 | 476 | 2 |
555396 | 555396 | 2020-09-21 | Lafayette | Missouri | 29107 | 464 | 2 |
552158 | 552158 | 2020-09-20 | Lafayette | Missouri | 29107 | 440 | 2 |
548919 | 548919 | 2020-09-19 | Lafayette | Missouri | 29107 | 408 | 2 |
545681 | 545681 | 2020-09-18 | Lafayette | Missouri | 29107 | 377 | 2 |
542444 | 542444 | 2020-09-17 | Lafayette | Missouri | 29107 | 368 | 2 |
539208 | 539208 | 2020-09-16 | Lafayette | Missouri | 29107 | 361 | 2 |
535971 | 535971 | 2020-09-15 | Lafayette | Missouri | 29107 | 350 | 2 |
532736 | 532736 | 2020-09-14 | Lafayette | Missouri | 29107 | 346 | 2 |
529500 | 529500 | 2020-09-13 | Lafayette | Missouri | 29107 | 320 | 2 |
526264 | 526264 | 2020-09-12 | Lafayette | Missouri | 29107 | 314 | 2 |
523028 | 523028 | 2020-09-11 | Lafayette | Missouri | 29107 | 292 | 2 |
519791 | 519791 | 2020-09-10 | Lafayette | Missouri | 29107 | 285 | 2 |
516556 | 516556 | 2020-09-09 | Lafayette | Missouri | 29107 | 281 | 2 |
513322 | 513322 | 2020-09-08 | Lafayette | Missouri | 29107 | 274 | 2 |
510090 | 510090 | 2020-09-07 | Lafayette | Missouri | 29107 | 274 | 2 |
506857 | 506857 | 2020-09-06 | Lafayette | Missouri | 29107 | 271 | 2 |
503624 | 503624 | 2020-09-05 | Lafayette | Missouri | 29107 | 266 | 2 |
500390 | 500390 | 2020-09-04 | Lafayette | Missouri | 29107 | 259 | 2 |
497156 | 497156 | 2020-09-03 | Lafayette | Missouri | 29107 | 257 | 2 |
493923 | 493923 | 2020-09-02 | Lafayette | Missouri | 29107 | 250 | 2 |
490689 | 490689 | 2020-09-01 | Lafayette | Missouri | 29107 | 245 | 2 |
487456 | 487456 | 2020-08-31 | Lafayette | Missouri | 29107 | 239 | 2 |
484222 | 484222 | 2020-08-30 | Lafayette | Missouri | 29107 | 234 | 2 |
480987 | 480987 | 2020-08-29 | Lafayette | Missouri | 29107 | 233 | 2 |
477755 | 477755 | 2020-08-28 | Lafayette | Missouri | 29107 | 226 | 2 |
474522 | 474522 | 2020-08-27 | Lafayette | Missouri | 29107 | 223 | 2 |
471290 | 471290 | 2020-08-26 | Lafayette | Missouri | 29107 | 220 | 2 |
468060 | 468060 | 2020-08-25 | Lafayette | Missouri | 29107 | 217 | 2 |
464831 | 464831 | 2020-08-24 | Lafayette | Missouri | 29107 | 215 | 2 |
461600 | 461600 | 2020-08-23 | Lafayette | Missouri | 29107 | 211 | 2 |
458373 | 458373 | 2020-08-22 | Lafayette | Missouri | 29107 | 208 | 2 |
455145 | 455145 | 2020-08-21 | Lafayette | Missouri | 29107 | 205 | 2 |
451917 | 451917 | 2020-08-20 | Lafayette | Missouri | 29107 | 203 | 2 |
448689 | 448689 | 2020-08-19 | Lafayette | Missouri | 29107 | 201 | 2 |
445463 | 445463 | 2020-08-18 | Lafayette | Missouri | 29107 | 200 | 2 |
442237 | 442237 | 2020-08-17 | Lafayette | Missouri | 29107 | 199 | 2 |
439010 | 439010 | 2020-08-16 | Lafayette | Missouri | 29107 | 198 | 2 |
435785 | 435785 | 2020-08-15 | Lafayette | Missouri | 29107 | 198 | 2 |
432559 | 432559 | 2020-08-14 | Lafayette | Missouri | 29107 | 194 | 2 |
429332 | 429332 | 2020-08-13 | Lafayette | Missouri | 29107 | 189 | 2 |
426108 | 426108 | 2020-08-12 | Lafayette | Missouri | 29107 | 183 | 2 |
422886 | 422886 | 2020-08-11 | Lafayette | Missouri | 29107 | 180 | 2 |
419664 | 419664 | 2020-08-10 | Lafayette | Missouri | 29107 | 178 | 2 |
416443 | 416443 | 2020-08-09 | Lafayette | Missouri | 29107 | 178 | 2 |
413223 | 413223 | 2020-08-08 | Lafayette | Missouri | 29107 | 175 | 2 |
410003 | 410003 | 2020-08-07 | Lafayette | Missouri | 29107 | 175 | 2 |
406783 | 406783 | 2020-08-06 | Lafayette | Missouri | 29107 | 171 | 2 |
403565 | 403565 | 2020-08-05 | Lafayette | Missouri | 29107 | 166 | 2 |
400348 | 400348 | 2020-08-04 | Lafayette | Missouri | 29107 | 164 | 2 |
397134 | 397134 | 2020-08-03 | Lafayette | Missouri | 29107 | 158 | 2 |
393918 | 393918 | 2020-08-02 | Lafayette | Missouri | 29107 | 152 | 2 |
390701 | 390701 | 2020-08-01 | Lafayette | Missouri | 29107 | 151 | 2 |
387484 | 387484 | 2020-07-31 | Lafayette | Missouri | 29107 | 150 | 2 |
384266 | 384266 | 2020-07-30 | Lafayette | Missouri | 29107 | 145 | 2 |
381050 | 381050 | 2020-07-29 | Lafayette | Missouri | 29107 | 137 | 2 |
377833 | 377833 | 2020-07-28 | Lafayette | Missouri | 29107 | 135 | 2 |
374618 | 374618 | 2020-07-27 | Lafayette | Missouri | 29107 | 131 | 2 |
371406 | 371406 | 2020-07-26 | Lafayette | Missouri | 29107 | 125 | 2 |
368195 | 368195 | 2020-07-25 | Lafayette | Missouri | 29107 | 125 | 2 |
364987 | 364987 | 2020-07-24 | Lafayette | Missouri | 29107 | 124 | 2 |
361780 | 361780 | 2020-07-23 | Lafayette | Missouri | 29107 | 124 | 2 |
358575 | 358575 | 2020-07-22 | Lafayette | Missouri | 29107 | 122 | 2 |
355372 | 355372 | 2020-07-21 | Lafayette | Missouri | 29107 | 120 | 2 |
352170 | 352170 | 2020-07-20 | Lafayette | Missouri | 29107 | 119 | 2 |
348970 | 348970 | 2020-07-19 | Lafayette | Missouri | 29107 | 117 | 2 |
345769 | 345769 | 2020-07-18 | Lafayette | Missouri | 29107 | 116 | 2 |
342569 | 342569 | 2020-07-17 | Lafayette | Missouri | 29107 | 108 | 2 |
339373 | 339373 | 2020-07-16 | Lafayette | Missouri | 29107 | 105 | 2 |
336177 | 336177 | 2020-07-15 | Lafayette | Missouri | 29107 | 104 | 2 |
332984 | 332984 | 2020-07-14 | Lafayette | Missouri | 29107 | 104 | 2 |
329797 | 329797 | 2020-07-13 | Lafayette | Missouri | 29107 | 103 | 2 |
326611 | 326611 | 2020-07-12 | Lafayette | Missouri | 29107 | 103 | 2 |
323428 | 323428 | 2020-07-11 | Lafayette | Missouri | 29107 | 102 | 2 |
320249 | 320249 | 2020-07-10 | Lafayette | Missouri | 29107 | 101 | 2 |
317074 | 317074 | 2020-07-09 | Lafayette | Missouri | 29107 | 100 | 2 |
313900 | 313900 | 2020-07-08 | Lafayette | Missouri | 29107 | 97 | 2 |
310729 | 310729 | 2020-07-07 | Lafayette | Missouri | 29107 | 94 | 2 |
307561 | 307561 | 2020-07-06 | Lafayette | Missouri | 29107 | 93 | 2 |
304394 | 304394 | 2020-07-05 | Lafayette | Missouri | 29107 | 93 | 2 |
301230 | 301230 | 2020-07-04 | Lafayette | Missouri | 29107 | 92 | 2 |
298067 | 298067 | 2020-07-03 | Lafayette | Missouri | 29107 | 92 | 2 |
294909 | 294909 | 2020-07-02 | Lafayette | Missouri | 29107 | 91 | 2 |
291755 | 291755 | 2020-07-01 | Lafayette | Missouri | 29107 | 91 | 2 |
288604 | 288604 | 2020-06-30 | Lafayette | Missouri | 29107 | 88 | 2 |
285454 | 285454 | 2020-06-29 | Lafayette | Missouri | 29107 | 88 | 2 |
282309 | 282309 | 2020-06-28 | Lafayette | Missouri | 29107 | 88 | 2 |
279161 | 279161 | 2020-06-27 | Lafayette | Missouri | 29107 | 87 | 2 |
276013 | 276013 | 2020-06-26 | Lafayette | Missouri | 29107 | 87 | 2 |
272870 | 272870 | 2020-06-25 | Lafayette | Missouri | 29107 | 87 | 2 |
269731 | 269731 | 2020-06-24 | Lafayette | Missouri | 29107 | 86 | 2 |
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);