ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Yamhill" 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 |
---|---|---|---|---|---|---|---|
2628 | 2628 | 2020-03-15 | Yamhill | Oregon | 41071 | 1 | 0 |
3093 | 3093 | 2020-03-16 | Yamhill | Oregon | 41071 | 1 | 0 |
3622 | 3622 | 2020-03-17 | Yamhill | Oregon | 41071 | 1 | 0 |
4237 | 4237 | 2020-03-18 | Yamhill | Oregon | 41071 | 2 | 0 |
4976 | 4976 | 2020-03-19 | Yamhill | Oregon | 41071 | 2 | 0 |
5845 | 5845 | 2020-03-20 | Yamhill | Oregon | 41071 | 4 | 0 |
6847 | 6847 | 2020-03-21 | Yamhill | Oregon | 41071 | 4 | 0 |
7962 | 7962 | 2020-03-22 | Yamhill | Oregon | 41071 | 6 | 0 |
9172 | 9172 | 2020-03-23 | Yamhill | Oregon | 41071 | 6 | 0 |
10491 | 10491 | 2020-03-24 | Yamhill | Oregon | 41071 | 6 | 0 |
11953 | 11953 | 2020-03-25 | Yamhill | Oregon | 41071 | 7 | 0 |
13571 | 13571 | 2020-03-26 | Yamhill | Oregon | 41071 | 7 | 0 |
15317 | 15317 | 2020-03-27 | Yamhill | Oregon | 41071 | 11 | 0 |
17164 | 17164 | 2020-03-28 | Yamhill | Oregon | 41071 | 13 | 1 |
19102 | 19102 | 2020-03-29 | Yamhill | Oregon | 41071 | 13 | 1 |
21152 | 21152 | 2020-03-30 | Yamhill | Oregon | 41071 | 14 | 2 |
23287 | 23287 | 2020-03-31 | Yamhill | Oregon | 41071 | 16 | 3 |
25485 | 25485 | 2020-04-01 | Yamhill | Oregon | 41071 | 17 | 3 |
27757 | 27757 | 2020-04-02 | Yamhill | Oregon | 41071 | 18 | 3 |
30090 | 30090 | 2020-04-03 | Yamhill | Oregon | 41071 | 23 | 3 |
32480 | 32480 | 2020-04-04 | Yamhill | Oregon | 41071 | 23 | 3 |
34915 | 34915 | 2020-04-05 | Yamhill | Oregon | 41071 | 26 | 3 |
37390 | 37390 | 2020-04-06 | Yamhill | Oregon | 41071 | 25 | 3 |
39911 | 39911 | 2020-04-07 | Yamhill | Oregon | 41071 | 25 | 3 |
42471 | 42471 | 2020-04-08 | Yamhill | Oregon | 41071 | 25 | 5 |
45057 | 45057 | 2020-04-09 | Yamhill | Oregon | 41071 | 29 | 5 |
47674 | 47674 | 2020-04-10 | Yamhill | Oregon | 41071 | 28 | 5 |
50331 | 50331 | 2020-04-11 | Yamhill | Oregon | 41071 | 30 | 6 |
53004 | 53004 | 2020-04-12 | Yamhill | Oregon | 41071 | 30 | 6 |
55689 | 55689 | 2020-04-13 | Yamhill | Oregon | 41071 | 30 | 6 |
58392 | 58392 | 2020-04-14 | Yamhill | Oregon | 41071 | 32 | 6 |
61107 | 61107 | 2020-04-15 | Yamhill | Oregon | 41071 | 32 | 6 |
63833 | 63833 | 2020-04-16 | Yamhill | Oregon | 41071 | 33 | 6 |
66579 | 66579 | 2020-04-17 | Yamhill | Oregon | 41071 | 35 | 6 |
69337 | 69337 | 2020-04-18 | Yamhill | Oregon | 41071 | 34 | 6 |
72104 | 72104 | 2020-04-19 | Yamhill | Oregon | 41071 | 34 | 6 |
74879 | 74879 | 2020-04-20 | Yamhill | Oregon | 41071 | 35 | 6 |
77661 | 77661 | 2020-04-21 | Yamhill | Oregon | 41071 | 34 | 6 |
80451 | 80451 | 2020-04-22 | Yamhill | Oregon | 41071 | 35 | 6 |
83250 | 83250 | 2020-04-23 | Yamhill | Oregon | 41071 | 35 | 6 |
86054 | 86054 | 2020-04-24 | Yamhill | Oregon | 41071 | 35 | 6 |
88868 | 88868 | 2020-04-25 | Yamhill | Oregon | 41071 | 35 | 6 |
91684 | 91684 | 2020-04-26 | Yamhill | Oregon | 41071 | 36 | 6 |
94511 | 94511 | 2020-04-27 | Yamhill | Oregon | 41071 | 37 | 6 |
97350 | 97350 | 2020-04-28 | Yamhill | Oregon | 41071 | 38 | 7 |
100199 | 100199 | 2020-04-29 | Yamhill | Oregon | 41071 | 39 | 7 |
103052 | 103052 | 2020-04-30 | Yamhill | Oregon | 41071 | 39 | 7 |
105915 | 105915 | 2020-05-01 | Yamhill | Oregon | 41071 | 39 | 7 |
108782 | 108782 | 2020-05-02 | Yamhill | Oregon | 41071 | 39 | 7 |
111656 | 111656 | 2020-05-03 | Yamhill | Oregon | 41071 | 39 | 7 |
114538 | 114538 | 2020-05-04 | Yamhill | Oregon | 41071 | 40 | 7 |
117419 | 117419 | 2020-05-05 | Yamhill | Oregon | 41071 | 41 | 7 |
120381 | 120381 | 2020-05-06 | Yamhill | Oregon | 41071 | 42 | 7 |
123358 | 123358 | 2020-05-07 | Yamhill | Oregon | 41071 | 45 | 7 |
126341 | 126341 | 2020-05-08 | Yamhill | Oregon | 41071 | 45 | 7 |
129330 | 129330 | 2020-05-09 | Yamhill | Oregon | 41071 | 47 | 7 |
132319 | 132319 | 2020-05-10 | Yamhill | Oregon | 41071 | 49 | 7 |
135310 | 135310 | 2020-05-11 | Yamhill | Oregon | 41071 | 49 | 7 |
138300 | 138300 | 2020-05-12 | Yamhill | Oregon | 41071 | 50 | 7 |
141296 | 141296 | 2020-05-13 | Yamhill | Oregon | 41071 | 50 | 7 |
144292 | 144292 | 2020-05-14 | Yamhill | Oregon | 41071 | 55 | 7 |
147293 | 147293 | 2020-05-15 | Yamhill | Oregon | 41071 | 55 | 7 |
150300 | 150300 | 2020-05-16 | Yamhill | Oregon | 41071 | 57 | 7 |
153311 | 153311 | 2020-05-17 | Yamhill | Oregon | 41071 | 57 | 7 |
156328 | 156328 | 2020-05-18 | Yamhill | Oregon | 41071 | 59 | 7 |
159349 | 159349 | 2020-05-19 | Yamhill | Oregon | 41071 | 62 | 7 |
162376 | 162376 | 2020-05-20 | Yamhill | Oregon | 41071 | 63 | 7 |
165405 | 165405 | 2020-05-21 | Yamhill | Oregon | 41071 | 63 | 7 |
168441 | 168441 | 2020-05-22 | Yamhill | Oregon | 41071 | 63 | 7 |
171480 | 171480 | 2020-05-23 | Yamhill | Oregon | 41071 | 64 | 7 |
174522 | 174522 | 2020-05-24 | Yamhill | Oregon | 41071 | 65 | 7 |
177566 | 177566 | 2020-05-25 | Yamhill | Oregon | 41071 | 65 | 7 |
180609 | 180609 | 2020-05-26 | Yamhill | Oregon | 41071 | 66 | 7 |
183659 | 183659 | 2020-05-27 | Yamhill | Oregon | 41071 | 67 | 7 |
186716 | 186716 | 2020-05-28 | Yamhill | Oregon | 41071 | 69 | 7 |
189777 | 189777 | 2020-05-29 | Yamhill | Oregon | 41071 | 69 | 7 |
192842 | 192842 | 2020-05-30 | Yamhill | Oregon | 41071 | 69 | 7 |
195911 | 195911 | 2020-05-31 | Yamhill | Oregon | 41071 | 70 | 7 |
198984 | 198984 | 2020-06-01 | Yamhill | Oregon | 41071 | 70 | 7 |
202059 | 202059 | 2020-06-02 | Yamhill | Oregon | 41071 | 70 | 7 |
205136 | 205136 | 2020-06-03 | Yamhill | Oregon | 41071 | 74 | 7 |
208217 | 208217 | 2020-06-04 | Yamhill | Oregon | 41071 | 75 | 7 |
211299 | 211299 | 2020-06-05 | Yamhill | Oregon | 41071 | 81 | 7 |
214385 | 214385 | 2020-06-06 | Yamhill | Oregon | 41071 | 83 | 7 |
217475 | 217475 | 2020-06-07 | Yamhill | Oregon | 41071 | 85 | 7 |
220567 | 220567 | 2020-06-08 | Yamhill | Oregon | 41071 | 87 | 7 |
223662 | 223662 | 2020-06-09 | Yamhill | Oregon | 41071 | 91 | 7 |
226762 | 226762 | 2020-06-10 | Yamhill | Oregon | 41071 | 91 | 7 |
229866 | 229866 | 2020-06-11 | Yamhill | Oregon | 41071 | 92 | 8 |
232971 | 232971 | 2020-06-12 | Yamhill | Oregon | 41071 | 92 | 8 |
236076 | 236076 | 2020-06-13 | Yamhill | Oregon | 41071 | 92 | 8 |
239184 | 239184 | 2020-06-14 | Yamhill | Oregon | 41071 | 92 | 8 |
242293 | 242293 | 2020-06-15 | Yamhill | Oregon | 41071 | 93 | 8 |
245405 | 245405 | 2020-06-16 | Yamhill | Oregon | 41071 | 94 | 8 |
248518 | 248518 | 2020-06-17 | Yamhill | Oregon | 41071 | 94 | 8 |
251633 | 251633 | 2020-06-18 | Yamhill | Oregon | 41071 | 97 | 8 |
254748 | 254748 | 2020-06-19 | Yamhill | Oregon | 41071 | 97 | 8 |
257874 | 257874 | 2020-06-20 | Yamhill | Oregon | 41071 | 97 | 8 |
261001 | 261001 | 2020-06-21 | Yamhill | Oregon | 41071 | 99 | 8 |
264129 | 264129 | 2020-06-22 | Yamhill | Oregon | 41071 | 101 | 8 |
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);