ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jefferson" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636430 | 636430 | 2020-10-16 | Jefferson | Missouri | 29099 | 5474 | 69 |
633184 | 633184 | 2020-10-15 | Jefferson | Missouri | 29099 | 5390 | 69 |
629939 | 629939 | 2020-10-14 | Jefferson | Missouri | 29099 | 5339 | 71 |
626695 | 626695 | 2020-10-13 | Jefferson | Missouri | 29099 | 5245 | 69 |
623453 | 623453 | 2020-10-12 | Jefferson | Missouri | 29099 | 5217 | 69 |
620210 | 620210 | 2020-10-11 | Jefferson | Missouri | 29099 | 5079 | 69 |
616968 | 616968 | 2020-10-10 | Jefferson | Missouri | 29099 | 5079 | 69 |
613727 | 613727 | 2020-10-09 | Jefferson | Missouri | 29099 | 5079 | 68 |
610485 | 610485 | 2020-10-08 | Jefferson | Missouri | 29099 | 5009 | 66 |
607243 | 607243 | 2020-10-07 | Jefferson | Missouri | 29099 | 4962 | 66 |
604000 | 604000 | 2020-10-06 | Jefferson | Missouri | 29099 | 4904 | 66 |
600758 | 600758 | 2020-10-05 | Jefferson | Missouri | 29099 | 4843 | 66 |
597515 | 597515 | 2020-10-04 | Jefferson | Missouri | 29099 | 4737 | 66 |
594274 | 594274 | 2020-10-03 | Jefferson | Missouri | 29099 | 4737 | 66 |
591033 | 591033 | 2020-10-02 | Jefferson | Missouri | 29099 | 4737 | 65 |
587792 | 587792 | 2020-10-01 | Jefferson | Missouri | 29099 | 4673 | 65 |
584552 | 584552 | 2020-09-30 | Jefferson | Missouri | 29099 | 4622 | 64 |
581311 | 581311 | 2020-09-29 | Jefferson | Missouri | 29099 | 4574 | 61 |
578070 | 578070 | 2020-09-28 | Jefferson | Missouri | 29099 | 4470 | 61 |
574829 | 574829 | 2020-09-27 | Jefferson | Missouri | 29099 | 4302 | 61 |
571586 | 571586 | 2020-09-26 | Jefferson | Missouri | 29099 | 4302 | 61 |
568344 | 568344 | 2020-09-25 | Jefferson | Missouri | 29099 | 4302 | 61 |
565104 | 565104 | 2020-09-24 | Jefferson | Missouri | 29099 | 4232 | 60 |
561864 | 561864 | 2020-09-23 | Jefferson | Missouri | 29099 | 4172 | 60 |
558627 | 558627 | 2020-09-22 | Jefferson | Missouri | 29099 | 4106 | 60 |
555390 | 555390 | 2020-09-21 | Jefferson | Missouri | 29099 | 4051 | 59 |
552152 | 552152 | 2020-09-20 | Jefferson | Missouri | 29099 | 3871 | 54 |
548913 | 548913 | 2020-09-19 | Jefferson | Missouri | 29099 | 3871 | 54 |
545675 | 545675 | 2020-09-18 | Jefferson | Missouri | 29099 | 3871 | 54 |
542438 | 542438 | 2020-09-17 | Jefferson | Missouri | 29099 | 3789 | 54 |
539202 | 539202 | 2020-09-16 | Jefferson | Missouri | 29099 | 3677 | 54 |
535965 | 535965 | 2020-09-15 | Jefferson | Missouri | 29099 | 3579 | 52 |
532730 | 532730 | 2020-09-14 | Jefferson | Missouri | 29099 | 3519 | 52 |
529494 | 529494 | 2020-09-13 | Jefferson | Missouri | 29099 | 3425 | 52 |
526258 | 526258 | 2020-09-12 | Jefferson | Missouri | 29099 | 3369 | 52 |
523022 | 523022 | 2020-09-11 | Jefferson | Missouri | 29099 | 3336 | 52 |
519785 | 519785 | 2020-09-10 | Jefferson | Missouri | 29099 | 3336 | 52 |
516550 | 516550 | 2020-09-09 | Jefferson | Missouri | 29099 | 3297 | 49 |
513316 | 513316 | 2020-09-08 | Jefferson | Missouri | 29099 | 3248 | 49 |
510084 | 510084 | 2020-09-07 | Jefferson | Missouri | 29099 | 3109 | 48 |
506851 | 506851 | 2020-09-06 | Jefferson | Missouri | 29099 | 3064 | 48 |
503618 | 503618 | 2020-09-05 | Jefferson | Missouri | 29099 | 3025 | 48 |
500384 | 500384 | 2020-09-04 | Jefferson | Missouri | 29099 | 3025 | 48 |
497150 | 497150 | 2020-09-03 | Jefferson | Missouri | 29099 | 2963 | 48 |
493917 | 493917 | 2020-09-02 | Jefferson | Missouri | 29099 | 2891 | 47 |
490683 | 490683 | 2020-09-01 | Jefferson | Missouri | 29099 | 2857 | 46 |
487450 | 487450 | 2020-08-31 | Jefferson | Missouri | 29099 | 2813 | 45 |
484216 | 484216 | 2020-08-30 | Jefferson | Missouri | 29099 | 2776 | 45 |
480981 | 480981 | 2020-08-29 | Jefferson | Missouri | 29099 | 2663 | 45 |
477749 | 477749 | 2020-08-28 | Jefferson | Missouri | 29099 | 2663 | 45 |
474516 | 474516 | 2020-08-27 | Jefferson | Missouri | 29099 | 2605 | 45 |
471284 | 471284 | 2020-08-26 | Jefferson | Missouri | 29099 | 2566 | 40 |
468054 | 468054 | 2020-08-25 | Jefferson | Missouri | 29099 | 2518 | 40 |
464825 | 464825 | 2020-08-24 | Jefferson | Missouri | 29099 | 2471 | 40 |
461594 | 461594 | 2020-08-23 | Jefferson | Missouri | 29099 | 2412 | 40 |
458367 | 458367 | 2020-08-22 | Jefferson | Missouri | 29099 | 2317 | 40 |
455139 | 455139 | 2020-08-21 | Jefferson | Missouri | 29099 | 2317 | 40 |
451911 | 451911 | 2020-08-20 | Jefferson | Missouri | 29099 | 2297 | 40 |
448683 | 448683 | 2020-08-19 | Jefferson | Missouri | 29099 | 2250 | 30 |
445457 | 445457 | 2020-08-18 | Jefferson | Missouri | 29099 | 2196 | 30 |
442231 | 442231 | 2020-08-17 | Jefferson | Missouri | 29099 | 2166 | 30 |
439004 | 439004 | 2020-08-16 | Jefferson | Missouri | 29099 | 2006 | 28 |
435779 | 435779 | 2020-08-15 | Jefferson | Missouri | 29099 | 2006 | 28 |
432553 | 432553 | 2020-08-14 | Jefferson | Missouri | 29099 | 2006 | 28 |
429326 | 429326 | 2020-08-13 | Jefferson | Missouri | 29099 | 1974 | 28 |
426102 | 426102 | 2020-08-12 | Jefferson | Missouri | 29099 | 1912 | 28 |
422880 | 422880 | 2020-08-11 | Jefferson | Missouri | 29099 | 1876 | 28 |
419658 | 419658 | 2020-08-10 | Jefferson | Missouri | 29099 | 1836 | 28 |
416437 | 416437 | 2020-08-09 | Jefferson | Missouri | 29099 | 1822 | 28 |
413217 | 413217 | 2020-08-08 | Jefferson | Missouri | 29099 | 1716 | 28 |
409997 | 409997 | 2020-08-07 | Jefferson | Missouri | 29099 | 1716 | 28 |
406777 | 406777 | 2020-08-06 | Jefferson | Missouri | 29099 | 1679 | 28 |
403559 | 403559 | 2020-08-05 | Jefferson | Missouri | 29099 | 1646 | 28 |
400342 | 400342 | 2020-08-04 | Jefferson | Missouri | 29099 | 1614 | 28 |
397128 | 397128 | 2020-08-03 | Jefferson | Missouri | 29099 | 1559 | 25 |
393912 | 393912 | 2020-08-02 | Jefferson | Missouri | 29099 | 1417 | 25 |
390695 | 390695 | 2020-08-01 | Jefferson | Missouri | 29099 | 1417 | 25 |
387478 | 387478 | 2020-07-31 | Jefferson | Missouri | 29099 | 1417 | 25 |
384260 | 384260 | 2020-07-30 | Jefferson | Missouri | 29099 | 1370 | 25 |
381044 | 381044 | 2020-07-29 | Jefferson | Missouri | 29099 | 1291 | 25 |
377827 | 377827 | 2020-07-28 | Jefferson | Missouri | 29099 | 1248 | 25 |
374612 | 374612 | 2020-07-27 | Jefferson | Missouri | 29099 | 1211 | 25 |
371400 | 371400 | 2020-07-26 | Jefferson | Missouri | 29099 | 1155 | 25 |
368189 | 368189 | 2020-07-25 | Jefferson | Missouri | 29099 | 1122 | 25 |
364981 | 364981 | 2020-07-24 | Jefferson | Missouri | 29099 | 1122 | 25 |
361774 | 361774 | 2020-07-23 | Jefferson | Missouri | 29099 | 1101 | 25 |
358569 | 358569 | 2020-07-22 | Jefferson | Missouri | 29099 | 1018 | 25 |
355366 | 355366 | 2020-07-21 | Jefferson | Missouri | 29099 | 1007 | 25 |
352164 | 352164 | 2020-07-20 | Jefferson | Missouri | 29099 | 969 | 25 |
348964 | 348964 | 2020-07-19 | Jefferson | Missouri | 29099 | 873 | 25 |
345763 | 345763 | 2020-07-18 | Jefferson | Missouri | 29099 | 873 | 25 |
342563 | 342563 | 2020-07-17 | Jefferson | Missouri | 29099 | 873 | 25 |
339367 | 339367 | 2020-07-16 | Jefferson | Missouri | 29099 | 857 | 25 |
336171 | 336171 | 2020-07-15 | Jefferson | Missouri | 29099 | 834 | 23 |
332978 | 332978 | 2020-07-14 | Jefferson | Missouri | 29099 | 814 | 23 |
329791 | 329791 | 2020-07-13 | Jefferson | Missouri | 29099 | 769 | 23 |
326605 | 326605 | 2020-07-12 | Jefferson | Missouri | 29099 | 743 | 23 |
323422 | 323422 | 2020-07-11 | Jefferson | Missouri | 29099 | 666 | 23 |
320243 | 320243 | 2020-07-10 | Jefferson | Missouri | 29099 | 666 | 23 |
317068 | 317068 | 2020-07-09 | Jefferson | Missouri | 29099 | 666 | 23 |
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);