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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Gallatin · 2,324 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
33703 | 33703 | 2020-04-05 | Gallatin | Illinois | 17059 | 1 | 0 |
36154 | 36154 | 2020-04-06 | Gallatin | Illinois | 17059 | 1 | 0 |
38649 | 38649 | 2020-04-07 | Gallatin | Illinois | 17059 | 1 | 0 |
41193 | 41193 | 2020-04-08 | Gallatin | Illinois | 17059 | 1 | 0 |
43767 | 43767 | 2020-04-09 | Gallatin | Illinois | 17059 | 1 | 0 |
46370 | 46370 | 2020-04-10 | Gallatin | Illinois | 17059 | 1 | 0 |
49001 | 49001 | 2020-04-11 | Gallatin | Illinois | 17059 | 1 | 0 |
51663 | 51663 | 2020-04-12 | Gallatin | Illinois | 17059 | 1 | 0 |
54343 | 54343 | 2020-04-13 | Gallatin | Illinois | 17059 | 1 | 0 |
57036 | 57036 | 2020-04-14 | Gallatin | Illinois | 17059 | 2 | 0 |
59743 | 59743 | 2020-04-15 | Gallatin | Illinois | 17059 | 2 | 0 |
62464 | 62464 | 2020-04-16 | Gallatin | Illinois | 17059 | 2 | 0 |
65196 | 65196 | 2020-04-17 | Gallatin | Illinois | 17059 | 2 | 0 |
67944 | 67944 | 2020-04-18 | Gallatin | Illinois | 17059 | 2 | 0 |
70706 | 70706 | 2020-04-19 | Gallatin | Illinois | 17059 | 2 | 0 |
73476 | 73476 | 2020-04-20 | Gallatin | Illinois | 17059 | 2 | 0 |
76252 | 76252 | 2020-04-21 | Gallatin | Illinois | 17059 | 2 | 0 |
79036 | 79036 | 2020-04-22 | Gallatin | Illinois | 17059 | 2 | 0 |
81829 | 81829 | 2020-04-23 | Gallatin | Illinois | 17059 | 2 | 0 |
84629 | 84629 | 2020-04-24 | Gallatin | Illinois | 17059 | 2 | 0 |
87439 | 87439 | 2020-04-25 | Gallatin | Illinois | 17059 | 2 | 0 |
90255 | 90255 | 2020-04-26 | Gallatin | Illinois | 17059 | 2 | 0 |
93074 | 93074 | 2020-04-27 | Gallatin | Illinois | 17059 | 2 | 0 |
95906 | 95906 | 2020-04-28 | Gallatin | Illinois | 17059 | 2 | 0 |
98750 | 98750 | 2020-04-29 | Gallatin | Illinois | 17059 | 2 | 0 |
101601 | 101601 | 2020-04-30 | Gallatin | Illinois | 17059 | 2 | 0 |
104457 | 104457 | 2020-05-01 | Gallatin | Illinois | 17059 | 2 | 0 |
107322 | 107322 | 2020-05-02 | Gallatin | Illinois | 17059 | 2 | 0 |
110192 | 110192 | 2020-05-03 | Gallatin | Illinois | 17059 | 2 | 0 |
113067 | 113067 | 2020-05-04 | Gallatin | Illinois | 17059 | 2 | 0 |
115950 | 115950 | 2020-05-05 | Gallatin | Illinois | 17059 | 2 | 0 |
118910 | 118910 | 2020-05-06 | Gallatin | Illinois | 17059 | 2 | 0 |
121880 | 121880 | 2020-05-07 | Gallatin | Illinois | 17059 | 2 | 0 |
124859 | 124859 | 2020-05-08 | Gallatin | Illinois | 17059 | 2 | 0 |
127846 | 127846 | 2020-05-09 | Gallatin | Illinois | 17059 | 2 | 0 |
130837 | 130837 | 2020-05-10 | Gallatin | Illinois | 17059 | 2 | 0 |
133828 | 133828 | 2020-05-11 | Gallatin | Illinois | 17059 | 2 | 0 |
136817 | 136817 | 2020-05-12 | Gallatin | Illinois | 17059 | 2 | 0 |
139809 | 139809 | 2020-05-13 | Gallatin | Illinois | 17059 | 2 | 0 |
142805 | 142805 | 2020-05-14 | Gallatin | Illinois | 17059 | 2 | 0 |
145805 | 145805 | 2020-05-15 | Gallatin | Illinois | 17059 | 2 | 0 |
148808 | 148808 | 2020-05-16 | Gallatin | Illinois | 17059 | 2 | 0 |
151817 | 151817 | 2020-05-17 | Gallatin | Illinois | 17059 | 2 | 0 |
154829 | 154829 | 2020-05-18 | Gallatin | Illinois | 17059 | 2 | 0 |
157845 | 157845 | 2020-05-19 | Gallatin | Illinois | 17059 | 2 | 0 |
160871 | 160871 | 2020-05-20 | Gallatin | Illinois | 17059 | 2 | 0 |
163899 | 163899 | 2020-05-21 | Gallatin | Illinois | 17059 | 2 | 0 |
166932 | 166932 | 2020-05-22 | Gallatin | Illinois | 17059 | 2 | 0 |
169969 | 169969 | 2020-05-23 | Gallatin | Illinois | 17059 | 2 | 0 |
173010 | 173010 | 2020-05-24 | Gallatin | Illinois | 17059 | 2 | 0 |
176054 | 176054 | 2020-05-25 | Gallatin | Illinois | 17059 | 2 | 0 |
179098 | 179098 | 2020-05-26 | Gallatin | Illinois | 17059 | 2 | 0 |
182142 | 182142 | 2020-05-27 | Gallatin | Illinois | 17059 | 2 | 0 |
185196 | 185196 | 2020-05-28 | Gallatin | Illinois | 17059 | 2 | 0 |
188254 | 188254 | 2020-05-29 | Gallatin | Illinois | 17059 | 2 | 0 |
191319 | 191319 | 2020-05-30 | Gallatin | Illinois | 17059 | 2 | 0 |
194386 | 194386 | 2020-05-31 | Gallatin | Illinois | 17059 | 2 | 0 |
197456 | 197456 | 2020-06-01 | Gallatin | Illinois | 17059 | 2 | 0 |
200529 | 200529 | 2020-06-02 | Gallatin | Illinois | 17059 | 2 | 0 |
203605 | 203605 | 2020-06-03 | Gallatin | Illinois | 17059 | 2 | 0 |
206685 | 206685 | 2020-06-04 | Gallatin | Illinois | 17059 | 2 | 0 |
209766 | 209766 | 2020-06-05 | Gallatin | Illinois | 17059 | 2 | 0 |
212851 | 212851 | 2020-06-06 | Gallatin | Illinois | 17059 | 2 | 0 |
215938 | 215938 | 2020-06-07 | Gallatin | Illinois | 17059 | 2 | 0 |
219029 | 219029 | 2020-06-08 | Gallatin | Illinois | 17059 | 2 | 0 |
222124 | 222124 | 2020-06-09 | Gallatin | Illinois | 17059 | 2 | 0 |
225219 | 225219 | 2020-06-10 | Gallatin | Illinois | 17059 | 2 | 0 |
228321 | 228321 | 2020-06-11 | Gallatin | Illinois | 17059 | 2 | 0 |
231424 | 231424 | 2020-06-12 | Gallatin | Illinois | 17059 | 2 | 0 |
234530 | 234530 | 2020-06-13 | Gallatin | Illinois | 17059 | 2 | 0 |
237637 | 237637 | 2020-06-14 | Gallatin | Illinois | 17059 | 2 | 0 |
240745 | 240745 | 2020-06-15 | Gallatin | Illinois | 17059 | 2 | 0 |
243856 | 243856 | 2020-06-16 | Gallatin | Illinois | 17059 | 2 | 0 |
246969 | 246969 | 2020-06-17 | Gallatin | Illinois | 17059 | 2 | 0 |
250081 | 250081 | 2020-06-18 | Gallatin | Illinois | 17059 | 2 | 0 |
253196 | 253196 | 2020-06-19 | Gallatin | Illinois | 17059 | 2 | 0 |
256316 | 256316 | 2020-06-20 | Gallatin | Illinois | 17059 | 2 | 0 |
259442 | 259442 | 2020-06-21 | Gallatin | Illinois | 17059 | 2 | 0 |
262569 | 262569 | 2020-06-22 | Gallatin | Illinois | 17059 | 2 | 0 |
265697 | 265697 | 2020-06-23 | Gallatin | Illinois | 17059 | 2 | 0 |
268827 | 268827 | 2020-06-24 | Gallatin | Illinois | 17059 | 2 | 0 |
271964 | 271964 | 2020-06-25 | Gallatin | Illinois | 17059 | 2 | 0 |
275106 | 275106 | 2020-06-26 | Gallatin | Illinois | 17059 | 2 | 0 |
278254 | 278254 | 2020-06-27 | Gallatin | Illinois | 17059 | 2 | 0 |
281402 | 281402 | 2020-06-28 | Gallatin | Illinois | 17059 | 2 | 0 |
284547 | 284547 | 2020-06-29 | Gallatin | Illinois | 17059 | 2 | 0 |
287696 | 287696 | 2020-06-30 | Gallatin | Illinois | 17059 | 2 | 0 |
290846 | 290846 | 2020-07-01 | Gallatin | Illinois | 17059 | 2 | 0 |
294000 | 294000 | 2020-07-02 | Gallatin | Illinois | 17059 | 2 | 0 |
297157 | 297157 | 2020-07-03 | Gallatin | Illinois | 17059 | 2 | 0 |
300319 | 300319 | 2020-07-04 | Gallatin | Illinois | 17059 | 2 | 0 |
303483 | 303483 | 2020-07-05 | Gallatin | Illinois | 17059 | 2 | 0 |
306648 | 306648 | 2020-07-06 | Gallatin | Illinois | 17059 | 3 | 0 |
309816 | 309816 | 2020-07-07 | Gallatin | Illinois | 17059 | 4 | 0 |
312986 | 312986 | 2020-07-08 | Gallatin | Illinois | 17059 | 4 | 0 |
316160 | 316160 | 2020-07-09 | Gallatin | Illinois | 17059 | 4 | 0 |
319333 | 319333 | 2020-07-10 | Gallatin | Illinois | 17059 | 5 | 0 |
322512 | 322512 | 2020-07-11 | Gallatin | Illinois | 17059 | 6 | 0 |
325693 | 325693 | 2020-07-12 | Gallatin | Illinois | 17059 | 6 | 0 |
328879 | 328879 | 2020-07-13 | Gallatin | Illinois | 17059 | 7 | 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);