legislators: offices: 1,312 rows

1,312 rows

id	legislator_id	address	suite	city	state	zip	latitude	longitude	fax	phone	building	hours
A000055-cullman	Robert Aderholt A000055	205 4th Ave. NE	Suite 104	Cullman	AL	35055	34.181059	-86.840631	202-225-5587	256-734-6043	null	null
A000055-jasper	Robert Aderholt A000055	1710 Alabama Ave.	247	Jasper	AL	35501	33.83438	-87.274935	null	205-221-2310	Carl Elliott Building	null
A000055-tuscumbia	Robert Aderholt A000055	1011 George Wallace Blvd.	Suite 146	Tuscumbia	AL	35674	34.7412348	-87.6794142	202-225-5587	256-381-3450	null	null
A000148-attleboro	Jake Auchincloss A000148	8 N. Main St.	Suite 200	Attleboro	MA	02703	41.9446048	-71.284441	null	508-431-1110	null	null
A000148-fall_river	Jake Auchincloss A000148	1 Government Center	Office 237B	Fall River	MA	02722	41.7008714	-71.15463729999999	null	null	null	Wednesday 10AM to 4PM
A000148-newton	Jake Auchincloss A000148	29 Crafts St.	Suite 375	Newton	MA	02458	42.354825	-71.1998658	null	617-332-3333	null	null
A000369-elko	Mark Amodei A000369	Elko, NV 89801	null	Elko	NV	89801	40.8324211	-115.7631232	null	775-777-7705	null	null
A000369-reno	Mark Amodei A000369	5310 Kietzke Ln.	Suite 103	Reno	NV	89511	39.4715058	-119.791273	775-686-5711	775-686-5760	null	null
A000370-charlotte	Alma Adams A000370	10815 David Taylor Dr.	Suite 100	Charlotte	NC	28262	35.3369067	-80.7670844	704-344-9971	704-344-9950	null	null
A000371-san_bernardino	Pete Aguilar A000371	685 E. Carnegie Dr.	Suite 100	San Bernardino	CA	92408	34.068627	-117.270925	909-890-9643	909-890-4445	null	null
A000372-augusta	Rick Allen A000372	2743 Perimeter Parkway	Suite 105	Augusta	GA	30909	33.4874834	-82.08416969999999	706-228-1954	706-228-1980	Building 200	null
A000372-dublin	Rick Allen A000372	100 S. Church St.	null	Dublin	GA	31021	32.5383565	-82.9084154	706-228-1954	478-291-6324	null	null
A000372-statesboro	Rick Allen A000372	50 E. Main St.	null	Statesboro	GA	30458	32.4484951	-81.781533	912-243-9453	912-243-9452	null	null
A000372-vidalia	Rick Allen A000372	107 Old Airport Rd.	Suite A	Vidalia	GA	30475	32.2046881	-82.37632649999999	null	912-243-9452	null	null
A000375-abilene	Jodey Arrington A000375	500 Chestnut St.	Suite 819	Abilene	TX	79602	32.4443053	-99.73461449999999	325-675-5038	325-675-9779	null	null
A000375-lubbock	Jodey Arrington A000375	1312 Texas Ave.	Suite 219	Lubbock	TX	79401	33.5830588	-101.8456125	806-767-9168	806-763-1611	null	null
A000379-columbia	Mark Alford A000379	2401 Bernadette Drive	Suite 117	Columbia	MO	65203	38.9666004	-92.37545380000002	null	573-540-6600	null	null
A000379-lebanon	Mark Alford A000379	500 E. Elm Street	null	Lebanon	MO	65536	37.6789025	-92.65382939999999	null	417-532-5582	null	null
A000379-raymore	Mark Alford A000379	1272 West Foxwood Dr.	null	Raymore	MO	64083	38.8135008	-94.477059	null	816-441-6318	null	null
A000380-pawtucket	Gabe Amo A000380	1070 Main Street	Suite 300	Pawtucket	RI	02860	41.8612017	-71.3988584	401-729-5608	401-729-5600	null	null
A000381-phoenix	Yassamin Ansari A000381	3770 N 7th St	100b	Phoenix	AZ	85014	33.491056939891365	-112.06524607862144	null	602-956-2285	null	null
A000382-bowie	Angela Alsobrooks A000382	10201 Martin Luther King Jr Hwy	Suite 210	Bowie	MD	20720	38.955065	-76.828113	null	301-860-0414	null	null
B000490-albany	Sanford Bishop B000490	323 Pine Ave	400	Albany	GA	31701-2596	31.57858	-84.1542	229-436-2099	229-439-8067	null	M-F 9-5:30pm
B000490-columbus	Sanford Bishop B000490	18 Ninth St.	Suite 201	Columbus	GA	31901	32.4625755	-84.9922596	706-320-9479	706-320-9477	null	Mon-Fri 9-5:30pm
B000490-macon	Sanford Bishop B000490	300 Mulberry Street	Suite 502	Macon	GA	31201	32.8356646	-83.6267623	478-803-2637	478-803-2631	null	Mon-Fri 9am-5:30pm
B000668-medford	Cliff Bentz B000668	14 N. Central Avenue	Suite 112	Medford	OR	97501	42.3269709	-122.8722219	541-779-0204	541-776-4646	null	null
B000668-ontario	Cliff Bentz B000668	2430 SW 4th Avenue	Suite 2	Ontario	OR	97914	44.0244314	-116.9984095	null	541-709-2040	null	null
B000740-oklahoma_city	Stephanie Bice B000740	101 N Robinson	Suite 1105	Oklahoma City	OK	73102	35.4679697	-97.5195523	855-235-5024	405-300-6890	null	By appointment only
B000825-castle_rock	Lauren Boebert B000825	900 Castleton Rd.	Suite 112	Castle Rock	CO	80109	39.4092707	-104.8709821	null	720-639-9165	null	null
B000825-eaton	Lauren Boebert B000825	271 South Elm Ave.	Suite 1A	Eaton	CO	80615	40.520859	-104.7133806	null	970-702-2136	null	null
B001230-eau_claire	Tammy Baldwin B001230	500 South Barstow St.	Suite LL2	Eau Claire	WI	54701	44.8088044	-91.5330934	null	715-832-8424	null	null
B001230-green_bay	Tammy Baldwin B001230	2325 Verlin Road	Suite 201	Green Bay	WI	54311	44.4704255	-87.9670328	null	920-498-2668	null	null
B001230-la_crosse	Tammy Baldwin B001230	210 7th Street South	Suite 203	La Crosse	WI	54601	43.8093946	-91.2472178	null	608-796-0045	null	null
B001230-ladysmith	Tammy Baldwin B001230	P.O. Box 401	null	Ladysmith	WI	54848	45.4630231	-91.10403579999999	null	715-832-8424	null	null
B001230-madison	Tammy Baldwin B001230	30 W. Mifflin St.	Suite 700	Madison	WI	53703	43.07506559999999	-89.38647139999999	null	608-264-5338	null	null
B001230-milwaukee	Tammy Baldwin B001230	633 West Wisconsin Ave	Suite 1300	Milwaukee	WI	53203	43.0386745	-87.91998439999999	null	414-297-4451	null	null
B001236-el_dorado	John Boozman B001236	106 W. Main St.	Suite 104	El Dorado	AR	71730	33.2120448	-92.664046	870-863-4105	870-863-4641	null	null
B001236-fort_smith	John Boozman B001236	1120 Garrison Ave.	Suite 2B	Fort Smith	AR	72901	35.383512	-94.42033099999999	479-573-0553	479-573-0189	null	null
B001236-jonesboro	John Boozman B001236	300 S. Church St.	Suite 400	Jonesboro	AR	72401	35.8404281	-90.70368549999999	870-268-6887	870-268-6925	null	null
B001236-little_rock	John Boozman B001236	1401 W. Capitol Ave.	Suite 155	Little Rock	AR	72201	34.7456872	-92.2865752	501-372-7163	501-372-7153	null	null
B001236-lowell	John Boozman B001236	213 W. Monroe	Suite N	Lowell	AR	72745	36.2535183	-94.1393049	479-725-0408	479-725-0400	null	null
B001236-mountain_home	John Boozman B001236	1001 Hwy 62 East	Suite 11	Mountain Home	AR	72653	36.3499306	-92.3729619	870-424-0141	870-424-0129	null	null
B001236-stuttgart	John Boozman B001236	620 E. 22nd St.	Suite 204	Stuttgart	AR	72160	34.478784	-91.54664090000001	870-672-6962	870-672-6941	null	null
B001243-chattanooga	Marsha Blackburn B001243	10 West M. L. King Blvd	6th Floor	Chattanooga	TN	37402	35.0455268	-85.3100155	423-541-2944	423-541-2939	null	null
B001243-jackson	Marsha Blackburn B001243	109 S Highland Ave	Suite 218	Jackson	TN	38301	35.6138097	-88.8199198	731-660-3978	731-660-3971	null	null
B001243-johnson_city	Marsha Blackburn B001243	207 Mocking Bird Ln	Suite 502	Johnson City	TN	37604	36.3355276	-82.37505809999999	423-788-0250	423-753-4009	null	null
B001243-knoxville	Marsha Blackburn B001243	800 Market St	Suite 121	Knoxville	TN	37902-2327	35.96225	-83.91771	865-540-7952	865-540-3781	null	null
B001243-memphis	Marsha Blackburn B001243	100 Peabody Pl	Suite 1125	Memphis	TN	38103-3654	35.14132	-90.05396	901-527-9515	901-527-9199	null	null
B001243-nashville	Marsha Blackburn B001243	719 Church Street	Suite 2100	Nashville	TN	37203	36.1615561	-86.78303760000001	615-298-2148	629-800-6600	null	null
B001257-brooksville	Gus Bilirakis B001257	15 N Main Street	Suite B	Brooksville	FL	34601	28.5552196	-82.3881335	null	352-691-1231	null	null
B001257-inverness	Gus Bilirakis B001257	212 W Main Street	Suite 208A	Inverness	FL	34450	28.836354	-82.3320907	null	352-654-1004	null	null
B001257-new_port_richey	Gus Bilirakis B001257	8731 Citizens Drive	Suite 135	New Port Richey	FL	34654	28.268217	-82.6702026	null	727-232-2921	null	null
B001260-bradenton	Vern Buchanan B001260	8433 Enterprise Circle	Suite 210	Bradenton	FL	34202	27.3876393	-82.43503079999999	771-200-5798	941-951-6643	null	null
B001260-brandon	Vern Buchanan B001260	510 Vonderburg Drive	Suite 303	Brandon	FL	33511	27.930656	-82.2892269	771-200-5798	813-657-1013	null	By appointment only
B001260-longboat_key	Vern Buchanan B001260	5370 Gulf of Mexico Drive	Suite 210	Longboat Key	FL	34228	27.4111492	-82.6563195	null	941-951-6643	null	By appointment only
B001261-casper	John Barrasso B001261	100 E. B St.	Suite 2004	Casper	WY	82601	42.8524124	-106.3248373	null	307-261-6413	null	null
B001261-cheyenne	John Barrasso B001261	2120 Capitol Ave.	Suite 2013	Cheyenne	WY	82001	41.1374591	-104.8189674	null	307-772-2451	null	null
B001261-riverton	John Barrasso B001261	324 E. Washington Ave.	null	Riverton	WY	82501	43.0238609	-108.386731	null	307-856-6642	null	null
B001261-rock_springs	John Barrasso B001261	1575 Dewar Drive	Suite 218	Rock Springs	WY	82901	41.5742346	-109.2423116	null	307-362-5012	Commerce Bank	null
B001261-sheridan	John Barrasso B001261	51 Coffeen Avenue	Suite 202	Sheridan	WY	82801	44.7952317	-106.9541476	null	307-672-6456	null	null
B001267-alamosa	Michael Bennet B001267	609 Main Street	Suite 206	Alamosa	CO	81101	37.4685007	-105.8659427	null	719-587-0096	null	null
B001267-colorado_springs	Michael Bennet B001267	409 N. Tejon St.	Suite 107	Colorado Springs	CO	80903	38.8400247	-104.8228748	719-328-1129	719-328-1100	null	null
B001267-denver	Michael Bennet B001267	1244 Speer Blvd.	null	Denver	CO	80204	39.7364704	-104.994978	202-224-1866	303-455-7600	Cesar E. Chavez Memorial Building	null
B001267-durango	Michael Bennet B001267	1309 East 3rd Avenue	Suite 101	Durango	CO	81301	37.2775875	-107.8770163	970-259-9789	970-259-1710	Smiley Building	null
B001267-fort_collins	Michael Bennet B001267	1200 S. College Ave.	Suite 211	Fort Collins	CO	80524	40.5716714	-105.0766516	970-224-2205	970-224-2200	null	null
B001267-grand_junction	Michael Bennet B001267	225 N. 5th St.	Suite 511	Grand Junction	CO	81501	39.0688046	-108.5648398	null	970-241-6631	null	null
B001267-pueblo	Michael Bennet B001267	129 W. B St.	null	Pueblo	CO	81003	38.2795281	-104.508253	null	719-542-7550	null	null
B001277-bridgeport	Richard Blumenthal B001277	915 Lafayette Blvd.	Suite 304	Bridgeport	CT	06604	41.1749972	-73.1931954	203-330-0608	203-330-0598	null	null
B001277-hartford	Richard Blumenthal B001277	90 State House Sq.	10th Floor	Hartford	CT	06103	41.7665316	-72.6719747	860-258-6958	860-258-6940	null	null
B001278-beaverton	Suzanne Bonamici B001278	12725 SW Millikan Way	Suite 220	Beaverton	OR	97005	45.4900502	-122.8078224	503-469-6018	503-469-6010	null	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-5640	614-220-0003	null	Monday-Friday 9:00am-5:00pm
B001282-lexington	Garland Barr B001282	2709 Old Rosebud Rd.	Ste. 100	Lexington	KY	40509	38.02835049999999	-84.4193689	null	859-219-1366	null	null
B001285-oxnard	Julia Brownley B001285	201 East Fourth St.	Suite 209B	Oxnard	CA	93030	34.1993342	-119.1783991	805-379-1799	805-379-1779	null	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-1799	805-379-1779	null	Monday-Friday 8:00am-5:00pm PT
B001287-sacramento	Ami Bera B001287	8950 Cal Center Dr.	Suite 100	Sacramento	CA	95826	38.5553768	-121.3738588	916-635-0514	916-635-0505	Building 3	M-F 9am -6pm
B001288-camden	Cory Booker B001288	401 Market St.	Suite 240	Camden	NJ	08102	39.9461715	-75.1219416	202-224-5701	856-338-8922	null	null
B001288-newark	Cory Booker B001288	One Gateway Center	23rd Floor	Newark	NJ	07102	40.7344571	-74.1657213	202-224-5702	973-639-8700	null	null
B001291-dayton	Brian Babin B001291	2004 N. Cleveland St.	null	Dayton	TX	77536	30.0569844	-94.899317	null	832-780-0966	Dayton Police Station	By appointment only
B001291-deer_park	Brian Babin B001291	203 Ivy Ave.	Suite 600	Deer Park	TX	77536	29.7089323	-95.12126239999999	832-780-0964	832-780-0966	null	null
B001291-lumberton	Brian Babin B001291	769 S. Main Street	null	Lumberton	TX	77657	30.241581	-94.1945327	409-886-9918	409-883-8075	null	null
B001291-woodville	Brian Babin B001291	100 W. Bluff Dr.	null	Woodville	TX	75979	30.7753424	-94.41539859999999	null	409-331-8066	Tyler County Courthouse	null
B001292-alexandria	Donald Beyer B001292	700 N Fairfax St.	Suite 510	Alexandria	VA	22314	38.8117105	-77.044029	703-658-5408	703-658-5403	null	null
B001295-effingham	Mike Bost B001295	101 N 4th St	Suite 302	Effingham	IL	62401	39.12162989999999	-88.54225699999999	618-448-4233	217-240-3170	null	null
B001295-mascoutah	Mike Bost B001295	205 East Harnett Street	null	Mascoutah	IL	62258	38.496664	-89.7948239	618-448-4233	618-622-0766	null	null
B001295-murphysboro	Mike Bost B001295	1109 Chestnut Street	null	Murphysboro	IL	62966	37.7635011	-89.33563699999999	618-448-4233	618-457-5787	null	null
B001296-philadelphia	Brendan Boyle B001296	5675 N. Front St.	Suite 180	Philadelphia	PA	19120	40.0381812	-75.1172342	267-437-3886	267-335-5643	One & Olney Shopping Center	8:30am-4:30pm, M-F
B001296-philadelphia-1	Brendan Boyle B001296	8572 Bustleton Ave.	null	Philadelphia	PA	19152	40.0730543	-75.049904	215-856-3734	215-335-3355	null	8:30am-4:30pm, M-F
B001296-philadelphia-2	Brendan Boyle B001296	1318 West Girard Avenue	null	Philadelphia	PA	19123	39.9710093	-75.1578869	267-639-9944	215-982-1156	null	8:30am-4:30pm, M-F
B001298-omaha	Don Bacon B001298	13906 Gold Circle	Suite 101	Omaha	NE	68144	41.23509809999999	-96.1296555	402-763-4947	402-938-0300	null	null
B001298-wahoo	Don Bacon B001298	543 Linden Street	null	Wahoo	NE	68066	41.210636	-96.6189117	null	402-607-0077	null	null
B001299-fort_wayne	Jim Banks B001299	1300 S. Harrison St.	null	Fort Wayne	IN	46802	41.0737372	-85.14045349999999	null	260-321-7130	E Ross Adair Federal Building	null
B001299-hammond	Jim Banks B001299	5400 Federal Plaza	Suite 3200	Hammond	IN	46320	41.6153916	-87.523337	null	null	Hammond Federal Building Courthouse	null
B001300-carson	Nanette Barragán B001300	701 E. Carson St.	null	Carson	CA	90745	33.8322643	-118.2630272	null	310-831-1799	Carson City Hall	Wednesday and Thursday, 9:00 a.m. - 5:00 p.m. Please call for an appointment
B001300-long_beach	Nanette Barragán B001300	4201 Long Beach Blvd	Suite 422	Long Beach	CA	90807	33.83467220000001	-118.189654	null	310-831-1799	null	null
B001300-san_pedro	Nanette Barragán B001300	638 S. Beacon St	null	San Pedro	CA	90731	33.7380779	-118.2802296	null	310-831-1799	null	null
B001300-south_gate	Nanette Barragán B001300	8650 California Ave.	null	South Gate	CA	90280	33.9556898	-118.2051037	null	310-831-1799	South Gate City Hall	Tuesday and Thursday, 9:00 a.m. - 5:00 p.m. Please call for an appointment
B001301-gwinn	Jack Bergman B001301	125 G Avenue	B	Gwinn	MI	49841	46.28105559999999	-87.4409718	null	906-273-2227	null	null
B001301-traverse_city	Jack Bergman B001301	1396 Douglas Drive	Suite 22B	Traverse City	MI	49696	44.7066718	-85.5961732	null	231-944-7633	null	null
B001302-mesa	Andy Biggs B001302	2509 S. Power Rd.	Suite 204	Mesa	AZ	85209	33.3712904	-111.6870648	null	480-699-8239	null	null
B001303-dover	Lisa Blunt Rochester B001303	555 East Loockerman St.	Suite 300	Dover	DE	19901	39.1616365	-75.5144994	null	302-674-3308	null	null

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,
   [fax] TEXT,
   [phone] TEXT,
   [building] TEXT
, [hours] TEXT);