ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 18063 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
729691 | 729691 | 2020-11-14 | Hendricks | Indiana | 18063 | 4677 | 165 |
726448 | 726448 | 2020-11-13 | Hendricks | Indiana | 18063 | 4531 | 165 |
723205 | 723205 | 2020-11-12 | Hendricks | Indiana | 18063 | 4426 | 164 |
719962 | 719962 | 2020-11-11 | Hendricks | Indiana | 18063 | 4309 | 164 |
716719 | 716719 | 2020-11-10 | Hendricks | Indiana | 18063 | 4250 | 164 |
713475 | 713475 | 2020-11-09 | Hendricks | Indiana | 18063 | 4167 | 163 |
710231 | 710231 | 2020-11-08 | Hendricks | Indiana | 18063 | 4118 | 162 |
706987 | 706987 | 2020-11-07 | Hendricks | Indiana | 18063 | 4033 | 162 |
703744 | 703744 | 2020-11-06 | Hendricks | Indiana | 18063 | 3966 | 161 |
700502 | 700502 | 2020-11-05 | Hendricks | Indiana | 18063 | 3904 | 163 |
697258 | 697258 | 2020-11-04 | Hendricks | Indiana | 18063 | 3844 | 160 |
694016 | 694016 | 2020-11-03 | Hendricks | Indiana | 18063 | 3792 | 159 |
690773 | 690773 | 2020-11-02 | Hendricks | Indiana | 18063 | 3760 | 159 |
687528 | 687528 | 2020-11-01 | Hendricks | Indiana | 18063 | 3714 | 157 |
684284 | 684284 | 2020-10-31 | Hendricks | Indiana | 18063 | 3691 | 157 |
681041 | 681041 | 2020-10-30 | Hendricks | Indiana | 18063 | 3635 | 156 |
677798 | 677798 | 2020-10-29 | Hendricks | Indiana | 18063 | 3568 | 156 |
674555 | 674555 | 2020-10-28 | Hendricks | Indiana | 18063 | 3508 | 155 |
671313 | 671313 | 2020-10-27 | Hendricks | Indiana | 18063 | 3478 | 154 |
668070 | 668070 | 2020-10-26 | Hendricks | Indiana | 18063 | 3454 | 151 |
664826 | 664826 | 2020-10-25 | Hendricks | Indiana | 18063 | 3403 | 151 |
661581 | 661581 | 2020-10-24 | Hendricks | Indiana | 18063 | 3373 | 150 |
658337 | 658337 | 2020-10-23 | Hendricks | Indiana | 18063 | 3338 | 150 |
655092 | 655092 | 2020-10-22 | Hendricks | Indiana | 18063 | 3304 | 150 |
651847 | 651847 | 2020-10-21 | Hendricks | Indiana | 18063 | 3257 | 147 |
648603 | 648603 | 2020-10-20 | Hendricks | Indiana | 18063 | 3219 | 147 |
645358 | 645358 | 2020-10-19 | Hendricks | Indiana | 18063 | 3176 | 147 |
642111 | 642111 | 2020-10-18 | Hendricks | Indiana | 18063 | 3152 | 147 |
638864 | 638864 | 2020-10-17 | Hendricks | Indiana | 18063 | 3129 | 146 |
635618 | 635618 | 2020-10-16 | Hendricks | Indiana | 18063 | 3104 | 145 |
632372 | 632372 | 2020-10-15 | Hendricks | Indiana | 18063 | 3065 | 145 |
629128 | 629128 | 2020-10-14 | Hendricks | Indiana | 18063 | 3041 | 145 |
625885 | 625885 | 2020-10-13 | Hendricks | Indiana | 18063 | 3029 | 145 |
622643 | 622643 | 2020-10-12 | Hendricks | Indiana | 18063 | 3005 | 145 |
619399 | 619399 | 2020-10-11 | Hendricks | Indiana | 18063 | 2995 | 145 |
616157 | 616157 | 2020-10-10 | Hendricks | Indiana | 18063 | 2975 | 145 |
612916 | 612916 | 2020-10-09 | Hendricks | Indiana | 18063 | 2960 | 145 |
609674 | 609674 | 2020-10-08 | Hendricks | Indiana | 18063 | 2924 | 145 |
606431 | 606431 | 2020-10-07 | Hendricks | Indiana | 18063 | 2915 | 144 |
603189 | 603189 | 2020-10-06 | Hendricks | Indiana | 18063 | 2893 | 145 |
599946 | 599946 | 2020-10-05 | Hendricks | Indiana | 18063 | 2881 | 144 |
596704 | 596704 | 2020-10-04 | Hendricks | Indiana | 18063 | 2877 | 144 |
593462 | 593462 | 2020-10-03 | Hendricks | Indiana | 18063 | 2863 | 144 |
590221 | 590221 | 2020-10-02 | Hendricks | Indiana | 18063 | 2850 | 144 |
586980 | 586980 | 2020-10-01 | Hendricks | Indiana | 18063 | 2836 | 143 |
583740 | 583740 | 2020-09-30 | Hendricks | Indiana | 18063 | 2823 | 142 |
580501 | 580501 | 2020-09-29 | Hendricks | Indiana | 18063 | 2813 | 141 |
577260 | 577260 | 2020-09-28 | Hendricks | Indiana | 18063 | 2800 | 141 |
574018 | 574018 | 2020-09-27 | Hendricks | Indiana | 18063 | 2781 | 140 |
570775 | 570775 | 2020-09-26 | Hendricks | Indiana | 18063 | 2775 | 140 |
567533 | 567533 | 2020-09-25 | Hendricks | Indiana | 18063 | 2749 | 140 |
564293 | 564293 | 2020-09-24 | Hendricks | Indiana | 18063 | 2729 | 140 |
561053 | 561053 | 2020-09-23 | Hendricks | Indiana | 18063 | 2716 | 139 |
557817 | 557817 | 2020-09-22 | Hendricks | Indiana | 18063 | 2708 | 139 |
554580 | 554580 | 2020-09-21 | Hendricks | Indiana | 18063 | 2697 | 139 |
551341 | 551341 | 2020-09-20 | Hendricks | Indiana | 18063 | 2686 | 139 |
548102 | 548102 | 2020-09-19 | Hendricks | Indiana | 18063 | 2674 | 138 |
544864 | 544864 | 2020-09-18 | Hendricks | Indiana | 18063 | 2651 | 137 |
541628 | 541628 | 2020-09-17 | Hendricks | Indiana | 18063 | 2640 | 137 |
538391 | 538391 | 2020-09-16 | Hendricks | Indiana | 18063 | 2617 | 137 |
535155 | 535155 | 2020-09-15 | Hendricks | Indiana | 18063 | 2605 | 137 |
531920 | 531920 | 2020-09-14 | Hendricks | Indiana | 18063 | 2595 | 136 |
528683 | 528683 | 2020-09-13 | Hendricks | Indiana | 18063 | 2579 | 137 |
525447 | 525447 | 2020-09-12 | Hendricks | Indiana | 18063 | 2560 | 137 |
522211 | 522211 | 2020-09-11 | Hendricks | Indiana | 18063 | 2544 | 136 |
518974 | 518974 | 2020-09-10 | Hendricks | Indiana | 18063 | 2521 | 135 |
515739 | 515739 | 2020-09-09 | Hendricks | Indiana | 18063 | 2513 | 135 |
512506 | 512506 | 2020-09-08 | Hendricks | Indiana | 18063 | 2500 | 135 |
509273 | 509273 | 2020-09-07 | Hendricks | Indiana | 18063 | 2493 | 134 |
506041 | 506041 | 2020-09-06 | Hendricks | Indiana | 18063 | 2482 | 134 |
502807 | 502807 | 2020-09-05 | Hendricks | Indiana | 18063 | 2467 | 133 |
499573 | 499573 | 2020-09-04 | Hendricks | Indiana | 18063 | 2445 | 130 |
496340 | 496340 | 2020-09-03 | Hendricks | Indiana | 18063 | 2423 | 130 |
493106 | 493106 | 2020-09-02 | Hendricks | Indiana | 18063 | 2403 | 130 |
489873 | 489873 | 2020-09-01 | Hendricks | Indiana | 18063 | 2368 | 130 |
486640 | 486640 | 2020-08-31 | Hendricks | Indiana | 18063 | 2357 | 128 |
483405 | 483405 | 2020-08-30 | Hendricks | Indiana | 18063 | 2332 | 128 |
480171 | 480171 | 2020-08-29 | Hendricks | Indiana | 18063 | 2313 | 128 |
476938 | 476938 | 2020-08-28 | Hendricks | Indiana | 18063 | 2283 | 128 |
473705 | 473705 | 2020-08-27 | Hendricks | Indiana | 18063 | 2269 | 128 |
470473 | 470473 | 2020-08-26 | Hendricks | Indiana | 18063 | 2232 | 128 |
467244 | 467244 | 2020-08-25 | Hendricks | Indiana | 18063 | 2216 | 128 |
464015 | 464015 | 2020-08-24 | Hendricks | Indiana | 18063 | 2199 | 127 |
460786 | 460786 | 2020-08-23 | Hendricks | Indiana | 18063 | 2180 | 127 |
457559 | 457559 | 2020-08-22 | Hendricks | Indiana | 18063 | 2152 | 127 |
454331 | 454331 | 2020-08-21 | Hendricks | Indiana | 18063 | 2130 | 127 |
451103 | 451103 | 2020-08-20 | Hendricks | Indiana | 18063 | 2099 | 127 |
447875 | 447875 | 2020-08-19 | Hendricks | Indiana | 18063 | 2072 | 125 |
444648 | 444648 | 2020-08-18 | Hendricks | Indiana | 18063 | 2065 | 125 |
441422 | 441422 | 2020-08-17 | Hendricks | Indiana | 18063 | 2045 | 125 |
438196 | 438196 | 2020-08-16 | Hendricks | Indiana | 18063 | 2042 | 125 |
434970 | 434970 | 2020-08-15 | Hendricks | Indiana | 18063 | 2023 | 125 |
431745 | 431745 | 2020-08-14 | Hendricks | Indiana | 18063 | 2005 | 125 |
428517 | 428517 | 2020-08-13 | Hendricks | Indiana | 18063 | 1999 | 125 |
425293 | 425293 | 2020-08-12 | Hendricks | Indiana | 18063 | 1970 | 124 |
422072 | 422072 | 2020-08-11 | Hendricks | Indiana | 18063 | 1953 | 124 |
418849 | 418849 | 2020-08-10 | Hendricks | Indiana | 18063 | 1927 | 124 |
415628 | 415628 | 2020-08-09 | Hendricks | Indiana | 18063 | 1913 | 124 |
412408 | 412408 | 2020-08-08 | Hendricks | Indiana | 18063 | 1897 | 124 |
409189 | 409189 | 2020-08-07 | Hendricks | Indiana | 18063 | 1858 | 122 |
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);