offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3 rows where legislator_id = "F000469"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
F000469-coeur_d_alene | Russ Fulcher F000469 | 1250 W Ironwood Dr | Suite 241 | Coeur D Alene | ID | 83814-2679 | 47.69725 | -116.80272 | 208-667-0127 | 208-667-0310 | ||
F000469-lewiston | Russ Fulcher F000469 | 313 D St | Suite 107 | Lewiston | ID | 83501-1894 | 46.42199 | -117.02845 | 208-743-1388 | |||
F000469-meridian | Russ Fulcher F000469 | 33 E Broadway Ave | Suite 251 | Meridian | ID | 83642-2619 | 43.61003 | -116.3929 | 208-888-3188 | 208-888-0894 |
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);