List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

40,847 rows sorted by Zip

View and edit SQL

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State

Registration_Number

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 ▼
80   2021-01-07 Winiarski Artur 6904 6904 2021-01-07 Gaya United Bytowska Street 15 Czarna Dabrowka Pomeranian    
376   2020-02-24 Bartels Lorand 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
379   2020-02-24 Coldicutt Samuel 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
380   2020-02-24 Fawke Alexander 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
381   2020-02-24 Gracia Natura 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
382   2020-02-24 Kar Nicole 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
383   2020-02-24 Lurie Adam 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
384   2020-02-24 Metcalf Caitlin 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
385   2020-02-24 Morgan Charlotte 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
386   2020-02-24 Ormerod Imogen 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
387   2020-02-24 Weiniger Matthew 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
454   2021-03-06 Culmer Sanique 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
455   2021-03-06 Kemp Adrian 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
456   2021-03-06 Lord Jonathan 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
457   2021-03-06 McPhee Ferguson Kendy 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
458   2021-03-06 Shivers Phylia 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
577   2012-03-27 Bramble Sylma Brown 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
645   2021-04-07 Dultaeva Dinara 6848 6848 2020-08-05 AH5 Ventures LLC 60B Konstitutsiya Street   Tashkent    
677   2018-04-11 Kramer Andrew L. 6200 6200 2013-12-11 Dickens & Madson Canada Inc. c/o Tragen Resources & Logistics 740 Notre Dame Ouest, Suite 1250 Montreal    
780   2016-04-29 Archer Garbrielle A. 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
781   2016-04-29 Johnson Deckery Keith 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
782   2016-04-29 Moss Mikala T. 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
783   2016-04-29 Munroe Richard 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
786   2016-04-29 Rodgers Jeffrey C. 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
787   2016-04-29 Sands Vandia D. 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
788   2016-04-29 Young Prescott 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
1000   2015-05-28 Smith Dupree 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
1001   2015-05-28 Strachan Danzarra M. 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
1161   2021-06-17 Martin Joseph Quinn 6848 6848 2020-08-05 AH5 Ventures LLC 60B Konstitutsiya Street   Tashkent    
1428   2020-08-05 Batmanghelidj Esfandyar 6848 6848 2020-08-05 AH5 Ventures LLC 60B Konstitutsiya Street   Tashkent    
1670   2020-09-29 Darling Jr. Sterling Price Adams 6795 6795 2020-02-24 Linklaters LLP One Silk Street   London    
1974   1994-11-17 Watson Dornell 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2001   2019-11-20 Winstanley Robert 6752 6752 2019-11-20 Halcyon Associates 69 Old Broad Street   London    
2129   2019-12-08 Friedman Alan 6764 6764 2019-12-08 Mediastrategia srl Via Campioni Inigo Trav. Prima 45, Lucca Tuscany    
2146   2013-12-11 Ben-Menashe Ari 6200 6200 2013-12-11 Dickens & Madson Canada Inc. c/o Tragen Resources & Logistics 740 Notre Dame Ouest, Suite 1250 Montreal    
2263   2013-12-31 Carey Raquel D. 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2264   2013-12-31 James Hilda L. 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2265   2013-12-31 Johnson-Patty Anita 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2266   2013-12-31 King Bridgette 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2267   2013-12-31 Lee Tina Theresa 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2268   2013-12-31 Miller Andre J. 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2269   2013-12-31 Treco Richard 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2270   2013-12-31 Woodside-Cidel Melony 2310 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2274 1948-01-01 1947-12-10 Hadi Nuraldin Abdul 322 322 1945-09-21 Arab Office Wardman Park Hotel Suite 400E Washington DC  
2278 1953-01-01 1953-01-08 Pawtowicz Tadeusz Aleksander 630 630 1950-07-10 Polish Freedom Movement 28 West 83rd Street   New York NY  
2279 1953-01-01 1952-09-12 Bartos Joseph 658 658 1951-01-30 Slovak Liberation Committee in the U.S. C/O Joseph Ferkovic 6627 Marcus Detroit MI  
2284 1956-01-01 1956-03-27 Pekelharing Rudolf C. 353 353 1946-04-22 Films of the Nations, Inc. 18 West 55th Street   New York NY  
2288 1958-01-01 1953-03-19 Morel Emilio A. 674 674 1951-05-29 Partido Revolucionario Dominicano, New York 229 West 97th Street Apartment 3C New York NY  
2289 1958-01-01 1957-08-15 Michalski Edward Leon 1054 1054 1957-07-30 Polonia International, Inc. 55 West 42nd Street   New York NY  
2290 1959-01-01 1957-02-06 Cheda Juan Vicente 998 998 1957-02-06 Club Patriotico 26 de Julio de Miami 3527 Northwest 2nd Street   Miami FL  
2291 1959-01-01 1957-05-22 Guevara Mario 998 998 1957-02-06 Club Patriotico 26 de Julio de Miami 3527 Northwest 2nd Street   Miami FL  
2292 1959-01-01 1957-05-22 Izquierdo Rafael 998 998 1957-02-06 Club Patriotico 26 de Julio de Miami 3527 Northwest 2nd Street   Miami FL  
2293 1959-01-01 1957-05-22 Margolles Fernando Delestino 998 998 1957-02-06 Club Patriotico 26 de Julio de Miami 3527 Northwest 2nd Street   Miami FL  
2294 1959-01-01 1957-05-22 Ross Luis 998 998 1957-02-06 Club Patriotico 26 de Julio de Miami 3527 Northwest 2nd Street   Miami FL  
2295 1959-01-01 1957-06-10 Porter William Matthews 998 998 1957-02-06 Club Patriotico 26 de Julio de Miami 3527 Northwest 2nd Street   Miami FL  
2296 1959-01-01 1958-06-23 Lopez Marco Antonio Ojeda y 998 998 1957-02-06 Club Patriotico 26 de Julio de Miami 3527 Northwest 2nd Street   Miami FL  
2297 1959-01-01 1958-06-23 Ramos Filiberto Zamora y 998 998 1957-02-06 Club Patriotico 26 de Julio de Miami 3527 Northwest 2nd Street   Miami FL  
2298 1959-01-01 1958-10-24 Ramirez Oscar Diego Ruben 998 998 1957-02-06 Club Patriotico 26 de Julio de Miami 3527 Northwest 2nd Street   Miami FL  
2299 1960-01-01 1956-11-20 White Bert E. 981 981 1956-11-20 American Express Company 65 Broadway   New York NY  
2301 1962-01-01 1961-09-05 Illenberger Theodora 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
2304 1964-01-01 1963-03-26 Guiglia Maria Corella 1612 1612 1963-03-26 Frente Civico Mexicano de Afirmacion Revolucionaria 4620 Beverly Boulevard   Los Angeles CA  
2305 1964-01-01 1963-03-26 Virchis Roman Joseph 1612 1612 1963-03-26 Frente Civico Mexicano de Afirmacion Revolucionaria 4620 Beverly Boulevard   Los Angeles CA  
2306 1964-01-01 1963-03-26 Zeman Leland Ellis 1612 1612 1963-03-26 Frente Civico Mexicano de Afirmacion Revolucionaria 4620 Beverly Boulevard   Los Angeles CA  
2330 1970-01-01 1963-10-18 Hausman Robert M. 540 540 1948-09-16 Ginsburg, Feldman & Bress 914 Ring Building   Washington DC  
2616 2006-01-01 1998-09-02 Prettejohn Nicholas 4883 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
2795 1952-01-02 1951-05-29 Quinones Jose Oscar 674 674 1951-05-29 Partido Revolucionario Dominicano, New York 229 West 97th Street Apartment 3C New York NY  
2796 1953-01-02 1952-01-02 Burns Joseph W. 703 703 1952-01-02 Fulton, Walter & Halley 30 Rockefeller Plaza   New York NY  
2797 1953-01-02 1952-01-02 Fulton Hugh Alfred 703 703 1952-01-02 Fulton, Walter & Halley 30 Rockefeller Plaza   New York NY  
2798 1953-01-02 1952-01-02 Sparks Wilbur Danforth 703 703 1952-01-02 Fulton, Walter & Halley 30 Rockefeller Plaza   New York NY  
2802 1973-01-02 1965-03-19 Bator Peter Anthony 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2803 1973-01-02 1965-03-19 Lindsay David Alexander 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2804 1973-01-02 1961-03-22 Leonard Edwin Deane 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2805 1973-01-02 1966-03-25 Carson Ralph M. 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2806 1973-01-02 1958-05-07 Fox Donald Thomas 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2807 1973-01-02 1958-05-07 King Henry Lawrence 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2808 1973-01-02 1958-05-07 Reid Edward Snover , III 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2809 1973-01-02 1953-08-21 Byard Dever Spencer 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2810 1973-01-02 1953-08-21 Ketchum William Tredwell , Jr. 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2811 1973-01-02 1953-08-21 Spofford Charles Merville 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2812 1973-01-02 1958-09-22 Coleman Leighton Hammond 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2813 1973-01-02 1960-10-19 Coleman Charles Payson 785 785 1953-08-21 Davis, Polk & Wardell 15 Broad Street   New York NY  
2907 2020-01-03 2020-08-26 Levi Zac 6569 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
2908 1964-01-04 1963-01-11 Sackren Harry 1589 1589 1963-01-11 Foreign Research & Development Corporation 575 Madison Avenue   New York NY  
2909 1964-01-04 1963-01-11 Shames Ben C. 1589 1589 1963-01-11 Foreign Research & Development Corporation 575 Madison Avenue   New York NY  
2910 1964-01-04 1963-03-14 Anthony Julian Chmielewski 1589 1589 1963-01-11 Foreign Research & Development Corporation 575 Madison Avenue   New York NY  
2911 1964-01-04 1963-03-29 Erskine Graves Blanchard 1589 1589 1963-01-11 Foreign Research & Development Corporation 575 Madison Avenue   New York NY  
2973 1951-01-05 1950-11-14 Whiston Michael W. 649 649 1950-11-14 Federal Advertising Agency, Inc. 270 Park Avenue   New York NY  
3005 2004-01-05 2002-07-18 Thomas-Frye Sadie 3078 3078 1979-12-18 Nova Scotia Information Centre 1800 Argyle Street Suite 603 Box 456 Halifax    
3018 1951-01-06 1950-01-06 Bildersee Barnett 604 604 1950-01-06 Allied Syndicates, Inc. 745 Fifth Avenue   New York NY  
3019 1951-01-06 1950-01-06 Charnay David B. 604 604 1950-01-06 Allied Syndicates, Inc. 745 Fifth Avenue   New York NY  
3020 1951-01-06 1950-01-06 Gray John M. 604 604 1950-01-06 Allied Syndicates, Inc. 745 Fifth Avenue   New York NY  
3021 1951-01-06 1950-01-06 Mockler Robert D. 604 604 1950-01-06 Allied Syndicates, Inc. 745 Fifth Avenue   New York NY  
3022 1951-01-06 1950-01-10 Maybruck Charles N. 604 604 1950-01-06 Allied Syndicates, Inc. 745 Fifth Avenue   New York NY  
3023 1959-01-06 1958-02-03 Tilker Kay Burr 991 991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
3024 1961-01-06 1959-07-06 Klein Carl W. , Jr. 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
3025 1961-01-06 1959-07-06 Popenas Michael 1243 1243 1959-07-06 Examro, Inc. 371 State Street   Detroit MI  
3070 1950-01-07 1948-07-07 Holland Barbara Ann 532 532 1948-07-07 Fleming, John William 1026 Continental Building 1511 K Street, N.W. Washington DC  
3071 1950-01-07 1948-07-27 Cooke Winnifred Patricia 532 532 1948-07-07 Fleming, John William 1026 Continental Building 1511 K Street, N.W. Washington DC  
3074 1959-01-07 1958-10-08 Tompkins William Finley 1175 1175 1958-10-08 Lum, Fairlie & Foster 605 Broad Street   Neward NJ  
3075 1960-01-07 1958-05-05 Downing Edward R. 1102 1102 1958-01-07 Satterlee, Browne, Cherbonnier & Dickerson 30 Broad Street   New York NY  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);