FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
752 rows where State = "" sorted by Address_1 descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number >30
- Bahamas Tourist Office 205
- Lloyd's of London Market Representatives 37
- Caribbean Tourism Organization, USA Inc. 30
- Union Nacional Sinarquista 28
- Camara Oficial Espanola de Comercio 26
- Canadian National Railways 16
- Alsace Development International, Inc. 16
- Actum International UK Limited 16
- Confederacion General de Trabajadores de P. Rico-Autentica 14
- FTI Consulting LLP 14
- Linklaters LLP 14
- Dominican Revolutionary Party, Puerto Rico 11
- Norwegian Seamens' Assocation 10
- International Group of P&I Clubs 10
- Nuclear Waste Management Organization 10
- Government of the Province of Alberta 9
- Partido Revolucionario Dominicano, Puerto Rico 8
- Partido Revolucionario Dominicano, Puerto Rico 8
- Nova Scotia Information Centre 8
- Polish Catholic Press Agency 7
- Partido Revolucionario Dominicano, Puerto Rico 7
- JAMPRO 7
- Comite Central de la Union Patriotica Dominicana 6
- Japan Center for Intercultural Communications (JCIC) 6
- Carlington Sales Canada Corporation 6
- Dinamica Multiple, S.A. 6
- Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6
- Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico 5
- Delgation of the Central Comm. for N. Epizus/Athens, Greece 5
- Partio Reformista, Filial de Puerto Rico 5
- …
Registrant_Name >30
- Bahamas Tourist Office 205
- Lloyd's of London Market Representatives 37
- Caribbean Tourism Organization, USA Inc. 30
- Union Nacional Sinarquista 28
- Camara Oficial Espanola de Comercio 26
- Partido Revolucionario Dominicano, Puerto Rico 23
- Actum International UK Limited 16
- Alsace Development International, Inc. 16
- Canadian National Railways 16
- Confederacion General de Trabajadores de P. Rico-Autentica 14
- FTI Consulting LLP 14
- Hakuhodo, Inc. 14
- Linklaters LLP 14
- Dominican Revolutionary Party, Puerto Rico 11
- Carlington Sales Canada Corporation 10
- International Group of P&I Clubs 10
- Norwegian Seamens' Assocation 10
- Nuclear Waste Management Organization 10
- Dickens & Madson Canada Inc. 9
- Government of the Province of Alberta 9
- Nova Scotia Information Centre 8
- JAMPRO 7
- Polish Catholic Press Agency 7
- Comite Central de la Union Patriotica Dominicana 6
- Dinamica Multiple, S.A. 6
- Hakuhodo Incorporated 6
- Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6
- Japan Center for Intercultural Communications (JCIC) 6
- Christian League of Southern Africa 5
- DEACERO S.A.P.I. de C.V. (DEACERO) 5
- …
City >30
- Nassau 205
- London 119
- San Juan 47
- Houston 30
- El Paso 28
- Montreal, Quebec 26
- San Juan De 26
- Tokyo 24
- 68000 Colmar 16
- Santurce 13
- Ontario 10
- Oslo 10
- Edmonton, Alberta 9
- London, England 9
- Halifax 8
- Rio Diedras 8
- Kingston 10 7
- Toronto, Ontario 7
- Athens 6
- Mexico D.F. 6
- Montreal 6
- Rio Piedras 6
- Tokyo, 102-0093 6
- Moscow 5
- San Pedro 5
- Santiago 9 5
- Sunnyside 0132 5
- Basseterre 4
- Chiyoda-ku, Tokyo 4
- Havana 4
- …
State 1
- - · 752 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
765 | 765 | 2018-04-11 | Kramer | Andrew L. | Dickens & Madson Canada Inc. 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | c/o Tragen Resources & Logistics | 740 Notre Dame Ouest, Suite 1250 | Montreal | |||
2383 | 2383 | 2013-12-11 | Ben-Menashe | Ari | Dickens & Madson Canada Inc. 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | c/o Tragen Resources & Logistics | 740 Notre Dame Ouest, Suite 1250 | Montreal | |||
32474 | 32474 | 2014-10-08 | 2013-12-11 | Hughes | Patrick B. | Dickens & Madson Canada Inc. 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | c/o Tragen Resources & Logistics | 740 Notre Dame Ouest, Suite 1250 | Montreal | ||
32475 | 32475 | 2014-10-08 | 2013-12-11 | Kelly | Martha | Dickens & Madson Canada Inc. 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | c/o Tragen Resources & Logistics | 740 Notre Dame Ouest, Suite 1250 | Montreal | ||
38190 | 38190 | 2019-12-12 | 2019-12-08 | Friedman | Alan | Mediastrategia srl 6764 | 2019-12-08 | Mediastrategia srl | Via Campioni Inigo Trav. | Prima 45, Lucca | Tuscany | ||
31794 | 31794 | 1964-10-01 | 1964-09-21 | Casey | John Thomas | Leiser, Henri 1786 | 1964-09-01 | Leiser, Henri | Vallehermoso 30 | Madrid | |||
7236 | 7236 | 1965-02-19 | 1965-02-19 | Ruiz | Cesar Augusto Morales | Bosch, Juan E. 1858 | 1965-02-19 | Bosch, Juan E. | University Station | Post Office Box 22577 | Rio Piedras | ||
36194 | 36194 | 1961-11-22 | 1961-11-22 | Barreto | Hector Febles | Unidad Revolucionaria 1492 | 1961-11-22 | Unidad Revolucionaria | Underground | Havana | |||
36195 | 36195 | 1961-11-22 | 1961-11-22 | Diaz | Aurelio Manuel Fernandez | Unidad Revolucionaria 1492 | 1961-11-22 | Unidad Revolucionaria | Underground | Havana | |||
36196 | 36196 | 1961-11-22 | 1961-11-22 | Moreno | Luis Ramon Vega | Unidad Revolucionaria 1492 | 1961-11-22 | Unidad Revolucionaria | Underground | Havana | |||
9867 | 9867 | 2022-03-14 | 2022-02-23 | Agudelo Garcia | Ana Paola | Partido Politico Mira 7081 | 2022-02-23 | Partido Politico Mira | Transv 29 # 36 - 40 | Bogota | |||
9868 | 9868 | 2022-03-14 | 2022-02-23 | Castro Berrio | Gloria Estela | Partido Politico Mira 7081 | 2022-02-23 | Partido Politico Mira | Transv 29 # 36 - 40 | Bogota | |||
13223 | 13223 | 1991-04-12 | 1991-04-12 | Tethong | Tenzin N. | Tethong, Tenzin 4734 | 1991-04-12 | Tethong, Tenzin | The Kashag, Gangchen | Kyishong | Dharamsala | ||
1620 | 1620 | 2022-08-16 | Yessaian | Charles | Salam International 7159 | 2022-08-16 | Salam International | Salam Tower | Corniche Road | Doha | |||
17299 | 17299 | 1993-05-28 | 1989-04-17 | Inwood | William John | Royal Trustco, Ltd. 4239 | 1989-04-17 | Royal Trustco, Ltd. | Royal Trust Tower, Station A | P.O. Box 7500, Suite 3900 | Toronto, Ontario | ||
26853 | 26853 | 1971-08-17 | 1967-04-28 | Khabele | Paseka E. | African National Congress (South Africa) Committee 2023 | 1967-04-28 | African National Congress (South Africa) Committee | Provisional Headquarters | Box 680 | Morogoro | ||
26854 | 26854 | 1971-08-17 | 1967-04-28 | Mtshali | Benedict Vulindlela | African National Congress (South Africa) Committee 2023 | 1967-04-28 | African National Congress (South Africa) Committee | Provisional Headquarters | Box 680 | Morogoro | ||
26855 | 26855 | 1971-08-17 | 1967-04-28 | Setai | Bethuel Pitori | African National Congress (South Africa) Committee 2023 | 1967-04-28 | African National Congress (South Africa) Committee | Provisional Headquarters | Box 680 | Morogoro | ||
34793 | 34793 | 1953-11-01 | 1952-09-02 | Chester | Edmund Albert | Chester, Edmund Albert 740 | 1952-09-02 | Chester, Edmund Albert | Prado 152-154 | Havana | |||
37816 | 37816 | 1962-12-06 | 1960-06-06 | Hurlburt | Edward | Netherlands West Indies Tourist Commission 1367 | 1960-06-06 | Netherlands West Indies Tourist Commission | Post Office Box 3072 | San Juan | |||
17228 | 17228 | 1994-05-27 | 1993-04-12 | Holtzman | Marc L. | EurAmerica Capital Corporation, Ltd. 4794 | 1993-04-12 | EurAmerica Capital Corporation, Ltd. | Post Office Box 25 Roseneath | The Grange, St. Petersport | Guernsey | ||
17233 | 17233 | 1994-05-27 | 1993-05-25 | Green | Jordan C. | EurAmerica Capital Corporation, Ltd. 4794 | 1993-04-12 | EurAmerica Capital Corporation, Ltd. | Post Office Box 25 Roseneath | The Grange, St. Petersport | Guernsey | ||
40193 | 40193 | 1981-12-31 | 1978-09-15 | Coleman | Francis L. | Christian League of Southern Africa 2957 | 1978-09-15 | Christian League of Southern Africa | Post Office 28507 | Sunnyside 0132 | |||
40194 | 40194 | 1981-12-31 | 1978-09-15 | Lewis | Arthur Roland | Christian League of Southern Africa 2957 | 1978-09-15 | Christian League of Southern Africa | Post Office 28507 | Sunnyside 0132 | |||
40195 | 40195 | 1981-12-31 | 1978-09-15 | Reddy | Kistappa | Christian League of Southern Africa 2957 | 1978-09-15 | Christian League of Southern Africa | Post Office 28507 | Sunnyside 0132 | |||
40196 | 40196 | 1981-12-31 | 1978-09-15 | Shaw | Frederick R. E. | Christian League of Southern Africa 2957 | 1978-09-15 | Christian League of Southern Africa | Post Office 28507 | Sunnyside 0132 | |||
40199 | 40199 | 1981-12-31 | 1978-10-03 | Kingdon | David P. | Christian League of Southern Africa 2957 | 1978-09-15 | Christian League of Southern Africa | Post Office 28507 | Sunnyside 0132 | |||
18008 | 18008 | 2006-05-31 | 1999-06-30 | Burgess | Sara | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
18022 | 18022 | 2006-05-31 | 1991-11-05 | Watkins | D.J.L. | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
18023 | 18023 | 2006-05-31 | 2005-12-14 | Bardot | Andrew | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
18024 | 18024 | 2006-05-31 | 2005-12-14 | Groom | Alistair John | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
28442 | 28442 | 2005-08-31 | 1999-07-07 | Havers | Chris | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
28443 | 28443 | 2005-08-31 | 2001-07-10 | James | Stephen | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
39181 | 39181 | 1994-12-27 | 1991-11-05 | Coghlin | Terence G. | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
41147 | 41147 | 1999-12-31 | 1993-07-06 | Readman | R.N. | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
41192 | 41192 | 2000-12-31 | 1995-07-10 | Greenwood | George E. | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
41374 | 41374 | 2004-12-31 | 1991-11-05 | Seward | Robert | International Group of P&I Clubs 4584 | 1991-11-05 | International Group of P&I Clubs | Peek House | 20 Eastcheap | London | ||
33276 | 33276 | 2019-10-20 | 2019-02-25 | Ricklefs | Norman M. | Iraq Advisory Group FZE 6641 | 2019-02-25 | Iraq Advisory Group FZE | PO Box 31303 | Emirates Towers | Dubai | ||
33277 | 33277 | 2019-10-20 | 2019-02-25 | Tayah | Therese | Iraq Advisory Group FZE 6641 | 2019-02-25 | Iraq Advisory Group FZE | PO Box 31303 | Emirates Towers | Dubai | ||
5240 | 5240 | 2001-01-31 | 1997-08-01 | Duncan | Monica | Ross-Robinson & Associates 4992 | 1995-02-07 | Ross-Robinson & Associates | P.O. Box 417 | Basseterre | |||
28380 | 28380 | 2001-08-31 | 1995-02-07 | Ross-Robinson | Hazel | Ross-Robinson & Associates 4992 | 1995-02-07 | Ross-Robinson & Associates | P.O. Box 417 | Basseterre | |||
28400 | 28400 | 2001-08-31 | 1995-10-30 | Blahey | Cecelie Counts | Ross-Robinson & Associates 4992 | 1995-02-07 | Ross-Robinson & Associates | P.O. Box 417 | Basseterre | |||
37448 | 37448 | 1996-12-01 | 1995-10-30 | Fenton | David | Ross-Robinson & Associates 4992 | 1995-02-07 | Ross-Robinson & Associates | P.O. Box 417 | Basseterre | |||
21697 | 21697 | 2012-06-30 | 2011-03-24 | Bohn III | Carl H. | Vista Group Corp. 6028 | 2011-03-24 | Vista Group Corp. | P.O. Box 0831-02638 | Panama | |||
4295 | 4295 | 2021-01-22 | 2020-05-22 | Evtimov | Bogdan Venelinov | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6753 | 6753 | 2023-02-13 | 2020-02-24 | Bartels | Lorand | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6754 | 6754 | 2023-02-13 | 2020-02-24 | Coldicutt | Samuel | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6755 | 6755 | 2023-02-13 | 2020-02-24 | Fawke | Alexander | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6756 | 6756 | 2023-02-13 | 2020-02-24 | Gracia | Natura | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6757 | 6757 | 2023-02-13 | 2020-02-24 | Kar | Nicole | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6758 | 6758 | 2023-02-13 | 2020-02-24 | Lurie | Adam | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6759 | 6759 | 2023-02-13 | 2020-02-24 | Metcalf | Caitlin | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6760 | 6760 | 2023-02-13 | 2020-02-24 | Morgan | Charlotte | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6761 | 6761 | 2023-02-13 | 2020-02-24 | Ormerod | Imogen | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6762 | 6762 | 2023-02-13 | 2020-02-24 | Weiniger | Matthew | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
6765 | 6765 | 2023-02-13 | 2020-09-29 | Darling Jr. | Sterling Price Adams | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
8410 | 8410 | 2021-02-28 | 2020-02-24 | Brooks | Aaron | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
8411 | 8411 | 2021-02-28 | 2020-02-24 | Tridgell | Anthony | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
2839 | 2839 | 2006-01-01 | 1998-09-02 | Prettejohn | Nicholas | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
5812 | 5812 | 2002-02-01 | 1996-09-09 | Barker | Jane | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
8010 | 8010 | 1995-02-28 | 1994-01-06 | Suterwalla | Razia | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
9982 | 9982 | 2000-03-15 | 1998-02-27 | Skwiertz | Albert | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
10633 | 10633 | 2007-03-23 | 2005-02-28 | Russell | David | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
11710 | 11710 | 1995-03-31 | 1994-02-09 | Hall | Stephen Hargreaves | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
11712 | 11712 | 1995-03-31 | 1994-02-16 | Mallinson | John Russell | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
14770 | 14770 | 1998-04-30 | 1994-06-01 | Lane | Peter William | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
14949 | 14949 | 2007-04-30 | 1998-02-27 | James | Julian | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
21340 | 21340 | 1999-06-30 | 1996-09-09 | Sandler | Ronald A. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
21869 | 21869 | 2017-06-30 | 2001-02-27 | Westcott | Rosemary Beaver | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25313 | 25313 | 2018-07-31 | 2013-02-26 | Miesowitz | Sabrina Ariel | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25314 | 25314 | 2018-07-31 | 2005-02-28 | Parry | John | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25315 | 25315 | 2018-07-31 | 2018-03-02 | Carter | Misty | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25316 | 25316 | 2018-07-31 | 2018-03-02 | Claydon | Simon | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25323 | 25323 | 2018-07-31 | 1994-06-01 | Evans | Alastair MacKenzie | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25327 | 25327 | 2018-07-31 | 2000-08-17 | Gunset | Joseph P. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25328 | 25328 | 2018-07-31 | 2002-08-19 | Walmsley | James Stuart Mainprize | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25330 | 25330 | 2018-07-31 | 2016-08-30 | Grant | Tirnothy | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25331 | 25331 | 2018-07-31 | 2017-08-30 | Weaver | Hilary | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
28257 | 28257 | 1995-08-31 | 1994-01-06 | Gibson | Barry J. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
29893 | 29893 | 2005-09-15 | 2002-08-29 | Pinchin | Jeremy | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
30546 | 30546 | 2005-09-26 | 2005-02-28 | Manning | Stephen | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
31371 | 31371 | 2007-09-30 | 2001-02-27 | Tompson | Bruce Martin | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
31590 | 31590 | 2016-09-30 | 2008-02-25 | McGovern | Sean | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
32750 | 32750 | 2011-10-13 | 2003-02-28 | Levene | of Portsoken | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
34567 | 34567 | 2007-10-31 | 2007-08-27 | Roberts | Martin | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
35592 | 35592 | 1995-11-10 | 1994-02-09 | Middleton | Peter James | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
36805 | 36805 | 1996-11-30 | 1994-02-09 | Merrett | Stephen Roy | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
36899 | 36899 | 2002-11-30 | 2001-04-16 | Riley | S. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41007 | 41007 | 1997-12-31 | 1994-02-09 | Rowland | John David | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41077 | 41077 | 1998-12-31 | 1994-02-09 | Youell | J. Richard L. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41105 | 41105 | 1998-12-31 | 1996-09-09 | Miller | Peter | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41176 | 41176 | 2000-12-31 | 1994-01-06 | Duguid | Andrew A. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41179 | 41179 | 2000-12-31 | 1998-02-27 | Taylor | John Maxwell Percy | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41545 | 41545 | 2007-12-31 | 2007-03-01 | Baker | Winifred A. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41653 | 41653 | 2009-12-31 | 2005-02-28 | Tolle | Rolf | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
16282 | 16282 | 1946-05-14 | 1944-03-08 | Borup | Oluf | Norwegian Seamens' Assocation 158 | 1942-11-14 | Norwegian Seamens' Assocation | Norsk Sjomannsforbund | Grev Wedels Plass 5 | Oslo | ||
16283 | 16283 | 1946-05-14 | 1944-03-08 | Jensen | Jens | Norwegian Seamens' Assocation 158 | 1942-11-14 | Norwegian Seamens' Assocation | Norsk Sjomannsforbund | Grev Wedels Plass 5 | Oslo | ||
16284 | 16284 | 1946-05-14 | 1944-03-08 | Johansen | Einar | Norwegian Seamens' Assocation 158 | 1942-11-14 | Norwegian Seamens' Assocation | Norsk Sjomannsforbund | Grev Wedels Plass 5 | Oslo | ||
16285 | 16285 | 1946-05-14 | 1944-03-08 | Karlsen | Gustav Adolf | Norwegian Seamens' Assocation 158 | 1942-11-14 | Norwegian Seamens' Assocation | Norsk Sjomannsforbund | Grev Wedels Plass 5 | Oslo | ||
16286 | 16286 | 1946-05-14 | 1944-03-08 | Skjelbred | Ragnvald | Norwegian Seamens' Assocation 158 | 1942-11-14 | Norwegian Seamens' Assocation | Norsk Sjomannsforbund | Grev Wedels Plass 5 | Oslo |
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]) );