raw_principal_officer
168 rows
| 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 |
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);