ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 41005 and state = "Oregon" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1541 | 1541 | 2020-03-12 | Clackamas | Oregon | 41005 | 1 | 0 |
1837 | 1837 | 2020-03-13 | Clackamas | Oregon | 41005 | 1 | 0 |
2198 | 2198 | 2020-03-14 | Clackamas | Oregon | 41005 | 1 | 0 |
2617 | 2617 | 2020-03-15 | Clackamas | Oregon | 41005 | 1 | 0 |
3082 | 3082 | 2020-03-16 | Clackamas | Oregon | 41005 | 2 | 0 |
3610 | 3610 | 2020-03-17 | Clackamas | Oregon | 41005 | 6 | 0 |
4225 | 4225 | 2020-03-18 | Clackamas | Oregon | 41005 | 6 | 0 |
4964 | 4964 | 2020-03-19 | Clackamas | Oregon | 41005 | 6 | 0 |
5831 | 5831 | 2020-03-20 | Clackamas | Oregon | 41005 | 10 | 0 |
6832 | 6832 | 2020-03-21 | Clackamas | Oregon | 41005 | 11 | 0 |
7947 | 7947 | 2020-03-22 | Clackamas | Oregon | 41005 | 12 | 0 |
9156 | 9156 | 2020-03-23 | Clackamas | Oregon | 41005 | 14 | 0 |
10474 | 10474 | 2020-03-24 | Clackamas | Oregon | 41005 | 17 | 1 |
11935 | 11935 | 2020-03-25 | Clackamas | Oregon | 41005 | 21 | 2 |
13551 | 13551 | 2020-03-26 | Clackamas | Oregon | 41005 | 21 | 2 |
15295 | 15295 | 2020-03-27 | Clackamas | Oregon | 41005 | 31 | 2 |
17142 | 17142 | 2020-03-28 | Clackamas | Oregon | 41005 | 36 | 2 |
19080 | 19080 | 2020-03-29 | Clackamas | Oregon | 41005 | 39 | 2 |
21130 | 21130 | 2020-03-30 | Clackamas | Oregon | 41005 | 40 | 3 |
23263 | 23263 | 2020-03-31 | Clackamas | Oregon | 41005 | 50 | 3 |
25461 | 25461 | 2020-04-01 | Clackamas | Oregon | 41005 | 56 | 3 |
27733 | 27733 | 2020-04-02 | Clackamas | Oregon | 41005 | 61 | 3 |
30065 | 30065 | 2020-04-03 | Clackamas | Oregon | 41005 | 66 | 3 |
32455 | 32455 | 2020-04-04 | Clackamas | Oregon | 41005 | 78 | 3 |
34889 | 34889 | 2020-04-05 | Clackamas | Oregon | 41005 | 84 | 3 |
37363 | 37363 | 2020-04-06 | Clackamas | Oregon | 41005 | 90 | 3 |
39884 | 39884 | 2020-04-07 | Clackamas | Oregon | 41005 | 97 | 3 |
42444 | 42444 | 2020-04-08 | Clackamas | Oregon | 41005 | 103 | 3 |
45030 | 45030 | 2020-04-09 | Clackamas | Oregon | 41005 | 109 | 3 |
47647 | 47647 | 2020-04-10 | Clackamas | Oregon | 41005 | 116 | 3 |
50303 | 50303 | 2020-04-11 | Clackamas | Oregon | 41005 | 121 | 3 |
52976 | 52976 | 2020-04-12 | Clackamas | Oregon | 41005 | 125 | 3 |
55661 | 55661 | 2020-04-13 | Clackamas | Oregon | 41005 | 132 | 3 |
58363 | 58363 | 2020-04-14 | Clackamas | Oregon | 41005 | 135 | 3 |
61078 | 61078 | 2020-04-15 | Clackamas | Oregon | 41005 | 142 | 3 |
63804 | 63804 | 2020-04-16 | Clackamas | Oregon | 41005 | 150 | 3 |
66550 | 66550 | 2020-04-17 | Clackamas | Oregon | 41005 | 153 | 4 |
69308 | 69308 | 2020-04-18 | Clackamas | Oregon | 41005 | 154 | 5 |
72075 | 72075 | 2020-04-19 | Clackamas | Oregon | 41005 | 161 | 5 |
74850 | 74850 | 2020-04-20 | Clackamas | Oregon | 41005 | 171 | 5 |
77632 | 77632 | 2020-04-21 | Clackamas | Oregon | 41005 | 173 | 5 |
80422 | 80422 | 2020-04-22 | Clackamas | Oregon | 41005 | 183 | 5 |
83221 | 83221 | 2020-04-23 | Clackamas | Oregon | 41005 | 191 | 6 |
86025 | 86025 | 2020-04-24 | Clackamas | Oregon | 41005 | 196 | 6 |
88839 | 88839 | 2020-04-25 | Clackamas | Oregon | 41005 | 201 | 6 |
91655 | 91655 | 2020-04-26 | Clackamas | Oregon | 41005 | 204 | 6 |
94482 | 94482 | 2020-04-27 | Clackamas | Oregon | 41005 | 204 | 6 |
97320 | 97320 | 2020-04-28 | Clackamas | Oregon | 41005 | 205 | 7 |
100169 | 100169 | 2020-04-29 | Clackamas | Oregon | 41005 | 206 | 7 |
103022 | 103022 | 2020-04-30 | Clackamas | Oregon | 41005 | 214 | 7 |
105885 | 105885 | 2020-05-01 | Clackamas | Oregon | 41005 | 222 | 7 |
108752 | 108752 | 2020-05-02 | Clackamas | Oregon | 41005 | 224 | 7 |
111626 | 111626 | 2020-05-03 | Clackamas | Oregon | 41005 | 225 | 7 |
114508 | 114508 | 2020-05-04 | Clackamas | Oregon | 41005 | 226 | 7 |
117389 | 117389 | 2020-05-05 | Clackamas | Oregon | 41005 | 231 | 7 |
120351 | 120351 | 2020-05-06 | Clackamas | Oregon | 41005 | 235 | 7 |
123328 | 123328 | 2020-05-07 | Clackamas | Oregon | 41005 | 241 | 8 |
126311 | 126311 | 2020-05-08 | Clackamas | Oregon | 41005 | 250 | 8 |
129300 | 129300 | 2020-05-09 | Clackamas | Oregon | 41005 | 256 | 9 |
132289 | 132289 | 2020-05-10 | Clackamas | Oregon | 41005 | 266 | 9 |
135280 | 135280 | 2020-05-11 | Clackamas | Oregon | 41005 | 268 | 9 |
144262 | 144262 | 2020-05-14 | Clackamas | Oregon | 41005 | 271 | 9 |
138270 | 138270 | 2020-05-12 | Clackamas | Oregon | 41005 | 274 | 9 |
141266 | 141266 | 2020-05-13 | Clackamas | Oregon | 41005 | 274 | 9 |
147263 | 147263 | 2020-05-15 | Clackamas | Oregon | 41005 | 277 | 9 |
150270 | 150270 | 2020-05-16 | Clackamas | Oregon | 41005 | 281 | 9 |
153281 | 153281 | 2020-05-17 | Clackamas | Oregon | 41005 | 281 | 9 |
159319 | 159319 | 2020-05-19 | Clackamas | Oregon | 41005 | 284 | 9 |
162346 | 162346 | 2020-05-20 | Clackamas | Oregon | 41005 | 284 | 9 |
165375 | 165375 | 2020-05-21 | Clackamas | Oregon | 41005 | 284 | 9 |
156298 | 156298 | 2020-05-18 | Clackamas | Oregon | 41005 | 286 | 9 |
168411 | 168411 | 2020-05-22 | Clackamas | Oregon | 41005 | 289 | 9 |
171450 | 171450 | 2020-05-23 | Clackamas | Oregon | 41005 | 290 | 9 |
174492 | 174492 | 2020-05-24 | Clackamas | Oregon | 41005 | 290 | 10 |
177536 | 177536 | 2020-05-25 | Clackamas | Oregon | 41005 | 294 | 10 |
180579 | 180579 | 2020-05-26 | Clackamas | Oregon | 41005 | 296 | 10 |
183628 | 183628 | 2020-05-27 | Clackamas | Oregon | 41005 | 300 | 10 |
186685 | 186685 | 2020-05-28 | Clackamas | Oregon | 41005 | 304 | 11 |
189746 | 189746 | 2020-05-29 | Clackamas | Oregon | 41005 | 305 | 11 |
192811 | 192811 | 2020-05-30 | Clackamas | Oregon | 41005 | 306 | 11 |
195880 | 195880 | 2020-05-31 | Clackamas | Oregon | 41005 | 312 | 11 |
198953 | 198953 | 2020-06-01 | Clackamas | Oregon | 41005 | 317 | 11 |
202028 | 202028 | 2020-06-02 | Clackamas | Oregon | 41005 | 317 | 11 |
205105 | 205105 | 2020-06-03 | Clackamas | Oregon | 41005 | 324 | 12 |
208186 | 208186 | 2020-06-04 | Clackamas | Oregon | 41005 | 333 | 12 |
211268 | 211268 | 2020-06-05 | Clackamas | Oregon | 41005 | 343 | 12 |
214354 | 214354 | 2020-06-06 | Clackamas | Oregon | 41005 | 350 | 12 |
217444 | 217444 | 2020-06-07 | Clackamas | Oregon | 41005 | 364 | 12 |
220536 | 220536 | 2020-06-08 | Clackamas | Oregon | 41005 | 377 | 12 |
223631 | 223631 | 2020-06-09 | Clackamas | Oregon | 41005 | 400 | 13 |
226731 | 226731 | 2020-06-10 | Clackamas | Oregon | 41005 | 409 | 13 |
229835 | 229835 | 2020-06-11 | Clackamas | Oregon | 41005 | 450 | 14 |
232940 | 232940 | 2020-06-12 | Clackamas | Oregon | 41005 | 459 | 14 |
236045 | 236045 | 2020-06-13 | Clackamas | Oregon | 41005 | 476 | 14 |
239153 | 239153 | 2020-06-14 | Clackamas | Oregon | 41005 | 486 | 14 |
242262 | 242262 | 2020-06-15 | Clackamas | Oregon | 41005 | 492 | 18 |
245374 | 245374 | 2020-06-16 | Clackamas | Oregon | 41005 | 513 | 19 |
248487 | 248487 | 2020-06-17 | Clackamas | Oregon | 41005 | 530 | 20 |
251602 | 251602 | 2020-06-18 | Clackamas | Oregon | 41005 | 542 | 22 |
254717 | 254717 | 2020-06-19 | Clackamas | Oregon | 41005 | 565 | 22 |
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);