ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Flathead" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
4811 | 4811 | 2020-03-19 | Flathead | Montana | 30029 | 1 | 0 |
5650 | 5650 | 2020-03-20 | Flathead | Montana | 30029 | 1 | 0 |
6641 | 6641 | 2020-03-21 | Flathead | Montana | 30029 | 2 | 0 |
7730 | 7730 | 2020-03-22 | Flathead | Montana | 30029 | 2 | 0 |
8923 | 8923 | 2020-03-23 | Flathead | Montana | 30029 | 4 | 0 |
10225 | 10225 | 2020-03-24 | Flathead | Montana | 30029 | 4 | 0 |
11654 | 11654 | 2020-03-25 | Flathead | Montana | 30029 | 5 | 0 |
13252 | 13252 | 2020-03-26 | Flathead | Montana | 30029 | 5 | 0 |
14982 | 14982 | 2020-03-27 | Flathead | Montana | 30029 | 6 | 0 |
16808 | 16808 | 2020-03-28 | Flathead | Montana | 30029 | 6 | 0 |
18731 | 18731 | 2020-03-29 | Flathead | Montana | 30029 | 8 | 0 |
20766 | 20766 | 2020-03-30 | Flathead | Montana | 30029 | 9 | 0 |
22886 | 22886 | 2020-03-31 | Flathead | Montana | 30029 | 11 | 0 |
25075 | 25075 | 2020-04-01 | Flathead | Montana | 30029 | 17 | 0 |
27332 | 27332 | 2020-04-02 | Flathead | Montana | 30029 | 18 | 0 |
29654 | 29654 | 2020-04-03 | Flathead | Montana | 30029 | 20 | 0 |
32036 | 32036 | 2020-04-04 | Flathead | Montana | 30029 | 23 | 0 |
34464 | 34464 | 2020-04-05 | Flathead | Montana | 30029 | 25 | 0 |
36931 | 36931 | 2020-04-06 | Flathead | Montana | 30029 | 31 | 0 |
39447 | 39447 | 2020-04-07 | Flathead | Montana | 30029 | 31 | 0 |
42002 | 42002 | 2020-04-08 | Flathead | Montana | 30029 | 31 | 0 |
44581 | 44581 | 2020-04-09 | Flathead | Montana | 30029 | 34 | 0 |
47191 | 47191 | 2020-04-10 | Flathead | Montana | 30029 | 34 | 0 |
49839 | 49839 | 2020-04-11 | Flathead | Montana | 30029 | 34 | 0 |
52512 | 52512 | 2020-04-12 | Flathead | Montana | 30029 | 34 | 0 |
55193 | 55193 | 2020-04-13 | Flathead | Montana | 30029 | 36 | 1 |
57892 | 57892 | 2020-04-14 | Flathead | Montana | 30029 | 36 | 1 |
60605 | 60605 | 2020-04-15 | Flathead | Montana | 30029 | 37 | 1 |
63328 | 63328 | 2020-04-16 | Flathead | Montana | 30029 | 37 | 1 |
66068 | 66068 | 2020-04-17 | Flathead | Montana | 30029 | 37 | 1 |
68822 | 68822 | 2020-04-18 | Flathead | Montana | 30029 | 37 | 1 |
71589 | 71589 | 2020-04-19 | Flathead | Montana | 30029 | 37 | 1 |
74362 | 74362 | 2020-04-20 | Flathead | Montana | 30029 | 37 | 1 |
77142 | 77142 | 2020-04-21 | Flathead | Montana | 30029 | 37 | 1 |
79930 | 79930 | 2020-04-22 | Flathead | Montana | 30029 | 37 | 2 |
82726 | 82726 | 2020-04-23 | Flathead | Montana | 30029 | 37 | 2 |
85530 | 85530 | 2020-04-24 | Flathead | Montana | 30029 | 37 | 2 |
88340 | 88340 | 2020-04-25 | Flathead | Montana | 30029 | 37 | 2 |
91155 | 91155 | 2020-04-26 | Flathead | Montana | 30029 | 37 | 2 |
93976 | 93976 | 2020-04-27 | Flathead | Montana | 30029 | 37 | 2 |
96812 | 96812 | 2020-04-28 | Flathead | Montana | 30029 | 37 | 2 |
99658 | 99658 | 2020-04-29 | Flathead | Montana | 30029 | 37 | 2 |
102510 | 102510 | 2020-04-30 | Flathead | Montana | 30029 | 37 | 2 |
105371 | 105371 | 2020-05-01 | Flathead | Montana | 30029 | 37 | 2 |
108237 | 108237 | 2020-05-02 | Flathead | Montana | 30029 | 37 | 2 |
111109 | 111109 | 2020-05-03 | Flathead | Montana | 30029 | 37 | 2 |
113988 | 113988 | 2020-05-04 | Flathead | Montana | 30029 | 37 | 2 |
116870 | 116870 | 2020-05-05 | Flathead | Montana | 30029 | 37 | 2 |
119830 | 119830 | 2020-05-06 | Flathead | Montana | 30029 | 37 | 2 |
122804 | 122804 | 2020-05-07 | Flathead | Montana | 30029 | 37 | 2 |
125786 | 125786 | 2020-05-08 | Flathead | Montana | 30029 | 37 | 2 |
128774 | 128774 | 2020-05-09 | Flathead | Montana | 30029 | 37 | 2 |
131764 | 131764 | 2020-05-10 | Flathead | Montana | 30029 | 37 | 2 |
134755 | 134755 | 2020-05-11 | Flathead | Montana | 30029 | 37 | 2 |
137745 | 137745 | 2020-05-12 | Flathead | Montana | 30029 | 37 | 2 |
140739 | 140739 | 2020-05-13 | Flathead | Montana | 30029 | 37 | 2 |
143734 | 143734 | 2020-05-14 | Flathead | Montana | 30029 | 37 | 2 |
146735 | 146735 | 2020-05-15 | Flathead | Montana | 30029 | 37 | 2 |
149741 | 149741 | 2020-05-16 | Flathead | Montana | 30029 | 37 | 2 |
152752 | 152752 | 2020-05-17 | Flathead | Montana | 30029 | 37 | 2 |
155766 | 155766 | 2020-05-18 | Flathead | Montana | 30029 | 37 | 2 |
158784 | 158784 | 2020-05-19 | Flathead | Montana | 30029 | 37 | 2 |
161810 | 161810 | 2020-05-20 | Flathead | Montana | 30029 | 37 | 2 |
164839 | 164839 | 2020-05-21 | Flathead | Montana | 30029 | 37 | 2 |
167875 | 167875 | 2020-05-22 | Flathead | Montana | 30029 | 37 | 2 |
170914 | 170914 | 2020-05-23 | Flathead | Montana | 30029 | 37 | 2 |
173956 | 173956 | 2020-05-24 | Flathead | Montana | 30029 | 37 | 2 |
176999 | 176999 | 2020-05-25 | Flathead | Montana | 30029 | 37 | 2 |
180043 | 180043 | 2020-05-26 | Flathead | Montana | 30029 | 37 | 2 |
183091 | 183091 | 2020-05-27 | Flathead | Montana | 30029 | 37 | 2 |
186147 | 186147 | 2020-05-28 | Flathead | Montana | 30029 | 37 | 2 |
189206 | 189206 | 2020-05-29 | Flathead | Montana | 30029 | 37 | 2 |
192270 | 192270 | 2020-05-30 | Flathead | Montana | 30029 | 37 | 2 |
195340 | 195340 | 2020-05-31 | Flathead | Montana | 30029 | 37 | 2 |
198411 | 198411 | 2020-06-01 | Flathead | Montana | 30029 | 37 | 2 |
201484 | 201484 | 2020-06-02 | Flathead | Montana | 30029 | 37 | 2 |
204561 | 204561 | 2020-06-03 | Flathead | Montana | 30029 | 37 | 2 |
207642 | 207642 | 2020-06-04 | Flathead | Montana | 30029 | 37 | 2 |
210723 | 210723 | 2020-06-05 | Flathead | Montana | 30029 | 37 | 2 |
213807 | 213807 | 2020-06-06 | Flathead | Montana | 30029 | 37 | 2 |
216896 | 216896 | 2020-06-07 | Flathead | Montana | 30029 | 37 | 2 |
219988 | 219988 | 2020-06-08 | Flathead | Montana | 30029 | 37 | 2 |
223083 | 223083 | 2020-06-09 | Flathead | Montana | 30029 | 37 | 2 |
226182 | 226182 | 2020-06-10 | Flathead | Montana | 30029 | 37 | 2 |
229285 | 229285 | 2020-06-11 | Flathead | Montana | 30029 | 37 | 2 |
232390 | 232390 | 2020-06-12 | Flathead | Montana | 30029 | 37 | 2 |
235496 | 235496 | 2020-06-13 | Flathead | Montana | 30029 | 37 | 2 |
238603 | 238603 | 2020-06-14 | Flathead | Montana | 30029 | 38 | 2 |
241713 | 241713 | 2020-06-15 | Flathead | Montana | 30029 | 39 | 2 |
244824 | 244824 | 2020-06-16 | Flathead | Montana | 30029 | 39 | 2 |
247937 | 247937 | 2020-06-17 | Flathead | Montana | 30029 | 41 | 2 |
251051 | 251051 | 2020-06-18 | Flathead | Montana | 30029 | 45 | 2 |
254166 | 254166 | 2020-06-19 | Flathead | Montana | 30029 | 45 | 2 |
257289 | 257289 | 2020-06-20 | Flathead | Montana | 30029 | 45 | 2 |
260415 | 260415 | 2020-06-21 | Flathead | Montana | 30029 | 46 | 2 |
263544 | 263544 | 2020-06-22 | Flathead | Montana | 30029 | 48 | 2 |
266670 | 266670 | 2020-06-23 | Flathead | Montana | 30029 | 48 | 2 |
269803 | 269803 | 2020-06-24 | Flathead | Montana | 30029 | 49 | 2 |
272941 | 272941 | 2020-06-25 | Flathead | Montana | 30029 | 51 | 2 |
276084 | 276084 | 2020-06-26 | Flathead | Montana | 30029 | 52 | 2 |
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);