ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Lake" and fips = 12069 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2825 | 2825 | 2020-03-16 | Lake | Florida | 12069 | 1 | 0 |
3309 | 3309 | 2020-03-17 | Lake | Florida | 12069 | 1 | 0 |
3866 | 3866 | 2020-03-18 | Lake | Florida | 12069 | 2 | 0 |
4534 | 4534 | 2020-03-19 | Lake | Florida | 12069 | 3 | 0 |
5313 | 5313 | 2020-03-20 | Lake | Florida | 12069 | 3 | 0 |
6242 | 6242 | 2020-03-21 | Lake | Florida | 12069 | 6 | 0 |
7282 | 7282 | 2020-03-22 | Lake | Florida | 12069 | 6 | 0 |
8428 | 8428 | 2020-03-23 | Lake | Florida | 12069 | 9 | 0 |
9673 | 9673 | 2020-03-24 | Lake | Florida | 12069 | 14 | 0 |
11048 | 11048 | 2020-03-25 | Lake | Florida | 12069 | 22 | 0 |
12596 | 12596 | 2020-03-26 | Lake | Florida | 12069 | 26 | 0 |
14265 | 14265 | 2020-03-27 | Lake | Florida | 12069 | 32 | 0 |
16050 | 16050 | 2020-03-28 | Lake | Florida | 12069 | 38 | 0 |
17943 | 17943 | 2020-03-29 | Lake | Florida | 12069 | 44 | 0 |
19924 | 19924 | 2020-03-30 | Lake | Florida | 12069 | 50 | 0 |
22002 | 22002 | 2020-03-31 | Lake | Florida | 12069 | 66 | 0 |
24163 | 24163 | 2020-04-01 | Lake | Florida | 12069 | 71 | 0 |
26393 | 26393 | 2020-04-02 | Lake | Florida | 12069 | 82 | 2 |
28696 | 28696 | 2020-04-03 | Lake | Florida | 12069 | 88 | 2 |
31056 | 31056 | 2020-04-04 | Lake | Florida | 12069 | 95 | 2 |
33462 | 33462 | 2020-04-05 | Lake | Florida | 12069 | 101 | 2 |
35908 | 35908 | 2020-04-06 | Lake | Florida | 12069 | 107 | 2 |
38399 | 38399 | 2020-04-07 | Lake | Florida | 12069 | 122 | 2 |
40943 | 40943 | 2020-04-08 | Lake | Florida | 12069 | 139 | 2 |
43517 | 43517 | 2020-04-09 | Lake | Florida | 12069 | 140 | 2 |
46118 | 46118 | 2020-04-10 | Lake | Florida | 12069 | 149 | 3 |
48748 | 48748 | 2020-04-11 | Lake | Florida | 12069 | 150 | 4 |
51409 | 51409 | 2020-04-12 | Lake | Florida | 12069 | 150 | 4 |
54089 | 54089 | 2020-04-13 | Lake | Florida | 12069 | 162 | 4 |
56781 | 56781 | 2020-04-14 | Lake | Florida | 12069 | 169 | 4 |
59489 | 59489 | 2020-04-15 | Lake | Florida | 12069 | 180 | 5 |
62208 | 62208 | 2020-04-16 | Lake | Florida | 12069 | 186 | 5 |
64941 | 64941 | 2020-04-17 | Lake | Florida | 12069 | 197 | 5 |
67689 | 67689 | 2020-04-18 | Lake | Florida | 12069 | 203 | 6 |
70451 | 70451 | 2020-04-19 | Lake | Florida | 12069 | 207 | 6 |
73220 | 73220 | 2020-04-20 | Lake | Florida | 12069 | 211 | 7 |
75996 | 75996 | 2020-04-21 | Lake | Florida | 12069 | 213 | 7 |
78780 | 78780 | 2020-04-22 | Lake | Florida | 12069 | 213 | 7 |
81574 | 81574 | 2020-04-23 | Lake | Florida | 12069 | 217 | 9 |
84374 | 84374 | 2020-04-24 | Lake | Florida | 12069 | 219 | 10 |
87182 | 87182 | 2020-04-25 | Lake | Florida | 12069 | 221 | 10 |
89999 | 89999 | 2020-04-26 | Lake | Florida | 12069 | 222 | 10 |
92817 | 92817 | 2020-04-27 | Lake | Florida | 12069 | 223 | 10 |
95649 | 95649 | 2020-04-28 | Lake | Florida | 12069 | 226 | 10 |
98494 | 98494 | 2020-04-29 | Lake | Florida | 12069 | 227 | 11 |
101344 | 101344 | 2020-04-30 | Lake | Florida | 12069 | 227 | 12 |
104199 | 104199 | 2020-05-01 | Lake | Florida | 12069 | 233 | 13 |
107064 | 107064 | 2020-05-02 | Lake | Florida | 12069 | 234 | 13 |
109933 | 109933 | 2020-05-03 | Lake | Florida | 12069 | 234 | 13 |
112808 | 112808 | 2020-05-04 | Lake | Florida | 12069 | 235 | 13 |
115691 | 115691 | 2020-05-05 | Lake | Florida | 12069 | 235 | 14 |
118651 | 118651 | 2020-05-06 | Lake | Florida | 12069 | 236 | 14 |
121620 | 121620 | 2020-05-07 | Lake | Florida | 12069 | 237 | 14 |
124599 | 124599 | 2020-05-08 | Lake | Florida | 12069 | 237 | 14 |
127586 | 127586 | 2020-05-09 | Lake | Florida | 12069 | 240 | 14 |
130577 | 130577 | 2020-05-10 | Lake | Florida | 12069 | 242 | 14 |
133568 | 133568 | 2020-05-11 | Lake | Florida | 12069 | 243 | 14 |
136557 | 136557 | 2020-05-12 | Lake | Florida | 12069 | 246 | 14 |
139548 | 139548 | 2020-05-13 | Lake | Florida | 12069 | 247 | 14 |
142544 | 142544 | 2020-05-14 | Lake | Florida | 12069 | 248 | 14 |
145544 | 145544 | 2020-05-15 | Lake | Florida | 12069 | 249 | 14 |
148547 | 148547 | 2020-05-16 | Lake | Florida | 12069 | 250 | 14 |
151556 | 151556 | 2020-05-17 | Lake | Florida | 12069 | 252 | 14 |
154568 | 154568 | 2020-05-18 | Lake | Florida | 12069 | 254 | 14 |
157584 | 157584 | 2020-05-19 | Lake | Florida | 12069 | 257 | 14 |
160610 | 160610 | 2020-05-20 | Lake | Florida | 12069 | 260 | 14 |
163638 | 163638 | 2020-05-21 | Lake | Florida | 12069 | 264 | 14 |
166671 | 166671 | 2020-05-22 | Lake | Florida | 12069 | 266 | 15 |
169708 | 169708 | 2020-05-23 | Lake | Florida | 12069 | 271 | 15 |
172749 | 172749 | 2020-05-24 | Lake | Florida | 12069 | 273 | 15 |
175792 | 175792 | 2020-05-25 | Lake | Florida | 12069 | 275 | 15 |
178836 | 178836 | 2020-05-26 | Lake | Florida | 12069 | 277 | 15 |
181880 | 181880 | 2020-05-27 | Lake | Florida | 12069 | 279 | 15 |
184934 | 184934 | 2020-05-28 | Lake | Florida | 12069 | 280 | 15 |
187990 | 187990 | 2020-05-29 | Lake | Florida | 12069 | 291 | 15 |
191055 | 191055 | 2020-05-30 | Lake | Florida | 12069 | 298 | 15 |
194122 | 194122 | 2020-05-31 | Lake | Florida | 12069 | 301 | 15 |
197192 | 197192 | 2020-06-01 | Lake | Florida | 12069 | 304 | 15 |
200265 | 200265 | 2020-06-02 | Lake | Florida | 12069 | 306 | 15 |
203341 | 203341 | 2020-06-03 | Lake | Florida | 12069 | 309 | 15 |
206421 | 206421 | 2020-06-04 | Lake | Florida | 12069 | 313 | 15 |
209502 | 209502 | 2020-06-05 | Lake | Florida | 12069 | 317 | 15 |
212587 | 212587 | 2020-06-06 | Lake | Florida | 12069 | 321 | 15 |
215674 | 215674 | 2020-06-07 | Lake | Florida | 12069 | 329 | 15 |
218765 | 218765 | 2020-06-08 | Lake | Florida | 12069 | 337 | 15 |
221860 | 221860 | 2020-06-09 | Lake | Florida | 12069 | 339 | 15 |
224955 | 224955 | 2020-06-10 | Lake | Florida | 12069 | 342 | 15 |
228057 | 228057 | 2020-06-11 | Lake | Florida | 12069 | 355 | 15 |
231160 | 231160 | 2020-06-12 | Lake | Florida | 12069 | 383 | 15 |
234266 | 234266 | 2020-06-13 | Lake | Florida | 12069 | 452 | 16 |
237373 | 237373 | 2020-06-14 | Lake | Florida | 12069 | 464 | 16 |
240481 | 240481 | 2020-06-15 | Lake | Florida | 12069 | 482 | 16 |
243592 | 243592 | 2020-06-16 | Lake | Florida | 12069 | 498 | 16 |
246705 | 246705 | 2020-06-17 | Lake | Florida | 12069 | 552 | 16 |
249817 | 249817 | 2020-06-18 | Lake | Florida | 12069 | 583 | 19 |
252932 | 252932 | 2020-06-19 | Lake | Florida | 12069 | 646 | 19 |
256051 | 256051 | 2020-06-20 | Lake | Florida | 12069 | 671 | 19 |
259178 | 259178 | 2020-06-21 | Lake | Florida | 12069 | 733 | 19 |
262305 | 262305 | 2020-06-22 | Lake | Florida | 12069 | 763 | 20 |
265433 | 265433 | 2020-06-23 | Lake | Florida | 12069 | 795 | 21 |
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);