ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Kane" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930818 | 930818 | 2021-01-15 | Kane | Illinois | 17089 | 45300 | 667 |
927573 | 927573 | 2021-01-14 | Kane | Illinois | 17089 | 45073 | 662 |
924327 | 924327 | 2021-01-13 | Kane | Illinois | 17089 | 44812 | 660 |
921082 | 921082 | 2021-01-12 | Kane | Illinois | 17089 | 44579 | 659 |
917837 | 917837 | 2021-01-11 | Kane | Illinois | 17089 | 44266 | 653 |
914592 | 914592 | 2021-01-10 | Kane | Illinois | 17089 | 44090 | 651 |
911347 | 911347 | 2021-01-09 | Kane | Illinois | 17089 | 43928 | 648 |
908102 | 908102 | 2021-01-08 | Kane | Illinois | 17089 | 43691 | 642 |
904856 | 904856 | 2021-01-07 | Kane | Illinois | 17089 | 43351 | 638 |
901611 | 901611 | 2021-01-06 | Kane | Illinois | 17089 | 42992 | 631 |
898366 | 898366 | 2021-01-05 | Kane | Illinois | 17089 | 42669 | 628 |
895121 | 895121 | 2021-01-04 | Kane | Illinois | 17089 | 42355 | 621 |
891874 | 891874 | 2021-01-03 | Kane | Illinois | 17089 | 42153 | 619 |
888627 | 888627 | 2021-01-02 | Kane | Illinois | 17089 | 41958 | 618 |
885382 | 885382 | 2021-01-01 | Kane | Illinois | 17089 | 41511 | 604 |
882137 | 882137 | 2020-12-31 | Kane | Illinois | 17089 | 41511 | 604 |
878892 | 878892 | 2020-12-30 | Kane | Illinois | 17089 | 41232 | 601 |
875647 | 875647 | 2020-12-29 | Kane | Illinois | 17089 | 40869 | 596 |
872402 | 872402 | 2020-12-28 | Kane | Illinois | 17089 | 40678 | 594 |
869157 | 869157 | 2020-12-27 | Kane | Illinois | 17089 | 40532 | 588 |
865912 | 865912 | 2020-12-26 | Kane | Illinois | 17089 | 40356 | 585 |
862667 | 862667 | 2020-12-25 | Kane | Illinois | 17089 | 40196 | 581 |
859422 | 859422 | 2020-12-24 | Kane | Illinois | 17089 | 39970 | 577 |
856177 | 856177 | 2020-12-23 | Kane | Illinois | 17089 | 39712 | 573 |
852932 | 852932 | 2020-12-22 | Kane | Illinois | 17089 | 39429 | 570 |
849687 | 849687 | 2020-12-21 | Kane | Illinois | 17089 | 39186 | 569 |
846442 | 846442 | 2020-12-20 | Kane | Illinois | 17089 | 38997 | 568 |
843196 | 843196 | 2020-12-19 | Kane | Illinois | 17089 | 38694 | 565 |
839951 | 839951 | 2020-12-18 | Kane | Illinois | 17089 | 38407 | 559 |
836706 | 836706 | 2020-12-17 | Kane | Illinois | 17089 | 38080 | 555 |
833460 | 833460 | 2020-12-16 | Kane | Illinois | 17089 | 37747 | 551 |
830213 | 830213 | 2020-12-15 | Kane | Illinois | 17089 | 37534 | 543 |
826967 | 826967 | 2020-12-14 | Kane | Illinois | 17089 | 37161 | 538 |
823720 | 823720 | 2020-12-13 | Kane | Illinois | 17089 | 36780 | 537 |
820474 | 820474 | 2020-12-12 | Kane | Illinois | 17089 | 36498 | 528 |
817228 | 817228 | 2020-12-11 | Kane | Illinois | 17089 | 36193 | 525 |
813982 | 813982 | 2020-12-10 | Kane | Illinois | 17089 | 35872 | 517 |
810737 | 810737 | 2020-12-09 | Kane | Illinois | 17089 | 35489 | 509 |
807492 | 807492 | 2020-12-08 | Kane | Illinois | 17089 | 35176 | 505 |
804247 | 804247 | 2020-12-07 | Kane | Illinois | 17089 | 34854 | 504 |
801002 | 801002 | 2020-12-06 | Kane | Illinois | 17089 | 34411 | 502 |
797757 | 797757 | 2020-12-05 | Kane | Illinois | 17089 | 34125 | 497 |
794512 | 794512 | 2020-12-04 | Kane | Illinois | 17089 | 33695 | 492 |
791267 | 791267 | 2020-12-03 | Kane | Illinois | 17089 | 33273 | 488 |
788022 | 788022 | 2020-12-02 | Kane | Illinois | 17089 | 32910 | 483 |
784778 | 784778 | 2020-12-01 | Kane | Illinois | 17089 | 32533 | 472 |
781533 | 781533 | 2020-11-30 | Kane | Illinois | 17089 | 31955 | 469 |
778287 | 778287 | 2020-11-29 | Kane | Illinois | 17089 | 31767 | 467 |
775042 | 775042 | 2020-11-28 | Kane | Illinois | 17089 | 31493 | 466 |
771797 | 771797 | 2020-11-27 | Kane | Illinois | 17089 | 31136 | 461 |
768552 | 768552 | 2020-11-26 | Kane | Illinois | 17089 | 30756 | 459 |
765306 | 765306 | 2020-11-25 | Kane | Illinois | 17089 | 30350 | 453 |
762061 | 762061 | 2020-11-24 | Kane | Illinois | 17089 | 29870 | 449 |
758816 | 758816 | 2020-11-23 | Kane | Illinois | 17089 | 29562 | 445 |
755569 | 755569 | 2020-11-22 | Kane | Illinois | 17089 | 29240 | 443 |
752323 | 752323 | 2020-11-21 | Kane | Illinois | 17089 | 28832 | 438 |
749077 | 749077 | 2020-11-20 | Kane | Illinois | 17089 | 28225 | 431 |
745831 | 745831 | 2020-11-19 | Kane | Illinois | 17089 | 27663 | 425 |
742584 | 742584 | 2020-11-18 | Kane | Illinois | 17089 | 26982 | 417 |
739337 | 739337 | 2020-11-17 | Kane | Illinois | 17089 | 26656 | 415 |
736093 | 736093 | 2020-11-16 | Kane | Illinois | 17089 | 26105 | 408 |
732847 | 732847 | 2020-11-15 | Kane | Illinois | 17089 | 25712 | 407 |
729602 | 729602 | 2020-11-14 | Kane | Illinois | 17089 | 25278 | 404 |
726359 | 726359 | 2020-11-13 | Kane | Illinois | 17089 | 24890 | 394 |
723116 | 723116 | 2020-11-12 | Kane | Illinois | 17089 | 24292 | 390 |
719873 | 719873 | 2020-11-11 | Kane | Illinois | 17089 | 23798 | 390 |
716630 | 716630 | 2020-11-10 | Kane | Illinois | 17089 | 23179 | 384 |
713386 | 713386 | 2020-11-09 | Kane | Illinois | 17089 | 22579 | 381 |
710142 | 710142 | 2020-11-08 | Kane | Illinois | 17089 | 22192 | 380 |
706898 | 706898 | 2020-11-07 | Kane | Illinois | 17089 | 21780 | 379 |
703655 | 703655 | 2020-11-06 | Kane | Illinois | 17089 | 21195 | 373 |
700412 | 700412 | 2020-11-05 | Kane | Illinois | 17089 | 20127 | 360 |
697168 | 697168 | 2020-11-04 | Kane | Illinois | 17089 | 19699 | 359 |
693926 | 693926 | 2020-11-03 | Kane | Illinois | 17089 | 19337 | 360 |
690683 | 690683 | 2020-11-02 | Kane | Illinois | 17089 | 18972 | 356 |
687438 | 687438 | 2020-11-01 | Kane | Illinois | 17089 | 18650 | 356 |
684194 | 684194 | 2020-10-31 | Kane | Illinois | 17089 | 18030 | 351 |
680951 | 680951 | 2020-10-30 | Kane | Illinois | 17089 | 18030 | 351 |
677708 | 677708 | 2020-10-29 | Kane | Illinois | 17089 | 17738 | 351 |
674465 | 674465 | 2020-10-28 | Kane | Illinois | 17089 | 17421 | 348 |
671223 | 671223 | 2020-10-27 | Kane | Illinois | 17089 | 17098 | 348 |
667980 | 667980 | 2020-10-26 | Kane | Illinois | 17089 | 16903 | 347 |
664736 | 664736 | 2020-10-25 | Kane | Illinois | 17089 | 16621 | 347 |
661491 | 661491 | 2020-10-24 | Kane | Illinois | 17089 | 16453 | 347 |
658247 | 658247 | 2020-10-23 | Kane | Illinois | 17089 | 16211 | 346 |
655002 | 655002 | 2020-10-22 | Kane | Illinois | 17089 | 16038 | 345 |
651757 | 651757 | 2020-10-21 | Kane | Illinois | 17089 | 15802 | 344 |
648513 | 648513 | 2020-10-20 | Kane | Illinois | 17089 | 15655 | 342 |
645268 | 645268 | 2020-10-19 | Kane | Illinois | 17089 | 15476 | 341 |
642021 | 642021 | 2020-10-18 | Kane | Illinois | 17089 | 15262 | 341 |
638774 | 638774 | 2020-10-17 | Kane | Illinois | 17089 | 15201 | 341 |
635528 | 635528 | 2020-10-16 | Kane | Illinois | 17089 | 14989 | 338 |
632282 | 632282 | 2020-10-15 | Kane | Illinois | 17089 | 14793 | 338 |
629038 | 629038 | 2020-10-14 | Kane | Illinois | 17089 | 14594 | 337 |
625795 | 625795 | 2020-10-13 | Kane | Illinois | 17089 | 14467 | 335 |
622553 | 622553 | 2020-10-12 | Kane | Illinois | 17089 | 14321 | 335 |
619309 | 619309 | 2020-10-11 | Kane | Illinois | 17089 | 14184 | 335 |
616067 | 616067 | 2020-10-10 | Kane | Illinois | 17089 | 14123 | 335 |
612826 | 612826 | 2020-10-09 | Kane | Illinois | 17089 | 14036 | 334 |
609584 | 609584 | 2020-10-08 | Kane | Illinois | 17089 | 13909 | 334 |
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);