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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
C001117-west_chicago | Sean Casten C001117 | 2700 International Dr | Suite 304 | West Chicago | IL | 60185-1670 | 41.8672 | -88.25793 | ||||
C001118-harrisonburg | Ben Cline C001118 | 70 N Mason St | Suite 110 | Harrisonburg | VA | 22802-4126 | 38.44978 | -78.86637 | 540-432-2391 | 540-432-6593 | ||
C001118-lynchburg | Ben Cline C001118 | 916 Main St | Suite 300 | Lynchburg | VA | 24504-1600 | 37.41441 | -79.14153 | 434-845-8306 | 434-845-8245 | ||
C001118-roanoke | Ben Cline C001118 | 10 Franklin Rd SE | Suite 510 | Roanoke | VA | 24011-2133 | 37.2694 | -79.94051 | 540-857-2672 | 540-857-2675 | ||
C001118-staunton | Ben Cline C001118 | 117 S Lewis St | Suite 215 | Staunton | VA | 24401-4282 | 38.14838 | -79.07444 | 540-885-3861 | 540-885-3930 | ||
C001119-burnsville | Angie Craig C001119 | 12940 Harriet Ave S | Suite 238 | Burnsville | MN | 55337-2680 | 44.7684 | -93.2863 | 651-846-2120 | |||
C001120-kingwood | Dan Crenshaw C001120 | 1801 Kingwood Dr | Suite 240 | Kingwood | TX | 77339-3060 | 30.05138 | -95.22975 | 713-860-1330 | |||
C001121-aurora | Jason Crow C001121 | 3300 S Parker Rd | Suite 100 | Aurora | CO | 80014-3518 | 39.65758 | -104.83538 | 720-748-7514 | |||
D000096-chicago | Danny Davis D000096 | 2813-15 W. Fifth Ave. | Chicago | IL | 60612 | 41.8807415 | -87.6990211 | 773-533-7520 | 773-533-7530 | |||
D000216-new_haven | Rosa DeLauro D000216 | 59 Elm St. | New Haven | CT | 06510 | 41.3080224 | -72.92267679999999 | 203-562-3718 | 203-772-2260 | |||
D000399-austin | Lloyd Doggett D000399 | 300 E. 8th St. | Suite 763 | Austin | TX | 78701 | 30.269401 | -97.7390867 | 512-916-5921 | |||
D000399-san_antonio | Lloyd Doggett D000399 | 217 W. Travis St. | San Antonio | TX | 78205 | 29.427604 | -98.4951151 | 210-704-1080 | ||||
D000482-bethel_park | Michael Doyle D000482 | 4705 Library Rd | Bethel Park | PA | 15102-2969 | 40.34915 | -80.02294 | 412-283-4451 | 412-283-4465 | |||
D000617-mount_vernon | Suzan DelBene D000617 | 204 W. Montgomery St. | Mount Vernon | WA | 98273 | 48.41949899999999 | -122.3357879 | 360-416-7879 | 425-485-0083 | |||
D000618-billings | Steve Daines D000618 | 222 N. 32nd St. | Suite 100 | Billings | MT | 59101 | 45.7810512 | -108.5125313 | 406-245-6822 | |||
D000618-bozeman | Steve Daines D000618 | 13 S. Willson Ave. | Suite 8 | Bozeman | MT | 59718 | 45.6788798 | -111.0390251 | 406-587-3446 | |||
D000618-great_falls | Steve Daines D000618 | 104 4th Street North | Suite 302 | Great Falls | MT | 59401 | 47.5067244 | -111.3009733 | 406-453-0148 | |||
D000618-hardin | Steve Daines D000618 | 310 N Ctr. | Hardin | MT | 59034 | 45.731817 | -107.606432 | 406-665-4126 | ||||
D000618-helena | Steve Daines D000618 | 30 W. 14th St. | Suite 206 | Helena | MT | 59601 | 46.596642 | -112.036443 | 406-443-3189 | |||
D000618-kalispell | Steve Daines D000618 | 40 2nd St East | Suite 211 | Kalispell | MT | 59901 | 48.19663569999999 | -114.3118812 | 406-257-3765 | KM Building | ||
D000618-missoula | Steve Daines D000618 | 218 E. Front St. | Suite 103 | Missoula | MT | 59802 | 46.8699041 | -113.9930208 | 406-549-8198 | |||
D000618-sidney | Steve Daines D000618 | 609 S. Central Ave. | Suite #4 | Sidney | MT | 59270 | 47.7106368 | -104.1606344 | 406-482-9010 | Central Plaza Building | ||
D000622-belleville | Tammy Duckworth D000622 | 23 Public Sq | Suite 460 | Belleville | IL | 62220-1650 | 38.5135 | -89.98093 | 618-722-7070 | 618-235-4011 | ||
D000622-carbondale | Tammy Duckworth D000622 | 441 E Willow St | Carbondale | IL | 62901-1659 | 37.73428 | -89.21251 | 618-677-7000 | 618-351-1551 | |||
D000622-chicago | Tammy Duckworth D000622 | 230 South Dearborn Street | Suite 3900 | Chicago | IL | 60604 | 41.8784454 | -87.63 | 312-886-3506 | |||
D000622-rock_island | Tammy Duckworth D000622 | 1823 2nd Ave | Suite 2 | Rock Island | IL | 61201-8002 | 41.51114 | -90.57433 | 309-606-7060 | 309-786-1799 | ||
D000622-springfield | Tammy Duckworth D000622 | 8 South Old State Capitol Plaza | Springfield | IL | 62701 | 39.800468 | -89.6509028 | 217-528-6124 | ||||
D000623-richmond | Mark DeSaulnier D000623 | 440 Civic Center Plz. | 2nd Floor | Richmond | CA | 94804 | 37.9367699 | -122.3428337 | 510-620-1000 | 510-620-1005 | ||
D000623-walnut_creek | Mark DeSaulnier D000623 | 3100 Oak Road | Suite 110 | Walnut Creek | CA | 94597 | 37.9043441 | -122.0583137 | 925-933-2660 | 925-933-2677 | ||
D000624-dearborn | Debbie Dingell D000624 | 19855 West Outer Drive | Suite 103-E | Dearborn | MI | 48124 | 42.3034918 | -83.2627983 | 313-278-2936 | |||
D000624-ypsilanti | Debbie Dingell D000624 | 301 W. Michigan Ave. | Suite 400 | Ypsilanti | MI | 48197 | 42.24069780000001 | -83.6164891 | 734-481-1100 | |||
D000626-troy | Warren Davidson D000626 | 20 Dotcom Drive | Troy | OH | 45373 | 40.0578289 | -84.2463325 | 937-339-1524 | ||||
D000626-west_chester | Warren Davidson D000626 | 8857 Cincinnati-Dayton Rd. | Suite #102 | West Chester | OH | 45069 | 39.33175850000001 | -84.4066223 | 513-779-5400 | |||
D000627-orlando | Val Demings D000627 | 2295 S. Hiawassee Rd. | Suite 301 | Orlando | FL | 32835 | 28.517804 | -81.48186439999999 | 321-388-9808 | |||
D000628-panama_city | Neal Dunn D000628 | 840 W. 11th St. | Suite 2250 | Panama City | FL | 32401 | 30.167961 | -85.67189499999999 | 850-785-0812 | 850-763-3764 | ||
D000628-tallahassee | Neal Dunn D000628 | 300 S. Adams St. | Tallahassee | FL | 32301 | 30.4395286 | -84.2826688 | 850-891-8610 | 850-891-8620 | |||
D000629-overland_park | Sharice Davids D000629 | 7325 W 79th St | Overland Park | KS | 66204-2908 | 38.9858 | -94.67027 | 913-621-0832 | 913-621-1533 | |||
D000631-glenside | Madeleine Dean D000631 | 115 E Glenside Ave | Suite 1 | Glenside | PA | 19038-4618 | 40.10015 | -75.15143 | 215-884-4300 | 215-884-3640 | ||
D000631-norristown | Madeleine Dean D000631 | 101 E Main St | A | Norristown | PA | 19401-4916 | 40.11381 | -75.34223 | 610-382-1250 | 610-275-1759 | ||
E000215-palo_alto | Anna Eshoo E000215 | 698 Emerson St. | Palo Alto | CA | 94301 | 37.4431725 | -122.1606451 | 650-323-2984 | 650-323-3498 | |||
E000294-otsego | Tom Emmer E000294 | 9201 Quaday Ave. NE | Suite 206 | Otsego | MN | 55330 | 45.2839958 | -93.5648066 | 763-241-6848 | 763-241-7955 | ||
E000296-philadelphia | Dwight Evans E000296 | 7174 Ogontz Ave. | Philadelphia | PA | 19138 | 40.063831 | -75.153345 | 215-276-0340 | 215-276-2939 | |||
E000297-bronx | Adriano Espaillat E000297 | 2530 Grand Concourse Avenue | Ground Floor | Bronx | NY | 10458 | 40.863512 | -73.895791 | 718-450-8241 | |||
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 | ||
E000298-wichita | Ron Estes E000298 | 7701 E Kellogg Ave | Suite 510 | Wichita | KS | 67207 | 37.6780708 | -97.24667099999999 | 316-262-8992 | 316-262-5309 | ||
E000299-el_paso | Veronica Escobar E000299 | 221 N Kansas St | Suite 1500 | El Paso | TX | 79901-1443 | 31.76012 | -106.48618 | 915-541-1400 | Wells Fargo Plaza | ||
F000462-boca_raton | Lois Frankel F000462 | 2500 N. Military Trl. | Suite 490 | Boca Raton | FL | 33431 | 26.3730924 | -80.1203093 | 561-998-9045 | 561-998-9048 | ||
F000463-kearney | Deb Fischer F000463 | 20 W. 23rd St. | Kearney | NE | 68847 | 40.6986843 | -99.0819184 | 308-234-2361 | 308-234-3684 | |||
F000463-lincoln | Deb Fischer F000463 | 440 N. 8th St. | Suite 120 | Lincoln | NE | 68508 | 40.8177383 | -96.7095183 | 402-441-4600 | 402-476-8753 | ||
F000463-omaha | Deb Fischer F000463 | 11819 Miracle Hills Drive | Suite 205 | Omaha | NE | 68154 | 41.26733180000001 | -96.0980857 | 402-391-3411 | 402-391-4725 | ||
F000463-scottsbluff | Deb Fischer F000463 | 120 East 16th St. | Suite 203 | Scottsbluff | NE | 69361 | 41.8680501 | -103.6483008 | 308-630-2329 | 308-630-2321 | ||
F000465-newnan | A. Ferguson F000465 | 1601 E Hwy 34 | Suite B | Newnan | GA | 30265 | 33.3996108 | -84.72636159999999 | 770-683-2033 | |||
F000466-langhorne | Brian Fitzpatrick F000466 | 1717 Langhorne-Newtown Rd. | Suite 400 | Langhorne | PA | 19047 | 40.2162341 | -74.9308492 | 215-579-8102 | 215-579-8109 | ||
F000468-houston | Lizzie Fletcher F000468 | 5599 San Felipe St | Suite 950 | Houston | TX | 77056-2724 | 29.74946 | -95.47373 | ||||
F000469-coeur_d_alene | Russ Fulcher F000469 | 1250 W Ironwood Dr | Suite 241 | Coeur D Alene | ID | 83814-2679 | 47.69725 | -116.80272 | 208-667-0127 | 208-667-0310 | ||
F000469-lewiston | Russ Fulcher F000469 | 313 D St | Suite 107 | Lewiston | ID | 83501-1894 | 46.42199 | -117.02845 | 208-743-1388 | |||
F000469-meridian | Russ Fulcher F000469 | 33 E Broadway Ave | Suite 251 | Meridian | ID | 83642-2619 | 43.61003 | -116.3929 | 208-888-3188 | 208-888-0894 | ||
G000359-columbia | Lindsey Graham G000359 | 508 Hampton St. | Suite 202 | Columbia | SC | 29201 | 34.0016459 | -81.0461408 | 803-933-0112 | 803-933-0957 | ||
G000359-florence | Lindsey Graham G000359 | 401 W. Evans St. | Suite 111 | Florence | SC | 29501 | 34.1974074 | -79.7733804 | 843-669-1505 | 843-669-9015 | McMillan Federal Building | |
G000359-greenville | Lindsey Graham G000359 | 130 S. Main St. | 7th Floor | Greenville | SC | 29601 | 34.84875359999999 | -82.4004437 | 864-250-1417 | 864-250-4322 | ||
G000359-mt__pleasant | Lindsey Graham G000359 | 530 Johnnie Dodds Blvd. | Suite 202 | Mt. Pleasant | SC | 29464 | 32.8060149 | -79.88793369999999 | 843-849-3887 | 843-971-3669 | ||
G000359-pendleton | Lindsey Graham G000359 | 124 Exchange St. | Suite A | Pendleton | SC | 29670 | 34.65072 | -82.782997 | 864-646-4090 | 864-646-8609 | ||
G000359-rock_hill | Lindsey Graham G000359 | 235 E. Main St. | Suite 100 | Rock Hill | SC | 29730 | 34.9245162 | -81.0247705 | 803-366-2828 | 803-366-5353 | ||
G000386-cedar_rapids | Charles Grassley G000386 | 111 7th Ave. SE | Suite 6800 | Cedar Rapids | IA | 52401 | 41.9731139 | -91.6645212 | 319-363-6832 | 319-363-7179 | ||
G000386-council_bluffs | Charles Grassley G000386 | 8 S. 6th St. | 307 | Council Bluffs | IA | 51501 | 41.2608863 | -95.8525576 | 712-322-7103 | 712-322-7196 | Federal Building | |
G000386-davenport | Charles Grassley G000386 | 201 W. 2nd St. | Suite 720 | Davenport | IA | 52801 | 41.5213296 | -90.5758645 | 563-322-4331 | 563-322-8552 | ||
G000386-des_moines | Charles Grassley G000386 | 210 Walnut St. | 721 | Des Moines | IA | 50309 | 41.5864152 | -93.62015319999999 | 515-288-1145 | 515-288-5097 | Federal Building | |
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 | |
G000386-waterloo | Charles Grassley G000386 | 531 Commercial St. | 210 | Waterloo | IA | 50701 | 42.4953784 | -92.339384 | 319-232-6657 | 319-232-9965 | Waterloo Building | |
G000546-kansas_city | Sam Graves G000546 | 11724 NW Plaza Circle | Suite 900 | Kansas City | MO | 64153 | 39.3060799 | -94.68496599999999 | 816-792-3976 | 816-792-0694 | ||
G000546-st__joseph | Sam Graves G000546 | 411 Jules St. | Room 111 | St. Joseph | MO | 64501 | 39.7685973 | -94.8548563 | 816-749-0800 | 816-749-0801 | ||
G000551-avondale | Raúl Grijalva G000551 | 1412 N. Central Ave. | Suite B | Avondale | AZ | 85323 | 33.4487419 | -112.3501093 | 623-536-3388 | 623-535-7479 | ||
G000551-somerton | Raúl Grijalva G000551 | 146 N. State Ave. | Somerton | AZ | 85350 | 32.5960917 | -114.7109846 | 928-343-7933 | 928-343-7949 | |||
G000551-tucson | Raúl Grijalva G000551 | 101 W. Irvington Road | Buildings 4 and 5 | Tucson | AZ | 85714 | 32.163554 | -110.969568 | 520-622-6788 | 520-622-0198 | El Pueblo Community Center | |
G000552-longview | Louie Gohmert G000552 | 101 E. Methvin | Suite 302 | Longview | TX | 75601 | 32.4970151 | -94.73894650000001 | 903-236-8597 | 903-561-7110 | ||
G000552-lufkin | Louie Gohmert G000552 | 300 E. Shepherd | Suite 210 | Lufkin | TX | 75901 | 31.3368848 | -94.7268845 | 936-632-3180 | 903-561-7110 | ||
G000552-marshall | Louie Gohmert G000552 | 102 W. Houston St. | Marshall | TX | 75670 | 32.5447093 | -94.36734899999999 | 903-938-8386 | 903-561-7110 | |||
G000552-nacogdoches | Louie Gohmert G000552 | 101 W. Main | Suite 160 | Nacogdoches | TX | 75961 | 31.6036806 | -94.6565524 | 936-715-9514 | 903-561-7110 | ||
G000552-tyler | Louie Gohmert G000552 | 1121 ESE Loop 323 | Suite 206 | Tyler | TX | 75701 | 32.3031236 | -95.28684349999999 | 903-561-6349 | 903-561-7110 | ||
G000555-albany | Kirsten Gillibrand G000555 | 11A Clinton Avenue | Room 821 | Albany | NY | 12207 | 42.655222 | -73.7492819 | 518-431-0120 | 518-431-0128 | Leo W. O’Brien Federal Office Building | |
G000555-buffalo | Kirsten Gillibrand G000555 | 726 Exchange St. | Suite 511 | Buffalo | NY | 14210 | 42.8747911 | -78.851165 | 716-854-9725 | 716-854-9731 | Larkin At Exchange | |
G000555-lowville | Kirsten Gillibrand G000555 | PO Box 273 | Lowville | NY | 13367 | 43.7880969 | -75.4938177 | 315-376-6118 | 315-376-6118 | |||
G000555-melville | Kirsten Gillibrand G000555 | 155 Pinelawn Rd. | Suite 250 North | Melville | NY | 11747 | 40.7707877 | -73.41024759999999 | 631-249-2825 | 631-249-2847 | ||
G000555-new_york | Kirsten Gillibrand G000555 | 780 Third Ave. | Suite 2601 | New York | NY | 10017 | 40.7550353 | -73.97185879999999 | 212-688-6262 | 866-824-6340 | ||
G000555-rochester | Kirsten Gillibrand G000555 | 100 State St. | Room 4195 | Rochester | NY | 14614 | 43.1576631 | -77.613515 | 585-263-6250 | 585-263-6247 | Kenneth B. Keating Federal Office Building | |
G000555-syracuse | Kirsten Gillibrand G000555 | 100 S. Clinton St. | Room 1470 | Syracuse | NY | 13261 | 43.0501042 | -76.1543204 | 315-448-0470 | 315-448-0476 | James M. Hanley Federal Building | |
G000555-yonkers | Kirsten Gillibrand G000555 | PO Box 749 | Yonkers | NY | 10710-0749 | 40.9188505 | -73.8596689 | 845-875-4585 | 845-875-9099 | |||
G000558-bowling_green | Brett Guthrie G000558 | 996 Wilkinson Trce. | Suite B2 | Bowling Green | KY | 42103 | 36.9671412 | -86.4282633 | 270-842-9896 | 270-842-9081 | ||
G000558-owensboro | Brett Guthrie G000558 | 2200 Airport Rd. | Owensboro | KY | 42301 | 37.7493662 | -87.1617598 | |||||
G000558-radcliff | Brett Guthrie G000558 | 411 W. Lincoln Trail Blvd. | Radcliff | KY | 40160 | 37.8379989 | -85.9440374 | |||||
G000565-gold_canyon | Paul Gosar G000565 | 6499 S. Kings Ranch Rd. | #4 | Gold Canyon | AZ | 85118 | 33.3557193 | -111.4526421 | 480-882-2697 | |||
G000565-kingman | Paul Gosar G000565 | 220 N. 4th St. | Kingman | AZ | 86401 | 35.1904088 | -114.0525545 | |||||
G000565-prescott | Paul Gosar G000565 | 122 N. Cortez St. | Suite 104 | Prescott | AZ | 86301 | 34.5427185 | -112.4690897 | 928-445-1683 | |||
G000568-abingdon | H. Griffith G000568 | 323 W. Main St. | Abingdon | VA | 24210 | 36.7086253 | -81.98113049999999 | 276-525-1405 | 276-525-1444 | |||
G000568-christiansburg | H. Griffith G000568 | 17 W. Main St. | Christiansburg | VA | 24073 | 37.1296267 | -80.4095978 | 540-381-5671 | 540-381-5675 | |||
G000574-phoenix | Ruben Gallego G000574 | 411 N. Central Ave. | Suite 150 | Phoenix | AZ | 85004 | 33.452957 | -112.0734511 | 602-256-0551 | 602-257-9103 | ||
G000576-fond_du_lac | Glenn Grothman G000576 | 24 W. Pioneer Rd. | Fond du Lac | WI | 54935 | 43.7522376 | -88.4509945 | 920-907-0624 | ||||
G000577-baton_rouge | Garret Graves G000577 | 2351 Energy Dr. | Suite 1200 | Baton Rouge | LA | 70808 | 30.4265187 | -91.1316524 | 225-442-1731 | 225-442-1736 | ||
G000577-livingston | Garret Graves G000577 | 29261 Frost Rd. | 2nd Floor | Livingston | LA | 70754 | 30.48302409999999 | -90.7486419 | 225-686-4413 | 225-442-1736 | Livingston Parish Government Building | |
G000577-thibodaux | Garret Graves G000577 | 908 E. 1st St. | Suite 405 | Thibodaux | LA | 70301 | 29.795623 | -90.8011997 | 985-448-4103 | 225-442-1736 | NSU Campus, Candies Hall |
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);