offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
7 rows where legislator_id = "B001267"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
B001267-alamosa | Michael Bennet B001267 | 609 Main St. | Suite 110 | Alamosa | CO | 81101 | 37.4685012 | -105.8659434 | 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-1100 | 719-328-1129 | ||
B001267-denver | Michael Bennet B001267 | 1244 Speer Blvd. | Denver | CO | 80204 | 39.7364704 | -104.994978 | 303-455-7600 | 303-455-8851 | Cesar E. Chavez Memorial Building | ||
B001267-durango | Michael Bennet B001267 | 835 E. 2nd Ave. | Suite 206 | Durango | CO | 81301 | 37.2725939 | -107.8799634 | 970-259-1710 | |||
B001267-fort_collins | Michael Bennet B001267 | 1200 S. College Ave. | Suite 211 | Fort Collins | CO | 80524 | 40.5716714 | -105.0766516 | 970-224-2200 | 970-224-2205 | ||
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
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);