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

50 rows where Registration_Number = 3311

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Bee Moua · 50 ✖

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
6518 6518 1986-02-10 1983-05-25 Xiong Xia Ser Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
9563 9563 1984-03-10 1983-03-30 Khang Wang Seng Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
22595 22595 1988-07-05 1986-01-13 Her Tong X. Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
22851 22851 1993-07-09 1985-12-10 Yang Kou Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
25980 25980 1988-08-05 1986-01-27 Her Xao Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
25981 25981 1988-08-05 1986-01-29 Her Pao Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28837 28837 1985-09-01 1985-12-26 Yang Cha Nhia Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28842 28842 1987-09-01 1985-02-14 Nao Vong Ly Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28843 28843 1987-09-01 1986-02-25 Yang Kao Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28845 28845 1987-09-01 1986-03-07 Moua Cha Koua Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28846 28846 1987-09-01 1986-03-07 Tong Gee Vue Tseu Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28847 28847 1987-09-01 1986-03-12 Yer Moua Tou Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28849 28849 1987-09-01 1983-03-30 Yang Chong Moua Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28850 28850 1987-09-01 1985-04-02 Yang Lia sue day Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28851 28851 1987-09-01 1983-04-15 Lo Chong Va Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28852 28852 1987-09-01 1985-04-15 Her Pa Ying Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28853 28853 1987-09-01 1985-04-15 Her Wang Xang Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28854 28854 1987-09-01 1984-04-17 Pao Lor Vang Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28855 28855 1987-09-01 1985-05-02 Her Yang Neng Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28858 28858 1987-09-01 1983-05-23 Vang Chia Koua Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28860 28860 1987-09-01 1983-06-29 Xiong Xia Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28861 28861 1987-09-01 1983-06-29 Yang Chue Tou Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28862 28862 1987-09-01 1983-06-29 Yang Long Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28863 28863 1987-09-01 1983-07-01 Yang Pa Doua Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28864 28864 1987-09-01 1983-07-27 Chou Vang Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28865 28865 1987-09-01 1984-07-30 Yang Chao Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28869 28869 1987-09-01 1985-09-06 Her You Pao Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28870 28870 1987-09-01 1984-09-12 Lue Lee Seng Nao Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28871 28871 1987-09-01 1982-09-15 Yang Shong Hue Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28872 28872 1987-09-01 1985-10-15 Xiong Eng Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28873 28873 1987-09-01 1985-10-15 Yang Xia Seng Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28874 28874 1987-09-01 1984-10-18 Ying Lee Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28875 28875 1987-09-01 1983-10-25 Moua Yo Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28876 28876 1987-09-01 1985-11-12 Heu Vang Lee Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28877 28877 1987-09-01 1985-11-18 Leng Yang Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28878 28878 1987-09-01 1985-12-02 Yang Tua Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28879 28879 1987-09-01 1985-12-11 Her Nay Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
28880 28880 1987-09-01 1985-12-11 Herr Ben W. Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
32673 32673 1988-10-12 1983-05-18 Yang Yee Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
32674 32674 1988-10-12 1983-06-15 Xiong Cha Ee Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
32675 32675 1988-10-12 1983-08-20 Xiong Gnia Yang Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
33241 33241 1988-10-20 1983-05-25 Yang Gnia Yee Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
33242 33242 1988-10-20 1983-05-25 Yang Tong Neng Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
33243 33243 1988-10-20 1982-09-20 Blong Yang Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
33418 33418 1988-10-22 1985-04-26 Her Chay Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
35290 35290 1988-11-05 1986-02-04 Her Seng Xia Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
35291 35291 1988-11-05 1986-03-13 Her Soua Pao Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
35292 35292 1988-11-05 1987-03-16 Yang Ter Fong Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
35293 35293 1988-11-05 1984-04-03 Moua Mit Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738
35295 35295 1988-11-05 1983-09-28 Chang Chue Bee Moua 3311 1981-11-27 Bee Moua 301 James Street   Grayling MI 49738

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