ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lake" and state = "Indiana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3384 | 3384 | 2020-03-17 | Lake | Indiana | 18089 | 2 | 0 |
3957 | 3957 | 2020-03-18 | Lake | Indiana | 18089 | 3 | 0 |
4633 | 4633 | 2020-03-19 | Lake | Indiana | 18089 | 4 | 0 |
5441 | 5441 | 2020-03-20 | Lake | Indiana | 18089 | 6 | 0 |
6380 | 6380 | 2020-03-21 | Lake | Indiana | 18089 | 7 | 0 |
7434 | 7434 | 2020-03-22 | Lake | Indiana | 18089 | 10 | 0 |
8592 | 8592 | 2020-03-23 | Lake | Indiana | 18089 | 11 | 0 |
9861 | 9861 | 2020-03-24 | Lake | Indiana | 18089 | 17 | 0 |
11256 | 11256 | 2020-03-25 | Lake | Indiana | 18089 | 19 | 0 |
12813 | 12813 | 2020-03-26 | Lake | Indiana | 18089 | 31 | 0 |
14498 | 14498 | 2020-03-27 | Lake | Indiana | 18089 | 47 | 0 |
16296 | 16296 | 2020-03-28 | Lake | Indiana | 18089 | 68 | 1 |
18200 | 18200 | 2020-03-29 | Lake | Indiana | 18089 | 85 | 1 |
20206 | 20206 | 2020-03-30 | Lake | Indiana | 18089 | 98 | 2 |
22301 | 22301 | 2020-03-31 | Lake | Indiana | 18089 | 147 | 6 |
24472 | 24472 | 2020-04-01 | Lake | Indiana | 18089 | 181 | 7 |
26711 | 26711 | 2020-04-02 | Lake | Indiana | 18089 | 216 | 7 |
29021 | 29021 | 2020-04-03 | Lake | Indiana | 18089 | 245 | 8 |
31387 | 31387 | 2020-04-04 | Lake | Indiana | 18089 | 314 | 9 |
33798 | 33798 | 2020-04-05 | Lake | Indiana | 18089 | 336 | 9 |
36251 | 36251 | 2020-04-06 | Lake | Indiana | 18089 | 370 | 9 |
38749 | 38749 | 2020-04-07 | Lake | Indiana | 18089 | 419 | 12 |
41295 | 41295 | 2020-04-08 | Lake | Indiana | 18089 | 462 | 13 |
43871 | 43871 | 2020-04-09 | Lake | Indiana | 18089 | 527 | 21 |
46475 | 46475 | 2020-04-10 | Lake | Indiana | 18089 | 578 | 25 |
49109 | 49109 | 2020-04-11 | Lake | Indiana | 18089 | 679 | 28 |
51772 | 51772 | 2020-04-12 | Lake | Indiana | 18089 | 747 | 28 |
54453 | 54453 | 2020-04-13 | Lake | Indiana | 18089 | 799 | 29 |
57146 | 57146 | 2020-04-14 | Lake | Indiana | 18089 | 822 | 34 |
59854 | 59854 | 2020-04-15 | Lake | Indiana | 18089 | 880 | 37 |
62575 | 62575 | 2020-04-16 | Lake | Indiana | 18089 | 983 | 46 |
65309 | 65309 | 2020-04-17 | Lake | Indiana | 18089 | 1032 | 48 |
68058 | 68058 | 2020-04-18 | Lake | Indiana | 18089 | 1102 | 50 |
70820 | 70820 | 2020-04-19 | Lake | Indiana | 18089 | 1112 | 52 |
73591 | 73591 | 2020-04-20 | Lake | Indiana | 18089 | 1189 | 54 |
76368 | 76368 | 2020-04-21 | Lake | Indiana | 18089 | 1235 | 62 |
79152 | 79152 | 2020-04-22 | Lake | Indiana | 18089 | 1301 | 65 |
81945 | 81945 | 2020-04-23 | Lake | Indiana | 18089 | 1358 | 69 |
84745 | 84745 | 2020-04-24 | Lake | Indiana | 18089 | 1457 | 71 |
87555 | 87555 | 2020-04-25 | Lake | Indiana | 18089 | 1528 | 76 |
90371 | 90371 | 2020-04-26 | Lake | Indiana | 18089 | 1546 | 78 |
93190 | 93190 | 2020-04-27 | Lake | Indiana | 18089 | 1602 | 75 |
96022 | 96022 | 2020-04-28 | Lake | Indiana | 18089 | 1731 | 82 |
98866 | 98866 | 2020-04-29 | Lake | Indiana | 18089 | 1806 | 88 |
101717 | 101717 | 2020-04-30 | Lake | Indiana | 18089 | 1866 | 90 |
104573 | 104573 | 2020-05-01 | Lake | Indiana | 18089 | 1952 | 101 |
107438 | 107438 | 2020-05-02 | Lake | Indiana | 18089 | 2015 | 104 |
110308 | 110308 | 2020-05-03 | Lake | Indiana | 18089 | 2058 | 104 |
113183 | 113183 | 2020-05-04 | Lake | Indiana | 18089 | 2120 | 106 |
116066 | 116066 | 2020-05-05 | Lake | Indiana | 18089 | 2184 | 112 |
119026 | 119026 | 2020-05-06 | Lake | Indiana | 18089 | 2257 | 116 |
121996 | 121996 | 2020-05-07 | Lake | Indiana | 18089 | 2312 | 121 |
124976 | 124976 | 2020-05-08 | Lake | Indiana | 18089 | 2383 | 128 |
127963 | 127963 | 2020-05-09 | Lake | Indiana | 18089 | 2416 | 132 |
130954 | 130954 | 2020-05-10 | Lake | Indiana | 18089 | 2469 | 134 |
133944 | 133944 | 2020-05-11 | Lake | Indiana | 18089 | 2516 | 135 |
136933 | 136933 | 2020-05-12 | Lake | Indiana | 18089 | 2559 | 138 |
139925 | 139925 | 2020-05-13 | Lake | Indiana | 18089 | 2614 | 142 |
142921 | 142921 | 2020-05-14 | Lake | Indiana | 18089 | 2710 | 144 |
145921 | 145921 | 2020-05-15 | Lake | Indiana | 18089 | 2773 | 146 |
148925 | 148925 | 2020-05-16 | Lake | Indiana | 18089 | 2840 | 150 |
151934 | 151934 | 2020-05-17 | Lake | Indiana | 18089 | 2871 | 150 |
154946 | 154946 | 2020-05-18 | Lake | Indiana | 18089 | 2914 | 150 |
157962 | 157962 | 2020-05-19 | Lake | Indiana | 18089 | 2974 | 154 |
160988 | 160988 | 2020-05-20 | Lake | Indiana | 18089 | 3053 | 160 |
164016 | 164016 | 2020-05-21 | Lake | Indiana | 18089 | 3116 | 174 |
167049 | 167049 | 2020-05-22 | Lake | Indiana | 18089 | 3157 | 178 |
170086 | 170086 | 2020-05-23 | Lake | Indiana | 18089 | 3220 | 179 |
173127 | 173127 | 2020-05-24 | Lake | Indiana | 18089 | 3289 | 179 |
176171 | 176171 | 2020-05-25 | Lake | Indiana | 18089 | 3328 | 179 |
179215 | 179215 | 2020-05-26 | Lake | Indiana | 18089 | 3349 | 180 |
182259 | 182259 | 2020-05-27 | Lake | Indiana | 18089 | 3378 | 182 |
185313 | 185313 | 2020-05-28 | Lake | Indiana | 18089 | 3525 | 187 |
188371 | 188371 | 2020-05-29 | Lake | Indiana | 18089 | 3571 | 198 |
191436 | 191436 | 2020-05-30 | Lake | Indiana | 18089 | 3607 | 200 |
194503 | 194503 | 2020-05-31 | Lake | Indiana | 18089 | 3650 | 204 |
197573 | 197573 | 2020-06-01 | Lake | Indiana | 18089 | 3673 | 204 |
200646 | 200646 | 2020-06-02 | Lake | Indiana | 18089 | 3723 | 214 |
203722 | 203722 | 2020-06-03 | Lake | Indiana | 18089 | 3840 | 216 |
206802 | 206802 | 2020-06-04 | Lake | Indiana | 18089 | 3867 | 217 |
209883 | 209883 | 2020-06-05 | Lake | Indiana | 18089 | 3911 | 222 |
212968 | 212968 | 2020-06-06 | Lake | Indiana | 18089 | 3950 | 225 |
216055 | 216055 | 2020-06-07 | Lake | Indiana | 18089 | 3975 | 226 |
219147 | 219147 | 2020-06-08 | Lake | Indiana | 18089 | 3994 | 230 |
222242 | 222242 | 2020-06-09 | Lake | Indiana | 18089 | 4040 | 232 |
225337 | 225337 | 2020-06-10 | Lake | Indiana | 18089 | 4068 | 234 |
228439 | 228439 | 2020-06-11 | Lake | Indiana | 18089 | 4092 | 238 |
231542 | 231542 | 2020-06-12 | Lake | Indiana | 18089 | 4116 | 239 |
234648 | 234648 | 2020-06-13 | Lake | Indiana | 18089 | 4144 | 243 |
237755 | 237755 | 2020-06-14 | Lake | Indiana | 18089 | 4168 | 245 |
240863 | 240863 | 2020-06-15 | Lake | Indiana | 18089 | 4207 | 245 |
243974 | 243974 | 2020-06-16 | Lake | Indiana | 18089 | 4246 | 245 |
247087 | 247087 | 2020-06-17 | Lake | Indiana | 18089 | 4257 | 246 |
250199 | 250199 | 2020-06-18 | Lake | Indiana | 18089 | 4332 | 247 |
253314 | 253314 | 2020-06-19 | Lake | Indiana | 18089 | 4361 | 248 |
256434 | 256434 | 2020-06-20 | Lake | Indiana | 18089 | 4392 | 249 |
259560 | 259560 | 2020-06-21 | Lake | Indiana | 18089 | 4436 | 249 |
262687 | 262687 | 2020-06-22 | Lake | Indiana | 18089 | 4473 | 250 |
265815 | 265815 | 2020-06-23 | Lake | Indiana | 18089 | 4526 | 254 |
268945 | 268945 | 2020-06-24 | Lake | Indiana | 18089 | 4562 | 254 |
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);