ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where "date" is on date 2020-04-14 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
57012 | 57012 | 2020-04-14 | Adams | Illinois | 17001 | 27 | 0 |
57013 | 57013 | 2020-04-14 | Bond | Illinois | 17005 | 4 | 0 |
57014 | 57014 | 2020-04-14 | Boone | Illinois | 17007 | 13 | 1 |
57015 | 57015 | 2020-04-14 | Bureau | Illinois | 17011 | 6 | 0 |
57016 | 57016 | 2020-04-14 | Calhoun | Illinois | 17013 | 1 | 0 |
57017 | 57017 | 2020-04-14 | Carroll | Illinois | 17015 | 5 | 1 |
57018 | 57018 | 2020-04-14 | Champaign | Illinois | 17019 | 88 | 2 |
57019 | 57019 | 2020-04-14 | Christian | Illinois | 17021 | 25 | 5 |
57020 | 57020 | 2020-04-14 | Clark | Illinois | 17023 | 4 | 0 |
57021 | 57021 | 2020-04-14 | Clay | Illinois | 17025 | 1 | 0 |
57022 | 57022 | 2020-04-14 | Clinton | Illinois | 17027 | 38 | 0 |
57023 | 57023 | 2020-04-14 | Coles | Illinois | 17029 | 8 | 0 |
57024 | 57024 | 2020-04-14 | Cook | Illinois | 17031 | 16323 | 577 |
57025 | 57025 | 2020-04-14 | Crawford | Illinois | 17033 | 4 | 0 |
57026 | 57026 | 2020-04-14 | Cumberland | Illinois | 17035 | 2 | 0 |
57027 | 57027 | 2020-04-14 | De Witt | Illinois | 17039 | 2 | 0 |
57028 | 57028 | 2020-04-14 | DeKalb | Illinois | 17037 | 35 | 1 |
57029 | 57029 | 2020-04-14 | Douglas | Illinois | 17041 | 11 | 0 |
57030 | 57030 | 2020-04-14 | DuPage | Illinois | 17043 | 1312 | 61 |
57031 | 57031 | 2020-04-14 | Effingham | Illinois | 17049 | 3 | 1 |
57032 | 57032 | 2020-04-14 | Fayette | Illinois | 17051 | 12 | 1 |
57033 | 57033 | 2020-04-14 | Ford | Illinois | 17053 | 5 | 1 |
57034 | 57034 | 2020-04-14 | Franklin | Illinois | 17055 | 4 | 0 |
57035 | 57035 | 2020-04-14 | Fulton | Illinois | 17057 | 1 | 0 |
57036 | 57036 | 2020-04-14 | Gallatin | Illinois | 17059 | 2 | 0 |
57037 | 57037 | 2020-04-14 | Greene | Illinois | 17061 | 1 | 0 |
57038 | 57038 | 2020-04-14 | Grundy | Illinois | 17063 | 24 | 0 |
57039 | 57039 | 2020-04-14 | Hancock | Illinois | 17067 | 1 | 0 |
57040 | 57040 | 2020-04-14 | Henry | Illinois | 17073 | 23 | 0 |
57041 | 57041 | 2020-04-14 | Iroquois | Illinois | 17075 | 9 | 0 |
57042 | 57042 | 2020-04-14 | Jackson | Illinois | 17077 | 35 | 4 |
57043 | 57043 | 2020-04-14 | Jasper | Illinois | 17079 | 3 | 1 |
57044 | 57044 | 2020-04-14 | Jefferson | Illinois | 17081 | 8 | 0 |
57045 | 57045 | 2020-04-14 | Jersey | Illinois | 17083 | 6 | 0 |
57046 | 57046 | 2020-04-14 | Jo Daviess | Illinois | 17085 | 11 | 0 |
57047 | 57047 | 2020-04-14 | Johnson | Illinois | 17087 | 1 | 0 |
57048 | 57048 | 2020-04-14 | Kane | Illinois | 17089 | 448 | 24 |
57049 | 57049 | 2020-04-14 | Kankakee | Illinois | 17091 | 228 | 12 |
57050 | 57050 | 2020-04-14 | Kendall | Illinois | 17093 | 114 | 2 |
57051 | 57051 | 2020-04-14 | Knox | Illinois | 17095 | 2 | 0 |
57052 | 57052 | 2020-04-14 | LaSalle | Illinois | 17099 | 23 | 1 |
57053 | 57053 | 2020-04-14 | Lake | Illinois | 17097 | 1621 | 58 |
57054 | 57054 | 2020-04-14 | Lawrence | Illinois | 17101 | 2 | 0 |
57055 | 57055 | 2020-04-14 | Lee | Illinois | 17103 | 13 | 0 |
57056 | 57056 | 2020-04-14 | Livingston | Illinois | 17105 | 17 | 0 |
57057 | 57057 | 2020-04-14 | Logan | Illinois | 17107 | 4 | 0 |
57058 | 57058 | 2020-04-14 | Macon | Illinois | 17115 | 45 | 3 |
57059 | 57059 | 2020-04-14 | Macoupin | Illinois | 17117 | 16 | 0 |
57060 | 57060 | 2020-04-14 | Madison | Illinois | 17119 | 128 | 2 |
57061 | 57061 | 2020-04-14 | Marion | Illinois | 17121 | 14 | 0 |
57062 | 57062 | 2020-04-14 | Marshall | Illinois | 17123 | 2 | 0 |
57063 | 57063 | 2020-04-14 | Mason | Illinois | 17125 | 3 | 0 |
57064 | 57064 | 2020-04-14 | Massac | Illinois | 17127 | 3 | 0 |
57065 | 57065 | 2020-04-14 | McDonough | Illinois | 17109 | 2 | 0 |
57066 | 57066 | 2020-04-14 | McHenry | Illinois | 17111 | 257 | 8 |
57067 | 57067 | 2020-04-14 | McLean | Illinois | 17113 | 81 | 2 |
57068 | 57068 | 2020-04-14 | Menard | Illinois | 17129 | 2 | 0 |
57069 | 57069 | 2020-04-14 | Mercer | Illinois | 17131 | 3 | 0 |
57070 | 57070 | 2020-04-14 | Monroe | Illinois | 17133 | 47 | 3 |
57071 | 57071 | 2020-04-14 | Montgomery | Illinois | 17135 | 9 | 0 |
57072 | 57072 | 2020-04-14 | Morgan | Illinois | 17137 | 11 | 1 |
57073 | 57073 | 2020-04-14 | Moultrie | Illinois | 17139 | 2 | 0 |
57074 | 57074 | 2020-04-14 | Ogle | Illinois | 17141 | 26 | 1 |
57075 | 57075 | 2020-04-14 | Peoria | Illinois | 17143 | 31 | 1 |
57076 | 57076 | 2020-04-14 | Perry | Illinois | 17145 | 1 | 0 |
57077 | 57077 | 2020-04-14 | Piatt | Illinois | 17147 | 6 | 0 |
57078 | 57078 | 2020-04-14 | Pike | Illinois | 17149 | 1 | 0 |
57079 | 57079 | 2020-04-14 | Pulaski | Illinois | 17153 | 5 | 0 |
57080 | 57080 | 2020-04-14 | Randolph | Illinois | 17157 | 41 | 0 |
57081 | 57081 | 2020-04-14 | Richland | Illinois | 17159 | 1 | 0 |
57082 | 57082 | 2020-04-14 | Rock Island | Illinois | 17161 | 113 | 3 |
57083 | 57083 | 2020-04-14 | Saline | Illinois | 17165 | 3 | 0 |
57084 | 57084 | 2020-04-14 | Sangamon | Illinois | 17167 | 50 | 3 |
57085 | 57085 | 2020-04-14 | Schuyler | Illinois | 17169 | 1 | 0 |
57086 | 57086 | 2020-04-14 | Shelby | Illinois | 17173 | 4 | 0 |
57087 | 57087 | 2020-04-14 | St. Clair | Illinois | 17163 | 220 | 8 |
57088 | 57088 | 2020-04-14 | Stark | Illinois | 17175 | 1 | 0 |
57089 | 57089 | 2020-04-14 | Stephenson | Illinois | 17177 | 9 | 0 |
57090 | 57090 | 2020-04-14 | Tazewell | Illinois | 17179 | 21 | 3 |
57091 | 57091 | 2020-04-14 | Unknown | Illinois | 43 | 0 | |
57092 | 57092 | 2020-04-14 | Vermilion | Illinois | 17183 | 8 | 0 |
57093 | 57093 | 2020-04-14 | Wabash | Illinois | 17185 | 2 | 0 |
57094 | 57094 | 2020-04-14 | Warren | Illinois | 17187 | 2 | 0 |
57095 | 57095 | 2020-04-14 | Washington | Illinois | 17189 | 2 | 0 |
57096 | 57096 | 2020-04-14 | Whiteside | Illinois | 17195 | 30 | 3 |
57097 | 57097 | 2020-04-14 | Will | Illinois | 17197 | 1350 | 77 |
57098 | 57098 | 2020-04-14 | Williamson | Illinois | 17199 | 10 | 0 |
57099 | 57099 | 2020-04-14 | Winnebago | Illinois | 17201 | 101 | 7 |
57100 | 57100 | 2020-04-14 | Woodford | Illinois | 17203 | 10 | 0 |
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);