offices

Table actions

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

5 rows where legislator_id = "B000575"

✎ 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
B000575-cape_girardeau Roy Blunt B000575 338 Broadway Suite 303 Cape Girardeau MO 63701 37.3064303 -89.5241403 573-334-7044      
B000575-columbia Roy Blunt B000575 1123 Wilkes Blvd Suite 320 Columbia MO 65201 38.9606243 -92.3229127 573-442-8151      
B000575-kansas_city Roy Blunt B000575 1000 Walnut St. Suite 1560 Kansas City MO 64106 39.1021449 -94.5825038 816-471-7141      
B000575-saint_louis Roy Blunt B000575 111 S 10th St 23.305 Saint Louis MO 63102-1125 38.62588 -90.196 314-725-4484   Thomas F. Eagleton U.S. Courthouse  
B000575-springfield Roy Blunt B000575 2740 B E. Sunshine   Springfield MO 65804 37.180415 -93.240439 417-877-7814      

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