offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
2 rows where legislator_id = "C000266" sorted by hours
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
C000266-cincinnati | Steve Chabot C000266 | 441 Vine St. | Rm. 3003 | Cincinnati | OH | 45202 | 39.100836 | -84.513238 | 513-684-2723 | 513-421-8722 | 9 a.m. - 5 p.m. | |
C000266-lebanon | Steve Chabot C000266 | 11 S. Broadway | Lebanon | OH | 45036 | 39.4341674 | -84.2086104 | 513-421-8704 | 513-421-8722 | 9am-5pm |
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);