offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
2 rows where legislator_id = "L000576"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
L000576-joplin | Billy Long L000576 | 2727 E. 32nd St. | Suite 2 | Joplin | MO | 64804 | 37.0555214 | -94.4831701 | 417-781-1041 | 417-781-2832 | ||
L000576-springfield | Billy Long L000576 | 3232 E. Ridgeview St. | Springfield | MO | 65804 | 37.1590571 | -93.22940179999999 | 417-889-1800 | 417-889-4915 |
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);