offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
5 rows where legislator_id = "H001046"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
H001046-albuquerque | Martin Heinrich H001046 | 400 Gold Ave. SW | Suite 1080 | Albuquerque | NM | 87102 | 35.0833514 | -106.6521937 | 505-346-6601 | 505-346-6780 | ||
H001046-farmington | Martin Heinrich H001046 | 7450 E. Main St. | Suite A | Farmington | NM | 87402 | 36.7863602 | -108.1112628 | 505-325-5030 | 505-325-6035 | ||
H001046-las_cruces | Martin Heinrich H001046 | 505 S. Main St. | Suite 148 | Las Cruces | NM | 88001 | 32.3041597 | -106.7758242 | 575-523-6561 | 575-523-6584 | Loretto Towne Center | |
H001046-roswell | Martin Heinrich H001046 | 200 E. 4th St. | Suite 300 | Roswell | NM | 88201 | 33.39647 | -104.521106 | 575-622-7113 | 575-622-3538 | ||
H001046-santa_fe | Martin Heinrich H001046 | 123 E. Marcy St. | Suite 103 | Santa Fe | NM | 87501 | 35.6889043 | -105.9354058 | 505-988-6647 | 505-992-8435 |
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);