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 deaths
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 |
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 |
14498 | 14498 | 2020-03-27 | Lake | Indiana | 18089 | 47 | 0 |
14986 | 14986 | 2020-03-27 | Lake | Montana | 30047 | 1 | 0 |
16050 | 16050 | 2020-03-28 | Lake | Florida | 12069 | 38 | 0 |
16812 | 16812 | 2020-03-28 | Lake | Montana | 30047 | 2 | 0 |
17943 | 17943 | 2020-03-29 | Lake | Florida | 12069 | 44 | 0 |
18735 | 18735 | 2020-03-29 | Lake | Montana | 30047 | 3 | 0 |
19924 | 19924 | 2020-03-30 | Lake | Florida | 12069 | 50 | 0 |
20770 | 20770 | 2020-03-30 | Lake | Montana | 30047 | 3 | 0 |
21939 | 21939 | 2020-03-31 | Lake | Colorado | 8065 | 1 | 0 |
22002 | 22002 | 2020-03-31 | Lake | Florida | 12069 | 66 | 0 |
22890 | 22890 | 2020-03-31 | Lake | Montana | 30047 | 3 | 0 |
24098 | 24098 | 2020-04-01 | Lake | Colorado | 8065 | 2 | 0 |
24163 | 24163 | 2020-04-01 | Lake | Florida | 12069 | 71 | 0 |
25079 | 25079 | 2020-04-01 | Lake | Montana | 30047 | 4 | 0 |
26328 | 26328 | 2020-04-02 | Lake | Colorado | 8065 | 2 | 0 |
27336 | 27336 | 2020-04-02 | Lake | Montana | 30047 | 4 | 0 |
27888 | 27888 | 2020-04-02 | Lake | South Dakota | 46079 | 1 | 0 |
28628 | 28628 | 2020-04-03 | Lake | Colorado | 8065 | 3 | 0 |
29659 | 29659 | 2020-04-03 | Lake | Montana | 30047 | 4 | 0 |
30223 | 30223 | 2020-04-03 | Lake | South Dakota | 46079 | 1 | 0 |
30985 | 30985 | 2020-04-04 | Lake | Colorado | 8065 | 3 | 0 |
32041 | 32041 | 2020-04-04 | Lake | Montana | 30047 | 4 | 0 |
32614 | 32614 | 2020-04-04 | Lake | South Dakota | 46079 | 1 | 0 |
33391 | 33391 | 2020-04-05 | Lake | Colorado | 8065 | 3 | 0 |
34469 | 34469 | 2020-04-05 | Lake | Montana | 30047 | 4 | 0 |
35050 | 35050 | 2020-04-05 | Lake | South Dakota | 46079 | 1 | 0 |
35772 | 35772 | 2020-04-06 | Lake | California | 6033 | 2 | 0 |
35836 | 35836 | 2020-04-06 | Lake | Colorado | 8065 | 3 | 0 |
36936 | 36936 | 2020-04-06 | Lake | Montana | 30047 | 5 | 0 |
37525 | 37525 | 2020-04-06 | Lake | South Dakota | 46079 | 1 | 0 |
38261 | 38261 | 2020-04-07 | Lake | California | 6033 | 2 | 0 |
38326 | 38326 | 2020-04-07 | Lake | Colorado | 8065 | 3 | 0 |
39452 | 39452 | 2020-04-07 | Lake | Montana | 30047 | 5 | 0 |
40048 | 40048 | 2020-04-07 | Lake | South Dakota | 46079 | 1 | 0 |
40805 | 40805 | 2020-04-08 | Lake | California | 6033 | 3 | 0 |
40869 | 40869 | 2020-04-08 | Lake | Colorado | 8065 | 3 | 0 |
42007 | 42007 | 2020-04-08 | Lake | Montana | 30047 | 5 | 0 |
42608 | 42608 | 2020-04-08 | Lake | South Dakota | 46079 | 2 | 0 |
43377 | 43377 | 2020-04-09 | Lake | California | 6033 | 3 | 0 |
43442 | 43442 | 2020-04-09 | Lake | Colorado | 8065 | 4 | 0 |
44586 | 44586 | 2020-04-09 | Lake | Montana | 30047 | 6 | 0 |
45196 | 45196 | 2020-04-09 | Lake | South Dakota | 46079 | 2 | 0 |
45977 | 45977 | 2020-04-10 | Lake | California | 6033 | 4 | 0 |
46042 | 46042 | 2020-04-10 | Lake | Colorado | 8065 | 4 | 0 |
47196 | 47196 | 2020-04-10 | Lake | Montana | 30047 | 5 | 0 |
47813 | 47813 | 2020-04-10 | Lake | South Dakota | 46079 | 2 | 0 |
48607 | 48607 | 2020-04-11 | Lake | California | 6033 | 4 | 0 |
48672 | 48672 | 2020-04-11 | Lake | Colorado | 8065 | 4 | 0 |
49553 | 49553 | 2020-04-11 | Lake | Michigan | 26085 | 1 | 0 |
49845 | 49845 | 2020-04-11 | Lake | Montana | 30047 | 5 | 0 |
50470 | 50470 | 2020-04-11 | Lake | South Dakota | 46079 | 2 | 0 |
51269 | 51269 | 2020-04-12 | Lake | California | 6033 | 4 | 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);