offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
6 rows where legislator_id = "D000619"
This data as json, copyable, CSV (advanced)
Suggested facets: phone, hours
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
D000619-champaign | Rodney Davis D000619 | 2004 Fox Dr. | Champaign | IL | 61280 | 40.090932 | -88.25012439999999 | 217-403-4690 | 217-403-4691 | Monday - Friday, 8:30am - 5:00pm | ||
D000619-decatur | Rodney Davis D000619 | 243 S. Water St. | Suite 100 | Decatur | IL | 62523 | 39.8396384 | -88.954852 | 217-791-6224 | 217-791-6168 | Mon-Fri 8:30am-5pm | |
D000619-maryville | Rodney Davis D000619 | 15 Professional Park Dr. | Maryville | IL | 62062 | 38.737077 | -89.95489859999999 | 618-205-8660 | 618-205-8662 | Monday-Friday, 8:30am-5:00pm | ||
D000619-normal | Rodney Davis D000619 | 104 W. North St. | Normal | IL | 61761 | 40.5094581 | -88.9846312 | 309-252-8834 | By appointment only | |||
D000619-springfield | Rodney Davis D000619 | 2833 S Grand Ave. East | Springfield | IL | 62703 | 39.7888553 | -89.6124109 | 217-791-6224 | 217-791-6166 | By appointment only | ||
D000619-taylorville | Rodney Davis D000619 | 108 W. Market St. | Taylorville | IL | 62568 | 39.5480891 | -89.29549949999999 | 217-824-5117 | 217-824-5121 | Monday - Friday, 8:30am - 5:00pm |
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);