ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where fips = 41025 and state = "Oregon" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
97329 | 97329 | 2020-04-28 | Harney | Oregon | 41025 | 1 | 0 |
100178 | 100178 | 2020-04-29 | Harney | Oregon | 41025 | 1 | 0 |
103031 | 103031 | 2020-04-30 | Harney | Oregon | 41025 | 1 | 0 |
105894 | 105894 | 2020-05-01 | Harney | Oregon | 41025 | 1 | 0 |
108761 | 108761 | 2020-05-02 | Harney | Oregon | 41025 | 1 | 0 |
111635 | 111635 | 2020-05-03 | Harney | Oregon | 41025 | 1 | 0 |
114517 | 114517 | 2020-05-04 | Harney | Oregon | 41025 | 1 | 0 |
117398 | 117398 | 2020-05-05 | Harney | Oregon | 41025 | 1 | 0 |
120360 | 120360 | 2020-05-06 | Harney | Oregon | 41025 | 1 | 0 |
123337 | 123337 | 2020-05-07 | Harney | Oregon | 41025 | 1 | 0 |
126320 | 126320 | 2020-05-08 | Harney | Oregon | 41025 | 1 | 0 |
129309 | 129309 | 2020-05-09 | Harney | Oregon | 41025 | 1 | 0 |
132298 | 132298 | 2020-05-10 | Harney | Oregon | 41025 | 1 | 0 |
135289 | 135289 | 2020-05-11 | Harney | Oregon | 41025 | 1 | 0 |
138279 | 138279 | 2020-05-12 | Harney | Oregon | 41025 | 1 | 0 |
141275 | 141275 | 2020-05-13 | Harney | Oregon | 41025 | 1 | 0 |
144271 | 144271 | 2020-05-14 | Harney | Oregon | 41025 | 1 | 0 |
147272 | 147272 | 2020-05-15 | Harney | Oregon | 41025 | 1 | 0 |
150279 | 150279 | 2020-05-16 | Harney | Oregon | 41025 | 1 | 0 |
153290 | 153290 | 2020-05-17 | Harney | Oregon | 41025 | 1 | 0 |
156307 | 156307 | 2020-05-18 | Harney | Oregon | 41025 | 1 | 0 |
159328 | 159328 | 2020-05-19 | Harney | Oregon | 41025 | 1 | 0 |
162355 | 162355 | 2020-05-20 | Harney | Oregon | 41025 | 1 | 0 |
165384 | 165384 | 2020-05-21 | Harney | Oregon | 41025 | 1 | 0 |
168420 | 168420 | 2020-05-22 | Harney | Oregon | 41025 | 1 | 0 |
171459 | 171459 | 2020-05-23 | Harney | Oregon | 41025 | 1 | 0 |
174501 | 174501 | 2020-05-24 | Harney | Oregon | 41025 | 1 | 0 |
177545 | 177545 | 2020-05-25 | Harney | Oregon | 41025 | 1 | 0 |
180588 | 180588 | 2020-05-26 | Harney | Oregon | 41025 | 1 | 0 |
183637 | 183637 | 2020-05-27 | Harney | Oregon | 41025 | 1 | 0 |
186694 | 186694 | 2020-05-28 | Harney | Oregon | 41025 | 1 | 0 |
189755 | 189755 | 2020-05-29 | Harney | Oregon | 41025 | 1 | 0 |
192820 | 192820 | 2020-05-30 | Harney | Oregon | 41025 | 1 | 0 |
195889 | 195889 | 2020-05-31 | Harney | Oregon | 41025 | 1 | 0 |
198962 | 198962 | 2020-06-01 | Harney | Oregon | 41025 | 1 | 0 |
202037 | 202037 | 2020-06-02 | Harney | Oregon | 41025 | 1 | 0 |
205114 | 205114 | 2020-06-03 | Harney | Oregon | 41025 | 1 | 0 |
208195 | 208195 | 2020-06-04 | Harney | Oregon | 41025 | 1 | 0 |
211277 | 211277 | 2020-06-05 | Harney | Oregon | 41025 | 1 | 0 |
214363 | 214363 | 2020-06-06 | Harney | Oregon | 41025 | 1 | 0 |
217453 | 217453 | 2020-06-07 | Harney | Oregon | 41025 | 1 | 0 |
220545 | 220545 | 2020-06-08 | Harney | Oregon | 41025 | 1 | 0 |
223640 | 223640 | 2020-06-09 | Harney | Oregon | 41025 | 1 | 0 |
226740 | 226740 | 2020-06-10 | Harney | Oregon | 41025 | 1 | 0 |
229844 | 229844 | 2020-06-11 | Harney | Oregon | 41025 | 1 | 0 |
232949 | 232949 | 2020-06-12 | Harney | Oregon | 41025 | 1 | 0 |
236054 | 236054 | 2020-06-13 | Harney | Oregon | 41025 | 1 | 0 |
239162 | 239162 | 2020-06-14 | Harney | Oregon | 41025 | 1 | 0 |
242271 | 242271 | 2020-06-15 | Harney | Oregon | 41025 | 1 | 0 |
245383 | 245383 | 2020-06-16 | Harney | Oregon | 41025 | 1 | 0 |
248496 | 248496 | 2020-06-17 | Harney | Oregon | 41025 | 1 | 0 |
251611 | 251611 | 2020-06-18 | Harney | Oregon | 41025 | 1 | 0 |
254726 | 254726 | 2020-06-19 | Harney | Oregon | 41025 | 1 | 0 |
257852 | 257852 | 2020-06-20 | Harney | Oregon | 41025 | 1 | 0 |
260979 | 260979 | 2020-06-21 | Harney | Oregon | 41025 | 1 | 0 |
264107 | 264107 | 2020-06-22 | Harney | Oregon | 41025 | 1 | 0 |
267235 | 267235 | 2020-06-23 | Harney | Oregon | 41025 | 1 | 0 |
270369 | 270369 | 2020-06-24 | Harney | Oregon | 41025 | 1 | 0 |
273508 | 273508 | 2020-06-25 | Harney | Oregon | 41025 | 1 | 0 |
276655 | 276655 | 2020-06-26 | Harney | Oregon | 41025 | 1 | 0 |
279803 | 279803 | 2020-06-27 | Harney | Oregon | 41025 | 1 | 0 |
282949 | 282949 | 2020-06-28 | Harney | Oregon | 41025 | 1 | 0 |
286094 | 286094 | 2020-06-29 | Harney | Oregon | 41025 | 1 | 0 |
289245 | 289245 | 2020-06-30 | Harney | Oregon | 41025 | 1 | 0 |
292397 | 292397 | 2020-07-01 | Harney | Oregon | 41025 | 1 | 0 |
295553 | 295553 | 2020-07-02 | Harney | Oregon | 41025 | 1 | 0 |
298712 | 298712 | 2020-07-03 | Harney | Oregon | 41025 | 1 | 0 |
301876 | 301876 | 2020-07-04 | Harney | Oregon | 41025 | 1 | 0 |
305039 | 305039 | 2020-07-05 | Harney | Oregon | 41025 | 1 | 0 |
308206 | 308206 | 2020-07-06 | Harney | Oregon | 41025 | 1 | 0 |
311375 | 311375 | 2020-07-07 | Harney | Oregon | 41025 | 1 | 0 |
314547 | 314547 | 2020-07-08 | Harney | Oregon | 41025 | 2 | 0 |
317720 | 317720 | 2020-07-09 | Harney | Oregon | 41025 | 2 | 0 |
320898 | 320898 | 2020-07-10 | Harney | Oregon | 41025 | 2 | 0 |
324078 | 324078 | 2020-07-11 | Harney | Oregon | 41025 | 2 | 0 |
327263 | 327263 | 2020-07-12 | Harney | Oregon | 41025 | 2 | 0 |
330449 | 330449 | 2020-07-13 | Harney | Oregon | 41025 | 2 | 0 |
333641 | 333641 | 2020-07-14 | Harney | Oregon | 41025 | 2 | 0 |
336835 | 336835 | 2020-07-15 | Harney | Oregon | 41025 | 2 | 0 |
340032 | 340032 | 2020-07-16 | Harney | Oregon | 41025 | 2 | 0 |
343230 | 343230 | 2020-07-17 | Harney | Oregon | 41025 | 2 | 0 |
346430 | 346430 | 2020-07-18 | Harney | Oregon | 41025 | 2 | 0 |
349630 | 349630 | 2020-07-19 | Harney | Oregon | 41025 | 2 | 0 |
352833 | 352833 | 2020-07-20 | Harney | Oregon | 41025 | 3 | 0 |
356036 | 356036 | 2020-07-21 | Harney | Oregon | 41025 | 5 | 0 |
359240 | 359240 | 2020-07-22 | Harney | Oregon | 41025 | 5 | 0 |
362446 | 362446 | 2020-07-23 | Harney | Oregon | 41025 | 5 | 0 |
365652 | 365652 | 2020-07-24 | Harney | Oregon | 41025 | 5 | 0 |
368861 | 368861 | 2020-07-25 | Harney | Oregon | 41025 | 6 | 0 |
372073 | 372073 | 2020-07-26 | Harney | Oregon | 41025 | 6 | 0 |
375286 | 375286 | 2020-07-27 | Harney | Oregon | 41025 | 7 | 0 |
378502 | 378502 | 2020-07-28 | Harney | Oregon | 41025 | 8 | 0 |
381719 | 381719 | 2020-07-29 | Harney | Oregon | 41025 | 8 | 0 |
384937 | 384937 | 2020-07-30 | Harney | Oregon | 41025 | 8 | 0 |
388154 | 388154 | 2020-07-31 | Harney | Oregon | 41025 | 8 | 0 |
391371 | 391371 | 2020-08-01 | Harney | Oregon | 41025 | 8 | 0 |
394587 | 394587 | 2020-08-02 | Harney | Oregon | 41025 | 8 | 0 |
397804 | 397804 | 2020-08-03 | Harney | Oregon | 41025 | 8 | 0 |
401019 | 401019 | 2020-08-04 | Harney | Oregon | 41025 | 10 | 0 |
404237 | 404237 | 2020-08-05 | Harney | Oregon | 41025 | 10 | 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);