FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
34 rows where Address_1 = "Beijing"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 27
- China National Textiles Import & Export Corporation 3
- China National Textiles Import/Export Corporation (CHINATEX) 3
- China Great Wall Industry Corporation 2
- People's Daily Overseas Edition 2
- Yan Shan Science & Technology Corporation 2
- Air China International Corporation, Ltd. 1
- Air China International Corporation, Ltd. d/b/a Air China 1
- Aviation Industries of China (formerly: Ministry of Aerospace Industry of the People's Repuplic of China) 1
- Beijing Economic Development Corporation 1
- Beijing Review 1
- China Counsel for the Promotion of International Trade (CCPIT) 1
- China Daily of Beijing, China 1
- China International Travel Service (CITS) 1
- China National Tourism Administration 1
- China National Tourism Administration (formerly: China International Travel Service) 1
- China Ocean Shipping Company 1
- Chinese Science News Overseas Edition 1
- General Administration of Civil Aviation of China 1
- General Administration of Civil Aviation of China (CAAC) 1
- Institute of Scientific & Technical Information of China 1
- Liao Wang Weekly, Ltd. 1
- Ministry of Economic Relations & Trade 1
- New China Pictures Company 1
- Outlook Weekly 1
- Poly Technologies, Inc. 1
- Renmin Ribao Publishing House 1
- Science Times - Overseas Edition (formerly Chinese Science News Overseas Edition) 1
Registrant_Name 26
- Graham & James, L.L.P. 3
- KMC Trading 3
- Daniels, Houlihan & Palmeter 2
- Fasturn, Inc. 2
- Fleishman-Hillard, Inc. 2
- Hai Tian Development U.S.A., Inc. 2
- A.I.T. Corporation 1
- China Books & Periodicals, Inc. 1
- China Daily Distribution Corporation 1
- China Exhibition Corporation 1
- China National Tourist Office 1
- Chinamerica Corporation 1
- Cole Corette & Abrutyn, P.C. 1
- Cypress Press (U.S.A.), Inc. 1
- Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 1
- Foster Garvey PC 1
- Haight, Gardner, Poor & Havens 1
- Harmer, John L. 1
- Institute for Economic Restructuring, Inc. 1
- Lau, Louis Yiu-Luen 1
- Mudge, Rose, Guthrie, Alexander & Ferdon 1
- Sandler, Travis & Rosenberg, P.A. 1
- Siegel, Leah 1
- Sino-American Technology Exchange Council (SATEC) 1
- Synergy Publishing, Inc. 1
- Washington, Perito & Dubuc 1
Registrant_Date (date) 26 ✖
- 1981-09-23 3
- 1992-03-20 3
- 1968-01-30 2
- 1978-08-09 2
- 1986-02-05 2
- 1996-12-03 2
- 1960-04-06 1
- 1974-01-21 1
- 1977-06-29 1
- 1978-10-18 1
- 1979-08-09 1
- 1979-11-30 1
- 1980-05-21 1
- 1981-02-18 1
- 1981-04-13 1
- 1981-04-15 1
- 1981-05-18 1
- 1981-12-30 1
- 1983-04-19 1
- 1984-09-21 1
- 1985-06-19 1
- 1986-12-23 1
- 1988-03-21 1
- 1992-07-31 1
- 1994-10-06 1
- 1995-01-04 1
State 1
- - 34
Country/Location_Represented 1
- CHINA 34
City 1
- - 34
Link | rowid ▼ | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14 | 14 | People's Daily Overseas Edition | 1996-12-03 | CHINA | Hai Tian Development U.S.A., Inc. 5143 | 1996-12-03 | Hai Tian Development U.S.A., Inc. | Beijing | |||||
112 | 112 | China Daily of Beijing, China | 1983-04-19 | CHINA | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | Beijing | |||||
113 | 113 | China National Tourism Administration (formerly: China International Travel Service) | 1981-12-30 | CHINA | China National Tourist Office 3318 | 1981-12-30 | China National Tourist Office | Beijing | |||||
1446 | 1446 | 1988-01-21 | Beijing Review | 1986-12-23 | CHINA | Cypress Press (U.S.A.), Inc. 3918 | 1986-12-23 | Cypress Press (U.S.A.), Inc. | Beijing | ||||
1785 | 1785 | 1995-01-31 | China Great Wall Industry Corporation | 1994-10-06 | CHINA | Institute for Economic Restructuring, Inc. 4959 | 1994-10-06 | Institute for Economic Restructuring, Inc. | Beijing | ||||
1817 | 1817 | 1998-01-31 | Institute of Scientific & Technical Information of China | 1995-01-04 | CHINA | Lau, Louis Yiu-Luen 4984 | 1995-01-04 | Lau, Louis Yiu-Luen | Beijing | ||||
2321 | 2321 | 1986-02-09 | China National Textiles Import/Export Corporation (CHINATEX) | 1984-08-08 | CHINA | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | Beijing | ||||
2665 | 2665 | 1987-02-19 | Poly Technologies, Inc. | 1985-06-19 | CHINA | Harmer, John L. 3691 | 1985-06-19 | Harmer, John L. | Beijing | ||||
2866 | 2866 | 1993-02-26 | Ministry of Economic Relations & Trade | 1992-07-31 | CHINA | Sandler, Travis & Rosenberg, P.A. 4698 | 1992-07-31 | Sandler, Travis & Rosenberg, P.A. | Beijing | ||||
3305 | 3305 | 1992-03-01 | Renmin Ribao Publishing House | 1981-11-03 | CHINA | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | Beijing | ||||
3441 | 3441 | 1994-03-04 | China International Travel Service (CITS) | 1993-09-07 | CHINA | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Beijing | ||||
3766 | 3766 | 1984-03-15 | Yan Shan Science & Technology Corporation | 1981-05-18 | CHINA | Sino-American Technology Exchange Council (SATEC) 3243 | 1981-05-18 | Sino-American Technology Exchange Council (SATEC) | Beijing | ||||
4002 | 4002 | 1996-03-23 | Aviation Industries of China (formerly: Ministry of Aerospace Industry of the People's Repuplic of China) | 1992-10-23 | CHINA | Graham & James, L.L.P. 3275 | 1981-09-23 | Graham & James, L.L.P. | Beijing | ||||
4056 | 4056 | 1986-03-26 | China National Textiles Import & Export Corporation | 1981-06-09 | CHINA | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | Beijing | ||||
5099 | 5099 | 1992-04-08 | Air China International Corporation, Ltd. | 1988-08-18 | CHINA | Washington, Perito & Dubuc 4107 | 1988-03-21 | Washington, Perito & Dubuc | Beijing | ||||
8330 | 8330 | 1980-06-30 | China National Textiles Import & Export Corporation | 1980-05-09 | CHINA | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | Beijing | ||||
8561 | 8561 | 1998-06-30 | Air China International Corporation, Ltd. d/b/a Air China | 1991-10-23 | CHINA | Graham & James, L.L.P. 3275 | 1981-09-23 | Graham & James, L.L.P. | Beijing | ||||
10130 | 10130 | 1980-08-04 | China National Textiles Import & Export Corporation | 1980-05-05 | CHINA | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | Beijing | ||||
11385 | 11385 | 1997-09-05 | China National Textiles Import/Export Corporation (CHINATEX) | 1996-03-27 | CHINA | Graham & James, L.L.P. 3275 | 1981-09-23 | Graham & James, L.L.P. | Beijing | ||||
11405 | 11405 | 1993-09-07 | China National Tourism Administration | 1991-11-19 | CHINA | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Beijing | ||||
12073 | 12073 | 1996-09-30 | People's Daily Overseas Edition | 1992-03-20 | CHINA | KMC Trading 4639 | 1992-03-20 | KMC Trading | Beijing | ||||
12075 | 12075 | 1996-09-30 | Chinese Science News Overseas Edition | 1993-08-24 | CHINA | KMC Trading 4639 | 1992-03-20 | KMC Trading | Beijing | ||||
12082 | 12082 | 1996-09-30 | Outlook Weekly | 1994-10-17 | CHINA | KMC Trading 4639 | 1992-03-20 | KMC Trading | Beijing | ||||
12402 | 12402 | 2007-10-01 | China Ocean Shipping Company | 1985-02-12 | CHINA | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | Beijing | ||||
12643 | 12643 | 1981-10-13 | Beijing Economic Development Corporation | 1981-04-13 | CHINA | Chinamerica Corporation 3224 | 1981-04-13 | Chinamerica Corporation | Beijing | ||||
12857 | 12857 | 1994-10-19 | Liao Wang Weekly, Ltd. | 1984-09-21 | CHINA | Synergy Publishing, Inc. 3615 | 1984-09-21 | Synergy Publishing, Inc. | Beijing | ||||
13765 | 13765 | 1995-11-06 | China National Textiles Import/Export Corporation (CHINATEX) | 1985-02-01 | CHINA | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | 1981-02-18 | Mudge, Rose, Guthrie, Alexander & Ferdon | Beijing | ||||
14125 | 14125 | 1993-11-21 | General Administration of Civil Aviation of China | 1980-05-21 | CHINA | Haight, Gardner, Poor & Havens 3108 | 1980-05-21 | Haight, Gardner, Poor & Havens | Beijing | ||||
14171 | 14171 | 1994-11-22 | China Great Wall Industry Corporation | 1993-09-15 | CHINA | Cole Corette & Abrutyn, P.C. 2968 | 1978-10-18 | Cole Corette & Abrutyn, P.C. | Beijing | ||||
14424 | 14424 | 1990-11-30 | New China Pictures Company | 1980-04-18 | CHINA | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | Beijing | ||||
15832 | 15832 | 1980-12-31 | China Counsel for the Promotion of International Trade (CCPIT) | 1979-11-30 | CHINA | China Exhibition Corporation 3071 | 1979-11-30 | China Exhibition Corporation | Beijing | ||||
16006 | 16006 | 1987-12-31 | General Administration of Civil Aviation of China (CAAC) | 1987-04-03 | CHINA | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey 2799 | 1977-06-29 | Finley Kumble Wagner Heine Underberg Manley Myerson & Casey | Beijing | ||||
16031 | 16031 | 1987-12-31 | Yan Shan Science & Technology Corporation | 1981-04-15 | CHINA | A.I.T. Corporation 3228 | 1981-04-15 | A.I.T. Corporation | Beijing | ||||
16473 | 16473 | 1999-12-31 | Science Times - Overseas Edition (formerly Chinese Science News Overseas Edition) | 1997-06-05 | CHINA | Hai Tian Development U.S.A., Inc. 5143 | 1996-12-03 | Hai Tian Development U.S.A., Inc. | Beijing |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );