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 |
---|---|---|---|---|---|---|---|
1278159 | 1278159 | 2021-05-02 | Cook | Illinois | 17031 | 536384 | 10525 |
1274912 | 1274912 | 2021-05-01 | Cook | Illinois | 17031 | 535614 | 10515 |
1271665 | 1271665 | 2021-04-30 | Cook | Illinois | 17031 | 534462 | 10507 |
1268418 | 1268418 | 2021-04-29 | Cook | Illinois | 17031 | 533297 | 10497 |
1265171 | 1265171 | 2021-04-28 | Cook | Illinois | 17031 | 531906 | 10482 |
1261924 | 1261924 | 2021-04-27 | Cook | Illinois | 17031 | 530975 | 10466 |
1258677 | 1258677 | 2021-04-26 | Cook | Illinois | 17031 | 530003 | 10455 |
1255430 | 1255430 | 2021-04-25 | Cook | Illinois | 17031 | 529165 | 10449 |
1252183 | 1252183 | 2021-04-24 | Cook | Illinois | 17031 | 528337 | 10433 |
1248936 | 1248936 | 2021-04-23 | Cook | Illinois | 17031 | 527102 | 10424 |
1245689 | 1245689 | 2021-04-22 | Cook | Illinois | 17031 | 525854 | 10415 |
1242442 | 1242442 | 2021-04-21 | Cook | Illinois | 17031 | 524592 | 10402 |
1239195 | 1239195 | 2021-04-20 | Cook | Illinois | 17031 | 523598 | 10394 |
1235948 | 1235948 | 2021-04-19 | Cook | Illinois | 17031 | 522552 | 10390 |
1232701 | 1232701 | 2021-04-18 | Cook | Illinois | 17031 | 521694 | 10379 |
1229452 | 1229452 | 2021-04-17 | Cook | Illinois | 17031 | 520642 | 10374 |
1226204 | 1226204 | 2021-04-16 | Cook | Illinois | 17031 | 519374 | 10362 |
1222957 | 1222957 | 2021-04-15 | Cook | Illinois | 17031 | 517808 | 10357 |
1219709 | 1219709 | 2021-04-14 | Cook | Illinois | 17031 | 516399 | 10347 |
1216461 | 1216461 | 2021-04-13 | Cook | Illinois | 17031 | 515075 | 10331 |
1213214 | 1213214 | 2021-04-12 | Cook | Illinois | 17031 | 513888 | 10326 |
1209966 | 1209966 | 2021-04-11 | Cook | Illinois | 17031 | 512773 | 10310 |
1206717 | 1206717 | 2021-04-10 | Cook | Illinois | 17031 | 511626 | 10306 |
1203469 | 1203469 | 2021-04-09 | Cook | Illinois | 17031 | 510006 | 10301 |
1200221 | 1200221 | 2021-04-08 | Cook | Illinois | 17031 | 508426 | 10297 |
1196972 | 1196972 | 2021-04-07 | Cook | Illinois | 17031 | 506828 | 10271 |
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 |
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);