ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 37 and county = "Flathead" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
235496 | 235496 | 2020-06-13 | Flathead | Montana | 30029 | 37 | 2 |
232390 | 232390 | 2020-06-12 | Flathead | Montana | 30029 | 37 | 2 |
229285 | 229285 | 2020-06-11 | Flathead | Montana | 30029 | 37 | 2 |
226182 | 226182 | 2020-06-10 | Flathead | Montana | 30029 | 37 | 2 |
223083 | 223083 | 2020-06-09 | Flathead | Montana | 30029 | 37 | 2 |
219988 | 219988 | 2020-06-08 | Flathead | Montana | 30029 | 37 | 2 |
216896 | 216896 | 2020-06-07 | Flathead | Montana | 30029 | 37 | 2 |
213807 | 213807 | 2020-06-06 | Flathead | Montana | 30029 | 37 | 2 |
210723 | 210723 | 2020-06-05 | Flathead | Montana | 30029 | 37 | 2 |
207642 | 207642 | 2020-06-04 | Flathead | Montana | 30029 | 37 | 2 |
204561 | 204561 | 2020-06-03 | Flathead | Montana | 30029 | 37 | 2 |
201484 | 201484 | 2020-06-02 | Flathead | Montana | 30029 | 37 | 2 |
198411 | 198411 | 2020-06-01 | Flathead | Montana | 30029 | 37 | 2 |
195340 | 195340 | 2020-05-31 | Flathead | Montana | 30029 | 37 | 2 |
192270 | 192270 | 2020-05-30 | Flathead | Montana | 30029 | 37 | 2 |
189206 | 189206 | 2020-05-29 | Flathead | Montana | 30029 | 37 | 2 |
186147 | 186147 | 2020-05-28 | Flathead | Montana | 30029 | 37 | 2 |
183091 | 183091 | 2020-05-27 | Flathead | Montana | 30029 | 37 | 2 |
180043 | 180043 | 2020-05-26 | Flathead | Montana | 30029 | 37 | 2 |
176999 | 176999 | 2020-05-25 | Flathead | Montana | 30029 | 37 | 2 |
173956 | 173956 | 2020-05-24 | Flathead | Montana | 30029 | 37 | 2 |
170914 | 170914 | 2020-05-23 | Flathead | Montana | 30029 | 37 | 2 |
167875 | 167875 | 2020-05-22 | Flathead | Montana | 30029 | 37 | 2 |
164839 | 164839 | 2020-05-21 | Flathead | Montana | 30029 | 37 | 2 |
161810 | 161810 | 2020-05-20 | Flathead | Montana | 30029 | 37 | 2 |
158784 | 158784 | 2020-05-19 | Flathead | Montana | 30029 | 37 | 2 |
155766 | 155766 | 2020-05-18 | Flathead | Montana | 30029 | 37 | 2 |
152752 | 152752 | 2020-05-17 | Flathead | Montana | 30029 | 37 | 2 |
149741 | 149741 | 2020-05-16 | Flathead | Montana | 30029 | 37 | 2 |
146735 | 146735 | 2020-05-15 | Flathead | Montana | 30029 | 37 | 2 |
143734 | 143734 | 2020-05-14 | Flathead | Montana | 30029 | 37 | 2 |
140739 | 140739 | 2020-05-13 | Flathead | Montana | 30029 | 37 | 2 |
137745 | 137745 | 2020-05-12 | Flathead | Montana | 30029 | 37 | 2 |
134755 | 134755 | 2020-05-11 | Flathead | Montana | 30029 | 37 | 2 |
131764 | 131764 | 2020-05-10 | Flathead | Montana | 30029 | 37 | 2 |
128774 | 128774 | 2020-05-09 | Flathead | Montana | 30029 | 37 | 2 |
125786 | 125786 | 2020-05-08 | Flathead | Montana | 30029 | 37 | 2 |
122804 | 122804 | 2020-05-07 | Flathead | Montana | 30029 | 37 | 2 |
119830 | 119830 | 2020-05-06 | Flathead | Montana | 30029 | 37 | 2 |
116870 | 116870 | 2020-05-05 | Flathead | Montana | 30029 | 37 | 2 |
113988 | 113988 | 2020-05-04 | Flathead | Montana | 30029 | 37 | 2 |
111109 | 111109 | 2020-05-03 | Flathead | Montana | 30029 | 37 | 2 |
108237 | 108237 | 2020-05-02 | Flathead | Montana | 30029 | 37 | 2 |
105371 | 105371 | 2020-05-01 | Flathead | Montana | 30029 | 37 | 2 |
102510 | 102510 | 2020-04-30 | Flathead | Montana | 30029 | 37 | 2 |
99658 | 99658 | 2020-04-29 | Flathead | Montana | 30029 | 37 | 2 |
96812 | 96812 | 2020-04-28 | Flathead | Montana | 30029 | 37 | 2 |
93976 | 93976 | 2020-04-27 | Flathead | Montana | 30029 | 37 | 2 |
91155 | 91155 | 2020-04-26 | Flathead | Montana | 30029 | 37 | 2 |
88340 | 88340 | 2020-04-25 | Flathead | Montana | 30029 | 37 | 2 |
85530 | 85530 | 2020-04-24 | Flathead | Montana | 30029 | 37 | 2 |
82726 | 82726 | 2020-04-23 | Flathead | Montana | 30029 | 37 | 2 |
79930 | 79930 | 2020-04-22 | Flathead | Montana | 30029 | 37 | 2 |
77142 | 77142 | 2020-04-21 | Flathead | Montana | 30029 | 37 | 1 |
74362 | 74362 | 2020-04-20 | Flathead | Montana | 30029 | 37 | 1 |
71589 | 71589 | 2020-04-19 | Flathead | Montana | 30029 | 37 | 1 |
68822 | 68822 | 2020-04-18 | Flathead | Montana | 30029 | 37 | 1 |
66068 | 66068 | 2020-04-17 | Flathead | Montana | 30029 | 37 | 1 |
63328 | 63328 | 2020-04-16 | Flathead | Montana | 30029 | 37 | 1 |
60605 | 60605 | 2020-04-15 | Flathead | Montana | 30029 | 37 | 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);