offices
1 row where legislator_id = "C001119"
This data as json, CSV (advanced)
| id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | fax | phone | building | hours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| C001119-eagan | C001119 | 1915 Plaza Dr. | Suite 202 | Eagan | MN | 55122 | 44.7869612 | -93.2034681 | 651-846-2120 |
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" REAL,
"longitude" REAL,
"fax" TEXT,
"phone" TEXT,
"building" TEXT
, "hours" TEXT);