ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-07-22" 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 |
---|---|---|---|---|---|---|---|
357627 | 357627 | 2020-07-22 | Adams | Illinois | 17001 | 286 | 1 |
357628 | 357628 | 2020-07-22 | Alexander | Illinois | 17003 | 32 | 0 |
357629 | 357629 | 2020-07-22 | Bond | Illinois | 17005 | 29 | 1 |
357630 | 357630 | 2020-07-22 | Boone | Illinois | 17007 | 663 | 21 |
357631 | 357631 | 2020-07-22 | Brown | Illinois | 17009 | 11 | 0 |
357632 | 357632 | 2020-07-22 | Bureau | Illinois | 17011 | 62 | 2 |
357633 | 357633 | 2020-07-22 | Calhoun | Illinois | 17013 | 3 | 0 |
357634 | 357634 | 2020-07-22 | Carroll | Illinois | 17015 | 24 | 2 |
357635 | 357635 | 2020-07-22 | Cass | Illinois | 17017 | 160 | 11 |
357636 | 357636 | 2020-07-22 | Champaign | Illinois | 17019 | 1293 | 17 |
357637 | 357637 | 2020-07-22 | Christian | Illinois | 17021 | 60 | 5 |
357638 | 357638 | 2020-07-22 | Clark | Illinois | 17023 | 50 | 0 |
357639 | 357639 | 2020-07-22 | Clay | Illinois | 17025 | 9 | 0 |
357640 | 357640 | 2020-07-22 | Clinton | Illinois | 17027 | 278 | 17 |
357641 | 357641 | 2020-07-22 | Coles | Illinois | 17029 | 261 | 17 |
357642 | 357642 | 2020-07-22 | Cook | Illinois | 17031 | 100124 | 4801 |
357643 | 357643 | 2020-07-22 | Crawford | Illinois | 17033 | 26 | 0 |
357644 | 357644 | 2020-07-22 | Cumberland | Illinois | 17035 | 36 | 1 |
357645 | 357645 | 2020-07-22 | De Witt | Illinois | 17039 | 24 | 0 |
357646 | 357646 | 2020-07-22 | DeKalb | Illinois | 17037 | 763 | 24 |
357647 | 357647 | 2020-07-22 | Douglas | Illinois | 17041 | 89 | 0 |
357648 | 357648 | 2020-07-22 | DuPage | Illinois | 17043 | 10531 | 500 |
357649 | 357649 | 2020-07-22 | Edgar | Illinois | 17045 | 18 | 0 |
357650 | 357650 | 2020-07-22 | Edwards | Illinois | 17047 | 6 | 0 |
357651 | 357651 | 2020-07-22 | Effingham | Illinois | 17049 | 48 | 1 |
357652 | 357652 | 2020-07-22 | Fayette | Illinois | 17051 | 39 | 3 |
357653 | 357653 | 2020-07-22 | Ford | Illinois | 17053 | 33 | 1 |
357654 | 357654 | 2020-07-22 | Franklin | Illinois | 17055 | 79 | 0 |
357655 | 357655 | 2020-07-22 | Fulton | Illinois | 17057 | 20 | 0 |
357656 | 357656 | 2020-07-22 | Gallatin | Illinois | 17059 | 23 | 0 |
357657 | 357657 | 2020-07-22 | Greene | Illinois | 17061 | 13 | 0 |
357658 | 357658 | 2020-07-22 | Grundy | Illinois | 17063 | 226 | 5 |
357659 | 357659 | 2020-07-22 | Hamilton | Illinois | 17065 | 11 | 0 |
357660 | 357660 | 2020-07-22 | Hancock | Illinois | 17067 | 22 | 1 |
357661 | 357661 | 2020-07-22 | Hardin | Illinois | 17069 | 9 | 0 |
357662 | 357662 | 2020-07-22 | Henderson | Illinois | 17071 | 8 | 0 |
357663 | 357663 | 2020-07-22 | Henry | Illinois | 17073 | 146 | 1 |
357664 | 357664 | 2020-07-22 | Iroquois | Illinois | 17075 | 201 | 5 |
357665 | 357665 | 2020-07-22 | Jackson | Illinois | 17077 | 434 | 19 |
357666 | 357666 | 2020-07-22 | Jasper | Illinois | 17079 | 49 | 7 |
357667 | 357667 | 2020-07-22 | Jefferson | Illinois | 17081 | 138 | 17 |
357668 | 357668 | 2020-07-22 | Jersey | Illinois | 17083 | 56 | 1 |
357669 | 357669 | 2020-07-22 | Jo Daviess | Illinois | 17085 | 80 | 1 |
357670 | 357670 | 2020-07-22 | Johnson | Illinois | 17087 | 42 | 0 |
357671 | 357671 | 2020-07-22 | Kane | Illinois | 17089 | 8548 | 294 |
357672 | 357672 | 2020-07-22 | Kankakee | Illinois | 17091 | 1628 | 66 |
357673 | 357673 | 2020-07-22 | Kendall | Illinois | 17093 | 1210 | 23 |
357674 | 357674 | 2020-07-22 | Knox | Illinois | 17095 | 199 | 1 |
357675 | 357675 | 2020-07-22 | LaSalle | Illinois | 17099 | 362 | 18 |
357676 | 357676 | 2020-07-22 | Lake | Illinois | 17097 | 11079 | 435 |
357677 | 357677 | 2020-07-22 | Lawrence | Illinois | 17101 | 30 | 0 |
357678 | 357678 | 2020-07-22 | Lee | Illinois | 17103 | 120 | 2 |
357679 | 357679 | 2020-07-22 | Livingston | Illinois | 17105 | 63 | 2 |
357680 | 357680 | 2020-07-22 | Logan | Illinois | 17107 | 57 | 0 |
357681 | 357681 | 2020-07-22 | Macon | Illinois | 17115 | 288 | 22 |
357682 | 357682 | 2020-07-22 | Macoupin | Illinois | 17117 | 100 | 3 |
357683 | 357683 | 2020-07-22 | Madison | Illinois | 17119 | 1604 | 71 |
357684 | 357684 | 2020-07-22 | Marion | Illinois | 17121 | 97 | 0 |
357685 | 357685 | 2020-07-22 | Marshall | Illinois | 17123 | 15 | 0 |
357686 | 357686 | 2020-07-22 | Mason | Illinois | 17125 | 36 | 0 |
357687 | 357687 | 2020-07-22 | Massac | Illinois | 17127 | 24 | 0 |
357688 | 357688 | 2020-07-22 | McDonough | Illinois | 17109 | 119 | 15 |
357689 | 357689 | 2020-07-22 | McHenry | Illinois | 17111 | 2608 | 110 |
357690 | 357690 | 2020-07-22 | McLean | Illinois | 17113 | 418 | 15 |
357691 | 357691 | 2020-07-22 | Menard | Illinois | 17129 | 36 | 0 |
357692 | 357692 | 2020-07-22 | Mercer | Illinois | 17131 | 39 | 0 |
357693 | 357693 | 2020-07-22 | Monroe | Illinois | 17133 | 205 | 13 |
357694 | 357694 | 2020-07-22 | Montgomery | Illinois | 17135 | 112 | 2 |
357695 | 357695 | 2020-07-22 | Morgan | Illinois | 17137 | 146 | 5 |
357696 | 357696 | 2020-07-22 | Moultrie | Illinois | 17139 | 33 | 0 |
357697 | 357697 | 2020-07-22 | Ogle | Illinois | 17141 | 357 | 5 |
357698 | 357698 | 2020-07-22 | Peoria | Illinois | 17143 | 884 | 32 |
357699 | 357699 | 2020-07-22 | Perry | Illinois | 17145 | 73 | 1 |
357700 | 357700 | 2020-07-22 | Piatt | Illinois | 17147 | 30 | 0 |
357701 | 357701 | 2020-07-22 | Pike | Illinois | 17149 | 9 | 0 |
357702 | 357702 | 2020-07-22 | Pope | Illinois | 17151 | 2 | 0 |
357703 | 357703 | 2020-07-22 | Pulaski | Illinois | 17153 | 88 | 0 |
357704 | 357704 | 2020-07-22 | Putnam | Illinois | 17155 | 3 | 0 |
357705 | 357705 | 2020-07-22 | Randolph | Illinois | 17157 | 374 | 7 |
357706 | 357706 | 2020-07-22 | Richland | Illinois | 17159 | 9 | 0 |
357707 | 357707 | 2020-07-22 | Rock Island | Illinois | 17161 | 1397 | 30 |
357708 | 357708 | 2020-07-22 | Saline | Illinois | 17165 | 60 | 0 |
357709 | 357709 | 2020-07-22 | Sangamon | Illinois | 17167 | 740 | 34 |
357710 | 357710 | 2020-07-22 | Schuyler | Illinois | 17169 | 14 | 0 |
357711 | 357711 | 2020-07-22 | Scott | Illinois | 17171 | 4 | 0 |
357712 | 357712 | 2020-07-22 | Shelby | Illinois | 17173 | 31 | 1 |
357713 | 357713 | 2020-07-22 | St. Clair | Illinois | 17163 | 3210 | 152 |
357714 | 357714 | 2020-07-22 | Stark | Illinois | 17175 | 7 | 0 |
357715 | 357715 | 2020-07-22 | Stephenson | Illinois | 17177 | 292 | 6 |
357716 | 357716 | 2020-07-22 | Tazewell | Illinois | 17179 | 243 | 8 |
357717 | 357717 | 2020-07-22 | Union | Illinois | 17181 | 255 | 21 |
357718 | 357718 | 2020-07-22 | Unknown | Illinois | 1175 | 193 | |
357719 | 357719 | 2020-07-22 | Vermilion | Illinois | 17183 | 141 | 2 |
357720 | 357720 | 2020-07-22 | Wabash | Illinois | 17185 | 25 | 0 |
357721 | 357721 | 2020-07-22 | Warren | Illinois | 17187 | 158 | 0 |
357722 | 357722 | 2020-07-22 | Washington | Illinois | 17189 | 35 | 0 |
357723 | 357723 | 2020-07-22 | Wayne | Illinois | 17191 | 27 | 1 |
357724 | 357724 | 2020-07-22 | White | Illinois | 17193 | 33 | 0 |
357725 | 357725 | 2020-07-22 | Whiteside | Illinois | 17195 | 250 | 16 |
357726 | 357726 | 2020-07-22 | Will | Illinois | 17197 | 7845 | 336 |
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);