offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
8 rows where legislator_id = "D000618" sorted by city
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city ▼ | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
D000618-billings | Steve Daines D000618 | 222 N. 32nd St. | Suite 100 | Billings | MT | 59101 | 45.7810512 | -108.5125313 | 406-245-6822 | |||
D000618-bozeman | Steve Daines D000618 | 13 S. Willson Ave. | Suite 8 | Bozeman | MT | 59718 | 45.6788798 | -111.0390251 | 406-587-3446 | |||
D000618-great_falls | Steve Daines D000618 | 104 4th Street North | Suite 302 | Great Falls | MT | 59401 | 47.5067244 | -111.3009733 | 406-453-0148 | |||
D000618-hardin | Steve Daines D000618 | 310 N Ctr. | Hardin | MT | 59034 | 45.731817 | -107.606432 | 406-665-4126 | ||||
D000618-helena | Steve Daines D000618 | 30 W. 14th St. | Suite 206 | Helena | MT | 59601 | 46.596642 | -112.036443 | 406-443-3189 | |||
D000618-kalispell | Steve Daines D000618 | 40 2nd St East | Suite 211 | Kalispell | MT | 59901 | 48.19663569999999 | -114.3118812 | 406-257-3765 | KM Building | ||
D000618-missoula | Steve Daines D000618 | 218 E. Front St. | Suite 103 | Missoula | MT | 59802 | 46.8699041 | -113.9930208 | 406-549-8198 | |||
D000618-sidney | Steve Daines D000618 | 609 S. Central Ave. | Suite #4 | Sidney | MT | 59270 | 47.7106368 | -104.1606344 | 406-482-9010 | Central Plaza Building |
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);