offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,163 rows sorted by hours
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
B001309-maryville | Tim Burchett B001309 | 341 Court St | Maryville | TN | 37804-5906 | 35.75488 | -83.96911 | 865-984-5464 | ||||
B001310-fort_wayne | Mike Braun B001310 | 203 E Berry St | 702B | Fort Wayne | IN | 46802-2724 | 41.0796 | -85.13801 | 260-427-2167 | |||
B001310-hammond | Mike Braun B001310 | 5400 Federal Plz | Suite 3200 | Hammond | IN | 46320-1840 | 41.61616 | -87.51962 | 219-937-9650 | |||
B001310-indianapolis | Mike Braun B001310 | 115 N Pennsylvania St | Indianapolis | IN | 46204-2410 | 39.76888 | -86.15612 | 317-822-8240 | 317-822-8353 | |||
B001310-south_bend | Mike Braun B001310 | 205 W Colfax Ave | South Bend | IN | 46601-1606 | 41.67813 | -86.25266 | 574-288-6302 | ||||
B001311-monroe | Dan Bishop B001311 | 300 N Main Street | Monroe | NC | 28112 | 34.982986 | -80.5499099 | 740-218-5300 | 844-273-1255 | |||
C000059-corona | Ken Calvert C000059 | 400 S. Vicentia Ave. | Suite 125 | Corona | CA | 92882 | 33.8784386 | -117.5759232 | 951-277-0042 | 951-277-0420 | ||
C000127-everett | Maria Cantwell C000127 | 2930 Wetmore Ave. | Suite 9B | Everett | WA | 98201 | 47.9781562 | -122.2076204 | 425-303-0114 | 425-303-8351 | ||
C000127-richland | Maria Cantwell C000127 | 825 Jadwin Ave. | Suite 206 | Richland | WA | 99352 | 46.2775762 | -119.2760977 | 509-946-8106 | 509-946-6937 | ||
C000127-seattle | Maria Cantwell C000127 | 915 Second Ave. | Suite 3206 | Seattle | WA | 98174 | 47.6045895 | -122.3354608 | 206-220-6400 | 206-220-6404 | ||
C000127-spokane | Maria Cantwell C000127 | 920 W. Riverside Ave. | Suite 697 | Spokane | WA | 99201 | 47.6585992 | -117.4260094 | 509-353-2507 | 509-353-2547 | ||
C000127-tacoma | Maria Cantwell C000127 | 950 Pacific Ave. | Suite 615 | Tacoma | WA | 98402 | 47.2535757 | -122.4390697 | 253-572-2281 | 253-572-5879 | ||
C000127-vancouver | Maria Cantwell C000127 | 1313 Officers Row | Vancouver | WA | 98661 | 45.628864 | -122.6641029 | 360-696-7838 | 360-696-7844 | |||
C000141-baltimore | Benjamin Cardin C000141 | 100 S. Charles St. | Suite 1710 | Baltimore | MD | 21201 | 39.2871649 | -76.6156372 | 410-962-4436 | 410-962-4156 | Tower 1 | |
C000141-cumberland | Benjamin Cardin C000141 | 13 Canal St. | Room 305 | Cumberland | MD | 21502 | 39.6495579 | -78.76360249999999 | 301-777-2957 | 301-777-2959 | ||
C000141-rockville | Benjamin Cardin C000141 | 451 Hungerford Dr. | Suite 230 | Rockville | MD | 20850 | 39.0895234 | -77.1511348 | 301-762-2974 | 301-762-2976 | ||
C000141-salisbury | Benjamin Cardin C000141 | 212 W. Main St. | Suite 301C | Salisbury | MD | 21801 | 38.3652837 | -75.6023764 | 410-546-4250 | 202-224-1651 | Plaza Gallery Building | |
C000880-boise | Michael Crapo C000880 | 251 E. Front St. | Suite 205 | Boise | ID | 83702 | 43.6086015 | -116.1956172 | 208-334-1776 | 208-334-9044 | ||
C000880-coeur_d_alene | Michael Crapo C000880 | 610 Hubbard Ave | Suite 209 | Coeur d'Alene | ID | 83814 | 47.6826921 | -116.7920799 | 208-664-5490 | 208-664-0889 | ||
C000880-idaho_falls | Michael Crapo C000880 | 410 Memorial Dr. | Suite 204 | Idaho Falls | ID | 83402 | 43.4936265 | -112.0425928 | 208-522-9779 | 208-529-8367 | ||
C000880-lewiston | Michael Crapo C000880 | 313 'D' St. | Suite 105 | Lewiston | ID | 83501 | 46.422158 | -117.028638 | 208-743-1492 | 208-743-6484 | ||
C000880-pocatello | Michael Crapo C000880 | 275 S. 5th Ave. | Suite 100 | Pocatello | ID | 83201 | 42.8649373 | -112.4428822 | 208-236-6775 | 208-236-6935 | ||
C000880-twin_falls | Michael Crapo C000880 | 202 Falls Ave. | Suite 2 | Twin Falls | ID | 83301 | 42.5776169 | -114.47751 | 208-734-2515 | 208-733-0414 | ||
C001035-augusta | Susan Collins C001035 | 68 Sewall St. | Room 507 | Augusta | ME | 04330 | 44.310824 | -69.783697 | 207-622-8414 | |||
C001035-bangor | Susan Collins C001035 | 202 Harlow St. | Room 20100 | Bangor | ME | 04401 | 44.8046399 | -68.7737891 | 207-945-0417 | |||
C001035-biddeford | Susan Collins C001035 | 160 Main St. | Biddeford | ME | 04005 | 43.493177 | -70.4548329 | 207-283-1101 | ||||
C001035-caribou | Susan Collins C001035 | 25 Sweden St. | Suite A | Caribou | ME | 04736 | 46.860458 | -68.013198 | 207-493-7873 | |||
C001035-lewiston | Susan Collins C001035 | 55 Lisbon St. | Lewiston | ME | 04240 | 44.097439 | -70.217972 | 207-784-6969 | ||||
C001035-portland | Susan Collins C001035 | One Canal Plaza | Suite 802 | Portland | ME | 04101 | 43.6566885 | -70.2551294 | 207-780-3575 | |||
C001047-charleston | Shelley Capito C001047 | 500 Virgina Street East | Suite 950 | Charleston | WV | 25301 | 38.3511449 | -81.6380602 | 304-347-5372 | |||
C001047-martinsburg | Shelley Capito C001047 | 300 Foxcroft Ave. | Suite 202A | Martinsburg | WV | 25401 | 39.4607489 | -77.986887 | 304-262-9285 | |||
C001047-morgantown | Shelley Capito C001047 | 48 Donley St. | Suite 504 | Morgantown | WV | 26501 | 39.6256581 | -79.96312549999999 | 304-292-2310 | |||
C001051-round_rock | John Carter C001051 | 1717 North IH 35 | Suite 303 | Round Rock | TX | 78664 | 30.5234565 | -97.688835 | 512-246-1600 | |||
C001051-temple | John Carter C001051 | 6544 S General Bruce Dr | B | Temple | TX | 76502 | 31.0718016 | -97.4233588 | 254-933-1392 | |||
C001053-ada | Tom Cole C001053 | 100 E. 13th St. | Suite 213 | Ada | OK | 74820 | 34.7723614 | -96.6790693 | 580-436-5375 | 580-436-5451 | ||
C001053-lawton | Tom Cole C001053 | 711 SW. D Ave. | Suite 201 | Lawton | OK | 73501 | 34.6044481 | -98.3995211 | 580-357-2131 | 580-357-7477 | ||
C001053-norman | Tom Cole C001053 | 2424 Springer Dr. | Suite 201 | Norman | OK | 73069 | 35.2053158 | -97.47880409999999 | 405-329-6500 | 405-321-7369 | ||
C001055-honolulu | Ed Case C001055 | 1132 Bishop St | Suite 1910 | Honolulu | HI | 96813-2807 | 21.30973 | -157.86005 | 808-650-6688 | |||
C001056-austin | John Cornyn C001056 | 221 W. Sixth St. | Suite 1530 | Austin | TX | 78701 | 30.2681008 | -97.7448471 | 512-469-6034 | 512-469-6020 | Chase Tower | |
C001056-dallas | John Cornyn C001056 | 5001 Spring Valley Rd. | Suite 1125 E | Dallas | TX | 75244 | 32.9400414 | -96.82359749999999 | 972-239-1310 | 972-239-2110 | ||
C001056-harlingen | John Cornyn C001056 | 222 E. Van Buren | Suite 404 | Harlingen | TX | 78550 | 26.1914148 | -97.69402009999999 | 956-423-0162 | 956-423-0193 | ||
C001056-houston | John Cornyn C001056 | 5300 Memorial Dr. | Suite 980 | Houston | TX | 77007 | 29.7620629 | -95.41595319999999 | 713-572-3337 | 713-572-3777 | ||
C001056-lubbock | John Cornyn C001056 | 1500 Broadway | Suite 1230 | Lubbock | TX | 79401 | 33.5849492 | -101.8519083 | 806-472-7533 | 806-472-7536 | Wells Fargo Center | |
C001056-san_antonio | John Cornyn C001056 | 600 Navarro | Suite 210 | San Antonio | TX | 78205 | 29.4267857 | -98.48957639999999 | 210-224-7485 | 210-224-8569 | ||
C001056-tyler | John Cornyn C001056 | 100 E. Ferguson St. | Suite 1004 | Tyler | TX | 75702 | 32.3522862 | -95.30028709999999 | 903-593-0902 | 903-593-0920 | Regions Bank Building | |
C001059-fresno | Jim Costa C001059 | 855 M St. | Suite 940 | Fresno | CA | 93721 | 36.7345489 | -119.7858717 | 559-495-1620 | |||
C001059-merced | Jim Costa C001059 | 2222 M St. | Suite 305 | Merced | CA | 95340 | 37.3070723 | -120.4812216 | 209-384-1620 | |||
C001063-mission | Henry Cuellar C001063 | 117 E. Tom Landry | Mission | TX | 78572 | 26.2161009 | -98.32499899999999 | 956-424-3942 | 956-424-3936 | |||
C001063-rio_grande_city | Henry Cuellar C001063 | 100 N. F.M. 3167 | Rio Grande City | TX | 78582 | 26.3834188 | -98.85823049999999 | 956-487-5603 | 956-488-0952 | |||
C001063-san_antonio | Henry Cuellar C001063 | 615 E. Houston St. | Suite 563 | San Antonio | TX | 78205 | 29.4270611 | -98.48622759999999 | 210-271-2851 | 210-277-6671 | ||
C001067-brooklyn | Yvette Clarke C001067 | 222 Lenox Rd. | Suites 1 & 2 | Brooklyn | NY | 11226 | 40.6536853 | -73.9516805 | 718-287-1142 | 718-287-1223 | ||
C001069-enfield | Joe Courtney C001069 | 77 Hazard Ave. | Unit J | Enfield | CT | 06082 | 41.9904484 | -72.5723972 | 860-741-6011 | 860-741-6036 | ||
C001069-norwich | Joe Courtney C001069 | 55 Main St. | Suite 250 | Norwich | CT | 06360 | 41.524272 | -72.07896800000002 | 860-886-0139 | 860-886-2974 | ||
C001070-allentown | Robert Casey C001070 | 840 Hamilton St. | Suite 301 | Allentown | PA | 18101 | 40.6010783 | -75.47499979999999 | 610-782-9470 | 610-782-9474 | ||
C001070-bellefonte | Robert Casey C001070 | 817 E. Bishop St. | Suite C | Bellefonte | PA | 16823 | 40.9138418 | -77.7641528 | 814-357-0314 | 814-357-0318 | ||
C001070-erie | Robert Casey C001070 | 17 S. Park Row. | Suite B-150 | Erie | PA | 16501 | 42.1289745 | -80.08406889999999 | 814-874-5080 | 814-874-5084 | ||
C001070-harrisburg | Robert Casey C001070 | 200 N. Third St. | Suite 14A | Harrisburg | PA | 17101 | 40.2619774 | -76.8829619 | 717-231-7540 | 717-231-7542 | ||
C001070-philadelphia | Robert Casey C001070 | 2000 Market St. | Suite 610 | Philadelphia | PA | 19103 | 39.9532694 | -75.1736461 | 215-405-9660 | 215-405-9669 | ||
C001070-pittsburgh | Robert Casey C001070 | 310 Grant St. | Suite 2415 | Pittsburgh | PA | 15219 | 40.4376694 | -79.99749159999999 | 412-803-7370 | 412-803-7379 | Grant Building | |
C001070-scranton | Robert Casey C001070 | 417 Lackawanna Ave. | Suite 303 | Scranton | PA | 18503 | 41.4073687 | -75.6654743 | 570-941-0930 | 570-941-0937 | ||
C001075-alexandria | Bill Cassidy C001075 | 3600 Jackson St. | Suite 115A | Alexandria | LA | 71303 | 31.2852075 | -92.47677350000001 | 318-448-7176 | 318-448-5175 | ||
C001075-baton_rouge | Bill Cassidy C001075 | 5555 Hilton Ave. | Suite 100 | Baton Rouge | LA | 70808 | 30.423884 | -91.1325791 | 225-929-7711 | 225-929-7688 | ||
C001075-lafayette | Bill Cassidy C001075 | 101 La Rue France | Suite 505 | Lafayette | LA | 70508 | 30.1948666 | -92.014654 | 337-261-1400 | 337-261-1490 | ||
C001075-lake_charles | Bill Cassidy C001075 | 1 Lakeshore Dr. | Suite 1155 | Lake Charles | LA | 70629 | 30.2305579 | -93.2196294 | 337-493-5398 | 337-493-5629 | ||
C001075-metairie | Bill Cassidy C001075 | 3421 N. Causeway Blvd. | Suite 204 | Metairie | LA | 70002 | 30.0112259 | -90.15417479999999 | 504-838-0130 | 504-838-0133 | ||
C001075-monroe | Bill Cassidy C001075 | 1651 Louisville Ave. | Suite 123 | Monroe | LA | 70201 | 32.5175209 | -92.1087384 | 318-324-2111 | 318-324-2197 | ||
C001075-shreveport | Bill Cassidy C001075 | 6425 Youree Dr. | Suite 415 | Shreveport | LA | 71105 | 32.448457 | -93.71986679999999 | 318-798-3215 | 318-798-6959 | ||
C001078-annandale | Gerald Connolly C001078 | 4115 Annandale Rd. | Suite 103 | Annandale | VA | 22003 | 38.8338994 | -77.1967528 | 703-256-3071 | 703-354-1284 | ||
C001078-woodbridge | Gerald Connolly C001078 | 2241-D Tacketts Mill Drive | Woodbridge | VA | 22192 | 38.6752583 | -77.2815925 | 571-408-4407 | 571-408-4708 | |||
C001080-pasadena | Judy Chu C001080 | 527 S. Lake Ave. | Suite 106 | Pasadena | CA | 91101 | 34.1367185 | -118.1327226 | 626-304-0110 | 626-304-0132 | ||
C001088-dover | Christopher Coons C001088 | 500 W. Loockerman St. | Suite 450 | Dover | DE | 19904 | 39.15666239999999 | -75.5311574 | 302-736-5601 | 302-736-5609 | ||
C001088-wilmington | Christopher Coons C001088 | 1105 N. Market St. | Suite 100 | Wilmington | DE | 19801-1233 | 39.7473432 | -75.5471367 | 302-573-6345 | 302-573-6351 | ||
C001095-el_dorado | Tom Cotton C001095 | 106 W. Main St. | Suite 410 | El Dorado | AR | 71730 | 33.2120448 | -92.664046 | 870-864-8582 | 870-864-8571 | ||
C001095-jonesboro | Tom Cotton C001095 | 300 S. Church | Suite 338 | Jonesboro | AR | 72401 | 35.8404281 | -90.70368549999999 | 870-933-6223 | 870-933-6596 | ||
C001095-little_rock | Tom Cotton C001095 | 1401 W. Capitol Ave. | Suite 235 | Little Rock | AR | 72201 | 34.7456872 | -92.2865752 | 501-223-9081 | 501-223-9105 | ||
C001095-springdale | Tom Cotton C001095 | 1108 S. Old Missouri Rd. | Suite B | Springdale | AR | 72764 | 36.17457100000001 | -94.1176151 | 479-751-0879 | 479-927-1092 | ||
C001096-fargo | Kevin Cramer C001096 | 3217 Fiechtner Dr. | Suite D | Fargo | ND | 58103 | 46.8653775 | -96.83148949999999 | 701-356-2216 | 701-356-2217 | ||
C001096-grand_forks | Kevin Cramer C001096 | 4200 James Ray Dr. | Office 600 | Grand Forks | ND | 58202 | 47.921087 | -97.090537 | 701-738-4880 | |||
C001096-minot | Kevin Cramer C001096 | 315 Main St. | Suite 203 | Minot | ND | 58701 | 48.23281009999999 | -101.2926299 | 701-839-0255 | |||
C001098-austin | Ted Cruz C001098 | 300 E 8th | Suite 961 | Austin | TX | 78701 | 30.269401 | -97.7390867 | 512-916-5834 | 512-916-5839 | ||
C001098-dallas | Ted Cruz C001098 | 3626 N. Hall St. | Suite 410 | Dallas | TX | 75219 | 32.8092691 | -96.8059281 | 214-599-8749 | 214-361-3518 | Lee Park Tower II | |
C001098-houston | Ted Cruz C001098 | 1919 Smith St. | Suite 9047 | Houston | TX | 77002 | 29.758844 | -95.3650242 | 713-718-3057 | 713-209-3459 | The Mickey Leland Federal Building | |
C001098-mcallen | Ted Cruz C001098 | 200 S. 10th St. | Suite 1603 | McAllen | TX | 78501 | 26.2019273 | -98.2313667 | 956-686-7339 | |||
C001098-san_antonio | Ted Cruz C001098 | 9901 Ih-10w | Suite 950 | San Antonio | TX | 78230 | 29.533858 | -98.5619881 | 210-340-2885 | 210-349-6753 | ||
C001098-tyler | Ted Cruz C001098 | 305 S. Broadway | Suite 501 | Tyler | TX | 75702 | 32.3480097 | -95.3009807 | 903-593-5130 | |||
C001103-brunswick | Earl Carter C001103 | 1510 Newcastle St. | Suite 200 | Brunswick | GA | 31520 | 31.149693 | -81.49532 | 912-265-9010 | 912-265-9013 | ||
C001103-savannah | Earl Carter C001103 | 6602 Abercorn St. | Suite 105B | Savannah | GA | 31405 | 32.017594 | -81.11040299999999 | 912-352-0101 | 912-352-0105 | ||
C001108-paducah | James Comer C001108 | 300 S. 3rd St. | Paducah | KY | 42003 | 37.0851283 | -88.595174 | 270-408-1865 | ||||
C001108-tompkinsville | James Comer C001108 | 200 N. Main St. | Suite F | Tompkinsville | KY | 42167 | 36.7006713 | -85.6929017 | 270-487-9509 | |||
C001109-casper | Liz Cheney C001109 | 100 East B Street | Room 4003 | Casper | WY | 82602 | 42.8524124 | -106.3248373 | 307-261-6595 | 307-261-6597 | ||
C001109-cheyenne | Liz Cheney C001109 | 2120 Capitol Ave. | Suite 8005 | Cheyenne | WY | 82001 | 41.1374591 | -104.8189674 | 307-772-2595 | 307-772-2597 | ||
C001109-gillette | Liz Cheney C001109 | 300 S. Gillette Ave. | Suite 2001 | Gillette | WY | 82716 | 44.2920649 | -105.5066014 | 307-414-1677 | 307-414-1711 | ||
C001109-sheridan | Liz Cheney C001109 | 45 E. Loucks St. | Suite 300 F | Sheridan | WY | 82801 | 44.7974845 | -106.9548869 | 307-673-4608 | 307-261-6597 | ||
C001110-santa_ana | J. Correa C001110 | 2323 N. Broadway | Suite 319 | Santa Ana | CA | 92706 | 33.7673604 | -117.8703812 | 714-621-0102 | Rancho Santiago Community College Building | ||
C001112-san_luis_obispo | Salud Carbajal C001112 | 1411 Marsh St. | Suite 205 | San Luis Obispo | CA | 93401 | 35.2838648 | -120.6538213 | 805-546-8348 | 805-439-3574 | ||
C001112-santa_barbara | Salud Carbajal C001112 | 360 S. Hope Ave. | Suite C-301 | Santa Barbara | CA | 93105 | 34.434901 | -119.746862 | 805-546-8348 | |||
C001112-santa_maria | Salud Carbajal C001112 | 1619 S. Thornburg St. | Santa Maria | CA | 93458 | 34.434901 | -120.4405464 | 805-730-1710 | ||||
C001114-provo | John Curtis C001114 | 51 South University Avenue | Suite 318 | Provo | UT | 84601 | 40.232986 | -111.6578512 | 801-851-2500 | |||
C001115-corpus_christi | Michael Cloud C001115 | 101 N. Shoreline Blvd. | Suite 300 | Corpus Christi | TX | 78401 | 27.7917948 | -97.3931982 | 361-884-2222 | |||
C001115-victoria | Michael Cloud C001115 | 5606 N. Navarro St. | Suite 203 | Victoria | TX | 77904 | 28.8476874 | -96.9978986 | 361-894-6446 |
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);