offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,163 rows sorted by longitude descending
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city | state | zip | latitude | longitude ▲ | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
S001204-hagatna | Michael San Nicolas S001204 | 330 Hernan Cortez Ave | Fl 3 | Hagatna | GU | 96910-5081 | 13.4763888 | 144.7455451 | ||||
P000610-frederiksted | Stacey Plaskett P000610 | 60 King St. | Frederiksted | VI | 00840 | 17.712475 | -64.882701 | 340-778-5900 | 340-778-5111 | 8:30 - 5pm | ||
P000610-st__thomas | Stacey Plaskett P000610 | 9100 Havensight | Suite 22 | St. Thomas | VI | 00802 | 18.334264 | -64.919169 | 340-774-4408 | 340-774-8033 | Port of Sale Mall | 8:30-5pm |
K000383-presque_isle | Angus King K000383 | 169 Academy St. | Suite A | Presque Isle | ME | 04769 | 46.6766073 | -67.9956649 | 207-764-5124 | |||
C001035-caribou | Susan Collins C001035 | 25 Sweden St. | Suite A | Caribou | ME | 04736 | 46.860458 | -68.013198 | 207-493-7873 | |||
G000592-caribou | Jared Golden G000592 | 7 Hatch Dr | Suite 230 | Caribou | ME | 04736-2159 | 46.85918 | -68.01637 | 207-492-6009 | |||
G000592-bangor | Jared Golden G000592 | 6 State St | Suite 101 | Bangor | ME | 04401-5112 | 44.8023 | -68.77015 | 207-249-7400 | |||
C001035-bangor | Susan Collins C001035 | 202 Harlow St. | Room 20100 | Bangor | ME | 04401 | 44.8046399 | -68.7737891 | 207-945-0417 | |||
K000383-bangor | Angus King K000383 | 202 Harlow St. | Suite 20350 | Bangor | ME | 04401 | 44.8046399 | -68.7737891 | 207-945-8000 | |||
P000597-waterville | Chellie Pingree P000597 | 1 Silver St. | Waterville | ME | 04901 | 44.5488273 | -69.62960439999999 | 207-873-5713 | 207-873-5717 | |||
C001035-augusta | Susan Collins C001035 | 68 Sewall St. | Room 507 | Augusta | ME | 04330 | 44.310824 | -69.783697 | 207-622-8414 | |||
K000383-augusta | Angus King K000383 | 4 Gabriel Dr. | Suite 3 | Augusta | ME | 04330 | 44.3676495 | -69.7940768 | 207-622-8292 | |||
G000592-lewiston | Jared Golden G000592 | 179 Lisbon St | Lewiston | ME | 04240-7248 | 44.09552 | -70.21691 | 207-241-6767 | ||||
C001035-lewiston | Susan Collins C001035 | 55 Lisbon St. | Lewiston | ME | 04240 | 44.097439 | -70.217972 | 207-784-6969 | ||||
P000597-portland | Chellie Pingree P000597 | 2 Portland Fish Pier | Suite 304 | Portland | ME | 04101 | 43.651525 | -70.25413499999999 | 207-774-5019 | 207-871-0720 | ||
C001035-portland | Susan Collins C001035 | One Canal Plaza | Suite 802 | Portland | ME | 04101 | 43.6566885 | -70.2551294 | 207-780-3575 | |||
K000375-hyannis | William Keating K000375 | 259 Stevens St. | Suite E | Hyannis | MA | 02601 | 41.6511319 | -70.2939487 | 508-771-6868 | 508-790-1959 | ||
C001035-biddeford | Susan Collins C001035 | 160 Main St. | Biddeford | ME | 04005 | 43.493177 | -70.4548329 | 207-283-1101 | ||||
K000383-biddeford | Angus King K000383 | 227 Main Street | Biddeford | ME | 04005 | 43.493662 | -70.457006 | 207-352-5216 | ||||
K000375-plymouth | William Keating K000375 | 170 Court St. | Plymouth | MA | 02360 | 41.9636518 | -70.6753841 | 508-746-9000 | 508-732-0072 | |||
H001076-portsmouth | Margaret Hassan H001076 | 14 Manchester Square | Suite 140 | Portsmouth | NH | 03801 | 43.0856076 | -70.8098029 | 603-433-4445 | |||
S001181-dover | Jeanne Shaheen S001181 | 340 Central Ave. | Suite 205 | Dover | NH | 03820 | 43.1952108 | -70.8748699 | 603-750-3004 | |||
P000614-dover | Chris Pappas P000614 | 660 Central Ave | Suite 101 | Dover | NH | 03820-3491 | 43.20588 | -70.87583 | 603-285-4300 | |||
M001196-salem | Seth Moulton M001196 | 21 Front St. | Salem | MA | 01970 | 42.5204343 | -70.8944236 | 978-531-1669 | 978-224-2270 | |||
K000375-new_bedford | William Keating K000375 | 128 Union Street | Suite 103 | New Bedford | MA | 02740 | 41.6339983 | -70.9267013 | 508-999-6462 | 508-999-6468 | ||
L000562-quincy | Stephen Lynch L000562 | 1245 Hancock St. | Suite 41 | Quincy | MA | 02169 | 42.2526962 | -71.0049509 | 617-657-6305 | 617-773-0955 | ||
L000562-brockton | Stephen Lynch L000562 | 37 Belmont Street | 2nd Floor, Suite 3 | Brockton | MA | 02301 | 42.080643 | -71.023661 | 508-586-5555 | 508-580-4692 | ||
L000562-boston | Stephen Lynch L000562 | One Harbor Street | Suite 304 | Boston | MA | 02210 | 42.3455095 | -71.035511 | 617-428-2000 | 617-428-2011 | ||
M000133-boston | Edward Markey M000133 | 15 Sudbury St. | 975 | Boston | MA | 02203 | 42.3613091 | -71.0593927 | 617-565-8519 | 617-248-3870 | JFK Federal Building | |
W000817-boston | Elizabeth Warren W000817 | 15 Sudbury St. | Boston | MA | 02203 | 42.3613091 | -71.0593927 | 617-565-3170 | 2400 JFK Federal Building | |||
P000617-boston | Ayanna Pressley P000617 | 1700 Dorchester Ave | Boston | MA | 02122-1373 | 42.2987 | -71.05997 | |||||
C001101-cambridge | Katherine Clark C001101 | 701 Concord Ave. | Suite 101 | Cambridge | MA | 02138 | 42.390572 | -71.151338 | 617-354-0292 | Mon-Fri 9am-5:30pm | ||
T000482-lawrence | Lori Trahan T000482 | 15 Union St | 4th Floor | Lawrence | MA | 01840-1866 | 42.70637 | -71.15331 | ||||
M000133-fall_river | Edward Markey M000133 | 222 Milliken Blvd. | Suite 312 | Fall River | MA | 02721 | 41.6999176 | -71.15872660000001 | 508-677-0523 | |||
S001181-berlin | Jeanne Shaheen S001181 | 961 Main St. | Berlin | NH | 03570 | 44.4781896 | -71.1708276 | 603-752-6300 | ||||
H001076-berlin | Margaret Hassan H001076 | 168 Main Street | Lower Level | Berlin | NH | 03570 | 44.469939 | -71.1821158 | 603-752-6190 | Berlin City Hall | ||
T000482-lowell | Lori Trahan T000482 | 126 John St | Suite 12 | Lowell | MA | 01852-1152 | 42.64756 | -71.30745 | 978-459-0101 | |||
C001084-pawtucket | David Cicilline C001084 | 1070 Main St. | Suite 300 | Pawtucket | RI | 02860 | 41.8610791 | -71.3986461 | 401-729-5600 | 401-729-5608 | Mon-Fri 8:30am-5:30pm | |
R000122-providence | John Reed R000122 | One Exchange Terrace | Suite 408 | Providence | RI | 02903-1744 | 41.8262057 | -71.4109836 | 401-528-5200 | 202-224-4680 | U.S. District Courthouse | |
W000802-providence | Sheldon Whitehouse W000802 | 170 Westminster St. | Suite 200 | Providence | RI | 02903 | 41.8235873 | -71.4113021 | 401-453-5294 | 401-453-5085 | ||
C001101-framingham | Katherine Clark C001101 | 116 Concord St. | Suite 1 | Framingham | MA | 01702 | 42.2787415 | -71.41700349999999 | 508-319-9757 | M-F 9-5:30 | ||
R000122-cranston | John Reed R000122 | 1000 Chapel View Blvd. | Suite 290 | Cranston | RI | 02920 | 41.7566184 | -71.4607281 | 401-943-3100 | 401-464-6837 | ||
S001181-manchester | Jeanne Shaheen S001181 | 2 Wall St. | Suite 220 | Manchester | NH | 03101 | 42.9940731 | -71.46386679999999 | 603-647-7500 | Mon-Fri 8:30am-5:00pm | ||
K000382-nashua | Ann Kuster K000382 | 184 Main Street | Suite 222 | Nashua | NH | 03060 | 42.7606386 | -71.4647244 | 603-595-2006 | 603-595-2016 | 8:30 AM - 5:00 PM, Monday - Friday | |
S001181-nashua | Jeanne Shaheen S001181 | 60 Main St. | Suite 217 | Nashua | NH | 03060 | 42.7633363 | -71.4659542 | 603-883-0196 | |||
H001076-manchester | Margaret Hassan H001076 | 1589 Elm Street | Third Floor | Manchester | NH | 03101 | 43.0009812 | -71.4662599 | 603-622-2204 | |||
H001076-nashua | Margaret Hassan H001076 | 142 Main Street | Suite 520 | Nashua | NH | 03060 | 42.7617932 | -71.4674553 | 603-880-3314 | |||
L000559-warwick | James Langevin L000559 | 300 Centerville Rd. | Suite 200 South | Warwick | RI | 02886 | 41.6944274 | -71.4705546 | 401-732-9400 | 401-737-2982 | Mon-Fri 8AM-5PM | |
K000382-concord | Ann Kuster K000382 | 18 N. Main St. | Fourth Floor | Concord | NH | 03301 | 43.2048069 | -71.5355091 | 603-226-1002 | 603-226-1010 | 8:30 AM - 5:00 PM, Monday - Friday | |
H001076-concord | Margaret Hassan H001076 | 53 Pleasant Street | Concord | NH | 03301 | 43.2024699 | -71.5416652 | 603-622-2204 | James C. Cleveland Federal Building | By appointment only | ||
M000312-leominster | James McGovern M000312 | 24 Church St. | Room 27 | Leominster | MA | 01453 | 42.5279312 | -71.7607974 | 978-466-3552 | 978-466-3973 | M-F 9-5:00pm | |
K000382-littleton | Ann Kuster K000382 | 33 Main St. | Suite 202 | Littleton | NH | 03561 | 44.3063587 | -71.7713705 | 603-444-7700 | |||
M000312-worcester | James McGovern M000312 | 12 E. Worcester St. | Suite 1 | Worcester | MA | 01604 | 42.2628409 | -71.7903444 | 508-831-7356 | 508-754-0982 | M-F 9-5:00pm | |
S000033-st__johnsbury | Bernard Sanders S000033 | 357 Western Ave. | Suite 1B | St. Johnsbury | VT | 05819 | 44.4173546 | -72.02646469999999 | 800-339-9834 | 802-860-6370 | ||
C001069-norwich | Joe Courtney C001069 | 55 Main St. | Suite 250 | Norwich | CT | 06360 | 41.524272 | -72.07896800000002 | 860-886-0139 | 860-886-2974 | ||
S001181-keene | Jeanne Shaheen S001181 | 12 Gilbo Ave. | Suite C | Keene | NH | 03431 | 42.9323699 | -72.2794587 | 603-358-6604 | |||
S001181-claremont | Jeanne Shaheen S001181 | 50 Opera House Sq. | Claremont | NH | 03743 | 43.3727196 | -72.3373946 | 603-542-4872 | ||||
C001069-enfield | Joe Courtney C001069 | 77 Hazard Ave. | Unit J | Enfield | CT | 06082 | 41.9904484 | -72.5723972 | 860-741-6011 | 860-741-6036 | ||
L000174-montpelier | Patrick Leahy L000174 | 87 State St. | Room 338 | Montpelier | VT | 05602 | 44.260997 | -72.5775843 | 802-229-0569 | |||
N000015-springfield | Richard Neal N000015 | 300 State St. | Suite 200 | Springfield | MA | 01105 | 42.1049876 | -72.58316479999999 | 413-785-0325 | 413-747-0604 | ||
M000133-springfield | Edward Markey M000133 | 1550 Main St. | 4th Floor | Springfield | MA | 01103 | 42.10321649999999 | -72.5929441 | 413-785-4610 | |||
W000817-springfield | Elizabeth Warren W000817 | 1550 Main St. | Suite 406 | Springfield | MA | 01103 | 42.10321649999999 | -72.5929441 | 413-788-2690 | |||
M000312-northampton | James McGovern M000312 | 94 Pleasant St. | Northampton | MA | 01060 | 42.3185388 | -72.6283162 | 413-341-8700 | 413-584-1216 | M-F 9-5:00pm | ||
Z000017-riverhead | Lee Zeldin Z000017 | 30 W. Main St. | Suite 201 | Riverhead | NY | 11901 | 40.9172285 | -72.6627645 | 631-209-4235 | Tues, Wed, Thurs, 10am - 2pm. By appointment only. | ||
M001169-hartford | Christopher Murphy M001169 | 120 Huyshope Ave. | Suite 401 | Hartford | CT | 06106 | 41.7559191 | -72.6646397 | 860-549-8463 | 860-524-5091 | Colt Gateway | |
B001277-hartford | Richard Blumenthal B001277 | 90 State House Sq. | 10th Floor | Hartford | CT | 06103 | 41.7665316 | -72.6719747 | 860-258-6940 | 860-258-6958 | ||
L000557-hartford | John Larson L000557 | 221 Main St. | 2nd Floor | Hartford | CT | 06106 | 41.7584184 | -72.6757241 | 860-278-8888 | 860-278-2111 | ||
D000216-new_haven | Rosa DeLauro D000216 | 59 Elm St. | New Haven | CT | 06510 | 41.3080224 | -72.92267679999999 | 203-562-3718 | 203-772-2260 | |||
Z000017-patchogue | Lee Zeldin Z000017 | 31 Oak St. | Suite 20 | Patchogue | NY | 11772 | 40.7671697 | -73.0138358 | 631-289-1097 | 631-289-1268 | ||
H001081-waterbury | Jahana Hayes H001081 | 108 Bank St | 2nd Floor | Waterbury | CT | 06702-2233 | 41.55442 | -73.04104 | 860-223-8412 | |||
H001047-bridgeport | James Himes H001047 | 211 State St. | 2nd Floor | Bridgeport | CT | 06604 | 41.1763593 | -73.1898756 | 203-333-6600 | 203-333-6655 | M - F 9:00 am to 5:00 pm | |
B001277-bridgeport | Richard Blumenthal B001277 | 915 Lafayette Blvd. | Suite 304 | Bridgeport | CT | 06604 | 41.1749972 | -73.1931954 | 203-330-0598 | 203-330-0608 | ||
L000174-burlington | Patrick Leahy L000174 | 199 Main St | 4th Floor | Burlington | VT | 05401 | 44.47553140000001 | -73.21128259999999 | 802-863-2525 | 800-642-3193 | ||
S000033-burlington | Bernard Sanders S000033 | 1 Church St. | 3rd Floor | Burlington | VT | 05401 | 44.4802081 | -73.21307019999999 | 802-862-0697 | 802-860-6370 | ||
W000800-burlington | Peter Welch W000800 | 128 Lakeside Ave. | Suite 235 | Burlington | VT | 05401 | 44.4626812 | -73.21776830000002 | 802-652-2450 | 888-605-7270 | ||
N000015-pittsfield | Richard Neal N000015 | 78 Center St. | Pittsfield | MA | 01201 | 42.4521544 | -73.25534979999999 | 413-442-0946 | 413-443-2792 | |||
S000148-melville | Charles Schumer S000148 | 145 Pine Lawn Rd. | Suite 300 | Melville | NY | 11747 | 40.7708436 | -73.40787569999999 | 631-753-0978 | 631-753-0997 | ||
G000555-melville | Kirsten Gillibrand G000555 | 155 Pinelawn Rd. | Suite 250 North | Melville | NY | 11747 | 40.7707877 | -73.41024759999999 | 631-249-2825 | 631-249-2847 | ||
S001201-huntington | Thomas Suozzi S001201 | 478A Park Avenue | Huntington | NY | 11743 | 40.873976 | -73.41131899999999 | 631-923-4100 | ||||
S001196-plattsburgh | Elise Stefanik S001196 | 23 Durkee St. | Suite C | Plattsburgh | NY | 12901 | 44.6964439 | -73.45244749999999 | 518-561-2324 | 518-561-2408 | ||
H001047-stamford | James Himes H001047 | 888 Washington Blvd. | 10th Floor | Stamford | CT | 06901 | 41.0514745 | -73.5428955 | 203-353-9400 | 203-323-1793 | Mon-Fri 9:00 am to 5:00 pm | |
R000602-garden_city | Kathleen Rice R000602 | 229 7th St. | Suite 300 | Garden City | NY | 11530 | 40.7258629 | -73.63281649999999 | 516-739-3008 | 516-739-2973 | ||
S001196-glens_falls | Elise Stefanik S001196 | 5 Warren St | Suite 4 | Glens Falls | NY | 12801-4565 | 43.30977 | -73.64131 | 518-743-0964 | 518-743-1391 | ||
S001201-little_neck | Thomas Suozzi S001201 | 250-02 Northern Boulevard | Little Neck | NY | 11362 | 40.7683191 | -73.7394598 | 718-631-0400 | Mon, Tue, and Thurs 9:00AM - 5:30PM by appointment | |||
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 | |
G000555-albany | Kirsten Gillibrand G000555 | 11A Clinton Avenue | Room 821 | Albany | NY | 12207 | 42.655222 | -73.7492819 | 518-431-0120 | 518-431-0128 | Leo W. O’Brien Federal Office Building | |
T000469-albany | Paul Tonko T000469 | 19 Dove St. | Suite 302 | Albany | NY | 12210 | 42.6553697 | -73.7616111 | 518-465-0700 | 518-427-5107 | ||
M001137-arverne | Gregory Meeks M001137 | 67-12 Rockaway Beach Blvd. | Arverne | NY | 11692 | 40.5907811 | -73.798273 | 347-230-4032 | 347-230-4045 | Tuesdays 10am-2pm, Wednesday-Friday- 9am-5pm | ||
M001137-jamaica | Gregory Meeks M001137 | 153-01 Jamaica Ave. | 2nd floor | Jamaica | NY | 11432 | 40.7030995 | -73.80205 | 718-725-6000 | 718-725-9868 | 9 am – 5:00 pm Mon – Thurs and Fri. 9:00 am – 3:00 pm (close at 3:00 pm for administrative purposes) | |
M001188-flushing | Grace Meng M001188 | 40-13 159th St. | Suite A | Flushing | NY | 11358 | 40.76260720000001 | -73.8062197 | 718-358-6364 | 718-445-7868 | ||
M001188-forest_hills | Grace Meng M001188 | 118-35 Queens Blvd. | 17th Floor | Forest Hills | NY | 11375 | 40.7148445 | -73.8310816 | 718-358-6364 | 718-445-7868 | By appointment only | |
G000555-yonkers | Kirsten Gillibrand G000555 | PO Box 749 | Yonkers | NY | 10710-0749 | 40.9188505 | -73.8596689 | 845-875-4585 | 845-875-9099 | |||
O000172-jackson_heights | Alexandria Ocasio-Cortez O000172 | 7409 37th Ave | Suite 305 | Jackson Heights | NY | 11372-6300 | 40.74924 | -73.89132 | ||||
E000297-bronx | Adriano Espaillat E000297 | 2530 Grand Concourse Avenue | Ground Floor | Bronx | NY | 10458 | 40.863512 | -73.895791 | 718-450-8241 | |||
S000148-peekskill | Charles Schumer S000148 | One Park Place | Suite 100 | Peekskill | NY | 10566 | 41.29051020000001 | -73.91672969999999 | 914-734-1532 | 914-734-1673 | ||
M000087-astoria | Carolyn Maloney M000087 | 31-19 Newtown Ave. | Astoria | NY | 11102-1391 | 40.7672194 | -73.9223996 | 718-932-1804 | 718-932-1805 | Monday 9:30am – 2:00pm; Tuesday – Thursday 9:30am – 5:00pm; Friday 10:00am – 4:00pm | ||
T000469-schenectady | Paul Tonko T000469 | 105 Jay St. | Room 15 | Schenectady | NY | 12305 | 42.8143015 | -73.9398087 | 518-374-4547 | 518-374-7908 | ||
E000297-new_york | Adriano Espaillat E000297 | 163 West 125th Street | #507 | New York | NY | 10027 | 40.8092343 | -73.9474317 | 212-663-3900 | Harlem State Office Building | ||
M000087-brooklyn | Carolyn Maloney M000087 | 619 Lorimer St. | Brooklyn | NY | 11211-2228 | 40.7155784 | -73.94987139999999 | 718-349-5972 | 718-349-5973 | Tuesday 9:00am – 5:00pm | ||
M000087-new_york | Carolyn Maloney M000087 | 1651 3rd Ave. | Suite 311 | New York | NY | 10128-3679 | 40.7828262 | -73.95068410000002 | 212-860-0606 | 212-860-0704 | Monday – Friday 9:00am – 6: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);