ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-05-27" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
182114 | 182114 | 2020-05-27 | Adams | Illinois | 17001 | 44 | 1 |
182115 | 182115 | 2020-05-27 | Alexander | Illinois | 17003 | 8 | 0 |
182116 | 182116 | 2020-05-27 | Bond | Illinois | 17005 | 10 | 1 |
182117 | 182117 | 2020-05-27 | Boone | Illinois | 17007 | 410 | 16 |
182118 | 182118 | 2020-05-27 | Brown | Illinois | 17009 | 10 | 0 |
182119 | 182119 | 2020-05-27 | Bureau | Illinois | 17011 | 15 | 1 |
182120 | 182120 | 2020-05-27 | Calhoun | Illinois | 17013 | 1 | 0 |
182121 | 182121 | 2020-05-27 | Carroll | Illinois | 17015 | 14 | 2 |
182122 | 182122 | 2020-05-27 | Cass | Illinois | 17017 | 68 | 0 |
182123 | 182123 | 2020-05-27 | Champaign | Illinois | 17019 | 583 | 7 |
182124 | 182124 | 2020-05-27 | Christian | Illinois | 17021 | 33 | 5 |
182125 | 182125 | 2020-05-27 | Clark | Illinois | 17023 | 10 | 0 |
182126 | 182126 | 2020-05-27 | Clay | Illinois | 17025 | 2 | 0 |
182127 | 182127 | 2020-05-27 | Clinton | Illinois | 17027 | 178 | 17 |
182128 | 182128 | 2020-05-27 | Coles | Illinois | 17029 | 119 | 12 |
182129 | 182129 | 2020-05-27 | Cook | Illinois | 17031 | 74521 | 3455 |
182130 | 182130 | 2020-05-27 | Crawford | Illinois | 17033 | 11 | 0 |
182131 | 182131 | 2020-05-27 | Cumberland | Illinois | 17035 | 10 | 0 |
182132 | 182132 | 2020-05-27 | De Witt | Illinois | 17039 | 4 | 0 |
182133 | 182133 | 2020-05-27 | DeKalb | Illinois | 17037 | 352 | 3 |
182134 | 182134 | 2020-05-27 | Douglas | Illinois | 17041 | 26 | 0 |
182135 | 182135 | 2020-05-27 | DuPage | Illinois | 17043 | 7369 | 347 |
182136 | 182136 | 2020-05-27 | Edwards | Illinois | 17047 | 2 | 0 |
182137 | 182137 | 2020-05-27 | Effingham | Illinois | 17049 | 6 | 1 |
182138 | 182138 | 2020-05-27 | Fayette | Illinois | 17051 | 20 | 3 |
182139 | 182139 | 2020-05-27 | Ford | Illinois | 17053 | 20 | 1 |
182140 | 182140 | 2020-05-27 | Franklin | Illinois | 17055 | 12 | 0 |
182141 | 182141 | 2020-05-27 | Fulton | Illinois | 17057 | 11 | 0 |
182142 | 182142 | 2020-05-27 | Gallatin | Illinois | 17059 | 2 | 0 |
182143 | 182143 | 2020-05-27 | Greene | Illinois | 17061 | 5 | 0 |
182144 | 182144 | 2020-05-27 | Grundy | Illinois | 17063 | 88 | 2 |
182145 | 182145 | 2020-05-27 | Hamilton | Illinois | 17065 | 2 | 0 |
182146 | 182146 | 2020-05-27 | Hancock | Illinois | 17067 | 15 | 0 |
182147 | 182147 | 2020-05-27 | Hardin | Illinois | 17069 | 1 | 0 |
182148 | 182148 | 2020-05-27 | Henderson | Illinois | 17071 | 8 | 0 |
182149 | 182149 | 2020-05-27 | Henry | Illinois | 17073 | 67 | 0 |
182150 | 182150 | 2020-05-27 | Iroquois | Illinois | 17075 | 131 | 4 |
182151 | 182151 | 2020-05-27 | Jackson | Illinois | 17077 | 242 | 10 |
182152 | 182152 | 2020-05-27 | Jasper | Illinois | 17079 | 45 | 7 |
182153 | 182153 | 2020-05-27 | Jefferson | Illinois | 17081 | 101 | 16 |
182154 | 182154 | 2020-05-27 | Jersey | Illinois | 17083 | 20 | 1 |
182155 | 182155 | 2020-05-27 | Jo Daviess | Illinois | 17085 | 31 | 0 |
182156 | 182156 | 2020-05-27 | Johnson | Illinois | 17087 | 7 | 0 |
182157 | 182157 | 2020-05-27 | Kane | Illinois | 17089 | 6000 | 163 |
182158 | 182158 | 2020-05-27 | Kankakee | Illinois | 17091 | 1124 | 53 |
182159 | 182159 | 2020-05-27 | Kendall | Illinois | 17093 | 769 | 22 |
182160 | 182160 | 2020-05-27 | Knox | Illinois | 17095 | 94 | 0 |
182161 | 182161 | 2020-05-27 | LaSalle | Illinois | 17099 | 140 | 13 |
182162 | 182162 | 2020-05-27 | Lake | Illinois | 17097 | 7845 | 270 |
182163 | 182163 | 2020-05-27 | Lawrence | Illinois | 17101 | 4 | 0 |
182164 | 182164 | 2020-05-27 | Lee | Illinois | 17103 | 76 | 1 |
182165 | 182165 | 2020-05-27 | Livingston | Illinois | 17105 | 31 | 2 |
182166 | 182166 | 2020-05-27 | Logan | Illinois | 17107 | 10 | 0 |
182167 | 182167 | 2020-05-27 | Macon | Illinois | 17115 | 189 | 19 |
182168 | 182168 | 2020-05-27 | Macoupin | Illinois | 17117 | 43 | 1 |
182169 | 182169 | 2020-05-27 | Madison | Illinois | 17119 | 551 | 58 |
182170 | 182170 | 2020-05-27 | Marion | Illinois | 17121 | 50 | 0 |
182171 | 182171 | 2020-05-27 | Marshall | Illinois | 17123 | 5 | 0 |
182172 | 182172 | 2020-05-27 | Mason | Illinois | 17125 | 17 | 0 |
182173 | 182173 | 2020-05-27 | Massac | Illinois | 17127 | 7 | 0 |
182174 | 182174 | 2020-05-27 | McDonough | Illinois | 17109 | 83 | 7 |
182175 | 182175 | 2020-05-27 | McHenry | Illinois | 17111 | 1475 | 69 |
182176 | 182176 | 2020-05-27 | McLean | Illinois | 17113 | 215 | 13 |
182177 | 182177 | 2020-05-27 | Menard | Illinois | 17129 | 17 | 0 |
182178 | 182178 | 2020-05-27 | Mercer | Illinois | 17131 | 16 | 0 |
182179 | 182179 | 2020-05-27 | Monroe | Illinois | 17133 | 93 | 11 |
182180 | 182180 | 2020-05-27 | Montgomery | Illinois | 17135 | 39 | 0 |
182181 | 182181 | 2020-05-27 | Morgan | Illinois | 17137 | 34 | 1 |
182182 | 182182 | 2020-05-27 | Moultrie | Illinois | 17139 | 10 | 0 |
182183 | 182183 | 2020-05-27 | Ogle | Illinois | 17141 | 204 | 3 |
182184 | 182184 | 2020-05-27 | Peoria | Illinois | 17143 | 189 | 8 |
182185 | 182185 | 2020-05-27 | Perry | Illinois | 17145 | 41 | 0 |
182186 | 182186 | 2020-05-27 | Piatt | Illinois | 17147 | 12 | 0 |
182187 | 182187 | 2020-05-27 | Pike | Illinois | 17149 | 1 | 0 |
182188 | 182188 | 2020-05-27 | Pope | Illinois | 17151 | 1 | 0 |
182189 | 182189 | 2020-05-27 | Pulaski | Illinois | 17153 | 41 | 0 |
182190 | 182190 | 2020-05-27 | Putnam | Illinois | 17155 | 1 | 0 |
182191 | 182191 | 2020-05-27 | Randolph | Illinois | 17157 | 264 | 4 |
182192 | 182192 | 2020-05-27 | Richland | Illinois | 17159 | 3 | 0 |
182193 | 182193 | 2020-05-27 | Rock Island | Illinois | 17161 | 686 | 26 |
182194 | 182194 | 2020-05-27 | Saline | Illinois | 17165 | 7 | 0 |
182195 | 182195 | 2020-05-27 | Sangamon | Illinois | 17167 | 343 | 30 |
182196 | 182196 | 2020-05-27 | Schuyler | Illinois | 17169 | 12 | 0 |
182197 | 182197 | 2020-05-27 | Shelby | Illinois | 17173 | 16 | 1 |
182198 | 182198 | 2020-05-27 | St. Clair | Illinois | 17163 | 1117 | 83 |
182199 | 182199 | 2020-05-27 | Stark | Illinois | 17175 | 3 | 0 |
182200 | 182200 | 2020-05-27 | Stephenson | Illinois | 17177 | 194 | 2 |
182201 | 182201 | 2020-05-27 | Tazewell | Illinois | 17179 | 69 | 4 |
182202 | 182202 | 2020-05-27 | Union | Illinois | 17181 | 143 | 7 |
182203 | 182203 | 2020-05-27 | Vermilion | Illinois | 17183 | 37 | 1 |
182204 | 182204 | 2020-05-27 | Wabash | Illinois | 17185 | 2 | 0 |
182205 | 182205 | 2020-05-27 | Warren | Illinois | 17187 | 113 | 0 |
182206 | 182206 | 2020-05-27 | Washington | Illinois | 17189 | 18 | 0 |
182207 | 182207 | 2020-05-27 | Wayne | Illinois | 17191 | 9 | 1 |
182208 | 182208 | 2020-05-27 | White | Illinois | 17193 | 2 | 0 |
182209 | 182209 | 2020-05-27 | Whiteside | Illinois | 17195 | 135 | 11 |
182210 | 182210 | 2020-05-27 | Will | Illinois | 17197 | 5301 | 264 |
182211 | 182211 | 2020-05-27 | Williamson | Illinois | 17199 | 57 | 2 |
182212 | 182212 | 2020-05-27 | Winnebago | Illinois | 17201 | 2001 | 54 |
182213 | 182213 | 2020-05-27 | Woodford | Illinois | 17203 | 19 | 2 |
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);