ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where deaths = 134 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451350 | 2451350 | 2022-04-28 | Fulton | Illinois | 17057 | 10128 | 134 |
2448094 | 2448094 | 2022-04-27 | Fulton | Illinois | 17057 | 10122 | 134 |
2444838 | 2444838 | 2022-04-26 | Fulton | Illinois | 17057 | 10117 | 134 |
2441582 | 2441582 | 2022-04-25 | Fulton | Illinois | 17057 | 10108 | 134 |
2438326 | 2438326 | 2022-04-24 | Fulton | Illinois | 17057 | 10094 | 134 |
2435070 | 2435070 | 2022-04-23 | Fulton | Illinois | 17057 | 10094 | 134 |
2431814 | 2431814 | 2022-04-22 | Fulton | Illinois | 17057 | 10094 | 134 |
2428558 | 2428558 | 2022-04-21 | Fulton | Illinois | 17057 | 10093 | 134 |
2425302 | 2425302 | 2022-04-20 | Fulton | Illinois | 17057 | 10080 | 134 |
2422046 | 2422046 | 2022-04-19 | Fulton | Illinois | 17057 | 10074 | 134 |
2418790 | 2418790 | 2022-04-18 | Fulton | Illinois | 17057 | 10071 | 134 |
2415534 | 2415534 | 2022-04-17 | Fulton | Illinois | 17057 | 10067 | 134 |
2412278 | 2412278 | 2022-04-16 | Fulton | Illinois | 17057 | 10067 | 134 |
2409022 | 2409022 | 2022-04-15 | Fulton | Illinois | 17057 | 10067 | 134 |
2405766 | 2405766 | 2022-04-14 | Fulton | Illinois | 17057 | 10065 | 134 |
2402511 | 2402511 | 2022-04-13 | Fulton | Illinois | 17057 | 10063 | 134 |
2399256 | 2399256 | 2022-04-12 | Fulton | Illinois | 17057 | 10059 | 134 |
2396001 | 2396001 | 2022-04-11 | Fulton | Illinois | 17057 | 10058 | 134 |
2392745 | 2392745 | 2022-04-10 | Fulton | Illinois | 17057 | 10055 | 134 |
2389489 | 2389489 | 2022-04-09 | Fulton | Illinois | 17057 | 10055 | 134 |
2386234 | 2386234 | 2022-04-08 | Fulton | Illinois | 17057 | 10055 | 134 |
2382979 | 2382979 | 2022-04-07 | Fulton | Illinois | 17057 | 10054 | 134 |
2379724 | 2379724 | 2022-04-06 | Fulton | Illinois | 17057 | 10052 | 134 |
2376470 | 2376470 | 2022-04-05 | Fulton | Illinois | 17057 | 10049 | 134 |
2373218 | 2373218 | 2022-04-04 | Fulton | Illinois | 17057 | 10048 | 134 |
2369965 | 2369965 | 2022-04-03 | Fulton | Illinois | 17057 | 10045 | 134 |
2366712 | 2366712 | 2022-04-02 | Fulton | Illinois | 17057 | 10045 | 134 |
2363459 | 2363459 | 2022-04-01 | Fulton | Illinois | 17057 | 10045 | 134 |
2360205 | 2360205 | 2022-03-31 | Fulton | Illinois | 17057 | 10041 | 134 |
2356951 | 2356951 | 2022-03-30 | Fulton | Illinois | 17057 | 10039 | 134 |
2353698 | 2353698 | 2022-03-29 | Fulton | Illinois | 17057 | 10038 | 134 |
2350446 | 2350446 | 2022-03-28 | Fulton | Illinois | 17057 | 10037 | 134 |
2347193 | 2347193 | 2022-03-27 | Fulton | Illinois | 17057 | 10028 | 134 |
2343940 | 2343940 | 2022-03-26 | Fulton | Illinois | 17057 | 10028 | 134 |
2340687 | 2340687 | 2022-03-25 | Fulton | Illinois | 17057 | 10028 | 134 |
2337434 | 2337434 | 2022-03-24 | Fulton | Illinois | 17057 | 10023 | 134 |
2334180 | 2334180 | 2022-03-23 | Fulton | Illinois | 17057 | 10022 | 134 |
2330926 | 2330926 | 2022-03-22 | Fulton | Illinois | 17057 | 10022 | 134 |
2327674 | 2327674 | 2022-03-21 | Fulton | Illinois | 17057 | 10020 | 134 |
2324421 | 2324421 | 2022-03-20 | Fulton | Illinois | 17057 | 10014 | 134 |
2321167 | 2321167 | 2022-03-19 | Fulton | Illinois | 17057 | 10014 | 134 |
2317913 | 2317913 | 2022-03-18 | Fulton | Illinois | 17057 | 10014 | 134 |
2314660 | 2314660 | 2022-03-17 | Fulton | Illinois | 17057 | 10009 | 134 |
2304903 | 2304903 | 2022-03-14 | Fulton | Illinois | 17057 | 9992 | 134 |
2301651 | 2301651 | 2022-03-13 | Fulton | Illinois | 17057 | 9988 | 134 |
2298399 | 2298399 | 2022-03-12 | Fulton | Illinois | 17057 | 9988 | 134 |
2295147 | 2295147 | 2022-03-11 | Fulton | Illinois | 17057 | 9988 | 134 |
2291895 | 2291895 | 2022-03-10 | Fulton | Illinois | 17057 | 9987 | 134 |
2288643 | 2288643 | 2022-03-09 | Fulton | Illinois | 17057 | 9978 | 134 |
2285392 | 2285392 | 2022-03-08 | Fulton | Illinois | 17057 | 9963 | 134 |
2282140 | 2282140 | 2022-03-07 | Fulton | Illinois | 17057 | 9954 | 134 |
2217114 | 2217114 | 2022-02-15 | Grundy | Illinois | 17063 | 12406 | 134 |
2213863 | 2213863 | 2022-02-14 | Grundy | Illinois | 17063 | 12400 | 134 |
2210650 | 2210650 | 2022-02-13 | Ogle | Illinois | 17141 | 13564 | 134 |
2207397 | 2207397 | 2022-02-12 | Ogle | Illinois | 17141 | 13564 | 134 |
2204144 | 2204144 | 2022-02-11 | Ogle | Illinois | 17141 | 13564 | 134 |
2200891 | 2200891 | 2022-02-10 | Ogle | Illinois | 17141 | 13564 | 134 |
2197637 | 2197637 | 2022-02-09 | Ogle | Illinois | 17141 | 13534 | 134 |
2194383 | 2194383 | 2022-02-08 | Ogle | Illinois | 17141 | 13518 | 134 |
2191129 | 2191129 | 2022-02-07 | Ogle | Illinois | 17141 | 13479 | 134 |
2187876 | 2187876 | 2022-02-06 | Ogle | Illinois | 17141 | 13403 | 134 |
2184623 | 2184623 | 2022-02-05 | Ogle | Illinois | 17141 | 13403 | 134 |
2181371 | 2181371 | 2022-02-04 | Ogle | Illinois | 17141 | 13403 | 134 |
2178120 | 2178120 | 2022-02-03 | Ogle | Illinois | 17141 | 13299 | 134 |
2174867 | 2174867 | 2022-02-02 | Ogle | Illinois | 17141 | 13299 | 134 |
2155277 | 2155277 | 2022-01-27 | Bureau | Illinois | 17011 | 7759 | 134 |
2155296 | 2155296 | 2022-01-27 | Effingham | Illinois | 17049 | 10029 | 134 |
2132549 | 2132549 | 2022-01-20 | Livingston | Illinois | 17105 | 9518 | 134 |
2051260 | 2051260 | 2021-12-26 | Kendall | Illinois | 17093 | 20271 | 134 |
2048010 | 2048010 | 2021-12-25 | Kendall | Illinois | 17093 | 20271 | 134 |
2044760 | 2044760 | 2021-12-24 | Kendall | Illinois | 17093 | 20271 | 134 |
2041511 | 2041511 | 2021-12-23 | Kendall | Illinois | 17093 | 20271 | 134 |
2038261 | 2038261 | 2021-12-22 | Kendall | Illinois | 17093 | 20017 | 134 |
2035011 | 2035011 | 2021-12-21 | Kendall | Illinois | 17093 | 19942 | 134 |
2031761 | 2031761 | 2021-12-20 | Kendall | Illinois | 17093 | 19942 | 134 |
2028510 | 2028510 | 2021-12-19 | Kendall | Illinois | 17093 | 19942 | 134 |
2025259 | 2025259 | 2021-12-18 | Kendall | Illinois | 17093 | 19942 | 134 |
2022008 | 2022008 | 2021-12-17 | Kendall | Illinois | 17093 | 19942 | 134 |
2018757 | 2018757 | 2021-12-16 | Kendall | Illinois | 17093 | 19942 | 134 |
1982981 | 1982981 | 2021-12-05 | Franklin | Illinois | 17055 | 7768 | 134 |
1979731 | 1979731 | 2021-12-04 | Franklin | Illinois | 17055 | 7768 | 134 |
1976481 | 1976481 | 2021-12-03 | Franklin | Illinois | 17055 | 7768 | 134 |
1937461 | 1937461 | 2021-11-21 | Coles | Illinois | 17029 | 8372 | 134 |
1934211 | 1934211 | 2021-11-20 | Coles | Illinois | 17029 | 8372 | 134 |
1930960 | 1930960 | 2021-11-19 | Coles | Illinois | 17029 | 8372 | 134 |
1927709 | 1927709 | 2021-11-18 | Coles | Illinois | 17029 | 8350 | 134 |
1924459 | 1924459 | 2021-11-17 | Coles | Illinois | 17029 | 8332 | 134 |
1921210 | 1921210 | 2021-11-16 | Coles | Illinois | 17029 | 8303 | 134 |
1917960 | 1917960 | 2021-11-15 | Coles | Illinois | 17029 | 8287 | 134 |
1833516 | 1833516 | 2021-10-20 | Macoupin | Illinois | 17117 | 6951 | 134 |
1758751 | 1758751 | 2021-09-27 | DeKalb | Illinois | 17037 | 12067 | 134 |
1755503 | 1755503 | 2021-09-26 | DeKalb | Illinois | 17037 | 12023 | 134 |
1752255 | 1752255 | 2021-09-25 | DeKalb | Illinois | 17037 | 12023 | 134 |
1749006 | 1749006 | 2021-09-24 | DeKalb | Illinois | 17037 | 12023 | 134 |
1745756 | 1745756 | 2021-09-23 | DeKalb | Illinois | 17037 | 11992 | 134 |
1109385 | 1109385 | 2021-03-11 | Williamson | Illinois | 17199 | 6905 | 134 |
1083325 | 1083325 | 2021-03-03 | Champaign | Illinois | 17019 | 18296 | 134 |
1080079 | 1080079 | 2021-03-02 | Champaign | Illinois | 17019 | 18256 | 134 |
1076834 | 1076834 | 2021-03-01 | Champaign | Illinois | 17019 | 18236 | 134 |
1073588 | 1073588 | 2021-02-28 | Champaign | Illinois | 17019 | 18209 | 134 |
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);