ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where deaths = 278 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Illinois · 52 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1986249 | 1986249 | 2021-12-06 | Kankakee | Illinois | 17091 | 19986 | 278 |
1421057 | 1421057 | 2021-06-15 | Sangamon | Illinois | 17167 | 19075 | 278 |
1417812 | 1417812 | 2021-06-14 | Sangamon | Illinois | 17167 | 19073 | 278 |
1414566 | 1414566 | 2021-06-13 | Sangamon | Illinois | 17167 | 19071 | 278 |
1411321 | 1411321 | 2021-06-12 | Sangamon | Illinois | 17167 | 19066 | 278 |
1408076 | 1408076 | 2021-06-11 | Sangamon | Illinois | 17167 | 19063 | 278 |
1404830 | 1404830 | 2021-06-10 | Sangamon | Illinois | 17167 | 19050 | 278 |
1401585 | 1401585 | 2021-06-09 | Sangamon | Illinois | 17167 | 19046 | 278 |
1398340 | 1398340 | 2021-06-08 | Sangamon | Illinois | 17167 | 19035 | 278 |
1395093 | 1395093 | 2021-06-07 | Sangamon | Illinois | 17167 | 19032 | 278 |
1391848 | 1391848 | 2021-06-06 | Sangamon | Illinois | 17167 | 19031 | 278 |
1388603 | 1388603 | 2021-06-05 | Sangamon | Illinois | 17167 | 19025 | 278 |
1385358 | 1385358 | 2021-06-04 | Sangamon | Illinois | 17167 | 19018 | 278 |
1382112 | 1382112 | 2021-06-03 | Sangamon | Illinois | 17167 | 19012 | 278 |
1378867 | 1378867 | 2021-06-02 | Sangamon | Illinois | 17167 | 19009 | 278 |
1375621 | 1375621 | 2021-06-01 | Sangamon | Illinois | 17167 | 19008 | 278 |
1372376 | 1372376 | 2021-05-31 | Sangamon | Illinois | 17167 | 19002 | 278 |
1369131 | 1369131 | 2021-05-30 | Sangamon | Illinois | 17167 | 18999 | 278 |
1365885 | 1365885 | 2021-05-29 | Sangamon | Illinois | 17167 | 18993 | 278 |
1362639 | 1362639 | 2021-05-28 | Sangamon | Illinois | 17167 | 18981 | 278 |
1359392 | 1359392 | 2021-05-27 | Sangamon | Illinois | 17167 | 18970 | 278 |
1356146 | 1356146 | 2021-05-26 | Sangamon | Illinois | 17167 | 18958 | 278 |
1352900 | 1352900 | 2021-05-25 | Sangamon | Illinois | 17167 | 18950 | 278 |
1349654 | 1349654 | 2021-05-24 | Sangamon | Illinois | 17167 | 18943 | 278 |
1346407 | 1346407 | 2021-05-23 | Sangamon | Illinois | 17167 | 18931 | 278 |
1343159 | 1343159 | 2021-05-22 | Sangamon | Illinois | 17167 | 18920 | 278 |
1219785 | 1219785 | 2021-04-14 | Unknown | Illinois | 0 | 278 | |
1174313 | 1174313 | 2021-03-31 | Tazewell | Illinois | 17179 | 14468 | 278 |
1171066 | 1171066 | 2021-03-30 | Tazewell | Illinois | 17179 | 14415 | 278 |
1167818 | 1167818 | 2021-03-29 | Tazewell | Illinois | 17179 | 14351 | 278 |
1164570 | 1164570 | 2021-03-28 | Tazewell | Illinois | 17179 | 14313 | 278 |
1161322 | 1161322 | 2021-03-27 | Tazewell | Illinois | 17179 | 14275 | 278 |
1158074 | 1158074 | 2021-03-26 | Tazewell | Illinois | 17179 | 14216 | 278 |
1154827 | 1154827 | 2021-03-25 | Tazewell | Illinois | 17179 | 14150 | 278 |
1132059 | 1132059 | 2021-03-18 | LaSalle | Illinois | 17099 | 11092 | 278 |
1128811 | 1128811 | 2021-03-17 | LaSalle | Illinois | 17099 | 11068 | 278 |
1125565 | 1125565 | 2021-03-16 | LaSalle | Illinois | 17099 | 11044 | 278 |
1122319 | 1122319 | 2021-03-15 | LaSalle | Illinois | 17099 | 11026 | 278 |
1119072 | 1119072 | 2021-03-14 | LaSalle | Illinois | 17099 | 11019 | 278 |
1115825 | 1115825 | 2021-03-13 | LaSalle | Illinois | 17099 | 11010 | 278 |
1112579 | 1112579 | 2021-03-12 | LaSalle | Illinois | 17099 | 11000 | 278 |
1109333 | 1109333 | 2021-03-11 | LaSalle | Illinois | 17099 | 10990 | 278 |
1106087 | 1106087 | 2021-03-10 | LaSalle | Illinois | 17099 | 10967 | 278 |
1102841 | 1102841 | 2021-03-09 | LaSalle | Illinois | 17099 | 10943 | 278 |
1002238 | 1002238 | 2021-02-06 | McHenry | Illinois | 17111 | 23215 | 278 |
998992 | 998992 | 2021-02-05 | McHenry | Illinois | 17111 | 23135 | 278 |
700459 | 700459 | 2020-11-05 | Unknown | Illinois | 5932 | 278 | |
697215 | 697215 | 2020-11-04 | Unknown | Illinois | 6087 | 278 | |
693973 | 693973 | 2020-11-03 | Unknown | Illinois | 6034 | 278 | |
690730 | 690730 | 2020-11-02 | Unknown | Illinois | 6034 | 278 | |
687485 | 687485 | 2020-11-01 | Unknown | Illinois | 6061 | 278 | |
680998 | 680998 | 2020-10-30 | Unknown | Illinois | 6061 | 278 |
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);