offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3 rows where legislator_id = "D000191" sorted by address
This data as json, copyable, CSV (advanced)
Suggested facets: fax
id | legislator_id | address ▼ | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
D000191-coos_bay | Peter DeFazio D000191 | 125 Central Ave. | Suite 350 | Coos Bay | OR | 97420 | 43.367748 | -124.213429 | 541-269-2609 | 541-269-5760 | M-F 8:00am-5:00pm | |
D000191-eugene | Peter DeFazio D000191 | 405 E. 8th Ave. | #2030 | Eugene | OR | 97401 | 44.0516985 | -123.0857882 | 541-465-6732 | 541-465-6458 | M-F 8:00am-5:00pm | |
D000191-roseburg | Peter DeFazio D000191 | 612 SE. Jackson St. | Room 9 | Roseburg | OR | 97470 | 43.2087597 | -123.3445182 | 541-440-3523 | 541-465-6458 | M-F 8:00am-5:00pm |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [offices] ( [id] TEXT PRIMARY KEY, [legislator_id] TEXT REFERENCES [legislators]([id]), [address] TEXT, [suite] TEXT, [city] TEXT, [state] TEXT, [zip] TEXT, [latitude] FLOAT, [longitude] FLOAT, [phone] TEXT, [fax] TEXT, [building] TEXT , [hours] TEXT);