offices

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

5 rows where legislator_id = "B001261"

✎ View and edit SQL

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

CSV options: 

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);