offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,163 rows sorted by suite
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite ▼ | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
G000592-lewiston | Jared Golden G000592 | 179 Lisbon St | Lewiston | ME | 04240-7248 | 44.09552 | -70.21691 | 207-241-6767 | ||||
H001053-harrisonville | Vicky Hartzler H001053 | 1909 N. Commercial St. | Harrisonville | MO | 64701 | 38.6630256 | -94.36446319999999 | 816-884-3411 | 816-884-3163 | |||
H001053-lebanon | Vicky Hartzler H001053 | 219 N. Adams St. | Lebanon | MO | 65536 | 37.6821821 | -92.6645922 | 417-532-5582 | 417-532-3886 | |||
H001056-chehalis | Jaime Herrera Beutler H001056 | 350 N. Market Blvd. | Chehalis | WA | 98532 | 46.6639928 | -122.9672327 | Chehalis City Hall Building | Tuesdays from 11:30am - 1:00pm | |||
H001061-watford_city | John Hoeven H001061 | Watford City | ND | 701-609-2727 | ||||||||
H001068-ukiah | Jared Huffman H001068 | 559 Low Gap Rd. | Ukiah | CA | 95482 | 39.1598605 | -123.2154259 | 707-962-0905 | 707-671-7449 | |||
H001071-monroe | Jody Hice H001071 | 100 Court St. | Monroe | GA | 30655 | 33.7942004 | -83.71309769999999 | 770-207-1776 | 770-266-6751 | |||
H001074-franklin | Trey Hollingsworth H001074 | 100 E Jefferson St | Franklin | IN | 46131-2323 | 39.48083 | -86.05373 | 317-851-8710 | ||||
H001074-jeffersonville | Trey Hollingsworth H001074 | 321 Quartermaster Ct. | Jeffersonville | IN | 47130 | 38.2842586 | -85.7435028 | 812-288-3999 | ||||
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 | ||
J000032-houston | Sheila Jackson Lee J000032 | 4300 Lyons Ave. | Houston | TX | 77020 | 29.7758442 | -95.3269342 | 713-227-7740 | M-F 9-5:30pm | |||
J000032-houston-3 | Sheila Jackson Lee J000032 | 420 W 19th St | Houston | TX | 77008-3914 | 29.8026 | -95.4038 | 713-861-4070 | M-F 9-5:30pm | |||
J000289-bucyrus | Jim Jordan J000289 | 500 S. Sandusky Ave. | Bucyrus | OH | 44820 | 40.8042672 | -82.9752194 | 419-663-1426 | Tu/Th - 8am to 4:30pm | |||
J000289-lima | Jim Jordan J000289 | 3121 W. Elm Plz. | Lima | OH | 45805 | 40.7369756 | -84.161425 | 419-999-6455 | 419-999-4238 | M-F 8:30AM-5PM | ||
J000289-norwalk | Jim Jordan J000289 | 13 B E. Main St. | Norwalk | OH | 44857 | 41.2425971 | -82.6150462 | 419-663-1426 | 419-668-3015 | M-F 8:30AM-5PM | ||
J000292-cambridge | Bill Johnson J000292 | 116 Southgate Pkwy. | Cambridge | OH | 43725 | 40.0243891 | -81.5899869 | 740-432-2366 | 740-432-2587 | |||
J000292-marietta | Bill Johnson J000292 | 246 Front St. | Marietta | OH | 45750 | 39.413511 | -81.45460899999999 | 740-376-0868 | 740-376-0886 | |||
J000292-salem | Bill Johnson J000292 | 192 E. State St. | Salem | OH | 44460 | 40.9010799 | -80.8561222 | 330-337-6951 | 330-337-7125 | |||
J000295-twinsburg | David Joyce J000295 | 10075 Ravenna Road | Twinsburg | OH | 44087 | 41.3183054 | -81.4478297 | 330-357-4139 | 330-425-7071 | Twinsburg Gov. Center | ||
J000301-aberdeen | Dusty Johnson J000301 | 304 6th Ave SE | Aberdeen | SD | 57401-6102 | 45.45894 | -98.48235 | 605-622-1060 | 605-262-0150 | |||
J000302-altoona | John Joyce J000302 | 5414 6th Ave | Altoona | PA | 16602-1203 | 40.4756 | -78.42257 | 814-656-6081 | ||||
K000009-cleveland | Marcy Kaptur K000009 | 17021 Lorain | Cleveland | OH | 44111 | 41.4502564 | -81.8160502 | 216-767-5933 | 419-255-9623 | |||
K000367-moorhead | Amy Klobuchar K000367 | 121 4th Street South | Moorhead | MN | 56560 | 46.873119 | -96.774188 | 218-287-2219 | 218-287-2930 | |||
K000375-plymouth | William Keating K000375 | 170 Court St. | Plymouth | MA | 02360 | 41.9636518 | -70.6753841 | 508-746-9000 | 508-732-0072 | |||
K000376-sharon | Mike Kelly K000376 | 33 Chestnut Ave. | Sharon | PA | 16146 | 41.2315486 | -80.5079773 | 724-342-7170 | 724-342-7242 | Monday through Friday, 9 a.m. to 5 p.m. | ||
K000378-watseka | Adam Kinzinger K000378 | 342 W. Walnut | Watseka | IL | 60970 | 40.7762446 | -87.7383019 | 815-432-0580 | Meetings by appointment. | |||
K000381-port_angeles | Derek Kilmer K000381 | 332 E. 5th St. | Port Angeles | WA | 98362 | 48.113181 | -123.431753 | 360-797-3623 | Tues: 9:00am-Noon (PST) Wed: 12:00pm-4:00pm (PST) Thurs: 9:00am-Noon (PST) | |||
K000383-biddeford | Angus King K000383 | 227 Main Street | Biddeford | ME | 04005 | 43.493662 | -70.457006 | 207-352-5216 | ||||
K000385-chicago | Robin Kelly K000385 | 1000 E. 111th St. | Chicago | IL | 60628 | 41.6944193 | -87.6012886 | 773-321-2001 | 9:00am-5:00pm | |||
K000386-auburn | John Katko K000386 | 71 Genesee St. | Auburn | NY | 13021 | 42.9318995 | -76.5664577 | 315-253-4068 | 315-253-2435 | |||
K000386-lyons | John Katko K000386 | 7376 State Route 31 | Lyons | NY | 14489 | 43.072187 | -77.03685779999999 | 315-253-4068 | Please call to make an appointment | |||
K000388-corinth | Trent Kelly K000388 | 4135 County Road 200 | Corinth | MS | 38844 | 34.9303984 | -88.43363889999999 | 662-687-1525 | 662-841-8845 | |||
K000388-eupora | Trent Kelly K000388 | 855 S. Dunn St. | Eupora | MS | 39744 | 33.5403014 | -89.2688098 | 662-258-7240 | 662-258-7240 | |||
K000388-tupelo | Trent Kelly K000388 | 431 W. Main St. | Tupelo | MS | 38804 | 34.2570023 | -88.70811259999999 | 662-841-8808 | 662-841-8845 | |||
K000392-dyersburg | David Kustoff K000392 | 425 W Court St | Dyersburg | TN | 38024-4616 | 36.03304 | -89.38925 | 731-412-1037 | ||||
K000392-jackson | David Kustoff K000392 | 117 North Liberty Street | Jackson | TN | 38301 | 35.6149736 | -88.81841440000001 | 731-423-4848 | 731-427-1537 | |||
K000393-mandeville | John Kennedy K000393 | 21490 Koop Dr. | Mandeville | LA | 70471 | 30.4182357 | -90.0470795 | 985-809-8153 | Building A | By appointment only | ||
K000394-marlton | Andy Kim K000394 | 535 E Main St | Marlton | NJ | 08053-2301 | 39.88539 | -74.89656 | |||||
K000394-toms_river | Andy Kim K000394 | 33 Washington St | Toms River | NJ | 08753-7642 | 39.95223 | -74.19681 | |||||
L000551-albany | Barbara Lee L000551 | 1249 Marin Ave. | Albany | CA | 94706 | 37.8879742 | -122.2932172 | Albany Community Center | Every 1st & 3rd Wed 3pm - 5pm | |||
L000551-oakland-1 | Barbara Lee L000551 | 1470 Fruitvale Ave. | Oakland | CA | 94601 | 37.7784791 | -122.2250837 | Every 1st & 3rd Thurs. 3pm-5pm (PST) | ||||
L000551-san_leandro | Barbara Lee L000551 | 300 Estudillo Ave. | San Leandro | CA | 94577 | 37.7260242 | -122.1540198 | Room C | Every 1st & 3rd Tues. 3 pm – 5 pm (PST) | |||
L000564-buena_vista | Doug Lamborn L000564 | 415 Main St. | Buena Vista | CO | 81211 | 38.842985 | -106.128575 | 719-520-0055 | 719-520-0840 | By appointment only | ||
L000569-jefferson_city | Blaine Luetkemeyer L000569 | 2117 Missouri Blvd. | Jefferson City | MO | 65109 | 38.5813109 | -92.20679520000002 | 573-635-7232 | 573-635-8347 | |||
L000569-washington | Blaine Luetkemeyer L000569 | 516 Jefferson St. | Washington | MO | 63090 | 38.5560438 | -91.0132469 | 636-239-2276 | 636-239-0478 | |||
L000569-wentzville | Blaine Luetkemeyer L000569 | 113 E. Pearce Blvd. | Wentzville | MO | 63385 | 38.8122807 | -90.85187169999999 | 636-327-7055 | ||||
L000570-farmington | Ben Luján L000570 | 800 Municipal Dr. | Farmington | NM | 87401 | 36.7378735 | -108.2167002 | 505-324-1005 | 505-324-1026 | |||
L000570-gallup | Ben Luján L000570 | 110 W. Aztec Ave. | Gallup | NM | 87301 | 35.5265052 | -108.7413892 | 505-863-0582 | 505-863-0678 | |||
L000570-tucumcari | Ben Luján L000570 | 404 W. Route 66 Blvd. | Tucumcari | NM | 88401 | 35.1718132 | -103.7221881 | 575-461-3029 | 575-461-3192 | |||
L000576-springfield | Billy Long L000576 | 3232 E. Ridgeview St. | Springfield | MO | 65804 | 37.1590571 | -93.22940179999999 | 417-889-1800 | 417-889-4915 | |||
L000578-auburn | Doug LaMalfa L000578 | 2399 Rickenbacker Way | Auburn | CA | 95602 | 38.9527935 | -121.0815891 | 530-878-5035 | ||||
L000585-jacksonville | Darin LaHood L000585 | 201 W. Morgan St. | Jacksonville | IL | 62650 | 39.7336397 | -90.22998150000001 | 217-245-1431 | 217-243-6852 | |||
L000585-springfield | Darin LaHood L000585 | 235 S. Sixth St. | Springfield | IL | 62701 | 39.79957450000001 | -89.648127 | 217-670-1653 | 217-670-1806 | |||
L000586-tallahassee | Al Lawson L000586 | 435 N. Macomb St. | Tallahassee | FL | 32301 | 30.4463425 | -84.28819759999999 | 850-558-9450 | 850-577-0633 | |||
L000588-monaca | Conor Lamb L000588 | 3468 Brodhead Rd | Monaca | PA | 15061-3149 | 40.65095 | -80.3124 | 724-206-4860 | ||||
L000588-pittsburgh | Conor Lamb L000588 | 504 Washington Rd | Pittsburgh | PA | 15228-2817 | 40.38423 | -80.04388 | 412-344-5583 | ||||
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 | ||
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 | ||
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 | ||
M000687-catonsville | Kweisi Mfume M000687 | 754 Frederick Road | Catonsville | MD | 21228 | 39.2719068 | -76.7336972 | 410-818-2120 | ||||
M001111-vancouver | Patty Murray M001111 | 1323 Officer's Row | Vancouver | WA | 98661 | 45.6276649 | -122.657351 | 360-696-7797 | 360-696-7798 | The Marshall House | ||
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 | ||
M001156-black_mountain | Patrick McHenry M001156 | 160 Midland Ave. | Black Mountain | NC | 28711 | 35.619814 | -82.3197859 | 828-669-0600 | Mondays & Wednesdays, 12 PM to 5 PM | |||
M001159-colville | Cathy McMorris Rodgers M001159 | 555 S. Main St. | Colville | WA | 99114 | 48.5392665 | -117.9052868 | 509-684-3481 | ||||
M001166-antioch | Jerry McNerney M001166 | 4703 Lone Tree Way | Antioch | CA | 94531 | 37.9662464 | -121.7741565 | 925-754-0716 | 925-754-0728 | Antioch Community Center | ||
M001180-parkersburg | David McKinley M001180 | 408 Market St. | Parkersburg | WV | 26101 | 39.2653465 | -81.56126309999999 | 304-422-5972 | 304-422-5974 | |||
M001183-fairmont | Joe Manchin M001183 | 230 Adams St. | Fairmont | WV | 26554 | 39.4846406 | -80.1429364 | 304-368-0567 | 304-368-0198 | |||
M001190-claremore | Markwayne Mullin M001190 | 223 W Patti Page Blvd | Claremore | OK | 74017-8046 | 36.30985 | -95.61233 | 918-283-6262 | 918-923-6451 | Monday-Friday, 8:00am-5:00pm CT | ||
M001190-muskogee | Markwayne Mullin M001190 | 811 N York St Ste A | Muskogee | OK | 74403-3860 | 35.75024 | -95.34046 | 918-687-2533 | 918-686-0128 | Monday-Friday, 8:00am-5:00pm CT | ||
M001196-salem | Seth Moulton M001196 | 21 Front St. | Salem | MA | 01970 | 42.5204343 | -70.8944236 | 978-531-1669 | 978-224-2270 | |||
M001198-salina | Roger Marshall M001198 | 200 E. Iron Ave. | Salina | KS | 67401 | 38.8403082 | -97.60774119999999 | 785-829-9000 | ||||
M001199-port_st__lucie | Brian Mast M001199 | 121 SW. Port St. Lucie Blvd. | Port St. Lucie | FL | 34984 | 27.2741604 | -80.3430288 | 772-336-2877 | ||||
M001199-stuart | Brian Mast M001199 | 171 SW Flagler Ave. | Stuart | FL | 34994 | 27.2006096 | -80.2582352 | 772-403-0900 | ||||
M001204-palmyra | Daniel Meuser M001204 | 1044 E Main St | Palmyra | PA | 17078-9501 | 40.31559 | -76.57823 | |||||
M001205-beckley | Carol Miller M001205 | 307 Prince St | Beckley | WV | 25801-4515 | 37.77843 | -81.17965 | 304-250-6177 | ||||
M001205-bluefield | Carol Miller M001205 | 601 Federal St | Bluefield | WV | 24701-3066 | 37.26693 | -81.22171 | Elizabeth Kee Federal Building | ||||
M001205-huntington | Carol Miller M001205 | 845 5th Ave | Huntington | WV | 25701-2014 | 38.41913 | -82.44445 | 304-522-2201 | Sidney L. Christie FB | |||
M001208-atlanta | Lucy McBath M001208 | 5775 Glenridge Dr. | Atlanta | GA | 30328-5380 | 33.91263 | -84.35953 | 470-773-6330 | Building B, Suite 380 | |||
M001210-jacksonville | Gregory Murphy M001210 | 234 Northwest Corridor Blvd. | Jacksonville | NC | 28540 | 34.7798159 | -77.48408909999999 | 910-937-6929 | ||||
N000002-brooklyn | Jerrold Nadler N000002 | 6605 Fort Hamilton Pkwy. | Brooklyn | NY | 11219 | 40.6298149 | -74.0100219 | 718-373-3198 | ||||
N000015-pittsfield | Richard Neal N000015 | 78 Center St. | Pittsfield | MA | 01201 | 42.4521544 | -73.25534979999999 | 413-442-0946 | 413-443-2792 | |||
N000189-twisp | Dan Newhouse N000189 | PO Box 823 | Twisp | WA | 98856-0823 | 48.3634784 | -120.122303 | 509-433-7760 | ||||
N000190-gaffney | Ralph Norman N000190 | 110 Railroad Ave. | Gaffney | SC | 29340 | 35.076577 | -81.642889 | Cherokee Admin. Building | 9am-4:30pm every Thursday | |||
P000034-long_branch | Frank Pallone P000034 | 504 Broadway | Long Branch | NJ | 07740 | 40.299971 | -73.99841099999999 | 732-571-1140 | 732-870-3890 | |||
P000034-new_brunswick | Frank Pallone P000034 | 67/69 Church St. | New Brunswick | NJ | 08901 | 40.4962932 | -74.4427577 | 732-249-8892 | 732-249-1335 | |||
P000096-englewood | Bill Pascrell P000096 | 2-10 N. Van Brunt St. | Englewood | NJ | 07631 | 40.8946254 | -73.97540300000001 | 201-935-2248 | Tues, Thurs 9am-5pm | |||
P000096-lyndhurst | Bill Pascrell P000096 | 367 Valley Brook Ave. | Lyndhurst | NJ | 07071 | 40.8126716 | -74.1243659 | 201-935-2248 | Wed, Fri 9am-5pm | |||
P000096-passaic | Bill Pascrell P000096 | 330 Passaic St. | Passaic | NJ | 07055 | 40.8612025 | -74.12380890000001 | 973-472-4510 | 1st Street | Mon, Wed 9am-5pm | ||
P000597-waterville | Chellie Pingree P000597 | 1 Silver St. | Waterville | ME | 04901 | 44.5488273 | -69.62960439999999 | 207-873-5713 | 207-873-5717 | |||
P000599-melbourne | Bill Posey P000599 | 2725 Judge Fran Jamieson Way | Melbourne | FL | 32940 | 28.246385 | -80.736905 | 321-632-1776 | 321-639-8595 | Building C | ||
P000601-gulfport | Steven Palazzo P000601 | 84 48th St | Gulfport | MS | 39507-4052 | 30.40959 | -89.05056 | 228-864-7670 | 228-864-3099 | |||
P000603-bowling_green | Rand Paul P000603 | 1029 State St. | Bowling Green | KY | 42101 | 36.991545 | -86.44277609999999 | 270-782-8303 | ||||
P000604-hillside | Donald Payne P000604 | 1455 Liberty Ave. | Hillside | NJ | 07205 | 40.70234809999999 | -74.228127 | 862-229-2994 | 862-225-2941 | Mon-Fri 9am-6pm | ||
P000604-jersey_city | Donald Payne P000604 | 253 Martin Luther King Dr. | Jersey City | NJ | 07305 | 40.7077679 | -74.0826434 | 201-369-0392 | 201-369-0395 | |||
P000605-wormleysburg | Scott Perry P000605 | 730 N. Front St. | Wormleysburg | PA | 17043 | 40.26472500000001 | -76.909221 | 717-635-9504 | 717-635-9861 | 9:00 a.m. - 5:00 p.m., M-F | ||
P000609-oneonta | Gary Palmer P000609 | 220 2nd Ave E | Oneonta | AL | 35121 | 33.9464211 | -86.4781082 | 205-625-4160 | Blount County Courthouse | |||
P000610-frederiksted | Stacey Plaskett P000610 | 60 King St. | Frederiksted | VI | 00840 | 17.712475 | -64.882701 | 340-778-5900 | 340-778-5111 | 8:30 - 5pm | ||
P000613-salinas | Jimmy Panetta P000613 | 100 W. Alisal St. | Salinas | CA | 93901 | 36.6737182 | -121.6575375 | 831-424-2229 | 831-424-7099 | |||
P000617-boston | Ayanna Pressley P000617 | 1700 Dorchester Ave | Boston | MA | 02122-1373 | 42.2987 | -71.05997 | |||||
Q000023-chicago | Mike Quigley Q000023 | 4345 N. Milwaukee Ave. | Chicago | IL | 60641 | 41.9600352 | -87.7536327 | 773-267-5926 | 773-267-6583 | Portage Park Office | Monday - Friday 9am - 5:30pm |
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);