ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
640 rows where deaths = 13 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Edwards 153
- Alexander 105
- Monroe 60
- McLean 42
- Brown 21
- Gallatin 16
- Menard 13
- Marshall 12
- Montgomery 11
- Whiteside 11
- Hardin 10
- Jasper 10
- Pulaski 10
- Perry 9
- Clay 7
- Crawford 7
- Jersey 7
- LaSalle 7
- McDonough 7
- Randolph 7
- Logan 6
- Wabash 6
- Henderson 5
- Johnson 5
- Mason 5
- White 5
- Bureau 4
- Cumberland 4
- De Witt 4
- Boone 3
- …
state 1
- Illinois · 640 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217084 | 2217084 | 2022-02-15 | Alexander | Illinois | 17003 | 1264 | 13 |
2213833 | 2213833 | 2022-02-14 | Alexander | Illinois | 17003 | 1260 | 13 |
2210581 | 2210581 | 2022-02-13 | Alexander | Illinois | 17003 | 1255 | 13 |
2207328 | 2207328 | 2022-02-12 | Alexander | Illinois | 17003 | 1255 | 13 |
2204075 | 2204075 | 2022-02-11 | Alexander | Illinois | 17003 | 1255 | 13 |
2200822 | 2200822 | 2022-02-10 | Alexander | Illinois | 17003 | 1255 | 13 |
2197568 | 2197568 | 2022-02-09 | Alexander | Illinois | 17003 | 1254 | 13 |
2197596 | 2197596 | 2022-02-09 | Gallatin | Illinois | 17059 | 1335 | 13 |
2194314 | 2194314 | 2022-02-08 | Alexander | Illinois | 17003 | 1252 | 13 |
2194342 | 2194342 | 2022-02-08 | Gallatin | Illinois | 17059 | 1333 | 13 |
2191060 | 2191060 | 2022-02-07 | Alexander | Illinois | 17003 | 1248 | 13 |
2191088 | 2191088 | 2022-02-07 | Gallatin | Illinois | 17059 | 1325 | 13 |
2187807 | 2187807 | 2022-02-06 | Alexander | Illinois | 17003 | 1240 | 13 |
2187835 | 2187835 | 2022-02-06 | Gallatin | Illinois | 17059 | 1302 | 13 |
2184554 | 2184554 | 2022-02-05 | Alexander | Illinois | 17003 | 1240 | 13 |
2184582 | 2184582 | 2022-02-05 | Gallatin | Illinois | 17059 | 1302 | 13 |
2181302 | 2181302 | 2022-02-04 | Alexander | Illinois | 17003 | 1240 | 13 |
2181330 | 2181330 | 2022-02-04 | Gallatin | Illinois | 17059 | 1302 | 13 |
2178051 | 2178051 | 2022-02-03 | Alexander | Illinois | 17003 | 1231 | 13 |
2178079 | 2178079 | 2022-02-03 | Gallatin | Illinois | 17059 | 1283 | 13 |
2174798 | 2174798 | 2022-02-02 | Alexander | Illinois | 17003 | 1231 | 13 |
2174826 | 2174826 | 2022-02-02 | Gallatin | Illinois | 17059 | 1283 | 13 |
2171545 | 2171545 | 2022-02-01 | Alexander | Illinois | 17003 | 1224 | 13 |
2171573 | 2171573 | 2022-02-01 | Gallatin | Illinois | 17059 | 1269 | 13 |
2168292 | 2168292 | 2022-01-31 | Alexander | Illinois | 17003 | 1212 | 13 |
2168320 | 2168320 | 2022-01-31 | Gallatin | Illinois | 17059 | 1254 | 13 |
2165037 | 2165037 | 2022-01-30 | Alexander | Illinois | 17003 | 1200 | 13 |
2165065 | 2165065 | 2022-01-30 | Gallatin | Illinois | 17059 | 1226 | 13 |
2161782 | 2161782 | 2022-01-29 | Alexander | Illinois | 17003 | 1200 | 13 |
2161810 | 2161810 | 2022-01-29 | Gallatin | Illinois | 17059 | 1226 | 13 |
2158527 | 2158527 | 2022-01-28 | Alexander | Illinois | 17003 | 1200 | 13 |
2158555 | 2158555 | 2022-01-28 | Gallatin | Illinois | 17059 | 1226 | 13 |
2155273 | 2155273 | 2022-01-27 | Alexander | Illinois | 17003 | 1189 | 13 |
2155301 | 2155301 | 2022-01-27 | Gallatin | Illinois | 17059 | 1205 | 13 |
2152020 | 2152020 | 2022-01-26 | Alexander | Illinois | 17003 | 1178 | 13 |
2152048 | 2152048 | 2022-01-26 | Gallatin | Illinois | 17059 | 1192 | 13 |
2148768 | 2148768 | 2022-01-25 | Alexander | Illinois | 17003 | 1168 | 13 |
2148796 | 2148796 | 2022-01-25 | Gallatin | Illinois | 17059 | 1179 | 13 |
2145516 | 2145516 | 2022-01-24 | Alexander | Illinois | 17003 | 1150 | 13 |
2142261 | 2142261 | 2022-01-23 | Alexander | Illinois | 17003 | 1110 | 13 |
2139006 | 2139006 | 2022-01-22 | Alexander | Illinois | 17003 | 1110 | 13 |
2135750 | 2135750 | 2022-01-21 | Alexander | Illinois | 17003 | 1110 | 13 |
2132498 | 2132498 | 2022-01-20 | Alexander | Illinois | 17003 | 1100 | 13 |
2129245 | 2129245 | 2022-01-19 | Alexander | Illinois | 17003 | 1069 | 13 |
2125991 | 2125991 | 2022-01-18 | Alexander | Illinois | 17003 | 1032 | 13 |
2122739 | 2122739 | 2022-01-17 | Alexander | Illinois | 17003 | 987 | 13 |
2119487 | 2119487 | 2022-01-16 | Alexander | Illinois | 17003 | 987 | 13 |
2116235 | 2116235 | 2022-01-15 | Alexander | Illinois | 17003 | 987 | 13 |
2112984 | 2112984 | 2022-01-14 | Alexander | Illinois | 17003 | 987 | 13 |
2109732 | 2109732 | 2022-01-13 | Alexander | Illinois | 17003 | 982 | 13 |
2106481 | 2106481 | 2022-01-12 | Alexander | Illinois | 17003 | 963 | 13 |
2103230 | 2103230 | 2022-01-11 | Alexander | Illinois | 17003 | 953 | 13 |
2099979 | 2099979 | 2022-01-10 | Alexander | Illinois | 17003 | 938 | 13 |
2096728 | 2096728 | 2022-01-09 | Alexander | Illinois | 17003 | 933 | 13 |
2093476 | 2093476 | 2022-01-08 | Alexander | Illinois | 17003 | 933 | 13 |
2090224 | 2090224 | 2022-01-07 | Alexander | Illinois | 17003 | 933 | 13 |
2086973 | 2086973 | 2022-01-06 | Alexander | Illinois | 17003 | 925 | 13 |
2083721 | 2083721 | 2022-01-05 | Alexander | Illinois | 17003 | 915 | 13 |
2080469 | 2080469 | 2022-01-04 | Alexander | Illinois | 17003 | 906 | 13 |
2077217 | 2077217 | 2022-01-03 | Alexander | Illinois | 17003 | 901 | 13 |
2073966 | 2073966 | 2022-01-02 | Alexander | Illinois | 17003 | 890 | 13 |
2070715 | 2070715 | 2022-01-01 | Alexander | Illinois | 17003 | 890 | 13 |
2067464 | 2067464 | 2021-12-31 | Alexander | Illinois | 17003 | 890 | 13 |
2064213 | 2064213 | 2021-12-30 | Alexander | Illinois | 17003 | 890 | 13 |
2060963 | 2060963 | 2021-12-29 | Alexander | Illinois | 17003 | 883 | 13 |
2057714 | 2057714 | 2021-12-28 | Alexander | Illinois | 17003 | 879 | 13 |
2054465 | 2054465 | 2021-12-27 | Alexander | Illinois | 17003 | 866 | 13 |
2051215 | 2051215 | 2021-12-26 | Alexander | Illinois | 17003 | 861 | 13 |
2047965 | 2047965 | 2021-12-25 | Alexander | Illinois | 17003 | 861 | 13 |
2044715 | 2044715 | 2021-12-24 | Alexander | Illinois | 17003 | 861 | 13 |
2041466 | 2041466 | 2021-12-23 | Alexander | Illinois | 17003 | 861 | 13 |
2038216 | 2038216 | 2021-12-22 | Alexander | Illinois | 17003 | 858 | 13 |
2034966 | 2034966 | 2021-12-21 | Alexander | Illinois | 17003 | 854 | 13 |
2031716 | 2031716 | 2021-12-20 | Alexander | Illinois | 17003 | 849 | 13 |
2028465 | 2028465 | 2021-12-19 | Alexander | Illinois | 17003 | 846 | 13 |
2025214 | 2025214 | 2021-12-18 | Alexander | Illinois | 17003 | 846 | 13 |
2021963 | 2021963 | 2021-12-17 | Alexander | Illinois | 17003 | 846 | 13 |
2018712 | 2018712 | 2021-12-16 | Alexander | Illinois | 17003 | 841 | 13 |
2015462 | 2015462 | 2021-12-15 | Alexander | Illinois | 17003 | 835 | 13 |
2012211 | 2012211 | 2021-12-14 | Alexander | Illinois | 17003 | 833 | 13 |
2008960 | 2008960 | 2021-12-13 | Alexander | Illinois | 17003 | 830 | 13 |
2005709 | 2005709 | 2021-12-12 | Alexander | Illinois | 17003 | 829 | 13 |
2005784 | 2005784 | 2021-12-12 | Pulaski | Illinois | 17153 | 1120 | 13 |
2002458 | 2002458 | 2021-12-11 | Alexander | Illinois | 17003 | 829 | 13 |
2002533 | 2002533 | 2021-12-11 | Pulaski | Illinois | 17153 | 1120 | 13 |
1999208 | 1999208 | 2021-12-10 | Alexander | Illinois | 17003 | 829 | 13 |
1999283 | 1999283 | 2021-12-10 | Pulaski | Illinois | 17153 | 1120 | 13 |
1995957 | 1995957 | 2021-12-09 | Alexander | Illinois | 17003 | 828 | 13 |
1996032 | 1996032 | 2021-12-09 | Pulaski | Illinois | 17153 | 1118 | 13 |
1992706 | 1992706 | 2021-12-08 | Alexander | Illinois | 17003 | 823 | 13 |
1992781 | 1992781 | 2021-12-08 | Pulaski | Illinois | 17153 | 1114 | 13 |
1989455 | 1989455 | 2021-12-07 | Alexander | Illinois | 17003 | 819 | 13 |
1989530 | 1989530 | 2021-12-07 | Pulaski | Illinois | 17153 | 1112 | 13 |
1986205 | 1986205 | 2021-12-06 | Alexander | Illinois | 17003 | 816 | 13 |
1986280 | 1986280 | 2021-12-06 | Pulaski | Illinois | 17153 | 1105 | 13 |
1982955 | 1982955 | 2021-12-05 | Alexander | Illinois | 17003 | 811 | 13 |
1983030 | 1983030 | 2021-12-05 | Pulaski | Illinois | 17153 | 1100 | 13 |
1979705 | 1979705 | 2021-12-04 | Alexander | Illinois | 17003 | 811 | 13 |
1979780 | 1979780 | 2021-12-04 | Pulaski | Illinois | 17153 | 1100 | 13 |
1976455 | 1976455 | 2021-12-03 | Alexander | Illinois | 17003 | 811 | 13 |
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);