ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17043 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535042 | 535042 | 2020-09-15 | DuPage | Illinois | 17043 | 16209 | 546 |
531807 | 531807 | 2020-09-14 | DuPage | Illinois | 17043 | 16123 | 545 |
528570 | 528570 | 2020-09-13 | DuPage | Illinois | 17043 | 16022 | 545 |
525334 | 525334 | 2020-09-12 | DuPage | Illinois | 17043 | 15938 | 543 |
522098 | 522098 | 2020-09-11 | DuPage | Illinois | 17043 | 15826 | 544 |
518861 | 518861 | 2020-09-10 | DuPage | Illinois | 17043 | 15704 | 540 |
515626 | 515626 | 2020-09-09 | DuPage | Illinois | 17043 | 15592 | 540 |
512393 | 512393 | 2020-09-08 | DuPage | Illinois | 17043 | 15499 | 540 |
509160 | 509160 | 2020-09-07 | DuPage | Illinois | 17043 | 15385 | 540 |
505928 | 505928 | 2020-09-06 | DuPage | Illinois | 17043 | 15322 | 539 |
502694 | 502694 | 2020-09-05 | DuPage | Illinois | 17043 | 15247 | 539 |
499460 | 499460 | 2020-09-04 | DuPage | Illinois | 17043 | 15109 | 536 |
496227 | 496227 | 2020-09-03 | DuPage | Illinois | 17043 | 14840 | 537 |
492993 | 492993 | 2020-09-02 | DuPage | Illinois | 17043 | 14770 | 537 |
489760 | 489760 | 2020-09-01 | DuPage | Illinois | 17043 | 14679 | 534 |
486527 | 486527 | 2020-08-31 | DuPage | Illinois | 17043 | 14615 | 533 |
483292 | 483292 | 2020-08-30 | DuPage | Illinois | 17043 | 14493 | 533 |
480058 | 480058 | 2020-08-29 | DuPage | Illinois | 17043 | 14398 | 533 |
476825 | 476825 | 2020-08-28 | DuPage | Illinois | 17043 | 14299 | 533 |
473592 | 473592 | 2020-08-27 | DuPage | Illinois | 17043 | 14200 | 533 |
470360 | 470360 | 2020-08-26 | DuPage | Illinois | 17043 | 14103 | 532 |
467131 | 467131 | 2020-08-25 | DuPage | Illinois | 17043 | 14001 | 531 |
463902 | 463902 | 2020-08-24 | DuPage | Illinois | 17043 | 13909 | 530 |
460673 | 460673 | 2020-08-23 | DuPage | Illinois | 17043 | 13778 | 529 |
457446 | 457446 | 2020-08-22 | DuPage | Illinois | 17043 | 13686 | 529 |
454218 | 454218 | 2020-08-21 | DuPage | Illinois | 17043 | 13530 | 529 |
450990 | 450990 | 2020-08-20 | DuPage | Illinois | 17043 | 13410 | 528 |
447762 | 447762 | 2020-08-19 | DuPage | Illinois | 17043 | 13289 | 527 |
444535 | 444535 | 2020-08-18 | DuPage | Illinois | 17043 | 13151 | 527 |
441309 | 441309 | 2020-08-17 | DuPage | Illinois | 17043 | 13032 | 526 |
438083 | 438083 | 2020-08-16 | DuPage | Illinois | 17043 | 12892 | 526 |
434857 | 434857 | 2020-08-15 | DuPage | Illinois | 17043 | 12815 | 526 |
431632 | 431632 | 2020-08-14 | DuPage | Illinois | 17043 | 12693 | 525 |
428404 | 428404 | 2020-08-13 | DuPage | Illinois | 17043 | 12592 | 523 |
425180 | 425180 | 2020-08-12 | DuPage | Illinois | 17043 | 12511 | 522 |
421959 | 421959 | 2020-08-11 | DuPage | Illinois | 17043 | 12427 | 522 |
418736 | 418736 | 2020-08-10 | DuPage | Illinois | 17043 | 12312 | 520 |
415515 | 415515 | 2020-08-09 | DuPage | Illinois | 17043 | 12233 | 520 |
412295 | 412295 | 2020-08-08 | DuPage | Illinois | 17043 | 12155 | 520 |
409076 | 409076 | 2020-08-07 | DuPage | Illinois | 17043 | 12021 | 519 |
405856 | 405856 | 2020-08-06 | DuPage | Illinois | 17043 | 11926 | 519 |
402638 | 402638 | 2020-08-05 | DuPage | Illinois | 17043 | 11804 | 515 |
399422 | 399422 | 2020-08-04 | DuPage | Illinois | 17043 | 11689 | 513 |
396206 | 396206 | 2020-08-03 | DuPage | Illinois | 17043 | 11558 | 510 |
392990 | 392990 | 2020-08-02 | DuPage | Illinois | 17043 | 11470 | 510 |
389773 | 389773 | 2020-08-01 | DuPage | Illinois | 17043 | 11380 | 510 |
386556 | 386556 | 2020-07-31 | DuPage | Illinois | 17043 | 11267 | 510 |
383338 | 383338 | 2020-07-30 | DuPage | Illinois | 17043 | 11177 | 509 |
380121 | 380121 | 2020-07-29 | DuPage | Illinois | 17043 | 11084 | 508 |
376904 | 376904 | 2020-07-28 | DuPage | Illinois | 17043 | 11005 | 510 |
373689 | 373689 | 2020-07-27 | DuPage | Illinois | 17043 | 10953 | 509 |
370477 | 370477 | 2020-07-26 | DuPage | Illinois | 17043 | 10880 | 507 |
367267 | 367267 | 2020-07-25 | DuPage | Illinois | 17043 | 10771 | 507 |
364060 | 364060 | 2020-07-24 | DuPage | Illinois | 17043 | 10705 | 506 |
360853 | 360853 | 2020-07-23 | DuPage | Illinois | 17043 | 10627 | 502 |
357648 | 357648 | 2020-07-22 | DuPage | Illinois | 17043 | 10531 | 500 |
354446 | 354446 | 2020-07-21 | DuPage | Illinois | 17043 | 10414 | 500 |
351244 | 351244 | 2020-07-20 | DuPage | Illinois | 17043 | 10317 | 498 |
348044 | 348044 | 2020-07-19 | DuPage | Illinois | 17043 | 10196 | 497 |
344843 | 344843 | 2020-07-18 | DuPage | Illinois | 17043 | 10107 | 497 |
341643 | 341643 | 2020-07-17 | DuPage | Illinois | 17043 | 10020 | 495 |
338447 | 338447 | 2020-07-16 | DuPage | Illinois | 17043 | 9917 | 494 |
335251 | 335251 | 2020-07-15 | DuPage | Illinois | 17043 | 9867 | 492 |
332058 | 332058 | 2020-07-14 | DuPage | Illinois | 17043 | 9810 | 491 |
328871 | 328871 | 2020-07-13 | DuPage | Illinois | 17043 | 9794 | 487 |
325685 | 325685 | 2020-07-12 | DuPage | Illinois | 17043 | 9721 | 486 |
322504 | 322504 | 2020-07-11 | DuPage | Illinois | 17043 | 9641 | 485 |
319325 | 319325 | 2020-07-10 | DuPage | Illinois | 17043 | 9571 | 483 |
316152 | 316152 | 2020-07-09 | DuPage | Illinois | 17043 | 9507 | 483 |
312978 | 312978 | 2020-07-08 | DuPage | Illinois | 17043 | 9457 | 480 |
309808 | 309808 | 2020-07-07 | DuPage | Illinois | 17043 | 9395 | 477 |
306640 | 306640 | 2020-07-06 | DuPage | Illinois | 17043 | 9364 | 475 |
303475 | 303475 | 2020-07-05 | DuPage | Illinois | 17043 | 9315 | 475 |
300311 | 300311 | 2020-07-04 | DuPage | Illinois | 17043 | 9276 | 475 |
297149 | 297149 | 2020-07-03 | DuPage | Illinois | 17043 | 9209 | 474 |
293992 | 293992 | 2020-07-02 | DuPage | Illinois | 17043 | 9147 | 473 |
290838 | 290838 | 2020-07-01 | DuPage | Illinois | 17043 | 9086 | 472 |
287688 | 287688 | 2020-06-30 | DuPage | Illinois | 17043 | 9036 | 470 |
284539 | 284539 | 2020-06-29 | DuPage | Illinois | 17043 | 8996 | 470 |
281394 | 281394 | 2020-06-28 | DuPage | Illinois | 17043 | 8951 | 469 |
278246 | 278246 | 2020-06-27 | DuPage | Illinois | 17043 | 8922 | 468 |
275098 | 275098 | 2020-06-26 | DuPage | Illinois | 17043 | 8879 | 465 |
271956 | 271956 | 2020-06-25 | DuPage | Illinois | 17043 | 8829 | 463 |
268819 | 268819 | 2020-06-24 | DuPage | Illinois | 17043 | 8782 | 458 |
265689 | 265689 | 2020-06-23 | DuPage | Illinois | 17043 | 8742 | 455 |
262561 | 262561 | 2020-06-22 | DuPage | Illinois | 17043 | 8716 | 449 |
259434 | 259434 | 2020-06-21 | DuPage | Illinois | 17043 | 8684 | 448 |
256308 | 256308 | 2020-06-20 | DuPage | Illinois | 17043 | 8648 | 448 |
253188 | 253188 | 2020-06-19 | DuPage | Illinois | 17043 | 8611 | 444 |
250073 | 250073 | 2020-06-18 | DuPage | Illinois | 17043 | 8575 | 443 |
246961 | 246961 | 2020-06-17 | DuPage | Illinois | 17043 | 8546 | 435 |
243848 | 243848 | 2020-06-16 | DuPage | Illinois | 17043 | 8501 | 432 |
240737 | 240737 | 2020-06-15 | DuPage | Illinois | 17043 | 8465 | 431 |
237629 | 237629 | 2020-06-14 | DuPage | Illinois | 17043 | 8434 | 431 |
234522 | 234522 | 2020-06-13 | DuPage | Illinois | 17043 | 8402 | 430 |
231416 | 231416 | 2020-06-12 | DuPage | Illinois | 17043 | 8360 | 429 |
228313 | 228313 | 2020-06-11 | DuPage | Illinois | 17043 | 8318 | 425 |
225211 | 225211 | 2020-06-10 | DuPage | Illinois | 17043 | 8263 | 418 |
222116 | 222116 | 2020-06-09 | DuPage | Illinois | 17043 | 8223 | 411 |
219021 | 219021 | 2020-06-08 | DuPage | Illinois | 17043 | 8157 | 406 |
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);