FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
352 rows where Zip = 10036
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number >30
- Ogilvy Group LLC 86
- China Daily Distribution Corporation 23
- Portuguese National Tourist Office 21
- Ogilvy Group, LLC 17
- Trinidad & Tobago Tourist Board 16
- Friends of Sinn Fein, Inc. 16
- White & Case LLP 16
- Ogilvy Public Relations 14
- Gavin Anderson Doremus & Company 12
- Whitman & Ransom 9
- PRICEWATERHOUSECOOPERS, L.L.P. 9
- Mutch Haberman Howard, Inc. 8
- Portuguese Government Trade Office 7
- Ogilvy Public Relations 7
- Polish National Tourist Office, New York 6
- Dentsu Corporation of America 6
- Michael Solomon Associates 6
- Panama Government Tourist Bureau 4
- James F. Fox, Inc. 4
- International Marketing Group 4
- Fenton Communications 4
- Xinhua News Agency North America 4
- James F. Fox, Inc. 3
- Planned Television Arts 3
- Bonaire Government Tourist Bureau 3
- Netherlands/Antilles Economic Mission 3
- Augay Enterprises, Inc. 3
- Jensen/Boga Inc. 3
- 42West, LLC 3
- Korea Tourist Association 2
- …
Registrant_Name >30
- Ogilvy Group LLC 86
- China Daily Distribution Corporation 23
- Ogilvy Public Relations 21
- Portuguese National Tourist Office 21
- Ogilvy Group, LLC 17
- Friends of Sinn Fein, Inc. 16
- Trinidad & Tobago Tourist Board 16
- White & Case LLP 16
- Gavin Anderson Doremus & Company 12
- James F. Fox, Inc. 9
- PRICEWATERHOUSECOOPERS, L.L.P. 9
- Whitman & Ransom 9
- Mutch Haberman Howard, Inc. 8
- Portuguese Government Trade Office 7
- Dentsu Corporation of America 6
- Michael Solomon Associates 6
- Polish National Tourist Office, New York 6
- Fenton Communications 4
- International Marketing Group 4
- Panama Government Tourist Bureau 4
- Xinhua News Agency North America 4
- 42West, LLC 3
- Augay Enterprises, Inc. 3
- Bonaire Government Tourist Bureau 3
- Jensen/Boga Inc. 3
- Netherlands/Antilles Economic Mission 3
- Planned Television Arts 3
- 5W Public Relations, LLC 2
- Berkowitz, Boyar & Higgins 2
- Business Council for International Understanding, Inc. (BCIU) 2
- …
Address_2 15 ✖
- - 253
- Suite 2800 23
- 5th Floor 16
- Suite 1508 16
- 8th Floor 12
- Suite 801 6
- Room 2225 5
- 10th Floor 4
- Floor 44 4
- Suite 910 4
- 12th Floor 3
- 42nd Floor 2
- 4th Floor 2
- 334 West 46th Street, Suite 2 1
- 550 Fifth Avenue 1
State 1
- NY 352
City 1
- New York 352
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37 | 37 | Prendergast | Olivia | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | |||
70 | 70 | 2022-01-06 | Ling | Margaret R | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
76 | 76 | 2022-01-07 | Castro | Erika Urgiles | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
77 | 77 | 2022-01-07 | Ramano | Chrikstine | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
78 | 78 | 2022-01-07 | Romero | Andrea | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
79 | 79 | 2022-01-07 | Rose | Michaelann | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
80 | 80 | 2022-01-07 | Simon | Sean | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
81 | 81 | 2022-01-07 | Smith | Melissa | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
82 | 82 | 2022-01-07 | Tay | Lilyan | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
83 | 83 | 2022-01-07 | Zumwalt | Denee | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
90 | 90 | 2022-01-10 | Applegate | Alyssa | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
91 | 91 | 2022-01-10 | Daniel | Hannah | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
92 | 92 | 2022-01-10 | Fabinao | Jillian | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
93 | 93 | 2022-01-10 | Mullins | Tara | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
94 | 94 | 2022-01-10 | Ortiz | Cathy | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
95 | 95 | 2022-01-10 | Risi | Jennifer | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
183 | 183 | 2022-01-24 | Crawford | Camilyn | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
185 | 185 | 2022-01-24 | Hanna | Edmund | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
302 | 302 | 2019-02-04 | DeLelle | Claire | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | ||
303 | 303 | 2019-02-04 | Erb | Nicole | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | ||
304 | 304 | 2019-02-04 | McLaughlin | Celia | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | ||
433 | 433 | 2021-02-21 | Calveiro | Lisette | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
496 | 496 | 2020-03-04 | Baumann | Terri | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
497 | 497 | 2020-03-04 | Dickson | Madeline | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
498 | 498 | 2020-03-04 | Mackenzie | Kimberly | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
499 | 499 | 2020-03-04 | Merritt | Matthew | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
500 | 500 | 2020-03-04 | Pope | Kristie | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
501 | 501 | 2020-03-04 | Redmond | Hillary | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
502 | 502 | 2020-03-04 | Vardaro | Valerie | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
513 | 513 | 2017-03-06 | Guilfoyle | Mark | Friends of Sinn Fein, Inc. 5006 | 1995-04-03 | Friends of Sinn Fein, Inc. | 1212 Avenue of the Americas | 5th Floor | New York | NY | 10036 | |
545 | 545 | 2021-03-10 | Maranzani | Martha | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
546 | 546 | 2021-03-10 | Reiss | Christina | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
582 | 582 | 2021-03-16 | Kaiser | Michael | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
583 | 583 | 2021-03-16 | Williams | Ansley | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
639 | 639 | 2022-03-24 | Atta | Kobby Amoako | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
640 | 640 | 2022-03-24 | Chiu | Leslie Tan | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
641 | 641 | 2022-03-24 | Fishel | Gayle | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
642 | 642 | 2022-03-24 | Jimenez | Camilo | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
643 | 643 | 2022-03-24 | Pettersson | Leah | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
644 | 644 | 2022-03-24 | Romano | Christine | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
645 | 645 | 2022-03-24 | Sass | Rebecca | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
646 | 646 | 2022-03-24 | Sotelo | Barbara Tamra | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
652 | 652 | 2022-03-25 | Kretzschmar | Natalie | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
653 | 653 | 2022-03-25 | Lopez | Jissette | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
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 | ||
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 | |
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 | |
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 | |
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 | ||
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 | ||
1182 | 1182 | 2022-06-01 | Otillar | Steven | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | ||
1233 | 1233 | 2022-06-14 | Hilton | Katherine | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
1235 | 1235 | 2022-06-14 | Schubert | Sherri | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
1291 | 1291 | 2018-06-25 | Curran | Christopher M. | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | ||
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 | ||
1610 | 1610 | 2011-08-14 | Serviss | Ben | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 | |
1665 | 1665 | 2022-08-26 | O'Loughlin | Gregory | Friends of Sinn Fein, Inc. 5006 | 1995-04-03 | Friends of Sinn Fein, Inc. | 1212 Avenue of the Americas | 5th Floor | New York | NY | 10036 | |
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 | ||
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 | ||
2091 | 2091 | 2020-11-02 | Aaron | Michael | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2096 | 2096 | 2020-11-02 | Irons | Todd | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2098 | 2098 | 2020-11-02 | Kress | Jason | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2100 | 2100 | 2020-11-02 | Weiss | Sophia | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
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 | ||
2179 | 2179 | 2022-11-17 | Urbach | Brooke | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2287 | 2287 | 2011-11-30 | Wang | Jun | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 | |
2386 | 2386 | 2002-12-12 | Huang | Qing | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 | |
3716 | 3716 | 2020-01-14 | 2016-05-12 | Zhang | Yuan | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
3720 | 3720 | 2022-01-14 | 2020-03-04 | Harrison | Melissa | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | |
3764 | 3764 | 1975-01-15 | 1974-03-12 | Falcao | Carlos P. | Portuguese Government Trade Office 2353 | 1972-07-10 | Portuguese Government Trade Office | 548 Fifth Avenue | New York | NY | 10036 | |
4949 | 4949 | 1974-01-31 | 1973-06-12 | Castel-Branco | Antonio | Portuguese National Tourist Office 172 | 1943-01-23 | Portuguese National Tourist Office | 570 Fifth Avenue | New York | NY | 10036 | |
4960 | 4960 | 1978-01-31 | 1975-02-25 | Barry | Kevin P. | Portuguese Government Trade Office 2353 | 1972-07-10 | Portuguese Government Trade Office | 548 Fifth Avenue | New York | NY | 10036 | |
5193 | 5193 | 1998-01-31 | 1996-07-31 | Katoh | Yasuyuki | IBC New York, Inc. 5125 | 1996-07-31 | IBC New York, Inc. | 1211 Avenue of the Americas | 42nd Floor | New York | NY | 10036 |
5208 | 5208 | 1999-01-31 | 1995-10-31 | Clifford | Kieran | Friends of Sinn Fein, Inc. 5006 | 1995-04-03 | Friends of Sinn Fein, Inc. | 1212 Avenue of the Americas | 5th Floor | New York | NY | 10036 |
5224 | 5224 | 2000-01-31 | 1998-10-09 | Carraro | Robert J. | Michael Solomon Associates 3923 | 1987-01-06 | Michael Solomon Associates | 516 Fifth Avenue | Suite 801 | New York | NY | 10036 |
5451 | 5451 | 2011-01-31 | 2011-08-14 | Preimesberger | Mei | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
5497 | 5497 | 2015-01-31 | 2011-11-30 | Liu | Lian | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
5735 | 5735 | 1983-02-01 | 1981-05-18 | Lewis | Selman | Trinidad & Tobago Tourist Board 3231 | 1981-04-20 | Trinidad & Tobago Tourist Board | 25 West 43rd Street | Suite 1508 | New York | NY | 10036 |
6104 | 6104 | 1966-02-04 | 1966-02-04 | Fox | James F. | James F. Fox, Inc. 1960 | 1966-02-04 | James F. Fox, Inc. | 500 Fifth Avenue | Room 2225 | New York | NY | 10036 |
6105 | 6105 | 1966-02-04 | 1966-02-04 | McGarry | Bart J. | James F. Fox, Inc. 1960 | 1966-02-04 | James F. Fox, Inc. | 500 Fifth Avenue | Room 2225 | New York | NY | 10036 |
6106 | 6106 | 1966-02-04 | 1966-02-04 | Williams | F. Bryan , Jr. | James F. Fox, Inc. 1960 | 1966-02-04 | James F. Fox, Inc. | 500 Fifth Avenue | Room 2225 | New York | NY | 10036 |
6117 | 6117 | 1980-02-04 | 1975-11-07 | Nery | Eduardo Montez | Portuguese National Tourist Office 172 | 1943-01-23 | Portuguese National Tourist Office | 570 Fifth Avenue | New York | NY | 10036 | |
6168 | 6168 | 1979-02-05 | 1975-11-14 | Isip | Rey | Marckrey 2631 | 1975-11-14 | Marckrey | 45 West 45th Street | New York | NY | 10036 | |
6169 | 6169 | 1979-02-05 | 1975-11-14 | Marck | George | Marckrey 2631 | 1975-11-14 | Marckrey | 45 West 45th Street | New York | NY | 10036 | |
6434 | 6434 | 2019-02-08 | 2018-09-28 | Sfikas | Athanasia | Ogilvy Group, LLC 6585 | 2018-08-30 | Ogilvy Group, LLC | 636 11th Avenue | New York | NY | 10036 | |
7094 | 7094 | 1990-02-16 | 1989-10-17 | Cornell | James | Gavin Anderson Doremus & Company 3378 | 1982-06-15 | Gavin Anderson Doremus & Company | 11 West 42nd Street | 8th Floor | New York | NY | 10036 |
7260 | 7260 | 2020-02-19 | 2019-07-25 | Erb | Nicole | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | |
7261 | 7261 | 2020-02-19 | 2019-07-25 | Hershman | Scott | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | |
7262 | 7262 | 2020-02-19 | 2019-07-25 | Lamm | Carolyn Beth | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 |
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]) );