offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3 rows where legislator_id = "B000490" sorted by city descending
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city ▲ | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
B000490-macon | Sanford Bishop B000490 | 300 Mulberry Street | Suite 502 | Macon | GA | 31201 | 32.8356646 | -83.6267623 | 478-803-2631 | 478-803-2637 | Mon-Fri 9am-5:30pm | |
B000490-columbus | Sanford Bishop B000490 | 18 Ninth St. | Suite 201 | Columbus | GA | 31901 | 32.4625755 | -84.9922596 | 706-320-9477 | 706-320-9479 | Mon-Fri 9-5:30pm | |
B000490-albany | Sanford Bishop B000490 | 323 Pine Ave | 400 | Albany | GA | 31701-2596 | 31.57858 | -84.1542 | 229-439-8067 | 229-436-2099 | M-F 9-5:30pm |
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);