FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14,948 rows where City = "New York" sorted by Address_2
This data as json, CSV (advanced)
Registration_Number >30
- JETRO, New York 490
- Quebec Government Office 417
- White & Case, LLP 413
- KOTRA 358
- Amtorg Trading Corporation 331
- Ruder Finn, Inc. 300
- Daniel J. Edelman, Inc. 297
- Netherlands Chamber of Commerce in the U.S., Inc. 238
- British Information Services 211
- Singapore Economic Development Board 199
- GCI Group, Inc. 186
- Ketchum Inc. NY 175
- New York Bureau of the Telegraph Agency of Russia (TASS) 153
- IPG DXTRA, Inc 152
- Saatchi & Saatchi North America, Inc. 150
- American Section of the Jewish Agency for Israel 136
- Government of Ontario, Canada 136
- Young & Rubicam, L.P. 117
- IDA Ireland 114
- McCann-Erickson, Inc. 110
- Bermuda Tourism Authority 104
- U.S. Office of the British Broadcasting Corporation 98
- Doremus & Company 96
- Cayman Islands Department of Tourism 94
- Swedish-American Chamber of Commerce, Inc. 92
- VisitBritain 92
- Israel Government Tourist Office 92
- European Travel Commission 87
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 87
- FCB New York 83
- …
Registrant_Name >30
- JETRO, New York 490
- Quebec Government Office 417
- White & Case, LLP 413
- KOTRA 358
- Ruder Finn, Inc. 339
- Amtorg Trading Corporation 331
- Daniel J. Edelman, Inc. 297
- Netherlands Chamber of Commerce in the U.S., Inc. 238
- British Information Services 211
- Singapore Economic Development Board 199
- GCI Group, Inc. 186
- Ketchum Inc. NY 175
- New York Bureau of the Telegraph Agency of Russia (TASS) 153
- IPG DXTRA, Inc 152
- Saatchi & Saatchi North America, Inc. 150
- Doremus & Company 140
- McCann-Erickson, Inc. 139
- American Section of the Jewish Agency for Israel 136
- Government of Ontario, Canada 136
- Young & Rubicam, L.P. 117
- IDA Ireland 114
- Bermuda Tourism Authority 104
- U.S. Office of the British Broadcasting Corporation 98
- Cayman Islands Department of Tourism 94
- Israel Government Tourist Office 92
- Swedish-American Chamber of Commerce, Inc. 92
- VisitBritain 92
- European Travel Commission 87
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 87
- FCB New York 83
- …
State 1
- NY 14,848
City 1
- New York · 14,848 ✖
Link | rowid | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 ▼ | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1361 | 1361 | 2023-07-05 | Chan | Gerry Keith | USSA International LLC 7252 | 2023-03-31 | USSA International LLC | 767 5th Avenue, 45th Floor | New York | NY | 10153 | ||
1391 | 1391 | 2022-07-11 | Mautz | Hannah | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1447 | 1447 | 2023-07-20 | Knight | Katherine Bodor | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | 150 East 42nd Street 34th Floor | New York | NY | 10017 | ||
1448 | 1448 | 2023-07-20 | Love | Lisa Alonso | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | 150 East 42nd Street 34th Floor | New York | NY | 10017 | ||
1463 | 1463 | 2021-07-22 | Zemp | Claudio | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | ||
1464 | 1464 | 2022-07-22 | D'Agnes | Kristie | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | 150 East 42nd Street 34th Floor | New York | NY | 10017 | ||
1466 | 1466 | 2022-07-22 | Kaesshaefer | Joseph | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | 150 East 42nd Street 34th Floor | New York | NY | 10017 | ||
1467 | 1467 | 2022-07-22 | McAlpine | Shaun | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | 150 East 42nd Street 34th Floor | New York | NY | 10017 | ||
1468 | 1468 | 2022-07-22 | Meninelli | Daniel | NSW Government US Office Inc. 7145 | 2022-07-22 | NSW Government US Office Inc. | 150 East 42nd Street 34th Floor | New York | NY | 10017 | ||
1473 | 1473 | 2013-07-24 | Spoerri | Marlene | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 246 Fifth Avenue | New York | NY | 10001 | ||
1480 | 1480 | 2022-07-25 | Yacavone | Kyra | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1501 | 1501 | 1999-07-28 | McAward | Patrick J. | Saudi Petroleum International, Inc. 5321 | 1999-07-21 | Saudi Petroleum International, Inc. | 52 Madison Avenue | New York | NY | 10022 | ||
1508 | 1508 | 2022-07-28 | Singh | Sindy | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 246 Fifth Avenue | New York | NY | 10001 | ||
1539 | 1539 | 2012-07-30 | Lane | Lauren | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | ||
1542 | 1542 | 2019-07-30 | Konvalina | Miroslav | Czech Center, New York 5115 | 1996-06-21 | Czech Center, New York | 321 E 73rd Street | New York | NY | 10021 | ||
1544 | 1544 | 2021-07-30 | Mason | Ryan | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1545 | 1545 | 2021-07-30 | Munjal | Sonali | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1590 | 1590 | 2021-08-10 | Cardenas | Carol | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
1591 | 1591 | 2021-08-10 | Smith | Cara Meadows | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
1653 | 1653 | 2022-08-22 | Eckett | Brittany | Group M Worldwide, LLC 7160 | 2022-08-22 | Group M Worldwide, LLC | 175 Greenwich Street | New York | NY | 10007 | ||
1654 | 1654 | 2022-08-22 | Free | Abby | Group M Worldwide, LLC 7160 | 2022-08-22 | Group M Worldwide, LLC | 175 Greenwich Street | New York | NY | 10007 | ||
1655 | 1655 | 2022-08-22 | Papes | Christopher | Group M Worldwide, LLC 7160 | 2022-08-22 | Group M Worldwide, LLC | 175 Greenwich Street | New York | NY | 10007 | ||
1656 | 1656 | 2022-08-22 | Schiekofer | Susan | Group M Worldwide, LLC 7160 | 2022-08-22 | Group M Worldwide, LLC | 175 Greenwich Street | New York | NY | 10007 | ||
1657 | 1657 | 2022-08-22 | Weiss | Jessica | Group M Worldwide, LLC 7160 | 2022-08-22 | Group M Worldwide, LLC | 175 Greenwich Street | New York | NY | 10007 | ||
1664 | 1664 | 2021-08-26 | WONG | PUI CHI | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | ||
1670 | 1670 | 2022-08-26 | Sholley | George Burrill | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
1716 | 1716 | 2016-09-03 | Al-Hokail | Samer | Saudi Petroleum International, Inc. 5321 | 1999-07-21 | Saudi Petroleum International, Inc. | 52 Madison Avenue | New York | NY | 10022 | ||
1983 | 1983 | 2020-10-19 | Lacher | Samantha | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 301 E. 57th Street | New York | NY | 10022 | ||
2004 | 2004 | 2022-10-21 | Berry | Haven | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2026 | 2026 | 2022-10-24 | Sheridan | Virginia | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 301 E. 57th Street | New York | NY | 10022 | ||
2028 | 2028 | 2022-10-25 | Ndjib | Jacqueline | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2029 | 2029 | 2022-10-25 | Shafer | Isabelle | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2030 | 2030 | 2022-10-25 | Smith | Arianne | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2031 | 2031 | 2022-10-25 | Szymanski | Susan | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2078 | 2078 | 2018-10-31 | Kim | Michael | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 | ||
2079 | 2079 | 2018-10-31 | Landman | Daniel | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 | ||
2080 | 2080 | 2018-10-31 | Wolf | Daniel | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 | ||
2081 | 2081 | 2018-10-31 | Zeff | Aharon | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 | ||
2082 | 2082 | 2018-10-31 | Zimmerman | Menucha | Kobre & Kim LLP 6604 | 2018-10-31 | Kobre & Kim LLP | 800 Third Avenue | New York | NY | 10022 | ||
2091 | 2091 | 2020-11-02 | Aaron | Michael | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2092 | 2092 | 2020-11-02 | Ayromlou | Maryam | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2093 | 2093 | 2020-11-02 | Barrett | Jenny | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2094 | 2094 | 2020-11-02 | Dickter | Noah | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2095 | 2095 | 2020-11-02 | Francum | Peyton | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2096 | 2096 | 2020-11-02 | Irons | Todd | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2097 | 2097 | 2020-11-02 | Kim | Robin | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2098 | 2098 | 2020-11-02 | Kress | Jason | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2099 | 2099 | 2020-11-02 | Savarese | Jessica | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2100 | 2100 | 2020-11-02 | Weiss | Sophia | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2101 | 2101 | 2020-11-02 | Yi | Guen | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2130 | 2130 | 2020-11-10 | Caggiano | Rachel | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2138 | 2138 | 2020-11-11 | Dwyer | Elizabeth | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2139 | 2139 | 2020-11-11 | High | Emily | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2142 | 2142 | 2022-11-11 | Bruno | Ajay | AMWPR, Inc. 7190 | 2022-11-11 | AMWPR, Inc. | 222 Broadway | New York | NY | 10038 | ||
2143 | 2143 | 2022-11-11 | Gorman | Angela | AMWPR, Inc. 7190 | 2022-11-11 | AMWPR, Inc. | 222 Broadway | New York | NY | 10038 | ||
2144 | 2144 | 2022-11-11 | Gusain | Tripti | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2145 | 2145 | 2022-11-11 | Lenzo | Krysia | AMWPR, Inc. 7190 | 2022-11-11 | AMWPR, Inc. | 222 Broadway | New York | NY | 10038 | ||
2146 | 2146 | 2022-11-11 | Weiss | Adam | AMWPR, Inc. 7190 | 2022-11-11 | AMWPR, Inc. | 222 Broadway | New York | NY | 10038 | ||
2179 | 2179 | 2022-11-17 | Urbach | Brooke | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2209 | 2209 | 2021-11-22 | Bender | Kristin | Willkie Farr & Gallagher LLP 7047 | 2021-11-22 | Willkie Farr & Gallagher LLP | 787 Seventh Avenue | New York | NY | 10019 | ||
2210 | 2210 | 2021-11-22 | Gottlieb | Michael | Willkie Farr & Gallagher LLP 7047 | 2021-11-22 | Willkie Farr & Gallagher LLP | 787 Seventh Avenue | New York | NY | 10019 | ||
2283 | 2283 | 2022-11-29 | Caldera | Paul | Havas Media Group USA LLC 7106 | 2022-04-08 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | ||
2284 | 2284 | 2022-11-29 | Castillo | Aldo | Havas Media Group USA LLC 7106 | 2022-04-08 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | ||
2395 | 2395 | 2021-12-13 | Ringger | Devin | Willkie Farr & Gallagher LLP 7047 | 2021-11-22 | Willkie Farr & Gallagher LLP | 787 Seventh Avenue | New York | NY | 10019 | ||
2433 | 2433 | 2017-12-19 | Morin | Vanessa | Quinn & Co. of NY LTD. 6433 | 2017-05-24 | Quinn & Co. of NY LTD. | 48 W 38th Street, 12th Floor | New York | NY | 10018 | ||
2445 | 2445 | 2017-12-21 | Szeto | Stefanie | Quinn & Co. of NY LTD. 6433 | 2017-05-24 | Quinn & Co. of NY LTD. | 48 W 38th Street, 12th Floor | New York | NY | 10018 | ||
2495 | 2495 | 1948-01-01 | 1943-04-16 | Trzecieski | Anthony | Gdynia American Line, Inc. 81 | 1942-08-03 | Gdynia American Line, Inc. | 115 Broadway | New York | NY | 10006 | |
2496 | 2496 | 1948-01-01 | 1947-12-01 | Wynne | Rita Florence | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 | |
2498 | 2498 | 1949-01-01 | 1947-07-25 | Ware | Margaret Amy Jessica | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
2499 | 2499 | 1950-01-01 | 1947-07-25 | Watson | Francis Leslie | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
2500 | 2500 | 1952-01-01 | 1950-03-27 | Bergman | Uri | Israel Government Tourist Office 620 | 1950-03-27 | Israel Government Tourist Office | 350 Fifth Avenue | New York | NY | 10118 | |
2501 | 2501 | 1953-01-01 | 1953-01-08 | Pawtowicz | Tadeusz Aleksander | Polish Freedom Movement 630 | 1950-07-10 | Polish Freedom Movement | 28 West 83rd Street | New York | NY | ||
2506 | 2506 | 1956-01-01 | 1955-03-07 | Lapan | Sonya | Israel Government Tourist Office 620 | 1950-03-27 | Israel Government Tourist Office | 350 Fifth Avenue | New York | NY | 10118 | |
2507 | 2507 | 1956-01-01 | 1956-03-27 | Pekelharing | Rudolf C. | Films of the Nations, Inc. 353 | 1946-04-22 | Films of the Nations, Inc. | 18 West 55th Street | New York | NY | ||
2512 | 2512 | 1958-01-01 | 1957-08-15 | Michalski | Edward Leon | Polonia International, Inc. 1054 | 1957-07-30 | Polonia International, Inc. | 55 West 42nd Street | New York | NY | ||
2522 | 2522 | 1960-01-01 | 1956-11-20 | White | Bert E. | American Express Company 981 | 1956-11-20 | American Express Company | 65 Broadway | New York | NY | ||
2523 | 2523 | 1961-01-01 | 1960-10-20 | Resnick | Michael | Artkino Pictures, Inc. 103 | 1942-08-22 | Artkino Pictures, Inc. | 410 East 62nd Street | New York | NY | 10021 | |
2530 | 2530 | 1964-01-01 | 1946-06-10 | Donovan | Cornelius B. | Charles W. Hoyt Company, Inc. 361 | 1946-06-10 | Charles W. Hoyt Company, Inc. | 380 Madison Avenue | New York | NY | 10017 | |
2533 | 2533 | 1965-01-01 | 1965-09-12 | Shadi | Mohammed Fouad | Egyptian Government Tourist Office 1322 | 1960-01-13 | Egyptian Government Tourist Office | 630 Fifth Avenue | New York | NY | 10020 | |
2540 | 2540 | 1967-01-01 | 1966-04-15 | Bernstein | Phyllis | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | 665 Fifth Avenue | New York | NY | 10022 | |
2541 | 2541 | 1967-01-01 | 1962-07-24 | Casey | James Joseph | Casey, Lane & Mittendorf 1553 | 1962-07-02 | Casey, Lane & Mittendorf | 26 Broadway | New York | NY | 10004 | |
2542 | 2542 | 1968-01-01 | 1967-04-21 | Fajardo | Manuel Garcia | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | 665 Fifth Avenue | New York | NY | 10022 | |
2544 | 2544 | 1969-01-01 | 1968-02-02 | Cohan | Carole | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
2545 | 2545 | 1969-01-01 | 1968-07-03 | Amato | Alphonso | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
2546 | 2546 | 1969-01-01 | 1968-07-03 | Wexler | Francine | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
2549 | 2549 | 1970-01-01 | 1969-02-26 | Cavalcanti | Geraldo Holanda | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | 1350 Avenue of the Americas | New York | NY | 10019 | |
2550 | 2550 | 1970-01-01 | 1969-03-11 | Peck | Ralph H. | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | 665 Fifth Avenue | New York | NY | 10022 | |
2555 | 2555 | 1971-01-01 | 1950-08-28 | Schoenfeld | Lester Alvin | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
2556 | 2556 | 1971-01-01 | 1968-11-04 | Zhigulev | Alexander Ivanovich | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 | |
2557 | 2557 | 1972-01-01 | 1971-09-20 | Grinere | Rose M. | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
2558 | 2558 | 1972-01-01 | 1971-09-20 | Zuspan | William H. | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
2562 | 2562 | 1974-01-01 | 1971-02-22 | Cordon | Susie H. | Sydney Morrell & Company, Inc. 1661 | 1963-10-11 | Sydney Morrell & Company, Inc. | 152 East 78th Street | New York | NY | 10021 | |
2565 | 2565 | 1974-01-01 | 1969-07-18 | Pankin | Guenadi | Bulgarian Tourist Office 2148 | 1969-07-18 | Bulgarian Tourist Office | 161 East 86th Street | New York | NY | 10028 | |
2569 | 2569 | 1975-01-01 | 1974-08-01 | Wang | Francis S.L. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
2572 | 2572 | 1976-01-01 | 1975-02-18 | Young | John Timothy | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
2576 | 2576 | 1977-01-01 | 1975-08-20 | Mandel | Stuart Jay | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
2579 | 2579 | 1978-01-01 | 1975-02-18 | Haberkern | Roy C. , Jr. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
2581 | 2581 | 1978-01-01 | 1976-09-03 | Proske | Wieland | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
2584 | 2584 | 1979-01-01 | 1978-08-09 | Cleff-Klages | Karin | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
2587 | 2587 | 1980-01-01 | 1977-03-01 | Schechter | Diane | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );