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 2020-12-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 |
---|---|---|---|---|---|---|---|
794468 | 794468 | 2020-12-04 | Adams | Illinois | 17001 | 5049 | 56 |
794469 | 794469 | 2020-12-04 | Alexander | Illinois | 17003 | 270 | 4 |
794470 | 794470 | 2020-12-04 | Bond | Illinois | 17005 | 1175 | 11 |
794471 | 794471 | 2020-12-04 | Boone | Illinois | 17007 | 4113 | 37 |
794472 | 794472 | 2020-12-04 | Brown | Illinois | 17009 | 343 | 6 |
794473 | 794473 | 2020-12-04 | Bureau | Illinois | 17011 | 2263 | 55 |
794474 | 794474 | 2020-12-04 | Calhoun | Illinois | 17013 | 280 | 1 |
794475 | 794475 | 2020-12-04 | Carroll | Illinois | 17015 | 1125 | 27 |
794476 | 794476 | 2020-12-04 | Cass | Illinois | 17017 | 1093 | 23 |
794477 | 794477 | 2020-12-04 | Champaign | Illinois | 17019 | 11436 | 63 |
794478 | 794478 | 2020-12-04 | Christian | Illinois | 17021 | 1984 | 47 |
794479 | 794479 | 2020-12-04 | Clark | Illinois | 17023 | 845 | 20 |
794480 | 794480 | 2020-12-04 | Clay | Illinois | 17025 | 967 | 22 |
794481 | 794481 | 2020-12-04 | Clinton | Illinois | 17027 | 3557 | 63 |
794482 | 794482 | 2020-12-04 | Coles | Illinois | 17029 | 3489 | 62 |
794483 | 794483 | 2020-12-04 | Cook | Illinois | 17031 | 322122 | 6852 |
794484 | 794484 | 2020-12-04 | Crawford | Illinois | 17033 | 1199 | 16 |
794485 | 794485 | 2020-12-04 | Cumberland | Illinois | 17035 | 699 | 19 |
794486 | 794486 | 2020-12-04 | De Witt | Illinois | 17039 | 665 | 18 |
794487 | 794487 | 2020-12-04 | DeKalb | Illinois | 17037 | 5458 | 49 |
794488 | 794488 | 2020-12-04 | Douglas | Illinois | 17041 | 1470 | 19 |
794489 | 794489 | 2020-12-04 | DuPage | Illinois | 17043 | 49311 | 832 |
794490 | 794490 | 2020-12-04 | Edgar | Illinois | 17045 | 914 | 17 |
794491 | 794491 | 2020-12-04 | Edwards | Illinois | 17047 | 252 | 4 |
794492 | 794492 | 2020-12-04 | Effingham | Illinois | 17049 | 3040 | 29 |
794493 | 794493 | 2020-12-04 | Fayette | Illinois | 17051 | 1955 | 37 |
794494 | 794494 | 2020-12-04 | Ford | Illinois | 17053 | 830 | 25 |
794495 | 794495 | 2020-12-04 | Franklin | Illinois | 17055 | 2243 | 30 |
794496 | 794496 | 2020-12-04 | Fulton | Illinois | 17057 | 1642 | 15 |
794497 | 794497 | 2020-12-04 | Gallatin | Illinois | 17059 | 216 | 3 |
794498 | 794498 | 2020-12-04 | Greene | Illinois | 17061 | 915 | 34 |
794499 | 794499 | 2020-12-04 | Grundy | Illinois | 17063 | 3034 | 25 |
794500 | 794500 | 2020-12-04 | Hamilton | Illinois | 17065 | 422 | 4 |
794501 | 794501 | 2020-12-04 | Hancock | Illinois | 17067 | 1022 | 16 |
794502 | 794502 | 2020-12-04 | Hardin | Illinois | 17069 | 162 | 2 |
794503 | 794503 | 2020-12-04 | Henderson | Illinois | 17071 | 314 | 1 |
794504 | 794504 | 2020-12-04 | Henry | Illinois | 17073 | 2907 | 22 |
794505 | 794505 | 2020-12-04 | Iroquois | Illinois | 17075 | 1869 | 34 |
794506 | 794506 | 2020-12-04 | Jackson | Illinois | 17077 | 2885 | 38 |
794507 | 794507 | 2020-12-04 | Jasper | Illinois | 17079 | 710 | 12 |
794508 | 794508 | 2020-12-04 | Jefferson | Illinois | 17081 | 2063 | 63 |
794509 | 794509 | 2020-12-04 | Jersey | Illinois | 17083 | 1410 | 24 |
794510 | 794510 | 2020-12-04 | Jo Daviess | Illinois | 17085 | 1149 | 20 |
794511 | 794511 | 2020-12-04 | Johnson | Illinois | 17087 | 786 | 8 |
794512 | 794512 | 2020-12-04 | Kane | Illinois | 17089 | 33695 | 492 |
794513 | 794513 | 2020-12-04 | Kankakee | Illinois | 17091 | 9226 | 124 |
794514 | 794514 | 2020-12-04 | Kendall | Illinois | 17093 | 6757 | 56 |
794515 | 794515 | 2020-12-04 | Knox | Illinois | 17095 | 3048 | 75 |
794516 | 794516 | 2020-12-04 | LaSalle | Illinois | 17099 | 6587 | 149 |
794517 | 794517 | 2020-12-04 | Lake | Illinois | 17097 | 39563 | 669 |
794518 | 794518 | 2020-12-04 | Lawrence | Illinois | 17101 | 1211 | 14 |
794519 | 794519 | 2020-12-04 | Lee | Illinois | 17103 | 2133 | 38 |
794520 | 794520 | 2020-12-04 | Livingston | Illinois | 17105 | 2419 | 38 |
794521 | 794521 | 2020-12-04 | Logan | Illinois | 17107 | 1928 | 24 |
794522 | 794522 | 2020-12-04 | Macon | Illinois | 17115 | 6874 | 145 |
794523 | 794523 | 2020-12-04 | Macoupin | Illinois | 17117 | 2467 | 25 |
794524 | 794524 | 2020-12-04 | Madison | Illinois | 17119 | 15643 | 271 |
794525 | 794525 | 2020-12-04 | Marion | Illinois | 17121 | 2700 | 66 |
794526 | 794526 | 2020-12-04 | Marshall | Illinois | 17123 | 441 | 7 |
794527 | 794527 | 2020-12-04 | Mason | Illinois | 17125 | 785 | 26 |
794528 | 794528 | 2020-12-04 | Massac | Illinois | 17127 | 661 | 7 |
794529 | 794529 | 2020-12-04 | McDonough | Illinois | 17109 | 1651 | 44 |
794530 | 794530 | 2020-12-04 | McHenry | Illinois | 17111 | 15160 | 170 |
794531 | 794531 | 2020-12-04 | McLean | Illinois | 17113 | 9099 | 59 |
794532 | 794532 | 2020-12-04 | Menard | Illinois | 17129 | 531 | 2 |
794533 | 794533 | 2020-12-04 | Mercer | Illinois | 17131 | 806 | 12 |
794534 | 794534 | 2020-12-04 | Monroe | Illinois | 17133 | 2241 | 48 |
794535 | 794535 | 2020-12-04 | Montgomery | Illinois | 17135 | 1278 | 19 |
794536 | 794536 | 2020-12-04 | Morgan | Illinois | 17137 | 2420 | 55 |
794537 | 794537 | 2020-12-04 | Moultrie | Illinois | 17139 | 981 | 11 |
794538 | 794538 | 2020-12-04 | Ogle | Illinois | 17141 | 3097 | 46 |
794539 | 794539 | 2020-12-04 | Peoria | Illinois | 17143 | 9949 | 142 |
794540 | 794540 | 2020-12-04 | Perry | Illinois | 17145 | 1208 | 33 |
794541 | 794541 | 2020-12-04 | Piatt | Illinois | 17147 | 833 | 5 |
794542 | 794542 | 2020-12-04 | Pike | Illinois | 17149 | 1076 | 30 |
794543 | 794543 | 2020-12-04 | Pope | Illinois | 17151 | 121 | 1 |
794544 | 794544 | 2020-12-04 | Pulaski | Illinois | 17153 | 456 | 2 |
794545 | 794545 | 2020-12-04 | Putnam | Illinois | 17155 | 257 | 0 |
794546 | 794546 | 2020-12-04 | Randolph | Illinois | 17157 | 2456 | 28 |
794547 | 794547 | 2020-12-04 | Richland | Illinois | 17159 | 883 | 19 |
794548 | 794548 | 2020-12-04 | Rock Island | Illinois | 17161 | 9110 | 170 |
794549 | 794549 | 2020-12-04 | Saline | Illinois | 17165 | 1197 | 29 |
794550 | 794550 | 2020-12-04 | Sangamon | Illinois | 17167 | 10792 | 112 |
794551 | 794551 | 2020-12-04 | Schuyler | Illinois | 17169 | 354 | 1 |
794552 | 794552 | 2020-12-04 | Scott | Illinois | 17171 | 257 | 0 |
794553 | 794553 | 2020-12-04 | Shelby | Illinois | 17173 | 1496 | 27 |
794554 | 794554 | 2020-12-04 | St. Clair | Illinois | 17163 | 15964 | 274 |
794555 | 794555 | 2020-12-04 | Stark | Illinois | 17175 | 312 | 5 |
794556 | 794556 | 2020-12-04 | Stephenson | Illinois | 17177 | 2614 | 41 |
794557 | 794557 | 2020-12-04 | Tazewell | Illinois | 17179 | 7543 | 122 |
794558 | 794558 | 2020-12-04 | Union | Illinois | 17181 | 1274 | 28 |
794559 | 794559 | 2020-12-04 | Vermilion | Illinois | 17183 | 4310 | 60 |
794560 | 794560 | 2020-12-04 | Wabash | Illinois | 17185 | 659 | 9 |
794561 | 794561 | 2020-12-04 | Warren | Illinois | 17187 | 1177 | 23 |
794562 | 794562 | 2020-12-04 | Washington | Illinois | 17189 | 810 | 3 |
794563 | 794563 | 2020-12-04 | Wayne | Illinois | 17191 | 989 | 35 |
794564 | 794564 | 2020-12-04 | White | Illinois | 17193 | 681 | 10 |
794565 | 794565 | 2020-12-04 | Whiteside | Illinois | 17195 | 4080 | 133 |
794566 | 794566 | 2020-12-04 | Will | Illinois | 17197 | 41826 | 600 |
794567 | 794567 | 2020-12-04 | Williamson | Illinois | 17199 | 3936 | 88 |
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);