ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where "date" is on date 2020-11-06 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
703611 | 703611 | 2020-11-06 | Adams | Illinois | 17001 | 2726 | 30 |
703612 | 703612 | 2020-11-06 | Alexander | Illinois | 17003 | 170 | 2 |
703613 | 703613 | 2020-11-06 | Bond | Illinois | 17005 | 627 | 9 |
703614 | 703614 | 2020-11-06 | Boone | Illinois | 17007 | 2442 | 26 |
703615 | 703615 | 2020-11-06 | Brown | Illinois | 17009 | 161 | 0 |
703616 | 703616 | 2020-11-06 | Bureau | Illinois | 17011 | 1184 | 19 |
703617 | 703617 | 2020-11-06 | Calhoun | Illinois | 17013 | 114 | 0 |
703618 | 703618 | 2020-11-06 | Carroll | Illinois | 17015 | 641 | 17 |
703619 | 703619 | 2020-11-06 | Cass | Illinois | 17017 | 533 | 11 |
703620 | 703620 | 2020-11-06 | Champaign | Illinois | 17019 | 7572 | 30 |
703621 | 703621 | 2020-11-06 | Christian | Illinois | 17021 | 1083 | 32 |
703622 | 703622 | 2020-11-06 | Clark | Illinois | 17023 | 466 | 18 |
703623 | 703623 | 2020-11-06 | Clay | Illinois | 17025 | 399 | 15 |
703624 | 703624 | 2020-11-06 | Clinton | Illinois | 17027 | 2100 | 36 |
703625 | 703625 | 2020-11-06 | Coles | Illinois | 17029 | 2386 | 47 |
703626 | 703626 | 2020-11-06 | Cook | Illinois | 17031 | 210266 | 5742 |
703627 | 703627 | 2020-11-06 | Crawford | Illinois | 17033 | 730 | 6 |
703628 | 703628 | 2020-11-06 | Cumberland | Illinois | 17035 | 398 | 6 |
703629 | 703629 | 2020-11-06 | De Witt | Illinois | 17039 | 398 | 9 |
703630 | 703630 | 2020-11-06 | DeKalb | Illinois | 17037 | 3228 | 43 |
703631 | 703631 | 2020-11-06 | Douglas | Illinois | 17041 | 947 | 10 |
703632 | 703632 | 2020-11-06 | DuPage | Illinois | 17043 | 28834 | 675 |
703633 | 703633 | 2020-11-06 | Edgar | Illinois | 17045 | 464 | 14 |
703634 | 703634 | 2020-11-06 | Edwards | Illinois | 17047 | 129 | 0 |
703635 | 703635 | 2020-11-06 | Effingham | Illinois | 17049 | 1593 | 5 |
703636 | 703636 | 2020-11-06 | Fayette | Illinois | 17051 | 906 | 26 |
703637 | 703637 | 2020-11-06 | Ford | Illinois | 17053 | 359 | 19 |
703638 | 703638 | 2020-11-06 | Franklin | Illinois | 17055 | 1231 | 12 |
703639 | 703639 | 2020-11-06 | Fulton | Illinois | 17057 | 788 | 2 |
703640 | 703640 | 2020-11-06 | Gallatin | Illinois | 17059 | 132 | 3 |
703641 | 703641 | 2020-11-06 | Greene | Illinois | 17061 | 457 | 19 |
703642 | 703642 | 2020-11-06 | Grundy | Illinois | 17063 | 1405 | 8 |
703643 | 703643 | 2020-11-06 | Hamilton | Illinois | 17065 | 174 | 2 |
703644 | 703644 | 2020-11-06 | Hancock | Illinois | 17067 | 482 | 4 |
703645 | 703645 | 2020-11-06 | Hardin | Illinois | 17069 | 66 | 0 |
703646 | 703646 | 2020-11-06 | Henderson | Illinois | 17071 | 162 | 0 |
703647 | 703647 | 2020-11-06 | Henry | Illinois | 17073 | 1230 | 9 |
703648 | 703648 | 2020-11-06 | Iroquois | Illinois | 17075 | 780 | 20 |
703649 | 703649 | 2020-11-06 | Jackson | Illinois | 17077 | 1780 | 28 |
703650 | 703650 | 2020-11-06 | Jasper | Illinois | 17079 | 408 | 10 |
703651 | 703651 | 2020-11-06 | Jefferson | Illinois | 17081 | 1150 | 52 |
703652 | 703652 | 2020-11-06 | Jersey | Illinois | 17083 | 707 | 22 |
703653 | 703653 | 2020-11-06 | Jo Daviess | Illinois | 17085 | 649 | 11 |
703654 | 703654 | 2020-11-06 | Johnson | Illinois | 17087 | 454 | 0 |
703655 | 703655 | 2020-11-06 | Kane | Illinois | 17089 | 21195 | 373 |
703656 | 703656 | 2020-11-06 | Kankakee | Illinois | 17091 | 4663 | 84 |
703657 | 703657 | 2020-11-06 | Kendall | Illinois | 17093 | 3619 | 32 |
703658 | 703658 | 2020-11-06 | Knox | Illinois | 17095 | 1682 | 29 |
703659 | 703659 | 2020-11-06 | LaSalle | Illinois | 17099 | 3356 | 79 |
703660 | 703660 | 2020-11-06 | Lake | Illinois | 17097 | 25124 | 546 |
703661 | 703661 | 2020-11-06 | Lawrence | Illinois | 17101 | 418 | 8 |
703662 | 703662 | 2020-11-06 | Lee | Illinois | 17103 | 1056 | 6 |
703663 | 703663 | 2020-11-06 | Livingston | Illinois | 17105 | 964 | 12 |
703664 | 703664 | 2020-11-06 | Logan | Illinois | 17107 | 805 | 6 |
703665 | 703665 | 2020-11-06 | Macon | Illinois | 17115 | 4210 | 72 |
703666 | 703666 | 2020-11-06 | Macoupin | Illinois | 17117 | 1021 | 12 |
703667 | 703667 | 2020-11-06 | Madison | Illinois | 17119 | 8763 | 164 |
703668 | 703668 | 2020-11-06 | Marion | Illinois | 17121 | 1331 | 27 |
703669 | 703669 | 2020-11-06 | Marshall | Illinois | 17123 | 198 | 4 |
703670 | 703670 | 2020-11-06 | Mason | Illinois | 17125 | 389 | 13 |
703671 | 703671 | 2020-11-06 | Massac | Illinois | 17127 | 204 | 2 |
703672 | 703672 | 2020-11-06 | McDonough | Illinois | 17109 | 962 | 25 |
703673 | 703673 | 2020-11-06 | McHenry | Illinois | 17111 | 8532 | 125 |
703674 | 703674 | 2020-11-06 | McLean | Illinois | 17113 | 5205 | 39 |
703675 | 703675 | 2020-11-06 | Menard | Illinois | 17129 | 209 | 1 |
703676 | 703676 | 2020-11-06 | Mercer | Illinois | 17131 | 419 | 7 |
703677 | 703677 | 2020-11-06 | Monroe | Illinois | 17133 | 1180 | 40 |
703678 | 703678 | 2020-11-06 | Montgomery | Illinois | 17135 | 752 | 16 |
703679 | 703679 | 2020-11-06 | Morgan | Illinois | 17137 | 1201 | 30 |
703680 | 703680 | 2020-11-06 | Moultrie | Illinois | 17139 | 565 | 7 |
703681 | 703681 | 2020-11-06 | Ogle | Illinois | 17141 | 1742 | 8 |
703682 | 703682 | 2020-11-06 | Peoria | Illinois | 17143 | 5601 | 92 |
703683 | 703683 | 2020-11-06 | Perry | Illinois | 17145 | 585 | 16 |
703684 | 703684 | 2020-11-06 | Piatt | Illinois | 17147 | 379 | 4 |
703685 | 703685 | 2020-11-06 | Pike | Illinois | 17149 | 584 | 12 |
703686 | 703686 | 2020-11-06 | Pope | Illinois | 17151 | 50 | 1 |
703687 | 703687 | 2020-11-06 | Pulaski | Illinois | 17153 | 269 | 1 |
703688 | 703688 | 2020-11-06 | Putnam | Illinois | 17155 | 124 | 0 |
703689 | 703689 | 2020-11-06 | Randolph | Illinois | 17157 | 1499 | 17 |
703690 | 703690 | 2020-11-06 | Richland | Illinois | 17159 | 399 | 19 |
703691 | 703691 | 2020-11-06 | Rock Island | Illinois | 17161 | 5217 | 109 |
703692 | 703692 | 2020-11-06 | Saline | Illinois | 17165 | 722 | 13 |
703693 | 703693 | 2020-11-06 | Sangamon | Illinois | 17167 | 5511 | 69 |
703694 | 703694 | 2020-11-06 | Schuyler | Illinois | 17169 | 119 | 1 |
703695 | 703695 | 2020-11-06 | Scott | Illinois | 17171 | 126 | 0 |
703696 | 703696 | 2020-11-06 | Shelby | Illinois | 17173 | 868 | 22 |
703697 | 703697 | 2020-11-06 | St. Clair | Illinois | 17163 | 9942 | 239 |
703698 | 703698 | 2020-11-06 | Stark | Illinois | 17175 | 127 | 3 |
703699 | 703699 | 2020-11-06 | Stephenson | Illinois | 17177 | 1504 | 12 |
703700 | 703700 | 2020-11-06 | Tazewell | Illinois | 17179 | 3479 | 63 |
703701 | 703701 | 2020-11-06 | Union | Illinois | 17181 | 858 | 26 |
703702 | 703702 | 2020-11-06 | Vermilion | Illinois | 17183 | 2208 | 18 |
703703 | 703703 | 2020-11-06 | Wabash | Illinois | 17185 | 307 | 6 |
703704 | 703704 | 2020-11-06 | Warren | Illinois | 17187 | 653 | 10 |
703705 | 703705 | 2020-11-06 | Washington | Illinois | 17189 | 396 | 2 |
703706 | 703706 | 2020-11-06 | Wayne | Illinois | 17191 | 622 | 21 |
703707 | 703707 | 2020-11-06 | White | Illinois | 17193 | 333 | 6 |
703708 | 703708 | 2020-11-06 | Whiteside | Illinois | 17195 | 2216 | 49 |
703709 | 703709 | 2020-11-06 | Will | Illinois | 17197 | 23279 | 473 |
703710 | 703710 | 2020-11-06 | Williamson | Illinois | 17199 | 2295 | 66 |
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);