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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Q000023-chicago-1 | Mike Quigley Q000023 | 3223 N. Sheffield Ave. | Chicago | IL | 60657 | 41.94076279999999 | -87.6538984 | 773-267-5926 | Monday - Friday 9am - 5pm | |||
R000395-hazard | Harold Rogers R000395 | 48 S. KY Hwy. 15 | Hazard | KY | 41701 | 37.3598755 | -83.2591463 | 606-439-0794 | 606-439-4647 | |||
R000395-somerset | Harold Rogers R000395 | 551 Clifty St. | Somerset | KY | 42503 | 37.0976576 | -84.6167349 | 800-632-8588 | 606-678-4856 | |||
R000515-chicago | Bobby Rush R000515 | 11750 S. Western Ave. | Chicago | IL | 60643-4732 | 41.6793889 | -87.6811963 | 773-779-2400 | 773-779-2401 | Monday – Friday, 9 a.m. – 6 p.m., Central | ||
R000577-akron | Tim Ryan R000577 | 1030 Tallmadge Ave. | Akron | OH | 44310 | 41.099949 | -81.478217 | 330-630-7311 | 330-630-7314 | M-F 9AM-5PM EST | ||
R000577-warren | Tim Ryan R000577 | 197 W. Market St. | Warren | OH | 44481 | 41.235888 | -80.819818 | 800-856-4152 | 330-373-0098 | M-F 9AM-5PM EST | ||
R000577-youngstown | Tim Ryan R000577 | 241 W. Federal St. | Youngstown | OH | 44503 | 41.1012396 | -80.6529585 | 330-740-0193 | 330-740-0182 | M-F 9AM-5PM EST | ||
R000605-rapid_city | Mike Rounds R000605 | 1313 W. Main St. | Rapid City | SD | 57701 | 44.0818193 | -103.2403111 | 605-343-5035 | 605-343-5348 | |||
R000609-jacksonville | John Rutherford R000609 | 4130 Salisbury Rd. | Jacksonville | FL | 32216 | 30.2539737 | -81.5959646 | 904-831-5205 | Suite 2500 | |||
S000522-hamilton | Christopher Smith S000522 | 4573 S. Broad St. | Hamilton | NJ | 08620 | 40.178635 | -74.67184200000001 | 609-585-7878 | 609-585-9155 | |||
S000522-plumsted | Christopher Smith S000522 | 405 Route 539 (Pinehurst Rd.) | Plumsted | NJ | 08514 | 40.1027135 | -74.5068462 | 609-585-7878 | 609-585-9155 | |||
S001145-chicago | Janice Schakowsky S001145 | 5533 N. Broadway | Chicago | IL | 60640 | 41.9827237 | -87.6595983 | 773-506-7100 | 773-506-9202 | |||
S001145-glenview | Janice Schakowsky S001145 | 1852 Johns Dr. | Glenview | IL | 60025 | 42.0884495 | -87.8103273 | 847-328-3409 | 847-328-3425 | |||
S001157-jonesboro | David Scott S001157 | 173 N. Main St. | Jonesboro | GA | 30236 | 33.5257191 | -84.3547213 | 770-210-5073 | 770-210-5673 | |||
S001165-elizabeth | Albio Sires S001165 | 800 Anna St. | Elizabeth | NJ | 07201 | 40.6662148 | -74.1968162 | 908-820-0692 | 908-820-0694 | Mon-Fri 8:00am-4:00pm | ||
S001168-burtonsville | John Sarbanes S001168 | 14906 Old Columbia Pike | Burtonsville | MD | 20866 | 39.102063 | -76.941686 | 301-421-4078 | Marilyn J. Praisner Community Recreation Center | Th, 11 a.m. - 1 p.m., or by appointment | ||
S001177-rota | Gregorio Sablan S001177 | P.O. Box 1361 | Rota | MP | 96951 | 670-532-2647 | 670-532-2649 | |||||
S001177-saipan | Gregorio Sablan S001177 | P.O. Box 504879 | Saipan | MP | 96950 | 670-323-2647 | 670-323-2649 | |||||
S001177-tinian | Gregorio Sablan S001177 | PO Box 520394 | Tinian | MP | 96952 | 670-433-2647 | 670-433-2648 | |||||
S001180-oregon_city | Kurt Schrader S001180 | 621 High St. | Oregon City | OR | 97045 | 45.3571432 | -122.6070483 | 503-557-1324 | 503-557-1981 | |||
S001181-berlin | Jeanne Shaheen S001181 | 961 Main St. | Berlin | NH | 03570 | 44.4781896 | -71.1708276 | 603-752-6300 | ||||
S001181-claremont | Jeanne Shaheen S001181 | 50 Opera House Sq. | Claremont | NH | 03743 | 43.3727196 | -72.3373946 | 603-542-4872 | ||||
S001189-tifton | Austin Scott S001189 | 127-B N. Central Ave. | Tifton | GA | 31794 | 31.4548661 | -83.5107367 | 229-396-5175 | 229-396-5179 | |||
S001190-round_lake_park | Bradley Schneider S001190 | 433 E Washington St. | Round Lake Park | IL | 60073 | 42.3565821 | -88.0740214 | Monday 8:30AM-4:30PM, Tuesday 8:30AM-12:30PM | ||||
S001190-waukegan | Bradley Schneider S001190 | 100 N Martin Luther King Jr Ave | Waukegan | IL | 60085-4328 | 42.36129 | -87.83472 | Tuesday 12:00-5:00pm,Wednesday 8:00am-5:00pm | ||||
S001193-castro_valley | Eric Swalwell S001193 | 3615 Castro Valley Blvd. | Castro Valley | CA | 94546 | 37.6950519 | -122.0722708 | 510-370-3322 | M-F 9:00 AM to 5:00 PM | |||
S001195-farmington | Jason Smith S001195 | 22 E. Columbia St. | Farmington | MO | 63640 | 37.7803665 | -90.4203215 | 573-756-9755 | 573-756-9762 | |||
S001195-rolla | Jason Smith S001195 | 830A S. Bishop | Rolla | MO | 65401 | 37.9315472 | -91.7789873 | 573-364-2455 | 573-364-1053 | |||
S001199-hanover | Lloyd Smucker S001199 | 118 Carlise Street | Hanover | PA | 17331 | 39.8018282 | -76.9852327 | 717-969-6132 | ||||
S001199-red_lion | Lloyd Smucker S001199 | 100 Redco Ave | Red Lion | PA | 17356-1436 | 39.90324 | -76.59862 | 717-969-6133 | ||||
S001200-haines_city | Darren Soto S001200 | 620 E Main St. | Haines City | FL | 33844 | 28.1083914 | -81.628392 | 202-615-1308 | Wednesday 9AM-5PM | |||
S001200-kissimmee | Darren Soto S001200 | 804 Bryan St. | Kissimmee | FL | 34741 | 28.2906297 | -81.4123113 | 407-452-1171 | ||||
S001200-lake_wales | Darren Soto S001200 | 201 W Central Avenue | Lake Wales | FL | 33853 | 27.8999663 | -81.596459 | 202-600-0843 | 202-615-1308 | Monday and Tuesday, 9AM-5PM | ||
S001200-winter_haven | Darren Soto S001200 | 451 3rd Street NW | Winter Haven | FL | 33881 | 28.0263894 | -81.732919 | 202-600-0843 | Open Thursday and Friday 9AM-5PM | |||
S001201-huntington | Thomas Suozzi S001201 | 478A Park Avenue | Huntington | NY | 11743 | 40.873976 | -73.41131899999999 | 631-923-4100 | ||||
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 | |||
S001205-east_lansdowne | Mary Scanlon S001205 | 927 E Baltimore Ave | East Lansdowne | PA | 19050-2749 | 39.94101 | -75.25719 | 610-626-1913 | ||||
S001212-brainerd | Pete Stauber S001212 | 501 Laurel St | Brainerd | MN | 56401-3595 | 46.35587 | -94.20074 | 218-355-0862 | Brainerd City Hall | |||
S001212-cambridge | Pete Stauber S001212 | 300 3rd Ave NE | Cambridge | MN | 55008-1281 | 45.57578 | -93.22133 | Cambridge City Hall | ||||
S001213-somers | Bryan Steil S001213 | 7511 12th Street | Somers | WI | 53171 | 42.6381671 | -87.9002263 | 262-654-1901 | Somers Village/Town Hall | |||
T000193-bolton | Bennie Thompson T000193 | 107 W. Madison St. | Bolton | MS | 39041 | 32.348821 | -90.459947 | 601-866-9003 | 601-866-9036 | |||
T000193-greenville | Bennie Thompson T000193 | 910 Courthouse Ln. | Greenville | MS | 38701 | 33.4079337 | -91.051782 | 662-335-9003 | 662-334-1304 | |||
T000193-jackson | Bennie Thompson T000193 | 3607 Medgar Evers Blvd. | Jackson | MS | 39213 | 32.339995 | -90.214478 | 601-946-9003 | 601-982-5337 | |||
T000193-marks | Bennie Thompson T000193 | 263 E. Main St. | Marks | MS | 38646 | 34.2568675 | -90.2711465 | 662-326-9003 | ||||
T000250-sioux_falls | John Thune T000250 | 5015 S. Bur Oak Place | Sioux Falls | SD | 57108 | 43.4995298 | -96.76391439999999 | 605-334-9596 | ||||
T000460-napa | Mike Thompson T000460 | 2721 Napa Valley Corporate Dr. | Napa | CA | 94558 | 38.2491248 | -122.2743897 | 707-226-9898 | 707-251-9800 | M-F 9-5:30pm | ||
T000464-kalispell | Jon Tester T000464 | 8 Third St. E | Kalispell | MT | 59901 | 48.1958316 | -114.3128666 | 406-257-3360 | 406-257-3974 | |||
T000464-missoula | Jon Tester T000464 | 130 W. Front St. | Missoula | MT | 59802 | 46.8704714 | -113.9961779 | 406-728-3003 | 406-728-2193 | |||
T000474-rialto | Norma Torres T000474 | 141 S. Riverside Ave. | Rialto | CA | 92376 | 34.0993394 | -117.3721013 | Every 2nd and 4th Wednesday, 9AM-12PM or by appointment | ||||
T000481-river_rouge | Rashida Tlaib T000481 | 10600 W Jefferson Ave | River Rouge | MI | 48218-1296 | 42.27338 | -83.13439 | 313-203-7540 | ||||
U000031-st__joseph | Fred Upton U000031 | 720 Main St. | St. Joseph | MI | 49085 | 42.105351 | -86.48403499999999 | 269-982-1986 | 269-982-0237 | |||
W000437-hernando | Roger Wicker W000437 | 321 Losher St. | Hernando | MS | 38632 | 34.822334 | -89.994967 | 662-429-1002 | 662-429-6002 | |||
W000797-aventura | Debbie Wasserman Schultz W000797 | 19200 West Country Club Drive | Aventura | FL | 33180 | 25.9528671 | -80.1390699 | 305-936-5724 | 305-932-9664 | |||
W000797-sunrise | Debbie Wasserman Schultz W000797 | 777 Sawgrass Corporate Parkway | Sunrise | FL | 33325 | 26.130384 | -80.333636 | 954-845-1179 | 954-845-0396 | |||
W000798-jackson | Tim Walberg W000798 | 401 W. Michigan Ave. | Jackson | MI | 49201 | 42.247186 | -84.414954 | 517-780-9075 | 517-780-9081 | Monday, Tuesday, Thursday, Friday 9:00AM-5:00PM Wednesday 9:00AM-6:00PM | ||
W000804-tappahannock | Robert Wittman W000804 | 508 Church Lane | Tappahannock | VA | 22560 | 37.9307412 | -76.8625874 | 804-443-0668 | 804-443-0671 | |||
W000805-roanoke | Mark Warner W000805 | 110 Kirk Ave. SW | Roanoke | VA | 24011 | 37.270958 | -79.942561 | 540-857-2676 | ||||
W000806-leesburg | Daniel Webster W000806 | 318 S 2nd St # A | Leesburg | FL | 34748-5805 | 28.80855 | -81.87609 | 352-241-9220 | 352-241-9220 | 8:30AM - 5:00PM | ||
W000808-west_park | Frederica Wilson W000808 | 1965 South State Road 7 | West Park | FL | 33023 | 25.993095 | -80.2038997 | 954-989-2688 | West Park City Hall | Thursday 9-5pm | ||
W000815-cincinnati | Brad Wenstrup W000815 | 4350 Aicholtz Rd. | Cincinnati | OH | 45245 | 39.0911309 | -84.2738952 | |||||
W000815-peebles | Brad Wenstrup W000815 | 170 N. Main St. | Peebles | OH | 45660 | 38.9507705 | -83.404366 | 513-605-1380 | 937-798-4024 | |||
W000817-boston | Elizabeth Warren W000817 | 15 Sudbury St. | Boston | MA | 02203 | 42.3613091 | -71.0593927 | 617-565-3170 | 2400 JFK Federal Building | |||
W000821-ozark | Bruce Westerman W000821 | 211 W. Commercial St. | Ozark | AR | 72949 | 35.4864789 | -93.8267906 | 479-667-0075 | 501-609-9887 | |||
Y000062-louisville-1 | John Yarmuth Y000062 | 7219 Dixie Highway | Louisville | KY | 40258 | 38.1458873 | -85.8399034 | 502-935-6934 | 502-933-5863 | Southwest Government Center | ||
R000575-anniston | Mike Rogers R000575 | 1129 Noble St. | # 104 | Anniston | AL | 36201 | 33.6595488 | -85.8294458 | 256-236-5655 | 256-237-9203 | Monday-Friday 9:00AM-5:00PM | |
I000024-enid | James Inhofe I000024 | 302 N. Independence | #104 | Enid | OK | 73701 | 36.3993287 | -97.8803343 | 580-234-5105 | 580-234-5094 | ||
I000024-mcalester | James Inhofe I000024 | 215 E. Choctaw Ave. | #106 | McAlester | OK | 74501 | 34.931573 | -95.7671124 | 918-426-0933 | 918-426-0935 | ||
G000585-los_angeles | Jimmy Gomez G000585 | 350 S. Bixel St. | #120 | Los Angeles | CA | 90017 | 34.0569399 | -118.2618953 | 213-481-1427 | 213-481-1425 | ||
N000189-richland | Dan Newhouse N000189 | 3100 George Washington Way | #130 | Richland | WA | 99354 | 46.3444932 | -119.2718385 | 509-713-7374 | 509-713-7377 | ||
H001089-cape_girardeau | Joshua Hawley H001089 | 555 Independence Street | #1600 | Cape Girardeau | MO | 63703-6235 | 37.3039 | -89.52491 | 573-334-5995 | 573-334-5947 | ||
K000388-hernando | Trent Kelly K000388 | 2565 Caffey St. | #200 | Hernando | MS | 38632 | 34.8226252 | -89.9956387 | 662-449-3090 | 662-449-4836 | ||
L000589-glendale | Debbie Lesko L000589 | 7121 W Bell Rd | #200 | Glendale | AZ | 85308 | 33.6373437 | -112.2108779 | 623-776-7911 | 623-776-7832 | ||
S001150-burbank | Adam Schiff S001150 | 245 E. Olive Ave. | #200 | Burbank | CA | 91502 | 34.1815906 | -118.3083786 | 818-450-2900 | 818-450-2928 | ||
S000320-huntsville | Richard Shelby S000320 | 1000 Glenn Hearn Blvd. | #20127 | Huntsville | AL | 35824 | 34.6471339 | -86.77460219999999 | 256-772-0460 | 256-772-8387 | ||
D000191-eugene | Peter DeFazio D000191 | 405 E. 8th Ave. | #2030 | Eugene | OR | 97401 | 44.0516985 | -123.0857882 | 541-465-6732 | 541-465-6458 | M-F 8:00am-5:00pm | |
H001079-oxford | Cindy Hyde-Smith H001079 | 911 Jackson Ave. | #249 | Oxford | MS | 38655 | 34.3672392 | -89.5212463 | 662-236-1018 | 662-236-7618 | ||
M001111-seattle | Patty Murray M001111 | 915 2nd Ave. | #2988 | Seattle | WA | 98174 | 47.6045895 | -122.3354608 | 206-553-5545 | 206-553-0891 | Jackson Federal Building | |
S001192-salt_lake_city | Chris Stewart S001192 | 420 East South Temple | #390 | Salt Lake City | UT | 84111 | 40.7686249 | -111.8789585 | 801-364-5550 | 801-364-5551 | ||
G000565-gold_canyon | Paul Gosar G000565 | 6499 S. Kings Ranch Rd. | #4 | Gold Canyon | AZ | 85118 | 33.3557193 | -111.4526421 | 480-882-2697 | |||
H001079-gulfport | Cindy Hyde-Smith H001079 | 2012 15th Street | #451 | Gulfport | MS | 39501 | 30.3701149 | -89.0870838 | 228-867-9710 | 228-867-9789 | ||
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 | ||
I000024-tulsa | James Inhofe I000024 | 1924 S. Utica Ave. | #530 | Tulsa | OK | 74104-6511 | 36.13417190000001 | -95.96760839999999 | 918-748-5111 | 918-748-5119 | ||
H001079-jackson | Cindy Hyde-Smith H001079 | 190 East Capitol St. | #550 | Jackson | MS | 39201 | 32.3004269 | -90.1867448 | 601-965-4459 | 601-965-4919 | ||
S000148-buffalo | Charles Schumer S000148 | 130 S. Elmwood Ave. | #660 | Buffalo | NY | 14202 | 42.88902849999999 | -78.87954189999999 | 716-846-4111 | 716-846-4113 | ||
M001166-stockton | Jerry McNerney M001166 | 2222 Grand Canal Blvd. | #7 | Stockton | CA | 95207 | 37.9845267 | -121.3334181 | 209-476-8552 | 209-476-8587 | ||
I000024-oklahoma_city | James Inhofe I000024 | 3817 NW Expressway | #780 | Oklahoma City | OK | 73112 | 35.5361791 | -97.5879455 | 405-604-0917 | 405-208-8841 | ||
S001203-duluth | Tina Smith S001203 | 515 W 1st Street | 104 | Duluth | MN | 55802 | 46.7825302 | -92.1069752 | 218-722-2390 | |||
B001277-hartford | Richard Blumenthal B001277 | 90 State House Sq. | 10th Floor | Hartford | CT | 06103 | 41.7665316 | -72.6719747 | 860-258-6940 | 860-258-6958 | ||
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 | |
G000386-sioux_city | Charles Grassley G000386 | 320 6th St. | 120 | Sioux City | IA | 51101 | 42.4963261 | -96.40758369999999 | 712-233-1860 | 712-233-1634 | Federal Building | |
P000604-newark | Donald Payne P000604 | 60 Nelson Pl. | 14th Floor | Newark | NJ | 07102 | 40.73821 | -74.182222 | 973-645-3213 | 973-645-5902 | LeRoy F. Smith, Jr. Public Safety Building | 9:00 am - 6:00pm |
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 | |
M001199-riviera_beach | Brian Mast M001199 | 7305 N Military Trl | 1A-366 | Riviera Beach | FL | 33410-7417 | 26.78415 | -80.10731 | 561-530-7778 | Mondays 10 a.m. - 2 p.m. | ||
M001203-somerville | Tom Malinowski M001203 | 58 E Main St | 1st Floor | Somerville | NJ | 08876-2312 | 40.5674 | -74.61027 | 908-547-3307 | |||
W000808-hollywood | Frederica Wilson W000808 | 2600 Hollywood Blvd | 1st Floor | Hollywood | FL | 33020-4807 | 26.01104 | -80.16059 | 954-921-3682 | Old Library | 2nd & 4th Thursdays 9am– 5pm | |
J000294-brooklyn | Hakeem Jeffries J000294 | 445 Neptune Ave | 1st Floor, Community Room 2C | Brooklyn | NY | 11224 | 40.5809199 | -73.9696891 | 718-373-0033 | Mon-Fri 9 am to 5pm | ||
H001085-reading | Chrissy Houlahan H001085 | 815 Washington St | 2-48 | Reading | PA | 19601-3615 | 40.33695 | -75.92123 | 610-295-0815 | |||
S001217-tallahassee | Rick Scott S001217 | 111 N Adams St | 208, | Tallahassee | FL | 32301-7736 | 30.44252 | -84.2819 | 850-942-8415 | |||
G000386-waterloo | Charles Grassley G000386 | 531 Commercial St. | 210 | Waterloo | IA | 50701 | 42.4953784 | -92.339384 | 319-232-6657 | 319-232-9965 | Waterloo Building | |
S001203-rochester | Tina Smith S001203 | 1202-1/2 7th Street NW | 213 | Rochester | MN | 55901 | 44.0524692 | -92.47637809999999 | 507-288-2003 |
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);