ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
267 rows where cases = 12 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Bond 33
- Franklin 33
- Fulton 20
- Douglas 10
- Hancock 10
- Effingham 9
- Wabash 9
- Jersey 8
- Marshall 7
- Richland 7
- Brown 6
- Bureau 6
- Clark 6
- Piatt 6
- Moultrie 5
- Carroll 4
- Fayette 4
- Jo Daviess 4
- Mercer 4
- Wayne 4
- Cumberland 3
- De Witt 3
- Johnson 3
- Lawrence 3
- Mason 3
- Morgan 3
- Schuyler 3
- Stephenson 3
- Alexander 2
- Calhoun 2
- …
state 1
- Illinois · 267 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
431617 | 431617 | 2020-08-14 | Calhoun | Illinois | 17013 | 12 | 0 |
428389 | 428389 | 2020-08-13 | Calhoun | Illinois | 17013 | 12 | 0 |
415529 | 415529 | 2020-08-09 | Henderson | Illinois | 17071 | 12 | 0 |
412309 | 412309 | 2020-08-08 | Henderson | Illinois | 17071 | 12 | 0 |
402701 | 402701 | 2020-08-05 | Scott | Illinois | 17171 | 12 | 0 |
393048 | 393048 | 2020-08-02 | Richland | Illinois | 17159 | 12 | 0 |
389831 | 389831 | 2020-08-01 | Richland | Illinois | 17159 | 12 | 0 |
386547 | 386547 | 2020-07-31 | Clay | Illinois | 17025 | 12 | 0 |
386558 | 386558 | 2020-07-31 | Edwards | Illinois | 17047 | 12 | 0 |
386614 | 386614 | 2020-07-31 | Richland | Illinois | 17159 | 12 | 0 |
383329 | 383329 | 2020-07-30 | Clay | Illinois | 17025 | 12 | 0 |
383340 | 383340 | 2020-07-30 | Edwards | Illinois | 17047 | 12 | 0 |
383391 | 383391 | 2020-07-30 | Pike | Illinois | 17149 | 12 | 0 |
383396 | 383396 | 2020-07-30 | Richland | Illinois | 17159 | 12 | 0 |
380179 | 380179 | 2020-07-29 | Richland | Illinois | 17159 | 12 | 0 |
376887 | 376887 | 2020-07-28 | Brown | Illinois | 17009 | 12 | 0 |
373672 | 373672 | 2020-07-27 | Brown | Illinois | 17009 | 12 | 0 |
373747 | 373747 | 2020-07-27 | Richland | Illinois | 17159 | 12 | 0 |
370460 | 370460 | 2020-07-26 | Brown | Illinois | 17009 | 12 | 0 |
370535 | 370535 | 2020-07-26 | Richland | Illinois | 17159 | 12 | 0 |
367250 | 367250 | 2020-07-25 | Brown | Illinois | 17009 | 12 | 0 |
364043 | 364043 | 2020-07-24 | Brown | Illinois | 17009 | 12 | 0 |
360836 | 360836 | 2020-07-23 | Brown | Illinois | 17009 | 12 | 0 |
344851 | 344851 | 2020-07-18 | Gallatin | Illinois | 17059 | 12 | 0 |
338456 | 338456 | 2020-07-16 | Greene | Illinois | 17061 | 12 | 0 |
335260 | 335260 | 2020-07-15 | Greene | Illinois | 17061 | 12 | 0 |
328900 | 328900 | 2020-07-13 | Lawrence | Illinois | 17101 | 12 | 0 |
328908 | 328908 | 2020-07-13 | Marshall | Illinois | 17123 | 12 | 0 |
325714 | 325714 | 2020-07-12 | Lawrence | Illinois | 17101 | 12 | 0 |
325722 | 325722 | 2020-07-12 | Marshall | Illinois | 17123 | 12 | 0 |
322533 | 322533 | 2020-07-11 | Lawrence | Illinois | 17101 | 12 | 0 |
322541 | 322541 | 2020-07-11 | Marshall | Illinois | 17123 | 12 | 0 |
319362 | 319362 | 2020-07-10 | Marshall | Illinois | 17123 | 12 | 0 |
316189 | 316189 | 2020-07-09 | Marshall | Illinois | 17123 | 12 | 0 |
313015 | 313015 | 2020-07-08 | Marshall | Illinois | 17123 | 12 | 0 |
309805 | 309805 | 2020-07-07 | De Witt | Illinois | 17039 | 12 | 0 |
309845 | 309845 | 2020-07-07 | Marshall | Illinois | 17123 | 12 | 0 |
306637 | 306637 | 2020-07-06 | De Witt | Illinois | 17039 | 12 | 0 |
303472 | 303472 | 2020-07-05 | De Witt | Illinois | 17039 | 12 | 0 |
297145 | 297145 | 2020-07-03 | Cumberland | Illinois | 17035 | 12 | 0 |
293988 | 293988 | 2020-07-02 | Cumberland | Illinois | 17035 | 12 | 0 |
293995 | 293995 | 2020-07-02 | Effingham | Illinois | 17049 | 12 | 1 |
290834 | 290834 | 2020-07-01 | Cumberland | Illinois | 17035 | 12 | 0 |
290841 | 290841 | 2020-07-01 | Effingham | Illinois | 17049 | 12 | 1 |
287691 | 287691 | 2020-06-30 | Effingham | Illinois | 17049 | 12 | 1 |
281468 | 281468 | 2020-06-28 | Wayne | Illinois | 17191 | 12 | 1 |
278320 | 278320 | 2020-06-27 | Wayne | Illinois | 17191 | 12 | 1 |
275079 | 275079 | 2020-06-26 | Bond | Illinois | 17005 | 12 | 1 |
275172 | 275172 | 2020-06-26 | Wayne | Illinois | 17191 | 12 | 1 |
271937 | 271937 | 2020-06-25 | Bond | Illinois | 17005 | 12 | 1 |
272030 | 272030 | 2020-06-25 | Wayne | Illinois | 17191 | 12 | 1 |
268800 | 268800 | 2020-06-24 | Bond | Illinois | 17005 | 12 | 1 |
268822 | 268822 | 2020-06-24 | Effingham | Illinois | 17049 | 12 | 1 |
268825 | 268825 | 2020-06-24 | Franklin | Illinois | 17055 | 12 | 0 |
265670 | 265670 | 2020-06-23 | Bond | Illinois | 17005 | 12 | 1 |
265695 | 265695 | 2020-06-23 | Franklin | Illinois | 17055 | 12 | 0 |
262542 | 262542 | 2020-06-22 | Bond | Illinois | 17005 | 12 | 1 |
262564 | 262564 | 2020-06-22 | Effingham | Illinois | 17049 | 12 | 1 |
262567 | 262567 | 2020-06-22 | Franklin | Illinois | 17055 | 12 | 0 |
262568 | 262568 | 2020-06-22 | Fulton | Illinois | 17057 | 12 | 0 |
259415 | 259415 | 2020-06-21 | Bond | Illinois | 17005 | 12 | 1 |
259437 | 259437 | 2020-06-21 | Effingham | Illinois | 17049 | 12 | 1 |
259440 | 259440 | 2020-06-21 | Franklin | Illinois | 17055 | 12 | 0 |
259441 | 259441 | 2020-06-21 | Fulton | Illinois | 17057 | 12 | 0 |
256289 | 256289 | 2020-06-20 | Bond | Illinois | 17005 | 12 | 1 |
256311 | 256311 | 2020-06-20 | Effingham | Illinois | 17049 | 12 | 1 |
256314 | 256314 | 2020-06-20 | Franklin | Illinois | 17055 | 12 | 0 |
256315 | 256315 | 2020-06-20 | Fulton | Illinois | 17057 | 12 | 0 |
253169 | 253169 | 2020-06-19 | Bond | Illinois | 17005 | 12 | 1 |
253191 | 253191 | 2020-06-19 | Effingham | Illinois | 17049 | 12 | 1 |
253194 | 253194 | 2020-06-19 | Franklin | Illinois | 17055 | 12 | 0 |
253195 | 253195 | 2020-06-19 | Fulton | Illinois | 17057 | 12 | 0 |
253220 | 253220 | 2020-06-19 | Logan | Illinois | 17107 | 12 | 0 |
250054 | 250054 | 2020-06-18 | Bond | Illinois | 17005 | 12 | 1 |
250076 | 250076 | 2020-06-18 | Effingham | Illinois | 17049 | 12 | 1 |
250079 | 250079 | 2020-06-18 | Franklin | Illinois | 17055 | 12 | 0 |
250080 | 250080 | 2020-06-18 | Fulton | Illinois | 17057 | 12 | 0 |
246942 | 246942 | 2020-06-17 | Bond | Illinois | 17005 | 12 | 1 |
246967 | 246967 | 2020-06-17 | Franklin | Illinois | 17055 | 12 | 0 |
243829 | 243829 | 2020-06-16 | Bond | Illinois | 17005 | 12 | 1 |
243854 | 243854 | 2020-06-16 | Franklin | Illinois | 17055 | 12 | 0 |
243855 | 243855 | 2020-06-16 | Fulton | Illinois | 17057 | 12 | 0 |
240718 | 240718 | 2020-06-15 | Bond | Illinois | 17005 | 12 | 1 |
240743 | 240743 | 2020-06-15 | Franklin | Illinois | 17055 | 12 | 0 |
240744 | 240744 | 2020-06-15 | Fulton | Illinois | 17057 | 12 | 0 |
237610 | 237610 | 2020-06-14 | Bond | Illinois | 17005 | 12 | 1 |
237635 | 237635 | 2020-06-14 | Franklin | Illinois | 17055 | 12 | 0 |
237636 | 237636 | 2020-06-14 | Fulton | Illinois | 17057 | 12 | 0 |
237700 | 237700 | 2020-06-14 | Wabash | Illinois | 17185 | 12 | 0 |
234503 | 234503 | 2020-06-13 | Bond | Illinois | 17005 | 12 | 1 |
234512 | 234512 | 2020-06-13 | Clark | Illinois | 17023 | 12 | 0 |
234528 | 234528 | 2020-06-13 | Franklin | Illinois | 17055 | 12 | 0 |
234529 | 234529 | 2020-06-13 | Fulton | Illinois | 17057 | 12 | 0 |
234593 | 234593 | 2020-06-13 | Wabash | Illinois | 17185 | 12 | 0 |
231397 | 231397 | 2020-06-12 | Bond | Illinois | 17005 | 12 | 1 |
231406 | 231406 | 2020-06-12 | Clark | Illinois | 17023 | 12 | 0 |
231422 | 231422 | 2020-06-12 | Franklin | Illinois | 17055 | 12 | 0 |
231423 | 231423 | 2020-06-12 | Fulton | Illinois | 17057 | 12 | 0 |
231487 | 231487 | 2020-06-12 | Wabash | Illinois | 17185 | 12 | 0 |
228294 | 228294 | 2020-06-11 | Bond | Illinois | 17005 | 12 | 1 |
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);