offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "L000570"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
L000570-farmington | Ben Luján L000570 | 800 Municipal Dr. | Farmington | NM | 87401 | 36.7378735 | -108.2167002 | 505-324-1005 | 505-324-1026 | |||
L000570-gallup | Ben Luján L000570 | 110 W. Aztec Ave. | Gallup | NM | 87301 | 35.5265052 | -108.7413892 | 505-863-0582 | 505-863-0678 | |||
L000570-las_vegas | Ben Luján L000570 | 1103 National Ave | Suite 210 | Las Vegas | NM | 87701-4024 | 35.59437 | -105.22224 | 505-454-3038 | 505-454-3265 | NMHU Hewett Hall | |
L000570-rio_rancho | Ben Luján L000570 | 3200 Civic Center NE | Suite 330 | Rio Rancho | NM | 87144 | 35.3109178 | -106.6851151 | 505-994-0499 | 505-994-0550 | ||
L000570-santa_fe | Ben Luján L000570 | 1611 Calle Lorca | Suite A | Santa Fe | NM | 87505 | 35.6605914 | -105.9630964 | 505-984-8950 | 505-986-5047 | ||
L000570-tucumcari | Ben Luján L000570 | 404 W. Route 66 Blvd. | Tucumcari | NM | 88401 | 35.1718132 | -103.7221881 | 575-461-3029 | 575-461-3192 |
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);