ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lane" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501830 | 2501830 | 2022-05-13 | Lane | Oregon | 41039 | 59853 | 541 |
2498572 | 2498572 | 2022-05-12 | Lane | Oregon | 41039 | 59691 | 540 |
2495314 | 2495314 | 2022-05-11 | Lane | Oregon | 41039 | 59524 | 540 |
2492056 | 2492056 | 2022-05-10 | Lane | Oregon | 41039 | 59436 | 540 |
2488798 | 2488798 | 2022-05-09 | Lane | Oregon | 41039 | 59275 | 540 |
2485541 | 2485541 | 2022-05-08 | Lane | Oregon | 41039 | 59006 | 538 |
2482283 | 2482283 | 2022-05-07 | Lane | Oregon | 41039 | 59006 | 538 |
2479025 | 2479025 | 2022-05-06 | Lane | Oregon | 41039 | 59006 | 538 |
2475767 | 2475767 | 2022-05-05 | Lane | Oregon | 41039 | 58928 | 538 |
2472510 | 2472510 | 2022-05-04 | Lane | Oregon | 41039 | 58797 | 538 |
2469254 | 2469254 | 2022-05-03 | Lane | Oregon | 41039 | 58677 | 535 |
2465998 | 2465998 | 2022-05-02 | Lane | Oregon | 41039 | 58544 | 533 |
2462743 | 2462743 | 2022-05-01 | Lane | Oregon | 41039 | 58401 | 533 |
2459487 | 2459487 | 2022-04-30 | Lane | Oregon | 41039 | 58401 | 533 |
2456231 | 2456231 | 2022-04-29 | Lane | Oregon | 41039 | 58401 | 533 |
2452975 | 2452975 | 2022-04-28 | Lane | Oregon | 41039 | 58326 | 533 |
2449719 | 2449719 | 2022-04-27 | Lane | Oregon | 41039 | 58215 | 532 |
2446462 | 2446462 | 2022-04-26 | Lane | Oregon | 41039 | 58150 | 532 |
2443207 | 2443207 | 2022-04-25 | Lane | Oregon | 41039 | 58057 | 532 |
2439951 | 2439951 | 2022-04-24 | Lane | Oregon | 41039 | 57879 | 532 |
2436695 | 2436695 | 2022-04-23 | Lane | Oregon | 41039 | 57879 | 532 |
2433439 | 2433439 | 2022-04-22 | Lane | Oregon | 41039 | 57879 | 532 |
2430183 | 2430183 | 2022-04-21 | Lane | Oregon | 41039 | 57841 | 532 |
2426927 | 2426927 | 2022-04-20 | Lane | Oregon | 41039 | 57790 | 532 |
2423671 | 2423671 | 2022-04-19 | Lane | Oregon | 41039 | 57730 | 531 |
2420414 | 2420414 | 2022-04-18 | Lane | Oregon | 41039 | 57555 | 531 |
2417159 | 2417159 | 2022-04-17 | Lane | Oregon | 41039 | 57555 | 531 |
2413903 | 2413903 | 2022-04-16 | Lane | Oregon | 41039 | 57555 | 531 |
2410647 | 2410647 | 2022-04-15 | Lane | Oregon | 41039 | 57555 | 531 |
2407391 | 2407391 | 2022-04-14 | Lane | Oregon | 41039 | 57524 | 529 |
2404135 | 2404135 | 2022-04-13 | Lane | Oregon | 41039 | 57490 | 524 |
2400880 | 2400880 | 2022-04-12 | Lane | Oregon | 41039 | 57456 | 524 |
2397625 | 2397625 | 2022-04-11 | Lane | Oregon | 41039 | 57421 | 516 |
2394370 | 2394370 | 2022-04-10 | Lane | Oregon | 41039 | 57373 | 514 |
2391114 | 2391114 | 2022-04-09 | Lane | Oregon | 41039 | 57373 | 514 |
2387858 | 2387858 | 2022-04-08 | Lane | Oregon | 41039 | 57373 | 514 |
2384603 | 2384603 | 2022-04-07 | Lane | Oregon | 41039 | 57344 | 514 |
2381348 | 2381348 | 2022-04-06 | Lane | Oregon | 41039 | 57317 | 508 |
2378093 | 2378093 | 2022-04-05 | Lane | Oregon | 41039 | 57292 | 508 |
2374839 | 2374839 | 2022-04-04 | Lane | Oregon | 41039 | 57274 | 508 |
2371587 | 2371587 | 2022-04-03 | Lane | Oregon | 41039 | 57237 | 502 |
2368334 | 2368334 | 2022-04-02 | Lane | Oregon | 41039 | 57237 | 502 |
2365081 | 2365081 | 2022-04-01 | Lane | Oregon | 41039 | 57237 | 502 |
2361828 | 2361828 | 2022-03-31 | Lane | Oregon | 41039 | 57201 | 501 |
2358574 | 2358574 | 2022-03-30 | Lane | Oregon | 41039 | 57165 | 501 |
2355320 | 2355320 | 2022-03-29 | Lane | Oregon | 41039 | 57133 | 500 |
2352067 | 2352067 | 2022-03-28 | Lane | Oregon | 41039 | 57100 | 498 |
2348815 | 2348815 | 2022-03-27 | Lane | Oregon | 41039 | 57039 | 496 |
2345562 | 2345562 | 2022-03-26 | Lane | Oregon | 41039 | 57039 | 496 |
2342309 | 2342309 | 2022-03-25 | Lane | Oregon | 41039 | 57039 | 496 |
2339056 | 2339056 | 2022-03-24 | Lane | Oregon | 41039 | 57027 | 496 |
2335802 | 2335802 | 2022-03-23 | Lane | Oregon | 41039 | 56995 | 495 |
2332548 | 2332548 | 2022-03-22 | Lane | Oregon | 41039 | 56970 | 492 |
2329295 | 2329295 | 2022-03-21 | Lane | Oregon | 41039 | 56928 | 490 |
2326043 | 2326043 | 2022-03-20 | Lane | Oregon | 41039 | 56882 | 490 |
2322790 | 2322790 | 2022-03-19 | Lane | Oregon | 41039 | 56882 | 490 |
2319536 | 2319536 | 2022-03-18 | Lane | Oregon | 41039 | 56882 | 490 |
2316282 | 2316282 | 2022-03-17 | Lane | Oregon | 41039 | 56859 | 489 |
2313029 | 2313029 | 2022-03-16 | Lane | Oregon | 41039 | 56827 | 486 |
2309776 | 2309776 | 2022-03-15 | Lane | Oregon | 41039 | 56801 | 485 |
2306523 | 2306523 | 2022-03-14 | Lane | Oregon | 41039 | 56756 | 484 |
2303272 | 2303272 | 2022-03-13 | Lane | Oregon | 41039 | 56677 | 480 |
2300020 | 2300020 | 2022-03-12 | Lane | Oregon | 41039 | 56677 | 480 |
2296768 | 2296768 | 2022-03-11 | Lane | Oregon | 41039 | 56677 | 480 |
2293516 | 2293516 | 2022-03-10 | Lane | Oregon | 41039 | 56646 | 477 |
2290264 | 2290264 | 2022-03-09 | Lane | Oregon | 41039 | 56610 | 475 |
2287012 | 2287012 | 2022-03-08 | Lane | Oregon | 41039 | 56566 | 475 |
2283760 | 2283760 | 2022-03-07 | Lane | Oregon | 41039 | 56538 | 472 |
2280508 | 2280508 | 2022-03-06 | Lane | Oregon | 41039 | 56436 | 471 |
2277255 | 2277255 | 2022-03-05 | Lane | Oregon | 41039 | 56436 | 471 |
2274002 | 2274002 | 2022-03-04 | Lane | Oregon | 41039 | 56436 | 471 |
2270749 | 2270749 | 2022-03-03 | Lane | Oregon | 41039 | 56362 | 470 |
2267497 | 2267497 | 2022-03-02 | Lane | Oregon | 41039 | 56307 | 465 |
2264244 | 2264244 | 2022-03-01 | Lane | Oregon | 41039 | 56239 | 465 |
2260994 | 2260994 | 2022-02-28 | Lane | Oregon | 41039 | 56178 | 464 |
2257743 | 2257743 | 2022-02-27 | Lane | Oregon | 41039 | 56044 | 457 |
2254492 | 2254492 | 2022-02-26 | Lane | Oregon | 41039 | 56044 | 457 |
2251241 | 2251241 | 2022-02-25 | Lane | Oregon | 41039 | 56044 | 457 |
2247990 | 2247990 | 2022-02-24 | Lane | Oregon | 41039 | 55957 | 457 |
2244739 | 2244739 | 2022-02-23 | Lane | Oregon | 41039 | 55906 | 453 |
2241488 | 2241488 | 2022-02-22 | Lane | Oregon | 41039 | 55821 | 447 |
2238237 | 2238237 | 2022-02-21 | Lane | Oregon | 41039 | 55461 | 446 |
2234986 | 2234986 | 2022-02-20 | Lane | Oregon | 41039 | 55461 | 446 |
2231735 | 2231735 | 2022-02-19 | Lane | Oregon | 41039 | 55461 | 446 |
2228484 | 2228484 | 2022-02-18 | Lane | Oregon | 41039 | 55461 | 446 |
2225233 | 2225233 | 2022-02-17 | Lane | Oregon | 41039 | 55280 | 445 |
2221982 | 2221982 | 2022-02-16 | Lane | Oregon | 41039 | 55088 | 444 |
2218731 | 2218731 | 2022-02-15 | Lane | Oregon | 41039 | 54876 | 443 |
2215480 | 2215480 | 2022-02-14 | Lane | Oregon | 41039 | 54711 | 435 |
2212229 | 2212229 | 2022-02-13 | Lane | Oregon | 41039 | 54133 | 431 |
2208976 | 2208976 | 2022-02-12 | Lane | Oregon | 41039 | 54133 | 431 |
2205723 | 2205723 | 2022-02-11 | Lane | Oregon | 41039 | 54133 | 431 |
2202470 | 2202470 | 2022-02-10 | Lane | Oregon | 41039 | 53870 | 431 |
2199216 | 2199216 | 2022-02-09 | Lane | Oregon | 41039 | 53603 | 430 |
2195962 | 2195962 | 2022-02-08 | Lane | Oregon | 41039 | 53223 | 428 |
2192708 | 2192708 | 2022-02-07 | Lane | Oregon | 41039 | 52905 | 424 |
2189454 | 2189454 | 2022-02-06 | Lane | Oregon | 41039 | 52131 | 420 |
2186201 | 2186201 | 2022-02-05 | Lane | Oregon | 41039 | 52131 | 420 |
2182949 | 2182949 | 2022-02-04 | Lane | Oregon | 41039 | 52131 | 420 |
2179697 | 2179697 | 2022-02-03 | Lane | Oregon | 41039 | 51614 | 418 |
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);