offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "T000193"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
T000193-bolton | Bennie Thompson T000193 | 107 W. Madison St. | Bolton | MS | 39041 | 32.348821 | -90.459947 | 601-866-9003 | 601-866-9036 | |||
T000193-greenville | Bennie Thompson T000193 | 910 Courthouse Ln. | Greenville | MS | 38701 | 33.4079337 | -91.051782 | 662-335-9003 | 662-334-1304 | |||
T000193-greenwood | Bennie Thompson T000193 | 728 Main Street | Suite A | Greenwood | MS | 38930 | 33.5146884 | -90.1821178 | 662-455-9003 | 662-453-0118 | ||
T000193-jackson | Bennie Thompson T000193 | 3607 Medgar Evers Blvd. | Jackson | MS | 39213 | 32.339995 | -90.214478 | 601-946-9003 | 601-982-5337 | |||
T000193-marks | Bennie Thompson T000193 | 263 E. Main St. | Marks | MS | 38646 | 34.2568675 | -90.2711465 | 662-326-9003 | ||||
T000193-mound_bayou | Bennie Thompson T000193 | 106 Green Avenue | Suite 106 | Mound Bayou | MS | 38762 | 33.8783982 | -90.7298777 | 662-741-9003 | 662-741-9002 |
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);