ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Kane" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281417 | 281417 | 2020-06-28 | Kane | Illinois | 17089 | 7683 | 266 |
283579 | 283579 | 2020-06-28 | Kane | Utah | 49025 | 6 | 0 |
278269 | 278269 | 2020-06-27 | Kane | Illinois | 17089 | 7656 | 265 |
280433 | 280433 | 2020-06-27 | Kane | Utah | 49025 | 6 | 0 |
275121 | 275121 | 2020-06-26 | Kane | Illinois | 17089 | 7638 | 262 |
277285 | 277285 | 2020-06-26 | Kane | Utah | 49025 | 6 | 0 |
271979 | 271979 | 2020-06-25 | Kane | Illinois | 17089 | 7597 | 257 |
274137 | 274137 | 2020-06-25 | Kane | Utah | 49025 | 6 | 0 |
268842 | 268842 | 2020-06-24 | Kane | Illinois | 17089 | 7553 | 255 |
270997 | 270997 | 2020-06-24 | Kane | Utah | 49025 | 6 | 0 |
265712 | 265712 | 2020-06-23 | Kane | Illinois | 17089 | 7514 | 254 |
267863 | 267863 | 2020-06-23 | Kane | Utah | 49025 | 6 | 0 |
262584 | 262584 | 2020-06-22 | Kane | Illinois | 17089 | 7485 | 252 |
264734 | 264734 | 2020-06-22 | Kane | Utah | 49025 | 5 | 0 |
259457 | 259457 | 2020-06-21 | Kane | Illinois | 17089 | 7461 | 251 |
261605 | 261605 | 2020-06-21 | Kane | Utah | 49025 | 5 | 0 |
256331 | 256331 | 2020-06-20 | Kane | Illinois | 17089 | 7415 | 250 |
258478 | 258478 | 2020-06-20 | Kane | Utah | 49025 | 5 | 0 |
253211 | 253211 | 2020-06-19 | Kane | Illinois | 17089 | 7342 | 245 |
255351 | 255351 | 2020-06-19 | Kane | Utah | 49025 | 5 | 0 |
250096 | 250096 | 2020-06-18 | Kane | Illinois | 17089 | 7286 | 242 |
252234 | 252234 | 2020-06-18 | Kane | Utah | 49025 | 4 | 0 |
246984 | 246984 | 2020-06-17 | Kane | Illinois | 17089 | 7246 | 240 |
249119 | 249119 | 2020-06-17 | Kane | Utah | 49025 | 4 | 0 |
243871 | 243871 | 2020-06-16 | Kane | Illinois | 17089 | 7223 | 234 |
246006 | 246006 | 2020-06-16 | Kane | Utah | 49025 | 4 | 0 |
240760 | 240760 | 2020-06-15 | Kane | Illinois | 17089 | 7175 | 234 |
242894 | 242894 | 2020-06-15 | Kane | Utah | 49025 | 4 | 0 |
237652 | 237652 | 2020-06-14 | Kane | Illinois | 17089 | 7154 | 231 |
239783 | 239783 | 2020-06-14 | Kane | Utah | 49025 | 4 | 0 |
234545 | 234545 | 2020-06-13 | Kane | Illinois | 17089 | 7126 | 230 |
236675 | 236675 | 2020-06-13 | Kane | Utah | 49025 | 4 | 0 |
231439 | 231439 | 2020-06-12 | Kane | Illinois | 17089 | 7074 | 228 |
233568 | 233568 | 2020-06-12 | Kane | Utah | 49025 | 4 | 0 |
228336 | 228336 | 2020-06-11 | Kane | Illinois | 17089 | 7053 | 227 |
230464 | 230464 | 2020-06-11 | Kane | Utah | 49025 | 4 | 0 |
225234 | 225234 | 2020-06-10 | Kane | Illinois | 17089 | 6956 | 221 |
227360 | 227360 | 2020-06-10 | Kane | Utah | 49025 | 4 | 0 |
222139 | 222139 | 2020-06-09 | Kane | Illinois | 17089 | 6956 | 221 |
224260 | 224260 | 2020-06-09 | Kane | Utah | 49025 | 4 | 0 |
219044 | 219044 | 2020-06-08 | Kane | Illinois | 17089 | 6906 | 215 |
221164 | 221164 | 2020-06-08 | Kane | Utah | 49025 | 4 | 0 |
215953 | 215953 | 2020-06-07 | Kane | Illinois | 17089 | 6859 | 215 |
218072 | 218072 | 2020-06-07 | Kane | Utah | 49025 | 3 | 0 |
212866 | 212866 | 2020-06-06 | Kane | Illinois | 17089 | 6793 | 215 |
214982 | 214982 | 2020-06-06 | Kane | Utah | 49025 | 3 | 0 |
209781 | 209781 | 2020-06-05 | Kane | Illinois | 17089 | 6736 | 207 |
211895 | 211895 | 2020-06-05 | Kane | Utah | 49025 | 3 | 0 |
206700 | 206700 | 2020-06-04 | Kane | Illinois | 17089 | 6638 | 198 |
208810 | 208810 | 2020-06-04 | Kane | Utah | 49025 | 3 | 0 |
203620 | 203620 | 2020-06-03 | Kane | Illinois | 17089 | 6590 | 194 |
205728 | 205728 | 2020-06-03 | Kane | Utah | 49025 | 3 | 0 |
200544 | 200544 | 2020-06-02 | Kane | Illinois | 17089 | 6514 | 188 |
202649 | 202649 | 2020-06-02 | Kane | Utah | 49025 | 3 | 0 |
197471 | 197471 | 2020-06-01 | Kane | Illinois | 17089 | 6461 | 178 |
199573 | 199573 | 2020-06-01 | Kane | Utah | 49025 | 3 | 0 |
194401 | 194401 | 2020-05-31 | Kane | Illinois | 17089 | 6408 | 178 |
196500 | 196500 | 2020-05-31 | Kane | Utah | 49025 | 3 | 0 |
191334 | 191334 | 2020-05-30 | Kane | Illinois | 17089 | 6327 | 176 |
193430 | 193430 | 2020-05-30 | Kane | Utah | 49025 | 3 | 0 |
188269 | 188269 | 2020-05-29 | Kane | Illinois | 17089 | 6235 | 170 |
190364 | 190364 | 2020-05-29 | Kane | Utah | 49025 | 3 | 0 |
185211 | 185211 | 2020-05-28 | Kane | Illinois | 17089 | 6145 | 167 |
187300 | 187300 | 2020-05-28 | Kane | Utah | 49025 | 3 | 0 |
182157 | 182157 | 2020-05-27 | Kane | Illinois | 17089 | 6000 | 163 |
184243 | 184243 | 2020-05-27 | Kane | Utah | 49025 | 3 | 0 |
179113 | 179113 | 2020-05-26 | Kane | Illinois | 17089 | 5920 | 155 |
181192 | 181192 | 2020-05-26 | Kane | Utah | 49025 | 3 | 0 |
176069 | 176069 | 2020-05-25 | Kane | Illinois | 17089 | 5846 | 152 |
178148 | 178148 | 2020-05-25 | Kane | Utah | 49025 | 3 | 0 |
173025 | 173025 | 2020-05-24 | Kane | Illinois | 17089 | 5703 | 152 |
175103 | 175103 | 2020-05-24 | Kane | Utah | 49025 | 3 | 0 |
169984 | 169984 | 2020-05-23 | Kane | Illinois | 17089 | 5575 | 152 |
172060 | 172060 | 2020-05-23 | Kane | Utah | 49025 | 3 | 0 |
166947 | 166947 | 2020-05-22 | Kane | Illinois | 17089 | 5327 | 150 |
169019 | 169019 | 2020-05-22 | Kane | Utah | 49025 | 3 | 0 |
163914 | 163914 | 2020-05-21 | Kane | Illinois | 17089 | 4981 | 145 |
165983 | 165983 | 2020-05-21 | Kane | Utah | 49025 | 3 | 0 |
160886 | 160886 | 2020-05-20 | Kane | Illinois | 17089 | 4813 | 136 |
162954 | 162954 | 2020-05-20 | Kane | Utah | 49025 | 3 | 0 |
157860 | 157860 | 2020-05-19 | Kane | Illinois | 17089 | 4682 | 120 |
159926 | 159926 | 2020-05-19 | Kane | Utah | 49025 | 3 | 0 |
154844 | 154844 | 2020-05-18 | Kane | Illinois | 17089 | 4584 | 115 |
156902 | 156902 | 2020-05-18 | Kane | Utah | 49025 | 3 | 0 |
151832 | 151832 | 2020-05-17 | Kane | Illinois | 17089 | 4396 | 115 |
153885 | 153885 | 2020-05-17 | Kane | Utah | 49025 | 3 | 0 |
148823 | 148823 | 2020-05-16 | Kane | Illinois | 17089 | 4263 | 109 |
150874 | 150874 | 2020-05-16 | Kane | Utah | 49025 | 3 | 0 |
145820 | 145820 | 2020-05-15 | Kane | Illinois | 17089 | 4159 | 107 |
147866 | 147866 | 2020-05-15 | Kane | Utah | 49025 | 3 | 0 |
142820 | 142820 | 2020-05-14 | Kane | Illinois | 17089 | 3995 | 104 |
144862 | 144862 | 2020-05-14 | Kane | Utah | 49025 | 3 | 0 |
139824 | 139824 | 2020-05-13 | Kane | Illinois | 17089 | 3744 | 98 |
141865 | 141865 | 2020-05-13 | Kane | Utah | 49025 | 3 | 0 |
136832 | 136832 | 2020-05-12 | Kane | Illinois | 17089 | 3592 | 93 |
138869 | 138869 | 2020-05-12 | Kane | Utah | 49025 | 3 | 0 |
133843 | 133843 | 2020-05-11 | Kane | Illinois | 17089 | 3126 | 90 |
135879 | 135879 | 2020-05-11 | Kane | Utah | 49025 | 3 | 0 |
130852 | 130852 | 2020-05-10 | Kane | Illinois | 17089 | 3003 | 89 |
132888 | 132888 | 2020-05-10 | Kane | Utah | 49025 | 3 | 0 |
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);