offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
5 rows where legislator_id = "D000622" sorted by phone
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city | state | zip | latitude | longitude | phone ▼ | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
D000622-springfield | Tammy Duckworth D000622 | 8 South Old State Capitol Plaza | Springfield | IL | 62701 | 39.800468 | -89.6509028 | 217-528-6124 | ||||
D000622-rock_island | Tammy Duckworth D000622 | 1823 2nd Ave | Suite 2 | Rock Island | IL | 61201-8002 | 41.51114 | -90.57433 | 309-606-7060 | 309-786-1799 | ||
D000622-chicago | Tammy Duckworth D000622 | 230 South Dearborn Street | Suite 3900 | Chicago | IL | 60604 | 41.8784454 | -87.63 | 312-886-3506 | |||
D000622-carbondale | Tammy Duckworth D000622 | 441 E Willow St | Carbondale | IL | 62901-1659 | 37.73428 | -89.21251 | 618-677-7000 | 618-351-1551 | |||
D000622-belleville | Tammy Duckworth D000622 | 23 Public Sq | Suite 460 | Belleville | IL | 62220-1650 | 38.5135 | -89.98093 | 618-722-7070 | 618-235-4011 |
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);