offices

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

1,163 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

id ▼ legislator_id address suite city state zip latitude longitude phone fax building hours
A000055-cullman Robert Aderholt A000055 205 4th Ave. NE Suite 104 Cullman AL 35055 34.181059 -86.840631 256-734-6043 256-737-0885    
A000055-gadsden Robert Aderholt A000055 600 Broad St. Suite 107 Gadsden AL 35901 34.01421000000001 -86.006846 256-546-0201 256-546-8778    
A000055-jasper Robert Aderholt A000055 1710 Alabama Ave. 247 Jasper AL 35501 33.83438 -87.274935 205-221-2310 205-221-9035 Carl Elliott Building  
A000055-tuscumbia Robert Aderholt A000055 1011 George Wallace Blvd. Suite 146 Tuscumbia AL 35674 34.7412348 -87.6794142 256-381-3450 256-381-7659    
A000369-elko Mark Amodei A000369 905 Railroad St. Suite 104 D Elko NV 89801 40.8355439 -115.7586349 775-777-7705 775-753-9984    
A000369-reno Mark Amodei A000369 5310 Kietzke Ln. Suite 103 Reno NV 89511 39.4715058 -119.791273 775-686-5760 775-686-5711    
A000370-charlotte Alma Adams A000370 801 E. Morehead St. Suite 150 Charlotte NC 28202 35.215055 -80.8452162 704-344-9950 704-344-9971   M-F 9-6pm
A000371-san_bernardino Pete Aguilar A000371 685 E. Carnegie Dr. Suite 100 San Bernardino CA 92408 34.068627 -117.270925 909-890-4445 909-890-9643    
A000372-augusta Rick Allen A000372 2743 Perimeter Pkwy Suite 225 Augusta GA 30909 33.4875735 -82.08466659999999 706-228-1980 706-228-1954 Bldg. 200  
A000372-dublin Rick Allen A000372 100 S. Church St.   Dublin GA 31021 32.5383565 -82.9084154 478-272-4030 478-277-0113    
A000372-statesboro Rick Allen A000372 50 E. Main St.   Statesboro GA 30458 32.4484951 -81.781533 912-243-9452 912-243-9453    
A000372-vidalia Rick Allen A000372 107 Old Airport Rd. Suite A Vidalia GA 30475 32.2046881 -82.37632649999999 912-403-3311      
A000375-abilene Jodey Arrington A000375 500 Chestnut St. Suite 819 Abilene TX 79602 32.4443053 -99.73461449999999 325-675-9779 325-675-5038    
A000375-lubbock Jodey Arrington A000375 1312 Texas Ave. Suite 219 Lubbock TX 79401 33.5830588 -101.8456125 806-763-1611 806-767-9168    
A000376-richardson Colin Allred A000376 100 North Central Expressway Suite 602 Richardson TX 75080-5332 32.95034 -96.73449 972-972-7949 888-671-0539    
A000377-bismarck Kelly Armstrong A000377 220 E Rosser Ave Suite 228 Bismarck ND 58501-3869 46.80868 -100.78881 701-354-6700   U.S. Federal Building  
A000377-fargo Kelly Armstrong A000377 3217 Fiechtner Dr S D Fargo ND 58103-8735 46.86533 -96.83182 701-353-6665      
A000378-council_bluffs Cynthia Axne A000378 501 5th Ave   Council Bluffs IA 51503-0902 41.25685 -95.85104 712-890-3117      
A000378-creston Cynthia Axne A000378 208 W Taylor St   Creston IA 50801-3766 41.04909 -94.36326 202-225-5476      
A000378-des_moines Cynthia Axne A000378 400 E Court Ave Suite 346 Des Moines IA 50309-2017 41.58781 -93.6113 202-225-5476      
B000490-albany Sanford Bishop B000490 323 Pine Ave 400 Albany GA 31701-2596 31.57858 -84.1542 229-439-8067 229-436-2099   M-F 9-5:30pm
B000490-columbus Sanford Bishop B000490 18 Ninth St. Suite 201 Columbus GA 31901 32.4625755 -84.9922596 706-320-9477 706-320-9479   Mon-Fri 9-5:30pm
B000490-macon Sanford Bishop B000490 300 Mulberry Street Suite 502 Macon GA 31201 32.8356646 -83.6267623 478-803-2631 478-803-2637   Mon-Fri 9am-5:30pm
B000574-portland Earl Blumenauer B000574 911 N.E. 11th Ave. Suite 200 Portland OR 97232 45.5293348 -122.6555902 503-231-2300 503-230-5413    
B000575-cape_girardeau Roy Blunt B000575 338 Broadway Suite 303 Cape Girardeau MO 63701 37.3064303 -89.5241403 573-334-7044      
B000575-columbia Roy Blunt B000575 1123 Wilkes Blvd Suite 320 Columbia MO 65201 38.9606243 -92.3229127 573-442-8151      
B000575-kansas_city Roy Blunt B000575 1000 Walnut St. Suite 1560 Kansas City MO 64106 39.1021449 -94.5825038 816-471-7141      
B000575-saint_louis Roy Blunt B000575 111 S 10th St 23.305 Saint Louis MO 63102-1125 38.62588 -90.196 314-725-4484   Thomas F. Eagleton U.S. Courthouse  
B000575-springfield Roy Blunt B000575 2740 B E. Sunshine   Springfield MO 65804 37.180415 -93.240439 417-877-7814      
B000755-conroe Kevin Brady B000755 200 River Pt. Suite 304 Conroe TX 77304 30.2844625 -95.4613914 936-441-5700 936-441-5757    
B000755-huntsville Kevin Brady B000755 1300 11th St. Suite 400 Huntsville TX 77340 30.7240052 -95.5535049 936-439-9532 936-439-9546    
B000944-cincinnati Sherrod Brown B000944 425 Walnut St. Suite 2310 Cincinnati OH 45202 39.1007745 -84.5120256 513-684-1021 513-684-1029    
B000944-cleveland Sherrod Brown B000944 801 W. Superior Ave. Suite 1400 Cleveland OH 44113 41.4964399 -81.6975439 216-522-7272 216-522-2239    
B000944-columbus Sherrod Brown B000944 200 N. High St. Room 614 Columbus OH 43215 39.9666883 -83.000974 614-469-2083 614-469-2171    
B000944-lorain Sherrod Brown B000944 200 W. Erie Ave. Suite 312 Lorain OH 44052 41.4685695 -82.1792684 440-242-4100 440-242-4108    
B001135-asheville Richard Burr B001135 151 Patton Ave. Suite 204 Asheville NC 28801 35.594066 -82.55792 828-350-2437 828-350-2439 Federal Building By appointment only
B001135-rocky_mount Richard Burr B001135 100 Coast Line St. Room 210 Rocky Mount NC 27804 35.9379802 -77.7977748 252-977-9522 252-977-7902   By appointment only.
B001135-wilmington Richard Burr B001135 201 N. Front St. Suite 809 Wilmington NC 28401 34.2376985 -77.9492582 888-848-1833 910-251-7975    
B001135-winston_salem Richard Burr B001135 2000 W. First St. Suite 508 Winston-Salem NC 27104 36.0960116 -80.27480249999999 336-631-5125 336-725-4493    
B001230-ashland Tammy Baldwin B001230 PO Box 61   Ashland WI 54806-0061 46.54692 -90.80933 715-450-3754      
B001230-eau_claire Tammy Baldwin B001230 500 South Barstow St. Suite LL2 Eau Claire WI 54701 44.8088044 -91.5330934 715-832-8424      
B001230-green_bay Tammy Baldwin B001230 1039 W. Mason Suite 119 Green Bay WI 54303 44.5151063 -88.0413549 920-498-2668      
B001230-la_crosse Tammy Baldwin B001230 205 5th Avenue South Room 216 La Crosse WI 54601 43.8109182 -91.24976400000001 608-796-0045      
B001230-madison Tammy Baldwin B001230 30 W. Mifflin St. Suite 700 Madison WI 53703 43.07506559999999 -89.38647139999999 608-264-5338      
B001230-milwaukee Tammy Baldwin B001230 633 W. Wisconsin Ave. Suite 1920 Milwaukee WI 53203 43.0388214 -87.9200848 414-297-4451      
B001230-wausau Tammy Baldwin B001230 2100 Stewart Ave. Suite 250 B Wausau WI 54401 44.9591474 -89.6628755 715-261-2611      
B001236-el_dorado John Boozman B001236 106 W. Main St. Suite 104 El Dorado AR 71730 33.2120448 -92.664046 870-863-4641 870-863-4105    
B001236-fort_smith John Boozman B001236 1120 Garrison Ave. Suite 2B Fort Smith AR 72901 35.383512 -94.42033099999999 479-573-0189 479-573-0553    
B001236-jonesboro John Boozman B001236 300 S. Church St. Suite 400 Jonesboro AR 72401 35.8404281 -90.70368549999999 870-268-6925 870-268-6887    
B001236-little_rock John Boozman B001236 1401 W. Capitol Ave. Suite 155 Little Rock AR 72201 34.7456872 -92.2865752 501-372-7153 501-372-7163    
B001236-lowell John Boozman B001236 213 W. Monroe Suite N Lowell AR 72745 36.2535183 -94.1393049 479-725-0400 479-725-0408    
B001236-mountain_home John Boozman B001236 1001 Hwy 62 East Suite 11 Mountain Home AR 72653 36.3499306 -92.3729619 870-424-0129 870-424-0141    
B001236-stuttgart John Boozman B001236 620 E. 22nd St. Suite 204 Stuttgart AR 72160 34.478784 -91.54664090000001 870-672-6941 870-672-6962    
B001243-chattanooga Marsha Blackburn B001243 10 West M. L. King Blvd 6th Floor Chattanooga TN 37402 35.0455268 -85.3100155 423-541-2939 423-541-2944    
B001243-jackson Marsha Blackburn B001243 109 S Highland Ave Suite 218 Jackson TN 38301     731-660-3971 731-660-3978    
B001243-jonesborough Marsha Blackburn B001243 1105 E Jackson Blvd Suite 4 Jonesborough TN 37659-4997 36.30306 -82.51024 423-753-4009 423-788-0250    
B001243-knoxville Marsha Blackburn B001243 800 Market St Suite 121 Knoxville TN 37902-2327 35.96225 -83.91771 865-540-3781 865-540-7952    
B001243-memphis Marsha Blackburn B001243 100 Peabody Pl Suite 1125 Memphis TN 38103-3654 35.14132 -90.05396 901-527-9199 901-527-9515    
B001243-nashville Marsha Blackburn B001243 3322 West End Avenue Suite 610 Nashville TN 37203     629-800-6600 615-298-2148    
B001248-lake_dallas Michael Burgess B001248 2000 S. Stemmons Fwy. Suite 200 Lake Dallas TX 75065 33.1213325 -97.0327015 940-497-5031 940-497-5067    
B001251-durham George Butterfield B001251 2741 Campus Walk Ave. Suite 300 Durham NC 27705 36.0098844 -78.9533296 919-908-0164 919-908-0169 Bldg. 400  
B001251-wilson George Butterfield B001251 216 NE Nash St. Suite B Wilson NC 27893 35.728383 -77.9131079 252-237-9816 252-291-0356    
B001257-new_port_richey Gus Bilirakis B001257 7132 Little Rd.   New Port Richey FL 34654 28.261156 -82.674347 727-232-2921 727-232-2923    
B001257-tarpon_springs Gus Bilirakis B001257 38500 U.S. Hwy 19 North BB-038 Tarpon Springs FL 34689 28.121418 -82.74161199999999 727-940-5860 727-940-5861 St. Petersburg College  
B001260-bradenton Vern Buchanan B001260 1051 Manatee Ave West Suite 305 Bradenton FL 34205 27.4945988 -82.5724073 941-747-9081 941-748-1564    
B001260-sarasota Vern Buchanan B001260 111 S. Orange Ave. Floor 2R, Suite 202W Sarasota FL 34236 27.3353999 -82.5382987 941-951-6643 941-951-2972    
B001261-casper John Barrasso B001261 100 E. B St. Suite 2004 Casper WY 82601 42.8524124 -106.3248373 307-261-6413      
B001261-cheyenne John Barrasso B001261 2120 Capitol Ave. Suite 2013 Cheyenne WY 82001 41.1374591 -104.8189674 307-772-2451      
B001261-riverton John Barrasso B001261 324 E. Washington Ave.   Riverton WY 82501 43.0238609 -108.386731 307-856-6642      
B001261-rock_springs John Barrasso B001261 1575 Dewar Drive Suite 218 Rock Springs WY 82901 41.5742346 -109.2423116 307-362-5012   Commerce Bank  
B001261-sheridan John Barrasso B001261 2 N. Main St. Suite 206 Sheridan WY 82801 44.7974506 -106.9562525 307-672-6456      
B001267-alamosa Michael Bennet B001267 609 Main St. Suite 110 Alamosa CO 81101 37.4685012 -105.8659434 719-587-0096      
B001267-colorado_springs Michael Bennet B001267 409 N. Tejon St. Suite 107 Colorado Springs CO 80903 38.8400247 -104.8228748 719-328-1100 719-328-1129    
B001267-denver Michael Bennet B001267 1244 Speer Blvd.   Denver CO 80204 39.7364704 -104.994978 303-455-7600 303-455-8851 Cesar E. Chavez Memorial Building  
B001267-durango Michael Bennet B001267 835 E. 2nd Ave. Suite 206 Durango CO 81301 37.2725939 -107.8799634 970-259-1710      
B001267-fort_collins Michael Bennet B001267 1200 S. College Ave. Suite 211 Fort Collins CO 80524 40.5716714 -105.0766516 970-224-2200 970-224-2205    
B001267-grand_junction Michael Bennet B001267 225 N. 5th St. Suite 511 Grand Junction CO 81501 39.0688046 -108.5648398 970-241-6631      
B001267-pueblo Michael Bennet B001267 129 W. B St.   Pueblo CO 81003 38.2795281 -104.508253 719-542-7550      
B001270-los_angeles Karen Bass B001270 4929 Wilshire Blvd. Suite 650 Los Angeles CA 90010 34.06264360000001 -118.3381029 323-965-1422 323-965-1113    
B001274-decatur Mo Brooks B001274 302 Lee St. Room 86 Decatur AL 35601 34.6069984 -86.9849204 256-355-9400 256-355-9406    
B001274-florence Mo Brooks B001274 102 S. Court St. Suite 310 Florence AL 35630 34.8002305 -87.6771285 256-718-5155 256-718-5156    
B001274-huntsville Mo Brooks B001274 2101 W. Clinton Ave. Suite 302 Huntsville AL 35805 34.7252133 -86.5977423 256-551-0190 256-551-0194    
B001275-evansville Larry Bucshon B001275 420 Main St. Suite 1402 Evansville IN 47708 37.9722214 -87.5705016 812-465-6484 812-422-4761   Monday-Friday 8:30am-5:00pm CT
B001275-jasper Larry Bucshon B001275 610 Main St. First Floor Small Conference Room Jasper IN 47547 38.3919787 -86.9304537       1st and 3rd Tuesday of the month 10:00am - 1:00pm ET
B001275-terre_haute Larry Bucshon B001275 901 Wabash Ave. Suite 140 Terre Haute IN 47807 39.466224 -87.4042291 812-232-0523 812-232-0526   8:30am - 5:00pm ET
B001275-vincennes Larry Bucshon B001275 1500 N. Chestnut St.   Vincennes IN 47591 38.6911192 -87.52073879999999       1st and 3rd Wednesday of the month 9:00am - 12:00pm ET
B001277-bridgeport Richard Blumenthal B001277 915 Lafayette Blvd. Suite 304 Bridgeport CT 06604 41.1749972 -73.1931954 203-330-0598 203-330-0608    
B001277-hartford Richard Blumenthal B001277 90 State House Sq. 10th Floor Hartford CT 06103 41.7665316 -72.6719747 860-258-6940 860-258-6958    
B001278-beaverton Suzanne Bonamici B001278 12725 SW Millikan Way Suite 220 Beaverton OR 97005 45.4900502 -122.8078224 503-469-6010 503-469-6018   Monday-Friday 9:00AM-5:00PM
B001281-columbus Joyce Beatty B001281 471 E. Broad St. Suite 1100 Columbus OH 43215 39.9633834 -82.9878075 614-220-0003 614-220-5640   Monday-Friday 9:00am-5:00pm
B001282-lexington Garland Barr B001282 2709 Old Rosebud Rd.   Lexington KY 40509 38.0283634 -84.4193762 859-219-1366     M-F 9:00-5:00pm
B001285-oxnard Julia Brownley B001285 201 East Fourth St. Suite 209B Oxnard CA 93030 34.1993342 -119.1783991 805-379-1779 805-379-1799   Call to make an appointment
B001285-thousand_oaks Julia Brownley B001285 223 E. Thousand Oaks Blvd. Suite 220 Thousand Oaks CA 91360 34.1794905 -118.8726791 805-379-1779 805-379-1799   Monday-Thursday 9:00am-5:30pm PT,Friday 9:00am-5:00pm PT
B001286-peoria Cheri Bustos B001286 820 SW Adams St   Peoria IL 61602 40.6855433 -89.5987706 309-966-1813      
B001286-rock_island Cheri Bustos B001286 2401 4th Ave.   Rock Island IL 61201 41.5089919 -90.5662359 309-786-3406 309-786-3720    
B001286-rockford Cheri Bustos B001286 119 N. Church St. Suite 207 & 208 Rockford IL 61101 42.2720192 -89.0952944 815-968-8011      
B001287-sacramento Ami Bera B001287 8950 Cal Center Dr. Suite 100 Sacramento CA 95826 38.5553768 -121.3738588 916-635-0505 916-635-0514 Building 3 M-F 9am -6pm
B001288-camden Cory Booker B001288 2 Riverside Dr. Suite 505 Camden NJ 08101 39.9443128 -75.1296174 856-338-8922 856-338-8936 One Port Center  
B001288-newark Cory Booker B001288 One Gateway Center 23rd Floor Newark NJ 07102 40.7344571 -74.1657213 973-639-8700 973-639-8723    
B001291-deer_park Brian Babin B001291 203 Ivy Ave. Suite 600 Deer Park TX 77536 29.7089323 -95.12126239999999 832-780-0966 832-780-0964    

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);