offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3 rows where legislator_id = "K000376"
This data as json, copyable, CSV (advanced)
Suggested facets: hours
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
K000376-butler | Mike Kelly K000376 | 101 E. Diamond St. | Suite 218 | Butler | PA | 16001 | 40.8580044 | -79.8948869 | 724-282-2557 | 724-282-3682 | Monday-Friday 9:00AM-5:00PM | |
K000376-erie | Mike Kelly K000376 | 208 E. Bayfront Pkwy. | Suite 102 | Erie | PA | 16507 | 42.1373875 | -80.0848493 | 814-454-8190 | 814-454-8197 | Monday-Friday 9:00AM-5:00PM | |
K000376-sharon | Mike Kelly K000376 | 33 Chestnut Ave. | Sharon | PA | 16146 | 41.2315486 | -80.5079773 | 724-342-7170 | 724-342-7242 | Monday through Friday, 9 a.m. to 5 p.m. |
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);