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 date
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 |
---|---|---|---|---|---|---|---|
1231 | 1231 | 2020-03-11 | Lake | Illinois | 17097 | 1 | 0 |
1445 | 1445 | 2020-03-12 | Lake | Illinois | 17097 | 1 | 0 |
1716 | 1716 | 2020-03-13 | Lake | Illinois | 17097 | 2 | 0 |
2044 | 2044 | 2020-03-14 | Lake | Illinois | 17097 | 3 | 0 |
2435 | 2435 | 2020-03-15 | Lake | Illinois | 17097 | 3 | 0 |
2825 | 2825 | 2020-03-16 | Lake | Florida | 12069 | 1 | 0 |
2876 | 2876 | 2020-03-16 | Lake | Illinois | 17097 | 6 | 0 |
3309 | 3309 | 2020-03-17 | Lake | Florida | 12069 | 1 | 0 |
3365 | 3365 | 2020-03-17 | Lake | Illinois | 17097 | 7 | 0 |
3384 | 3384 | 2020-03-17 | Lake | Indiana | 18089 | 2 | 0 |
3592 | 3592 | 2020-03-17 | Lake | Ohio | 39085 | 1 | 0 |
3866 | 3866 | 2020-03-18 | Lake | Florida | 12069 | 2 | 0 |
3932 | 3932 | 2020-03-18 | Lake | Illinois | 17097 | 18 | 0 |
3957 | 3957 | 2020-03-18 | Lake | Indiana | 18089 | 3 | 0 |
4206 | 4206 | 2020-03-18 | Lake | Ohio | 39085 | 2 | 0 |
4534 | 4534 | 2020-03-19 | Lake | Florida | 12069 | 3 | 0 |
4608 | 4608 | 2020-03-19 | Lake | Illinois | 17097 | 37 | 0 |
4633 | 4633 | 2020-03-19 | Lake | Indiana | 18089 | 4 | 0 |
4938 | 4938 | 2020-03-19 | Lake | Ohio | 39085 | 2 | 0 |
5313 | 5313 | 2020-03-20 | Lake | Florida | 12069 | 3 | 0 |
5413 | 5413 | 2020-03-20 | Lake | Illinois | 17097 | 52 | 0 |
5441 | 5441 | 2020-03-20 | Lake | Indiana | 18089 | 6 | 0 |
5801 | 5801 | 2020-03-20 | Lake | Ohio | 39085 | 3 | 0 |
6242 | 6242 | 2020-03-21 | Lake | Florida | 12069 | 6 | 0 |
6348 | 6348 | 2020-03-21 | Lake | Illinois | 17097 | 63 | 0 |
6380 | 6380 | 2020-03-21 | Lake | Indiana | 18089 | 7 | 0 |
6801 | 6801 | 2020-03-21 | Lake | Ohio | 39085 | 4 | 0 |
7282 | 7282 | 2020-03-22 | Lake | Florida | 12069 | 6 | 0 |
7399 | 7399 | 2020-03-22 | Lake | Illinois | 17097 | 69 | 0 |
7434 | 7434 | 2020-03-22 | Lake | Indiana | 18089 | 10 | 0 |
7912 | 7912 | 2020-03-22 | Lake | Ohio | 39085 | 6 | 0 |
8428 | 8428 | 2020-03-23 | Lake | Florida | 12069 | 9 | 0 |
8554 | 8554 | 2020-03-23 | Lake | Illinois | 17097 | 96 | 0 |
8592 | 8592 | 2020-03-23 | Lake | Indiana | 18089 | 11 | 0 |
9116 | 9116 | 2020-03-23 | Lake | Ohio | 39085 | 8 | 0 |
9673 | 9673 | 2020-03-24 | Lake | Florida | 12069 | 14 | 0 |
9818 | 9818 | 2020-03-24 | Lake | Illinois | 17097 | 111 | 0 |
9861 | 9861 | 2020-03-24 | Lake | Indiana | 18089 | 17 | 0 |
10432 | 10432 | 2020-03-24 | Lake | Ohio | 39085 | 11 | 0 |
11048 | 11048 | 2020-03-25 | Lake | Florida | 12069 | 22 | 0 |
11209 | 11209 | 2020-03-25 | Lake | Illinois | 17097 | 139 | 0 |
11256 | 11256 | 2020-03-25 | Lake | Indiana | 18089 | 19 | 0 |
11880 | 11880 | 2020-03-25 | Lake | Ohio | 39085 | 14 | 0 |
12596 | 12596 | 2020-03-26 | Lake | Florida | 12069 | 26 | 0 |
12765 | 12765 | 2020-03-26 | Lake | Illinois | 17097 | 185 | 0 |
12813 | 12813 | 2020-03-26 | Lake | Indiana | 18089 | 31 | 0 |
13488 | 13488 | 2020-03-26 | Lake | Ohio | 39085 | 19 | 0 |
14265 | 14265 | 2020-03-27 | Lake | Florida | 12069 | 32 | 0 |
14443 | 14443 | 2020-03-27 | Lake | Illinois | 17097 | 230 | 2 |
14498 | 14498 | 2020-03-27 | Lake | Indiana | 18089 | 47 | 0 |
14986 | 14986 | 2020-03-27 | Lake | Montana | 30047 | 1 | 0 |
15226 | 15226 | 2020-03-27 | Lake | Ohio | 39085 | 27 | 1 |
16050 | 16050 | 2020-03-28 | Lake | Florida | 12069 | 38 | 0 |
16238 | 16238 | 2020-03-28 | Lake | Illinois | 17097 | 264 | 2 |
16296 | 16296 | 2020-03-28 | Lake | Indiana | 18089 | 68 | 1 |
16812 | 16812 | 2020-03-28 | Lake | Montana | 30047 | 2 | 0 |
17068 | 17068 | 2020-03-28 | Lake | Ohio | 39085 | 30 | 1 |
17943 | 17943 | 2020-03-29 | Lake | Florida | 12069 | 44 | 0 |
18138 | 18138 | 2020-03-29 | Lake | Illinois | 17097 | 300 | 3 |
18200 | 18200 | 2020-03-29 | Lake | Indiana | 18089 | 85 | 1 |
18735 | 18735 | 2020-03-29 | Lake | Montana | 30047 | 3 | 0 |
19002 | 19002 | 2020-03-29 | Lake | Ohio | 39085 | 35 | 1 |
19924 | 19924 | 2020-03-30 | Lake | Florida | 12069 | 50 | 0 |
20140 | 20140 | 2020-03-30 | Lake | Illinois | 17097 | 343 | 5 |
20206 | 20206 | 2020-03-30 | Lake | Indiana | 18089 | 98 | 2 |
20770 | 20770 | 2020-03-30 | Lake | Montana | 30047 | 3 | 0 |
21047 | 21047 | 2020-03-30 | Lake | Ohio | 39085 | 43 | 1 |
21939 | 21939 | 2020-03-31 | Lake | Colorado | 8065 | 1 | 0 |
22002 | 22002 | 2020-03-31 | Lake | Florida | 12069 | 66 | 0 |
22232 | 22232 | 2020-03-31 | Lake | Illinois | 17097 | 389 | 7 |
22301 | 22301 | 2020-03-31 | Lake | Indiana | 18089 | 147 | 6 |
22890 | 22890 | 2020-03-31 | Lake | Montana | 30047 | 3 | 0 |
23179 | 23179 | 2020-03-31 | Lake | Ohio | 39085 | 44 | 2 |
24098 | 24098 | 2020-04-01 | Lake | Colorado | 8065 | 2 | 0 |
24163 | 24163 | 2020-04-01 | Lake | Florida | 12069 | 71 | 0 |
24400 | 24400 | 2020-04-01 | Lake | Illinois | 17097 | 477 | 7 |
24472 | 24472 | 2020-04-01 | Lake | Indiana | 18089 | 181 | 7 |
25079 | 25079 | 2020-04-01 | Lake | Montana | 30047 | 4 | 0 |
25374 | 25374 | 2020-04-01 | Lake | Ohio | 39085 | 48 | 2 |
26328 | 26328 | 2020-04-02 | Lake | Colorado | 8065 | 2 | 0 |
26393 | 26393 | 2020-04-02 | Lake | Florida | 12069 | 82 | 2 |
26633 | 26633 | 2020-04-02 | Lake | Illinois | 17097 | 540 | 7 |
26711 | 26711 | 2020-04-02 | Lake | Indiana | 18089 | 216 | 7 |
27336 | 27336 | 2020-04-02 | Lake | Montana | 30047 | 4 | 0 |
27642 | 27642 | 2020-04-02 | Lake | Ohio | 39085 | 62 | 3 |
27888 | 27888 | 2020-04-02 | Lake | South Dakota | 46079 | 1 | 0 |
28628 | 28628 | 2020-04-03 | Lake | Colorado | 8065 | 3 | 0 |
28696 | 28696 | 2020-04-03 | Lake | Florida | 12069 | 88 | 2 |
28943 | 28943 | 2020-04-03 | Lake | Illinois | 17097 | 608 | 14 |
29021 | 29021 | 2020-04-03 | Lake | Indiana | 18089 | 245 | 8 |
29659 | 29659 | 2020-04-03 | Lake | Montana | 30047 | 4 | 0 |
29971 | 29971 | 2020-04-03 | Lake | Ohio | 39085 | 66 | 3 |
30223 | 30223 | 2020-04-03 | Lake | South Dakota | 46079 | 1 | 0 |
30985 | 30985 | 2020-04-04 | Lake | Colorado | 8065 | 3 | 0 |
31056 | 31056 | 2020-04-04 | Lake | Florida | 12069 | 95 | 2 |
31306 | 31306 | 2020-04-04 | Lake | Illinois | 17097 | 689 | 14 |
31387 | 31387 | 2020-04-04 | Lake | Indiana | 18089 | 314 | 9 |
32041 | 32041 | 2020-04-04 | Lake | Montana | 30047 | 4 | 0 |
32360 | 32360 | 2020-04-04 | Lake | Ohio | 39085 | 76 | 3 |
32614 | 32614 | 2020-04-04 | Lake | South Dakota | 46079 | 1 | 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);