ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,555 rows where county = "Hill" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, 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 |
21419 | 21419 | 2020-03-30 | Hill | Texas | 48217 | 1 | 0 |
22888 | 22888 | 2020-03-31 | Hill | Montana | 30041 | 1 | 0 |
23558 | 23558 | 2020-03-31 | Hill | Texas | 48217 | 1 | 0 |
25077 | 25077 | 2020-04-01 | Hill | Montana | 30041 | 1 | 0 |
25768 | 25768 | 2020-04-01 | Hill | Texas | 48217 | 2 | 0 |
27334 | 27334 | 2020-04-02 | Hill | Montana | 30041 | 1 | 0 |
28051 | 28051 | 2020-04-02 | Hill | Texas | 48217 | 3 | 0 |
29657 | 29657 | 2020-04-03 | Hill | Montana | 30041 | 1 | 0 |
30386 | 30386 | 2020-04-03 | Hill | Texas | 48217 | 3 | 0 |
32039 | 32039 | 2020-04-04 | Hill | Montana | 30041 | 1 | 0 |
32780 | 32780 | 2020-04-04 | Hill | Texas | 48217 | 5 | 0 |
34467 | 34467 | 2020-04-05 | Hill | Montana | 30041 | 1 | 0 |
35218 | 35218 | 2020-04-05 | Hill | Texas | 48217 | 5 | 0 |
36934 | 36934 | 2020-04-06 | Hill | Montana | 30041 | 1 | 0 |
37694 | 37694 | 2020-04-06 | Hill | Texas | 48217 | 5 | 0 |
39450 | 39450 | 2020-04-07 | Hill | Montana | 30041 | 1 | 0 |
40221 | 40221 | 2020-04-07 | Hill | Texas | 48217 | 5 | 0 |
42005 | 42005 | 2020-04-08 | Hill | Montana | 30041 | 1 | 0 |
42788 | 42788 | 2020-04-08 | Hill | Texas | 48217 | 5 | 0 |
44584 | 44584 | 2020-04-09 | Hill | Montana | 30041 | 1 | 0 |
45377 | 45377 | 2020-04-09 | Hill | Texas | 48217 | 6 | 0 |
47194 | 47194 | 2020-04-10 | Hill | Montana | 30041 | 1 | 0 |
47997 | 47997 | 2020-04-10 | Hill | Texas | 48217 | 8 | 0 |
49843 | 49843 | 2020-04-11 | Hill | Montana | 30041 | 1 | 0 |
50655 | 50655 | 2020-04-11 | Hill | Texas | 48217 | 8 | 0 |
52516 | 52516 | 2020-04-12 | Hill | Montana | 30041 | 1 | 0 |
53330 | 53330 | 2020-04-12 | Hill | Texas | 48217 | 8 | 0 |
55197 | 55197 | 2020-04-13 | Hill | Montana | 30041 | 1 | 0 |
56018 | 56018 | 2020-04-13 | Hill | Texas | 48217 | 8 | 0 |
57896 | 57896 | 2020-04-14 | Hill | Montana | 30041 | 1 | 0 |
58723 | 58723 | 2020-04-14 | Hill | Texas | 48217 | 8 | 0 |
60609 | 60609 | 2020-04-15 | Hill | Montana | 30041 | 1 | 0 |
61441 | 61441 | 2020-04-15 | Hill | Texas | 48217 | 8 | 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 |
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);