ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jo Daviess" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386577 | 386577 | 2020-07-31 | Jo Daviess | Illinois | 17085 | 110 | 1 |
383359 | 383359 | 2020-07-30 | Jo Daviess | Illinois | 17085 | 108 | 1 |
380142 | 380142 | 2020-07-29 | Jo Daviess | Illinois | 17085 | 106 | 1 |
376925 | 376925 | 2020-07-28 | Jo Daviess | Illinois | 17085 | 103 | 1 |
373710 | 373710 | 2020-07-27 | Jo Daviess | Illinois | 17085 | 99 | 1 |
370498 | 370498 | 2020-07-26 | Jo Daviess | Illinois | 17085 | 96 | 1 |
367288 | 367288 | 2020-07-25 | Jo Daviess | Illinois | 17085 | 92 | 1 |
364081 | 364081 | 2020-07-24 | Jo Daviess | Illinois | 17085 | 88 | 1 |
360874 | 360874 | 2020-07-23 | Jo Daviess | Illinois | 17085 | 84 | 1 |
357669 | 357669 | 2020-07-22 | Jo Daviess | Illinois | 17085 | 80 | 1 |
354467 | 354467 | 2020-07-21 | Jo Daviess | Illinois | 17085 | 70 | 1 |
351265 | 351265 | 2020-07-20 | Jo Daviess | Illinois | 17085 | 66 | 1 |
348065 | 348065 | 2020-07-19 | Jo Daviess | Illinois | 17085 | 64 | 1 |
344864 | 344864 | 2020-07-18 | Jo Daviess | Illinois | 17085 | 63 | 1 |
341664 | 341664 | 2020-07-17 | Jo Daviess | Illinois | 17085 | 58 | 1 |
338468 | 338468 | 2020-07-16 | Jo Daviess | Illinois | 17085 | 58 | 1 |
335272 | 335272 | 2020-07-15 | Jo Daviess | Illinois | 17085 | 57 | 1 |
332079 | 332079 | 2020-07-14 | Jo Daviess | Illinois | 17085 | 55 | 1 |
328892 | 328892 | 2020-07-13 | Jo Daviess | Illinois | 17085 | 56 | 1 |
325706 | 325706 | 2020-07-12 | Jo Daviess | Illinois | 17085 | 55 | 1 |
322525 | 322525 | 2020-07-11 | Jo Daviess | Illinois | 17085 | 54 | 1 |
319346 | 319346 | 2020-07-10 | Jo Daviess | Illinois | 17085 | 52 | 1 |
316173 | 316173 | 2020-07-09 | Jo Daviess | Illinois | 17085 | 49 | 1 |
312999 | 312999 | 2020-07-08 | Jo Daviess | Illinois | 17085 | 49 | 1 |
309829 | 309829 | 2020-07-07 | Jo Daviess | Illinois | 17085 | 47 | 1 |
306661 | 306661 | 2020-07-06 | Jo Daviess | Illinois | 17085 | 47 | 1 |
303496 | 303496 | 2020-07-05 | Jo Daviess | Illinois | 17085 | 46 | 1 |
300332 | 300332 | 2020-07-04 | Jo Daviess | Illinois | 17085 | 45 | 1 |
297170 | 297170 | 2020-07-03 | Jo Daviess | Illinois | 17085 | 46 | 1 |
294013 | 294013 | 2020-07-02 | Jo Daviess | Illinois | 17085 | 45 | 1 |
290859 | 290859 | 2020-07-01 | Jo Daviess | Illinois | 17085 | 44 | 1 |
287709 | 287709 | 2020-06-30 | Jo Daviess | Illinois | 17085 | 42 | 1 |
284560 | 284560 | 2020-06-29 | Jo Daviess | Illinois | 17085 | 42 | 1 |
281415 | 281415 | 2020-06-28 | Jo Daviess | Illinois | 17085 | 42 | 1 |
278267 | 278267 | 2020-06-27 | Jo Daviess | Illinois | 17085 | 40 | 1 |
275119 | 275119 | 2020-06-26 | Jo Daviess | Illinois | 17085 | 40 | 1 |
271977 | 271977 | 2020-06-25 | Jo Daviess | Illinois | 17085 | 39 | 1 |
268840 | 268840 | 2020-06-24 | Jo Daviess | Illinois | 17085 | 39 | 1 |
265710 | 265710 | 2020-06-23 | Jo Daviess | Illinois | 17085 | 38 | 1 |
262582 | 262582 | 2020-06-22 | Jo Daviess | Illinois | 17085 | 38 | 1 |
259455 | 259455 | 2020-06-21 | Jo Daviess | Illinois | 17085 | 38 | 1 |
256329 | 256329 | 2020-06-20 | Jo Daviess | Illinois | 17085 | 38 | 1 |
253209 | 253209 | 2020-06-19 | Jo Daviess | Illinois | 17085 | 35 | 1 |
250094 | 250094 | 2020-06-18 | Jo Daviess | Illinois | 17085 | 35 | 1 |
246982 | 246982 | 2020-06-17 | Jo Daviess | Illinois | 17085 | 35 | 1 |
243869 | 243869 | 2020-06-16 | Jo Daviess | Illinois | 17085 | 35 | 1 |
240758 | 240758 | 2020-06-15 | Jo Daviess | Illinois | 17085 | 34 | 1 |
237650 | 237650 | 2020-06-14 | Jo Daviess | Illinois | 17085 | 34 | 1 |
234543 | 234543 | 2020-06-13 | Jo Daviess | Illinois | 17085 | 34 | 1 |
231437 | 231437 | 2020-06-12 | Jo Daviess | Illinois | 17085 | 34 | 1 |
228334 | 228334 | 2020-06-11 | Jo Daviess | Illinois | 17085 | 34 | 1 |
225232 | 225232 | 2020-06-10 | Jo Daviess | Illinois | 17085 | 33 | 1 |
222137 | 222137 | 2020-06-09 | Jo Daviess | Illinois | 17085 | 33 | 1 |
219042 | 219042 | 2020-06-08 | Jo Daviess | Illinois | 17085 | 34 | 1 |
215951 | 215951 | 2020-06-07 | Jo Daviess | Illinois | 17085 | 33 | 1 |
212864 | 212864 | 2020-06-06 | Jo Daviess | Illinois | 17085 | 33 | 1 |
209779 | 209779 | 2020-06-05 | Jo Daviess | Illinois | 17085 | 32 | 1 |
206698 | 206698 | 2020-06-04 | Jo Daviess | Illinois | 17085 | 32 | 1 |
203618 | 203618 | 2020-06-03 | Jo Daviess | Illinois | 17085 | 32 | 0 |
200542 | 200542 | 2020-06-02 | Jo Daviess | Illinois | 17085 | 32 | 0 |
197469 | 197469 | 2020-06-01 | Jo Daviess | Illinois | 17085 | 32 | 0 |
194399 | 194399 | 2020-05-31 | Jo Daviess | Illinois | 17085 | 32 | 0 |
191332 | 191332 | 2020-05-30 | Jo Daviess | Illinois | 17085 | 32 | 0 |
188267 | 188267 | 2020-05-29 | Jo Daviess | Illinois | 17085 | 32 | 0 |
185209 | 185209 | 2020-05-28 | Jo Daviess | Illinois | 17085 | 32 | 0 |
182155 | 182155 | 2020-05-27 | Jo Daviess | Illinois | 17085 | 31 | 0 |
179111 | 179111 | 2020-05-26 | Jo Daviess | Illinois | 17085 | 27 | 0 |
176067 | 176067 | 2020-05-25 | Jo Daviess | Illinois | 17085 | 27 | 0 |
173023 | 173023 | 2020-05-24 | Jo Daviess | Illinois | 17085 | 26 | 0 |
169982 | 169982 | 2020-05-23 | Jo Daviess | Illinois | 17085 | 26 | 0 |
166945 | 166945 | 2020-05-22 | Jo Daviess | Illinois | 17085 | 24 | 0 |
163912 | 163912 | 2020-05-21 | Jo Daviess | Illinois | 17085 | 23 | 0 |
160884 | 160884 | 2020-05-20 | Jo Daviess | Illinois | 17085 | 22 | 0 |
157858 | 157858 | 2020-05-19 | Jo Daviess | Illinois | 17085 | 21 | 0 |
154842 | 154842 | 2020-05-18 | Jo Daviess | Illinois | 17085 | 19 | 0 |
151830 | 151830 | 2020-05-17 | Jo Daviess | Illinois | 17085 | 18 | 0 |
148821 | 148821 | 2020-05-16 | Jo Daviess | Illinois | 17085 | 18 | 0 |
145818 | 145818 | 2020-05-15 | Jo Daviess | Illinois | 17085 | 18 | 0 |
142818 | 142818 | 2020-05-14 | Jo Daviess | Illinois | 17085 | 18 | 0 |
139822 | 139822 | 2020-05-13 | Jo Daviess | Illinois | 17085 | 19 | 1 |
136830 | 136830 | 2020-05-12 | Jo Daviess | Illinois | 17085 | 18 | 0 |
133841 | 133841 | 2020-05-11 | Jo Daviess | Illinois | 17085 | 18 | 0 |
130850 | 130850 | 2020-05-10 | Jo Daviess | Illinois | 17085 | 18 | 0 |
127859 | 127859 | 2020-05-09 | Jo Daviess | Illinois | 17085 | 18 | 0 |
124872 | 124872 | 2020-05-08 | Jo Daviess | Illinois | 17085 | 16 | 0 |
121893 | 121893 | 2020-05-07 | Jo Daviess | Illinois | 17085 | 14 | 0 |
118923 | 118923 | 2020-05-06 | Jo Daviess | Illinois | 17085 | 14 | 0 |
115963 | 115963 | 2020-05-05 | Jo Daviess | Illinois | 17085 | 14 | 0 |
113080 | 113080 | 2020-05-04 | Jo Daviess | Illinois | 17085 | 14 | 0 |
110205 | 110205 | 2020-05-03 | Jo Daviess | Illinois | 17085 | 13 | 0 |
107335 | 107335 | 2020-05-02 | Jo Daviess | Illinois | 17085 | 13 | 0 |
104470 | 104470 | 2020-05-01 | Jo Daviess | Illinois | 17085 | 13 | 0 |
101614 | 101614 | 2020-04-30 | Jo Daviess | Illinois | 17085 | 13 | 0 |
98763 | 98763 | 2020-04-29 | Jo Daviess | Illinois | 17085 | 12 | 0 |
95919 | 95919 | 2020-04-28 | Jo Daviess | Illinois | 17085 | 11 | 0 |
93087 | 93087 | 2020-04-27 | Jo Daviess | Illinois | 17085 | 11 | 0 |
90268 | 90268 | 2020-04-26 | Jo Daviess | Illinois | 17085 | 11 | 0 |
87452 | 87452 | 2020-04-25 | Jo Daviess | Illinois | 17085 | 11 | 0 |
84642 | 84642 | 2020-04-24 | Jo Daviess | Illinois | 17085 | 11 | 0 |
81842 | 81842 | 2020-04-23 | Jo Daviess | Illinois | 17085 | 11 | 0 |
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);