ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-08-27" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
473571 | 473571 | 2020-08-27 | Adams | Illinois | 17001 | 734 | 7 |
473572 | 473572 | 2020-08-27 | Alexander | Illinois | 17003 | 44 | 0 |
473573 | 473573 | 2020-08-27 | Bond | Illinois | 17005 | 123 | 3 |
473574 | 473574 | 2020-08-27 | Boone | Illinois | 17007 | 846 | 23 |
473575 | 473575 | 2020-08-27 | Brown | Illinois | 17009 | 18 | 0 |
473576 | 473576 | 2020-08-27 | Bureau | Illinois | 17011 | 348 | 5 |
473577 | 473577 | 2020-08-27 | Calhoun | Illinois | 17013 | 26 | 0 |
473578 | 473578 | 2020-08-27 | Carroll | Illinois | 17015 | 125 | 4 |
473579 | 473579 | 2020-08-27 | Cass | Illinois | 17017 | 297 | 11 |
473580 | 473580 | 2020-08-27 | Champaign | Illinois | 17019 | 2210 | 20 |
473581 | 473581 | 2020-08-27 | Christian | Illinois | 17021 | 195 | 5 |
473582 | 473582 | 2020-08-27 | Clark | Illinois | 17023 | 112 | 2 |
473583 | 473583 | 2020-08-27 | Clay | Illinois | 17025 | 65 | 0 |
473584 | 473584 | 2020-08-27 | Clinton | Illinois | 17027 | 667 | 17 |
473585 | 473585 | 2020-08-27 | Coles | Illinois | 17029 | 860 | 21 |
473586 | 473586 | 2020-08-27 | Cook | Illinois | 17031 | 123691 | 5039 |
473587 | 473587 | 2020-08-27 | Crawford | Illinois | 17033 | 72 | 0 |
473588 | 473588 | 2020-08-27 | Cumberland | Illinois | 17035 | 127 | 3 |
473589 | 473589 | 2020-08-27 | De Witt | Illinois | 17039 | 39 | 1 |
473590 | 473590 | 2020-08-27 | DeKalb | Illinois | 17037 | 1129 | 33 |
473591 | 473591 | 2020-08-27 | Douglas | Illinois | 17041 | 202 | 4 |
473592 | 473592 | 2020-08-27 | DuPage | Illinois | 17043 | 14200 | 533 |
473593 | 473593 | 2020-08-27 | Edgar | Illinois | 17045 | 77 | 0 |
473594 | 473594 | 2020-08-27 | Edwards | Illinois | 17047 | 34 | 0 |
473595 | 473595 | 2020-08-27 | Effingham | Illinois | 17049 | 464 | 1 |
473596 | 473596 | 2020-08-27 | Fayette | Illinois | 17051 | 144 | 3 |
473597 | 473597 | 2020-08-27 | Ford | Illinois | 17053 | 69 | 2 |
473598 | 473598 | 2020-08-27 | Franklin | Illinois | 17055 | 315 | 1 |
473599 | 473599 | 2020-08-27 | Fulton | Illinois | 17057 | 75 | 0 |
473600 | 473600 | 2020-08-27 | Gallatin | Illinois | 17059 | 62 | 2 |
473601 | 473601 | 2020-08-27 | Greene | Illinois | 17061 | 97 | 0 |
473602 | 473602 | 2020-08-27 | Grundy | Illinois | 17063 | 461 | 5 |
473603 | 473603 | 2020-08-27 | Hamilton | Illinois | 17065 | 44 | 0 |
473604 | 473604 | 2020-08-27 | Hancock | Illinois | 17067 | 123 | 2 |
473605 | 473605 | 2020-08-27 | Hardin | Illinois | 17069 | 18 | 0 |
473606 | 473606 | 2020-08-27 | Henderson | Illinois | 17071 | 40 | 0 |
473607 | 473607 | 2020-08-27 | Henry | Illinois | 17073 | 424 | 1 |
473608 | 473608 | 2020-08-27 | Iroquois | Illinois | 17075 | 287 | 18 |
473609 | 473609 | 2020-08-27 | Jackson | Illinois | 17077 | 892 | 20 |
473610 | 473610 | 2020-08-27 | Jasper | Illinois | 17079 | 104 | 7 |
473611 | 473611 | 2020-08-27 | Jefferson | Illinois | 17081 | 434 | 33 |
473612 | 473612 | 2020-08-27 | Jersey | Illinois | 17083 | 264 | 3 |
473613 | 473613 | 2020-08-27 | Jo Daviess | Illinois | 17085 | 171 | 2 |
473614 | 473614 | 2020-08-27 | Johnson | Illinois | 17087 | 107 | 0 |
473615 | 473615 | 2020-08-27 | Kane | Illinois | 17089 | 11066 | 312 |
473616 | 473616 | 2020-08-27 | Kankakee | Illinois | 17091 | 2182 | 71 |
473617 | 473617 | 2020-08-27 | Kendall | Illinois | 17093 | 1671 | 25 |
473618 | 473618 | 2020-08-27 | Knox | Illinois | 17095 | 440 | 3 |
473619 | 473619 | 2020-08-27 | LaSalle | Illinois | 17099 | 1180 | 45 |
473620 | 473620 | 2020-08-27 | Lake | Illinois | 17097 | 14223 | 462 |
473621 | 473621 | 2020-08-27 | Lawrence | Illinois | 17101 | 93 | 0 |
473622 | 473622 | 2020-08-27 | Lee | Illinois | 17103 | 226 | 1 |
473623 | 473623 | 2020-08-27 | Livingston | Illinois | 17105 | 179 | 4 |
473624 | 473624 | 2020-08-27 | Logan | Illinois | 17107 | 247 | 1 |
473625 | 473625 | 2020-08-27 | Macon | Illinois | 17115 | 894 | 26 |
473626 | 473626 | 2020-08-27 | Macoupin | Illinois | 17117 | 333 | 3 |
473627 | 473627 | 2020-08-27 | Madison | Illinois | 17119 | 3818 | 95 |
473628 | 473628 | 2020-08-27 | Marion | Illinois | 17121 | 259 | 0 |
473629 | 473629 | 2020-08-27 | Marshall | Illinois | 17123 | 44 | 0 |
473630 | 473630 | 2020-08-27 | Mason | Illinois | 17125 | 76 | 1 |
473631 | 473631 | 2020-08-27 | Massac | Illinois | 17127 | 63 | 1 |
473632 | 473632 | 2020-08-27 | McDonough | Illinois | 17109 | 176 | 15 |
473633 | 473633 | 2020-08-27 | McHenry | Illinois | 17111 | 3807 | 116 |
473634 | 473634 | 2020-08-27 | McLean | Illinois | 17113 | 1323 | 16 |
473635 | 473635 | 2020-08-27 | Menard | Illinois | 17129 | 68 | 0 |
473636 | 473636 | 2020-08-27 | Mercer | Illinois | 17131 | 94 | 4 |
473637 | 473637 | 2020-08-27 | Monroe | Illinois | 17133 | 442 | 14 |
473638 | 473638 | 2020-08-27 | Montgomery | Illinois | 17135 | 243 | 7 |
473639 | 473639 | 2020-08-27 | Morgan | Illinois | 17137 | 494 | 18 |
473640 | 473640 | 2020-08-27 | Moultrie | Illinois | 17139 | 144 | 0 |
473641 | 473641 | 2020-08-27 | Ogle | Illinois | 17141 | 479 | 5 |
473642 | 473642 | 2020-08-27 | Peoria | Illinois | 17143 | 2271 | 40 |
473643 | 473643 | 2020-08-27 | Perry | Illinois | 17145 | 283 | 8 |
473644 | 473644 | 2020-08-27 | Piatt | Illinois | 17147 | 72 | 0 |
473645 | 473645 | 2020-08-27 | Pike | Illinois | 17149 | 66 | 0 |
473646 | 473646 | 2020-08-27 | Pope | Illinois | 17151 | 14 | 1 |
473647 | 473647 | 2020-08-27 | Pulaski | Illinois | 17153 | 117 | 1 |
473648 | 473648 | 2020-08-27 | Putnam | Illinois | 17155 | 15 | 0 |
473649 | 473649 | 2020-08-27 | Randolph | Illinois | 17157 | 697 | 7 |
473650 | 473650 | 2020-08-27 | Richland | Illinois | 17159 | 58 | 1 |
473651 | 473651 | 2020-08-27 | Rock Island | Illinois | 17161 | 2123 | 57 |
473652 | 473652 | 2020-08-27 | Saline | Illinois | 17165 | 161 | 3 |
473653 | 473653 | 2020-08-27 | Sangamon | Illinois | 17167 | 1736 | 39 |
473654 | 473654 | 2020-08-27 | Schuyler | Illinois | 17169 | 19 | 0 |
473655 | 473655 | 2020-08-27 | Scott | Illinois | 17171 | 44 | 0 |
473656 | 473656 | 2020-08-27 | Shelby | Illinois | 17173 | 176 | 3 |
473657 | 473657 | 2020-08-27 | St. Clair | Illinois | 17163 | 5617 | 174 |
473658 | 473658 | 2020-08-27 | Stark | Illinois | 17175 | 15 | 0 |
473659 | 473659 | 2020-08-27 | Stephenson | Illinois | 17177 | 373 | 6 |
473660 | 473660 | 2020-08-27 | Tazewell | Illinois | 17179 | 1028 | 9 |
473661 | 473661 | 2020-08-27 | Union | Illinois | 17181 | 414 | 23 |
473662 | 473662 | 2020-08-27 | Unknown | Illinois | 1361 | 207 | |
473663 | 473663 | 2020-08-27 | Vermilion | Illinois | 17183 | 312 | 3 |
473664 | 473664 | 2020-08-27 | Wabash | Illinois | 17185 | 95 | 1 |
473665 | 473665 | 2020-08-27 | Warren | Illinois | 17187 | 241 | 1 |
473666 | 473666 | 2020-08-27 | Washington | Illinois | 17189 | 106 | 1 |
473667 | 473667 | 2020-08-27 | Wayne | Illinois | 17191 | 90 | 2 |
473668 | 473668 | 2020-08-27 | White | Illinois | 17193 | 114 | 0 |
473669 | 473669 | 2020-08-27 | Whiteside | Illinois | 17195 | 483 | 19 |
473670 | 473670 | 2020-08-27 | Will | Illinois | 17197 | 11181 | 359 |
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);