FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
59 rows where State = "CA" and Zip = 90010
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date)
Registration_Number 10
- Government of India Tourist Office, Los Angeles 13
- Chinese Information Service, Pacific Coast Bureau 10
- Jamaica Tourist Board, Los Angeles 9
- Braun & Company 8
- Braun & Company 7
- Mexican Ministry of Tourism, Los Angeles 4
- Jamaica Tourist Board, Los Angeles 2
- Scandinavian National Tourist Office 2
- Austrian National Tourist Office, Los Angeles 2
- Culver Advertising, Inc., a California Corporation 2
Registrant_Name 8
- Braun & Company 15
- Government of India Tourist Office, Los Angeles 13
- Jamaica Tourist Board, Los Angeles 11
- Chinese Information Service, Pacific Coast Bureau 10
- Mexican Ministry of Tourism, Los Angeles 4
- Austrian National Tourist Office, Los Angeles 2
- Culver Advertising, Inc., a California Corporation 2
- Scandinavian National Tourist Office 2
City 2
- Los Angeles 57
- Los Angles 2
State 1
- CA · 59 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4950 | 4950 | 1975-01-31 | 1973-05-22 | Chaturvedi | A. N. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
4962 | 4962 | 1979-01-31 | 1975-01-07 | Kohli | Y. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
5691 | 5691 | 1973-02-01 | 1966-03-18 | Pow | Patricia Shiu-Ying | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
6919 | 6919 | 1977-02-15 | 1973-04-05 | Gupte | H. S. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
6920 | 6920 | 1977-02-15 | 1975-05-06 | Becker | John Williams | Culver Advertising, Inc., a California Corporation 2582 | 1975-05-06 | Culver Advertising, Inc., a California Corporation | 3550 Wilshire Boulevard | Los Angeles | CA | 90010 | |
6921 | 6921 | 1977-02-15 | 1975-05-06 | Plexico | Jon L. | Culver Advertising, Inc., a California Corporation 2582 | 1975-05-06 | Culver Advertising, Inc., a California Corporation | 3550 Wilshire Boulevard | Los Angeles | CA | 90010 | |
7160 | 7160 | 1975-02-17 | 1971-03-08 | Ni | Kung-Chao | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
7430 | 7430 | 1973-02-23 | 1973-02-21 | Chowdry | A. P. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
7592 | 7592 | 1978-02-25 | 1972-11-13 | Tsui | Pao-Ying | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
7874 | 7874 | 1975-02-28 | 1973-09-24 | Khurana | D. R. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
7902 | 7902 | 1983-02-28 | 1981-01-23 | Miller | Clifford A. | Braun & Company 3192 | 1981-01-23 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 |
7904 | 7904 | 1983-02-28 | 1983-02-28 | Boyle | Audrey | Braun & Company 3192 | 1981-01-23 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 |
7905 | 7905 | 1983-02-28 | 1983-02-28 | Campbell | Ian D. | Braun & Company 3192 | 1981-01-23 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 |
7909 | 7909 | 1983-02-28 | 1982-03-24 | Grimaldi | John | Braun & Company 3192 | 1981-01-23 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 |
7910 | 7910 | 1983-02-28 | 1982-03-24 | Miller | Judy M. | Braun & Company 3192 | 1981-01-23 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 |
7912 | 7912 | 1983-02-28 | 1982-03-31 | Cicetti | Fred | Braun & Company 3192 | 1981-01-23 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 |
7913 | 7913 | 1983-02-28 | 1982-03-31 | Miller | William | Braun & Company 3192 | 1981-01-23 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 |
7914 | 7914 | 1983-02-28 | 1982-03-31 | Molinelli | Donald | Braun & Company 3192 | 1981-01-23 | Braun & Company | 3055 Wilshire Boulevard | Suite 540 | Los Angeles | CA | 90010 |
11481 | 11481 | 1978-03-31 | 1972-08-24 | Christensen | Poul | Scandinavian National Tourist Office 2372 | 1972-08-24 | Scandinavian National Tourist Office | 3600 Wilshire Boulevard | Los Angeles | CA | 90010 | |
13685 | 13685 | 1982-04-18 | 1976-01-16 | Sandanam | K. S. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
13917 | 13917 | 1996-04-22 | 1987-12-29 | Brown | Richard | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
14077 | 14077 | 1967-04-25 | 1966-03-18 | Shih | Hsio-Pan | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
15349 | 15349 | 1980-05-01 | 1976-08-31 | Duerer | Dr. Alexander M. | Austrian National Tourist Office, Los Angeles 2481 | 1973-12-04 | Austrian National Tourist Office, Los Angeles | 3440 Wilshire Boulevard | Suite 515 | Los Angles | CA | 90010 |
15350 | 15350 | 1980-05-01 | 1973-12-04 | Winkler | Dr. Egon | Austrian National Tourist Office, Los Angeles 2481 | 1973-12-04 | Austrian National Tourist Office, Los Angeles | 3440 Wilshire Boulevard | Suite 515 | Los Angles | CA | 90010 |
16672 | 16672 | 2004-05-18 | 2000-01-05 | DaCosta | Rosemary C. | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
16673 | 16673 | 2004-05-18 | 2004-09-01 | Holland | Dian | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
17629 | 17629 | 1976-05-31 | 1975-06-13 | Sand | John J. | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
18974 | 18974 | 1986-06-06 | 1985-07-30 | Kohli | G. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
19107 | 19107 | 1989-06-09 | 1986-05-06 | Wallace | Laura | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
19109 | 19109 | 1989-06-09 | 1986-11-06 | Malik | Peter Anthony | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
20886 | 20886 | 1974-06-30 | 1972-02-15 | Brachvogel | Theodora | Jamaica Tourist Board, Los Angeles 2316 | 1972-02-15 | Jamaica Tourist Board, Los Angeles | 3075 Wilshire Boulevard | Los Angeles | CA | 90010 | |
20887 | 20887 | 1974-06-30 | 1972-02-15 | Delgado | Albert J. | Jamaica Tourist Board, Los Angeles 2316 | 1972-02-15 | Jamaica Tourist Board, Los Angeles | 3075 Wilshire Boulevard | Los Angeles | CA | 90010 | |
21149 | 21149 | 1991-06-30 | 1989-04-27 | Nair | Devika B. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
23619 | 23619 | 1994-07-19 | 1990-08-07 | Dryden | Roger | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
23621 | 23621 | 1999-07-19 | 1995-01-06 | Dryden | Roger A. | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
24677 | 24677 | 1973-07-31 | 1972-08-31 | Valades | Leon | Mexican Ministry of Tourism, Los Angeles 1869 | 1965-03-16 | Mexican Ministry of Tourism, Los Angeles | 3106 Wilshire Boulevard | Los Angeles | CA | 90010 | |
24746 | 24746 | 1986-07-31 | 1982-03-18 | Taffe | Clive E. | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
26850 | 26850 | 1965-08-17 | 1965-03-16 | De Larrea | Javier Lelo | Mexican Ministry of Tourism, Los Angeles 1869 | 1965-03-16 | Mexican Ministry of Tourism, Los Angeles | 3106 Wilshire Boulevard | Los Angeles | CA | 90010 | |
27139 | 27139 | 1993-08-21 | 1995-04-19 | Khattar | B.K. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
28011 | 28011 | 1979-08-31 | 1978-10-31 | Paavola | Timo | Scandinavian National Tourist Office 2372 | 1972-08-24 | Scandinavian National Tourist Office | 3600 Wilshire Boulevard | Los Angeles | CA | 90010 | |
29485 | 29485 | 1993-09-09 | 1990-06-06 | Trehan | Mr. K.K. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
31814 | 31814 | 1972-10-01 | 1966-03-18 | Lin | Robert C.H. | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
31971 | 31971 | 2003-10-01 | 1982-08-04 | Dawson | Donald | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
32682 | 32682 | 1990-10-12 | 1973-02-21 | Ramakrishna | G. | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
32683 | 32683 | 1990-10-12 | 1973-05-10 | Ahmed | Q. Iqbal | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
34861 | 34861 | 1972-11-01 | 1972-01-26 | Ma | Alun Fu-Chung | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
35202 | 35202 | 1974-11-04 | 1973-11-13 | Liu | Shih-Hong | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
36115 | 36115 | 1989-11-20 | 1986-12-24 | Kelsay | Sonia Chin | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
36696 | 36696 | 1988-11-30 | 1987-02-12 | Miller | William | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36697 | 36697 | 1988-11-30 | 1987-02-17 | Miller | Judy M. | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36703 | 36703 | 1988-11-30 | 1986-05-06 | Grimaldi | John P. | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36704 | 36704 | 1988-11-30 | 1986-05-06 | Harper | Jeff | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36705 | 36705 | 1988-11-30 | 1986-05-21 | Miller | Clifford A. | Braun & Company 3825 | 1986-05-06 | Braun & Company | 3580 Wilshire Boulevard | Suite 1520 | Los Angeles | CA | 90010 |
36724 | 36724 | 1989-11-30 | 1986-11-19 | Majeed | Abdul | Government of India Tourist Office, Los Angeles 2407 | 1973-02-21 | Government of India Tourist Office, Los Angeles | 3550 Wilshire Boulevard | Suite 204 | Los Angeles | CA | 90010 |
37350 | 37350 | 1981-12-01 | 1981-11-18 | Steele | Mary Ann | Jamaica Tourist Board, Los Angeles 3305 | 1981-11-18 | Jamaica Tourist Board, Los Angeles | 8703 La Tijera Boulevard | Suite 208 | Los Angeles | CA | 90010 |
40015 | 40015 | 1976-12-31 | 1972-08-31 | Jimenez | Pedro Amaro | Mexican Ministry of Tourism, Los Angeles 1869 | 1965-03-16 | Mexican Ministry of Tourism, Los Angeles | 3106 Wilshire Boulevard | Los Angeles | CA | 90010 | |
40016 | 40016 | 1976-12-31 | 1972-08-31 | Van Gelderen | Marcela Molgora | Mexican Ministry of Tourism, Los Angeles 1869 | 1965-03-16 | Mexican Ministry of Tourism, Los Angeles | 3106 Wilshire Boulevard | Los Angeles | CA | 90010 | |
40127 | 40127 | 1980-12-31 | 1966-03-18 | Cheng | Stanway N.W. | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
40135 | 40135 | 1980-12-31 | 1978-04-28 | Tzou | David Y.S. | Chinese Information Service, Pacific Coast Bureau 1969 | 1966-03-18 | Chinese Information Service, Pacific Coast Bureau | 3440 Wilshire Boulevard | Suite 1108 | Los Angeles | CA | 90010 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );