ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29069 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282289 | 282289 | 2020-06-28 | Dunklin | Missouri | 29069 | 93 | 3 |
285434 | 285434 | 2020-06-29 | Dunklin | Missouri | 29069 | 93 | 3 |
288584 | 288584 | 2020-06-30 | Dunklin | Missouri | 29069 | 98 | 3 |
291735 | 291735 | 2020-07-01 | Dunklin | Missouri | 29069 | 104 | 3 |
294889 | 294889 | 2020-07-02 | Dunklin | Missouri | 29069 | 106 | 3 |
298047 | 298047 | 2020-07-03 | Dunklin | Missouri | 29069 | 108 | 3 |
301210 | 301210 | 2020-07-04 | Dunklin | Missouri | 29069 | 109 | 3 |
304374 | 304374 | 2020-07-05 | Dunklin | Missouri | 29069 | 110 | 3 |
307541 | 307541 | 2020-07-06 | Dunklin | Missouri | 29069 | 110 | 3 |
310709 | 310709 | 2020-07-07 | Dunklin | Missouri | 29069 | 116 | 3 |
313879 | 313879 | 2020-07-08 | Dunklin | Missouri | 29069 | 115 | 3 |
317053 | 317053 | 2020-07-09 | Dunklin | Missouri | 29069 | 119 | 3 |
320228 | 320228 | 2020-07-10 | Dunklin | Missouri | 29069 | 128 | 3 |
323407 | 323407 | 2020-07-11 | Dunklin | Missouri | 29069 | 127 | 3 |
326590 | 326590 | 2020-07-12 | Dunklin | Missouri | 29069 | 127 | 3 |
329776 | 329776 | 2020-07-13 | Dunklin | Missouri | 29069 | 134 | 3 |
332963 | 332963 | 2020-07-14 | Dunklin | Missouri | 29069 | 136 | 3 |
336156 | 336156 | 2020-07-15 | Dunklin | Missouri | 29069 | 138 | 3 |
339352 | 339352 | 2020-07-16 | Dunklin | Missouri | 29069 | 138 | 3 |
342548 | 342548 | 2020-07-17 | Dunklin | Missouri | 29069 | 146 | 3 |
345748 | 345748 | 2020-07-18 | Dunklin | Missouri | 29069 | 146 | 3 |
348949 | 348949 | 2020-07-19 | Dunklin | Missouri | 29069 | 147 | 3 |
352149 | 352149 | 2020-07-20 | Dunklin | Missouri | 29069 | 149 | 3 |
355351 | 355351 | 2020-07-21 | Dunklin | Missouri | 29069 | 160 | 3 |
358554 | 358554 | 2020-07-22 | Dunklin | Missouri | 29069 | 168 | 3 |
361759 | 361759 | 2020-07-23 | Dunklin | Missouri | 29069 | 176 | 3 |
364966 | 364966 | 2020-07-24 | Dunklin | Missouri | 29069 | 192 | 3 |
368174 | 368174 | 2020-07-25 | Dunklin | Missouri | 29069 | 194 | 3 |
371385 | 371385 | 2020-07-26 | Dunklin | Missouri | 29069 | 194 | 3 |
374597 | 374597 | 2020-07-27 | Dunklin | Missouri | 29069 | 205 | 3 |
377812 | 377812 | 2020-07-28 | Dunklin | Missouri | 29069 | 218 | 3 |
381029 | 381029 | 2020-07-29 | Dunklin | Missouri | 29069 | 228 | 3 |
384245 | 384245 | 2020-07-30 | Dunklin | Missouri | 29069 | 234 | 4 |
387463 | 387463 | 2020-07-31 | Dunklin | Missouri | 29069 | 239 | 4 |
390680 | 390680 | 2020-08-01 | Dunklin | Missouri | 29069 | 242 | 4 |
393897 | 393897 | 2020-08-02 | Dunklin | Missouri | 29069 | 247 | 4 |
397113 | 397113 | 2020-08-03 | Dunklin | Missouri | 29069 | 255 | 4 |
400327 | 400327 | 2020-08-04 | Dunklin | Missouri | 29069 | 267 | 4 |
403544 | 403544 | 2020-08-05 | Dunklin | Missouri | 29069 | 276 | 4 |
406762 | 406762 | 2020-08-06 | Dunklin | Missouri | 29069 | 288 | 4 |
409982 | 409982 | 2020-08-07 | Dunklin | Missouri | 29069 | 300 | 4 |
413202 | 413202 | 2020-08-08 | Dunklin | Missouri | 29069 | 300 | 4 |
416422 | 416422 | 2020-08-09 | Dunklin | Missouri | 29069 | 310 | 4 |
419643 | 419643 | 2020-08-10 | Dunklin | Missouri | 29069 | 317 | 4 |
422865 | 422865 | 2020-08-11 | Dunklin | Missouri | 29069 | 319 | 4 |
426087 | 426087 | 2020-08-12 | Dunklin | Missouri | 29069 | 336 | 4 |
429311 | 429311 | 2020-08-13 | Dunklin | Missouri | 29069 | 339 | 4 |
432538 | 432538 | 2020-08-14 | Dunklin | Missouri | 29069 | 372 | 4 |
435764 | 435764 | 2020-08-15 | Dunklin | Missouri | 29069 | 378 | 4 |
438989 | 438989 | 2020-08-16 | Dunklin | Missouri | 29069 | 388 | 4 |
442216 | 442216 | 2020-08-17 | Dunklin | Missouri | 29069 | 398 | 4 |
445442 | 445442 | 2020-08-18 | Dunklin | Missouri | 29069 | 402 | 4 |
448668 | 448668 | 2020-08-19 | Dunklin | Missouri | 29069 | 420 | 4 |
451896 | 451896 | 2020-08-20 | Dunklin | Missouri | 29069 | 430 | 4 |
455124 | 455124 | 2020-08-21 | Dunklin | Missouri | 29069 | 440 | 4 |
458352 | 458352 | 2020-08-22 | Dunklin | Missouri | 29069 | 443 | 4 |
461579 | 461579 | 2020-08-23 | Dunklin | Missouri | 29069 | 445 | 4 |
464810 | 464810 | 2020-08-24 | Dunklin | Missouri | 29069 | 446 | 4 |
468039 | 468039 | 2020-08-25 | Dunklin | Missouri | 29069 | 452 | 4 |
471269 | 471269 | 2020-08-26 | Dunklin | Missouri | 29069 | 464 | 4 |
474501 | 474501 | 2020-08-27 | Dunklin | Missouri | 29069 | 471 | 4 |
477734 | 477734 | 2020-08-28 | Dunklin | Missouri | 29069 | 473 | 4 |
480966 | 480966 | 2020-08-29 | Dunklin | Missouri | 29069 | 473 | 4 |
484201 | 484201 | 2020-08-30 | Dunklin | Missouri | 29069 | 487 | 4 |
487435 | 487435 | 2020-08-31 | Dunklin | Missouri | 29069 | 491 | 4 |
490668 | 490668 | 2020-09-01 | Dunklin | Missouri | 29069 | 517 | 4 |
493902 | 493902 | 2020-09-02 | Dunklin | Missouri | 29069 | 532 | 4 |
497135 | 497135 | 2020-09-03 | Dunklin | Missouri | 29069 | 544 | 4 |
500369 | 500369 | 2020-09-04 | Dunklin | Missouri | 29069 | 545 | 4 |
503603 | 503603 | 2020-09-05 | Dunklin | Missouri | 29069 | 557 | 6 |
506836 | 506836 | 2020-09-06 | Dunklin | Missouri | 29069 | 568 | 6 |
510069 | 510069 | 2020-09-07 | Dunklin | Missouri | 29069 | 566 | 6 |
513301 | 513301 | 2020-09-08 | Dunklin | Missouri | 29069 | 579 | 6 |
516535 | 516535 | 2020-09-09 | Dunklin | Missouri | 29069 | 586 | 6 |
519770 | 519770 | 2020-09-10 | Dunklin | Missouri | 29069 | 600 | 6 |
523007 | 523007 | 2020-09-11 | Dunklin | Missouri | 29069 | 612 | 6 |
526243 | 526243 | 2020-09-12 | Dunklin | Missouri | 29069 | 628 | 6 |
529479 | 529479 | 2020-09-13 | Dunklin | Missouri | 29069 | 636 | 6 |
532715 | 532715 | 2020-09-14 | Dunklin | Missouri | 29069 | 641 | 6 |
535950 | 535950 | 2020-09-15 | Dunklin | Missouri | 29069 | 647 | 6 |
539187 | 539187 | 2020-09-16 | Dunklin | Missouri | 29069 | 676 | 6 |
542423 | 542423 | 2020-09-17 | Dunklin | Missouri | 29069 | 693 | 6 |
545660 | 545660 | 2020-09-18 | Dunklin | Missouri | 29069 | 709 | 6 |
548898 | 548898 | 2020-09-19 | Dunklin | Missouri | 29069 | 730 | 6 |
552137 | 552137 | 2020-09-20 | Dunklin | Missouri | 29069 | 744 | 6 |
555375 | 555375 | 2020-09-21 | Dunklin | Missouri | 29069 | 746 | 6 |
558612 | 558612 | 2020-09-22 | Dunklin | Missouri | 29069 | 751 | 6 |
561849 | 561849 | 2020-09-23 | Dunklin | Missouri | 29069 | 764 | 7 |
565089 | 565089 | 2020-09-24 | Dunklin | Missouri | 29069 | 769 | 7 |
568329 | 568329 | 2020-09-25 | Dunklin | Missouri | 29069 | 779 | 7 |
571571 | 571571 | 2020-09-26 | Dunklin | Missouri | 29069 | 784 | 8 |
574814 | 574814 | 2020-09-27 | Dunklin | Missouri | 29069 | 789 | 8 |
578055 | 578055 | 2020-09-28 | Dunklin | Missouri | 29069 | 800 | 8 |
581296 | 581296 | 2020-09-29 | Dunklin | Missouri | 29069 | 800 | 8 |
584537 | 584537 | 2020-09-30 | Dunklin | Missouri | 29069 | 841 | 8 |
587777 | 587777 | 2020-10-01 | Dunklin | Missouri | 29069 | 845 | 8 |
591018 | 591018 | 2020-10-02 | Dunklin | Missouri | 29069 | 855 | 8 |
594259 | 594259 | 2020-10-03 | Dunklin | Missouri | 29069 | 867 | 8 |
597500 | 597500 | 2020-10-04 | Dunklin | Missouri | 29069 | 875 | 8 |
600743 | 600743 | 2020-10-05 | Dunklin | Missouri | 29069 | 883 | 8 |
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);