offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
8 rows where legislator_id = "S000148"
This data as json, copyable, CSV (advanced)
id ▼ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
S000148-albany | Charles Schumer S000148 | 1 Clinton Ave. | Room 420 | Albany | NY | 12207 | 42.65513869999999 | -73.749201 | 518-431-4070 | 518-431-4076 | Leo O'Brien Building | |
S000148-binghamton | Charles Schumer S000148 | 15 Henry St. | Room. 100 A-F | Binghamton | NY | 13901 | 42.1008749 | -75.9123579 | 607-772-6792 | 607-772-8124 | ||
S000148-buffalo | Charles Schumer S000148 | 130 S. Elmwood Ave. | #660 | Buffalo | NY | 14202 | 42.88902849999999 | -78.87954189999999 | 716-846-4111 | 716-846-4113 | ||
S000148-melville | Charles Schumer S000148 | 145 Pine Lawn Rd. | Suite 300 | Melville | NY | 11747 | 40.7708436 | -73.40787569999999 | 631-753-0978 | 631-753-0997 | ||
S000148-new_york | Charles Schumer S000148 | 780 Third Ave. | Suite 2301 | New York | NY | 10017 | 40.7550353 | -73.97185879999999 | 212-486-4430 | 202-228-2838 | ||
S000148-peekskill | Charles Schumer S000148 | One Park Place | Suite 100 | Peekskill | NY | 10566 | 41.29051020000001 | -73.91672969999999 | 914-734-1532 | 914-734-1673 | ||
S000148-rochester | Charles Schumer S000148 | 100 State St. | Room 3040 | Rochester | NY | 14614 | 43.1576631 | -77.613515 | 585-263-5866 | 585-263-3173 | ||
S000148-syracuse | Charles Schumer S000148 | 100 S. Clinton St. | Room 841 | Syracuse | NY | 13261 | 43.0501042 | -76.1543204 | 315-423-5471 | 315-423-5185 |
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);