offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
9 rows where legislator_id = "K000393"
This data as json, copyable, CSV (advanced)
Suggested facets: latitude
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
K000393-alexandria | John Kennedy K000393 | 6501 Coliseum Blvd | Suite 700A | Alexandria | LA | 71303 | 31.2934776 | -92.51565289999999 | 318-445-2892 | By appointment only | ||
K000393-baton_rouge | John Kennedy K000393 | 7932 Wrenwood Blvd | Suite A & B | Baton Rouge | LA | 70809 | 30.4233173 | -91.1027159 | 225-926-8033 | By appointment only | ||
K000393-houma | John Kennedy K000393 | 8026 Main St | Suite 700 | Houma | LA | 70360 | 29.5979835 | -90.7180594 | 985-851-0956 | Government Towers | By appointment only | |
K000393-lafayette | John Kennedy K000393 | 101 La Rue France | Suite 503 | Lafayette | LA | 70508 | 30.1948666 | -92.014654 | 337-269-5980 | By appointment only | ||
K000393-lake_charles | John Kennedy K000393 | 1 Lakeshore Dr. | Suite 530 | Lake Charles | LA | 70629 | 32.5175209 | -91.102734 | 337-436-6255 | By appointment only | ||
K000393-mandeville | John Kennedy K000393 | 21490 Koop Dr. | Mandeville | LA | 70471 | 30.4182357 | -90.0470795 | 985-809-8153 | Building A | By appointment only | ||
K000393-monroe | John Kennedy K000393 | 1651 Louisville Ave. | Suite 148 | Monroe | LA | 71201 | 32.5175209 | -92.1087384 | 318-361-1489 | By appointment only | ||
K000393-new_orleans | John Kennedy K000393 | 500 Poydras St. | Suite 364 | New Orleans | LA | 70113 | 29.9484696 | -90.0711728 | 504-581-6190 | By appointment only | ||
K000393-shreveport | John Kennedy K000393 | 401 Market St. | Suite 1050 | Shreveport | LA | 71101 | 32.515033 | -93.7502759 | 318-670-5192 | By appointment only |
Advanced export
JSON shape: default, array, newline-delimited, object
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);