offices

Table actions

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

4 rows where legislator_id = "C001063"

✎ 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
C001063-laredo Henry Cuellar C001063 602 E. Calton Rd. Suite 2 Laredo TX 78041 27.5423782 -99.4887937 956-725-0639 956-725-2647   Monday - Friday 8:00 a.m. CST to 5:30 p.m. CST
C001063-mission Henry Cuellar C001063 117 E. Tom Landry   Mission TX 78572 26.2161009 -98.32499899999999 956-424-3942 956-424-3936    
C001063-rio_grande_city Henry Cuellar C001063 100 N. F.M. 3167   Rio Grande City TX 78582 26.3834188 -98.85823049999999 956-487-5603 956-488-0952    
C001063-san_antonio Henry Cuellar C001063 615 E. Houston St. Suite 563 San Antonio TX 78205 29.4270611 -98.48622759999999 210-271-2851 210-277-6671    

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