offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
5 rows where legislator_id = "H001089"
This data as json, copyable, CSV (advanced)
Suggested facets: suite
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
H001089-cape_girardeau | Joshua Hawley H001089 | 555 Independence Street | #1600 | Cape Girardeau | MO | 63703-6235 | 37.3039 | -89.52491 | 573-334-5995 | 573-334-5947 | ||
H001089-columbia | Joshua Hawley H001089 | 1123 Wilkes Blvd | Suite 220 | Columbia | MO | 65201-4774 | 38.96012 | -92.32279 | 202-860-5207 | |||
H001089-kansas_city | Joshua Hawley H001089 | 4141 Pennsylvania Ave | Suite 101 | Kansas City | MO | 64111-3051 | 39.05193 | -94.5903 | 816-960-4694 | 816-960-4815 | ||
H001089-springfield | Joshua Hawley H001089 | 324 Park Central West | Suite 101 | Springfield | MO | 65806-1245 | 37.2088 | -93.29409 | 417-869-4433 | 417-869-4411 | ||
H001089-st__louis | Joshua Hawley H001089 | 111 South 10th Street | Suite 23.366 | St. Louis | MO | 63102-1125 | 38.62588 | -90.196 | 314-354-7060 | 314-436-8534 |
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);