ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2020-10-13 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
625854 | 625854 | 2020-10-13 | Adams | Indiana | 18001 | 401 | 5 |
625855 | 625855 | 2020-10-13 | Allen | Indiana | 18003 | 7274 | 223 |
625856 | 625856 | 2020-10-13 | Bartholomew | Indiana | 18005 | 1322 | 61 |
625857 | 625857 | 2020-10-13 | Benton | Indiana | 18007 | 95 | 0 |
625858 | 625858 | 2020-10-13 | Blackford | Indiana | 18009 | 177 | 3 |
625859 | 625859 | 2020-10-13 | Boone | Indiana | 18011 | 1143 | 49 |
625860 | 625860 | 2020-10-13 | Brown | Indiana | 18013 | 122 | 3 |
625861 | 625861 | 2020-10-13 | Carroll | Indiana | 18015 | 299 | 13 |
625862 | 625862 | 2020-10-13 | Cass | Indiana | 18017 | 2140 | 17 |
625863 | 625863 | 2020-10-13 | Clark | Indiana | 18019 | 2636 | 64 |
625864 | 625864 | 2020-10-13 | Clay | Indiana | 18021 | 382 | 6 |
625865 | 625865 | 2020-10-13 | Clinton | Indiana | 18023 | 752 | 18 |
625866 | 625866 | 2020-10-13 | Crawford | Indiana | 18025 | 134 | 2 |
625867 | 625867 | 2020-10-13 | Daviess | Indiana | 18027 | 762 | 33 |
625868 | 625868 | 2020-10-13 | DeKalb | Indiana | 18033 | 614 | 12 |
625869 | 625869 | 2020-10-13 | Dearborn | Indiana | 18029 | 808 | 30 |
625870 | 625870 | 2020-10-13 | Decatur | Indiana | 18031 | 508 | 42 |
625871 | 625871 | 2020-10-13 | Delaware | Indiana | 18035 | 2518 | 72 |
625872 | 625872 | 2020-10-13 | Dubois | Indiana | 18037 | 1225 | 21 |
625873 | 625873 | 2020-10-13 | Elkhart | Indiana | 18039 | 7826 | 130 |
625874 | 625874 | 2020-10-13 | Fayette | Indiana | 18041 | 629 | 14 |
625875 | 625875 | 2020-10-13 | Floyd | Indiana | 18043 | 1613 | 68 |
625876 | 625876 | 2020-10-13 | Fountain | Indiana | 18045 | 230 | 2 |
625877 | 625877 | 2020-10-13 | Franklin | Indiana | 18047 | 339 | 26 |
625878 | 625878 | 2020-10-13 | Fulton | Indiana | 18049 | 296 | 2 |
625879 | 625879 | 2020-10-13 | Gibson | Indiana | 18051 | 758 | 9 |
625880 | 625880 | 2020-10-13 | Grant | Indiana | 18053 | 1494 | 41 |
625881 | 625881 | 2020-10-13 | Greene | Indiana | 18055 | 477 | 39 |
625882 | 625882 | 2020-10-13 | Hamilton | Indiana | 18057 | 5593 | 121 |
625883 | 625883 | 2020-10-13 | Hancock | Indiana | 18059 | 1081 | 47 |
625884 | 625884 | 2020-10-13 | Harrison | Indiana | 18061 | 684 | 26 |
625885 | 625885 | 2020-10-13 | Hendricks | Indiana | 18063 | 3029 | 145 |
625886 | 625886 | 2020-10-13 | Henry | Indiana | 18065 | 1069 | 27 |
625887 | 625887 | 2020-10-13 | Howard | Indiana | 18067 | 1512 | 69 |
625888 | 625888 | 2020-10-13 | Huntington | Indiana | 18069 | 340 | 5 |
625889 | 625889 | 2020-10-13 | Jackson | Indiana | 18071 | 960 | 11 |
625890 | 625890 | 2020-10-13 | Jasper | Indiana | 18073 | 464 | 4 |
625891 | 625891 | 2020-10-13 | Jay | Indiana | 18075 | 254 | 3 |
625892 | 625892 | 2020-10-13 | Jefferson | Indiana | 18077 | 309 | 4 |
625893 | 625893 | 2020-10-13 | Jennings | Indiana | 18079 | 346 | 15 |
625894 | 625894 | 2020-10-13 | Johnson | Indiana | 18081 | 2816 | 136 |
625895 | 625895 | 2020-10-13 | Knox | Indiana | 18083 | 611 | 10 |
625896 | 625896 | 2020-10-13 | Kosciusko | Indiana | 18085 | 1557 | 21 |
625897 | 625897 | 2020-10-13 | LaGrange | Indiana | 18087 | 726 | 13 |
625898 | 625898 | 2020-10-13 | LaPorte | Indiana | 18091 | 1912 | 49 |
625899 | 625899 | 2020-10-13 | Lake | Indiana | 18089 | 12149 | 357 |
625900 | 625900 | 2020-10-13 | Lawrence | Indiana | 18093 | 659 | 32 |
625901 | 625901 | 2020-10-13 | Madison | Indiana | 18095 | 2084 | 95 |
625902 | 625902 | 2020-10-13 | Marion | Indiana | 18097 | 23686 | 825 |
625903 | 625903 | 2020-10-13 | Marshall | Indiana | 18099 | 1209 | 26 |
625904 | 625904 | 2020-10-13 | Martin | Indiana | 18101 | 186 | 0 |
625905 | 625905 | 2020-10-13 | Miami | Indiana | 18103 | 511 | 4 |
625906 | 625906 | 2020-10-13 | Monroe | Indiana | 18105 | 3059 | 41 |
625907 | 625907 | 2020-10-13 | Montgomery | Indiana | 18107 | 538 | 23 |
625908 | 625908 | 2020-10-13 | Morgan | Indiana | 18109 | 864 | 43 |
625909 | 625909 | 2020-10-13 | Newton | Indiana | 18111 | 192 | 12 |
625910 | 625910 | 2020-10-13 | Noble | Indiana | 18113 | 1032 | 34 |
625911 | 625911 | 2020-10-13 | Ohio | Indiana | 18115 | 94 | 7 |
625912 | 625912 | 2020-10-13 | Orange | Indiana | 18117 | 351 | 26 |
625913 | 625913 | 2020-10-13 | Owen | Indiana | 18119 | 184 | 2 |
625914 | 625914 | 2020-10-13 | Parke | Indiana | 18121 | 192 | 2 |
625915 | 625915 | 2020-10-13 | Perry | Indiana | 18123 | 269 | 14 |
625916 | 625916 | 2020-10-13 | Pike | Indiana | 18125 | 292 | 8 |
625917 | 625917 | 2020-10-13 | Porter | Indiana | 18127 | 2683 | 49 |
625918 | 625918 | 2020-10-13 | Posey | Indiana | 18129 | 603 | 3 |
625919 | 625919 | 2020-10-13 | Pulaski | Indiana | 18131 | 126 | 1 |
625920 | 625920 | 2020-10-13 | Putnam | Indiana | 18133 | 675 | 15 |
625921 | 625921 | 2020-10-13 | Randolph | Indiana | 18135 | 327 | 8 |
625922 | 625922 | 2020-10-13 | Ripley | Indiana | 18137 | 375 | 8 |
625923 | 625923 | 2020-10-13 | Rush | Indiana | 18139 | 219 | 4 |
625924 | 625924 | 2020-10-13 | Scott | Indiana | 18143 | 487 | 14 |
625925 | 625925 | 2020-10-13 | Shelby | Indiana | 18145 | 1237 | 37 |
625926 | 625926 | 2020-10-13 | Spencer | Indiana | 18147 | 346 | 6 |
625927 | 625927 | 2020-10-13 | St. Joseph | Indiana | 18141 | 8108 | 152 |
625928 | 625928 | 2020-10-13 | Starke | Indiana | 18149 | 348 | 8 |
625929 | 625929 | 2020-10-13 | Steuben | Indiana | 18151 | 536 | 9 |
625930 | 625930 | 2020-10-13 | Sullivan | Indiana | 18153 | 388 | 12 |
625931 | 625931 | 2020-10-13 | Switzerland | Indiana | 18155 | 78 | 0 |
625932 | 625932 | 2020-10-13 | Tippecanoe | Indiana | 18157 | 3207 | 14 |
625933 | 625933 | 2020-10-13 | Tipton | Indiana | 18159 | 261 | 26 |
625934 | 625934 | 2020-10-13 | Union | Indiana | 18161 | 112 | 0 |
625935 | 625935 | 2020-10-13 | Vanderburgh | Indiana | 18163 | 5059 | 45 |
625936 | 625936 | 2020-10-13 | Vermillion | Indiana | 18165 | 173 | 1 |
625937 | 625937 | 2020-10-13 | Vigo | Indiana | 18167 | 2272 | 32 |
625938 | 625938 | 2020-10-13 | Wabash | Indiana | 18169 | 331 | 9 |
625939 | 625939 | 2020-10-13 | Warren | Indiana | 18171 | 60 | 1 |
625940 | 625940 | 2020-10-13 | Warrick | Indiana | 18173 | 1744 | 60 |
625941 | 625941 | 2020-10-13 | Washington | Indiana | 18175 | 314 | 2 |
625942 | 625942 | 2020-10-13 | Wayne | Indiana | 18177 | 1384 | 18 |
625943 | 625943 | 2020-10-13 | Wells | Indiana | 18179 | 362 | 5 |
625944 | 625944 | 2020-10-13 | White | Indiana | 18181 | 527 | 15 |
625945 | 625945 | 2020-10-13 | Whitley | Indiana | 18183 | 375 | 6 |
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);