offices

Table actions

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

7 rows where legislator_id = "B001236"

✎ 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
B001236-el_dorado John Boozman B001236 106 W. Main St. Suite 104 El Dorado AR 71730 33.2120448 -92.664046 870-863-4641 870-863-4105    
B001236-fort_smith John Boozman B001236 1120 Garrison Ave. Suite 2B Fort Smith AR 72901 35.383512 -94.42033099999999 479-573-0189 479-573-0553    
B001236-jonesboro John Boozman B001236 300 S. Church St. Suite 400 Jonesboro AR 72401 35.8404281 -90.70368549999999 870-268-6925 870-268-6887    
B001236-little_rock John Boozman B001236 1401 W. Capitol Ave. Suite 155 Little Rock AR 72201 34.7456872 -92.2865752 501-372-7153 501-372-7163    
B001236-lowell John Boozman B001236 213 W. Monroe Suite N Lowell AR 72745 36.2535183 -94.1393049 479-725-0400 479-725-0408    
B001236-mountain_home John Boozman B001236 1001 Hwy 62 East Suite 11 Mountain Home AR 72653 36.3499306 -92.3729619 870-424-0129 870-424-0141    
B001236-stuttgart John Boozman B001236 620 E. 22nd St. Suite 204 Stuttgart AR 72160 34.478784 -91.54664090000001 870-672-6941 870-672-6962    

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