home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

50 rows where City = "Falls Church" and State = "VA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number 14

  • National Union for the Total Independence of Angola (UNITA) 16
  • KRL International, LLC 11
  • Hoffman and Hoffman Public Relations 5
  • Reed Smith LLP 4
  • Hoffman & Hoffman Public Relations 3
  • Sims Jr., John Rogers 2
  • DiNovo Strategies, LLC 2
  • American Friends of the BNP 1
  • Tramposch, Albert 1
  • Footlik, Jay 1
  • Iron Bridge Strategies LLC 1
  • ETS Consulting 1
  • Potomac Radio Group, Inc. 1
  • GP International LLC/ DBA GlobalPoint International 1

Registrant_Name 14

  • National Union for the Total Independence of Angola (UNITA) 16
  • KRL International, LLC 11
  • Hoffman and Hoffman Public Relations 5
  • Reed Smith LLP 4
  • Hoffman & Hoffman Public Relations 3
  • DiNovo Strategies, LLC 2
  • Sims Jr., John Rogers 2
  • American Friends of the BNP 1
  • ETS Consulting 1
  • Footlik, Jay 1
  • GP International LLC/ DBA GlobalPoint International 1
  • Iron Bridge Strategies LLC 1
  • Potomac Radio Group, Inc. 1
  • Tramposch, Albert 1

State 1

  • VA · 50 ✖

City 1

  • Falls Church · 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
1379 1379   2022-07-08 Levinson K Riva KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
2361 2361   2017-12-08 Berardini Chris Iron Bridge Strategies LLC 6497 2017-12-08 Iron Bridge Strategies LLC 5573 Seminary Road Unit 106 Falls Church VA 22041
2389 2389   2017-12-13 Brunts Laura KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
5846 5846 2008-02-01 2007-04-09 Levinson K. Riva KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
7617 7617 1987-02-25 1986-03-21 Domingos Muekalia Jardo National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
7618 7618 1987-02-25 1986-03-21 Muekalia Jardo National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
10951 10951 1989-03-28 1986-03-21 Chingunji Tito National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
12702 12702 2002-04-03 2002-04-03 Cotterill Mark American Friends of the BNP 5488 2002-04-03 American Friends of the BNP P.O. Box 1746   Falls Church VA 22041-1746
13731 13731 2023-04-18 2022-11-22 Harvin Christopher GP International LLC/ DBA GlobalPoint International 7193 2022-11-22 GP International LLC/ DBA GlobalPoint International 103 Rowell Court   Falls Church VA 22046
14879 14879 2002-04-30 2001-10-29 Pedigo Christopher L. Reed Smith LLP 5465 2001-10-29 Reed Smith LLP 3110 Fairview Park Drive Suite 1400 Falls Church VA 22042-0681
14880 14880 2002-04-30 2001-10-29 Sterne John H. Jr., Reed Smith LLP 5465 2001-10-29 Reed Smith LLP 3110 Fairview Park Drive Suite 1400 Falls Church VA 22042-0681
15478 15478 2009-05-01 2008-10-09 Rabin Yuval DiNovo Strategies, LLC 5887 2008-10-09 DiNovo Strategies, LLC 3035 Meeting Street   Falls Church VA 22044
15501 15501 2015-05-01 2014-03-06 Chinje Eric KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
17310 17310 2010-05-28 2009-03-19 Clack Mark C. KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
17486 17486 2000-05-30 2000-07-03 Kayne Julia Hoffman and Hoffman Public Relations 5338 1999-10-29 Hoffman and Hoffman Public Relations 5683 Columbia Pike Suite 200 Falls Church VA 22141
17487 17487 2000-05-30 2000-07-03 Larsen Ian D. Hoffman and Hoffman Public Relations 5338 1999-10-29 Hoffman and Hoffman Public Relations 5683 Columbia Pike Suite 200 Falls Church VA 22141
17489 17489 2000-05-30 1999-10-29 Hoffman Marshall Hoffman and Hoffman Public Relations 5338 1999-10-29 Hoffman and Hoffman Public Relations 5683 Columbia Pike Suite 200 Falls Church VA 22141
17490 17490 2000-05-30 1999-10-29 Hoffman Nils Hoffman and Hoffman Public Relations 5338 1999-10-29 Hoffman and Hoffman Public Relations 5683 Columbia Pike Suite 200 Falls Church VA 22141
17491 17491 2000-05-30 1999-10-29 Kiel Frederick Hoffman and Hoffman Public Relations 5338 1999-10-29 Hoffman and Hoffman Public Relations 5683 Columbia Pike Suite 200 Falls Church VA 22141
17973 17973 2003-05-31 2001-10-29 Koch Robbie N. Reed Smith LLP 5465 2001-10-29 Reed Smith LLP 3110 Fairview Park Drive Suite 1400 Falls Church VA 22042-0681
17974 17974 2003-05-31 2001-10-29 Kronmiller Theodore G. Reed Smith LLP 5465 2001-10-29 Reed Smith LLP 3110 Fairview Park Drive Suite 1400 Falls Church VA 22042-0681
18531 18531 2009-06-01 2008-10-09 Footlik Jay DiNovo Strategies, LLC 5887 2008-10-09 DiNovo Strategies, LLC 3035 Meeting Street   Falls Church VA 22044
20567 20567 1998-06-29 1990-11-21 Santa Jaime Azezedo Vila National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
23691 23691 2018-07-20 2017-12-13 Johnson Danielle KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
25144 25144 2009-07-31 2009-02-27 McKew Molly M. KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
25741 25741 2017-08-01 2010-02-26 Beatty Christopher KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
25748 25748 2017-08-01 2016-07-20 Levinson K Riva KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
27049 27049 1986-08-20 1986-03-21 Pollock Howard W. National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
27786 27786 1998-08-30 1997-08-26 Flynn Christopher T. Hoffman & Hoffman Public Relations 5203 1997-08-26 Hoffman & Hoffman Public Relations 5683 Columbia Pike Suite 200 Falls Church VA 22041
27787 27787 1998-08-30 1997-08-26 Hoffman Marshall Hoffman & Hoffman Public Relations 5203 1997-08-26 Hoffman & Hoffman Public Relations 5683 Columbia Pike Suite 200 Falls Church VA 22041
27788 27788 1998-08-30 1998-10-05 Kiel Frederick Hoffman & Hoffman Public Relations 5203 1997-08-26 Hoffman & Hoffman Public Relations 5683 Columbia Pike Suite 200 Falls Church VA 22041
30224 30224 1998-09-21 1986-03-21 Paulo Figueriedo National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
30225 30225 1998-09-21 1986-03-21 dos Santos Wilson National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
30226 30226 1998-09-21 1987-04-27 Hicks A.J. National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
30227 30227 1998-09-21 1987-05-13 Chingunji Pedro N'Gueve Jonatao National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
30228 30228 1998-09-21 1987-05-13 Samondo Marcos National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
30229 30229 1998-09-21 1987-06-18 Chipeio Ramiro National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
30230 30230 1998-09-21 1988-09-29 Lehman Christopher M. National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
30231 30231 1998-09-21 1990-12-07 Chivukuvuku Abel National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
30232 30232 1998-09-21 1989-12-13 Savimbi Dr. Jonas M. National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
33647 33647 2019-10-25 2017-12-13 Manyeh Edwina KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
34588 34588 2009-10-31 2008-10-09 Footlik Jay Footlik, Jay 5886 2008-10-09 Footlik, Jay 3035 Meeting Street   Falls Church VA 22044
36279 36279 2007-11-23 2007-08-23 McKew Molly K. KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
37435 37435 1991-12-01 1989-12-11 Amitay Morris J. National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
37860 37860 1958-12-07 1958-02-24 Lautner John Sims Jr., John Rogers 1034 1957-06-07 Sims Jr., John Rogers 804 Ridge Place   Falls Church VA  
37861 37861 1958-12-07 1957-06-07 Stout Clair LeRoy Sims Jr., John Rogers 1034 1957-06-07 Sims Jr., John Rogers 804 Ridge Place   Falls Church VA  
37958 37958 1986-12-09 1986-03-21 Chitunda Jeremias K. National Union for the Total Independence of Angola (UNITA) 3797 1986-03-21 National Union for the Total Independence of Angola (UNITA) 6021 Munson Hill Road   Falls Church VA 22041
41606 41606 2008-12-31 2008-02-06 Tramposch Albert Tramposch, Albert 5779 2006-12-07 Tramposch, Albert 2111 Preston Square Court   Falls Church VA 22043
42425 42425 2021-12-31 2021-12-16 Masden Danny R. Potomac Radio Group, Inc. 7059 2021-12-16 Potomac Radio Group, Inc. 2890 Emma Lee Street Suite 201 Falls Church VA 22042
42458 42458 2022-12-31 2021-12-06 Schultz Eric Todd ETS Consulting 7052 2021-12-06 ETS Consulting 2800 Flagmaker Drive   Falls Church VA 22042

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])
);
Powered by Datasette · Queries took 293.936ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history