offices

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

4 rows where legislator_id = "B000944"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude phone fax building hours
B000944-cincinnati Sherrod Brown B000944 425 Walnut St. Suite 2310 Cincinnati OH 45202 39.1007745 -84.5120256 513-684-1021 513-684-1029    
B000944-cleveland Sherrod Brown B000944 801 W. Superior Ave. Suite 1400 Cleveland OH 44113 41.4964399 -81.6975439 216-522-7272 216-522-2239    
B000944-columbus Sherrod Brown B000944 200 N. High St. Room 614 Columbus OH 43215 39.9666883 -83.000974 614-469-2083 614-469-2171    
B000944-lorain Sherrod Brown B000944 200 W. Erie Ave. Suite 312 Lorain OH 44052 41.4685695 -82.1792684 440-242-4100 440-242-4108    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);