ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-07-20" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1534695 | 1534695 | 2021-07-20 | Adams | Indiana | 18001 | 3561 | 57 |
1534696 | 1534696 | 2021-07-20 | Allen | Indiana | 18003 | 42531 | 720 |
1534697 | 1534697 | 2021-07-20 | Bartholomew | Indiana | 18005 | 8239 | 162 |
1534698 | 1534698 | 2021-07-20 | Benton | Indiana | 18007 | 1089 | 15 |
1534699 | 1534699 | 2021-07-20 | Blackford | Indiana | 18009 | 1388 | 32 |
1534700 | 1534700 | 2021-07-20 | Boone | Indiana | 18011 | 7142 | 109 |
1534701 | 1534701 | 2021-07-20 | Brown | Indiana | 18013 | 1053 | 43 |
1534702 | 1534702 | 2021-07-20 | Carroll | Indiana | 18015 | 1957 | 24 |
1534703 | 1534703 | 2021-07-20 | Cass | Indiana | 18017 | 6083 | 113 |
1534704 | 1534704 | 2021-07-20 | Clark | Indiana | 18019 | 13419 | 207 |
1534705 | 1534705 | 2021-07-20 | Clay | Indiana | 18021 | 2723 | 48 |
1534706 | 1534706 | 2021-07-20 | Clinton | Indiana | 18023 | 4518 | 60 |
1534707 | 1534707 | 2021-07-20 | Crawford | Indiana | 18025 | 1044 | 17 |
1534708 | 1534708 | 2021-07-20 | Daviess | Indiana | 18027 | 3081 | 102 |
1534709 | 1534709 | 2021-07-20 | DeKalb | Indiana | 18033 | 4499 | 88 |
1534710 | 1534710 | 2021-07-20 | Dearborn | Indiana | 18029 | 5977 | 81 |
1534711 | 1534711 | 2021-07-20 | Decatur | Indiana | 18031 | 2969 | 96 |
1534712 | 1534712 | 2021-07-20 | Delaware | Indiana | 18035 | 11081 | 205 |
1534713 | 1534713 | 2021-07-20 | Dubois | Indiana | 18037 | 6252 | 119 |
1534714 | 1534714 | 2021-07-20 | Elkhart | Indiana | 18039 | 29754 | 482 |
1534715 | 1534715 | 2021-07-20 | Fayette | Indiana | 18041 | 2994 | 66 |
1534716 | 1534716 | 2021-07-20 | Floyd | Indiana | 18043 | 7951 | 186 |
1534717 | 1534717 | 2021-07-20 | Fountain | Indiana | 18045 | 2325 | 50 |
1534718 | 1534718 | 2021-07-20 | Franklin | Indiana | 18047 | 1731 | 36 |
1534719 | 1534719 | 2021-07-20 | Fulton | Indiana | 18049 | 2072 | 45 |
1534720 | 1534720 | 2021-07-20 | Gibson | Indiana | 18051 | 4595 | 99 |
1534721 | 1534721 | 2021-07-20 | Grant | Indiana | 18053 | 7737 | 188 |
1534722 | 1534722 | 2021-07-20 | Greene | Indiana | 18055 | 2921 | 89 |
1534723 | 1534723 | 2021-07-20 | Hamilton | Indiana | 18057 | 37065 | 446 |
1534724 | 1534724 | 2021-07-20 | Hancock | Indiana | 18059 | 8713 | 152 |
1534725 | 1534725 | 2021-07-20 | Harrison | Indiana | 18061 | 4488 | 77 |
1534726 | 1534726 | 2021-07-20 | Hendricks | Indiana | 18063 | 18023 | 343 |
1534727 | 1534727 | 2021-07-20 | Henry | Indiana | 18065 | 5945 | 113 |
1534728 | 1534728 | 2021-07-20 | Howard | Indiana | 18067 | 10576 | 241 |
1534729 | 1534729 | 2021-07-20 | Huntington | Indiana | 18069 | 4104 | 83 |
1534730 | 1534730 | 2021-07-20 | Jackson | Indiana | 18071 | 5131 | 78 |
1534731 | 1534731 | 2021-07-20 | Jasper | Indiana | 18073 | 3992 | 57 |
1534732 | 1534732 | 2021-07-20 | Jay | Indiana | 18075 | 2039 | 35 |
1534733 | 1534733 | 2021-07-20 | Jefferson | Indiana | 18077 | 3398 | 87 |
1534734 | 1534734 | 2021-07-20 | Jennings | Indiana | 18079 | 2367 | 51 |
1534735 | 1534735 | 2021-07-20 | Johnson | Indiana | 18081 | 18754 | 408 |
1534736 | 1534736 | 2021-07-20 | Knox | Indiana | 18083 | 3864 | 91 |
1534737 | 1534737 | 2021-07-20 | Kosciusko | Indiana | 18085 | 9737 | 128 |
1534738 | 1534738 | 2021-07-20 | LaGrange | Indiana | 18087 | 2768 | 74 |
1534739 | 1534739 | 2021-07-20 | LaPorte | Indiana | 18091 | 12525 | 226 |
1534740 | 1534740 | 2021-07-20 | Lake | Indiana | 18089 | 56809 | 1070 |
1534741 | 1534741 | 2021-07-20 | Lawrence | Indiana | 18093 | 4871 | 130 |
1534742 | 1534742 | 2021-07-20 | Madison | Indiana | 18095 | 13437 | 365 |
1534743 | 1534743 | 2021-07-20 | Marion | Indiana | 18097 | 104836 | 1870 |
1534744 | 1534744 | 2021-07-20 | Marshall | Indiana | 18099 | 6319 | 118 |
1534745 | 1534745 | 2021-07-20 | Martin | Indiana | 18101 | 927 | 15 |
1534746 | 1534746 | 2021-07-20 | Miami | Indiana | 18103 | 4036 | 73 |
1534747 | 1534747 | 2021-07-20 | Monroe | Indiana | 18105 | 12457 | 181 |
1534748 | 1534748 | 2021-07-20 | Montgomery | Indiana | 18107 | 4530 | 94 |
1534749 | 1534749 | 2021-07-20 | Morgan | Indiana | 18109 | 6879 | 147 |
1534750 | 1534750 | 2021-07-20 | Newton | Indiana | 18111 | 1217 | 38 |
1534751 | 1534751 | 2021-07-20 | Noble | Indiana | 18113 | 5929 | 93 |
1534752 | 1534752 | 2021-07-20 | Ohio | Indiana | 18115 | 581 | 11 |
1534753 | 1534753 | 2021-07-20 | Orange | Indiana | 18117 | 1907 | 59 |
1534754 | 1534754 | 2021-07-20 | Owen | Indiana | 18119 | 2202 | 60 |
1534755 | 1534755 | 2021-07-20 | Parke | Indiana | 18121 | 1538 | 16 |
1534756 | 1534756 | 2021-07-20 | Perry | Indiana | 18123 | 1897 | 40 |
1534757 | 1534757 | 2021-07-20 | Pike | Indiana | 18125 | 1405 | 34 |
1534758 | 1534758 | 2021-07-20 | Porter | Indiana | 18127 | 19536 | 338 |
1534759 | 1534759 | 2021-07-20 | Posey | Indiana | 18129 | 2792 | 35 |
1534760 | 1534760 | 2021-07-20 | Pulaski | Indiana | 18131 | 1224 | 48 |
1534761 | 1534761 | 2021-07-20 | Putnam | Indiana | 18133 | 3822 | 62 |
1534762 | 1534762 | 2021-07-20 | Randolph | Indiana | 18135 | 2499 | 84 |
1534763 | 1534763 | 2021-07-20 | Ripley | Indiana | 18137 | 3505 | 72 |
1534764 | 1534764 | 2021-07-20 | Rush | Indiana | 18139 | 1838 | 27 |
1534765 | 1534765 | 2021-07-20 | Scott | Indiana | 18143 | 2762 | 60 |
1534766 | 1534766 | 2021-07-20 | Shelby | Indiana | 18145 | 6074 | 108 |
1534767 | 1534767 | 2021-07-20 | Spencer | Indiana | 18147 | 2366 | 31 |
1534768 | 1534768 | 2021-07-20 | St. Joseph | Indiana | 18141 | 37236 | 585 |
1534769 | 1534769 | 2021-07-20 | Starke | Indiana | 18149 | 2300 | 61 |
1534770 | 1534770 | 2021-07-20 | Steuben | Indiana | 18151 | 4087 | 62 |
1534771 | 1534771 | 2021-07-20 | Sullivan | Indiana | 18153 | 2187 | 43 |
1534772 | 1534772 | 2021-07-20 | Switzerland | Indiana | 18155 | 823 | 8 |
1534773 | 1534773 | 2021-07-20 | Tippecanoe | Indiana | 18157 | 23278 | 233 |
1534774 | 1534774 | 2021-07-20 | Tipton | Indiana | 18159 | 1706 | 50 |
1534775 | 1534775 | 2021-07-20 | Union | Indiana | 18161 | 762 | 11 |
1534776 | 1534776 | 2021-07-20 | Vanderburgh | Indiana | 18163 | 22987 | 410 |
1534777 | 1534777 | 2021-07-20 | Vermillion | Indiana | 18165 | 1795 | 44 |
1534778 | 1534778 | 2021-07-20 | Vigo | Indiana | 18167 | 12775 | 260 |
1534779 | 1534779 | 2021-07-20 | Wabash | Indiana | 18169 | 3664 | 83 |
1534780 | 1534780 | 2021-07-20 | Warren | Indiana | 18171 | 876 | 16 |
1534781 | 1534781 | 2021-07-20 | Warrick | Indiana | 18173 | 7986 | 160 |
1534782 | 1534782 | 2021-07-20 | Washington | Indiana | 18175 | 2507 | 37 |
1534783 | 1534783 | 2021-07-20 | Wayne | Indiana | 18177 | 7593 | 205 |
1534784 | 1534784 | 2021-07-20 | Wells | Indiana | 18179 | 3041 | 83 |
1534785 | 1534785 | 2021-07-20 | White | Indiana | 18181 | 3384 | 55 |
1534786 | 1534786 | 2021-07-20 | Whitley | Indiana | 18183 | 4133 | 44 |
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);