offices

Table actions

4 rows where legislator_id = "B001291"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: zip, phone

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
B001291-dayton Brian Babin B001291 2004 N. Cleveland St.   Dayton TX 77536 30.0569844 -94.899317   832-780-0966 Dayton Police Station By appointment only
B001291-deer_park Brian Babin B001291 203 Ivy Ave. Suite 600 Deer Park TX 77536 29.7089323 -95.12126239999999 832-780-0964 832-780-0966    
B001291-lumberton Brian Babin B001291 769 S. Main Street   Lumberton TX 77657 30.241581 -94.1945327 409-886-9918 409-883-8075    
B001291-woodville Brian Babin B001291 100 W. Bluff Dr.   Woodville TX 75979 30.7753424 -94.41539859999999   409-331-8066 Tyler County Courthouse  

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