ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Will" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
422037 | 422037 | 2020-08-11 | Will | Illinois | 17197 | 9413 | 346 |
418814 | 418814 | 2020-08-10 | Will | Illinois | 17197 | 9315 | 344 |
415593 | 415593 | 2020-08-09 | Will | Illinois | 17197 | 9236 | 344 |
412373 | 412373 | 2020-08-08 | Will | Illinois | 17197 | 9151 | 344 |
409154 | 409154 | 2020-08-07 | Will | Illinois | 17197 | 9120 | 345 |
405934 | 405934 | 2020-08-06 | Will | Illinois | 17197 | 9013 | 345 |
402716 | 402716 | 2020-08-05 | Will | Illinois | 17197 | 8872 | 343 |
399500 | 399500 | 2020-08-04 | Will | Illinois | 17197 | 8729 | 340 |
396284 | 396284 | 2020-08-03 | Will | Illinois | 17197 | 8715 | 339 |
393068 | 393068 | 2020-08-02 | Will | Illinois | 17197 | 8592 | 339 |
389851 | 389851 | 2020-08-01 | Will | Illinois | 17197 | 8502 | 339 |
386634 | 386634 | 2020-07-31 | Will | Illinois | 17197 | 8474 | 339 |
383416 | 383416 | 2020-07-30 | Will | Illinois | 17197 | 8417 | 338 |
380199 | 380199 | 2020-07-29 | Will | Illinois | 17197 | 8260 | 338 |
376982 | 376982 | 2020-07-28 | Will | Illinois | 17197 | 8230 | 338 |
373767 | 373767 | 2020-07-27 | Will | Illinois | 17197 | 8148 | 338 |
370555 | 370555 | 2020-07-26 | Will | Illinois | 17197 | 8101 | 338 |
367345 | 367345 | 2020-07-25 | Will | Illinois | 17197 | 8024 | 338 |
364138 | 364138 | 2020-07-24 | Will | Illinois | 17197 | 7997 | 338 |
360931 | 360931 | 2020-07-23 | Will | Illinois | 17197 | 7925 | 338 |
357726 | 357726 | 2020-07-22 | Will | Illinois | 17197 | 7845 | 336 |
354524 | 354524 | 2020-07-21 | Will | Illinois | 17197 | 7762 | 336 |
351322 | 351322 | 2020-07-20 | Will | Illinois | 17197 | 7710 | 336 |
348122 | 348122 | 2020-07-19 | Will | Illinois | 17197 | 7652 | 333 |
344921 | 344921 | 2020-07-18 | Will | Illinois | 17197 | 7592 | 331 |
341721 | 341721 | 2020-07-17 | Will | Illinois | 17197 | 7542 | 330 |
338525 | 338525 | 2020-07-16 | Will | Illinois | 17197 | 7476 | 330 |
335329 | 335329 | 2020-07-15 | Will | Illinois | 17197 | 7449 | 328 |
332136 | 332136 | 2020-07-14 | Will | Illinois | 17197 | 7401 | 326 |
328949 | 328949 | 2020-07-13 | Will | Illinois | 17197 | 7340 | 326 |
325763 | 325763 | 2020-07-12 | Will | Illinois | 17197 | 7278 | 326 |
322582 | 322582 | 2020-07-11 | Will | Illinois | 17197 | 7223 | 325 |
319403 | 319403 | 2020-07-10 | Will | Illinois | 17197 | 7176 | 324 |
316230 | 316230 | 2020-07-09 | Will | Illinois | 17197 | 7137 | 323 |
313056 | 313056 | 2020-07-08 | Will | Illinois | 17197 | 7077 | 323 |
309886 | 309886 | 2020-07-07 | Will | Illinois | 17197 | 6996 | 322 |
306718 | 306718 | 2020-07-06 | Will | Illinois | 17197 | 6957 | 320 |
303553 | 303553 | 2020-07-05 | Will | Illinois | 17197 | 6923 | 320 |
300389 | 300389 | 2020-07-04 | Will | Illinois | 17197 | 6883 | 320 |
297227 | 297227 | 2020-07-03 | Will | Illinois | 17197 | 6839 | 320 |
294069 | 294069 | 2020-07-02 | Will | Illinois | 17197 | 6801 | 321 |
290915 | 290915 | 2020-07-01 | Will | Illinois | 17197 | 6744 | 320 |
287765 | 287765 | 2020-06-30 | Will | Illinois | 17197 | 6686 | 321 |
284616 | 284616 | 2020-06-29 | Will | Illinois | 17197 | 6635 | 319 |
281471 | 281471 | 2020-06-28 | Will | Illinois | 17197 | 6608 | 319 |
278323 | 278323 | 2020-06-27 | Will | Illinois | 17197 | 6577 | 316 |
275175 | 275175 | 2020-06-26 | Will | Illinois | 17197 | 6542 | 316 |
272033 | 272033 | 2020-06-25 | Will | Illinois | 17197 | 6504 | 316 |
268896 | 268896 | 2020-06-24 | Will | Illinois | 17197 | 6480 | 315 |
265766 | 265766 | 2020-06-23 | Will | Illinois | 17197 | 6446 | 310 |
262638 | 262638 | 2020-06-22 | Will | Illinois | 17197 | 6398 | 310 |
259511 | 259511 | 2020-06-21 | Will | Illinois | 17197 | 6367 | 310 |
256385 | 256385 | 2020-06-20 | Will | Illinois | 17197 | 6317 | 310 |
253265 | 253265 | 2020-06-19 | Will | Illinois | 17197 | 6301 | 310 |
250150 | 250150 | 2020-06-18 | Will | Illinois | 17197 | 6258 | 310 |
247038 | 247038 | 2020-06-17 | Will | Illinois | 17197 | 6222 | 308 |
243925 | 243925 | 2020-06-16 | Will | Illinois | 17197 | 6207 | 303 |
240814 | 240814 | 2020-06-15 | Will | Illinois | 17197 | 6158 | 302 |
237706 | 237706 | 2020-06-14 | Will | Illinois | 17197 | 6140 | 302 |
234599 | 234599 | 2020-06-13 | Will | Illinois | 17197 | 6106 | 301 |
231493 | 231493 | 2020-06-12 | Will | Illinois | 17197 | 6100 | 300 |
228390 | 228390 | 2020-06-11 | Will | Illinois | 17197 | 6051 | 297 |
225288 | 225288 | 2020-06-10 | Will | Illinois | 17197 | 6025 | 296 |
222193 | 222193 | 2020-06-09 | Will | Illinois | 17197 | 5961 | 295 |
219098 | 219098 | 2020-06-08 | Will | Illinois | 17197 | 5942 | 289 |
216006 | 216006 | 2020-06-07 | Will | Illinois | 17197 | 5890 | 288 |
212919 | 212919 | 2020-06-06 | Will | Illinois | 17197 | 5858 | 285 |
209834 | 209834 | 2020-06-05 | Will | Illinois | 17197 | 5799 | 285 |
206753 | 206753 | 2020-06-04 | Will | Illinois | 17197 | 5752 | 286 |
203673 | 203673 | 2020-06-03 | Will | Illinois | 17197 | 5730 | 283 |
200597 | 200597 | 2020-06-02 | Will | Illinois | 17197 | 5649 | 280 |
197524 | 197524 | 2020-06-01 | Will | Illinois | 17197 | 5641 | 279 |
194454 | 194454 | 2020-05-31 | Will | Illinois | 17197 | 5566 | 276 |
191387 | 191387 | 2020-05-30 | Will | Illinois | 17197 | 5510 | 273 |
188322 | 188322 | 2020-05-29 | Will | Illinois | 17197 | 5459 | 269 |
185264 | 185264 | 2020-05-28 | Will | Illinois | 17197 | 5356 | 268 |
182210 | 182210 | 2020-05-27 | Will | Illinois | 17197 | 5301 | 264 |
179166 | 179166 | 2020-05-26 | Will | Illinois | 17197 | 5255 | 259 |
176122 | 176122 | 2020-05-25 | Will | Illinois | 17197 | 5188 | 258 |
173078 | 173078 | 2020-05-24 | Will | Illinois | 17197 | 5117 | 257 |
170037 | 170037 | 2020-05-23 | Will | Illinois | 17197 | 5012 | 257 |
167000 | 167000 | 2020-05-22 | Will | Illinois | 17197 | 4966 | 255 |
163967 | 163967 | 2020-05-21 | Will | Illinois | 17197 | 4811 | 252 |
160939 | 160939 | 2020-05-20 | Will | Illinois | 17197 | 4718 | 248 |
157913 | 157913 | 2020-05-19 | Will | Illinois | 17197 | 4577 | 244 |
154897 | 154897 | 2020-05-18 | Will | Illinois | 17197 | 4508 | 240 |
151885 | 151885 | 2020-05-17 | Will | Illinois | 17197 | 4388 | 240 |
148876 | 148876 | 2020-05-16 | Will | Illinois | 17197 | 4312 | 240 |
145872 | 145872 | 2020-05-15 | Will | Illinois | 17197 | 4277 | 237 |
142872 | 142872 | 2020-05-14 | Will | Illinois | 17197 | 4090 | 231 |
139876 | 139876 | 2020-05-13 | Will | Illinois | 17197 | 3973 | 214 |
136884 | 136884 | 2020-05-12 | Will | Illinois | 17197 | 3896 | 210 |
133895 | 133895 | 2020-05-11 | Will | Illinois | 17197 | 3740 | 202 |
130905 | 130905 | 2020-05-10 | Will | Illinois | 17197 | 3684 | 202 |
127914 | 127914 | 2020-05-09 | Will | Illinois | 17197 | 3636 | 202 |
124927 | 124927 | 2020-05-08 | Will | Illinois | 17197 | 3561 | 199 |
121947 | 121947 | 2020-05-07 | Will | Illinois | 17197 | 3434 | 195 |
118977 | 118977 | 2020-05-06 | Will | Illinois | 17197 | 3332 | 189 |
116017 | 116017 | 2020-05-05 | Will | Illinois | 17197 | 3150 | 178 |
113134 | 113134 | 2020-05-04 | Will | Illinois | 17197 | 3066 | 169 |
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);