ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
841 rows where fips = 17031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921053 | 921053 | 2021-01-12 | Cook | Illinois | 17031 | 422159 | 8841 |
917808 | 917808 | 2021-01-11 | Cook | Illinois | 17031 | 419471 | 8811 |
914563 | 914563 | 2021-01-10 | Cook | Illinois | 17031 | 417790 | 8760 |
911318 | 911318 | 2021-01-09 | Cook | Illinois | 17031 | 415991 | 8701 |
908073 | 908073 | 2021-01-08 | Cook | Illinois | 17031 | 413504 | 8684 |
904827 | 904827 | 2021-01-07 | Cook | Illinois | 17031 | 410005 | 8630 |
901582 | 901582 | 2021-01-06 | Cook | Illinois | 17031 | 406674 | 8574 |
898337 | 898337 | 2021-01-05 | Cook | Illinois | 17031 | 403987 | 8523 |
895092 | 895092 | 2021-01-04 | Cook | Illinois | 17031 | 401457 | 8483 |
891845 | 891845 | 2021-01-03 | Cook | Illinois | 17031 | 399609 | 8436 |
888598 | 888598 | 2021-01-02 | Cook | Illinois | 17031 | 397942 | 8359 |
885353 | 885353 | 2021-01-01 | Cook | Illinois | 17031 | 393652 | 8285 |
882108 | 882108 | 2020-12-31 | Cook | Illinois | 17031 | 393652 | 8285 |
878863 | 878863 | 2020-12-30 | Cook | Illinois | 17031 | 390927 | 8246 |
875618 | 875618 | 2020-12-29 | Cook | Illinois | 17031 | 388386 | 8169 |
872373 | 872373 | 2020-12-28 | Cook | Illinois | 17031 | 386469 | 8137 |
869128 | 869128 | 2020-12-27 | Cook | Illinois | 17031 | 384931 | 8114 |
865883 | 865883 | 2020-12-26 | Cook | Illinois | 17031 | 383480 | 8060 |
862638 | 862638 | 2020-12-25 | Cook | Illinois | 17031 | 382213 | 8031 |
859393 | 859393 | 2020-12-24 | Cook | Illinois | 17031 | 380096 | 7954 |
856148 | 856148 | 2020-12-23 | Cook | Illinois | 17031 | 377709 | 7908 |
852903 | 852903 | 2020-12-22 | Cook | Illinois | 17031 | 375360 | 7853 |
849658 | 849658 | 2020-12-21 | Cook | Illinois | 17031 | 373008 | 7802 |
846413 | 846413 | 2020-12-20 | Cook | Illinois | 17031 | 371088 | 7724 |
843167 | 843167 | 2020-12-19 | Cook | Illinois | 17031 | 368824 | 7681 |
839922 | 839922 | 2020-12-18 | Cook | Illinois | 17031 | 366020 | 7654 |
836677 | 836677 | 2020-12-17 | Cook | Illinois | 17031 | 363261 | 7574 |
833431 | 833431 | 2020-12-16 | Cook | Illinois | 17031 | 360117 | 7505 |
830184 | 830184 | 2020-12-15 | Cook | Illinois | 17031 | 358014 | 7458 |
826938 | 826938 | 2020-12-14 | Cook | Illinois | 17031 | 355467 | 7440 |
823691 | 823691 | 2020-12-13 | Cook | Illinois | 17031 | 352409 | 7340 |
820445 | 820445 | 2020-12-12 | Cook | Illinois | 17031 | 349461 | 7319 |
817199 | 817199 | 2020-12-11 | Cook | Illinois | 17031 | 346004 | 7282 |
813953 | 813953 | 2020-12-10 | Cook | Illinois | 17031 | 342654 | 7203 |
810708 | 810708 | 2020-12-09 | Cook | Illinois | 17031 | 338093 | 7134 |
807463 | 807463 | 2020-12-08 | Cook | Illinois | 17031 | 335204 | 7051 |
804218 | 804218 | 2020-12-07 | Cook | Illinois | 17031 | 332693 | 7018 |
800973 | 800973 | 2020-12-06 | Cook | Illinois | 17031 | 329003 | 6951 |
797728 | 797728 | 2020-12-05 | Cook | Illinois | 17031 | 325813 | 6922 |
794483 | 794483 | 2020-12-04 | Cook | Illinois | 17031 | 322122 | 6852 |
791238 | 791238 | 2020-12-03 | Cook | Illinois | 17031 | 318324 | 6823 |
787993 | 787993 | 2020-12-02 | Cook | Illinois | 17031 | 314134 | 6768 |
784749 | 784749 | 2020-12-01 | Cook | Illinois | 17031 | 310722 | 6695 |
781504 | 781504 | 2020-11-30 | Cook | Illinois | 17031 | 306369 | 6669 |
778258 | 778258 | 2020-11-29 | Cook | Illinois | 17031 | 304220 | 6595 |
775013 | 775013 | 2020-11-28 | Cook | Illinois | 17031 | 301582 | 6568 |
771768 | 771768 | 2020-11-27 | Cook | Illinois | 17031 | 298870 | 6476 |
768523 | 768523 | 2020-11-26 | Cook | Illinois | 17031 | 296129 | 6450 |
765277 | 765277 | 2020-11-25 | Cook | Illinois | 17031 | 291312 | 6414 |
762032 | 762032 | 2020-11-24 | Cook | Illinois | 17031 | 287124 | 6389 |
758787 | 758787 | 2020-11-23 | Cook | Illinois | 17031 | 284217 | 6339 |
755540 | 755540 | 2020-11-22 | Cook | Illinois | 17031 | 280896 | 6303 |
752294 | 752294 | 2020-11-21 | Cook | Illinois | 17031 | 277026 | 6261 |
749048 | 749048 | 2020-11-20 | Cook | Illinois | 17031 | 272733 | 6201 |
745802 | 745802 | 2020-11-19 | Cook | Illinois | 17031 | 268284 | 6148 |
742555 | 742555 | 2020-11-18 | Cook | Illinois | 17031 | 262429 | 6120 |
739308 | 739308 | 2020-11-17 | Cook | Illinois | 17031 | 260004 | 6035 |
736064 | 736064 | 2020-11-16 | Cook | Illinois | 17031 | 255608 | 6016 |
732818 | 732818 | 2020-11-15 | Cook | Illinois | 17031 | 251101 | 5996 |
729573 | 729573 | 2020-11-14 | Cook | Illinois | 17031 | 246392 | 5976 |
726330 | 726330 | 2020-11-13 | Cook | Illinois | 17031 | 242662 | 5895 |
723087 | 723087 | 2020-11-12 | Cook | Illinois | 17031 | 236717 | 5889 |
719844 | 719844 | 2020-11-11 | Cook | Illinois | 17031 | 231462 | 5881 |
716601 | 716601 | 2020-11-10 | Cook | Illinois | 17031 | 227425 | 5828 |
713357 | 713357 | 2020-11-09 | Cook | Illinois | 17031 | 223110 | 5808 |
710113 | 710113 | 2020-11-08 | Cook | Illinois | 17031 | 218662 | 5798 |
706869 | 706869 | 2020-11-07 | Cook | Illinois | 17031 | 214924 | 5770 |
703626 | 703626 | 2020-11-06 | Cook | Illinois | 17031 | 210266 | 5742 |
700383 | 700383 | 2020-11-05 | Cook | Illinois | 17031 | 204977 | 5574 |
697139 | 697139 | 2020-11-04 | Cook | Illinois | 17031 | 201176 | 5541 |
693897 | 693897 | 2020-11-03 | Cook | Illinois | 17031 | 198184 | 5517 |
690654 | 690654 | 2020-11-02 | Cook | Illinois | 17031 | 195740 | 5510 |
687409 | 687409 | 2020-11-01 | Cook | Illinois | 17031 | 193102 | 5500 |
684165 | 684165 | 2020-10-31 | Cook | Illinois | 17031 | 186405 | 5469 |
680922 | 680922 | 2020-10-30 | Cook | Illinois | 17031 | 186405 | 5469 |
677679 | 677679 | 2020-10-29 | Cook | Illinois | 17031 | 183649 | 5463 |
674436 | 674436 | 2020-10-28 | Cook | Illinois | 17031 | 181108 | 5450 |
671194 | 671194 | 2020-10-27 | Cook | Illinois | 17031 | 178832 | 5439 |
667951 | 667951 | 2020-10-26 | Cook | Illinois | 17031 | 177465 | 5433 |
664707 | 664707 | 2020-10-25 | Cook | Illinois | 17031 | 175586 | 5421 |
661462 | 661462 | 2020-10-24 | Cook | Illinois | 17031 | 173817 | 5409 |
658218 | 658218 | 2020-10-23 | Cook | Illinois | 17031 | 171437 | 5392 |
654973 | 654973 | 2020-10-22 | Cook | Illinois | 17031 | 170039 | 5390 |
651728 | 651728 | 2020-10-21 | Cook | Illinois | 17031 | 168139 | 5382 |
648484 | 648484 | 2020-10-20 | Cook | Illinois | 17031 | 166457 | 5369 |
645239 | 645239 | 2020-10-19 | Cook | Illinois | 17031 | 165198 | 5364 |
641992 | 641992 | 2020-10-18 | Cook | Illinois | 17031 | 163912 | 5357 |
638745 | 638745 | 2020-10-17 | Cook | Illinois | 17031 | 162220 | 5350 |
635499 | 635499 | 2020-10-16 | Cook | Illinois | 17031 | 160645 | 5340 |
632253 | 632253 | 2020-10-15 | Cook | Illinois | 17031 | 159035 | 5332 |
629009 | 629009 | 2020-10-14 | Cook | Illinois | 17031 | 157573 | 5321 |
625766 | 625766 | 2020-10-13 | Cook | Illinois | 17031 | 156726 | 5315 |
622524 | 622524 | 2020-10-12 | Cook | Illinois | 17031 | 155567 | 5304 |
619280 | 619280 | 2020-10-11 | Cook | Illinois | 17031 | 154519 | 5300 |
616038 | 616038 | 2020-10-10 | Cook | Illinois | 17031 | 153514 | 5298 |
612797 | 612797 | 2020-10-09 | Cook | Illinois | 17031 | 152387 | 5289 |
609555 | 609555 | 2020-10-08 | Cook | Illinois | 17031 | 151474 | 5280 |
606312 | 606312 | 2020-10-07 | Cook | Illinois | 17031 | 150400 | 5273 |
603070 | 603070 | 2020-10-06 | Cook | Illinois | 17031 | 149588 | 5268 |
599827 | 599827 | 2020-10-05 | Cook | Illinois | 17031 | 149127 | 5260 |
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);