ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
210 rows where deaths = 127 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 29
county 29
- Monroe 51
- Boone 20
- Kendall 17
- DeKalb 14
- Randolph 12
- Fulton 11
- Franklin 10
- Jefferson 10
- Livingston 10
- Bureau 8
- Williamson 7
- Effingham 6
- Marion 5
- Ogle 5
- Champaign 3
- Coles 3
- Henry 3
- Jackson 3
- Grundy 2
- Adams 1
- Christian 1
- DuPage 1
- Kankakee 1
- Knox 1
- LaSalle 1
- McHenry 1
- Rock Island 1
- Vermilion 1
- Winnebago 1
state 1
- Illinois · 210 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464412 | 2464412 | 2022-05-02 | Monroe | Illinois | 17133 | 9558 | 127 |
2461156 | 2461156 | 2022-05-01 | Monroe | Illinois | 17133 | 9545 | 127 |
2457900 | 2457900 | 2022-04-30 | Monroe | Illinois | 17133 | 9545 | 127 |
2454644 | 2454644 | 2022-04-29 | Monroe | Illinois | 17133 | 9545 | 127 |
2451388 | 2451388 | 2022-04-28 | Monroe | Illinois | 17133 | 9543 | 127 |
2448132 | 2448132 | 2022-04-27 | Monroe | Illinois | 17133 | 9533 | 127 |
2444876 | 2444876 | 2022-04-26 | Monroe | Illinois | 17133 | 9528 | 127 |
2441620 | 2441620 | 2022-04-25 | Monroe | Illinois | 17133 | 9526 | 127 |
2438364 | 2438364 | 2022-04-24 | Monroe | Illinois | 17133 | 9518 | 127 |
2435108 | 2435108 | 2022-04-23 | Monroe | Illinois | 17133 | 9518 | 127 |
2431852 | 2431852 | 2022-04-22 | Monroe | Illinois | 17133 | 9518 | 127 |
2428596 | 2428596 | 2022-04-21 | Monroe | Illinois | 17133 | 9512 | 127 |
2425340 | 2425340 | 2022-04-20 | Monroe | Illinois | 17133 | 9507 | 127 |
2422084 | 2422084 | 2022-04-19 | Monroe | Illinois | 17133 | 9504 | 127 |
2418828 | 2418828 | 2022-04-18 | Monroe | Illinois | 17133 | 9498 | 127 |
2415572 | 2415572 | 2022-04-17 | Monroe | Illinois | 17133 | 9496 | 127 |
2412316 | 2412316 | 2022-04-16 | Monroe | Illinois | 17133 | 9496 | 127 |
2409060 | 2409060 | 2022-04-15 | Monroe | Illinois | 17133 | 9496 | 127 |
2405804 | 2405804 | 2022-04-14 | Monroe | Illinois | 17133 | 9492 | 127 |
2402549 | 2402549 | 2022-04-13 | Monroe | Illinois | 17133 | 9489 | 127 |
2399294 | 2399294 | 2022-04-12 | Monroe | Illinois | 17133 | 9489 | 127 |
2396039 | 2396039 | 2022-04-11 | Monroe | Illinois | 17133 | 9487 | 127 |
2392783 | 2392783 | 2022-04-10 | Monroe | Illinois | 17133 | 9486 | 127 |
2389527 | 2389527 | 2022-04-09 | Monroe | Illinois | 17133 | 9486 | 127 |
2386272 | 2386272 | 2022-04-08 | Monroe | Illinois | 17133 | 9486 | 127 |
2383017 | 2383017 | 2022-04-07 | Monroe | Illinois | 17133 | 9482 | 127 |
2379762 | 2379762 | 2022-04-06 | Monroe | Illinois | 17133 | 9481 | 127 |
2376508 | 2376508 | 2022-04-05 | Monroe | Illinois | 17133 | 9479 | 127 |
2373256 | 2373256 | 2022-04-04 | Monroe | Illinois | 17133 | 9473 | 127 |
2370003 | 2370003 | 2022-04-03 | Monroe | Illinois | 17133 | 9467 | 127 |
2366750 | 2366750 | 2022-04-02 | Monroe | Illinois | 17133 | 9467 | 127 |
2363497 | 2363497 | 2022-04-01 | Monroe | Illinois | 17133 | 9467 | 127 |
2360243 | 2360243 | 2022-03-31 | Monroe | Illinois | 17133 | 9465 | 127 |
2356989 | 2356989 | 2022-03-30 | Monroe | Illinois | 17133 | 9463 | 127 |
2353736 | 2353736 | 2022-03-29 | Monroe | Illinois | 17133 | 9455 | 127 |
2350484 | 2350484 | 2022-03-28 | Monroe | Illinois | 17133 | 9451 | 127 |
2347231 | 2347231 | 2022-03-27 | Monroe | Illinois | 17133 | 9451 | 127 |
2343978 | 2343978 | 2022-03-26 | Monroe | Illinois | 17133 | 9451 | 127 |
2340725 | 2340725 | 2022-03-25 | Monroe | Illinois | 17133 | 9451 | 127 |
2337472 | 2337472 | 2022-03-24 | Monroe | Illinois | 17133 | 9451 | 127 |
2334218 | 2334218 | 2022-03-23 | Monroe | Illinois | 17133 | 9449 | 127 |
2330901 | 2330901 | 2022-03-22 | Boone | Illinois | 17007 | 13761 | 127 |
2330964 | 2330964 | 2022-03-22 | Monroe | Illinois | 17133 | 9446 | 127 |
2327649 | 2327649 | 2022-03-21 | Boone | Illinois | 17007 | 13758 | 127 |
2327712 | 2327712 | 2022-03-21 | Monroe | Illinois | 17133 | 9440 | 127 |
2324396 | 2324396 | 2022-03-20 | Boone | Illinois | 17007 | 13748 | 127 |
2324459 | 2324459 | 2022-03-20 | Monroe | Illinois | 17133 | 9436 | 127 |
2321142 | 2321142 | 2022-03-19 | Boone | Illinois | 17007 | 13748 | 127 |
2321205 | 2321205 | 2022-03-19 | Monroe | Illinois | 17133 | 9436 | 127 |
2317888 | 2317888 | 2022-03-18 | Boone | Illinois | 17007 | 13748 | 127 |
2317951 | 2317951 | 2022-03-18 | Monroe | Illinois | 17133 | 9436 | 127 |
2314635 | 2314635 | 2022-03-17 | Boone | Illinois | 17007 | 13746 | 127 |
2314698 | 2314698 | 2022-03-17 | Monroe | Illinois | 17133 | 9431 | 127 |
2311382 | 2311382 | 2022-03-16 | Boone | Illinois | 17007 | 13738 | 127 |
2311445 | 2311445 | 2022-03-16 | Monroe | Illinois | 17133 | 9448 | 127 |
2308129 | 2308129 | 2022-03-15 | Boone | Illinois | 17007 | 13733 | 127 |
2308192 | 2308192 | 2022-03-15 | Monroe | Illinois | 17133 | 9447 | 127 |
2304878 | 2304878 | 2022-03-14 | Boone | Illinois | 17007 | 13732 | 127 |
2304941 | 2304941 | 2022-03-14 | Monroe | Illinois | 17133 | 9445 | 127 |
2301626 | 2301626 | 2022-03-13 | Boone | Illinois | 17007 | 13727 | 127 |
2298374 | 2298374 | 2022-03-12 | Boone | Illinois | 17007 | 13727 | 127 |
2295122 | 2295122 | 2022-03-11 | Boone | Illinois | 17007 | 13727 | 127 |
2291870 | 2291870 | 2022-03-10 | Boone | Illinois | 17007 | 13721 | 127 |
2288618 | 2288618 | 2022-03-09 | Boone | Illinois | 17007 | 13715 | 127 |
2285367 | 2285367 | 2022-03-08 | Boone | Illinois | 17007 | 13708 | 127 |
2285442 | 2285442 | 2022-03-08 | Randolph | Illinois | 17157 | 10394 | 127 |
2282115 | 2282115 | 2022-03-07 | Boone | Illinois | 17007 | 13703 | 127 |
2282190 | 2282190 | 2022-03-07 | Randolph | Illinois | 17157 | 10395 | 127 |
2278862 | 2278862 | 2022-03-06 | Boone | Illinois | 17007 | 13690 | 127 |
2278937 | 2278937 | 2022-03-06 | Randolph | Illinois | 17157 | 10389 | 127 |
2275609 | 2275609 | 2022-03-05 | Boone | Illinois | 17007 | 13690 | 127 |
2275684 | 2275684 | 2022-03-05 | Randolph | Illinois | 17157 | 10389 | 127 |
2272356 | 2272356 | 2022-03-04 | Boone | Illinois | 17007 | 13690 | 127 |
2272431 | 2272431 | 2022-03-04 | Randolph | Illinois | 17157 | 10389 | 127 |
2269104 | 2269104 | 2022-03-03 | Boone | Illinois | 17007 | 13683 | 127 |
2269179 | 2269179 | 2022-03-03 | Randolph | Illinois | 17157 | 10390 | 127 |
2265886 | 2265886 | 2022-03-02 | Jackson | Illinois | 17077 | 15408 | 127 |
2265926 | 2265926 | 2022-03-02 | Randolph | Illinois | 17157 | 10394 | 127 |
2262635 | 2262635 | 2022-03-01 | Jackson | Illinois | 17077 | 15399 | 127 |
2262675 | 2262675 | 2022-03-01 | Randolph | Illinois | 17157 | 10385 | 127 |
2259384 | 2259384 | 2022-02-28 | Jackson | Illinois | 17077 | 15388 | 127 |
2259424 | 2259424 | 2022-02-28 | Randolph | Illinois | 17157 | 10382 | 127 |
2256123 | 2256123 | 2022-02-27 | Fulton | Illinois | 17057 | 9914 | 127 |
2256173 | 2256173 | 2022-02-27 | Randolph | Illinois | 17157 | 10390 | 127 |
2252872 | 2252872 | 2022-02-26 | Fulton | Illinois | 17057 | 9914 | 127 |
2252922 | 2252922 | 2022-02-26 | Randolph | Illinois | 17157 | 10390 | 127 |
2249621 | 2249621 | 2022-02-25 | Fulton | Illinois | 17057 | 9914 | 127 |
2249671 | 2249671 | 2022-02-25 | Randolph | Illinois | 17157 | 10390 | 127 |
2246352 | 2246352 | 2022-02-24 | Christian | Illinois | 17021 | 10006 | 127 |
2246370 | 2246370 | 2022-02-24 | Fulton | Illinois | 17057 | 9900 | 127 |
2243119 | 2243119 | 2022-02-23 | Fulton | Illinois | 17057 | 9891 | 127 |
2239868 | 2239868 | 2022-02-22 | Fulton | Illinois | 17057 | 9881 | 127 |
2236617 | 2236617 | 2022-02-21 | Fulton | Illinois | 17057 | 9859 | 127 |
2233366 | 2233366 | 2022-02-20 | Fulton | Illinois | 17057 | 9859 | 127 |
2230115 | 2230115 | 2022-02-19 | Fulton | Illinois | 17057 | 9859 | 127 |
2226864 | 2226864 | 2022-02-18 | Fulton | Illinois | 17057 | 9859 | 127 |
2223613 | 2223613 | 2022-02-17 | Fulton | Illinois | 17057 | 9857 | 127 |
2217149 | 2217149 | 2022-02-15 | Monroe | Illinois | 17133 | 9300 | 127 |
2171575 | 2171575 | 2022-02-01 | Grundy | Illinois | 17063 | 12195 | 127 |
2168322 | 2168322 | 2022-01-31 | Grundy | Illinois | 17063 | 12170 | 127 |
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);