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 |
---|---|---|---|---|---|---|---|
1193724 | 1193724 | 2021-04-06 | Cook | Illinois | 17031 | 505380 | 10264 |
1190474 | 1190474 | 2021-04-05 | Cook | Illinois | 17031 | 504203 | 10263 |
1187227 | 1187227 | 2021-04-04 | Cook | Illinois | 17031 | 503169 | 10257 |
1183980 | 1183980 | 2021-04-03 | Cook | Illinois | 17031 | 502207 | 10248 |
1180733 | 1180733 | 2021-04-02 | Cook | Illinois | 17031 | 500914 | 10242 |
1177486 | 1177486 | 2021-04-01 | Cook | Illinois | 17031 | 499429 | 10227 |
1174239 | 1174239 | 2021-03-31 | Cook | Illinois | 17031 | 497885 | 10220 |
1170992 | 1170992 | 2021-03-30 | Cook | Illinois | 17031 | 496856 | 10200 |
1167744 | 1167744 | 2021-03-29 | Cook | Illinois | 17031 | 495858 | 10191 |
1164496 | 1164496 | 2021-03-28 | Cook | Illinois | 17031 | 495050 | 10190 |
1161248 | 1161248 | 2021-03-27 | Cook | Illinois | 17031 | 493968 | 10183 |
1158000 | 1158000 | 2021-03-26 | Cook | Illinois | 17031 | 492837 | 10177 |
1154753 | 1154753 | 2021-03-25 | Cook | Illinois | 17031 | 491512 | 10166 |
1151506 | 1151506 | 2021-03-24 | Cook | Illinois | 17031 | 490661 | 10156 |
1148259 | 1148259 | 2021-03-23 | Cook | Illinois | 17031 | 489484 | 10153 |
1145012 | 1145012 | 2021-03-22 | Cook | Illinois | 17031 | 488793 | 10144 |
1141765 | 1141765 | 2021-03-21 | Cook | Illinois | 17031 | 488249 | 10128 |
1138519 | 1138519 | 2021-03-20 | Cook | Illinois | 17031 | 487602 | 10112 |
1135273 | 1135273 | 2021-03-19 | Cook | Illinois | 17031 | 486730 | 10101 |
1132026 | 1132026 | 2021-03-18 | Cook | Illinois | 17031 | 485771 | 10099 |
1128778 | 1128778 | 2021-03-17 | Cook | Illinois | 17031 | 484719 | 10090 |
1125532 | 1125532 | 2021-03-16 | Cook | Illinois | 17031 | 484146 | 10086 |
1122286 | 1122286 | 2021-03-15 | Cook | Illinois | 17031 | 483282 | 10077 |
1119039 | 1119039 | 2021-03-14 | Cook | Illinois | 17031 | 482973 | 10069 |
1115792 | 1115792 | 2021-03-13 | Cook | Illinois | 17031 | 482424 | 10064 |
1112546 | 1112546 | 2021-03-12 | Cook | Illinois | 17031 | 481787 | 10051 |
1109300 | 1109300 | 2021-03-11 | Cook | Illinois | 17031 | 481101 | 10049 |
1106054 | 1106054 | 2021-03-10 | Cook | Illinois | 17031 | 480487 | 10020 |
1102808 | 1102808 | 2021-03-09 | Cook | Illinois | 17031 | 479913 | 10012 |
1099562 | 1099562 | 2021-03-08 | Cook | Illinois | 17031 | 479361 | 10011 |
1096314 | 1096314 | 2021-03-07 | Cook | Illinois | 17031 | 478884 | 10008 |
1093068 | 1093068 | 2021-03-06 | Cook | Illinois | 17031 | 478498 | 10002 |
1089822 | 1089822 | 2021-03-05 | Cook | Illinois | 17031 | 477381 | 9983 |
1086577 | 1086577 | 2021-03-04 | Cook | Illinois | 17031 | 476835 | 9972 |
1083331 | 1083331 | 2021-03-03 | Cook | Illinois | 17031 | 476094 | 9961 |
1080085 | 1080085 | 2021-03-02 | Cook | Illinois | 17031 | 475386 | 9955 |
1076840 | 1076840 | 2021-03-01 | Cook | Illinois | 17031 | 474885 | 9924 |
1073594 | 1073594 | 2021-02-28 | Cook | Illinois | 17031 | 474397 | 9914 |
1070348 | 1070348 | 2021-02-27 | Cook | Illinois | 17031 | 473944 | 9906 |
1067103 | 1067103 | 2021-02-26 | Cook | Illinois | 17031 | 473194 | 9894 |
1063858 | 1063858 | 2021-02-25 | Cook | Illinois | 17031 | 472206 | 9872 |
1060613 | 1060613 | 2021-02-24 | Cook | Illinois | 17031 | 471685 | 9862 |
1057367 | 1057367 | 2021-02-23 | Cook | Illinois | 17031 | 470933 | 9846 |
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 |
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);