ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,324 rows where county = "Gallatin" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
county 1
- Gallatin · 2,324 ✖
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1783 | 1783 | 2020-03-13 | Gallatin | Montana | 30031 | 1 | 0 |
2128 | 2128 | 2020-03-14 | Gallatin | Montana | 30031 | 1 | 0 |
2535 | 2535 | 2020-03-15 | Gallatin | Montana | 30031 | 1 | 0 |
2990 | 2990 | 2020-03-16 | Gallatin | Montana | 30031 | 1 | 0 |
3500 | 3500 | 2020-03-17 | Gallatin | Montana | 30031 | 1 | 0 |
4091 | 4091 | 2020-03-18 | Gallatin | Montana | 30031 | 2 | 0 |
4812 | 4812 | 2020-03-19 | Gallatin | Montana | 30031 | 2 | 0 |
5651 | 5651 | 2020-03-20 | Gallatin | Montana | 30031 | 2 | 0 |
6642 | 6642 | 2020-03-21 | Gallatin | Montana | 30031 | 7 | 0 |
7731 | 7731 | 2020-03-22 | Gallatin | Montana | 30031 | 10 | 0 |
8924 | 8924 | 2020-03-23 | Gallatin | Montana | 30031 | 16 | 0 |
10226 | 10226 | 2020-03-24 | Gallatin | Montana | 30031 | 19 | 0 |
11655 | 11655 | 2020-03-25 | Gallatin | Montana | 30031 | 24 | 0 |
13253 | 13253 | 2020-03-26 | Gallatin | Montana | 30031 | 38 | 0 |
14983 | 14983 | 2020-03-27 | Gallatin | Montana | 30031 | 42 | 0 |
16809 | 16809 | 2020-03-28 | Gallatin | Montana | 30031 | 57 | 0 |
18732 | 18732 | 2020-03-29 | Gallatin | Montana | 30031 | 62 | 0 |
20767 | 20767 | 2020-03-30 | Gallatin | Montana | 30031 | 69 | 0 |
22887 | 22887 | 2020-03-31 | Gallatin | Montana | 30031 | 74 | 0 |
25076 | 25076 | 2020-04-01 | Gallatin | Montana | 30031 | 79 | 0 |
27333 | 27333 | 2020-04-02 | Gallatin | Montana | 30031 | 93 | 0 |
29655 | 29655 | 2020-04-03 | Gallatin | Montana | 30031 | 101 | 0 |
32037 | 32037 | 2020-04-04 | Gallatin | Montana | 30031 | 109 | 0 |
34465 | 34465 | 2020-04-05 | Gallatin | Montana | 30031 | 115 | 0 |
36932 | 36932 | 2020-04-06 | Gallatin | Montana | 30031 | 118 | 0 |
39448 | 39448 | 2020-04-07 | Gallatin | Montana | 30031 | 118 | 0 |
42003 | 42003 | 2020-04-08 | Gallatin | Montana | 30031 | 119 | 0 |
44582 | 44582 | 2020-04-09 | Gallatin | Montana | 30031 | 128 | 0 |
47192 | 47192 | 2020-04-10 | Gallatin | Montana | 30031 | 134 | 0 |
49840 | 49840 | 2020-04-11 | Gallatin | Montana | 30031 | 135 | 0 |
52513 | 52513 | 2020-04-12 | Gallatin | Montana | 30031 | 138 | 0 |
55194 | 55194 | 2020-04-13 | Gallatin | Montana | 30031 | 138 | 0 |
57893 | 57893 | 2020-04-14 | Gallatin | Montana | 30031 | 138 | 0 |
60606 | 60606 | 2020-04-15 | Gallatin | Montana | 30031 | 139 | 0 |
63329 | 63329 | 2020-04-16 | Gallatin | Montana | 30031 | 141 | 0 |
66069 | 66069 | 2020-04-17 | Gallatin | Montana | 30031 | 142 | 0 |
68823 | 68823 | 2020-04-18 | Gallatin | Montana | 30031 | 142 | 0 |
71590 | 71590 | 2020-04-19 | Gallatin | Montana | 30031 | 143 | 0 |
74363 | 74363 | 2020-04-20 | Gallatin | Montana | 30031 | 143 | 0 |
77143 | 77143 | 2020-04-21 | Gallatin | Montana | 30031 | 145 | 0 |
79931 | 79931 | 2020-04-22 | Gallatin | Montana | 30031 | 145 | 0 |
82727 | 82727 | 2020-04-23 | Gallatin | Montana | 30031 | 146 | 0 |
85531 | 85531 | 2020-04-24 | Gallatin | Montana | 30031 | 146 | 0 |
88341 | 88341 | 2020-04-25 | Gallatin | Montana | 30031 | 146 | 0 |
91156 | 91156 | 2020-04-26 | Gallatin | Montana | 30031 | 146 | 0 |
93977 | 93977 | 2020-04-27 | Gallatin | Montana | 30031 | 146 | 0 |
96813 | 96813 | 2020-04-28 | Gallatin | Montana | 30031 | 146 | 1 |
99659 | 99659 | 2020-04-29 | Gallatin | Montana | 30031 | 146 | 1 |
102511 | 102511 | 2020-04-30 | Gallatin | Montana | 30031 | 146 | 1 |
105372 | 105372 | 2020-05-01 | Gallatin | Montana | 30031 | 146 | 1 |
108238 | 108238 | 2020-05-02 | Gallatin | Montana | 30031 | 146 | 1 |
111110 | 111110 | 2020-05-03 | Gallatin | Montana | 30031 | 146 | 1 |
113989 | 113989 | 2020-05-04 | Gallatin | Montana | 30031 | 146 | 1 |
116871 | 116871 | 2020-05-05 | Gallatin | Montana | 30031 | 146 | 1 |
119831 | 119831 | 2020-05-06 | Gallatin | Montana | 30031 | 146 | 1 |
122805 | 122805 | 2020-05-07 | Gallatin | Montana | 30031 | 146 | 1 |
125787 | 125787 | 2020-05-08 | Gallatin | Montana | 30031 | 148 | 1 |
128775 | 128775 | 2020-05-09 | Gallatin | Montana | 30031 | 149 | 1 |
131765 | 131765 | 2020-05-10 | Gallatin | Montana | 30031 | 149 | 1 |
134756 | 134756 | 2020-05-11 | Gallatin | Montana | 30031 | 149 | 1 |
137746 | 137746 | 2020-05-12 | Gallatin | Montana | 30031 | 149 | 1 |
140740 | 140740 | 2020-05-13 | Gallatin | Montana | 30031 | 149 | 1 |
143735 | 143735 | 2020-05-14 | Gallatin | Montana | 30031 | 149 | 1 |
146736 | 146736 | 2020-05-15 | Gallatin | Montana | 30031 | 149 | 1 |
149742 | 149742 | 2020-05-16 | Gallatin | Montana | 30031 | 149 | 1 |
152753 | 152753 | 2020-05-17 | Gallatin | Montana | 30031 | 149 | 1 |
155767 | 155767 | 2020-05-18 | Gallatin | Montana | 30031 | 149 | 1 |
158785 | 158785 | 2020-05-19 | Gallatin | Montana | 30031 | 149 | 1 |
161811 | 161811 | 2020-05-20 | Gallatin | Montana | 30031 | 149 | 1 |
164840 | 164840 | 2020-05-21 | Gallatin | Montana | 30031 | 149 | 1 |
167876 | 167876 | 2020-05-22 | Gallatin | Montana | 30031 | 149 | 1 |
170915 | 170915 | 2020-05-23 | Gallatin | Montana | 30031 | 149 | 1 |
173957 | 173957 | 2020-05-24 | Gallatin | Montana | 30031 | 149 | 1 |
177000 | 177000 | 2020-05-25 | Gallatin | Montana | 30031 | 149 | 1 |
180044 | 180044 | 2020-05-26 | Gallatin | Montana | 30031 | 149 | 1 |
183092 | 183092 | 2020-05-27 | Gallatin | Montana | 30031 | 149 | 1 |
186148 | 186148 | 2020-05-28 | Gallatin | Montana | 30031 | 149 | 1 |
189207 | 189207 | 2020-05-29 | Gallatin | Montana | 30031 | 150 | 1 |
192271 | 192271 | 2020-05-30 | Gallatin | Montana | 30031 | 151 | 1 |
195341 | 195341 | 2020-05-31 | Gallatin | Montana | 30031 | 151 | 1 |
198412 | 198412 | 2020-06-01 | Gallatin | Montana | 30031 | 153 | 1 |
201485 | 201485 | 2020-06-02 | Gallatin | Montana | 30031 | 155 | 1 |
204562 | 204562 | 2020-06-03 | Gallatin | Montana | 30031 | 155 | 1 |
207643 | 207643 | 2020-06-04 | Gallatin | Montana | 30031 | 161 | 1 |
210724 | 210724 | 2020-06-05 | Gallatin | Montana | 30031 | 161 | 1 |
213808 | 213808 | 2020-06-06 | Gallatin | Montana | 30031 | 161 | 1 |
216897 | 216897 | 2020-06-07 | Gallatin | Montana | 30031 | 162 | 1 |
219989 | 219989 | 2020-06-08 | Gallatin | Montana | 30031 | 164 | 1 |
223084 | 223084 | 2020-06-09 | Gallatin | Montana | 30031 | 168 | 1 |
226183 | 226183 | 2020-06-10 | Gallatin | Montana | 30031 | 174 | 1 |
229286 | 229286 | 2020-06-11 | Gallatin | Montana | 30031 | 176 | 1 |
232391 | 232391 | 2020-06-12 | Gallatin | Montana | 30031 | 182 | 1 |
235497 | 235497 | 2020-06-13 | Gallatin | Montana | 30031 | 187 | 1 |
238604 | 238604 | 2020-06-14 | Gallatin | Montana | 30031 | 188 | 1 |
241714 | 241714 | 2020-06-15 | Gallatin | Montana | 30031 | 188 | 1 |
244825 | 244825 | 2020-06-16 | Gallatin | Montana | 30031 | 188 | 1 |
247938 | 247938 | 2020-06-17 | Gallatin | Montana | 30031 | 191 | 1 |
251052 | 251052 | 2020-06-18 | Gallatin | Montana | 30031 | 195 | 1 |
254167 | 254167 | 2020-06-19 | Gallatin | Montana | 30031 | 197 | 1 |
257290 | 257290 | 2020-06-20 | Gallatin | Montana | 30031 | 204 | 1 |
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);