ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27,784 rows where state = "Oregon" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 37
- 41067 806
- 41029 798
- 41035 798
- 41019 797
- 41047 797
- 41051 795
- 41017 794
- 41043 794
- 41053 794
- 41059 794
- 41005 793
- 41071 790
- 41003 789
- 41039 788
- 41023 785
- 41061 785
- 41033 784
- 41027 782
- 41007 781
- 41041 780
- 41057 779
- 41065 779
- 41009 778
- 41049 778
- 41045 774
- 41063 774
- 41013 771
- 41055 769
- 41015 768
- 41011 763
- 41031 760
- 41025 746
- 41001 738
- 41037 717
- 41021 679
- 41069 580
- - 7
county 37
- Washington 806
- Jackson 798
- Klamath 798
- Douglas 797
- Marion 797
- Multnomah 795
- Deschutes 794
- Linn 794
- Polk 794
- Umatilla 794
- Clackamas 793
- Yamhill 790
- Benton 789
- Lane 788
- Grant 785
- Union 785
- Josephine 784
- Hood River 782
- Clatsop 781
- Lincoln 780
- Tillamook 779
- Wasco 779
- Columbia 778
- Morrow 778
- Malheur 774
- Wallowa 774
- Crook 771
- Sherman 769
- Curry 768
- Coos 763
- Jefferson 760
- Harney 746
- Baker 738
- Lake 717
- Gilliam 679
- Wheeler 580
- Unknown 7
state 1
- Oregon · 27,784 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
120349 | 120349 | 2020-05-06 | Baker | Oregon | 41001 | 1 | 0 |
123326 | 123326 | 2020-05-07 | Baker | Oregon | 41001 | 1 | 0 |
126309 | 126309 | 2020-05-08 | Baker | Oregon | 41001 | 1 | 0 |
129298 | 129298 | 2020-05-09 | Baker | Oregon | 41001 | 1 | 0 |
132287 | 132287 | 2020-05-10 | Baker | Oregon | 41001 | 1 | 0 |
135278 | 135278 | 2020-05-11 | Baker | Oregon | 41001 | 1 | 0 |
138268 | 138268 | 2020-05-12 | Baker | Oregon | 41001 | 1 | 0 |
141264 | 141264 | 2020-05-13 | Baker | Oregon | 41001 | 1 | 0 |
144260 | 144260 | 2020-05-14 | Baker | Oregon | 41001 | 1 | 0 |
147261 | 147261 | 2020-05-15 | Baker | Oregon | 41001 | 3 | 0 |
150268 | 150268 | 2020-05-16 | Baker | Oregon | 41001 | 1 | 0 |
153279 | 153279 | 2020-05-17 | Baker | Oregon | 41001 | 1 | 0 |
156296 | 156296 | 2020-05-18 | Baker | Oregon | 41001 | 1 | 0 |
159317 | 159317 | 2020-05-19 | Baker | Oregon | 41001 | 1 | 0 |
162344 | 162344 | 2020-05-20 | Baker | Oregon | 41001 | 1 | 0 |
165373 | 165373 | 2020-05-21 | Baker | Oregon | 41001 | 1 | 0 |
168409 | 168409 | 2020-05-22 | Baker | Oregon | 41001 | 1 | 0 |
171448 | 171448 | 2020-05-23 | Baker | Oregon | 41001 | 1 | 0 |
174490 | 174490 | 2020-05-24 | Baker | Oregon | 41001 | 1 | 0 |
177534 | 177534 | 2020-05-25 | Baker | Oregon | 41001 | 1 | 0 |
180577 | 180577 | 2020-05-26 | Baker | Oregon | 41001 | 1 | 0 |
183626 | 183626 | 2020-05-27 | Baker | Oregon | 41001 | 1 | 0 |
186683 | 186683 | 2020-05-28 | Baker | Oregon | 41001 | 1 | 0 |
189744 | 189744 | 2020-05-29 | Baker | Oregon | 41001 | 1 | 0 |
192809 | 192809 | 2020-05-30 | Baker | Oregon | 41001 | 1 | 0 |
195878 | 195878 | 2020-05-31 | Baker | Oregon | 41001 | 1 | 0 |
198951 | 198951 | 2020-06-01 | Baker | Oregon | 41001 | 1 | 0 |
202026 | 202026 | 2020-06-02 | Baker | Oregon | 41001 | 1 | 0 |
205103 | 205103 | 2020-06-03 | Baker | Oregon | 41001 | 1 | 0 |
208184 | 208184 | 2020-06-04 | Baker | Oregon | 41001 | 1 | 0 |
211266 | 211266 | 2020-06-05 | Baker | Oregon | 41001 | 1 | 0 |
214352 | 214352 | 2020-06-06 | Baker | Oregon | 41001 | 1 | 0 |
217442 | 217442 | 2020-06-07 | Baker | Oregon | 41001 | 1 | 0 |
220534 | 220534 | 2020-06-08 | Baker | Oregon | 41001 | 1 | 0 |
223629 | 223629 | 2020-06-09 | Baker | Oregon | 41001 | 1 | 0 |
226729 | 226729 | 2020-06-10 | Baker | Oregon | 41001 | 1 | 0 |
229833 | 229833 | 2020-06-11 | Baker | Oregon | 41001 | 1 | 0 |
232938 | 232938 | 2020-06-12 | Baker | Oregon | 41001 | 1 | 0 |
236043 | 236043 | 2020-06-13 | Baker | Oregon | 41001 | 1 | 0 |
239151 | 239151 | 2020-06-14 | Baker | Oregon | 41001 | 1 | 0 |
242260 | 242260 | 2020-06-15 | Baker | Oregon | 41001 | 1 | 0 |
245372 | 245372 | 2020-06-16 | Baker | Oregon | 41001 | 1 | 0 |
248485 | 248485 | 2020-06-17 | Baker | Oregon | 41001 | 1 | 0 |
251600 | 251600 | 2020-06-18 | Baker | Oregon | 41001 | 1 | 0 |
254715 | 254715 | 2020-06-19 | Baker | Oregon | 41001 | 1 | 0 |
257841 | 257841 | 2020-06-20 | Baker | Oregon | 41001 | 1 | 0 |
260968 | 260968 | 2020-06-21 | Baker | Oregon | 41001 | 1 | 0 |
264096 | 264096 | 2020-06-22 | Baker | Oregon | 41001 | 1 | 0 |
267224 | 267224 | 2020-06-23 | Baker | Oregon | 41001 | 1 | 0 |
270358 | 270358 | 2020-06-24 | Baker | Oregon | 41001 | 1 | 0 |
273497 | 273497 | 2020-06-25 | Baker | Oregon | 41001 | 1 | 0 |
276644 | 276644 | 2020-06-26 | Baker | Oregon | 41001 | 1 | 0 |
279792 | 279792 | 2020-06-27 | Baker | Oregon | 41001 | 1 | 0 |
282938 | 282938 | 2020-06-28 | Baker | Oregon | 41001 | 1 | 0 |
286083 | 286083 | 2020-06-29 | Baker | Oregon | 41001 | 1 | 0 |
289234 | 289234 | 2020-06-30 | Baker | Oregon | 41001 | 1 | 0 |
292386 | 292386 | 2020-07-01 | Baker | Oregon | 41001 | 4 | 0 |
295542 | 295542 | 2020-07-02 | Baker | Oregon | 41001 | 4 | 0 |
298701 | 298701 | 2020-07-03 | Baker | Oregon | 41001 | 4 | 0 |
301864 | 301864 | 2020-07-04 | Baker | Oregon | 41001 | 5 | 0 |
305027 | 305027 | 2020-07-05 | Baker | Oregon | 41001 | 5 | 0 |
308194 | 308194 | 2020-07-06 | Baker | Oregon | 41001 | 5 | 0 |
311363 | 311363 | 2020-07-07 | Baker | Oregon | 41001 | 5 | 0 |
314535 | 314535 | 2020-07-08 | Baker | Oregon | 41001 | 8 | 0 |
317708 | 317708 | 2020-07-09 | Baker | Oregon | 41001 | 8 | 0 |
320886 | 320886 | 2020-07-10 | Baker | Oregon | 41001 | 9 | 0 |
324066 | 324066 | 2020-07-11 | Baker | Oregon | 41001 | 11 | 0 |
327251 | 327251 | 2020-07-12 | Baker | Oregon | 41001 | 12 | 0 |
330437 | 330437 | 2020-07-13 | Baker | Oregon | 41001 | 12 | 0 |
333629 | 333629 | 2020-07-14 | Baker | Oregon | 41001 | 12 | 0 |
336823 | 336823 | 2020-07-15 | Baker | Oregon | 41001 | 13 | 0 |
340020 | 340020 | 2020-07-16 | Baker | Oregon | 41001 | 13 | 0 |
343218 | 343218 | 2020-07-17 | Baker | Oregon | 41001 | 13 | 0 |
346418 | 346418 | 2020-07-18 | Baker | Oregon | 41001 | 13 | 0 |
349618 | 349618 | 2020-07-19 | Baker | Oregon | 41001 | 13 | 0 |
352821 | 352821 | 2020-07-20 | Baker | Oregon | 41001 | 13 | 0 |
356024 | 356024 | 2020-07-21 | Baker | Oregon | 41001 | 15 | 0 |
359228 | 359228 | 2020-07-22 | Baker | Oregon | 41001 | 16 | 0 |
362434 | 362434 | 2020-07-23 | Baker | Oregon | 41001 | 16 | 0 |
365640 | 365640 | 2020-07-24 | Baker | Oregon | 41001 | 17 | 0 |
368849 | 368849 | 2020-07-25 | Baker | Oregon | 41001 | 19 | 0 |
372061 | 372061 | 2020-07-26 | Baker | Oregon | 41001 | 22 | 0 |
375274 | 375274 | 2020-07-27 | Baker | Oregon | 41001 | 22 | 0 |
378490 | 378490 | 2020-07-28 | Baker | Oregon | 41001 | 22 | 0 |
381707 | 381707 | 2020-07-29 | Baker | Oregon | 41001 | 22 | 0 |
384925 | 384925 | 2020-07-30 | Baker | Oregon | 41001 | 25 | 0 |
388142 | 388142 | 2020-07-31 | Baker | Oregon | 41001 | 28 | 0 |
391359 | 391359 | 2020-08-01 | Baker | Oregon | 41001 | 30 | 0 |
394575 | 394575 | 2020-08-02 | Baker | Oregon | 41001 | 30 | 0 |
397792 | 397792 | 2020-08-03 | Baker | Oregon | 41001 | 33 | 0 |
401007 | 401007 | 2020-08-04 | Baker | Oregon | 41001 | 35 | 0 |
404225 | 404225 | 2020-08-05 | Baker | Oregon | 41001 | 36 | 0 |
407444 | 407444 | 2020-08-06 | Baker | Oregon | 41001 | 37 | 0 |
410664 | 410664 | 2020-08-07 | Baker | Oregon | 41001 | 38 | 0 |
413884 | 413884 | 2020-08-08 | Baker | Oregon | 41001 | 38 | 0 |
417105 | 417105 | 2020-08-09 | Baker | Oregon | 41001 | 38 | 0 |
420325 | 420325 | 2020-08-10 | Baker | Oregon | 41001 | 40 | 0 |
423548 | 423548 | 2020-08-11 | Baker | Oregon | 41001 | 40 | 0 |
426771 | 426771 | 2020-08-12 | Baker | Oregon | 41001 | 42 | 0 |
429996 | 429996 | 2020-08-13 | Baker | Oregon | 41001 | 45 | 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);