ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
648 rows where deaths = 34 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Mercer 134
- Bond 94
- Hamilton 73
- Lawrence 65
- Sangamon 43
- Washington 31
- Moultrie 26
- Shelby 15
- Cass 14
- Crawford 9
- Douglas 9
- Massac 9
- Carroll 8
- Union 8
- De Witt 7
- Jo Daviess 7
- Christian 5
- Jefferson 5
- Johnson 5
- Peoria 5
- Edgar 4
- Greene 4
- Hancock 4
- McLean 4
- Stephenson 4
- Williamson 4
- Clark 3
- Jackson 3
- Jersey 3
- Kendall 3
- …
state 1
- Illinois · 648 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500209 | 2500209 | 2022-05-13 | Hamilton | Illinois | 17065 | 2181 | 34 |
2496951 | 2496951 | 2022-05-12 | Hamilton | Illinois | 17065 | 2181 | 34 |
2493693 | 2493693 | 2022-05-11 | Hamilton | Illinois | 17065 | 2181 | 34 |
2490435 | 2490435 | 2022-05-10 | Hamilton | Illinois | 17065 | 2180 | 34 |
2487178 | 2487178 | 2022-05-09 | Hamilton | Illinois | 17065 | 2181 | 34 |
2483920 | 2483920 | 2022-05-08 | Hamilton | Illinois | 17065 | 2180 | 34 |
2480662 | 2480662 | 2022-05-07 | Hamilton | Illinois | 17065 | 2180 | 34 |
2477404 | 2477404 | 2022-05-06 | Hamilton | Illinois | 17065 | 2180 | 34 |
2474146 | 2474146 | 2022-05-05 | Hamilton | Illinois | 17065 | 2181 | 34 |
2470889 | 2470889 | 2022-05-04 | Hamilton | Illinois | 17065 | 2179 | 34 |
2467633 | 2467633 | 2022-05-03 | Hamilton | Illinois | 17065 | 2179 | 34 |
2464378 | 2464378 | 2022-05-02 | Hamilton | Illinois | 17065 | 2179 | 34 |
2461122 | 2461122 | 2022-05-01 | Hamilton | Illinois | 17065 | 2179 | 34 |
2457866 | 2457866 | 2022-04-30 | Hamilton | Illinois | 17065 | 2179 | 34 |
2454610 | 2454610 | 2022-04-29 | Hamilton | Illinois | 17065 | 2179 | 34 |
2451354 | 2451354 | 2022-04-28 | Hamilton | Illinois | 17065 | 2177 | 34 |
2448098 | 2448098 | 2022-04-27 | Hamilton | Illinois | 17065 | 2177 | 34 |
2444842 | 2444842 | 2022-04-26 | Hamilton | Illinois | 17065 | 2179 | 34 |
2441586 | 2441586 | 2022-04-25 | Hamilton | Illinois | 17065 | 2179 | 34 |
2438330 | 2438330 | 2022-04-24 | Hamilton | Illinois | 17065 | 2180 | 34 |
2435074 | 2435074 | 2022-04-23 | Hamilton | Illinois | 17065 | 2180 | 34 |
2431818 | 2431818 | 2022-04-22 | Hamilton | Illinois | 17065 | 2180 | 34 |
2428562 | 2428562 | 2022-04-21 | Hamilton | Illinois | 17065 | 2177 | 34 |
2425306 | 2425306 | 2022-04-20 | Hamilton | Illinois | 17065 | 2176 | 34 |
2422050 | 2422050 | 2022-04-19 | Hamilton | Illinois | 17065 | 2177 | 34 |
2418794 | 2418794 | 2022-04-18 | Hamilton | Illinois | 17065 | 2177 | 34 |
2415538 | 2415538 | 2022-04-17 | Hamilton | Illinois | 17065 | 2177 | 34 |
2412282 | 2412282 | 2022-04-16 | Hamilton | Illinois | 17065 | 2177 | 34 |
2409026 | 2409026 | 2022-04-15 | Hamilton | Illinois | 17065 | 2177 | 34 |
2405770 | 2405770 | 2022-04-14 | Hamilton | Illinois | 17065 | 2178 | 34 |
2402515 | 2402515 | 2022-04-13 | Hamilton | Illinois | 17065 | 2177 | 34 |
2399260 | 2399260 | 2022-04-12 | Hamilton | Illinois | 17065 | 2176 | 34 |
2396005 | 2396005 | 2022-04-11 | Hamilton | Illinois | 17065 | 2178 | 34 |
2392749 | 2392749 | 2022-04-10 | Hamilton | Illinois | 17065 | 2178 | 34 |
2389493 | 2389493 | 2022-04-09 | Hamilton | Illinois | 17065 | 2178 | 34 |
2386238 | 2386238 | 2022-04-08 | Hamilton | Illinois | 17065 | 2178 | 34 |
2382983 | 2382983 | 2022-04-07 | Hamilton | Illinois | 17065 | 2177 | 34 |
2379728 | 2379728 | 2022-04-06 | Hamilton | Illinois | 17065 | 2177 | 34 |
2376474 | 2376474 | 2022-04-05 | Hamilton | Illinois | 17065 | 2175 | 34 |
2373222 | 2373222 | 2022-04-04 | Hamilton | Illinois | 17065 | 2175 | 34 |
2369969 | 2369969 | 2022-04-03 | Hamilton | Illinois | 17065 | 2173 | 34 |
2366716 | 2366716 | 2022-04-02 | Hamilton | Illinois | 17065 | 2173 | 34 |
2363463 | 2363463 | 2022-04-01 | Hamilton | Illinois | 17065 | 2173 | 34 |
2360209 | 2360209 | 2022-03-31 | Hamilton | Illinois | 17065 | 2173 | 34 |
2356955 | 2356955 | 2022-03-30 | Hamilton | Illinois | 17065 | 2173 | 34 |
2353702 | 2353702 | 2022-03-29 | Hamilton | Illinois | 17065 | 2172 | 34 |
2350450 | 2350450 | 2022-03-28 | Hamilton | Illinois | 17065 | 2172 | 34 |
2347197 | 2347197 | 2022-03-27 | Hamilton | Illinois | 17065 | 2172 | 34 |
2343944 | 2343944 | 2022-03-26 | Hamilton | Illinois | 17065 | 2172 | 34 |
2340691 | 2340691 | 2022-03-25 | Hamilton | Illinois | 17065 | 2172 | 34 |
2337438 | 2337438 | 2022-03-24 | Hamilton | Illinois | 17065 | 2171 | 34 |
2334184 | 2334184 | 2022-03-23 | Hamilton | Illinois | 17065 | 2166 | 34 |
2330930 | 2330930 | 2022-03-22 | Hamilton | Illinois | 17065 | 2165 | 34 |
2327678 | 2327678 | 2022-03-21 | Hamilton | Illinois | 17065 | 2165 | 34 |
2324425 | 2324425 | 2022-03-20 | Hamilton | Illinois | 17065 | 2165 | 34 |
2321171 | 2321171 | 2022-03-19 | Hamilton | Illinois | 17065 | 2165 | 34 |
2317917 | 2317917 | 2022-03-18 | Hamilton | Illinois | 17065 | 2165 | 34 |
2314664 | 2314664 | 2022-03-17 | Hamilton | Illinois | 17065 | 2165 | 34 |
2311411 | 2311411 | 2022-03-16 | Hamilton | Illinois | 17065 | 2165 | 34 |
2308158 | 2308158 | 2022-03-15 | Hamilton | Illinois | 17065 | 2165 | 34 |
2304907 | 2304907 | 2022-03-14 | Hamilton | Illinois | 17065 | 2165 | 34 |
2301655 | 2301655 | 2022-03-13 | Hamilton | Illinois | 17065 | 2163 | 34 |
2298403 | 2298403 | 2022-03-12 | Hamilton | Illinois | 17065 | 2163 | 34 |
2295151 | 2295151 | 2022-03-11 | Hamilton | Illinois | 17065 | 2163 | 34 |
2291899 | 2291899 | 2022-03-10 | Hamilton | Illinois | 17065 | 2163 | 34 |
2288647 | 2288647 | 2022-03-09 | Hamilton | Illinois | 17065 | 2163 | 34 |
2285396 | 2285396 | 2022-03-08 | Hamilton | Illinois | 17065 | 2164 | 34 |
2282144 | 2282144 | 2022-03-07 | Hamilton | Illinois | 17065 | 2164 | 34 |
2278891 | 2278891 | 2022-03-06 | Hamilton | Illinois | 17065 | 2162 | 34 |
2275638 | 2275638 | 2022-03-05 | Hamilton | Illinois | 17065 | 2162 | 34 |
2272385 | 2272385 | 2022-03-04 | Hamilton | Illinois | 17065 | 2162 | 34 |
2269133 | 2269133 | 2022-03-03 | Hamilton | Illinois | 17065 | 2163 | 34 |
2265880 | 2265880 | 2022-03-02 | Hamilton | Illinois | 17065 | 2163 | 34 |
2210582 | 2210582 | 2022-02-13 | Bond | Illinois | 17005 | 4245 | 34 |
2207329 | 2207329 | 2022-02-12 | Bond | Illinois | 17005 | 4245 | 34 |
2204076 | 2204076 | 2022-02-11 | Bond | Illinois | 17005 | 4245 | 34 |
2200823 | 2200823 | 2022-02-10 | Bond | Illinois | 17005 | 4245 | 34 |
2197569 | 2197569 | 2022-02-09 | Bond | Illinois | 17005 | 4241 | 34 |
2194315 | 2194315 | 2022-02-08 | Bond | Illinois | 17005 | 4226 | 34 |
2191061 | 2191061 | 2022-02-07 | Bond | Illinois | 17005 | 4212 | 34 |
2187808 | 2187808 | 2022-02-06 | Bond | Illinois | 17005 | 4196 | 34 |
2184555 | 2184555 | 2022-02-05 | Bond | Illinois | 17005 | 4196 | 34 |
2181303 | 2181303 | 2022-02-04 | Bond | Illinois | 17005 | 4196 | 34 |
2178052 | 2178052 | 2022-02-03 | Bond | Illinois | 17005 | 4162 | 34 |
2174799 | 2174799 | 2022-02-02 | Bond | Illinois | 17005 | 4162 | 34 |
2171546 | 2171546 | 2022-02-01 | Bond | Illinois | 17005 | 4155 | 34 |
2168293 | 2168293 | 2022-01-31 | Bond | Illinois | 17005 | 4129 | 34 |
2165038 | 2165038 | 2022-01-30 | Bond | Illinois | 17005 | 4097 | 34 |
2161783 | 2161783 | 2022-01-29 | Bond | Illinois | 17005 | 4097 | 34 |
2158528 | 2158528 | 2022-01-28 | Bond | Illinois | 17005 | 4097 | 34 |
2155274 | 2155274 | 2022-01-27 | Bond | Illinois | 17005 | 4072 | 34 |
2152021 | 2152021 | 2022-01-26 | Bond | Illinois | 17005 | 4048 | 34 |
2148769 | 2148769 | 2022-01-25 | Bond | Illinois | 17005 | 4020 | 34 |
2145517 | 2145517 | 2022-01-24 | Bond | Illinois | 17005 | 3964 | 34 |
2142262 | 2142262 | 2022-01-23 | Bond | Illinois | 17005 | 3900 | 34 |
2139007 | 2139007 | 2022-01-22 | Bond | Illinois | 17005 | 3900 | 34 |
2135751 | 2135751 | 2022-01-21 | Bond | Illinois | 17005 | 3900 | 34 |
2132499 | 2132499 | 2022-01-20 | Bond | Illinois | 17005 | 3868 | 34 |
2129246 | 2129246 | 2022-01-19 | Bond | Illinois | 17005 | 3836 | 34 |
2125992 | 2125992 | 2022-01-18 | Bond | Illinois | 17005 | 3741 | 34 |
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);