offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
7 rows where legislator_id = "T000464"
This data as json, copyable, CSV (advanced)
Suggested facets: suite
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
T000464-billings | Jon Tester T000464 | 2900 4th Ave. N | Suite 201 | Billings | MT | 59101 | 45.783552 | -108.509375 | 406-252-0550 | 406-252-7768 | Judge Jameson Federal Building | |
T000464-bozeman | Jon Tester T000464 | 1 E. Main St. | Suite 202 | Bozeman | MT | 59715 | 45.6795093 | -111.0370333 | 406-586-4450 | 406-586-7647 | Avant Courier Building | |
T000464-butte | Jon Tester T000464 | 125 W. Granite | Suite 200 | Butte | MT | 59701 | 46.01461 | -112.538136 | 406-723-3277 | 406-782-4717 | Silver Bow Center | |
T000464-great_falls | Jon Tester T000464 | 119 1st Ave. N | Suite 102 | Great Falls | MT | 59401 | 47.5065688 | -111.3040376 | 402-452-9585 | 406-452-9586 | ||
T000464-helena | Jon Tester T000464 | 208 N. Montana Ave. | Suite 202 | Helena | MT | 59601 | 46.5865426 | -112.020799 | 406-449-5401 | 406-449-5462 | Capital One Center | |
T000464-kalispell | Jon Tester T000464 | 8 Third St. E | Kalispell | MT | 59901 | 48.1958316 | -114.3128666 | 406-257-3360 | 406-257-3974 | |||
T000464-missoula | Jon Tester T000464 | 130 W. Front St. | Missoula | MT | 59802 | 46.8704714 | -113.9961779 | 406-728-3003 | 406-728-2193 |
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);