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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1231 | 1231 | 2020-03-11 | Lake | Illinois | 17097 | 1 | 0 |
1445 | 1445 | 2020-03-12 | Lake | Illinois | 17097 | 1 | 0 |
2825 | 2825 | 2020-03-16 | Lake | Florida | 12069 | 1 | 0 |
3309 | 3309 | 2020-03-17 | Lake | Florida | 12069 | 1 | 0 |
3592 | 3592 | 2020-03-17 | Lake | Ohio | 39085 | 1 | 0 |
14986 | 14986 | 2020-03-27 | Lake | Montana | 30047 | 1 | 0 |
21939 | 21939 | 2020-03-31 | Lake | Colorado | 8065 | 1 | 0 |
27888 | 27888 | 2020-04-02 | Lake | South Dakota | 46079 | 1 | 0 |
30223 | 30223 | 2020-04-03 | Lake | South Dakota | 46079 | 1 | 0 |
32614 | 32614 | 2020-04-04 | Lake | South Dakota | 46079 | 1 | 0 |
35050 | 35050 | 2020-04-05 | Lake | South Dakota | 46079 | 1 | 0 |
37525 | 37525 | 2020-04-06 | Lake | South Dakota | 46079 | 1 | 0 |
40048 | 40048 | 2020-04-07 | Lake | South Dakota | 46079 | 1 | 0 |
49553 | 49553 | 2020-04-11 | Lake | Michigan | 26085 | 1 | 0 |
52223 | 52223 | 2020-04-12 | Lake | Michigan | 26085 | 1 | 0 |
122568 | 122568 | 2020-05-07 | Lake | Minnesota | 27075 | 1 | 0 |
125550 | 125550 | 2020-05-08 | Lake | Minnesota | 27075 | 1 | 0 |
128537 | 128537 | 2020-05-09 | Lake | Minnesota | 27075 | 1 | 0 |
131527 | 131527 | 2020-05-10 | Lake | Minnesota | 27075 | 1 | 0 |
134518 | 134518 | 2020-05-11 | Lake | Minnesota | 27075 | 1 | 0 |
137508 | 137508 | 2020-05-12 | Lake | Minnesota | 27075 | 1 | 0 |
140502 | 140502 | 2020-05-13 | Lake | Minnesota | 27075 | 1 | 0 |
143497 | 143497 | 2020-05-14 | Lake | Minnesota | 27075 | 1 | 0 |
146497 | 146497 | 2020-05-15 | Lake | Minnesota | 27075 | 1 | 0 |
149502 | 149502 | 2020-05-16 | Lake | Minnesota | 27075 | 1 | 0 |
152513 | 152513 | 2020-05-17 | Lake | Minnesota | 27075 | 1 | 0 |
155527 | 155527 | 2020-05-18 | Lake | Minnesota | 27075 | 1 | 0 |
158545 | 158545 | 2020-05-19 | Lake | Minnesota | 27075 | 1 | 0 |
161571 | 161571 | 2020-05-20 | Lake | Minnesota | 27075 | 1 | 0 |
164600 | 164600 | 2020-05-21 | Lake | Minnesota | 27075 | 1 | 0 |
167636 | 167636 | 2020-05-22 | Lake | Minnesota | 27075 | 1 | 0 |
170674 | 170674 | 2020-05-23 | Lake | Minnesota | 27075 | 1 | 0 |
173716 | 173716 | 2020-05-24 | Lake | Minnesota | 27075 | 1 | 0 |
176759 | 176759 | 2020-05-25 | Lake | Minnesota | 27075 | 1 | 0 |
179803 | 179803 | 2020-05-26 | Lake | Minnesota | 27075 | 1 | 0 |
182849 | 182849 | 2020-05-27 | Lake | Minnesota | 27075 | 1 | 0 |
185904 | 185904 | 2020-05-28 | Lake | Minnesota | 27075 | 1 | 0 |
188962 | 188962 | 2020-05-29 | Lake | Minnesota | 27075 | 1 | 0 |
192026 | 192026 | 2020-05-30 | Lake | Minnesota | 27075 | 1 | 0 |
195094 | 195094 | 2020-05-31 | Lake | Minnesota | 27075 | 1 | 0 |
198165 | 198165 | 2020-06-01 | Lake | Minnesota | 27075 | 1 | 0 |
201238 | 201238 | 2020-06-02 | Lake | Minnesota | 27075 | 1 | 0 |
204315 | 204315 | 2020-06-03 | Lake | Minnesota | 27075 | 1 | 0 |
207396 | 207396 | 2020-06-04 | Lake | Minnesota | 27075 | 1 | 0 |
210477 | 210477 | 2020-06-05 | Lake | Minnesota | 27075 | 1 | 0 |
213561 | 213561 | 2020-06-06 | Lake | Minnesota | 27075 | 1 | 0 |
216649 | 216649 | 2020-06-07 | Lake | Minnesota | 27075 | 1 | 0 |
219741 | 219741 | 2020-06-08 | Lake | Minnesota | 27075 | 1 | 0 |
222836 | 222836 | 2020-06-09 | Lake | Minnesota | 27075 | 1 | 0 |
225934 | 225934 | 2020-06-10 | Lake | Minnesota | 27075 | 1 | 0 |
229036 | 229036 | 2020-06-11 | Lake | Minnesota | 27075 | 1 | 0 |
232140 | 232140 | 2020-06-12 | Lake | Minnesota | 27075 | 1 | 0 |
235246 | 235246 | 2020-06-13 | Lake | Minnesota | 27075 | 1 | 0 |
238353 | 238353 | 2020-06-14 | Lake | Minnesota | 27075 | 1 | 0 |
241462 | 241462 | 2020-06-15 | Lake | Minnesota | 27075 | 1 | 0 |
1716 | 1716 | 2020-03-13 | Lake | Illinois | 17097 | 2 | 0 |
3384 | 3384 | 2020-03-17 | Lake | Indiana | 18089 | 2 | 0 |
3866 | 3866 | 2020-03-18 | Lake | Florida | 12069 | 2 | 0 |
4206 | 4206 | 2020-03-18 | Lake | Ohio | 39085 | 2 | 0 |
4938 | 4938 | 2020-03-19 | Lake | Ohio | 39085 | 2 | 0 |
16812 | 16812 | 2020-03-28 | Lake | Montana | 30047 | 2 | 0 |
24098 | 24098 | 2020-04-01 | Lake | Colorado | 8065 | 2 | 0 |
26328 | 26328 | 2020-04-02 | Lake | Colorado | 8065 | 2 | 0 |
35772 | 35772 | 2020-04-06 | Lake | California | 6033 | 2 | 0 |
38261 | 38261 | 2020-04-07 | Lake | California | 6033 | 2 | 0 |
42608 | 42608 | 2020-04-08 | Lake | South Dakota | 46079 | 2 | 0 |
45196 | 45196 | 2020-04-09 | Lake | South Dakota | 46079 | 2 | 0 |
47813 | 47813 | 2020-04-10 | Lake | South Dakota | 46079 | 2 | 0 |
50470 | 50470 | 2020-04-11 | Lake | South Dakota | 46079 | 2 | 0 |
53143 | 53143 | 2020-04-12 | Lake | South Dakota | 46079 | 2 | 0 |
54904 | 54904 | 2020-04-13 | Lake | Michigan | 26085 | 2 | 0 |
55829 | 55829 | 2020-04-13 | Lake | South Dakota | 46079 | 2 | 0 |
57602 | 57602 | 2020-04-14 | Lake | Michigan | 26085 | 2 | 0 |
58532 | 58532 | 2020-04-14 | Lake | South Dakota | 46079 | 2 | 0 |
60312 | 60312 | 2020-04-15 | Lake | Michigan | 26085 | 2 | 0 |
61247 | 61247 | 2020-04-15 | Lake | South Dakota | 46079 | 2 | 0 |
63034 | 63034 | 2020-04-16 | Lake | Michigan | 26085 | 2 | 0 |
65772 | 65772 | 2020-04-17 | Lake | Michigan | 26085 | 2 | 0 |
68523 | 68523 | 2020-04-18 | Lake | Michigan | 26085 | 2 | 0 |
71287 | 71287 | 2020-04-19 | Lake | Michigan | 26085 | 2 | 0 |
74059 | 74059 | 2020-04-20 | Lake | Michigan | 26085 | 2 | 0 |
76839 | 76839 | 2020-04-21 | Lake | Michigan | 26085 | 2 | 0 |
79625 | 79625 | 2020-04-22 | Lake | Michigan | 26085 | 2 | 0 |
82420 | 82420 | 2020-04-23 | Lake | Michigan | 26085 | 2 | 0 |
85224 | 85224 | 2020-04-24 | Lake | Michigan | 26085 | 2 | 0 |
88034 | 88034 | 2020-04-25 | Lake | Michigan | 26085 | 2 | 0 |
90850 | 90850 | 2020-04-26 | Lake | Michigan | 26085 | 2 | 0 |
93671 | 93671 | 2020-04-27 | Lake | Michigan | 26085 | 2 | 0 |
96506 | 96506 | 2020-04-28 | Lake | Michigan | 26085 | 2 | 0 |
99352 | 99352 | 2020-04-29 | Lake | Michigan | 26085 | 2 | 0 |
102204 | 102204 | 2020-04-30 | Lake | Michigan | 26085 | 2 | 0 |
105064 | 105064 | 2020-05-01 | Lake | Michigan | 26085 | 2 | 0 |
107928 | 107928 | 2020-05-02 | Lake | Michigan | 26085 | 2 | 0 |
110800 | 110800 | 2020-05-03 | Lake | Michigan | 26085 | 2 | 0 |
113678 | 113678 | 2020-05-04 | Lake | Michigan | 26085 | 2 | 0 |
116559 | 116559 | 2020-05-05 | Lake | Michigan | 26085 | 2 | 0 |
119520 | 119520 | 2020-05-06 | Lake | Michigan | 26085 | 2 | 0 |
122492 | 122492 | 2020-05-07 | Lake | Michigan | 26085 | 2 | 0 |
125474 | 125474 | 2020-05-08 | Lake | Michigan | 26085 | 2 | 0 |
128461 | 128461 | 2020-05-09 | Lake | Michigan | 26085 | 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);