offices

Table actions Table actions

2 rows where legislator_id = "C001113"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
C001113-las_vegas C001113 333 Las Vegas Boulevard South Suite 8016 Las Vegas NV 89101 36.1651058 -115.1424211 702-388-5030 702-388-5020   Monday-Friday; 8:00am – 5:00pm PT
C001113-reno C001113 400 South Virginia Street Suite 902 Reno NV 89501 39.5215352 -119.810287 775-686-5757 775-686-5750 Courthouse and Federal Building Monday-Friday; 8:00am-5:00pm PT

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