ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,229 rows where county = "Lake" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-05-27 12
- 2020-05-28 12
- 2020-05-29 12
- 2020-05-30 12
- 2020-05-31 12
- 2020-06-01 12
- 2020-06-02 12
- 2020-06-03 12
- 2020-06-04 12
- 2020-06-05 12
- 2020-06-06 12
- 2020-06-07 12
- 2020-06-08 12
- 2020-06-09 12
- 2020-06-10 12
- 2020-06-11 12
- 2020-06-12 12
- 2020-06-13 12
- 2020-06-14 12
- 2020-06-15 12
- 2020-06-16 12
- 2020-06-17 12
- 2020-06-18 12
- 2020-06-19 12
- 2020-06-20 12
- 2020-06-21 12
- 2020-06-22 12
- 2020-06-23 12
- 2020-06-24 12
- 2020-06-25 12
- …
state 12
fips 12
county 1
- Lake · 9,229 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
35772 | 35772 | 2020-04-06 | Lake | California | 6033 | 2 | 0 |
38261 | 38261 | 2020-04-07 | Lake | California | 6033 | 2 | 0 |
40805 | 40805 | 2020-04-08 | Lake | California | 6033 | 3 | 0 |
43377 | 43377 | 2020-04-09 | Lake | California | 6033 | 3 | 0 |
45977 | 45977 | 2020-04-10 | Lake | California | 6033 | 4 | 0 |
48607 | 48607 | 2020-04-11 | Lake | California | 6033 | 4 | 0 |
51269 | 51269 | 2020-04-12 | Lake | California | 6033 | 4 | 0 |
53948 | 53948 | 2020-04-13 | Lake | California | 6033 | 4 | 0 |
56640 | 56640 | 2020-04-14 | Lake | California | 6033 | 5 | 0 |
59348 | 59348 | 2020-04-15 | Lake | California | 6033 | 5 | 0 |
62067 | 62067 | 2020-04-16 | Lake | California | 6033 | 6 | 0 |
64800 | 64800 | 2020-04-17 | Lake | California | 6033 | 6 | 0 |
67548 | 67548 | 2020-04-18 | Lake | California | 6033 | 6 | 0 |
70310 | 70310 | 2020-04-19 | Lake | California | 6033 | 6 | 0 |
73079 | 73079 | 2020-04-20 | Lake | California | 6033 | 6 | 0 |
75855 | 75855 | 2020-04-21 | Lake | California | 6033 | 6 | 0 |
78639 | 78639 | 2020-04-22 | Lake | California | 6033 | 6 | 0 |
81433 | 81433 | 2020-04-23 | Lake | California | 6033 | 6 | 0 |
84233 | 84233 | 2020-04-24 | Lake | California | 6033 | 6 | 0 |
87041 | 87041 | 2020-04-25 | Lake | California | 6033 | 6 | 0 |
89858 | 89858 | 2020-04-26 | Lake | California | 6033 | 6 | 0 |
92676 | 92676 | 2020-04-27 | Lake | California | 6033 | 6 | 0 |
95507 | 95507 | 2020-04-28 | Lake | California | 6033 | 6 | 0 |
98352 | 98352 | 2020-04-29 | Lake | California | 6033 | 6 | 0 |
101202 | 101202 | 2020-04-30 | Lake | California | 6033 | 7 | 0 |
104057 | 104057 | 2020-05-01 | Lake | California | 6033 | 7 | 0 |
106922 | 106922 | 2020-05-02 | Lake | California | 6033 | 7 | 0 |
109791 | 109791 | 2020-05-03 | Lake | California | 6033 | 7 | 0 |
112666 | 112666 | 2020-05-04 | Lake | California | 6033 | 7 | 0 |
115549 | 115549 | 2020-05-05 | Lake | California | 6033 | 8 | 0 |
118508 | 118508 | 2020-05-06 | Lake | California | 6033 | 8 | 0 |
121475 | 121475 | 2020-05-07 | Lake | California | 6033 | 8 | 0 |
124455 | 124455 | 2020-05-08 | Lake | California | 6033 | 8 | 0 |
127440 | 127440 | 2020-05-09 | Lake | California | 6033 | 8 | 0 |
130430 | 130430 | 2020-05-10 | Lake | California | 6033 | 8 | 0 |
133420 | 133420 | 2020-05-11 | Lake | California | 6033 | 8 | 0 |
136410 | 136410 | 2020-05-12 | Lake | California | 6033 | 8 | 0 |
139401 | 139401 | 2020-05-13 | Lake | California | 6033 | 8 | 0 |
142397 | 142397 | 2020-05-14 | Lake | California | 6033 | 8 | 0 |
145396 | 145396 | 2020-05-15 | Lake | California | 6033 | 8 | 0 |
148400 | 148400 | 2020-05-16 | Lake | California | 6033 | 8 | 0 |
151409 | 151409 | 2020-05-17 | Lake | California | 6033 | 8 | 0 |
154421 | 154421 | 2020-05-18 | Lake | California | 6033 | 10 | 0 |
157437 | 157437 | 2020-05-19 | Lake | California | 6033 | 11 | 0 |
160463 | 160463 | 2020-05-20 | Lake | California | 6033 | 12 | 0 |
163491 | 163491 | 2020-05-21 | Lake | California | 6033 | 12 | 0 |
166523 | 166523 | 2020-05-22 | Lake | California | 6033 | 12 | 0 |
169559 | 169559 | 2020-05-23 | Lake | California | 6033 | 12 | 0 |
172600 | 172600 | 2020-05-24 | Lake | California | 6033 | 12 | 0 |
175644 | 175644 | 2020-05-25 | Lake | California | 6033 | 12 | 0 |
178688 | 178688 | 2020-05-26 | Lake | California | 6033 | 13 | 0 |
181732 | 181732 | 2020-05-27 | Lake | California | 6033 | 19 | 0 |
184786 | 184786 | 2020-05-28 | Lake | California | 6033 | 23 | 0 |
187842 | 187842 | 2020-05-29 | Lake | California | 6033 | 23 | 0 |
190907 | 190907 | 2020-05-30 | Lake | California | 6033 | 23 | 0 |
193974 | 193974 | 2020-05-31 | Lake | California | 6033 | 23 | 0 |
197044 | 197044 | 2020-06-01 | Lake | California | 6033 | 21 | 0 |
200117 | 200117 | 2020-06-02 | Lake | California | 6033 | 26 | 0 |
203193 | 203193 | 2020-06-03 | Lake | California | 6033 | 30 | 0 |
206273 | 206273 | 2020-06-04 | Lake | California | 6033 | 30 | 0 |
209354 | 209354 | 2020-06-05 | Lake | California | 6033 | 30 | 0 |
212439 | 212439 | 2020-06-06 | Lake | California | 6033 | 30 | 0 |
215526 | 215526 | 2020-06-07 | Lake | California | 6033 | 30 | 0 |
218617 | 218617 | 2020-06-08 | Lake | California | 6033 | 30 | 0 |
221712 | 221712 | 2020-06-09 | Lake | California | 6033 | 30 | 0 |
224807 | 224807 | 2020-06-10 | Lake | California | 6033 | 30 | 0 |
227909 | 227909 | 2020-06-11 | Lake | California | 6033 | 30 | 0 |
231012 | 231012 | 2020-06-12 | Lake | California | 6033 | 31 | 0 |
234118 | 234118 | 2020-06-13 | Lake | California | 6033 | 31 | 0 |
237225 | 237225 | 2020-06-14 | Lake | California | 6033 | 31 | 0 |
240333 | 240333 | 2020-06-15 | Lake | California | 6033 | 34 | 0 |
243444 | 243444 | 2020-06-16 | Lake | California | 6033 | 34 | 0 |
246557 | 246557 | 2020-06-17 | Lake | California | 6033 | 34 | 0 |
249669 | 249669 | 2020-06-18 | Lake | California | 6033 | 34 | 0 |
252784 | 252784 | 2020-06-19 | Lake | California | 6033 | 36 | 0 |
255903 | 255903 | 2020-06-20 | Lake | California | 6033 | 36 | 0 |
259030 | 259030 | 2020-06-21 | Lake | California | 6033 | 37 | 0 |
262157 | 262157 | 2020-06-22 | Lake | California | 6033 | 36 | 0 |
265285 | 265285 | 2020-06-23 | Lake | California | 6033 | 41 | 0 |
268415 | 268415 | 2020-06-24 | Lake | California | 6033 | 41 | 0 |
271550 | 271550 | 2020-06-25 | Lake | California | 6033 | 42 | 0 |
274690 | 274690 | 2020-06-26 | Lake | California | 6033 | 42 | 0 |
277838 | 277838 | 2020-06-27 | Lake | California | 6033 | 42 | 0 |
280985 | 280985 | 2020-06-28 | Lake | California | 6033 | 42 | 0 |
284131 | 284131 | 2020-06-29 | Lake | California | 6033 | 58 | 0 |
287277 | 287277 | 2020-06-30 | Lake | California | 6033 | 62 | 0 |
290428 | 290428 | 2020-07-01 | Lake | California | 6033 | 81 | 0 |
293582 | 293582 | 2020-07-02 | Lake | California | 6033 | 87 | 0 |
296738 | 296738 | 2020-07-03 | Lake | California | 6033 | 88 | 0 |
299900 | 299900 | 2020-07-04 | Lake | California | 6033 | 89 | 1 |
303064 | 303064 | 2020-07-05 | Lake | California | 6033 | 89 | 1 |
306228 | 306228 | 2020-07-06 | Lake | California | 6033 | 96 | 1 |
309396 | 309396 | 2020-07-07 | Lake | California | 6033 | 98 | 1 |
312566 | 312566 | 2020-07-08 | Lake | California | 6033 | 100 | 1 |
315741 | 315741 | 2020-07-09 | Lake | California | 6033 | 101 | 1 |
318914 | 318914 | 2020-07-10 | Lake | California | 6033 | 108 | 1 |
322093 | 322093 | 2020-07-11 | Lake | California | 6033 | 108 | 1 |
325274 | 325274 | 2020-07-12 | Lake | California | 6033 | 110 | 1 |
328460 | 328460 | 2020-07-13 | Lake | California | 6033 | 121 | 1 |
331646 | 331646 | 2020-07-14 | Lake | California | 6033 | 122 | 1 |
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);