ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 18097 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
729708 | 729708 | 2020-11-14 | Marion | Indiana | 18097 | 34807 | 872 |
726465 | 726465 | 2020-11-13 | Marion | Indiana | 18097 | 33752 | 869 |
723222 | 723222 | 2020-11-12 | Marion | Indiana | 18097 | 33135 | 867 |
719979 | 719979 | 2020-11-11 | Marion | Indiana | 18097 | 32204 | 863 |
716736 | 716736 | 2020-11-10 | Marion | Indiana | 18097 | 31495 | 861 |
713492 | 713492 | 2020-11-09 | Marion | Indiana | 18097 | 30956 | 857 |
710248 | 710248 | 2020-11-08 | Marion | Indiana | 18097 | 30597 | 857 |
707004 | 707004 | 2020-11-07 | Marion | Indiana | 18097 | 30171 | 856 |
703761 | 703761 | 2020-11-06 | Marion | Indiana | 18097 | 29621 | 854 |
700519 | 700519 | 2020-11-05 | Marion | Indiana | 18097 | 29219 | 853 |
697275 | 697275 | 2020-11-04 | Marion | Indiana | 18097 | 28839 | 851 |
694033 | 694033 | 2020-11-03 | Marion | Indiana | 18097 | 28446 | 850 |
690790 | 690790 | 2020-11-02 | Marion | Indiana | 18097 | 28165 | 850 |
687545 | 687545 | 2020-11-01 | Marion | Indiana | 18097 | 27861 | 850 |
684301 | 684301 | 2020-10-31 | Marion | Indiana | 18097 | 27627 | 850 |
681058 | 681058 | 2020-10-30 | Marion | Indiana | 18097 | 27279 | 850 |
677815 | 677815 | 2020-10-29 | Marion | Indiana | 18097 | 26979 | 850 |
674572 | 674572 | 2020-10-28 | Marion | Indiana | 18097 | 26620 | 848 |
671330 | 671330 | 2020-10-27 | Marion | Indiana | 18097 | 26427 | 849 |
668087 | 668087 | 2020-10-26 | Marion | Indiana | 18097 | 26227 | 846 |
664843 | 664843 | 2020-10-25 | Marion | Indiana | 18097 | 26043 | 846 |
661598 | 661598 | 2020-10-24 | Marion | Indiana | 18097 | 25863 | 845 |
658354 | 658354 | 2020-10-23 | Marion | Indiana | 18097 | 25565 | 843 |
655109 | 655109 | 2020-10-22 | Marion | Indiana | 18097 | 25324 | 839 |
651864 | 651864 | 2020-10-21 | Marion | Indiana | 18097 | 25079 | 838 |
648620 | 648620 | 2020-10-20 | Marion | Indiana | 18097 | 24871 | 837 |
645375 | 645375 | 2020-10-19 | Marion | Indiana | 18097 | 24738 | 834 |
642128 | 642128 | 2020-10-18 | Marion | Indiana | 18097 | 24584 | 833 |
638881 | 638881 | 2020-10-17 | Marion | Indiana | 18097 | 24464 | 833 |
635635 | 635635 | 2020-10-16 | Marion | Indiana | 18097 | 24208 | 830 |
632389 | 632389 | 2020-10-15 | Marion | Indiana | 18097 | 24026 | 829 |
629145 | 629145 | 2020-10-14 | Marion | Indiana | 18097 | 23785 | 827 |
625902 | 625902 | 2020-10-13 | Marion | Indiana | 18097 | 23686 | 825 |
622660 | 622660 | 2020-10-12 | Marion | Indiana | 18097 | 23487 | 824 |
619416 | 619416 | 2020-10-11 | Marion | Indiana | 18097 | 23351 | 824 |
616174 | 616174 | 2020-10-10 | Marion | Indiana | 18097 | 23211 | 824 |
612933 | 612933 | 2020-10-09 | Marion | Indiana | 18097 | 23040 | 824 |
609691 | 609691 | 2020-10-08 | Marion | Indiana | 18097 | 22862 | 824 |
606448 | 606448 | 2020-10-07 | Marion | Indiana | 18097 | 22732 | 825 |
603206 | 603206 | 2020-10-06 | Marion | Indiana | 18097 | 22612 | 823 |
599963 | 599963 | 2020-10-05 | Marion | Indiana | 18097 | 22512 | 822 |
596721 | 596721 | 2020-10-04 | Marion | Indiana | 18097 | 22454 | 822 |
593479 | 593479 | 2020-10-03 | Marion | Indiana | 18097 | 22287 | 822 |
590238 | 590238 | 2020-10-02 | Marion | Indiana | 18097 | 22122 | 822 |
586997 | 586997 | 2020-10-01 | Marion | Indiana | 18097 | 21953 | 822 |
583757 | 583757 | 2020-09-30 | Marion | Indiana | 18097 | 21843 | 821 |
580518 | 580518 | 2020-09-29 | Marion | Indiana | 18097 | 21735 | 821 |
577277 | 577277 | 2020-09-28 | Marion | Indiana | 18097 | 21673 | 819 |
574035 | 574035 | 2020-09-27 | Marion | Indiana | 18097 | 21574 | 818 |
570792 | 570792 | 2020-09-26 | Marion | Indiana | 18097 | 21493 | 818 |
567550 | 567550 | 2020-09-25 | Marion | Indiana | 18097 | 21367 | 817 |
564310 | 564310 | 2020-09-24 | Marion | Indiana | 18097 | 21238 | 816 |
561070 | 561070 | 2020-09-23 | Marion | Indiana | 18097 | 21105 | 812 |
557834 | 557834 | 2020-09-22 | Marion | Indiana | 18097 | 21001 | 810 |
554597 | 554597 | 2020-09-21 | Marion | Indiana | 18097 | 20915 | 809 |
551358 | 551358 | 2020-09-20 | Marion | Indiana | 18097 | 20868 | 809 |
548119 | 548119 | 2020-09-19 | Marion | Indiana | 18097 | 20814 | 809 |
544881 | 544881 | 2020-09-18 | Marion | Indiana | 18097 | 20676 | 809 |
541645 | 541645 | 2020-09-17 | Marion | Indiana | 18097 | 20508 | 808 |
538408 | 538408 | 2020-09-16 | Marion | Indiana | 18097 | 20416 | 808 |
535172 | 535172 | 2020-09-15 | Marion | Indiana | 18097 | 20363 | 807 |
531937 | 531937 | 2020-09-14 | Marion | Indiana | 18097 | 20314 | 806 |
528700 | 528700 | 2020-09-13 | Marion | Indiana | 18097 | 20233 | 805 |
525464 | 525464 | 2020-09-12 | Marion | Indiana | 18097 | 19822 | 805 |
522228 | 522228 | 2020-09-11 | Marion | Indiana | 18097 | 19717 | 805 |
518991 | 518991 | 2020-09-10 | Marion | Indiana | 18097 | 19641 | 804 |
515756 | 515756 | 2020-09-09 | Marion | Indiana | 18097 | 19555 | 803 |
512523 | 512523 | 2020-09-08 | Marion | Indiana | 18097 | 19474 | 801 |
509290 | 509290 | 2020-09-07 | Marion | Indiana | 18097 | 19439 | 801 |
506058 | 506058 | 2020-09-06 | Marion | Indiana | 18097 | 19363 | 801 |
502824 | 502824 | 2020-09-05 | Marion | Indiana | 18097 | 19240 | 801 |
499590 | 499590 | 2020-09-04 | Marion | Indiana | 18097 | 19123 | 801 |
496357 | 496357 | 2020-09-03 | Marion | Indiana | 18097 | 19004 | 800 |
493123 | 493123 | 2020-09-02 | Marion | Indiana | 18097 | 18888 | 800 |
489890 | 489890 | 2020-09-01 | Marion | Indiana | 18097 | 18734 | 798 |
486657 | 486657 | 2020-08-31 | Marion | Indiana | 18097 | 18631 | 799 |
483422 | 483422 | 2020-08-30 | Marion | Indiana | 18097 | 18500 | 799 |
480188 | 480188 | 2020-08-29 | Marion | Indiana | 18097 | 18377 | 799 |
476955 | 476955 | 2020-08-28 | Marion | Indiana | 18097 | 18252 | 797 |
473722 | 473722 | 2020-08-27 | Marion | Indiana | 18097 | 18141 | 797 |
470490 | 470490 | 2020-08-26 | Marion | Indiana | 18097 | 17997 | 796 |
467261 | 467261 | 2020-08-25 | Marion | Indiana | 18097 | 17854 | 796 |
464032 | 464032 | 2020-08-24 | Marion | Indiana | 18097 | 17757 | 794 |
460803 | 460803 | 2020-08-23 | Marion | Indiana | 18097 | 17587 | 794 |
457576 | 457576 | 2020-08-22 | Marion | Indiana | 18097 | 17502 | 794 |
454348 | 454348 | 2020-08-21 | Marion | Indiana | 18097 | 17362 | 794 |
451120 | 451120 | 2020-08-20 | Marion | Indiana | 18097 | 17228 | 792 |
447892 | 447892 | 2020-08-19 | Marion | Indiana | 18097 | 17104 | 790 |
444665 | 444665 | 2020-08-18 | Marion | Indiana | 18097 | 17027 | 788 |
441439 | 441439 | 2020-08-17 | Marion | Indiana | 18097 | 16863 | 785 |
438213 | 438213 | 2020-08-16 | Marion | Indiana | 18097 | 16796 | 785 |
434987 | 434987 | 2020-08-15 | Marion | Indiana | 18097 | 16694 | 785 |
431762 | 431762 | 2020-08-14 | Marion | Indiana | 18097 | 16592 | 784 |
428534 | 428534 | 2020-08-13 | Marion | Indiana | 18097 | 16457 | 783 |
425310 | 425310 | 2020-08-12 | Marion | Indiana | 18097 | 16346 | 781 |
422089 | 422089 | 2020-08-11 | Marion | Indiana | 18097 | 16239 | 780 |
418866 | 418866 | 2020-08-10 | Marion | Indiana | 18097 | 16113 | 775 |
415645 | 415645 | 2020-08-09 | Marion | Indiana | 18097 | 16010 | 775 |
412425 | 412425 | 2020-08-08 | Marion | Indiana | 18097 | 15849 | 773 |
409206 | 409206 | 2020-08-07 | Marion | Indiana | 18097 | 15651 | 773 |
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);