FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40,054 rows where Document_Type = "Short-Form"
This data as json, CSV (advanced)
Registrant_Name >30
- HILL & KNOWLTON, INC. 1,522
- Daniel J. Edelman, Inc. 895
- ARNOLD & PORTER 448
- Hill & Knowlton, Inc. 418
- BURSON-MARSTELLER 389
- SQUIRE, SANDERS & DEMPSEY 341
- Ogilvy Public Relations Worldwide 332
- WHITE & CASE 318
- Amtorg Trading Corporation 314
- JETRO, New York 286
- RUDER & FINN, INC. 285
- DANIEL J. EDELMAN, INC. 281
- Mercury Public Affairs, LLC 271
- AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 269
- NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. 259
- MMGY Global, LLC 241
- Commonwealth of Dominica Maritime Registry, Inc. 237
- Fleishman-Hillard, Inc. 237
- DLA Piper US LLP 231
- QUEBEC GOVERNMENT HOUSE 228
- Akin, Gump, Strauss, Hauer & Feld, LLP 226
- JETRO, NEW YORK 218
- Ketchum Inc. NY 217
- FLEISHMAN-HILLARD, INC. 203
- Hill and Knowlton Strategies, LLC 203
- Qorvis Communications, LLC 199
- L.A. MOTLEY & COMPANY 190
- Podesta Group, Inc. 190
- Patton Boggs, LLP 185
- NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) 182
- …
Foreign_Principal_Name 1
- - 40,023
Foreign_Principal_Country 1
- - 40,023
Document_Type 1
- Short-Form · 40,023 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
115 | 115 | 1966-01-01 | JETRO, NEW YORK | JETRO, New York 1643 | Short-Form | AKIO KURODA | Available-FARA-Public-Office | ||
116 | 116 | 1966-01-01 | OFFICE OF TIBET | Office of Tibet 1699 | Short-Form | PHINTSO THONDEN | Available-FARA-Public-Office | ||
118 | 118 | 1967-01-01 | BARBADOS INVESTMENT & DEVELOPMENT CORP. BARBADOS TOURISM | Barbados Investment & Development Corp. Barbados Tourism 1995 | Short-Form | BRANDFORD MAYHEW TAITT | Available-FARA-Public-Office | ||
123 | 123 | 1967-01-01 | JAMAICA TOURIST BOARD, NEW YORK | Jamaica Tourist Board, New York 1445 | Short-Form | CHARLENE ADAIR ROSS | Available-FARA-Public-Office | ||
124 | 124 | 1967-01-01 | JETRO, NEW YORK | JETRO, New York 1643 | Short-Form | SATOSHI YUKAWA | Available-FARA-Public-Office | ||
126 | 126 | 1967-01-01 | OFFICE OF TIBET | Office of Tibet 1699 | Short-Form | PAMELA BARNARD | Available-FARA-Public-Office | ||
136 | 136 | 1968-01-01 | INTOURIST, RUSSIAN JOINT STOCK COMPANY FOR FOREIGN TRAVEL, | Intourist U.S.A., Inc. 1240 | Short-Form | OLEG IOSIPHOVICH LYSKIN | Available-FARA-Public-Office | ||
146 | 146 | 1969-01-01 | CEDOK CZECHOSLOVAK TRAVEL BUREAU | CEDOK Czechoslovak Travel Bureau 1848 | Short-Form | JAN K. KOLARIK | Available-FARA-Public-Office | ||
155 | 155 | 1970-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | ANNE WELLS BRANSCOMB | Available-FARA-Public-Office | ||
156 | 156 | 1970-01-01 | BERMUDA DEPARTMENT OF TOURISM | Bermuda Tourism Authority 430 | Short-Form | WENDELL BRUCE BEEM | Available-FARA-Public-Office | ||
160 | 160 | 1970-01-01 | HONG KONG TOURIST ASSOCIATION | Hong Kong Tourism Board 2110 | Short-Form | TERENCE J. FU | Available-FARA-Public-Office | ||
163 | 163 | 1970-01-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | ANNA T. STIER | Available-FARA-Public-Office | ||
164 | 164 | 1970-01-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | ERIC FOOK-CHUEN LI | Available-FARA-Public-Office | ||
165 | 165 | 1970-01-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | JIMMY CHUNG MAY LOH | Available-FARA-Public-Office | ||
166 | 166 | 1970-01-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | PETER HUNG-SUM LEUNG | Available-FARA-Public-Office | ||
167 | 167 | 1970-01-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | ROBERT STRONG SUN | Available-FARA-Public-Office | ||
170 | 170 | 1970-01-01 | INTOURIST, RUSSIAN JOINT STOCK COMPANY FOR FOREIGN TRAVEL, | Intourist U.S.A., Inc. 1240 | Short-Form | VALLERIY DMITRIEVICH UVAROV | Available-FARA-Public-Office | ||
171 | 171 | 1970-01-01 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Short-Form | MASUJI NOMOTO | Available-FARA-Public-Office | ||
174 | 174 | 1971-01-01 | BRITISH COLUMBIA HOUSE | British Columbia House 1782 | Short-Form | STEVE C. TURBIS | Available-FARA-Public-Office | ||
178 | 178 | 1971-01-01 | GOVERNMENT OF THE PROVINCE OF ALBERTA | Government of the Province of Alberta 1720 | Short-Form | DALTON D. TAMNEY | Available-FARA-Public-Office | ||
179 | 179 | 1971-01-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | NISBET KWONG | Available-FARA-Public-Office | ||
180 | 180 | 1971-01-01 | HONG KONG TRADE DEVELOPMENT COUNCIL, INC. | Hong Kong Trade Development Council, Inc. 2181 | Short-Form | WING-BOO NG | Available-FARA-Public-Office | ||
186 | 186 | 1971-01-01 | ITALIAN GOVERNMENT TOURIST BOARD, NEW YORK | Italian Government Tourist Board, New York 568 | Short-Form | EMILIO TOMMASI | Available-FARA-Public-Office | ||
192 | 192 | 1971-01-01 | SOUTH AFRICA FOUNDATION | South Africa Foundation 2111 | Short-Form | MICHAEL REID CHRISTIE | Available-FARA-Public-Office | ||
193 | 193 | 1971-01-01 | SVERIGES TELEVISION AB | Sveriges Television AB (Swedish Broadcasting Corporation) 1676 | Short-Form | BRITT SIMONSON | Available-FARA-Public-Office | ||
194 | 194 | 1971-01-01 | TURKISH CONSULATE OFFICE OF CULTURE & INFORMATION ATTACHE | Turkish Consulate Office of Culture & Information Attache 498 | Short-Form | ADNAN OZAKTAS | Available-FARA-Public-Office | ||
198 | 198 | 1972-01-01 | BAHAMAS TOURIST OFFICE | Bahamas Tourist Office 2310 | Short-Form | DAVID H. SHAFFER | Available-FARA-Public-Office | ||
206 | 206 | 1972-01-01 | GOVERNMENT OF ONTARIO, CANADA | Government of Ontario, Canada 2087 | Short-Form | BOWCHER THEODORE SENHOUSE CLARKE | Available-FARA-Public-Office | ||
213 | 213 | 1972-01-01 | KOREA TRADE PROMOTION CENTER, NEW YORK | KOTRA 1619 | Short-Form | CLAIRE E. BELASCO | Available-FARA-Public-Office | ||
216 | 216 | 1972-01-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | A.E. SHRIMPTON | Available-FARA-Public-Office | ||
217 | 217 | 1972-01-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | COLIN H. READ | Available-FARA-Public-Office | ||
218 | 218 | 1972-01-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | J.H. DAVIS | Available-FARA-Public-Office | ||
220 | 220 | 1972-01-01 | RUDER & FINN, INC. | Ruder Finn, Inc. 1481 | Short-Form | SUZANNE PEDERSEN | Available-FARA-Public-Office | ||
224 | 224 | 1972-01-01 | TURKISH CONSULATE OFFICE OF CULTURE & INFORMATION ATTACHE | Turkish Consulate Office of Culture & Information Attache 498 | Short-Form | HANDE SURMELIOGLU | Available-FARA-Public-Office | ||
244 | 244 | 1973-01-01 | NATIONAL FILM BOARD OF CANADA | National Film Board of Canada 437 | Short-Form | THOMAS LOW JOHNSTON | Available-FARA-Public-Office | ||
251 | 251 | 1974-01-01 | AUSTRALIAN BROADCASTING CORPORATION | Australian Broadcasting Corporation 394 | Short-Form | WARWICK BLOOD | Available-FARA-Public-Office | ||
252 | 252 | 1974-01-01 | AUSTRALIAN TOURIST COMMISSION | Tourism Australia 1032 | Short-Form | CLIFFORD DODD | Available-FARA-Public-Office | ||
253 | 253 | 1974-01-01 | AUSTRIAN TRADE COMMISSIONER IN THE U.S., CHICAGO | Austrian Trade Commissioner in the U.S., Chicago 874 | Short-Form | WILHELM A. BRAUNER | Available-FARA-Public-Office | ||
255 | 255 | 1974-01-01 | BERRY, MAX N. | Berry, Max N. 2216 | Short-Form | FRED GIPSON | Available-FARA-Public-Office | ||
259 | 259 | 1974-01-01 | DANISH TOURIST BOARD | VisitDenmark 634 | Short-Form | AXEL DESSAU | Available-FARA-Public-Office | ||
278 | 278 | 1974-01-01 | NEW ZEALAND CENTRAL RESERVATIONS OFFICE | New Zealand Central Reservations Office 672 | Short-Form | FRANK EDWARD KERR | Available-FARA-Public-Office | ||
280 | 280 | 1974-01-01 | PRATHER, SEEGER, DOOLITTLE & FARMER | Prather, Seeger, Doolittle & Farmer 1815 | Short-Form | THOMAS L. FARMER | Available-FARA-Public-Office | ||
281 | 281 | 1974-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | JOHN W. SHARP | Available-FARA-Public-Office | ||
285 | 285 | 1974-01-01 | SHANNON FREE AIRPORT DEVELOPMENT COMPANY, LTD. | Shannon Free Airport Development Company, Ltd. 2467 | Short-Form | JOHN KEVIN IMBUSCH | Available-FARA-Public-Office | ||
286 | 286 | 1974-01-01 | SHANNON FREE AIRPORT DEVELOPMENT COMPANY, LTD. | Shannon Free Airport Development Company, Ltd. 2467 | Short-Form | JOSEPH POWER | Available-FARA-Public-Office | ||
287 | 287 | 1974-01-01 | SHANNON FREE AIRPORT DEVELOPMENT COMPANY, LTD. | Shannon Free Airport Development Company, Ltd. 2467 | Short-Form | MARY S. FITZGIBBON | Available-FARA-Public-Office | ||
288 | 288 | 1974-01-01 | SHANNON FREE AIRPORT DEVELOPMENT COMPANY, LTD. | Shannon Free Airport Development Company, Ltd. 2467 | Short-Form | NOEL MACGOWAN | Available-FARA-Public-Office | ||
292 | 292 | 1974-01-01 | TEA COUNCIL OF THE U.S.A., INC. | Tea Council of the U.S.A., Inc. 1853 | Short-Form | WILLIAM F. TREADWELL | Available-FARA-Public-Office | ||
296 | 296 | 1975-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | ANDREA LANGE | Available-FARA-Public-Office | ||
297 | 297 | 1975-01-01 | BARBADOS INVESTMENT & DEVELOPMENT CORP. BARBADOS TOURISM | Barbados Investment & Development Corp. Barbados Tourism 1995 | Short-Form | HALLAM G.S. TAYLOR | Available-FARA-Public-Office | ||
298 | 298 | 1975-01-01 | CARIBBEAN TOURISM ORGANIZATION | Caribbean Tourism Organization, USA Inc. 991 | Short-Form | JAMES PEPPERDINE | Available-FARA-Public-Office | ||
307 | 307 | 1975-01-01 | GOVERNMENT OF INDIA TOURIST OFFICE, LOS ANGELES | Government of India Tourist Office, Los Angeles 2407 | Short-Form | Y. KOHLI | Available-FARA-Public-Office | ||
311 | 311 | 1975-01-01 | INTERNATIONAL PUBLIC RELATIONS COMPANY, LTD. | International Public Relations Company, Ltd. 1967 | Short-Form | KURT KRON | Available-FARA-Public-Office | ||
319 | 319 | 1975-01-01 | NETHERLANDS BOARD OF TOURISM | Netherlands Board of Tourism and Conventions (NBTC) 619 | Short-Form | UBBO WILKENS | Available-FARA-Public-Office | ||
321 | 321 | 1975-01-01 | PEKAO TRADING CORPORATION | Pekao Trading Corporation 817 | Short-Form | TADEUSZ KROPINIEWICZ | Available-FARA-Public-Office | ||
326 | 326 | 1975-01-01 | TEA COUNCIL OF THE U.S.A., INC. | Tea Council of the U.S.A., Inc. 1853 | Short-Form | ROBERT H. WEISS | Available-FARA-Public-Office | ||
335 | 335 | 1976-01-01 | EHRIG & ASSOCIATES, INC. | Ehrig & Associates, Inc. 2603 | Short-Form | WILFRIED A. PASCOE | Available-FARA-Public-Office | ||
338 | 338 | 1976-01-01 | GOVERNMENT OF INDIA TOURIST OFFICE, LOS ANGELES | Government of India Tourist Office, Los Angeles 2407 | Short-Form | K. S. SANDANAM | Available-FARA-Public-Office | ||
340 | 340 | 1976-01-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | J. WILLIAM FULBRIGHT | Available-FARA-Public-Office | ||
353 | 353 | 1976-01-01 | KOREA TRADE PROMOTION CENTER, NEW YORK | KOTRA 1619 | Short-Form | DUK MO KOO | Available-FARA-Public-Office | ||
358 | 358 | 1976-01-01 | TOURISM AUTHORITY OF THAILAND, NEW YORK | Tourism Authority of Thailand, New York 1897 | Short-Form | YIBBHAN PHROMYOTHI | Available-FARA-Public-Office | ||
362 | 362 | 1976-01-01 | U.S. BRANCH PLAID CYMRU | U.S. Branch Plaid Cymru 2653 | Short-Form | D. GLYNNE OWEN | Available-FARA-Public-Office | ||
366 | 366 | 1977-01-01 | AUSTRALIAN TOURIST COMMISSION | Tourism Australia 1032 | Short-Form | ROBERT M. WOOD | Available-FARA-Public-Office | ||
367 | 367 | 1977-01-01 | CAYMAN ISLANDS DEPARTMENT OF TOURISM | Cayman Islands Department of Tourism 2500 | Short-Form | DOROTHY O'BRIEN | Available-FARA-Public-Office | ||
379 | 379 | 1977-01-01 | IRISH TOURIST BOARD | Tourism Ireland 536 | Short-Form | DONAL F. MCSULLIVAN | Available-FARA-Public-Office | ||
391 | 391 | 1977-01-01 | NORTH AMERICAN ASEAN PROMOTIONAL CHAPTER | ASEAN Promotional Chapter for Tourism - North America 2744 | Short-Form | ESA JAFFAR | Available-FARA-Public-Office | ||
400 | 400 | 1977-01-01 | TURKISH CONSULATE OFFICE OF CULTURE & INFORMATION ATTACHE | Turkish Consulate Office of Culture & Information Attache 498 | Short-Form | IBRAHIM SIPIT | Available-FARA-Public-Office | ||
402 | 402 | 1978-01-01 | NEW ZEALAND MEAT PRODUCERS' BOARD | Beef + Lamb New Zealand, Ltd. 2526 | Short-Form | BRIAN LEWIS ARTHUR JEFFRIES | Available-FARA-Public-Office | ||
404 | 404 | 1978-01-01 | ANDERSON & PENDLETON, C.A. | Anderson & Pendleton, C.A. 2696 | Short-Form | JEROME F. DONOVAN | Available-FARA-Public-Office | ||
405 | 405 | 1978-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | THOMAS B. WILNER | Available-FARA-Public-Office | ||
406 | 406 | 1978-01-01 | AUSTRALIAN TOURIST COMMISSION | Tourism Australia 1032 | Short-Form | IAN L. KENNEDY | Available-FARA-Public-Office | ||
417 | 417 | 1978-01-01 | INTOURIST, RUSSIAN JOINT STOCK COMPANY FOR FOREIGN TRAVEL, | Intourist U.S.A., Inc. 1240 | Short-Form | VICOR N. TOURKINE | Available-FARA-Public-Office | ||
424 | 424 | 1978-01-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SUGURU MURAKAMI | Available-FARA-Public-Office | ||
425 | 425 | 1978-01-01 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Short-Form | KAZUMI SUZUKI | Available-FARA-Public-Office | ||
426 | 426 | 1978-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KOTARO YAMADA | Available-FARA-Public-Office | ||
429 | 429 | 1978-01-01 | KOREA INTERNATL TRADE ASSN, INC. | Korea International Trade Association, Inc. 2686 | Short-Form | SUNG DO HONG | Available-FARA-Public-Office | ||
433 | 433 | 1978-01-01 | MALAYSIAN INDUSTRIAL DEVELOPMENT AUTHORITY | Malaysian Industrial Development Authority 2331 | Short-Form | YAAKUB ARSHAD | Available-FARA-Public-Office | ||
436 | 436 | 1978-01-01 | NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | Short-Form | NIKOLAI NIKOLAEVICH KAREV | Available-FARA-Public-Office | ||
450 | 450 | 1979-01-01 | ARAB INFORMATION CENTER | Arab Information Center 876 | Short-Form | A. HADI TORON | Available-FARA-Public-Office | ||
451 | 451 | 1979-01-01 | BAHAMAS TOURIST OFFICE | Bahamas Tourist Office 2310 | Short-Form | VAN JAMES ISSACS | Available-FARA-Public-Office | ||
456 | 456 | 1979-01-01 | CLEARY, GOTTLIEB, STEEN & HAMILTON | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | Short-Form | THOMAS J. KIERNAN | Available-FARA-Public-Office | ||
461 | 461 | 1979-01-01 | HANNAFORD COMPANY, INC. | Hannaford Company, Inc. 2850 | Short-Form | JAMES W. ROBINSON | Available-FARA-Public-Office | ||
463 | 463 | 1979-01-01 | HENRY DAVIS CORPORATION | Henry Davis Corporation 2952 | Short-Form | FRED SKELTON | Available-FARA-Public-Office | ||
464 | 464 | 1979-01-01 | HONG KONG TOURIST ASSOCIATION | Hong Kong Tourism Board 2110 | Short-Form | VINCE DI MARCO | Available-FARA-Public-Office | ||
469 | 469 | 1979-01-01 | IDA IRELAND | IDA Ireland 1770 | Short-Form | BERNARD USSHER | Available-FARA-Public-Office | ||
474 | 474 | 1979-01-01 | JAMAICA TOURIST BOARD, NEW YORK | Jamaica Tourist Board, New York 1445 | Short-Form | DOLORES ELAINE STEPHENSON | Available-FARA-Public-Office | ||
479 | 479 | 1979-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | FUGIE ROSE KAJIMURA | Available-FARA-Public-Office | ||
482 | 482 | 1979-01-01 | KOREA TRADE PROMOTION CENTER, NEW YORK | KOTRA 1619 | Short-Form | JOONDU JOHONG | Available-FARA-Public-Office | ||
486 | 486 | 1979-01-01 | MEXICAN GOVERNMENT TOURIST OFFICE, NEW YORK | Mexican Tourism Board 1754 | Short-Form | JORGE V. GONZALEZ | Available-FARA-Public-Office | ||
489 | 489 | 1979-01-01 | NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | Short-Form | PAVEL A. FISUNOV | Available-FARA-Public-Office | ||
496 | 496 | 1979-01-01 | OFFICE OF TIBET | Office of Tibet 1699 | Short-Form | IRVING MANDELL | Available-FARA-Public-Office | ||
497 | 497 | 1979-01-01 | PEKAO TRADING CORPORATION | Pekao Trading Corporation 817 | Short-Form | JOSEF KIRSTEIN | Available-FARA-Public-Office | ||
500 | 500 | 1979-01-01 | PIERSON, SEMMES & BEMIS | Pierson, Semmes & Bemis 2988 | Short-Form | DAVID H. SEMMES | Available-FARA-Public-Office | ||
501 | 501 | 1979-01-01 | PIERSON, SEMMES & BEMIS | Pierson, Semmes & Bemis 2988 | Short-Form | WARREN E. OLSEN | Available-FARA-Public-Office | ||
502 | 502 | 1979-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | PHILLIPPE CINQ-MARS | Available-FARA-Public-Office | ||
503 | 503 | 1979-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | ROBERT G. JONES | Available-FARA-Public-Office | ||
504 | 504 | 1979-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | THEODORE H. JOHN | Available-FARA-Public-Office | ||
505 | 505 | 1979-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | YVES LABONTE | Available-FARA-Public-Office | ||
509 | 509 | 1979-01-01 | TEA COUNCIL OF THE U.S.A., INC. | Tea Council of the U.S.A., Inc. 1853 | Short-Form | DONALD A. WIEDERECHT | Available-FARA-Public-Office | ||
511 | 511 | 1979-01-01 | TURKISH CONSULATE OFFICE OF CULTURE & INFORMATION ATTACHE | Turkish Consulate Office of Culture & Information Attache 498 | Short-Form | HASAN HUSEYIN CERCI | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );