ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 41013 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 |
---|---|---|---|---|---|---|---|
2501817 | 2501817 | 2022-05-13 | Crook | Oregon | 41013 | 6158 | 79 |
2498559 | 2498559 | 2022-05-12 | Crook | Oregon | 41013 | 6153 | 79 |
2495301 | 2495301 | 2022-05-11 | Crook | Oregon | 41013 | 6146 | 79 |
2492043 | 2492043 | 2022-05-10 | Crook | Oregon | 41013 | 6144 | 79 |
2488785 | 2488785 | 2022-05-09 | Crook | Oregon | 41013 | 6137 | 79 |
2485528 | 2485528 | 2022-05-08 | Crook | Oregon | 41013 | 6132 | 79 |
2482270 | 2482270 | 2022-05-07 | Crook | Oregon | 41013 | 6132 | 79 |
2479012 | 2479012 | 2022-05-06 | Crook | Oregon | 41013 | 6132 | 79 |
2475754 | 2475754 | 2022-05-05 | Crook | Oregon | 41013 | 6123 | 79 |
2472497 | 2472497 | 2022-05-04 | Crook | Oregon | 41013 | 6121 | 79 |
2469241 | 2469241 | 2022-05-03 | Crook | Oregon | 41013 | 6118 | 79 |
2465985 | 2465985 | 2022-05-02 | Crook | Oregon | 41013 | 6094 | 79 |
2462730 | 2462730 | 2022-05-01 | Crook | Oregon | 41013 | 6086 | 79 |
2459474 | 2459474 | 2022-04-30 | Crook | Oregon | 41013 | 6086 | 79 |
2456218 | 2456218 | 2022-04-29 | Crook | Oregon | 41013 | 6086 | 79 |
2452962 | 2452962 | 2022-04-28 | Crook | Oregon | 41013 | 6081 | 79 |
2449706 | 2449706 | 2022-04-27 | Crook | Oregon | 41013 | 6076 | 79 |
2446449 | 2446449 | 2022-04-26 | Crook | Oregon | 41013 | 6074 | 79 |
2443194 | 2443194 | 2022-04-25 | Crook | Oregon | 41013 | 6071 | 79 |
2439938 | 2439938 | 2022-04-24 | Crook | Oregon | 41013 | 6061 | 79 |
2436682 | 2436682 | 2022-04-23 | Crook | Oregon | 41013 | 6061 | 79 |
2433426 | 2433426 | 2022-04-22 | Crook | Oregon | 41013 | 6061 | 79 |
2430170 | 2430170 | 2022-04-21 | Crook | Oregon | 41013 | 6060 | 79 |
2426914 | 2426914 | 2022-04-20 | Crook | Oregon | 41013 | 6054 | 79 |
2423658 | 2423658 | 2022-04-19 | Crook | Oregon | 41013 | 6053 | 79 |
2420401 | 2420401 | 2022-04-18 | Crook | Oregon | 41013 | 6048 | 79 |
2417146 | 2417146 | 2022-04-17 | Crook | Oregon | 41013 | 6048 | 79 |
2413890 | 2413890 | 2022-04-16 | Crook | Oregon | 41013 | 6048 | 79 |
2410634 | 2410634 | 2022-04-15 | Crook | Oregon | 41013 | 6048 | 79 |
2407378 | 2407378 | 2022-04-14 | Crook | Oregon | 41013 | 6046 | 79 |
2404122 | 2404122 | 2022-04-13 | Crook | Oregon | 41013 | 6046 | 79 |
2400867 | 2400867 | 2022-04-12 | Crook | Oregon | 41013 | 6044 | 79 |
2397612 | 2397612 | 2022-04-11 | Crook | Oregon | 41013 | 6044 | 77 |
2394357 | 2394357 | 2022-04-10 | Crook | Oregon | 41013 | 6040 | 77 |
2391101 | 2391101 | 2022-04-09 | Crook | Oregon | 41013 | 6040 | 77 |
2387845 | 2387845 | 2022-04-08 | Crook | Oregon | 41013 | 6040 | 77 |
2384590 | 2384590 | 2022-04-07 | Crook | Oregon | 41013 | 6039 | 77 |
2381335 | 2381335 | 2022-04-06 | Crook | Oregon | 41013 | 6038 | 77 |
2378080 | 2378080 | 2022-04-05 | Crook | Oregon | 41013 | 6037 | 77 |
2374826 | 2374826 | 2022-04-04 | Crook | Oregon | 41013 | 6037 | 77 |
2371574 | 2371574 | 2022-04-03 | Crook | Oregon | 41013 | 6036 | 77 |
2368321 | 2368321 | 2022-04-02 | Crook | Oregon | 41013 | 6036 | 77 |
2365068 | 2365068 | 2022-04-01 | Crook | Oregon | 41013 | 6036 | 77 |
2361815 | 2361815 | 2022-03-31 | Crook | Oregon | 41013 | 6036 | 77 |
2358561 | 2358561 | 2022-03-30 | Crook | Oregon | 41013 | 6035 | 77 |
2355307 | 2355307 | 2022-03-29 | Crook | Oregon | 41013 | 6036 | 77 |
2352054 | 2352054 | 2022-03-28 | Crook | Oregon | 41013 | 6034 | 77 |
2348802 | 2348802 | 2022-03-27 | Crook | Oregon | 41013 | 6033 | 77 |
2345549 | 2345549 | 2022-03-26 | Crook | Oregon | 41013 | 6033 | 77 |
2342296 | 2342296 | 2022-03-25 | Crook | Oregon | 41013 | 6033 | 77 |
2339043 | 2339043 | 2022-03-24 | Crook | Oregon | 41013 | 6032 | 77 |
2335789 | 2335789 | 2022-03-23 | Crook | Oregon | 41013 | 6031 | 77 |
2332535 | 2332535 | 2022-03-22 | Crook | Oregon | 41013 | 6031 | 77 |
2329282 | 2329282 | 2022-03-21 | Crook | Oregon | 41013 | 6031 | 77 |
2326030 | 2326030 | 2022-03-20 | Crook | Oregon | 41013 | 6029 | 77 |
2322777 | 2322777 | 2022-03-19 | Crook | Oregon | 41013 | 6029 | 77 |
2319523 | 2319523 | 2022-03-18 | Crook | Oregon | 41013 | 6029 | 77 |
2316269 | 2316269 | 2022-03-17 | Crook | Oregon | 41013 | 6027 | 77 |
2313016 | 2313016 | 2022-03-16 | Crook | Oregon | 41013 | 6024 | 77 |
2309763 | 2309763 | 2022-03-15 | Crook | Oregon | 41013 | 6023 | 77 |
2306510 | 2306510 | 2022-03-14 | Crook | Oregon | 41013 | 6021 | 77 |
2303259 | 2303259 | 2022-03-13 | Crook | Oregon | 41013 | 6019 | 77 |
2300007 | 2300007 | 2022-03-12 | Crook | Oregon | 41013 | 6019 | 77 |
2296755 | 2296755 | 2022-03-11 | Crook | Oregon | 41013 | 6019 | 77 |
2293503 | 2293503 | 2022-03-10 | Crook | Oregon | 41013 | 6014 | 77 |
2290251 | 2290251 | 2022-03-09 | Crook | Oregon | 41013 | 6010 | 77 |
2286999 | 2286999 | 2022-03-08 | Crook | Oregon | 41013 | 6007 | 77 |
2283747 | 2283747 | 2022-03-07 | Crook | Oregon | 41013 | 6001 | 76 |
2280495 | 2280495 | 2022-03-06 | Crook | Oregon | 41013 | 5995 | 76 |
2277242 | 2277242 | 2022-03-05 | Crook | Oregon | 41013 | 5995 | 76 |
2273989 | 2273989 | 2022-03-04 | Crook | Oregon | 41013 | 5995 | 76 |
2270736 | 2270736 | 2022-03-03 | Crook | Oregon | 41013 | 5987 | 76 |
2267484 | 2267484 | 2022-03-02 | Crook | Oregon | 41013 | 5984 | 74 |
2264231 | 2264231 | 2022-03-01 | Crook | Oregon | 41013 | 5974 | 74 |
2260981 | 2260981 | 2022-02-28 | Crook | Oregon | 41013 | 5967 | 74 |
2257730 | 2257730 | 2022-02-27 | Crook | Oregon | 41013 | 5957 | 74 |
2254479 | 2254479 | 2022-02-26 | Crook | Oregon | 41013 | 5957 | 74 |
2251228 | 2251228 | 2022-02-25 | Crook | Oregon | 41013 | 5957 | 74 |
2247977 | 2247977 | 2022-02-24 | Crook | Oregon | 41013 | 5952 | 72 |
2244726 | 2244726 | 2022-02-23 | Crook | Oregon | 41013 | 5945 | 69 |
2241475 | 2241475 | 2022-02-22 | Crook | Oregon | 41013 | 5932 | 69 |
2238224 | 2238224 | 2022-02-21 | Crook | Oregon | 41013 | 5910 | 69 |
2234973 | 2234973 | 2022-02-20 | Crook | Oregon | 41013 | 5910 | 69 |
2231722 | 2231722 | 2022-02-19 | Crook | Oregon | 41013 | 5910 | 69 |
2228471 | 2228471 | 2022-02-18 | Crook | Oregon | 41013 | 5910 | 69 |
2225220 | 2225220 | 2022-02-17 | Crook | Oregon | 41013 | 5900 | 68 |
2221969 | 2221969 | 2022-02-16 | Crook | Oregon | 41013 | 5879 | 68 |
2218718 | 2218718 | 2022-02-15 | Crook | Oregon | 41013 | 5867 | 68 |
2215467 | 2215467 | 2022-02-14 | Crook | Oregon | 41013 | 5849 | 68 |
2212216 | 2212216 | 2022-02-13 | Crook | Oregon | 41013 | 5794 | 68 |
2208963 | 2208963 | 2022-02-12 | Crook | Oregon | 41013 | 5794 | 68 |
2205710 | 2205710 | 2022-02-11 | Crook | Oregon | 41013 | 5794 | 68 |
2202457 | 2202457 | 2022-02-10 | Crook | Oregon | 41013 | 5765 | 66 |
2199203 | 2199203 | 2022-02-09 | Crook | Oregon | 41013 | 5728 | 65 |
2195949 | 2195949 | 2022-02-08 | Crook | Oregon | 41013 | 5697 | 65 |
2192695 | 2192695 | 2022-02-07 | Crook | Oregon | 41013 | 5658 | 64 |
2189441 | 2189441 | 2022-02-06 | Crook | Oregon | 41013 | 5568 | 64 |
2186188 | 2186188 | 2022-02-05 | Crook | Oregon | 41013 | 5568 | 64 |
2182936 | 2182936 | 2022-02-04 | Crook | Oregon | 41013 | 5568 | 64 |
2179684 | 2179684 | 2022-02-03 | Crook | Oregon | 41013 | 5527 | 64 |
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);