offices

Table actions

6 rows where legislator_id = "C001125"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, zip

id ▼ legislator_id address suite city state zip latitude longitude fax phone building hours
C001125-baton_rouge Troy Carter C001125 801 Harding Blvd   Baton Rouge LA 70807 30.5204744 -91.1855444     T.H. Harris Hall  
C001125-gonzales Troy Carter C001125 615 E. Worthy St Rm 107 Gonzales LA 70737 30.2243054 -90.9174972     Ascension Parish Government Bldg By appointment only
C001125-gonzales-1 Troy Carter C001125 925 W. Edenborne Pkwy Room T117 Gonzales LA 70737 30.1909973 -90.933357     River Parishes Community College Gonzales Technical Training Center  
C001125-gretna Troy Carter C001125 200 Derbigny St Suite 3200 Gretna LA 70053 29.9159844 -90.0676331     Gretna Courthouse  
C001125-new_orleans Troy Carter C001125 3401 General DeGaulle Dr Suite 100 New Orleans LA 70114 29.924804 -90.0244505   504-381-3970    
C001125-new_orleans-1 Troy Carter C001125 650 Poydras St Suite 2525 New Orleans LA 70130 29.9488746 -90.0701146   504-288-3777    

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