ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where date = "2021-01-18" 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 |
---|---|---|---|---|---|---|---|
940509 | 940509 | 2021-01-18 | Adams | Illinois | 17001 | 7370 | 117 |
940510 | 940510 | 2021-01-18 | Alexander | Illinois | 17003 | 389 | 7 |
940511 | 940511 | 2021-01-18 | Bond | Illinois | 17005 | 1735 | 24 |
940512 | 940512 | 2021-01-18 | Boone | Illinois | 17007 | 5532 | 77 |
940513 | 940513 | 2021-01-18 | Brown | Illinois | 17009 | 608 | 11 |
940514 | 940514 | 2021-01-18 | Bureau | Illinois | 17011 | 2997 | 84 |
940515 | 940515 | 2021-01-18 | Calhoun | Illinois | 17013 | 438 | 4 |
940516 | 940516 | 2021-01-18 | Carroll | Illinois | 17015 | 1426 | 33 |
940517 | 940517 | 2021-01-18 | Cass | Illinois | 17017 | 1748 | 31 |
940518 | 940518 | 2021-01-18 | Champaign | Illinois | 17019 | 15428 | 99 |
940519 | 940519 | 2021-01-18 | Christian | Illinois | 17021 | 2979 | 74 |
940520 | 940520 | 2021-01-18 | Clark | Illinois | 17023 | 1474 | 30 |
940521 | 940521 | 2021-01-18 | Clay | Illinois | 17025 | 1309 | 39 |
940522 | 940522 | 2021-01-18 | Clinton | Illinois | 17027 | 5006 | 85 |
940523 | 940523 | 2021-01-18 | Coles | Illinois | 17029 | 4698 | 80 |
940524 | 940524 | 2021-01-18 | Cook | Illinois | 17031 | 434341 | 9046 |
940525 | 940525 | 2021-01-18 | Crawford | Illinois | 17033 | 1755 | 34 |
940526 | 940526 | 2021-01-18 | Cumberland | Illinois | 17035 | 1079 | 27 |
940527 | 940527 | 2021-01-18 | De Witt | Illinois | 17039 | 1139 | 27 |
940528 | 940528 | 2021-01-18 | DeKalb | Illinois | 17037 | 7469 | 92 |
940529 | 940529 | 2021-01-18 | Douglas | Illinois | 17041 | 1987 | 33 |
940530 | 940530 | 2021-01-18 | DuPage | Illinois | 17043 | 68970 | 1151 |
940531 | 940531 | 2021-01-18 | Edgar | Illinois | 17045 | 1432 | 53 |
940532 | 940532 | 2021-01-18 | Edwards | Illinois | 17047 | 460 | 9 |
940533 | 940533 | 2021-01-18 | Effingham | Illinois | 17049 | 4306 | 68 |
940534 | 940534 | 2021-01-18 | Fayette | Illinois | 17051 | 2906 | 53 |
940535 | 940535 | 2021-01-18 | Ford | Illinois | 17053 | 1380 | 49 |
940536 | 940536 | 2021-01-18 | Franklin | Illinois | 17055 | 3829 | 69 |
940537 | 940537 | 2021-01-18 | Fulton | Illinois | 17057 | 2553 | 49 |
940538 | 940538 | 2021-01-18 | Gallatin | Illinois | 17059 | 386 | 4 |
940539 | 940539 | 2021-01-18 | Greene | Illinois | 17061 | 1254 | 42 |
940540 | 940540 | 2021-01-18 | Grundy | Illinois | 17063 | 4359 | 54 |
940541 | 940541 | 2021-01-18 | Hamilton | Illinois | 17065 | 716 | 17 |
940542 | 940542 | 2021-01-18 | Hancock | Illinois | 17067 | 1476 | 34 |
940543 | 940543 | 2021-01-18 | Hardin | Illinois | 17069 | 302 | 8 |
940544 | 940544 | 2021-01-18 | Henderson | Illinois | 17071 | 452 | 16 |
940545 | 940545 | 2021-01-18 | Henry | Illinois | 17073 | 4007 | 76 |
940546 | 940546 | 2021-01-18 | Iroquois | Illinois | 17075 | 2587 | 56 |
940547 | 940547 | 2021-01-18 | Jackson | Illinois | 17077 | 4168 | 67 |
940548 | 940548 | 2021-01-18 | Jasper | Illinois | 17079 | 1038 | 15 |
940549 | 940549 | 2021-01-18 | Jefferson | Illinois | 17081 | 3421 | 104 |
940550 | 940550 | 2021-01-18 | Jersey | Illinois | 17083 | 2206 | 56 |
940551 | 940551 | 2021-01-18 | Jo Daviess | Illinois | 17085 | 1482 | 24 |
940552 | 940552 | 2021-01-18 | Johnson | Illinois | 17087 | 1210 | 15 |
940553 | 940553 | 2021-01-18 | Kane | Illinois | 17089 | 45873 | 676 |
940554 | 940554 | 2021-01-18 | Kankakee | Illinois | 17091 | 11465 | 179 |
940555 | 940555 | 2021-01-18 | Kendall | Illinois | 17093 | 9782 | 78 |
940556 | 940556 | 2021-01-18 | Knox | Illinois | 17095 | 4579 | 141 |
940557 | 940557 | 2021-01-18 | LaSalle | Illinois | 17099 | 9427 | 247 |
940558 | 940558 | 2021-01-18 | Lake | Illinois | 17097 | 53227 | 886 |
940559 | 940559 | 2021-01-18 | Lawrence | Illinois | 17101 | 2172 | 30 |
940560 | 940560 | 2021-01-18 | Lee | Illinois | 17103 | 3031 | 72 |
940561 | 940561 | 2021-01-18 | Livingston | Illinois | 17105 | 3635 | 66 |
940562 | 940562 | 2021-01-18 | Logan | Illinois | 17107 | 3083 | 56 |
940563 | 940563 | 2021-01-18 | Macon | Illinois | 17115 | 8794 | 179 |
940564 | 940564 | 2021-01-18 | Macoupin | Illinois | 17117 | 3826 | 94 |
940565 | 940565 | 2021-01-18 | Madison | Illinois | 17119 | 24262 | 463 |
940566 | 940566 | 2021-01-18 | Marion | Illinois | 17121 | 3970 | 111 |
940567 | 940567 | 2021-01-18 | Marshall | Illinois | 17123 | 664 | 13 |
940568 | 940568 | 2021-01-18 | Mason | Illinois | 17125 | 1163 | 40 |
940569 | 940569 | 2021-01-18 | Massac | Illinois | 17127 | 1018 | 31 |
940570 | 940570 | 2021-01-18 | McDonough | Illinois | 17109 | 2144 | 51 |
940571 | 940571 | 2021-01-18 | McHenry | Illinois | 17111 | 21591 | 248 |
940572 | 940572 | 2021-01-18 | McLean | Illinois | 17113 | 13170 | 159 |
940573 | 940573 | 2021-01-18 | Menard | Illinois | 17129 | 871 | 10 |
940574 | 940574 | 2021-01-18 | Mercer | Illinois | 17131 | 1170 | 29 |
940575 | 940575 | 2021-01-18 | Monroe | Illinois | 17133 | 3561 | 70 |
940576 | 940576 | 2021-01-18 | Montgomery | Illinois | 17135 | 3038 | 40 |
940577 | 940577 | 2021-01-18 | Morgan | Illinois | 17137 | 3306 | 90 |
940578 | 940578 | 2021-01-18 | Moultrie | Illinois | 17139 | 1370 | 28 |
940579 | 940579 | 2021-01-18 | Ogle | Illinois | 17141 | 4589 | 71 |
940580 | 940580 | 2021-01-18 | Peoria | Illinois | 17143 | 14966 | 239 |
940581 | 940581 | 2021-01-18 | Perry | Illinois | 17145 | 2665 | 60 |
940582 | 940582 | 2021-01-18 | Piatt | Illinois | 17147 | 1168 | 16 |
940583 | 940583 | 2021-01-18 | Pike | Illinois | 17149 | 1542 | 46 |
940584 | 940584 | 2021-01-18 | Pope | Illinois | 17151 | 246 | 2 |
940585 | 940585 | 2021-01-18 | Pulaski | Illinois | 17153 | 610 | 3 |
940586 | 940586 | 2021-01-18 | Putnam | Illinois | 17155 | 346 | 2 |
940587 | 940587 | 2021-01-18 | Randolph | Illinois | 17157 | 3714 | 68 |
940588 | 940588 | 2021-01-18 | Richland | Illinois | 17159 | 1535 | 44 |
940589 | 940589 | 2021-01-18 | Rock Island | Illinois | 17161 | 11860 | 302 |
940590 | 940590 | 2021-01-18 | Saline | Illinois | 17165 | 2021 | 53 |
940591 | 940591 | 2021-01-18 | Sangamon | Illinois | 17167 | 14477 | 234 |
940592 | 940592 | 2021-01-18 | Schuyler | Illinois | 17169 | 619 | 16 |
940593 | 940593 | 2021-01-18 | Scott | Illinois | 17171 | 375 | 1 |
940594 | 940594 | 2021-01-18 | Shelby | Illinois | 17173 | 1964 | 35 |
940595 | 940595 | 2021-01-18 | St. Clair | Illinois | 17163 | 24431 | 426 |
940596 | 940596 | 2021-01-18 | Stark | Illinois | 17175 | 493 | 20 |
940597 | 940597 | 2021-01-18 | Stephenson | Illinois | 17177 | 3524 | 74 |
940598 | 940598 | 2021-01-18 | Tazewell | Illinois | 17179 | 11885 | 245 |
940599 | 940599 | 2021-01-18 | Union | Illinois | 17181 | 1973 | 32 |
940600 | 940600 | 2021-01-18 | Vermilion | Illinois | 17183 | 7470 | 112 |
940601 | 940601 | 2021-01-18 | Wabash | Illinois | 17185 | 1172 | 14 |
940602 | 940602 | 2021-01-18 | Warren | Illinois | 17187 | 1582 | 44 |
940603 | 940603 | 2021-01-18 | Washington | Illinois | 17189 | 1446 | 25 |
940604 | 940604 | 2021-01-18 | Wayne | Illinois | 17191 | 1511 | 43 |
940605 | 940605 | 2021-01-18 | White | Illinois | 17193 | 1331 | 30 |
940606 | 940606 | 2021-01-18 | Whiteside | Illinois | 17195 | 5354 | 173 |
940607 | 940607 | 2021-01-18 | Will | Illinois | 17197 | 58209 | 870 |
940608 | 940608 | 2021-01-18 | Williamson | Illinois | 17199 | 6166 | 116 |
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);