ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-08-24" 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 |
---|---|---|---|---|---|---|---|
463984 | 463984 | 2020-08-24 | Adams | Indiana | 18001 | 160 | 3 |
463985 | 463985 | 2020-08-24 | Allen | Indiana | 18003 | 4676 | 182 |
463986 | 463986 | 2020-08-24 | Bartholomew | Indiana | 18005 | 1027 | 54 |
463987 | 463987 | 2020-08-24 | Benton | Indiana | 18007 | 76 | 0 |
463988 | 463988 | 2020-08-24 | Blackford | Indiana | 18009 | 76 | 2 |
463989 | 463989 | 2020-08-24 | Boone | Indiana | 18011 | 804 | 49 |
463990 | 463990 | 2020-08-24 | Brown | Indiana | 18013 | 83 | 2 |
463991 | 463991 | 2020-08-24 | Carroll | Indiana | 18015 | 249 | 11 |
463992 | 463992 | 2020-08-24 | Cass | Indiana | 18017 | 1845 | 10 |
463993 | 463993 | 2020-08-24 | Clark | Indiana | 18019 | 1618 | 58 |
463994 | 463994 | 2020-08-24 | Clay | Indiana | 18021 | 207 | 5 |
463995 | 463995 | 2020-08-24 | Clinton | Indiana | 18023 | 522 | 7 |
463996 | 463996 | 2020-08-24 | Crawford | Indiana | 18025 | 56 | 1 |
463997 | 463997 | 2020-08-24 | Daviess | Indiana | 18027 | 409 | 25 |
463998 | 463998 | 2020-08-24 | DeKalb | Indiana | 18033 | 287 | 5 |
463999 | 463999 | 2020-08-24 | Dearborn | Indiana | 18029 | 563 | 30 |
464000 | 464000 | 2020-08-24 | Decatur | Indiana | 18031 | 397 | 36 |
464001 | 464001 | 2020-08-24 | Delaware | Indiana | 18035 | 901 | 54 |
464002 | 464002 | 2020-08-24 | Dubois | Indiana | 18037 | 796 | 17 |
464003 | 464003 | 2020-08-24 | Elkhart | Indiana | 18039 | 5475 | 99 |
464004 | 464004 | 2020-08-24 | Fayette | Indiana | 18041 | 372 | 8 |
464005 | 464005 | 2020-08-24 | Floyd | Indiana | 18043 | 1001 | 57 |
464006 | 464006 | 2020-08-24 | Fountain | Indiana | 18045 | 82 | 2 |
464007 | 464007 | 2020-08-24 | Franklin | Indiana | 18047 | 271 | 23 |
464008 | 464008 | 2020-08-24 | Fulton | Indiana | 18049 | 198 | 2 |
464009 | 464009 | 2020-08-24 | Gibson | Indiana | 18051 | 289 | 4 |
464010 | 464010 | 2020-08-24 | Grant | Indiana | 18053 | 897 | 33 |
464011 | 464011 | 2020-08-24 | Greene | Indiana | 18055 | 340 | 38 |
464012 | 464012 | 2020-08-24 | Hamilton | Indiana | 18057 | 3560 | 115 |
464013 | 464013 | 2020-08-24 | Hancock | Indiana | 18059 | 790 | 44 |
464014 | 464014 | 2020-08-24 | Harrison | Indiana | 18061 | 440 | 26 |
464015 | 464015 | 2020-08-24 | Hendricks | Indiana | 18063 | 2199 | 127 |
464016 | 464016 | 2020-08-24 | Henry | Indiana | 18065 | 563 | 21 |
464017 | 464017 | 2020-08-24 | Howard | Indiana | 18067 | 1034 | 64 |
464018 | 464018 | 2020-08-24 | Huntington | Indiana | 18069 | 157 | 3 |
464019 | 464019 | 2020-08-24 | Jackson | Indiana | 18071 | 676 | 8 |
464020 | 464020 | 2020-08-24 | Jasper | Indiana | 18073 | 302 | 2 |
464021 | 464021 | 2020-08-24 | Jay | Indiana | 18075 | 120 | 0 |
464022 | 464022 | 2020-08-24 | Jefferson | Indiana | 18077 | 199 | 3 |
464023 | 464023 | 2020-08-24 | Jennings | Indiana | 18079 | 257 | 14 |
464024 | 464024 | 2020-08-24 | Johnson | Indiana | 18081 | 1978 | 128 |
464025 | 464025 | 2020-08-24 | Knox | Indiana | 18083 | 280 | 3 |
464026 | 464026 | 2020-08-24 | Kosciusko | Indiana | 18085 | 1005 | 13 |
464027 | 464027 | 2020-08-24 | LaGrange | Indiana | 18087 | 583 | 11 |
464028 | 464028 | 2020-08-24 | LaPorte | Indiana | 18091 | 1118 | 31 |
464029 | 464029 | 2020-08-24 | Lake | Indiana | 18089 | 8760 | 310 |
464030 | 464030 | 2020-08-24 | Lawrence | Indiana | 18093 | 420 | 29 |
464031 | 464031 | 2020-08-24 | Madison | Indiana | 18095 | 1217 | 78 |
464032 | 464032 | 2020-08-24 | Marion | Indiana | 18097 | 17757 | 794 |
464033 | 464033 | 2020-08-24 | Marshall | Indiana | 18099 | 858 | 23 |
464034 | 464034 | 2020-08-24 | Martin | Indiana | 18101 | 75 | 0 |
464035 | 464035 | 2020-08-24 | Miami | Indiana | 18103 | 310 | 2 |
464036 | 464036 | 2020-08-24 | Monroe | Indiana | 18105 | 957 | 40 |
464037 | 464037 | 2020-08-24 | Montgomery | Indiana | 18107 | 390 | 22 |
464038 | 464038 | 2020-08-24 | Morgan | Indiana | 18109 | 565 | 38 |
464039 | 464039 | 2020-08-24 | Newton | Indiana | 18111 | 134 | 11 |
464040 | 464040 | 2020-08-24 | Noble | Indiana | 18113 | 777 | 31 |
464041 | 464041 | 2020-08-24 | Ohio | Indiana | 18115 | 70 | 7 |
464042 | 464042 | 2020-08-24 | Orange | Indiana | 18117 | 216 | 26 |
464043 | 464043 | 2020-08-24 | Owen | Indiana | 18119 | 133 | 2 |
464044 | 464044 | 2020-08-24 | Parke | Indiana | 18121 | 81 | 2 |
464045 | 464045 | 2020-08-24 | Perry | Indiana | 18123 | 206 | 14 |
464046 | 464046 | 2020-08-24 | Pike | Indiana | 18125 | 80 | 1 |
464047 | 464047 | 2020-08-24 | Porter | Indiana | 18127 | 1593 | 42 |
464048 | 464048 | 2020-08-24 | Posey | Indiana | 18129 | 202 | 0 |
464049 | 464049 | 2020-08-24 | Pulaski | Indiana | 18131 | 94 | 1 |
464050 | 464050 | 2020-08-24 | Putnam | Indiana | 18133 | 406 | 8 |
464051 | 464051 | 2020-08-24 | Randolph | Indiana | 18135 | 182 | 6 |
464052 | 464052 | 2020-08-24 | Ripley | Indiana | 18137 | 234 | 8 |
464053 | 464053 | 2020-08-24 | Rush | Indiana | 18139 | 166 | 4 |
464054 | 464054 | 2020-08-24 | Scott | Indiana | 18143 | 309 | 12 |
464055 | 464055 | 2020-08-24 | Shelby | Indiana | 18145 | 1020 | 36 |
464056 | 464056 | 2020-08-24 | Spencer | Indiana | 18147 | 153 | 3 |
464057 | 464057 | 2020-08-24 | St. Joseph | Indiana | 18141 | 4557 | 93 |
464058 | 464058 | 2020-08-24 | Starke | Indiana | 18149 | 191 | 8 |
464059 | 464059 | 2020-08-24 | Steuben | Indiana | 18151 | 246 | 3 |
464060 | 464060 | 2020-08-24 | Sullivan | Indiana | 18153 | 262 | 5 |
464061 | 464061 | 2020-08-24 | Switzerland | Indiana | 18155 | 65 | 0 |
464062 | 464062 | 2020-08-24 | Tippecanoe | Indiana | 18157 | 1467 | 14 |
464063 | 464063 | 2020-08-24 | Tipton | Indiana | 18159 | 173 | 21 |
464064 | 464064 | 2020-08-24 | Union | Indiana | 18161 | 80 | 0 |
464065 | 464065 | 2020-08-24 | Vanderburgh | Indiana | 18163 | 2364 | 17 |
464066 | 464066 | 2020-08-24 | Vermillion | Indiana | 18165 | 82 | 0 |
464067 | 464067 | 2020-08-24 | Vigo | Indiana | 18167 | 1050 | 16 |
464068 | 464068 | 2020-08-24 | Wabash | Indiana | 18169 | 199 | 5 |
464069 | 464069 | 2020-08-24 | Warren | Indiana | 18171 | 35 | 1 |
464070 | 464070 | 2020-08-24 | Warrick | Indiana | 18173 | 701 | 32 |
464071 | 464071 | 2020-08-24 | Washington | Indiana | 18175 | 190 | 1 |
464072 | 464072 | 2020-08-24 | Wayne | Indiana | 18177 | 820 | 10 |
464073 | 464073 | 2020-08-24 | Wells | Indiana | 18179 | 211 | 2 |
464074 | 464074 | 2020-08-24 | White | Indiana | 18181 | 414 | 11 |
464075 | 464075 | 2020-08-24 | Whitley | Indiana | 18183 | 192 | 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);