offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "B001243"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
B001243-chattanooga | Marsha Blackburn B001243 | 10 West M. L. King Blvd | 6th Floor | Chattanooga | TN | 37402 | 35.0455268 | -85.3100155 | 423-541-2939 | 423-541-2944 | ||
B001243-jackson | Marsha Blackburn B001243 | 109 S Highland Ave | Suite 218 | Jackson | TN | 38301 | 731-660-3971 | 731-660-3978 | ||||
B001243-jonesborough | Marsha Blackburn B001243 | 1105 E Jackson Blvd | Suite 4 | Jonesborough | TN | 37659-4997 | 36.30306 | -82.51024 | 423-753-4009 | 423-788-0250 | ||
B001243-knoxville | Marsha Blackburn B001243 | 800 Market St | Suite 121 | Knoxville | TN | 37902-2327 | 35.96225 | -83.91771 | 865-540-3781 | 865-540-7952 | ||
B001243-memphis | Marsha Blackburn B001243 | 100 Peabody Pl | Suite 1125 | Memphis | TN | 38103-3654 | 35.14132 | -90.05396 | 901-527-9199 | 901-527-9515 | ||
B001243-nashville | Marsha Blackburn B001243 | 3322 West End Avenue | Suite 610 | Nashville | TN | 37203 | 629-800-6600 | 615-298-2148 |
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);