ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-09-04" 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 |
---|---|---|---|---|---|---|---|
499439 | 499439 | 2020-09-04 | Adams | Illinois | 17001 | 805 | 9 |
499440 | 499440 | 2020-09-04 | Alexander | Illinois | 17003 | 47 | 1 |
499441 | 499441 | 2020-09-04 | Bond | Illinois | 17005 | 191 | 4 |
499442 | 499442 | 2020-09-04 | Boone | Illinois | 17007 | 898 | 23 |
499443 | 499443 | 2020-09-04 | Brown | Illinois | 17009 | 24 | 0 |
499444 | 499444 | 2020-09-04 | Bureau | Illinois | 17011 | 429 | 9 |
499445 | 499445 | 2020-09-04 | Calhoun | Illinois | 17013 | 32 | 0 |
499446 | 499446 | 2020-09-04 | Carroll | Illinois | 17015 | 146 | 4 |
499447 | 499447 | 2020-09-04 | Cass | Illinois | 17017 | 332 | 11 |
499448 | 499448 | 2020-09-04 | Champaign | Illinois | 17019 | 3225 | 20 |
499449 | 499449 | 2020-09-04 | Christian | Illinois | 17021 | 264 | 7 |
499450 | 499450 | 2020-09-04 | Clark | Illinois | 17023 | 120 | 2 |
499451 | 499451 | 2020-09-04 | Clay | Illinois | 17025 | 108 | 0 |
499452 | 499452 | 2020-09-04 | Clinton | Illinois | 17027 | 809 | 17 |
499453 | 499453 | 2020-09-04 | Coles | Illinois | 17029 | 1094 | 23 |
499454 | 499454 | 2020-09-04 | Cook | Illinois | 17031 | 129545 | 5086 |
499455 | 499455 | 2020-09-04 | Crawford | Illinois | 17033 | 111 | 1 |
499456 | 499456 | 2020-09-04 | Cumberland | Illinois | 17035 | 154 | 4 |
499457 | 499457 | 2020-09-04 | De Witt | Illinois | 17039 | 52 | 1 |
499458 | 499458 | 2020-09-04 | DeKalb | Illinois | 17037 | 1237 | 36 |
499459 | 499459 | 2020-09-04 | Douglas | Illinois | 17041 | 235 | 5 |
499460 | 499460 | 2020-09-04 | DuPage | Illinois | 17043 | 15109 | 536 |
499461 | 499461 | 2020-09-04 | Edgar | Illinois | 17045 | 93 | 2 |
499462 | 499462 | 2020-09-04 | Edwards | Illinois | 17047 | 45 | 0 |
499463 | 499463 | 2020-09-04 | Effingham | Illinois | 17049 | 616 | 1 |
499464 | 499464 | 2020-09-04 | Fayette | Illinois | 17051 | 196 | 3 |
499465 | 499465 | 2020-09-04 | Ford | Illinois | 17053 | 77 | 3 |
499466 | 499466 | 2020-09-04 | Franklin | Illinois | 17055 | 377 | 1 |
499467 | 499467 | 2020-09-04 | Fulton | Illinois | 17057 | 99 | 0 |
499468 | 499468 | 2020-09-04 | Gallatin | Illinois | 17059 | 65 | 2 |
499469 | 499469 | 2020-09-04 | Greene | Illinois | 17061 | 152 | 1 |
499470 | 499470 | 2020-09-04 | Grundy | Illinois | 17063 | 526 | 5 |
499471 | 499471 | 2020-09-04 | Hamilton | Illinois | 17065 | 47 | 0 |
499472 | 499472 | 2020-09-04 | Hancock | Illinois | 17067 | 155 | 2 |
499473 | 499473 | 2020-09-04 | Hardin | Illinois | 17069 | 20 | 0 |
499474 | 499474 | 2020-09-04 | Henderson | Illinois | 17071 | 51 | 0 |
499475 | 499475 | 2020-09-04 | Henry | Illinois | 17073 | 514 | 2 |
499476 | 499476 | 2020-09-04 | Iroquois | Illinois | 17075 | 316 | 19 |
499477 | 499477 | 2020-09-04 | Jackson | Illinois | 17077 | 1021 | 22 |
499478 | 499478 | 2020-09-04 | Jasper | Illinois | 17079 | 155 | 7 |
499479 | 499479 | 2020-09-04 | Jefferson | Illinois | 17081 | 479 | 35 |
499480 | 499480 | 2020-09-04 | Jersey | Illinois | 17083 | 315 | 6 |
499481 | 499481 | 2020-09-04 | Jo Daviess | Illinois | 17085 | 190 | 2 |
499482 | 499482 | 2020-09-04 | Johnson | Illinois | 17087 | 122 | 0 |
499483 | 499483 | 2020-09-04 | Kane | Illinois | 17089 | 11623 | 317 |
499484 | 499484 | 2020-09-04 | Kankakee | Illinois | 17091 | 2420 | 72 |
499485 | 499485 | 2020-09-04 | Kendall | Illinois | 17093 | 1762 | 26 |
499486 | 499486 | 2020-09-04 | Knox | Illinois | 17095 | 483 | 3 |
499487 | 499487 | 2020-09-04 | LaSalle | Illinois | 17099 | 1357 | 52 |
499488 | 499488 | 2020-09-04 | Lake | Illinois | 17097 | 15012 | 471 |
499489 | 499489 | 2020-09-04 | Lawrence | Illinois | 17101 | 175 | 0 |
499490 | 499490 | 2020-09-04 | Lee | Illinois | 17103 | 268 | 1 |
499491 | 499491 | 2020-09-04 | Livingston | Illinois | 17105 | 224 | 4 |
499492 | 499492 | 2020-09-04 | Logan | Illinois | 17107 | 306 | 1 |
499493 | 499493 | 2020-09-04 | Macon | Illinois | 17115 | 1072 | 28 |
499494 | 499494 | 2020-09-04 | Macoupin | Illinois | 17117 | 388 | 6 |
499495 | 499495 | 2020-09-04 | Madison | Illinois | 17119 | 4380 | 105 |
499496 | 499496 | 2020-09-04 | Marion | Illinois | 17121 | 311 | 0 |
499497 | 499497 | 2020-09-04 | Marshall | Illinois | 17123 | 53 | 0 |
499498 | 499498 | 2020-09-04 | Mason | Illinois | 17125 | 95 | 1 |
499499 | 499499 | 2020-09-04 | Massac | Illinois | 17127 | 70 | 1 |
499500 | 499500 | 2020-09-04 | McDonough | Illinois | 17109 | 278 | 15 |
499501 | 499501 | 2020-09-04 | McHenry | Illinois | 17111 | 4078 | 118 |
499502 | 499502 | 2020-09-04 | McLean | Illinois | 17113 | 2454 | 17 |
499503 | 499503 | 2020-09-04 | Menard | Illinois | 17129 | 77 | 0 |
499504 | 499504 | 2020-09-04 | Mercer | Illinois | 17131 | 114 | 5 |
499505 | 499505 | 2020-09-04 | Monroe | Illinois | 17133 | 499 | 14 |
499506 | 499506 | 2020-09-04 | Montgomery | Illinois | 17135 | 263 | 9 |
499507 | 499507 | 2020-09-04 | Morgan | Illinois | 17137 | 575 | 21 |
499508 | 499508 | 2020-09-04 | Moultrie | Illinois | 17139 | 178 | 3 |
499509 | 499509 | 2020-09-04 | Ogle | Illinois | 17141 | 534 | 5 |
499510 | 499510 | 2020-09-04 | Peoria | Illinois | 17143 | 2548 | 41 |
499511 | 499511 | 2020-09-04 | Perry | Illinois | 17145 | 306 | 11 |
499512 | 499512 | 2020-09-04 | Piatt | Illinois | 17147 | 92 | 0 |
499513 | 499513 | 2020-09-04 | Pike | Illinois | 17149 | 78 | 0 |
499514 | 499514 | 2020-09-04 | Pope | Illinois | 17151 | 22 | 1 |
499515 | 499515 | 2020-09-04 | Pulaski | Illinois | 17153 | 136 | 1 |
499516 | 499516 | 2020-09-04 | Putnam | Illinois | 17155 | 21 | 0 |
499517 | 499517 | 2020-09-04 | Randolph | Illinois | 17157 | 783 | 7 |
499518 | 499518 | 2020-09-04 | Richland | Illinois | 17159 | 76 | 4 |
499519 | 499519 | 2020-09-04 | Rock Island | Illinois | 17161 | 2378 | 68 |
499520 | 499520 | 2020-09-04 | Saline | Illinois | 17165 | 176 | 3 |
499521 | 499521 | 2020-09-04 | Sangamon | Illinois | 17167 | 1954 | 40 |
499522 | 499522 | 2020-09-04 | Schuyler | Illinois | 17169 | 30 | 0 |
499523 | 499523 | 2020-09-04 | Scott | Illinois | 17171 | 49 | 0 |
499524 | 499524 | 2020-09-04 | Shelby | Illinois | 17173 | 242 | 3 |
499525 | 499525 | 2020-09-04 | St. Clair | Illinois | 17163 | 6167 | 175 |
499526 | 499526 | 2020-09-04 | Stark | Illinois | 17175 | 37 | 1 |
499527 | 499527 | 2020-09-04 | Stephenson | Illinois | 17177 | 395 | 6 |
499528 | 499528 | 2020-09-04 | Tazewell | Illinois | 17179 | 1209 | 12 |
499529 | 499529 | 2020-09-04 | Union | Illinois | 17181 | 442 | 24 |
499530 | 499530 | 2020-09-04 | Unknown | Illinois | 1863 | 219 | |
499531 | 499531 | 2020-09-04 | Vermilion | Illinois | 17183 | 385 | 4 |
499532 | 499532 | 2020-09-04 | Wabash | Illinois | 17185 | 120 | 1 |
499533 | 499533 | 2020-09-04 | Warren | Illinois | 17187 | 270 | 1 |
499534 | 499534 | 2020-09-04 | Washington | Illinois | 17189 | 126 | 1 |
499535 | 499535 | 2020-09-04 | Wayne | Illinois | 17191 | 125 | 2 |
499536 | 499536 | 2020-09-04 | White | Illinois | 17193 | 139 | 0 |
499537 | 499537 | 2020-09-04 | Whiteside | Illinois | 17195 | 586 | 19 |
499538 | 499538 | 2020-09-04 | Will | Illinois | 17197 | 12107 | 363 |
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);