offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
7 rows where legislator_id = "B001236" sorted by zip descending
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city | state | zip ▲ | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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-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-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-stuttgart | John Boozman B001236 | 620 E. 22nd St. | Suite 204 | Stuttgart | AR | 72160 | 34.478784 | -91.54664090000001 | 870-672-6941 | 870-672-6962 | ||
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 |
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);