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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
T000468-las_vegas | Dina Titus T000468 | 495 South Main St. | 3rd Floor | Las Vegas | NV | 89101 | 36.1673606 | -115.1506179 | 702-220-9823 | 702-220-9841 | M-F 8:30-5:30pm | |
T000467-oil_city | Glenn Thompson T000467 | 217 Elm St | B | Oil City | PA | 16301-1412 | 41.43636 | -79.70781 | 814-670-0432 | 814-670-0868 | ||
T000467-bellefonte | Glenn Thompson T000467 | 3555 Benner Pike. | Suite 101 | Bellefonte | PA | 16823 | 40.8956202 | -77.7877153 | 814-353-0215 | 814-353-0218 | M-F 9:00AM-5:00PM | |
T000464-missoula | Jon Tester T000464 | 130 W. Front St. | Missoula | MT | 59802 | 46.8704714 | -113.9961779 | 406-728-3003 | 406-728-2193 | |||
T000464-kalispell | Jon Tester T000464 | 8 Third St. E | Kalispell | MT | 59901 | 48.1958316 | -114.3128666 | 406-257-3360 | 406-257-3974 | |||
T000464-helena | Jon Tester T000464 | 208 N. Montana Ave. | Suite 202 | Helena | MT | 59601 | 46.5865426 | -112.020799 | 406-449-5401 | 406-449-5462 | Capital One Center | |
T000464-great_falls | Jon Tester T000464 | 119 1st Ave. N | Suite 102 | Great Falls | MT | 59401 | 47.5065688 | -111.3040376 | 402-452-9585 | 406-452-9586 | ||
T000464-butte | Jon Tester T000464 | 125 W. Granite | Suite 200 | Butte | MT | 59701 | 46.01461 | -112.538136 | 406-723-3277 | 406-782-4717 | Silver Bow Center | |
T000464-bozeman | Jon Tester T000464 | 1 E. Main St. | Suite 202 | Bozeman | MT | 59715 | 45.6795093 | -111.0370333 | 406-586-4450 | 406-586-7647 | Avant Courier Building | |
T000464-billings | Jon Tester T000464 | 2900 4th Ave. N | Suite 201 | Billings | MT | 59101 | 45.783552 | -108.509375 | 406-252-0550 | 406-252-7768 | Judge Jameson Federal Building | |
T000463-dayton | Michael Turner T000463 | 120 W. 3rd St. | Suite 305 | Dayton | OH | 45402 | 39.7586771 | -84.19453349999999 | 937-225-2843 | 937-225-2752 | ||
T000461-wilkes_barre | Patrick Toomey T000461 | 7 North Wilkes-Barre Boulevard | Suite 406 | Wilkes-Barre | PA | 18702 | 41.2419893 | -75.8773626 | 570-820-4088 | 570-820-6442 | ||
T000461-pittsburgh | Patrick Toomey T000461 | 310 Grant St. | Suite 1440 | Pittsburgh | PA | 15219 | 40.4376735 | -79.9996749 | 412-803-3501 | 412-803-3504 | ||
T000461-philadelphia | Patrick Toomey T000461 | 200 Chestnut Street | Suite 600 | Philadelphia | PA | 19106 | 39.94829 | -75.1441 | 215-241-1090 | 215-241-1095 | US Custom House | |
T000461-johnstown | Patrick Toomey T000461 | 1397 Eisenhower Blvd | Suite 302 | Johnstown | PA | 15904 | 40.273143 | -78.848055 | 814-266-5970 | 814-266-5973 | Richland Square III | |
T000461-harrisburg | Patrick Toomey T000461 | 228 Walnut St. | Suite 1104 | Harrisburg | PA | 17101 | 40.261919 | -76.882739 | 717-782-3951 | 717-782-4920 | United States Federal Building | |
T000461-erie | Patrick Toomey T000461 | 17 S. Park Row. | Suite B-120 | Erie | PA | 16501 | 42.1289745 | -80.08406889999999 | 814-453-3010 | 814-455-9925 | United States Federal Building | |
T000461-allentown | Patrick Toomey T000461 | 1150 S. Cedar Crest Blvd | Suite 101 | Allentown | PA | 18103 | 40.569891 | -75.519529 | 610-434-1444 | 202-228-2727 | ||
T000460-vallejo | Mike Thompson T000460 | 420 Virginia St. | Suite 1C | Vallejo | CA | 94590 | 38.1023237 | -122.2557289 | 707-645-1888 | 707-645-1870 | Mon-Fri 9am-5.30pm | |
T000460-santa_rosa | Mike Thompson T000460 | 2300 County Center Dr. | Suite A100 | Santa Rosa | CA | 95403 | 38.4620056 | -122.7253838 | 707-542-7182 | 707-542-2745 | Mon-Fri 9am-5:30pm | |
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 | ||
T000250-sioux_falls | John Thune T000250 | 5015 S. Bur Oak Place | Sioux Falls | SD | 57108 | 43.4995298 | -96.76391439999999 | 605-334-9596 | ||||
T000250-rapid_city | John Thune T000250 | 246 Founders Park Dr. | Suite 102 | Rapid City | SD | 57701 | 44.0872508 | -103.239745 | 605-348-7551 | |||
T000250-aberdeen | John Thune T000250 | 320 S. 1st St. | Suite 101 | Aberdeen | SD | 57401 | 45.4614099 | -98.4898984 | 605-225-8823 | |||
T000193-mound_bayou | Bennie Thompson T000193 | 106 Green Avenue | Suite 106 | Mound Bayou | MS | 38762 | 33.8783982 | -90.7298777 | 662-741-9003 | 662-741-9002 | ||
T000193-marks | Bennie Thompson T000193 | 263 E. Main St. | Marks | MS | 38646 | 34.2568675 | -90.2711465 | 662-326-9003 | ||||
T000193-jackson | Bennie Thompson T000193 | 3607 Medgar Evers Blvd. | Jackson | MS | 39213 | 32.339995 | -90.214478 | 601-946-9003 | 601-982-5337 | |||
T000193-greenwood | Bennie Thompson T000193 | 728 Main Street | Suite A | Greenwood | MS | 38930 | 33.5146884 | -90.1821178 | 662-455-9003 | 662-453-0118 | ||
T000193-greenville | Bennie Thompson T000193 | 910 Courthouse Ln. | Greenville | MS | 38701 | 33.4079337 | -91.051782 | 662-335-9003 | 662-334-1304 | |||
T000193-bolton | Bennie Thompson T000193 | 107 W. Madison St. | Bolton | MS | 39041 | 32.348821 | -90.459947 | 601-866-9003 | 601-866-9036 | |||
S001217-west_palm_beach | Rick Scott S001217 | 415 Clematis Street | Suite 201 | West Palm Beach | FL | 33401 | 26.7134899 | -80.0544948 | 561-514-0189 | |||
S001217-tampa | Rick Scott S001217 | 801 North Florida Avenue | Suite 421 | Tampa | FL | 33602 | 27.95168 | -82.4580549 | 813-225-7040 | |||
S001217-tallahassee | Rick Scott S001217 | 111 N Adams St | 208, | Tallahassee | FL | 32301-7736 | 30.44252 | -84.2819 | 850-942-8415 | |||
S001217-pensacola | Rick Scott S001217 | 221 Palafox Place | Suite 420 | Pensacola | FL | 32502 | 30.4096575 | -87.2155533 | 850-760-5151 | |||
S001217-orlando | Rick Scott S001217 | 225 East Robinson Street | Suite 410 | Orlando | FL | 32801 | 28.5460289 | -81.3745694 | 407-872-7161 | |||
S001217-naples | Rick Scott S001217 | 3299 Tamiami Trail East | Building F, Suite 106 | Naples | FL | 34112 | 26.1275317 | -81.7654572 | 239-231-7890 | |||
S001217-miami | Rick Scott S001217 | 901 Ponce de Leon Boulevard | Suite 505 | Miami | FL | 33134 | 786-501-7141 | |||||
S001217-kissimmee | Rick Scott S001217 | 1 Courthouse Square | Suite 300 | Kissimmee | FL | 34741 | 28.2912612 | -81.4108061 | 407-586-7879 | |||
S001217-jacksonville | Rick Scott S001217 | 400 West Bay Street | Suite 289 | Jacksonville | FL | 32202 | 30.3269484 | -81.6637337 | 904-479-7227 | |||
S001216-issaquah | Kim Schrier S001216 | 1445 NW Mall St | Suite 4 | Issaquah | WA | 98027-7900 | 47.54425 | -122.0602 | 425-657-1001 | |||
S001215-novi | Haley Stevens S001215 | 43155 Main St | 2300B | Novi | MI | 48375-1777 | 42.47818 | -83.47075 | 202-227-7397 | |||
S001214-punta_gorda | W. Steube S001214 | 226 Taylor St | Suite 230 | Punta Gorda | FL | 33950-4457 | 26.93505 | -82.05085 | 941-575-9101 | 941-575-9103 | ||
S001213-somers | Bryan Steil S001213 | 7511 12th Street | Somers | WI | 53171 | 42.6381671 | -87.9002263 | 262-654-1901 | Somers Village/Town Hall | |||
S001213-racine | Bryan Steil S001213 | 730 Wisconsin Ave | Suite 101 | Racine | WI | 53403-1238 | 42.72521 | -87.78431 | 262-637-0510 | Racine County Courthouse | ||
S001213-janesville | Bryan Steil S001213 | 20 S Main St | Suite 10 | Janesville | WI | 53545-3959 | 42.68247 | -89.02214 | 608-752-4050 | Monday-Friday, 8am-5pm | ||
S001212-hermantown | Pete Stauber S001212 | 5094 Miller Trunk Hwy | Suite 900 | Hermantown | MN | 55811-1626 | 46.83671 | -92.21649 | 218-481-6396 | |||
S001212-chisholm | Pete Stauber S001212 | 316 W Lake St | Suite 7 | Chisholm | MN | 55719-3708 | 47.48942 | -92.88417 | 218-355-0726 | Chisholm City Hall | ||
S001212-cambridge | Pete Stauber S001212 | 300 3rd Ave NE | Cambridge | MN | 55008-1281 | 45.57578 | -93.22133 | Cambridge City Hall | ||||
S001212-brainerd | Pete Stauber S001212 | 501 Laurel St | Brainerd | MN | 56401-3595 | 46.35587 | -94.20074 | 218-355-0862 | Brainerd City Hall | |||
S001211-phoenix | Greg Stanton S001211 | 2944 N 44th St | Suite 150 | Phoenix | AZ | 85018-7257 | 33.48161 | -111.98764 | 602-956-2463 | |||
S001209-spotsylvania | Abigail Spanberger S001209 | 9104 Courthouse Rd | Suite 249 | Spotsylvania | VA | 22553-1902 | 38.20557 | -77.58501 | 202-225-2815 | |||
S001209-glen_allen | Abigail Spanberger S001209 | 4201 Dominion Blvd | Suite 110 | Glen Allen | VA | 23060-6743 | 37.6518 | -77.58431 | 804-401-4110 | |||
S001208-lansing | Elissa Slotkin S001208 | 1100 W Saginaw St | 3a | Lansing | MI | 48915-2033 | 42.74097 | -84.56793 | 517-993-0510 | |||
S001207-parsippany | Mikie Sherrill S001207 | 8 Woodhollow Rd | Suite 203 | Parsippany | NJ | 07054-2828 | 40.86193 | -74.41507 | 973-526-5668 | |||
S001205-east_lansdowne | Mary Scanlon S001205 | 927 E Baltimore Ave | East Lansdowne | PA | 19050-2749 | 39.94101 | -75.25719 | 610-626-1913 | ||||
S001204-hagatna | Michael San Nicolas S001204 | 330 Hernan Cortez Ave | Fl 3 | Hagatna | GU | 96910-5081 | 13.4763888 | 144.7455451 | ||||
S001203-saint_paul | Tina Smith S001203 | 60 Plato Blvd. East | 220 | Saint Paul | MN | 55107 | 44.93741180000001 | -93.0843115 | 651-221-1016 | |||
S001203-rochester | Tina Smith S001203 | 1202-1/2 7th Street NW | 213 | Rochester | MN | 55901 | 44.0524692 | -92.47637809999999 | 507-288-2003 | |||
S001203-moorhead | Tina Smith S001203 | 819 Center Avenue | 2A | Moorhead | MN | 56560 | 46.8750559 | -96.7677958 | 218-284-8721 | |||
S001203-duluth | Tina Smith S001203 | 515 W 1st Street | 104 | Duluth | MN | 55802 | 46.7825302 | -92.1069752 | 218-722-2390 | |||
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 | |||
S001201-huntington | Thomas Suozzi S001201 | 478A Park Avenue | Huntington | NY | 11743 | 40.873976 | -73.41131899999999 | 631-923-4100 | ||||
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 | |||
S001200-orlando | Darren Soto S001200 | 13800 Veterans Way | s 1F806 | Orlando | FL | 32827-7401 | 28.36525 | -81.2749461 | 202-322-4476 | VA Medical Center | Tuesdays 9AM-3PM | |
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-kissimmee | Darren Soto S001200 | 804 Bryan St. | Kissimmee | FL | 34741 | 28.2906297 | -81.4123113 | 407-452-1171 | ||||
S001200-haines_city | Darren Soto S001200 | 620 E Main St. | Haines City | FL | 33844 | 28.1083914 | -81.628392 | 202-615-1308 | Wednesday 9AM-5PM | |||
S001199-red_lion | Lloyd Smucker S001199 | 100 Redco Ave | Red Lion | PA | 17356-1436 | 39.90324 | -76.59862 | 717-969-6133 | ||||
S001199-lancaster | Lloyd Smucker S001199 | 51 S. Duke St. | Suite 201 | Lancaster | PA | 17602 | 40.03689079999999 | -76.3031804 | 717-393-0667 | 717-393-0924 | ||
S001199-hanover | Lloyd Smucker S001199 | 118 Carlise Street | Hanover | PA | 17331 | 39.8018282 | -76.9852327 | 717-969-6132 | ||||
S001198-wasilla | Dan Sullivan S001198 | 851 E. Westpoint Dr. | Suite 309 | Wasilla | AK | 99654 | 61.5826697 | -149.4286826 | 907-357-9956 | 907-357-9964 | ||
S001198-soldotna | Dan Sullivan S001198 | 44539 Sterling Highway | Suite 204 | Soldotna | AK | 99669 | 60.480503 | -151.0747996 | 907-262-4040 | 907-262-4224 | ||
S001198-ketchikan | Dan Sullivan S001198 | 1900 First Ave. | Suite 225 | Ketchikan | AK | 99901 | 55.3492023 | -131.6673863 | 907-225-6880 | 907-225-0390 | ||
S001198-juneau | Dan Sullivan S001198 | 800 Glacier Ave. | Suite 101 | Juneau | AK | 99801 | 58.30033239999999 | -134.4205554 | 907-586-7277 | 907-586-7201 | ||
S001198-fairbanks | Dan Sullivan S001198 | 101 12th Ave. | Suite 328 | Fairbanks | AK | 99701 | 64.8383052 | -147.7082477 | 907-456-0261 | 907-451-7290 | Federal Building | |
S001198-anchorage | Dan Sullivan S001198 | 510 L St. | Suite 750 | Anchorage | AK | 99501 | 61.2171561 | -149.9043364 | 907-271-5915 | 907-258-9305 | ||
S001197-scottsbluff | Benjamin Sasse S001197 | 115 Railway St. | Suite C102 | Scottsbluff | NE | 69361 | 41.8624626 | -103.6650529 | 308-632-6032 | |||
S001197-omaha | Benjamin Sasse S001197 | 304 N. 168th Cir. | Suite 213 | Omaha | NE | 68118 | 41.2618733 | -96.1778064 | 402-550-8040 | |||
S001197-lincoln | Benjamin Sasse S001197 | 1128 Lincoln Mall | Suite 305 | Lincoln | NE | 68508 | 40.8084319 | -96.7048142 | 402-476-1400 | |||
S001197-kearney | Benjamin Sasse S001197 | 4111 Fourth Ave. | Suite 26 | Kearney | NE | 68845 | 40.715284 | -99.086211 | 308-233-3677 | |||
S001196-watertown | Elise Stefanik S001196 | 88 Public Sq. | Suite A | Watertown | NY | 13601 | 43.974587 | -75.907664 | 315-782-3150 | 315-782-1291 | Mon-Fri 9-5 | |
S001196-plattsburgh | Elise Stefanik S001196 | 23 Durkee St. | Suite C | Plattsburgh | NY | 12901 | 44.6964439 | -73.45244749999999 | 518-561-2324 | 518-561-2408 | ||
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 | ||
S001195-west_plains | Jason Smith S001195 | 35 Court Sq. | Suite 300 | West Plains | MO | 65775 | 36.7283104 | -91.8529136 | 417-255-1515 | 417-255-2009 | ||
S001195-rolla | Jason Smith S001195 | 830A S. Bishop | Rolla | MO | 65401 | 37.9315472 | -91.7789873 | 573-364-2455 | 573-364-1053 | |||
S001195-poplar_bluff | Jason Smith S001195 | 2725 N. Westwood Blvd. | Suite 5A | Poplar Bluff | MO | 63901 | 36.7847526 | -90.4294579 | 573-609-2996 | |||
S001195-farmington | Jason Smith S001195 | 22 E. Columbia St. | Farmington | MO | 63640 | 37.7803665 | -90.4203215 | 573-756-9755 | 573-756-9762 | |||
S001195-cape_girardeau | Jason Smith S001195 | 2502 Tanner Dr. | Suite 205 | Cape Girardeau | MO | 63703 | 37.30292850000001 | -89.55584789999999 | 573-335-0101 | 573-335-1931 | ||
S001194-honolulu | Brian Schatz S001194 | 300 Ala Moana Blvd. | Room 7-212 | Honolulu | HI | 96850 | 21.3036893 | -157.862353 | 808-523-2061 | 808-523-2065 | ||
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 | |||
S001192-st__george | Chris Stewart S001192 | 253 W. St George Blvd. | Suite 100 | St. George | UT | 84770 | 37.10961350000001 | -113.5887467 | 435-627-1500 | 435-627-1911 | ||
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 | ||
S001191-phoenix | Kyrsten Sinema S001191 | 2200 E Camelback Rd | Suite 120 | Phoenix | AZ | 85016-3454 | 33.50965 | -112.03408 | 602-598-7327 | |||
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 | ||||
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-lincolnshire | Bradley Schneider S001190 | 111 Barclay Blvd. | Suite 200 | Lincolnshire | IL | 60069 | 42.1964098 | -87.9362154 | 847-383-4870 | 847-793-0677 | ||
S001189-warner_robins | Austin Scott S001189 | 230 Margie Dr. | Suite 500 | Warner Robins | GA | 31088 | 32.6144617 | -83.6893055 | 478-971-1776 | 478-971-1778 | ||
S001189-tifton | Austin Scott S001189 | 127-B N. Central Ave. | Tifton | GA | 31794 | 31.4548661 | -83.5107367 | 229-396-5175 | 229-396-5179 | |||
S001185-tuscaloosa | Terri Sewell S001185 | 2501 7th St. | Suite 300 | Tuscaloosa | AL | 35401 | 33.2071459 | -87.56926 | 205-752-5380 | 205-752-5899 | ||
S001185-selma | Terri Sewell S001185 | 908 Alabama Ave. | Suite 112 | Selma | AL | 36701 | 32.4071252 | -87.0214629 | 334-877-4414 | 334-877-4489 | Federal Building |
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);