ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 30013 and state = "Montana" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
6640 | 6640 | 2020-03-21 | Cascade | Montana | 30013 | 3 | 0 |
7729 | 7729 | 2020-03-22 | Cascade | Montana | 30013 | 3 | 0 |
8922 | 8922 | 2020-03-23 | Cascade | Montana | 30013 | 3 | 0 |
10224 | 10224 | 2020-03-24 | Cascade | Montana | 30013 | 3 | 0 |
11653 | 11653 | 2020-03-25 | Cascade | Montana | 30013 | 3 | 0 |
13251 | 13251 | 2020-03-26 | Cascade | Montana | 30013 | 5 | 0 |
14981 | 14981 | 2020-03-27 | Cascade | Montana | 30013 | 7 | 0 |
16807 | 16807 | 2020-03-28 | Cascade | Montana | 30013 | 7 | 0 |
18729 | 18729 | 2020-03-29 | Cascade | Montana | 30013 | 7 | 0 |
20764 | 20764 | 2020-03-30 | Cascade | Montana | 30013 | 7 | 0 |
22884 | 22884 | 2020-03-31 | Cascade | Montana | 30013 | 9 | 0 |
25073 | 25073 | 2020-04-01 | Cascade | Montana | 30013 | 9 | 0 |
27330 | 27330 | 2020-04-02 | Cascade | Montana | 30013 | 11 | 0 |
29652 | 29652 | 2020-04-03 | Cascade | Montana | 30013 | 11 | 0 |
32034 | 32034 | 2020-04-04 | Cascade | Montana | 30013 | 11 | 0 |
34462 | 34462 | 2020-04-05 | Cascade | Montana | 30013 | 11 | 0 |
36929 | 36929 | 2020-04-06 | Cascade | Montana | 30013 | 11 | 0 |
39445 | 39445 | 2020-04-07 | Cascade | Montana | 30013 | 11 | 0 |
42000 | 42000 | 2020-04-08 | Cascade | Montana | 30013 | 11 | 0 |
44579 | 44579 | 2020-04-09 | Cascade | Montana | 30013 | 12 | 0 |
47189 | 47189 | 2020-04-10 | Cascade | Montana | 30013 | 12 | 0 |
49837 | 49837 | 2020-04-11 | Cascade | Montana | 30013 | 13 | 0 |
52510 | 52510 | 2020-04-12 | Cascade | Montana | 30013 | 13 | 0 |
55191 | 55191 | 2020-04-13 | Cascade | Montana | 30013 | 13 | 0 |
57890 | 57890 | 2020-04-14 | Cascade | Montana | 30013 | 13 | 0 |
60603 | 60603 | 2020-04-15 | Cascade | Montana | 30013 | 13 | 0 |
63326 | 63326 | 2020-04-16 | Cascade | Montana | 30013 | 13 | 0 |
66066 | 66066 | 2020-04-17 | Cascade | Montana | 30013 | 13 | 0 |
68820 | 68820 | 2020-04-18 | Cascade | Montana | 30013 | 13 | 1 |
71587 | 71587 | 2020-04-19 | Cascade | Montana | 30013 | 13 | 1 |
74360 | 74360 | 2020-04-20 | Cascade | Montana | 30013 | 13 | 2 |
77140 | 77140 | 2020-04-21 | Cascade | Montana | 30013 | 13 | 2 |
79928 | 79928 | 2020-04-22 | Cascade | Montana | 30013 | 13 | 2 |
82724 | 82724 | 2020-04-23 | Cascade | Montana | 30013 | 13 | 2 |
85528 | 85528 | 2020-04-24 | Cascade | Montana | 30013 | 13 | 2 |
88338 | 88338 | 2020-04-25 | Cascade | Montana | 30013 | 14 | 2 |
91153 | 91153 | 2020-04-26 | Cascade | Montana | 30013 | 14 | 2 |
93974 | 93974 | 2020-04-27 | Cascade | Montana | 30013 | 14 | 2 |
96810 | 96810 | 2020-04-28 | Cascade | Montana | 30013 | 15 | 2 |
99656 | 99656 | 2020-04-29 | Cascade | Montana | 30013 | 15 | 2 |
102508 | 102508 | 2020-04-30 | Cascade | Montana | 30013 | 15 | 2 |
105369 | 105369 | 2020-05-01 | Cascade | Montana | 30013 | 15 | 2 |
108235 | 108235 | 2020-05-02 | Cascade | Montana | 30013 | 15 | 2 |
111107 | 111107 | 2020-05-03 | Cascade | Montana | 30013 | 15 | 2 |
113986 | 113986 | 2020-05-04 | Cascade | Montana | 30013 | 16 | 2 |
116868 | 116868 | 2020-05-05 | Cascade | Montana | 30013 | 16 | 2 |
119828 | 119828 | 2020-05-06 | Cascade | Montana | 30013 | 16 | 2 |
122802 | 122802 | 2020-05-07 | Cascade | Montana | 30013 | 16 | 2 |
125784 | 125784 | 2020-05-08 | Cascade | Montana | 30013 | 16 | 2 |
128772 | 128772 | 2020-05-09 | Cascade | Montana | 30013 | 16 | 2 |
131762 | 131762 | 2020-05-10 | Cascade | Montana | 30013 | 16 | 2 |
134753 | 134753 | 2020-05-11 | Cascade | Montana | 30013 | 16 | 2 |
137743 | 137743 | 2020-05-12 | Cascade | Montana | 30013 | 17 | 2 |
140737 | 140737 | 2020-05-13 | Cascade | Montana | 30013 | 17 | 2 |
143732 | 143732 | 2020-05-14 | Cascade | Montana | 30013 | 17 | 2 |
146733 | 146733 | 2020-05-15 | Cascade | Montana | 30013 | 17 | 2 |
149739 | 149739 | 2020-05-16 | Cascade | Montana | 30013 | 17 | 2 |
152750 | 152750 | 2020-05-17 | Cascade | Montana | 30013 | 17 | 2 |
155764 | 155764 | 2020-05-18 | Cascade | Montana | 30013 | 17 | 2 |
158782 | 158782 | 2020-05-19 | Cascade | Montana | 30013 | 17 | 2 |
161808 | 161808 | 2020-05-20 | Cascade | Montana | 30013 | 17 | 2 |
164837 | 164837 | 2020-05-21 | Cascade | Montana | 30013 | 17 | 2 |
167873 | 167873 | 2020-05-22 | Cascade | Montana | 30013 | 17 | 2 |
170912 | 170912 | 2020-05-23 | Cascade | Montana | 30013 | 17 | 2 |
173954 | 173954 | 2020-05-24 | Cascade | Montana | 30013 | 17 | 2 |
176997 | 176997 | 2020-05-25 | Cascade | Montana | 30013 | 17 | 2 |
180041 | 180041 | 2020-05-26 | Cascade | Montana | 30013 | 17 | 2 |
183089 | 183089 | 2020-05-27 | Cascade | Montana | 30013 | 17 | 2 |
186145 | 186145 | 2020-05-28 | Cascade | Montana | 30013 | 17 | 2 |
189204 | 189204 | 2020-05-29 | Cascade | Montana | 30013 | 17 | 2 |
192268 | 192268 | 2020-05-30 | Cascade | Montana | 30013 | 17 | 2 |
195338 | 195338 | 2020-05-31 | Cascade | Montana | 30013 | 17 | 2 |
198409 | 198409 | 2020-06-01 | Cascade | Montana | 30013 | 17 | 2 |
201482 | 201482 | 2020-06-02 | Cascade | Montana | 30013 | 17 | 2 |
204559 | 204559 | 2020-06-03 | Cascade | Montana | 30013 | 17 | 2 |
207640 | 207640 | 2020-06-04 | Cascade | Montana | 30013 | 17 | 2 |
210721 | 210721 | 2020-06-05 | Cascade | Montana | 30013 | 17 | 2 |
213805 | 213805 | 2020-06-06 | Cascade | Montana | 30013 | 17 | 2 |
216894 | 216894 | 2020-06-07 | Cascade | Montana | 30013 | 17 | 2 |
219986 | 219986 | 2020-06-08 | Cascade | Montana | 30013 | 17 | 2 |
223081 | 223081 | 2020-06-09 | Cascade | Montana | 30013 | 17 | 2 |
226180 | 226180 | 2020-06-10 | Cascade | Montana | 30013 | 17 | 2 |
229283 | 229283 | 2020-06-11 | Cascade | Montana | 30013 | 17 | 2 |
232387 | 232387 | 2020-06-12 | Cascade | Montana | 30013 | 17 | 2 |
235493 | 235493 | 2020-06-13 | Cascade | Montana | 30013 | 17 | 2 |
238600 | 238600 | 2020-06-14 | Cascade | Montana | 30013 | 18 | 2 |
241710 | 241710 | 2020-06-15 | Cascade | Montana | 30013 | 19 | 2 |
244821 | 244821 | 2020-06-16 | Cascade | Montana | 30013 | 19 | 2 |
247934 | 247934 | 2020-06-17 | Cascade | Montana | 30013 | 20 | 2 |
251047 | 251047 | 2020-06-18 | Cascade | Montana | 30013 | 20 | 2 |
254162 | 254162 | 2020-06-19 | Cascade | Montana | 30013 | 20 | 2 |
257284 | 257284 | 2020-06-20 | Cascade | Montana | 30013 | 21 | 2 |
260410 | 260410 | 2020-06-21 | Cascade | Montana | 30013 | 22 | 2 |
263539 | 263539 | 2020-06-22 | Cascade | Montana | 30013 | 22 | 2 |
266665 | 266665 | 2020-06-23 | Cascade | Montana | 30013 | 25 | 2 |
269798 | 269798 | 2020-06-24 | Cascade | Montana | 30013 | 26 | 2 |
272936 | 272936 | 2020-06-25 | Cascade | Montana | 30013 | 26 | 2 |
276079 | 276079 | 2020-06-26 | Cascade | Montana | 30013 | 26 | 2 |
279227 | 279227 | 2020-06-27 | Cascade | Montana | 30013 | 27 | 2 |
282375 | 282375 | 2020-06-28 | Cascade | Montana | 30013 | 27 | 2 |
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);