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 |
---|---|---|---|---|---|---|---|
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 |
405986 | 405986 | 2020-08-06 | Marion | Indiana | 18097 | 15470 | 771 |
402768 | 402768 | 2020-08-05 | Marion | Indiana | 18097 | 15296 | 772 |
399552 | 399552 | 2020-08-04 | Marion | Indiana | 18097 | 15173 | 772 |
396336 | 396336 | 2020-08-03 | Marion | Indiana | 18097 | 15007 | 767 |
393120 | 393120 | 2020-08-02 | Marion | Indiana | 18097 | 14853 | 767 |
389903 | 389903 | 2020-08-01 | Marion | Indiana | 18097 | 14721 | 766 |
386686 | 386686 | 2020-07-31 | Marion | Indiana | 18097 | 14575 | 766 |
383468 | 383468 | 2020-07-30 | Marion | Indiana | 18097 | 14412 | 765 |
380251 | 380251 | 2020-07-29 | Marion | Indiana | 18097 | 14237 | 762 |
377034 | 377034 | 2020-07-28 | Marion | Indiana | 18097 | 14094 | 761 |
373819 | 373819 | 2020-07-27 | Marion | Indiana | 18097 | 13953 | 760 |
370607 | 370607 | 2020-07-26 | Marion | Indiana | 18097 | 13835 | 759 |
367397 | 367397 | 2020-07-25 | Marion | Indiana | 18097 | 13685 | 759 |
364190 | 364190 | 2020-07-24 | Marion | Indiana | 18097 | 13545 | 758 |
360983 | 360983 | 2020-07-23 | Marion | Indiana | 18097 | 13380 | 758 |
357778 | 357778 | 2020-07-22 | Marion | Indiana | 18097 | 13228 | 758 |
354576 | 354576 | 2020-07-21 | Marion | Indiana | 18097 | 13124 | 755 |
351374 | 351374 | 2020-07-20 | Marion | Indiana | 18097 | 12976 | 752 |
348174 | 348174 | 2020-07-19 | Marion | Indiana | 18097 | 12883 | 752 |
344973 | 344973 | 2020-07-18 | Marion | Indiana | 18097 | 12742 | 752 |
341773 | 341773 | 2020-07-17 | Marion | Indiana | 18097 | 12617 | 748 |
338577 | 338577 | 2020-07-16 | Marion | Indiana | 18097 | 12494 | 747 |
335381 | 335381 | 2020-07-15 | Marion | Indiana | 18097 | 12409 | 745 |
332188 | 332188 | 2020-07-14 | Marion | Indiana | 18097 | 12323 | 743 |
329001 | 329001 | 2020-07-13 | Marion | Indiana | 18097 | 12243 | 739 |
325815 | 325815 | 2020-07-12 | Marion | Indiana | 18097 | 12206 | 739 |
322634 | 322634 | 2020-07-11 | Marion | Indiana | 18097 | 12151 | 739 |
319455 | 319455 | 2020-07-10 | Marion | Indiana | 18097 | 12052 | 738 |
316282 | 316282 | 2020-07-09 | Marion | Indiana | 18097 | 11943 | 736 |
313108 | 313108 | 2020-07-08 | Marion | Indiana | 18097 | 11891 | 735 |
309938 | 309938 | 2020-07-07 | Marion | Indiana | 18097 | 11854 | 735 |
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);