-
Notifications
You must be signed in to change notification settings - Fork 4
/
members.sql
2480 lines (2480 loc) · 428 KB
/
members.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
BEGIN TRANSACTION;
CREATE TABLE office (
handle varchar(60),
bioguide_id varchar(7),
type varchar(8),
name varchar(50),
line1 varchar(255),
line2 varchar(255),
city varchar(100),
state_code varchar(2),
zip varchar(10),
phone varchar(14),
latitude real,
longitude real
);
INSERT INTO "office" VALUES('A000055-gadsden','A000055','DISTRICT','Gadsden','600 Broad St','107 Federal Building','Gadsden','AL','35901','(256) 546-0201',34.01421,-86.006846);
INSERT INTO "office" VALUES('A000055-cullman','A000055','DISTRICT','Cullman','205 4th Ave NE',NULL,'Cullman','AL','35055','(256) 734-6043',34.180779,-86.840634);
INSERT INTO "office" VALUES('A000055-jasper','A000055','DISTRICT','Jasper','98 18th St E','247 Carl Elliott Bldg','Jasper','AL','35501','(205) 221-2310',33.833501,-87.274683);
INSERT INTO "office" VALUES('A000055-shoals','A000055','DISTRICT','Shoals','1011 George Wallace Blvd.','Suite 146','Tuscumbia','AL','35674','(256) 381-3450',34.7412348,-87.6794142);
INSERT INTO "office" VALUES('A000055-washington','A000055','DC','Washington','235 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4876',38.8868,-77.0085);
INSERT INTO "office" VALUES('A000360-knoxville','A000360','DISTRICT','Knoxville','Howard H. Baker, Jr. U.S. Courthouse','800 Market Street, #112','Knoxville','TN','37902','(865) 545-4253',35.96172,-83.917758);
INSERT INTO "office" VALUES('A000360-jackson','A000360','DISTRICT','Jackson','Federal Building','109 South Highland Street, #B-9','Jackson','TN','38301','(731) 664-0289',35.6138131,-88.8199475);
INSERT INTO "office" VALUES('A000360-chattanooga','A000360','DISTRICT','Chattanooga','Joel E. Soloman Federal Building','900 Georgia Avenue, #260','Chattanooga','TN','37402','(423) 752-5337',35.0450875,-85.3082146);
INSERT INTO "office" VALUES('A000360-tricities','A000360','DISTRICT','Tri-Cities','Bldg. 101, 2525 Highway 75','P. O. Box 1113','Blountville','TN','37617','(423) 325-6240',36.473223,-82.4092344);
INSERT INTO "office" VALUES('A000360-nashville','A000360','DISTRICT','Nashville','3322 West End Avenue, #120',NULL,'Nashville','TN','37203','(615) 736-5129',36.1400262,-86.8199101);
INSERT INTO "office" VALUES('A000360-memphis','A000360','DISTRICT','Memphis','Clifford Davis-Odell Horton Federal Building','167 North Main Street, #1068','Memphis','TN','38103','(901) 544-4224',35.1497482,-90.0517538);
INSERT INTO "office" VALUES('A000360-washington','A000360','DC','Washington','455 Dirksen Senate Office Building',NULL,'Washington','DC','20510','(202) 224-4944',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('A000367-battle-creek','A000367','DISTRICT','Battle Creek','70 W Michigan Ave, Suite 212',NULL,'Battle Creek','MI','49017','(269) 205-3823',42.3213842,-85.1838246);
INSERT INTO "office" VALUES('A000367-grand-rapids','A000367','DISTRICT','Grand Rapids','110 Michigan St NW, Suite 460',NULL,'Grand Rapids','MI','49503','(616) 451-8383',42.9699746,-85.6709742);
INSERT INTO "office" VALUES('A000367-washington','A000367','DC','Washington','114 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-3831',38.8868,-77.0085);
INSERT INTO "office" VALUES('A000369-elko','A000369','DISTRICT','Elko','905 Railroad Street, Suite 104 D',NULL,'Elko','NV','89801','(775) 777-7705',40.8355439,-115.7586349);
INSERT INTO "office" VALUES('A000369-washington','A000369','DC','Washington','332 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-6155',38.8868,-77.0085);
INSERT INTO "office" VALUES('A000369-reno','A000369','DISTRICT','Reno','5310 Kietzke Lane, Suite 103',NULL,'Reno','NV','89511','(775) 686-5760',39.4715058,-119.791273);
INSERT INTO "office" VALUES('A000370-charlotte','A000370','DISTRICT','Charlotte','801 E Morehead Street','Suite 150','Charlotte','NC','28202','(704) 344-9950',35.215055,-80.8452162);
INSERT INTO "office" VALUES('A000370-washington','A000370','DC','Washington','222 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-1510',38.8868,-77.0085);
INSERT INTO "office" VALUES('A000371-san-bernardino','A000371','DISTRICT','San Bernardino','685 E. Carnegie Drive','Suite 100','San Bernardino','CA','92408','(909) 890-4445',34.068627,-117.270925);
INSERT INTO "office" VALUES('A000371-washington','A000371','DC','Washington','1223 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3201',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('A000372-dublin','A000372','DISTRICT','Dublin','100 S. Church St.',NULL,'Dublin','GA','31021','(478) 272-4030',32.5383565,-82.9084154);
INSERT INTO "office" VALUES('A000372-statesboro','A000372','DISTRICT','Statesboro','50 E. Main Street',NULL,'Statesboro','GA','30458','(912) 243-9452',32.4484951,-81.781533);
INSERT INTO "office" VALUES('A000372-vidalia','A000372','DISTRICT','Vidalia','107 Old Airport Road, Suite A',NULL,'Vidalia','GA','30475','(912) 403-3311',32.2046881,-8.23763264999999904585e+01);
INSERT INTO "office" VALUES('A000372-washington','A000372','DC','Washington','426 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2823',38.8868,-77.0085);
INSERT INTO "office" VALUES('A000372-augusta','A000372','DISTRICT','Augusta','2743 Perimeter Parkway','Bldg. 200, Suite 225','Augusta','GA','30909','(706) 228-1980',33.4875735,-82.0846666);
INSERT INTO "office" VALUES('A000374-northeast-louisiana','A000374','DISTRICT','Northeast Louisiana','426 DeSiard St.',NULL,'Monroe','LA','71201','(318) 322-3500',32.5036093,-92.1144236);
INSERT INTO "office" VALUES('A000374-washington','A000374','DC','Washington','417 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-8490',38.8868,-77.0085);
INSERT INTO "office" VALUES('A000374-central-louisiana','A000374','DISTRICT','Central Louisiana','2003 MacArthur Dr., Bldg. 5',NULL,'Alexandria','LA','71301','(318) 445-0818',31.27656,-92.46964);
INSERT INTO "office" VALUES('A000375-abilene','A000375','DISTRICT','Abilene','500 Chestnut St','#819','Abilene','TX','79602','(325) 675-9779',32.4443053,-99.7346145);
INSERT INTO "office" VALUES('A000375-lubbock','A000375','DISTRICT','Lubbock','1312 Texas Ave.','Suite 219','Lubbock','TX','79401','(806) 763-1611',33.5885782,-101.8702325);
INSERT INTO "office" VALUES('A000375-washington','A000375','DC','Washington','1029 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4005',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B000213-ennis','B000213','DISTRICT','Ennis','2106 A W. Ennis Ave.',NULL,'Ennis','TX','75119','(972) 875-8488',32.3198509,-96.6470243);
INSERT INTO "office" VALUES('B000213-arlington','B000213','DISTRICT','Arlington','6001 W. Ronald Reagan Memorial Hwy, #200',NULL,'Arlington','TX','76017','(817) 543-1000',32.6740058,-97.2021179);
INSERT INTO "office" VALUES('B000213-washington','B000213','DC','Washington','2107 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2002',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('B000287-los-angeles','B000287','DISTRICT','Los Angeles','350 South Bixel Street, Suite 120',NULL,'Los Angeles','CA','90017','(213) 481-1425',34.0569399,-118.2597013);
INSERT INTO "office" VALUES('B000287-washington','B000287','DC','Washington','1226 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-6235',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B000490-macon','B000490','DISTRICT','Macon','682 Cherry Street','City Hall Annex, Suite 302','Macon','GA','31201','(478) 803-2631',32.837156,-83.630497);
INSERT INTO "office" VALUES('B000490-albany','B000490','DISTRICT','Albany','235 West Roosevelt Avenue','Albany Towers, Suite 114','Albany','GA','31701','(229) 439-8067',31.5819859,-84.1530072);
INSERT INTO "office" VALUES('B000490-columbus','B000490','DISTRICT','Columbus','18 Ninth Street, Suite 201',NULL,'Columbus','GA','31901','(706) 320-9477',32.4625755,-84.9922596);
INSERT INTO "office" VALUES('B000490-washington','B000490','DC','Washington','2407 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3631',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('B000574-washington','B000574','DC','Washington','1111 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4811',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B000574-portland','B000574','DISTRICT','Portland','911 N.E. 11th Ave','Suite 200','Portland','OR','97232','(503) 231-2300',45.5293348,-122.6555902);
INSERT INTO "office" VALUES('B000575-kansas-city','B000575','DISTRICT','Kansas City','1000 Walnut Street, Suite # 1560',NULL,'Kansas City','MO','64106','(816) 471-7141',39.1021449,-94.5825038);
INSERT INTO "office" VALUES('B000575-columbia','B000575','DISTRICT','Columbia','1001 Cherry Street, Suite 104',NULL,'Columbia','MO','65201','(573) 442-8151',38.9507077,-92.3262317);
INSERT INTO "office" VALUES('B000575-cape-girardeau','B000575','DISTRICT','Cape Girardeau','2502 Tanner Drive Suite 208',NULL,'Cape Girardeau','MO','63703','(573) 334-7044',37.3029285,-89.5558479);
INSERT INTO "office" VALUES('B000575-washington','B000575','DC','Washington','260 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5721',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('B000575-springfield','B000575','DISTRICT','Springfield','2740 B East Sunshine',NULL,'Springfield','MO','65804','(417) 877-7814',37.180415,-93.240439);
INSERT INTO "office" VALUES('B000575-st-louisclayton','B000575','DISTRICT','St. Louis/Clayton','7700 Bonhomme, #315',NULL,'Clayton','MO','63105','(314) 725-4484',38.647051,-90.3351311);
INSERT INTO "office" VALUES('B000755-conroe','B000755','DISTRICT','Conroe','200 River Point, Ste 304',NULL,'Conroe','TX','77304','(936) 441-5700',30.2844625,-95.4613914);
INSERT INTO "office" VALUES('B000755-huntsville','B000755','DISTRICT','Huntsville','1300 11th Street, Suite 400',NULL,'Huntsville','TX','77340','(936) 439-9532',30.7240052,-95.5535049);
INSERT INTO "office" VALUES('B000755-washington','B000755','DC','Washington','1011 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4901',38.8868,-77.0085);
INSERT INTO "office" VALUES('B000944-cleveland','B000944','DISTRICT','Cleveland','801 West Superior Ave.,','Suite 1400','Cleveland','OH','44113','(216) 522-7272',41.4964399,-81.6975439);
INSERT INTO "office" VALUES('B000944-cincinnati','B000944','DISTRICT','Cincinnati','425 Walnut St.,','Suite 2310','Cincinnati','OH','45202','(513) 684-1021',39.1007745,-84.5120256);
INSERT INTO "office" VALUES('B000944-columbus','B000944','DISTRICT','Columbus','200 North High St.','Room 614','Columbus','OH','43215','(614) 469-2083',39.9666883,-83.000974);
INSERT INTO "office" VALUES('B000944-washington','B000944','DC','Washington','713 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2315',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('B000944-lorain','B000944','DISTRICT','Lorain','200 West Erie Ave.','Suite 312','Lorain','OH','44052','(440) 242-4100',41.4685695,-82.1792684);
INSERT INTO "office" VALUES('B001135-asheville','B001135','DISTRICT','Asheville','Federal Building','151 Patton Avenue, Suite 204','Asheville','NC','28801','(828) 350-2437',35.594066,-82.55792);
INSERT INTO "office" VALUES('B001135-winstonsalem','B001135','DISTRICT','Winston-Salem','2000 West First Street','Suite 508','Winston-Salem','NC','27104','(336) 631-5125',36.0960116,-80.2748025);
INSERT INTO "office" VALUES('B001135-wilmington','B001135','DISTRICT','Wilmington','201 North Front Street','Suite 809','Wilmington','NC','28401','(888) 848-1833',34.2376985,-77.9492582);
INSERT INTO "office" VALUES('B001135-rocky-mount','B001135','DISTRICT','Rocky Mount','100 Coast Line Street','Room 210','Rocky Mount','NC','27804','(252) 977-9522',35.9379802,-77.7977748);
INSERT INTO "office" VALUES('B001135-washington','B001135','DC','Washington','217 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3154',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('B001227-delaware-county','B001227','DISTRICT','Delaware County','1350 Edgmont Avenue, Suite 2575',NULL,'Chester','PA','19013','(610) 874-7094',39.857906,-75.3620646);
INSERT INTO "office" VALUES('B001227-e-clearfield-street','B001227','DISTRICT','E. Clearfield Street','2637 E. Clearfield Street',NULL,'Philadelphia','PA','19134','(267) 519-2252',39.9835935,-75.1053451);
INSERT INTO "office" VALUES('B001227-memphis-street','B001227','DISTRICT','Memphis Street','2630 Memphis St.',NULL,'Philadelphia','PA','19125','(215) 426-4616',39.9822635,-75.1199045);
INSERT INTO "office" VALUES('B001227-washington','B001227','DC','Washington','2004 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4731',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001227-s-broad-street','B001227','DISTRICT','S. Broad Street','1909 S. Broad Street',NULL,'Philadelphia','PA','19148','(215) 389-4627',39.9264992,-75.1689727);
INSERT INTO "office" VALUES('B001230-eau-claire','B001230','DISTRICT','Eau Claire','402 Graham Street, Suite 206',NULL,'Eau Claire','WI','54701-2633','(715) 832-8424',44.8094935,-91.4995641);
INSERT INTO "office" VALUES('B001230-madison','B001230','DISTRICT','Madison','30 West Mifflin Street, Suite 700',NULL,'Madison','WI','53703','(608) 264-5338',43.0750656,-89.3864714);
INSERT INTO "office" VALUES('B001230-green-bay','B001230','DISTRICT','Green Bay','1039 W. Mason, Suite 119',NULL,'Green Bay','WI','54303','(920) 498-2668',44.5151063,-88.0413549);
INSERT INTO "office" VALUES('B001230-la-crosse','B001230','DISTRICT','La Crosse','205 5th Avenue South, Room 216',NULL,'La Crosse','WI','54601','(608) 796-0045',43.8109182,-91.249764);
INSERT INTO "office" VALUES('B001230-wausau','B001230','DISTRICT','Wausau','2100 Stewart Avenue, Suite 250 B',NULL,'Wausau','WI','54401','(715) 261-2611',44.9591474,-89.6628755);
INSERT INTO "office" VALUES('B001230-washington','B001230','DC','Washington','709 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5653',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('B001230-milwaukee','B001230','DISTRICT','Milwaukee','633 W. Wisconsin Ave, Suite 1920',NULL,'Milwaukee','WI','53203','(414) 297-4451',43.0388214,-87.9200848);
INSERT INTO "office" VALUES('B001236-little-rock','B001236','DISTRICT','Little Rock','1401 W. Capitol Ave., Suite 155',NULL,'Little Rock','AR','72201','(501) 372-7153',34.7456872,-92.2865752);
INSERT INTO "office" VALUES('B001236-fort-smith','B001236','DISTRICT','Fort Smith','1120 Garrison Ave','Suite 2B','Fort Smith','AR','72901','(479) 573-0189',35.383512,-94.420331);
INSERT INTO "office" VALUES('B001236-lowell','B001236','DISTRICT','Lowell','213 West Monroe','Suite N','Lowell','AR','72745','(479) 725-0400',36.2535183,-94.1393049);
INSERT INTO "office" VALUES('B001236-mountain-home','B001236','DISTRICT','Mountain Home','1001 Hwy. 62 East','Suite 11','Mountain Home','AR','72653','(870) 424-0129',36.3499306,-92.3707731);
INSERT INTO "office" VALUES('B001236-stuttgart','B001236','DISTRICT','Stuttgart','620 E. 22nd St.','Suite 204','Stuttgart','AR','72160','(870) 672-6941',34.478784,-91.5466409);
INSERT INTO "office" VALUES('B001236-el-dorado','B001236','DISTRICT','El Dorado','106 West Main St.','Suite 104','El Dorado','AR','71730','(870) 863-4641',33.2120448,-92.664046);
INSERT INTO "office" VALUES('B001236-jonesboro','B001236','DISTRICT','Jonesboro','300 South Church St.','Suite 400','Jonesboro','AR','72401','(870) 268-6925',35.8404281,-90.7036855);
INSERT INTO "office" VALUES('B001236-washington','B001236','DC','Washington','141 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-4843',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('B001243-franklin','B001243','DISTRICT','Franklin','305 Public Square','Suite 212','Franklin','TN','37064','(615) 591-5161',35.9250525,-86.8692419);
INSERT INTO "office" VALUES('B001243-clarksville','B001243','DISTRICT','Clarksville','128 North 2nd Street','Suite 202','Clarksville','TN','37040','(931) 503-0391',36.5285913,-87.3594209);
INSERT INTO "office" VALUES('B001243-washington','B001243','DC','Washington','2266 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2811',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('B001245-guam','B001245','DISTRICT','Guam','120 Father Duenas Avenue','Suite 107','Hagåtña','GU','96910','(671) 477-4272',13.4760084,144.7466326);
INSERT INTO "office" VALUES('B001245-washington','B001245','DC','Washington','2441 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-1188',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('B001248-lake-dallas','B001248','DISTRICT','Lake Dallas','2000 South Stemmons Freeway, Suite 200',NULL,'Lake Dallas','TX','75065','(940) 497-5031',33.1213325,-97.0327015);
INSERT INTO "office" VALUES('B001248-washington','B001248','DC','Washington','2336 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-7772',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('B001250-ogden','B001250','DISTRICT','Ogden','1017 Federal Building','324 25th St','Ogden','UT','84401','(801) 625-0107',41.2206915,-111.9726124);
INSERT INTO "office" VALUES('B001250-washington','B001250','DC','Washington','123 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-0453',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001251-wilson','B001251','DISTRICT','Wilson','216 NE Nash Street, Suite B',NULL,'Wilson','NC','27893','(252) 237-9816',35.728383,-77.9131079);
INSERT INTO "office" VALUES('B001251-washington','B001251','DC','Washington','2080 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3101',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('B001251-durham','B001251','DISTRICT','Durham','411 W. Chapel Hill Street, Suite 905',NULL,'Durham','NC','27701','(919) 908-0164',35.9963746,-78.9082411);
INSERT INTO "office" VALUES('B001257-new-port-richey','B001257','DISTRICT','New Port Richey','7132 Little Road',NULL,'New Port Richey','FL','34654','(727) 232-2921',28.261156,-82.674347);
INSERT INTO "office" VALUES('B001257-washington','B001257','DC','Washington','2112 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5755',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('B001257-tarpon-springs','B001257','DISTRICT','Tarpon Springs','38500 US Highway 19 North','Room BB-038','Tarpon Springs','FL','34689','(727) 940-5860',28.121418,-82.741612);
INSERT INTO "office" VALUES('B001260-bradenton','B001260','DISTRICT','Bradenton','1051 Manatee Ave West, Suite 305',NULL,'Bradenton','FL','34205','(941) 747-9081',27.4945988,-82.5724073);
INSERT INTO "office" VALUES('B001260-sarasota','B001260','DISTRICT','Sarasota','111 South Orange Avenue','Floor 2R, Suite 202W','Sarasota','FL','34236','(941) 951-6643',27.3353999,-82.5382987);
INSERT INTO "office" VALUES('B001260-washington','B001260','DC','Washington','2104 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5015',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('B001261-casper','B001261','DISTRICT','Casper','100 East B Street','Suite 2201','Casper','WY','82601','(307) 261-6413',42.8524124,-106.3248373);
INSERT INTO "office" VALUES('B001261-cheyenne','B001261','DISTRICT','Cheyenne','2120 Capitol Avenue','Suite 2013','Cheyenne','WY','82001','(307) 772-2451',41.1374591,-104.8189674);
INSERT INTO "office" VALUES('B001261-sheridan','B001261','DISTRICT','Sheridan','2 North Main Street','Suite 206','Sheridan','WY','82801','(307) 672-6456',44.7974506,-106.9562525);
INSERT INTO "office" VALUES('B001261-rock-springs','B001261','DISTRICT','Rock Springs','1575 Dewar Drive','Suite 218','Rock Springs','WY','82901','(307) 362-5012',41.5742346,-109.2423116);
INSERT INTO "office" VALUES('B001261-riverton','B001261','DISTRICT','Riverton','324 East Washington Ave',NULL,'Riverton','WY','82501','(307) 856-6642',43.0238609,-108.386731);
INSERT INTO "office" VALUES('B001261-washington','B001261','DC','Washington','307 Dirksen Senate Office Building',NULL,'Washington','DC','20510','(202) 224-6441',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('B001267-grand-junction','B001267','DISTRICT','Grand Junction','225 North 5th Street, Suite 511',NULL,'Grand Junction','CO','81501','(970) 241-6631',39.0688046,-108.5648398);
INSERT INTO "office" VALUES('B001267-denver','B001267','DISTRICT','Denver','1127 Sherman St., Suite 150',NULL,'Denver','CO','80203','(303) 455-7600',39.734465,-104.9852342);
INSERT INTO "office" VALUES('B001267-southwest-colorado','B001267','DISTRICT','Southwest Colorado','835 East 2nd Avenue, Suite 206',NULL,'Durango','CO','81301','(970) 259-1710',37.2725939,-107.8799634);
INSERT INTO "office" VALUES('B001267-washington','B001267','DC','Washington','261 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5852',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('B001267-san-luis-valley','B001267','DISTRICT','San Luis Valley','609 Main Street, Suite 110',NULL,'Alamosa','CO','81101','(719) 587-0096',37.4685012,-105.8659434);
INSERT INTO "office" VALUES('B001267-northern-colorado--eastern-plains','B001267','DISTRICT','Northern Colorado - Eastern Plains','1200 South College Ave., Suite 211',NULL,'Fort Collins','CO','80524','(970) 224-2200',40.5716714,-105.0766516);
INSERT INTO "office" VALUES('B001269-carlisle','B001269','DISTRICT','Carlisle','126 N. Hanover St.',NULL,'Carlisle','PA','17013','(717) 249-0190',40.2036592,-77.1889699);
INSERT INTO "office" VALUES('B001269-harrisburg','B001269','DISTRICT','Harrisburg','4813 Jonestown Road','Suite 101','Harrisburg','PA','17109','(717) 525-7002',40.3042318,-76.8076698);
INSERT INTO "office" VALUES('B001269-sunbury','B001269','DISTRICT','Sunbury','106 Arch Street',NULL,'Sunbury','PA','17801','(570) 988-7801',40.8643639,-76.795568);
INSERT INTO "office" VALUES('B001269-washington','B001269','DC','Washington','2049 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6511',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001269-hazleton','B001269','DISTRICT','Hazleton','1 South Church Street','Suite 100','Hazleton','PA','18201','(570) 751-0050',40.9545235,-75.9769174);
INSERT INTO "office" VALUES('B001270-washington','B001270','DC','Washington','2241 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-7084',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001270-los-angeles-ca-','B001270','DISTRICT','Los Angeles CA ','4929 Wilshire Blvd','Suite 650','Los Angeles','CA','90010','(323) 965-1422',34.0626436,-118.3381029);
INSERT INTO "office" VALUES('B001273-cookeville','B001273','DISTRICT','Cookeville','321 East Spring Street, Suite 301',NULL,'Cookeville','TN','38501','(931) 854-0069',36.1618073,-85.4996529);
INSERT INTO "office" VALUES('B001273-washington','B001273','DC','Washington','1131 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4231',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001273-gallatin-','B001273','DISTRICT','Gallatin ','355 North Belvedere Drive, Suite 308',NULL,'Gallatin ','TN','37066','(615) 206-8204',36.3784589,-86.4789823);
INSERT INTO "office" VALUES('B001274-decatur','B001274','DISTRICT','Decatur','302 Lee Street','Room 86','Decatur','AL','35601','(256) 355-9400',34.6069984,-86.9849204);
INSERT INTO "office" VALUES('B001274-huntsville','B001274','DISTRICT','Huntsville','2101 W. Clinton Avenue','Suite 302','Huntsville','AL','35805','(256) 551-0190',34.7252133,-86.5977423);
INSERT INTO "office" VALUES('B001274-florence','B001274','DISTRICT','Florence','102 South Court Street','Suite 310','Florence','AL','35630','(256) 718-5155',34.8002305,-87.6771285);
INSERT INTO "office" VALUES('B001274-washington','B001274','DC','Washington','2400 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4801',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001275-evansville','B001275','DISTRICT','Evansville','420 Main Street','Suite 1402','Evansville','IN','47708','(812) 465-6484',37.9722214,-87.5705016);
INSERT INTO "office" VALUES('B001275-terre-haute','B001275','DISTRICT','Terre Haute','901 Wabash Ave.','Suite 140','Terre Haute','IN','47807','(812) 232-0523',39.466224,-87.4042291);
INSERT INTO "office" VALUES('B001275-washington','B001275','DC','Washington','1005 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4636',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001277-hartford','B001277','DISTRICT','Hartford','90 State House Square 10th Floor',NULL,'Hartford','CT','06103','(860) 258-6940',41.766133,-72.6719443);
INSERT INTO "office" VALUES('B001277-bridgeport','B001277','DISTRICT','Bridgeport','915 Lafayette Blvd., Rm 230',NULL,'Bridgeport','CT','06604','(203) 330-0598',41.1749972,-73.1931954);
INSERT INTO "office" VALUES('B001277-washington','B001277','DC','Washington','706 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2823',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('B001278-beaverton','B001278','DISTRICT','Beaverton','12725 SW Millikan Way, Suite 220',NULL,'Beaverton','OR','97005','(503) 469-6010',45.4900502,-122.8078224);
INSERT INTO "office" VALUES('B001278-washington','B001278','DC','Washington','439 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-0855',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001281-washington','B001281','DC','Washington','133 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4324',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001281-columbus','B001281','DISTRICT','Columbus','471 East Broad Street, Suite 1100',NULL,'Columbus','OH','43215','(614) 220-0003',39.9633834,-82.9878075);
INSERT INTO "office" VALUES('B001282-washington','B001282','DC','Washington','1427 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4706',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001282-lexington','B001282','DISTRICT','Lexington','2709 Old Rosebud Road',NULL,'Lexington','KY','40509','(859) 219-1366',38.0283634,-84.4193762);
INSERT INTO "office" VALUES('B001283-tulsa','B001283','DISTRICT','Tulsa','2448 E. 81st St.,','Suite 5150','Tulsa','OK','74137','(918) 935-3222',36.0445807,-95.9535553);
INSERT INTO "office" VALUES('B001283-washington','B001283','DC','Washington','216 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2211',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001284-carmel','B001284','DISTRICT','Carmel','11611 N. Meridian Street','Suite 415','Carmel','IN','46032','(317) 848-0201',39.9569089,-86.1563927);
INSERT INTO "office" VALUES('B001284-anderson','B001284','DISTRICT','Anderson','120 East 8th Street','Suite 101','Anderson','IN','46016','(765) 640-5115',40.1083423,-85.6776394);
INSERT INTO "office" VALUES('B001284-washington','B001284','DC','Washington','1030 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2276',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001285-thousand-oaks','B001285','DISTRICT','Thousand Oaks','223 E. Thousand Oaks Blvd., Suite 411',NULL,'Thousand Oaks','CA','91360','(805) 379-1779',34.1794905,-118.8726791);
INSERT INTO "office" VALUES('B001285-oxnard','B001285','DISTRICT','Oxnard','300 E. Esplanade Drive, Suite 470',NULL,'Oxnard','CA','93036','(805) 379-1779',34.2283405,-119.1745197);
INSERT INTO "office" VALUES('B001285-washington','B001285','DC','Washington','1019 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5811',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001286-peoria','B001286','DISTRICT','Peoria','3100 N. Knoxville Ave.','Suite 205','Peoria','IL','61603','(309) 966-1813',40.7252144,-89.5930768);
INSERT INTO "office" VALUES('B001286-rock-island','B001286','DISTRICT','Rock Island','2401 4th Ave',NULL,'Rock Island','IL','61201','(309) 786-3406',41.5089919,-90.5662359);
INSERT INTO "office" VALUES('B001286-washington','B001286','DC','Washington','1009 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5905',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001286-rockford','B001286','DISTRICT','Rockford','119 N. Church St.','Suite 207 & 208','Rockford','IL','61101','(815) 968-8011',42.2720192,-89.0952944);
INSERT INTO "office" VALUES('B001287-sacramento','B001287','DISTRICT','Sacramento','8950 Cal Center Drive','Building 3, Suite 100','Sacramento','CA','95826','(916) 635-0505',38.5553768,-121.3738588);
INSERT INTO "office" VALUES('B001287-washington','B001287','DC','Washington','1431 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5716',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001288-newark','B001288','DISTRICT','Newark','One Gateway Center','23rd Floor','Newark','NJ','07102','(973) 639-8700',40.7344571,-74.1657213);
INSERT INTO "office" VALUES('B001288-camden','B001288','DISTRICT','Camden','One Port Center','2 Riverside Drive, Suite 505','Camden','NJ','08101','(856) 338-8922',39.9443128,-75.1296174);
INSERT INTO "office" VALUES('B001288-washington','B001288','DC','Washington','359 Dirksen Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3224',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('B001289-mobile','B001289','DISTRICT','Mobile','11 N. Water St.','Ste. 15290','Mobile','AL','36602','(251) 690-2811',30.6932306,-88.0401357);
INSERT INTO "office" VALUES('B001289-baldwin-county','B001289','DISTRICT','Baldwin County','502 West Lee Avenue',NULL,'Summerdale','AL','36580','(251) 989-2664',30.4834677,-87.7041946);
INSERT INTO "office" VALUES('B001289-washington','B001289','DC','Washington','119 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4931',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001290-spotsylvania','B001290','DISTRICT','Spotsylvania','9104 Courthouse Rd.',NULL,'Spotsylvania','VA','22553','(540) 507-7216',38.2021276,-77.5894494);
INSERT INTO "office" VALUES('B001290-washington','B001290','DC','Washington','1628 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2815',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001290-glen-allen','B001290','DISTRICT','Glen Allen','4201 Dominion Blvd, Suite 110',NULL,'Glen Allen','VA','23060','(804) 747-4073',37.6520841,-77.5841752);
INSERT INTO "office" VALUES('B001291-deer-park','B001291','DISTRICT','Deer Park','203 Ivy Avenue, Suite 600',NULL,'Deer Park','TX','77536','(832) 780-0966',29.7089323,-95.1212624);
INSERT INTO "office" VALUES('B001291-orange','B001291','DISTRICT','Orange','420 Green Avenue',NULL,'Orange','TX','77630','(409) 883-8075',30.093311,-93.7330474);
INSERT INTO "office" VALUES('B001291-woodville','B001291','DISTRICT','Woodville','Tyler County Courthouse','100 W. Bluff Drive','Woodville','TX','75979','(844) 303-8934',30.7753424,-94.4153986);
INSERT INTO "office" VALUES('B001291-washington','B001291','DC','Washington','316 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-1555',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001292-alexandria','B001292','DISTRICT','Alexandria','5285 Shawnee Road','Suite 250','Alexandria','VA','22312','(703) 658-5403',38.8086036,-77.165008);
INSERT INTO "office" VALUES('B001292-washington','B001292','DC','Washington','1119 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4376',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001293-brighton','B001293','DISTRICT','Brighton','711 E. Grand River Avenue','Suite A','Brighton','MI','48116','(810) 227-8600',42.5250483,-83.7760175);
INSERT INTO "office" VALUES('B001293-washington','B001293','DC','Washington','428 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4872',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001294-cedar-falls','B001294','DISTRICT','Cedar Falls','515 Main Street, Suite D',NULL,'Cedar Falls','IA','50613','(319) 266-6925',42.5338165,-92.4458948);
INSERT INTO "office" VALUES('B001294-dubuque','B001294','DISTRICT','Dubuque','1050 Main Street',NULL,'Dubuque','IA','52001','(563) 557-7789',42.502919,-90.6681282);
INSERT INTO "office" VALUES('B001294-washington','B001294','DC','Washington','1108 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2911',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001294-cedar-rapids','B001294','DISTRICT','Cedar Rapids','310 3rd Street SE',NULL,'Cedar Rapids','IA','52401','(319) 364-2288',41.9773904,-91.6653664);
INSERT INTO "office" VALUES('B001295-granite-city','B001295','DISTRICT','Granite City','City Hall','2000 Edison Avenue','Granite City','IL','62040','(618) 233-8026',38.7015611,-90.1488745);
INSERT INTO "office" VALUES('B001295-alton','B001295','DISTRICT','Alton','101 East Third Street',NULL,'Alton','IL','62002','(618) 233-8026',38.8906416,-90.1839515);
INSERT INTO "office" VALUES('B001295-belleville','B001295','DISTRICT','Belleville','23 Public Square','Suite 404','Belleville','IL','62220','(618) 233-8026',38.5139815,-89.9834624);
INSERT INTO "office" VALUES('B001295-mt-vernon','B001295','DISTRICT','Mt. Vernon','Mt. Vernon City Hall','1100 Main Street','Mt. Vernon','IL','62864','(618) 513-5294',38.317936,-88.9049835);
INSERT INTO "office" VALUES('B001295-washington','B001295','DC','Washington','1440 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5661',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001295-carbondale','B001295','DISTRICT','Carbondale','300 East Main Street','Hunter Building-Suite 4','Carbondale','IL','62901','(618) 457-5787',37.7277729,-89.2134992);
INSERT INTO "office" VALUES('B001296-olney-philadelphia','B001296','DISTRICT','Olney Philadelphia','One & Olney Shopping Center','5675 N. Front Street, Ste 180','Philadelphia','PA','19120','(267) 335-5643',40.0381812,-75.1172342);
INSERT INTO "office" VALUES('B001296-glenside','B001296','DISTRICT','Glenside','115 E. Glenside Avenue, Ste 1',NULL,'Glenside','PA','19038','(215) 517-6572',40.100299,-75.151156);
INSERT INTO "office" VALUES('B001296-norristown','B001296','DISTRICT','Norristown','101 E. Main St, Ste A',NULL,'Norristown','PA','19401','(610) 270-8081',40.113802,-75.3421376);
INSERT INTO "office" VALUES('B001296-washington','B001296','DC','Washington','1133 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-6111',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001296-northeast-philadelphia','B001296','DISTRICT','Northeast Philadelphia','The Towers','2375 Woodward Street, Ste 105','Philadelphia','PA','19115','(215) 335-3355',40.0723585,-75.0388295);
INSERT INTO "office" VALUES('B001297-greeley','B001297','DISTRICT','Greeley','1023 39th Ave','Unit B','Greeley','CO','80634','(970) 702-2136',40.4205693,-104.7446355);
INSERT INTO "office" VALUES('B001297-washington','B001297','DC','Washington','1130 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4676',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001297-castle-rock','B001297','DISTRICT','Castle Rock','900 Castleton Rd.','Suite 112','Castle Rock','CO','80109','(720) 639-9165',39.4092665,-104.8684125);
INSERT INTO "office" VALUES('B001298-omaha','B001298','DISTRICT','Omaha','13906 Gold Circle','Suite 101','Omaha','NE','68144','(402) 938-0300',41.2350981,-96.1296555);
INSERT INTO "office" VALUES('B001298-washington','B001298','DC','Washington','1516 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4155',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001299-fort-wayne','B001299','DISTRICT','Fort Wayne','1300 S Harrison St',NULL,'Fort Wayne','IN','46802','(260) 702-4750',41.0737372,-85.1404535);
INSERT INTO "office" VALUES('B001299-washington','B001299','DC','Washington','509 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4436',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001300-south-gate','B001300','DISTRICT','South Gate','8650 California Ave',NULL,'South Gate','CA','90280','(310) 831-1799',33.9556898,-118.2051037);
INSERT INTO "office" VALUES('B001300-washington','B001300','DC','Washington','1320 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-8220',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001300-carson','B001300','DISTRICT','Carson','701 E. Carson St',NULL,'Carson','CA','90745','(310) 831-1799',33.8322958,-118.2629115);
INSERT INTO "office" VALUES('B001300-san-pedro','B001300','DISTRICT','San Pedro','302 W. Fifth St','Suite 201','San Pedro','CA','90731','(310) 831-1799',33.7398775,-118.2839378);
INSERT INTO "office" VALUES('B001301-washington','B001301','DC','Washington','414 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4735',38.8868,-77.0085);
INSERT INTO "office" VALUES('B001301-traverse-city','B001301','DISTRICT','Traverse City','1396 Douglas Drive','Suite 22B','Traverse City','MI','49696','(231) 944-7633',44.7066718,-85.5961732);
INSERT INTO "office" VALUES('B001301-marquette','B001301','DISTRICT','Marquette','1500 W. Washington St.','Suite 2','Marquette','MI','49855','(906) 273-2227',4.6547038000000007683e+01,-87.4227729);
INSERT INTO "office" VALUES('B001302-mesa','B001302','DISTRICT','Mesa','2509 S Power Rd','Suite 204','Mesa','AZ','85209','(480) 699-8239',33.3712904,-111.6870648);
INSERT INTO "office" VALUES('B001302-washington','B001302','DC','Washington','1626 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2635',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001303-wilmington','B001303','DISTRICT','Wilmington','1105 N Market St','Suite 400','Wilmington','DE','19801','(302) 830-2330',39.7473432,-75.5471367);
INSERT INTO "office" VALUES('B001303-washington','B001303','DC','Washington','1123 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4165',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001304-upper-marlboro','B001304','DISTRICT','Upper Marlboro','9701 Apollo Dr','Ste 103','Upper Marlboro','MD','20774','(301) 458-2600',38.9044752,-76.8384674);
INSERT INTO "office" VALUES('B001304-washington','B001304','DC','Washington','1505 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-8699',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('B001305-advance','B001305','DISTRICT','Advance','128 Peachtree Lane','Suite A','Advance','NC','27006','(336) 998-1313',36.0038879,-80.4394348);
INSERT INTO "office" VALUES('B001305-washington','B001305','DC','Washington','118 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4531',38.8868,-77.0085);
INSERT INTO "office" VALUES('C000059-corona','C000059','DISTRICT','Corona','400 S. Vicentia Avenue, Suite 125',NULL,'Corona','CA','92882','(951) 277-0042',33.8784386,-117.5759232);
INSERT INTO "office" VALUES('C000059-washington','C000059','DC','Washington','2205 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-1986',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C000127-seattle','C000127','DISTRICT','Seattle','915 Second Avenue, Suite 3206',NULL,'Seattle','WA','98174','(206) 220-6400',47.6046037,-122.3356036);
INSERT INTO "office" VALUES('C000127-tacoma','C000127','DISTRICT','Tacoma','950 Pacific Avenue, Suite 615',NULL,'Tacoma','WA','98402','(253) 572-2281',47.2535757,-122.4390697);
INSERT INTO "office" VALUES('C000127-everett','C000127','DISTRICT','Everett','2930 Wetmore Avenue, Suite 9B',NULL,'Everett','WA','98201','(425) 303-0114',47.9781562,-122.2076204);
INSERT INTO "office" VALUES('C000127-vancouver','C000127','DISTRICT','Vancouver','1313 Officers Row',NULL,'Vancouver','WA','98661','(360) 696-7838',45.628864,-122.6641029);
INSERT INTO "office" VALUES('C000127-richland','C000127','DISTRICT','Richland','825 Jadwin Avenue, Suite 206',NULL,'Richland','WA','99352','(509) 946-8106',46.2775762,-119.2760977);
INSERT INTO "office" VALUES('C000127-washington','C000127','DC','Washington','511 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3441',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('C000127-spokane','C000127','DISTRICT','Spokane','920 W. Riverside Avenue, Suite 697',NULL,'Spokane','WA','99201','(509) 353-2507',47.6585992,-117.4260094);
INSERT INTO "office" VALUES('C000141-rockville','C000141','DISTRICT','Rockville','451 Hungerford Drive','Suite 230','Rockville','MD','20850','(301) 762-2974',39.0895234,-77.1511348);
INSERT INTO "office" VALUES('C000141-baltimore','C000141','DISTRICT','Baltimore','100 S. Charles Street','Tower 1, Suite 1710','Baltimore','MD','21201','(410) 962-4436',39.2871649,-76.6156372);
INSERT INTO "office" VALUES('C000141-cumberland','C000141','DISTRICT','Cumberland','13 Canal Street','Room 305','Cumberland','MD','21502','(301) 777-2957',39.6495579,-78.7636025);
INSERT INTO "office" VALUES('C000141-bowie','C000141','DISTRICT','Bowie','10201 Martin Luther King Jr. Highway','Suite 210','Bowie','MD','20720','(301) 860-0414',38.9550571,-76.8280981);
INSERT INTO "office" VALUES('C000141-washington','C000141','DC','Washington','509 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-4524',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('C000141-southern-maryland','C000141','DISTRICT','Southern Maryland','10201 Martin Luther King Jr. Highway,','Suite 210','Bowie','MD','20720','(202) 870-1164',38.9550571,-76.8280981);
INSERT INTO "office" VALUES('C000141-salisbury','C000141','DISTRICT','Salisbury','Plaza Gallery Building','212 West Main Street, Suite 301C','Salisbury','MD','21801','(410) 546-4250',38.3652837,-75.6023764);
INSERT INTO "office" VALUES('C000174-wilmington','C000174','DISTRICT','Wilmington','301 North Walnut Street, Suite 102L-1',NULL,'Wilmington','DE','19801-3974','(302) 573-6291',39.739183,-75.5492666);
INSERT INTO "office" VALUES('C000174-dover','C000174','DISTRICT','Dover','500 West Loockerman Street, Suite 470',NULL,'Dover','DE','19904','(302) 674-3308',39.1566624,-75.5311574);
INSERT INTO "office" VALUES('C000174-georgetown','C000174','DISTRICT','Georgetown','12 The Circle',NULL,'Georgetown','DE','19947','(302) 856-7690',38.6902745,-75.3852914);
INSERT INTO "office" VALUES('C000174-washington','C000174','DC','Washington','513 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2441',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('C000266-cincinnati','C000266','DISTRICT','Cincinnati','441 Vine Street, Rm. 3003',NULL,'Cincinnati','OH','45202','(513) 684-2723',39.100836,-84.513238);
INSERT INTO "office" VALUES('C000266-warren-county','C000266','DISTRICT','Warren County','11 South Broadway',NULL,'Lebanon','OH','45036','(513) 421-8704',39.4341674,-84.2086104);
INSERT INTO "office" VALUES('C000266-washington','C000266','DC','Washington','2371 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2216',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C000537-kingstree','C000537','DISTRICT','Kingstree','130 W. Main Street',NULL,'Kingstree','SC','29556','(843) 355-1211',33.6637604,-79.8313355);
INSERT INTO "office" VALUES('C000537-santee','C000537','DISTRICT','Santee','176 Brooks Blvd.',NULL,'Santee','SC','29142','(803) 854-4700',33.4737478,-80.4819747);
INSERT INTO "office" VALUES('C000537-washington','C000537','DC','Washington','242 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-3315',38.8868,-77.0085);
INSERT INTO "office" VALUES('C000537-columbia','C000537','DISTRICT','Columbia','1225 Lady Street, Suite 200',NULL,'Columbia','SC','29201','(803) 799-1100',34.0032484,-81.0330283);
INSERT INTO "office" VALUES('C000567-gulf-coast','C000567','DISTRICT','Gulf Coast','2012 15th Street','Suite 451','Gulfport','MS','39501','(228) 867-9710',30.3692606,-89.086237);
INSERT INTO "office" VALUES('C000567-washington','C000567','DC','Washington','113 Dirksen Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5054',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('C000567-oxford','C000567','DISTRICT','Oxford','U.S. Federal Courthouse','911 East Jackson Avenue, Suite 249','Oxford','MS','38655','(662) 236-1018',34.3671955,-89.5213847);
INSERT INTO "office" VALUES('C000567-jackson','C000567','DISTRICT','Jackson','190 East Capitol St.','Suite 550','Jackson','MS','39201','(601) 965-4459',32.3004566,-90.186689);
INSERT INTO "office" VALUES('C000714-detroit','C000714','DISTRICT','Detroit','669 Federal Bldg.','231 W. Lafayette','Detroit','MI','48226','(313) 961-5670',42.3303849,-83.0496286);
INSERT INTO "office" VALUES('C000714-westland','C000714','DISTRICT','Westland','33300 Warren Rd.','Suite 13','Westland','MI','48185','(734) 675-4084',42.339678,-83.3701998);
INSERT INTO "office" VALUES('C000714-washington','C000714','DC','Washington','2426 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5126',38.8870193,-77.0081589);
INSERT INTO "office" VALUES('C000754-nashville','C000754','DISTRICT','Nashville','605 Church Street',NULL,'Nashville','TN','37219','(615) 736-5295',36.1623269,-86.7817797);
INSERT INTO "office" VALUES('C000754-washington','C000754','DC','Washington','1536 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4311',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C000880-boise','C000880','DISTRICT','Boise','251 E. Front St., Suite 205',NULL,'Boise','ID','83702','(208) 334-1776',43.6086015,-116.1956172);
INSERT INTO "office" VALUES('C000880-coeur-dalene','C000880','DISTRICT','Coeur D''Alene','610 Hubbard, Suite 209',NULL,'Coeur d'' Alene','ID','83814','(208) 664-5490',47.6826921,-116.7920799);
INSERT INTO "office" VALUES('C000880-idaho-falls','C000880','DISTRICT','Idaho Falls','410 Memorial Dr., Suite 204',NULL,'Idaho Falls','ID','83402','(208) 522-9779',43.4936265,-112.0425928);
INSERT INTO "office" VALUES('C000880-lewiston','C000880','DISTRICT','Lewiston','313 ''D'' St., Suite 105',NULL,'Lewiston','ID','83501','(208) 743-1492',46.422158,-117.028638);
INSERT INTO "office" VALUES('C000880-twin-falls','C000880','DISTRICT','Twin Falls','202 Falls Ave., Suite 2',NULL,'Twin Falls','ID','83301','(208) 734-2515',42.5776169,-114.47751);
INSERT INTO "office" VALUES('C000880-pocatello','C000880','DISTRICT','Pocatello','275 S. 5th Ave., Suite 225',NULL,'Pocatello','ID','83201','(208) 236-6775',42.8649373,-112.4428822);
INSERT INTO "office" VALUES('C000880-washington','C000880','DC','Washington','239 Dirksen Senate Office Building',NULL,'Washington','DC','20510','(202) 224-6142',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('C000984-baltimore','C000984','DISTRICT','Baltimore','1010 Park Avenue','Suite 105','Baltimore','MD','21201','(410) 685-9199',39.3030641,-76.6191075);
INSERT INTO "office" VALUES('C000984-catonsville','C000984','DISTRICT','Catonsville','754 Frederick Road',NULL,'Catonsville','MD','21228','(410) 719-8777',39.2717668,-76.7327434);
INSERT INTO "office" VALUES('C000984-ellicott','C000984','DISTRICT','Ellicott','8267 Main Street','Room 102','Ellicott','MD','21043','(410) 465-8259',39.2675157,-76.7991703);
INSERT INTO "office" VALUES('C000984-washington','C000984','DC','Washington','2163 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4741',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001035-augusta','C001035','DISTRICT','Augusta','68 Sewall Street, Room 507',NULL,'Augusta','ME','04330','(207) 622-8414',44.310824,-69.783697);
INSERT INTO "office" VALUES('C001035-bangor','C001035','DISTRICT','Bangor','202 Harlow Street, Room 20100',NULL,'Bangor','ME','04401','(207) 945-0417',44.8046399,-68.7737891);
INSERT INTO "office" VALUES('C001035-caribou','C001035','DISTRICT','Caribou','25 Sweden Street, Suite A',NULL,'Caribou','ME','04736','(207) 493-7873',46.860458,-68.013198);
INSERT INTO "office" VALUES('C001035-lewiston','C001035','DISTRICT','Lewiston','55 Lisbon Street',NULL,'Lewiston','ME','04240','(207) 784-6969',44.097439,-70.217972);
INSERT INTO "office" VALUES('C001035-portland','C001035','DISTRICT','Portland','One Canal Plaza','Suite 802','Portland','ME','04101','(207) 780-3575',43.6566885,-70.2551294);
INSERT INTO "office" VALUES('C001035-biddeford','C001035','DISTRICT','Biddeford','160 Main Street',NULL,'Biddeford','ME','04005','(207) 283-1101',43.493177,-70.4548329);
INSERT INTO "office" VALUES('C001035-washington','C001035','DC','Washington','413 Dirksen Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2523',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('C001037-washington','C001037','DC','Washington','1414 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5111',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001037-cambridge','C001037','DISTRICT','Cambridge','110 First Street',NULL,'Cambridge','MA','02141','(617) 621-6208',42.3678607,-71.0773053);
INSERT INTO "office" VALUES('C001038-bronx','C001038','DISTRICT','Bronx','2800 Bruckner Blvd., Suite 201',NULL,'Bronx','NY','10465','(718) 931-1400',40.8311507,-73.8306591);
INSERT INTO "office" VALUES('C001038-queens','C001038','DISTRICT','Queens','82-11 37th Ave., Suite 402',NULL,'Queens','NY','11372','(718) 779-1400',40.7500176,-73.8839356);
INSERT INTO "office" VALUES('C001038-washington','C001038','DC','Washington','1035 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3965',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001047-charleston','C001047','DISTRICT','Charleston','500 Virginia Street East','Suite 950','Charleston','WV','25301','(304) 347-5372',38.3511449,-81.6380602);
INSERT INTO "office" VALUES('C001047-martinsburg','C001047','DISTRICT','Martinsburg','300 Foxcroft Avenue','Suite 202A','Martinsburg','WV','25401','(304) 262-9285',39.4607489,-77.986887);
INSERT INTO "office" VALUES('C001047-morgantown','C001047','DISTRICT','Morgantown','48 Donley Street','Suite 504','Morgantown','WV','26501','(304) 292-2310',39.6256581,-79.9631255);
INSERT INTO "office" VALUES('C001047-washington','C001047','DC','Washington','172 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-6472',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('C001047-beckley','C001047','DISTRICT','Beckley','220 North Kanawha Street','Suite 1','Beckley','WV','25801','(304) 347-5372',37.779625,-81.188172);
INSERT INTO "office" VALUES('C001048-houston','C001048','DISTRICT','Houston','10000 Memorial Drive','Suite 620','Houston','TX','77024','(713) 682-8828',29.7788628,-95.4831225);
INSERT INTO "office" VALUES('C001048-washington','C001048','DC','Washington','2161 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2571',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001049-florissant','C001049','DISTRICT','Florissant','1281 Graham Rd','Suite 202','Florissant','MO','63031','(314) 383-5240',38.7764554,-90.3355487);
INSERT INTO "office" VALUES('C001049-washington','C001049','DC','Washington','2428 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2406',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001049-st-louis--10th-st','C001049','DISTRICT','St. Louis - 10th St','111 S. 10th Street','Suite 24.344','St. Louis','MO','63102','(314) 367-1970',38.6254195,-90.1970195);
INSERT INTO "office" VALUES('C001051-round-rock','C001051','DISTRICT','Round Rock','1717 North IH 35','Suite 303','Round Rock','TX','78664','(512) 246-1600',30.5234565,-97.688835);
INSERT INTO "office" VALUES('C001051-temple','C001051','DISTRICT','Temple','6544B S. General Bruce Drive',NULL,'Temple','TX','76502','(254) 933-1392',31.0718016,-97.4233588);
INSERT INTO "office" VALUES('C001051-washington','C001051','DC','Washington','2110 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3864',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001053-ada','C001053','DISTRICT','Ada','100 E. 13th St','Suite 213','Ada','OK','74820','(580) 436-5375',34.7723614,-96.6790693);
INSERT INTO "office" VALUES('C001053-lawton','C001053','DISTRICT','Lawton','711 SW D Ave.','Suite 201','Lawton','OK','73501','(580) 357-2131',34.6044481,-98.3995211);
INSERT INTO "office" VALUES('C001053-washington','C001053','DC','Washington','2467 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6165',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001053-norman','C001053','DISTRICT','Norman','2424 Springer Dr.','Suite 201','Norman','OK','73069','(405) 329-6500',35.2053158,-97.4788041);
INSERT INTO "office" VALUES('C001056-east-texas','C001056','DISTRICT','East Texas','Regions Bank Building','100 E. Ferguson Street, Suite 1004','Tyler','TX','75702','(903) 593-0902',32.3522862,-95.3002871);
INSERT INTO "office" VALUES('C001056-north-texas','C001056','DISTRICT','North Texas','5001 Spring Valley Road','Suite 1125 E','Dallas','TX','75244','(972) 239-1310',32.9400414,-96.8235975);
INSERT INTO "office" VALUES('C001056-south-texas','C001056','DISTRICT','South Texas','222 East Van Buren','Suite 404','Harlingen','TX','78550','(956) 423-0162',26.1914148,-97.6940201);
INSERT INTO "office" VALUES('C001056-south-central-texas','C001056','DISTRICT','South Central Texas','600 Navarro','Suite 210','San Antonio','TX','78205','(210) 224-7485',29.4267857,-98.4895764);
INSERT INTO "office" VALUES('C001056-central-texas','C001056','DISTRICT','Central Texas','Chase Tower','221 West Sixth Street, Suite 1530','Austin','TX','78701','(512) 469-6034',30.2681008,-97.7448471);
INSERT INTO "office" VALUES('C001056-west-texas','C001056','DISTRICT','West Texas','Wells Fargo Center','1500 Broadway, Suite 1230','Lubbock','TX','79401','(806) 472-7533',33.5849492,-101.8519083);
INSERT INTO "office" VALUES('C001056-southeast-texas','C001056','DISTRICT','Southeast Texas','5300 Memorial Drive Suite 980',NULL,'Houston','TX','77007','(713) 572-3337',29.7620629,-95.4159532);
INSERT INTO "office" VALUES('C001056-washington','C001056','DC','Washington','517 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2934',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('C001059-fresno','C001059','DISTRICT','Fresno','855 M Street, Suite 940',NULL,'Fresno','CA','93721','(559) 495-1620',36.7345489,-119.7858717);
INSERT INTO "office" VALUES('C001059-merced','C001059','DISTRICT','Merced','2222 M St, Suite 305',NULL,'Merced','CA','95340','(209) 384-1620',37.3070723,-120.4812216);
INSERT INTO "office" VALUES('C001059-washington','C001059','DC','Washington','2081 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3341',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001061-higginsville','C001061','DISTRICT','Higginsville','1923 Main St.',NULL,'Higginsville','MO','64037','(660) 584-7373',39.0754557,-93.7170832);
INSERT INTO "office" VALUES('C001061-independence','C001061','DISTRICT','Independence','211 West Maple Avenue',NULL,'Independence','MO','64050','(816) 833-4545',39.0926561,-94.4176503);
INSERT INTO "office" VALUES('C001061-washington','C001061','DC','Washington','2335 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4535',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001061-kansas-city','C001061','DISTRICT','Kansas City','101 W. 31 Street',NULL,'Kansas City','MO','64108','(816) 842-4545',39.070874,-94.587124);
INSERT INTO "office" VALUES('C001062-odessa','C001062','DISTRICT','Odessa','City Hall','411 W. 8th Street, 5th Floor','Odessa','TX','79761','(432) 331-9667',31.848779,-102.3748667);
INSERT INTO "office" VALUES('C001062-llano','C001062','DISTRICT','Llano','County Annex','104 W. Sandstone','Llano','TX','78643','(325) 247-2826',30.7492439,-98.6764682);
INSERT INTO "office" VALUES('C001062-midland','C001062','DISTRICT','Midland','6 Desta Drive, Suite 2000',NULL,'Midland','TX','79705','(432) 687-2390',32.0303053,-102.0856792);
INSERT INTO "office" VALUES('C001062-brownwood','C001062','DISTRICT','Brownwood','Brownwood City Hall','501 Center Ave.','Brownwood','TX','76801','(325) 646-1950',31.7197496,-98.9836114);
INSERT INTO "office" VALUES('C001062-granbury','C001062','DISTRICT','Granbury','132 Houston St.',NULL,'Granbury','TX','76048','(682) 936-2577',32.44305,-97.787906);
INSERT INTO "office" VALUES('C001062-washington','C001062','DC','Washington','2430 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3605',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001062-san-angelo','C001062','DISTRICT','San Angelo','33 Twohig, Suite 307',NULL,'San Angelo','TX','76903','(325) 659-4010',31.4614147,-100.4355616);
INSERT INTO "office" VALUES('C001063-san-antonio','C001063','DISTRICT','San Antonio','615 E. Houston Street, Suite 563',NULL,'San Antonio','TX','78205','(210) 271-2851',29.4270611,-98.4862276);
INSERT INTO "office" VALUES('C001063-laredo','C001063','DISTRICT','Laredo','602 E. Calton Road, Suite 2',NULL,'Laredo','TX','78041','(956) 725-0639',27.5423782,-99.4887937);
INSERT INTO "office" VALUES('C001063-mission','C001063','DISTRICT','Mission','117 E. Tom Landry',NULL,'Mission','TX','78572','(956) 424-3942',26.2161009,-98.324999);
INSERT INTO "office" VALUES('C001063-rio-grande','C001063','DISTRICT','Rio Grande','100 N. F.M. 3167',NULL,'Rio Grande City','TX','78582','(956) 487-5603',26.3834188,-98.8582305);
INSERT INTO "office" VALUES('C001063-washington','C001063','DC','Washington','2209 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-1640',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001066-tampa','C001066','DISTRICT','Tampa','4144 N Armenia Ave., Suite 300',NULL,'Tampa','FL','33607','(813) 871-2817',27.9771817,-82.4852065);
INSERT INTO "office" VALUES('C001066-washington','C001066','DC','Washington','2052 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3376',38.8868,-77.0085);
INSERT INTO "office" VALUES('C001067-brooklyn','C001067','DISTRICT','Brooklyn','222 Lenox Road, Suites 1 & 2',NULL,'Brooklyn','NY','11226','(718) 287-1142',40.6538207,-73.9519417);
INSERT INTO "office" VALUES('C001067-washington','C001067','DC','Washington','2058 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6231',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001068-memphis','C001068','DISTRICT','Memphis','The Clifford Davis/Odell Horton Federal Building','167 North Main Street, Suite 369','Memphis','TN','38103','(901) 544-4131',35.1497482,-90.0517538);
INSERT INTO "office" VALUES('C001068-washington','C001068','DC','Washington','2404 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3265',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001069-norwich','C001069','DISTRICT','Norwich','55 Main Street, Suite 250',NULL,'Norwich','CT','06360','(860) 886-0139',41.524272,-72.078968);
INSERT INTO "office" VALUES('C001069-enfield','C001069','DISTRICT','Enfield','77 Hazard Ave, Unit J',NULL,'Enfield','CT','06082','(860) 741-6011',41.9904484,-72.5723972);
INSERT INTO "office" VALUES('C001069-washington','C001069','DC','Washington','2348 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2076',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001070-northeastern-pa','C001070','DISTRICT','Northeastern Pa','417 Lackawanna Avenue, Suite 303',NULL,'Scranton','PA','18503','(570) 941-0930',41.4073687,-75.6654743);
INSERT INTO "office" VALUES('C001070-erie','C001070','DISTRICT','Erie','17 South Park Row, Suite B-150',NULL,'Erie','PA','16501','(814) 874-5080',42.1289745,-80.0840689);
INSERT INTO "office" VALUES('C001070-harrisburg','C001070','DISTRICT','Harrisburg','200 N Third St, Suite 14A',NULL,'Harrisburg','PA','17101','(717) 231-7540',40.2619774,-76.8829619);
INSERT INTO "office" VALUES('C001070-pittsburgh','C001070','DISTRICT','Pittsburgh','Grant Building','310 Grant Street, Suite 2415','Pittsburgh','PA','15219','(412) 803-7370',40.4376694,-79.9974916);
INSERT INTO "office" VALUES('C001070-lehigh-valley','C001070','DISTRICT','Lehigh Valley','840 Hamilton Street, Suite 301',NULL,'Allentown','PA','18101','(610) 782-9470',40.6010783,-75.4749998);
INSERT INTO "office" VALUES('C001070-washington','C001070','DC','Washington','393 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-6324',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('C001070-philadelphia','C001070','DISTRICT','Philadelphia','2000 Market Street, Suite 610',NULL,'Philadelphia','PA','19103','(215) 405-9660',39.9532653,-75.1736411);
INSERT INTO "office" VALUES('C001070-central-pa','C001070','DISTRICT','Central Pa','817 E. Bishop Street, Suite C',NULL,'Bellefonte','PA','16823','(814) 357-0314',40.9138418,-77.7641528);
INSERT INTO "office" VALUES('C001071-memphis','C001071','DISTRICT','Memphis','100 Peabody Place, Suite 1125',NULL,'Memphis','TN','38103','(901) 683-1910',35.1412747,-90.0540056);
INSERT INTO "office" VALUES('C001071-jackson','C001071','DISTRICT','Jackson','91 Stonebridge Boulevard','Suite 103','Jackson','TN','38305','(731) 664-2294',35.675843,-88.853423);
INSERT INTO "office" VALUES('C001071-nashville','C001071','DISTRICT','Nashville','3322 West End Ave., Suite 610',NULL,'Nashville','TN','37203','(615) 279-8125',36.1400262,-86.8199101);
INSERT INTO "office" VALUES('C001071-knoxville','C001071','DISTRICT','Knoxville','800 Market Street, Suite 121',NULL,'Knoxville','TN','37902','(865) 637-4180',35.96172,-83.917758);
INSERT INTO "office" VALUES('C001071-tricities','C001071','DISTRICT','Tri-Cities','1105 East Jackson Boulevard','Suite 4','Jonesborough','TN','37659','(423) 753-2263',36.3024064,-82.4579189);
INSERT INTO "office" VALUES('C001071-chattanooga','C001071','DISTRICT','Chattanooga','10 West MLK Blvd., 6th Floor',NULL,'Chattanooga','TN','37402','(423) 756-2757',35.0454311,-85.309912);
INSERT INTO "office" VALUES('C001071-washington','C001071','DC','Washington','425 Dirksen Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3344',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('C001072-washington','C001072','DC','Washington','2135 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4011',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001072-indianapolis','C001072','DISTRICT','Indianapolis','300 E Fall Creek Pkwy. N. Dr.','Suite 300','Indianapolis','IN','46205','(317) 283-6516',39.8063243,-86.1513962);
INSERT INTO "office" VALUES('C001075-baton-rouge','C001075','DISTRICT','Baton Rouge','5555 Hilton Ave.','Suite 100','Baton Rouge','LA','70808','(225) 929-7711',30.423884,-91.1325791);
INSERT INTO "office" VALUES('C001075-lake-charles','C001075','DISTRICT','Lake Charles','1 Lakeshore Drive','Suite 1155','Lake Charles','LA','70629','(337) 493-5398',30.2305579,-93.2196294);
INSERT INTO "office" VALUES('C001075-shreveport','C001075','DISTRICT','Shreveport','6425 Youree Dr.','Suite 415','Shreveport','LA','71105','(318) 798-3215',32.448457,-93.7198668);
INSERT INTO "office" VALUES('C001075-metairie','C001075','DISTRICT','Metairie','3421 N. Causeway Blvd.','Suite 204','Metairie','LA','70002','(504) 838-0130',30.0112259,-90.1541748);
INSERT INTO "office" VALUES('C001075-lafayette','C001075','DISTRICT','Lafayette','101 La Rue France','Suite 505','Lafayette','LA','70508','(337) 261-1400',30.1948666,-92.014654);
INSERT INTO "office" VALUES('C001075-alexandria','C001075','DISTRICT','Alexandria','3600 Jackson Street','Suite 115A','Alexandria','LA','71303','(318) 448-7176',31.2852075,-92.4767735);
INSERT INTO "office" VALUES('C001075-washington','C001075','DC','Washington','520 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5824',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('C001075-monroe','C001075','DISTRICT','Monroe','1651 Louisville Ave','Suite 123','Monroe','LA','70201','(318) 324-2111',32.5175209,-92.1087384);
INSERT INTO "office" VALUES('C001076-provo','C001076','DISTRICT','Provo','51 S University Ave.','Suite 318','Provo','UT','84601','(801) 851-2500',40.232986,-111.6578512);
INSERT INTO "office" VALUES('C001076-washington','C001076','DC','Washington','2236 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-7751',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001077-aurora','C001077','DISTRICT','Aurora','3300 S. Parker Road','Cherry Creek Place IV Suite #305','Aurora','CO','80014','(720) 748-7514',39.6573403,-104.8354278);
INSERT INTO "office" VALUES('C001077-washington','C001077','DC','Washington','2443 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-7882',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001078-annandale','C001078','DISTRICT','Annandale','4115 Annandale Road, Ste. 103',NULL,'Annandale','VA','22003','(703) 256-3071',38.8338994,-77.1967528);
INSERT INTO "office" VALUES('C001078-prince-william','C001078','DISTRICT','Prince William','2241-D Tacketts Mill Drive',NULL,'Woodbridge','VA','22192','(571) 408-4407',38.6752583,-77.2815925);
INSERT INTO "office" VALUES('C001078-washington','C001078','DC','Washington','2238 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-1492',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001080-claremont','C001080','DISTRICT','Claremont','415 W. Foothill Blvd, Ste 122',NULL,'Claremont','CA','91711','(909) 625-5394',34.1079585,-117.7212331);
INSERT INTO "office" VALUES('C001080-pasadena','C001080','DISTRICT','Pasadena','527 S. Lake Ave','Suite 106','Pasadena','CA','91101','(626) 304-0110',34.1367185,-118.1327226);
INSERT INTO "office" VALUES('C001080-washington','C001080','DC','Washington','2423 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5464',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001084-pawtucket','C001084','DISTRICT','Pawtucket','1070 Main Street, Suite 300,',NULL,'Pawtucket','RI','02860','(401) 729-5600',41.8610791,-71.3986461);
INSERT INTO "office" VALUES('C001084-washington','C001084','DC','Washington','2244 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4911',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('C001087-jonesboro','C001087','DISTRICT','Jonesboro','2400 Highland Drive, Suite 300',NULL,'Jonesboro','AR','72401','(870) 203-0540',35.8220219,-90.6760171);
INSERT INTO "office" VALUES('C001087-cabot','C001087','DISTRICT','Cabot','112 S. 1st',NULL,'Cabot','AR','72023','(501) 843-3043',34.9730598,-92.0167235);
INSERT INTO "office" VALUES('C001087-washington','C001087','DC','Washington','2422 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4076',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001087-mountain-home','C001087','DISTRICT','Mountain Home','1001 Highway 62 E, Suite 9',NULL,'Mountain Home','AR','72653','(870) 424-2075',36.3499306,-92.3707731);
INSERT INTO "office" VALUES('C001088-dover','C001088','DISTRICT','Dover','500 W. Loockerman St.','Suite 450','Dover','DE','19904','(302) 736-5601',39.1566624,-75.5311574);
INSERT INTO "office" VALUES('C001088-wilmington','C001088','DISTRICT','Wilmington','1105 N. Market St.','Suite 100','Wilmington','DE','19801-1233','(302) 573-6345',39.7473432,-75.5471367);
INSERT INTO "office" VALUES('C001088-washington','C001088','DC','Washington','127a Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5042',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('C001090-scranton','C001090','DISTRICT','Scranton','226 Wyoming Avenue',NULL,'Scranton','PA','18503','(570) 341-1050',41.4093981,-75.6643973);
INSERT INTO "office" VALUES('C001090-easton','C001090','DISTRICT','Easton','400 Northampton Street','Suite 307','Easton','PA','18042','(484) 546-0776',40.6908081,-75.2111997);
INSERT INTO "office" VALUES('C001090-wilkesbarre','C001090','DISTRICT','Wilkes-Barre','20 North Pennsylvania Avenue','Suite 201','Wilkes-Barre','PA','18711','(570) 371-0317',41.2441677,-75.8791709);
INSERT INTO "office" VALUES('C001090-washington','C001090','DC','Washington','1034 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5546',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001090-pottsville','C001090','DISTRICT','Pottsville','121 Progress Avenue','Suite 310','Pottsville','PA','17901','(570) 624-0140',40.6864175,-76.1950516);
INSERT INTO "office" VALUES('C001091-san-antonio','C001091','DISTRICT','San Antonio','727 E. Cesar E. Chavez Blvd','Suite B-128','San Antonio','TX','78206','(210) 348-8216',29.4175269,-98.4846276);
INSERT INTO "office" VALUES('C001091-washington','C001091','DC','Washington','1221 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3236',38.8868,-77.0085);
INSERT INTO "office" VALUES('C001092-lancaster','C001092','DISTRICT','Lancaster','2813 Wehrle Drive','Suite 13','Williamsville','NY','14221','(716) 634-2324',42.9552643,-78.6780537);
INSERT INTO "office" VALUES('C001092-geneseo','C001092','DISTRICT','Geneseo','128 Main Street',NULL,'Geneseo','NY','14454','(585) 519-4002',42.794794,-77.817404);
INSERT INTO "office" VALUES('C001092-washington','C001092','DC','Washington','1117 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5265',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001093-gainesville','C001093','DISTRICT','Gainesville','210 Washington St. NW, Suite 202',NULL,'Gainesville','GA','30501','(770) 297-3388',34.299434,-83.8282158);
INSERT INTO "office" VALUES('C001093-washington','C001093','DC','Washington','1504 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-9893',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001094-yucaipa','C001094','DISTRICT','Yucaipa','34282 Yucaipa Boulevard',NULL,'Yucaipa','CA','92399','(909) 797-4900',34.0344717,-117.0567352);
INSERT INTO "office" VALUES('C001094-apple-valley','C001094','DISTRICT','Apple Valley','14955 Dale Evans Parkway','Apple Valley Town Hall','Apple Valley','CA','92307','(760) 247-1815',34.5240995,-117.2142837);
INSERT INTO "office" VALUES('C001094-washington','C001094','DC','Washington','1222 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5861',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001095-springdale','C001095','DISTRICT','Springdale','1108 South Old Missouri Road','Suite B','Springdale','AR','72764','(479) 751-0879',36.174571,-94.1176151);
INSERT INTO "office" VALUES('C001095-jonesboro','C001095','DISTRICT','Jonesboro','300 South Church','Suite 338','Jonesboro','AR','72401','(870) 933-6223',35.8404281,-90.7036855);
INSERT INTO "office" VALUES('C001095-little-rock','C001095','DISTRICT','Little Rock','1401 West Capitol Ave','Suite 235','Little Rock','AR','72201','(501) 223-9081',34.7456872,-92.2865752);
INSERT INTO "office" VALUES('C001095-washington','C001095','DC','Washington','124 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2353',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('C001095-el-dorado','C001095','DISTRICT','El Dorado','106 West Main Street','Suite 410','El Dorado','AR','71730','(870) 864-8582',33.2120448,-92.664046);
INSERT INTO "office" VALUES('C001096-fargo','C001096','DISTRICT','Fargo','3217 Fiechtner Drive','Suite D','Fargo','ND','58103','(701) 356-2216',46.8653775,-96.8314895);
INSERT INTO "office" VALUES('C001096-grand-forks','C001096','DISTRICT','Grand Forks','4200 James Ray Drive','Office 600','Grand Forks','ND','58202','(701) 738-4880',47.921087,-97.090537);
INSERT INTO "office" VALUES('C001096-minot','C001096','DISTRICT','Minot','315 Main Street','Suite 203','Minot','ND','58701','(701) 839-0255',48.2328101,-101.2926299);
INSERT INTO "office" VALUES('C001096-washington','C001096','DC','Washington','1717 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2611',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001096-bismarck','C001096','DISTRICT','Bismarck','220 East Rosser Avenue','328 Federal Building','Bismarck','ND','58501','(701) 224-0355',46.8090113,-100.7882597);
INSERT INTO "office" VALUES('C001097-panorama-city','C001097','DISTRICT','Panorama City','9612 Van Nuys Blvd.','Suite 201','Panorama City','CA','91402','(818) 221-3718',34.2449325,-118.4495976);
INSERT INTO "office" VALUES('C001097-washington','C001097','DC','Washington','1510 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-6131',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001098-north-texas','C001098','DISTRICT','North Texas','Lee Park Tower II','3626 N. Hall St., Suite 410','Dallas','TX','75219','(214) 599-8749',32.8092691,-96.8059281);
INSERT INTO "office" VALUES('C001098-southcentral-texas','C001098','DISTRICT','South/Central Texas','9901 IH-10W','Suite 950','San Antonio','TX','78230','(210) 340-2885',29.533858,-98.5619881);
INSERT INTO "office" VALUES('C001098-central-texas','C001098','DISTRICT','Central Texas','300 E 8th','Suite 961','Austin','TX','78701','(512) 916-5834',30.269401,-97.7390867);
INSERT INTO "office" VALUES('C001098-southeast-texas','C001098','DISTRICT','Southeast Texas','808 Travis Street','Suite 1420','Houston','TX','77002','(713) 718-3057',29.758844,-95.3650242);
INSERT INTO "office" VALUES('C001098-east-texas','C001098','DISTRICT','East Texas','305 S. Broadway','Suite 501','Tyler','TX','75702','(903) 593-5130',32.3480097,-95.3009807);
INSERT INTO "office" VALUES('C001098-south-texas','C001098','DISTRICT','South Texas','200 S. 10th St','Suite 1603','McAllen','TX','78501','(956) 686-7339',26.2019273,-98.2313667);
INSERT INTO "office" VALUES('C001098-washington','C001098','DC','Washington','404 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5922',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('C001101-cambridge','C001101','DISTRICT','Cambridge','701 Concord Avenue, Suite 101',NULL,'Cambridge','MA','02138','(617) 354-0292',42.390572,-71.151338);
INSERT INTO "office" VALUES('C001101-framingham','C001101','DISTRICT','Framingham','116 Concord Street, Suite 1',NULL,'Framingham','MA','01702','(508) 319-9757',42.2787415,-71.4170035);
INSERT INTO "office" VALUES('C001101-washington','C001101','DC','Washington','1415 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2836',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001103-savannah','C001103','DISTRICT','Savannah','6602 Abercorn Street, Suite 105B',NULL,'Savannah','GA','31405','(912) 352-0101',32.017594,-81.110403);
INSERT INTO "office" VALUES('C001103-washington','C001103','DC','Washington','432 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-5831',38.8868,-77.0085);
INSERT INTO "office" VALUES('C001103-brunswick','C001103','DISTRICT','Brunswick','1510 Newcastle Street, Suite 200',NULL,'Brunswick','GA','31520','(912) 265-9010',31.149693,-81.49532);
INSERT INTO "office" VALUES('C001105-shenandoah-valley','C001105','DISTRICT','Shenandoah Valley','117 E. Piccadilly Street','Suite 100 D','Winchester','VA','22601','(540) 773-3600',39.185574,-78.1625238);
INSERT INTO "office" VALUES('C001105-loudoun-county','C001105','DISTRICT','Loudoun County','21430 Cedar Drive','Suite 218','Sterling','VA','20164','(703) 404-6903',39.0191653,-77.3782613);
INSERT INTO "office" VALUES('C001105-washington','C001105','DC','Washington','229 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-5136',38.8868,-77.0085);
INSERT INTO "office" VALUES('C001106-west-chester','C001106','DISTRICT','West Chester','21 West Market Street, Suite 105',NULL,'West Chester','PA','19382','(610) 696-2982',39.9594878,-75.6049694);
INSERT INTO "office" VALUES('C001106-washington','C001106','DC','Washington','326 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4315',38.8868,-77.0085);
INSERT INTO "office" VALUES('C001106-wyomissing','C001106','DISTRICT','Wyomissing','840 North Park Road',NULL,'Wyomissing','PA','19610','(610) 376-7630',40.3466277,-75.9595672);
INSERT INTO "office" VALUES('C001107-key-west','C001107','DISTRICT','Key West','1100 Simonton Street','Suite 1-213','Key West','FL','33040','(305) 292-4485',24.5505584,-81.7973549);
INSERT INTO "office" VALUES('C001107-florida-city','C001107','DISTRICT','Florida City','404 West Palm Drive',NULL,'Florida City','FL','33034','(305) 247-1234',25.4483513,-80.4827158);
INSERT INTO "office" VALUES('C001107-washington','C001107','DC','Washington','1404 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2778',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001107-miami','C001107','DISTRICT','Miami','12851 SW 42nd Street','Suite 131','Miami','FL','33175','(305) 222-0160',25.7298536,-80.4026651);
INSERT INTO "office" VALUES('C001108-washington','C001108','DC','Washington','1513 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3115',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001108-tompkinsville','C001108','DISTRICT','Tompkinsville','200 North Main Street','Suite F','Tompkinsville','KY','42167','(270) 487-9509',36.7006713,-85.6929017);
INSERT INTO "office" VALUES('C001109-casper','C001109','DISTRICT','Casper','100 East B Street','Room 4003','Casper','WY','82602','(307) 261-6595',42.8524124,-106.3248373);
INSERT INTO "office" VALUES('C001109-cheyenne','C001109','DISTRICT','Cheyenne','2120 Capitol Ave','Ste. 8005','Cheyenne','WY','82001','(307) 772-2595',41.1374591,-104.8189674);
INSERT INTO "office" VALUES('C001109-washington','C001109','DC','Washington','416 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2311',38.8868,-77.0085);
INSERT INTO "office" VALUES('C001109-sheridan','C001109','DISTRICT','Sheridan','45 East Loucks St.',NULL,'Sheridan','WY','82801','(307) 673-4608',44.7974845,-106.9548869);
INSERT INTO "office" VALUES('C001109-gillette','C001109','DISTRICT','Gillette','300 S.Gillette Ave','Suite 2000','Gillette','WY','82716','(307) 414-1677',44.2920649,-105.5044127);
INSERT INTO "office" VALUES('C001110-washington','C001110','DC','Washington','1039 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2965',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('C001111-washington','C001111','DC','Washington','427 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-5961',38.8868,-77.0085);
INSERT INTO "office" VALUES('C001111-st-petersburg','C001111','DISTRICT','St. Petersburg','696 1st Avenue North','Suite 203','St. Petersburg','FL','33701','(727) 318-6770',27.7717703,-82.6435748);
INSERT INTO "office" VALUES('C001112-san-luis-obispo','C001112','DISTRICT','San Luis Obispo','1411 Marsh St','Suite 205','San Luis Obispo','CA','93401','(805) 546-8348',35.2838648,-120.6538213);
INSERT INTO "office" VALUES('C001112-washington','C001112','DC','Washington','212 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-3601',38.8868,-77.0085);
INSERT INTO "office" VALUES('C001112-santa-barbara','C001112','DISTRICT','Santa Barbara','360 S. Hope Ave','Suite C-301','Santa Barbara','CA','93105','(805) 730-1710',34.4349008,-119.7468517);
INSERT INTO "office" VALUES('C001113-washington','C001113','DC','Washington','B40a Dirksen Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3542',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('C001113-las-vegas','C001113','DISTRICT','Las Vegas','333 Las Vegas Blvd South','Suite 8016','Las Vegas','NV','89101','(702) 388-5020',36.1651154,-115.1424185);
INSERT INTO "office" VALUES('C001113-reno','C001113','DISTRICT','Reno','400 S. Virginia St, Suite 902','Courthouse and Federal Building','Reno','NV','89501',' (775) 686-5750',39.5215352,-119.810287);
INSERT INTO "office" VALUES('D000096-chicago','D000096','DISTRICT','Chicago','2746 West Madison Street',NULL,'Chicago','IL','60612','(773) 533-7520',41.8812579,-87.6957293);
INSERT INTO "office" VALUES('D000096-washington','D000096','DC','Washington','2159 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5006',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('D000191-coos-bay','D000191','DISTRICT','Coos Bay','125 Central Ave','Suite 350','Coos Bay','OR','97420','(541) 269-2609',43.367748,-124.213429);
INSERT INTO "office" VALUES('D000191-eugene','D000191','DISTRICT','Eugene','405 East 8th Ave.','#2030','Eugene','OR','97401','(541) 465-6732',44.0516985,-123.0857882);
INSERT INTO "office" VALUES('D000191-roseburg','D000191','DISTRICT','Roseburg','612 S.E Jackson St','Room 9','Roseburg','OR','97470','(541) 440-3523',43.2087689,-123.3444436);
INSERT INTO "office" VALUES('D000191-washington','D000191','DC','Washington','2134 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6416',38.886842,-77.0097673);
INSERT INTO "office" VALUES('D000197-denver','D000197','DISTRICT','Denver','600 Grant Street, Suite 202',NULL,'Denver','CO','80203','(303) 844-4988',39.7260392,-104.9832743);
INSERT INTO "office" VALUES('D000197-washington','D000197','DC','Washington','2111 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4431',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('D000216-new-haven','D000216','DISTRICT','New Haven','59 Elm Street',NULL,'New Haven','CT','06510','(203) 562-3718',41.3080224,-72.9226768);
INSERT INTO "office" VALUES('D000216-washington','D000216','DC','Washington','2413 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3661',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('D000399-austin','D000399','DISTRICT','Austin','300 East 8th St, Suite 763',NULL,'Austin','TX','78701','(512) 916-5921',30.269401,-97.7390867);
INSERT INTO "office" VALUES('D000399-washington','D000399','DC','Washington','2307 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4865',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('D000399-san-antonio','D000399','DISTRICT','San Antonio','217 W. Travis St.',NULL,'San Antonio','TX','78205','(210) 704-1080',29.427604,-98.4951151);
INSERT INTO "office" VALUES('D000482-pittsburgh','D000482','DISTRICT','Pittsburgh','2637 East Carson Street',NULL,'Pittsburgh','PA','15203','(412) 390-1499',40.4273525,-79.9675163);
INSERT INTO "office" VALUES('D000482-mckeesport','D000482','DISTRICT','Mckeesport','627 Lysle Boulevard',NULL,'McKeesport','PA','15132','(412) 664-4049',40.352477,-79.858547);
INSERT INTO "office" VALUES('D000482-penn-hills','D000482','DISTRICT','Penn Hills','11 Duff Road',NULL,'Penn Hills','PA','15235','(412) 241-6055',40.4644937,-79.8281138);
INSERT INTO "office" VALUES('D000482-washington','D000482','DC','Washington','239 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2135',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000533-knoxville','D000533','DISTRICT','Knoxville','800 Market Street, Suite 110',NULL,'Knoxville','TN','37902','(865) 523-3772',35.96172,-83.917758);
INSERT INTO "office" VALUES('D000533-washington','D000533','DC','Washington','2207 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5435',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('D000533-maryville','D000533','DISTRICT','Maryville','331 Court Street',NULL,'Maryville','TN','37804','(865) 984-5464',35.7548786,-83.9690043);
INSERT INTO "office" VALUES('D000563-chicago','D000563','DISTRICT','Chicago','230 S. Dearborn Street','Suite 3892','Chicago','IL','60604','(312) 353-4952',41.8784454,-87.63);
INSERT INTO "office" VALUES('D000563-springfield','D000563','DISTRICT','Springfield','525 S. 8th Street',NULL,'Springfield','IL','62703','(217) 492-4062',39.7965137,-89.6451404);
INSERT INTO "office" VALUES('D000563-carbondale','D000563','DISTRICT','Carbondale','250 W. Cherry Street','Suite 115-D','Carbondale','IL','62901','(618) 351-1122',37.7233822,-89.2173032);
INSERT INTO "office" VALUES('D000563-rock-island','D000563','DISTRICT','Rock Island','1504 Third Avenue','Suite 227','Rock Island','IL','61201','(309) 786-5173',41.5090535,-90.5782533);
INSERT INTO "office" VALUES('D000563-washington','D000563','DC','Washington','711 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2152',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('D000598-san-diego','D000598','DISTRICT','San Diego','2700 Adams Avenue, Suite 102',NULL,'San Diego','CA','92116','(619) 280-5353',32.7631233,-117.1348898);
INSERT INTO "office" VALUES('D000598-washington','D000598','DC','Washington','1214 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2040',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('D000600-doral','D000600','DISTRICT','Doral','8669 NW 36th Street, Suite 100',NULL,'Doral','FL','33166','(305) 470-8555',25.8109245,-80.3361915);
INSERT INTO "office" VALUES('D000600-naples','D000600','DISTRICT','Naples','4715 Golden Gate Parkway, Suite 1',NULL,'Naples','FL','34116','(239) 348-1620',26.1833954,-81.7038021);
INSERT INTO "office" VALUES('D000600-washington','D000600','DC','Washington','440 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4211',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000604-berks-county','D000604','DISTRICT','Berks County','61 N 3rd Street',NULL,'Hamburg','PA','19526','(610) 562-4281',40.556407,-75.9840798);
INSERT INTO "office" VALUES('D000604-dauphin-county','D000604','DISTRICT','Dauphin County','250 W Chocolate Avenue','Suite 2','Hershey','PA','17033','(717) 533-3959',40.2832262,-76.6556063);
INSERT INTO "office" VALUES('D000604-washington','D000604','DC','Washington','2082 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6411',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('D000604-lehigh-valley','D000604','DISTRICT','Lehigh Valley','3900 Hamilton Boulevard','Suite 207','Allentown','PA','18103','(610) 770-3490',40.5733973,-75.535032);
INSERT INTO "office" VALUES('D000604-lebanon-county','D000604','DISTRICT','Lebanon County','342 W Main St',NULL,'Annville','PA','17003','(717) 867-1026',40.32787,-76.521464);
INSERT INTO "office" VALUES('D000607-evansville','D000607','DISTRICT','Evansville','123 NW 4th Street, Suite 417',NULL,'Evansville','IN','47708','(812) 425-5813',37.9732451,-87.5720272);
INSERT INTO "office" VALUES('D000607-jeffersonville','D000607','DISTRICT','Jeffersonville','702 North Shore Drive','Suite LL-101','Jeffersonville','IN','47130','(812) 284-2027',38.271605,-85.7488172);
INSERT INTO "office" VALUES('D000607-fort-wayne','D000607','DISTRICT','Fort Wayne','203 E. Berry Street, Suite 702 B',NULL,'Fort Wayne','IN','46802','(260) 420-4955',41.0798997,-85.1378306);
INSERT INTO "office" VALUES('D000607-hammond','D000607','DISTRICT','Hammond','5400 Federal Plaza, Suite 3200',NULL,'Hammond','IN','46320','(219) 852-0089',41.6153792,-87.5212089);
INSERT INTO "office" VALUES('D000607-indianapolis','D000607','DISTRICT','Indianapolis','115 N. Pennsylvania Street Suite 100',NULL,'Indianapolis','IN','46204','(317) 226-5555',39.7689854,-86.1559046);
INSERT INTO "office" VALUES('D000607-south-bend','D000607','DISTRICT','South Bend','205 West Colfax Avenue',NULL,'South Bend','IN','46601','(574) 288-2780',41.6778965,-86.2524695);
INSERT INTO "office" VALUES('D000607-washington','D000607','DC','Washington','720 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-4814',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('D000610-boca-raton','D000610','DISTRICT','Boca Raton','7900 Glades Road, Ste. 250',NULL,'Boca Raton','FL','33434','(561) 470-5440',26.365483,-80.1673666);
INSERT INTO "office" VALUES('D000610-margate','D000610','DISTRICT','Margate','5790 Margate Blvd',NULL,'Margate','FL','33063','(954) 972-6454',26.2420954,-80.2050177);
INSERT INTO "office" VALUES('D000610-washington','D000610','DC','Washington','2447 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3001',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('D000610-coral-springs','D000610','DISTRICT','Coral Springs','1300 Coral Springs Drive',NULL,'Coral Springs','FL','33071','(954) 255-8336',26.2459273,-80.2697548);
INSERT INTO "office" VALUES('D000612-modesto','D000612','DISTRICT','Modesto','4701 Sisk Road, Suite 202',NULL,'Modesto','CA','95356','(209) 579-5458',37.7071746,-121.0778461);
INSERT INTO "office" VALUES('D000612-washington','D000612','DC','Washington','1730 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4540',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('D000614-hayward','D000614','DISTRICT','Hayward','15954 Rivers Edge Drive','Suite 206','Hayward','WI','54843','(715) 392-3984',46.0039436,-91.4901222);
INSERT INTO "office" VALUES('D000614-hudson','D000614','DISTRICT','Hudson','502 2nd St.','Suite 202','Hudson','WI','54016','(715) 808-8160',44.9750352,-92.7566503);
INSERT INTO "office" VALUES('D000614-washington','D000614','DC','Washington','2330 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3365',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('D000614-wausau','D000614','DISTRICT','Wausau','208 Grand Avenue',NULL,'Wausau','WI','54403','(715) 298-9344',44.955171,-89.624724);
INSERT INTO "office" VALUES('D000615-anderson','D000615','DISTRICT','Anderson','303 West Beltline Blvd',NULL,'Anderson','SC','29625','(864) 224-7401',34.5490603,-82.6746057);
INSERT INTO "office" VALUES('D000615-laurens','D000615','DISTRICT','Laurens','200 Courthouse Public Square',NULL,'Laurens','SC','29360','(864) 681-1028',34.4993065,-82.0144844);
INSERT INTO "office" VALUES('D000615-washington','D000615','DC','Washington','2229 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5301',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000616-winchester','D000616','DISTRICT','Winchester','200 South Jefferson St.','Federal Building Suite 311','Winchester','TN','37398','(931) 962-3180',35.1850086,-86.1112284);
INSERT INTO "office" VALUES('D000616-cleveland','D000616','DISTRICT','Cleveland','301 Keith St., Suite 212',NULL,'Cleveland','TN','37311','(423) 472-7500',35.160062,-84.8840222);
INSERT INTO "office" VALUES('D000616-murfreesboro','D000616','DISTRICT','Murfreesboro','305 W. Main St',NULL,'Murfreesboro','TN','37130','(615) 896-1986',35.8461158,-86.3940965);
INSERT INTO "office" VALUES('D000616-washington','D000616','DC','Washington','2301 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6831',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000616-columbia','D000616','DISTRICT','Columbia','711 North Garden St.',NULL,'Columbia','TN','38401','(931) 381-9920',35.61587,-87.035826);
INSERT INTO "office" VALUES('D000617-mount-vernon','D000617','DISTRICT','Mount Vernon','204 W. Montgomery Street',NULL,'Mount Vernon','WA','98273','(360) 416-7879',48.419499,-122.3357879);
INSERT INTO "office" VALUES('D000617-washington','D000617','DC','Washington','2442 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6311',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000617-bothell','D000617','DISTRICT','Bothell','Canyon Park Business Center, 22121 17th Ave SE, Bldg E','Suite 220','Bothell','WA','98021','(425) 485-0085',47.7966018,-122.2098875);
INSERT INTO "office" VALUES('D000618-kalispell','D000618','DISTRICT','Kalispell','40 2nd St East, Suite 211',NULL,'Kalispell','MT','59901','(406) 257-3765',48.1966357,-114.3118812);
INSERT INTO "office" VALUES('D000618-bozeman','D000618','DISTRICT','Bozeman','13 S. Willson Ave. Ste. 8',NULL,'Bozeman','MT','59718','(406) 587-3446',45.6788798,-111.0390251);
INSERT INTO "office" VALUES('D000618-hardin','D000618','DISTRICT','Hardin','310 N Center',NULL,'Hardin','MT','59034','(406) 665-4126',45.731817,-107.606432);
INSERT INTO "office" VALUES('D000618-billings','D000618','DISTRICT','Billings','222 N. 32nd Street, Ste. 100',NULL,'Billings','MT','59101','(406) 245-6822',45.7810512,-108.5125313);
INSERT INTO "office" VALUES('D000618-missoula','D000618','DISTRICT','Missoula','218 East Front Street, Ste. 103',NULL,'Missoula','MT','59802','(406) 549-8198',46.8699041,-113.9930208);
INSERT INTO "office" VALUES('D000618-sidney','D000618','DISTRICT','Sidney','609 S. Central Ave. Suite #4','(Central Plaza Building)','Sidney','MT','59270','(406) 482-9010',47.7106368,-104.1606344);
INSERT INTO "office" VALUES('D000618-great-falls','D000618','DISTRICT','Great Falls','104 4th Street North, Ste. 302',NULL,'Great Falls','MT','59401','(406) 453-0148',47.5067244,-111.3009733);
INSERT INTO "office" VALUES('D000618-helena','D000618','DISTRICT','Helena','30 West 14th Street, Ste. 206',NULL,'Helena','MT','59601','(406) 443-3189',46.596642,-112.036443);
INSERT INTO "office" VALUES('D000618-washington','D000618','DC','Washington','320 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2651',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('D000619-maryville','D000619','DISTRICT','Maryville','15 Professional Park Drive',NULL,'Maryville','IL','62062','(618) 205-8660',38.737077,-89.9548986);
INSERT INTO "office" VALUES('D000619-champaign','D000619','DISTRICT','Champaign','2004 Fox Drive',NULL,'Champaign','IL','61820','(217) 403-4690',40.090932,-88.2501244);
INSERT INTO "office" VALUES('D000619-normal','D000619','DISTRICT','Normal','104 W. North Street',NULL,'Normal','IL','61761','(309) 252-8834',40.5094581,-88.9846312);
INSERT INTO "office" VALUES('D000619-taylorville','D000619','DISTRICT','Taylorville','108 W. Market St.',NULL,'Taylorville','IL','62568','(217) 824-5117',39.5480891,-89.2954995);
INSERT INTO "office" VALUES('D000619-springfield','D000619','DISTRICT','Springfield','2833 S Grand Ave. East',NULL,'Springfield','IL','62703','(217) 791-6224',39.7888553,-89.6124109);
INSERT INTO "office" VALUES('D000619-washington','D000619','DC','Washington','1740 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2371',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('D000619-decatur','D000619','DISTRICT','Decatur','243 S Water Street','Suite 100','Decatur','IL','62523','(217) 791-6224',39.8396384,-88.954852);
INSERT INTO "office" VALUES('D000620-hagerstown','D000620','DISTRICT','Hagerstown','38 South Potomac Street','Suite 205','Hagerstown','MD','21740','(301) 733-2900',39.6410348,-77.7207337);
INSERT INTO "office" VALUES('D000620-washington','D000620','DC','Washington','1632 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2721',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('D000620-gaithersburg','D000620','DISTRICT','Gaithersburg','9801 Washingtonian Boulevard','Suite 330','Gaithersburg','MD','20878','(301) 926-0300',39.1148145,-77.196095);
INSERT INTO "office" VALUES('D000621-st-augustine','D000621','DISTRICT','St. Augustine','3940 Lewis Speedway','Suite 2104','St. Augustine','FL','32084','(904) 827-1101',29.9393092,-81.339015);
INSERT INTO "office" VALUES('D000621-port-orange','D000621','DISTRICT','Port Orange','1000 City Center Circle',NULL,'Port Orange','FL','32129','(386) 756-9798',29.1265173,-81.0207249);
INSERT INTO "office" VALUES('D000621-washington','D000621','DC','Washington','1524 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2706',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000622-chicago','D000622','DISTRICT','Chicago','230 S Dearborn Suite 3900',NULL,'Chicago','IL','60604','(312) 886-3506',41.8784454,-87.63);
INSERT INTO "office" VALUES('D000622-washington','D000622','DC','Washington','524 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2854',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('D000622-springfield','D000622','DISTRICT','Springfield','8 South Old State Capitol Plaza',NULL,'Springfield','IL','62701','(217) 528-6124',39.800468,-8.96487140999999923031e+01);
INSERT INTO "office" VALUES('D000623-richmond','D000623','DISTRICT','Richmond','440 Civic Center Plaza','2nd Floor','Richmond','CA','94804','(510) 620-1000',37.9367699,-122.3428337);
INSERT INTO "office" VALUES('D000623-walnut-creek','D000623','DISTRICT','Walnut Creek','101 Ygnacio Valley Road','Suite #210','Walnut Creek','CA','94596','(925) 933-2660',37.9043441,-122.0688945);
INSERT INTO "office" VALUES('D000623-washington','D000623','DC','Washington','115 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2095',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000624-ypsilanti','D000624','DISTRICT','Ypsilanti','301 West Michigan Avenue','Suite 400','Ypsilanti','MI','48197','(734) 481-1100',42.2406978,-83.6164891);
INSERT INTO "office" VALUES('D000624-washington','D000624','DC','Washington','116 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4071',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000624-dearborn','D000624','DISTRICT','Dearborn','19855 West Outer Drive','Suite 103-E','Dearborn','MI','48124','(313) 278-2936',42.3034918,-83.2627983);
INSERT INTO "office" VALUES('D000625-brooklyn','D000625','DISTRICT','Brooklyn','7308 13th Avenue',NULL,'Brooklyn','NY','11228','(718) 630-5277',40.6213928,-74.0066707);
INSERT INTO "office" VALUES('D000625-staten-island','D000625','DISTRICT','Staten Island','265 New Dorp Lane, 2nd Floor',NULL,'Staten Island','NY','10306','(718) 351-1062',40.5725536,-74.1132361);
INSERT INTO "office" VALUES('D000625-washington','D000625','DC','Washington','1541 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3371',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('D000626-springfield','D000626','DISTRICT','Springfield','76 E. High Street','3rd Floor','Springfield','OH','45502','(937) 322-1120',39.9237363,-83.8097194);
INSERT INTO "office" VALUES('D000626-troy','D000626','DISTRICT','Troy','12 S. Plum Street',NULL,'Troy','OH','45373','(937) 339-1524',40.0401311,-84.2056989);
INSERT INTO "office" VALUES('D000626-washington','D000626','DC','Washington','1004 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-6205',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('D000626-west-chester','D000626','DISTRICT','West Chester','8857 Cincinnati-Dayton Rd.','Suite #102','West Chester','OH','45069','(513) 779-5400',39.3315731,-84.4063897);
INSERT INTO "office" VALUES('D000627-orlando','D000627','DISTRICT','Orlando','2295 S Hiawassee Rd','Suite 301','Orlando','FL','32835','(321) 388-9808',28.517804,-81.4818644);
INSERT INTO "office" VALUES('D000627-washington','D000627','DC','Washington','238 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2176',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000628-tallahassee','D000628','DISTRICT','Tallahassee','300 South Adams Street',NULL,'Tallahassee','FL','32301','(850) 891-8610',30.4395286,-84.2826688);
INSERT INTO "office" VALUES('D000628-washington','D000628','DC','Washington','423 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-5235',38.8868,-77.0085);
INSERT INTO "office" VALUES('D000628-panama-city','D000628','DISTRICT','Panama City','840 W. 11th St.','Suite 2250','Panama City','FL','32401','(850) 785-0812',30.167961,-85.671895);
INSERT INTO "office" VALUES('E000179-bronx','E000179','DISTRICT','Bronx','3655 Johnson Avenue',NULL,'Bronx','NY','10463','(718) 796-9700',40.8881337,-73.909585);
INSERT INTO "office" VALUES('E000179-westchester','E000179','DISTRICT','Westchester','6 Gramatan Avenue; Suite 205',NULL,'Mt. Vernon','NY','10550','(914) 699-4100',40.9124845,-73.8376727);
INSERT INTO "office" VALUES('E000179-coop-city','E000179','DISTRICT','Co-Op City','177 Dreiser Loop, Rm 3',NULL,'Bronx','NY','10475','(718) 320-2314',40.8777838,-73.8292461);
INSERT INTO "office" VALUES('E000179-washington','E000179','DC','Washington','2462 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2464',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('E000215-palo-alto','E000215','DISTRICT','Palo Alto','698 Emerson Street',NULL,'Palo Alto','CA','94301','(650) 323-2984',37.4431725,-122.1606451);
INSERT INTO "office" VALUES('E000215-washington','E000215','DC','Washington','241 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-8104',38.8868,-77.0085);
INSERT INTO "office" VALUES('E000285-cody','E000285','DISTRICT','Cody','1285 Sheridan Avenue','Suite 210','Cody','WY','82414','(307) 527-9444',44.5260698,-109.0624068);
INSERT INTO "office" VALUES('E000285-gillette','E000285','DISTRICT','Gillette','222 S. Gillette Avenue','Suite 503','Gillette','WY','82716','(307) 682-6268',44.2924295,-105.5045976);
INSERT INTO "office" VALUES('E000285-jackson','E000285','DISTRICT','Jackson','1110 Maple Way, Suite G',NULL,'Jaskson','WY','83002','(307) 739-9507',43.4700659,-110.7872894);
INSERT INTO "office" VALUES('E000285-cheyenne','E000285','DISTRICT','Cheyenne','Federal Center, Suite 2007','2120 Capitol Avenue','Cheyenne','WY','82001','(307) 772-2477',41.1374591,-104.8189674);
INSERT INTO "office" VALUES('E000285-casper','E000285','DISTRICT','Casper','Dick Cheney Federal Building','100 East B Street, Suite 3201','Casper','WY','82601','(307) 261-6572',42.8524124,-106.3248373);
INSERT INTO "office" VALUES('E000285-washington','E000285','DC','Washington','379a Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3424',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('E000288-minneapolis','E000288','DISTRICT','Minneapolis','2100 Plymouth Avenue N',NULL,'Minneapolis','MN','55411','(612) 522-1212',44.9918557,-93.3071661);
INSERT INTO "office" VALUES('E000288-washington','E000288','DC','Washington','2263 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4755',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('E000293-new-britain','E000293','DISTRICT','New Britain','1 Grove St.','Suite 600','New Britain','CT','06053','(860) 223-8412',41.6706549,-72.7867265);
INSERT INTO "office" VALUES('E000293-washington','E000293','DC','Washington','221 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4476',38.8868,-77.0085);
INSERT INTO "office" VALUES('E000294-otsego','E000294','DISTRICT','Otsego','9201 Quaday Ave. NE','Suite 206','Otsego','MN','55330','(763) 241-6848',45.2839958,-93.5648066);
INSERT INTO "office" VALUES('E000294-washington','E000294','DC','Washington','315 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2331',38.8868,-77.0085);
INSERT INTO "office" VALUES('E000295-sioux-city','E000295','DISTRICT','Sioux City','194 Federal Building','320 Sixth Street','Sioux City','IA','51101','(712) 252-1550',42.4963261,-96.4075837);
INSERT INTO "office" VALUES('E000295-council-bluffs','E000295','DISTRICT','Council Bluffs','221 Federal Building','8 South Sixth Street','Council Bluffs','IA','51501','(712) 352-1167',41.2608863,-95.8525576);
INSERT INTO "office" VALUES('E000295-des-moines','E000295','DISTRICT','Des Moines','733 Federal Building','210 Walnut Street','Des Moines','IA','50309','(515) 284-4574',41.5864152,-93.6201532);
INSERT INTO "office" VALUES('E000295-davenport','E000295','DISTRICT','Davenport','201 West Second Street','Suite 806','Davenport','IA','52801','(563) 322-0677',41.5213296,-90.5758645);
INSERT INTO "office" VALUES('E000295-cedar-rapids','E000295','DISTRICT','Cedar Rapids','111 Seventh Avenue SE','Suite 480','Cedar Rapids','IA','52401','(319) 365-4504',41.9731139,-91.6645212);
INSERT INTO "office" VALUES('E000295-washington','E000295','DC','Washington','111 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3254',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('E000296-philadelphia','E000296','DISTRICT','Philadelphia','7174 Ogontz Avenue',NULL,'Philadelphia','PA','19138','(215) 276-0340',40.063831,-75.153345);
INSERT INTO "office" VALUES('E000296-washington','E000296','DC','Washington','1105 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4001',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('E000297-washington','E000297','DC','Washington','1630 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4365',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('E000297-new-york','E000297','DISTRICT','New York','163 West 125th Street','Harlem State Office Building','New York','NY','10027','(212) 663-3900',40.8092263,-73.9474304);
INSERT INTO "office" VALUES('F000062-san-francisco','F000062','DISTRICT','San Francisco','One Post Street, Suite 2450',NULL,'San Francisco','CA','94104','(415) 393-0707',37.7887748,-122.4026656);
INSERT INTO "office" VALUES('F000062-san-diego','F000062','DISTRICT','San Diego','880 Front Street, Suite 4236',NULL,'San Diego','CA','92101','(619) 231-9712',32.7143481,-117.1647085);
INSERT INTO "office" VALUES('F000062-fresno','F000062','DISTRICT','Fresno','2500 Tulare Street, Suite 4290',NULL,'Fresno','CA','93721','(559) 485-7430',36.7374775,-119.7836709);
INSERT INTO "office" VALUES('F000062-washington','F000062','DC','Washington','331 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3841',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('F000062-los-angeles','F000062','DISTRICT','Los Angeles','11111 Santa Monica Blvd., Suite 915',NULL,'Los Angeles','CA','90025','(310) 914-7300',34.0476223,-118.444656);
INSERT INTO "office" VALUES('F000372-morristown','F000372','DISTRICT','Morristown','30 Schuyler Place, Second Floor',NULL,'Morristown','NJ','07960','(973) 984-0711',40.7964118,-74.4835583);
INSERT INTO "office" VALUES('F000372-washington','F000372','DC','Washington','2306 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5034',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('F000444-phoenix','F000444','DISTRICT','Phoenix','2200 East Camelback Road','Suite 120','Phoenix','AZ','85016','(602) 840-1891',33.5098565,-112.0338808);
INSERT INTO "office" VALUES('F000444-tucson','F000444','DISTRICT','Tucson','6840 North Oracle Road','Suite 150','Tucson','AZ','85704','(520) 575-8633',32.3316739,-110.976131);
INSERT INTO "office" VALUES('F000444-washington','F000444','DC','Washington','413 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-4521',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('F000448-glendale','F000448','DISTRICT','Glendale','7121 West Bell Road','Suite 200','Glendale','AZ','85308','(623) 776-7911',33.6372922,-112.2108385);
INSERT INTO "office" VALUES('F000448-washington','F000448','DC','Washington','2435 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4576',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('F000449-fremont','F000449','DISTRICT','Fremont','641 N. Broad Street',NULL,'Fremont','NE','68026','(402) 727-0888',41.4355946,-96.4988074);
INSERT INTO "office" VALUES('F000449-norfolk','F000449','DISTRICT','Norfolk','506 West Madison Avenue','Suite 2','Norfolk','NE','68701','(402) 379-2064',42.0317036,-97.4144702);
INSERT INTO "office" VALUES('F000449-washington','F000449','DC','Washington','1514 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4806',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('F000449-lincoln','F000449','DISTRICT','Lincoln','301 South 13th Street','Suite 100','Lincoln','NE','68508','(402) 438-1598',40.8108404,-96.7033345);
INSERT INTO "office" VALUES('F000450-boone','F000450','DISTRICT','Boone','400 Shadowline Dr, Suite 205',NULL,'Boone','NC','28607','(828) 265-0240',36.2033658,-81.6584959);
INSERT INTO "office" VALUES('F000450-clemmons','F000450','DISTRICT','Clemmons','3540 Clemmons Rd, Suite 125',NULL,'Clemmons','NC','27012','(336) 778-0211',36.0225285,-80.3758084);
INSERT INTO "office" VALUES('F000450-washington','F000450','DC','Washington','2262 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2071',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('F000454-aurora','F000454','DISTRICT','Aurora','2711 E New York Street','Suite 204','Aurora','IL','60502','(630) 585-7672',41.758276,-88.249771);
INSERT INTO "office" VALUES('F000454-washington','F000454','DC','Washington','1224 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3515',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('F000454-joliet','F000454','DISTRICT','Joliet','195 Springfield Avenue','Suite 102','Joliet','IL','60435','(815) 280-5876',41.5253876,-88.1380854);
INSERT INTO "office" VALUES('F000455-summit-county','F000455','DISTRICT','Summit County','1225 Lawton Street',NULL,'Akron','OH','44320','(330) 835-4758',41.080905,-81.565018);
INSERT INTO "office" VALUES('F000455-cuyahoga-county','F000455','DISTRICT','Cuyahoga County','4834 Richmond Road, Suite 150',NULL,'Warrensville Heights','OH','44128','(216) 522-4900',41.4286825,-81.4985324);
INSERT INTO "office" VALUES('F000455-washington','F000455','DC','Washington','2344 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-7032',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('F000457-duluth','F000457','DISTRICT','Duluth','515 W 1st St','Suite 104','Duluth','MN','55802','(218) 722-2390',46.7825784,-92.1068891);
INSERT INTO "office" VALUES('F000457-rochester','F000457','DISTRICT','Rochester','1202-1/2 7th Street NW','Suite 213','Rochester','MN','55901','(507) 288-2003',44.0316171,-92.4806419);
INSERT INTO "office" VALUES('F000457-saint-paul','F000457','DISTRICT','Saint Paul','60 East Plato Blvd','Suite 220','Saint Paul','MN','55107','(651) 221-1016',44.9373985,-93.0843011);
INSERT INTO "office" VALUES('F000457-washington','F000457','DC','Washington','309 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5641',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('F000457-moorhead','F000457','DISTRICT','Moorhead','819 Center Avenue','Suite 2A','Moorhead','MN','56560','(218) 284-8721',46.8750559,-96.7677958);
INSERT INTO "office" VALUES('F000459-chattanooga','F000459','DISTRICT','Chattanooga','900 Georgia Avenue, Suite 126',NULL,'Chattanooga','TN','37402','(423) 756-2342',35.0450875,-85.3082146);
INSERT INTO "office" VALUES('F000459-oak-ridge','F000459','DISTRICT','Oak Ridge','200 Administration Road, Suite 100',NULL,'Oak Ridge','TN','37830','(865) 576-1976',36.02409,-84.234908);
INSERT INTO "office" VALUES('F000459-washington','F000459','DC','Washington','2410 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3271',38.8868,-77.0085);
INSERT INTO "office" VALUES('F000459-athens','F000459','DISTRICT','Athens','6 East Madison Avenue',NULL,'Athens','TN','37303','(423) 745-4671',35.441192,-84.594681);
INSERT INTO "office" VALUES('F000460-victoria','F000460','DISTRICT','Victoria','5606 North Navarro Street','Suite 203','Victoria','TX','77904','(361) 894-6446',28.8476874,-96.9978986);
INSERT INTO "office" VALUES('F000460-washington','F000460','DC','Washington','2331 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-7742',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('F000460-corpus-christi','F000460','DISTRICT','Corpus Christi','101 N. Shoreline Blvd','Suite 300','Corpus Christi','TX','78401','(361) 884-2222',27.7917948,-97.3931982);
INSERT INTO "office" VALUES('F000461-waco','F000461','DISTRICT','Waco','400 Austin Avenue','Suite 302','Waco','TX','76701','(254) 732-0748',31.5572533,-97.130924);
INSERT INTO "office" VALUES('F000461-austinpflugerville','F000461','DISTRICT','Austin/Pflugerville','14205 Burnet Road','Suite 230','Austin','TX','78728','(512) 373-3378',30.4436527,-97.695721);
INSERT INTO "office" VALUES('F000461-washington','F000461','DC','Washington','2440 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6105',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('F000461-bryancollege-station','F000461','DISTRICT','Bryan/College Station','3000 Briarcrest Drive','Suite 406','Bryan','TX','77802','(979) 703-4037',30.6609467,-96.328648);
INSERT INTO "office" VALUES('F000462-boca-raton','F000462','DISTRICT','Boca Raton','2500 N. Military Trail, Suite 490',NULL,'Boca Raton','FL','33431','(561) 998-9045',26.3730924,-80.1203093);
INSERT INTO "office" VALUES('F000462-washington','F000462','DC','Washington','1037 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-9890',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('F000463-lincoln','F000463','DISTRICT','Lincoln','440 North 8th Street','Suite 120','Lincoln','NE','68508','(402) 441-4600',40.8177383,-96.7095183);
INSERT INTO "office" VALUES('F000463-omaha','F000463','DISTRICT','Omaha','11819 Miracle Hills Drive','Suite 205','Omaha','NE','68154','(402) 391-3411',41.2673318,-96.0980857);
INSERT INTO "office" VALUES('F000463-kearney','F000463','DISTRICT','Kearney','20 West 23rd Street',NULL,'Kearney','NE','68847','(308) 234-2361',40.6986843,-99.0819184);
INSERT INTO "office" VALUES('F000463-washington','F000463','DC','Washington','454 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-6551',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('F000463-scottsbluff','F000463','DISTRICT','Scottsbluff','1110 Circle Drive','Suite F2','Scottsbluff','NE','69361','(308) 630-2329',41.8680501,-103.6483008);
INSERT INTO "office" VALUES('F000464-kinderhook','F000464','DISTRICT','Kinderhook','2 Hudson St',NULL,'Kinderhook','NY','12106','(518) 610-8133',42.3947969,-73.698395);
INSERT INTO "office" VALUES('F000464-kingston','F000464','DISTRICT','Kingston','721 Broadway',NULL,'Kingston','NY','12401','(845) 514-2322',41.9310395,-74.0098026);
INSERT INTO "office" VALUES('F000464-washington','F000464','DC','Washington','1616 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5614',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('F000464-delhi','F000464','DISTRICT','Delhi','111 Main Street',NULL,'Delhi','NY','13753','(607) 746-9537',42.2774942,-74.9160098);
INSERT INTO "office" VALUES('F000465-newnan','F000465','DISTRICT','Newnan','1601 E Hwy 34','Suite B','Newnan','GA','30265','(770) 683-2033',33.3996108,-84.7263616);
INSERT INTO "office" VALUES('F000465-washington','F000465','DC','Washington','1032 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5901',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('F000466-washington','F000466','DC','Washington','514 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4276',38.8868,-77.0085);
INSERT INTO "office" VALUES('F000466-langhorne','F000466','DISTRICT','Langhorne','1717 Langhorne-Newtown Rd.','Suite 400','Langhorne','PA','19047','(215) 579-8102',40.2162341,-74.9308492);
INSERT INTO "office" VALUES('G000289-harrisonburg','G000289','DISTRICT','Harrisonburg','70 North Mason Street',NULL,'Harrisonburg','VA','22802','(540) 432-2391',38.4496778,-78.8661965);
INSERT INTO "office" VALUES('G000289-lynchburg','G000289','DISTRICT','Lynchburg','916 Main Street','Suite 300','Lynchburg','VA','24504','(434) 845-8306',37.4144164,-79.1415629);
INSERT INTO "office" VALUES('G000289-roanoke','G000289','DISTRICT','Roanoke','10 Franklin Road SE','Suite 540','Roanoke','VA','24011','(540) 857-2672',37.2696634,-79.9399357);
INSERT INTO "office" VALUES('G000289-staunton','G000289','DISTRICT','Staunton','117 South Lewis Street','Suite 215','Staunton','VA','24401','(540) 885-3861',38.1477382,-79.0742178);
INSERT INTO "office" VALUES('G000289-washington','G000289','DC','Washington','2309 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5431',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('G000359-washington','G000359','DC','Washington','290 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5972',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('G000359-pee-dee','G000359','DISTRICT','Pee Dee','McMillan Federal Building','401 West Evans Street, Suite 111','Florence','SC','29501','(843) 669-1505',34.1974074,-79.7733804);
INSERT INTO "office" VALUES('G000359-upstate','G000359','DISTRICT','Upstate','130 South Main Street, 7th Floor',NULL,'Greenville','SC','29601','(864) 250-1417',34.8487536,-82.4004437);
INSERT INTO "office" VALUES('G000359-midlands','G000359','DISTRICT','Midlands','508 Hampton Street, Suite 202',NULL,'Columbia','SC','29201','(803) 933-0112',34.0016459,-81.0461408);
INSERT INTO "office" VALUES('G000359-piedmont','G000359','DISTRICT','Piedmont','235 East Main Street, Suite 100',NULL,'Rock Hill','SC','29730','(803) 366-2828',34.9245162,-81.0247705);
INSERT INTO "office" VALUES('G000359-lowcountry','G000359','DISTRICT','Lowcountry','530 Johnnie Dodds Boulevard, Suite 202',NULL,'Mt. Pleasant','SC','29464','(843) 849-3887',32.8060149,-79.8879337);
INSERT INTO "office" VALUES('G000359-golden-corner','G000359','DISTRICT','Golden Corner','124 Exchange Street, Suite A',NULL,'Pendleton','SC','29670','(864) 646-4090',34.65072,-82.782997);
INSERT INTO "office" VALUES('G000377-fort-worth','G000377','DISTRICT','Fort Worth','1701 River Run Road Suite 407',NULL,'Fort Worth','TX','76107','(817) 338-0909',32.7270777,-97.3597301);
INSERT INTO "office" VALUES('G000377-washington','G000377','DC','Washington','1026 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5071',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('G000386-cedar-rapids','G000386','DISTRICT','Cedar Rapids','111 7th Avenue SE','Suite 6800','Cedar Rapids','IA','52401','(319) 363-6832',41.9731139,-91.6645212);
INSERT INTO "office" VALUES('G000386-council-bluffs','G000386','DISTRICT','Council Bluffs','307 Federal Building','8 South 6th Street','Council Bluffs','IA','51501','(712) 322-7103',41.2608863,-95.8525576);
INSERT INTO "office" VALUES('G000386-davenport','G000386','DISTRICT','Davenport','201 West 2nd Street','Suite 720','Davenport','IA','52801','(563) 322-4331',41.5213296,-90.5758645);
INSERT INTO "office" VALUES('G000386-des-moines','G000386','DISTRICT','Des Moines','721 Federal Building','210 Walnut Street','Des Moines','IA','50309','(515) 288-1145',41.5864152,-93.6201532);
INSERT INTO "office" VALUES('G000386-sioux-city','G000386','DISTRICT','Sioux City','120 Federal Building','320 6th Street','Sioux City','IA','51101','(712) 233-1860',42.4963125,-96.4075836);
INSERT INTO "office" VALUES('G000386-washington','G000386','DC','Washington','135 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3744',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('G000386-waterloo','G000386','DISTRICT','Waterloo','210 Waterloo Building','531 Commercial Street','Waterloo','IA','50701','(319) 232-6657',42.4953784,-92.339384);
INSERT INTO "office" VALUES('G000410-houston-north','G000410','DISTRICT','Houston North','256 North Sam Houston Parkway East','Suite 29','Houston','TX','77060','(281) 999-5879',29.9398853,-95.4046901);
INSERT INTO "office" VALUES('G000410-washington','G000410','DC','Washington','2470 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-1688',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('G000410-houston-east','G000410','DISTRICT','Houston East','11811 East Freeway','Suite 430','Houston','TX','77029-1974','(713) 330-0761',29.771125,-95.224792);
INSERT INTO "office" VALUES('G000535-chicago','G000535','DISTRICT','Chicago','3240 W. Fullerton Ave',NULL,'Chicago','IL','60647','(773) 342-0774',41.9249703,-87.7091868);
INSERT INTO "office" VALUES('G000535-washington','G000535','DC','Washington','2408 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-8203',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('G000546-kansas-city','G000546','DISTRICT','Kansas City','11724 NW Plaza Circle','Suite 900','Kansas City','MO','64153','(816) 792-3976',39.3060799,-94.684966);
INSERT INTO "office" VALUES('G000546-st-joseph','G000546','DISTRICT','St. Joseph','411 Jules Street','Room 111','St. Joseph','MO','64501','(816) 749-0800',39.7685973,-94.8548563);
INSERT INTO "office" VALUES('G000546-washington','G000546','DC','Washington','1135 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-7041',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('G000546-hannibal','G000546','DISTRICT','Hannibal','906 Broadway',NULL,'Hannibal','MO','63401','(573) 221-3400',39.7065377,-91.3643168);
INSERT INTO "office" VALUES('G000551-avondale','G000551','DISTRICT','Avondale','1412 N Central Ave, Suite B',NULL,'Avondale','AZ','85323','(623) 536-3388',33.4487419,-112.3501093);
INSERT INTO "office" VALUES('G000551-somerton','G000551','DISTRICT','Somerton','146 N. State Avenue',NULL,'Somerton','AZ','85350','(928) 343-7933',32.5960917,-114.7109846);
INSERT INTO "office" VALUES('G000551-tucson','G000551','DISTRICT','Tucson','738 N 5th Ave. Suite 110',NULL,'Tucson','AZ','85705','(520) 622-6788',32.2313653,-110.9668739);
INSERT INTO "office" VALUES('G000551-washington','G000551','DC','Washington','1511 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2435',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('G000552-longview','G000552','DISTRICT','Longview','101 East Methvin, Ste 302',NULL,'Longview','TX','75601','(903) 236-8597',32.4970151,-94.7389465);
INSERT INTO "office" VALUES('G000552-lufkin','G000552','DISTRICT','Lufkin','300 East Shepherd, Ste 210',NULL,'Lufkin','TX','75901','(936) 632-3180',31.3368848,-94.7268845);
INSERT INTO "office" VALUES('G000552-nacogdoches','G000552','DISTRICT','Nacogdoches','101 West Main, Ste 160',NULL,'Nacogdoches','TX','75961','(936) 715-9514',31.6036806,-94.6565524);
INSERT INTO "office" VALUES('G000552-tyler','G000552','DISTRICT','Tyler','1121 ESE Loop 323, Ste 206',NULL,'Tyler','TX','75701','(903) 561-6349',32.3031058,-95.2868686);
INSERT INTO "office" VALUES('G000552-washington','G000552','DC','Washington','2243 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3035',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('G000552-marshall','G000552','DISTRICT','Marshall','102 West Houston St.',NULL,'Marshall','TX','75670','(903) 938-8386',32.5447093,-94.367349);
INSERT INTO "office" VALUES('G000553-washington','G000553','DC','Washington','2347 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-7508',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('G000553-houston','G000553','DISTRICT','Houston','3003 South Loop West, Suite 460',NULL,'Houston','TX','77054','(713) 383-9234',29.6765115,-95.4252617);
INSERT INTO "office" VALUES('G000555-buffalo','G000555','DISTRICT','Buffalo','Larkin At Exchange','726 Exchange Street, Suite 511','Buffalo','NY','14210','(716) 854-9725',42.8747911,-78.851165);
INSERT INTO "office" VALUES('G000555-long-island','G000555','DISTRICT','Long Island','155 Pinelawn Road','Suite 250 North','Melville','NY','11747','(631) 249-2825',40.7707877,-73.4102476);
INSERT INTO "office" VALUES('G000555-rochester','G000555','DISTRICT','Rochester','Kenneth B. Keating Federal Office Building','100 State Street, Room 4195','Rochester','NY','14614','(585) 263-6250',43.1576631,-77.613515);
INSERT INTO "office" VALUES('G000555-syracusecentral-new-york','G000555','DISTRICT','Syracuse/Central New York','James M. Hanley Federal Building','100 South Clinton Street, Room 1470','Syracuse','NY','13261','(315) 448-0470',43.0501042,-76.1543204);
INSERT INTO "office" VALUES('G000555-new-york-city','G000555','DISTRICT','New York City','780 Third Avenue','Suite 2601','New York','NY','10017','(212) 688-6262',40.7550353,-73.9718588);
INSERT INTO "office" VALUES('G000555-albanycapital-district','G000555','DISTRICT','Albany/Capital District','Leo W. O''Brien Federal Office Building','11A Clinton Avenue, Room 821','Albany','NY','12207','(518) 431-0120',42.655222,-73.7492819);
INSERT INTO "office" VALUES('G000555-washington','G000555','DC','Washington','478 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-4451',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('G000558-bowling-green','G000558','DISTRICT','Bowling Green','996 Wilkinson Trace, Suite B2',NULL,'Bowling Green','KY','42103','(270) 842-9896',36.9671412,-86.4282633);
INSERT INTO "office" VALUES('G000558-washington','G000558','DC','Washington','2434 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3501',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('G000559-davis','G000559','DISTRICT','Davis','412 G Street',NULL,'Davis','CA','95616','(530) 753-5301',38.5466673,-121.7395708);
INSERT INTO "office" VALUES('G000559-fairfield','G000559','DISTRICT','Fairfield','1261 Travis Blvd. Suite 130',NULL,'Fairfield','CA','94533','(707) 438-1822',38.2576953,-122.0494716);
INSERT INTO "office" VALUES('G000559-yuba-city','G000559','DISTRICT','Yuba City','795 Plumas Street',NULL,'Yuba City','CA','95991','(530) 329-8865',39.1396913,-121.6173255);
INSERT INTO "office" VALUES('G000559-washington','G000559','DC','Washington','2438 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-1880',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('G000560-dalton','G000560','DISTRICT','Dalton','702 South Thornton Avenue',NULL,'Dalton','GA','30720','(706) 226-5320',34.7627274,-84.9720332);
INSERT INTO "office" VALUES('G000560-rome','G000560','DISTRICT','Rome','600 E. First Street Suite 30',NULL,'Rome','GA','30161','(706) 290-1776',34.2553159,-85.1670568);
INSERT INTO "office" VALUES('G000560-washington','G000560','DC','Washington','2078 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5211',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('G000562-pueblo','G000562','DISTRICT','Pueblo','503 N. Main St., Ste. 426',NULL,'Pueblo','CO','81003','(719) 543-1324',38.2720307,-104.60937);
INSERT INTO "office" VALUES('G000562-yuma','G000562','DISTRICT','Yuma','529 N. Albany St., Ste. 1220',NULL,'Yuma','CO','80759','(970) 848-3095',40.1304123,-102.7221695);
INSERT INTO "office" VALUES('G000562-durango','G000562','DISTRICT','Durango','329 S.Camino Del Rio','Suite. #1','Durango','CO','81303','(970) 259-1231',37.2509136,-107.8778701);
INSERT INTO "office" VALUES('G000562-denver','G000562','DISTRICT','Denver','1125 17th St., Ste. 525',NULL,'Denver','CO','80202','(303) 391-5777',39.7494865,-104.994834);
INSERT INTO "office" VALUES('G000562-greeley','G000562','DISTRICT','Greeley','801 8th St., Ste. 140A',NULL,'Greeley','CO','80631','(970) 352-5546',40.425174,-104.6910459);
INSERT INTO "office" VALUES('G000562-colorado-springs','G000562','DISTRICT','Colorado Springs','102 S. Tejon St., Ste. 930',NULL,'Colorado Springs','CO','80903','(719) 632-6706',38.8319995,-104.8240571);
INSERT INTO "office" VALUES('G000562-washington','G000562','DC','Washington','354 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5941',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('G000562-fort-collins','G000562','DISTRICT','Fort Collins','2001 S. Shields St.,','Building H, Ste. 104','Fort Collins','CO','80526','(970) 484-3502',40.5607326,-105.0969106);
INSERT INTO "office" VALUES('G000562-grand-junction','G000562','DISTRICT','Grand Junction','400 Rood Ave','Federal Building, Suite 220','Grand Junction','CO','81501','(970) 245-9553',39.0685649,-108.5657085);
INSERT INTO "office" VALUES('G000563-canton','G000563','DISTRICT','Canton','110 Central Plaza South',NULL,'Canton','OH','44702','(330) 737-1631',40.797956,-81.374289);
INSERT INTO "office" VALUES('G000563-ashland','G000563','DISTRICT','Ashland','110 Cottage St.',NULL,'Ashland','OH','44805','(419) 207-0650',40.8690512,-82.318261);
INSERT INTO "office" VALUES('G000563-washington','G000563','DC','Washington','2446 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6265',38.8868,-77.0085);
INSERT INTO "office" VALUES('G000565-gold-canyon','G000565','DISTRICT','Gold Canyon','6499 S. Kings Ranch Road, #4',NULL,'Gold Canyon','AZ','85118','(480) 882-2697',33.3557193,-111.4526421);
INSERT INTO "office" VALUES('G000565-kingman','G000565','DISTRICT','Kingman','220 N. 4th Street',NULL,'Kingman','AZ','86401',NULL,35.1904088,-114.0525545);
INSERT INTO "office" VALUES('G000565-prescott','G000565','DISTRICT','Prescott','122 N. Cortez Street, Suite 104',NULL,'Prescott','AZ','86301','(928) 445-1683',34.5427185,-112.4690897);
INSERT INTO "office" VALUES('G000565-washington','G000565','DC','Washington','2057 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2315',38.8868,-77.0085);
INSERT INTO "office" VALUES('G000566-greenville','G000566','DISTRICT','Greenville','104 South Main St',NULL,'Greenville','SC','29601','(864) 241-0175',34.849407,-82.40024);
INSERT INTO "office" VALUES('G000566-washington','G000566','DC','Washington','2418 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-6030',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('G000566-spartanburg','G000566','DISTRICT','Spartanburg','101 West St. John St.',NULL,'Spartanburg','SC','29306','(864) 583-3264',34.9509114,-81.9333968);
INSERT INTO "office" VALUES('G000568-abingdon','G000568','DISTRICT','Abingdon','323 West Main Street',NULL,'Abingdon','VA','24210','(276) 525-1405',36.7086253,-81.9811305);
INSERT INTO "office" VALUES('G000568-christiansburg','G000568','DISTRICT','Christiansburg','17 West Main Street',NULL,'Christiansburg','VA','24073','(540) 381-5671',37.1296267,-80.4095978);
INSERT INTO "office" VALUES('G000568-big-stone-gap','G000568','DISTRICT','Big Stone Gap','Federal Courthouse',NULL,'Big Stone Gap','VA','24219','(276) 525-1405',36.8586404,-82.7832489);
INSERT INTO "office" VALUES('G000568-washington','G000568','DC','Washington','2202 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3861',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('G000571-hawaii','G000571','DISTRICT','HawaiʻI','300 Ala Moana Blvd., Rm. 5-104',NULL,'Honolulu','HI','96850','(808) 541-1986',21.3036893,-157.862353);
INSERT INTO "office" VALUES('G000571-washington','G000571','DC','Washington','1433 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4906',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('G000574-phoenix','G000574','DISTRICT','Phoenix','411 N. Central Ave','Suite 150','Phoenix','AZ','85004','(602) 256-0551',33.452957,-112.0734511);
INSERT INTO "office" VALUES('G000574-washington','G000574','DC','Washington','1218 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4065',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('G000576-fond-du-lac','G000576','DISTRICT','Fond du Lac','24 West Pioneer Rd.',NULL,'Fond du Lac','WI','54935','(920) 907-0624',43.7522376,-88.4509945);
INSERT INTO "office" VALUES('G000576-washington','G000576','DC','Washington','1217 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2476',38.8868,-77.0085);
INSERT INTO "office" VALUES('G000577-baton-rouge','G000577','DISTRICT','Baton Rouge','2351 Energy Drive','Suite 1200','Baton Rouge','LA','70808','(225) 442-1731',30.4265187,-91.1316524);
INSERT INTO "office" VALUES('G000577-livingston','G000577','DISTRICT','Livingston','Livingston Parish Government Building','29261 Frost Rd, 2nd Floor','Livingston','LA','70754','(225) 686-4413',30.4830241,-90.7486419);
INSERT INTO "office" VALUES('G000577-washington','G000577','DC','Washington','430 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-3901',38.8868,-77.0085);
INSERT INTO "office" VALUES('G000577-thibodaux','G000577','DISTRICT','Thibodaux','908 East 1st Street','NSU Campus, Candies Hall, Suite 405','Thibodaux','LA','70301','(985) 448-4103',29.795623,-90.8011997);
INSERT INTO "office" VALUES('G000578-pensacola','G000578','DISTRICT','Pensacola','226 S Palafox Pl','6th Floor','Pensacola','FL','32502','(850) 479-1183',30.4094572,-87.2143001);
INSERT INTO "office" VALUES('G000578-washington','G000578','DC','Washington','507 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4136',38.8868,-77.0085);
INSERT INTO "office" VALUES('G000578-fort-walton-beach','G000578','DISTRICT','Fort Walton Beach','1170 Martin Luther King, Jr. Blvd','Bldg. 4, Rm 454','Fort Walton Beach','FL','32547','(850) 479-1183',30.4533919,-86.6530906);
INSERT INTO "office" VALUES('G000579-appleton','G000579','DISTRICT','Appleton','333 W. College Ave',NULL,'Appleton','WI','54911','(920) 903-9806',44.2614778,-88.4094435);
INSERT INTO "office" VALUES('G000579-washington','G000579','DC','Washington','1007 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5665',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('G000579-green-bay','G000579','DISTRICT','Greey Bay','1915 S. Webster Avenue','Suite D','Green Bay','WI','54301','(920) 301-4500',44.4852063,-88.0200192);
INSERT INTO "office" VALUES('G000580-danville','G000580','DISTRICT','Danville','308 Craghead Street','Suite 102D','Danville','VA','24541','(434) 791-2596',36.5867166,-79.389396);
INSERT INTO "office" VALUES('G000580-charlottesville','G000580','DISTRICT','Charlottesville','686 Berkmar Circle','2nd Floor','Charlottesville','VA','22901','(434) 973-9631',38.0847006,-78.4784307);
INSERT INTO "office" VALUES('G000580-washington','G000580','DC','Washington','415 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4711',38.8868,-77.0085);
INSERT INTO "office" VALUES('G000581-washington','G000581','DC','Washington','113 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2531',38.8868,-77.0085);
INSERT INTO "office" VALUES('G000581-edinburg','G000581','DISTRICT','Edinburg','2864 West Trenton Rd',NULL,'Edinburg','TX','78539','(956) 682-5545',26.2658508,-98.2010279);
INSERT INTO "office" VALUES('G000582-san-juan','G000582','DISTRICT','San Juan','Edificio Antigua Escuela','Medicina Tropical','San Juan','PR','00901',NULL,18.4669792,-66.1040007);
INSERT INTO "office" VALUES('G000582-washington','G000582','DC','Washington','1529 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2615',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('G000583-glen-rock','G000583','DISTRICT','Glen Rock','65 Harristown Rd','Suite 104','Glen Rock','NJ','07452','(201) 389-1100',40.9506625,-74.143801);
INSERT INTO "office" VALUES('G000583-washington','G000583','DC','Washington','213 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4465',38.8868,-77.0085);
INSERT INTO "office" VALUES('G000583-newton','G000583','DISTRICT','Newton','93 Spring Street','Suite 408','Newton','NJ','07860','(973) 814-4078',41.058088,-7.47518489999999928823e+01);
INSERT INTO "office" VALUES('H000324-palm-beach-county','H000324','DISTRICT','Palm Beach County','Town of Mangonia Park Municipal Center','1755 East Tiffany Drive','Mangonia Park','FL','33407','(561) 469-7048',26.7555179,-80.081968);
INSERT INTO "office" VALUES('H000324-broward-county','H000324','DISTRICT','Broward County','2701 W. Oakland Park Blvd, Suite 200',NULL,'Fort Lauderdale','FL','33311','(954) 733-2800',26.165965,-80.1797155);
INSERT INTO "office" VALUES('H000324-washington','H000324','DC','Washington','2353 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-1313',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('H000338-salt-lake-city','H000338','DISTRICT','Salt Lake City','8402 Federal Building','125 South State Street','Salt Lake City','UT','84138','(801) 524-4380',40.7667476,-111.8871382);
INSERT INTO "office" VALUES('H000338-st-george','H000338','DISTRICT','St. George','Federal Building','196 East Tabernacle, Rm 14','St. George','UT','84770','(435) 634-1795',37.107876,-113.579673);
INSERT INTO "office" VALUES('H000338-cedar-city','H000338','DISTRICT','Cedar City','77 N. Main Street','Suite 112','Cedar City','UT','84720','(435) 586-8435',37.6787282,-113.0619776);
INSERT INTO "office" VALUES('H000338-provo','H000338','DISTRICT','Provo','51 S. University Ave.','Suite 320','Provo','UT','84601','(801) 375-7881',40.232986,-111.6578512);
INSERT INTO "office" VALUES('H000338-ogden','H000338','DISTRICT','Ogden','1006 Federal Building','324 25th Street','Ogden','UT','84401','(801) 625-5672',41.2206915,-111.9726124);
INSERT INTO "office" VALUES('H000338-washington','H000338','DC','Washington','104 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5251',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('H000874-greenbelt','H000874','DISTRICT','Greenbelt','U.S. District Courthouse','6500 Cherrywood Lane, Suite 310','Greenbelt','MD','20770','(301) 474-0119',39.0089504,-76.8952351);
INSERT INTO "office" VALUES('H000874-waldorf','H000874','DISTRICT','Waldorf','401 Post Office Road, Ste. 202',NULL,'Waldorf','MD','20602','(301) 843-1577',38.6112157,-76.9022185);
INSERT INTO "office" VALUES('H000874-washington','H000874','DC','Washington','1705 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4131',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001036-athens','H001036','DISTRICT','Athens','810 East Corsicana Street, Suite C',NULL,'Athens','TX','75751','(903) 675-8288',32.2039064,-95.8422855);
INSERT INTO "office" VALUES('H001036-washington','H001036','DC','Washington','2228 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3484',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('H001036-dallas','H001036','DISTRICT','Dallas','6510 Abrams Road, Suite 243',NULL,'Dallas','TX','75231','(214) 349-9996',32.8630659,-96.7436031);
INSERT INTO "office" VALUES('H001038-buffalo','H001038','DISTRICT','Buffalo','726 Exchange Street, Suite 601',NULL,'Buffalo','NY','14210','(716) 852-3501',42.8747911,-78.851165);
INSERT INTO "office" VALUES('H001038-niagara-falls','H001038','DISTRICT','Niagara Falls','800 Main Street','Suite 3C','Niagara Falls','NY','14301','(716) 282-1274',43.0967702,-79.0554227);
INSERT INTO "office" VALUES('H001038-washington','H001038','DC','Washington','2459 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3306',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('H001041-elko','H001041','DISTRICT','Elko','3920 E. Idaho Street, Suite 2A',NULL,'Elko','NV','89801','(775) 738-2001',40.8639086,-115.7337943);
INSERT INTO "office" VALUES('H001041-reno','H001041','DISTRICT','Reno','Bruce Thompson Federal Building','400 S. Virginia Street, Suite 738','Reno','NV','89501','(775) 686-5770',39.5215352,-119.810287);
INSERT INTO "office" VALUES('H001041-las-vegas','H001041','DISTRICT','Las Vegas','8930 West Sunset Road','Suite 230','Las Vegas','NV','89148','(702) 388-6605',36.0718617,-115.2870903);
INSERT INTO "office" VALUES('H001041-washington','H001041','DC','Washington','324 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-6244',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('H001042-hawaii','H001042','DISTRICT','Hawaii','300 Ala Moana Blvd. Rm. 3-106',NULL,'Honolulu','HI','96850','(808) 522-8970',21.3036893,-157.862353);
INSERT INTO "office" VALUES('H001042-washington','H001042','DC','Washington','730 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-6361',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('H001045-brookhaven','H001045','DISTRICT','Brookhaven','230 South Whitworth St.',NULL,'Brookhaven','MS','39601','(601) 823-3400',31.5774837,-90.4440201);
INSERT INTO "office" VALUES('H001045-pearl','H001045','DISTRICT','Pearl','2507-A Old Brandon Rd.',NULL,'Pearl','MS','39208','(601) 932-2410',32.2751731,-90.1296633);
INSERT INTO "office" VALUES('H001045-starkville','H001045','DISTRICT','Starkville','The Mill at Mississippi State','600 Russell St., Suite 160','Starkville','MS','39759','(662) 324-0007',33.4573663,-88.8027055);
INSERT INTO "office" VALUES('H001045-meridian','H001045','DISTRICT','Meridian','1901 Front St., Suite A',NULL,'Meridian','MS','39301','(601) 693-6681',32.3639891,-88.6963131);
INSERT INTO "office" VALUES('H001045-washington','H001045','DC','Washington','2227 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5031',38.8868,-77.0085);
INSERT INTO "office" VALUES('H001046-albuquerque','H001046','DISTRICT','Albuquerque','400 Gold Avenue SW, Ste. 1080',NULL,'Albuquerque','NM','87102','(505) 346-6601',35.0833514,-106.6521937);
INSERT INTO "office" VALUES('H001046-farmington','H001046','DISTRICT','Farmington','7450 East Main St., Ste. A',NULL,'Farmington','NM','87402','(505) 325-5030',36.7863602,-108.1112628);
INSERT INTO "office" VALUES('H001046-roswell','H001046','DISTRICT','Roswell','200 East 4th St., Ste. 300',NULL,'Roswell','NM','88201','(575) 622-7113',33.39647,-104.521106);
INSERT INTO "office" VALUES('H001046-las-cruces','H001046','DISTRICT','Las Cruces','Loretto Towne Center','505 South Main St., Ste. 148','Las Cruces','NM','88001','(575) 523-6561',32.3041597,-106.7758242);
INSERT INTO "office" VALUES('H001046-santa-fe','H001046','DISTRICT','Santa Fe','123 East Marcy St., Ste. 103',NULL,'Santa Fe','NM','87501','(505) 988-6647',35.6889043,-105.9354058);
INSERT INTO "office" VALUES('H001046-washington','H001046','DC','Washington','303 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5521',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('H001047-stamford','H001047','DISTRICT','Stamford','888 Washington Boulevard, 10th Floor',NULL,'Stamford','CT','06901','(203) 353-9400',41.0514745,-73.5428955);
INSERT INTO "office" VALUES('H001047-bridgeport','H001047','DISTRICT','Bridgeport','211 State Street, 2nd Floor',NULL,'Bridgeport','CT','06604','(203) 333-6600',41.1763593,-73.1898756);
INSERT INTO "office" VALUES('H001047-washington','H001047','DC','Washington','1227 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5541',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001048-el-cajon','H001048','DISTRICT','El Cajon','1611 N. Magnolia Ave., Ste 310',NULL,'El Cajon','CA','92020','(619) 448-5201',32.820926,-116.9614599);
INSERT INTO "office" VALUES('H001048-temecula','H001048','DISTRICT','Temecula','41000 Main St.',NULL,'Temecula','CA','92590','(951) 695-5108',33.4941712,-117.1470449);
INSERT INTO "office" VALUES('H001048-washington','H001048','DC','Washington','2429 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-5672',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('H001050-honolulu','H001050','DISTRICT','Honolulu','300 Ala Moana Blvd.','Room 4-104','Honolulu','HI','96850','(808) 541-2570',21.3036893,-157.862353);
INSERT INTO "office" VALUES('H001050-washington','H001050','DC','Washington','422 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2726',38.8868,-77.0085);
INSERT INTO "office" VALUES('H001052-bel-air','H001052','DISTRICT','Bel Air','15 East Churchville Road Suite 102B',NULL,'Bel Air','MD','21014','(410) 588-5670',39.535151,-76.3464629);
INSERT INTO "office" VALUES('H001052-chester','H001052','DISTRICT','Chester','100 Olde Point Village Suite 101',NULL,'Chester','MD','21619','(410) 643-5425',38.975324,-76.28993);
INSERT INTO "office" VALUES('H001052-washington','H001052','DC','Washington','1533 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5311',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001052-salisbury','H001052','DISTRICT','Salisbury','100 East Main Street, Suite 702',NULL,'Salisbury','MD','21801','(443) 944-8624',38.3652997,-75.600858);
INSERT INTO "office" VALUES('H001053-harrisonville','H001053','DISTRICT','Harrisonville','1909 North Commercial Street',NULL,'Harrisonville','MO','64701','(816) 884-3411',38.6630256,-94.3644632);
INSERT INTO "office" VALUES('H001053-lebanon','H001053','DISTRICT','Lebanon','219 North Adams Street',NULL,'Lebanon','MO','65536','(417) 532-5582',37.6821821,-92.6645922);
INSERT INTO "office" VALUES('H001053-washington','H001053','DC','Washington','2235 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2876',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('H001053-columbia','H001053','DISTRICT','Columbia','2415 Carter Lane, Suite 4',NULL,'Columbia','MO','65201','(573) 442-9311',38.9230515,-92.3365352);
INSERT INTO "office" VALUES('H001056-chehalis','H001056','DISTRICT','Chehalis','Chehalis City Hall Building','350 N. Market Blvd','Chehalis','WA','98532',NULL,46.6639928,-122.9672327);
INSERT INTO "office" VALUES('H001056-washington','H001056','DC','Washington','1107 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3536',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001056-vancouver','H001056','DISTRICT','Vancouver','O.O. Howard House (Officers’ Row)','750 Anderson Street, Suite B','Vancouver','WA','98661','(360) 695-6292',45.6281298,-122.6643142);
INSERT INTO "office" VALUES('H001058-grand-haven','H001058','DISTRICT','Grand Haven','1 South Harbor Ave. Suite 6B',NULL,'Grand Haven','MI','49417','(616) 414-5516',43.0647606,-86.2346593);
INSERT INTO "office" VALUES('H001058-washington','H001058','DC','Washington','2232 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4401',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001058-grandville','H001058','DISTRICT','Grandville','4555 Wilson Ave. SW Suite 3',NULL,'Grandville','MI','49418','(616) 570-0917',42.881882,-85.763622);
INSERT INTO "office" VALUES('H001059-campton-hills','H001059','DISTRICT','Campton Hills','40W310 Lafox Road, #F2',NULL,'Campton Hills','IL','60175','(630) 584-2734',41.9356063,-88.4006984);
INSERT INTO "office" VALUES('H001059-washington','H001059','DC','Washington','2455 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2976',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('H001061-bismarck','H001061','DISTRICT','Bismarck','U.S. Federal Building','220 East Rosser Ave., Room 312','Bismarck','ND','58501','(701) 250-4618',46.8090113,-100.7882597);
INSERT INTO "office" VALUES('H001061-grand-forks','H001061','DISTRICT','Grand Forks','Federal Building','102 North Fourth St., Room 108','Grand Forks','ND','58203','(701) 746-8972',47.9255358,-97.0327393);
INSERT INTO "office" VALUES('H001061-fargo','H001061','DISTRICT','Fargo','1802 32nd Ave. South','Room B','Fargo','ND','58103','(701) 239-5389',46.832277,-96.8111195);
INSERT INTO "office" VALUES('H001061-minot','H001061','DISTRICT','Minot','100 1st Street SW','Suite 107','Minot','ND','58701','(701) 838-1361',48.2351551,-101.2950057);
INSERT INTO "office" VALUES('H001061-washington','H001061','DC','Washington','338 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2551',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('H001064-thurston-and-mason-county','H001064','DISTRICT','Thurston and Mason County','420 College Street SE',NULL,'Lacey','WA','98503','(360) 459-8514',47.0448705,-122.8223848);
INSERT INTO "office" VALUES('H001064-washington','H001064','DC','Washington','425 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-9740',38.8868,-77.0085);
INSERT INTO "office" VALUES('H001064-pierce-county','H001064','DISTRICT','Pierce County','6000 Main Street SW','Suite 3B','Lakewood','WA','98499','(253) 722-5860',47.1615029,-122.51552);
INSERT INTO "office" VALUES('H001065-fremont','H001065','DISTRICT','Fremont','120 Main Street',NULL,'Fremont','NC','27830','(919) 440-5247',35.5436158,-77.9743557);
INSERT INTO "office" VALUES('H001065-washington','H001065','DC','Washington','1110 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3032',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001065-raleigh','H001065','DISTRICT','Raleigh','3725 National Drive','Suite 101','Raleigh','NC','27612','(919) 782-4400',35.8346419,-78.6666549);
INSERT INTO "office" VALUES('H001067-rockingham','H001067','DISTRICT','Rockingham','1015 Fayetteville Rd',NULL,'Rockingham','NC','28379','(910) 997-2070',34.943077,-79.761606);
INSERT INTO "office" VALUES('H001067-concord','H001067','DISTRICT','Concord','325 McGill Avenue, NW','Suite 500','Concord','NC','28027','(704) 786-1612',35.4150032,-80.6027893);
INSERT INTO "office" VALUES('H001067-washington','H001067','DC','Washington','429 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-3715',38.8868,-77.0085);
INSERT INTO "office" VALUES('H001068-san-rafael','H001068','DISTRICT','San Rafael','999 Fifth Ave.','Suite 290','San Rafael','CA','94901','(415) 258-9657',37.9738069,-122.5267);
INSERT INTO "office" VALUES('H001068-eureka','H001068','DISTRICT','Eureka','317 Third St.','Suite 1','Eureka','CA','95501','(707) 407-3585',40.8035929,-124.1682054);
INSERT INTO "office" VALUES('H001068-petaluma','H001068','DISTRICT','Petaluma','206 G Street, Unit #3',NULL,'Petaluma','CA','94952','(707) 981-8967',38.2315024,-122.6330448);
INSERT INTO "office" VALUES('H001068-ukiah','H001068','DISTRICT','Ukiah','559 Low Gap Road',NULL,'Ukiah','CA','95482','(707) 671-7449',39.1598605,-123.2154259);
INSERT INTO "office" VALUES('H001068-washington','H001068','DC','Washington','1406 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5161',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001068-fort-bragg','H001068','DISTRICT','Fort Bragg','430 North Franklin St.',NULL,'Fort Bragg','CA','95437','(707) 962-0933',39.4461329,-123.8042883);
INSERT INTO "office" VALUES('H001069-bismarck','H001069','DISTRICT','Bismarck','228 Federal Building','220 East Rosser Avenue','Bismarck','ND','58501','(701) 258-4648',46.8090113,-100.7882597);
INSERT INTO "office" VALUES('H001069-minot','H001069','DISTRICT','Minot','105 Federal Building','100 First Street SW','Minot','ND','58701','(701) 852-0703',48.2351551,-101.2950057);
INSERT INTO "office" VALUES('H001069-fargo','H001069','DISTRICT','Fargo','306 Federal Building','657 Second Avenue North','Fargo','ND','58102','(701) 232-8030',46.878685,-96.790097);
INSERT INTO "office" VALUES('H001069-dickinson','H001069','DISTRICT','Dickinson','40 1st Ave West, Suite 202',NULL,'Dickinson','ND','58601','(701) 225-0974',46.8795958,-102.786515);
INSERT INTO "office" VALUES('H001069-grand-forks','H001069','DISTRICT','Grand Forks','33 South Third Street Suite B',NULL,'Grand Forks','ND','58201','(701) 775-9601',47.9250077,-97.0295224);
INSERT INTO "office" VALUES('H001069-washington','H001069','DC','Washington','516 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-2043',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('H001071-thomson','H001071','DISTRICT','Thomson','210 Railroad Street','City-County Administration Room 2401','Thomson','GA','30824','(770) 207-1776',33.4671424,-82.4986906);
INSERT INTO "office" VALUES('H001071-monroe','H001071','DISTRICT','Monroe','100 Court St',NULL,'Monroe','GA','30655','(770) 207-1776',33.7942004,-83.7130977);
INSERT INTO "office" VALUES('H001071-washington','H001071','DC','Washington','324 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4101',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001072-conway','H001072','DISTRICT','Conway','1105 Deer Street','Suite 12','Conway','AR','72032','(501) 358-3481',35.0868894,-92.4381401);
INSERT INTO "office" VALUES('H001072-little-rock','H001072','DISTRICT','Little Rock','1501 N. University Ave.','Suite 150','Little Rock','AR','72207','(501) 324-5941',34.7651263,-92.3397715);
INSERT INTO "office" VALUES('H001072-washington','H001072','DC','Washington','1229 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2506',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001073-del-rio','H001073','DISTRICT','Del Rio','1104 West 10th',NULL,'Del Rio','TX','78840','(830) 422-2040',29.3705708,-100.9202206);
INSERT INTO "office" VALUES('H001073-eagle-pass','H001073','DISTRICT','Eagle Pass','100 Monroe Street',NULL,'Eagle Pass','TX','78852','(830) 491-7003',28.706671,-100.50032);
INSERT INTO "office" VALUES('H001073-socorro','H001073','DISTRICT','Socorro','124 South Horizon',NULL,'Socorro','TX','79927','(915) 235-6421',31.6495216,-106.2845808);
INSERT INTO "office" VALUES('H001073-washington','H001073','DC','Washington','317 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4511',38.8868,-77.0085);
INSERT INTO "office" VALUES('H001073-san-antonio-northside','H001073','DISTRICT','San Antonio Northside','17721 Rogers Ranch Parkway','Suite 120','San Antonio','TX','78258','(210) 921-3130',29.6043724,-98.5350201);
INSERT INTO "office" VALUES('H001073-san-antonio-southside','H001073','DISTRICT','San Antonio Southside','Texas A&M San Antonio Patriots'' Casa','One University Way, Suite 202A','San Antonio','TX','78224','(210) 784-5023',29.3113119,-98.5246584);
INSERT INTO "office" VALUES('H001074-washington','H001074','DC','Washington','1641 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5315',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001074-jeffersonville','H001074','DISTRICT','Jeffersonville','279 Quartermaster Court',NULL,'Jeffersonville','IN','47130','(812) 288-3999',38.2842945,-85.7413663);
INSERT INTO "office" VALUES('H001074-greenwood','H001074','DISTRICT','Greenwood','720 Executive Park Dr.','Suite 3000B','Greenwood','IN','46143','(317) 851-8710',3.96053469999999876441e+01,-86.1107229);
INSERT INTO "office" VALUES('H001075-sacramento','H001075','DISTRICT','Sacramento','501 I Street','Suite 7-600','Sacramento','CA','95814','(916) 448-2787',38.583455,-121.4987519);
INSERT INTO "office" VALUES('H001075-fresno','H001075','DISTRICT','Fresno','2500 Tulare Street','Suite 5290','Fresno','CA','93721','(916) 448-2787',36.7374775,-119.7836709);
INSERT INTO "office" VALUES('H001075-san-francisco','H001075','DISTRICT','San Francisco','50 United Nations Plaza','Suite 5584','San Francisco','CA','94102','(213) 894-5000',37.7804298,-122.4144643);
INSERT INTO "office" VALUES('H001075-san-diego','H001075','DISTRICT','San Diego','600 B Street','Suite 2240','San Diego','CA','92101','(213) 894-5000',32.7182014,-117.1587103);
INSERT INTO "office" VALUES('H001075-los-angeles','H001075','DISTRICT','Los Angeles','312 N. Spring St.','Suite 1748','Los Angeles','CA','90012','(213) 894-5000',34.0552049,-118.241422);
INSERT INTO "office" VALUES('H001075-washington','H001075','DC','Washington','112 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3553',38.8928369,-77.0051216);
INSERT INTO "office" VALUES('H001076-washington','H001076','DC','Washington','B85 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3324',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('H001076-manchester','H001076','DISTRICT','Manchester','1589 Elm Street','Third Floor','Manchester','NH','03101','(603) 622-2204',42.9813958,-7.14722939999999908869e+01);
INSERT INTO "office" VALUES('H001076-portsmouth','H001076','DISTRICT','Portsmouth','14 Manchester Square','Suite #140','Portsmouth','NH','03801','(603) 433-4445',43.0856076,-70.8098029);
INSERT INTO "office" VALUES('H001077-washington','H001077','DC','Washington','1711 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-2031',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('H001077-Lafayette','H001077','DISTRICT','Lafayette','600 Jefferson Street','Suite 808','Lafayette','LA','70501','(337) 703-6105',30.22335,-92.01907);
INSERT INTO "office" VALUES('H001077-lake-charles','H001077','DISTRICT','Lake Charles','1 Lakeshore Drive','Suite 1670','Lake Charles','LA','70629','(337) 656-2833',30.2305579,-93.2196295);
INSERT INTO "office" VALUES('I000024-mcalester','I000024','DISTRICT','Mcalester','215 E Choctaw Ave #106',NULL,'McAlester','OK','74501','(918) 426-0933',34.931573,-95.7671124);
INSERT INTO "office" VALUES('I000024-oklahoma-city','I000024','DISTRICT','Oklahoma City','1900 NW Expressway #1210',NULL,'Oklahoma City','OK','73118','(405) 608-4381',35.5219627,-97.5457597);
INSERT INTO "office" VALUES('I000024-tulsa','I000024','DISTRICT','Tulsa','1924 S Utica Ave #530',NULL,'Tulsa','OK','74104-6511','(918) 748-5111',36.1341719,-95.9676084);
INSERT INTO "office" VALUES('I000024-enid','I000024','DISTRICT','Enid','302 N Independence #104',NULL,'Enid','OK','73701','(580) 234-5105',36.3993287,-97.8803343);
INSERT INTO "office" VALUES('I000024-washington','I000024','DC','Washington','205 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-4721',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('I000055-washington','I000055','DC','Washington','131 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3643',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('I000055-atlanta','I000055','DISTRICT','Atlanta','One Overton Park','3625 Cumberland Blvd, Suite 970','Atlanta','GA','30339','(770) 661-0999',33.8842234,-84.4536761);
INSERT INTO "office" VALUES('I000056-vista','I000056','DISTRICT','Vista','1800 Thibodo Road, #310',NULL,'Vista','CA','92081','(760) 599-5000',33.1734619,-117.2261545);
INSERT INTO "office" VALUES('I000056-washington','I000056','DC','Washington','2269 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3906',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('I000056-dana-point','I000056','DISTRICT','Dana Point','33282 Golden Lantern, Ste 102',NULL,'Dana Point','CA','92629','(949) 281-2449',33.4795351,-117.6970568);
INSERT INTO "office" VALUES('J000032-acres-home','J000032','DISTRICT','Acres Home','6719 West Montgomery','Suite 204','Houston','TX','77091','(713) 691-4882',29.8575093,-95.4221659);
INSERT INTO "office" VALUES('J000032-fifth-ward','J000032','DISTRICT','Fifth Ward','4300 Lyons Ave.',NULL,'Houston','TX','77020','(713) 227-7740',29.7758442,-95.3269342);
INSERT INTO "office" VALUES('J000032-heights','J000032','DISTRICT','Heights','420 West 19th Street',NULL,'Houston','TX','77008','(713) 861-4070',29.8026927,-95.4044876);
INSERT INTO "office" VALUES('J000032-washington','J000032','DC','Washington','2187 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3816',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('J000032-houston','J000032','DISTRICT','Houston','1919 Smith Street','Suite 1180','Houston','TX','77002','(713) 655-0050',29.7519042,-95.3736058);
INSERT INTO "office" VALUES('J000126-dallas','J000126','DISTRICT','Dallas','3102 Maple Avenue, Suite 600',NULL,'Dallas','TX','75201','(214) 922-8885',32.7991061,-96.8079014);
INSERT INTO "office" VALUES('J000126-washington','J000126','DC','Washington','2468 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-8885',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('J000174-texas','J000174','DISTRICT','Texas','1255 W 15th Street, Suite 170',NULL,'Plano','TX','75075','(469) 304-0382',33.0206224,-96.7187297);
INSERT INTO "office" VALUES('J000174-washington','J000174','DC','Washington','2304 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4201',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('J000255-greenville','J000255','DISTRICT','Greenville','1105-C Corporate Drive',NULL,'Greenville','NC','27858','(252) 931-1003',35.580699,-77.356802);
INSERT INTO "office" VALUES('J000255-havelock','J000255','DISTRICT','Havelock','1 Governmental Avenue',NULL,'Havelock','NC','28532','(252) 565-6846',34.8760387,-76.9018802);
INSERT INTO "office" VALUES('J000255-washington','J000255','DC','Washington','2333 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3415',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('J000255-jacksonville','J000255','DISTRICT','Jacksonville','234 Northwest Corridor Blvd. Room 313B',NULL,'Jacksonville','NC','28540','(252) 565-6846',34.7806024,-77.4857495);
INSERT INTO "office" VALUES('J000288-decatur','J000288','DISTRICT','Decatur','5240 Snapfinger Park Drive','Suite 130','Decatur','GA','30035','(770) 987-2291',33.704214,-84.1763731);
INSERT INTO "office" VALUES('J000288-washington','J000288','DC','Washington','2240 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-1605',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('J000289-lima','J000289','DISTRICT','Lima','3121 West Elm Plaza',NULL,'Lima','OH','45805','(419) 999-6455',40.7369756,-84.161425);
INSERT INTO "office" VALUES('J000289-norwalk','J000289','DISTRICT','Norwalk','13 B East Main Street',NULL,'Norwalk','OH','44857','(419) 663-1426',41.2425971,-82.6150462);
INSERT INTO "office" VALUES('J000289-washington','J000289','DC','Washington','2056 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-2676',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('J000290-pittsburg','J000290','DISTRICT','Pittsburg','1001 N. Broadway Street #C',NULL,'Pittsburg','KS','66762','(620) 231-5966',37.4174839,-94.7048524);
INSERT INTO "office" VALUES('J000290-topeka','J000290','DISTRICT','Topeka','3550 SW 5th Street',NULL,'Topeka','KS','66606','(785) 234-5966',39.0608999,-95.720894);
INSERT INTO "office" VALUES('J000290-washington','J000290','DC','Washington','1526 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-6601',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('J000292-marietta','J000292','DISTRICT','Marietta','246 Front St.',NULL,'Marietta','OH','45750','(740) 376-0868',39.413511,-81.454609);
INSERT INTO "office" VALUES('J000292-salem','J000292','DISTRICT','Salem','192 East State St.',NULL,'Salem','OH','44460','(330) 337-6951',40.9010799,-80.8561222);
INSERT INTO "office" VALUES('J000292-cambridge','J000292','DISTRICT','Cambridge','116 Southgate Pkwy.',NULL,'Cambridge','OH','43725','(740) 432-2366',40.0243891,-81.5899869);
INSERT INTO "office" VALUES('J000292-ironton','J000292','DISTRICT','Ironton','202 Park Ave. Suite C',NULL,'Ironton','OH','45638','(740) 534-9431',38.5344281,-82.6854708);
INSERT INTO "office" VALUES('J000292-washington','J000292','DC','Washington','1710 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5705',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('J000293-milwaukee','J000293','DISTRICT','Milwaukee','517 East Wisconsin Avenue','Suite 408','Milwaukee','WI','53202','(414) 276-7282',43.0382241,-87.90456);
INSERT INTO "office" VALUES('J000293-oshkosh','J000293','DISTRICT','Oshkosh','219 Washington Avenue','Suite 100','Oshkosh','WI','54901','(920) 230-7250',44.0174081,-88.5343632);
INSERT INTO "office" VALUES('J000293-washington','J000293','DC','Washington','328 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5323',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('J000294-central-brooklyn','J000294','DISTRICT','Central Brooklyn','55 Hanson Place','Suite 603','Brooklyn','NY','11217','(718) 237-2211',40.6856283,-73.9757756);
INSERT INTO "office" VALUES('J000294-washington','J000294','DC','Washington','1607 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5936',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('J000294-south-brooklyn','J000294','DISTRICT','South Brooklyn','445 Neptune Avenue, 1st Floor','Community Room 2C','Brooklyn','NY','11224','(718) 373-0033',40.5809199,-73.9696891);
INSERT INTO "office" VALUES('J000295-painesville','J000295','DISTRICT','Painesville','1 Victoria Place, Room 320',NULL,'Painesville','OH','44077','(440) 352-3939',41.7245406,-81.2427281);
INSERT INTO "office" VALUES('J000295-washington','J000295','DC','Washington','1124 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5731',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('J000295-twinsburg','J000295','DISTRICT','Twinsburg','Twinsburg Gov. Center','10075 Ravenna Road','Twinsburg','OH','44087','(330) 357-4139',41.3183054,-81.4478297);
INSERT INTO "office" VALUES('J000297-beckley','J000297','DISTRICT','Beckley','307 Prince St.',NULL,'Beckley','WV','25801','(304) 250-6177',37.778036,-81.190697);
INSERT INTO "office" VALUES('J000297-bluefield','J000297','DISTRICT','Bluefield','601 Federal St. Suite 1003','Elizabeth Kee Federal Building','Bluefield','WV','24701','(304) 325-6800',37.267208,-81.2215008);
INSERT INTO "office" VALUES('J000297-huntington','J000297','DISTRICT','Huntington','845 Fifth Ave.','Suite 314','Huntington','WV','25701','(304) 522-2201',38.4189915,-82.4441521);
INSERT INTO "office" VALUES('J000297-washington','J000297','DC','Washington','1609 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3452',38.8868,-77.0085);
INSERT INTO "office" VALUES('J000298-seattle','J000298','DISTRICT','Seattle','1904 3rd Ave., Suite 510',NULL,'Seattle','WA','98101','(206) 674-0040',47.6119653,-122.3397313);
INSERT INTO "office" VALUES('J000298-washington','J000298','DC','Washington','319 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-3106',38.8868,-77.0085);
INSERT INTO "office" VALUES('J000299-bossier-city','J000299','DISTRICT','Bossier City','2250 Hospital Drive','Suite 248','Bossier City','LA','71111','(318) 840-0309',32.5579513,-93.7228425);
INSERT INTO "office" VALUES('J000299-washington','J000299','DC','Washington','327 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2777',38.8868,-77.0085);
INSERT INTO "office" VALUES('J000299-natchitoches','J000299','DISTRICT','Natchitoches','444 Caspari Drive','South Hall Room 224','Natchitoches','LA','71497','(318) 357-5731',3.1747896699999991199e+01,-93.0973496);
INSERT INTO "office" VALUES('J000299-leesville','J000299','DISTRICT','Leesville','3329 University Parkway','Building 552, Room 24','Leesville','LA','71446','(337) 392-3146',31.0884912,-93.2312895);
INSERT INTO "office" VALUES('K000009-cleveland','K000009','DISTRICT','Cleveland','17021 Lorain',NULL,'Cleveland','OH','44111','(216) 767-5933',41.4502564,-81.8160502);
INSERT INTO "office" VALUES('K000009-lorain','K000009','DISTRICT','Lorain','200 West Erie','Room 310','Lorain','OH','44052','(440) 288-1500',41.4685695,-82.1792684);
INSERT INTO "office" VALUES('K000009-washington','K000009','DC','Washington','2186 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4146',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('K000009-toledo','K000009','DISTRICT','Toledo','One Maritime Plaza','Room 600','Toledo','OH','43604','(419) 259-7500',41.6538759,-83.528238);
INSERT INTO "office" VALUES('K000188-la-crosse','K000188','DISTRICT','La Crosse','205 Fifth Avenue S., Suite 400',NULL,'La Crosse','WI','54601','(608) 782-2558',43.8109182,-91.249764);
INSERT INTO "office" VALUES('K000188-eau-claire','K000188','DISTRICT','Eau Claire','131 S. Barstow St. Suite 301',NULL,'Eau Claire','WI','54701','(715) 831-9214',44.8120136,-91.500022);
INSERT INTO "office" VALUES('K000188-washington','K000188','DC','Washington','1502 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5506',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('K000210-massapequa-park','K000210','DISTRICT','Massapequa Park','1003 Park Boulevard',NULL,'Massapequa Park','NY','11762','(516) 541-4225',40.6785193,-73.4556272);
INSERT INTO "office" VALUES('K000210-washington','K000210','DC','Washington','339 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-7896',38.8868,-77.0085);
INSERT INTO "office" VALUES('K000362-ames','K000362','DISTRICT','Ames','1421 S Bell Avenue','Suite 102','Ames','IA','50010','(515) 232-2885',42.009659,-93.575922);
INSERT INTO "office" VALUES('K000362-mason-city','K000362','DISTRICT','Mason City','202-1st Street SE','Suite 126','Mason City','IA','50401','(641) 201-1624',43.1511623,-93.1974843);
INSERT INTO "office" VALUES('K000362-sioux-city','K000362','DISTRICT','Sioux City','526 Nebraska Street',NULL,'Sioux City','IA','51101','(712) 224-4692',42.4962179,-96.4032879);
INSERT INTO "office" VALUES('K000362-spencer','K000362','DISTRICT','Spencer','306 Grand Avenue',NULL,'Spencer','IA','51301','(712) 580-7754',43.1407023,-95.144286);
INSERT INTO "office" VALUES('K000362-washington','K000362','DC','Washington','2210 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-4426',38.8871071,-77.0104749);
INSERT INTO "office" VALUES('K000362-fort-dodge','K000362','DISTRICT','Fort Dodge','723 Central Avenue',NULL,'Fort Dodge','IA','50501','(515) 573-2738',42.5047853,-94.1875913);
INSERT INTO "office" VALUES('K000367-northeastern','K000367','DISTRICT','Northeastern','Olcott Plaza, Room 105','820 9th Street North','Virginia','MN','55792','(218) 741-9690',47.5302888,-92.5465059);
INSERT INTO "office" VALUES('K000367-southern','K000367','DISTRICT','Southern','1130 1/2 7th Street NW, Room 212',NULL,'Rochester','MN','55901','(507) 288-5321',44.0314822,-92.479679);
INSERT INTO "office" VALUES('K000367-twin-citiesmetro-office','K000367','DISTRICT','Twin Cities/Metro Office','1200 Washington Avenue South, Room 250',NULL,'Minneapolis','MN','55415','(612) 727-5220',44.9751443,-93.2505863);
INSERT INTO "office" VALUES('K000367-northwestern--central','K000367','DISTRICT','Northwestern & Central','121 4th Street South',NULL,'Moorhead','MN','56560','(218) 287-2219',46.873119,-96.774188);
INSERT INTO "office" VALUES('K000367-washington','K000367','DC','Washington','302 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-3244',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('K000375-new-bedford','K000375','DISTRICT','New Bedford','558 Pleasant St.','Suite 309','New Bedford','MA','02740','(508) 999-6462',41.6344958,-70.9266835);
INSERT INTO "office" VALUES('K000375-plymouth','K000375','DISTRICT','Plymouth','170 Court St.',NULL,'Plymouth','MA','02360','(508) 746-9000',41.9636518,-70.6753841);
INSERT INTO "office" VALUES('K000375-washington','K000375','DC','Washington','2351 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3111',38.8868,-77.0085);
INSERT INTO "office" VALUES('K000375-hyannis','K000375','DISTRICT','Hyannis','297 North St.','Suite 312','Hyannis','MA','02601','(508) 771-0666',41.6502963,-70.2930554);
INSERT INTO "office" VALUES('K000376-erie','K000376','DISTRICT','Erie','208 E. Bayfront Parkway, Suite 102',NULL,'Erie','PA','16507','(814) 454-8190',42.1373875,-80.0848493);
INSERT INTO "office" VALUES('K000376-sharon','K000376','DISTRICT','Sharon','33 Chestnut Avenue',NULL,'Sharon','PA','16146','(724) 342-7170',41.2315486,-80.5079773);
INSERT INTO "office" VALUES('K000376-butler','K000376','DISTRICT','Butler','101 E. Diamond St., Suite 218',NULL,'Butler','PA','16001','(724) 282-2557',40.8580044,-79.8948869);
INSERT INTO "office" VALUES('K000376-washington','K000376','DC','Washington','1707 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5406',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('K000378-ottawa','K000378','DISTRICT','Ottawa','628 Columbus St., Suite 507',NULL,'Ottawa','IL','61350','(815) 431-9271',41.346247,-88.841051);
INSERT INTO "office" VALUES('K000378-rockford','K000378','DISTRICT','Rockford','725 N. Lyford Road, Suite 3',NULL,'Rockford','IL','61107','(815) 708-8032',42.2743104,-88.9601839);
INSERT INTO "office" VALUES('K000378-washington','K000378','DC','Washington','2245 Rayburn House Office Building',NULL,'Washington','DC','20515','(202) 225-3635',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('K000378-watseka','K000378','DISTRICT','Watseka','342 West Walnut',NULL,'Watseka','IL','60970','(815) 432-0580',40.7762446,-87.7383019);
INSERT INTO "office" VALUES('K000379-newton','K000379','DISTRICT','Newton','29 Crafts Street','Suite 375','Newton','MA','02458','(617) 332-3333',42.3548224,-71.1999166);
INSERT INTO "office" VALUES('K000379-attleboro','K000379','DISTRICT','Attleboro','8 North Main St.','Suite 200','Attleboro','MA','02703','(508) 431-1110',41.9449626,-71.2846799);
INSERT INTO "office" VALUES('K000379-washington','K000379','DC','Washington','434 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-5931',38.8868,-77.0085);
INSERT INTO "office" VALUES('K000380-flint','K000380','DISTRICT','Flint','111 East Court St. #3B',NULL,'Flint','MI','48502','(810) 238-8627',43.0133524,-83.6871014);
INSERT INTO "office" VALUES('K000380-washington','K000380','DC','Washington','227 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-3611',38.8868,-77.0085);
INSERT INTO "office" VALUES('K000381-port-angeles','K000381','DISTRICT','Port Angeles','332 E 5th St',NULL,'Port Angeles','WA','98362','(360) 797-3623',48.113181,-123.431753);
INSERT INTO "office" VALUES('K000381-tacoma','K000381','DISTRICT','Tacoma','950 Pacific Avenue','Suite 1230','Tacoma','WA','98402','(253) 272-3515',47.2535757,-122.4390697);
INSERT INTO "office" VALUES('K000381-bremerton','K000381','DISTRICT','Bremerton','345 6th Street','Suite 500','Bremerton','WA','98337','(360) 373-9725',47.5669568,-122.6258917);
INSERT INTO "office" VALUES('K000381-washington','K000381','DC','Washington','1520 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-5916',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('K000382-concord','K000382','DISTRICT','Concord','18 North Main Street','Fourth Floor','Concord','NH','03301','(603) 226-1002',43.2048069,-71.5355091);
INSERT INTO "office" VALUES('K000382-nashua','K000382','DISTRICT','Nashua','70 East Pearl Street',NULL,'Nashua','NH','03060','(603) 595-2006',42.7601735,-71.4642733);
INSERT INTO "office" VALUES('K000382-washington','K000382','DC','Washington','137 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-5206',38.8868,-77.0085);
INSERT INTO "office" VALUES('K000382-littleton','K000382','DISTRICT','Littleton','33 Main Street, Suite 202',NULL,'Littleton','NH','03561','(603) 444-7700',44.3063587,-71.7713705);
INSERT INTO "office" VALUES('K000383-augusta','K000383','DISTRICT','Augusta','4 Gabriel Drive, Suite 3',NULL,'Augusta','ME','04330','(207) 622-8292',44.3676495,-69.7940768);
INSERT INTO "office" VALUES('K000383-presque-isle','K000383','DISTRICT','Presque Isle','169 Academy St., Suite A',NULL,'Presque Isle','ME','04769','(207) 764-5124',46.6766073,-67.9956649);
INSERT INTO "office" VALUES('K000383-scarborough','K000383','DISTRICT','Scarborough','383 US Route 1, Suite 1C',NULL,'Scarborough','ME','04074','(207) 883-1588',43.5854463,-70.3582263);
INSERT INTO "office" VALUES('K000383-bangor','K000383','DISTRICT','Bangor','202 Harlow St., Suite 20350',NULL,'Bangor','ME','04401','(207) 945-8000',44.8046399,-68.7737891);
INSERT INTO "office" VALUES('K000383-washington','K000383','DC','Washington','133 Hart Senate Office Building',NULL,'Washington','DC','20510','(202) 224-5344',38.8928388,-77.0043561);
INSERT INTO "office" VALUES('K000384-danville','K000384','DISTRICT','Danville','308 Craghead Street, Suite 102A',NULL,'Danville','VA','24541','(434) 792-0976',36.5867166,-79.389396);
INSERT INTO "office" VALUES('K000384-abingdon','K000384','DISTRICT','Abingdon','121 Russell Road, Suite 2',NULL,'Abingdon','VA','24210','(276) 525-4790',36.709042,-81.981768);
INSERT INTO "office" VALUES('K000384-virginia-beach','K000384','DISTRICT','Virginia Beach','222 Central Park Avenue, Suite 120',NULL,'Virginia Beach','VA','23462','(757) 518-1674',36.842768,-76.133277);
INSERT INTO "office" VALUES('K000384-roanoke','K000384','DISTRICT','Roanoke','611 S. Jefferson Street, Suite 5B',NULL,'Roanoke','VA','24011','(540) 682-5693',37.268654,-79.9408098);
INSERT INTO "office" VALUES('K000384-manassas','K000384','DISTRICT','Manassas','9408 Grant Avenue, Suite 202',NULL,'Manassas','VA','20110','(703) 361-3192',38.7515843,-77.4755912);
INSERT INTO "office" VALUES('K000384-washington','K000384','DC','Washington','231 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-4024',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('K000384-richmond','K000384','DISTRICT','Richmond','919 East Main Street, Suite 970',NULL,'Richmond','VA','23219','(804) 771-2221',37.5374358,-77.4362913);
INSERT INTO "office" VALUES('K000385-kankakee','K000385','DISTRICT','Kankakee','Kankakee City Hall','304 South Indiana Avenue','Kankakee','IL','60901','(708) 679-0078',41.117146,-87.861261);
INSERT INTO "office" VALUES('K000385-matteson','K000385','DISTRICT','Matteson','600 Holiday Plaza Dr','Suite 505','Matteson','IL','60443','(708) 679-0078',41.5042785,-87.7382453);
INSERT INTO "office" VALUES('K000385-chicago','K000385','DISTRICT','Chicago','9204 S. Commercial Ave','Suite 415','Chicago','IL','60617','(773) 321-2001',41.7280317,-87.5514868);
INSERT INTO "office" VALUES('K000385-washington','K000385','DC','Washington','1239 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-0773',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('K000386-syracuse','K000386','DISTRICT','Syracuse','440 South Warren St.','7th Floor Suite 711','Syracuse','NY','13202','(315) 423-5657',43.0461194,-76.1516167);
INSERT INTO "office" VALUES('K000386-auburn','K000386','DISTRICT','Auburn','71 Genesee St.',NULL,'Auburn','NY','13021','(315) 253-4068',42.9318995,-76.5664577);
INSERT INTO "office" VALUES('K000386-washington','K000386','DC','Washington','1620 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-3701',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('K000387-antelope-valley','K000387','DISTRICT','Antelope Valley','1008 West Avenue M-14, Suite E',NULL,'Palmdale','CA','93551','(661) 441-0320',34.6327078,-118.1484295);
INSERT INTO "office" VALUES('K000387-santa-clarita-valley','K000387','DISTRICT','Santa Clarita Valley','26415 Carl Boyer Drive, Suite 220',NULL,'Santa Clarita','CA','91350','(661) 255-5630',34.4128248,-118.5040453);
INSERT INTO "office" VALUES('K000387-simi-valley','K000387','DISTRICT','Simi Valley','1445 E. Los Angeles Avenue, #206',NULL,'Simi Valley','CA','93065','(805) 581-7130',34.2722109,-118.7716329);
INSERT INTO "office" VALUES('K000387-washington','K000387','DC','Washington','1023 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-1956',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('K000388-columbus','K000388','DISTRICT','Columbus','318 North 7th Street, Suite D',NULL,'Columbus','MS','39701','(662) 327-0748',33.4985949,-88.4258776);
INSERT INTO "office" VALUES('K000388-tupelo','K000388','DISTRICT','Tupelo','431 West Main Street',NULL,'Tupelo','MS','38804','(662) 841-8808',34.2570023,-88.7081126);
INSERT INTO "office" VALUES('K000388-farmington','K000388','DISTRICT','Farmington','4135 County Road 200',NULL,'Corinth','MS','38844','(662) 687-1525',34.9303984,-88.4336389);
INSERT INTO "office" VALUES('K000388-washington','K000388','DC','Washington','1721 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4306',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('K000388-eupora','K000388','DISTRICT','Eupora','855 South Dunn Street',NULL,'Eupora','MS','39744','(662) 258-7240',33.5403014,-89.2688098);
INSERT INTO "office" VALUES('K000388-hernando','K000388','DISTRICT','Hernando','2565 Caffey Street, #200',NULL,'Hernando','MS','38632','(662) 449-3090',34.8226252,-89.9956387);
INSERT INTO "office" VALUES('K000389-santa-clara','K000389','DISTRICT','Santa Clara','900 Lafayette Street','Suite 206','Santa Clara','CA','95050','(408) 436-2720',37.3494432,-121.9434873);
INSERT INTO "office" VALUES('K000389-washington','K000389','DC','Washington','513 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-2631',38.8868,-77.0085);
INSERT INTO "office" VALUES('K000390-north-las-vegas','K000390','DISTRICT','North Las Vegas','2250 N Las Vegas Blvd','Suite 500','North Las Vegas','NV','89030','(702) 963-9360',36.2004978,-115.1214764);
INSERT INTO "office" VALUES('K000390-washington','K000390','DC','Washington','313 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-9894',38.8868,-77.0085);
INSERT INTO "office" VALUES('K000391-schaumburg','K000391','DISTRICT','Schaumburg','1701 East Woodfield Rd','Suite 704','Schaumburg','IL','60173','(847) 413-1959',42.042839,-88.0382131);
INSERT INTO "office" VALUES('K000391-washington','K000391','DC','Washington','515 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-3711',38.8868,-77.0085);
INSERT INTO "office" VALUES('K000392-dyersburg','K000392','DISTRICT','Dyersburg','100 Main Street',NULL,'Dyersburg','TN','38024','(731) 412-1037',35.9688328,-89.3845615);
INSERT INTO "office" VALUES('K000392-martin','K000392','DISTRICT','Martin','406 South Lindell Street',NULL,'Martin','TN','38237','(731) 412-1043',36.342528,-88.850229);
INSERT INTO "office" VALUES('K000392-memphis','K000392','DISTRICT','Memphis','5900 Poplar Ave.','Suite 202','Memphis','TN','38119','(901) 682-4422',35.1034459,-89.8641093);
INSERT INTO "office" VALUES('K000392-washington','K000392','DC','Washington','508 Cannon House Office Building',NULL,'Washington','DC','20515','(202) 225-4714',38.8868,-77.0085);
INSERT INTO "office" VALUES('K000392-jackson','K000392','DISTRICT','Jackson','117 North Liberty Street',NULL,'Jackson','TN','38301','(731) 423-4848',35.6149736,-8.88184144000000088715e+01);
INSERT INTO "office" VALUES('K000393-washington','K000393','DC','Washington','SR383 Russell Senate Building',NULL,'Washington','DC','20510','(202) 224-4623',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('L000174-burlington','L000174','DISTRICT','Burlington','199 Main Street, 4th Floor',NULL,'Burlington','VT','05401','(802) 863-2525',44.4755314,-73.2112826);
INSERT INTO "office" VALUES('L000174-montpelier','L000174','DISTRICT','Montpelier','87 State Street, Room 338',NULL,'Montpelier','VT','05602','(802) 229-0569',44.260997,-72.5775843);
INSERT INTO "office" VALUES('L000174-washington','L000174','DC','Washington','437 Russell Senate Office Building',NULL,'Washington','DC','20510','(202) 224-4242',38.8925417,-77.0074155);
INSERT INTO "office" VALUES('L000263-washington','L000263','DC','Washington','1236 Longworth House Office Building',NULL,'Washington','DC','20515','(202) 225-4961',38.8867621,-77.0069216);
INSERT INTO "office" VALUES('L000263-roseville','L000263','DISTRICT','Roseville','27085 Gratiot Ave',NULL,'Roseville','MI','48066','(586) 498-7122',42.495564,-82.9385656);
INSERT INTO "office" VALUES('L000287-atlanta','L000287','DISTRICT','Atlanta','100 Peachtree Street NW','Suite 1920','Atlanta','GA','30303','(404) 659-0116',33.7568505,-84.3885994);