ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2020-03-31" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22205 | 22205 | 2020-03-31 | Adams | Illinois | 17001 | 2 | 0 |
22206 | 22206 | 2020-03-31 | Bond | Illinois | 17005 | 2 | 0 |
22207 | 22207 | 2020-03-31 | Bureau | Illinois | 17011 | 1 | 0 |
22208 | 22208 | 2020-03-31 | Carroll | Illinois | 17015 | 2 | 1 |
22209 | 22209 | 2020-03-31 | Champaign | Illinois | 17019 | 26 | 0 |
22210 | 22210 | 2020-03-31 | Christian | Illinois | 17021 | 14 | 0 |
22211 | 22211 | 2020-03-31 | Clark | Illinois | 17023 | 1 | 0 |
22212 | 22212 | 2020-03-31 | Clinton | Illinois | 17027 | 7 | 0 |
22213 | 22213 | 2020-03-31 | Cook | Illinois | 17031 | 4496 | 61 |
22214 | 22214 | 2020-03-31 | Crawford | Illinois | 17033 | 1 | 0 |
22215 | 22215 | 2020-03-31 | Cumberland | Illinois | 17035 | 1 | 0 |
22216 | 22216 | 2020-03-31 | DeKalb | Illinois | 17037 | 9 | 0 |
22217 | 22217 | 2020-03-31 | Douglas | Illinois | 17041 | 3 | 0 |
22218 | 22218 | 2020-03-31 | DuPage | Illinois | 17043 | 356 | 10 |
22219 | 22219 | 2020-03-31 | Fayette | Illinois | 17051 | 1 | 0 |
22220 | 22220 | 2020-03-31 | Ford | Illinois | 17053 | 1 | 0 |
22221 | 22221 | 2020-03-31 | Franklin | Illinois | 17055 | 1 | 0 |
22222 | 22222 | 2020-03-31 | Grundy | Illinois | 17063 | 4 | 0 |
22223 | 22223 | 2020-03-31 | Henry | Illinois | 17073 | 2 | 0 |
22224 | 22224 | 2020-03-31 | Iroquois | Illinois | 17075 | 2 | 0 |
22225 | 22225 | 2020-03-31 | Jackson | Illinois | 17077 | 4 | 0 |
22226 | 22226 | 2020-03-31 | Jo Daviess | Illinois | 17085 | 1 | 0 |
22227 | 22227 | 2020-03-31 | Kane | Illinois | 17089 | 128 | 7 |
22228 | 22228 | 2020-03-31 | Kankakee | Illinois | 17091 | 47 | 0 |
22229 | 22229 | 2020-03-31 | Kendall | Illinois | 17093 | 19 | 2 |
22230 | 22230 | 2020-03-31 | Knox | Illinois | 17095 | 1 | 0 |
22231 | 22231 | 2020-03-31 | LaSalle | Illinois | 17099 | 6 | 1 |
22232 | 22232 | 2020-03-31 | Lake | Illinois | 17097 | 389 | 7 |
22233 | 22233 | 2020-03-31 | Livingston | Illinois | 17105 | 3 | 0 |
22234 | 22234 | 2020-03-31 | Macon | Illinois | 17115 | 2 | 0 |
22235 | 22235 | 2020-03-31 | Madison | Illinois | 17119 | 16 | 0 |
22236 | 22236 | 2020-03-31 | Marion | Illinois | 17121 | 2 | 0 |
22237 | 22237 | 2020-03-31 | Marshall | Illinois | 17123 | 1 | 0 |
22238 | 22238 | 2020-03-31 | McHenry | Illinois | 17111 | 63 | 2 |
22239 | 22239 | 2020-03-31 | McLean | Illinois | 17113 | 19 | 2 |
22240 | 22240 | 2020-03-31 | Menard | Illinois | 17129 | 1 | 0 |
22241 | 22241 | 2020-03-31 | Monroe | Illinois | 17133 | 3 | 0 |
22242 | 22242 | 2020-03-31 | Montgomery | Illinois | 17135 | 2 | 0 |
22243 | 22243 | 2020-03-31 | Morgan | Illinois | 17137 | 4 | 1 |
22244 | 22244 | 2020-03-31 | Ogle | Illinois | 17141 | 1 | 0 |
22245 | 22245 | 2020-03-31 | Peoria | Illinois | 17143 | 8 | 0 |
22246 | 22246 | 2020-03-31 | Randolph | Illinois | 17157 | 3 | 0 |
22247 | 22247 | 2020-03-31 | Rock Island | Illinois | 17161 | 11 | 0 |
22248 | 22248 | 2020-03-31 | Saline | Illinois | 17165 | 1 | 0 |
22249 | 22249 | 2020-03-31 | Sangamon | Illinois | 17167 | 16 | 2 |
22250 | 22250 | 2020-03-31 | St. Clair | Illinois | 17163 | 43 | 2 |
22251 | 22251 | 2020-03-31 | Stephenson | Illinois | 17177 | 3 | 0 |
22252 | 22252 | 2020-03-31 | Tazewell | Illinois | 17179 | 4 | 0 |
22253 | 22253 | 2020-03-31 | Unknown | Illinois | 6 | 0 | |
22254 | 22254 | 2020-03-31 | Washington | Illinois | 17189 | 1 | 0 |
22255 | 22255 | 2020-03-31 | Whiteside | Illinois | 17195 | 5 | 1 |
22256 | 22256 | 2020-03-31 | Will | Illinois | 17197 | 228 | 8 |
22257 | 22257 | 2020-03-31 | Williamson | Illinois | 17199 | 1 | 0 |
22258 | 22258 | 2020-03-31 | Winnebago | Illinois | 17201 | 15 | 0 |
22259 | 22259 | 2020-03-31 | Woodford | Illinois | 17203 | 3 | 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);