offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "S001181"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
S001181-berlin | Jeanne Shaheen S001181 | 961 Main St. | Berlin | NH | 03570 | 44.4781896 | -71.1708276 | 603-752-6300 | ||||
S001181-claremont | Jeanne Shaheen S001181 | 50 Opera House Sq. | Claremont | NH | 03743 | 43.3727196 | -72.3373946 | 603-542-4872 | ||||
S001181-dover | Jeanne Shaheen S001181 | 340 Central Ave. | Suite 205 | Dover | NH | 03820 | 43.1952108 | -70.8748699 | 603-750-3004 | |||
S001181-keene | Jeanne Shaheen S001181 | 12 Gilbo Ave. | Suite C | Keene | NH | 03431 | 42.9323699 | -72.2794587 | 603-358-6604 | |||
S001181-manchester | Jeanne Shaheen S001181 | 2 Wall St. | Suite 220 | Manchester | NH | 03101 | 42.9940731 | -71.46386679999999 | 603-647-7500 | Mon-Fri 8:30am-5:00pm | ||
S001181-nashua | Jeanne Shaheen S001181 | 60 Main St. | Suite 217 | Nashua | NH | 03060 | 42.7633363 | -71.4659542 | 603-883-0196 |
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);