ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-05-26" 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 |
---|---|---|---|---|---|---|---|
1356064 | 1356064 | 2021-05-26 | Adams | Illinois | 17001 | 8592 | 153 |
1356065 | 1356065 | 2021-05-26 | Alexander | Illinois | 17003 | 470 | 11 |
1356066 | 1356066 | 2021-05-26 | Bond | Illinois | 17005 | 2077 | 30 |
1356067 | 1356067 | 2021-05-26 | Boone | Illinois | 17007 | 6763 | 87 |
1356068 | 1356068 | 2021-05-26 | Brown | Illinois | 17009 | 723 | 12 |
1356069 | 1356069 | 2021-05-26 | Bureau | Illinois | 17011 | 3753 | 95 |
1356070 | 1356070 | 2021-05-26 | Calhoun | Illinois | 17013 | 519 | 5 |
1356071 | 1356071 | 2021-05-26 | Carroll | Illinois | 17015 | 1764 | 37 |
1356072 | 1356072 | 2021-05-26 | Cass | Illinois | 17017 | 2004 | 36 |
1356073 | 1356073 | 2021-05-26 | Champaign | Illinois | 17019 | 20900 | 156 |
1356074 | 1356074 | 2021-05-26 | Christian | Illinois | 17021 | 3756 | 91 |
1356075 | 1356075 | 2021-05-26 | Clark | Illinois | 17023 | 1821 | 41 |
1356076 | 1356076 | 2021-05-26 | Clay | Illinois | 17025 | 1486 | 48 |
1356077 | 1356077 | 2021-05-26 | Clinton | Illinois | 17027 | 5776 | 99 |
1356078 | 1356078 | 2021-05-26 | Coles | Illinois | 17029 | 5726 | 101 |
1356079 | 1356079 | 2021-05-26 | Cook | Illinois | 17031 | 552055 | 10800 |
1356080 | 1356080 | 2021-05-26 | Crawford | Illinois | 17033 | 2133 | 42 |
1356081 | 1356081 | 2021-05-26 | Cumberland | Illinois | 17035 | 1298 | 31 |
1356082 | 1356082 | 2021-05-26 | De Witt | Illinois | 17039 | 1550 | 34 |
1356083 | 1356083 | 2021-05-26 | DeKalb | Illinois | 17037 | 10246 | 125 |
1356084 | 1356084 | 2021-05-26 | Douglas | Illinois | 17041 | 2593 | 40 |
1356085 | 1356085 | 2021-05-26 | DuPage | Illinois | 17043 | 91623 | 1380 |
1356086 | 1356086 | 2021-05-26 | Edgar | Illinois | 17045 | 1739 | 60 |
1356087 | 1356087 | 2021-05-26 | Edwards | Illinois | 17047 | 574 | 13 |
1356088 | 1356088 | 2021-05-26 | Effingham | Illinois | 17049 | 4741 | 83 |
1356089 | 1356089 | 2021-05-26 | Fayette | Illinois | 17051 | 3196 | 58 |
1356090 | 1356090 | 2021-05-26 | Ford | Illinois | 17053 | 1830 | 56 |
1356091 | 1356091 | 2021-05-26 | Franklin | Illinois | 17055 | 4500 | 88 |
1356092 | 1356092 | 2021-05-26 | Fulton | Illinois | 17057 | 4022 | 67 |
1356093 | 1356093 | 2021-05-26 | Gallatin | Illinois | 17059 | 462 | 5 |
1356094 | 1356094 | 2021-05-26 | Greene | Illinois | 17061 | 1446 | 46 |
1356095 | 1356095 | 2021-05-26 | Grundy | Illinois | 17063 | 5950 | 80 |
1356096 | 1356096 | 2021-05-26 | Hamilton | Illinois | 17065 | 838 | 18 |
1356097 | 1356097 | 2021-05-26 | Hancock | Illinois | 17067 | 1780 | 41 |
1356098 | 1356098 | 2021-05-26 | Hardin | Illinois | 17069 | 389 | 12 |
1356099 | 1356099 | 2021-05-26 | Henderson | Illinois | 17071 | 526 | 23 |
1356100 | 1356100 | 2021-05-26 | Henry | Illinois | 17073 | 5049 | 97 |
1356101 | 1356101 | 2021-05-26 | Iroquois | Illinois | 17075 | 3062 | 68 |
1356102 | 1356102 | 2021-05-26 | Jackson | Illinois | 17077 | 5066 | 75 |
1356103 | 1356103 | 2021-05-26 | Jasper | Illinois | 17079 | 1156 | 20 |
1356104 | 1356104 | 2021-05-26 | Jefferson | Illinois | 17081 | 4402 | 121 |
1356105 | 1356105 | 2021-05-26 | Jersey | Illinois | 17083 | 2706 | 69 |
1356106 | 1356106 | 2021-05-26 | Jo Daviess | Illinois | 17085 | 1824 | 27 |
1356107 | 1356107 | 2021-05-26 | Johnson | Illinois | 17087 | 1460 | 21 |
1356108 | 1356108 | 2021-05-26 | Kane | Illinois | 17089 | 59070 | 838 |
1356109 | 1356109 | 2021-05-26 | Kankakee | Illinois | 17091 | 14382 | 220 |
1356110 | 1356110 | 2021-05-26 | Kendall | Illinois | 17093 | 13676 | 105 |
1356111 | 1356111 | 2021-05-26 | Knox | Illinois | 17095 | 5605 | 182 |
1356112 | 1356112 | 2021-05-26 | LaSalle | Illinois | 17099 | 12690 | 301 |
1356113 | 1356113 | 2021-05-26 | Lake | Illinois | 17097 | 67913 | 1071 |
1356114 | 1356114 | 2021-05-26 | Lawrence | Illinois | 17101 | 2407 | 34 |
1356115 | 1356115 | 2021-05-26 | Lee | Illinois | 17103 | 4185 | 91 |
1356116 | 1356116 | 2021-05-26 | Livingston | Illinois | 17105 | 4862 | 99 |
1356117 | 1356117 | 2021-05-26 | Logan | Illinois | 17107 | 3932 | 75 |
1356118 | 1356118 | 2021-05-26 | Macon | Illinois | 17115 | 10902 | 216 |
1356119 | 1356119 | 2021-05-26 | Macoupin | Illinois | 17117 | 4752 | 116 |
1356120 | 1356120 | 2021-05-26 | Madison | Illinois | 17119 | 30751 | 595 |
1356121 | 1356121 | 2021-05-26 | Marion | Illinois | 17121 | 4489 | 122 |
1356122 | 1356122 | 2021-05-26 | Marshall | Illinois | 17123 | 1081 | 21 |
1356123 | 1356123 | 2021-05-26 | Mason | Illinois | 17125 | 1529 | 46 |
1356124 | 1356124 | 2021-05-26 | Massac | Illinois | 17127 | 1354 | 43 |
1356125 | 1356125 | 2021-05-26 | McDonough | Illinois | 17109 | 2890 | 62 |
1356126 | 1356126 | 2021-05-26 | McHenry | Illinois | 17111 | 28959 | 314 |
1356127 | 1356127 | 2021-05-26 | McLean | Illinois | 17113 | 18435 | 218 |
1356128 | 1356128 | 2021-05-26 | Menard | Illinois | 17129 | 1240 | 16 |
1356129 | 1356129 | 2021-05-26 | Mercer | Illinois | 17131 | 1485 | 33 |
1356130 | 1356130 | 2021-05-26 | Monroe | Illinois | 17133 | 4364 | 94 |
1356131 | 1356131 | 2021-05-26 | Montgomery | Illinois | 17135 | 3767 | 79 |
1356132 | 1356132 | 2021-05-26 | Morgan | Illinois | 17137 | 4016 | 104 |
1356133 | 1356133 | 2021-05-26 | Moultrie | Illinois | 17139 | 1619 | 36 |
1356134 | 1356134 | 2021-05-26 | Ogle | Illinois | 17141 | 6160 | 91 |
1356135 | 1356135 | 2021-05-26 | Peoria | Illinois | 17143 | 23457 | 356 |
1356136 | 1356136 | 2021-05-26 | Perry | Illinois | 17145 | 3192 | 69 |
1356137 | 1356137 | 2021-05-26 | Piatt | Illinois | 17147 | 1517 | 20 |
1356138 | 1356138 | 2021-05-26 | Pike | Illinois | 17149 | 1798 | 56 |
1356139 | 1356139 | 2021-05-26 | Pope | Illinois | 17151 | 326 | 4 |
1356140 | 1356140 | 2021-05-26 | Pulaski | Illinois | 17153 | 694 | 7 |
1356141 | 1356141 | 2021-05-26 | Putnam | Illinois | 17155 | 485 | 4 |
1356142 | 1356142 | 2021-05-26 | Randolph | Illinois | 17157 | 4144 | 90 |
1356143 | 1356143 | 2021-05-26 | Richland | Illinois | 17159 | 1759 | 48 |
1356144 | 1356144 | 2021-05-26 | Rock Island | Illinois | 17161 | 15169 | 363 |
1356145 | 1356145 | 2021-05-26 | Saline | Illinois | 17165 | 2584 | 71 |
1356146 | 1356146 | 2021-05-26 | Sangamon | Illinois | 17167 | 18958 | 278 |
1356147 | 1356147 | 2021-05-26 | Schuyler | Illinois | 17169 | 775 | 19 |
1356148 | 1356148 | 2021-05-26 | Scott | Illinois | 17171 | 483 | 1 |
1356149 | 1356149 | 2021-05-26 | Shelby | Illinois | 17173 | 2310 | 40 |
1356150 | 1356150 | 2021-05-26 | St. Clair | Illinois | 17163 | 31046 | 561 |
1356151 | 1356151 | 2021-05-26 | Stark | Illinois | 17175 | 643 | 24 |
1356152 | 1356152 | 2021-05-26 | Stephenson | Illinois | 17177 | 4801 | 103 |
1356153 | 1356153 | 2021-05-26 | Tazewell | Illinois | 17179 | 17112 | 331 |
1356154 | 1356154 | 2021-05-26 | Union | Illinois | 17181 | 2264 | 44 |
1356155 | 1356155 | 2021-05-26 | Unknown | Illinois | 0 | 357 | |
1356156 | 1356156 | 2021-05-26 | Vermilion | Illinois | 17183 | 9873 | 151 |
1356157 | 1356157 | 2021-05-26 | Wabash | Illinois | 17185 | 1350 | 15 |
1356158 | 1356158 | 2021-05-26 | Warren | Illinois | 17187 | 1820 | 50 |
1356159 | 1356159 | 2021-05-26 | Washington | Illinois | 17189 | 1647 | 31 |
1356160 | 1356160 | 2021-05-26 | Wayne | Illinois | 17191 | 1802 | 54 |
1356161 | 1356161 | 2021-05-26 | White | Illinois | 17193 | 1702 | 36 |
1356162 | 1356162 | 2021-05-26 | Whiteside | Illinois | 17195 | 7268 | 214 |
1356163 | 1356163 | 2021-05-26 | Will | Illinois | 17197 | 76435 | 1083 |
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);