offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
9 rows where legislator_id = "S001217"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
S001217-jacksonville | Rick Scott S001217 | 400 West Bay Street | Suite 289 | Jacksonville | FL | 32202 | 30.3269484 | -81.6637337 | 904-479-7227 | |||
S001217-kissimmee | Rick Scott S001217 | 1 Courthouse Square | Suite 300 | Kissimmee | FL | 34741 | 28.2912612 | -81.4108061 | 407-586-7879 | |||
S001217-miami | Rick Scott S001217 | 901 Ponce de Leon Boulevard | Suite 505 | Miami | FL | 33134 | 786-501-7141 | |||||
S001217-naples | Rick Scott S001217 | 3299 Tamiami Trail East | Building F, Suite 106 | Naples | FL | 34112 | 26.1275317 | -81.7654572 | 239-231-7890 | |||
S001217-orlando | Rick Scott S001217 | 225 East Robinson Street | Suite 410 | Orlando | FL | 32801 | 28.5460289 | -81.3745694 | 407-872-7161 | |||
S001217-pensacola | Rick Scott S001217 | 221 Palafox Place | Suite 420 | Pensacola | FL | 32502 | 30.4096575 | -87.2155533 | 850-760-5151 | |||
S001217-tallahassee | Rick Scott S001217 | 111 N Adams St | 208, | Tallahassee | FL | 32301-7736 | 30.44252 | -84.2819 | 850-942-8415 | |||
S001217-tampa | Rick Scott S001217 | 801 North Florida Avenue | Suite 421 | Tampa | FL | 33602 | 27.95168 | -82.4580549 | 813-225-7040 | |||
S001217-west_palm_beach | Rick Scott S001217 | 415 Clematis Street | Suite 201 | West Palm Beach | FL | 33401 | 26.7134899 | -80.0544948 | 561-514-0189 |
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);