ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
422 rows where deaths = 59 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 |
---|---|---|---|---|---|---|---|
2500274 | 2500274 | 2022-05-13 | White | Illinois | 17193 | 4413 | 59 |
2497016 | 2497016 | 2022-05-12 | White | Illinois | 17193 | 4413 | 59 |
2493758 | 2493758 | 2022-05-11 | White | Illinois | 17193 | 4413 | 59 |
2490500 | 2490500 | 2022-05-10 | White | Illinois | 17193 | 4413 | 59 |
2487243 | 2487243 | 2022-05-09 | White | Illinois | 17193 | 4412 | 59 |
2483985 | 2483985 | 2022-05-08 | White | Illinois | 17193 | 4411 | 59 |
2480727 | 2480727 | 2022-05-07 | White | Illinois | 17193 | 4411 | 59 |
2477469 | 2477469 | 2022-05-06 | White | Illinois | 17193 | 4411 | 59 |
2474211 | 2474211 | 2022-05-05 | White | Illinois | 17193 | 4411 | 59 |
2470954 | 2470954 | 2022-05-04 | White | Illinois | 17193 | 4410 | 59 |
2467698 | 2467698 | 2022-05-03 | White | Illinois | 17193 | 4408 | 59 |
2464443 | 2464443 | 2022-05-02 | White | Illinois | 17193 | 4407 | 59 |
2461187 | 2461187 | 2022-05-01 | White | Illinois | 17193 | 4405 | 59 |
2457931 | 2457931 | 2022-04-30 | White | Illinois | 17193 | 4405 | 59 |
2454675 | 2454675 | 2022-04-29 | White | Illinois | 17193 | 4405 | 59 |
2451419 | 2451419 | 2022-04-28 | White | Illinois | 17193 | 4405 | 59 |
2448163 | 2448163 | 2022-04-27 | White | Illinois | 17193 | 4404 | 59 |
2444907 | 2444907 | 2022-04-26 | White | Illinois | 17193 | 4403 | 59 |
2441651 | 2441651 | 2022-04-25 | White | Illinois | 17193 | 4402 | 59 |
2438395 | 2438395 | 2022-04-24 | White | Illinois | 17193 | 4402 | 59 |
2435139 | 2435139 | 2022-04-23 | White | Illinois | 17193 | 4402 | 59 |
2431883 | 2431883 | 2022-04-22 | White | Illinois | 17193 | 4402 | 59 |
2428627 | 2428627 | 2022-04-21 | White | Illinois | 17193 | 4403 | 59 |
2425371 | 2425371 | 2022-04-20 | White | Illinois | 17193 | 4403 | 59 |
2422115 | 2422115 | 2022-04-19 | White | Illinois | 17193 | 4403 | 59 |
2418859 | 2418859 | 2022-04-18 | White | Illinois | 17193 | 4403 | 59 |
2415603 | 2415603 | 2022-04-17 | White | Illinois | 17193 | 4403 | 59 |
2412347 | 2412347 | 2022-04-16 | White | Illinois | 17193 | 4403 | 59 |
2409091 | 2409091 | 2022-04-15 | White | Illinois | 17193 | 4403 | 59 |
2405835 | 2405835 | 2022-04-14 | White | Illinois | 17193 | 4404 | 59 |
2402580 | 2402580 | 2022-04-13 | White | Illinois | 17193 | 4403 | 59 |
2399325 | 2399325 | 2022-04-12 | White | Illinois | 17193 | 4406 | 59 |
2396070 | 2396070 | 2022-04-11 | White | Illinois | 17193 | 4406 | 59 |
2392814 | 2392814 | 2022-04-10 | White | Illinois | 17193 | 4405 | 59 |
2389558 | 2389558 | 2022-04-09 | White | Illinois | 17193 | 4405 | 59 |
2386303 | 2386303 | 2022-04-08 | White | Illinois | 17193 | 4405 | 59 |
2282132 | 2282132 | 2022-03-07 | Douglas | Illinois | 17041 | 6431 | 59 |
2278875 | 2278875 | 2022-03-06 | Crawford | Illinois | 17033 | 6157 | 59 |
2278879 | 2278879 | 2022-03-06 | Douglas | Illinois | 17041 | 6431 | 59 |
2275622 | 2275622 | 2022-03-05 | Crawford | Illinois | 17033 | 6157 | 59 |
2275626 | 2275626 | 2022-03-05 | Douglas | Illinois | 17041 | 6431 | 59 |
2272369 | 2272369 | 2022-03-04 | Crawford | Illinois | 17033 | 6157 | 59 |
2272373 | 2272373 | 2022-03-04 | Douglas | Illinois | 17041 | 6431 | 59 |
2269121 | 2269121 | 2022-03-03 | Douglas | Illinois | 17041 | 6429 | 59 |
2265868 | 2265868 | 2022-03-02 | Douglas | Illinois | 17041 | 6429 | 59 |
2262608 | 2262608 | 2022-03-01 | Clark | Illinois | 17023 | 4800 | 59 |
2262617 | 2262617 | 2022-03-01 | Douglas | Illinois | 17041 | 6427 | 59 |
2259357 | 2259357 | 2022-02-28 | Clark | Illinois | 17023 | 4800 | 59 |
2259366 | 2259366 | 2022-02-28 | Douglas | Illinois | 17041 | 6427 | 59 |
2256106 | 2256106 | 2022-02-27 | Clark | Illinois | 17023 | 4796 | 59 |
2252855 | 2252855 | 2022-02-26 | Clark | Illinois | 17023 | 4796 | 59 |
2249604 | 2249604 | 2022-02-25 | Clark | Illinois | 17023 | 4796 | 59 |
2171603 | 2171603 | 2022-02-01 | Mason | Illinois | 17125 | 3706 | 59 |
2168350 | 2168350 | 2022-01-31 | Mason | Illinois | 17125 | 3692 | 59 |
2165095 | 2165095 | 2022-01-30 | Mason | Illinois | 17125 | 3670 | 59 |
2161840 | 2161840 | 2022-01-29 | Mason | Illinois | 17125 | 3670 | 59 |
2158585 | 2158585 | 2022-01-28 | Mason | Illinois | 17125 | 3670 | 59 |
2096817 | 2096817 | 2022-01-09 | Union | Illinois | 17181 | 3844 | 59 |
2093565 | 2093565 | 2022-01-08 | Union | Illinois | 17181 | 3844 | 59 |
2090313 | 2090313 | 2022-01-07 | Union | Illinois | 17181 | 3844 | 59 |
2074050 | 2074050 | 2022-01-02 | Shelby | Illinois | 17173 | 4420 | 59 |
2070799 | 2070799 | 2022-01-01 | Shelby | Illinois | 17173 | 4420 | 59 |
2067548 | 2067548 | 2021-12-31 | Shelby | Illinois | 17173 | 4420 | 59 |
2064297 | 2064297 | 2021-12-30 | Shelby | Illinois | 17173 | 4420 | 59 |
2054524 | 2054524 | 2021-12-27 | Massac | Illinois | 17127 | 2593 | 59 |
2051274 | 2051274 | 2021-12-26 | Massac | Illinois | 17127 | 2565 | 59 |
2048024 | 2048024 | 2021-12-25 | Massac | Illinois | 17127 | 2565 | 59 |
2044774 | 2044774 | 2021-12-24 | Massac | Illinois | 17127 | 2565 | 59 |
2041525 | 2041525 | 2021-12-23 | Massac | Illinois | 17127 | 2565 | 59 |
2038275 | 2038275 | 2021-12-22 | Massac | Illinois | 17127 | 2552 | 59 |
2035025 | 2035025 | 2021-12-21 | Massac | Illinois | 17127 | 2534 | 59 |
2031775 | 2031775 | 2021-12-20 | Massac | Illinois | 17127 | 2516 | 59 |
2028524 | 2028524 | 2021-12-19 | Massac | Illinois | 17127 | 2496 | 59 |
2025273 | 2025273 | 2021-12-18 | Massac | Illinois | 17127 | 2496 | 59 |
2022022 | 2022022 | 2021-12-17 | Massac | Illinois | 17127 | 2496 | 59 |
2018771 | 2018771 | 2021-12-16 | Massac | Illinois | 17127 | 2483 | 59 |
2015521 | 2015521 | 2021-12-15 | Massac | Illinois | 17127 | 2479 | 59 |
2012222 | 2012222 | 2021-12-14 | Clay | Illinois | 17025 | 3111 | 59 |
2012270 | 2012270 | 2021-12-14 | Massac | Illinois | 17127 | 2456 | 59 |
2008971 | 2008971 | 2021-12-13 | Clay | Illinois | 17025 | 3080 | 59 |
2009019 | 2009019 | 2021-12-13 | Massac | Illinois | 17127 | 2443 | 59 |
2005720 | 2005720 | 2021-12-12 | Clay | Illinois | 17025 | 3051 | 59 |
2002469 | 2002469 | 2021-12-11 | Clay | Illinois | 17025 | 3051 | 59 |
1999219 | 1999219 | 2021-12-10 | Clay | Illinois | 17025 | 3051 | 59 |
1995968 | 1995968 | 2021-12-09 | Clay | Illinois | 17025 | 3028 | 59 |
1992717 | 1992717 | 2021-12-08 | Clay | Illinois | 17025 | 3010 | 59 |
1989466 | 1989466 | 2021-12-07 | Clay | Illinois | 17025 | 2991 | 59 |
1986216 | 1986216 | 2021-12-06 | Clay | Illinois | 17025 | 2962 | 59 |
1982966 | 1982966 | 2021-12-05 | Clay | Illinois | 17025 | 2930 | 59 |
1979716 | 1979716 | 2021-12-04 | Clay | Illinois | 17025 | 2930 | 59 |
1976466 | 1976466 | 2021-12-03 | Clay | Illinois | 17025 | 2930 | 59 |
1973217 | 1973217 | 2021-12-02 | Clay | Illinois | 17025 | 2916 | 59 |
1969967 | 1969967 | 2021-12-01 | Clay | Illinois | 17025 | 2902 | 59 |
1966717 | 1966717 | 2021-11-30 | Clay | Illinois | 17025 | 2888 | 59 |
1963465 | 1963465 | 2021-11-29 | Clay | Illinois | 17025 | 2848 | 59 |
1960214 | 1960214 | 2021-11-28 | Clay | Illinois | 17025 | 2808 | 59 |
1956963 | 1956963 | 2021-11-27 | Clay | Illinois | 17025 | 2808 | 59 |
1953712 | 1953712 | 2021-11-26 | Clay | Illinois | 17025 | 2808 | 59 |
1950461 | 1950461 | 2021-11-25 | Clay | Illinois | 17025 | 2808 | 59 |
1947210 | 1947210 | 2021-11-24 | Clay | Illinois | 17025 | 2808 | 59 |
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);