ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 28 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Douglas 10
- Christian 9
- Jersey 5
- Edgar 3
- Moultrie 3
- Crawford 2
- Edwards 2
- Grundy 2
- Hancock 2
- Henderson 2
- Johnson 2
- Macoupin 2
- Marshall 2
- Mercer 2
- Stark 2
- Bond 1
- Fayette 1
- Franklin 1
- Fulton 1
- Greene 1
- Hamilton 1
- Henry 1
- LaSalle 1
- Lawrence 1
- Livingston 1
- Marion 1
- Mason 1
- Massac 1
- Menard 1
- Montgomery 1
- …
state 1
- Illinois · 79 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
522154 | 522154 | 2020-09-11 | Putnam | Illinois | 17155 | 28 | 0 |
496293 | 496293 | 2020-09-03 | Stark | Illinois | 17175 | 28 | 0 |
493059 | 493059 | 2020-09-02 | Stark | Illinois | 17175 | 28 | 0 |
457460 | 457460 | 2020-08-22 | Henderson | Illinois | 17071 | 28 | 0 |
454232 | 454232 | 2020-08-21 | Henderson | Illinois | 17071 | 28 | 0 |
450992 | 450992 | 2020-08-20 | Edwards | Illinois | 17047 | 28 | 0 |
444537 | 444537 | 2020-08-18 | Edwards | Illinois | 17047 | 28 | 0 |
428467 | 428467 | 2020-08-13 | Scott | Illinois | 17171 | 28 | 0 |
425217 | 425217 | 2020-08-12 | Marshall | Illinois | 17123 | 28 | 0 |
421996 | 421996 | 2020-08-11 | Marshall | Illinois | 17123 | 28 | 0 |
415516 | 415516 | 2020-08-09 | Edgar | Illinois | 17045 | 28 | 0 |
409077 | 409077 | 2020-08-07 | Edgar | Illinois | 17045 | 28 | 0 |
409087 | 409087 | 2020-08-07 | Hamilton | Illinois | 17065 | 28 | 0 |
405857 | 405857 | 2020-08-06 | Edgar | Illinois | 17045 | 28 | 0 |
402647 | 402647 | 2020-08-05 | Greene | Illinois | 17061 | 28 | 0 |
399429 | 399429 | 2020-08-04 | Fulton | Illinois | 17057 | 28 | 0 |
386568 | 386568 | 2020-07-31 | Hancock | Illinois | 17067 | 28 | 1 |
383350 | 383350 | 2020-07-30 | Hancock | Illinois | 17067 | 28 | 1 |
367306 | 367306 | 2020-07-25 | Massac | Illinois | 17127 | 28 | 0 |
367342 | 367342 | 2020-07-25 | Wayne | Illinois | 17191 | 28 | 1 |
364055 | 364055 | 2020-07-24 | Crawford | Illinois | 17033 | 28 | 0 |
360848 | 360848 | 2020-07-23 | Crawford | Illinois | 17033 | 28 | 0 |
354427 | 354427 | 2020-07-21 | Bond | Illinois | 17005 | 28 | 1 |
354475 | 354475 | 2020-07-21 | Lawrence | Illinois | 17101 | 28 | 0 |
348120 | 348120 | 2020-07-19 | White | Illinois | 17193 | 28 | 0 |
341691 | 341691 | 2020-07-17 | Moultrie | Illinois | 17139 | 28 | 0 |
338495 | 338495 | 2020-07-16 | Moultrie | Illinois | 17139 | 28 | 0 |
338507 | 338507 | 2020-07-16 | Saline | Illinois | 17165 | 28 | 0 |
335255 | 335255 | 2020-07-15 | Fayette | Illinois | 17051 | 28 | 3 |
335299 | 335299 | 2020-07-15 | Moultrie | Illinois | 17139 | 28 | 0 |
335325 | 335325 | 2020-07-15 | Washington | Illinois | 17189 | 28 | 0 |
332080 | 332080 | 2020-07-14 | Johnson | Illinois | 17087 | 28 | 0 |
332096 | 332096 | 2020-07-14 | Mason | Illinois | 17125 | 28 | 0 |
328893 | 328893 | 2020-07-13 | Johnson | Illinois | 17087 | 28 | 0 |
319369 | 319369 | 2020-07-10 | Mercer | Illinois | 17131 | 28 | 0 |
316195 | 316195 | 2020-07-09 | Menard | Illinois | 17129 | 28 | 0 |
316196 | 316196 | 2020-07-09 | Mercer | Illinois | 17131 | 28 | 0 |
300317 | 300317 | 2020-07-04 | Franklin | Illinois | 17055 | 28 | 0 |
240757 | 240757 | 2020-06-15 | Jersey | Illinois | 17083 | 28 | 1 |
240817 | 240817 | 2020-06-15 | Woodford | Illinois | 17203 | 28 | 2 |
237649 | 237649 | 2020-06-14 | Jersey | Illinois | 17083 | 28 | 1 |
234542 | 234542 | 2020-06-13 | Jersey | Illinois | 17083 | 28 | 1 |
231436 | 231436 | 2020-06-12 | Jersey | Illinois | 17083 | 28 | 1 |
228333 | 228333 | 2020-06-11 | Jersey | Illinois | 17083 | 28 | 1 |
215929 | 215929 | 2020-06-07 | Douglas | Illinois | 17041 | 28 | 0 |
212842 | 212842 | 2020-06-06 | Douglas | Illinois | 17041 | 28 | 0 |
209757 | 209757 | 2020-06-05 | Douglas | Illinois | 17041 | 28 | 0 |
206676 | 206676 | 2020-06-04 | Douglas | Illinois | 17041 | 28 | 0 |
203596 | 203596 | 2020-06-03 | Douglas | Illinois | 17041 | 28 | 0 |
200520 | 200520 | 2020-06-02 | Douglas | Illinois | 17041 | 28 | 0 |
197447 | 197447 | 2020-06-01 | Douglas | Illinois | 17041 | 28 | 0 |
194377 | 194377 | 2020-05-31 | Douglas | Illinois | 17041 | 28 | 0 |
179090 | 179090 | 2020-05-26 | Douglas | Illinois | 17041 | 28 | 0 |
173002 | 173002 | 2020-05-24 | Douglas | Illinois | 17041 | 28 | 0 |
160894 | 160894 | 2020-05-20 | Livingston | Illinois | 17105 | 28 | 1 |
124898 | 124898 | 2020-05-08 | Morgan | Illinois | 17137 | 28 | 1 |
118893 | 118893 | 2020-05-06 | Christian | Illinois | 17021 | 28 | 5 |
115933 | 115933 | 2020-05-05 | Christian | Illinois | 17021 | 28 | 5 |
113050 | 113050 | 2020-05-04 | Christian | Illinois | 17021 | 28 | 5 |
110175 | 110175 | 2020-05-03 | Christian | Illinois | 17021 | 28 | 5 |
110230 | 110230 | 2020-05-03 | Montgomery | Illinois | 17135 | 28 | 0 |
110250 | 110250 | 2020-05-03 | Union | Illinois | 17181 | 28 | 0 |
107305 | 107305 | 2020-05-02 | Christian | Illinois | 17021 | 28 | 5 |
95889 | 95889 | 2020-04-28 | Christian | Illinois | 17021 | 28 | 5 |
95934 | 95934 | 2020-04-28 | Marion | Illinois | 17121 | 28 | 0 |
95974 | 95974 | 2020-04-28 | Williamson | Illinois | 17199 | 28 | 0 |
93057 | 93057 | 2020-04-27 | Christian | Illinois | 17021 | 28 | 5 |
90238 | 90238 | 2020-04-26 | Christian | Illinois | 17021 | 28 | 5 |
90281 | 90281 | 2020-04-26 | Macoupin | Illinois | 17117 | 28 | 0 |
87422 | 87422 | 2020-04-25 | Christian | Illinois | 17021 | 28 | 5 |
87441 | 87441 | 2020-04-25 | Grundy | Illinois | 17063 | 28 | 0 |
87465 | 87465 | 2020-04-25 | Macoupin | Illinois | 17117 | 28 | 0 |
84631 | 84631 | 2020-04-24 | Grundy | Illinois | 17063 | 28 | 0 |
70724 | 70724 | 2020-04-19 | LaSalle | Illinois | 17099 | 28 | 1 |
65201 | 65201 | 2020-04-17 | Henry | Illinois | 17073 | 28 | 0 |
59781 | 59781 | 2020-04-15 | Ogle | Illinois | 17141 | 28 | 1 |
54403 | 54403 | 2020-04-13 | Whiteside | Illinois | 17195 | 28 | 1 |
28976 | 28976 | 2020-04-03 | Winnebago | Illinois | 17201 | 28 | 1 |
26660 | 26660 | 2020-04-02 | Unknown | Illinois | 28 | 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);