raw_principal_officer

168 rows

✎ View and edit SQL

Link rptId _key city name po_box,_bldg,_room_no,_if_any state street zip_code_+_4
1 721322 0 Boston Scott E. Couto mail stop BX32-10875 MA 225 Franklin Street 02110 - 2804
2 723454 0            
3 725226 0 Kansas City K.C. Mathews   MO 1010 Grand Blvd 64106
4 726093 0 Philadelphia Sheri Preston   PA 725 E. Erie Avenue 19134
5 728027 0 Troy Edward Wolyniec   MI 700 Tower Drive, Suite 300 48098
6 729412 0 Pittsburgh Saurabh Tripathi FAPHM-313E PA 120 5th Avenue 15222
7 748202 0            
8 748389 0 Kansas City Erin Stucky   MO 2301 Main Street 64108
9 749688 0 Phoenix Robert B Boyer   AZ 18500 North Allied Way 85054
10 751188 0 New York George Cheeks 1515 Broadway NY 1515 Broadway 10036
11 751196 0 New York George Cheeks   NY 1515 Broadway 10036
12 751956 0 Troy Edward Wolyniec   MI 700 Tower Drive, Suite 300 48098
13 751999 0            
14 753503 0 Houston Jim Hart 8441 Gulf Freeway, Suite 600, Suite 600 TX 8441 Gulf Freeway, Suite 600, Suite 600 77017
15 754042 0 BROOKLYN Michael Policarpo   OH 4900 TIEDMAN ROAD 44144
16 754915 0            
17 755527 0 Nashville Harry Boot   TN 1910 Air Lane Drive 37210
18 804879 0 BROOKLYN Michael Policarpo   OH 4900 TIEDMAN ROAD 44144
19 806065 0            
20 806570 0 Kansas City Erin Stucky   MO 2301 Main St 64108
21 810548 0            
22 811529 0 Phoenix Mary Semma Admin 1 AZ 8220 N. 23rd Avenue 85021 - 4872
23 811851 0 McLean Michael Hollman   VA 7930 Jones Branch Dr. 22102
24 812520 0 Kansas City K.C. Mathews   MO 1010 Grand Blvd 64106
25 812653 0 Cleveland John G Morikis   OH 101 West Prospect Avenue 44115
26 813196 0 New York Uwe Voss 10th Floor NY 28 Liberty Street 10005
27 813414 0            
28 813573 0 Troy Edward Wolyniec   MI 700 Tower Drive, Suite 300 48098
29 814014 0 New York George Cheeks   NY 1515 Broadway 10036
30 816314 0 New York George Cheeks 1515 Broadway NY 1515 Broadway 10036
31 821811 0 Nashville Harry Boot   TN 1910 Air Lane Drive 37210
32 823241 0 Pittsburgh Saurabh Tripathi FAPHM-313E PA 150 5th Avenue 15222
33 854630 0            
34 856734 0 BROOKLYN Michael Policarpo   OH 4900 TIEDMAN ROAD 44144
35 857976 0 Dallas Suzanne Myers   TX 500 N. Akard, Suite 400 75201
36 860684 0 New York George Cheeks   NY 1515 Broadway 10036
37 860687 0 New York George Cheeks 1515 Broadway NY 1515 Broadway 10036
38 861061 0 Cleveland John G Morikis   OH 101 West Prospect Avenue 44115
39 861317 0 Ontario David Gans 4755 CA Philadelphia St. 91761
40 861594 0            
41 861851 0 Kansas City K.C. Mathews   MO 1010 Grand Blvd 64106
42 862660 0 San Francisco Sarah Chavarria   CA 560 Mission St Ste 1300 94105
43 862666 0 San Francisco Sarah Chavarria   CA 560 Mission Street Ste 1300 94105
44 863489 0 Houston Jim Hart   TX 8441 Gulf Freeway, Suite 600 77017
45 864028 0 Kansas City Erin Stucky   MO 2301 Main St 64108
46 864077 0 New York Uwe Voss 10th Floor NY 28 Liberty Street 10005
47 864877 0 Peachtree Corners Rick Tomcho   GA 30 Technology Pkwy South Suite 200 30092
48 864879 0 Peachtree Rick Tomcho   GA 30 Technology Parkway South, Suite 30092
49 864882 0 Peachtree Rick Tomcho   GA 30 Technology Parkway South, Suite 30092
50 865090 0 Troy EDWARD S WOLYNIEC   MI 700 Tower Drive, Suite 300 48098
51 865472 0 Seattle John Felton   WA 410 Terry Ave. N 98109
52 865666 0            
53 866792 0            
54 868089 0 Nashville Harry Boot   TN 1910 Air Lane Drive 37210
55 868676 0 Pittsburgh Janine Colinear FAPHM-303B PA 150 5th Avenue 15222
56 871442 0            
57 878841 0 Ontario Steve Panelli   CA 4755 E. Philadelphia St. 91761
58 882598 0 San Francisco Sarah Chavarria   CA 560 Mission Street Ste 1300 94105
59 882599 0 San Francisco Sarah Chavarria   CA 560 Mission Street Ste 1300 94105
60 882843 0 Detroit Daniel J Loepp   MI 600 E Lafayette Blvd 48226
61 883217 0 Peachtree Corners Rick Tomcho   GA 30 Technology Pkwy S, Suite 200 30092
62 883267 0            
63 884921 0 Oaks James J Cipriano   PA One Freedom Valley Drive 19456
64 886572 0 New York Francine Asselta 485 Lexington Avenue NY   10017
65 886657 0 Kansas City Erin Stucky   MO 2301 Main St 64108
66 887363 0 New York Uwe Voss 10th Floor NY 28 Liberty Street 10005
67 887952 0 Suite 600 Jim Hart   TX 8441 Gulf Freeway 77017
68 888051 0            
69 888106 0 Troy Edward S Wolyniec   MI 700 Tower Drive, Suite 300 48098
70 888497 0 San Diego Luke Brooks   CA 655 W Broadway, #1900 92101
71 888782 0 New York George Cheeks   NY 1515 Broadway 10036
72 888789 0 New York George Cheeks 1515 Broadway NY 1515 Broadway 10036
73 888816 0            
74 890239 0            
75 890743 0 Pittsburgh Carl Daley 120 5th Avenue PA OFF-CFO 15222
76 890914 0 New York Michael Palmateer   NY 55 Water Street 10041
77 892298 0 Dallas Suzanne Myers   TX 500 N. Akard, Suite 400 75201
78 893005 0 Brooklyn Michael Policarpo   OH 4900 Tiedeman Road 44114
79 893036 0 Nashville Harry Boot   TN 1910 Air Lane Drive 37210
80 893736 0 McLean Daniel Hughes 1100 VA 7930 Jones Branch Drive 22102
81 894547 0 Cleveland Heidi G Petz   OH 101 West Prospect Avenue 44115
82 899077 0 Mullica Hill Amy Mansue   NJ 165 Bridgeton Pike 08062
83 902814 0 Ontario Steve Panelli   CA 4755 E. Philadelphia St. 91761
84 906144 0 Brooklyn Michael Policarpo   OH 4900 Tiedeman Road 44114
85 907822 0 Detroit Tricia Keith   MI 600 E Lafayette Blvd 48226
86 908917 0            
87 910020 0 New York Uwe Voss 10th Floor NY 28 Liberty Street 10005
88 910365 0 Kansas City Erin Stucky   MO 2301 Main St 64108
89 910644 0 Pittsburgh Carl Daley 120 5th Avenue PA OFF-CFO 15222
90 911149 0 Oaks Michael Lane   PA One Freedom Valley Drive 19456
91 912556 0            
92 912559 0            
93 913556 0 Phoenix Julia Arambula   AZ 18500 North Allied Way 85054
94 913755 0 New York Francine Asselta 485 Lexington Avenue NY   10017
95 913963 0 Troy Edward S Wolyniec   MI 700 Tower Drive Suite 300 48098
96 914009 0            
97 914028 0 McLean Daniel Hughes 1100 VA 7930 Jones Branch Drive 22102
98 914752 0 San Francisco Sarah Chavarria 560 Mission St Ste 1300 CA   94105
99 914757 0 San Francisco Sarah Chavarria 560 Missions St Ste 1300 CA   94105
100 914911 0            

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE "raw_principal_officer"(
"rptId" TEXT, "_key" TEXT, "city" TEXT, "name" TEXT,
 "po_box,_bldg,_room_no,_if_any" TEXT, "state" TEXT, "street" TEXT, "zip_code_+_4" TEXT);