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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, 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 |
64168 | 64168 | 2020-04-16 | Hill | Texas | 48217 | 9 | 1 |
66072 | 66072 | 2020-04-17 | Hill | Montana | 30041 | 1 | 0 |
66915 | 66915 | 2020-04-17 | Hill | Texas | 48217 | 10 | 1 |
68826 | 68826 | 2020-04-18 | Hill | Montana | 30041 | 1 | 0 |
69675 | 69675 | 2020-04-18 | Hill | Texas | 48217 | 10 | 1 |
71593 | 71593 | 2020-04-19 | Hill | Montana | 30041 | 1 | 0 |
72443 | 72443 | 2020-04-19 | Hill | Texas | 48217 | 10 | 1 |
74366 | 74366 | 2020-04-20 | Hill | Montana | 30041 | 1 | 0 |
75219 | 75219 | 2020-04-20 | Hill | Texas | 48217 | 10 | 1 |
77146 | 77146 | 2020-04-21 | Hill | Montana | 30041 | 1 | 0 |
78001 | 78001 | 2020-04-21 | Hill | Texas | 48217 | 11 | 1 |
79934 | 79934 | 2020-04-22 | Hill | Montana | 30041 | 1 | 0 |
80792 | 80792 | 2020-04-22 | Hill | Texas | 48217 | 12 | 1 |
82730 | 82730 | 2020-04-23 | Hill | Montana | 30041 | 1 | 0 |
83592 | 83592 | 2020-04-23 | Hill | Texas | 48217 | 14 | 1 |
85534 | 85534 | 2020-04-24 | Hill | Montana | 30041 | 1 | 0 |
86397 | 86397 | 2020-04-24 | Hill | Texas | 48217 | 15 | 1 |
88344 | 88344 | 2020-04-25 | Hill | Montana | 30041 | 1 | 0 |
89212 | 89212 | 2020-04-25 | Hill | Texas | 48217 | 15 | 1 |
91159 | 91159 | 2020-04-26 | Hill | Montana | 30041 | 1 | 0 |
92029 | 92029 | 2020-04-26 | Hill | Texas | 48217 | 15 | 1 |
93980 | 93980 | 2020-04-27 | Hill | Montana | 30041 | 1 | 0 |
94858 | 94858 | 2020-04-27 | Hill | Texas | 48217 | 15 | 1 |
96816 | 96816 | 2020-04-28 | Hill | Montana | 30041 | 1 | 0 |
97698 | 97698 | 2020-04-28 | Hill | Texas | 48217 | 15 | 1 |
99662 | 99662 | 2020-04-29 | Hill | Montana | 30041 | 1 | 0 |
100548 | 100548 | 2020-04-29 | Hill | Texas | 48217 | 16 | 1 |
102514 | 102514 | 2020-04-30 | Hill | Montana | 30041 | 1 | 0 |
103403 | 103403 | 2020-04-30 | Hill | Texas | 48217 | 16 | 1 |
105375 | 105375 | 2020-05-01 | Hill | Montana | 30041 | 1 | 0 |
106267 | 106267 | 2020-05-01 | Hill | Texas | 48217 | 16 | 1 |
108241 | 108241 | 2020-05-02 | Hill | Montana | 30041 | 1 | 0 |
109136 | 109136 | 2020-05-02 | Hill | Texas | 48217 | 16 | 1 |
111113 | 111113 | 2020-05-03 | Hill | Montana | 30041 | 1 | 0 |
112010 | 112010 | 2020-05-03 | Hill | Texas | 48217 | 17 | 1 |
113992 | 113992 | 2020-05-04 | Hill | Montana | 30041 | 1 | 0 |
114892 | 114892 | 2020-05-04 | Hill | Texas | 48217 | 17 | 1 |
116874 | 116874 | 2020-05-05 | Hill | Montana | 30041 | 1 | 0 |
117851 | 117851 | 2020-05-05 | Hill | Texas | 48217 | 18 | 1 |
119834 | 119834 | 2020-05-06 | Hill | Montana | 30041 | 1 | 0 |
120815 | 120815 | 2020-05-06 | Hill | Texas | 48217 | 18 | 1 |
122808 | 122808 | 2020-05-07 | Hill | Montana | 30041 | 1 | 0 |
123794 | 123794 | 2020-05-07 | Hill | Texas | 48217 | 18 | 1 |
125790 | 125790 | 2020-05-08 | Hill | Montana | 30041 | 1 | 0 |
126777 | 126777 | 2020-05-08 | Hill | Texas | 48217 | 19 | 1 |
128778 | 128778 | 2020-05-09 | Hill | Montana | 30041 | 1 | 0 |
129766 | 129766 | 2020-05-09 | Hill | Texas | 48217 | 19 | 1 |
131768 | 131768 | 2020-05-10 | Hill | Montana | 30041 | 1 | 0 |
132756 | 132756 | 2020-05-10 | Hill | Texas | 48217 | 19 | 1 |
134759 | 134759 | 2020-05-11 | Hill | Montana | 30041 | 1 | 0 |
135747 | 135747 | 2020-05-11 | Hill | Texas | 48217 | 19 | 1 |
137749 | 137749 | 2020-05-12 | Hill | Montana | 30041 | 1 | 0 |
138737 | 138737 | 2020-05-12 | Hill | Texas | 48217 | 21 | 1 |
140743 | 140743 | 2020-05-13 | Hill | Montana | 30041 | 1 | 0 |
141733 | 141733 | 2020-05-13 | Hill | Texas | 48217 | 21 | 1 |
143738 | 143738 | 2020-05-14 | Hill | Montana | 30041 | 1 | 0 |
144730 | 144730 | 2020-05-14 | Hill | Texas | 48217 | 22 | 1 |
146739 | 146739 | 2020-05-15 | Hill | Montana | 30041 | 1 | 0 |
147734 | 147734 | 2020-05-15 | Hill | Texas | 48217 | 22 | 1 |
149745 | 149745 | 2020-05-16 | 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);