offices
2 rows where legislator_id = "A000369"
This data as json, CSV (advanced)
| id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | fax | phone | building | hours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A000369-elko | A000369 | Elko, NV 89801 | Elko | NV | 89801 | 40.8324211 | -115.7631232 | 775-777-7705 | ||||
| A000369-reno | A000369 | 5310 Kietzke Ln. | Suite 103 | Reno | NV | 89511 | 39.4715058 | -119.791273 | 775-686-5711 | 775-686-5760 |
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);