FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

45 rows where Registration_Number = 5554

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date)

State 1

Registration_Number 1

  • Hmong Foreign Council · 45 ✖

Registrant_Name 1

City 1

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
17500 17500 2004-05-30 2003-09-22 Moua Bee Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
26397 26397 2004-08-10 2004-06-04 Neu Vang Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39187 39187 2004-12-27 2004-02-26 Xiong Seng SalXooly Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39188 39188 2004-12-27 2004-02-26 Yang Leepao Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39189 39189 2004-12-27 2004-06-04 Chang Kao Xong Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39190 39190 2004-12-27 2004-06-04 Her James Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39191 39191 2004-12-27 2004-06-04 Lee Yer Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39192 39192 2004-12-27 2004-06-04 Lo Ker Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39193 39193 2004-12-27 2004-06-04 Yang Keng Fue Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39194 39194 2004-12-27 2003-09-22 Chang Chong Xue Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39195 39195 2004-12-27 2003-09-22 Her Soua Xue Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39196 39196 2004-12-27 2003-09-22 Xiong Xeng Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39197 39197 2004-12-27 2004-12-27 Chang Jeffrey Dang Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39198 39198 2004-12-27 2004-12-27 Chaw Kue Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39199 39199 2004-12-27 2004-12-27 Lao Ly (Phai Thun Li) Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39200 39200 2004-12-27 2004-12-27 Lee Teng Za Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39201 39201 2004-12-27 2004-12-27 Lee Yee Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39202 39202 2004-12-27 2004-12-27 Thao Teng Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39203 39203 2004-12-27 2004-12-27 Vang Ge H.M. Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39204 39204 2004-12-27 2004-12-27 Vang Nao Shoua Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39205 39205 2004-12-27 2004-12-27 Vang Nhia Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39206 39206 2004-12-27 2004-12-27 Vang Nou Xia Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39207 39207 2004-12-27 2004-12-27 Vang Yang Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39208 39208 2004-12-27 2004-12-27 Vue Chai Zong Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39209 39209 2004-12-27 2004-12-27 Vue Chong Sue Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39210 39210 2004-12-27 2004-12-27 Vue Kia Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39211 39211 2004-12-27 2004-12-27 Xiong Chou Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39212 39212 2004-12-27 2004-12-27 Xiong Gnia Yang Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39213 39213 2004-12-27 2004-12-27 Xiong Long Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39214 39214 2004-12-27 2004-12-27 Xiong Phia Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39215 39215 2004-12-27 2004-12-27 Xiong Sy Khue Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39216 39216 2004-12-27 2004-12-27 Xiong Vansan Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39217 39217 2004-12-27 2004-12-27 Xiong Yer Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39218 39218 2004-12-27 2004-12-27 Yang Chang Vang Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39219 39219 2004-12-27 2004-12-27 Yang Chao Lee Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39220 39220 2004-12-27 2004-12-27 Yang Cher Yao Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39221 39221 2004-12-27 2004-12-27 Yang Chong Sao Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39222 39222 2004-12-27 2004-12-27 Yang Jerry Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39223 39223 2004-12-27 2004-12-27 Yang Leng Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39224 39224 2004-12-27 2004-12-27 Yang Neng Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39225 39225 2004-12-27 2004-12-27 Yang Nhia Long Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39226 39226 2004-12-27 2004-12-27 Yang Pao T. Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39227 39227 2004-12-27 2004-12-27 Yang Thomas Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39228 39228 2004-12-27 2004-12-27 Yang Wang Doua Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015
39229 39229 2004-12-27 2004-12-27 Yang Zong Teng Hmong Foreign Council 5554 2003-04-14 Hmong Foreign Council 6740 E. Ten Mile Road   Centerline MI 48015

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])
);