ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 18141 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
729733 | 729733 | 2020-11-14 | St. Joseph | Indiana | 18141 | 13883 | 203 |
726490 | 726490 | 2020-11-13 | St. Joseph | Indiana | 18141 | 13442 | 203 |
723247 | 723247 | 2020-11-12 | St. Joseph | Indiana | 18141 | 13172 | 202 |
720004 | 720004 | 2020-11-11 | St. Joseph | Indiana | 18141 | 12823 | 200 |
716761 | 716761 | 2020-11-10 | St. Joseph | Indiana | 18141 | 12598 | 200 |
713517 | 713517 | 2020-11-09 | St. Joseph | Indiana | 18141 | 12365 | 197 |
710273 | 710273 | 2020-11-08 | St. Joseph | Indiana | 18141 | 12114 | 196 |
707029 | 707029 | 2020-11-07 | St. Joseph | Indiana | 18141 | 11818 | 195 |
703786 | 703786 | 2020-11-06 | St. Joseph | Indiana | 18141 | 11547 | 194 |
700544 | 700544 | 2020-11-05 | St. Joseph | Indiana | 18141 | 11339 | 193 |
697300 | 697300 | 2020-11-04 | St. Joseph | Indiana | 18141 | 11161 | 192 |
694058 | 694058 | 2020-11-03 | St. Joseph | Indiana | 18141 | 10946 | 191 |
690815 | 690815 | 2020-11-02 | St. Joseph | Indiana | 18141 | 10810 | 190 |
687570 | 687570 | 2020-11-01 | St. Joseph | Indiana | 18141 | 10679 | 189 |
684326 | 684326 | 2020-10-31 | St. Joseph | Indiana | 18141 | 10491 | 187 |
681083 | 681083 | 2020-10-30 | St. Joseph | Indiana | 18141 | 10274 | 186 |
677840 | 677840 | 2020-10-29 | St. Joseph | Indiana | 18141 | 10114 | 182 |
674597 | 674597 | 2020-10-28 | St. Joseph | Indiana | 18141 | 9888 | 181 |
671355 | 671355 | 2020-10-27 | St. Joseph | Indiana | 18141 | 9747 | 179 |
668112 | 668112 | 2020-10-26 | St. Joseph | Indiana | 18141 | 9628 | 176 |
664868 | 664868 | 2020-10-25 | St. Joseph | Indiana | 18141 | 9554 | 174 |
661623 | 661623 | 2020-10-24 | St. Joseph | Indiana | 18141 | 9421 | 173 |
658379 | 658379 | 2020-10-23 | St. Joseph | Indiana | 18141 | 9299 | 170 |
655134 | 655134 | 2020-10-22 | St. Joseph | Indiana | 18141 | 9167 | 168 |
651889 | 651889 | 2020-10-21 | St. Joseph | Indiana | 18141 | 9007 | 168 |
648645 | 648645 | 2020-10-20 | St. Joseph | Indiana | 18141 | 8900 | 166 |
645400 | 645400 | 2020-10-19 | St. Joseph | Indiana | 18141 | 8811 | 164 |
642153 | 642153 | 2020-10-18 | St. Joseph | Indiana | 18141 | 8674 | 161 |
638906 | 638906 | 2020-10-17 | St. Joseph | Indiana | 18141 | 8583 | 161 |
635660 | 635660 | 2020-10-16 | St. Joseph | Indiana | 18141 | 8456 | 158 |
632414 | 632414 | 2020-10-15 | St. Joseph | Indiana | 18141 | 8341 | 156 |
629170 | 629170 | 2020-10-14 | St. Joseph | Indiana | 18141 | 8211 | 154 |
625927 | 625927 | 2020-10-13 | St. Joseph | Indiana | 18141 | 8108 | 152 |
622685 | 622685 | 2020-10-12 | St. Joseph | Indiana | 18141 | 7987 | 148 |
619441 | 619441 | 2020-10-11 | St. Joseph | Indiana | 18141 | 7871 | 147 |
616199 | 616199 | 2020-10-10 | St. Joseph | Indiana | 18141 | 7786 | 146 |
612958 | 612958 | 2020-10-09 | St. Joseph | Indiana | 18141 | 7640 | 143 |
609716 | 609716 | 2020-10-08 | St. Joseph | Indiana | 18141 | 7520 | 140 |
606473 | 606473 | 2020-10-07 | St. Joseph | Indiana | 18141 | 7438 | 136 |
603231 | 603231 | 2020-10-06 | St. Joseph | Indiana | 18141 | 7337 | 135 |
599988 | 599988 | 2020-10-05 | St. Joseph | Indiana | 18141 | 7252 | 131 |
596746 | 596746 | 2020-10-04 | St. Joseph | Indiana | 18141 | 7200 | 131 |
593504 | 593504 | 2020-10-03 | St. Joseph | Indiana | 18141 | 7119 | 129 |
590263 | 590263 | 2020-10-02 | St. Joseph | Indiana | 18141 | 6985 | 123 |
587022 | 587022 | 2020-10-01 | St. Joseph | Indiana | 18141 | 6876 | 123 |
583782 | 583782 | 2020-09-30 | St. Joseph | Indiana | 18141 | 6782 | 122 |
580543 | 580543 | 2020-09-29 | St. Joseph | Indiana | 18141 | 6698 | 121 |
577302 | 577302 | 2020-09-28 | St. Joseph | Indiana | 18141 | 6637 | 119 |
574060 | 574060 | 2020-09-27 | St. Joseph | Indiana | 18141 | 6594 | 116 |
570817 | 570817 | 2020-09-26 | St. Joseph | Indiana | 18141 | 6506 | 115 |
567575 | 567575 | 2020-09-25 | St. Joseph | Indiana | 18141 | 6410 | 112 |
564335 | 564335 | 2020-09-24 | St. Joseph | Indiana | 18141 | 6330 | 111 |
561095 | 561095 | 2020-09-23 | St. Joseph | Indiana | 18141 | 6244 | 109 |
557859 | 557859 | 2020-09-22 | St. Joseph | Indiana | 18141 | 6174 | 108 |
554622 | 554622 | 2020-09-21 | St. Joseph | Indiana | 18141 | 6127 | 106 |
551383 | 551383 | 2020-09-20 | St. Joseph | Indiana | 18141 | 6063 | 103 |
548144 | 548144 | 2020-09-19 | St. Joseph | Indiana | 18141 | 6025 | 103 |
544906 | 544906 | 2020-09-18 | St. Joseph | Indiana | 18141 | 5953 | 102 |
541670 | 541670 | 2020-09-17 | St. Joseph | Indiana | 18141 | 5885 | 102 |
538433 | 538433 | 2020-09-16 | St. Joseph | Indiana | 18141 | 5846 | 102 |
535197 | 535197 | 2020-09-15 | St. Joseph | Indiana | 18141 | 5822 | 102 |
531962 | 531962 | 2020-09-14 | St. Joseph | Indiana | 18141 | 5790 | 102 |
528725 | 528725 | 2020-09-13 | St. Joseph | Indiana | 18141 | 5741 | 102 |
525489 | 525489 | 2020-09-12 | St. Joseph | Indiana | 18141 | 5658 | 102 |
522253 | 522253 | 2020-09-11 | St. Joseph | Indiana | 18141 | 5619 | 102 |
519016 | 519016 | 2020-09-10 | St. Joseph | Indiana | 18141 | 5574 | 102 |
515781 | 515781 | 2020-09-09 | St. Joseph | Indiana | 18141 | 5559 | 102 |
512548 | 512548 | 2020-09-08 | St. Joseph | Indiana | 18141 | 5488 | 101 |
509315 | 509315 | 2020-09-07 | St. Joseph | Indiana | 18141 | 5472 | 101 |
506083 | 506083 | 2020-09-06 | St. Joseph | Indiana | 18141 | 5450 | 101 |
502849 | 502849 | 2020-09-05 | St. Joseph | Indiana | 18141 | 5409 | 101 |
499615 | 499615 | 2020-09-04 | St. Joseph | Indiana | 18141 | 5355 | 100 |
496382 | 496382 | 2020-09-03 | St. Joseph | Indiana | 18141 | 5311 | 100 |
493148 | 493148 | 2020-09-02 | St. Joseph | Indiana | 18141 | 5233 | 99 |
489915 | 489915 | 2020-09-01 | St. Joseph | Indiana | 18141 | 5197 | 99 |
486682 | 486682 | 2020-08-31 | St. Joseph | Indiana | 18141 | 5168 | 97 |
483447 | 483447 | 2020-08-30 | St. Joseph | Indiana | 18141 | 5117 | 97 |
480213 | 480213 | 2020-08-29 | St. Joseph | Indiana | 18141 | 5044 | 97 |
476980 | 476980 | 2020-08-28 | St. Joseph | Indiana | 18141 | 4986 | 97 |
473747 | 473747 | 2020-08-27 | St. Joseph | Indiana | 18141 | 4939 | 95 |
470515 | 470515 | 2020-08-26 | St. Joseph | Indiana | 18141 | 4840 | 95 |
467286 | 467286 | 2020-08-25 | St. Joseph | Indiana | 18141 | 4709 | 95 |
464057 | 464057 | 2020-08-24 | St. Joseph | Indiana | 18141 | 4557 | 93 |
460828 | 460828 | 2020-08-23 | St. Joseph | Indiana | 18141 | 4245 | 93 |
457601 | 457601 | 2020-08-22 | St. Joseph | Indiana | 18141 | 4194 | 93 |
454373 | 454373 | 2020-08-21 | St. Joseph | Indiana | 18141 | 4121 | 92 |
451145 | 451145 | 2020-08-20 | St. Joseph | Indiana | 18141 | 4057 | 92 |
447917 | 447917 | 2020-08-19 | St. Joseph | Indiana | 18141 | 3986 | 92 |
444690 | 444690 | 2020-08-18 | St. Joseph | Indiana | 18141 | 3953 | 92 |
441464 | 441464 | 2020-08-17 | St. Joseph | Indiana | 18141 | 3898 | 90 |
438238 | 438238 | 2020-08-16 | St. Joseph | Indiana | 18141 | 3857 | 88 |
435012 | 435012 | 2020-08-15 | St. Joseph | Indiana | 18141 | 3821 | 88 |
431787 | 431787 | 2020-08-14 | St. Joseph | Indiana | 18141 | 3778 | 88 |
428559 | 428559 | 2020-08-13 | St. Joseph | Indiana | 18141 | 3693 | 88 |
425335 | 425335 | 2020-08-12 | St. Joseph | Indiana | 18141 | 3622 | 88 |
422114 | 422114 | 2020-08-11 | St. Joseph | Indiana | 18141 | 3589 | 88 |
418891 | 418891 | 2020-08-10 | St. Joseph | Indiana | 18141 | 3557 | 87 |
415670 | 415670 | 2020-08-09 | St. Joseph | Indiana | 18141 | 3511 | 86 |
412450 | 412450 | 2020-08-08 | St. Joseph | Indiana | 18141 | 3434 | 86 |
409231 | 409231 | 2020-08-07 | St. Joseph | Indiana | 18141 | 3384 | 86 |
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);