ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 18113 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635643 | 635643 | 2020-10-16 | Noble | Indiana | 18113 | 1078 | 34 |
632397 | 632397 | 2020-10-15 | Noble | Indiana | 18113 | 1062 | 34 |
629153 | 629153 | 2020-10-14 | Noble | Indiana | 18113 | 1039 | 34 |
625910 | 625910 | 2020-10-13 | Noble | Indiana | 18113 | 1032 | 34 |
622668 | 622668 | 2020-10-12 | Noble | Indiana | 18113 | 1021 | 34 |
619424 | 619424 | 2020-10-11 | Noble | Indiana | 18113 | 1006 | 34 |
616182 | 616182 | 2020-10-10 | Noble | Indiana | 18113 | 1000 | 34 |
612941 | 612941 | 2020-10-09 | Noble | Indiana | 18113 | 985 | 34 |
609699 | 609699 | 2020-10-08 | Noble | Indiana | 18113 | 976 | 34 |
606456 | 606456 | 2020-10-07 | Noble | Indiana | 18113 | 971 | 33 |
603214 | 603214 | 2020-10-06 | Noble | Indiana | 18113 | 961 | 33 |
599971 | 599971 | 2020-10-05 | Noble | Indiana | 18113 | 959 | 33 |
596729 | 596729 | 2020-10-04 | Noble | Indiana | 18113 | 956 | 33 |
593487 | 593487 | 2020-10-03 | Noble | Indiana | 18113 | 954 | 33 |
590246 | 590246 | 2020-10-02 | Noble | Indiana | 18113 | 949 | 33 |
587005 | 587005 | 2020-10-01 | Noble | Indiana | 18113 | 940 | 33 |
583765 | 583765 | 2020-09-30 | Noble | Indiana | 18113 | 939 | 33 |
580526 | 580526 | 2020-09-29 | Noble | Indiana | 18113 | 933 | 33 |
577285 | 577285 | 2020-09-28 | Noble | Indiana | 18113 | 935 | 33 |
574043 | 574043 | 2020-09-27 | Noble | Indiana | 18113 | 929 | 33 |
570800 | 570800 | 2020-09-26 | Noble | Indiana | 18113 | 919 | 33 |
567558 | 567558 | 2020-09-25 | Noble | Indiana | 18113 | 912 | 33 |
564318 | 564318 | 2020-09-24 | Noble | Indiana | 18113 | 904 | 33 |
561078 | 561078 | 2020-09-23 | Noble | Indiana | 18113 | 898 | 33 |
557842 | 557842 | 2020-09-22 | Noble | Indiana | 18113 | 895 | 33 |
554605 | 554605 | 2020-09-21 | Noble | Indiana | 18113 | 890 | 33 |
551366 | 551366 | 2020-09-20 | Noble | Indiana | 18113 | 885 | 33 |
548127 | 548127 | 2020-09-19 | Noble | Indiana | 18113 | 880 | 33 |
544889 | 544889 | 2020-09-18 | Noble | Indiana | 18113 | 873 | 33 |
541653 | 541653 | 2020-09-17 | Noble | Indiana | 18113 | 868 | 33 |
538416 | 538416 | 2020-09-16 | Noble | Indiana | 18113 | 862 | 33 |
535180 | 535180 | 2020-09-15 | Noble | Indiana | 18113 | 862 | 33 |
531945 | 531945 | 2020-09-14 | Noble | Indiana | 18113 | 858 | 33 |
528708 | 528708 | 2020-09-13 | Noble | Indiana | 18113 | 854 | 33 |
525472 | 525472 | 2020-09-12 | Noble | Indiana | 18113 | 852 | 33 |
522236 | 522236 | 2020-09-11 | Noble | Indiana | 18113 | 854 | 33 |
518999 | 518999 | 2020-09-10 | Noble | Indiana | 18113 | 848 | 33 |
515764 | 515764 | 2020-09-09 | Noble | Indiana | 18113 | 845 | 33 |
512531 | 512531 | 2020-09-08 | Noble | Indiana | 18113 | 845 | 32 |
509298 | 509298 | 2020-09-07 | Noble | Indiana | 18113 | 842 | 32 |
506066 | 506066 | 2020-09-06 | Noble | Indiana | 18113 | 839 | 32 |
502832 | 502832 | 2020-09-05 | Noble | Indiana | 18113 | 838 | 32 |
499598 | 499598 | 2020-09-04 | Noble | Indiana | 18113 | 829 | 32 |
496365 | 496365 | 2020-09-03 | Noble | Indiana | 18113 | 825 | 32 |
493131 | 493131 | 2020-09-02 | Noble | Indiana | 18113 | 814 | 32 |
489898 | 489898 | 2020-09-01 | Noble | Indiana | 18113 | 814 | 32 |
486665 | 486665 | 2020-08-31 | Noble | Indiana | 18113 | 808 | 32 |
483430 | 483430 | 2020-08-30 | Noble | Indiana | 18113 | 805 | 31 |
480196 | 480196 | 2020-08-29 | Noble | Indiana | 18113 | 802 | 31 |
476963 | 476963 | 2020-08-28 | Noble | Indiana | 18113 | 793 | 31 |
473730 | 473730 | 2020-08-27 | Noble | Indiana | 18113 | 791 | 31 |
470498 | 470498 | 2020-08-26 | Noble | Indiana | 18113 | 783 | 31 |
467269 | 467269 | 2020-08-25 | Noble | Indiana | 18113 | 779 | 31 |
464040 | 464040 | 2020-08-24 | Noble | Indiana | 18113 | 777 | 31 |
460811 | 460811 | 2020-08-23 | Noble | Indiana | 18113 | 770 | 31 |
457584 | 457584 | 2020-08-22 | Noble | Indiana | 18113 | 766 | 31 |
454356 | 454356 | 2020-08-21 | Noble | Indiana | 18113 | 757 | 31 |
451128 | 451128 | 2020-08-20 | Noble | Indiana | 18113 | 753 | 31 |
447900 | 447900 | 2020-08-19 | Noble | Indiana | 18113 | 749 | 30 |
444673 | 444673 | 2020-08-18 | Noble | Indiana | 18113 | 749 | 30 |
441447 | 441447 | 2020-08-17 | Noble | Indiana | 18113 | 745 | 30 |
438221 | 438221 | 2020-08-16 | Noble | Indiana | 18113 | 741 | 30 |
434995 | 434995 | 2020-08-15 | Noble | Indiana | 18113 | 728 | 30 |
431770 | 431770 | 2020-08-14 | Noble | Indiana | 18113 | 721 | 30 |
428542 | 428542 | 2020-08-13 | Noble | Indiana | 18113 | 712 | 30 |
425318 | 425318 | 2020-08-12 | Noble | Indiana | 18113 | 694 | 30 |
422097 | 422097 | 2020-08-11 | Noble | Indiana | 18113 | 692 | 30 |
418874 | 418874 | 2020-08-10 | Noble | Indiana | 18113 | 688 | 30 |
415653 | 415653 | 2020-08-09 | Noble | Indiana | 18113 | 682 | 30 |
412433 | 412433 | 2020-08-08 | Noble | Indiana | 18113 | 667 | 30 |
409214 | 409214 | 2020-08-07 | Noble | Indiana | 18113 | 663 | 30 |
405994 | 405994 | 2020-08-06 | Noble | Indiana | 18113 | 649 | 30 |
402776 | 402776 | 2020-08-05 | Noble | Indiana | 18113 | 642 | 30 |
399560 | 399560 | 2020-08-04 | Noble | Indiana | 18113 | 641 | 30 |
396344 | 396344 | 2020-08-03 | Noble | Indiana | 18113 | 641 | 29 |
393128 | 393128 | 2020-08-02 | Noble | Indiana | 18113 | 639 | 29 |
389911 | 389911 | 2020-08-01 | Noble | Indiana | 18113 | 628 | 29 |
386694 | 386694 | 2020-07-31 | Noble | Indiana | 18113 | 621 | 29 |
383476 | 383476 | 2020-07-30 | Noble | Indiana | 18113 | 617 | 29 |
380259 | 380259 | 2020-07-29 | Noble | Indiana | 18113 | 612 | 29 |
377042 | 377042 | 2020-07-28 | Noble | Indiana | 18113 | 609 | 29 |
373827 | 373827 | 2020-07-27 | Noble | Indiana | 18113 | 606 | 29 |
370615 | 370615 | 2020-07-26 | Noble | Indiana | 18113 | 603 | 29 |
367405 | 367405 | 2020-07-25 | Noble | Indiana | 18113 | 598 | 29 |
364198 | 364198 | 2020-07-24 | Noble | Indiana | 18113 | 595 | 29 |
360991 | 360991 | 2020-07-23 | Noble | Indiana | 18113 | 592 | 29 |
357786 | 357786 | 2020-07-22 | Noble | Indiana | 18113 | 583 | 29 |
354584 | 354584 | 2020-07-21 | Noble | Indiana | 18113 | 578 | 29 |
351382 | 351382 | 2020-07-20 | Noble | Indiana | 18113 | 570 | 29 |
348182 | 348182 | 2020-07-19 | Noble | Indiana | 18113 | 560 | 29 |
344981 | 344981 | 2020-07-18 | Noble | Indiana | 18113 | 555 | 29 |
341781 | 341781 | 2020-07-17 | Noble | Indiana | 18113 | 550 | 29 |
338585 | 338585 | 2020-07-16 | Noble | Indiana | 18113 | 540 | 29 |
335389 | 335389 | 2020-07-15 | Noble | Indiana | 18113 | 534 | 29 |
332196 | 332196 | 2020-07-14 | Noble | Indiana | 18113 | 530 | 29 |
329009 | 329009 | 2020-07-13 | Noble | Indiana | 18113 | 528 | 29 |
325823 | 325823 | 2020-07-12 | Noble | Indiana | 18113 | 524 | 29 |
322642 | 322642 | 2020-07-11 | Noble | Indiana | 18113 | 517 | 29 |
319463 | 319463 | 2020-07-10 | Noble | Indiana | 18113 | 505 | 29 |
316290 | 316290 | 2020-07-09 | Noble | Indiana | 18113 | 495 | 29 |
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);