fara

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

Custom SQL query returning 101 rows (hide)

select 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 from FARA_All_ShortForms where "Registrant_Name" = :p0 order by rowid limit 101

 
select 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 from FARA_All_ShortForms where "Registrant_Name" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

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
3378	2011-01-07	2009-11-19	Bentley-Jacobs	Jessica	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
3596	2018-01-11	2017-11-28	Vieira	Daniela S.	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
5124	1994-01-31	1992-01-10	Bushnell	David J.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
5131	1994-01-31	1992-09-03	Sheon	David	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
5199	1998-01-31	1995-10-12	Weisberg	Alison J.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
5215	2000-01-31	1994-03-04	Carter	J. Rene	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
7229	2011-02-18	2010-05-13	Allnutt	Caroline Baker	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
7306	2004-02-20	2001-10-17	Roseman	Derek	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
7651	2010-02-25	2010-04-28	Cheyne	Alison	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
7711	1992-02-26	1991-09-03	Nealer	Kevin G.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
8103	1999-02-28	1995-07-10	Tappan	Joan S.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
8296	2016-02-28	2015-06-22	Zelkowitz	Jeffrey	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
8297	2016-02-28	2015-11-05	Page	Kenneth	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
8858	2008-03-01	2007-08-17	Jones	A. Elizabeth (Beth)	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
8983	2010-03-02	2008-09-17	Levine	Jodi	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
10627	2001-03-23	1996-07-17	Johnson	Michael S.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
11816	1999-03-31	1995-07-17	Hyland	Amy E.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
12503	1997-04-01	1993-03-31	Jenkins	Kempton B.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
12542	2010-04-01	1999-05-07	Peterson	J.E.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
13484	2009-04-15	1994-02-03	Hausrath	Jan	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
13816	2018-04-20	2017-07-28	Ackerman	Graham	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
13913	1992-04-22	1991-12-13	Bernstein	James S.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
14115	2014-04-25	2014-04-16	Johnson	Glen	6184	2013-09-05	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
14295	2010-04-28	2010-04-28	Cangany	John Joseph	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
14307	2017-04-28	2016-06-21	Adekoya	Abisola	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
14308	2017-04-28	2016-06-21	Colquitt	Katherine	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
14381	2011-04-29	2010-04-28	Rice	Emily	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
14842	2001-04-30	1994-03-22	Haas	Clifford B.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
14847	2001-04-30	1999-04-30	Chornodolsky	Volodymyr A.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
15081	2016-04-30	2016-04-12	Eymond-Laritaz	Thomas	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15100	2018-04-30	2018-02-15	Suter	Kelsey	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15103	2018-04-30	2018-03-13	Allapur	Prateek D.	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15104	2018-04-30	2018-03-13	Barnhart	Linda	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15105	2018-04-30	2018-03-13	Chaney	Glyn Cozart	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15106	2018-04-30	2018-03-13	Faull	Benjamin	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15107	2018-04-30	2018-03-13	Feldman	Alyse Rebecca	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15108	2018-04-30	2018-03-13	Kraus	Margery	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15109	2018-04-30	2018-03-13	Kredan	Mohammed K.	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15110	2018-04-30	2018-03-13	McDonald	Devyn	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15111	2018-04-30	2018-03-13	Mimms	Evan	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15112	2018-04-30	2018-03-13	Shaffer	Iris D.	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15113	2018-04-30	2018-03-13	VanOrnum	Richard	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15114	2018-04-30	2018-03-13	Waldmann	Jennifer	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15115	2018-04-30	2018-03-13	Waly	Ahmed	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15116	2018-04-30	2018-03-13	Wills	Taylor N.	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15117	2018-04-30	2018-03-19	Banks	Dominique	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15118	2018-04-30	2018-03-19	Cannon	Mylan	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15119	2018-04-30	2018-03-19	Eisengrein	Jeremy D.	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15120	2018-04-30	2018-03-19	Foust	Patrick	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15121	2018-04-30	2018-03-19	Kimble	Jolyon	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15122	2018-04-30	2018-03-26	Clarke	Liam Leduc	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15123	2018-04-30	2018-03-26	MacDonald	Killian Grace	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15126	2018-04-30	2018-05-10	Bruce	Isabel	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15127	2018-04-30	2017-07-28	Kumar	Anu	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15128	2018-04-30	2017-07-28	Scandling	Dan	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15129	2018-04-30	2017-07-28	Valdes	Jordan	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15130	2018-04-30	2017-07-28	Vieregge	Dale B.	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15131	2018-04-30	2017-08-04	Arlook	Eleanor	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15132	2018-04-30	2017-08-04	Saad	Passent	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15133	2018-04-30	2017-08-22	Osher	Lana Elizabeth	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15136	2018-04-30	2017-11-09	Valeriano	Julio M.	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15138	2018-04-30	2017-11-22	Goldman	Kevin	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15139	2018-04-30	2017-11-28	Wills	Taylor	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15140	2018-04-30	2017-12-20	Glace	Margaret Keitha	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
15861	2010-05-07	2007-12-04	Kraus	Evan	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
16277	2010-05-13	2010-05-13	London	Joanna Krinn	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
16767	1998-05-20	1995-07-10	Hill	Emil T.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
16771	2003-05-20	1994-05-20	Stiner	John E.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
16772	2003-05-20	1995-10-12	Sinel	Natasha	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
16831	1992-05-21	1992-01-16	Bonker	Don L.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
17246	2010-05-27	2010-05-13	Wyche	Gustavus	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
17513	2014-05-30	2014-04-16	Goldman	Kevin	6184	2013-09-05	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
17514	2014-05-30	2014-04-16	Gregory	Jonathan M.	6184	2013-09-05	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
17515	2014-05-30	2014-04-16	Namsral	Ariuna	6184	2013-09-05	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
17516	2014-05-30	2014-04-16	Pierce	William A.	6184	2013-09-05	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
17517	2014-05-30	2014-04-16	Wescott	David Michael	6184	2013-09-05	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
17518	2014-05-30	2014-04-25	Maze-Sencier	Philippe	6184	2013-09-05	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
17519	2014-05-30	2014-04-25	Zou	Yin	6184	2013-09-05	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
17523	2015-05-30	2015-04-28	Bonker	Don	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
17524	2015-05-30	2015-04-28	Gregory	Jonathan	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
17525	2015-05-30	2015-04-28	Kraus	Margery	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
17526	2015-05-30	2015-04-28	Steams	Cliff	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
17858	1996-05-31	1994-03-01	Deutsch	Edward A.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18089	2011-05-31	2009-08-14	Hutson	Zachary	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18533	2010-06-01	2001-03-09	Krause	Charles A.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18534	2010-06-01	2010-04-12	Swint	Jennifer	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18538	2010-06-01	2009-08-14	Buerkle	Karen	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18539	2010-06-01	2009-08-14	Dalbec	Bill	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18540	2010-06-01	2009-08-14	Gara	Robert	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18541	2010-06-01	2009-08-14	Jarrell	Kent	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18542	2010-06-01	2009-08-14	Pierce	William	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18543	2010-06-01	2009-08-14	Pines	Wayne	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
18551	2011-06-01	2009-08-14	Meadows	Taj	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
19978	1995-06-21	1993-05-14	McCormick	Ann	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
20122	2010-06-23	2010-04-28	Kolton	Anne W.	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
21874	2017-06-30	2017-06-09	Waldmann	Jennifer	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
21888	2017-06-30	2016-12-06	Kare	Sarika Uma	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
21889	2017-06-30	2016-12-06	Limoges	Amanda	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
21890	2017-06-30	2016-12-06	Resler	Sutton	6291	2015-04-28	APCO Worldwide, Inc.	1299 Pennsylvania Ave. NW	Suite 300	Washington	DC	20004
22862	2010-07-09	2010-04-28	Leonard	Scott	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005
23314	2011-07-15	2010-04-28	Alejandro	John	4561	1991-09-03	APCO Worldwide, Inc.	700 12th Street, NW	Suite 800	Washington	DC	20005