offices

Table actions

5 rows where legislator_id = "B001261"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone 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 51 Coffeen Avenue Suite 202 Sheridan WY 82801 44.7952317 -106.9541476   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,
   [fax] TEXT,
   [phone] TEXT,
   [building] TEXT
, [hours] TEXT);