ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-07-07" 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 |
---|---|---|---|---|---|---|---|
309890 | 309890 | 2020-07-07 | Adams | Indiana | 18001 | 51 | 2 |
309891 | 309891 | 2020-07-07 | Allen | Indiana | 18003 | 2834 | 142 |
309892 | 309892 | 2020-07-07 | Bartholomew | Indiana | 18005 | 595 | 47 |
309893 | 309893 | 2020-07-07 | Benton | Indiana | 18007 | 48 | 0 |
309894 | 309894 | 2020-07-07 | Blackford | Indiana | 18009 | 43 | 2 |
309895 | 309895 | 2020-07-07 | Boone | Indiana | 18011 | 467 | 46 |
309896 | 309896 | 2020-07-07 | Brown | Indiana | 18013 | 39 | 1 |
309897 | 309897 | 2020-07-07 | Carroll | Indiana | 18015 | 110 | 2 |
309898 | 309898 | 2020-07-07 | Cass | Indiana | 18017 | 1642 | 10 |
309899 | 309899 | 2020-07-07 | Clark | Indiana | 18019 | 672 | 51 |
309900 | 309900 | 2020-07-07 | Clay | Indiana | 18021 | 60 | 4 |
309901 | 309901 | 2020-07-07 | Clinton | Indiana | 18023 | 290 | 3 |
309902 | 309902 | 2020-07-07 | Crawford | Indiana | 18025 | 33 | 1 |
309903 | 309903 | 2020-07-07 | Daviess | Indiana | 18027 | 149 | 19 |
309904 | 309904 | 2020-07-07 | DeKalb | Indiana | 18033 | 164 | 5 |
309905 | 309905 | 2020-07-07 | Dearborn | Indiana | 18029 | 234 | 24 |
309906 | 309906 | 2020-07-07 | Decatur | Indiana | 18031 | 272 | 35 |
309907 | 309907 | 2020-07-07 | Delaware | Indiana | 18035 | 452 | 51 |
309908 | 309908 | 2020-07-07 | Dubois | Indiana | 18037 | 283 | 6 |
309909 | 309909 | 2020-07-07 | Elkhart | Indiana | 18039 | 3405 | 55 |
309910 | 309910 | 2020-07-07 | Fayette | Indiana | 18041 | 152 | 7 |
309911 | 309911 | 2020-07-07 | Floyd | Indiana | 18043 | 384 | 46 |
309912 | 309912 | 2020-07-07 | Fountain | Indiana | 18045 | 32 | 2 |
309913 | 309913 | 2020-07-07 | Franklin | Indiana | 18047 | 134 | 9 |
309914 | 309914 | 2020-07-07 | Fulton | Indiana | 18049 | 71 | 1 |
309915 | 309915 | 2020-07-07 | Gibson | Indiana | 18051 | 87 | 2 |
309916 | 309916 | 2020-07-07 | Grant | Indiana | 18053 | 405 | 29 |
309917 | 309917 | 2020-07-07 | Greene | Indiana | 18055 | 195 | 35 |
309918 | 309918 | 2020-07-07 | Hamilton | Indiana | 18057 | 1622 | 107 |
309919 | 309919 | 2020-07-07 | Hancock | Indiana | 18059 | 454 | 36 |
309920 | 309920 | 2020-07-07 | Harrison | Indiana | 18061 | 218 | 24 |
309921 | 309921 | 2020-07-07 | Hendricks | Indiana | 18063 | 1438 | 116 |
309922 | 309922 | 2020-07-07 | Henry | Indiana | 18065 | 285 | 16 |
309923 | 309923 | 2020-07-07 | Howard | Indiana | 18067 | 585 | 60 |
309924 | 309924 | 2020-07-07 | Huntington | Indiana | 18069 | 79 | 2 |
309925 | 309925 | 2020-07-07 | Jackson | Indiana | 18071 | 476 | 4 |
309926 | 309926 | 2020-07-07 | Jasper | Indiana | 18073 | 122 | 2 |
309927 | 309927 | 2020-07-07 | Jay | Indiana | 18075 | 73 | 0 |
309928 | 309928 | 2020-07-07 | Jefferson | Indiana | 18077 | 73 | 2 |
309929 | 309929 | 2020-07-07 | Jennings | Indiana | 18079 | 178 | 14 |
309930 | 309930 | 2020-07-07 | Johnson | Indiana | 18081 | 1317 | 125 |
309931 | 309931 | 2020-07-07 | Knox | Indiana | 18083 | 65 | 0 |
309932 | 309932 | 2020-07-07 | Kosciusko | Indiana | 18085 | 561 | 5 |
309933 | 309933 | 2020-07-07 | LaGrange | Indiana | 18087 | 473 | 9 |
309934 | 309934 | 2020-07-07 | LaPorte | Indiana | 18091 | 581 | 26 |
309935 | 309935 | 2020-07-07 | Lake | Indiana | 18089 | 5251 | 260 |
309936 | 309936 | 2020-07-07 | Lawrence | Indiana | 18093 | 247 | 26 |
309937 | 309937 | 2020-07-07 | Madison | Indiana | 18095 | 674 | 74 |
309938 | 309938 | 2020-07-07 | Marion | Indiana | 18097 | 11854 | 735 |
309939 | 309939 | 2020-07-07 | Marshall | Indiana | 18099 | 492 | 6 |
309940 | 309940 | 2020-07-07 | Martin | Indiana | 18101 | 23 | 0 |
309941 | 309941 | 2020-07-07 | Miami | Indiana | 18103 | 189 | 2 |
309942 | 309942 | 2020-07-07 | Monroe | Indiana | 18105 | 303 | 30 |
309943 | 309943 | 2020-07-07 | Montgomery | Indiana | 18107 | 299 | 21 |
309944 | 309944 | 2020-07-07 | Morgan | Indiana | 18109 | 340 | 34 |
309945 | 309945 | 2020-07-07 | Newton | Indiana | 18111 | 100 | 11 |
309946 | 309946 | 2020-07-07 | Noble | Indiana | 18113 | 488 | 29 |
309947 | 309947 | 2020-07-07 | Ohio | Indiana | 18115 | 17 | 0 |
309948 | 309948 | 2020-07-07 | Orange | Indiana | 18117 | 137 | 25 |
309949 | 309949 | 2020-07-07 | Owen | Indiana | 18119 | 49 | 1 |
309950 | 309950 | 2020-07-07 | Parke | Indiana | 18121 | 28 | 0 |
309951 | 309951 | 2020-07-07 | Perry | Indiana | 18123 | 146 | 10 |
309952 | 309952 | 2020-07-07 | Pike | Indiana | 18125 | 11 | 0 |
309953 | 309953 | 2020-07-07 | Porter | Indiana | 18127 | 744 | 39 |
309954 | 309954 | 2020-07-07 | Posey | Indiana | 18129 | 44 | 0 |
309955 | 309955 | 2020-07-07 | Pulaski | Indiana | 18131 | 67 | 1 |
309956 | 309956 | 2020-07-07 | Putnam | Indiana | 18133 | 175 | 8 |
309957 | 309957 | 2020-07-07 | Randolph | Indiana | 18135 | 105 | 4 |
309958 | 309958 | 2020-07-07 | Ripley | Indiana | 18137 | 122 | 7 |
309959 | 309959 | 2020-07-07 | Rush | Indiana | 18139 | 82 | 3 |
309960 | 309960 | 2020-07-07 | Scott | Indiana | 18143 | 166 | 9 |
309961 | 309961 | 2020-07-07 | Shelby | Indiana | 18145 | 658 | 32 |
309962 | 309962 | 2020-07-07 | Spencer | Indiana | 18147 | 44 | 1 |
309963 | 309963 | 2020-07-07 | St. Joseph | Indiana | 18141 | 1991 | 73 |
309964 | 309964 | 2020-07-07 | Starke | Indiana | 18149 | 95 | 4 |
309965 | 309965 | 2020-07-07 | Steuben | Indiana | 18151 | 130 | 2 |
309966 | 309966 | 2020-07-07 | Sullivan | Indiana | 18153 | 47 | 1 |
309967 | 309967 | 2020-07-07 | Switzerland | Indiana | 18155 | 29 | 0 |
309968 | 309968 | 2020-07-07 | Tippecanoe | Indiana | 18157 | 730 | 10 |
309969 | 309969 | 2020-07-07 | Tipton | Indiana | 18159 | 32 | 2 |
309970 | 309970 | 2020-07-07 | Union | Indiana | 18161 | 29 | 0 |
309971 | 309971 | 2020-07-07 | Vanderburgh | Indiana | 18163 | 573 | 6 |
309972 | 309972 | 2020-07-07 | Vermillion | Indiana | 18165 | 15 | 0 |
309973 | 309973 | 2020-07-07 | Vigo | Indiana | 18167 | 237 | 9 |
309974 | 309974 | 2020-07-07 | Wabash | Indiana | 18169 | 115 | 2 |
309975 | 309975 | 2020-07-07 | Warren | Indiana | 18171 | 15 | 1 |
309976 | 309976 | 2020-07-07 | Warrick | Indiana | 18173 | 223 | 31 |
309977 | 309977 | 2020-07-07 | Washington | Indiana | 18175 | 67 | 1 |
309978 | 309978 | 2020-07-07 | Wayne | Indiana | 18177 | 320 | 6 |
309979 | 309979 | 2020-07-07 | Wells | Indiana | 18179 | 92 | 1 |
309980 | 309980 | 2020-07-07 | White | Indiana | 18181 | 265 | 10 |
309981 | 309981 | 2020-07-07 | Whitley | Indiana | 18183 | 96 | 5 |
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);