offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
5 rows where legislator_id = "H001061"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
H001061-bismarck | John Hoeven H001061 | 220 E. Rosser Ave. | Room 312 | Bismarck | ND | 58501 | 46.80901129999999 | -100.7882597 | 701-250-4618 | 701-250-4484 | U.S. Federal Building | |
H001061-fargo | John Hoeven H001061 | 123 Broadway North | Suite 201 | Fargo | ND | 58102 | 46.8778235 | -96.7894805 | 701-239-5389 | 202-228-5112 | ||
H001061-grand_forks | John Hoeven H001061 | 102 N. Fourth St. | Room 108 | Grand Forks | ND | 58203 | 47.9255358 | -97.03273929999999 | 701-746-8972 | Federal Building | ||
H001061-minot | John Hoeven H001061 | 100 1st St. SW | Suite 107 | Minot | ND | 58701 | 48.2351551 | -101.2950057 | 701-838-1361 | 701-838-1381 | ||
H001061-watford_city | John Hoeven H001061 | Watford City | ND | 701-609-2727 |
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);