FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15,598 rows where State = "NY"
This data as json, CSV (advanced)
Registration_Number >30
- JETRO, New York 483
- White & Case, LLP 413
- Quebec Government Office 380
- 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 198
- GCI Group, Inc. 186
- Ketchum Inc. NY 175
- New York Bureau of the Telegraph Agency of Russia (TASS) 153
- IPG DXTRA, Inc 152
- Japan National Tourism Organization 150
- 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
- McCann-Erickson, Inc. 110
- IDA Ireland 107
- Bermuda Tourism Authority 101
- U.S. Office of the British Broadcasting Corporation 98
- Jamaica Progressive League, Inc. 97
- Doremus & Company 96
- Swedish-American Chamber of Commerce, Inc. 92
- Israel Government Tourist Office 92
- VisitBritain 91
- Cayman Islands Department of Tourism 90
- European Travel Commission 87
- …
Registrant_Name >30
- JETRO, New York 483
- White & Case, LLP 413
- Quebec Government Office 380
- KOTRA 358
- Ruder Finn, Inc. 346
- 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 198
- GCI Group, Inc. 186
- Ketchum Inc. NY 175
- New York Bureau of the Telegraph Agency of Russia (TASS) 153
- IPG DXTRA, Inc 152
- Japan National Tourism Organization 150
- 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 107
- Bermuda Tourism Authority 101
- U.S. Office of the British Broadcasting Corporation 98
- Jamaica Progressive League, Inc. 97
- Israel Government Tourist Office 92
- Swedish-American Chamber of Commerce, Inc. 92
- VisitBritain 91
- Cayman Islands Department of Tourism 90
- European Travel Commission 87
- …
City >30
- New York 14,768
- New York 188
- Jamaica 98
- Brooklyn 58
- Staten Island 31
- Syracuse 31
- Manhattan 18
- Albany 14
- Bronxville 13
- White Plains 13
- Buffalo 11
- Jackson Heights 11
- Yorktown Heights 11
- Long Island City 10
- Muttontown 10
- New Rochelle 10
- Bronx 9
- Hamburg 8
- Garden City 7
- Hempstead 6
- Long Island 6
- New York City 6
- Bedford 5
- Flushing 5
- Hawthorne 4
- Mount Vernon 4
- Scarsdale 4
- Yonkers 4
- Carmel 3
- Elmhurst 3
- …
State 1
- NY · 15,406 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
713 | 713 | 2023-03-31 | Franco | Marc | USSA International LLC 7252 | 2023-03-31 | USSA International LLC | 767 5th Avenue, 45th Floor | New York | NY | 10153 | ||
714 | 714 | 2023-03-31 | Mehmood | Ibraheem | USSA International LLC 7252 | 2023-03-31 | USSA International LLC | 767 5th Avenue, 45th Floor | New York | NY | 10153 | ||
720 | 720 | 2022-04-01 | Fujioka | Yota | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
722 | 722 | 2023-04-03 | Liew | Wei Qiang Danny | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
724 | 724 | 2023-04-04 | Hirano | Yuichiro | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 | |
728 | 728 | 2022-04-05 | Chia | Qian Hui | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
729 | 729 | 2022-04-05 | Hui | Sarah Thiam Jia | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
730 | 730 | 2022-04-05 | Kwan | Siku On Ann | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
731 | 731 | 2022-04-05 | Lim | Songwei Joshua | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
732 | 732 | 2022-04-05 | Tay | Jun Long | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
733 | 733 | 2022-04-05 | Wong | Ji Inn | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
734 | 734 | 2022-04-05 | Zheng | Jingxin | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
735 | 735 | 2022-04-06 | Enkhbaatar | Odsuren | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
742 | 742 | 2013-04-08 | Frank | Andrew D. | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | 122 East 42nd Street | Suite 2005 | New York | NY | 10168 | |
744 | 744 | 2022-04-08 | Bissacot | Denise Charlier | Havas Media Group USA LLC 7106 | 2022-04-08 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | ||
745 | 745 | 2022-04-08 | Grande | Ginger | Havas Media Group USA LLC 7106 | 2022-04-08 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | ||
750 | 750 | 2020-04-09 | Binder | Amy | RF Binder Partners Inc. 6814 | 2020-04-09 | RF Binder Partners Inc. | 950 Third Avenue | 7th Floor | New York | NY | 10022 | |
751 | 751 | 2020-04-09 | Maroni | William | RF Binder Partners Inc. 6814 | 2020-04-09 | RF Binder Partners Inc. | 950 Third Avenue | 7th Floor | New York | NY | 10022 | |
752 | 752 | 2020-04-09 | McBride | William | RF Binder Partners Inc. 6814 | 2020-04-09 | RF Binder Partners Inc. | 950 Third Avenue | 7th Floor | New York | NY | 10022 | |
767 | 767 | 2023-04-11 | Hunter | Hannah | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | 122 East 42nd Street | Suite 2005 | New York | NY | 10168 | |
768 | 768 | 2023-04-11 | Rose Frank | Alessandra Tehya | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | 122 East 42nd Street | Suite 2005 | New York | NY | 10168 | |
771 | 771 | 2023-04-12 | Helfman | Scott | USSA International LLC 7252 | 2023-03-31 | USSA International LLC | 767 5th Avenue, 45th Floor | New York | NY | 10153 | ||
773 | 773 | 2022-04-13 | O'Flaherty | Catherina | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
774 | 774 | 2022-04-13 | O'Mahony | Tara | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
775 | 775 | 2022-04-13 | Curley | Paul | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
776 | 776 | 2022-04-13 | Leonard | Mark | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
778 | 778 | 2022-04-13 | Trautt | Enda | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
779 | 779 | 2023-04-13 | Chmara | Lauren | Teneo Strategy LLC 6698 | 2019-07-08 | Teneo Strategy LLC | 280 Park Avenue | 4th Floor | New York | NY | 10017 | |
782 | 782 | 2011-04-14 | Danisman | Janet | Bavarian U.S. Offices for Economic Development, LLC 6015 | 2011-01-07 | Bavarian U.S. Offices for Economic Development, LLC | 80 Pine Street | 24th Floor | New York | NY | 10005 | |
795 | 795 | 2022-04-15 | O'Brien | Damien | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
796 | 796 | 2022-04-15 | O'Brien | Mark | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
797 | 797 | 2022-04-15 | Allen | Gemma | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
798 | 798 | 2022-04-15 | Benson | Jessica Niamh | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
799 | 799 | 2022-04-15 | Carroll | Seamus | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
800 | 800 | 2022-04-15 | Cowley | Maeve Bernadette | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
801 | 801 | 2022-04-15 | Dempsey | Gary | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
802 | 802 | 2022-04-15 | Houlihan | Ivan Patrick | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
803 | 803 | 2022-04-15 | Jones | David | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
804 | 804 | 2022-04-15 | Loughran | Michelle | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
805 | 805 | 2022-04-15 | Lynch | Suzanne Helen | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
806 | 806 | 2022-04-15 | McGee | Patrick Joseph | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
807 | 807 | 2022-04-15 | Mooney | Doireann Eilish | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
808 | 808 | 2022-04-15 | Storan | Michael | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
809 | 809 | 2022-04-15 | Veale | James Paul | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
812 | 812 | 2021-04-16 | McGarry | Kelly | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
814 | 814 | 2021-04-16 | Ting | Laura | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
815 | 815 | 2023-04-16 | Bragg | Kyle Edward | BMW Government Relations LLC 7258 | 2023-04-16 | BMW Government Relations LLC | 24907 Memphis Avenue | Rosedale | NY | 11422 | ||
824 | 824 | 2022-04-18 | Ames | Helen | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 301 E. 57th Street | New York | NY | 10022 | ||
826 | 826 | 2022-04-18 | Ruebsteck | Sharon | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 301 E. 57th Street | New York | NY | 10022 | ||
836 | 836 | 2023-04-19 | Sinkovitz | Lily | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
839 | 839 | 2020-04-20 | Chia | Min Xin Jeff | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
840 | 840 | 2020-04-20 | Lim | Xuan Hong | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
841 | 841 | 2020-04-20 | Wen | Ng Wei | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 | |
843 | 843 | 2023-04-20 | Cyrille | Laura | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | |
845 | 845 | 2023-04-20 | Scarinzi | Chip | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
865 | 865 | 2020-04-24 | Ng | Qi Hui | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 | |
867 | 867 | 2023-04-24 | Johnson | Stephanie | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
870 | 870 | 2023-04-24 | Mignott | Noel | PM Group, LLC 7262 | 2023-04-24 | PM Group, LLC | 300 East 46th Street, 2J | New York | NY | 10017 | ||
877 | 877 | 2018-04-26 | Allman | Ryan | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 246 Fifth Avenue | New York | NY | 10001 | ||
883 | 883 | 2023-04-26 | Curry | Brent | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | |
888 | 888 | 2023-04-26 | Zaher | Mariana Awad | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 | |
889 | 889 | 2017-04-27 | Gauger | Paul | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
890 | 890 | 2018-04-27 | Ahn | Debbie | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 | |
892 | 892 | 2022-04-27 | Gonzalez-Hernandez | Alicia | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | |
893 | 893 | 2022-04-27 | Kvachadze | Natia | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | |
896 | 896 | 2022-04-27 | Peretti | Chiara Giulia` | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | |
924 | 924 | 2018-04-30 | Meliti | Amalia | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | |
940 | 940 | 2021-04-30 | Curren | Dariel | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | |
943 | 943 | 2021-04-30 | Middleton | Daniella | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | |
945 | 945 | 2021-04-30 | Snyder | Justin | Terakeet LLC 6806 | 2020-03-24 | Terakeet LLC | 333 West Washington Street, Suite 500 | Syracuse | NY | 13202 | ||
955 | 955 | 2018-05-03 | Berry | Cait | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
956 | 956 | 2018-05-03 | Landry | Gavin | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
960 | 960 | 2021-05-05 | Bailey | Elyse | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
961 | 961 | 2021-05-05 | Didi | Tara | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
962 | 962 | 2021-05-05 | Gordin | Julia | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
963 | 963 | 2021-05-05 | Heasman | Jonathan | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
964 | 964 | 2021-05-05 | Heller | Leila | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
965 | 965 | 2021-05-05 | Jungkurth | Allison | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
966 | 966 | 2021-05-05 | Liang | Yan | Xinhua News Agency North America 6958 | 2021-05-05 | Xinhua News Agency North America | 1540 Broadway | Floor 44 | New York | NY | 10036 | |
967 | 967 | 2021-05-05 | Lin | Xia | Xinhua News Agency North America 6958 | 2021-05-05 | Xinhua News Agency North America | 1540 Broadway | Floor 44 | New York | NY | 10036 | |
968 | 968 | 2021-05-05 | McKay | Tiffany | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
970 | 970 | 2021-05-05 | Wylie | Sheelagh | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
971 | 971 | 2021-05-05 | Xingtang | Xu | Xinhua News Agency North America 6958 | 2021-05-05 | Xinhua News Agency North America | 1540 Broadway | Floor 44 | New York | NY | 10036 | |
980 | 980 | 2020-05-08 | Chinwuba | Chukwuemeka Charles | Baker & McKenzie 6821 | 2020-05-08 | Baker & McKenzie | 452 5th Avenue | New York | NY | 10018 | ||
981 | 981 | 2020-05-08 | Georgaklis | Christina | Baker & McKenzie 6821 | 2020-05-08 | Baker & McKenzie | 452 5th Avenue | New York | NY | 10018 | ||
992 | 992 | 2022-05-09 | Gonzales-Hernandez | Alicia | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | |
1001 | 1001 | 2022-05-11 | Sequeira | Marianne | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 | |
1005 | 1005 | 2016-05-12 | Ji | Tao | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 | |
1006 | 1006 | 2022-05-12 | Bishop | Leslie | 5W Public Relations, LLC 7118 | 2022-05-12 | 5W Public Relations, LLC | 3 Park Avenue | 19th Floor | New York | NY | 10016 | |
1048 | 1048 | 2022-05-18 | Turan | Behram | Turken Foundation Inc. 7121 | 2022-05-18 | Turken Foundation Inc. | 4 West, 43rd Street, #316 | New York | NY | 10036 | ||
1049 | 1049 | 2022-05-18 | Yetim | Memis | Turken Foundation Inc. 7121 | 2022-05-18 | Turken Foundation Inc. | 4 West, 43rd Street, #316 | New York | NY | 10036 | ||
1054 | 1054 | 2009-05-19 | Barnette | Justin | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 | |
1055 | 1055 | 2011-05-19 | Aberaouz | Hamid | Moroccan National Tourist Office 1793 | 1964-09-21 | Moroccan National Tourist Office | 104 West 40th Street | Suite 1820 | New York | NY | 10018 | |
1056 | 1056 | 2011-05-19 | Ghadouani | Chakib El Mokhtar | Moroccan National Tourist Office 1793 | 1964-09-21 | Moroccan National Tourist Office | 104 West 40th Street | Suite 1820 | New York | NY | 10018 | |
1064 | 1064 | 2020-05-20 | Eliano | Liza | Brunswick Group LLC 6826 | 2020-05-20 | Brunswick Group LLC | 245 Park Avenue | 14th Floor | New York | NY | 10167 | |
1065 | 1065 | 2020-05-20 | Sleiman | Dana Ghaleb | Brunswick Group LLC 6826 | 2020-05-20 | Brunswick Group LLC | 245 Park Avenue | 14th Floor | New York | NY | 10167 | |
1066 | 1066 | 2022-05-20 | Boesen | Madelyn | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
1067 | 1067 | 2022-05-20 | Sequeira | Siddhanth Iyer | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
1085 | 1085 | 2022-05-23 | Gross | Dyneisha | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
1101 | 1101 | 2010-05-25 | Wieck | Reinhard | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
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]) );