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 |
---|---|---|---|---|---|---|---|
1054121 | 1054121 | 2021-02-22 | Cook | Illinois | 17031 | 470391 | 9833 |
1050874 | 1050874 | 2021-02-21 | Cook | Illinois | 17031 | 469935 | 9809 |
1047627 | 1047627 | 2021-02-20 | Cook | Illinois | 17031 | 469379 | 9800 |
1044382 | 1044382 | 2021-02-19 | Cook | Illinois | 17031 | 468690 | 9790 |
1041137 | 1041137 | 2021-02-18 | Cook | Illinois | 17031 | 467986 | 9775 |
1037892 | 1037892 | 2021-02-17 | Cook | Illinois | 17031 | 467424 | 9747 |
1034647 | 1034647 | 2021-02-16 | Cook | Illinois | 17031 | 466870 | 9738 |
1031401 | 1031401 | 2021-02-15 | Cook | Illinois | 17031 | 466422 | 9714 |
1028154 | 1028154 | 2021-02-14 | Cook | Illinois | 17031 | 465914 | 9690 |
1024909 | 1024909 | 2021-02-13 | Cook | Illinois | 17031 | 465341 | 9675 |
1021664 | 1021664 | 2021-02-12 | Cook | Illinois | 17031 | 464573 | 9669 |
1018419 | 1018419 | 2021-02-11 | Cook | Illinois | 17031 | 463581 | 9655 |
1015174 | 1015174 | 2021-02-10 | Cook | Illinois | 17031 | 462667 | 9601 |
1011929 | 1011929 | 2021-02-09 | Cook | Illinois | 17031 | 461757 | 9585 |
1008683 | 1008683 | 2021-02-08 | Cook | Illinois | 17031 | 461118 | 9579 |
1005437 | 1005437 | 2021-02-07 | Cook | Illinois | 17031 | 460554 | 9561 |
1002191 | 1002191 | 2021-02-06 | Cook | Illinois | 17031 | 459740 | 9551 |
998945 | 998945 | 2021-02-05 | Cook | Illinois | 17031 | 458600 | 9532 |
995699 | 995699 | 2021-02-04 | Cook | Illinois | 17031 | 457285 | 9501 |
992453 | 992453 | 2021-02-03 | Cook | Illinois | 17031 | 456144 | 9481 |
989207 | 989207 | 2021-02-02 | Cook | Illinois | 17031 | 455138 | 9456 |
985960 | 985960 | 2021-02-01 | Cook | Illinois | 17031 | 454485 | 9433 |
982713 | 982713 | 2021-01-31 | Cook | Illinois | 17031 | 453634 | 9374 |
979467 | 979467 | 2021-01-30 | Cook | Illinois | 17031 | 452742 | 9374 |
976222 | 976222 | 2021-01-29 | Cook | Illinois | 17031 | 451581 | 9374 |
972977 | 972977 | 2021-01-28 | Cook | Illinois | 17031 | 450116 | 9363 |
969732 | 969732 | 2021-01-27 | Cook | Illinois | 17031 | 448546 | 9305 |
966488 | 966488 | 2021-01-26 | Cook | Illinois | 17031 | 447295 | 9280 |
963243 | 963243 | 2021-01-25 | Cook | Illinois | 17031 | 446035 | 9268 |
959998 | 959998 | 2021-01-24 | Cook | Illinois | 17031 | 444927 | 9243 |
956752 | 956752 | 2021-01-23 | Cook | Illinois | 17031 | 443600 | 9227 |
953507 | 953507 | 2021-01-22 | Cook | Illinois | 17031 | 441657 | 9197 |
950262 | 950262 | 2021-01-21 | Cook | Illinois | 17031 | 439118 | 9148 |
947016 | 947016 | 2021-01-20 | Cook | Illinois | 17031 | 437465 | 9098 |
943769 | 943769 | 2021-01-19 | Cook | Illinois | 17031 | 435888 | 9065 |
940524 | 940524 | 2021-01-18 | Cook | Illinois | 17031 | 434341 | 9046 |
937279 | 937279 | 2021-01-17 | Cook | Illinois | 17031 | 433089 | 9005 |
934034 | 934034 | 2021-01-16 | Cook | Illinois | 17031 | 431385 | 8980 |
930789 | 930789 | 2021-01-15 | Cook | Illinois | 17031 | 429270 | 8939 |
927544 | 927544 | 2021-01-14 | Cook | Illinois | 17031 | 426658 | 8889 |
924298 | 924298 | 2021-01-13 | Cook | Illinois | 17031 | 424217 | 8870 |
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 |
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);