offices

Table actions

7 rows where legislator_id = "B001267"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
B001267-alamosa Michael Bennet B001267 609 Main Street Suite 206 Alamosa CO 81101 37.4685007 -105.8659427   719-587-0096    
B001267-colorado_springs Michael Bennet B001267 409 N. Tejon St. Suite 107 Colorado Springs CO 80903 38.8400247 -104.8228748 719-328-1129 719-328-1100    
B001267-denver Michael Bennet B001267 1244 Speer Blvd.   Denver CO 80204 39.7364704 -104.994978 202-224-1866 303-455-7600 Cesar E. Chavez Memorial Building  
B001267-durango Michael Bennet B001267 1309 East 3rd Avenue Suite 101 Durango CO 81301 37.2775875 -107.8770163 970-259-9789 970-259-1710 Smiley Building  
B001267-fort_collins Michael Bennet B001267 1200 S. College Ave. Suite 211 Fort Collins CO 80524 40.5716714 -105.0766516 970-224-2205 970-224-2200    
B001267-grand_junction Michael Bennet B001267 225 N. 5th St. Suite 511 Grand Junction CO 81501 39.0688046 -108.5648398   970-241-6631    
B001267-pueblo Michael Bennet B001267 129 W. B St.   Pueblo CO 81003 38.2795281 -104.508253   719-542-7550    

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