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 2020-07-24 and state = "Illinois" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
364114 | 364114 | 2020-07-24 | Pope | Illinois | 17151 | 3 | 0 |
364045 | 364045 | 2020-07-24 | Calhoun | Illinois | 17013 | 5 | 0 |
364123 | 364123 | 2020-07-24 | Scott | Illinois | 17171 | 5 | 0 |
364062 | 364062 | 2020-07-24 | Edwards | Illinois | 17047 | 6 | 0 |
364116 | 364116 | 2020-07-24 | Putnam | Illinois | 17155 | 6 | 0 |
364126 | 364126 | 2020-07-24 | Stark | Illinois | 17175 | 6 | 0 |
364074 | 364074 | 2020-07-24 | Henderson | Illinois | 17071 | 8 | 0 |
364051 | 364051 | 2020-07-24 | Clay | Illinois | 17025 | 9 | 0 |
364073 | 364073 | 2020-07-24 | Hardin | Illinois | 17069 | 9 | 0 |
364113 | 364113 | 2020-07-24 | Pike | Illinois | 17149 | 9 | 0 |
364118 | 364118 | 2020-07-24 | Richland | Illinois | 17159 | 10 | 0 |
364071 | 364071 | 2020-07-24 | Hamilton | Illinois | 17065 | 11 | 0 |
364043 | 364043 | 2020-07-24 | Brown | Illinois | 17009 | 12 | 0 |
364069 | 364069 | 2020-07-24 | Greene | Illinois | 17061 | 14 | 0 |
364122 | 364122 | 2020-07-24 | Schuyler | Illinois | 17169 | 14 | 0 |
364097 | 364097 | 2020-07-24 | Marshall | Illinois | 17123 | 16 | 0 |
364067 | 364067 | 2020-07-24 | Fulton | Illinois | 17057 | 21 | 0 |
364057 | 364057 | 2020-07-24 | De Witt | Illinois | 17039 | 24 | 0 |
364061 | 364061 | 2020-07-24 | Edgar | Illinois | 17045 | 24 | 0 |
364072 | 364072 | 2020-07-24 | Hancock | Illinois | 17067 | 25 | 1 |
364132 | 364132 | 2020-07-24 | Wabash | Illinois | 17185 | 25 | 0 |
364099 | 364099 | 2020-07-24 | Massac | Illinois | 17127 | 26 | 0 |
364135 | 364135 | 2020-07-24 | Wayne | Illinois | 17191 | 27 | 1 |
364055 | 364055 | 2020-07-24 | Crawford | Illinois | 17033 | 28 | 0 |
364046 | 364046 | 2020-07-24 | Carroll | Illinois | 17015 | 29 | 2 |
364068 | 364068 | 2020-07-24 | Gallatin | Illinois | 17059 | 31 | 0 |
364112 | 364112 | 2020-07-24 | Piatt | Illinois | 17147 | 31 | 0 |
364089 | 364089 | 2020-07-24 | Lawrence | Illinois | 17101 | 32 | 0 |
364041 | 364041 | 2020-07-24 | Bond | Illinois | 17005 | 33 | 1 |
364040 | 364040 | 2020-07-24 | Alexander | Illinois | 17003 | 34 | 0 |
364124 | 364124 | 2020-07-24 | Shelby | Illinois | 17173 | 34 | 1 |
364065 | 364065 | 2020-07-24 | Ford | Illinois | 17053 | 36 | 1 |
364098 | 364098 | 2020-07-24 | Mason | Illinois | 17125 | 36 | 0 |
364103 | 364103 | 2020-07-24 | Menard | Illinois | 17129 | 37 | 0 |
364136 | 364136 | 2020-07-24 | White | Illinois | 17193 | 38 | 0 |
364056 | 364056 | 2020-07-24 | Cumberland | Illinois | 17035 | 40 | 1 |
364064 | 364064 | 2020-07-24 | Fayette | Illinois | 17051 | 41 | 3 |
364134 | 364134 | 2020-07-24 | Washington | Illinois | 17189 | 41 | 0 |
364104 | 364104 | 2020-07-24 | Mercer | Illinois | 17131 | 42 | 0 |
364108 | 364108 | 2020-07-24 | Moultrie | Illinois | 17139 | 43 | 0 |
364082 | 364082 | 2020-07-24 | Johnson | Illinois | 17087 | 48 | 0 |
364078 | 364078 | 2020-07-24 | Jasper | Illinois | 17079 | 49 | 7 |
364050 | 364050 | 2020-07-24 | Clark | Illinois | 17023 | 52 | 0 |
364080 | 364080 | 2020-07-24 | Jersey | Illinois | 17083 | 58 | 1 |
364063 | 364063 | 2020-07-24 | Effingham | Illinois | 17049 | 59 | 1 |
364092 | 364092 | 2020-07-24 | Logan | Illinois | 17107 | 64 | 0 |
364091 | 364091 | 2020-07-24 | Livingston | Illinois | 17105 | 66 | 2 |
364141 | 364141 | 2020-07-24 | Woodford | Illinois | 17203 | 68 | 3 |
364044 | 364044 | 2020-07-24 | Bureau | Illinois | 17011 | 69 | 2 |
364120 | 364120 | 2020-07-24 | Saline | Illinois | 17165 | 73 | 0 |
364049 | 364049 | 2020-07-24 | Christian | Illinois | 17021 | 75 | 5 |
364111 | 364111 | 2020-07-24 | Perry | Illinois | 17145 | 83 | 1 |
364081 | 364081 | 2020-07-24 | Jo Daviess | Illinois | 17085 | 88 | 1 |
364115 | 364115 | 2020-07-24 | Pulaski | Illinois | 17153 | 88 | 0 |
364066 | 364066 | 2020-07-24 | Franklin | Illinois | 17055 | 90 | 0 |
364059 | 364059 | 2020-07-24 | Douglas | Illinois | 17041 | 92 | 1 |
364094 | 364094 | 2020-07-24 | Macoupin | Illinois | 17117 | 101 | 3 |
364096 | 364096 | 2020-07-24 | Marion | Illinois | 17121 | 110 | 0 |
364106 | 364106 | 2020-07-24 | Montgomery | Illinois | 17135 | 118 | 2 |
364100 | 364100 | 2020-07-24 | McDonough | Illinois | 17109 | 119 | 15 |
364090 | 364090 | 2020-07-24 | Lee | Illinois | 17103 | 121 | 2 |
364079 | 364079 | 2020-07-24 | Jefferson | Illinois | 17081 | 151 | 17 |
364107 | 364107 | 2020-07-24 | Morgan | Illinois | 17137 | 151 | 5 |
364075 | 364075 | 2020-07-24 | Henry | Illinois | 17073 | 155 | 1 |
364133 | 364133 | 2020-07-24 | Warren | Illinois | 17187 | 162 | 0 |
364047 | 364047 | 2020-07-24 | Cass | Illinois | 17017 | 163 | 11 |
364131 | 364131 | 2020-07-24 | Vermilion | Illinois | 17183 | 164 | 2 |
364076 | 364076 | 2020-07-24 | Iroquois | Illinois | 17075 | 205 | 5 |
364086 | 364086 | 2020-07-24 | Knox | Illinois | 17095 | 211 | 1 |
364105 | 364105 | 2020-07-24 | Monroe | Illinois | 17133 | 213 | 13 |
364070 | 364070 | 2020-07-24 | Grundy | Illinois | 17063 | 233 | 5 |
364139 | 364139 | 2020-07-24 | Williamson | Illinois | 17199 | 240 | 4 |
364128 | 364128 | 2020-07-24 | Tazewell | Illinois | 17179 | 260 | 8 |
364129 | 364129 | 2020-07-24 | Union | Illinois | 17181 | 262 | 21 |
364137 | 364137 | 2020-07-24 | Whiteside | Illinois | 17195 | 274 | 16 |
364053 | 364053 | 2020-07-24 | Coles | Illinois | 17029 | 286 | 17 |
364052 | 364052 | 2020-07-24 | Clinton | Illinois | 17027 | 292 | 17 |
364127 | 364127 | 2020-07-24 | Stephenson | Illinois | 17177 | 299 | 6 |
364093 | 364093 | 2020-07-24 | Macon | Illinois | 17115 | 311 | 22 |
364039 | 364039 | 2020-07-24 | Adams | Illinois | 17001 | 316 | 1 |
364109 | 364109 | 2020-07-24 | Ogle | Illinois | 17141 | 362 | 5 |
364087 | 364087 | 2020-07-24 | LaSalle | Illinois | 17099 | 388 | 18 |
364117 | 364117 | 2020-07-24 | Randolph | Illinois | 17157 | 392 | 7 |
364102 | 364102 | 2020-07-24 | McLean | Illinois | 17113 | 442 | 15 |
364077 | 364077 | 2020-07-24 | Jackson | Illinois | 17077 | 463 | 19 |
364042 | 364042 | 2020-07-24 | Boone | Illinois | 17007 | 677 | 22 |
364121 | 364121 | 2020-07-24 | Sangamon | Illinois | 17167 | 783 | 34 |
364058 | 364058 | 2020-07-24 | DeKalb | Illinois | 17037 | 787 | 24 |
364110 | 364110 | 2020-07-24 | Peoria | Illinois | 17143 | 951 | 32 |
364130 | 364130 | 2020-07-24 | Unknown | Illinois | 1209 | 192 | |
364085 | 364085 | 2020-07-24 | Kendall | Illinois | 17093 | 1235 | 23 |
364048 | 364048 | 2020-07-24 | Champaign | Illinois | 17019 | 1350 | 17 |
364119 | 364119 | 2020-07-24 | Rock Island | Illinois | 17161 | 1451 | 30 |
364084 | 364084 | 2020-07-24 | Kankakee | Illinois | 17091 | 1654 | 66 |
364095 | 364095 | 2020-07-24 | Madison | Illinois | 17119 | 1701 | 71 |
364101 | 364101 | 2020-07-24 | McHenry | Illinois | 17111 | 2681 | 111 |
364125 | 364125 | 2020-07-24 | St. Clair | Illinois | 17163 | 3357 | 152 |
364140 | 364140 | 2020-07-24 | Winnebago | Illinois | 17201 | 3457 | 115 |
364138 | 364138 | 2020-07-24 | Will | Illinois | 17197 | 7997 | 338 |
364083 | 364083 | 2020-07-24 | Kane | Illinois | 17089 | 8694 | 294 |
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);