ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Elkhart" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
729679 | 729679 | 2020-11-14 | Elkhart | Indiana | 18039 | 14073 | 190 |
726436 | 726436 | 2020-11-13 | Elkhart | Indiana | 18039 | 13622 | 189 |
723193 | 723193 | 2020-11-12 | Elkhart | Indiana | 18039 | 13341 | 186 |
719950 | 719950 | 2020-11-11 | Elkhart | Indiana | 18039 | 12930 | 184 |
716707 | 716707 | 2020-11-10 | Elkhart | Indiana | 18039 | 12725 | 181 |
713463 | 713463 | 2020-11-09 | Elkhart | Indiana | 18039 | 12544 | 177 |
710219 | 710219 | 2020-11-08 | Elkhart | Indiana | 18039 | 12228 | 176 |
706975 | 706975 | 2020-11-07 | Elkhart | Indiana | 18039 | 11896 | 173 |
703732 | 703732 | 2020-11-06 | Elkhart | Indiana | 18039 | 11542 | 167 |
700490 | 700490 | 2020-11-05 | Elkhart | Indiana | 18039 | 11280 | 163 |
697246 | 697246 | 2020-11-04 | Elkhart | Indiana | 18039 | 11062 | 162 |
694004 | 694004 | 2020-11-03 | Elkhart | Indiana | 18039 | 10833 | 162 |
690761 | 690761 | 2020-11-02 | Elkhart | Indiana | 18039 | 10599 | 157 |
687516 | 687516 | 2020-11-01 | Elkhart | Indiana | 18039 | 10404 | 156 |
684272 | 684272 | 2020-10-31 | Elkhart | Indiana | 18039 | 10224 | 155 |
681029 | 681029 | 2020-10-30 | Elkhart | Indiana | 18039 | 10057 | 152 |
677786 | 677786 | 2020-10-29 | Elkhart | Indiana | 18039 | 9875 | 150 |
674543 | 674543 | 2020-10-28 | Elkhart | Indiana | 18039 | 9642 | 149 |
671301 | 671301 | 2020-10-27 | Elkhart | Indiana | 18039 | 9495 | 146 |
668058 | 668058 | 2020-10-26 | Elkhart | Indiana | 18039 | 9363 | 142 |
664814 | 664814 | 2020-10-25 | Elkhart | Indiana | 18039 | 9248 | 141 |
661569 | 661569 | 2020-10-24 | Elkhart | Indiana | 18039 | 9118 | 141 |
658325 | 658325 | 2020-10-23 | Elkhart | Indiana | 18039 | 8982 | 139 |
655080 | 655080 | 2020-10-22 | Elkhart | Indiana | 18039 | 8851 | 139 |
651835 | 651835 | 2020-10-21 | Elkhart | Indiana | 18039 | 8623 | 136 |
648591 | 648591 | 2020-10-20 | Elkhart | Indiana | 18039 | 8562 | 136 |
645346 | 645346 | 2020-10-19 | Elkhart | Indiana | 18039 | 8464 | 136 |
642099 | 642099 | 2020-10-18 | Elkhart | Indiana | 18039 | 8374 | 134 |
638852 | 638852 | 2020-10-17 | Elkhart | Indiana | 18039 | 8248 | 133 |
635606 | 635606 | 2020-10-16 | Elkhart | Indiana | 18039 | 8132 | 132 |
632360 | 632360 | 2020-10-15 | Elkhart | Indiana | 18039 | 8018 | 130 |
629116 | 629116 | 2020-10-14 | Elkhart | Indiana | 18039 | 7867 | 130 |
625873 | 625873 | 2020-10-13 | Elkhart | Indiana | 18039 | 7826 | 130 |
622631 | 622631 | 2020-10-12 | Elkhart | Indiana | 18039 | 7740 | 130 |
619387 | 619387 | 2020-10-11 | Elkhart | Indiana | 18039 | 7634 | 129 |
616145 | 616145 | 2020-10-10 | Elkhart | Indiana | 18039 | 7539 | 129 |
612904 | 612904 | 2020-10-09 | Elkhart | Indiana | 18039 | 7469 | 128 |
609662 | 609662 | 2020-10-08 | Elkhart | Indiana | 18039 | 7399 | 124 |
606419 | 606419 | 2020-10-07 | Elkhart | Indiana | 18039 | 7270 | 122 |
603177 | 603177 | 2020-10-06 | Elkhart | Indiana | 18039 | 7184 | 121 |
599934 | 599934 | 2020-10-05 | Elkhart | Indiana | 18039 | 7134 | 120 |
596692 | 596692 | 2020-10-04 | Elkhart | Indiana | 18039 | 7108 | 118 |
593450 | 593450 | 2020-10-03 | Elkhart | Indiana | 18039 | 7054 | 118 |
590209 | 590209 | 2020-10-02 | Elkhart | Indiana | 18039 | 6969 | 118 |
586968 | 586968 | 2020-10-01 | Elkhart | Indiana | 18039 | 6894 | 118 |
583728 | 583728 | 2020-09-30 | Elkhart | Indiana | 18039 | 6849 | 116 |
580489 | 580489 | 2020-09-29 | Elkhart | Indiana | 18039 | 6828 | 116 |
577248 | 577248 | 2020-09-28 | Elkhart | Indiana | 18039 | 6801 | 115 |
574006 | 574006 | 2020-09-27 | Elkhart | Indiana | 18039 | 6761 | 115 |
570763 | 570763 | 2020-09-26 | Elkhart | Indiana | 18039 | 6717 | 115 |
567521 | 567521 | 2020-09-25 | Elkhart | Indiana | 18039 | 6622 | 114 |
564281 | 564281 | 2020-09-24 | Elkhart | Indiana | 18039 | 6571 | 113 |
561041 | 561041 | 2020-09-23 | Elkhart | Indiana | 18039 | 6532 | 113 |
557805 | 557805 | 2020-09-22 | Elkhart | Indiana | 18039 | 6509 | 113 |
554568 | 554568 | 2020-09-21 | Elkhart | Indiana | 18039 | 6481 | 113 |
551329 | 551329 | 2020-09-20 | Elkhart | Indiana | 18039 | 6462 | 113 |
548090 | 548090 | 2020-09-19 | Elkhart | Indiana | 18039 | 6415 | 112 |
544852 | 544852 | 2020-09-18 | Elkhart | Indiana | 18039 | 6363 | 111 |
541616 | 541616 | 2020-09-17 | Elkhart | Indiana | 18039 | 6293 | 110 |
538379 | 538379 | 2020-09-16 | Elkhart | Indiana | 18039 | 6234 | 110 |
535143 | 535143 | 2020-09-15 | Elkhart | Indiana | 18039 | 6212 | 109 |
531908 | 531908 | 2020-09-14 | Elkhart | Indiana | 18039 | 6161 | 108 |
528671 | 528671 | 2020-09-13 | Elkhart | Indiana | 18039 | 6136 | 108 |
525435 | 525435 | 2020-09-12 | Elkhart | Indiana | 18039 | 6090 | 108 |
522199 | 522199 | 2020-09-11 | Elkhart | Indiana | 18039 | 6032 | 107 |
518962 | 518962 | 2020-09-10 | Elkhart | Indiana | 18039 | 5991 | 106 |
515727 | 515727 | 2020-09-09 | Elkhart | Indiana | 18039 | 5967 | 105 |
512494 | 512494 | 2020-09-08 | Elkhart | Indiana | 18039 | 5929 | 105 |
509261 | 509261 | 2020-09-07 | Elkhart | Indiana | 18039 | 5916 | 103 |
506029 | 506029 | 2020-09-06 | Elkhart | Indiana | 18039 | 5906 | 103 |
502795 | 502795 | 2020-09-05 | Elkhart | Indiana | 18039 | 5883 | 103 |
499561 | 499561 | 2020-09-04 | Elkhart | Indiana | 18039 | 5838 | 103 |
496328 | 496328 | 2020-09-03 | Elkhart | Indiana | 18039 | 5793 | 102 |
493094 | 493094 | 2020-09-02 | Elkhart | Indiana | 18039 | 5722 | 102 |
489861 | 489861 | 2020-09-01 | Elkhart | Indiana | 18039 | 5702 | 102 |
486628 | 486628 | 2020-08-31 | Elkhart | Indiana | 18039 | 5693 | 102 |
483393 | 483393 | 2020-08-30 | Elkhart | Indiana | 18039 | 5668 | 102 |
480159 | 480159 | 2020-08-29 | Elkhart | Indiana | 18039 | 5645 | 102 |
476926 | 476926 | 2020-08-28 | Elkhart | Indiana | 18039 | 5603 | 102 |
473693 | 473693 | 2020-08-27 | Elkhart | Indiana | 18039 | 5576 | 101 |
470461 | 470461 | 2020-08-26 | Elkhart | Indiana | 18039 | 5530 | 101 |
467232 | 467232 | 2020-08-25 | Elkhart | Indiana | 18039 | 5489 | 101 |
464003 | 464003 | 2020-08-24 | Elkhart | Indiana | 18039 | 5475 | 99 |
460774 | 460774 | 2020-08-23 | Elkhart | Indiana | 18039 | 5431 | 99 |
457547 | 457547 | 2020-08-22 | Elkhart | Indiana | 18039 | 5405 | 99 |
454319 | 454319 | 2020-08-21 | Elkhart | Indiana | 18039 | 5356 | 99 |
451091 | 451091 | 2020-08-20 | Elkhart | Indiana | 18039 | 5329 | 97 |
447863 | 447863 | 2020-08-19 | Elkhart | Indiana | 18039 | 5300 | 97 |
444636 | 444636 | 2020-08-18 | Elkhart | Indiana | 18039 | 5280 | 97 |
441410 | 441410 | 2020-08-17 | Elkhart | Indiana | 18039 | 5243 | 96 |
438184 | 438184 | 2020-08-16 | Elkhart | Indiana | 18039 | 5210 | 96 |
434958 | 434958 | 2020-08-15 | Elkhart | Indiana | 18039 | 5192 | 96 |
431733 | 431733 | 2020-08-14 | Elkhart | Indiana | 18039 | 5141 | 95 |
428505 | 428505 | 2020-08-13 | Elkhart | Indiana | 18039 | 5082 | 91 |
425281 | 425281 | 2020-08-12 | Elkhart | Indiana | 18039 | 5046 | 91 |
422060 | 422060 | 2020-08-11 | Elkhart | Indiana | 18039 | 5016 | 89 |
418837 | 418837 | 2020-08-10 | Elkhart | Indiana | 18039 | 4973 | 89 |
415616 | 415616 | 2020-08-09 | Elkhart | Indiana | 18039 | 4933 | 88 |
412396 | 412396 | 2020-08-08 | Elkhart | Indiana | 18039 | 4891 | 88 |
409177 | 409177 | 2020-08-07 | Elkhart | Indiana | 18039 | 4850 | 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);