ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 17197 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531885 | 531885 | 2020-09-14 | Will | Illinois | 17197 | 12888 | 367 |
528648 | 528648 | 2020-09-13 | Will | Illinois | 17197 | 12820 | 367 |
525412 | 525412 | 2020-09-12 | Will | Illinois | 17197 | 12770 | 367 |
522176 | 522176 | 2020-09-11 | Will | Illinois | 17197 | 12681 | 367 |
518939 | 518939 | 2020-09-10 | Will | Illinois | 17197 | 12591 | 365 |
515704 | 515704 | 2020-09-09 | Will | Illinois | 17197 | 12514 | 364 |
512471 | 512471 | 2020-09-08 | Will | Illinois | 17197 | 12415 | 361 |
509238 | 509238 | 2020-09-07 | Will | Illinois | 17197 | 12337 | 361 |
506006 | 506006 | 2020-09-06 | Will | Illinois | 17197 | 12260 | 361 |
502772 | 502772 | 2020-09-05 | Will | Illinois | 17197 | 12189 | 361 |
499538 | 499538 | 2020-09-04 | Will | Illinois | 17197 | 12107 | 363 |
496305 | 496305 | 2020-09-03 | Will | Illinois | 17197 | 11778 | 362 |
493071 | 493071 | 2020-09-02 | Will | Illinois | 17197 | 11731 | 362 |
489838 | 489838 | 2020-09-01 | Will | Illinois | 17197 | 11692 | 362 |
486605 | 486605 | 2020-08-31 | Will | Illinois | 17197 | 11612 | 361 |
483370 | 483370 | 2020-08-30 | Will | Illinois | 17197 | 11447 | 359 |
480136 | 480136 | 2020-08-29 | Will | Illinois | 17197 | 11371 | 359 |
476903 | 476903 | 2020-08-28 | Will | Illinois | 17197 | 11311 | 360 |
473670 | 473670 | 2020-08-27 | Will | Illinois | 17197 | 11181 | 359 |
470438 | 470438 | 2020-08-26 | Will | Illinois | 17197 | 11094 | 358 |
467209 | 467209 | 2020-08-25 | Will | Illinois | 17197 | 11020 | 357 |
463980 | 463980 | 2020-08-24 | Will | Illinois | 17197 | 10830 | 354 |
460751 | 460751 | 2020-08-23 | Will | Illinois | 17197 | 10760 | 354 |
457524 | 457524 | 2020-08-22 | Will | Illinois | 17197 | 10614 | 354 |
454296 | 454296 | 2020-08-21 | Will | Illinois | 17197 | 10501 | 354 |
451068 | 451068 | 2020-08-20 | Will | Illinois | 17197 | 10414 | 355 |
447840 | 447840 | 2020-08-19 | Will | Illinois | 17197 | 10239 | 353 |
444613 | 444613 | 2020-08-18 | Will | Illinois | 17197 | 10143 | 354 |
441387 | 441387 | 2020-08-17 | Will | Illinois | 17197 | 10074 | 352 |
438161 | 438161 | 2020-08-16 | Will | Illinois | 17197 | 9874 | 351 |
434935 | 434935 | 2020-08-15 | Will | Illinois | 17197 | 9804 | 348 |
431710 | 431710 | 2020-08-14 | Will | Illinois | 17197 | 9754 | 349 |
428482 | 428482 | 2020-08-13 | Will | Illinois | 17197 | 9620 | 348 |
425258 | 425258 | 2020-08-12 | Will | Illinois | 17197 | 9522 | 347 |
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 |
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);