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-09 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
612885 | 612885 | 2020-10-09 | Adams | Indiana | 18001 | 342 | 5 |
612886 | 612886 | 2020-10-09 | Allen | Indiana | 18003 | 6971 | 221 |
612887 | 612887 | 2020-10-09 | Bartholomew | Indiana | 18005 | 1279 | 61 |
612888 | 612888 | 2020-10-09 | Benton | Indiana | 18007 | 92 | 0 |
612889 | 612889 | 2020-10-09 | Blackford | Indiana | 18009 | 168 | 3 |
612890 | 612890 | 2020-10-09 | Boone | Indiana | 18011 | 1107 | 49 |
612891 | 612891 | 2020-10-09 | Brown | Indiana | 18013 | 115 | 3 |
612892 | 612892 | 2020-10-09 | Carroll | Indiana | 18015 | 294 | 13 |
612893 | 612893 | 2020-10-09 | Cass | Indiana | 18017 | 2103 | 12 |
612894 | 612894 | 2020-10-09 | Clark | Indiana | 18019 | 2514 | 64 |
612895 | 612895 | 2020-10-09 | Clay | Indiana | 18021 | 352 | 6 |
612896 | 612896 | 2020-10-09 | Clinton | Indiana | 18023 | 722 | 18 |
612897 | 612897 | 2020-10-09 | Crawford | Indiana | 18025 | 124 | 2 |
612898 | 612898 | 2020-10-09 | Daviess | Indiana | 18027 | 737 | 32 |
612899 | 612899 | 2020-10-09 | DeKalb | Indiana | 18033 | 578 | 12 |
612900 | 612900 | 2020-10-09 | Dearborn | Indiana | 18029 | 761 | 30 |
612901 | 612901 | 2020-10-09 | Decatur | Indiana | 18031 | 501 | 42 |
612902 | 612902 | 2020-10-09 | Delaware | Indiana | 18035 | 2345 | 68 |
612903 | 612903 | 2020-10-09 | Dubois | Indiana | 18037 | 1125 | 20 |
612904 | 612904 | 2020-10-09 | Elkhart | Indiana | 18039 | 7469 | 128 |
612905 | 612905 | 2020-10-09 | Fayette | Indiana | 18041 | 600 | 14 |
612906 | 612906 | 2020-10-09 | Floyd | Indiana | 18043 | 1551 | 67 |
612907 | 612907 | 2020-10-09 | Fountain | Indiana | 18045 | 193 | 2 |
612908 | 612908 | 2020-10-09 | Franklin | Indiana | 18047 | 335 | 26 |
612909 | 612909 | 2020-10-09 | Fulton | Indiana | 18049 | 278 | 2 |
612910 | 612910 | 2020-10-09 | Gibson | Indiana | 18051 | 705 | 9 |
612911 | 612911 | 2020-10-09 | Grant | Indiana | 18053 | 1450 | 40 |
612912 | 612912 | 2020-10-09 | Greene | Indiana | 18055 | 459 | 39 |
612913 | 612913 | 2020-10-09 | Hamilton | Indiana | 18057 | 5414 | 119 |
612914 | 612914 | 2020-10-09 | Hancock | Indiana | 18059 | 1026 | 47 |
612915 | 612915 | 2020-10-09 | Harrison | Indiana | 18061 | 657 | 26 |
612916 | 612916 | 2020-10-09 | Hendricks | Indiana | 18063 | 2960 | 145 |
612917 | 612917 | 2020-10-09 | Henry | Indiana | 18065 | 1008 | 27 |
612918 | 612918 | 2020-10-09 | Howard | Indiana | 18067 | 1470 | 68 |
612919 | 612919 | 2020-10-09 | Huntington | Indiana | 18069 | 319 | 3 |
612920 | 612920 | 2020-10-09 | Jackson | Indiana | 18071 | 894 | 11 |
612921 | 612921 | 2020-10-09 | Jasper | Indiana | 18073 | 434 | 4 |
612922 | 612922 | 2020-10-09 | Jay | Indiana | 18075 | 241 | 2 |
612923 | 612923 | 2020-10-09 | Jefferson | Indiana | 18077 | 289 | 4 |
612924 | 612924 | 2020-10-09 | Jennings | Indiana | 18079 | 338 | 15 |
612925 | 612925 | 2020-10-09 | Johnson | Indiana | 18081 | 2650 | 135 |
612926 | 612926 | 2020-10-09 | Knox | Indiana | 18083 | 592 | 10 |
612927 | 612927 | 2020-10-09 | Kosciusko | Indiana | 18085 | 1468 | 19 |
612928 | 612928 | 2020-10-09 | LaGrange | Indiana | 18087 | 694 | 12 |
612929 | 612929 | 2020-10-09 | LaPorte | Indiana | 18091 | 1771 | 47 |
612930 | 612930 | 2020-10-09 | Lake | Indiana | 18089 | 11640 | 353 |
612931 | 612931 | 2020-10-09 | Lawrence | Indiana | 18093 | 617 | 32 |
612932 | 612932 | 2020-10-09 | Madison | Indiana | 18095 | 1970 | 92 |
612933 | 612933 | 2020-10-09 | Marion | Indiana | 18097 | 23040 | 824 |
612934 | 612934 | 2020-10-09 | Marshall | Indiana | 18099 | 1123 | 26 |
612935 | 612935 | 2020-10-09 | Martin | Indiana | 18101 | 178 | 0 |
612936 | 612936 | 2020-10-09 | Miami | Indiana | 18103 | 474 | 4 |
612937 | 612937 | 2020-10-09 | Monroe | Indiana | 18105 | 2925 | 41 |
612938 | 612938 | 2020-10-09 | Montgomery | Indiana | 18107 | 520 | 23 |
612939 | 612939 | 2020-10-09 | Morgan | Indiana | 18109 | 826 | 43 |
612940 | 612940 | 2020-10-09 | Newton | Indiana | 18111 | 183 | 12 |
612941 | 612941 | 2020-10-09 | Noble | Indiana | 18113 | 985 | 34 |
612942 | 612942 | 2020-10-09 | Ohio | Indiana | 18115 | 83 | 7 |
612943 | 612943 | 2020-10-09 | Orange | Indiana | 18117 | 315 | 26 |
612944 | 612944 | 2020-10-09 | Owen | Indiana | 18119 | 180 | 2 |
612945 | 612945 | 2020-10-09 | Parke | Indiana | 18121 | 163 | 2 |
612946 | 612946 | 2020-10-09 | Perry | Indiana | 18123 | 258 | 14 |
612947 | 612947 | 2020-10-09 | Pike | Indiana | 18125 | 260 | 6 |
612948 | 612948 | 2020-10-09 | Porter | Indiana | 18127 | 2523 | 49 |
612949 | 612949 | 2020-10-09 | Posey | Indiana | 18129 | 504 | 3 |
612950 | 612950 | 2020-10-09 | Pulaski | Indiana | 18131 | 121 | 1 |
612951 | 612951 | 2020-10-09 | Putnam | Indiana | 18133 | 643 | 14 |
612952 | 612952 | 2020-10-09 | Randolph | Indiana | 18135 | 304 | 8 |
612953 | 612953 | 2020-10-09 | Ripley | Indiana | 18137 | 349 | 8 |
612954 | 612954 | 2020-10-09 | Rush | Indiana | 18139 | 208 | 4 |
612955 | 612955 | 2020-10-09 | Scott | Indiana | 18143 | 460 | 13 |
612956 | 612956 | 2020-10-09 | Shelby | Indiana | 18145 | 1208 | 37 |
612957 | 612957 | 2020-10-09 | Spencer | Indiana | 18147 | 322 | 4 |
612958 | 612958 | 2020-10-09 | St. Joseph | Indiana | 18141 | 7640 | 143 |
612959 | 612959 | 2020-10-09 | Starke | Indiana | 18149 | 317 | 8 |
612960 | 612960 | 2020-10-09 | Steuben | Indiana | 18151 | 468 | 9 |
612961 | 612961 | 2020-10-09 | Sullivan | Indiana | 18153 | 370 | 12 |
612962 | 612962 | 2020-10-09 | Switzerland | Indiana | 18155 | 74 | 0 |
612963 | 612963 | 2020-10-09 | Tippecanoe | Indiana | 18157 | 3038 | 14 |
612964 | 612964 | 2020-10-09 | Tipton | Indiana | 18159 | 255 | 26 |
612965 | 612965 | 2020-10-09 | Union | Indiana | 18161 | 110 | 0 |
612966 | 612966 | 2020-10-09 | Vanderburgh | Indiana | 18163 | 4655 | 41 |
612967 | 612967 | 2020-10-09 | Vermillion | Indiana | 18165 | 152 | 1 |
612968 | 612968 | 2020-10-09 | Vigo | Indiana | 18167 | 2126 | 31 |
612969 | 612969 | 2020-10-09 | Wabash | Indiana | 18169 | 309 | 9 |
612970 | 612970 | 2020-10-09 | Warren | Indiana | 18171 | 51 | 1 |
612971 | 612971 | 2020-10-09 | Warrick | Indiana | 18173 | 1640 | 58 |
612972 | 612972 | 2020-10-09 | Washington | Indiana | 18175 | 304 | 2 |
612973 | 612973 | 2020-10-09 | Wayne | Indiana | 18177 | 1281 | 16 |
612974 | 612974 | 2020-10-09 | Wells | Indiana | 18179 | 335 | 5 |
612975 | 612975 | 2020-10-09 | White | Indiana | 18181 | 514 | 15 |
612976 | 612976 | 2020-10-09 | Whitley | Indiana | 18183 | 348 | 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);