ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Lake" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281422 | 281422 | 2020-06-28 | Lake | Illinois | 17097 | 9644 | 415 |
278274 | 278274 | 2020-06-27 | Lake | Illinois | 17097 | 9608 | 414 |
275126 | 275126 | 2020-06-26 | Lake | Illinois | 17097 | 9561 | 412 |
271984 | 271984 | 2020-06-25 | Lake | Illinois | 17097 | 9514 | 411 |
268847 | 268847 | 2020-06-24 | Lake | Illinois | 17097 | 9468 | 409 |
265717 | 265717 | 2020-06-23 | Lake | Illinois | 17097 | 9411 | 405 |
262589 | 262589 | 2020-06-22 | Lake | Illinois | 17097 | 9356 | 401 |
259462 | 259462 | 2020-06-21 | Lake | Illinois | 17097 | 9326 | 401 |
256336 | 256336 | 2020-06-20 | Lake | Illinois | 17097 | 9279 | 398 |
253216 | 253216 | 2020-06-19 | Lake | Illinois | 17097 | 9244 | 395 |
250101 | 250101 | 2020-06-18 | Lake | Illinois | 17097 | 9221 | 392 |
246989 | 246989 | 2020-06-17 | Lake | Illinois | 17097 | 9154 | 389 |
243876 | 243876 | 2020-06-16 | Lake | Illinois | 17097 | 9147 | 386 |
240765 | 240765 | 2020-06-15 | Lake | Illinois | 17097 | 9123 | 375 |
237657 | 237657 | 2020-06-14 | Lake | Illinois | 17097 | 9076 | 374 |
234550 | 234550 | 2020-06-13 | Lake | Illinois | 17097 | 9033 | 374 |
231444 | 231444 | 2020-06-12 | Lake | Illinois | 17097 | 9021 | 372 |
228341 | 228341 | 2020-06-11 | Lake | Illinois | 17097 | 8962 | 367 |
225239 | 225239 | 2020-06-10 | Lake | Illinois | 17097 | 8924 | 362 |
222144 | 222144 | 2020-06-09 | Lake | Illinois | 17097 | 8890 | 356 |
219049 | 219049 | 2020-06-08 | Lake | Illinois | 17097 | 8839 | 345 |
215958 | 215958 | 2020-06-07 | Lake | Illinois | 17097 | 8768 | 344 |
212871 | 212871 | 2020-06-06 | Lake | Illinois | 17097 | 8690 | 342 |
209786 | 209786 | 2020-06-05 | Lake | Illinois | 17097 | 8683 | 334 |
206705 | 206705 | 2020-06-04 | Lake | Illinois | 17097 | 8619 | 330 |
203625 | 203625 | 2020-06-03 | Lake | Illinois | 17097 | 8562 | 315 |
200549 | 200549 | 2020-06-02 | Lake | Illinois | 17097 | 8511 | 307 |
197476 | 197476 | 2020-06-01 | Lake | Illinois | 17097 | 8456 | 292 |
194406 | 194406 | 2020-05-31 | Lake | Illinois | 17097 | 8373 | 291 |
191339 | 191339 | 2020-05-30 | Lake | Illinois | 17097 | 8238 | 288 |
188274 | 188274 | 2020-05-29 | Lake | Illinois | 17097 | 8063 | 287 |
185216 | 185216 | 2020-05-28 | Lake | Illinois | 17097 | 7933 | 281 |
182162 | 182162 | 2020-05-27 | Lake | Illinois | 17097 | 7845 | 270 |
179118 | 179118 | 2020-05-26 | Lake | Illinois | 17097 | 7767 | 250 |
176074 | 176074 | 2020-05-25 | Lake | Illinois | 17097 | 7723 | 250 |
173030 | 173030 | 2020-05-24 | Lake | Illinois | 17097 | 7615 | 250 |
169989 | 169989 | 2020-05-23 | Lake | Illinois | 17097 | 7465 | 250 |
166952 | 166952 | 2020-05-22 | Lake | Illinois | 17097 | 7291 | 249 |
163919 | 163919 | 2020-05-21 | Lake | Illinois | 17097 | 7128 | 237 |
160891 | 160891 | 2020-05-20 | Lake | Illinois | 17097 | 6905 | 231 |
157865 | 157865 | 2020-05-19 | Lake | Illinois | 17097 | 6709 | 221 |
154849 | 154849 | 2020-05-18 | Lake | Illinois | 17097 | 6645 | 215 |
151837 | 151837 | 2020-05-17 | Lake | Illinois | 17097 | 6489 | 215 |
148828 | 148828 | 2020-05-16 | Lake | Illinois | 17097 | 6382 | 209 |
145825 | 145825 | 2020-05-15 | Lake | Illinois | 17097 | 6157 | 207 |
142825 | 142825 | 2020-05-14 | Lake | Illinois | 17097 | 5992 | 202 |
139829 | 139829 | 2020-05-13 | Lake | Illinois | 17097 | 5758 | 194 |
136837 | 136837 | 2020-05-12 | Lake | Illinois | 17097 | 5662 | 185 |
133848 | 133848 | 2020-05-11 | Lake | Illinois | 17097 | 5323 | 173 |
130857 | 130857 | 2020-05-10 | Lake | Illinois | 17097 | 5245 | 173 |
127866 | 127866 | 2020-05-09 | Lake | Illinois | 17097 | 5199 | 173 |
124879 | 124879 | 2020-05-08 | Lake | Illinois | 17097 | 4985 | 170 |
121900 | 121900 | 2020-05-07 | Lake | Illinois | 17097 | 4762 | 165 |
118930 | 118930 | 2020-05-06 | Lake | Illinois | 17097 | 4529 | 162 |
115970 | 115970 | 2020-05-05 | Lake | Illinois | 17097 | 4370 | 151 |
113087 | 113087 | 2020-05-04 | Lake | Illinois | 17097 | 4252 | 151 |
110212 | 110212 | 2020-05-03 | Lake | Illinois | 17097 | 4161 | 145 |
107342 | 107342 | 2020-05-02 | Lake | Illinois | 17097 | 3975 | 141 |
104477 | 104477 | 2020-05-01 | Lake | Illinois | 17097 | 3766 | 140 |
101621 | 101621 | 2020-04-30 | Lake | Illinois | 17097 | 3509 | 138 |
98770 | 98770 | 2020-04-29 | Lake | Illinois | 17097 | 3382 | 128 |
95926 | 95926 | 2020-04-28 | Lake | Illinois | 17097 | 3192 | 123 |
93094 | 93094 | 2020-04-27 | Lake | Illinois | 17097 | 3080 | 118 |
90275 | 90275 | 2020-04-26 | Lake | Illinois | 17097 | 2990 | 118 |
87459 | 87459 | 2020-04-25 | Lake | Illinois | 17097 | 2879 | 115 |
84649 | 84649 | 2020-04-24 | Lake | Illinois | 17097 | 2717 | 105 |
81849 | 81849 | 2020-04-23 | Lake | Illinois | 17097 | 2540 | 100 |
79056 | 79056 | 2020-04-22 | Lake | Illinois | 17097 | 2379 | 89 |
76272 | 76272 | 2020-04-21 | Lake | Illinois | 17097 | 2287 | 87 |
73495 | 73495 | 2020-04-20 | Lake | Illinois | 17097 | 2216 | 82 |
70725 | 70725 | 2020-04-19 | Lake | Illinois | 17097 | 2162 | 75 |
67963 | 67963 | 2020-04-18 | Lake | Illinois | 17097 | 2073 | 75 |
65214 | 65214 | 2020-04-17 | Lake | Illinois | 17097 | 1914 | 71 |
62481 | 62481 | 2020-04-16 | Lake | Illinois | 17097 | 1767 | 70 |
59760 | 59760 | 2020-04-15 | Lake | Illinois | 17097 | 1711 | 65 |
57053 | 57053 | 2020-04-14 | Lake | Illinois | 17097 | 1621 | 58 |
54360 | 54360 | 2020-04-13 | Lake | Illinois | 17097 | 1516 | 45 |
51679 | 51679 | 2020-04-12 | Lake | Illinois | 17097 | 1445 | 42 |
49017 | 49017 | 2020-04-11 | Lake | Illinois | 17097 | 1331 | 39 |
46386 | 46386 | 2020-04-10 | Lake | Illinois | 17097 | 1230 | 34 |
43782 | 43782 | 2020-04-09 | Lake | Illinois | 17097 | 1124 | 29 |
41208 | 41208 | 2020-04-08 | Lake | Illinois | 17097 | 1041 | 23 |
38663 | 38663 | 2020-04-07 | Lake | Illinois | 17097 | 925 | 22 |
36168 | 36168 | 2020-04-06 | Lake | Illinois | 17097 | 815 | 15 |
33716 | 33716 | 2020-04-05 | Lake | Illinois | 17097 | 742 | 15 |
31306 | 31306 | 2020-04-04 | Lake | Illinois | 17097 | 689 | 14 |
28943 | 28943 | 2020-04-03 | Lake | Illinois | 17097 | 608 | 14 |
26633 | 26633 | 2020-04-02 | Lake | Illinois | 17097 | 540 | 7 |
24400 | 24400 | 2020-04-01 | Lake | Illinois | 17097 | 477 | 7 |
22232 | 22232 | 2020-03-31 | Lake | Illinois | 17097 | 389 | 7 |
20140 | 20140 | 2020-03-30 | Lake | Illinois | 17097 | 343 | 5 |
18138 | 18138 | 2020-03-29 | Lake | Illinois | 17097 | 300 | 3 |
16238 | 16238 | 2020-03-28 | Lake | Illinois | 17097 | 264 | 2 |
14443 | 14443 | 2020-03-27 | Lake | Illinois | 17097 | 230 | 2 |
12765 | 12765 | 2020-03-26 | Lake | Illinois | 17097 | 185 | 0 |
11209 | 11209 | 2020-03-25 | Lake | Illinois | 17097 | 139 | 0 |
9818 | 9818 | 2020-03-24 | Lake | Illinois | 17097 | 111 | 0 |
8554 | 8554 | 2020-03-23 | Lake | Illinois | 17097 | 96 | 0 |
7399 | 7399 | 2020-03-22 | Lake | Illinois | 17097 | 69 | 0 |
6348 | 6348 | 2020-03-21 | Lake | Illinois | 17097 | 63 | 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);