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