ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where "date" is on date 2022-01-08 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2093475 | 2093475 | 2022-01-08 | Adams | Illinois | 17001 | 17327 | 203 |
2093476 | 2093476 | 2022-01-08 | Alexander | Illinois | 17003 | 933 | 13 |
2093477 | 2093477 | 2022-01-08 | Bond | Illinois | 17005 | 3294 | 34 |
2093478 | 2093478 | 2022-01-08 | Boone | Illinois | 17007 | 10634 | 106 |
2093479 | 2093479 | 2022-01-08 | Brown | Illinois | 17009 | 1280 | 19 |
2093480 | 2093480 | 2022-01-08 | Bureau | Illinois | 17011 | 6267 | 126 |
2093481 | 2093481 | 2022-01-08 | Calhoun | Illinois | 17013 | 1129 | 7 |
2093482 | 2093482 | 2022-01-08 | Carroll | Illinois | 17015 | 3139 | 43 |
2093483 | 2093483 | 2022-01-08 | Cass | Illinois | 17017 | 3423 | 40 |
2093484 | 2093484 | 2022-01-08 | Champaign | Illinois | 17019 | 43813 | 237 |
2093485 | 2093485 | 2022-01-08 | Christian | Illinois | 17021 | 7242 | 113 |
2093486 | 2093486 | 2022-01-08 | Clark | Illinois | 17023 | 3466 | 54 |
2093487 | 2093487 | 2022-01-08 | Clay | Illinois | 17025 | 3604 | 64 |
2093488 | 2093488 | 2022-01-08 | Clinton | Illinois | 17027 | 9146 | 117 |
2093489 | 2093489 | 2022-01-08 | Coles | Illinois | 17029 | 10745 | 148 |
2093490 | 2093490 | 2022-01-08 | Cook | Illinois | 17031 | 917379 | 12757 |
2093491 | 2093491 | 2022-01-08 | Crawford | Illinois | 17033 | 4061 | 52 |
2093492 | 2093492 | 2022-01-08 | Cumberland | Illinois | 17035 | 2488 | 43 |
2093493 | 2093493 | 2022-01-08 | De Witt | Illinois | 17039 | 3236 | 40 |
2093494 | 2093494 | 2022-01-08 | DeKalb | Illinois | 17037 | 18013 | 163 |
2093495 | 2093495 | 2022-01-08 | Douglas | Illinois | 17041 | 4538 | 48 |
2093496 | 2093496 | 2022-01-08 | DuPage | Illinois | 17043 | 159801 | 1553 |
2093497 | 2093497 | 2022-01-08 | Edgar | Illinois | 17045 | 3671 | 75 |
2093498 | 2093498 | 2022-01-08 | Edwards | Illinois | 17047 | 1324 | 23 |
2093499 | 2093499 | 2022-01-08 | Effingham | Illinois | 17049 | 8404 | 124 |
2093500 | 2093500 | 2022-01-08 | Fayette | Illinois | 17051 | 5435 | 77 |
2093501 | 2093501 | 2022-01-08 | Ford | Illinois | 17053 | 3434 | 67 |
2093502 | 2093502 | 2022-01-08 | Franklin | Illinois | 17055 | 9036 | 146 |
2093503 | 2093503 | 2022-01-08 | Fulton | Illinois | 17057 | 7229 | 106 |
2093504 | 2093504 | 2022-01-08 | Gallatin | Illinois | 17059 | 955 | 11 |
2093505 | 2093505 | 2022-01-08 | Greene | Illinois | 17061 | 2790 | 53 |
2093506 | 2093506 | 2022-01-08 | Grundy | Illinois | 17063 | 10584 | 109 |
2093507 | 2093507 | 2022-01-08 | Hamilton | Illinois | 17065 | 1605 | 28 |
2093508 | 2093508 | 2022-01-08 | Hancock | Illinois | 17067 | 3459 | 48 |
2093509 | 2093509 | 2022-01-08 | Hardin | Illinois | 17069 | 803 | 17 |
2093510 | 2093510 | 2022-01-08 | Henderson | Illinois | 17071 | 923 | 24 |
2093511 | 2093511 | 2022-01-08 | Henry | Illinois | 17073 | 9450 | 127 |
2093512 | 2093512 | 2022-01-08 | Iroquois | Illinois | 17075 | 5832 | 94 |
2093513 | 2093513 | 2022-01-08 | Jackson | Illinois | 17077 | 10719 | 113 |
2093514 | 2093514 | 2022-01-08 | Jasper | Illinois | 17079 | 2049 | 26 |
2093515 | 2093515 | 2022-01-08 | Jefferson | Illinois | 17081 | 8010 | 153 |
2093516 | 2093516 | 2022-01-08 | Jersey | Illinois | 17083 | 4713 | 76 |
2093517 | 2093517 | 2022-01-08 | Jo Daviess | Illinois | 17085 | 3061 | 35 |
2093518 | 2093518 | 2022-01-08 | Johnson | Illinois | 17087 | 2891 | 41 |
2093519 | 2093519 | 2022-01-08 | Kane | Illinois | 17089 | 95298 | 1011 |
2093520 | 2093520 | 2022-01-08 | Kankakee | Illinois | 17091 | 24298 | 309 |
2093521 | 2093521 | 2022-01-08 | Kendall | Illinois | 17093 | 24302 | 136 |
2093522 | 2093522 | 2022-01-08 | Knox | Illinois | 17095 | 9893 | 217 |
2093523 | 2093523 | 2022-01-08 | LaSalle | Illinois | 17099 | 21263 | 386 |
2093524 | 2093524 | 2022-01-08 | Lake | Illinois | 17097 | 111749 | 1235 |
2093525 | 2093525 | 2022-01-08 | Lawrence | Illinois | 17101 | 4017 | 47 |
2093526 | 2093526 | 2022-01-08 | Lee | Illinois | 17103 | 6510 | 109 |
2093527 | 2093527 | 2022-01-08 | Livingston | Illinois | 17105 | 7973 | 128 |
2093528 | 2093528 | 2022-01-08 | Logan | Illinois | 17107 | 6791 | 91 |
2093529 | 2093529 | 2022-01-08 | Macon | Illinois | 17115 | 22196 | 295 |
2093530 | 2093530 | 2022-01-08 | Macoupin | Illinois | 17117 | 9268 | 152 |
2093531 | 2093531 | 2022-01-08 | Madison | Illinois | 17119 | 53801 | 733 |
2093532 | 2093532 | 2022-01-08 | Marion | Illinois | 17121 | 9015 | 174 |
2093533 | 2093533 | 2022-01-08 | Marshall | Illinois | 17123 | 2117 | 26 |
2093534 | 2093534 | 2022-01-08 | Mason | Illinois | 17125 | 2944 | 56 |
2093535 | 2093535 | 2022-01-08 | Massac | Illinois | 17127 | 2787 | 64 |
2093536 | 2093536 | 2022-01-08 | McDonough | Illinois | 17109 | 5124 | 85 |
2093537 | 2093537 | 2022-01-08 | McHenry | Illinois | 17111 | 51753 | 400 |
2093538 | 2093538 | 2022-01-08 | McLean | Illinois | 17113 | 35127 | 286 |
2093539 | 2093539 | 2022-01-08 | Menard | Illinois | 17129 | 2573 | 19 |
2093540 | 2093540 | 2022-01-08 | Mercer | Illinois | 17131 | 3014 | 38 |
2093541 | 2093541 | 2022-01-08 | Monroe | Illinois | 17133 | 7092 | 109 |
2093542 | 2093542 | 2022-01-08 | Montgomery | Illinois | 17135 | 6802 | 94 |
2093543 | 2093543 | 2022-01-08 | Morgan | Illinois | 17137 | 6689 | 125 |
2093544 | 2093544 | 2022-01-08 | Moultrie | Illinois | 17139 | 3148 | 47 |
2093545 | 2093545 | 2022-01-08 | Ogle | Illinois | 17141 | 10774 | 124 |
2093546 | 2093546 | 2022-01-08 | Peoria | Illinois | 17143 | 37833 | 470 |
2093547 | 2093547 | 2022-01-08 | Perry | Illinois | 17145 | 5188 | 93 |
2093548 | 2093548 | 2022-01-08 | Piatt | Illinois | 17147 | 3284 | 22 |
2093549 | 2093549 | 2022-01-08 | Pike | Illinois | 17149 | 3828 | 62 |
2093550 | 2093550 | 2022-01-08 | Pope | Illinois | 17151 | 729 | 7 |
2093551 | 2093551 | 2022-01-08 | Pulaski | Illinois | 17153 | 1265 | 15 |
2093552 | 2093552 | 2022-01-08 | Putnam | Illinois | 17155 | 862 | 8 |
2093553 | 2093553 | 2022-01-08 | Randolph | Illinois | 17157 | 6857 | 114 |
2093554 | 2093554 | 2022-01-08 | Richland | Illinois | 17159 | 3684 | 76 |
2093555 | 2093555 | 2022-01-08 | Rock Island | Illinois | 17161 | 26056 | 455 |
2093556 | 2093556 | 2022-01-08 | Saline | Illinois | 17165 | 5389 | 94 |
2093557 | 2093557 | 2022-01-08 | Sangamon | Illinois | 17167 | 38668 | 358 |
2093558 | 2093558 | 2022-01-08 | Schuyler | Illinois | 17169 | 1454 | 26 |
2093559 | 2093559 | 2022-01-08 | Scott | Illinois | 17171 | 992 | 9 |
2093560 | 2093560 | 2022-01-08 | Shelby | Illinois | 17173 | 4706 | 63 |
2093561 | 2093561 | 2022-01-08 | St. Clair | Illinois | 17163 | 53280 | 694 |
2093562 | 2093562 | 2022-01-08 | Stark | Illinois | 17175 | 1089 | 30 |
2093563 | 2093563 | 2022-01-08 | Stephenson | Illinois | 17177 | 8857 | 148 |
2093564 | 2093564 | 2022-01-08 | Tazewell | Illinois | 17179 | 29116 | 424 |
2093565 | 2093565 | 2022-01-08 | Union | Illinois | 17181 | 3844 | 59 |
2093566 | 2093566 | 2022-01-08 | Unknown | Illinois | 0 | 1259 | |
2093567 | 2093567 | 2022-01-08 | Vermilion | Illinois | 17183 | 20727 | 262 |
2093568 | 2093568 | 2022-01-08 | Wabash | Illinois | 17185 | 2566 | 22 |
2093569 | 2093569 | 2022-01-08 | Warren | Illinois | 17187 | 3216 | 75 |
2093570 | 2093570 | 2022-01-08 | Washington | Illinois | 17189 | 2683 | 37 |
2093571 | 2093571 | 2022-01-08 | Wayne | Illinois | 17191 | 3763 | 68 |
2093572 | 2093572 | 2022-01-08 | White | Illinois | 17193 | 3306 | 45 |
2093573 | 2093573 | 2022-01-08 | Whiteside | Illinois | 17195 | 11437 | 239 |
2093574 | 2093574 | 2022-01-08 | Will | Illinois | 17197 | 131643 | 1336 |
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);