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
139		2023-01-17	Goldman	Kevin	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
140		2023-01-17	London	Joy	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
141		2023-01-17	Perlmutter	Rachel	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
142		2023-01-17	Pittman	Mary Gannon	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
143		2023-01-17	Prade	Nasir Steven	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
144		2023-01-17	Ringler	Todd D.	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
145		2023-01-17	Teitelman	Sarah	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
196		2023-01-25	Chitwood	Matthew McKenzie	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
197		2023-01-25	Garsko	Summer	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
273		2023-01-31	O'Keefe	Eleanor	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
274		2023-01-31	Albrow	Sophie	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
276		2023-01-31	Cusack	Patricia	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
277		2023-01-31	Garvey	Alex Edward	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
278		2023-01-31	Jones	Timothy Carlton	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
279		2023-01-31	Killick	Charles Robinson	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
280		2023-01-31	Lock	Benjamin	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
281		2023-01-31	Lowe	Matthew	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
333		2022-02-07	Workman	Daniel	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
353		2023-02-10	Awesu	Awanat Toyin	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
354		2023-02-10	Streit	Matthew	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
355		2023-02-10	Thompson	Jeremy Solomon	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
461		2021-02-26	Millard	Rachel Louise	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
480		2023-03-02	Cazalet	Eloise	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
481		2023-03-02	Lehr	Deborah	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
484		2023-03-02	Resnick-Ault	Jessica	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
485		2023-03-02	Rowland	Daniel	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
486		2023-03-02	Walters	Lindsay E.	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
487		2023-03-02	Watts	Joseph	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
532		2023-03-08	Ishaq Malalla Fairooz	Noora Mohammed	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
534		2023-03-08	Petroccione	Emily	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
535		2023-03-08	Roscoe	Andrew Leslie	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
560		2020-03-11	Sullivan Jr.	Jere J.	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
581		2021-03-16	Bledsoe	Paul W.	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
758		2023-04-10	Dunn	Paul	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
760		2023-04-10	Ostrower	Matthew	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
761		2023-04-10	Sabrina Lam	Ka Wai	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
762		2023-04-10	Tailor	Sophia	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
763		2023-04-10	Wei Ching	Adrianna Lau	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
764		2023-04-10	Wong	Yue Kei	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
769		2023-04-11	Si Ho Chan	Simon	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
770		2023-04-12	Cheung	Wing Sze	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
875		2023-04-25	Reid	Zoe	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
979		2023-05-06	Palmer	Jodie	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
985		2023-05-08	Mitchell	John	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
986		2023-05-08	Morimoto	Andrew	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1026		2023-05-15	Rubel	Steven	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1068		2023-05-20	Tyson	Max	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1069		2023-05-20	Vazquez	Edgar	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1080		2023-05-22	Johnson	Tomos	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1081		2023-05-22	Laws	George Benjamin	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1095		2023-05-24	DuToit	Lili	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1096		2023-05-24	Forrest	Sophie	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1097		2023-05-24	Gibbs	Portia	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1098		2023-05-24	Konowe	Adam	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1114		2023-05-26	Larese-Pollonin	Sabrina	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1213		2022-06-09	Ames	Joseph P.	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1214		2022-06-09	Esguerra	Lorenz	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1215		2022-06-09	Moses	Jarrod	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1216		2022-06-09	Silverman	Audra	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1218		2023-06-09	Dingwell	Makena	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1236		2022-06-14	Vera	Maria Pereyra	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1242		2022-06-15	Semaski	Victoria	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1263		2023-06-20	Murray	Debora Comenalli	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1264		2023-06-20	Oh	Clare	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1367		2022-07-07	Hedquist	Christopher	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1369		2022-07-07	Nandigama	Saveri	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1550		2023-07-31	Farrah	Rami	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1551		2023-07-31	Haskell	Maxim	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1567		2021-08-05	Phillips	Lauren Delaney	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1628		2021-08-17	O'Shea	Jack	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1779		2022-09-14	Davidson-Musser	Stella Bijou	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1780		2022-09-14	Edelman	Richard	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1783		2022-09-14	Harris	Lauren	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1916		2021-10-07	Lehner	Tyler Joseph	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1953		2022-10-13	Hershey	Isabella Rane	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1960		2022-10-14	Hakimi	Nicole	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1977		2019-10-17	Neary	Sean	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
1986		2022-10-19	Rittenberry	Jordan	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2106		2022-11-03	Albin	Daniela	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2107		2022-11-03	Brown	Christina	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2108		2022-11-03	Rudorf	Hanna	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2178		2022-11-17	Silva	Luis Felipe Betancourt	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2322		2020-12-01	Loyd	Weston Yates	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2401		2022-12-14	Wales	Alexandra	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2447		2022-12-21	Willner	Sean Thomas	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2895	2012-01-01	2010-07-20	Walsh	Monica	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2898	2012-01-01	2011-07-22	Bennett	Taylor R.	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
2993	2017-01-01	2013-03-15	Holland	Michael	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
3104	2008-01-02	2008-04-22	Williamson	Maria Conti	3657	1985-03-12	Daniel J. Edelman, Inc.	250 Hudson Street		New York	NY	10013
3201	2008-01-04	2008-04-22	Field	Steven	3657	1985-03-12	Daniel J. Edelman, Inc.	250 Hudson Street		New York	NY	10013
3202	2008-01-04	2008-10-31	Chamberlin	Emily	3657	1985-03-12	Daniel J. Edelman, Inc.	250 Hudson Street		New York	NY	10013
3203	2008-01-04	2008-10-31	Lopez	Jennifer	3657	1985-03-12	Daniel J. Edelman, Inc.	250 Hudson Street		New York	NY	10013
3248	2008-01-05	2008-04-22	Caldwell	Erin	3657	1985-03-12	Daniel J. Edelman, Inc.	250 Hudson Street		New York	NY	10013
3249	2008-01-05	2008-04-22	Kozel	Jennifer	3657	1985-03-12	Daniel J. Edelman, Inc.	250 Hudson Street		New York	NY	10013
3250	2008-01-05	2008-04-22	Levy	David	3657	1985-03-12	Daniel J. Edelman, Inc.	250 Hudson Street		New York	NY	10013
3498	2008-01-09	2008-10-31	Brown	Jeanette	3657	1985-03-12	Daniel J. Edelman, Inc.	250 Hudson Street		New York	NY	10013
3826	2008-01-15	2008-04-22	Roy	Tristan	3657	1985-03-12	Daniel J. Edelman, Inc.	250 Hudson Street		New York	NY	10013
3829	2010-01-15	2004-11-10	Segal	J. Peter	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
3839	2021-01-15	2020-02-20	Streit	Matthew Alan	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
3840	2021-01-15	2020-02-20	Thompson	Jeremy Solomon	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606
3841	2021-01-15	2020-02-26	Mansfield	Adalie Joy	3634	1984-11-15	Daniel J. Edelman, Inc.	111 North Canal Street	Suite 1100	Chicago	IL	60606