ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-09-13" 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 |
---|---|---|---|---|---|---|---|
528549 | 528549 | 2020-09-13 | Adams | Illinois | 17001 | 876 | 10 |
528550 | 528550 | 2020-09-13 | Alexander | Illinois | 17003 | 60 | 1 |
528551 | 528551 | 2020-09-13 | Bond | Illinois | 17005 | 231 | 4 |
528552 | 528552 | 2020-09-13 | Boone | Illinois | 17007 | 955 | 23 |
528553 | 528553 | 2020-09-13 | Brown | Illinois | 17009 | 26 | 0 |
528554 | 528554 | 2020-09-13 | Bureau | Illinois | 17011 | 489 | 9 |
528555 | 528555 | 2020-09-13 | Calhoun | Illinois | 17013 | 34 | 0 |
528556 | 528556 | 2020-09-13 | Carroll | Illinois | 17015 | 159 | 4 |
528557 | 528557 | 2020-09-13 | Cass | Illinois | 17017 | 351 | 11 |
528558 | 528558 | 2020-09-13 | Champaign | Illinois | 17019 | 4035 | 20 |
528559 | 528559 | 2020-09-13 | Christian | Illinois | 17021 | 305 | 10 |
528560 | 528560 | 2020-09-13 | Clark | Illinois | 17023 | 137 | 2 |
528561 | 528561 | 2020-09-13 | Clay | Illinois | 17025 | 129 | 0 |
528562 | 528562 | 2020-09-13 | Clinton | Illinois | 17027 | 950 | 19 |
528563 | 528563 | 2020-09-13 | Coles | Illinois | 17029 | 1237 | 26 |
528564 | 528564 | 2020-09-13 | Cook | Illinois | 17031 | 134801 | 5133 |
528565 | 528565 | 2020-09-13 | Crawford | Illinois | 17033 | 255 | 1 |
528566 | 528566 | 2020-09-13 | Cumberland | Illinois | 17035 | 182 | 4 |
528567 | 528567 | 2020-09-13 | De Witt | Illinois | 17039 | 75 | 1 |
528568 | 528568 | 2020-09-13 | DeKalb | Illinois | 17037 | 1350 | 36 |
528569 | 528569 | 2020-09-13 | Douglas | Illinois | 17041 | 260 | 5 |
528570 | 528570 | 2020-09-13 | DuPage | Illinois | 17043 | 16022 | 545 |
528571 | 528571 | 2020-09-13 | Edgar | Illinois | 17045 | 104 | 3 |
528572 | 528572 | 2020-09-13 | Edwards | Illinois | 17047 | 55 | 0 |
528573 | 528573 | 2020-09-13 | Effingham | Illinois | 17049 | 744 | 1 |
528574 | 528574 | 2020-09-13 | Fayette | Illinois | 17051 | 255 | 3 |
528575 | 528575 | 2020-09-13 | Ford | Illinois | 17053 | 86 | 4 |
528576 | 528576 | 2020-09-13 | Franklin | Illinois | 17055 | 427 | 1 |
528577 | 528577 | 2020-09-13 | Fulton | Illinois | 17057 | 119 | 0 |
528578 | 528578 | 2020-09-13 | Gallatin | Illinois | 17059 | 68 | 2 |
528579 | 528579 | 2020-09-13 | Greene | Illinois | 17061 | 183 | 2 |
528580 | 528580 | 2020-09-13 | Grundy | Illinois | 17063 | 579 | 5 |
528581 | 528581 | 2020-09-13 | Hamilton | Illinois | 17065 | 52 | 0 |
528582 | 528582 | 2020-09-13 | Hancock | Illinois | 17067 | 170 | 2 |
528583 | 528583 | 2020-09-13 | Hardin | Illinois | 17069 | 26 | 0 |
528584 | 528584 | 2020-09-13 | Henderson | Illinois | 17071 | 60 | 0 |
528585 | 528585 | 2020-09-13 | Henry | Illinois | 17073 | 576 | 4 |
528586 | 528586 | 2020-09-13 | Iroquois | Illinois | 17075 | 335 | 19 |
528587 | 528587 | 2020-09-13 | Jackson | Illinois | 17077 | 1144 | 24 |
528588 | 528588 | 2020-09-13 | Jasper | Illinois | 17079 | 180 | 7 |
528589 | 528589 | 2020-09-13 | Jefferson | Illinois | 17081 | 513 | 37 |
528590 | 528590 | 2020-09-13 | Jersey | Illinois | 17083 | 356 | 12 |
528591 | 528591 | 2020-09-13 | Jo Daviess | Illinois | 17085 | 212 | 2 |
528592 | 528592 | 2020-09-13 | Johnson | Illinois | 17087 | 130 | 0 |
528593 | 528593 | 2020-09-13 | Kane | Illinois | 17089 | 12097 | 325 |
528594 | 528594 | 2020-09-13 | Kankakee | Illinois | 17091 | 2549 | 72 |
528595 | 528595 | 2020-09-13 | Kendall | Illinois | 17093 | 1852 | 26 |
528596 | 528596 | 2020-09-13 | Knox | Illinois | 17095 | 525 | 3 |
528597 | 528597 | 2020-09-13 | LaSalle | Illinois | 17099 | 1496 | 54 |
528598 | 528598 | 2020-09-13 | Lake | Illinois | 17097 | 15776 | 481 |
528599 | 528599 | 2020-09-13 | Lawrence | Illinois | 17101 | 233 | 0 |
528600 | 528600 | 2020-09-13 | Lee | Illinois | 17103 | 299 | 1 |
528601 | 528601 | 2020-09-13 | Livingston | Illinois | 17105 | 266 | 4 |
528602 | 528602 | 2020-09-13 | Logan | Illinois | 17107 | 386 | 1 |
528603 | 528603 | 2020-09-13 | Macon | Illinois | 17115 | 1224 | 32 |
528604 | 528604 | 2020-09-13 | Macoupin | Illinois | 17117 | 432 | 6 |
528605 | 528605 | 2020-09-13 | Madison | Illinois | 17119 | 4908 | 119 |
528606 | 528606 | 2020-09-13 | Marion | Illinois | 17121 | 427 | 0 |
528607 | 528607 | 2020-09-13 | Marshall | Illinois | 17123 | 71 | 0 |
528608 | 528608 | 2020-09-13 | Mason | Illinois | 17125 | 109 | 1 |
528609 | 528609 | 2020-09-13 | Massac | Illinois | 17127 | 83 | 1 |
528610 | 528610 | 2020-09-13 | McDonough | Illinois | 17109 | 404 | 15 |
528611 | 528611 | 2020-09-13 | McHenry | Illinois | 17111 | 4326 | 118 |
528612 | 528612 | 2020-09-13 | McLean | Illinois | 17113 | 2909 | 18 |
528613 | 528613 | 2020-09-13 | Menard | Illinois | 17129 | 95 | 0 |
528614 | 528614 | 2020-09-13 | Mercer | Illinois | 17131 | 118 | 5 |
528615 | 528615 | 2020-09-13 | Monroe | Illinois | 17133 | 581 | 15 |
528616 | 528616 | 2020-09-13 | Montgomery | Illinois | 17135 | 287 | 11 |
528617 | 528617 | 2020-09-13 | Morgan | Illinois | 17137 | 606 | 21 |
528618 | 528618 | 2020-09-13 | Moultrie | Illinois | 17139 | 196 | 3 |
528619 | 528619 | 2020-09-13 | Ogle | Illinois | 17141 | 575 | 5 |
528620 | 528620 | 2020-09-13 | Peoria | Illinois | 17143 | 2898 | 44 |
528621 | 528621 | 2020-09-13 | Perry | Illinois | 17145 | 320 | 13 |
528622 | 528622 | 2020-09-13 | Piatt | Illinois | 17147 | 119 | 0 |
528623 | 528623 | 2020-09-13 | Pike | Illinois | 17149 | 99 | 1 |
528624 | 528624 | 2020-09-13 | Pope | Illinois | 17151 | 23 | 1 |
528625 | 528625 | 2020-09-13 | Pulaski | Illinois | 17153 | 148 | 1 |
528626 | 528626 | 2020-09-13 | Putnam | Illinois | 17155 | 31 | 0 |
528627 | 528627 | 2020-09-13 | Randolph | Illinois | 17157 | 854 | 8 |
528628 | 528628 | 2020-09-13 | Richland | Illinois | 17159 | 116 | 4 |
528629 | 528629 | 2020-09-13 | Rock Island | Illinois | 17161 | 2684 | 73 |
528630 | 528630 | 2020-09-13 | Saline | Illinois | 17165 | 211 | 3 |
528631 | 528631 | 2020-09-13 | Sangamon | Illinois | 17167 | 2146 | 44 |
528632 | 528632 | 2020-09-13 | Schuyler | Illinois | 17169 | 34 | 0 |
528633 | 528633 | 2020-09-13 | Scott | Illinois | 17171 | 62 | 0 |
528634 | 528634 | 2020-09-13 | Shelby | Illinois | 17173 | 304 | 3 |
528635 | 528635 | 2020-09-13 | St. Clair | Illinois | 17163 | 6652 | 180 |
528636 | 528636 | 2020-09-13 | Stark | Illinois | 17175 | 45 | 1 |
528637 | 528637 | 2020-09-13 | Stephenson | Illinois | 17177 | 424 | 6 |
528638 | 528638 | 2020-09-13 | Tazewell | Illinois | 17179 | 1381 | 13 |
528639 | 528639 | 2020-09-13 | Union | Illinois | 17181 | 471 | 24 |
528640 | 528640 | 2020-09-13 | Unknown | Illinois | 2027 | 232 | |
528641 | 528641 | 2020-09-13 | Vermilion | Illinois | 17183 | 470 | 4 |
528642 | 528642 | 2020-09-13 | Wabash | Illinois | 17185 | 133 | 1 |
528643 | 528643 | 2020-09-13 | Warren | Illinois | 17187 | 282 | 1 |
528644 | 528644 | 2020-09-13 | Washington | Illinois | 17189 | 158 | 1 |
528645 | 528645 | 2020-09-13 | Wayne | Illinois | 17191 | 218 | 4 |
528646 | 528646 | 2020-09-13 | White | Illinois | 17193 | 149 | 0 |
528647 | 528647 | 2020-09-13 | Whiteside | Illinois | 17195 | 637 | 20 |
528648 | 528648 | 2020-09-13 | Will | Illinois | 17197 | 12820 | 367 |
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);