offices
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,163 rows sorted by hours descending
This data as json, copyable, CSV (advanced)
id | legislator_id | address | suite | city | state | zip | latitude | longitude | phone | fax | building | hours ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
D000626-springfield | Warren Davidson D000626 | 76 E. High St. | 3rd Floor | Springfield | OH | 45502 | 39.9237363 | -83.80971939999999 | 937-322-1120 | part-time, please call ahead | ||
L000582-manhattan_beach | Ted Lieu L000582 | 1600 Rosecrans Ave. | 4th Floor | Manhattan Beach | CA | 90266 | 33.9015419 | -118.383875 | 310-321-7664 | by appointment only | ||
B001300-carson | Nanette Barragán B001300 | 701 E. Carson St. | Carson | CA | 90745 | 33.8322643 | -118.2630272 | 310-831-1799 | Carson City Hall | Wednesday and Thursday, 9:00 a.m. - 5:00 p.m. Please call for an appointment | ||
S001200-haines_city | Darren Soto S001200 | 620 E Main St. | Haines City | FL | 33844 | 28.1083914 | -81.628392 | 202-615-1308 | Wednesday 9AM-5PM | |||
G000581-benavides | Vicente Gonzalez G000581 | 131 W. Main St. | Benavides | TX | 78341 | 27.5968913 | -98.4176561 | 888-217-0261 | Wednesday 9-12 and 1-5 CT | |||
P000096-lyndhurst | Bill Pascrell P000096 | 367 Valley Brook Ave. | Lyndhurst | NJ | 07071 | 40.8126716 | -74.1243659 | 201-935-2248 | Wed, Fri 9am-5pm | |||
G000583-hackensack | Josh Gottheimer G000583 | 65 Central Ave | Hackensack | NJ | 07601 | 40.8857964 | -74.046227 | 973-814-4076 | W 12-4PM | |||
H001056-chehalis | Jaime Herrera Beutler H001056 | 350 N. Market Blvd. | Chehalis | WA | 98532 | 46.6639928 | -122.9672327 | Chehalis City Hall Building | Tuesdays from 11:30am - 1:00pm | |||
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 | |
B001295-mt__vernon | Mike Bost B001295 | 1100 Main St. | Mt. Vernon | IL | 62864 | 38.317936 | -88.9049835 | 618-513-5294 | Mt. Vernon City Hall | Tuesdays 9 a.m. to 12 p.m. | ||
M001137-arverne | Gregory Meeks M001137 | 67-12 Rockaway Beach Blvd. | Arverne | NY | 11692 | 40.5907811 | -73.798273 | 347-230-4032 | 347-230-4045 | Tuesdays 10am-2pm, Wednesday-Friday- 9am-5pm | ||
C001090-wilkes_barre | Matthew Cartwright C001090 | 20 N. Pennsylvania Ave. | Suite 201 | Wilkes-Barre | PA | 18711 | 41.2441677 | -75.87917089999999 | 570-371-0317 | Tuesday and Thursday, 9:00am - 5:00pm | ||
B001300-south_gate | Nanette Barragán B001300 | 8650 California Ave. | South Gate | CA | 90280 | 33.9556898 | -118.2051037 | 310-831-1799 | South Gate City Hall | Tuesday and Thursday, 9:00 a.m. - 5:00 p.m. Please call for an appointment | ||
B001304-annapolis | Anthony Brown B001304 | 2666 Riva Rd | Suite 120 | Annapolis | MD | 21401 | 38.9746861 | -76.5612782 | 410-266-3249 | Tuesday and Thursday, 9 a.m. - 1 p.m., or by appointment | ||
M001157-brenham | Michael McCaul M001157 | 2000 S. Market St. | Suite 303 | Brenham | TX | 77833 | 30.1510408 | -96.3912448 | 979-830-8497 | 979-830-1984 | Tuesday and Thursday 8-5pm | |
W000806-brooksville | Daniel Webster W000806 | 15 N. Main Street | Suite B | Brooksville | FL | 34601 | 28.5552249 | -82.38811919999999 | 352-241-9230 | 352-241-9181 | Tuesday and Thursday | |
M000087-brooklyn | Carolyn Maloney M000087 | 619 Lorimer St. | Brooklyn | NY | 11211-2228 | 40.7155784 | -73.94987139999999 | 718-349-5972 | 718-349-5973 | Tuesday 9:00am – 5:00pm | ||
B001300-compton | Nanette Barragán B001300 | 205 S. Willowbrook Ave. | Compton | CA | 90220 | 33.8946744 | -118.226945 | 310-831-1799 | Compton City Hall | Tuesday 9:00 a.m. - 5:00 p.m. Please call for an appointment | ||
G000581-falfurrias | Vicente Gonzalez G000581 | 217 E. Miller St. | Suite 200 | Falfurrias | TX | 78355 | 27.2260914 | -98.1424972 | 361-209-3027 | Tuesday 9 a.m.- 12 p.m. & 1 p.m.-5 p.m. CT | ||
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 | ||||
K000381-port_angeles | Derek Kilmer K000381 | 332 E. 5th St. | Port Angeles | WA | 98362 | 48.113181 | -123.431753 | 360-797-3623 | Tues: 9:00am-Noon (PST) Wed: 12:00pm-4:00pm (PST) Thurs: 9:00am-Noon (PST) | |||
Z000017-riverhead | Lee Zeldin Z000017 | 30 W. Main St. | Suite 201 | Riverhead | NY | 11901 | 40.9172285 | -72.6627645 | 631-209-4235 | Tues, Wed, Thurs, 10am - 2pm. By appointment only. | ||
P000096-englewood | Bill Pascrell P000096 | 2-10 N. Van Brunt St. | Englewood | NJ | 07631 | 40.8946254 | -73.97540300000001 | 201-935-2248 | Tues, Thurs 9am-5pm | |||
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 |
H001067-pinehurst | Richard Hudson H001067 | 3395 Airport Rd | Suite 114 | Pinehurst | NC | 28374 | 35.219259 | -79.405317 | 910-246-5374 | Sandhills Community College Van Dusen Building | Tues and Thurs 8:30am-5:30pm and by appointment | |
J000289-bucyrus | Jim Jordan J000289 | 500 S. Sandusky Ave. | Bucyrus | OH | 44820 | 40.8042672 | -82.9752194 | 419-663-1426 | Tu/Th - 8am to 4:30pm | |||
W000808-west_park | Frederica Wilson W000808 | 1965 South State Road 7 | West Park | FL | 33023 | 25.993095 | -80.2038997 | 954-989-2688 | West Park City Hall | Thursday 9-5pm | ||
B001295-granite_city | Mike Bost B001295 | 2000 Edison Ave. | Granite City | IL | 62040 | 38.7015611 | -90.14887449999999 | 618-622-0766 | City Hall | The third Thursday of each month from 1:00 p.m. to 4:00 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 | ||
G000583-washington | Josh Gottheimer G000583 | 100 Belvidere Ave | Washington | NJ | 07882 | 40.7599515 | -74.9823375 | 973-814-4076 | TH 9AM-1PM | |||
G000583-ringwood | Josh Gottheimer G000583 | 60 Margaret King Ave. | Ringwood | NJ | 07456 | 41.129452 | -74.2672991 | 973-814-4076 | TH 1PM-4:30PM | |||
G000583-vernon_township | Josh Gottheimer G000583 | 21 Church St. | Vernon Township | NJ | 07462 | 41.2025042 | -74.4855857 | 973-814-4076 | T 9AM-1PM | |||
P000607-beloit | Mark Pocan P000607 | 100 State St. | 3rd floor | Beloit | WI | 53511 | 42.49752240000001 | -89.03699309999999 | 608-365-8001 | Second Thursday of the Month, 9:30 - 11:30 AM | ||
E000295-council_bluffs | Joni Ernst E000295 | 8 S 6th St | Suite 221 | Council Bluffs | IA | 51501 | 41.2608863 | -95.8525576 | 712-352-1167 | 712-352-0087 | Federal Building | Please call to schedule an appointment |
K000386-lyons | John Katko K000386 | 7376 State Route 31 | Lyons | NY | 14489 | 43.072187 | -77.03685779999999 | 315-253-4068 | Please call to make an appointment | |||
K000386-oswego | John Katko K000386 | 13 W. Oneida St. | 2nd Floor | Oswego | NY | 13126 | 43.4554199 | -76.511258 | 315-423-5657 | Please call to make an appointment | ||
K000385-kankakee | Robin Kelly K000385 | 304 S. Indiana Ave. | lower level | Kankakee | IL | 60901 | 41.117146 | -87.861261 | 708-679-0078 | Kankakee City Hall | Open on the second and fourth Wednesdays of each month, from 9am - 4pm | |
L000585-bloomington | Darin LaHood L000585 | 3004 G.E. Rd. | Suite 1B | Bloomington | IL | 61704 | 40.5029607 | -88.9230848 | 309-205-9556 | Open Tuesdays and Thursdays | ||
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. | ||
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 | |||
C001080-claremont | Judy Chu C001080 | 415 W. Foothill Blvd. | Suite 122 | Claremont | CA | 91711 | 34.1079585 | -117.7212331 | 909-625-5394 | 909-399-0198 | Only open Tuesdays and Thursdays | |
W000806-inverness | Daniel Webster W000806 | 212 W. Main St. | Suite 208A | Inverness | FL | 34450 | 28.8363417 | -82.3321296 | 352-241-9204 | 352-241-9181 | Mondays 9:00AM - 5:00PM | |
M001199-riviera_beach | Brian Mast M001199 | 7305 N Military Trl | 1A-366 | Riviera Beach | FL | 33410-7417 | 26.78415 | -80.10731 | 561-530-7778 | Mondays 10 a.m. - 2 p.m. | ||
M001156-black_mountain | Patrick McHenry M001156 | 160 Midland Ave. | Black Mountain | NC | 28711 | 35.619814 | -82.3197859 | 828-669-0600 | Mondays & Wednesdays, 12 PM to 5 PM | |||
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 | |
C001113-reno | Catherine Cortez Masto C001113 | 400 South Virginia Street | Suite 902 | Reno | NV | 89501 | 39.5215352 | -119.810287 | 775-686-5750 | 775-686-5757 | Courthouse and Federal Building | Monday-Friday; 8:00am-5:00pm PT |
C001113-las_vegas | Catherine Cortez Masto C001113 | 333 Las Vegas Boulevard South | Suite 8016 | Las Vegas | NV | 89101 | 36.1651058 | -115.1424211 | 702-388-5020 | 702-388-5030 | Monday-Friday; 8:00am – 5:00pm PT | |
C001091-san_antonio | Joaquin Castro C001091 | 727 E. Chavez Blvd. | Suite B-128 | San Antonio | TX | 78206 | 29.4175269 | -98.4846276 | 210-348-8216 | 210-979-0737 | Monday-Friday, 9:00 am- 6:00 pm CT | |
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 | ||
V000131-dallas | Marc Veasey V000131 | 1881 Sylvan Ave. | Suite 108 | Dallas | TX | 75208 | 32.7687234 | -96.8364642 | 214-741-1387 | 214-741-2026 | JP Morgan Chase Building | Monday-Friday, 8:30am-5:30pm |
D000619-maryville | Rodney Davis D000619 | 15 Professional Park Dr. | Maryville | IL | 62062 | 38.737077 | -89.95489859999999 | 618-205-8660 | 618-205-8662 | Monday-Friday, 8:30am-5:00pm | ||
M001190-claremore | Markwayne Mullin M001190 | 223 W Patti Page Blvd | Claremore | OK | 74017-8046 | 36.30985 | -95.61233 | 918-283-6262 | 918-923-6451 | Monday-Friday, 8:00am-5:00pm CT | ||
M001190-mcalester | Markwayne Mullin M001190 | 1 E. Choctaw | Suite 175 | McAlester | OK | 74501 | 34.9325288 | -95.76939100000001 | 918-423-5951 | 918-423-1940 | Monday-Friday, 8:00am-5:00pm CT | |
M001190-muskogee | Markwayne Mullin M001190 | 811 N York St Ste A | Muskogee | OK | 74403-3860 | 35.75024 | -95.34046 | 918-687-2533 | 918-686-0128 | Monday-Friday, 8:00am-5:00pm CT | ||
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 | |
D000615-clinton | Jeff Duncan D000615 | 100 Plaza Circle | Suite A1 | Clinton | SC | 29325 | 34.4772923 | -81.9380738 | 864-681-1028 | 864-681-1030 | Monday-Friday 9:00AM-5:00PM Closed on Federal Holidays | |
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 | |
C000537-kingstree | James Clyburn C000537 | 130 W. Main St. | Kingstree | SC | 29556 | 33.6637604 | -79.8313355 | 843-355-1211 | 843-355-1232 | Monday-Friday 9:00AM-5:00PM | ||
F000459-athens | Charles Fleischmann F000459 | 6 E. Madison Ave. | Athens | TN | 37303 | 35.441192 | -84.594681 | 423-745-4671 | 423-745-6025 | Monday-Friday 9:00AM-5:00PM | ||
F000459-chattanooga | Charles Fleischmann F000459 | 900 Georgia Ave. | Suite 126 | Chattanooga | TN | 37402 | 35.0450875 | -85.3082146 | 423-756-2342 | 423-756-6613 | Monday-Friday 9:00AM-5:00PM | |
F000459-oak_ridge | Charles Fleischmann F000459 | 200 Administration Rd. | Suite 100 | Oak Ridge | TN | 37830 | 36.02409 | -84.23490799999999 | 865-576-1976 | 865-576-3221 | Monday-Friday 9:00AM-5:00PM | |
K000376-butler | Mike Kelly K000376 | 101 E. Diamond St. | Suite 218 | Butler | PA | 16001 | 40.8580044 | -79.8948869 | 724-282-2557 | 724-282-3682 | Monday-Friday 9:00AM-5:00PM | |
K000376-erie | Mike Kelly K000376 | 208 E. Bayfront Pkwy. | Suite 102 | Erie | PA | 16507 | 42.1373875 | -80.0848493 | 814-454-8190 | 814-454-8197 | Monday-Friday 9:00AM-5:00PM | |
M001184-ashland | Thomas Massie M001184 | 1700 Greenup Ave. | Suite 505 | Ashland | KY | 41101 | 38.4791287 | -82.6379039 | 606-324-9898 | Monday-Friday 9:00AM-5:00PM | ||
M001184-crescent_springs | Thomas Massie M001184 | 541 Buttermilk Pike | Suite 208 | Crescent Springs | KY | 41017 | 39.0486598 | -84.5777416 | 859-426-0080 | 859-426-0061 | Monday-Friday 9:00AM-5:00PM | |
R000575-anniston | Mike Rogers R000575 | 1129 Noble St. | # 104 | Anniston | AL | 36201 | 33.6595488 | -85.8294458 | 256-236-5655 | 256-237-9203 | Monday-Friday 9:00AM-5:00PM | |
C001097-panorama_city | Tony Cárdenas C001097 | 9612 Van Nuys Blvd. | Suite 201 | Panorama City | CA | 91402 | 34.2449325 | -118.4495976 | 818-221-3718 | 818-221-3809 | Monday-Friday 9:00 a.m. - 6:00 p.m. PACIFIC TIME | |
C001068-memphis | Steve Cohen C001068 | 167 N. Main St. | Suite 369 | Memphis | TN | 38103 | 35.1497482 | -90.0517538 | 901-544-4131 | 901-544-4329 | The Clifford Davis/Odell Horton Federal Building | Monday-Friday 8am-5pm CT |
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 | |
R000575-opelika | Mike Rogers R000575 | 701 Avenue A | Suite 300 | Opelika | AL | 36801 | 32.6481909 | -85.3772489 | 334-745-6221 | 334-742-0109 | G.W. Andrews Federal Building | Monday-Friday 8:00AM-5:00PM |
L000560-bellingham | Rick Larsen L000560 | 119 N. Commercial St. | Suite 275 | Bellingham | WA | 98225 | 48.7523829 | -122.4785173 | 360-733-4500 | 360-733-5144 | Monday-Friday 8 a.m. to 5 p.m. | |
L000560-everett | Rick Larsen L000560 | 2930 Wetmore Ave. | Suite 9F | Everett | WA | 98201 | 47.9781562 | -122.2076204 | 425-252-3188 | 425-252-6606 | Wall Street Building | Monday-Friday 8 a.m. to 5 p.m |
W000798-jackson | Tim Walberg W000798 | 401 W. Michigan Ave. | Jackson | MI | 49201 | 42.247186 | -84.414954 | 517-780-9075 | 517-780-9081 | Monday, Tuesday, Thursday, Friday 9:00AM-5:00PM Wednesday 9:00AM-6:00PM | ||
R000515-chicago | Bobby Rush R000515 | 11750 S. Western Ave. | Chicago | IL | 60643-4732 | 41.6793889 | -87.6811963 | 773-779-2400 | 773-779-2401 | Monday – Friday, 9 a.m. – 6 p.m., Central | ||
M000087-new_york | Carolyn Maloney M000087 | 1651 3rd Ave. | Suite 311 | New York | NY | 10128-3679 | 40.7828262 | -73.95068410000002 | 212-860-0606 | 212-860-0704 | Monday – Friday 9:00am – 6:00pm | |
G000563-canton | Bob Gibbs G000563 | 110 Central Plaza South | Canton | OH | 44702 | 40.797956 | -81.37428899999999 | 330-737-1631 | Monday to Friday By Appointment Only | |||
G000563-ashland | Bob Gibbs G000563 | 110 Cottage St. | Ashland | OH | 44805 | 40.86905120000001 | -82.31826099999999 | 419-207-0650 | 419-207-0655 | Monday to Friday 9AM to 5PM | ||
K000376-sharon | Mike Kelly K000376 | 33 Chestnut Ave. | Sharon | PA | 16146 | 41.2315486 | -80.5079773 | 724-342-7170 | 724-342-7242 | Monday through Friday, 9 a.m. to 5 p.m. | ||
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 | ||
M000087-astoria | Carolyn Maloney M000087 | 31-19 Newtown Ave. | Astoria | NY | 11102-1391 | 40.7672194 | -73.9223996 | 718-932-1804 | 718-932-1805 | Monday 9:30am – 2:00pm; Tuesday – Thursday 9:30am – 5:00pm; Friday 10:00am – 4:00pm | ||
G000581-san_diego | Vicente Gonzalez G000581 | 404 S. Mier St. | San Diego | TX | 78384 | 27.7605991 | -98.2413715 | 888-217-0261 | Monday 9-12 & 1-5 CT | |||
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 | ||||
C000141-bowie | Benjamin Cardin C000141 | 10201 Martin Luther King Jr. Highway | Suite 210 | Bowie | MD | 20720 | 38.9550571 | -76.82809809999999 | 301-860-0414 | 301-860-0416 | Monday - Friday: 9:00 AM - 5:00 PM | |
F000450-clemmons | Virginia Foxx F000450 | 3540 Clemmons Rd. | Suite 125 | Clemmons | NC | 27012 | 36.0225285 | -80.3758084 | 336-778-0211 | 336-778-2290 | Monday - Friday, 9am - 5pm | |
P000616-bloomington | Dean Phillips P000616 | 1800 W Old Shakopee Rd | Second Floor | Bloomington | MN | 55431-3071 | 44.82514 | -93.30211 | 952-563-4593 | Bloomington Civic Plaza | Monday - Friday, 9:00 a.m. - 5:00 p.m. | |
D000619-champaign | Rodney Davis D000619 | 2004 Fox Dr. | Champaign | IL | 61280 | 40.090932 | -88.25012439999999 | 217-403-4690 | 217-403-4691 | Monday - Friday, 8:30am - 5:00pm | ||
D000619-taylorville | Rodney Davis D000619 | 108 W. Market St. | Taylorville | IL | 62568 | 39.5480891 | -89.29549949999999 | 217-824-5117 | 217-824-5121 | Monday - Friday, 8:30am - 5:00pm | ||
P000607-madison | Mark Pocan P000607 | 10 E. Doty St. | Suite 405 | Madison | WI | 53703 | 43.0737508 | -89.3816999 | 608-258-9800 | 608-258-0377 | Monday - Friday, 8:00 AM - 5:00 PM | |
Q000023-chicago-1 | Mike Quigley Q000023 | 3223 N. Sheffield Ave. | Chicago | IL | 60657 | 41.94076279999999 | -87.6538984 | 773-267-5926 | Monday - Friday 9am - 5pm | |||
Q000023-chicago | Mike Quigley Q000023 | 4345 N. Milwaukee Ave. | Chicago | IL | 60641 | 41.9600352 | -87.7536327 | 773-267-5926 | 773-267-6583 | Portage Park Office | Monday - Friday 9am - 5:30pm | |
C001063-laredo | Henry Cuellar C001063 | 602 E. Calton Rd. | Suite 2 | Laredo | TX | 78041 | 27.5423782 | -99.4887937 | 956-725-0639 | 956-725-2647 | Monday - Friday 8:00 a.m. CST to 5:30 p.m. CST | |
W000806-the_villages | Daniel Webster W000806 | 8015 E County Rd 466 | Suite B | The Villages | FL | 32162 | 28.9188822 | -81.970805 | 352-383-3552 | 352-241-9181 | Monday & Wednesday, Friday by appointment only | |
N000188-cherry_hill | Donald Norcross N000188 | 10 Melrose Ave. | Suite 210 | Cherry Hill | NJ | 08003 | 39.8719711 | -75.0138274 | 856-427-7000 | 856-427-4109 | Mon. - Fri., 9:00 am - 5:00 pm | |
P000604-hillside | Donald Payne P000604 | 1455 Liberty Ave. | Hillside | NJ | 07205 | 40.70234809999999 | -74.228127 | 862-229-2994 | 862-225-2941 | Mon-Fri 9am-6pm | ||
C000537-columbia | James Clyburn C000537 | 1225 Lady St. | Suite 200 | Columbia | SC | 29201 | 34.0032484 | -81.03302830000001 | 803-799-1100 | 803-799-9060 | Mon-Fri 9am-5pm | |
D000600-naples | Mario Diaz-Balart D000600 | 4715 Golden Gate Pkwy. | Suite 1 | Naples | FL | 34116 | 26.1833954 | -81.70380209999999 | 239-348-1620 | 239-348-3569 | Mon-Fri 9am-5pm | |
F000450-boone | Virginia Foxx F000450 | 400 Shadowline Dr. | Suite 205 | Boone | NC | 28607 | 36.2033658 | -81.65849589999999 | 828-265-0240 | 828-265-0390 | Mon-Fri 9am-5pm | |
H000874-greenbelt | Steny Hoyer H000874 | 6500 Cherrywood Ln. | Suite 310 | Greenbelt | MD | 20770 | 39.0089504 | -76.8952351 | 301-474-0119 | 301-474-4697 | U.S. District Courthouse | Mon-Fri 9am-5pm |
H000874-white_plains | Steny Hoyer H000874 | 4475 Regency Pl. | Suite 203 | White Plains | MD | 20695 | 38.5923982 | -76.9415779 | 301-843-1577 | 301-843-1331 | Mon-Fri 9am-5pm | |
W000812-ballwin | Ann Wagner W000812 | 301 Sovereign Ct. | Suite 201 | Ballwin | MO | 63011 | 38.5980031 | -90.4902674 | 636-779-5449 | 636-779-5449 | Mon-Fri 9am-5pm |
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);