ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
298 rows where deaths = 104 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Fayette 46
- Morgan 42
- Stephenson 33
- Lee 24
- Livingston 24
- McDonough 23
- Woodford 21
- Randolph 11
- Bureau 10
- Jackson 8
- Jefferson 8
- Monroe 8
- Coles 5
- Perry 5
- Saline 4
- Champaign 3
- Christian 3
- Montgomery 3
- Iroquois 2
- Kendall 2
- Marion 2
- Tazewell 2
- Fulton 1
- Grundy 1
- Kane 1
- Ogle 1
- Rock Island 1
- St. Clair 1
- Whiteside 1
- Williamson 1
- …
state 1
- Illinois · 298 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500202 | 2500202 | 2022-05-13 | Fayette | Illinois | 17051 | 7155 | 104 |
2496944 | 2496944 | 2022-05-12 | Fayette | Illinois | 17051 | 7151 | 104 |
2493686 | 2493686 | 2022-05-11 | Fayette | Illinois | 17051 | 7150 | 104 |
2493722 | 2493722 | 2022-05-11 | McDonough | Illinois | 17109 | 7291 | 104 |
2490428 | 2490428 | 2022-05-10 | Fayette | Illinois | 17051 | 7146 | 104 |
2490464 | 2490464 | 2022-05-10 | McDonough | Illinois | 17109 | 7281 | 104 |
2487171 | 2487171 | 2022-05-09 | Fayette | Illinois | 17051 | 7142 | 104 |
2487207 | 2487207 | 2022-05-09 | McDonough | Illinois | 17109 | 7276 | 104 |
2483913 | 2483913 | 2022-05-08 | Fayette | Illinois | 17051 | 7137 | 104 |
2483949 | 2483949 | 2022-05-08 | McDonough | Illinois | 17109 | 7274 | 104 |
2480655 | 2480655 | 2022-05-07 | Fayette | Illinois | 17051 | 7137 | 104 |
2480691 | 2480691 | 2022-05-07 | McDonough | Illinois | 17109 | 7274 | 104 |
2477397 | 2477397 | 2022-05-06 | Fayette | Illinois | 17051 | 7137 | 104 |
2477433 | 2477433 | 2022-05-06 | McDonough | Illinois | 17109 | 7274 | 104 |
2474139 | 2474139 | 2022-05-05 | Fayette | Illinois | 17051 | 7137 | 104 |
2474175 | 2474175 | 2022-05-05 | McDonough | Illinois | 17109 | 7272 | 104 |
2470882 | 2470882 | 2022-05-04 | Fayette | Illinois | 17051 | 7130 | 104 |
2470918 | 2470918 | 2022-05-04 | McDonough | Illinois | 17109 | 7262 | 104 |
2467626 | 2467626 | 2022-05-03 | Fayette | Illinois | 17051 | 7126 | 104 |
2467662 | 2467662 | 2022-05-03 | McDonough | Illinois | 17109 | 7260 | 104 |
2464371 | 2464371 | 2022-05-02 | Fayette | Illinois | 17051 | 7126 | 104 |
2464407 | 2464407 | 2022-05-02 | McDonough | Illinois | 17109 | 7256 | 104 |
2461115 | 2461115 | 2022-05-01 | Fayette | Illinois | 17051 | 7123 | 104 |
2461151 | 2461151 | 2022-05-01 | McDonough | Illinois | 17109 | 7251 | 104 |
2457859 | 2457859 | 2022-04-30 | Fayette | Illinois | 17051 | 7123 | 104 |
2457895 | 2457895 | 2022-04-30 | McDonough | Illinois | 17109 | 7251 | 104 |
2454603 | 2454603 | 2022-04-29 | Fayette | Illinois | 17051 | 7123 | 104 |
2454639 | 2454639 | 2022-04-29 | McDonough | Illinois | 17109 | 7251 | 104 |
2451347 | 2451347 | 2022-04-28 | Fayette | Illinois | 17051 | 7120 | 104 |
2451383 | 2451383 | 2022-04-28 | McDonough | Illinois | 17109 | 7242 | 104 |
2448091 | 2448091 | 2022-04-27 | Fayette | Illinois | 17051 | 7119 | 104 |
2448127 | 2448127 | 2022-04-27 | McDonough | Illinois | 17109 | 7240 | 104 |
2444835 | 2444835 | 2022-04-26 | Fayette | Illinois | 17051 | 7118 | 104 |
2444871 | 2444871 | 2022-04-26 | McDonough | Illinois | 17109 | 7239 | 104 |
2441579 | 2441579 | 2022-04-25 | Fayette | Illinois | 17051 | 7114 | 104 |
2441615 | 2441615 | 2022-04-25 | McDonough | Illinois | 17109 | 7229 | 104 |
2438323 | 2438323 | 2022-04-24 | Fayette | Illinois | 17051 | 7107 | 104 |
2438359 | 2438359 | 2022-04-24 | McDonough | Illinois | 17109 | 7224 | 104 |
2435067 | 2435067 | 2022-04-23 | Fayette | Illinois | 17051 | 7107 | 104 |
2435103 | 2435103 | 2022-04-23 | McDonough | Illinois | 17109 | 7224 | 104 |
2431811 | 2431811 | 2022-04-22 | Fayette | Illinois | 17051 | 7107 | 104 |
2431847 | 2431847 | 2022-04-22 | McDonough | Illinois | 17109 | 7224 | 104 |
2428555 | 2428555 | 2022-04-21 | Fayette | Illinois | 17051 | 7103 | 104 |
2428591 | 2428591 | 2022-04-21 | McDonough | Illinois | 17109 | 7218 | 104 |
2425299 | 2425299 | 2022-04-20 | Fayette | Illinois | 17051 | 7100 | 104 |
2425335 | 2425335 | 2022-04-20 | McDonough | Illinois | 17109 | 7208 | 104 |
2422043 | 2422043 | 2022-04-19 | Fayette | Illinois | 17051 | 7096 | 104 |
2422079 | 2422079 | 2022-04-19 | McDonough | Illinois | 17109 | 7203 | 104 |
2418787 | 2418787 | 2022-04-18 | Fayette | Illinois | 17051 | 7095 | 104 |
2415531 | 2415531 | 2022-04-17 | Fayette | Illinois | 17051 | 7092 | 104 |
2412275 | 2412275 | 2022-04-16 | Fayette | Illinois | 17051 | 7092 | 104 |
2409019 | 2409019 | 2022-04-15 | Fayette | Illinois | 17051 | 7092 | 104 |
2405763 | 2405763 | 2022-04-14 | Fayette | Illinois | 17051 | 7089 | 104 |
2402508 | 2402508 | 2022-04-13 | Fayette | Illinois | 17051 | 7089 | 104 |
2399253 | 2399253 | 2022-04-12 | Fayette | Illinois | 17051 | 7087 | 104 |
2395998 | 2395998 | 2022-04-11 | Fayette | Illinois | 17051 | 7087 | 104 |
2392742 | 2392742 | 2022-04-10 | Fayette | Illinois | 17051 | 7087 | 104 |
2389486 | 2389486 | 2022-04-09 | Fayette | Illinois | 17051 | 7087 | 104 |
2386231 | 2386231 | 2022-04-08 | Fayette | Illinois | 17051 | 7087 | 104 |
2382976 | 2382976 | 2022-04-07 | Fayette | Illinois | 17051 | 7087 | 104 |
2379721 | 2379721 | 2022-04-06 | Fayette | Illinois | 17051 | 7086 | 104 |
2376467 | 2376467 | 2022-04-05 | Fayette | Illinois | 17051 | 7083 | 104 |
2373215 | 2373215 | 2022-04-04 | Fayette | Illinois | 17051 | 7083 | 104 |
2369962 | 2369962 | 2022-04-03 | Fayette | Illinois | 17051 | 7082 | 104 |
2366709 | 2366709 | 2022-04-02 | Fayette | Illinois | 17051 | 7082 | 104 |
2363456 | 2363456 | 2022-04-01 | Fayette | Illinois | 17051 | 7082 | 104 |
2360202 | 2360202 | 2022-03-31 | Fayette | Illinois | 17051 | 7081 | 104 |
2356948 | 2356948 | 2022-03-30 | Fayette | Illinois | 17051 | 7083 | 104 |
2353695 | 2353695 | 2022-03-29 | Fayette | Illinois | 17051 | 7082 | 104 |
2262669 | 2262669 | 2022-03-01 | Perry | Illinois | 17145 | 7375 | 104 |
2259418 | 2259418 | 2022-02-28 | Perry | Illinois | 17145 | 7371 | 104 |
2256167 | 2256167 | 2022-02-27 | Perry | Illinois | 17145 | 7357 | 104 |
2252916 | 2252916 | 2022-02-26 | Perry | Illinois | 17145 | 7357 | 104 |
2249665 | 2249665 | 2022-02-25 | Perry | Illinois | 17145 | 7357 | 104 |
2246409 | 2246409 | 2022-02-24 | Montgomery | Illinois | 17135 | 9660 | 104 |
2243158 | 2243158 | 2022-02-23 | Montgomery | Illinois | 17135 | 9640 | 104 |
2239907 | 2239907 | 2022-02-22 | Montgomery | Illinois | 17135 | 9633 | 104 |
2236670 | 2236670 | 2022-02-21 | Saline | Illinois | 17165 | 7685 | 104 |
2233419 | 2233419 | 2022-02-20 | Saline | Illinois | 17165 | 7685 | 104 |
2230168 | 2230168 | 2022-02-19 | Saline | Illinois | 17165 | 7685 | 104 |
2226917 | 2226917 | 2022-02-18 | Saline | Illinois | 17165 | 7685 | 104 |
2152056 | 2152056 | 2022-01-26 | Iroquois | Illinois | 17075 | 6740 | 104 |
2148804 | 2148804 | 2022-01-25 | Iroquois | Illinois | 17075 | 6696 | 104 |
2087000 | 2087000 | 2022-01-06 | Fulton | Illinois | 17057 | 7194 | 104 |
2060972 | 2060972 | 2021-12-29 | Christian | Illinois | 17021 | 6690 | 104 |
2057723 | 2057723 | 2021-12-28 | Christian | Illinois | 17021 | 6645 | 104 |
2057744 | 2057744 | 2021-12-28 | Grundy | Illinois | 17063 | 9596 | 104 |
2054474 | 2054474 | 2021-12-27 | Christian | Illinois | 17021 | 6571 | 104 |
1992756 | 1992756 | 2021-12-08 | Lee | Illinois | 17103 | 5359 | 104 |
1989505 | 1989505 | 2021-12-07 | Lee | Illinois | 17103 | 5316 | 104 |
1986255 | 1986255 | 2021-12-06 | Lee | Illinois | 17103 | 5277 | 104 |
1983005 | 1983005 | 2021-12-05 | Lee | Illinois | 17103 | 5214 | 104 |
1979755 | 1979755 | 2021-12-04 | Lee | Illinois | 17103 | 5214 | 104 |
1976505 | 1976505 | 2021-12-03 | Lee | Illinois | 17103 | 5214 | 104 |
1973256 | 1973256 | 2021-12-02 | Lee | Illinois | 17103 | 5177 | 104 |
1970006 | 1970006 | 2021-12-01 | Lee | Illinois | 17103 | 5148 | 104 |
1970025 | 1970025 | 2021-12-01 | Ogle | Illinois | 17141 | 8614 | 104 |
1966756 | 1966756 | 2021-11-30 | Lee | Illinois | 17103 | 5101 | 104 |
1963504 | 1963504 | 2021-11-29 | Lee | Illinois | 17103 | 5093 | 104 |
1960253 | 1960253 | 2021-11-28 | Lee | Illinois | 17103 | 5058 | 104 |
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);