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 |
---|---|---|---|---|---|---|---|
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 |
596585 | 596585 | 2020-10-04 | Cook | Illinois | 17031 | 148381 | 5256 |
593343 | 593343 | 2020-10-03 | Cook | Illinois | 17031 | 147841 | 5245 |
590102 | 590102 | 2020-10-02 | Cook | Illinois | 17031 | 146917 | 5239 |
586861 | 586861 | 2020-10-01 | Cook | Illinois | 17031 | 146152 | 5229 |
583621 | 583621 | 2020-09-30 | Cook | Illinois | 17031 | 145462 | 5225 |
580382 | 580382 | 2020-09-29 | Cook | Illinois | 17031 | 144697 | 5221 |
577141 | 577141 | 2020-09-28 | Cook | Illinois | 17031 | 144315 | 5217 |
573899 | 573899 | 2020-09-27 | Cook | Illinois | 17031 | 143634 | 5210 |
570656 | 570656 | 2020-09-26 | Cook | Illinois | 17031 | 143084 | 5203 |
567414 | 567414 | 2020-09-25 | Cook | Illinois | 17031 | 142215 | 5194 |
564174 | 564174 | 2020-09-24 | Cook | Illinois | 17031 | 141430 | 5187 |
560934 | 560934 | 2020-09-23 | Cook | Illinois | 17031 | 140623 | 5180 |
557698 | 557698 | 2020-09-22 | Cook | Illinois | 17031 | 140078 | 5172 |
554461 | 554461 | 2020-09-21 | Cook | Illinois | 17031 | 139597 | 5167 |
551222 | 551222 | 2020-09-20 | Cook | Illinois | 17031 | 139088 | 5162 |
547983 | 547983 | 2020-09-19 | Cook | Illinois | 17031 | 138576 | 5157 |
544745 | 544745 | 2020-09-18 | Cook | Illinois | 17031 | 137580 | 5150 |
541509 | 541509 | 2020-09-17 | Cook | Illinois | 17031 | 136993 | 5147 |
538272 | 538272 | 2020-09-16 | Cook | Illinois | 17031 | 136246 | 5146 |
535036 | 535036 | 2020-09-15 | Cook | Illinois | 17031 | 135690 | 5137 |
531801 | 531801 | 2020-09-14 | Cook | Illinois | 17031 | 135274 | 5134 |
528564 | 528564 | 2020-09-13 | Cook | Illinois | 17031 | 134801 | 5133 |
525328 | 525328 | 2020-09-12 | Cook | Illinois | 17031 | 134352 | 5128 |
522092 | 522092 | 2020-09-11 | Cook | Illinois | 17031 | 133686 | 5113 |
518855 | 518855 | 2020-09-10 | Cook | Illinois | 17031 | 132966 | 5103 |
515620 | 515620 | 2020-09-09 | Cook | Illinois | 17031 | 132401 | 5100 |
512387 | 512387 | 2020-09-08 | Cook | Illinois | 17031 | 132079 | 5098 |
509154 | 509154 | 2020-09-07 | Cook | Illinois | 17031 | 131622 | 5097 |
505922 | 505922 | 2020-09-06 | Cook | Illinois | 17031 | 131078 | 5094 |
502688 | 502688 | 2020-09-05 | Cook | Illinois | 17031 | 130616 | 5092 |
499454 | 499454 | 2020-09-04 | Cook | Illinois | 17031 | 129545 | 5086 |
496221 | 496221 | 2020-09-03 | Cook | Illinois | 17031 | 128012 | 5080 |
492987 | 492987 | 2020-09-02 | Cook | Illinois | 17031 | 127616 | 5073 |
489754 | 489754 | 2020-09-01 | Cook | Illinois | 17031 | 126992 | 5069 |
486521 | 486521 | 2020-08-31 | Cook | Illinois | 17031 | 126577 | 5058 |
483286 | 483286 | 2020-08-30 | Cook | Illinois | 17031 | 126003 | 5054 |
480052 | 480052 | 2020-08-29 | Cook | Illinois | 17031 | 125124 | 5046 |
476819 | 476819 | 2020-08-28 | Cook | Illinois | 17031 | 124573 | 5045 |
473586 | 473586 | 2020-08-27 | Cook | Illinois | 17031 | 123691 | 5039 |
470354 | 470354 | 2020-08-26 | Cook | Illinois | 17031 | 123172 | 5031 |
467125 | 467125 | 2020-08-25 | Cook | Illinois | 17031 | 122423 | 5022 |
463896 | 463896 | 2020-08-24 | Cook | Illinois | 17031 | 121894 | 5015 |
460667 | 460667 | 2020-08-23 | Cook | Illinois | 17031 | 121308 | 5013 |
457440 | 457440 | 2020-08-22 | Cook | Illinois | 17031 | 120567 | 5008 |
454212 | 454212 | 2020-08-21 | Cook | Illinois | 17031 | 119644 | 4997 |
450984 | 450984 | 2020-08-20 | Cook | Illinois | 17031 | 118757 | 4988 |
447756 | 447756 | 2020-08-19 | Cook | Illinois | 17031 | 118012 | 4984 |
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);