ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Grant" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
901695 | 901695 | 2021-01-06 | Grant | Indiana | 18053 | 5707 | 108 |
898450 | 898450 | 2021-01-05 | Grant | Indiana | 18053 | 5648 | 106 |
895205 | 895205 | 2021-01-04 | Grant | Indiana | 18053 | 5582 | 106 |
891958 | 891958 | 2021-01-03 | Grant | Indiana | 18053 | 5558 | 106 |
888712 | 888712 | 2021-01-02 | Grant | Indiana | 18053 | 5496 | 105 |
885466 | 885466 | 2021-01-01 | Grant | Indiana | 18053 | 5462 | 105 |
882221 | 882221 | 2020-12-31 | Grant | Indiana | 18053 | 5404 | 102 |
878976 | 878976 | 2020-12-30 | Grant | Indiana | 18053 | 5306 | 100 |
875731 | 875731 | 2020-12-29 | Grant | Indiana | 18053 | 5257 | 98 |
872486 | 872486 | 2020-12-28 | Grant | Indiana | 18053 | 5208 | 97 |
869241 | 869241 | 2020-12-27 | Grant | Indiana | 18053 | 5182 | 97 |
865996 | 865996 | 2020-12-26 | Grant | Indiana | 18053 | 5170 | 97 |
862751 | 862751 | 2020-12-25 | Grant | Indiana | 18053 | 5141 | 96 |
859506 | 859506 | 2020-12-24 | Grant | Indiana | 18053 | 5073 | 94 |
856261 | 856261 | 2020-12-23 | Grant | Indiana | 18053 | 5025 | 92 |
853016 | 853016 | 2020-12-22 | Grant | Indiana | 18053 | 4973 | 91 |
849771 | 849771 | 2020-12-21 | Grant | Indiana | 18053 | 4916 | 88 |
846526 | 846526 | 2020-12-20 | Grant | Indiana | 18053 | 4888 | 88 |
843280 | 843280 | 2020-12-19 | Grant | Indiana | 18053 | 4792 | 86 |
840035 | 840035 | 2020-12-18 | Grant | Indiana | 18053 | 4761 | 84 |
836790 | 836790 | 2020-12-17 | Grant | Indiana | 18053 | 4677 | 84 |
833544 | 833544 | 2020-12-16 | Grant | Indiana | 18053 | 4620 | 78 |
830297 | 830297 | 2020-12-15 | Grant | Indiana | 18053 | 4560 | 68 |
827051 | 827051 | 2020-12-14 | Grant | Indiana | 18053 | 4509 | 66 |
823804 | 823804 | 2020-12-13 | Grant | Indiana | 18053 | 4449 | 66 |
820558 | 820558 | 2020-12-12 | Grant | Indiana | 18053 | 4402 | 66 |
817312 | 817312 | 2020-12-11 | Grant | Indiana | 18053 | 4315 | 65 |
814066 | 814066 | 2020-12-10 | Grant | Indiana | 18053 | 4229 | 64 |
810821 | 810821 | 2020-12-09 | Grant | Indiana | 18053 | 4128 | 64 |
807576 | 807576 | 2020-12-08 | Grant | Indiana | 18053 | 4075 | 64 |
804331 | 804331 | 2020-12-07 | Grant | Indiana | 18053 | 3989 | 61 |
801086 | 801086 | 2020-12-06 | Grant | Indiana | 18053 | 3926 | 60 |
797841 | 797841 | 2020-12-05 | Grant | Indiana | 18053 | 3867 | 60 |
794596 | 794596 | 2020-12-04 | Grant | Indiana | 18053 | 3769 | 57 |
791351 | 791351 | 2020-12-03 | Grant | Indiana | 18053 | 3690 | 56 |
788106 | 788106 | 2020-12-02 | Grant | Indiana | 18053 | 3581 | 55 |
784862 | 784862 | 2020-12-01 | Grant | Indiana | 18053 | 3515 | 55 |
781617 | 781617 | 2020-11-30 | Grant | Indiana | 18053 | 3451 | 53 |
778371 | 778371 | 2020-11-29 | Grant | Indiana | 18053 | 3380 | 53 |
775126 | 775126 | 2020-11-28 | Grant | Indiana | 18053 | 3330 | 53 |
771881 | 771881 | 2020-11-27 | Grant | Indiana | 18053 | 3298 | 53 |
768636 | 768636 | 2020-11-26 | Grant | Indiana | 18053 | 3247 | 53 |
765390 | 765390 | 2020-11-25 | Grant | Indiana | 18053 | 3153 | 53 |
762145 | 762145 | 2020-11-24 | Grant | Indiana | 18053 | 3058 | 52 |
758900 | 758900 | 2020-11-23 | Grant | Indiana | 18053 | 3015 | 50 |
755653 | 755653 | 2020-11-22 | Grant | Indiana | 18053 | 2972 | 50 |
752407 | 752407 | 2020-11-21 | Grant | Indiana | 18053 | 2899 | 49 |
749161 | 749161 | 2020-11-20 | Grant | Indiana | 18053 | 2790 | 49 |
745915 | 745915 | 2020-11-19 | Grant | Indiana | 18053 | 2694 | 49 |
742668 | 742668 | 2020-11-18 | Grant | Indiana | 18053 | 2646 | 49 |
739421 | 739421 | 2020-11-17 | Grant | Indiana | 18053 | 2575 | 49 |
736177 | 736177 | 2020-11-16 | Grant | Indiana | 18053 | 2509 | 49 |
732931 | 732931 | 2020-11-15 | Grant | Indiana | 18053 | 2470 | 49 |
729686 | 729686 | 2020-11-14 | Grant | Indiana | 18053 | 2392 | 48 |
726443 | 726443 | 2020-11-13 | Grant | Indiana | 18053 | 2348 | 48 |
723200 | 723200 | 2020-11-12 | Grant | Indiana | 18053 | 2269 | 48 |
719957 | 719957 | 2020-11-11 | Grant | Indiana | 18053 | 2220 | 47 |
716714 | 716714 | 2020-11-10 | Grant | Indiana | 18053 | 2190 | 47 |
713470 | 713470 | 2020-11-09 | Grant | Indiana | 18053 | 2147 | 47 |
710226 | 710226 | 2020-11-08 | Grant | Indiana | 18053 | 2121 | 47 |
706982 | 706982 | 2020-11-07 | Grant | Indiana | 18053 | 2067 | 46 |
703739 | 703739 | 2020-11-06 | Grant | Indiana | 18053 | 2038 | 46 |
700497 | 700497 | 2020-11-05 | Grant | Indiana | 18053 | 2008 | 46 |
697253 | 697253 | 2020-11-04 | Grant | Indiana | 18053 | 1966 | 45 |
694011 | 694011 | 2020-11-03 | Grant | Indiana | 18053 | 1941 | 45 |
690768 | 690768 | 2020-11-02 | Grant | Indiana | 18053 | 1924 | 44 |
687523 | 687523 | 2020-11-01 | Grant | Indiana | 18053 | 1907 | 44 |
684279 | 684279 | 2020-10-31 | Grant | Indiana | 18053 | 1894 | 43 |
681036 | 681036 | 2020-10-30 | Grant | Indiana | 18053 | 1876 | 43 |
677793 | 677793 | 2020-10-29 | Grant | Indiana | 18053 | 1821 | 43 |
674550 | 674550 | 2020-10-28 | Grant | Indiana | 18053 | 1785 | 43 |
671308 | 671308 | 2020-10-27 | Grant | Indiana | 18053 | 1753 | 43 |
668065 | 668065 | 2020-10-26 | Grant | Indiana | 18053 | 1735 | 42 |
664821 | 664821 | 2020-10-25 | Grant | Indiana | 18053 | 1711 | 42 |
661576 | 661576 | 2020-10-24 | Grant | Indiana | 18053 | 1699 | 42 |
658332 | 658332 | 2020-10-23 | Grant | Indiana | 18053 | 1679 | 42 |
655087 | 655087 | 2020-10-22 | Grant | Indiana | 18053 | 1654 | 42 |
651842 | 651842 | 2020-10-21 | Grant | Indiana | 18053 | 1625 | 42 |
648598 | 648598 | 2020-10-20 | Grant | Indiana | 18053 | 1604 | 42 |
645353 | 645353 | 2020-10-19 | Grant | Indiana | 18053 | 1575 | 42 |
642106 | 642106 | 2020-10-18 | Grant | Indiana | 18053 | 1563 | 42 |
638859 | 638859 | 2020-10-17 | Grant | Indiana | 18053 | 1549 | 42 |
635613 | 635613 | 2020-10-16 | Grant | Indiana | 18053 | 1536 | 42 |
632367 | 632367 | 2020-10-15 | Grant | Indiana | 18053 | 1511 | 42 |
629123 | 629123 | 2020-10-14 | Grant | Indiana | 18053 | 1499 | 41 |
625880 | 625880 | 2020-10-13 | Grant | Indiana | 18053 | 1494 | 41 |
622638 | 622638 | 2020-10-12 | Grant | Indiana | 18053 | 1478 | 40 |
619394 | 619394 | 2020-10-11 | Grant | Indiana | 18053 | 1467 | 40 |
616152 | 616152 | 2020-10-10 | Grant | Indiana | 18053 | 1457 | 40 |
612911 | 612911 | 2020-10-09 | Grant | Indiana | 18053 | 1450 | 40 |
609669 | 609669 | 2020-10-08 | Grant | Indiana | 18053 | 1429 | 40 |
606426 | 606426 | 2020-10-07 | Grant | Indiana | 18053 | 1415 | 40 |
603184 | 603184 | 2020-10-06 | Grant | Indiana | 18053 | 1405 | 40 |
599941 | 599941 | 2020-10-05 | Grant | Indiana | 18053 | 1376 | 40 |
596699 | 596699 | 2020-10-04 | Grant | Indiana | 18053 | 1367 | 40 |
593457 | 593457 | 2020-10-03 | Grant | Indiana | 18053 | 1365 | 40 |
590216 | 590216 | 2020-10-02 | Grant | Indiana | 18053 | 1348 | 40 |
586975 | 586975 | 2020-10-01 | Grant | Indiana | 18053 | 1334 | 40 |
583735 | 583735 | 2020-09-30 | Grant | Indiana | 18053 | 1321 | 40 |
580496 | 580496 | 2020-09-29 | Grant | Indiana | 18053 | 1310 | 39 |
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);