offices

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

5 rows where legislator_id = "B001295"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: phone

id ▼ legislator_id address suite city state zip latitude longitude phone fax building hours
B001295-alton Mike Bost B001295 101 E. Third St.   Alton IL 62002 38.8906416 -90.18395149999999 618-622-0766     First Thursday of every month from 9:00 a.m. until 11:00 a.m.
B001295-carbondale Mike Bost B001295 300 E. Main St. Suite 4 Carbondale IL 62901 37.7277729 -89.2134992 618-457-5787 618-457-2990 Hunter Building  
B001295-granite_city Mike Bost B001295 2000 Edison Ave.   Granite City IL 62040 38.7015611 -90.14887449999999 618-622-0766   City Hall The third Thursday of each month from 1:00 p.m. to 4:00 p.m.
B001295-mt__vernon Mike Bost B001295 1100 Main St.   Mt. Vernon IL 62864 38.317936 -88.9049835 618-513-5294   Mt. Vernon City Hall Tuesdays 9 a.m. to 12 p.m.
B001295-o_fallon Mike Bost B001295 302 West State St.   O'Fallon IL 62269 38.5925108 -89.9141608 618-622-0766 618-622-0774    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);