ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
211 rows where deaths = 144 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500245 | 2500245 | 2022-05-13 | Morgan | Illinois | 17137 | 9661 | 144 |
2496987 | 2496987 | 2022-05-12 | Morgan | Illinois | 17137 | 9652 | 144 |
2493729 | 2493729 | 2022-05-11 | Morgan | Illinois | 17137 | 9642 | 144 |
2490471 | 2490471 | 2022-05-10 | Morgan | Illinois | 17137 | 9635 | 144 |
2487214 | 2487214 | 2022-05-09 | Morgan | Illinois | 17137 | 9629 | 144 |
2483956 | 2483956 | 2022-05-08 | Morgan | Illinois | 17137 | 9612 | 144 |
2480698 | 2480698 | 2022-05-07 | Morgan | Illinois | 17137 | 9612 | 144 |
2477440 | 2477440 | 2022-05-06 | Morgan | Illinois | 17137 | 9612 | 144 |
2474182 | 2474182 | 2022-05-05 | Morgan | Illinois | 17137 | 9599 | 144 |
2470925 | 2470925 | 2022-05-04 | Morgan | Illinois | 17137 | 9596 | 144 |
2467669 | 2467669 | 2022-05-03 | Morgan | Illinois | 17137 | 9586 | 144 |
2464414 | 2464414 | 2022-05-02 | Morgan | Illinois | 17137 | 9580 | 144 |
2461158 | 2461158 | 2022-05-01 | Morgan | Illinois | 17137 | 9565 | 144 |
2457902 | 2457902 | 2022-04-30 | Morgan | Illinois | 17137 | 9565 | 144 |
2454646 | 2454646 | 2022-04-29 | Morgan | Illinois | 17137 | 9565 | 144 |
2451390 | 2451390 | 2022-04-28 | Morgan | Illinois | 17137 | 9561 | 144 |
2448134 | 2448134 | 2022-04-27 | Morgan | Illinois | 17137 | 9546 | 144 |
2444878 | 2444878 | 2022-04-26 | Morgan | Illinois | 17137 | 9532 | 144 |
2441622 | 2441622 | 2022-04-25 | Morgan | Illinois | 17137 | 9529 | 144 |
2438366 | 2438366 | 2022-04-24 | Morgan | Illinois | 17137 | 9524 | 144 |
2435110 | 2435110 | 2022-04-23 | Morgan | Illinois | 17137 | 9524 | 144 |
2431854 | 2431854 | 2022-04-22 | Morgan | Illinois | 17137 | 9524 | 144 |
2428598 | 2428598 | 2022-04-21 | Morgan | Illinois | 17137 | 9518 | 144 |
2425342 | 2425342 | 2022-04-20 | Morgan | Illinois | 17137 | 9513 | 144 |
2422086 | 2422086 | 2022-04-19 | Morgan | Illinois | 17137 | 9508 | 144 |
2418830 | 2418830 | 2022-04-18 | Morgan | Illinois | 17137 | 9508 | 144 |
2415574 | 2415574 | 2022-04-17 | Morgan | Illinois | 17137 | 9500 | 144 |
2412318 | 2412318 | 2022-04-16 | Morgan | Illinois | 17137 | 9500 | 144 |
2409062 | 2409062 | 2022-04-15 | Morgan | Illinois | 17137 | 9500 | 144 |
2405806 | 2405806 | 2022-04-14 | Morgan | Illinois | 17137 | 9499 | 144 |
2402551 | 2402551 | 2022-04-13 | Morgan | Illinois | 17137 | 9497 | 144 |
2399296 | 2399296 | 2022-04-12 | Morgan | Illinois | 17137 | 9496 | 144 |
2396041 | 2396041 | 2022-04-11 | Morgan | Illinois | 17137 | 9495 | 144 |
2392785 | 2392785 | 2022-04-10 | Morgan | Illinois | 17137 | 9494 | 144 |
2389529 | 2389529 | 2022-04-09 | Morgan | Illinois | 17137 | 9494 | 144 |
2386274 | 2386274 | 2022-04-08 | Morgan | Illinois | 17137 | 9494 | 144 |
2383019 | 2383019 | 2022-04-07 | Morgan | Illinois | 17137 | 9489 | 144 |
2379764 | 2379764 | 2022-04-06 | Morgan | Illinois | 17137 | 9489 | 144 |
2376510 | 2376510 | 2022-04-05 | Morgan | Illinois | 17137 | 9467 | 144 |
2373258 | 2373258 | 2022-04-04 | Morgan | Illinois | 17137 | 9458 | 144 |
2370005 | 2370005 | 2022-04-03 | Morgan | Illinois | 17137 | 9455 | 144 |
2366752 | 2366752 | 2022-04-02 | Morgan | Illinois | 17137 | 9455 | 144 |
2363499 | 2363499 | 2022-04-01 | Morgan | Illinois | 17137 | 9455 | 144 |
2360245 | 2360245 | 2022-03-31 | Morgan | Illinois | 17137 | 9452 | 144 |
2356991 | 2356991 | 2022-03-30 | Morgan | Illinois | 17137 | 9451 | 144 |
2353738 | 2353738 | 2022-03-29 | Morgan | Illinois | 17137 | 9446 | 144 |
2350486 | 2350486 | 2022-03-28 | Morgan | Illinois | 17137 | 9444 | 144 |
2347233 | 2347233 | 2022-03-27 | Morgan | Illinois | 17137 | 9437 | 144 |
2343980 | 2343980 | 2022-03-26 | Morgan | Illinois | 17137 | 9437 | 144 |
2340727 | 2340727 | 2022-03-25 | Morgan | Illinois | 17137 | 9437 | 144 |
2337474 | 2337474 | 2022-03-24 | Morgan | Illinois | 17137 | 9434 | 144 |
2334220 | 2334220 | 2022-03-23 | Morgan | Illinois | 17137 | 9431 | 144 |
2330966 | 2330966 | 2022-03-22 | Morgan | Illinois | 17137 | 9429 | 144 |
2327714 | 2327714 | 2022-03-21 | Morgan | Illinois | 17137 | 9427 | 144 |
2324461 | 2324461 | 2022-03-20 | Morgan | Illinois | 17137 | 9423 | 144 |
2321207 | 2321207 | 2022-03-19 | Morgan | Illinois | 17137 | 9423 | 144 |
2317953 | 2317953 | 2022-03-18 | Morgan | Illinois | 17137 | 9423 | 144 |
2314700 | 2314700 | 2022-03-17 | Morgan | Illinois | 17137 | 9417 | 144 |
2311403 | 2311403 | 2022-03-16 | Effingham | Illinois | 17049 | 10589 | 144 |
2311447 | 2311447 | 2022-03-16 | Morgan | Illinois | 17137 | 9412 | 144 |
2308150 | 2308150 | 2022-03-15 | Effingham | Illinois | 17049 | 10588 | 144 |
2308194 | 2308194 | 2022-03-15 | Morgan | Illinois | 17137 | 9408 | 144 |
2304899 | 2304899 | 2022-03-14 | Effingham | Illinois | 17049 | 10588 | 144 |
2304943 | 2304943 | 2022-03-14 | Morgan | Illinois | 17137 | 9399 | 144 |
2301647 | 2301647 | 2022-03-13 | Effingham | Illinois | 17049 | 10583 | 144 |
2301691 | 2301691 | 2022-03-13 | Morgan | Illinois | 17137 | 9398 | 144 |
2298395 | 2298395 | 2022-03-12 | Effingham | Illinois | 17049 | 10583 | 144 |
2298439 | 2298439 | 2022-03-12 | Morgan | Illinois | 17137 | 9398 | 144 |
2295143 | 2295143 | 2022-03-11 | Effingham | Illinois | 17049 | 10583 | 144 |
2295187 | 2295187 | 2022-03-11 | Morgan | Illinois | 17137 | 9398 | 144 |
2291891 | 2291891 | 2022-03-10 | Effingham | Illinois | 17049 | 10581 | 144 |
2291935 | 2291935 | 2022-03-10 | Morgan | Illinois | 17137 | 9397 | 144 |
2288639 | 2288639 | 2022-03-09 | Effingham | Illinois | 17049 | 10578 | 144 |
2288683 | 2288683 | 2022-03-09 | Morgan | Illinois | 17137 | 9391 | 144 |
2285388 | 2285388 | 2022-03-08 | Effingham | Illinois | 17049 | 10576 | 144 |
2285432 | 2285432 | 2022-03-08 | Morgan | Illinois | 17137 | 9386 | 144 |
2282180 | 2282180 | 2022-03-07 | Morgan | Illinois | 17137 | 9384 | 144 |
2278927 | 2278927 | 2022-03-06 | Morgan | Illinois | 17137 | 9378 | 144 |
2275674 | 2275674 | 2022-03-05 | Morgan | Illinois | 17137 | 9378 | 144 |
2272421 | 2272421 | 2022-03-04 | Morgan | Illinois | 17137 | 9378 | 144 |
2269169 | 2269169 | 2022-03-03 | Morgan | Illinois | 17137 | 9369 | 144 |
2265916 | 2265916 | 2022-03-02 | Morgan | Illinois | 17137 | 9368 | 144 |
2262665 | 2262665 | 2022-03-01 | Morgan | Illinois | 17137 | 9366 | 144 |
2259414 | 2259414 | 2022-02-28 | Morgan | Illinois | 17137 | 9360 | 144 |
2223621 | 2223621 | 2022-02-17 | Henry | Illinois | 17073 | 12439 | 144 |
2223637 | 2223637 | 2022-02-17 | Livingston | Illinois | 17105 | 10536 | 144 |
2220386 | 2220386 | 2022-02-16 | Livingston | Illinois | 17105 | 10525 | 144 |
2217135 | 2217135 | 2022-02-15 | Livingston | Illinois | 17105 | 10505 | 144 |
2213884 | 2213884 | 2022-02-14 | Livingston | Illinois | 17105 | 10500 | 144 |
2126036 | 2126036 | 2022-01-18 | Kendall | Illinois | 17093 | 27089 | 144 |
2080556 | 2080556 | 2022-01-04 | Stephenson | Illinois | 17177 | 8499 | 144 |
2077304 | 2077304 | 2022-01-03 | Stephenson | Illinois | 17177 | 8471 | 144 |
2038229 | 2038229 | 2021-12-22 | Coles | Illinois | 17029 | 9405 | 144 |
2034979 | 2034979 | 2021-12-21 | Coles | Illinois | 17029 | 9368 | 144 |
2031729 | 2031729 | 2021-12-20 | Coles | Illinois | 17029 | 9331 | 144 |
2028478 | 2028478 | 2021-12-19 | Coles | Illinois | 17029 | 9262 | 144 |
2025227 | 2025227 | 2021-12-18 | Coles | Illinois | 17029 | 9262 | 144 |
2021976 | 2021976 | 2021-12-17 | Coles | Illinois | 17029 | 9262 | 144 |
2018725 | 2018725 | 2021-12-16 | Coles | Illinois | 17029 | 9217 | 144 |
2015475 | 2015475 | 2021-12-15 | Coles | Illinois | 17029 | 9173 | 144 |
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);