ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where fips = 41037 and state = "Oregon" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
183643 | 183643 | 2020-05-27 | Lake | Oregon | 41037 | 2 | 0 |
186700 | 186700 | 2020-05-28 | Lake | Oregon | 41037 | 2 | 0 |
189761 | 189761 | 2020-05-29 | Lake | Oregon | 41037 | 2 | 0 |
192826 | 192826 | 2020-05-30 | Lake | Oregon | 41037 | 2 | 0 |
195895 | 195895 | 2020-05-31 | Lake | Oregon | 41037 | 2 | 0 |
198968 | 198968 | 2020-06-01 | Lake | Oregon | 41037 | 2 | 0 |
202043 | 202043 | 2020-06-02 | Lake | Oregon | 41037 | 2 | 0 |
205120 | 205120 | 2020-06-03 | Lake | Oregon | 41037 | 2 | 0 |
208201 | 208201 | 2020-06-04 | Lake | Oregon | 41037 | 2 | 0 |
211283 | 211283 | 2020-06-05 | Lake | Oregon | 41037 | 2 | 0 |
214369 | 214369 | 2020-06-06 | Lake | Oregon | 41037 | 2 | 0 |
217459 | 217459 | 2020-06-07 | Lake | Oregon | 41037 | 2 | 0 |
220551 | 220551 | 2020-06-08 | Lake | Oregon | 41037 | 2 | 0 |
223646 | 223646 | 2020-06-09 | Lake | Oregon | 41037 | 2 | 0 |
226746 | 226746 | 2020-06-10 | Lake | Oregon | 41037 | 2 | 0 |
229850 | 229850 | 2020-06-11 | Lake | Oregon | 41037 | 4 | 0 |
232955 | 232955 | 2020-06-12 | Lake | Oregon | 41037 | 4 | 0 |
236060 | 236060 | 2020-06-13 | Lake | Oregon | 41037 | 4 | 0 |
239168 | 239168 | 2020-06-14 | Lake | Oregon | 41037 | 4 | 0 |
242277 | 242277 | 2020-06-15 | Lake | Oregon | 41037 | 5 | 0 |
245389 | 245389 | 2020-06-16 | Lake | Oregon | 41037 | 5 | 0 |
248502 | 248502 | 2020-06-17 | Lake | Oregon | 41037 | 6 | 0 |
251617 | 251617 | 2020-06-18 | Lake | Oregon | 41037 | 6 | 0 |
254732 | 254732 | 2020-06-19 | Lake | Oregon | 41037 | 6 | 0 |
257858 | 257858 | 2020-06-20 | Lake | Oregon | 41037 | 6 | 0 |
260985 | 260985 | 2020-06-21 | Lake | Oregon | 41037 | 6 | 0 |
264113 | 264113 | 2020-06-22 | Lake | Oregon | 41037 | 6 | 0 |
267241 | 267241 | 2020-06-23 | Lake | Oregon | 41037 | 6 | 0 |
270375 | 270375 | 2020-06-24 | Lake | Oregon | 41037 | 6 | 0 |
273514 | 273514 | 2020-06-25 | Lake | Oregon | 41037 | 9 | 0 |
276661 | 276661 | 2020-06-26 | Lake | Oregon | 41037 | 12 | 0 |
279809 | 279809 | 2020-06-27 | Lake | Oregon | 41037 | 13 | 0 |
282955 | 282955 | 2020-06-28 | Lake | Oregon | 41037 | 13 | 0 |
286100 | 286100 | 2020-06-29 | Lake | Oregon | 41037 | 15 | 0 |
289251 | 289251 | 2020-06-30 | Lake | Oregon | 41037 | 17 | 0 |
292403 | 292403 | 2020-07-01 | Lake | Oregon | 41037 | 19 | 0 |
295559 | 295559 | 2020-07-02 | Lake | Oregon | 41037 | 19 | 0 |
298718 | 298718 | 2020-07-03 | Lake | Oregon | 41037 | 20 | 0 |
301882 | 301882 | 2020-07-04 | Lake | Oregon | 41037 | 21 | 0 |
305045 | 305045 | 2020-07-05 | Lake | Oregon | 41037 | 21 | 0 |
308212 | 308212 | 2020-07-06 | Lake | Oregon | 41037 | 21 | 0 |
311381 | 311381 | 2020-07-07 | Lake | Oregon | 41037 | 22 | 0 |
314553 | 314553 | 2020-07-08 | Lake | Oregon | 41037 | 22 | 0 |
317726 | 317726 | 2020-07-09 | Lake | Oregon | 41037 | 24 | 0 |
320904 | 320904 | 2020-07-10 | Lake | Oregon | 41037 | 24 | 0 |
324084 | 324084 | 2020-07-11 | Lake | Oregon | 41037 | 24 | 0 |
327269 | 327269 | 2020-07-12 | Lake | Oregon | 41037 | 24 | 0 |
330455 | 330455 | 2020-07-13 | Lake | Oregon | 41037 | 24 | 0 |
333647 | 333647 | 2020-07-14 | Lake | Oregon | 41037 | 24 | 0 |
336841 | 336841 | 2020-07-15 | Lake | Oregon | 41037 | 24 | 0 |
340038 | 340038 | 2020-07-16 | Lake | Oregon | 41037 | 24 | 0 |
343236 | 343236 | 2020-07-17 | Lake | Oregon | 41037 | 24 | 0 |
346436 | 346436 | 2020-07-18 | Lake | Oregon | 41037 | 27 | 0 |
349636 | 349636 | 2020-07-19 | Lake | Oregon | 41037 | 28 | 0 |
352839 | 352839 | 2020-07-20 | Lake | Oregon | 41037 | 29 | 0 |
356042 | 356042 | 2020-07-21 | Lake | Oregon | 41037 | 30 | 0 |
359246 | 359246 | 2020-07-22 | Lake | Oregon | 41037 | 30 | 0 |
362452 | 362452 | 2020-07-23 | Lake | Oregon | 41037 | 31 | 0 |
365658 | 365658 | 2020-07-24 | Lake | Oregon | 41037 | 31 | 0 |
368867 | 368867 | 2020-07-25 | Lake | Oregon | 41037 | 31 | 0 |
372079 | 372079 | 2020-07-26 | Lake | Oregon | 41037 | 31 | 0 |
375292 | 375292 | 2020-07-27 | Lake | Oregon | 41037 | 31 | 0 |
378508 | 378508 | 2020-07-28 | Lake | Oregon | 41037 | 31 | 0 |
381725 | 381725 | 2020-07-29 | Lake | Oregon | 41037 | 31 | 0 |
384943 | 384943 | 2020-07-30 | Lake | Oregon | 41037 | 32 | 0 |
388160 | 388160 | 2020-07-31 | Lake | Oregon | 41037 | 32 | 0 |
391377 | 391377 | 2020-08-01 | Lake | Oregon | 41037 | 32 | 0 |
394593 | 394593 | 2020-08-02 | Lake | Oregon | 41037 | 32 | 0 |
397810 | 397810 | 2020-08-03 | Lake | Oregon | 41037 | 32 | 0 |
401025 | 401025 | 2020-08-04 | Lake | Oregon | 41037 | 32 | 0 |
404243 | 404243 | 2020-08-05 | Lake | Oregon | 41037 | 32 | 0 |
407462 | 407462 | 2020-08-06 | Lake | Oregon | 41037 | 32 | 0 |
410682 | 410682 | 2020-08-07 | Lake | Oregon | 41037 | 32 | 0 |
413902 | 413902 | 2020-08-08 | Lake | Oregon | 41037 | 32 | 0 |
417123 | 417123 | 2020-08-09 | Lake | Oregon | 41037 | 32 | 0 |
420343 | 420343 | 2020-08-10 | Lake | Oregon | 41037 | 32 | 0 |
423566 | 423566 | 2020-08-11 | Lake | Oregon | 41037 | 32 | 0 |
426789 | 426789 | 2020-08-12 | Lake | Oregon | 41037 | 32 | 0 |
430014 | 430014 | 2020-08-13 | Lake | Oregon | 41037 | 32 | 0 |
433240 | 433240 | 2020-08-14 | Lake | Oregon | 41037 | 32 | 0 |
436467 | 436467 | 2020-08-15 | Lake | Oregon | 41037 | 32 | 0 |
439692 | 439692 | 2020-08-16 | Lake | Oregon | 41037 | 32 | 0 |
442919 | 442919 | 2020-08-17 | Lake | Oregon | 41037 | 32 | 0 |
446145 | 446145 | 2020-08-18 | Lake | Oregon | 41037 | 32 | 0 |
449373 | 449373 | 2020-08-19 | Lake | Oregon | 41037 | 32 | 0 |
452601 | 452601 | 2020-08-20 | Lake | Oregon | 41037 | 32 | 0 |
455829 | 455829 | 2020-08-21 | Lake | Oregon | 41037 | 32 | 0 |
459057 | 459057 | 2020-08-22 | Lake | Oregon | 41037 | 32 | 0 |
462285 | 462285 | 2020-08-23 | Lake | Oregon | 41037 | 32 | 0 |
465514 | 465514 | 2020-08-24 | Lake | Oregon | 41037 | 32 | 0 |
468742 | 468742 | 2020-08-25 | Lake | Oregon | 41037 | 32 | 0 |
471974 | 471974 | 2020-08-26 | Lake | Oregon | 41037 | 30 | 0 |
475208 | 475208 | 2020-08-27 | Lake | Oregon | 41037 | 30 | 0 |
478441 | 478441 | 2020-08-28 | Lake | Oregon | 41037 | 30 | 0 |
481675 | 481675 | 2020-08-29 | Lake | Oregon | 41037 | 30 | 0 |
484910 | 484910 | 2020-08-30 | Lake | Oregon | 41037 | 30 | 0 |
488143 | 488143 | 2020-08-31 | Lake | Oregon | 41037 | 30 | 0 |
491376 | 491376 | 2020-09-01 | Lake | Oregon | 41037 | 30 | 0 |
494610 | 494610 | 2020-09-02 | Lake | Oregon | 41037 | 29 | 0 |
497843 | 497843 | 2020-09-03 | Lake | Oregon | 41037 | 29 | 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);