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
1103		2018-05-25	Koo	Hyunmo	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1130		2021-05-28	Choung	Dongha	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1134		2021-05-28	Kho	Dong Hyun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1135		2021-05-28	Kim	Jooyoung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1136		2021-05-28	Kim	Wookjin	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1138		2021-05-28	Lee	Donghoon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1139		2021-05-28	NA	Joungyoung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1145		2020-05-29	Jung	Sewon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1151		2019-05-30	Park	Donguk	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1152		2019-05-30	Sung	Kijoo	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1154		2023-05-30	Baek	Sungwoo	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1157		2023-05-30	Kyung	Kiwoo	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1158		2023-05-30	Park	Jongpyo	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1159		2023-05-30	Park	Keunhyung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1160		2023-05-30	Park	Wooksang	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1161		2023-05-30	Sungwoo	BAEK	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1166		2022-05-31	Chang	Jae Ho	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1169		2022-05-31	Jeong	Hui-ung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1170		2022-05-31	Kim	Dong Jun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1171		2022-05-31	Kim	Hyunbeom	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1172		2022-05-31	Kim	Mi-suk	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
1173		2022-05-31	Shin	Jeongsu	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2239		2019-11-27	Jin	Junhyun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2270		2021-11-29	Jang	Hyosun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2271		2021-11-29	Jung	Yeonjin	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2272		2021-11-29	Kim	Hyoung il	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2273		2021-11-29	Kim	Jonghyun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2277		2021-11-29	Min	Keunggi	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2278		2021-11-29	Park	Sungho	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2279		2021-11-29	Shim	Solina	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2280		2021-11-29	Shin	Yongho	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2281		2021-11-29	Sohn	Hosung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2291		2018-11-30	Choi	Bosung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2296		2020-11-30	Jang	Choong Sik	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2297		2020-11-30	Kim	Chulmin	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2298		2020-11-30	Lee	Seok Hwan	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2299		2020-11-30	Lee	Yungsun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2301		2020-11-30	Seo	Jiwon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2313		2022-11-30	Chang	Seog II	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2314		2022-11-30	Kim	Hoiseung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
2315		2022-11-30	Lee	Joonsub	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
3631	2007-01-12	2006-11-27	Hwang	Min Ha	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
3714	2006-01-14	2002-11-18	Kim	Yoon Tae	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4113	2010-01-19	2006-05-09	Choi	Hyun Soo	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4114	2011-01-19	2008-05-28	Jung	Won Joon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4234	2016-01-21	2012-11-28	Lee	Sujung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4325	2008-01-23	2004-07-08	Noh	Chul	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4326	2010-01-23	2008-05-28	Choe	Kihyung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4327	2013-01-23	2010-06-01	Oh	Jae Ho	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4363	2008-01-24	2004-11-12	Lim	Chae Keun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4497	2007-01-25	2005-05-10	Oh	Sung Keun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4498	2007-01-25	2003-05-16	Hong	Doo Yung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4499	2007-01-25	2003-05-16	Lee	Jung Hoon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4501	2008-01-25	2004-07-08	Son	Ho Gil	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4503	2012-01-25	2008-05-28	Uh	Jaesun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4504	2013-01-25	2009-05-28	Bae	Sangbum	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4588	2012-01-26	2008-05-28	Kim	Jun Sung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4589	2015-01-26	2012-05-29	Park	Jun Gwe	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4590	2016-01-26	2012-05-29	Kim	Ho Joon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4591	2017-01-26	2014-11-25	Lee	Jihoon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4592	2017-01-26	2013-11-27	Moon	Jin Wook	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4599	2023-01-26	2020-05-29	Kim	Seung Wook	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4600	2023-01-26	2020-05-29	Lee	Nuri	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4601	2023-01-26	2023-05-30	Kim	Seowon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4644	2007-01-27	2003-11-17	Kwak	Dong Woon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4646	2010-01-27	2006-05-09	Lee	In Kyu	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4661	2013-01-27	2010-06-01	Chang	Sunyoung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4662	2018-01-27	2014-05-28	Kim	Youngsang	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4664	2023-01-27	2020-05-29	Kang	Taek Woo	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4665	2023-01-27	2020-05-29	Park	Yong Min	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4716	2011-01-28	2007-05-29	Ahn	Jaeyong	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4721	2014-01-28	2010-06-01	Kwon	Oh Sung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4722	2017-01-28	2014-11-25	Kim	Byung Ho	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4723	2018-01-28	2015-11-30	Kang	Junkyung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4725	2019-01-28	2015-05-28	Yoo	Jeawook	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4767	2008-01-29	2004-11-12	Kim	Doo Young	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4768	2009-01-29	2004-11-12	Lee	Hong Kyun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4772	2011-01-29	2008-05-28	Park	Sang Hyup	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4861	2014-01-30	2011-05-25	Kang	Sang Yeob	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4866	2017-01-30	2013-05-28	Han	Taesik	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
4868	2017-01-30	2014-05-28	Ahn	Young Ju	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5318	2004-01-31	2000-12-06	Kim	Jong-Weon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5319	2004-01-31	2000-12-06	Kim	Kyung-Yool	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5320	2004-01-31	2000-12-06	Lee	Kwang Il	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5321	2004-01-31	2000-12-06	Lee	Kyu-Seon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5322	2004-01-31	2000-12-06	Yeon	Young-Chul	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5332	2005-01-31	2001-05-17	Hwang	Eui Shun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5333	2005-01-31	2002-05-17	Kim	Yang Il	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5337	2005-01-31	2002-11-18	Jeon	Sang Woo	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5338	2005-01-31	2002-11-18	Kim	Hyun-Duk	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5339	2005-01-31	2002-11-18	Kim	Kwanghee	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5340	2005-01-31	2000-12-06	Kang	Shin-Taeg	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5353	2006-01-31	2003-05-16	Min	Kyun	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5354	2006-01-31	2002-05-17	Kwon	Oh Hyoung	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5376	2007-01-31	2003-05-16	Jang	Jin	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5382	2007-01-31	2004-07-08	Park	Bum Hoon	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5406	2008-01-31	2004-07-08	Kim	Jeong Dong	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5430	2010-01-31	2007-05-29	Chung	Jongtae	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5431	2010-01-31	2007-05-29	Kim	Sang Chul	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5447	2011-01-31	2007-05-29	Hur	Jin Hak	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022
5471	2013-01-31	2009-05-28	Lim	Jaegeol	1619	1963-04-17	KOTRA	460 Park Avenue	14th Floor	New York	NY	10022