ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 41007 and state = "Oregon" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10475 | 10475 | 2020-03-24 | Clatsop | Oregon | 41007 | 1 | 0 |
11936 | 11936 | 2020-03-25 | Clatsop | Oregon | 41007 | 1 | 0 |
13552 | 13552 | 2020-03-26 | Clatsop | Oregon | 41007 | 2 | 0 |
15296 | 15296 | 2020-03-27 | Clatsop | Oregon | 41007 | 2 | 0 |
17143 | 17143 | 2020-03-28 | Clatsop | Oregon | 41007 | 3 | 0 |
19081 | 19081 | 2020-03-29 | Clatsop | Oregon | 41007 | 3 | 0 |
21131 | 21131 | 2020-03-30 | Clatsop | Oregon | 41007 | 3 | 0 |
23264 | 23264 | 2020-03-31 | Clatsop | Oregon | 41007 | 3 | 0 |
25462 | 25462 | 2020-04-01 | Clatsop | Oregon | 41007 | 3 | 0 |
27734 | 27734 | 2020-04-02 | Clatsop | Oregon | 41007 | 3 | 0 |
30066 | 30066 | 2020-04-03 | Clatsop | Oregon | 41007 | 4 | 0 |
32456 | 32456 | 2020-04-04 | Clatsop | Oregon | 41007 | 4 | 0 |
34890 | 34890 | 2020-04-05 | Clatsop | Oregon | 41007 | 4 | 0 |
37364 | 37364 | 2020-04-06 | Clatsop | Oregon | 41007 | 4 | 0 |
39885 | 39885 | 2020-04-07 | Clatsop | Oregon | 41007 | 5 | 0 |
42445 | 42445 | 2020-04-08 | Clatsop | Oregon | 41007 | 5 | 0 |
45031 | 45031 | 2020-04-09 | Clatsop | Oregon | 41007 | 5 | 0 |
47648 | 47648 | 2020-04-10 | Clatsop | Oregon | 41007 | 6 | 0 |
50304 | 50304 | 2020-04-11 | Clatsop | Oregon | 41007 | 6 | 0 |
52977 | 52977 | 2020-04-12 | Clatsop | Oregon | 41007 | 6 | 0 |
55662 | 55662 | 2020-04-13 | Clatsop | Oregon | 41007 | 6 | 0 |
58364 | 58364 | 2020-04-14 | Clatsop | Oregon | 41007 | 6 | 0 |
61079 | 61079 | 2020-04-15 | Clatsop | Oregon | 41007 | 6 | 0 |
63805 | 63805 | 2020-04-16 | Clatsop | Oregon | 41007 | 6 | 0 |
66551 | 66551 | 2020-04-17 | Clatsop | Oregon | 41007 | 6 | 0 |
69309 | 69309 | 2020-04-18 | Clatsop | Oregon | 41007 | 6 | 0 |
72076 | 72076 | 2020-04-19 | Clatsop | Oregon | 41007 | 6 | 0 |
74851 | 74851 | 2020-04-20 | Clatsop | Oregon | 41007 | 6 | 0 |
77633 | 77633 | 2020-04-21 | Clatsop | Oregon | 41007 | 6 | 0 |
80423 | 80423 | 2020-04-22 | Clatsop | Oregon | 41007 | 6 | 0 |
83222 | 83222 | 2020-04-23 | Clatsop | Oregon | 41007 | 6 | 0 |
86026 | 86026 | 2020-04-24 | Clatsop | Oregon | 41007 | 6 | 0 |
88840 | 88840 | 2020-04-25 | Clatsop | Oregon | 41007 | 6 | 0 |
91656 | 91656 | 2020-04-26 | Clatsop | Oregon | 41007 | 6 | 0 |
94483 | 94483 | 2020-04-27 | Clatsop | Oregon | 41007 | 6 | 0 |
97321 | 97321 | 2020-04-28 | Clatsop | Oregon | 41007 | 6 | 0 |
100170 | 100170 | 2020-04-29 | Clatsop | Oregon | 41007 | 6 | 0 |
103023 | 103023 | 2020-04-30 | Clatsop | Oregon | 41007 | 6 | 0 |
105886 | 105886 | 2020-05-01 | Clatsop | Oregon | 41007 | 7 | 0 |
108753 | 108753 | 2020-05-02 | Clatsop | Oregon | 41007 | 7 | 0 |
111627 | 111627 | 2020-05-03 | Clatsop | Oregon | 41007 | 7 | 0 |
114509 | 114509 | 2020-05-04 | Clatsop | Oregon | 41007 | 8 | 0 |
117390 | 117390 | 2020-05-05 | Clatsop | Oregon | 41007 | 17 | 0 |
120352 | 120352 | 2020-05-06 | Clatsop | Oregon | 41007 | 17 | 0 |
123329 | 123329 | 2020-05-07 | Clatsop | Oregon | 41007 | 18 | 0 |
126312 | 126312 | 2020-05-08 | Clatsop | Oregon | 41007 | 27 | 0 |
129301 | 129301 | 2020-05-09 | Clatsop | Oregon | 41007 | 28 | 0 |
132290 | 132290 | 2020-05-10 | Clatsop | Oregon | 41007 | 29 | 0 |
135281 | 135281 | 2020-05-11 | Clatsop | Oregon | 41007 | 33 | 0 |
138271 | 138271 | 2020-05-12 | Clatsop | Oregon | 41007 | 34 | 0 |
141267 | 141267 | 2020-05-13 | Clatsop | Oregon | 41007 | 37 | 0 |
144263 | 144263 | 2020-05-14 | Clatsop | Oregon | 41007 | 36 | 0 |
147264 | 147264 | 2020-05-15 | Clatsop | Oregon | 41007 | 36 | 0 |
150271 | 150271 | 2020-05-16 | Clatsop | Oregon | 41007 | 37 | 0 |
153282 | 153282 | 2020-05-17 | Clatsop | Oregon | 41007 | 37 | 0 |
156299 | 156299 | 2020-05-18 | Clatsop | Oregon | 41007 | 38 | 0 |
159320 | 159320 | 2020-05-19 | Clatsop | Oregon | 41007 | 38 | 0 |
162347 | 162347 | 2020-05-20 | Clatsop | Oregon | 41007 | 42 | 0 |
165376 | 165376 | 2020-05-21 | Clatsop | Oregon | 41007 | 42 | 0 |
168412 | 168412 | 2020-05-22 | Clatsop | Oregon | 41007 | 44 | 0 |
171451 | 171451 | 2020-05-23 | Clatsop | Oregon | 41007 | 45 | 0 |
174493 | 174493 | 2020-05-24 | Clatsop | Oregon | 41007 | 45 | 0 |
177537 | 177537 | 2020-05-25 | Clatsop | Oregon | 41007 | 45 | 0 |
180580 | 180580 | 2020-05-26 | Clatsop | Oregon | 41007 | 45 | 0 |
183629 | 183629 | 2020-05-27 | Clatsop | Oregon | 41007 | 45 | 0 |
186686 | 186686 | 2020-05-28 | Clatsop | Oregon | 41007 | 45 | 0 |
189747 | 189747 | 2020-05-29 | Clatsop | Oregon | 41007 | 45 | 0 |
192812 | 192812 | 2020-05-30 | Clatsop | Oregon | 41007 | 45 | 0 |
195881 | 195881 | 2020-05-31 | Clatsop | Oregon | 41007 | 45 | 0 |
198954 | 198954 | 2020-06-01 | Clatsop | Oregon | 41007 | 45 | 0 |
202029 | 202029 | 2020-06-02 | Clatsop | Oregon | 41007 | 45 | 0 |
205106 | 205106 | 2020-06-03 | Clatsop | Oregon | 41007 | 45 | 0 |
208187 | 208187 | 2020-06-04 | Clatsop | Oregon | 41007 | 45 | 0 |
211269 | 211269 | 2020-06-05 | Clatsop | Oregon | 41007 | 45 | 0 |
214355 | 214355 | 2020-06-06 | Clatsop | Oregon | 41007 | 45 | 0 |
217445 | 217445 | 2020-06-07 | Clatsop | Oregon | 41007 | 45 | 0 |
220537 | 220537 | 2020-06-08 | Clatsop | Oregon | 41007 | 45 | 0 |
223632 | 223632 | 2020-06-09 | Clatsop | Oregon | 41007 | 45 | 0 |
226732 | 226732 | 2020-06-10 | Clatsop | Oregon | 41007 | 45 | 0 |
229836 | 229836 | 2020-06-11 | Clatsop | Oregon | 41007 | 46 | 0 |
232941 | 232941 | 2020-06-12 | Clatsop | Oregon | 41007 | 46 | 0 |
236046 | 236046 | 2020-06-13 | Clatsop | Oregon | 41007 | 46 | 0 |
239154 | 239154 | 2020-06-14 | Clatsop | Oregon | 41007 | 46 | 0 |
242263 | 242263 | 2020-06-15 | Clatsop | Oregon | 41007 | 46 | 0 |
245375 | 245375 | 2020-06-16 | Clatsop | Oregon | 41007 | 46 | 0 |
248488 | 248488 | 2020-06-17 | Clatsop | Oregon | 41007 | 46 | 0 |
251603 | 251603 | 2020-06-18 | Clatsop | Oregon | 41007 | 46 | 0 |
254718 | 254718 | 2020-06-19 | Clatsop | Oregon | 41007 | 46 | 0 |
257844 | 257844 | 2020-06-20 | Clatsop | Oregon | 41007 | 46 | 0 |
260971 | 260971 | 2020-06-21 | Clatsop | Oregon | 41007 | 46 | 0 |
264099 | 264099 | 2020-06-22 | Clatsop | Oregon | 41007 | 46 | 0 |
267227 | 267227 | 2020-06-23 | Clatsop | Oregon | 41007 | 46 | 0 |
270361 | 270361 | 2020-06-24 | Clatsop | Oregon | 41007 | 47 | 0 |
273500 | 273500 | 2020-06-25 | Clatsop | Oregon | 41007 | 48 | 0 |
276647 | 276647 | 2020-06-26 | Clatsop | Oregon | 41007 | 48 | 0 |
279795 | 279795 | 2020-06-27 | Clatsop | Oregon | 41007 | 48 | 0 |
282941 | 282941 | 2020-06-28 | Clatsop | Oregon | 41007 | 49 | 0 |
286086 | 286086 | 2020-06-29 | Clatsop | Oregon | 41007 | 49 | 0 |
289237 | 289237 | 2020-06-30 | Clatsop | Oregon | 41007 | 49 | 0 |
292389 | 292389 | 2020-07-01 | Clatsop | Oregon | 41007 | 49 | 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);