fara

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

Custom SQL query returning 22 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 "Registration_Number" = :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 "Registration_Number" = :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
601		2009-03-19	Nielsen	Anna	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
1585		2022-08-09	Hansen	Mette Ejlskov	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
1663		2021-08-24	Petersen	Katinka Friis	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
4367	2017-01-24	2008-09-10	Sorensen	Britt Hougaard	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
4874	1951-01-31	1950-07-25	Thulin	Sven	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
7321	1973-02-21	1950-07-25	Dessau	Axel Carl Julius	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
8624	1957-03-01	1951-08-27	Hasselriis	Casper H.W.	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
11312	2021-03-30	2019-10-07	Cordt-Bergholt	Mette	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
11478	1978-03-31	1973-02-01	Dessau	Axel	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
19882	2015-06-19	2008-09-10	Johansson	Christina Emmy Heinze	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
21581	2006-06-30	2004-09-15	Tierney	Erin	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
21644	2009-06-30	2008-09-10	Giery	Catrine A.	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
21866	2017-06-30	2013-02-07	Bedholm	Bruno	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
22375	2020-07-01	2016-02-04	Simonsen	Kathrine	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
22546	2012-07-03	2008-09-10	Nordenbaek	Susanne	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
23315	2013-07-15	2012-03-20	Moller	Sidsel Godshaw	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
23547	1990-07-18	1950-07-25	Brumme	Ilma	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
28546	2010-08-31	2010-02-18	Henriksen	Andrea Storm	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
28834	1984-09-01	1978-09-22	Lovschal	Steen	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
33648	2020-10-25	2018-03-15	Kristiansen	Ninna Seerup	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
38852	2018-12-20	2014-07-25	Klan	Tai Hoejer	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017
42023	2016-12-31	2010-02-18	Andersen	Christina	634	1950-07-25	VisitDenmark	655 Third Avenue	18th Floor, Suite 2010	New York	NY	10017