offices

Table actions

4 rows where legislator_id = "B001315"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
B001315-champaign Nicole (Nikki) Budzinski B001315 44 East Main Street Suite 205 Champaign IL 61820 40.1173647 -88.241557   217-305-6991    
B001315-collinsville Nicole (Nikki) Budzinski B001315 409 Belt Line Road Suite 110 Collinsville IL 62234 38.691488 -89.9744207   618-212-7333    
B001315-decatur Nicole (Nikki) Budzinski B001315 101 South Main Street Suite 100 Decatur IL 62523 39.84110099999999 -88.95629410000001   217-859-5313    
B001315-springfield Nicole (Nikki) Budzinski B001315 133 South 4th Street Suite 300 Springfield IL 62701 39.80112889999999 -89.65084809999999   217-814-2880    

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,
   [fax] TEXT,
   [phone] TEXT,
   [building] TEXT
, [hours] TEXT);