ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Jasper" and state = "Illinois" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
31298 | 31298 | 2020-04-04 | Jasper | Illinois | 17079 | 2 | 0 |
33708 | 33708 | 2020-04-05 | Jasper | Illinois | 17079 | 3 | 0 |
36159 | 36159 | 2020-04-06 | Jasper | Illinois | 17079 | 4 | 0 |
38654 | 38654 | 2020-04-07 | Jasper | Illinois | 17079 | 3 | 0 |
41199 | 41199 | 2020-04-08 | Jasper | Illinois | 17079 | 3 | 0 |
43773 | 43773 | 2020-04-09 | Jasper | Illinois | 17079 | 3 | 0 |
46377 | 46377 | 2020-04-10 | Jasper | Illinois | 17079 | 3 | 0 |
49008 | 49008 | 2020-04-11 | Jasper | Illinois | 17079 | 3 | 0 |
51670 | 51670 | 2020-04-12 | Jasper | Illinois | 17079 | 3 | 0 |
54350 | 54350 | 2020-04-13 | Jasper | Illinois | 17079 | 3 | 1 |
57043 | 57043 | 2020-04-14 | Jasper | Illinois | 17079 | 3 | 1 |
59750 | 59750 | 2020-04-15 | Jasper | Illinois | 17079 | 3 | 1 |
62471 | 62471 | 2020-04-16 | Jasper | Illinois | 17079 | 3 | 1 |
65204 | 65204 | 2020-04-17 | Jasper | Illinois | 17079 | 4 | 1 |
67953 | 67953 | 2020-04-18 | Jasper | Illinois | 17079 | 7 | 1 |
70715 | 70715 | 2020-04-19 | Jasper | Illinois | 17079 | 20 | 1 |
73485 | 73485 | 2020-04-20 | Jasper | Illinois | 17079 | 20 | 2 |
76262 | 76262 | 2020-04-21 | Jasper | Illinois | 17079 | 36 | 2 |
79046 | 79046 | 2020-04-22 | Jasper | Illinois | 17079 | 36 | 2 |
81839 | 81839 | 2020-04-23 | Jasper | Illinois | 17079 | 40 | 2 |
84639 | 84639 | 2020-04-24 | Jasper | Illinois | 17079 | 41 | 2 |
87449 | 87449 | 2020-04-25 | Jasper | Illinois | 17079 | 42 | 2 |
90265 | 90265 | 2020-04-26 | Jasper | Illinois | 17079 | 41 | 2 |
93084 | 93084 | 2020-04-27 | Jasper | Illinois | 17079 | 42 | 3 |
95916 | 95916 | 2020-04-28 | Jasper | Illinois | 17079 | 44 | 3 |
98760 | 98760 | 2020-04-29 | Jasper | Illinois | 17079 | 44 | 4 |
101611 | 101611 | 2020-04-30 | Jasper | Illinois | 17079 | 44 | 5 |
104467 | 104467 | 2020-05-01 | Jasper | Illinois | 17079 | 44 | 5 |
107332 | 107332 | 2020-05-02 | Jasper | Illinois | 17079 | 45 | 5 |
110202 | 110202 | 2020-05-03 | Jasper | Illinois | 17079 | 45 | 5 |
113077 | 113077 | 2020-05-04 | Jasper | Illinois | 17079 | 48 | 5 |
115960 | 115960 | 2020-05-05 | Jasper | Illinois | 17079 | 48 | 5 |
118920 | 118920 | 2020-05-06 | Jasper | Illinois | 17079 | 46 | 5 |
121890 | 121890 | 2020-05-07 | Jasper | Illinois | 17079 | 46 | 5 |
124869 | 124869 | 2020-05-08 | Jasper | Illinois | 17079 | 46 | 6 |
127856 | 127856 | 2020-05-09 | Jasper | Illinois | 17079 | 46 | 6 |
130847 | 130847 | 2020-05-10 | Jasper | Illinois | 17079 | 46 | 6 |
133838 | 133838 | 2020-05-11 | Jasper | Illinois | 17079 | 46 | 6 |
136827 | 136827 | 2020-05-12 | Jasper | Illinois | 17079 | 46 | 6 |
139819 | 139819 | 2020-05-13 | Jasper | Illinois | 17079 | 45 | 7 |
142815 | 142815 | 2020-05-14 | Jasper | Illinois | 17079 | 45 | 7 |
145815 | 145815 | 2020-05-15 | Jasper | Illinois | 17079 | 45 | 7 |
148818 | 148818 | 2020-05-16 | Jasper | Illinois | 17079 | 46 | 8 |
151827 | 151827 | 2020-05-17 | Jasper | Illinois | 17079 | 45 | 7 |
154839 | 154839 | 2020-05-18 | Jasper | Illinois | 17079 | 45 | 7 |
157855 | 157855 | 2020-05-19 | Jasper | Illinois | 17079 | 45 | 7 |
160881 | 160881 | 2020-05-20 | Jasper | Illinois | 17079 | 45 | 7 |
163909 | 163909 | 2020-05-21 | Jasper | Illinois | 17079 | 45 | 7 |
166942 | 166942 | 2020-05-22 | Jasper | Illinois | 17079 | 45 | 7 |
169979 | 169979 | 2020-05-23 | Jasper | Illinois | 17079 | 45 | 7 |
173020 | 173020 | 2020-05-24 | Jasper | Illinois | 17079 | 45 | 7 |
176064 | 176064 | 2020-05-25 | Jasper | Illinois | 17079 | 45 | 7 |
179108 | 179108 | 2020-05-26 | Jasper | Illinois | 17079 | 45 | 7 |
182152 | 182152 | 2020-05-27 | Jasper | Illinois | 17079 | 45 | 7 |
185206 | 185206 | 2020-05-28 | Jasper | Illinois | 17079 | 45 | 7 |
188264 | 188264 | 2020-05-29 | Jasper | Illinois | 17079 | 45 | 7 |
191329 | 191329 | 2020-05-30 | Jasper | Illinois | 17079 | 45 | 7 |
194396 | 194396 | 2020-05-31 | Jasper | Illinois | 17079 | 45 | 7 |
197466 | 197466 | 2020-06-01 | Jasper | Illinois | 17079 | 45 | 7 |
200539 | 200539 | 2020-06-02 | Jasper | Illinois | 17079 | 46 | 7 |
203615 | 203615 | 2020-06-03 | Jasper | Illinois | 17079 | 46 | 7 |
206695 | 206695 | 2020-06-04 | Jasper | Illinois | 17079 | 46 | 7 |
209776 | 209776 | 2020-06-05 | Jasper | Illinois | 17079 | 46 | 7 |
212861 | 212861 | 2020-06-06 | Jasper | Illinois | 17079 | 46 | 7 |
215948 | 215948 | 2020-06-07 | Jasper | Illinois | 17079 | 46 | 7 |
219039 | 219039 | 2020-06-08 | Jasper | Illinois | 17079 | 46 | 7 |
222134 | 222134 | 2020-06-09 | Jasper | Illinois | 17079 | 46 | 7 |
225229 | 225229 | 2020-06-10 | Jasper | Illinois | 17079 | 46 | 7 |
228331 | 228331 | 2020-06-11 | Jasper | Illinois | 17079 | 46 | 7 |
231434 | 231434 | 2020-06-12 | Jasper | Illinois | 17079 | 46 | 7 |
234540 | 234540 | 2020-06-13 | Jasper | Illinois | 17079 | 46 | 7 |
237647 | 237647 | 2020-06-14 | Jasper | Illinois | 17079 | 46 | 7 |
240755 | 240755 | 2020-06-15 | Jasper | Illinois | 17079 | 46 | 7 |
243866 | 243866 | 2020-06-16 | Jasper | Illinois | 17079 | 46 | 7 |
246979 | 246979 | 2020-06-17 | Jasper | Illinois | 17079 | 46 | 7 |
250091 | 250091 | 2020-06-18 | Jasper | Illinois | 17079 | 46 | 7 |
253206 | 253206 | 2020-06-19 | Jasper | Illinois | 17079 | 46 | 7 |
256326 | 256326 | 2020-06-20 | Jasper | Illinois | 17079 | 46 | 7 |
259452 | 259452 | 2020-06-21 | Jasper | Illinois | 17079 | 46 | 7 |
262579 | 262579 | 2020-06-22 | Jasper | Illinois | 17079 | 46 | 7 |
265707 | 265707 | 2020-06-23 | Jasper | Illinois | 17079 | 46 | 7 |
268837 | 268837 | 2020-06-24 | Jasper | Illinois | 17079 | 46 | 7 |
271974 | 271974 | 2020-06-25 | Jasper | Illinois | 17079 | 46 | 7 |
275116 | 275116 | 2020-06-26 | Jasper | Illinois | 17079 | 46 | 7 |
278264 | 278264 | 2020-06-27 | Jasper | Illinois | 17079 | 46 | 7 |
281412 | 281412 | 2020-06-28 | Jasper | Illinois | 17079 | 46 | 7 |
284557 | 284557 | 2020-06-29 | Jasper | Illinois | 17079 | 46 | 7 |
287706 | 287706 | 2020-06-30 | Jasper | Illinois | 17079 | 46 | 7 |
290856 | 290856 | 2020-07-01 | Jasper | Illinois | 17079 | 46 | 7 |
294010 | 294010 | 2020-07-02 | Jasper | Illinois | 17079 | 46 | 7 |
297167 | 297167 | 2020-07-03 | Jasper | Illinois | 17079 | 47 | 7 |
300329 | 300329 | 2020-07-04 | Jasper | Illinois | 17079 | 47 | 7 |
303493 | 303493 | 2020-07-05 | Jasper | Illinois | 17079 | 47 | 7 |
306658 | 306658 | 2020-07-06 | Jasper | Illinois | 17079 | 47 | 7 |
309826 | 309826 | 2020-07-07 | Jasper | Illinois | 17079 | 47 | 7 |
312996 | 312996 | 2020-07-08 | Jasper | Illinois | 17079 | 47 | 7 |
316170 | 316170 | 2020-07-09 | Jasper | Illinois | 17079 | 47 | 7 |
319343 | 319343 | 2020-07-10 | Jasper | Illinois | 17079 | 47 | 7 |
322522 | 322522 | 2020-07-11 | Jasper | Illinois | 17079 | 47 | 7 |
325703 | 325703 | 2020-07-12 | Jasper | Illinois | 17079 | 47 | 7 |
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);