ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Hill" 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 ▼ |
---|---|---|---|---|---|---|---|
11656 | 11656 | 2020-03-25 | Hill | Montana | 30041 | 1 | 0 |
13254 | 13254 | 2020-03-26 | Hill | Montana | 30041 | 1 | 0 |
14984 | 14984 | 2020-03-27 | Hill | Montana | 30041 | 1 | 0 |
16810 | 16810 | 2020-03-28 | Hill | Montana | 30041 | 1 | 0 |
18733 | 18733 | 2020-03-29 | Hill | Montana | 30041 | 1 | 0 |
20768 | 20768 | 2020-03-30 | Hill | Montana | 30041 | 1 | 0 |
22888 | 22888 | 2020-03-31 | Hill | Montana | 30041 | 1 | 0 |
25077 | 25077 | 2020-04-01 | Hill | Montana | 30041 | 1 | 0 |
27334 | 27334 | 2020-04-02 | Hill | Montana | 30041 | 1 | 0 |
29657 | 29657 | 2020-04-03 | Hill | Montana | 30041 | 1 | 0 |
32039 | 32039 | 2020-04-04 | Hill | Montana | 30041 | 1 | 0 |
34467 | 34467 | 2020-04-05 | Hill | Montana | 30041 | 1 | 0 |
36934 | 36934 | 2020-04-06 | Hill | Montana | 30041 | 1 | 0 |
39450 | 39450 | 2020-04-07 | Hill | Montana | 30041 | 1 | 0 |
42005 | 42005 | 2020-04-08 | Hill | Montana | 30041 | 1 | 0 |
44584 | 44584 | 2020-04-09 | Hill | Montana | 30041 | 1 | 0 |
47194 | 47194 | 2020-04-10 | Hill | Montana | 30041 | 1 | 0 |
49843 | 49843 | 2020-04-11 | Hill | Montana | 30041 | 1 | 0 |
52516 | 52516 | 2020-04-12 | Hill | Montana | 30041 | 1 | 0 |
55197 | 55197 | 2020-04-13 | Hill | Montana | 30041 | 1 | 0 |
57896 | 57896 | 2020-04-14 | Hill | Montana | 30041 | 1 | 0 |
60609 | 60609 | 2020-04-15 | Hill | Montana | 30041 | 1 | 0 |
63332 | 63332 | 2020-04-16 | Hill | Montana | 30041 | 1 | 0 |
66072 | 66072 | 2020-04-17 | Hill | Montana | 30041 | 1 | 0 |
68826 | 68826 | 2020-04-18 | Hill | Montana | 30041 | 1 | 0 |
71593 | 71593 | 2020-04-19 | Hill | Montana | 30041 | 1 | 0 |
74366 | 74366 | 2020-04-20 | Hill | Montana | 30041 | 1 | 0 |
77146 | 77146 | 2020-04-21 | Hill | Montana | 30041 | 1 | 0 |
79934 | 79934 | 2020-04-22 | Hill | Montana | 30041 | 1 | 0 |
82730 | 82730 | 2020-04-23 | Hill | Montana | 30041 | 1 | 0 |
85534 | 85534 | 2020-04-24 | Hill | Montana | 30041 | 1 | 0 |
88344 | 88344 | 2020-04-25 | Hill | Montana | 30041 | 1 | 0 |
91159 | 91159 | 2020-04-26 | Hill | Montana | 30041 | 1 | 0 |
93980 | 93980 | 2020-04-27 | Hill | Montana | 30041 | 1 | 0 |
96816 | 96816 | 2020-04-28 | Hill | Montana | 30041 | 1 | 0 |
99662 | 99662 | 2020-04-29 | Hill | Montana | 30041 | 1 | 0 |
102514 | 102514 | 2020-04-30 | Hill | Montana | 30041 | 1 | 0 |
105375 | 105375 | 2020-05-01 | Hill | Montana | 30041 | 1 | 0 |
108241 | 108241 | 2020-05-02 | Hill | Montana | 30041 | 1 | 0 |
111113 | 111113 | 2020-05-03 | Hill | Montana | 30041 | 1 | 0 |
113992 | 113992 | 2020-05-04 | Hill | Montana | 30041 | 1 | 0 |
116874 | 116874 | 2020-05-05 | Hill | Montana | 30041 | 1 | 0 |
119834 | 119834 | 2020-05-06 | Hill | Montana | 30041 | 1 | 0 |
122808 | 122808 | 2020-05-07 | Hill | Montana | 30041 | 1 | 0 |
125790 | 125790 | 2020-05-08 | Hill | Montana | 30041 | 1 | 0 |
128778 | 128778 | 2020-05-09 | Hill | Montana | 30041 | 1 | 0 |
131768 | 131768 | 2020-05-10 | Hill | Montana | 30041 | 1 | 0 |
134759 | 134759 | 2020-05-11 | Hill | Montana | 30041 | 1 | 0 |
137749 | 137749 | 2020-05-12 | Hill | Montana | 30041 | 1 | 0 |
140743 | 140743 | 2020-05-13 | Hill | Montana | 30041 | 1 | 0 |
143738 | 143738 | 2020-05-14 | Hill | Montana | 30041 | 1 | 0 |
146739 | 146739 | 2020-05-15 | Hill | Montana | 30041 | 1 | 0 |
149745 | 149745 | 2020-05-16 | Hill | Montana | 30041 | 1 | 0 |
152756 | 152756 | 2020-05-17 | Hill | Montana | 30041 | 1 | 0 |
155770 | 155770 | 2020-05-18 | Hill | Montana | 30041 | 1 | 0 |
158788 | 158788 | 2020-05-19 | Hill | Montana | 30041 | 1 | 0 |
161814 | 161814 | 2020-05-20 | Hill | Montana | 30041 | 1 | 0 |
164843 | 164843 | 2020-05-21 | Hill | Montana | 30041 | 1 | 0 |
167879 | 167879 | 2020-05-22 | Hill | Montana | 30041 | 1 | 0 |
170918 | 170918 | 2020-05-23 | Hill | Montana | 30041 | 1 | 0 |
173960 | 173960 | 2020-05-24 | Hill | Montana | 30041 | 1 | 0 |
177003 | 177003 | 2020-05-25 | Hill | Montana | 30041 | 1 | 0 |
180047 | 180047 | 2020-05-26 | Hill | Montana | 30041 | 1 | 0 |
183095 | 183095 | 2020-05-27 | Hill | Montana | 30041 | 1 | 0 |
186151 | 186151 | 2020-05-28 | Hill | Montana | 30041 | 1 | 0 |
189210 | 189210 | 2020-05-29 | Hill | Montana | 30041 | 1 | 0 |
192274 | 192274 | 2020-05-30 | Hill | Montana | 30041 | 1 | 0 |
195344 | 195344 | 2020-05-31 | Hill | Montana | 30041 | 1 | 0 |
198415 | 198415 | 2020-06-01 | Hill | Montana | 30041 | 1 | 0 |
201488 | 201488 | 2020-06-02 | Hill | Montana | 30041 | 1 | 0 |
204565 | 204565 | 2020-06-03 | Hill | Montana | 30041 | 1 | 0 |
207646 | 207646 | 2020-06-04 | Hill | Montana | 30041 | 1 | 0 |
210727 | 210727 | 2020-06-05 | Hill | Montana | 30041 | 1 | 0 |
213811 | 213811 | 2020-06-06 | Hill | Montana | 30041 | 1 | 0 |
216900 | 216900 | 2020-06-07 | Hill | Montana | 30041 | 1 | 0 |
219992 | 219992 | 2020-06-08 | Hill | Montana | 30041 | 1 | 0 |
223087 | 223087 | 2020-06-09 | Hill | Montana | 30041 | 1 | 0 |
226186 | 226186 | 2020-06-10 | Hill | Montana | 30041 | 1 | 0 |
229289 | 229289 | 2020-06-11 | Hill | Montana | 30041 | 1 | 0 |
232394 | 232394 | 2020-06-12 | Hill | Montana | 30041 | 1 | 0 |
235500 | 235500 | 2020-06-13 | Hill | Montana | 30041 | 1 | 0 |
238607 | 238607 | 2020-06-14 | Hill | Montana | 30041 | 1 | 0 |
241717 | 241717 | 2020-06-15 | Hill | Montana | 30041 | 1 | 0 |
244828 | 244828 | 2020-06-16 | Hill | Montana | 30041 | 1 | 0 |
247941 | 247941 | 2020-06-17 | Hill | Montana | 30041 | 1 | 0 |
251055 | 251055 | 2020-06-18 | Hill | Montana | 30041 | 1 | 0 |
254170 | 254170 | 2020-06-19 | Hill | Montana | 30041 | 1 | 0 |
257293 | 257293 | 2020-06-20 | Hill | Montana | 30041 | 1 | 0 |
260419 | 260419 | 2020-06-21 | Hill | Montana | 30041 | 1 | 0 |
263548 | 263548 | 2020-06-22 | Hill | Montana | 30041 | 1 | 0 |
266674 | 266674 | 2020-06-23 | Hill | Montana | 30041 | 1 | 0 |
269807 | 269807 | 2020-06-24 | Hill | Montana | 30041 | 1 | 0 |
272946 | 272946 | 2020-06-25 | Hill | Montana | 30041 | 1 | 0 |
276089 | 276089 | 2020-06-26 | Hill | Montana | 30041 | 1 | 0 |
279237 | 279237 | 2020-06-27 | Hill | Montana | 30041 | 1 | 0 |
282385 | 282385 | 2020-06-28 | Hill | Montana | 30041 | 1 | 0 |
285530 | 285530 | 2020-06-29 | Hill | Montana | 30041 | 1 | 0 |
288680 | 288680 | 2020-06-30 | Hill | Montana | 30041 | 1 | 0 |
291831 | 291831 | 2020-07-01 | Hill | Montana | 30041 | 1 | 0 |
294985 | 294985 | 2020-07-02 | Hill | Montana | 30041 | 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);