ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17105 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386587 | 386587 | 2020-07-31 | Livingston | Illinois | 17105 | 85 | 2 |
383369 | 383369 | 2020-07-30 | Livingston | Illinois | 17105 | 83 | 2 |
380152 | 380152 | 2020-07-29 | Livingston | Illinois | 17105 | 79 | 2 |
376935 | 376935 | 2020-07-28 | Livingston | Illinois | 17105 | 76 | 2 |
373720 | 373720 | 2020-07-27 | Livingston | Illinois | 17105 | 74 | 2 |
370508 | 370508 | 2020-07-26 | Livingston | Illinois | 17105 | 71 | 2 |
367298 | 367298 | 2020-07-25 | Livingston | Illinois | 17105 | 69 | 2 |
364091 | 364091 | 2020-07-24 | Livingston | Illinois | 17105 | 66 | 2 |
360884 | 360884 | 2020-07-23 | Livingston | Illinois | 17105 | 65 | 2 |
357679 | 357679 | 2020-07-22 | Livingston | Illinois | 17105 | 63 | 2 |
354477 | 354477 | 2020-07-21 | Livingston | Illinois | 17105 | 61 | 2 |
351275 | 351275 | 2020-07-20 | Livingston | Illinois | 17105 | 60 | 2 |
348075 | 348075 | 2020-07-19 | Livingston | Illinois | 17105 | 60 | 2 |
344874 | 344874 | 2020-07-18 | Livingston | Illinois | 17105 | 58 | 2 |
341674 | 341674 | 2020-07-17 | Livingston | Illinois | 17105 | 58 | 2 |
338478 | 338478 | 2020-07-16 | Livingston | Illinois | 17105 | 57 | 2 |
335282 | 335282 | 2020-07-15 | Livingston | Illinois | 17105 | 58 | 2 |
332089 | 332089 | 2020-07-14 | Livingston | Illinois | 17105 | 55 | 2 |
328902 | 328902 | 2020-07-13 | Livingston | Illinois | 17105 | 55 | 2 |
325716 | 325716 | 2020-07-12 | Livingston | Illinois | 17105 | 55 | 2 |
322535 | 322535 | 2020-07-11 | Livingston | Illinois | 17105 | 54 | 2 |
319356 | 319356 | 2020-07-10 | Livingston | Illinois | 17105 | 54 | 2 |
316183 | 316183 | 2020-07-09 | Livingston | Illinois | 17105 | 54 | 2 |
313009 | 313009 | 2020-07-08 | Livingston | Illinois | 17105 | 53 | 2 |
309839 | 309839 | 2020-07-07 | Livingston | Illinois | 17105 | 53 | 2 |
306671 | 306671 | 2020-07-06 | Livingston | Illinois | 17105 | 52 | 2 |
303506 | 303506 | 2020-07-05 | Livingston | Illinois | 17105 | 52 | 2 |
300342 | 300342 | 2020-07-04 | Livingston | Illinois | 17105 | 52 | 2 |
297180 | 297180 | 2020-07-03 | Livingston | Illinois | 17105 | 50 | 2 |
294023 | 294023 | 2020-07-02 | Livingston | Illinois | 17105 | 47 | 2 |
290869 | 290869 | 2020-07-01 | Livingston | Illinois | 17105 | 45 | 2 |
287719 | 287719 | 2020-06-30 | Livingston | Illinois | 17105 | 43 | 2 |
284570 | 284570 | 2020-06-29 | Livingston | Illinois | 17105 | 43 | 2 |
281425 | 281425 | 2020-06-28 | Livingston | Illinois | 17105 | 43 | 2 |
278277 | 278277 | 2020-06-27 | Livingston | Illinois | 17105 | 42 | 2 |
275129 | 275129 | 2020-06-26 | Livingston | Illinois | 17105 | 42 | 2 |
271987 | 271987 | 2020-06-25 | Livingston | Illinois | 17105 | 40 | 2 |
268850 | 268850 | 2020-06-24 | Livingston | Illinois | 17105 | 40 | 2 |
265720 | 265720 | 2020-06-23 | Livingston | Illinois | 17105 | 38 | 2 |
262592 | 262592 | 2020-06-22 | Livingston | Illinois | 17105 | 37 | 2 |
259465 | 259465 | 2020-06-21 | Livingston | Illinois | 17105 | 37 | 2 |
256339 | 256339 | 2020-06-20 | Livingston | Illinois | 17105 | 37 | 2 |
253219 | 253219 | 2020-06-19 | Livingston | Illinois | 17105 | 36 | 2 |
250104 | 250104 | 2020-06-18 | Livingston | Illinois | 17105 | 35 | 2 |
246992 | 246992 | 2020-06-17 | Livingston | Illinois | 17105 | 35 | 2 |
243879 | 243879 | 2020-06-16 | Livingston | Illinois | 17105 | 35 | 2 |
240768 | 240768 | 2020-06-15 | Livingston | Illinois | 17105 | 37 | 2 |
237660 | 237660 | 2020-06-14 | Livingston | Illinois | 17105 | 39 | 2 |
234553 | 234553 | 2020-06-13 | Livingston | Illinois | 17105 | 37 | 2 |
231447 | 231447 | 2020-06-12 | Livingston | Illinois | 17105 | 36 | 2 |
228344 | 228344 | 2020-06-11 | Livingston | Illinois | 17105 | 36 | 2 |
225242 | 225242 | 2020-06-10 | Livingston | Illinois | 17105 | 36 | 2 |
222147 | 222147 | 2020-06-09 | Livingston | Illinois | 17105 | 36 | 2 |
219052 | 219052 | 2020-06-08 | Livingston | Illinois | 17105 | 36 | 2 |
215961 | 215961 | 2020-06-07 | Livingston | Illinois | 17105 | 36 | 2 |
212874 | 212874 | 2020-06-06 | Livingston | Illinois | 17105 | 36 | 2 |
209789 | 209789 | 2020-06-05 | Livingston | Illinois | 17105 | 36 | 2 |
206708 | 206708 | 2020-06-04 | Livingston | Illinois | 17105 | 36 | 2 |
203628 | 203628 | 2020-06-03 | Livingston | Illinois | 17105 | 36 | 2 |
200552 | 200552 | 2020-06-02 | Livingston | Illinois | 17105 | 34 | 2 |
197479 | 197479 | 2020-06-01 | Livingston | Illinois | 17105 | 34 | 2 |
194409 | 194409 | 2020-05-31 | Livingston | Illinois | 17105 | 34 | 2 |
191342 | 191342 | 2020-05-30 | Livingston | Illinois | 17105 | 34 | 2 |
188277 | 188277 | 2020-05-29 | Livingston | Illinois | 17105 | 32 | 2 |
185219 | 185219 | 2020-05-28 | Livingston | Illinois | 17105 | 32 | 2 |
182165 | 182165 | 2020-05-27 | Livingston | Illinois | 17105 | 31 | 2 |
179121 | 179121 | 2020-05-26 | Livingston | Illinois | 17105 | 31 | 2 |
176077 | 176077 | 2020-05-25 | Livingston | Illinois | 17105 | 31 | 2 |
173033 | 173033 | 2020-05-24 | Livingston | Illinois | 17105 | 31 | 2 |
169992 | 169992 | 2020-05-23 | Livingston | Illinois | 17105 | 31 | 2 |
166955 | 166955 | 2020-05-22 | Livingston | Illinois | 17105 | 30 | 2 |
163922 | 163922 | 2020-05-21 | Livingston | Illinois | 17105 | 29 | 2 |
160894 | 160894 | 2020-05-20 | Livingston | Illinois | 17105 | 28 | 1 |
157868 | 157868 | 2020-05-19 | Livingston | Illinois | 17105 | 27 | 1 |
154852 | 154852 | 2020-05-18 | Livingston | Illinois | 17105 | 27 | 1 |
151840 | 151840 | 2020-05-17 | Livingston | Illinois | 17105 | 26 | 1 |
148831 | 148831 | 2020-05-16 | Livingston | Illinois | 17105 | 25 | 1 |
145828 | 145828 | 2020-05-15 | Livingston | Illinois | 17105 | 25 | 1 |
142828 | 142828 | 2020-05-14 | Livingston | Illinois | 17105 | 25 | 1 |
139832 | 139832 | 2020-05-13 | Livingston | Illinois | 17105 | 25 | 1 |
136840 | 136840 | 2020-05-12 | Livingston | Illinois | 17105 | 25 | 1 |
133851 | 133851 | 2020-05-11 | Livingston | Illinois | 17105 | 24 | 1 |
130860 | 130860 | 2020-05-10 | Livingston | Illinois | 17105 | 24 | 1 |
127869 | 127869 | 2020-05-09 | Livingston | Illinois | 17105 | 24 | 1 |
124882 | 124882 | 2020-05-08 | Livingston | Illinois | 17105 | 24 | 1 |
121903 | 121903 | 2020-05-07 | Livingston | Illinois | 17105 | 24 | 1 |
118933 | 118933 | 2020-05-06 | Livingston | Illinois | 17105 | 23 | 1 |
115973 | 115973 | 2020-05-05 | Livingston | Illinois | 17105 | 23 | 1 |
113090 | 113090 | 2020-05-04 | Livingston | Illinois | 17105 | 23 | 1 |
110215 | 110215 | 2020-05-03 | Livingston | Illinois | 17105 | 24 | 1 |
107345 | 107345 | 2020-05-02 | Livingston | Illinois | 17105 | 21 | 1 |
104480 | 104480 | 2020-05-01 | Livingston | Illinois | 17105 | 20 | 1 |
101624 | 101624 | 2020-04-30 | Livingston | Illinois | 17105 | 20 | 1 |
98773 | 98773 | 2020-04-29 | Livingston | Illinois | 17105 | 20 | 1 |
95929 | 95929 | 2020-04-28 | Livingston | Illinois | 17105 | 20 | 1 |
93097 | 93097 | 2020-04-27 | Livingston | Illinois | 17105 | 20 | 1 |
90278 | 90278 | 2020-04-26 | Livingston | Illinois | 17105 | 20 | 1 |
87462 | 87462 | 2020-04-25 | Livingston | Illinois | 17105 | 20 | 1 |
84652 | 84652 | 2020-04-24 | Livingston | Illinois | 17105 | 18 | 1 |
81852 | 81852 | 2020-04-23 | Livingston | Illinois | 17105 | 18 | 1 |
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);