offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
8 rows where legislator_id = "R000595"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
R000595-fort_myers | Marco Rubio R000595 | 2120 Main St. | Room 200 | Fort Myers | FL | 33901 | 26.6426923 | -81.8727155 | 239-318-6464 | |||
R000595-jacksonville | Marco Rubio R000595 | 300 North Hogan St. | Suite 8-111 | Jacksonville | FL | 32202 | 30.32909 | -81.65997 | 904-354-4300 | Bryan Simpson U.S. Courthouse | M-F 8:30AM-5:30PM | |
R000595-miami | Marco Rubio R000595 | 7400 SW 87th Ave. | Suite 270 | Miami | FL | 33173 | 25.7001209 | -80.3372066 | 305-596-4224 | 305-596-4345 | ||
R000595-orlando | Marco Rubio R000595 | 201 S. Orange Ave. | Suite 350 | Orlando | FL | 32801 | 28.5400755 | -81.3780508 | 407-254-2573 | |||
R000595-palm_beach_gardens | Marco Rubio R000595 | 4580 PGA Blvd. | Suite 201 | Palm Beach Gardens | FL | 33418 | 26.8380427 | -80.1114094 | 561-775-3360 | |||
R000595-pensacola | Marco Rubio R000595 | 700 S. Palafox St. | Suite 125 | Pensacola | FL | 32502 | 30.405605 | -87.213161 | 850-433-2603 | |||
R000595-tallahassee | Marco Rubio R000595 | 402 S. Monroe St. | Suite 2105E | Tallahassee | FL | 32399 | 30.438114 | -84.281289 | 850-599-9100 | |||
R000595-tampa | Marco Rubio R000595 | 501 E. Polk St | Suite 601 | Tampa | FL | 33602 | 27.9511694 | -82.459228 | 813-947-6288 |
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);