ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Glacier" and state = "Montana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
29656 | 29656 | 2020-04-03 | Glacier | Montana | 30035 | 1 | 0 |
32038 | 32038 | 2020-04-04 | Glacier | Montana | 30035 | 1 | 0 |
34466 | 34466 | 2020-04-05 | Glacier | Montana | 30035 | 1 | 0 |
36933 | 36933 | 2020-04-06 | Glacier | Montana | 30035 | 1 | 0 |
39449 | 39449 | 2020-04-07 | Glacier | Montana | 30035 | 1 | 0 |
42004 | 42004 | 2020-04-08 | Glacier | Montana | 30035 | 2 | 0 |
44583 | 44583 | 2020-04-09 | Glacier | Montana | 30035 | 3 | 0 |
47193 | 47193 | 2020-04-10 | Glacier | Montana | 30035 | 3 | 0 |
49841 | 49841 | 2020-04-11 | Glacier | Montana | 30035 | 3 | 0 |
52514 | 52514 | 2020-04-12 | Glacier | Montana | 30035 | 3 | 0 |
55195 | 55195 | 2020-04-13 | Glacier | Montana | 30035 | 4 | 0 |
57894 | 57894 | 2020-04-14 | Glacier | Montana | 30035 | 4 | 0 |
60607 | 60607 | 2020-04-15 | Glacier | Montana | 30035 | 4 | 0 |
63330 | 63330 | 2020-04-16 | Glacier | Montana | 30035 | 4 | 0 |
66070 | 66070 | 2020-04-17 | Glacier | Montana | 30035 | 4 | 0 |
68824 | 68824 | 2020-04-18 | Glacier | Montana | 30035 | 4 | 0 |
71591 | 71591 | 2020-04-19 | Glacier | Montana | 30035 | 4 | 0 |
74364 | 74364 | 2020-04-20 | Glacier | Montana | 30035 | 4 | 0 |
77144 | 77144 | 2020-04-21 | Glacier | Montana | 30035 | 4 | 0 |
79932 | 79932 | 2020-04-22 | Glacier | Montana | 30035 | 4 | 0 |
82728 | 82728 | 2020-04-23 | Glacier | Montana | 30035 | 4 | 0 |
85532 | 85532 | 2020-04-24 | Glacier | Montana | 30035 | 4 | 0 |
88342 | 88342 | 2020-04-25 | Glacier | Montana | 30035 | 4 | 0 |
91157 | 91157 | 2020-04-26 | Glacier | Montana | 30035 | 6 | 0 |
93978 | 93978 | 2020-04-27 | Glacier | Montana | 30035 | 6 | 0 |
96814 | 96814 | 2020-04-28 | Glacier | Montana | 30035 | 6 | 0 |
99660 | 99660 | 2020-04-29 | Glacier | Montana | 30035 | 6 | 0 |
102512 | 102512 | 2020-04-30 | Glacier | Montana | 30035 | 6 | 0 |
105373 | 105373 | 2020-05-01 | Glacier | Montana | 30035 | 6 | 0 |
108239 | 108239 | 2020-05-02 | Glacier | Montana | 30035 | 6 | 0 |
111111 | 111111 | 2020-05-03 | Glacier | Montana | 30035 | 6 | 0 |
113990 | 113990 | 2020-05-04 | Glacier | Montana | 30035 | 6 | 0 |
116872 | 116872 | 2020-05-05 | Glacier | Montana | 30035 | 6 | 0 |
119832 | 119832 | 2020-05-06 | Glacier | Montana | 30035 | 6 | 0 |
122806 | 122806 | 2020-05-07 | Glacier | Montana | 30035 | 6 | 0 |
125788 | 125788 | 2020-05-08 | Glacier | Montana | 30035 | 6 | 0 |
128776 | 128776 | 2020-05-09 | Glacier | Montana | 30035 | 6 | 0 |
131766 | 131766 | 2020-05-10 | Glacier | Montana | 30035 | 6 | 0 |
134757 | 134757 | 2020-05-11 | Glacier | Montana | 30035 | 6 | 0 |
137747 | 137747 | 2020-05-12 | Glacier | Montana | 30035 | 6 | 0 |
140741 | 140741 | 2020-05-13 | Glacier | Montana | 30035 | 6 | 0 |
143736 | 143736 | 2020-05-14 | Glacier | Montana | 30035 | 6 | 0 |
146737 | 146737 | 2020-05-15 | Glacier | Montana | 30035 | 6 | 0 |
149743 | 149743 | 2020-05-16 | Glacier | Montana | 30035 | 6 | 0 |
152754 | 152754 | 2020-05-17 | Glacier | Montana | 30035 | 6 | 0 |
155768 | 155768 | 2020-05-18 | Glacier | Montana | 30035 | 6 | 0 |
158786 | 158786 | 2020-05-19 | Glacier | Montana | 30035 | 6 | 0 |
161812 | 161812 | 2020-05-20 | Glacier | Montana | 30035 | 6 | 0 |
164841 | 164841 | 2020-05-21 | Glacier | Montana | 30035 | 6 | 0 |
167877 | 167877 | 2020-05-22 | Glacier | Montana | 30035 | 6 | 0 |
170916 | 170916 | 2020-05-23 | Glacier | Montana | 30035 | 6 | 0 |
173958 | 173958 | 2020-05-24 | Glacier | Montana | 30035 | 6 | 0 |
177001 | 177001 | 2020-05-25 | Glacier | Montana | 30035 | 6 | 0 |
180045 | 180045 | 2020-05-26 | Glacier | Montana | 30035 | 6 | 0 |
183093 | 183093 | 2020-05-27 | Glacier | Montana | 30035 | 6 | 0 |
186149 | 186149 | 2020-05-28 | Glacier | Montana | 30035 | 6 | 0 |
189208 | 189208 | 2020-05-29 | Glacier | Montana | 30035 | 6 | 0 |
192272 | 192272 | 2020-05-30 | Glacier | Montana | 30035 | 6 | 0 |
195342 | 195342 | 2020-05-31 | Glacier | Montana | 30035 | 6 | 0 |
198413 | 198413 | 2020-06-01 | Glacier | Montana | 30035 | 6 | 0 |
201486 | 201486 | 2020-06-02 | Glacier | Montana | 30035 | 6 | 0 |
204563 | 204563 | 2020-06-03 | Glacier | Montana | 30035 | 6 | 0 |
207644 | 207644 | 2020-06-04 | Glacier | Montana | 30035 | 6 | 0 |
210725 | 210725 | 2020-06-05 | Glacier | Montana | 30035 | 6 | 0 |
213809 | 213809 | 2020-06-06 | Glacier | Montana | 30035 | 6 | 0 |
216898 | 216898 | 2020-06-07 | Glacier | Montana | 30035 | 6 | 0 |
219990 | 219990 | 2020-06-08 | Glacier | Montana | 30035 | 6 | 0 |
223085 | 223085 | 2020-06-09 | Glacier | Montana | 30035 | 6 | 0 |
226184 | 226184 | 2020-06-10 | Glacier | Montana | 30035 | 6 | 0 |
229287 | 229287 | 2020-06-11 | Glacier | Montana | 30035 | 6 | 0 |
232392 | 232392 | 2020-06-12 | Glacier | Montana | 30035 | 6 | 0 |
235498 | 235498 | 2020-06-13 | Glacier | Montana | 30035 | 6 | 0 |
238605 | 238605 | 2020-06-14 | Glacier | Montana | 30035 | 6 | 0 |
241715 | 241715 | 2020-06-15 | Glacier | Montana | 30035 | 6 | 0 |
244826 | 244826 | 2020-06-16 | Glacier | Montana | 30035 | 6 | 0 |
247939 | 247939 | 2020-06-17 | Glacier | Montana | 30035 | 6 | 0 |
251053 | 251053 | 2020-06-18 | Glacier | Montana | 30035 | 6 | 0 |
254168 | 254168 | 2020-06-19 | Glacier | Montana | 30035 | 6 | 0 |
257291 | 257291 | 2020-06-20 | Glacier | Montana | 30035 | 7 | 0 |
260417 | 260417 | 2020-06-21 | Glacier | Montana | 30035 | 7 | 0 |
263546 | 263546 | 2020-06-22 | Glacier | Montana | 30035 | 7 | 0 |
266672 | 266672 | 2020-06-23 | Glacier | Montana | 30035 | 7 | 0 |
269805 | 269805 | 2020-06-24 | Glacier | Montana | 30035 | 7 | 0 |
272943 | 272943 | 2020-06-25 | Glacier | Montana | 30035 | 7 | 0 |
276086 | 276086 | 2020-06-26 | Glacier | Montana | 30035 | 7 | 0 |
279234 | 279234 | 2020-06-27 | Glacier | Montana | 30035 | 8 | 0 |
282382 | 282382 | 2020-06-28 | Glacier | Montana | 30035 | 9 | 0 |
285527 | 285527 | 2020-06-29 | Glacier | Montana | 30035 | 18 | 0 |
288677 | 288677 | 2020-06-30 | Glacier | Montana | 30035 | 18 | 0 |
291828 | 291828 | 2020-07-01 | Glacier | Montana | 30035 | 18 | 0 |
294982 | 294982 | 2020-07-02 | Glacier | Montana | 30035 | 22 | 0 |
298140 | 298140 | 2020-07-03 | Glacier | Montana | 30035 | 22 | 0 |
301303 | 301303 | 2020-07-04 | Glacier | Montana | 30035 | 22 | 0 |
304467 | 304467 | 2020-07-05 | Glacier | Montana | 30035 | 25 | 0 |
307634 | 307634 | 2020-07-06 | Glacier | Montana | 30035 | 25 | 0 |
310802 | 310802 | 2020-07-07 | Glacier | Montana | 30035 | 25 | 0 |
313973 | 313973 | 2020-07-08 | Glacier | Montana | 30035 | 25 | 0 |
317147 | 317147 | 2020-07-09 | Glacier | Montana | 30035 | 25 | 0 |
320322 | 320322 | 2020-07-10 | Glacier | Montana | 30035 | 27 | 0 |
323501 | 323501 | 2020-07-11 | Glacier | Montana | 30035 | 28 | 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);