offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "M000355"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
M000355-bowling_green | Mitch McConnell M000355 | 241 E. Main St. | Room 102 | Bowling Green | KY | 42101 | 36.9948956 | -86.4430273 | 270-781-1673 | Federal Building | ||
M000355-fort_wright | Mitch McConnell M000355 | 1885 Dixie Hwy. | Suite 345 | Fort Wright | KY | 41011 | 39.0575706 | -84.542929 | 859-578-0188 | |||
M000355-lexington | Mitch McConnell M000355 | 771 Corporate Dr. | Suite 108 | Lexington | KY | 40503 | 38.0134107 | -84.5524557 | 859-224-8286 | |||
M000355-london | Mitch McConnell M000355 | 300 S. Main St. | Suite 310 | London | KY | 40741 | 37.1258183 | -84.0809548 | 606-864-2026 | |||
M000355-louisville | Mitch McConnell M000355 | 601 W. Broadway | Room 630 | Louisville | KY | 40202 | 38.2469833 | -85.7624677 | 502-582-6304 | |||
M000355-paducah | Mitch McConnell M000355 | 100 Fountain Ave. | Suite 300 | Paducah | KY | 42001 | 37.07925609999999 | -88.6172508 | 270-442-4554 |
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);