offices

Table actions

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

3 rows where legislator_id = "C001061"

✎ 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
C001061-higginsville Emanuel Cleaver C001061 1923 Main St   Higginsville MO 64037 39.0754557 -93.7170832 660-584-7373 660-584-7227   Mon-Fri 8-5:00pm
C001061-independence Emanuel Cleaver C001061 411 W Maple Ave F Independence MO 64050-2840 39.09278 -94.4201 816-833-4545 816-833-2991   M-F 9-6:00pm
C001061-kansas_city Emanuel Cleaver C001061 101 W. 31 St.   Kansas City MO 64108 39.070874 -94.587124 816-842-4545 816-471-5215   Mon-Fri 9:00am-6:00pm

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