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 rowid
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 |
---|---|---|---|---|---|---|---|
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 |
33703 | 33703 | 2020-04-05 | Gallatin | Illinois | 17059 | 1 | 0 |
34465 | 34465 | 2020-04-05 | Gallatin | Montana | 30031 | 115 | 0 |
36154 | 36154 | 2020-04-06 | Gallatin | Illinois | 17059 | 1 | 0 |
36932 | 36932 | 2020-04-06 | Gallatin | Montana | 30031 | 118 | 0 |
38649 | 38649 | 2020-04-07 | Gallatin | Illinois | 17059 | 1 | 0 |
39448 | 39448 | 2020-04-07 | Gallatin | Montana | 30031 | 118 | 0 |
41193 | 41193 | 2020-04-08 | Gallatin | Illinois | 17059 | 1 | 0 |
42003 | 42003 | 2020-04-08 | Gallatin | Montana | 30031 | 119 | 0 |
43767 | 43767 | 2020-04-09 | Gallatin | Illinois | 17059 | 1 | 0 |
44582 | 44582 | 2020-04-09 | Gallatin | Montana | 30031 | 128 | 0 |
46370 | 46370 | 2020-04-10 | Gallatin | Illinois | 17059 | 1 | 0 |
47192 | 47192 | 2020-04-10 | Gallatin | Montana | 30031 | 134 | 0 |
49001 | 49001 | 2020-04-11 | Gallatin | Illinois | 17059 | 1 | 0 |
49328 | 49328 | 2020-04-11 | Gallatin | Kentucky | 21077 | 1 | 0 |
49840 | 49840 | 2020-04-11 | Gallatin | Montana | 30031 | 135 | 0 |
51663 | 51663 | 2020-04-12 | Gallatin | Illinois | 17059 | 1 | 0 |
51994 | 51994 | 2020-04-12 | Gallatin | Kentucky | 21077 | 1 | 0 |
52513 | 52513 | 2020-04-12 | Gallatin | Montana | 30031 | 138 | 0 |
54343 | 54343 | 2020-04-13 | Gallatin | Illinois | 17059 | 1 | 0 |
54675 | 54675 | 2020-04-13 | Gallatin | Kentucky | 21077 | 1 | 0 |
55194 | 55194 | 2020-04-13 | Gallatin | Montana | 30031 | 138 | 0 |
57036 | 57036 | 2020-04-14 | Gallatin | Illinois | 17059 | 2 | 0 |
57371 | 57371 | 2020-04-14 | Gallatin | Kentucky | 21077 | 1 | 0 |
57893 | 57893 | 2020-04-14 | Gallatin | Montana | 30031 | 138 | 0 |
59743 | 59743 | 2020-04-15 | Gallatin | Illinois | 17059 | 2 | 0 |
60080 | 60080 | 2020-04-15 | Gallatin | Kentucky | 21077 | 1 | 0 |
60606 | 60606 | 2020-04-15 | Gallatin | Montana | 30031 | 139 | 0 |
62464 | 62464 | 2020-04-16 | Gallatin | Illinois | 17059 | 2 | 0 |
62800 | 62800 | 2020-04-16 | Gallatin | Kentucky | 21077 | 1 | 0 |
63329 | 63329 | 2020-04-16 | Gallatin | Montana | 30031 | 141 | 0 |
65196 | 65196 | 2020-04-17 | Gallatin | Illinois | 17059 | 2 | 0 |
65539 | 65539 | 2020-04-17 | Gallatin | Kentucky | 21077 | 1 | 0 |
66069 | 66069 | 2020-04-17 | Gallatin | Montana | 30031 | 142 | 0 |
67944 | 67944 | 2020-04-18 | Gallatin | Illinois | 17059 | 2 | 0 |
68288 | 68288 | 2020-04-18 | Gallatin | Kentucky | 21077 | 1 | 0 |
68823 | 68823 | 2020-04-18 | Gallatin | Montana | 30031 | 142 | 0 |
70706 | 70706 | 2020-04-19 | Gallatin | Illinois | 17059 | 2 | 0 |
71051 | 71051 | 2020-04-19 | Gallatin | Kentucky | 21077 | 1 | 0 |
71590 | 71590 | 2020-04-19 | Gallatin | Montana | 30031 | 143 | 0 |
73476 | 73476 | 2020-04-20 | Gallatin | Illinois | 17059 | 2 | 0 |
73823 | 73823 | 2020-04-20 | Gallatin | Kentucky | 21077 | 1 | 0 |
74363 | 74363 | 2020-04-20 | Gallatin | Montana | 30031 | 143 | 0 |
76252 | 76252 | 2020-04-21 | Gallatin | Illinois | 17059 | 2 | 0 |
76603 | 76603 | 2020-04-21 | Gallatin | Kentucky | 21077 | 1 | 0 |
77143 | 77143 | 2020-04-21 | Gallatin | Montana | 30031 | 145 | 0 |
79036 | 79036 | 2020-04-22 | Gallatin | Illinois | 17059 | 2 | 0 |
79388 | 79388 | 2020-04-22 | Gallatin | Kentucky | 21077 | 1 | 0 |
79931 | 79931 | 2020-04-22 | Gallatin | Montana | 30031 | 145 | 0 |
81829 | 81829 | 2020-04-23 | Gallatin | Illinois | 17059 | 2 | 0 |
82185 | 82185 | 2020-04-23 | Gallatin | Kentucky | 21077 | 1 | 0 |
82727 | 82727 | 2020-04-23 | Gallatin | Montana | 30031 | 146 | 0 |
84629 | 84629 | 2020-04-24 | Gallatin | Illinois | 17059 | 2 | 0 |
84988 | 84988 | 2020-04-24 | Gallatin | Kentucky | 21077 | 1 | 0 |
85531 | 85531 | 2020-04-24 | Gallatin | Montana | 30031 | 146 | 0 |
87439 | 87439 | 2020-04-25 | Gallatin | Illinois | 17059 | 2 | 0 |
87797 | 87797 | 2020-04-25 | Gallatin | Kentucky | 21077 | 1 | 0 |
88341 | 88341 | 2020-04-25 | Gallatin | Montana | 30031 | 146 | 0 |
90255 | 90255 | 2020-04-26 | Gallatin | Illinois | 17059 | 2 | 0 |
90613 | 90613 | 2020-04-26 | Gallatin | Kentucky | 21077 | 1 | 0 |
91156 | 91156 | 2020-04-26 | Gallatin | Montana | 30031 | 146 | 0 |
93074 | 93074 | 2020-04-27 | Gallatin | Illinois | 17059 | 2 | 0 |
93434 | 93434 | 2020-04-27 | Gallatin | Kentucky | 21077 | 1 | 0 |
93977 | 93977 | 2020-04-27 | Gallatin | Montana | 30031 | 146 | 0 |
95906 | 95906 | 2020-04-28 | Gallatin | Illinois | 17059 | 2 | 0 |
96267 | 96267 | 2020-04-28 | Gallatin | Kentucky | 21077 | 1 | 0 |
96813 | 96813 | 2020-04-28 | Gallatin | Montana | 30031 | 146 | 1 |
98750 | 98750 | 2020-04-29 | Gallatin | Illinois | 17059 | 2 | 0 |
99113 | 99113 | 2020-04-29 | Gallatin | Kentucky | 21077 | 1 | 0 |
99659 | 99659 | 2020-04-29 | Gallatin | Montana | 30031 | 146 | 1 |
101601 | 101601 | 2020-04-30 | Gallatin | Illinois | 17059 | 2 | 0 |
101965 | 101965 | 2020-04-30 | Gallatin | Kentucky | 21077 | 1 | 0 |
102511 | 102511 | 2020-04-30 | Gallatin | Montana | 30031 | 146 | 1 |
104457 | 104457 | 2020-05-01 | Gallatin | Illinois | 17059 | 2 | 0 |
104826 | 104826 | 2020-05-01 | Gallatin | Kentucky | 21077 | 1 | 0 |
105372 | 105372 | 2020-05-01 | Gallatin | Montana | 30031 | 146 | 1 |
107322 | 107322 | 2020-05-02 | Gallatin | Illinois | 17059 | 2 | 0 |
107691 | 107691 | 2020-05-02 | Gallatin | Kentucky | 21077 | 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);