offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "S000770"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
S000770-detroit | Debbie Stabenow S000770 | 719 Griswold St. | Suite 700 | Detroit | MI | 48226 | 42.3307555 | -83.048152 | 313-961-4330 | |||
S000770-east_lansing | Debbie Stabenow S000770 | 221 W. Lake Lansing Rd. | Suite 100 | East Lansing | MI | 48823 | 42.757677 | -84.48539199999999 | 517-203-1760 | |||
S000770-flint | Debbie Stabenow S000770 | 432 N. Saginaw St. | Suite 301 | Flint | MI | 48502 | 43.0201574 | -83.69306720000002 | 810-720-4172 | |||
S000770-grand_rapids | Debbie Stabenow S000770 | 3280 E. Beltline Ct. NE | Suite 400 | Grand Rapids | MI | 49525 | 43.037652 | -85.588081 | 616-975-0052 | |||
S000770-marquette | Debbie Stabenow S000770 | 1901 W. Ridge | Suite 7 | Marquette | MI | 49855 | 46.5484343 | -87.4269822 | 906-228-8756 | |||
S000770-traverse_city | Debbie Stabenow S000770 | 3335 S. Airport Road West | Suite 6B | Traverse City | MI | 49684 | 44.7222478 | -85.642375 | 231-929-1031 |
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);