ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,367 rows where deaths = 0 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 17013 241
- 17155 233
- 17071 225
- 17069 220
- 17087 214
- 17147 209
- 17123 198
- 17009 195
- 17057 192
- 17047 182
- 17121 182
- 17129 180
- 17169 180
- 17025 177
- 17193 165
- 17101 162
- 17171 162
- 17065 161
- 17033 156
- 17149 155
- 17139 149
- 17175 149
- 17189 148
- 17127 146
- 17003 140
- 17061 140
- 17039 139
- 17125 139
- 17055 138
- 17187 137
- …
county >30
- Calhoun 241
- Putnam 233
- Henderson 225
- Hardin 220
- Johnson 214
- Piatt 209
- Marshall 198
- Brown 195
- Fulton 192
- Edwards 182
- Marion 182
- Menard 180
- Schuyler 180
- Clay 177
- White 165
- Lawrence 162
- Scott 162
- Hamilton 161
- Crawford 156
- Pike 155
- Moultrie 149
- Stark 149
- Washington 148
- Massac 146
- Alexander 140
- Greene 140
- De Witt 139
- Mason 139
- Franklin 138
- Warren 137
- …
state 1
- Illinois · 8,367 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
891907 | 891907 | 2021-01-03 | Putnam | Illinois | 17155 | 325 | 0 |
888660 | 888660 | 2021-01-02 | Putnam | Illinois | 17155 | 323 | 0 |
885415 | 885415 | 2021-01-01 | Putnam | Illinois | 17155 | 319 | 0 |
882170 | 882170 | 2020-12-31 | Putnam | Illinois | 17155 | 319 | 0 |
878925 | 878925 | 2020-12-30 | Putnam | Illinois | 17155 | 319 | 0 |
875680 | 875680 | 2020-12-29 | Putnam | Illinois | 17155 | 312 | 0 |
872435 | 872435 | 2020-12-28 | Putnam | Illinois | 17155 | 312 | 0 |
869190 | 869190 | 2020-12-27 | Putnam | Illinois | 17155 | 310 | 0 |
865945 | 865945 | 2020-12-26 | Putnam | Illinois | 17155 | 310 | 0 |
862700 | 862700 | 2020-12-25 | Putnam | Illinois | 17155 | 309 | 0 |
859455 | 859455 | 2020-12-24 | Putnam | Illinois | 17155 | 305 | 0 |
856210 | 856210 | 2020-12-23 | Putnam | Illinois | 17155 | 304 | 0 |
852965 | 852965 | 2020-12-22 | Putnam | Illinois | 17155 | 303 | 0 |
849720 | 849720 | 2020-12-21 | Putnam | Illinois | 17155 | 302 | 0 |
846475 | 846475 | 2020-12-20 | Putnam | Illinois | 17155 | 300 | 0 |
843229 | 843229 | 2020-12-19 | Putnam | Illinois | 17155 | 297 | 0 |
839984 | 839984 | 2020-12-18 | Putnam | Illinois | 17155 | 296 | 0 |
836739 | 836739 | 2020-12-17 | Putnam | Illinois | 17155 | 296 | 0 |
833493 | 833493 | 2020-12-16 | Putnam | Illinois | 17155 | 296 | 0 |
830246 | 830246 | 2020-12-15 | Putnam | Illinois | 17155 | 295 | 0 |
827000 | 827000 | 2020-12-14 | Putnam | Illinois | 17155 | 291 | 0 |
823753 | 823753 | 2020-12-13 | Putnam | Illinois | 17155 | 292 | 0 |
820507 | 820507 | 2020-12-12 | Putnam | Illinois | 17155 | 290 | 0 |
817261 | 817261 | 2020-12-11 | Putnam | Illinois | 17155 | 286 | 0 |
817268 | 817268 | 2020-12-11 | Scott | Illinois | 17171 | 274 | 0 |
814015 | 814015 | 2020-12-10 | Putnam | Illinois | 17155 | 283 | 0 |
814022 | 814022 | 2020-12-10 | Scott | Illinois | 17171 | 271 | 0 |
810770 | 810770 | 2020-12-09 | Putnam | Illinois | 17155 | 277 | 0 |
810777 | 810777 | 2020-12-09 | Scott | Illinois | 17171 | 268 | 0 |
807525 | 807525 | 2020-12-08 | Putnam | Illinois | 17155 | 271 | 0 |
807532 | 807532 | 2020-12-08 | Scott | Illinois | 17171 | 269 | 0 |
804280 | 804280 | 2020-12-07 | Putnam | Illinois | 17155 | 268 | 0 |
804287 | 804287 | 2020-12-07 | Scott | Illinois | 17171 | 265 | 0 |
801035 | 801035 | 2020-12-06 | Putnam | Illinois | 17155 | 264 | 0 |
801042 | 801042 | 2020-12-06 | Scott | Illinois | 17171 | 264 | 0 |
797790 | 797790 | 2020-12-05 | Putnam | Illinois | 17155 | 261 | 0 |
797797 | 797797 | 2020-12-05 | Scott | Illinois | 17171 | 264 | 0 |
794545 | 794545 | 2020-12-04 | Putnam | Illinois | 17155 | 257 | 0 |
794552 | 794552 | 2020-12-04 | Scott | Illinois | 17171 | 257 | 0 |
791300 | 791300 | 2020-12-03 | Putnam | Illinois | 17155 | 256 | 0 |
791307 | 791307 | 2020-12-03 | Scott | Illinois | 17171 | 251 | 0 |
788055 | 788055 | 2020-12-02 | Putnam | Illinois | 17155 | 252 | 0 |
788062 | 788062 | 2020-12-02 | Scott | Illinois | 17171 | 244 | 0 |
784740 | 784740 | 2020-12-01 | Calhoun | Illinois | 17013 | 262 | 0 |
784811 | 784811 | 2020-12-01 | Putnam | Illinois | 17155 | 250 | 0 |
784818 | 784818 | 2020-12-01 | Scott | Illinois | 17171 | 244 | 0 |
781495 | 781495 | 2020-11-30 | Calhoun | Illinois | 17013 | 251 | 0 |
781566 | 781566 | 2020-11-30 | Putnam | Illinois | 17155 | 246 | 0 |
781573 | 781573 | 2020-11-30 | Scott | Illinois | 17171 | 233 | 0 |
778249 | 778249 | 2020-11-29 | Calhoun | Illinois | 17013 | 247 | 0 |
778320 | 778320 | 2020-11-29 | Putnam | Illinois | 17155 | 243 | 0 |
778327 | 778327 | 2020-11-29 | Scott | Illinois | 17171 | 231 | 0 |
775004 | 775004 | 2020-11-28 | Calhoun | Illinois | 17013 | 235 | 0 |
775075 | 775075 | 2020-11-28 | Putnam | Illinois | 17155 | 242 | 0 |
775082 | 775082 | 2020-11-28 | Scott | Illinois | 17171 | 231 | 0 |
771759 | 771759 | 2020-11-27 | Calhoun | Illinois | 17013 | 231 | 0 |
771788 | 771788 | 2020-11-27 | Henderson | Illinois | 17071 | 279 | 0 |
771830 | 771830 | 2020-11-27 | Putnam | Illinois | 17155 | 242 | 0 |
771837 | 771837 | 2020-11-27 | Scott | Illinois | 17171 | 231 | 0 |
768514 | 768514 | 2020-11-26 | Calhoun | Illinois | 17013 | 231 | 0 |
768542 | 768542 | 2020-11-26 | Hardin | Illinois | 17069 | 144 | 0 |
768543 | 768543 | 2020-11-26 | Henderson | Illinois | 17071 | 276 | 0 |
768585 | 768585 | 2020-11-26 | Putnam | Illinois | 17155 | 240 | 0 |
768592 | 768592 | 2020-11-26 | Scott | Illinois | 17171 | 231 | 0 |
765268 | 765268 | 2020-11-25 | Calhoun | Illinois | 17013 | 228 | 0 |
765296 | 765296 | 2020-11-25 | Hardin | Illinois | 17069 | 136 | 0 |
765297 | 765297 | 2020-11-25 | Henderson | Illinois | 17071 | 265 | 0 |
765339 | 765339 | 2020-11-25 | Putnam | Illinois | 17155 | 236 | 0 |
765346 | 765346 | 2020-11-25 | Scott | Illinois | 17171 | 223 | 0 |
762023 | 762023 | 2020-11-24 | Calhoun | Illinois | 17013 | 225 | 0 |
762051 | 762051 | 2020-11-24 | Hardin | Illinois | 17069 | 131 | 0 |
762052 | 762052 | 2020-11-24 | Henderson | Illinois | 17071 | 261 | 0 |
762094 | 762094 | 2020-11-24 | Putnam | Illinois | 17155 | 236 | 0 |
762101 | 762101 | 2020-11-24 | Scott | Illinois | 17171 | 223 | 0 |
758778 | 758778 | 2020-11-23 | Calhoun | Illinois | 17013 | 217 | 0 |
758806 | 758806 | 2020-11-23 | Hardin | Illinois | 17069 | 127 | 0 |
758807 | 758807 | 2020-11-23 | Henderson | Illinois | 17071 | 258 | 0 |
758849 | 758849 | 2020-11-23 | Putnam | Illinois | 17155 | 228 | 0 |
758856 | 758856 | 2020-11-23 | Scott | Illinois | 17171 | 212 | 0 |
755531 | 755531 | 2020-11-22 | Calhoun | Illinois | 17013 | 215 | 0 |
755559 | 755559 | 2020-11-22 | Hardin | Illinois | 17069 | 120 | 0 |
755560 | 755560 | 2020-11-22 | Henderson | Illinois | 17071 | 254 | 0 |
755602 | 755602 | 2020-11-22 | Putnam | Illinois | 17155 | 224 | 0 |
755609 | 755609 | 2020-11-22 | Scott | Illinois | 17171 | 211 | 0 |
752285 | 752285 | 2020-11-21 | Calhoun | Illinois | 17013 | 212 | 0 |
752313 | 752313 | 2020-11-21 | Hardin | Illinois | 17069 | 116 | 0 |
752314 | 752314 | 2020-11-21 | Henderson | Illinois | 17071 | 248 | 0 |
752356 | 752356 | 2020-11-21 | Putnam | Illinois | 17155 | 220 | 0 |
752363 | 752363 | 2020-11-21 | Scott | Illinois | 17171 | 211 | 0 |
749039 | 749039 | 2020-11-20 | Calhoun | Illinois | 17013 | 206 | 0 |
749067 | 749067 | 2020-11-20 | Hardin | Illinois | 17069 | 111 | 0 |
749068 | 749068 | 2020-11-20 | Henderson | Illinois | 17071 | 243 | 0 |
749110 | 749110 | 2020-11-20 | Putnam | Illinois | 17155 | 209 | 0 |
749117 | 749117 | 2020-11-20 | Scott | Illinois | 17171 | 207 | 0 |
745793 | 745793 | 2020-11-19 | Calhoun | Illinois | 17013 | 194 | 0 |
745821 | 745821 | 2020-11-19 | Hardin | Illinois | 17069 | 105 | 0 |
745822 | 745822 | 2020-11-19 | Henderson | Illinois | 17071 | 241 | 0 |
745864 | 745864 | 2020-11-19 | Putnam | Illinois | 17155 | 197 | 0 |
745871 | 745871 | 2020-11-19 | Scott | Illinois | 17171 | 203 | 0 |
742546 | 742546 | 2020-11-18 | Calhoun | Illinois | 17013 | 188 | 0 |
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);