offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
7 rows where legislator_id = "P000595"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
P000595-detroit | Gary Peters P000595 | 477 Michigan Ave. | Suite 1837 | Detroit | MI | 48226 | 42.3311478 | -83.0532168 | 313-226-6020 | Patrick V. McNamara Federal Building | ||
P000595-grand_rapids | Gary Peters P000595 | 110 Michigan St. NW | Suite 720 | Grand Rapids | MI | 49503 | 42.96997460000001 | -85.67097419999999 | 616-233-9150 | Gerald R. Ford Federal Building | ||
P000595-lansing | Gary Peters P000595 | 124 W. Allegan St. | Suite 1400 | Lansing | MI | 48933 | 42.73289279999999 | -84.553479 | 517-377-1508 | |||
P000595-marquette | Gary Peters P000595 | 857 W. Washington St. | Suite 308 | Marquette | MI | 49855 | 46.545668 | -87.413111 | 906-226-4554 | |||
P000595-rochester | Gary Peters P000595 | 407 6th St. | Suite C | Rochester | MI | 48307 | 42.682816 | -83.137692 | 248-608-8040 | |||
P000595-saginaw | Gary Peters P000595 | 515 N. Washington Ave. | Suite 401 | Saginaw | MI | 48607 | 43.438206 | -83.93773879999999 | 989-754-0112 | |||
P000595-traverse_city | Gary Peters P000595 | 818 Red Dr. | Suite 40 | Traverse City | MI | 49684 | 44.7556947 | -85.64489909999999 | 231-947-7773 |
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);