ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,569 rows where county = "St. Joseph" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535197 | 535197 | 2020-09-15 | St. Joseph | Indiana | 18141 | 5822 | 102 |
535739 | 535739 | 2020-09-15 | St. Joseph | Michigan | 26149 | 711 | 11 |
531962 | 531962 | 2020-09-14 | St. Joseph | Indiana | 18141 | 5790 | 102 |
532504 | 532504 | 2020-09-14 | St. Joseph | Michigan | 26149 | 711 | 11 |
528725 | 528725 | 2020-09-13 | St. Joseph | Indiana | 18141 | 5741 | 102 |
529268 | 529268 | 2020-09-13 | St. Joseph | Michigan | 26149 | 708 | 11 |
525489 | 525489 | 2020-09-12 | St. Joseph | Indiana | 18141 | 5658 | 102 |
526032 | 526032 | 2020-09-12 | St. Joseph | Michigan | 26149 | 708 | 11 |
522253 | 522253 | 2020-09-11 | St. Joseph | Indiana | 18141 | 5619 | 102 |
522796 | 522796 | 2020-09-11 | St. Joseph | Michigan | 26149 | 703 | 11 |
519016 | 519016 | 2020-09-10 | St. Joseph | Indiana | 18141 | 5574 | 102 |
519559 | 519559 | 2020-09-10 | St. Joseph | Michigan | 26149 | 703 | 11 |
515781 | 515781 | 2020-09-09 | St. Joseph | Indiana | 18141 | 5559 | 102 |
516324 | 516324 | 2020-09-09 | St. Joseph | Michigan | 26149 | 702 | 11 |
512548 | 512548 | 2020-09-08 | St. Joseph | Indiana | 18141 | 5488 | 101 |
513090 | 513090 | 2020-09-08 | St. Joseph | Michigan | 26149 | 703 | 11 |
509315 | 509315 | 2020-09-07 | St. Joseph | Indiana | 18141 | 5472 | 101 |
509858 | 509858 | 2020-09-07 | St. Joseph | Michigan | 26149 | 698 | 11 |
506083 | 506083 | 2020-09-06 | St. Joseph | Indiana | 18141 | 5450 | 101 |
506625 | 506625 | 2020-09-06 | St. Joseph | Michigan | 26149 | 696 | 11 |
502849 | 502849 | 2020-09-05 | St. Joseph | Indiana | 18141 | 5409 | 101 |
503392 | 503392 | 2020-09-05 | St. Joseph | Michigan | 26149 | 696 | 11 |
499615 | 499615 | 2020-09-04 | St. Joseph | Indiana | 18141 | 5355 | 100 |
500158 | 500158 | 2020-09-04 | St. Joseph | Michigan | 26149 | 691 | 11 |
496382 | 496382 | 2020-09-03 | St. Joseph | Indiana | 18141 | 5311 | 100 |
496924 | 496924 | 2020-09-03 | St. Joseph | Michigan | 26149 | 683 | 11 |
493148 | 493148 | 2020-09-02 | St. Joseph | Indiana | 18141 | 5233 | 99 |
493691 | 493691 | 2020-09-02 | St. Joseph | Michigan | 26149 | 684 | 11 |
489915 | 489915 | 2020-09-01 | St. Joseph | Indiana | 18141 | 5197 | 99 |
490457 | 490457 | 2020-09-01 | St. Joseph | Michigan | 26149 | 685 | 11 |
486682 | 486682 | 2020-08-31 | St. Joseph | Indiana | 18141 | 5168 | 97 |
487224 | 487224 | 2020-08-31 | St. Joseph | Michigan | 26149 | 683 | 11 |
483447 | 483447 | 2020-08-30 | St. Joseph | Indiana | 18141 | 5117 | 97 |
483990 | 483990 | 2020-08-30 | St. Joseph | Michigan | 26149 | 680 | 11 |
480213 | 480213 | 2020-08-29 | St. Joseph | Indiana | 18141 | 5044 | 97 |
480755 | 480755 | 2020-08-29 | St. Joseph | Michigan | 26149 | 679 | 11 |
476980 | 476980 | 2020-08-28 | St. Joseph | Indiana | 18141 | 4986 | 97 |
477523 | 477523 | 2020-08-28 | St. Joseph | Michigan | 26149 | 676 | 11 |
473747 | 473747 | 2020-08-27 | St. Joseph | Indiana | 18141 | 4939 | 95 |
474290 | 474290 | 2020-08-27 | St. Joseph | Michigan | 26149 | 671 | 11 |
470515 | 470515 | 2020-08-26 | St. Joseph | Indiana | 18141 | 4840 | 95 |
471058 | 471058 | 2020-08-26 | St. Joseph | Michigan | 26149 | 669 | 11 |
467286 | 467286 | 2020-08-25 | St. Joseph | Indiana | 18141 | 4709 | 95 |
467828 | 467828 | 2020-08-25 | St. Joseph | Michigan | 26149 | 670 | 11 |
464057 | 464057 | 2020-08-24 | St. Joseph | Indiana | 18141 | 4557 | 93 |
464599 | 464599 | 2020-08-24 | St. Joseph | Michigan | 26149 | 667 | 11 |
460828 | 460828 | 2020-08-23 | St. Joseph | Indiana | 18141 | 4245 | 93 |
461368 | 461368 | 2020-08-23 | St. Joseph | Michigan | 26149 | 661 | 11 |
457601 | 457601 | 2020-08-22 | St. Joseph | Indiana | 18141 | 4194 | 93 |
458141 | 458141 | 2020-08-22 | St. Joseph | Michigan | 26149 | 657 | 11 |
454373 | 454373 | 2020-08-21 | St. Joseph | Indiana | 18141 | 4121 | 92 |
454913 | 454913 | 2020-08-21 | St. Joseph | Michigan | 26149 | 644 | 10 |
451145 | 451145 | 2020-08-20 | St. Joseph | Indiana | 18141 | 4057 | 92 |
451685 | 451685 | 2020-08-20 | St. Joseph | Michigan | 26149 | 644 | 10 |
447917 | 447917 | 2020-08-19 | St. Joseph | Indiana | 18141 | 3986 | 92 |
448457 | 448457 | 2020-08-19 | St. Joseph | Michigan | 26149 | 641 | 10 |
444690 | 444690 | 2020-08-18 | St. Joseph | Indiana | 18141 | 3953 | 92 |
445231 | 445231 | 2020-08-18 | St. Joseph | Michigan | 26149 | 636 | 10 |
441464 | 441464 | 2020-08-17 | St. Joseph | Indiana | 18141 | 3898 | 90 |
442005 | 442005 | 2020-08-17 | St. Joseph | Michigan | 26149 | 637 | 10 |
438238 | 438238 | 2020-08-16 | St. Joseph | Indiana | 18141 | 3857 | 88 |
438778 | 438778 | 2020-08-16 | St. Joseph | Michigan | 26149 | 622 | 10 |
435012 | 435012 | 2020-08-15 | St. Joseph | Indiana | 18141 | 3821 | 88 |
435553 | 435553 | 2020-08-15 | St. Joseph | Michigan | 26149 | 622 | 10 |
431787 | 431787 | 2020-08-14 | St. Joseph | Indiana | 18141 | 3778 | 88 |
432327 | 432327 | 2020-08-14 | St. Joseph | Michigan | 26149 | 618 | 10 |
428559 | 428559 | 2020-08-13 | St. Joseph | Indiana | 18141 | 3693 | 88 |
429100 | 429100 | 2020-08-13 | St. Joseph | Michigan | 26149 | 608 | 10 |
425335 | 425335 | 2020-08-12 | St. Joseph | Indiana | 18141 | 3622 | 88 |
425876 | 425876 | 2020-08-12 | St. Joseph | Michigan | 26149 | 603 | 9 |
422114 | 422114 | 2020-08-11 | St. Joseph | Indiana | 18141 | 3589 | 88 |
422654 | 422654 | 2020-08-11 | St. Joseph | Michigan | 26149 | 600 | 9 |
418891 | 418891 | 2020-08-10 | St. Joseph | Indiana | 18141 | 3557 | 87 |
419432 | 419432 | 2020-08-10 | St. Joseph | Michigan | 26149 | 591 | 8 |
415670 | 415670 | 2020-08-09 | St. Joseph | Indiana | 18141 | 3511 | 86 |
416211 | 416211 | 2020-08-09 | St. Joseph | Michigan | 26149 | 588 | 8 |
412450 | 412450 | 2020-08-08 | St. Joseph | Indiana | 18141 | 3434 | 86 |
412991 | 412991 | 2020-08-08 | St. Joseph | Michigan | 26149 | 587 | 8 |
409231 | 409231 | 2020-08-07 | St. Joseph | Indiana | 18141 | 3384 | 86 |
409771 | 409771 | 2020-08-07 | St. Joseph | Michigan | 26149 | 580 | 8 |
406011 | 406011 | 2020-08-06 | St. Joseph | Indiana | 18141 | 3312 | 84 |
406551 | 406551 | 2020-08-06 | St. Joseph | Michigan | 26149 | 571 | 8 |
402793 | 402793 | 2020-08-05 | St. Joseph | Indiana | 18141 | 3235 | 84 |
403333 | 403333 | 2020-08-05 | St. Joseph | Michigan | 26149 | 569 | 8 |
399577 | 399577 | 2020-08-04 | St. Joseph | Indiana | 18141 | 3214 | 84 |
400116 | 400116 | 2020-08-04 | St. Joseph | Michigan | 26149 | 563 | 8 |
396361 | 396361 | 2020-08-03 | St. Joseph | Indiana | 18141 | 3165 | 84 |
396902 | 396902 | 2020-08-03 | St. Joseph | Michigan | 26149 | 561 | 7 |
393145 | 393145 | 2020-08-02 | St. Joseph | Indiana | 18141 | 3125 | 84 |
393686 | 393686 | 2020-08-02 | St. Joseph | Michigan | 26149 | 557 | 7 |
389928 | 389928 | 2020-08-01 | St. Joseph | Indiana | 18141 | 3082 | 84 |
390469 | 390469 | 2020-08-01 | St. Joseph | Michigan | 26149 | 551 | 7 |
386711 | 386711 | 2020-07-31 | St. Joseph | Indiana | 18141 | 3026 | 84 |
387252 | 387252 | 2020-07-31 | St. Joseph | Michigan | 26149 | 549 | 7 |
383493 | 383493 | 2020-07-30 | St. Joseph | Indiana | 18141 | 2978 | 83 |
384034 | 384034 | 2020-07-30 | St. Joseph | Michigan | 26149 | 551 | 7 |
380276 | 380276 | 2020-07-29 | St. Joseph | Indiana | 18141 | 2904 | 82 |
380817 | 380817 | 2020-07-29 | St. Joseph | Michigan | 26149 | 543 | 7 |
377059 | 377059 | 2020-07-28 | St. Joseph | Indiana | 18141 | 2865 | 81 |
377600 | 377600 | 2020-07-28 | St. Joseph | Michigan | 26149 | 536 | 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);