ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Crook" and state = "Oregon" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
30068 | 30068 | 2020-04-03 | Crook | Oregon | 41013 | 1 | 0 |
32458 | 32458 | 2020-04-04 | Crook | Oregon | 41013 | 1 | 0 |
34892 | 34892 | 2020-04-05 | Crook | Oregon | 41013 | 1 | 0 |
37366 | 37366 | 2020-04-06 | Crook | Oregon | 41013 | 1 | 0 |
39887 | 39887 | 2020-04-07 | Crook | Oregon | 41013 | 1 | 0 |
42447 | 42447 | 2020-04-08 | Crook | Oregon | 41013 | 1 | 0 |
45033 | 45033 | 2020-04-09 | Crook | Oregon | 41013 | 1 | 0 |
47650 | 47650 | 2020-04-10 | Crook | Oregon | 41013 | 1 | 0 |
50307 | 50307 | 2020-04-11 | Crook | Oregon | 41013 | 1 | 0 |
52980 | 52980 | 2020-04-12 | Crook | Oregon | 41013 | 1 | 0 |
55665 | 55665 | 2020-04-13 | Crook | Oregon | 41013 | 1 | 0 |
58367 | 58367 | 2020-04-14 | Crook | Oregon | 41013 | 1 | 0 |
61082 | 61082 | 2020-04-15 | Crook | Oregon | 41013 | 1 | 0 |
63808 | 63808 | 2020-04-16 | Crook | Oregon | 41013 | 1 | 0 |
66554 | 66554 | 2020-04-17 | Crook | Oregon | 41013 | 1 | 0 |
69312 | 69312 | 2020-04-18 | Crook | Oregon | 41013 | 1 | 0 |
72079 | 72079 | 2020-04-19 | Crook | Oregon | 41013 | 1 | 0 |
74854 | 74854 | 2020-04-20 | Crook | Oregon | 41013 | 1 | 0 |
77636 | 77636 | 2020-04-21 | Crook | Oregon | 41013 | 1 | 0 |
80426 | 80426 | 2020-04-22 | Crook | Oregon | 41013 | 1 | 0 |
83225 | 83225 | 2020-04-23 | Crook | Oregon | 41013 | 1 | 0 |
86029 | 86029 | 2020-04-24 | Crook | Oregon | 41013 | 1 | 0 |
88843 | 88843 | 2020-04-25 | Crook | Oregon | 41013 | 1 | 0 |
91659 | 91659 | 2020-04-26 | Crook | Oregon | 41013 | 1 | 0 |
94486 | 94486 | 2020-04-27 | Crook | Oregon | 41013 | 1 | 0 |
97324 | 97324 | 2020-04-28 | Crook | Oregon | 41013 | 1 | 0 |
100173 | 100173 | 2020-04-29 | Crook | Oregon | 41013 | 1 | 0 |
103026 | 103026 | 2020-04-30 | Crook | Oregon | 41013 | 1 | 0 |
105889 | 105889 | 2020-05-01 | Crook | Oregon | 41013 | 1 | 0 |
108756 | 108756 | 2020-05-02 | Crook | Oregon | 41013 | 1 | 0 |
111630 | 111630 | 2020-05-03 | Crook | Oregon | 41013 | 1 | 0 |
114512 | 114512 | 2020-05-04 | Crook | Oregon | 41013 | 1 | 0 |
117393 | 117393 | 2020-05-05 | Crook | Oregon | 41013 | 1 | 0 |
120355 | 120355 | 2020-05-06 | Crook | Oregon | 41013 | 1 | 0 |
123332 | 123332 | 2020-05-07 | Crook | Oregon | 41013 | 1 | 0 |
126315 | 126315 | 2020-05-08 | Crook | Oregon | 41013 | 1 | 0 |
129304 | 129304 | 2020-05-09 | Crook | Oregon | 41013 | 1 | 0 |
132293 | 132293 | 2020-05-10 | Crook | Oregon | 41013 | 1 | 0 |
135284 | 135284 | 2020-05-11 | Crook | Oregon | 41013 | 1 | 0 |
138274 | 138274 | 2020-05-12 | Crook | Oregon | 41013 | 1 | 0 |
141270 | 141270 | 2020-05-13 | Crook | Oregon | 41013 | 1 | 0 |
144266 | 144266 | 2020-05-14 | Crook | Oregon | 41013 | 1 | 0 |
147267 | 147267 | 2020-05-15 | Crook | Oregon | 41013 | 1 | 0 |
150274 | 150274 | 2020-05-16 | Crook | Oregon | 41013 | 1 | 0 |
153285 | 153285 | 2020-05-17 | Crook | Oregon | 41013 | 1 | 0 |
156302 | 156302 | 2020-05-18 | Crook | Oregon | 41013 | 1 | 0 |
159323 | 159323 | 2020-05-19 | Crook | Oregon | 41013 | 1 | 0 |
162350 | 162350 | 2020-05-20 | Crook | Oregon | 41013 | 1 | 0 |
165379 | 165379 | 2020-05-21 | Crook | Oregon | 41013 | 1 | 0 |
168415 | 168415 | 2020-05-22 | Crook | Oregon | 41013 | 1 | 0 |
171454 | 171454 | 2020-05-23 | Crook | Oregon | 41013 | 4 | 0 |
174496 | 174496 | 2020-05-24 | Crook | Oregon | 41013 | 5 | 0 |
177540 | 177540 | 2020-05-25 | Crook | Oregon | 41013 | 5 | 0 |
180583 | 180583 | 2020-05-26 | Crook | Oregon | 41013 | 6 | 0 |
183632 | 183632 | 2020-05-27 | Crook | Oregon | 41013 | 6 | 0 |
186689 | 186689 | 2020-05-28 | Crook | Oregon | 41013 | 6 | 0 |
189750 | 189750 | 2020-05-29 | Crook | Oregon | 41013 | 6 | 0 |
192815 | 192815 | 2020-05-30 | Crook | Oregon | 41013 | 6 | 0 |
195884 | 195884 | 2020-05-31 | Crook | Oregon | 41013 | 6 | 0 |
198957 | 198957 | 2020-06-01 | Crook | Oregon | 41013 | 6 | 0 |
202032 | 202032 | 2020-06-02 | Crook | Oregon | 41013 | 6 | 0 |
205109 | 205109 | 2020-06-03 | Crook | Oregon | 41013 | 6 | 0 |
208190 | 208190 | 2020-06-04 | Crook | Oregon | 41013 | 7 | 0 |
211272 | 211272 | 2020-06-05 | Crook | Oregon | 41013 | 6 | 0 |
214358 | 214358 | 2020-06-06 | Crook | Oregon | 41013 | 6 | 0 |
217448 | 217448 | 2020-06-07 | Crook | Oregon | 41013 | 6 | 0 |
220540 | 220540 | 2020-06-08 | Crook | Oregon | 41013 | 6 | 0 |
223635 | 223635 | 2020-06-09 | Crook | Oregon | 41013 | 6 | 0 |
226735 | 226735 | 2020-06-10 | Crook | Oregon | 41013 | 6 | 0 |
229839 | 229839 | 2020-06-11 | Crook | Oregon | 41013 | 8 | 0 |
232944 | 232944 | 2020-06-12 | Crook | Oregon | 41013 | 8 | 0 |
236049 | 236049 | 2020-06-13 | Crook | Oregon | 41013 | 8 | 0 |
239157 | 239157 | 2020-06-14 | Crook | Oregon | 41013 | 8 | 0 |
242266 | 242266 | 2020-06-15 | Crook | Oregon | 41013 | 8 | 0 |
245378 | 245378 | 2020-06-16 | Crook | Oregon | 41013 | 9 | 0 |
248491 | 248491 | 2020-06-17 | Crook | Oregon | 41013 | 9 | 0 |
251606 | 251606 | 2020-06-18 | Crook | Oregon | 41013 | 9 | 0 |
254721 | 254721 | 2020-06-19 | Crook | Oregon | 41013 | 9 | 0 |
257847 | 257847 | 2020-06-20 | Crook | Oregon | 41013 | 9 | 0 |
260974 | 260974 | 2020-06-21 | Crook | Oregon | 41013 | 9 | 0 |
264102 | 264102 | 2020-06-22 | Crook | Oregon | 41013 | 9 | 0 |
267230 | 267230 | 2020-06-23 | Crook | Oregon | 41013 | 9 | 0 |
270364 | 270364 | 2020-06-24 | Crook | Oregon | 41013 | 9 | 0 |
273503 | 273503 | 2020-06-25 | Crook | Oregon | 41013 | 9 | 0 |
276650 | 276650 | 2020-06-26 | Crook | Oregon | 41013 | 9 | 0 |
279798 | 279798 | 2020-06-27 | Crook | Oregon | 41013 | 10 | 0 |
282944 | 282944 | 2020-06-28 | Crook | Oregon | 41013 | 10 | 0 |
286089 | 286089 | 2020-06-29 | Crook | Oregon | 41013 | 10 | 0 |
289240 | 289240 | 2020-06-30 | Crook | Oregon | 41013 | 10 | 0 |
292392 | 292392 | 2020-07-01 | Crook | Oregon | 41013 | 10 | 0 |
295548 | 295548 | 2020-07-02 | Crook | Oregon | 41013 | 11 | 0 |
298707 | 298707 | 2020-07-03 | Crook | Oregon | 41013 | 12 | 0 |
301870 | 301870 | 2020-07-04 | Crook | Oregon | 41013 | 12 | 0 |
305033 | 305033 | 2020-07-05 | Crook | Oregon | 41013 | 13 | 0 |
308200 | 308200 | 2020-07-06 | Crook | Oregon | 41013 | 13 | 0 |
311369 | 311369 | 2020-07-07 | Crook | Oregon | 41013 | 14 | 0 |
314541 | 314541 | 2020-07-08 | Crook | Oregon | 41013 | 15 | 0 |
317714 | 317714 | 2020-07-09 | Crook | Oregon | 41013 | 17 | 1 |
320892 | 320892 | 2020-07-10 | Crook | Oregon | 41013 | 18 | 1 |
324072 | 324072 | 2020-07-11 | Crook | Oregon | 41013 | 18 | 1 |
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);