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 |
---|---|---|---|---|---|---|---|
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 |
79049 | 79049 | 2020-04-22 | Jo Daviess | Illinois | 17085 | 11 | 0 |
76265 | 76265 | 2020-04-21 | Jo Daviess | Illinois | 17085 | 11 | 0 |
73488 | 73488 | 2020-04-20 | Jo Daviess | Illinois | 17085 | 12 | 0 |
70718 | 70718 | 2020-04-19 | Jo Daviess | Illinois | 17085 | 12 | 0 |
67956 | 67956 | 2020-04-18 | Jo Daviess | Illinois | 17085 | 12 | 0 |
65207 | 65207 | 2020-04-17 | Jo Daviess | Illinois | 17085 | 11 | 0 |
62474 | 62474 | 2020-04-16 | Jo Daviess | Illinois | 17085 | 11 | 0 |
59753 | 59753 | 2020-04-15 | Jo Daviess | Illinois | 17085 | 11 | 0 |
57046 | 57046 | 2020-04-14 | Jo Daviess | Illinois | 17085 | 11 | 0 |
54353 | 54353 | 2020-04-13 | Jo Daviess | Illinois | 17085 | 11 | 0 |
51673 | 51673 | 2020-04-12 | Jo Daviess | Illinois | 17085 | 11 | 0 |
49011 | 49011 | 2020-04-11 | Jo Daviess | Illinois | 17085 | 10 | 0 |
46380 | 46380 | 2020-04-10 | Jo Daviess | Illinois | 17085 | 10 | 0 |
43776 | 43776 | 2020-04-09 | Jo Daviess | Illinois | 17085 | 9 | 0 |
41202 | 41202 | 2020-04-08 | Jo Daviess | Illinois | 17085 | 8 | 0 |
38657 | 38657 | 2020-04-07 | Jo Daviess | Illinois | 17085 | 6 | 0 |
36162 | 36162 | 2020-04-06 | Jo Daviess | Illinois | 17085 | 6 | 0 |
33710 | 33710 | 2020-04-05 | Jo Daviess | Illinois | 17085 | 5 | 0 |
31300 | 31300 | 2020-04-04 | Jo Daviess | Illinois | 17085 | 4 | 0 |
28937 | 28937 | 2020-04-03 | Jo Daviess | Illinois | 17085 | 4 | 0 |
26627 | 26627 | 2020-04-02 | Jo Daviess | Illinois | 17085 | 3 | 0 |
24394 | 24394 | 2020-04-01 | Jo Daviess | Illinois | 17085 | 3 | 0 |
22226 | 22226 | 2020-03-31 | Jo Daviess | Illinois | 17085 | 1 | 0 |
20134 | 20134 | 2020-03-30 | Jo Daviess | Illinois | 17085 | 1 | 0 |
18132 | 18132 | 2020-03-29 | Jo Daviess | Illinois | 17085 | 1 | 0 |
16233 | 16233 | 2020-03-28 | Jo Daviess | Illinois | 17085 | 1 | 0 |
14438 | 14438 | 2020-03-27 | Jo Daviess | Illinois | 17085 | 1 | 0 |
12760 | 12760 | 2020-03-26 | Jo Daviess | Illinois | 17085 | 1 | 0 |
11204 | 11204 | 2020-03-25 | Jo Daviess | Illinois | 17085 | 1 | 0 |
9813 | 9813 | 2020-03-24 | Jo Daviess | Illinois | 17085 | 1 | 0 |
8549 | 8549 | 2020-03-23 | Jo Daviess | Illinois | 17085 | 1 | 0 |
7394 | 7394 | 2020-03-22 | Jo Daviess | Illinois | 17085 | 1 | 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);