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 2021-01-19 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 |
---|---|---|---|---|---|---|---|
943754 | 943754 | 2021-01-19 | Adams | Illinois | 17001 | 7405 | 117 |
943755 | 943755 | 2021-01-19 | Alexander | Illinois | 17003 | 389 | 7 |
943756 | 943756 | 2021-01-19 | Bond | Illinois | 17005 | 1738 | 24 |
943757 | 943757 | 2021-01-19 | Boone | Illinois | 17007 | 5549 | 77 |
943758 | 943758 | 2021-01-19 | Brown | Illinois | 17009 | 610 | 11 |
943759 | 943759 | 2021-01-19 | Bureau | Illinois | 17011 | 3004 | 84 |
943760 | 943760 | 2021-01-19 | Calhoun | Illinois | 17013 | 440 | 4 |
943761 | 943761 | 2021-01-19 | Carroll | Illinois | 17015 | 1426 | 33 |
943762 | 943762 | 2021-01-19 | Cass | Illinois | 17017 | 1751 | 31 |
943763 | 943763 | 2021-01-19 | Champaign | Illinois | 17019 | 15485 | 102 |
943764 | 943764 | 2021-01-19 | Christian | Illinois | 17021 | 2986 | 74 |
943765 | 943765 | 2021-01-19 | Clark | Illinois | 17023 | 1477 | 30 |
943766 | 943766 | 2021-01-19 | Clay | Illinois | 17025 | 1312 | 40 |
943767 | 943767 | 2021-01-19 | Clinton | Illinois | 17027 | 5032 | 85 |
943768 | 943768 | 2021-01-19 | Coles | Illinois | 17029 | 4703 | 80 |
943769 | 943769 | 2021-01-19 | Cook | Illinois | 17031 | 435888 | 9065 |
943770 | 943770 | 2021-01-19 | Crawford | Illinois | 17033 | 1761 | 34 |
943771 | 943771 | 2021-01-19 | Cumberland | Illinois | 17035 | 1085 | 27 |
943772 | 943772 | 2021-01-19 | De Witt | Illinois | 17039 | 1147 | 27 |
943773 | 943773 | 2021-01-19 | DeKalb | Illinois | 17037 | 7612 | 92 |
943774 | 943774 | 2021-01-19 | Douglas | Illinois | 17041 | 1995 | 33 |
943775 | 943775 | 2021-01-19 | DuPage | Illinois | 17043 | 69285 | 1153 |
943776 | 943776 | 2021-01-19 | Edgar | Illinois | 17045 | 1443 | 53 |
943777 | 943777 | 2021-01-19 | Edwards | Illinois | 17047 | 462 | 9 |
943778 | 943778 | 2021-01-19 | Effingham | Illinois | 17049 | 4311 | 69 |
943779 | 943779 | 2021-01-19 | Fayette | Illinois | 17051 | 2911 | 53 |
943780 | 943780 | 2021-01-19 | Ford | Illinois | 17053 | 1390 | 49 |
943781 | 943781 | 2021-01-19 | Franklin | Illinois | 17055 | 3847 | 69 |
943782 | 943782 | 2021-01-19 | Fulton | Illinois | 17057 | 2569 | 49 |
943783 | 943783 | 2021-01-19 | Gallatin | Illinois | 17059 | 388 | 4 |
943784 | 943784 | 2021-01-19 | Greene | Illinois | 17061 | 1257 | 42 |
943785 | 943785 | 2021-01-19 | Grundy | Illinois | 17063 | 4387 | 54 |
943786 | 943786 | 2021-01-19 | Hamilton | Illinois | 17065 | 717 | 17 |
943787 | 943787 | 2021-01-19 | Hancock | Illinois | 17067 | 1486 | 34 |
943788 | 943788 | 2021-01-19 | Hardin | Illinois | 17069 | 303 | 8 |
943789 | 943789 | 2021-01-19 | Henderson | Illinois | 17071 | 453 | 16 |
943790 | 943790 | 2021-01-19 | Henry | Illinois | 17073 | 4014 | 76 |
943791 | 943791 | 2021-01-19 | Iroquois | Illinois | 17075 | 2597 | 56 |
943792 | 943792 | 2021-01-19 | Jackson | Illinois | 17077 | 4187 | 67 |
943793 | 943793 | 2021-01-19 | Jasper | Illinois | 17079 | 1040 | 15 |
943794 | 943794 | 2021-01-19 | Jefferson | Illinois | 17081 | 3435 | 104 |
943795 | 943795 | 2021-01-19 | Jersey | Illinois | 17083 | 2225 | 56 |
943796 | 943796 | 2021-01-19 | Jo Daviess | Illinois | 17085 | 1485 | 24 |
943797 | 943797 | 2021-01-19 | Johnson | Illinois | 17087 | 1211 | 15 |
943798 | 943798 | 2021-01-19 | Kane | Illinois | 17089 | 46063 | 677 |
943799 | 943799 | 2021-01-19 | Kankakee | Illinois | 17091 | 11488 | 179 |
943800 | 943800 | 2021-01-19 | Kendall | Illinois | 17093 | 9855 | 78 |
943801 | 943801 | 2021-01-19 | Knox | Illinois | 17095 | 4589 | 142 |
943802 | 943802 | 2021-01-19 | LaSalle | Illinois | 17099 | 9478 | 247 |
943803 | 943803 | 2021-01-19 | Lake | Illinois | 17097 | 53439 | 886 |
943804 | 943804 | 2021-01-19 | Lawrence | Illinois | 17101 | 2176 | 30 |
943805 | 943805 | 2021-01-19 | Lee | Illinois | 17103 | 3048 | 72 |
943806 | 943806 | 2021-01-19 | Livingston | Illinois | 17105 | 3647 | 66 |
943807 | 943807 | 2021-01-19 | Logan | Illinois | 17107 | 3094 | 56 |
943808 | 943808 | 2021-01-19 | Macon | Illinois | 17115 | 8836 | 179 |
943809 | 943809 | 2021-01-19 | Macoupin | Illinois | 17117 | 3849 | 94 |
943810 | 943810 | 2021-01-19 | Madison | Illinois | 17119 | 24398 | 463 |
943811 | 943811 | 2021-01-19 | Marion | Illinois | 17121 | 3994 | 112 |
943812 | 943812 | 2021-01-19 | Marshall | Illinois | 17123 | 670 | 13 |
943813 | 943813 | 2021-01-19 | Mason | Illinois | 17125 | 1166 | 40 |
943814 | 943814 | 2021-01-19 | Massac | Illinois | 17127 | 1018 | 31 |
943815 | 943815 | 2021-01-19 | McDonough | Illinois | 17109 | 2150 | 51 |
943816 | 943816 | 2021-01-19 | McHenry | Illinois | 17111 | 21712 | 248 |
943817 | 943817 | 2021-01-19 | McLean | Illinois | 17113 | 13244 | 159 |
943818 | 943818 | 2021-01-19 | Menard | Illinois | 17129 | 880 | 10 |
943819 | 943819 | 2021-01-19 | Mercer | Illinois | 17131 | 1172 | 29 |
943820 | 943820 | 2021-01-19 | Monroe | Illinois | 17133 | 3587 | 70 |
943821 | 943821 | 2021-01-19 | Montgomery | Illinois | 17135 | 3053 | 41 |
943822 | 943822 | 2021-01-19 | Morgan | Illinois | 17137 | 3347 | 90 |
943823 | 943823 | 2021-01-19 | Moultrie | Illinois | 17139 | 1374 | 28 |
943824 | 943824 | 2021-01-19 | Ogle | Illinois | 17141 | 4603 | 71 |
943825 | 943825 | 2021-01-19 | Peoria | Illinois | 17143 | 15067 | 241 |
943826 | 943826 | 2021-01-19 | Perry | Illinois | 17145 | 2670 | 60 |
943827 | 943827 | 2021-01-19 | Piatt | Illinois | 17147 | 1174 | 16 |
943828 | 943828 | 2021-01-19 | Pike | Illinois | 17149 | 1543 | 46 |
943829 | 943829 | 2021-01-19 | Pope | Illinois | 17151 | 247 | 2 |
943830 | 943830 | 2021-01-19 | Pulaski | Illinois | 17153 | 613 | 3 |
943831 | 943831 | 2021-01-19 | Putnam | Illinois | 17155 | 346 | 2 |
943832 | 943832 | 2021-01-19 | Randolph | Illinois | 17157 | 3715 | 68 |
943833 | 943833 | 2021-01-19 | Richland | Illinois | 17159 | 1536 | 44 |
943834 | 943834 | 2021-01-19 | Rock Island | Illinois | 17161 | 11919 | 303 |
943835 | 943835 | 2021-01-19 | Saline | Illinois | 17165 | 2030 | 53 |
943836 | 943836 | 2021-01-19 | Sangamon | Illinois | 17167 | 14548 | 235 |
943837 | 943837 | 2021-01-19 | Schuyler | Illinois | 17169 | 624 | 16 |
943838 | 943838 | 2021-01-19 | Scott | Illinois | 17171 | 385 | 1 |
943839 | 943839 | 2021-01-19 | Shelby | Illinois | 17173 | 1970 | 35 |
943840 | 943840 | 2021-01-19 | St. Clair | Illinois | 17163 | 24618 | 426 |
943841 | 943841 | 2021-01-19 | Stark | Illinois | 17175 | 493 | 20 |
943842 | 943842 | 2021-01-19 | Stephenson | Illinois | 17177 | 3532 | 74 |
943843 | 943843 | 2021-01-19 | Tazewell | Illinois | 17179 | 11996 | 245 |
943844 | 943844 | 2021-01-19 | Union | Illinois | 17181 | 1993 | 32 |
943845 | 943845 | 2021-01-19 | Vermilion | Illinois | 17183 | 7538 | 113 |
943846 | 943846 | 2021-01-19 | Wabash | Illinois | 17185 | 1179 | 14 |
943847 | 943847 | 2021-01-19 | Warren | Illinois | 17187 | 1586 | 44 |
943848 | 943848 | 2021-01-19 | Washington | Illinois | 17189 | 1452 | 25 |
943849 | 943849 | 2021-01-19 | Wayne | Illinois | 17191 | 1520 | 43 |
943850 | 943850 | 2021-01-19 | White | Illinois | 17193 | 1334 | 30 |
943851 | 943851 | 2021-01-19 | Whiteside | Illinois | 17195 | 5375 | 173 |
943852 | 943852 | 2021-01-19 | Will | Illinois | 17197 | 58408 | 870 |
943853 | 943853 | 2021-01-19 | Williamson | Illinois | 17199 | 6196 | 116 |
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);