ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

29,869 rows where state = "Illinois" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Illinois · 29,869 ✖
Link rowid date ▲ county state fips cases deaths
934099 934099 2021-01-16 Adams Illinois 17001 7329 117
934100 934100 2021-01-16 Alexander Illinois 17003 384 7
934101 934101 2021-01-16 Bond Illinois 17005 1726 24
934102 934102 2021-01-16 Boone Illinois 17007 5513 77
934103 934103 2021-01-16 Brown Illinois 17009 606 11
934104 934104 2021-01-16 Bureau Illinois 17011 2993 84
934105 934105 2021-01-16 Calhoun Illinois 17013 437 4
934106 934106 2021-01-16 Carroll Illinois 17015 1422 33
934107 934107 2021-01-16 Cass Illinois 17017 1741 31
934108 934108 2021-01-16 Champaign Illinois 17019 15288 96
934109 934109 2021-01-16 Christian Illinois 17021 2964 74
934110 934110 2021-01-16 Clark Illinois 17023 1459 29
934111 934111 2021-01-16 Clay Illinois 17025 1304 39
934112 934112 2021-01-16 Clinton Illinois 17027 4979 85
934113 934113 2021-01-16 Coles Illinois 17029 4684 80
934114 934114 2021-01-16 Cook Illinois 17031 431385 8980
934115 934115 2021-01-16 Crawford Illinois 17033 1749 34
934116 934116 2021-01-16 Cumberland Illinois 17035 1070 27
934117 934117 2021-01-16 De Witt Illinois 17039 1130 27
934118 934118 2021-01-16 DeKalb Illinois 17037 7469 92
934119 934119 2021-01-16 Douglas Illinois 17041 1986 33
934120 934120 2021-01-16 DuPage Illinois 17043 68534 1144
934121 934121 2021-01-16 Edgar Illinois 17045 1428 53
934122 934122 2021-01-16 Edwards Illinois 17047 461 9
934123 934123 2021-01-16 Effingham Illinois 17049 4285 68
934124 934124 2021-01-16 Fayette Illinois 17051 2892 53
934125 934125 2021-01-16 Ford Illinois 17053 1380 49
934126 934126 2021-01-16 Franklin Illinois 17055 3803 68
934127 934127 2021-01-16 Fulton Illinois 17057 2536 49
934128 934128 2021-01-16 Gallatin Illinois 17059 383 4
934129 934129 2021-01-16 Greene Illinois 17061 1252 42
934130 934130 2021-01-16 Grundy Illinois 17063 4318 54
934131 934131 2021-01-16 Hamilton Illinois 17065 711 16
934132 934132 2021-01-16 Hancock Illinois 17067 1467 33
934133 934133 2021-01-16 Hardin Illinois 17069 300 8
934134 934134 2021-01-16 Henderson Illinois 17071 448 16
934135 934135 2021-01-16 Henry Illinois 17073 3990 76
934136 934136 2021-01-16 Iroquois Illinois 17075 2569 56
934137 934137 2021-01-16 Jackson Illinois 17077 4132 67
934138 934138 2021-01-16 Jasper Illinois 17079 1030 16
934139 934139 2021-01-16 Jefferson Illinois 17081 3392 104
934140 934140 2021-01-16 Jersey Illinois 17083 2184 56
934141 934141 2021-01-16 Jo Daviess Illinois 17085 1478 24
934142 934142 2021-01-16 Johnson Illinois 17087 1210 15
934143 934143 2021-01-16 Kane Illinois 17089 45493 675
934144 934144 2021-01-16 Kankakee Illinois 17091 11401 179
934145 934145 2021-01-16 Kendall Illinois 17093 9681 78
934146 934146 2021-01-16 Knox Illinois 17095 4553 140
934147 934147 2021-01-16 LaSalle Illinois 17099 9328 247
934148 934148 2021-01-16 Lake Illinois 17097 52834 884
934149 934149 2021-01-16 Lawrence Illinois 17101 2167 30
934150 934150 2021-01-16 Lee Illinois 17103 3018 72
934151 934151 2021-01-16 Livingston Illinois 17105 3608 66
934152 934152 2021-01-16 Logan Illinois 17107 3060 56
934153 934153 2021-01-16 Macon Illinois 17115 8739 179
934154 934154 2021-01-16 Macoupin Illinois 17117 3795 94
934155 934155 2021-01-16 Madison Illinois 17119 23998 461
934156 934156 2021-01-16 Marion Illinois 17121 3938 111
934157 934157 2021-01-16 Marshall Illinois 17123 657 13
934158 934158 2021-01-16 Mason Illinois 17125 1159 40
934159 934159 2021-01-16 Massac Illinois 17127 1013 30
934160 934160 2021-01-16 McDonough Illinois 17109 2117 51
934161 934161 2021-01-16 McHenry Illinois 17111 21395 248
934162 934162 2021-01-16 McLean Illinois 17113 13093 159
934163 934163 2021-01-16 Menard Illinois 17129 864 10
934164 934164 2021-01-16 Mercer Illinois 17131 1167 29
934165 934165 2021-01-16 Monroe Illinois 17133 3533 70
934166 934166 2021-01-16 Montgomery Illinois 17135 3006 40
934167 934167 2021-01-16 Morgan Illinois 17137 3306 90
934168 934168 2021-01-16 Moultrie Illinois 17139 1361 28
934169 934169 2021-01-16 Ogle Illinois 17141 4571 71
934170 934170 2021-01-16 Peoria Illinois 17143 14860 238
934171 934171 2021-01-16 Perry Illinois 17145 2612 60
934172 934172 2021-01-16 Piatt Illinois 17147 1162 16
934173 934173 2021-01-16 Pike Illinois 17149 1538 46
934174 934174 2021-01-16 Pope Illinois 17151 243 2
934175 934175 2021-01-16 Pulaski Illinois 17153 609 3
934176 934176 2021-01-16 Putnam Illinois 17155 344 2
934177 934177 2021-01-16 Randolph Illinois 17157 3693 67
934178 934178 2021-01-16 Richland Illinois 17159 1522 44
934179 934179 2021-01-16 Rock Island Illinois 17161 11805 302
934180 934180 2021-01-16 Saline Illinois 17165 2005 53
934181 934181 2021-01-16 Sangamon Illinois 17167 14406 234
934182 934182 2021-01-16 Schuyler Illinois 17169 615 16
934183 934183 2021-01-16 Scott Illinois 17171 373 1
934184 934184 2021-01-16 Shelby Illinois 17173 1957 35
934185 934185 2021-01-16 St. Clair Illinois 17163 24172 424
934186 934186 2021-01-16 Stark Illinois 17175 493 20
934187 934187 2021-01-16 Stephenson Illinois 17177 3495 74
934188 934188 2021-01-16 Tazewell Illinois 17179 11825 242
934189 934189 2021-01-16 Union Illinois 17181 1968 32
934190 934190 2021-01-16 Vermilion Illinois 17183 7404 112
934191 934191 2021-01-16 Wabash Illinois 17185 1163 14
934192 934192 2021-01-16 Warren Illinois 17187 1577 43
934193 934193 2021-01-16 Washington Illinois 17189 1440 25
934194 934194 2021-01-16 Wayne Illinois 17191 1501 43
934195 934195 2021-01-16 White Illinois 17193 1319 30
934196 934196 2021-01-16 Whiteside Illinois 17195 5342 173
934197 934197 2021-01-16 Will Illinois 17197 57707 867
934198 934198 2021-01-16 Williamson Illinois 17199 6119 115

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);