ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-05-10" 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 |
---|---|---|---|---|---|---|---|
1304116 | 1304116 | 2021-05-10 | Adams | Illinois | 17001 | 8409 | 152 |
1304117 | 1304117 | 2021-05-10 | Alexander | Illinois | 17003 | 467 | 11 |
1304118 | 1304118 | 2021-05-10 | Bond | Illinois | 17005 | 2039 | 30 |
1304119 | 1304119 | 2021-05-10 | Boone | Illinois | 17007 | 6673 | 84 |
1304120 | 1304120 | 2021-05-10 | Brown | Illinois | 17009 | 703 | 12 |
1304121 | 1304121 | 2021-05-10 | Bureau | Illinois | 17011 | 3700 | 95 |
1304122 | 1304122 | 2021-05-10 | Calhoun | Illinois | 17013 | 516 | 5 |
1304123 | 1304123 | 2021-05-10 | Carroll | Illinois | 17015 | 1745 | 37 |
1304124 | 1304124 | 2021-05-10 | Cass | Illinois | 17017 | 1984 | 34 |
1304125 | 1304125 | 2021-05-10 | Champaign | Illinois | 17019 | 20540 | 153 |
1304126 | 1304126 | 2021-05-10 | Christian | Illinois | 17021 | 3646 | 91 |
1304127 | 1304127 | 2021-05-10 | Clark | Illinois | 17023 | 1786 | 41 |
1304128 | 1304128 | 2021-05-10 | Clay | Illinois | 17025 | 1480 | 48 |
1304129 | 1304129 | 2021-05-10 | Clinton | Illinois | 17027 | 5751 | 99 |
1304130 | 1304130 | 2021-05-10 | Coles | Illinois | 17029 | 5668 | 96 |
1304131 | 1304131 | 2021-05-10 | Cook | Illinois | 17031 | 543111 | 10618 |
1304132 | 1304132 | 2021-05-10 | Crawford | Illinois | 17033 | 2114 | 42 |
1304133 | 1304133 | 2021-05-10 | Cumberland | Illinois | 17035 | 1291 | 31 |
1304134 | 1304134 | 2021-05-10 | De Witt | Illinois | 17039 | 1502 | 31 |
1304135 | 1304135 | 2021-05-10 | DeKalb | Illinois | 17037 | 10046 | 124 |
1304136 | 1304136 | 2021-05-10 | Douglas | Illinois | 17041 | 2583 | 41 |
1304137 | 1304137 | 2021-05-10 | DuPage | Illinois | 17043 | 90140 | 1361 |
1304138 | 1304138 | 2021-05-10 | Edgar | Illinois | 17045 | 1686 | 59 |
1304139 | 1304139 | 2021-05-10 | Edwards | Illinois | 17047 | 568 | 13 |
1304140 | 1304140 | 2021-05-10 | Effingham | Illinois | 17049 | 4726 | 83 |
1304141 | 1304141 | 2021-05-10 | Fayette | Illinois | 17051 | 3168 | 58 |
1304142 | 1304142 | 2021-05-10 | Ford | Illinois | 17053 | 1775 | 54 |
1304143 | 1304143 | 2021-05-10 | Franklin | Illinois | 17055 | 4439 | 86 |
1304144 | 1304144 | 2021-05-10 | Fulton | Illinois | 17057 | 3896 | 63 |
1304145 | 1304145 | 2021-05-10 | Gallatin | Illinois | 17059 | 458 | 5 |
1304146 | 1304146 | 2021-05-10 | Greene | Illinois | 17061 | 1433 | 46 |
1304147 | 1304147 | 2021-05-10 | Grundy | Illinois | 17063 | 5858 | 79 |
1304148 | 1304148 | 2021-05-10 | Hamilton | Illinois | 17065 | 831 | 18 |
1304149 | 1304149 | 2021-05-10 | Hancock | Illinois | 17067 | 1753 | 41 |
1304150 | 1304150 | 2021-05-10 | Hardin | Illinois | 17069 | 384 | 12 |
1304151 | 1304151 | 2021-05-10 | Henderson | Illinois | 17071 | 525 | 23 |
1304152 | 1304152 | 2021-05-10 | Henry | Illinois | 17073 | 4931 | 92 |
1304153 | 1304153 | 2021-05-10 | Iroquois | Illinois | 17075 | 2996 | 68 |
1304154 | 1304154 | 2021-05-10 | Jackson | Illinois | 17077 | 5003 | 75 |
1304155 | 1304155 | 2021-05-10 | Jasper | Illinois | 17079 | 1150 | 20 |
1304156 | 1304156 | 2021-05-10 | Jefferson | Illinois | 17081 | 4272 | 121 |
1304157 | 1304157 | 2021-05-10 | Jersey | Illinois | 17083 | 2688 | 68 |
1304158 | 1304158 | 2021-05-10 | Jo Daviess | Illinois | 17085 | 1805 | 27 |
1304159 | 1304159 | 2021-05-10 | Johnson | Illinois | 17087 | 1428 | 21 |
1304160 | 1304160 | 2021-05-10 | Kane | Illinois | 17089 | 58123 | 822 |
1304161 | 1304161 | 2021-05-10 | Kankakee | Illinois | 17091 | 14087 | 217 |
1304162 | 1304162 | 2021-05-10 | Kendall | Illinois | 17093 | 13411 | 101 |
1304163 | 1304163 | 2021-05-10 | Knox | Illinois | 17095 | 5530 | 172 |
1304164 | 1304164 | 2021-05-10 | LaSalle | Illinois | 17099 | 12469 | 298 |
1304165 | 1304165 | 2021-05-10 | Lake | Illinois | 17097 | 66904 | 1055 |
1304166 | 1304166 | 2021-05-10 | Lawrence | Illinois | 17101 | 2404 | 34 |
1304167 | 1304167 | 2021-05-10 | Lee | Illinois | 17103 | 4143 | 91 |
1304168 | 1304168 | 2021-05-10 | Livingston | Illinois | 17105 | 4804 | 97 |
1304169 | 1304169 | 2021-05-10 | Logan | Illinois | 17107 | 3853 | 70 |
1304170 | 1304170 | 2021-05-10 | Macon | Illinois | 17115 | 10709 | 208 |
1304171 | 1304171 | 2021-05-10 | Macoupin | Illinois | 17117 | 4676 | 110 |
1304172 | 1304172 | 2021-05-10 | Madison | Illinois | 17119 | 30404 | 591 |
1304173 | 1304173 | 2021-05-10 | Marion | Illinois | 17121 | 4460 | 121 |
1304174 | 1304174 | 2021-05-10 | Marshall | Illinois | 17123 | 1060 | 20 |
1304175 | 1304175 | 2021-05-10 | Mason | Illinois | 17125 | 1496 | 46 |
1304176 | 1304176 | 2021-05-10 | Massac | Illinois | 17127 | 1334 | 43 |
1304177 | 1304177 | 2021-05-10 | McDonough | Illinois | 17109 | 2825 | 59 |
1304178 | 1304178 | 2021-05-10 | McHenry | Illinois | 17111 | 28441 | 311 |
1304179 | 1304179 | 2021-05-10 | McLean | Illinois | 17113 | 18060 | 214 |
1304180 | 1304180 | 2021-05-10 | Menard | Illinois | 17129 | 1229 | 16 |
1304181 | 1304181 | 2021-05-10 | Mercer | Illinois | 17131 | 1461 | 33 |
1304182 | 1304182 | 2021-05-10 | Monroe | Illinois | 17133 | 4355 | 93 |
1304183 | 1304183 | 2021-05-10 | Montgomery | Illinois | 17135 | 3708 | 79 |
1304184 | 1304184 | 2021-05-10 | Morgan | Illinois | 17137 | 3963 | 102 |
1304185 | 1304185 | 2021-05-10 | Moultrie | Illinois | 17139 | 1605 | 34 |
1304186 | 1304186 | 2021-05-10 | Ogle | Illinois | 17141 | 6082 | 89 |
1304187 | 1304187 | 2021-05-10 | Peoria | Illinois | 17143 | 23097 | 330 |
1304188 | 1304188 | 2021-05-10 | Perry | Illinois | 17145 | 3158 | 69 |
1304189 | 1304189 | 2021-05-10 | Piatt | Illinois | 17147 | 1482 | 20 |
1304190 | 1304190 | 2021-05-10 | Pike | Illinois | 17149 | 1786 | 55 |
1304191 | 1304191 | 2021-05-10 | Pope | Illinois | 17151 | 317 | 4 |
1304192 | 1304192 | 2021-05-10 | Pulaski | Illinois | 17153 | 686 | 7 |
1304193 | 1304193 | 2021-05-10 | Putnam | Illinois | 17155 | 481 | 4 |
1304194 | 1304194 | 2021-05-10 | Randolph | Illinois | 17157 | 4128 | 90 |
1304195 | 1304195 | 2021-05-10 | Richland | Illinois | 17159 | 1741 | 49 |
1304196 | 1304196 | 2021-05-10 | Rock Island | Illinois | 17161 | 14889 | 351 |
1304197 | 1304197 | 2021-05-10 | Saline | Illinois | 17165 | 2562 | 70 |
1304198 | 1304198 | 2021-05-10 | Sangamon | Illinois | 17167 | 18648 | 275 |
1304199 | 1304199 | 2021-05-10 | Schuyler | Illinois | 17169 | 743 | 17 |
1304200 | 1304200 | 2021-05-10 | Scott | Illinois | 17171 | 478 | 1 |
1304201 | 1304201 | 2021-05-10 | Shelby | Illinois | 17173 | 2291 | 40 |
1304202 | 1304202 | 2021-05-10 | St. Clair | Illinois | 17163 | 30717 | 556 |
1304203 | 1304203 | 2021-05-10 | Stark | Illinois | 17175 | 634 | 23 |
1304204 | 1304204 | 2021-05-10 | Stephenson | Illinois | 17177 | 4735 | 100 |
1304205 | 1304205 | 2021-05-10 | Tazewell | Illinois | 17179 | 16855 | 316 |
1304206 | 1304206 | 2021-05-10 | Union | Illinois | 17181 | 2252 | 44 |
1304207 | 1304207 | 2021-05-10 | Unknown | Illinois | 0 | 335 | |
1304208 | 1304208 | 2021-05-10 | Vermilion | Illinois | 17183 | 9558 | 149 |
1304209 | 1304209 | 2021-05-10 | Wabash | Illinois | 17185 | 1345 | 15 |
1304210 | 1304210 | 2021-05-10 | Warren | Illinois | 17187 | 1794 | 49 |
1304211 | 1304211 | 2021-05-10 | Washington | Illinois | 17189 | 1639 | 31 |
1304212 | 1304212 | 2021-05-10 | Wayne | Illinois | 17191 | 1768 | 53 |
1304213 | 1304213 | 2021-05-10 | White | Illinois | 17193 | 1693 | 36 |
1304214 | 1304214 | 2021-05-10 | Whiteside | Illinois | 17195 | 7215 | 213 |
1304215 | 1304215 | 2021-05-10 | Will | Illinois | 17197 | 75162 | 1062 |
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);