ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Lewis and Clark" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1784 | 1784 | 2020-03-13 | Lewis and Clark | Montana | 30049 | 1 | 0 |
2129 | 2129 | 2020-03-14 | Lewis and Clark | Montana | 30049 | 1 | 0 |
2536 | 2536 | 2020-03-15 | Lewis and Clark | Montana | 30049 | 1 | 0 |
2991 | 2991 | 2020-03-16 | Lewis and Clark | Montana | 30049 | 1 | 0 |
3501 | 3501 | 2020-03-17 | Lewis and Clark | Montana | 30049 | 1 | 0 |
4092 | 4092 | 2020-03-18 | Lewis and Clark | Montana | 30049 | 1 | 0 |
4813 | 4813 | 2020-03-19 | Lewis and Clark | Montana | 30049 | 3 | 0 |
5652 | 5652 | 2020-03-20 | Lewis and Clark | Montana | 30049 | 3 | 0 |
6643 | 6643 | 2020-03-21 | Lewis and Clark | Montana | 30049 | 3 | 0 |
7732 | 7732 | 2020-03-22 | Lewis and Clark | Montana | 30049 | 3 | 0 |
8925 | 8925 | 2020-03-23 | Lewis and Clark | Montana | 30049 | 3 | 0 |
10228 | 10228 | 2020-03-24 | Lewis and Clark | Montana | 30049 | 3 | 0 |
11658 | 11658 | 2020-03-25 | Lewis and Clark | Montana | 30049 | 3 | 0 |
13256 | 13256 | 2020-03-26 | Lewis and Clark | Montana | 30049 | 5 | 0 |
14987 | 14987 | 2020-03-27 | Lewis and Clark | Montana | 30049 | 7 | 0 |
16813 | 16813 | 2020-03-28 | Lewis and Clark | Montana | 30049 | 10 | 0 |
18736 | 18736 | 2020-03-29 | Lewis and Clark | Montana | 30049 | 10 | 0 |
20771 | 20771 | 2020-03-30 | Lewis and Clark | Montana | 30049 | 11 | 0 |
22891 | 22891 | 2020-03-31 | Lewis and Clark | Montana | 30049 | 12 | 0 |
25080 | 25080 | 2020-04-01 | Lewis and Clark | Montana | 30049 | 14 | 0 |
27337 | 27337 | 2020-04-02 | Lewis and Clark | Montana | 30049 | 13 | 0 |
29660 | 29660 | 2020-04-03 | Lewis and Clark | Montana | 30049 | 13 | 0 |
32042 | 32042 | 2020-04-04 | Lewis and Clark | Montana | 30049 | 14 | 0 |
34470 | 34470 | 2020-04-05 | Lewis and Clark | Montana | 30049 | 14 | 0 |
36937 | 36937 | 2020-04-06 | Lewis and Clark | Montana | 30049 | 15 | 0 |
39453 | 39453 | 2020-04-07 | Lewis and Clark | Montana | 30049 | 15 | 0 |
42008 | 42008 | 2020-04-08 | Lewis and Clark | Montana | 30049 | 16 | 0 |
44587 | 44587 | 2020-04-09 | Lewis and Clark | Montana | 30049 | 16 | 0 |
47197 | 47197 | 2020-04-10 | Lewis and Clark | Montana | 30049 | 16 | 0 |
49846 | 49846 | 2020-04-11 | Lewis and Clark | Montana | 30049 | 16 | 0 |
52519 | 52519 | 2020-04-12 | Lewis and Clark | Montana | 30049 | 16 | 0 |
55200 | 55200 | 2020-04-13 | Lewis and Clark | Montana | 30049 | 16 | 0 |
57899 | 57899 | 2020-04-14 | Lewis and Clark | Montana | 30049 | 16 | 0 |
60612 | 60612 | 2020-04-15 | Lewis and Clark | Montana | 30049 | 16 | 0 |
63335 | 63335 | 2020-04-16 | Lewis and Clark | Montana | 30049 | 16 | 0 |
66075 | 66075 | 2020-04-17 | Lewis and Clark | Montana | 30049 | 16 | 0 |
68829 | 68829 | 2020-04-18 | Lewis and Clark | Montana | 30049 | 16 | 0 |
71596 | 71596 | 2020-04-19 | Lewis and Clark | Montana | 30049 | 16 | 0 |
74369 | 74369 | 2020-04-20 | Lewis and Clark | Montana | 30049 | 16 | 0 |
77149 | 77149 | 2020-04-21 | Lewis and Clark | Montana | 30049 | 16 | 0 |
79937 | 79937 | 2020-04-22 | Lewis and Clark | Montana | 30049 | 16 | 0 |
82733 | 82733 | 2020-04-23 | Lewis and Clark | Montana | 30049 | 16 | 0 |
85537 | 85537 | 2020-04-24 | Lewis and Clark | Montana | 30049 | 16 | 0 |
88347 | 88347 | 2020-04-25 | Lewis and Clark | Montana | 30049 | 16 | 0 |
91162 | 91162 | 2020-04-26 | Lewis and Clark | Montana | 30049 | 16 | 0 |
93983 | 93983 | 2020-04-27 | Lewis and Clark | Montana | 30049 | 16 | 0 |
96819 | 96819 | 2020-04-28 | Lewis and Clark | Montana | 30049 | 16 | 0 |
99665 | 99665 | 2020-04-29 | Lewis and Clark | Montana | 30049 | 16 | 0 |
102517 | 102517 | 2020-04-30 | Lewis and Clark | Montana | 30049 | 16 | 0 |
105378 | 105378 | 2020-05-01 | Lewis and Clark | Montana | 30049 | 16 | 0 |
108244 | 108244 | 2020-05-02 | Lewis and Clark | Montana | 30049 | 16 | 0 |
111116 | 111116 | 2020-05-03 | Lewis and Clark | Montana | 30049 | 16 | 0 |
113995 | 113995 | 2020-05-04 | Lewis and Clark | Montana | 30049 | 16 | 0 |
116877 | 116877 | 2020-05-05 | Lewis and Clark | Montana | 30049 | 16 | 0 |
119837 | 119837 | 2020-05-06 | Lewis and Clark | Montana | 30049 | 16 | 0 |
122811 | 122811 | 2020-05-07 | Lewis and Clark | Montana | 30049 | 16 | 0 |
125793 | 125793 | 2020-05-08 | Lewis and Clark | Montana | 30049 | 16 | 0 |
128781 | 128781 | 2020-05-09 | Lewis and Clark | Montana | 30049 | 16 | 0 |
131771 | 131771 | 2020-05-10 | Lewis and Clark | Montana | 30049 | 16 | 0 |
134762 | 134762 | 2020-05-11 | Lewis and Clark | Montana | 30049 | 16 | 0 |
137752 | 137752 | 2020-05-12 | Lewis and Clark | Montana | 30049 | 16 | 0 |
140746 | 140746 | 2020-05-13 | Lewis and Clark | Montana | 30049 | 16 | 0 |
143741 | 143741 | 2020-05-14 | Lewis and Clark | Montana | 30049 | 16 | 0 |
146742 | 146742 | 2020-05-15 | Lewis and Clark | Montana | 30049 | 16 | 0 |
149748 | 149748 | 2020-05-16 | Lewis and Clark | Montana | 30049 | 16 | 0 |
152759 | 152759 | 2020-05-17 | Lewis and Clark | Montana | 30049 | 16 | 0 |
155773 | 155773 | 2020-05-18 | Lewis and Clark | Montana | 30049 | 16 | 0 |
158791 | 158791 | 2020-05-19 | Lewis and Clark | Montana | 30049 | 16 | 0 |
161817 | 161817 | 2020-05-20 | Lewis and Clark | Montana | 30049 | 16 | 0 |
164846 | 164846 | 2020-05-21 | Lewis and Clark | Montana | 30049 | 16 | 0 |
167882 | 167882 | 2020-05-22 | Lewis and Clark | Montana | 30049 | 16 | 0 |
170921 | 170921 | 2020-05-23 | Lewis and Clark | Montana | 30049 | 16 | 0 |
173963 | 173963 | 2020-05-24 | Lewis and Clark | Montana | 30049 | 16 | 0 |
177006 | 177006 | 2020-05-25 | Lewis and Clark | Montana | 30049 | 16 | 0 |
180050 | 180050 | 2020-05-26 | Lewis and Clark | Montana | 30049 | 16 | 0 |
183098 | 183098 | 2020-05-27 | Lewis and Clark | Montana | 30049 | 16 | 0 |
186154 | 186154 | 2020-05-28 | Lewis and Clark | Montana | 30049 | 16 | 0 |
189213 | 189213 | 2020-05-29 | Lewis and Clark | Montana | 30049 | 16 | 0 |
192277 | 192277 | 2020-05-30 | Lewis and Clark | Montana | 30049 | 16 | 0 |
195347 | 195347 | 2020-05-31 | Lewis and Clark | Montana | 30049 | 16 | 0 |
198418 | 198418 | 2020-06-01 | Lewis and Clark | Montana | 30049 | 16 | 0 |
201491 | 201491 | 2020-06-02 | Lewis and Clark | Montana | 30049 | 16 | 0 |
204568 | 204568 | 2020-06-03 | Lewis and Clark | Montana | 30049 | 16 | 0 |
207649 | 207649 | 2020-06-04 | Lewis and Clark | Montana | 30049 | 16 | 0 |
210730 | 210730 | 2020-06-05 | Lewis and Clark | Montana | 30049 | 18 | 0 |
213814 | 213814 | 2020-06-06 | Lewis and Clark | Montana | 30049 | 18 | 0 |
216903 | 216903 | 2020-06-07 | Lewis and Clark | Montana | 30049 | 18 | 0 |
219995 | 219995 | 2020-06-08 | Lewis and Clark | Montana | 30049 | 18 | 0 |
223090 | 223090 | 2020-06-09 | Lewis and Clark | Montana | 30049 | 18 | 0 |
226189 | 226189 | 2020-06-10 | Lewis and Clark | Montana | 30049 | 18 | 0 |
229292 | 229292 | 2020-06-11 | Lewis and Clark | Montana | 30049 | 18 | 0 |
232397 | 232397 | 2020-06-12 | Lewis and Clark | Montana | 30049 | 19 | 0 |
235503 | 235503 | 2020-06-13 | Lewis and Clark | Montana | 30049 | 19 | 0 |
238610 | 238610 | 2020-06-14 | Lewis and Clark | Montana | 30049 | 20 | 0 |
241720 | 241720 | 2020-06-15 | Lewis and Clark | Montana | 30049 | 20 | 0 |
244831 | 244831 | 2020-06-16 | Lewis and Clark | Montana | 30049 | 20 | 0 |
247944 | 247944 | 2020-06-17 | Lewis and Clark | Montana | 30049 | 20 | 0 |
251058 | 251058 | 2020-06-18 | Lewis and Clark | Montana | 30049 | 20 | 0 |
254173 | 254173 | 2020-06-19 | Lewis and Clark | Montana | 30049 | 22 | 0 |
257296 | 257296 | 2020-06-20 | Lewis and Clark | Montana | 30049 | 22 | 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);