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 2021-12-15 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2015461 | 2015461 | 2021-12-15 | Adams | Illinois | 17001 | 15231 | 192 |
2015462 | 2015462 | 2021-12-15 | Alexander | Illinois | 17003 | 835 | 13 |
2015463 | 2015463 | 2021-12-15 | Bond | Illinois | 17005 | 2889 | 34 |
2015464 | 2015464 | 2021-12-15 | Boone | Illinois | 17007 | 9395 | 100 |
2015465 | 2015465 | 2021-12-15 | Brown | Illinois | 17009 | 1171 | 18 |
2015466 | 2015466 | 2021-12-15 | Bureau | Illinois | 17011 | 5241 | 116 |
2015467 | 2015467 | 2021-12-15 | Calhoun | Illinois | 17013 | 890 | 6 |
2015468 | 2015468 | 2021-12-15 | Carroll | Illinois | 17015 | 2848 | 42 |
2015469 | 2015469 | 2021-12-15 | Cass | Illinois | 17017 | 2907 | 40 |
2015470 | 2015470 | 2021-12-15 | Champaign | Illinois | 17019 | 32518 | 220 |
2015471 | 2015471 | 2021-12-15 | Christian | Illinois | 17021 | 6279 | 102 |
2015472 | 2015472 | 2021-12-15 | Clark | Illinois | 17023 | 3129 | 52 |
2015473 | 2015473 | 2021-12-15 | Clay | Illinois | 17025 | 3134 | 60 |
2015474 | 2015474 | 2021-12-15 | Clinton | Illinois | 17027 | 7780 | 116 |
2015475 | 2015475 | 2021-12-15 | Coles | Illinois | 17029 | 9173 | 144 |
2015476 | 2015476 | 2021-12-15 | Cook | Illinois | 17031 | 711936 | 12247 |
2015477 | 2015477 | 2021-12-15 | Crawford | Illinois | 17033 | 3694 | 47 |
2015478 | 2015478 | 2021-12-15 | Cumberland | Illinois | 17035 | 2215 | 41 |
2015479 | 2015479 | 2021-12-15 | De Witt | Illinois | 17039 | 2679 | 39 |
2015480 | 2015480 | 2021-12-15 | DeKalb | Illinois | 17037 | 14695 | 156 |
2015481 | 2015481 | 2021-12-15 | Douglas | Illinois | 17041 | 3817 | 44 |
2015482 | 2015482 | 2021-12-15 | DuPage | Illinois | 17043 | 125077 | 1509 |
2015483 | 2015483 | 2021-12-15 | Edgar | Illinois | 17045 | 3226 | 71 |
2015484 | 2015484 | 2021-12-15 | Edwards | Illinois | 17047 | 1201 | 21 |
2015485 | 2015485 | 2021-12-15 | Effingham | Illinois | 17049 | 7541 | 123 |
2015486 | 2015486 | 2021-12-15 | Fayette | Illinois | 17051 | 4847 | 74 |
2015487 | 2015487 | 2021-12-15 | Ford | Illinois | 17053 | 2858 | 67 |
2015488 | 2015488 | 2021-12-15 | Franklin | Illinois | 17055 | 8120 | 137 |
2015489 | 2015489 | 2021-12-15 | Fulton | Illinois | 17057 | 6018 | 96 |
2015490 | 2015490 | 2021-12-15 | Gallatin | Illinois | 17059 | 857 | 11 |
2015491 | 2015491 | 2021-12-15 | Greene | Illinois | 17061 | 2362 | 53 |
2015492 | 2015492 | 2021-12-15 | Grundy | Illinois | 17063 | 8882 | 96 |
2015493 | 2015493 | 2021-12-15 | Hamilton | Illinois | 17065 | 1473 | 26 |
2015494 | 2015494 | 2021-12-15 | Hancock | Illinois | 17067 | 3219 | 45 |
2015495 | 2015495 | 2021-12-15 | Hardin | Illinois | 17069 | 715 | 16 |
2015496 | 2015496 | 2021-12-15 | Henderson | Illinois | 17071 | 851 | 24 |
2015497 | 2015497 | 2021-12-15 | Henry | Illinois | 17073 | 7885 | 115 |
2015498 | 2015498 | 2021-12-15 | Iroquois | Illinois | 17075 | 5028 | 88 |
2015499 | 2015499 | 2021-12-15 | Jackson | Illinois | 17077 | 8702 | 110 |
2015500 | 2015500 | 2021-12-15 | Jasper | Illinois | 17079 | 1825 | 23 |
2015501 | 2015501 | 2021-12-15 | Jefferson | Illinois | 17081 | 7199 | 149 |
2015502 | 2015502 | 2021-12-15 | Jersey | Illinois | 17083 | 4010 | 74 |
2015503 | 2015503 | 2021-12-15 | Jo Daviess | Illinois | 17085 | 2751 | 34 |
2015504 | 2015504 | 2021-12-15 | Johnson | Illinois | 17087 | 2581 | 38 |
2015505 | 2015505 | 2021-12-15 | Kane | Illinois | 17089 | 77932 | 978 |
2015506 | 2015506 | 2021-12-15 | Kankakee | Illinois | 17091 | 20698 | 285 |
2015507 | 2015507 | 2021-12-15 | Kendall | Illinois | 17093 | 19339 | 133 |
2015508 | 2015508 | 2021-12-15 | Knox | Illinois | 17095 | 8268 | 211 |
2015509 | 2015509 | 2021-12-15 | LaSalle | Illinois | 17099 | 17462 | 352 |
2015510 | 2015510 | 2021-12-15 | Lake | Illinois | 17097 | 92293 | 1196 |
2015511 | 2015511 | 2021-12-15 | Lawrence | Illinois | 17101 | 3689 | 46 |
2015512 | 2015512 | 2021-12-15 | Lee | Illinois | 17103 | 5551 | 105 |
2015513 | 2015513 | 2021-12-15 | Livingston | Illinois | 17105 | 6822 | 122 |
2015514 | 2015514 | 2021-12-15 | Logan | Illinois | 17107 | 5660 | 90 |
2015515 | 2015515 | 2021-12-15 | Macon | Illinois | 17115 | 18086 | 276 |
2015516 | 2015516 | 2021-12-15 | Macoupin | Illinois | 17117 | 8031 | 148 |
2015517 | 2015517 | 2021-12-15 | Madison | Illinois | 17119 | 45073 | 708 |
2015518 | 2015518 | 2021-12-15 | Marion | Illinois | 17121 | 7868 | 162 |
2015519 | 2015519 | 2021-12-15 | Marshall | Illinois | 17123 | 1689 | 25 |
2015520 | 2015520 | 2021-12-15 | Mason | Illinois | 17125 | 2505 | 54 |
2015521 | 2015521 | 2021-12-15 | Massac | Illinois | 17127 | 2479 | 59 |
2015522 | 2015522 | 2021-12-15 | McDonough | Illinois | 17109 | 4345 | 81 |
2015523 | 2015523 | 2021-12-15 | McHenry | Illinois | 17111 | 42383 | 376 |
2015524 | 2015524 | 2021-12-15 | McLean | Illinois | 17113 | 27248 | 276 |
2015525 | 2015525 | 2021-12-15 | Menard | Illinois | 17129 | 2034 | 19 |
2015526 | 2015526 | 2021-12-15 | Mercer | Illinois | 17131 | 2520 | 37 |
2015527 | 2015527 | 2021-12-15 | Monroe | Illinois | 17133 | 5920 | 106 |
2015528 | 2015528 | 2021-12-15 | Montgomery | Illinois | 17135 | 5702 | 91 |
2015529 | 2015529 | 2021-12-15 | Morgan | Illinois | 17137 | 5831 | 125 |
2015530 | 2015530 | 2021-12-15 | Moultrie | Illinois | 17139 | 2770 | 44 |
2015531 | 2015531 | 2021-12-15 | Ogle | Illinois | 17141 | 9360 | 110 |
2015532 | 2015532 | 2021-12-15 | Peoria | Illinois | 17143 | 30796 | 433 |
2015533 | 2015533 | 2021-12-15 | Perry | Illinois | 17145 | 4671 | 89 |
2015534 | 2015534 | 2021-12-15 | Piatt | Illinois | 17147 | 2666 | 21 |
2015535 | 2015535 | 2021-12-15 | Pike | Illinois | 17149 | 3194 | 61 |
2015536 | 2015536 | 2021-12-15 | Pope | Illinois | 17151 | 641 | 6 |
2015537 | 2015537 | 2021-12-15 | Pulaski | Illinois | 17153 | 1134 | 14 |
2015538 | 2015538 | 2021-12-15 | Putnam | Illinois | 17155 | 705 | 6 |
2015539 | 2015539 | 2021-12-15 | Randolph | Illinois | 17157 | 5955 | 110 |
2015540 | 2015540 | 2021-12-15 | Richland | Illinois | 17159 | 3325 | 74 |
2015541 | 2015541 | 2021-12-15 | Rock Island | Illinois | 17161 | 22191 | 431 |
2015542 | 2015542 | 2021-12-15 | Saline | Illinois | 17165 | 4758 | 90 |
2015543 | 2015543 | 2021-12-15 | Sangamon | Illinois | 17167 | 29444 | 343 |
2015544 | 2015544 | 2021-12-15 | Schuyler | Illinois | 17169 | 1229 | 24 |
2015545 | 2015545 | 2021-12-15 | Scott | Illinois | 17171 | 822 | 7 |
2015546 | 2015546 | 2021-12-15 | Shelby | Illinois | 17173 | 4141 | 57 |
2015547 | 2015547 | 2021-12-15 | St. Clair | Illinois | 17163 | 44711 | 667 |
2015548 | 2015548 | 2021-12-15 | Stark | Illinois | 17175 | 977 | 29 |
2015549 | 2015549 | 2021-12-15 | Stephenson | Illinois | 17177 | 7833 | 136 |
2015550 | 2015550 | 2021-12-15 | Tazewell | Illinois | 17179 | 24296 | 397 |
2015551 | 2015551 | 2021-12-15 | Union | Illinois | 17181 | 3426 | 56 |
2015552 | 2015552 | 2021-12-15 | Unknown | Illinois | 0 | 1031 | |
2015553 | 2015553 | 2021-12-15 | Vermilion | Illinois | 17183 | 17799 | 242 |
2015554 | 2015554 | 2021-12-15 | Wabash | Illinois | 17185 | 2316 | 22 |
2015555 | 2015555 | 2021-12-15 | Warren | Illinois | 17187 | 2767 | 72 |
2015556 | 2015556 | 2021-12-15 | Washington | Illinois | 17189 | 2315 | 36 |
2015557 | 2015557 | 2021-12-15 | Wayne | Illinois | 17191 | 3399 | 67 |
2015558 | 2015558 | 2021-12-15 | White | Illinois | 17193 | 2998 | 43 |
2015559 | 2015559 | 2021-12-15 | Whiteside | Illinois | 17195 | 9921 | 235 |
2015560 | 2015560 | 2021-12-15 | Will | Illinois | 17197 | 105964 | 1273 |
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);