ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 41017 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1298 | 1298 | 2020-03-11 | Deschutes | Oregon | 41017 | 1 | 0 |
1542 | 1542 | 2020-03-12 | Deschutes | Oregon | 41017 | 1 | 0 |
1838 | 1838 | 2020-03-13 | Deschutes | Oregon | 41017 | 1 | 0 |
2199 | 2199 | 2020-03-14 | Deschutes | Oregon | 41017 | 3 | 0 |
2618 | 2618 | 2020-03-15 | Deschutes | Oregon | 41017 | 4 | 0 |
3083 | 3083 | 2020-03-16 | Deschutes | Oregon | 41017 | 6 | 0 |
3611 | 3611 | 2020-03-17 | Deschutes | Oregon | 41017 | 6 | 0 |
4226 | 4226 | 2020-03-18 | Deschutes | Oregon | 41017 | 6 | 0 |
4965 | 4965 | 2020-03-19 | Deschutes | Oregon | 41017 | 6 | 0 |
5832 | 5832 | 2020-03-20 | Deschutes | Oregon | 41017 | 8 | 0 |
6833 | 6833 | 2020-03-21 | Deschutes | Oregon | 41017 | 9 | 0 |
7948 | 7948 | 2020-03-22 | Deschutes | Oregon | 41017 | 10 | 0 |
9157 | 9157 | 2020-03-23 | Deschutes | Oregon | 41017 | 10 | 0 |
10476 | 10476 | 2020-03-24 | Deschutes | Oregon | 41017 | 10 | 0 |
11937 | 11937 | 2020-03-25 | Deschutes | Oregon | 41017 | 10 | 0 |
13553 | 13553 | 2020-03-26 | Deschutes | Oregon | 41017 | 15 | 0 |
15298 | 15298 | 2020-03-27 | Deschutes | Oregon | 41017 | 18 | 0 |
17145 | 17145 | 2020-03-28 | Deschutes | Oregon | 41017 | 20 | 0 |
19083 | 19083 | 2020-03-29 | Deschutes | Oregon | 41017 | 23 | 0 |
21133 | 21133 | 2020-03-30 | Deschutes | Oregon | 41017 | 25 | 0 |
23266 | 23266 | 2020-03-31 | Deschutes | Oregon | 41017 | 24 | 0 |
25464 | 25464 | 2020-04-01 | Deschutes | Oregon | 41017 | 27 | 0 |
27736 | 27736 | 2020-04-02 | Deschutes | Oregon | 41017 | 32 | 0 |
30069 | 30069 | 2020-04-03 | Deschutes | Oregon | 41017 | 36 | 0 |
32459 | 32459 | 2020-04-04 | Deschutes | Oregon | 41017 | 39 | 0 |
34893 | 34893 | 2020-04-05 | Deschutes | Oregon | 41017 | 39 | 0 |
37368 | 37368 | 2020-04-06 | Deschutes | Oregon | 41017 | 40 | 0 |
39889 | 39889 | 2020-04-07 | Deschutes | Oregon | 41017 | 44 | 0 |
42449 | 42449 | 2020-04-08 | Deschutes | Oregon | 41017 | 45 | 0 |
45035 | 45035 | 2020-04-09 | Deschutes | Oregon | 41017 | 50 | 0 |
47652 | 47652 | 2020-04-10 | Deschutes | Oregon | 41017 | 51 | 0 |
50309 | 50309 | 2020-04-11 | Deschutes | Oregon | 41017 | 53 | 0 |
52982 | 52982 | 2020-04-12 | Deschutes | Oregon | 41017 | 54 | 0 |
55667 | 55667 | 2020-04-13 | Deschutes | Oregon | 41017 | 54 | 0 |
58369 | 58369 | 2020-04-14 | Deschutes | Oregon | 41017 | 55 | 0 |
61084 | 61084 | 2020-04-15 | Deschutes | Oregon | 41017 | 55 | 0 |
63810 | 63810 | 2020-04-16 | Deschutes | Oregon | 41017 | 59 | 0 |
66556 | 66556 | 2020-04-17 | Deschutes | Oregon | 41017 | 61 | 0 |
69314 | 69314 | 2020-04-18 | Deschutes | Oregon | 41017 | 63 | 0 |
72081 | 72081 | 2020-04-19 | Deschutes | Oregon | 41017 | 64 | 0 |
74856 | 74856 | 2020-04-20 | Deschutes | Oregon | 41017 | 64 | 0 |
77638 | 77638 | 2020-04-21 | Deschutes | Oregon | 41017 | 64 | 0 |
80428 | 80428 | 2020-04-22 | Deschutes | Oregon | 41017 | 66 | 0 |
83227 | 83227 | 2020-04-23 | Deschutes | Oregon | 41017 | 70 | 0 |
86031 | 86031 | 2020-04-24 | Deschutes | Oregon | 41017 | 70 | 0 |
88845 | 88845 | 2020-04-25 | Deschutes | Oregon | 41017 | 71 | 0 |
91661 | 91661 | 2020-04-26 | Deschutes | Oregon | 41017 | 73 | 0 |
94488 | 94488 | 2020-04-27 | Deschutes | Oregon | 41017 | 75 | 0 |
97326 | 97326 | 2020-04-28 | Deschutes | Oregon | 41017 | 75 | 0 |
100175 | 100175 | 2020-04-29 | Deschutes | Oregon | 41017 | 75 | 0 |
103028 | 103028 | 2020-04-30 | Deschutes | Oregon | 41017 | 76 | 0 |
105891 | 105891 | 2020-05-01 | Deschutes | Oregon | 41017 | 76 | 0 |
108758 | 108758 | 2020-05-02 | Deschutes | Oregon | 41017 | 78 | 0 |
111632 | 111632 | 2020-05-03 | Deschutes | Oregon | 41017 | 78 | 0 |
114514 | 114514 | 2020-05-04 | Deschutes | Oregon | 41017 | 79 | 0 |
117395 | 117395 | 2020-05-05 | Deschutes | Oregon | 41017 | 80 | 0 |
120357 | 120357 | 2020-05-06 | Deschutes | Oregon | 41017 | 81 | 0 |
123334 | 123334 | 2020-05-07 | Deschutes | Oregon | 41017 | 83 | 0 |
126317 | 126317 | 2020-05-08 | Deschutes | Oregon | 41017 | 84 | 0 |
129306 | 129306 | 2020-05-09 | Deschutes | Oregon | 41017 | 85 | 0 |
132295 | 132295 | 2020-05-10 | Deschutes | Oregon | 41017 | 86 | 0 |
135286 | 135286 | 2020-05-11 | Deschutes | Oregon | 41017 | 86 | 0 |
138276 | 138276 | 2020-05-12 | Deschutes | Oregon | 41017 | 90 | 0 |
141272 | 141272 | 2020-05-13 | Deschutes | Oregon | 41017 | 89 | 0 |
144268 | 144268 | 2020-05-14 | Deschutes | Oregon | 41017 | 91 | 0 |
147269 | 147269 | 2020-05-15 | Deschutes | Oregon | 41017 | 94 | 0 |
150276 | 150276 | 2020-05-16 | Deschutes | Oregon | 41017 | 95 | 0 |
153287 | 153287 | 2020-05-17 | Deschutes | Oregon | 41017 | 96 | 0 |
156304 | 156304 | 2020-05-18 | Deschutes | Oregon | 41017 | 101 | 0 |
159325 | 159325 | 2020-05-19 | Deschutes | Oregon | 41017 | 107 | 0 |
162352 | 162352 | 2020-05-20 | Deschutes | Oregon | 41017 | 116 | 0 |
165381 | 165381 | 2020-05-21 | Deschutes | Oregon | 41017 | 117 | 0 |
168417 | 168417 | 2020-05-22 | Deschutes | Oregon | 41017 | 116 | 0 |
171456 | 171456 | 2020-05-23 | Deschutes | Oregon | 41017 | 117 | 0 |
174498 | 174498 | 2020-05-24 | Deschutes | Oregon | 41017 | 119 | 0 |
177542 | 177542 | 2020-05-25 | Deschutes | Oregon | 41017 | 120 | 0 |
180585 | 180585 | 2020-05-26 | Deschutes | Oregon | 41017 | 120 | 0 |
183634 | 183634 | 2020-05-27 | Deschutes | Oregon | 41017 | 120 | 0 |
186691 | 186691 | 2020-05-28 | Deschutes | Oregon | 41017 | 121 | 0 |
189752 | 189752 | 2020-05-29 | Deschutes | Oregon | 41017 | 121 | 0 |
192817 | 192817 | 2020-05-30 | Deschutes | Oregon | 41017 | 124 | 0 |
195886 | 195886 | 2020-05-31 | Deschutes | Oregon | 41017 | 125 | 0 |
198959 | 198959 | 2020-06-01 | Deschutes | Oregon | 41017 | 127 | 0 |
202034 | 202034 | 2020-06-02 | Deschutes | Oregon | 41017 | 127 | 0 |
205111 | 205111 | 2020-06-03 | Deschutes | Oregon | 41017 | 128 | 0 |
208192 | 208192 | 2020-06-04 | Deschutes | Oregon | 41017 | 133 | 0 |
211274 | 211274 | 2020-06-05 | Deschutes | Oregon | 41017 | 134 | 0 |
214360 | 214360 | 2020-06-06 | Deschutes | Oregon | 41017 | 133 | 0 |
217450 | 217450 | 2020-06-07 | Deschutes | Oregon | 41017 | 136 | 0 |
220542 | 220542 | 2020-06-08 | Deschutes | Oregon | 41017 | 136 | 0 |
223637 | 223637 | 2020-06-09 | Deschutes | Oregon | 41017 | 136 | 0 |
226737 | 226737 | 2020-06-10 | Deschutes | Oregon | 41017 | 136 | 0 |
229841 | 229841 | 2020-06-11 | Deschutes | Oregon | 41017 | 136 | 0 |
232946 | 232946 | 2020-06-12 | Deschutes | Oregon | 41017 | 137 | 0 |
236051 | 236051 | 2020-06-13 | Deschutes | Oregon | 41017 | 137 | 0 |
239159 | 239159 | 2020-06-14 | Deschutes | Oregon | 41017 | 137 | 0 |
242268 | 242268 | 2020-06-15 | Deschutes | Oregon | 41017 | 137 | 0 |
245380 | 245380 | 2020-06-16 | Deschutes | Oregon | 41017 | 137 | 0 |
248493 | 248493 | 2020-06-17 | Deschutes | Oregon | 41017 | 139 | 0 |
251608 | 251608 | 2020-06-18 | Deschutes | Oregon | 41017 | 139 | 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);