ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where date = "2020-11-21" 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 |
---|---|---|---|---|---|---|---|
752279 | 752279 | 2020-11-21 | Adams | Illinois | 17001 | 4372 | 46 |
752280 | 752280 | 2020-11-21 | Alexander | Illinois | 17003 | 241 | 2 |
752281 | 752281 | 2020-11-21 | Bond | Illinois | 17005 | 907 | 10 |
752282 | 752282 | 2020-11-21 | Boone | Illinois | 17007 | 3471 | 29 |
752283 | 752283 | 2020-11-21 | Brown | Illinois | 17009 | 273 | 3 |
752284 | 752284 | 2020-11-21 | Bureau | Illinois | 17011 | 1903 | 35 |
752285 | 752285 | 2020-11-21 | Calhoun | Illinois | 17013 | 212 | 0 |
752286 | 752286 | 2020-11-21 | Carroll | Illinois | 17015 | 966 | 24 |
752287 | 752287 | 2020-11-21 | Cass | Illinois | 17017 | 868 | 19 |
752288 | 752288 | 2020-11-21 | Champaign | Illinois | 17019 | 9974 | 45 |
752289 | 752289 | 2020-11-21 | Christian | Illinois | 17021 | 1719 | 38 |
752290 | 752290 | 2020-11-21 | Clark | Illinois | 17023 | 699 | 19 |
752291 | 752291 | 2020-11-21 | Clay | Illinois | 17025 | 715 | 16 |
752292 | 752292 | 2020-11-21 | Clinton | Illinois | 17027 | 2910 | 56 |
752293 | 752293 | 2020-11-21 | Coles | Illinois | 17029 | 3046 | 57 |
752294 | 752294 | 2020-11-21 | Cook | Illinois | 17031 | 277026 | 6261 |
752295 | 752295 | 2020-11-21 | Crawford | Illinois | 17033 | 1001 | 9 |
752296 | 752296 | 2020-11-21 | Cumberland | Illinois | 17035 | 555 | 13 |
752297 | 752297 | 2020-11-21 | De Witt | Illinois | 17039 | 564 | 13 |
752298 | 752298 | 2020-11-21 | DeKalb | Illinois | 17037 | 4518 | 45 |
752299 | 752299 | 2020-11-21 | Douglas | Illinois | 17041 | 1231 | 15 |
752300 | 752300 | 2020-11-21 | DuPage | Illinois | 17043 | 40314 | 744 |
752301 | 752301 | 2020-11-21 | Edgar | Illinois | 17045 | 679 | 15 |
752302 | 752302 | 2020-11-21 | Edwards | Illinois | 17047 | 197 | 3 |
752303 | 752303 | 2020-11-21 | Effingham | Illinois | 17049 | 2386 | 17 |
752304 | 752304 | 2020-11-21 | Fayette | Illinois | 17051 | 1386 | 28 |
752305 | 752305 | 2020-11-21 | Ford | Illinois | 17053 | 643 | 21 |
752306 | 752306 | 2020-11-21 | Franklin | Illinois | 17055 | 1816 | 22 |
752307 | 752307 | 2020-11-21 | Fulton | Illinois | 17057 | 1213 | 9 |
752308 | 752308 | 2020-11-21 | Gallatin | Illinois | 17059 | 175 | 3 |
752309 | 752309 | 2020-11-21 | Greene | Illinois | 17061 | 731 | 26 |
752310 | 752310 | 2020-11-21 | Grundy | Illinois | 17063 | 2387 | 11 |
752311 | 752311 | 2020-11-21 | Hamilton | Illinois | 17065 | 351 | 3 |
752312 | 752312 | 2020-11-21 | Hancock | Illinois | 17067 | 868 | 9 |
752313 | 752313 | 2020-11-21 | Hardin | Illinois | 17069 | 116 | 0 |
752314 | 752314 | 2020-11-21 | Henderson | Illinois | 17071 | 248 | 0 |
752315 | 752315 | 2020-11-21 | Henry | Illinois | 17073 | 2264 | 12 |
752316 | 752316 | 2020-11-21 | Iroquois | Illinois | 17075 | 1465 | 24 |
752317 | 752317 | 2020-11-21 | Jackson | Illinois | 17077 | 2413 | 33 |
752318 | 752318 | 2020-11-21 | Jasper | Illinois | 17079 | 571 | 11 |
752319 | 752319 | 2020-11-21 | Jefferson | Illinois | 17081 | 1619 | 57 |
752320 | 752320 | 2020-11-21 | Jersey | Illinois | 17083 | 1078 | 23 |
752321 | 752321 | 2020-11-21 | Jo Daviess | Illinois | 17085 | 958 | 16 |
752322 | 752322 | 2020-11-21 | Johnson | Illinois | 17087 | 647 | 3 |
752323 | 752323 | 2020-11-21 | Kane | Illinois | 17089 | 28832 | 438 |
752324 | 752324 | 2020-11-21 | Kankakee | Illinois | 17091 | 7536 | 95 |
752325 | 752325 | 2020-11-21 | Kendall | Illinois | 17093 | 5566 | 41 |
752326 | 752326 | 2020-11-21 | Knox | Illinois | 17095 | 2481 | 54 |
752327 | 752327 | 2020-11-21 | LaSalle | Illinois | 17099 | 5450 | 119 |
752328 | 752328 | 2020-11-21 | Lake | Illinois | 17097 | 33841 | 600 |
752329 | 752329 | 2020-11-21 | Lawrence | Illinois | 17101 | 821 | 9 |
752330 | 752330 | 2020-11-21 | Lee | Illinois | 17103 | 1645 | 20 |
752331 | 752331 | 2020-11-21 | Livingston | Illinois | 17105 | 1978 | 18 |
752332 | 752332 | 2020-11-21 | Logan | Illinois | 17107 | 1398 | 11 |
752333 | 752333 | 2020-11-21 | Macon | Illinois | 17115 | 5863 | 112 |
752334 | 752334 | 2020-11-21 | Macoupin | Illinois | 17117 | 1874 | 17 |
752335 | 752335 | 2020-11-21 | Madison | Illinois | 17119 | 12653 | 219 |
752336 | 752336 | 2020-11-21 | Marion | Illinois | 17121 | 2172 | 41 |
752337 | 752337 | 2020-11-21 | Marshall | Illinois | 17123 | 331 | 5 |
752338 | 752338 | 2020-11-21 | Mason | Illinois | 17125 | 612 | 16 |
752339 | 752339 | 2020-11-21 | Massac | Illinois | 17127 | 443 | 2 |
752340 | 752340 | 2020-11-21 | McDonough | Illinois | 17109 | 1460 | 37 |
752341 | 752341 | 2020-11-21 | McHenry | Illinois | 17111 | 12789 | 146 |
752342 | 752342 | 2020-11-21 | McLean | Illinois | 17113 | 7526 | 48 |
752343 | 752343 | 2020-11-21 | Menard | Illinois | 17129 | 396 | 1 |
752344 | 752344 | 2020-11-21 | Mercer | Illinois | 17131 | 658 | 9 |
752345 | 752345 | 2020-11-21 | Monroe | Illinois | 17133 | 1748 | 44 |
752346 | 752346 | 2020-11-21 | Montgomery | Illinois | 17135 | 1030 | 17 |
752347 | 752347 | 2020-11-21 | Morgan | Illinois | 17137 | 1922 | 36 |
752348 | 752348 | 2020-11-21 | Moultrie | Illinois | 17139 | 801 | 10 |
752349 | 752349 | 2020-11-21 | Ogle | Illinois | 17141 | 2529 | 24 |
752350 | 752350 | 2020-11-21 | Peoria | Illinois | 17143 | 7968 | 115 |
752351 | 752351 | 2020-11-21 | Perry | Illinois | 17145 | 898 | 19 |
752352 | 752352 | 2020-11-21 | Piatt | Illinois | 17147 | 695 | 5 |
752353 | 752353 | 2020-11-21 | Pike | Illinois | 17149 | 919 | 19 |
752354 | 752354 | 2020-11-21 | Pope | Illinois | 17151 | 71 | 1 |
752355 | 752355 | 2020-11-21 | Pulaski | Illinois | 17153 | 370 | 2 |
752356 | 752356 | 2020-11-21 | Putnam | Illinois | 17155 | 220 | 0 |
752357 | 752357 | 2020-11-21 | Randolph | Illinois | 17157 | 1992 | 23 |
752358 | 752358 | 2020-11-21 | Richland | Illinois | 17159 | 626 | 19 |
752359 | 752359 | 2020-11-21 | Rock Island | Illinois | 17161 | 7794 | 127 |
752360 | 752360 | 2020-11-21 | Saline | Illinois | 17165 | 1013 | 21 |
752361 | 752361 | 2020-11-21 | Sangamon | Illinois | 17167 | 8908 | 89 |
752362 | 752362 | 2020-11-21 | Schuyler | Illinois | 17169 | 227 | 1 |
752363 | 752363 | 2020-11-21 | Scott | Illinois | 17171 | 211 | 0 |
752364 | 752364 | 2020-11-21 | Shelby | Illinois | 17173 | 1177 | 24 |
752365 | 752365 | 2020-11-21 | St. Clair | Illinois | 17163 | 12866 | 251 |
752366 | 752366 | 2020-11-21 | Stark | Illinois | 17175 | 193 | 3 |
752367 | 752367 | 2020-11-21 | Stephenson | Illinois | 17177 | 2234 | 29 |
752368 | 752368 | 2020-11-21 | Tazewell | Illinois | 17179 | 5695 | 89 |
752369 | 752369 | 2020-11-21 | Union | Illinois | 17181 | 1094 | 26 |
752370 | 752370 | 2020-11-21 | Vermilion | Illinois | 17183 | 3335 | 42 |
752371 | 752371 | 2020-11-21 | Wabash | Illinois | 17185 | 452 | 8 |
752372 | 752372 | 2020-11-21 | Warren | Illinois | 17187 | 937 | 16 |
752373 | 752373 | 2020-11-21 | Washington | Illinois | 17189 | 569 | 2 |
752374 | 752374 | 2020-11-21 | Wayne | Illinois | 17191 | 800 | 31 |
752375 | 752375 | 2020-11-21 | White | Illinois | 17193 | 511 | 8 |
752376 | 752376 | 2020-11-21 | Whiteside | Illinois | 17195 | 3573 | 91 |
752377 | 752377 | 2020-11-21 | Will | Illinois | 17197 | 34338 | 526 |
752378 | 752378 | 2020-11-21 | Williamson | Illinois | 17199 | 3176 | 76 |
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);