ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
381 rows where deaths = 39 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 |
---|---|---|---|---|---|---|---|
2500219 | 2500219 | 2022-05-13 | Jo Daviess | Illinois | 17085 | 4105 | 39 |
2496961 | 2496961 | 2022-05-12 | Jo Daviess | Illinois | 17085 | 4095 | 39 |
2493703 | 2493703 | 2022-05-11 | Jo Daviess | Illinois | 17085 | 4091 | 39 |
2490445 | 2490445 | 2022-05-10 | Jo Daviess | Illinois | 17085 | 4088 | 39 |
2487188 | 2487188 | 2022-05-09 | Jo Daviess | Illinois | 17085 | 4082 | 39 |
2483930 | 2483930 | 2022-05-08 | Jo Daviess | Illinois | 17085 | 4072 | 39 |
2480672 | 2480672 | 2022-05-07 | Jo Daviess | Illinois | 17085 | 4072 | 39 |
2477414 | 2477414 | 2022-05-06 | Jo Daviess | Illinois | 17085 | 4072 | 39 |
2474156 | 2474156 | 2022-05-05 | Jo Daviess | Illinois | 17085 | 4068 | 39 |
2470899 | 2470899 | 2022-05-04 | Jo Daviess | Illinois | 17085 | 4066 | 39 |
2467643 | 2467643 | 2022-05-03 | Jo Daviess | Illinois | 17085 | 4064 | 39 |
2464388 | 2464388 | 2022-05-02 | Jo Daviess | Illinois | 17085 | 4062 | 39 |
2461132 | 2461132 | 2022-05-01 | Jo Daviess | Illinois | 17085 | 4057 | 39 |
2457876 | 2457876 | 2022-04-30 | Jo Daviess | Illinois | 17085 | 4057 | 39 |
2454620 | 2454620 | 2022-04-29 | Jo Daviess | Illinois | 17085 | 4057 | 39 |
2451364 | 2451364 | 2022-04-28 | Jo Daviess | Illinois | 17085 | 4052 | 39 |
2448108 | 2448108 | 2022-04-27 | Jo Daviess | Illinois | 17085 | 4049 | 39 |
2444852 | 2444852 | 2022-04-26 | Jo Daviess | Illinois | 17085 | 4045 | 39 |
2441596 | 2441596 | 2022-04-25 | Jo Daviess | Illinois | 17085 | 4040 | 39 |
2438340 | 2438340 | 2022-04-24 | Jo Daviess | Illinois | 17085 | 4036 | 39 |
2435084 | 2435084 | 2022-04-23 | Jo Daviess | Illinois | 17085 | 4036 | 39 |
2431828 | 2431828 | 2022-04-22 | Jo Daviess | Illinois | 17085 | 4036 | 39 |
2428572 | 2428572 | 2022-04-21 | Jo Daviess | Illinois | 17085 | 4035 | 39 |
2425316 | 2425316 | 2022-04-20 | Jo Daviess | Illinois | 17085 | 4035 | 39 |
2422060 | 2422060 | 2022-04-19 | Jo Daviess | Illinois | 17085 | 4035 | 39 |
2418804 | 2418804 | 2022-04-18 | Jo Daviess | Illinois | 17085 | 4035 | 39 |
2415548 | 2415548 | 2022-04-17 | Jo Daviess | Illinois | 17085 | 4033 | 39 |
2412292 | 2412292 | 2022-04-16 | Jo Daviess | Illinois | 17085 | 4033 | 39 |
2409036 | 2409036 | 2022-04-15 | Jo Daviess | Illinois | 17085 | 4033 | 39 |
2405780 | 2405780 | 2022-04-14 | Jo Daviess | Illinois | 17085 | 4032 | 39 |
2402525 | 2402525 | 2022-04-13 | Jo Daviess | Illinois | 17085 | 4032 | 39 |
2399270 | 2399270 | 2022-04-12 | Jo Daviess | Illinois | 17085 | 4032 | 39 |
2396015 | 2396015 | 2022-04-11 | Jo Daviess | Illinois | 17085 | 4031 | 39 |
2392759 | 2392759 | 2022-04-10 | Jo Daviess | Illinois | 17085 | 4031 | 39 |
2389503 | 2389503 | 2022-04-09 | Jo Daviess | Illinois | 17085 | 4031 | 39 |
2386248 | 2386248 | 2022-04-08 | Jo Daviess | Illinois | 17085 | 4031 | 39 |
2382993 | 2382993 | 2022-04-07 | Jo Daviess | Illinois | 17085 | 4030 | 39 |
2379738 | 2379738 | 2022-04-06 | Jo Daviess | Illinois | 17085 | 4029 | 39 |
2376484 | 2376484 | 2022-04-05 | Jo Daviess | Illinois | 17085 | 4027 | 39 |
2373232 | 2373232 | 2022-04-04 | Jo Daviess | Illinois | 17085 | 4027 | 39 |
2369979 | 2369979 | 2022-04-03 | Jo Daviess | Illinois | 17085 | 4025 | 39 |
2366726 | 2366726 | 2022-04-02 | Jo Daviess | Illinois | 17085 | 4025 | 39 |
2363473 | 2363473 | 2022-04-01 | Jo Daviess | Illinois | 17085 | 4025 | 39 |
2360219 | 2360219 | 2022-03-31 | Jo Daviess | Illinois | 17085 | 4024 | 39 |
2217178 | 2217178 | 2022-02-15 | Washington | Illinois | 17189 | 3370 | 39 |
2213927 | 2213927 | 2022-02-14 | Washington | Illinois | 17189 | 3369 | 39 |
2210675 | 2210675 | 2022-02-13 | Washington | Illinois | 17189 | 3356 | 39 |
2207422 | 2207422 | 2022-02-12 | Washington | Illinois | 17189 | 3356 | 39 |
2204169 | 2204169 | 2022-02-11 | Washington | Illinois | 17189 | 3356 | 39 |
2200916 | 2200916 | 2022-02-10 | Washington | Illinois | 17189 | 3356 | 39 |
2197662 | 2197662 | 2022-02-09 | Washington | Illinois | 17189 | 3349 | 39 |
2194408 | 2194408 | 2022-02-08 | Washington | Illinois | 17189 | 3342 | 39 |
2191154 | 2191154 | 2022-02-07 | Washington | Illinois | 17189 | 3338 | 39 |
2187901 | 2187901 | 2022-02-06 | Washington | Illinois | 17189 | 3329 | 39 |
2184648 | 2184648 | 2022-02-05 | Washington | Illinois | 17189 | 3329 | 39 |
2181396 | 2181396 | 2022-02-04 | Washington | Illinois | 17189 | 3329 | 39 |
2178145 | 2178145 | 2022-02-03 | Washington | Illinois | 17189 | 3319 | 39 |
2174892 | 2174892 | 2022-02-02 | Washington | Illinois | 17189 | 3319 | 39 |
2171639 | 2171639 | 2022-02-01 | Washington | Illinois | 17189 | 3302 | 39 |
2168386 | 2168386 | 2022-01-31 | Washington | Illinois | 17189 | 3280 | 39 |
2145580 | 2145580 | 2022-01-24 | Mercer | Illinois | 17131 | 3566 | 39 |
2086990 | 2086990 | 2022-01-06 | De Witt | Illinois | 17039 | 3183 | 39 |
2083738 | 2083738 | 2022-01-05 | De Witt | Illinois | 17039 | 3118 | 39 |
2080486 | 2080486 | 2022-01-04 | De Witt | Illinois | 17039 | 3065 | 39 |
2077234 | 2077234 | 2022-01-03 | De Witt | Illinois | 17039 | 3016 | 39 |
2073983 | 2073983 | 2022-01-02 | De Witt | Illinois | 17039 | 2937 | 39 |
2070732 | 2070732 | 2022-01-01 | De Witt | Illinois | 17039 | 2937 | 39 |
2067481 | 2067481 | 2021-12-31 | De Witt | Illinois | 17039 | 2937 | 39 |
2064230 | 2064230 | 2021-12-30 | De Witt | Illinois | 17039 | 2937 | 39 |
2060980 | 2060980 | 2021-12-29 | De Witt | Illinois | 17039 | 2901 | 39 |
2061005 | 2061005 | 2021-12-29 | Johnson | Illinois | 17087 | 2692 | 39 |
2057731 | 2057731 | 2021-12-28 | De Witt | Illinois | 17039 | 2877 | 39 |
2057756 | 2057756 | 2021-12-28 | Johnson | Illinois | 17087 | 2678 | 39 |
2054482 | 2054482 | 2021-12-27 | De Witt | Illinois | 17039 | 2856 | 39 |
2054507 | 2054507 | 2021-12-27 | Johnson | Illinois | 17087 | 2671 | 39 |
2051232 | 2051232 | 2021-12-26 | De Witt | Illinois | 17039 | 2821 | 39 |
2051257 | 2051257 | 2021-12-26 | Johnson | Illinois | 17087 | 2653 | 39 |
2047982 | 2047982 | 2021-12-25 | De Witt | Illinois | 17039 | 2821 | 39 |
2048007 | 2048007 | 2021-12-25 | Johnson | Illinois | 17087 | 2653 | 39 |
2044732 | 2044732 | 2021-12-24 | De Witt | Illinois | 17039 | 2821 | 39 |
2044757 | 2044757 | 2021-12-24 | Johnson | Illinois | 17087 | 2653 | 39 |
2041483 | 2041483 | 2021-12-23 | De Witt | Illinois | 17039 | 2821 | 39 |
2041508 | 2041508 | 2021-12-23 | Johnson | Illinois | 17087 | 2653 | 39 |
2038233 | 2038233 | 2021-12-22 | De Witt | Illinois | 17039 | 2803 | 39 |
2034983 | 2034983 | 2021-12-21 | De Witt | Illinois | 17039 | 2783 | 39 |
2031733 | 2031733 | 2021-12-20 | De Witt | Illinois | 17039 | 2765 | 39 |
2028482 | 2028482 | 2021-12-19 | De Witt | Illinois | 17039 | 2723 | 39 |
2025231 | 2025231 | 2021-12-18 | De Witt | Illinois | 17039 | 2723 | 39 |
2021980 | 2021980 | 2021-12-17 | De Witt | Illinois | 17039 | 2723 | 39 |
2018729 | 2018729 | 2021-12-16 | De Witt | Illinois | 17039 | 2709 | 39 |
2015479 | 2015479 | 2021-12-15 | De Witt | Illinois | 17039 | 2679 | 39 |
2012228 | 2012228 | 2021-12-14 | De Witt | Illinois | 17039 | 2659 | 39 |
2008977 | 2008977 | 2021-12-13 | De Witt | Illinois | 17039 | 2638 | 39 |
1995973 | 1995973 | 2021-12-09 | Cumberland | Illinois | 17035 | 2160 | 39 |
1992722 | 1992722 | 2021-12-08 | Cumberland | Illinois | 17035 | 2145 | 39 |
1989471 | 1989471 | 2021-12-07 | Cumberland | Illinois | 17035 | 2136 | 39 |
1986221 | 1986221 | 2021-12-06 | Cumberland | Illinois | 17035 | 2119 | 39 |
1982971 | 1982971 | 2021-12-05 | Cumberland | Illinois | 17035 | 2100 | 39 |
1979721 | 1979721 | 2021-12-04 | Cumberland | Illinois | 17035 | 2100 | 39 |
1976471 | 1976471 | 2021-12-03 | Cumberland | Illinois | 17035 | 2100 | 39 |
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);