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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Gallatin · 2,224 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
108238 | 108238 | 2020-05-02 | Gallatin | Montana | 30031 | 146 | 1 |
110192 | 110192 | 2020-05-03 | Gallatin | Illinois | 17059 | 2 | 0 |
110562 | 110562 | 2020-05-03 | Gallatin | Kentucky | 21077 | 1 | 0 |
111110 | 111110 | 2020-05-03 | Gallatin | Montana | 30031 | 146 | 1 |
113067 | 113067 | 2020-05-04 | Gallatin | Illinois | 17059 | 2 | 0 |
113439 | 113439 | 2020-05-04 | Gallatin | Kentucky | 21077 | 1 | 0 |
113989 | 113989 | 2020-05-04 | Gallatin | Montana | 30031 | 146 | 1 |
115950 | 115950 | 2020-05-05 | Gallatin | Illinois | 17059 | 2 | 0 |
116321 | 116321 | 2020-05-05 | Gallatin | Kentucky | 21077 | 1 | 0 |
116871 | 116871 | 2020-05-05 | Gallatin | Montana | 30031 | 146 | 1 |
118910 | 118910 | 2020-05-06 | Gallatin | Illinois | 17059 | 2 | 0 |
119282 | 119282 | 2020-05-06 | Gallatin | Kentucky | 21077 | 1 | 0 |
119831 | 119831 | 2020-05-06 | Gallatin | Montana | 30031 | 146 | 1 |
121880 | 121880 | 2020-05-07 | Gallatin | Illinois | 17059 | 2 | 0 |
122252 | 122252 | 2020-05-07 | Gallatin | Kentucky | 21077 | 1 | 0 |
122805 | 122805 | 2020-05-07 | Gallatin | Montana | 30031 | 146 | 1 |
124859 | 124859 | 2020-05-08 | Gallatin | Illinois | 17059 | 2 | 0 |
125234 | 125234 | 2020-05-08 | Gallatin | Kentucky | 21077 | 1 | 0 |
125787 | 125787 | 2020-05-08 | Gallatin | Montana | 30031 | 148 | 1 |
127846 | 127846 | 2020-05-09 | Gallatin | Illinois | 17059 | 2 | 0 |
128222 | 128222 | 2020-05-09 | Gallatin | Kentucky | 21077 | 1 | 0 |
128775 | 128775 | 2020-05-09 | Gallatin | Montana | 30031 | 149 | 1 |
130837 | 130837 | 2020-05-10 | Gallatin | Illinois | 17059 | 2 | 0 |
131212 | 131212 | 2020-05-10 | Gallatin | Kentucky | 21077 | 1 | 0 |
131765 | 131765 | 2020-05-10 | Gallatin | Montana | 30031 | 149 | 1 |
133828 | 133828 | 2020-05-11 | Gallatin | Illinois | 17059 | 2 | 0 |
134203 | 134203 | 2020-05-11 | Gallatin | Kentucky | 21077 | 1 | 0 |
134756 | 134756 | 2020-05-11 | Gallatin | Montana | 30031 | 149 | 1 |
136817 | 136817 | 2020-05-12 | Gallatin | Illinois | 17059 | 2 | 0 |
137193 | 137193 | 2020-05-12 | Gallatin | Kentucky | 21077 | 1 | 0 |
137746 | 137746 | 2020-05-12 | Gallatin | Montana | 30031 | 149 | 1 |
139809 | 139809 | 2020-05-13 | Gallatin | Illinois | 17059 | 2 | 0 |
140186 | 140186 | 2020-05-13 | Gallatin | Kentucky | 21077 | 1 | 0 |
140740 | 140740 | 2020-05-13 | Gallatin | Montana | 30031 | 149 | 1 |
142805 | 142805 | 2020-05-14 | Gallatin | Illinois | 17059 | 2 | 0 |
143182 | 143182 | 2020-05-14 | Gallatin | Kentucky | 21077 | 2 | 0 |
143735 | 143735 | 2020-05-14 | Gallatin | Montana | 30031 | 149 | 1 |
145805 | 145805 | 2020-05-15 | Gallatin | Illinois | 17059 | 2 | 0 |
146182 | 146182 | 2020-05-15 | Gallatin | Kentucky | 21077 | 2 | 0 |
146736 | 146736 | 2020-05-15 | Gallatin | Montana | 30031 | 149 | 1 |
148808 | 148808 | 2020-05-16 | Gallatin | Illinois | 17059 | 2 | 0 |
149186 | 149186 | 2020-05-16 | Gallatin | Kentucky | 21077 | 2 | 0 |
149742 | 149742 | 2020-05-16 | Gallatin | Montana | 30031 | 149 | 1 |
151817 | 151817 | 2020-05-17 | Gallatin | Illinois | 17059 | 2 | 0 |
152197 | 152197 | 2020-05-17 | Gallatin | Kentucky | 21077 | 2 | 0 |
152753 | 152753 | 2020-05-17 | Gallatin | Montana | 30031 | 149 | 1 |
154829 | 154829 | 2020-05-18 | Gallatin | Illinois | 17059 | 2 | 0 |
155211 | 155211 | 2020-05-18 | Gallatin | Kentucky | 21077 | 3 | 0 |
155767 | 155767 | 2020-05-18 | Gallatin | Montana | 30031 | 149 | 1 |
157845 | 157845 | 2020-05-19 | Gallatin | Illinois | 17059 | 2 | 0 |
158228 | 158228 | 2020-05-19 | Gallatin | Kentucky | 21077 | 3 | 0 |
158785 | 158785 | 2020-05-19 | Gallatin | Montana | 30031 | 149 | 1 |
160871 | 160871 | 2020-05-20 | Gallatin | Illinois | 17059 | 2 | 0 |
161254 | 161254 | 2020-05-20 | Gallatin | Kentucky | 21077 | 3 | 0 |
161811 | 161811 | 2020-05-20 | Gallatin | Montana | 30031 | 149 | 1 |
163899 | 163899 | 2020-05-21 | Gallatin | Illinois | 17059 | 2 | 0 |
164283 | 164283 | 2020-05-21 | Gallatin | Kentucky | 21077 | 3 | 0 |
164840 | 164840 | 2020-05-21 | Gallatin | Montana | 30031 | 149 | 1 |
166932 | 166932 | 2020-05-22 | Gallatin | Illinois | 17059 | 2 | 0 |
167319 | 167319 | 2020-05-22 | Gallatin | Kentucky | 21077 | 5 | 0 |
167876 | 167876 | 2020-05-22 | Gallatin | Montana | 30031 | 149 | 1 |
169969 | 169969 | 2020-05-23 | Gallatin | Illinois | 17059 | 2 | 0 |
170357 | 170357 | 2020-05-23 | Gallatin | Kentucky | 21077 | 8 | 0 |
170915 | 170915 | 2020-05-23 | Gallatin | Montana | 30031 | 149 | 1 |
173010 | 173010 | 2020-05-24 | Gallatin | Illinois | 17059 | 2 | 0 |
173398 | 173398 | 2020-05-24 | Gallatin | Kentucky | 21077 | 8 | 0 |
173957 | 173957 | 2020-05-24 | Gallatin | Montana | 30031 | 149 | 1 |
176054 | 176054 | 2020-05-25 | Gallatin | Illinois | 17059 | 2 | 0 |
176442 | 176442 | 2020-05-25 | Gallatin | Kentucky | 21077 | 8 | 0 |
177000 | 177000 | 2020-05-25 | Gallatin | Montana | 30031 | 149 | 1 |
179098 | 179098 | 2020-05-26 | Gallatin | Illinois | 17059 | 2 | 0 |
179486 | 179486 | 2020-05-26 | Gallatin | Kentucky | 21077 | 8 | 0 |
180044 | 180044 | 2020-05-26 | Gallatin | Montana | 30031 | 149 | 1 |
182142 | 182142 | 2020-05-27 | Gallatin | Illinois | 17059 | 2 | 0 |
182531 | 182531 | 2020-05-27 | Gallatin | Kentucky | 21077 | 12 | 0 |
183092 | 183092 | 2020-05-27 | Gallatin | Montana | 30031 | 149 | 1 |
185196 | 185196 | 2020-05-28 | Gallatin | Illinois | 17059 | 2 | 0 |
185585 | 185585 | 2020-05-28 | Gallatin | Kentucky | 21077 | 15 | 0 |
186148 | 186148 | 2020-05-28 | Gallatin | Montana | 30031 | 149 | 1 |
188254 | 188254 | 2020-05-29 | Gallatin | Illinois | 17059 | 2 | 0 |
188643 | 188643 | 2020-05-29 | Gallatin | Kentucky | 21077 | 33 | 2 |
189207 | 189207 | 2020-05-29 | Gallatin | Montana | 30031 | 150 | 1 |
191319 | 191319 | 2020-05-30 | Gallatin | Illinois | 17059 | 2 | 0 |
191707 | 191707 | 2020-05-30 | Gallatin | Kentucky | 21077 | 36 | 3 |
192271 | 192271 | 2020-05-30 | Gallatin | Montana | 30031 | 151 | 1 |
194386 | 194386 | 2020-05-31 | Gallatin | Illinois | 17059 | 2 | 0 |
194775 | 194775 | 2020-05-31 | Gallatin | Kentucky | 21077 | 36 | 3 |
195341 | 195341 | 2020-05-31 | Gallatin | Montana | 30031 | 151 | 1 |
197456 | 197456 | 2020-06-01 | Gallatin | Illinois | 17059 | 2 | 0 |
197846 | 197846 | 2020-06-01 | Gallatin | Kentucky | 21077 | 37 | 4 |
198412 | 198412 | 2020-06-01 | Gallatin | Montana | 30031 | 153 | 1 |
200529 | 200529 | 2020-06-02 | Gallatin | Illinois | 17059 | 2 | 0 |
200918 | 200918 | 2020-06-02 | Gallatin | Kentucky | 21077 | 43 | 4 |
201485 | 201485 | 2020-06-02 | Gallatin | Montana | 30031 | 155 | 1 |
203605 | 203605 | 2020-06-03 | Gallatin | Illinois | 17059 | 2 | 0 |
203995 | 203995 | 2020-06-03 | Gallatin | Kentucky | 21077 | 46 | 5 |
204562 | 204562 | 2020-06-03 | Gallatin | Montana | 30031 | 155 | 1 |
206685 | 206685 | 2020-06-04 | Gallatin | Illinois | 17059 | 2 | 0 |
207076 | 207076 | 2020-06-04 | Gallatin | Kentucky | 21077 | 46 | 5 |
207643 | 207643 | 2020-06-04 | Gallatin | Montana | 30031 | 161 | 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);