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

23 rows where City = "Los Angeles" and Registrant_Name = "Malaysia Tourism Promotion Board"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

Registrant_Name 1

  • Malaysia Tourism Promotion Board · 23 ✖

City 1

  • Los Angeles · 23 ✖
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
1057 1057   2020-05-19 Setia Mohd Akbal Bin Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
2681 2681 1989-01-01 1989-08-16 Hamid Noor Ahmad Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
3374 3374 2005-01-07 2000-05-19 Musa Normasila Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
6083 6083 2013-02-03 2009-07-14 Araju Mazlan Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
12662 12662 2021-04-02 2017-11-27 Ab Rahim Ednie Rahma Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
13636 13636 1990-04-17 1989-02-07 Abu Amirrudin Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
13648 13648 2000-04-17 1995-05-17 Danial Sharifah Loon Fatimah Syed Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
14534 14534 1982-04-30 1975-10-10 Jaffar Esa B. Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
16611 16611 1995-05-17 1990-06-06 Mohamed Yazid Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
16768 16768 2002-05-20 1995-05-17 Cheah Kin Hun Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
17713 17713 1988-05-31 1984-06-26 Mohyat Mokhtar B. Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
18095 18095 2012-05-31 2008-05-21 Kaur Robinder Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
19062 19062 1993-06-08 1987-10-02 Yusop Ahmad Hj. Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
19338 19338 1975-06-13 1974-05-23 Abod Sheikh Salim Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
21596 21596 2007-06-30 2002-09-19 Long Abd. Talib HJ. Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
21901 21901 2018-06-30 2013-06-04 Zainal Abidin Azilina Azni Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
22612 22612 2017-07-05 2015-12-04 Noordin Norzaimi Izham Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
24592 24592 2011-07-30 2008-03-18 Omar Norazmi Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
24780 24780 1989-07-31 1988-11-22 Zakaria Dzullkeflee B. Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
29124 29124 2015-09-03 2011-12-08 Ishak Azham Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
29308 29308 1982-09-07 1979-12-17 Johari Mazita Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
36669 36669 1984-11-30 1984-06-26 Hun Cheah Kin Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
38694 38694 2008-12-18 2006-09-06 Yahya Mohamed Amin Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432

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