ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where date = "2020-11-10" 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 |
---|---|---|---|---|---|---|---|
716586 | 716586 | 2020-11-10 | Adams | Illinois | 17001 | 3136 | 31 |
716587 | 716587 | 2020-11-10 | Alexander | Illinois | 17003 | 185 | 2 |
716588 | 716588 | 2020-11-10 | Bond | Illinois | 17005 | 718 | 9 |
716589 | 716589 | 2020-11-10 | Boone | Illinois | 17007 | 2706 | 26 |
716590 | 716590 | 2020-11-10 | Brown | Illinois | 17009 | 196 | 0 |
716591 | 716591 | 2020-11-10 | Bureau | Illinois | 17011 | 1356 | 20 |
716592 | 716592 | 2020-11-10 | Calhoun | Illinois | 17013 | 127 | 0 |
716593 | 716593 | 2020-11-10 | Carroll | Illinois | 17015 | 755 | 18 |
716594 | 716594 | 2020-11-10 | Cass | Illinois | 17017 | 613 | 12 |
716595 | 716595 | 2020-11-10 | Champaign | Illinois | 17019 | 8180 | 37 |
716596 | 716596 | 2020-11-10 | Christian | Illinois | 17021 | 1265 | 32 |
716597 | 716597 | 2020-11-10 | Clark | Illinois | 17023 | 510 | 19 |
716598 | 716598 | 2020-11-10 | Clay | Illinois | 17025 | 462 | 16 |
716599 | 716599 | 2020-11-10 | Clinton | Illinois | 17027 | 2294 | 37 |
716600 | 716600 | 2020-11-10 | Coles | Illinois | 17029 | 2549 | 51 |
716601 | 716601 | 2020-11-10 | Cook | Illinois | 17031 | 227425 | 5828 |
716602 | 716602 | 2020-11-10 | Crawford | Illinois | 17033 | 776 | 6 |
716603 | 716603 | 2020-11-10 | Cumberland | Illinois | 17035 | 430 | 6 |
716604 | 716604 | 2020-11-10 | De Witt | Illinois | 17039 | 453 | 10 |
716605 | 716605 | 2020-11-10 | DeKalb | Illinois | 17037 | 3600 | 43 |
716606 | 716606 | 2020-11-10 | Douglas | Illinois | 17041 | 1015 | 10 |
716607 | 716607 | 2020-11-10 | DuPage | Illinois | 17043 | 31830 | 683 |
716608 | 716608 | 2020-11-10 | Edgar | Illinois | 17045 | 522 | 14 |
716609 | 716609 | 2020-11-10 | Edwards | Illinois | 17047 | 135 | 0 |
716610 | 716610 | 2020-11-10 | Effingham | Illinois | 17049 | 1771 | 6 |
716611 | 716611 | 2020-11-10 | Fayette | Illinois | 17051 | 1008 | 26 |
716612 | 716612 | 2020-11-10 | Ford | Illinois | 17053 | 421 | 19 |
716613 | 716613 | 2020-11-10 | Franklin | Illinois | 17055 | 1363 | 14 |
716614 | 716614 | 2020-11-10 | Fulton | Illinois | 17057 | 877 | 6 |
716615 | 716615 | 2020-11-10 | Gallatin | Illinois | 17059 | 138 | 3 |
716616 | 716616 | 2020-11-10 | Greene | Illinois | 17061 | 529 | 19 |
716617 | 716617 | 2020-11-10 | Grundy | Illinois | 17063 | 1617 | 9 |
716618 | 716618 | 2020-11-10 | Hamilton | Illinois | 17065 | 218 | 2 |
716619 | 716619 | 2020-11-10 | Hancock | Illinois | 17067 | 593 | 5 |
716620 | 716620 | 2020-11-10 | Hardin | Illinois | 17069 | 74 | 0 |
716621 | 716621 | 2020-11-10 | Henderson | Illinois | 17071 | 182 | 0 |
716622 | 716622 | 2020-11-10 | Henry | Illinois | 17073 | 1424 | 9 |
716623 | 716623 | 2020-11-10 | Iroquois | Illinois | 17075 | 945 | 20 |
716624 | 716624 | 2020-11-10 | Jackson | Illinois | 17077 | 1931 | 30 |
716625 | 716625 | 2020-11-10 | Jasper | Illinois | 17079 | 435 | 10 |
716626 | 716626 | 2020-11-10 | Jefferson | Illinois | 17081 | 1277 | 55 |
716627 | 716627 | 2020-11-10 | Jersey | Illinois | 17083 | 787 | 22 |
716628 | 716628 | 2020-11-10 | Jo Daviess | Illinois | 17085 | 757 | 11 |
716629 | 716629 | 2020-11-10 | Johnson | Illinois | 17087 | 504 | 0 |
716630 | 716630 | 2020-11-10 | Kane | Illinois | 17089 | 23179 | 384 |
716631 | 716631 | 2020-11-10 | Kankakee | Illinois | 17091 | 5367 | 86 |
716632 | 716632 | 2020-11-10 | Kendall | Illinois | 17093 | 4144 | 32 |
716633 | 716633 | 2020-11-10 | Knox | Illinois | 17095 | 1824 | 34 |
716634 | 716634 | 2020-11-10 | LaSalle | Illinois | 17099 | 3891 | 87 |
716635 | 716635 | 2020-11-10 | Lake | Illinois | 17097 | 27189 | 552 |
716636 | 716636 | 2020-11-10 | Lawrence | Illinois | 17101 | 501 | 8 |
716637 | 716637 | 2020-11-10 | Lee | Illinois | 17103 | 1248 | 8 |
716638 | 716638 | 2020-11-10 | Livingston | Illinois | 17105 | 1264 | 12 |
716639 | 716639 | 2020-11-10 | Logan | Illinois | 17107 | 957 | 6 |
716640 | 716640 | 2020-11-10 | Macon | Illinois | 17115 | 4699 | 80 |
716641 | 716641 | 2020-11-10 | Macoupin | Illinois | 17117 | 1205 | 13 |
716642 | 716642 | 2020-11-10 | Madison | Illinois | 17119 | 9601 | 170 |
716643 | 716643 | 2020-11-10 | Marion | Illinois | 17121 | 1495 | 29 |
716644 | 716644 | 2020-11-10 | Marshall | Illinois | 17123 | 223 | 4 |
716645 | 716645 | 2020-11-10 | Mason | Illinois | 17125 | 418 | 13 |
716646 | 716646 | 2020-11-10 | Massac | Illinois | 17127 | 238 | 2 |
716647 | 716647 | 2020-11-10 | McDonough | Illinois | 17109 | 1120 | 27 |
716648 | 716648 | 2020-11-10 | McHenry | Illinois | 17111 | 9858 | 126 |
716649 | 716649 | 2020-11-10 | McLean | Illinois | 17113 | 5890 | 40 |
716650 | 716650 | 2020-11-10 | Menard | Illinois | 17129 | 255 | 1 |
716651 | 716651 | 2020-11-10 | Mercer | Illinois | 17131 | 487 | 7 |
716652 | 716652 | 2020-11-10 | Monroe | Illinois | 17133 | 1335 | 40 |
716653 | 716653 | 2020-11-10 | Montgomery | Illinois | 17135 | 817 | 16 |
716654 | 716654 | 2020-11-10 | Morgan | Illinois | 17137 | 1420 | 31 |
716655 | 716655 | 2020-11-10 | Moultrie | Illinois | 17139 | 622 | 8 |
716656 | 716656 | 2020-11-10 | Ogle | Illinois | 17141 | 1931 | 9 |
716657 | 716657 | 2020-11-10 | Peoria | Illinois | 17143 | 6202 | 94 |
716658 | 716658 | 2020-11-10 | Perry | Illinois | 17145 | 651 | 16 |
716659 | 716659 | 2020-11-10 | Piatt | Illinois | 17147 | 474 | 5 |
716660 | 716660 | 2020-11-10 | Pike | Illinois | 17149 | 667 | 13 |
716661 | 716661 | 2020-11-10 | Pope | Illinois | 17151 | 53 | 1 |
716662 | 716662 | 2020-11-10 | Pulaski | Illinois | 17153 | 294 | 1 |
716663 | 716663 | 2020-11-10 | Putnam | Illinois | 17155 | 140 | 0 |
716664 | 716664 | 2020-11-10 | Randolph | Illinois | 17157 | 1588 | 19 |
716665 | 716665 | 2020-11-10 | Richland | Illinois | 17159 | 448 | 19 |
716666 | 716666 | 2020-11-10 | Rock Island | Illinois | 17161 | 5772 | 109 |
716667 | 716667 | 2020-11-10 | Saline | Illinois | 17165 | 786 | 15 |
716668 | 716668 | 2020-11-10 | Sangamon | Illinois | 17167 | 6431 | 73 |
716669 | 716669 | 2020-11-10 | Schuyler | Illinois | 17169 | 133 | 1 |
716670 | 716670 | 2020-11-10 | Scott | Illinois | 17171 | 157 | 0 |
716671 | 716671 | 2020-11-10 | Shelby | Illinois | 17173 | 946 | 22 |
716672 | 716672 | 2020-11-10 | St. Clair | Illinois | 17163 | 10676 | 242 |
716673 | 716673 | 2020-11-10 | Stark | Illinois | 17175 | 141 | 3 |
716674 | 716674 | 2020-11-10 | Stephenson | Illinois | 17177 | 1719 | 16 |
716675 | 716675 | 2020-11-10 | Tazewell | Illinois | 17179 | 3971 | 65 |
716676 | 716676 | 2020-11-10 | Union | Illinois | 17181 | 891 | 26 |
716677 | 716677 | 2020-11-10 | Vermilion | Illinois | 17183 | 2466 | 24 |
716678 | 716678 | 2020-11-10 | Wabash | Illinois | 17185 | 344 | 6 |
716679 | 716679 | 2020-11-10 | Warren | Illinois | 17187 | 719 | 11 |
716680 | 716680 | 2020-11-10 | Washington | Illinois | 17189 | 436 | 2 |
716681 | 716681 | 2020-11-10 | Wayne | Illinois | 17191 | 652 | 23 |
716682 | 716682 | 2020-11-10 | White | Illinois | 17193 | 373 | 6 |
716683 | 716683 | 2020-11-10 | Whiteside | Illinois | 17195 | 2600 | 61 |
716684 | 716684 | 2020-11-10 | Will | Illinois | 17197 | 25892 | 481 |
716685 | 716685 | 2020-11-10 | Williamson | Illinois | 17199 | 2545 | 67 |
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);