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)
Suggested facets: date, date (date)
deaths 413 ✖
- 11 49
- 1 40
- 104 40
- 101 32
- 3 27
- 0 26
- 100 24
- 204 21
- 2 19
- 121 18
- 208 17
- 5 15
- 93 15
- 205 15
- 207 15
- 6 14
- 12 14
- 84 14
- 87 14
- 585 14
- 586 14
- 863 14
- 4 13
- 39 13
- 94 13
- 102 13
- 587 13
- 10 11
- 25 11
- 99 11
- 33 10
- 81 10
- 91 10
- 582 10
- 584 10
- 74 9
- 85 9
- 92 9
- 103 9
- 583 9
- 871 9
- 7 8
- 8 8
- 75 8
- 88 8
- 95 8
- 115 8
- 196 8
- 588 8
- 31 7
- 97 7
- 98 7
- 157 7
- 168 7
- 199 7
- 568 7
- 572 7
- 870 7
- 873 7
- 37 6
- 58 6
- 71 6
- 106 6
- 111 6
- 122 6
- 136 6
- 152 6
- 179 6
- 181 6
- 186 6
- 189 6
- 539 6
- 576 6
- 617 6
- 640 6
- 641 6
- 657 6
- 849 6
- 30 5
- 43 5
- 47 5
- 50 5
- 80 5
- 86 5
- 90 5
- 110 5
- 117 5
- 132 5
- 160 5
- 172 5
- 191 5
- 528 5
- 570 5
- 597 5
- 602 5
- 608 5
- 705 5
- 872 5
- 874 5
- 24 4
- 48 4
- 49 4
- 55 4
- 63 4
- 64 4
- 67 4
- 70 4
- 73 4
- 77 4
- 78 4
- 96 4
- 123 4
- 192 4
- 537 4
- 548 4
- 556 4
- 567 4
- 600 4
- 625 4
- 721 4
- 786 4
- 825 4
- 859 4
- 16 3
- 17 3
- 22 3
- 27 3
- 28 3
- 29 3
- 35 3
- 41 3
- 45 3
- 65 3
- 79 3
- 82 3
- 108 3
- 112 3
- 128 3
- 142 3
- 164 3
- 367 3
- 385 3
- 389 3
- 412 3
- 519 3
- 531 3
- 532 3
- 538 3
- 551 3
- 561 3
- 563 3
- 591 3
- 611 3
- 613 3
- 633 3
- 648 3
- 653 3
- 668 3
- 681 3
- 696 3
- 745 3
- 768 3
- 794 3
- 813 3
- 837 3
- 852 3
- 865 3
- 869 3
- 9 2
- 13 2
- 15 2
- 21 2
- 23 2
- 26 2
- 44 2
- 59 2
- 61 2
- 62 2
- 68 2
- 89 2
- 105 2
- 113 2
- 118 2
- 120 2
- 126 2
- 130 2
- 131 2
- 133 2
- 134 2
- 139 2
- 144 2
- 151 2
- 161 2
- 162 2
- 171 2
- 178 2
- 180 2
- 183 2
- 188 2
- 200 2
- 203 2
- 245 2
- 304 2
- 345 2
- 377 2
- 388 2
- 398 2
- 400 2
- 401 2
- 510 2
- 513 2
- 517 2
- 530 2
- 535 2
- 536 2
- 543 2
- 554 2
- 559 2
- 566 2
- 571 2
- 573 2
- 578 2
- 579 2
- 595 2
- 599 2
- 601 2
- 644 2
- 651 2
- 664 2
- 820 2
- 841 2
- 853 2
- 861 2
- 866 2
- 867 2
- 14 1
- 19 1
- 20 1
- 32 1
- 36 1
- 38 1
- 40 1
- 56 1
- 60 1
- 69 1
- 76 1
- 83 1
- 109 1
- 116 1
- 119 1
- 129 1
- 135 1
- 140 1
- 143 1
- 146 1
- 147 1
- 148 1
- 154 1
- 156 1
- 158 1
- 166 1
- 170 1
- 173 1
- 174 1
- 176 1
- 182 1
- 187 1
- 190 1
- 193 1
- 194 1
- 195 1
- 197 1
- 202 1
- 209 1
- 214 1
- 222 1
- 225 1
- 226 1
- 228 1
- 231 1
- 234 1
- 240 1
- 246 1
- 248 1
- 250 1
- 253 1
- 257 1
- 259 1
- 263 1
- 270 1
- 273 1
- 277 1
- 282 1
- 287 1
- 292 1
- 294 1
- 299 1
- 307 1
- 309 1
- 316 1
- 318 1
- 320 1
- 321 1
- 323 1
- 335 1
- 340 1
- 350 1
- 352 1
- 354 1
- 358 1
- 361 1
- 370 1
- 371 1
- 375 1
- 379 1
- 391 1
- 392 1
- 402 1
- 403 1
- 405 1
- 407 1
- 413 1
- 416 1
- 419 1
- 502 1
- 504 1
- 506 1
- 507 1
- 515 1
- 516 1
- 522 1
- 524 1
- 525 1
- 529 1
- 533 1
- 541 1
- 542 1
- 544 1
- 545 1
- 546 1
- 547 1
- 552 1
- 555 1
- 558 1
- 564 1
- 575 1
- 580 1
- 581 1
- 589 1
- 592 1
- 604 1
- 605 1
- 610 1
- 615 1
- 620 1
- 621 1
- 622 1
- 624 1
- 626 1
- 629 1
- 631 1
- 635 1
- 637 1
- 639 1
- 647 1
- 650 1
- 652 1
- 655 1
- 658 1
- 662 1
- 669 1
- 671 1
- 676 1
- 678 1
- 683 1
- 689 1
- 694 1
- 695 1
- 697 1
- 701 1
- 713 1
- 719 1
- 720 1
- 724 1
- 730 1
- 731 1
- 736 1
- 755 1
- 756 1
- 763 1
- 765 1
- 770 1
- 774 1
- 779 1
- 783 1
- 788 1
- 791 1
- 792 1
- 795 1
- 803 1
- 807 1
- 810 1
- 817 1
- 822 1
- 827 1
- 830 1
- 833 1
- 843 1
- 848 1
- 850 1
- 854 1
- 855 1
- 860 1
county 1
- St. Joseph · 1,569 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500353 | 2500353 | 2022-05-13 | St. Joseph | Indiana | 18141 | 71793 | 874 |
2500898 | 2500898 | 2022-05-13 | St. Joseph | Michigan | 26149 | 13812 | 208 |
2497095 | 2497095 | 2022-05-12 | St. Joseph | Indiana | 18141 | 71645 | 874 |
2497640 | 2497640 | 2022-05-12 | St. Joseph | Michigan | 26149 | 13812 | 208 |
2493837 | 2493837 | 2022-05-11 | St. Joseph | Indiana | 18141 | 71645 | 874 |
2494382 | 2494382 | 2022-05-11 | St. Joseph | Michigan | 26149 | 13812 | 208 |
2490579 | 2490579 | 2022-05-10 | St. Joseph | Indiana | 18141 | 71550 | 874 |
2491124 | 2491124 | 2022-05-10 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2487322 | 2487322 | 2022-05-09 | St. Joseph | Indiana | 18141 | 71550 | 874 |
2487867 | 2487867 | 2022-05-09 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2484064 | 2484064 | 2022-05-08 | St. Joseph | Indiana | 18141 | 71349 | 873 |
2484609 | 2484609 | 2022-05-08 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2480806 | 2480806 | 2022-05-07 | St. Joseph | Indiana | 18141 | 71349 | 873 |
2481351 | 2481351 | 2022-05-07 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2477548 | 2477548 | 2022-05-06 | St. Joseph | Indiana | 18141 | 71349 | 873 |
2478093 | 2478093 | 2022-05-06 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2474290 | 2474290 | 2022-05-05 | St. Joseph | Indiana | 18141 | 71349 | 873 |
2474835 | 2474835 | 2022-05-05 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2471033 | 2471033 | 2022-05-04 | St. Joseph | Indiana | 18141 | 71349 | 873 |
2471578 | 2471578 | 2022-05-04 | St. Joseph | Michigan | 26149 | 13757 | 208 |
2467777 | 2467777 | 2022-05-03 | St. Joseph | Indiana | 18141 | 71272 | 873 |
2468322 | 2468322 | 2022-05-03 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2464522 | 2464522 | 2022-05-02 | St. Joseph | Indiana | 18141 | 71272 | 873 |
2465067 | 2465067 | 2022-05-02 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2461266 | 2461266 | 2022-05-01 | St. Joseph | Indiana | 18141 | 71191 | 872 |
2461811 | 2461811 | 2022-05-01 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2458010 | 2458010 | 2022-04-30 | St. Joseph | Indiana | 18141 | 71191 | 872 |
2458555 | 2458555 | 2022-04-30 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2454754 | 2454754 | 2022-04-29 | St. Joseph | Indiana | 18141 | 71191 | 872 |
2455299 | 2455299 | 2022-04-29 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2451498 | 2451498 | 2022-04-28 | St. Joseph | Indiana | 18141 | 71095 | 872 |
2452043 | 2452043 | 2022-04-28 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2448242 | 2448242 | 2022-04-27 | St. Joseph | Indiana | 18141 | 71095 | 872 |
2448787 | 2448787 | 2022-04-27 | St. Joseph | Michigan | 26149 | 13736 | 208 |
2444986 | 2444986 | 2022-04-26 | St. Joseph | Indiana | 18141 | 71010 | 871 |
2445531 | 2445531 | 2022-04-26 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2441730 | 2441730 | 2022-04-25 | St. Joseph | Indiana | 18141 | 71010 | 871 |
2442275 | 2442275 | 2022-04-25 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2438474 | 2438474 | 2022-04-24 | St. Joseph | Indiana | 18141 | 70875 | 871 |
2439019 | 2439019 | 2022-04-24 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2435218 | 2435218 | 2022-04-23 | St. Joseph | Indiana | 18141 | 70875 | 871 |
2435763 | 2435763 | 2022-04-23 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2431962 | 2431962 | 2022-04-22 | St. Joseph | Indiana | 18141 | 70875 | 871 |
2432507 | 2432507 | 2022-04-22 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2428706 | 2428706 | 2022-04-21 | St. Joseph | Indiana | 18141 | 70806 | 871 |
2429251 | 2429251 | 2022-04-21 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2425450 | 2425450 | 2022-04-20 | St. Joseph | Indiana | 18141 | 70806 | 871 |
2425995 | 2425995 | 2022-04-20 | St. Joseph | Michigan | 26149 | 13715 | 207 |
2422194 | 2422194 | 2022-04-19 | St. Joseph | Indiana | 18141 | 70762 | 871 |
2422739 | 2422739 | 2022-04-19 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2418938 | 2418938 | 2022-04-18 | St. Joseph | Indiana | 18141 | 70762 | 871 |
2419483 | 2419483 | 2022-04-18 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2415682 | 2415682 | 2022-04-17 | St. Joseph | Indiana | 18141 | 70681 | 870 |
2416227 | 2416227 | 2022-04-17 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2412426 | 2412426 | 2022-04-16 | St. Joseph | Indiana | 18141 | 70681 | 870 |
2412971 | 2412971 | 2022-04-16 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2409170 | 2409170 | 2022-04-15 | St. Joseph | Indiana | 18141 | 70681 | 870 |
2409715 | 2409715 | 2022-04-15 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2405914 | 2405914 | 2022-04-14 | St. Joseph | Indiana | 18141 | 70681 | 870 |
2406459 | 2406459 | 2022-04-14 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2402659 | 2402659 | 2022-04-13 | St. Joseph | Indiana | 18141 | 70681 | 870 |
2403203 | 2403203 | 2022-04-13 | St. Joseph | Michigan | 26149 | 13692 | 207 |
2399404 | 2399404 | 2022-04-12 | St. Joseph | Indiana | 18141 | 70646 | 870 |
2399949 | 2399949 | 2022-04-12 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2396149 | 2396149 | 2022-04-11 | St. Joseph | Indiana | 18141 | 70646 | 870 |
2396693 | 2396693 | 2022-04-11 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2392893 | 2392893 | 2022-04-10 | St. Joseph | Indiana | 18141 | 70612 | 869 |
2393438 | 2393438 | 2022-04-10 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2389637 | 2389637 | 2022-04-09 | St. Joseph | Indiana | 18141 | 70612 | 869 |
2390182 | 2390182 | 2022-04-09 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2386382 | 2386382 | 2022-04-08 | St. Joseph | Indiana | 18141 | 70612 | 869 |
2386926 | 2386926 | 2022-04-08 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2383127 | 2383127 | 2022-04-07 | St. Joseph | Indiana | 18141 | 70589 | 867 |
2383671 | 2383671 | 2022-04-07 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2379872 | 2379872 | 2022-04-06 | St. Joseph | Indiana | 18141 | 70589 | 867 |
2380416 | 2380416 | 2022-04-06 | St. Joseph | Michigan | 26149 | 13667 | 204 |
2376618 | 2376618 | 2022-04-05 | St. Joseph | Indiana | 18141 | 70568 | 866 |
2377161 | 2377161 | 2022-04-05 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2373366 | 2373366 | 2022-04-04 | St. Joseph | Indiana | 18141 | 70568 | 866 |
2373909 | 2373909 | 2022-04-04 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2370113 | 2370113 | 2022-04-03 | St. Joseph | Indiana | 18141 | 70541 | 865 |
2370656 | 2370656 | 2022-04-03 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2366860 | 2366860 | 2022-04-02 | St. Joseph | Indiana | 18141 | 70541 | 865 |
2367403 | 2367403 | 2022-04-02 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2363607 | 2363607 | 2022-04-01 | St. Joseph | Indiana | 18141 | 70541 | 865 |
2364150 | 2364150 | 2022-04-01 | St. Joseph | Michigan | 26149 | 13655 | 204 |
2360353 | 2360353 | 2022-03-31 | St. Joseph | Indiana | 18141 | 70506 | 863 |
2360896 | 2360896 | 2022-03-31 | St. Joseph | Michigan | 26149 | 13651 | 204 |
2357099 | 2357099 | 2022-03-30 | St. Joseph | Indiana | 18141 | 70506 | 863 |
2357642 | 2357642 | 2022-03-30 | St. Joseph | Michigan | 26149 | 13651 | 204 |
2353846 | 2353846 | 2022-03-29 | St. Joseph | Indiana | 18141 | 70553 | 863 |
2354389 | 2354389 | 2022-03-29 | St. Joseph | Michigan | 26149 | 13643 | 205 |
2350594 | 2350594 | 2022-03-28 | St. Joseph | Indiana | 18141 | 70543 | 863 |
2351137 | 2351137 | 2022-03-28 | St. Joseph | Michigan | 26149 | 13643 | 205 |
2347341 | 2347341 | 2022-03-27 | St. Joseph | Indiana | 18141 | 70522 | 863 |
2347884 | 2347884 | 2022-03-27 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2344088 | 2344088 | 2022-03-26 | St. Joseph | Indiana | 18141 | 70522 | 863 |
2344631 | 2344631 | 2022-03-26 | St. Joseph | Michigan | 26149 | 13641 | 205 |
2340835 | 2340835 | 2022-03-25 | St. Joseph | Indiana | 18141 | 70522 | 863 |
2341378 | 2341378 | 2022-03-25 | St. Joseph | Michigan | 26149 | 13641 | 205 |
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);