offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
5 rows where legislator_id = "B001261"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
B001261-casper | John Barrasso B001261 | 100 E. B St. | Suite 2004 | Casper | WY | 82601 | 42.8524124 | -106.3248373 | 307-261-6413 | |||
B001261-cheyenne | John Barrasso B001261 | 2120 Capitol Ave. | Suite 2013 | Cheyenne | WY | 82001 | 41.1374591 | -104.8189674 | 307-772-2451 | |||
B001261-riverton | John Barrasso B001261 | 324 E. Washington Ave. | Riverton | WY | 82501 | 43.0238609 | -108.386731 | 307-856-6642 | ||||
B001261-rock_springs | John Barrasso B001261 | 1575 Dewar Drive | Suite 218 | Rock Springs | WY | 82901 | 41.5742346 | -109.2423116 | 307-362-5012 | Commerce Bank | ||
B001261-sheridan | John Barrasso B001261 | 2 N. Main St. | Suite 206 | Sheridan | WY | 82801 | 44.7974506 | -106.9562525 | 307-672-6456 |
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);