offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "G000386" sorted by latitude
This data as json, copyable, CSV (advanced)
Suggested facets: building
id | legislator_id | address | suite | city | state | zip | latitude ▼ | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
G000386-council_bluffs | Charles Grassley G000386 | 8 S. 6th St. | 307 | Council Bluffs | IA | 51501 | 41.2608863 | -95.8525576 | 712-322-7103 | 712-322-7196 | Federal Building | |
G000386-davenport | Charles Grassley G000386 | 201 W. 2nd St. | Suite 720 | Davenport | IA | 52801 | 41.5213296 | -90.5758645 | 563-322-4331 | 563-322-8552 | ||
G000386-des_moines | Charles Grassley G000386 | 210 Walnut St. | 721 | Des Moines | IA | 50309 | 41.5864152 | -93.62015319999999 | 515-288-1145 | 515-288-5097 | Federal Building | |
G000386-cedar_rapids | Charles Grassley G000386 | 111 7th Ave. SE | Suite 6800 | Cedar Rapids | IA | 52401 | 41.9731139 | -91.6645212 | 319-363-6832 | 319-363-7179 | ||
G000386-waterloo | Charles Grassley G000386 | 531 Commercial St. | 210 | Waterloo | IA | 50701 | 42.4953784 | -92.339384 | 319-232-6657 | 319-232-9965 | Waterloo Building | |
G000386-sioux_city | Charles Grassley G000386 | 320 6th St. | 120 | Sioux City | IA | 51101 | 42.4963261 | -96.40758369999999 | 712-233-1860 | 712-233-1634 | Federal Building |
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);