ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 46, fips = 17079 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
294010 | 294010 | 2020-07-02 | Jasper | Illinois | 17079 | 46 | 7 |
290856 | 290856 | 2020-07-01 | Jasper | Illinois | 17079 | 46 | 7 |
287706 | 287706 | 2020-06-30 | Jasper | Illinois | 17079 | 46 | 7 |
284557 | 284557 | 2020-06-29 | Jasper | Illinois | 17079 | 46 | 7 |
281412 | 281412 | 2020-06-28 | Jasper | Illinois | 17079 | 46 | 7 |
278264 | 278264 | 2020-06-27 | Jasper | Illinois | 17079 | 46 | 7 |
275116 | 275116 | 2020-06-26 | Jasper | Illinois | 17079 | 46 | 7 |
271974 | 271974 | 2020-06-25 | Jasper | Illinois | 17079 | 46 | 7 |
268837 | 268837 | 2020-06-24 | Jasper | Illinois | 17079 | 46 | 7 |
265707 | 265707 | 2020-06-23 | Jasper | Illinois | 17079 | 46 | 7 |
262579 | 262579 | 2020-06-22 | Jasper | Illinois | 17079 | 46 | 7 |
259452 | 259452 | 2020-06-21 | Jasper | Illinois | 17079 | 46 | 7 |
256326 | 256326 | 2020-06-20 | Jasper | Illinois | 17079 | 46 | 7 |
253206 | 253206 | 2020-06-19 | Jasper | Illinois | 17079 | 46 | 7 |
250091 | 250091 | 2020-06-18 | Jasper | Illinois | 17079 | 46 | 7 |
246979 | 246979 | 2020-06-17 | Jasper | Illinois | 17079 | 46 | 7 |
243866 | 243866 | 2020-06-16 | Jasper | Illinois | 17079 | 46 | 7 |
240755 | 240755 | 2020-06-15 | Jasper | Illinois | 17079 | 46 | 7 |
237647 | 237647 | 2020-06-14 | Jasper | Illinois | 17079 | 46 | 7 |
234540 | 234540 | 2020-06-13 | Jasper | Illinois | 17079 | 46 | 7 |
231434 | 231434 | 2020-06-12 | Jasper | Illinois | 17079 | 46 | 7 |
228331 | 228331 | 2020-06-11 | Jasper | Illinois | 17079 | 46 | 7 |
225229 | 225229 | 2020-06-10 | Jasper | Illinois | 17079 | 46 | 7 |
222134 | 222134 | 2020-06-09 | Jasper | Illinois | 17079 | 46 | 7 |
219039 | 219039 | 2020-06-08 | Jasper | Illinois | 17079 | 46 | 7 |
215948 | 215948 | 2020-06-07 | Jasper | Illinois | 17079 | 46 | 7 |
212861 | 212861 | 2020-06-06 | Jasper | Illinois | 17079 | 46 | 7 |
209776 | 209776 | 2020-06-05 | Jasper | Illinois | 17079 | 46 | 7 |
206695 | 206695 | 2020-06-04 | Jasper | Illinois | 17079 | 46 | 7 |
203615 | 203615 | 2020-06-03 | Jasper | Illinois | 17079 | 46 | 7 |
200539 | 200539 | 2020-06-02 | Jasper | Illinois | 17079 | 46 | 7 |
148818 | 148818 | 2020-05-16 | Jasper | Illinois | 17079 | 46 | 8 |
136827 | 136827 | 2020-05-12 | Jasper | Illinois | 17079 | 46 | 6 |
133838 | 133838 | 2020-05-11 | Jasper | Illinois | 17079 | 46 | 6 |
130847 | 130847 | 2020-05-10 | Jasper | Illinois | 17079 | 46 | 6 |
127856 | 127856 | 2020-05-09 | Jasper | Illinois | 17079 | 46 | 6 |
124869 | 124869 | 2020-05-08 | Jasper | Illinois | 17079 | 46 | 6 |
121890 | 121890 | 2020-05-07 | Jasper | Illinois | 17079 | 46 | 5 |
118920 | 118920 | 2020-05-06 | Jasper | Illinois | 17079 | 46 | 5 |
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);