offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,163 rows sorted by id descending
This data as json, copyable, CSV (advanced)
id ▲ | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours |
---|---|---|---|---|---|---|---|---|---|---|---|---|
S001185-montgomery | Terri Sewell S001185 | 101 S. Lawrence St. | Annex 3 | Montgomery | AL | 36104 | 32.3759486 | -86.3054822 | 334-262-1919 | 334-262-1921 | Courthouse | |
S001185-birmingham | Terri Sewell S001185 | Two 20th Street North | Suite 1130 | Birmingham | AL | 35203 | 33.5132889 | -86.80582559999999 | 205-254-1960 | 205-254-1974 | ||
S001184-north_charleston | Tim Scott S001184 | 2500 City Hall Ln. | 3rd Floor Suite | North Charleston | SC | 29406 | 32.8769943 | -80.0121928 | 843-727-4525 | 855-802-9355 | 8:30am - 5:30pm (M-F) | |
S001184-greenville | Tim Scott S001184 | 104 S. Main St. | Suite 803 | Greenville | SC | 29601 | 34.849407 | -82.40024 | 864-233-5366 | 855-802-9355 | 8:30am - 5:30pm (M-F) | |
S001184-columbia | Tim Scott S001184 | 1901 Main St. | Suite 1425 | Columbia | SC | 29201 | 34.0108841 | -81.0384094 | 803-771-6112 | 855-802-9355 | 8:30am - 5:30pm (M-F) | |
S001183-scottsdale | David Schweikert S001183 | 14500 N Northsight Blvd | Suite 221 | Scottsdale | AZ | 85260-3658 | 33.61738 | -111.89853 | 480-946-2411 | 480-946-2446 | ||
S001181-nashua | Jeanne Shaheen S001181 | 60 Main St. | Suite 217 | Nashua | NH | 03060 | 42.7633363 | -71.4659542 | 603-883-0196 | |||
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 | ||
S001181-keene | Jeanne Shaheen S001181 | 12 Gilbo Ave. | Suite C | Keene | NH | 03431 | 42.9323699 | -72.2794587 | 603-358-6604 | |||
S001181-dover | Jeanne Shaheen S001181 | 340 Central Ave. | Suite 205 | Dover | NH | 03820 | 43.1952108 | -70.8748699 | 603-750-3004 | |||
S001181-claremont | Jeanne Shaheen S001181 | 50 Opera House Sq. | Claremont | NH | 03743 | 43.3727196 | -72.3373946 | 603-542-4872 | ||||
S001181-berlin | Jeanne Shaheen S001181 | 961 Main St. | Berlin | NH | 03570 | 44.4781896 | -71.1708276 | 603-752-6300 | ||||
S001180-salem | Kurt Schrader S001180 | 530 Center St. NE | Suite 415 | Salem | OR | 97301 | 44.94254830000001 | -123.0352226 | 503-588-9100 | 503-588-5517 | ||
S001180-oregon_city | Kurt Schrader S001180 | 621 High St. | Oregon City | OR | 97045 | 45.3571432 | -122.6070483 | 503-557-1324 | 503-557-1981 | |||
S001177-tinian | Gregorio Sablan S001177 | PO Box 520394 | Tinian | MP | 96952 | 670-433-2647 | 670-433-2648 | |||||
S001177-saipan | Gregorio Sablan S001177 | P.O. Box 504879 | Saipan | MP | 96950 | 670-323-2647 | 670-323-2649 | |||||
S001177-rota | Gregorio Sablan S001177 | P.O. Box 1361 | Rota | MP | 96951 | 670-532-2647 | 670-532-2649 | |||||
S001176-metairie | Steve Scalise S001176 | 110 Veterans Blvd. | Suite 500 | Metairie | LA | 70005 | 29.9992548 | -90.1242066 | 504-837-1259 | |||
S001176-mandeville | Steve Scalise S001176 | 21454 Koop Drive | Suite 2C | Mandeville | LA | 70471 | 30.4172835 | -90.0434162 | 985-893-9064 | |||
S001176-houma | Steve Scalise S001176 | 8026 Main St. | Suite 700 | Houma | LA | 70360 | 29.5979361 | -90.71805719999999 | 985-879-2300 | |||
S001176-hammond | Steve Scalise S001176 | 1514 Martens Dr. | Suite 10 | Hammond | LA | 70401 | 30.517849 | -90.47894529999999 | 985-340-2185 | |||
S001175-san_mateo | Jackie Speier S001175 | 155 Bovet Rd. | Suite 780 | San Mateo | CA | 94402 | 37.5496382 | -122.3167359 | 650-342-0300 | 650-375-8270 | ||
S001172-scottsbluff | Adrian Smith S001172 | 416 Valley View Dr. | Suite 600 | Scottsbluff | NE | 69361 | 41.8785841 | -103.6569419 | 308-633-6333 | 308-633-6335 | ||
S001172-grand_island | Adrian Smith S001172 | 1811 W. Second St. | Suite 275 | Grand Island | NE | 68803 | 40.91689849999999 | -98.35834179999999 | 308-384-3900 | 308-384-3902 | ||
S001168-towson | John Sarbanes S001168 | 600 Baltimore Ave. | Suite 303 | Towson | MD | 21204 | 39.4023248 | -76.6073615 | 410-832-8890 | 410-832-8898 | M-F, 9 a.m. - 5 p.m. | |
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 | ||
S001168-annapolis | John Sarbanes S001168 | 44 Calvert St. | Suite 349 | Annapolis | MD | 21401 | 38.9793786 | -76.4949839 | 410-295-1679 | 410-295-1682 | Arundel Center | Tues, 11 a.m. - 1 p.m. or by appointment |
S001165-west_new_york | Albio Sires S001165 | 5500 Palisade Ave. | Suite A | West New York | NJ | 07093 | 40.7850274 | -74.0161301 | 201-558-0800 | 201-617-2809 | Mon-Fri 9-6:00pm | |
S001165-jersey_city | Albio Sires S001165 | 257 Cornelison Ave. | Suite 4408 | Jersey City | NJ | 07302 | 40.7248331 | -74.0607631 | 201-309-0301 | 201-309-0384 | M-F 9-6:00pm | |
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 | ||
S001157-smyrna | David Scott S001157 | 888 Concord Rd. | Suite 100 | Smyrna | GA | 30080 | 33.874631 | -84.5279704 | 770-432-5405 | 770-432-5813 | ||
S001157-jonesboro | David Scott S001157 | 173 N. Main St. | Jonesboro | GA | 30236 | 33.5257191 | -84.3547213 | 770-210-5073 | 770-210-5673 | |||
S001156-norwalk | Linda Sánchez S001156 | 12440 E. Imperial Hwy. | Suite 140 | Norwalk | CA | 90650 | 33.9163272 | -118.0663246 | 562-860-5050 | 562-924-2914 | ||
S001150-los_angeles | Adam Schiff S001150 | 5500 Hollywood Blvd. | Suite #416 | Los Angeles | CA | 90028 | 34.1014609 | -118.3095706 | 323-315-5555 | Open Tuesdays 2 pm - 5 pm and by appointment only. | ||
S001150-burbank | Adam Schiff S001150 | 245 E. Olive Ave. | #200 | Burbank | CA | 91502 | 34.1815906 | -118.3083786 | 818-450-2900 | 818-450-2928 | ||
S001148-twin_falls | Michael Simpson S001148 | 650 Addison Ave W | Suite 1078 | Twin Falls | ID | 83301-5851 | 42.56422 | -114.49355 | 208-734-7219 | |||
S001148-idaho_falls | Michael Simpson S001148 | 410 Memorial Dr. | Suite 203 | Idaho Falls | ID | 83402 | 43.4936265 | -112.0425928 | 208-523-6701 | |||
S001148-boise | Michael Simpson S001148 | 802 W. Bannock | Suite 600 | Boise | ID | 83702 | 43.6174275 | -116.2020512 | 208-334-1953 | 208-334-9533 | ||
S001145-glenview | Janice Schakowsky S001145 | 1852 Johns Dr. | Glenview | IL | 60025 | 42.0884495 | -87.8103273 | 847-328-3409 | 847-328-3425 | |||
S001145-evanston | Janice Schakowsky S001145 | 820 Davis St. | Suite 105 | Evanston | IL | 60201 | 42.0466618 | -87.6829625 | 847-328-3409 | 847-328-3425 | ||
S001145-chicago | Janice Schakowsky S001145 | 5533 N. Broadway | Chicago | IL | 60640 | 41.9827237 | -87.6595983 | 773-506-7100 | 773-506-9202 | |||
S000770-traverse_city | Debbie Stabenow S000770 | 3335 S. Airport Road West | Suite 6B | Traverse City | MI | 49684 | 44.7222478 | -85.642375 | 231-929-1031 | |||
S000770-marquette | Debbie Stabenow S000770 | 1901 W. Ridge | Suite 7 | Marquette | MI | 49855 | 46.5484343 | -87.4269822 | 906-228-8756 | |||
S000770-grand_rapids | Debbie Stabenow S000770 | 3280 E. Beltline Ct. NE | Suite 400 | Grand Rapids | MI | 49525 | 43.037652 | -85.588081 | 616-975-0052 | |||
S000770-flint | Debbie Stabenow S000770 | 432 N. Saginaw St. | Suite 301 | Flint | MI | 48502 | 43.0201574 | -83.69306720000002 | 810-720-4172 | |||
S000770-east_lansing | Debbie Stabenow S000770 | 221 W. Lake Lansing Rd. | Suite 100 | East Lansing | MI | 48823 | 42.757677 | -84.48539199999999 | 517-203-1760 | |||
S000770-detroit | Debbie Stabenow S000770 | 719 Griswold St. | Suite 700 | Detroit | MI | 48226 | 42.3307555 | -83.048152 | 313-961-4330 | |||
S000522-plumsted | Christopher Smith S000522 | 405 Route 539 (Pinehurst Rd.) | Plumsted | NJ | 08514 | 40.1027135 | -74.5068462 | 609-585-7878 | 609-585-9155 | |||
S000522-hamilton | Christopher Smith S000522 | 4573 S. Broad St. | Hamilton | NJ | 08620 | 40.178635 | -74.67184200000001 | 609-585-7878 | 609-585-9155 | |||
S000522-freehold | Christopher Smith S000522 | 112 Village Center Dr. | Second Floor | Freehold | NJ | 07728 | 40.2402775 | -74.30812019999999 | 732-780-3035 | 732-780-3079 | Raintree Shopping Center | |
S000510-renton | Adam Smith S000510 | 15 S. Grady Way | Suite 101 | Renton | WA | 98057 | 47.469273 | -122.2153306 | 425-793-5180 | Evergreen Building | 8:00 am - 5:00 pm PST | |
S000344-sherman_oaks | Brad Sherman S000344 | 5000 Van Nuys Blvd. | Suite 420 | Sherman Oaks | CA | 91403 | 34.1615172 | -118.4483015 | 818-501-9200 | 818-501-1554 | M-F 9-5:30pm | |
S000320-tuscaloosa | Richard Shelby S000320 | 2005 University Blvd. | Suite 2100 | Tuscaloosa | AL | 35401 | 33.21019640000001 | -87.5631689 | 205-759-5047 | |||
S000320-montgomery | Richard Shelby S000320 | 15 Lee St. | Suite 208 | Montgomery | AL | 36104 | 32.3752753 | -86.3089916 | 334-223-7303 | 334-223-7317 | FMJ Federal Courthouse | |
S000320-mobile | Richard Shelby S000320 | 113 St Joseph St. | 445 | Mobile | AL | 36602 | 30.6938886 | -88.0431615 | 251-694-4164 | 251-694-4166 | U.S. Federal Courthouse | |
S000320-huntsville | Richard Shelby S000320 | 1000 Glenn Hearn Blvd. | #20127 | Huntsville | AL | 35824 | 34.6471339 | -86.77460219999999 | 256-772-0460 | 256-772-8387 | ||
S000320-birmingham | Richard Shelby S000320 | 1800 5th Avenue North | 321 | Birmingham | AL | 35203 | 33.517386 | -86.810488 | 205-731-1384 | 205-731-1386 | Robert S. Vance Federal Building | |
S000185-newport_news | Robert Scott S000185 | 2600 Washington Ave. | Suite 1010 | Newport News | VA | 23607 | 36.9788711 | -76.4304902 | 757-380-1000 | 757-928-6694 | Mon-Fri 8:30am-5:30pm | |
S000148-syracuse | Charles Schumer S000148 | 100 S. Clinton St. | Room 841 | Syracuse | NY | 13261 | 43.0501042 | -76.1543204 | 315-423-5471 | 315-423-5185 | ||
S000148-rochester | Charles Schumer S000148 | 100 State St. | Room 3040 | Rochester | NY | 14614 | 43.1576631 | -77.613515 | 585-263-5866 | 585-263-3173 | ||
S000148-peekskill | Charles Schumer S000148 | One Park Place | Suite 100 | Peekskill | NY | 10566 | 41.29051020000001 | -73.91672969999999 | 914-734-1532 | 914-734-1673 | ||
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-melville | Charles Schumer S000148 | 145 Pine Lawn Rd. | Suite 300 | Melville | NY | 11747 | 40.7708436 | -73.40787569999999 | 631-753-0978 | 631-753-0997 | ||
S000148-buffalo | Charles Schumer S000148 | 130 S. Elmwood Ave. | #660 | Buffalo | NY | 14202 | 42.88902849999999 | -78.87954189999999 | 716-846-4111 | 716-846-4113 | ||
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-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 | |
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 | ||
S000033-burlington | Bernard Sanders S000033 | 1 Church St. | 3rd Floor | Burlington | VT | 05401 | 44.4802081 | -73.21307019999999 | 802-862-0697 | 802-860-6370 | ||
R000615-salt_lake_city | Mitt Romney R000615 | 125 S State St | Suite 8402 | Salt Lake City | UT | 84138-1102 | 40.76664 | -111.88714 | 801-524-4380 | |||
R000614-san_antonio | Chip Roy R000614 | 1100 NE Loop 410 | Suite 640 | San Antonio | TX | 78209-1537 | 29.51566 | -98.45396 | 210-821-5024 | 210-821-5947 | ||
R000612-gallatin | John Rose R000612 | 355 N Belvedere Dr | Suite 308 | Gallatin | TN | 37066-5466 | 36.37974 | -86.48063 | 615-206-8204 | 615-206-8980 | ||
R000612-cookeville | John Rose R000612 | 321 E Spring St | Suite 301 | Cookeville | TN | 38501-4167 | 36.16183 | -85.50005 | 931-854-9430 | 615-206-8980 | ||
R000610-greensburg | Guy Reschenthaler R000610 | 700 Pellis Rd | Suite 1 | Greensburg | PA | 15601-4488 | 40.29199 | -79.52448 | 724-219-4200 | |||
R000609-jacksonville | John Rutherford R000609 | 4130 Salisbury Rd. | Jacksonville | FL | 32216 | 30.2539737 | -81.5959646 | 904-831-5205 | Suite 2500 | |||
R000608-reno | Jacky Rosen R000608 | 400 S Virginia St | Suite 738 | Reno | NV | 89501-2132 | 39.52994 | -119.81414 | 775-337-0110 | Bruce Thompson Federal Building | ||
R000608-las_vegas | Jacky Rosen R000608 | 8930 W Sunset Rd | Suite 230 | Las Vegas | NV | 89148-5008 | 36.07191 | -115.28661 | 702-388-0205 | |||
R000606-rockville | Jamie Raskin R000606 | 51 Monroe St. | Suite 503 | Rockville | MD | 20850 | 39.083791 | -77.1481645 | 301-354-1000 | |||
R000605-sioux_falls | Mike Rounds R000605 | 320 N. Main Ave. | Suite A | Sioux Falls | SD | 57104 | 43.5506861 | -96.7279008 | 605-336-0486 | 605-336-6624 | ||
R000605-rapid_city | Mike Rounds R000605 | 1313 W. Main St. | Rapid City | SD | 57701 | 44.0818193 | -103.2403111 | 605-343-5035 | 605-343-5348 | |||
R000605-pierre | Mike Rounds R000605 | 111 W. Capitol Ave. | Suite 210 | Pierre | SD | 57501 | 44.36917280000001 | -100.35182 | 605-224-1450 | 605-224-1379 | ||
R000605-aberdeen | Mike Rounds R000605 | 514 S. Main St. | Suite 100 | Aberdeen | SD | 57401 | 45.45953249999999 | -98.48834950000001 | 605-225-0366 | |||
R000603-wilmington | David Rouzer R000603 | 230 Government Center Dr. | Suite 113 | Wilmington | NC | 28403 | 34.2415626 | -77.8669625 | 910-395-0202 | 910-395-0209 | ||
R000603-four_oaks | David Rouzer R000603 | 4001 US Hwy. 301 South | Suite 106 | Four Oaks | NC | 27524 | 35.46515 | -78.387203 | 919-938-3040 | 919-938-3540 | ||
R000603-bolivia | David Rouzer R000603 | 310 Government Center Dr. | Unit 1 | Bolivia | NC | 28422 | 34.0583353 | -78.16267719999999 | 910-253-6111 | 910-253-6114 | ||
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 | ||
R000600-pago_pago | Aumua Amata Radewagen R000600 | 1 Fagatogo Square | PO Box 5859 | Pago Pago | AS | 96799 | -14.2775712 | -170.6899787 | 684-633-3601 | 684-633-3607 | ||
R000599-palm_desert | Raul Ruiz R000599 | 43875 Washington Street | Suite F | Palm Desert | CA | 92211 | 33.7302529 | -116.3043432 | 760-424-8888 | 760-424-8993 | ||
R000599-hemet | Raul Ruiz R000599 | 445 E. Florida Ave. | 2nd Floor | Hemet | CA | 92543 | 33.7472608 | -116.9677534 | 951-765-2304 | 951-765-3784 | ||
R000597-myrtle_beach | Tom Rice R000597 | 2411 N. Oak St. | Suite 405 | Myrtle Beach | SC | 29577 | 33.7081253 | -78.87212720000001 | 843-445-6459 | 843-445-6418 | ||
R000597-florence | Tom Rice R000597 | 1831 W. Evans St. | Suite 300 | Florence | SC | 29501 | 34.1959092 | -79.8017864 | 843-679-9781 | 843-679-9783 | ||
R000595-tampa | Marco Rubio R000595 | 501 E. Polk St | Suite 601 | Tampa | FL | 33602 | 27.9511694 | -82.459228 | 813-947-6288 | |||
R000595-tallahassee | Marco Rubio R000595 | 402 S. Monroe St. | Suite 2105E | Tallahassee | FL | 32399 | 30.438114 | -84.281289 | 850-599-9100 | |||
R000595-pensacola | Marco Rubio R000595 | 700 S. Palafox St. | Suite 125 | Pensacola | FL | 32502 | 30.405605 | -87.213161 | 850-433-2603 | |||
R000595-palm_beach_gardens | Marco Rubio R000595 | 4580 PGA Blvd. | Suite 201 | Palm Beach Gardens | FL | 33418 | 26.8380427 | -80.1114094 | 561-775-3360 | |||
R000595-orlando | Marco Rubio R000595 | 201 S. Orange Ave. | Suite 350 | Orlando | FL | 32801 | 28.5400755 | -81.3780508 | 407-254-2573 | |||
R000595-miami | Marco Rubio R000595 | 7400 SW 87th Ave. | Suite 270 | Miami | FL | 33173 | 25.7001209 | -80.3372066 | 305-596-4224 | 305-596-4345 | ||
R000595-jacksonville | Marco Rubio R000595 | 300 North Hogan St. | Suite 8-111 | Jacksonville | FL | 32202 | 30.32909 | -81.65997 | 904-354-4300 | Bryan Simpson U.S. Courthouse | M-F 8:30AM-5:30PM | |
R000595-fort_myers | Marco Rubio R000595 | 2120 Main St. | Room 200 | Fort Myers | FL | 33901 | 26.6426923 | -81.8727155 | 239-318-6464 | |||
R000584-twin_falls | James Risch R000584 | 1411 Falls Avenue East | Suite 201 | Twin Falls | ID | 83301 | 42.5785998 | -114.456626 | 208-734-6780 | 208-734-3905 | ||
R000584-pocatello | James Risch R000584 | 275 S. 5th Ave. | Suite 290 | Pocatello | ID | 83201 | 42.8649373 | -112.4428822 | 208-236-6817 | 208-236-6820 |
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);