ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-09-06" 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 |
---|---|---|---|---|---|---|---|
506010 | 506010 | 2020-09-06 | Adams | Indiana | 18001 | 196 | 4 |
506011 | 506011 | 2020-09-06 | Allen | Indiana | 18003 | 5321 | 192 |
506012 | 506012 | 2020-09-06 | Bartholomew | Indiana | 18005 | 1103 | 58 |
506013 | 506013 | 2020-09-06 | Benton | Indiana | 18007 | 84 | 0 |
506014 | 506014 | 2020-09-06 | Blackford | Indiana | 18009 | 90 | 2 |
506015 | 506015 | 2020-09-06 | Boone | Indiana | 18011 | 909 | 49 |
506016 | 506016 | 2020-09-06 | Brown | Indiana | 18013 | 91 | 2 |
506017 | 506017 | 2020-09-06 | Carroll | Indiana | 18015 | 260 | 13 |
506018 | 506018 | 2020-09-06 | Cass | Indiana | 18017 | 1897 | 10 |
506019 | 506019 | 2020-09-06 | Clark | Indiana | 18019 | 1888 | 60 |
506020 | 506020 | 2020-09-06 | Clay | Indiana | 18021 | 250 | 5 |
506021 | 506021 | 2020-09-06 | Clinton | Indiana | 18023 | 574 | 15 |
506022 | 506022 | 2020-09-06 | Crawford | Indiana | 18025 | 76 | 1 |
506023 | 506023 | 2020-09-06 | Daviess | Indiana | 18027 | 544 | 26 |
506024 | 506024 | 2020-09-06 | DeKalb | Indiana | 18033 | 375 | 8 |
506025 | 506025 | 2020-09-06 | Dearborn | Indiana | 18029 | 595 | 30 |
506026 | 506026 | 2020-09-06 | Decatur | Indiana | 18031 | 454 | 39 |
506027 | 506027 | 2020-09-06 | Delaware | Indiana | 18035 | 1573 | 58 |
506028 | 506028 | 2020-09-06 | Dubois | Indiana | 18037 | 873 | 17 |
506029 | 506029 | 2020-09-06 | Elkhart | Indiana | 18039 | 5906 | 103 |
506030 | 506030 | 2020-09-06 | Fayette | Indiana | 18041 | 473 | 10 |
506031 | 506031 | 2020-09-06 | Floyd | Indiana | 18043 | 1149 | 60 |
506032 | 506032 | 2020-09-06 | Fountain | Indiana | 18045 | 101 | 2 |
506033 | 506033 | 2020-09-06 | Franklin | Indiana | 18047 | 291 | 26 |
506034 | 506034 | 2020-09-06 | Fulton | Indiana | 18049 | 211 | 2 |
506035 | 506035 | 2020-09-06 | Gibson | Indiana | 18051 | 345 | 4 |
506036 | 506036 | 2020-09-06 | Grant | Indiana | 18053 | 1049 | 34 |
506037 | 506037 | 2020-09-06 | Greene | Indiana | 18055 | 382 | 38 |
506038 | 506038 | 2020-09-06 | Hamilton | Indiana | 18057 | 4232 | 116 |
506039 | 506039 | 2020-09-06 | Hancock | Indiana | 18059 | 861 | 45 |
506040 | 506040 | 2020-09-06 | Harrison | Indiana | 18061 | 514 | 26 |
506041 | 506041 | 2020-09-06 | Hendricks | Indiana | 18063 | 2482 | 134 |
506042 | 506042 | 2020-09-06 | Henry | Indiana | 18065 | 667 | 22 |
506043 | 506043 | 2020-09-06 | Howard | Indiana | 18067 | 1154 | 65 |
506044 | 506044 | 2020-09-06 | Huntington | Indiana | 18069 | 184 | 3 |
506045 | 506045 | 2020-09-06 | Jackson | Indiana | 18071 | 716 | 10 |
506046 | 506046 | 2020-09-06 | Jasper | Indiana | 18073 | 342 | 2 |
506047 | 506047 | 2020-09-06 | Jay | Indiana | 18075 | 146 | 0 |
506048 | 506048 | 2020-09-06 | Jefferson | Indiana | 18077 | 220 | 3 |
506049 | 506049 | 2020-09-06 | Jennings | Indiana | 18079 | 285 | 14 |
506050 | 506050 | 2020-09-06 | Johnson | Indiana | 18081 | 2126 | 131 |
506051 | 506051 | 2020-09-06 | Knox | Indiana | 18083 | 385 | 6 |
506052 | 506052 | 2020-09-06 | Kosciusko | Indiana | 18085 | 1105 | 19 |
506053 | 506053 | 2020-09-06 | LaGrange | Indiana | 18087 | 619 | 11 |
506054 | 506054 | 2020-09-06 | LaPorte | Indiana | 18091 | 1233 | 37 |
506055 | 506055 | 2020-09-06 | Lake | Indiana | 18089 | 9546 | 316 |
506056 | 506056 | 2020-09-06 | Lawrence | Indiana | 18093 | 482 | 29 |
506057 | 506057 | 2020-09-06 | Madison | Indiana | 18095 | 1418 | 85 |
506058 | 506058 | 2020-09-06 | Marion | Indiana | 18097 | 19363 | 801 |
506059 | 506059 | 2020-09-06 | Marshall | Indiana | 18099 | 927 | 23 |
506060 | 506060 | 2020-09-06 | Martin | Indiana | 18101 | 128 | 0 |
506061 | 506061 | 2020-09-06 | Miami | Indiana | 18103 | 347 | 2 |
506062 | 506062 | 2020-09-06 | Monroe | Indiana | 18105 | 1439 | 40 |
506063 | 506063 | 2020-09-06 | Montgomery | Indiana | 18107 | 467 | 22 |
506064 | 506064 | 2020-09-06 | Morgan | Indiana | 18109 | 634 | 38 |
506065 | 506065 | 2020-09-06 | Newton | Indiana | 18111 | 152 | 11 |
506066 | 506066 | 2020-09-06 | Noble | Indiana | 18113 | 839 | 32 |
506067 | 506067 | 2020-09-06 | Ohio | Indiana | 18115 | 74 | 7 |
506068 | 506068 | 2020-09-06 | Orange | Indiana | 18117 | 262 | 26 |
506069 | 506069 | 2020-09-06 | Owen | Indiana | 18119 | 155 | 2 |
506070 | 506070 | 2020-09-06 | Parke | Indiana | 18121 | 88 | 2 |
506071 | 506071 | 2020-09-06 | Perry | Indiana | 18123 | 209 | 15 |
506072 | 506072 | 2020-09-06 | Pike | Indiana | 18125 | 113 | 1 |
506073 | 506073 | 2020-09-06 | Porter | Indiana | 18127 | 1850 | 44 |
506074 | 506074 | 2020-09-06 | Posey | Indiana | 18129 | 231 | 0 |
506075 | 506075 | 2020-09-06 | Pulaski | Indiana | 18131 | 106 | 1 |
506076 | 506076 | 2020-09-06 | Putnam | Indiana | 18133 | 464 | 8 |
506077 | 506077 | 2020-09-06 | Randolph | Indiana | 18135 | 224 | 7 |
506078 | 506078 | 2020-09-06 | Ripley | Indiana | 18137 | 252 | 8 |
506079 | 506079 | 2020-09-06 | Rush | Indiana | 18139 | 180 | 4 |
506080 | 506080 | 2020-09-06 | Scott | Indiana | 18143 | 329 | 12 |
506081 | 506081 | 2020-09-06 | Shelby | Indiana | 18145 | 1097 | 36 |
506082 | 506082 | 2020-09-06 | Spencer | Indiana | 18147 | 175 | 3 |
506083 | 506083 | 2020-09-06 | St. Joseph | Indiana | 18141 | 5450 | 101 |
506084 | 506084 | 2020-09-06 | Starke | Indiana | 18149 | 217 | 8 |
506085 | 506085 | 2020-09-06 | Steuben | Indiana | 18151 | 316 | 6 |
506086 | 506086 | 2020-09-06 | Sullivan | Indiana | 18153 | 312 | 10 |
506087 | 506087 | 2020-09-06 | Switzerland | Indiana | 18155 | 66 | 0 |
506088 | 506088 | 2020-09-06 | Tippecanoe | Indiana | 18157 | 1739 | 14 |
506089 | 506089 | 2020-09-06 | Tipton | Indiana | 18159 | 204 | 25 |
506090 | 506090 | 2020-09-06 | Union | Indiana | 18161 | 91 | 0 |
506091 | 506091 | 2020-09-06 | Vanderburgh | Indiana | 18163 | 2756 | 23 |
506092 | 506092 | 2020-09-06 | Vermillion | Indiana | 18165 | 110 | 0 |
506093 | 506093 | 2020-09-06 | Vigo | Indiana | 18167 | 1518 | 18 |
506094 | 506094 | 2020-09-06 | Wabash | Indiana | 18169 | 233 | 6 |
506095 | 506095 | 2020-09-06 | Warren | Indiana | 18171 | 39 | 1 |
506096 | 506096 | 2020-09-06 | Warrick | Indiana | 18173 | 854 | 33 |
506097 | 506097 | 2020-09-06 | Washington | Indiana | 18175 | 239 | 1 |
506098 | 506098 | 2020-09-06 | Wayne | Indiana | 18177 | 981 | 10 |
506099 | 506099 | 2020-09-06 | Wells | Indiana | 18179 | 238 | 2 |
506100 | 506100 | 2020-09-06 | White | Indiana | 18181 | 463 | 13 |
506101 | 506101 | 2020-09-06 | Whitley | Indiana | 18183 | 229 | 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);