FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
42,460 rows sorted by Address_2
This data as json, CSV (advanced)
State >30
Registration_Number >30
- Hill and Knowlton Strategies, LLC 990
- Daniel J. Edelman, Inc. 573
- JETRO, New York 490
- Quebec Government Office 417
- KOTRA 358
- Burson-Marsteller 353
- Amtorg Trading Corporation 331
- Squire, Sanders & Dempsey, L.L.P. 327
- QORVIS LLC 305
- Arnold & Porter Kaye Scholer LLP 303
- Ogilvy Public Relations Worldwide 299
- White & Case, LLP 286
- Daniel J. Edelman, Inc. 251
- Squire Patton Boggs, LLP 248
- Ruder Finn, Inc. 227
- Bahamas Tourist Office 205
- Netherlands Chamber of Commerce in the U.S., Inc. 200
- Akin, Gump, Strauss, Hauer & Feld, LLP 200
- Singapore Economic Development Board 199
- JETRO, Chicago 196
- DLA Piper US LLP 186
- GCI Group, Inc. 186
- JETRO, Los Angeles 184
- MMGY Global, LLC 182
- Mercury Public Affairs, LLC 153
- Saatchi & Saatchi North America, Inc. 150
- BCW LLC 142
- Fleishman-Hillard, Inc. 140
- Government of Ontario, Canada 136
- American Section of the Jewish Agency for Israel 133
- …
Registrant_Name >30
- Hill and Knowlton Strategies, LLC 990
- Daniel J. Edelman, Inc. 840
- JETRO, New York 490
- Quebec Government Office 417
- KOTRA 358
- Burson-Marsteller 356
- Amtorg Trading Corporation 331
- Squire, Sanders & Dempsey, L.L.P. 327
- QORVIS LLC 305
- Arnold & Porter Kaye Scholer LLP 303
- Ogilvy Public Relations Worldwide 299
- White & Case, LLP 286
- Ruder Finn, Inc. 274
- Squire Patton Boggs, LLP 248
- Fleishman-Hillard, Inc. 227
- Bahamas Tourist Office 205
- Akin, Gump, Strauss, Hauer & Feld, LLP 200
- Netherlands Chamber of Commerce in the U.S., Inc. 200
- Singapore Economic Development Board 199
- JETRO, Chicago 196
- APCO Worldwide, Inc. 188
- DLA Piper US LLP 186
- GCI Group, Inc. 186
- JETRO, Los Angeles 184
- MMGY Global, LLC 182
- Mercury Public Affairs, LLC 153
- Cassidy & Associates, Inc. 151
- Saatchi & Saatchi North America, Inc. 150
- BCW LLC 142
- Government of Ontario, Canada 136
- …
City >30
- Washington 14,529
- New York 12,704
- Chicago 1,342
- Los Angeles 1,051
- San Francisco 481
- Miami 353
- Houston 308
- Arlington 282
- St. Louis 277
- Overland Park 274
- Alexandria 240
- Nassau 205
- Seattle 177
- Boston 166
- Atlanta 164
- New York 157
- Philadelphia 151
- Cambridge 111
- Bethesda 102
- Denver 100
- Jamaica 98
- Bannockburn 95
- London 91
- Austin 87
- Silver Spring 86
- Dallas 74
- Detroit 63
- Reston 57
- Santa Monica 51
- Fairhaven 50
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13005 | 13005 | 1985-04-09 | 1973-06-12 | Samokish | Nina | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13006 | 13006 | 1985-04-09 | 1973-06-12 | Sharvan | Wasyl | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13007 | 13007 | 1985-04-09 | 1973-06-12 | Swan | Thomas | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13008 | 13008 | 1985-04-09 | 1963-06-14 | Gotman | Kateryna | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13009 | 13009 | 1985-04-09 | 1958-06-20 | Abrahamian | Onik | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13010 | 13010 | 1985-04-09 | 1958-06-20 | Levy | Henry | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13011 | 13011 | 1985-04-09 | 1961-06-28 | Starosielski | Julian | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13012 | 13012 | 1985-04-09 | 1966-06-28 | Vislocky | William | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13013 | 13013 | 1985-04-09 | 1975-06-30 | Wirlo | Vera | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13014 | 13014 | 1985-04-09 | 1973-07-10 | Babiak | Klemens | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13015 | 13015 | 1985-04-09 | 1965-07-22 | Bikow | Artamon | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13016 | 13016 | 1985-04-09 | 1973-08-06 | Abrahamian | Onik | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13017 | 13017 | 1985-04-09 | 1973-08-06 | Brendzey | Stefan | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13018 | 13018 | 1985-04-09 | 1973-08-06 | Frankfurt | Nathaniel | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13019 | 13019 | 1985-04-09 | 1973-08-06 | Gotman | Katezyna | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13020 | 13020 | 1985-04-09 | 1973-08-06 | Klamfer | Max | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13021 | 13021 | 1985-04-09 | 1973-08-06 | Kujtkowski | Harry | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13022 | 13022 | 1985-04-09 | 1973-08-06 | Svenchansky | A. | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13023 | 13023 | 1985-04-09 | 1961-08-08 | Kraft | Alexander Krawczenko | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13024 | 13024 | 1985-04-09 | 1973-08-14 | Vislocky | William | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13025 | 13025 | 1985-04-09 | 1963-10-02 | Szarwan | Wasyl | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13026 | 13026 | 1985-04-09 | 1960-10-10 | Podoba | Theodore | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13027 | 13027 | 1985-04-09 | 1962-10-10 | Duke | Zurach | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13028 | 13028 | 1985-04-09 | 1958-10-16 | Komarnycky | Bohdan | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13029 | 13029 | 1985-04-09 | 1960-10-17 | Babiak | Joanna | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13030 | 13030 | 1985-04-09 | 1961-10-23 | Feigelson | Moses | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13031 | 13031 | 1985-04-09 | 1962-12-26 | Swan | Thomas | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13044 | 13044 | 1996-04-09 | 1995-02-17 | Johnson | Richard A. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
13045 | 13045 | 1996-04-09 | 1985-06-26 | Aslan | Shaoul | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
13046 | 13046 | 1998-04-09 | 1997-07-21 | Smith | Dov | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
13047 | 13047 | 1999-04-09 | 1999-04-01 | Beeson | Simon | Yorkshire Forward ( Yorkshire and Humber Regional Development Agency) 5310 | 1999-04-01 | Yorkshire Forward ( Yorkshire and Humber Regional Development Agency) | 28 Junction Square | Concord | MA | 01742 | |
13050 | 13050 | 2002-04-09 | 2002-02-04 | Burdick | Jessica A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
13054 | 13054 | 2007-04-09 | 2007-03-30 | Przybyl | Regan | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
13059 | 13059 | 1950-04-10 | 1949-07-11 | Marshall | Joseph Paull | Goodwin, William J. 580 | 1949-07-11 | Goodwin, William J. | 528 Union Trust Building | Washington | DC | ||
13060 | 13060 | 1950-04-10 | 1949-08-16 | Goodwin | William J. | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
13063 | 13063 | 1964-04-10 | 1964-02-28 | Lewis | Philip C. | Marathon International Productions, Inc. 1695 | 1964-02-28 | Marathon International Productions, Inc. | 10 East 49th Street | New York | NY | 10017 | |
13064 | 13064 | 1967-04-10 | 1966-02-01 | Rogers | Gifford Eugene | Development & Resources Corporation 969 | 1956-08-02 | Development & Resources Corporation | 44 Wall Street | New York | NY | ||
13065 | 13065 | 1973-04-10 | 1948-04-16 | O'Brian | John Lord | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 888 - 16th Street, N.W. | Washington | DC | 20006 | |
13066 | 13066 | 1973-04-10 | 1972-04-27 | Simonsz | W.H. | Netherlands Information Service 2048 | 1966-12-31 | Netherlands Information Service | 601 California Street | San Francisco | CA | 94108 | |
13067 | 13067 | 1973-04-10 | 1955-05-10 | Bogaert | Josephus P.A.M. Den | Netherlands Information Service, New York 447 | 1947-03-14 | Netherlands Information Service, New York | 711 Third Avenue | New York | NY | 10017 | |
13068 | 13068 | 1975-04-10 | 1965-02-12 | d'Albis | Roland | French Expositions in the U.S., Inc. 1867 | 1965-03-12 | French Expositions in the U.S., Inc. | 810 Seventh Avenue | New York | NY | 10019 | |
13069 | 13069 | 1976-04-10 | 1973-10-30 | Gammon | Roland | Editorial Communications, Inc. 2473 | 1973-10-30 | Editorial Communications, Inc. | 655 Madison Avenue | New York | NY | 10021 | |
13070 | 13070 | 1977-04-10 | 1971-03-18 | Martin | Pierre G. | French Expositions in the U.S., Inc. 1867 | 1965-03-12 | French Expositions in the U.S., Inc. | 810 Seventh Avenue | New York | NY | 10019 | |
13072 | 13072 | 1985-04-10 | 1985-03-19 | Cicconi | James W. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
13073 | 13073 | 1986-04-10 | 1984-05-17 | de l'Estang | Francois Bujon | COGEMA, Inc. 3587 | 1984-05-17 | COGEMA, Inc. | 7401 Wisconsin Avenue | Bethesda | MD | 20814-3416 | |
13074 | 13074 | 1987-04-10 | 1984-01-04 | Bayless | James L. , Jr. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
13075 | 13075 | 1987-04-10 | 1987-01-05 | Rothstein | Richard J. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
13076 | 13076 | 1987-04-10 | 1986-10-03 | McGovern | John J. , Jr. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
13077 | 13077 | 1987-04-10 | 1984-10-16 | Schneider | Susanne | Austrian Business Agency 3620 | 1984-10-16 | Austrian Business Agency | 747 Third Avenue | New York | NY | 10017 | |
13084 | 13084 | 1991-04-10 | 1990-01-17 | Bloom | Evan | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
13090 | 13090 | 1992-04-10 | 1990-01-31 | Anderson | Robin | McCann Direct, Inc. 3922 | 1986-12-29 | McCann Direct, Inc. | 750 Third Avenue | New York | NY | 10017 | |
13092 | 13092 | 1992-04-10 | 1986-04-10 | Jones | Frederick Macy | Hill, Holliday, Connors, Cosmopulos, Inc. 3810 | 1986-04-10 | Hill, Holliday, Connors, Cosmopulos, Inc. | 200 Clarendon Street | Boston | MA | 02116 | |
13093 | 13093 | 1992-04-10 | 1990-07-18 | Kendrick | John J. , Jr. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
13094 | 13094 | 1992-04-10 | 1990-10-16 | Fitzpatrick | Mary Jean | Hill, Holliday, Connors, Cosmopulos, Inc. 3810 | 1986-04-10 | Hill, Holliday, Connors, Cosmopulos, Inc. | 200 Clarendon Street | Boston | MA | 02116 | |
13095 | 13095 | 1992-04-10 | 1990-11-07 | Panayotopoulou | Natasha | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
13098 | 13098 | 1998-04-10 | 1996-03-27 | Robinson | Karen A. | Leone & Leone, Ltd. 4619 | 1992-02-12 | Leone & Leone, Ltd. | 24743 Del Prado PMB #327 | Dana Point | CA | 92629-2852 | |
13100 | 13100 | 2000-04-10 | 1999-03-05 | Guarnieri | Rica M. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
13102 | 13102 | 2001-04-10 | 1989-03-03 | Gregory | John R. (Jack) | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
13109 | 13109 | 2007-04-10 | 2007-01-29 | Garcia | Alexander | OpinionMakers, LLC 5789 | 2007-01-29 | OpinionMakers, LLC | 4022 25th Road North | Arlington | VA | 22207 | |
13112 | 13112 | 2013-04-10 | 2013-03-01 | Yen | Jason | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
13114 | 13114 | 2013-04-10 | 2009-11-03 | Suringa | Dirk J.J. | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
13115 | 13115 | 2020-04-10 | 2017-12-20 | Powell | Brad | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
13116 | 13116 | 2021-04-10 | 2020-06-26 | Shaw | Steven | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
13121 | 13121 | 1946-04-11 | 1945-04-11 | Crhistiani | Henning O. | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13122 | 13122 | 1946-04-11 | 1945-04-11 | Host | Thorkil | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13123 | 13123 | 1946-04-11 | 1945-04-11 | Jacobsen | Halvor J.T. | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13124 | 13124 | 1946-04-11 | 1945-04-11 | Koefoed | S.M. | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13125 | 13125 | 1946-04-11 | 1945-04-11 | Madsen | Eick Lumbye | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13126 | 13126 | 1946-04-11 | 1945-04-11 | Mathiasen | Karl | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13127 | 13127 | 1946-04-11 | 1945-04-11 | Nielsen | Tage | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13128 | 13128 | 1946-04-11 | 1945-04-11 | Nyholm | Erik | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13129 | 13129 | 1946-04-11 | 1945-04-11 | Sorenson | William C. | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13130 | 13130 | 1946-04-11 | 1945-04-11 | Toksvig | Signe | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13131 | 13131 | 1946-04-11 | 1945-04-21 | Lorsentzen | Hans K. | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13132 | 13132 | 1946-04-11 | 1945-04-21 | Stig-Nielsen | Torkild | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13133 | 13133 | 1946-04-11 | 1945-08-25 | Hasselriis | Caspar Henrik Wolffsen | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
13135 | 13135 | 1958-04-11 | 1956-04-11 | Miller | Morris | Lucas, Scott W. 944 | 1956-04-11 | Lucas, Scott W. | 1025 Connecticut Avenue, N.W. | Washington | DC | ||
13136 | 13136 | 1966-04-11 | 1965-08-05 | Karp | David | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
13137 | 13137 | 1966-04-11 | 1964-11-30 | Olguin | Harriet | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
13138 | 13138 | 1967-04-11 | 1965-07-21 | Lochmaria | Yves du Parc | Belgo-American Development Corporation 1501 | 1961-12-18 | Belgo-American Development Corporation | 605 Third Avenue | New York | NY | 10016 | |
13141 | 13141 | 1968-04-11 | 1967-05-08 | Beyer | John Carl | Robert R. Nathan Associates, Inc. 352 | 1946-04-22 | Robert R. Nathan Associates, Inc. | 3 Thomas Circle | Washington | DC | 20530 | |
13144 | 13144 | 1969-04-11 | 1962-07-03 | Sebald | William Joseph | James, Leonard Gage 1554 | 1962-07-03 | James, Leonard Gage | 310 Sansome Street | San Francisco | CA | 94104 | |
13146 | 13146 | 1977-04-11 | 1967-02-03 | Eaton | John McCurdy | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13147 | 13147 | 1977-04-11 | 1973-02-08 | Butler | Paul M. , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13148 | 13148 | 1977-04-11 | 1971-02-17 | Augur | Harrison H. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13149 | 13149 | 1977-04-11 | 1970-03-05 | Elicker | Gordon L. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13150 | 13150 | 1977-04-11 | 1965-04-16 | MacKinnon | Robert H. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13151 | 13151 | 1977-04-11 | 1965-04-22 | Weiser | John W. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13152 | 13152 | 1977-04-11 | 1965-04-29 | Eaton | Frederick M. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13153 | 13153 | 1977-04-11 | 1965-04-29 | Knight | Robert Huntington | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13154 | 13154 | 1977-04-11 | 1970-05-08 | Lee | William L. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13155 | 13155 | 1977-04-11 | 1971-08-03 | Hurley | Raymond D. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13156 | 13156 | 1977-04-11 | 1966-08-04 | Forrestal | Michael V. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13157 | 13157 | 1977-04-11 | 1966-08-11 | Ross | Alfred J. , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13158 | 13158 | 1977-04-11 | 1967-09-06 | Clare | Robert Linn , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13159 | 13159 | 1977-04-11 | 1976-09-09 | Crowley | James M. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13160 | 13160 | 1977-04-11 | 1974-10-18 | Cuneo | Donald L. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13161 | 13161 | 1977-04-11 | 1969-10-29 | Goodwin | Charles , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13162 | 13162 | 1977-04-11 | 1969-10-29 | Murphy | Grayson M.P. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
13163 | 13163 | 1977-04-11 | 1975-11-07 | Halverson | James T. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | 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]) );