offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
5 rows where legislator_id = "G000581"
This data as json, copyable, CSV (advanced)
Suggested facets: phone
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
G000581-benavides | Vicente Gonzalez G000581 | 131 W. Main St. | Benavides | TX | 78341 | 27.5968913 | -98.4176561 | 888-217-0261 | Wednesday 9-12 and 1-5 CT | |||
G000581-falfurrias | Vicente Gonzalez G000581 | 217 E. Miller St. | Suite 200 | Falfurrias | TX | 78355 | 27.2260914 | -98.1424972 | 361-209-3027 | Tuesday 9 a.m.- 12 p.m. & 1 p.m.-5 p.m. CT | ||
G000581-mcallen | Vicente Gonzalez G000581 | 1305 W Hackberry Ave | McAllen | TX | 78501-4306 | 26.21101 | -98.23214 | 956-682-5545 | 9 a.m.-6 p.m. CT | |||
G000581-san_diego | Vicente Gonzalez G000581 | 404 S. Mier St. | San Diego | TX | 78384 | 27.7605991 | -98.2413715 | 888-217-0261 | Monday 9-12 & 1-5 CT | |||
G000581-seguin | Vicente Gonzalez G000581 | 1243 Cardinal Ln | Seguin | TX | 78155-3915 | 29.57597 | -97.94818 | 830-358-0497 | 8 a.m. - 12 p.m. CT |
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);