offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
5 rows where legislator_id = "S001200"
This data as json, copyable, CSV (advanced)
Suggested facets: phone
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
S001200-haines_city | Darren Soto S001200 | 620 E Main St. | Haines City | FL | 33844 | 28.1083914 | -81.628392 | 202-615-1308 | Wednesday 9AM-5PM | |||
S001200-kissimmee | Darren Soto S001200 | 804 Bryan St. | Kissimmee | FL | 34741 | 28.2906297 | -81.4123113 | 407-452-1171 | ||||
S001200-lake_wales | Darren Soto S001200 | 201 W Central Avenue | Lake Wales | FL | 33853 | 27.8999663 | -81.596459 | 202-600-0843 | 202-615-1308 | Monday and Tuesday, 9AM-5PM | ||
S001200-orlando | Darren Soto S001200 | 13800 Veterans Way | s 1F806 | Orlando | FL | 32827-7401 | 28.36525 | -81.2749461 | 202-322-4476 | VA Medical Center | Tuesdays 9AM-3PM | |
S001200-winter_haven | Darren Soto S001200 | 451 3rd Street NW | Winter Haven | FL | 33881 | 28.0263894 | -81.732919 | 202-600-0843 | Open Thursday and Friday 9AM-5PM |
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);