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" and Foreign_Principal_Country = ""
This data as json, CSV (advanced)
Registrant_Name >30
- HILL & KNOWLTON, INC. 1,459
- Daniel J. Edelman, Inc. 833
- ARNOLD & PORTER 382
- BURSON-MARSTELLER 351
- Hill & Knowlton, Inc. 327
- Ogilvy Public Relations Worldwide 315
- WHITE & CASE 293
- Amtorg Trading Corporation 281
- JETRO, New York 276
- RUDER & FINN, INC. 274
- DANIEL J. EDELMAN, INC. 266
- AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 253
- SQUIRE, SANDERS & DEMPSEY 250
- NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. 238
- Commonwealth of Dominica Maritime Registry, Inc. 236
- Fleishman-Hillard, Inc. 232
- Mercury Public Affairs, LLC 230
- DLA Piper US LLP 224
- MMGY Global, LLC 210
- JETRO, NEW YORK 206
- Ketchum Inc. NY 206
- Akin, Gump, Strauss, Hauer & Feld, LLP 203
- FLEISHMAN-HILLARD, INC. 193
- Qorvis Communications, LLC 192
- QUEBEC GOVERNMENT HOUSE 189
- Hill and Knowlton Strategies, LLC 187
- NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) 179
- L.A. MOTLEY & COMPANY 178
- Podesta Group, Inc. 173
- Patton Boggs, LLP 171
- …
Foreign_Principal_Name 1
- - 37,156
Foreign_Principal_Country 1
- - · 37,156 ✖
Document_Type 1
- Short-Form · 37,156 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
9289 | 9289 | 2020-01-30 | CMGRP, Inc. | IPG DXTRA, Inc 3911 | Short-Form | Boonshoft, Emma | https://efile.fara.gov/docs/3911-Short-Form-20200130-144.pdf | ||
9290 | 9290 | 2020-01-30 | CMGRP, Inc. | IPG DXTRA, Inc 3911 | Short-Form | Foxman, Elizabeth | https://efile.fara.gov/docs/3911-Short-Form-20200130-148.pdf | ||
9291 | 9291 | 2020-01-30 | CMGRP, Inc. | IPG DXTRA, Inc 3911 | Short-Form | Hobbs, Lemondria | https://efile.fara.gov/docs/3911-Short-Form-20200130-146.pdf | ||
9292 | 9292 | 2020-01-30 | CMGRP, Inc. | IPG DXTRA, Inc 3911 | Short-Form | McKenna, Kelly | https://efile.fara.gov/docs/3911-Short-Form-20200130-150.pdf | ||
9306 | 9306 | 2020-01-30 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Cunillera, Cristina De Jesus | https://efile.fara.gov/docs/6621-Short-Form-20200130-72.pdf | ||
9307 | 9307 | 2020-01-30 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Harvie, Frederick | https://efile.fara.gov/docs/6621-Short-Form-20200130-74.pdf | ||
9308 | 9308 | 2020-01-30 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Llanos, Idalma | https://efile.fara.gov/docs/6621-Short-Form-20200130-68.pdf | ||
9309 | 9309 | 2020-01-30 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Pagliery, Patricia | https://efile.fara.gov/docs/6621-Short-Form-20200130-76.pdf | ||
9310 | 9310 | 2020-01-30 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Reich, Allegra | https://efile.fara.gov/docs/6621-Short-Form-20200130-66.pdf | ||
9311 | 9311 | 2020-01-30 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Reich, Allegra | https://efile.fara.gov/docs/6621-Short-Form-20200130-70.pdf | ||
9312 | 9312 | 2020-01-30 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Sepulveda, Mayerly | https://efile.fara.gov/docs/6621-Short-Form-20200130-62.pdf | ||
9313 | 9313 | 2020-01-30 | Media Planning International Corporation | Media Planning International Corporation 6621 | Short-Form | Sepulveda, Mayerly | https://efile.fara.gov/docs/6621-Short-Form-20200130-64.pdf | ||
9319 | 9319 | 2020-01-30 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Short-Form | Tomlin, John | https://efile.fara.gov/docs/6170-Short-Form-20200130-566.pdf | ||
9334 | 9334 | 2021-01-30 | Arnold & Porter Kaye Scholer, LLP | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | O'Neill, Kevin | https://efile.fara.gov/docs/1750-Short-Form-20210130-128.pdf | ||
9335 | 9335 | 2021-01-30 | Arnold & Porter Kaye Scholer, LLP | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | Witten, Samuel | https://efile.fara.gov/docs/1750-Short-Form-20210130-130.pdf | ||
9342 | 9342 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Adolph, Michael Charles | https://efile.fara.gov/docs/5801-Short-Form-20210130-282.pdf | ||
9343 | 9343 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Belding, Arman | https://efile.fara.gov/docs/5801-Short-Form-20210130-274.pdf | ||
9344 | 9344 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Bernard, Mikael | https://efile.fara.gov/docs/5801-Short-Form-20210130-284.pdf | ||
9345 | 9345 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Bueno, Alexander de la Torre | https://efile.fara.gov/docs/5801-Short-Form-20210130-276.pdf | ||
9346 | 9346 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Franklin, James Nikolai | https://efile.fara.gov/docs/5801-Short-Form-20210130-280.pdf | ||
9347 | 9347 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Graziano, Devon | https://efile.fara.gov/docs/5801-Short-Form-20210130-278.pdf | ||
9348 | 9348 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Heibeck, Olivia | https://efile.fara.gov/docs/5801-Short-Form-20210130-288.pdf | ||
9349 | 9349 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Sanchez, Nicole | https://efile.fara.gov/docs/5801-Short-Form-20210130-286.pdf | ||
9358 | 9358 | 2021-01-30 | Marsh Law Firm PLLC | Marsh Law Firm PLLC 6920 | Short-Form | Mabie, Margaret Elizabeth | https://efile.fara.gov/docs/6920-Short-Form-20210130-2.pdf | ||
9359 | 9359 | 2021-01-30 | Marsh Law Firm PLLC | Marsh Law Firm PLLC 6920 | Short-Form | Marsh, James Ryan | https://efile.fara.gov/docs/6920-Short-Form-20210130-4.pdf | ||
9370 | 9370 | 2022-01-30 | Ruder Finn, Inc. | Ruder Finn, Inc. 6840 | Short-Form | Caamano, Antonia | https://efile.fara.gov/docs/6840-Short-Form-20220130-86.pdf | ||
9393 | 9393 | 2023-01-30 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Short-Form | Chitwood, Matthew McKenzie | https://efile.fara.gov/docs/3634-Short-Form-20230130-1241.pdf | ||
9394 | 9394 | 2023-01-30 | Daniel J. Edelman, Inc. | Daniel J. Edelman, Inc. 3634 | Short-Form | Garsko, Summer | https://efile.fara.gov/docs/3634-Short-Form-20230130-1243.pdf | ||
9401 | 9401 | 2023-01-30 | Isaiah King | Isaiah King 7224 | Short-Form | Lapetina, Christopher | https://efile.fara.gov/docs/7224-Short-Form-20230130-2.pdf | ||
9410 | 9410 | 2023-01-30 | Media Theory LLC | Media Theory LLC 7223 | Short-Form | Kimer, James | https://efile.fara.gov/docs/7223-Short-Form-20230130-2.pdf | ||
9417 | 9417 | 1957-01-31 | Arab Information Center | Arab Information Center 876 | Short-Form | Beynon,Joyce Jessie | Available-FARA-Public-Office | ||
9418 | 9418 | 1971-01-31 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Short-Form | KAZUYUKI WAKASONE | Available-FARA-Public-Office | ||
9419 | 9419 | 1971-01-31 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Short-Form | KOOICHI UEDA | Available-FARA-Public-Office | ||
9420 | 9420 | 1971-01-31 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Short-Form | SOBEE IKEDA | Available-FARA-Public-Office | ||
9422 | 9422 | 1971-01-31 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | FRANK M. WALKER | Available-FARA-Public-Office | ||
9423 | 9423 | 1971-01-31 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | HARVEY V. DELAPENA, JR. | Available-FARA-Public-Office | ||
9424 | 9424 | 1971-01-31 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | NEIL MACCORMICK | Available-FARA-Public-Office | ||
9425 | 9425 | 1971-01-31 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | NELSON L. MCELHATTEN | Available-FARA-Public-Office | ||
9426 | 9426 | 1971-01-31 | RUDER & FINN, INC. | Ruder Finn, Inc. 1481 | Short-Form | ADELE SHAINBLUM | Available-FARA-Public-Office | ||
9427 | 9427 | 1971-01-31 | RUDER & FINN, INC. | Ruder Finn, Inc. 1481 | Short-Form | DEIRDRE MARYNISSEN | Available-FARA-Public-Office | ||
9428 | 9428 | 1971-01-31 | RUDER & FINN, INC. | Ruder Finn, Inc. 1481 | Short-Form | JOHN LEON DUPREE | Available-FARA-Public-Office | ||
9429 | 9429 | 1971-01-31 | RUDER & FINN, INC. | Ruder Finn, Inc. 1481 | Short-Form | WILLIAM F. WELCH | Available-FARA-Public-Office | ||
9431 | 9431 | 1981-01-31 | Modern Education Services, Inc. | Modern Education Services, Inc. 1803 | Short-Form | Daly ,Harry John | Available-FARA-Public-Office | ||
9435 | 9435 | 1986-01-31 | GLOBAL U.S.A., INC. | Global U.S.A., Inc. 3489 | Short-Form | BOHDAN DENYSYK | Available-FARA-Public-Office | ||
9437 | 9437 | 1986-01-31 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | FRANK MANKIEWICZ | Available-FARA-Public-Office | ||
9438 | 9438 | 1986-01-31 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | LAURI J. FITZ | Available-FARA-Public-Office | ||
9439 | 9439 | 1986-01-31 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | STEPHEN M. JOHNSON | Available-FARA-Public-Office | ||
9442 | 9442 | 1986-01-31 | JONES, DAY, REAVIS & POGUE | Jones Day 3427 | Short-Form | BENJAMIN P. FISHBURNE, III | Available-FARA-Public-Office | ||
9443 | 9443 | 1986-01-31 | JONES, DAY, REAVIS & POGUE | Jones Day 3427 | Short-Form | FLORENCE R. KEENAN | Available-FARA-Public-Office | ||
9444 | 9444 | 1986-01-31 | JONES, DAY, REAVIS & POGUE | Jones Day 3427 | Short-Form | MARC C. GINSBERG | Available-FARA-Public-Office | ||
9445 | 9445 | 1986-01-31 | JONES, DAY, REAVIS & POGUE | Jones Day 3427 | Short-Form | WALTER STERLING SURREY | Available-FARA-Public-Office | ||
9446 | 9446 | 1989-01-31 | Amtorg Trading Corporation | Amtorg Trading Corporation 596 | Short-Form | Mashkin ,Yuri M. | Available-FARA-Public-Office | ||
9448 | 9448 | 1989-01-31 | L.A. MOTLEY & COMPANY | L.A. Motley & Company 3723 | Short-Form | CLAUD L. GINGRICH | Available-FARA-Public-Office | ||
9449 | 9449 | 1989-01-31 | L.A. MOTLEY & COMPANY | L.A. Motley & Company 3723 | Short-Form | HARRY KOPP | Available-FARA-Public-Office | ||
9450 | 9450 | 1989-01-31 | L.A. MOTLEY & COMPANY | L.A. Motley & Company 3723 | Short-Form | LANGHORNE A. MOTLEY | Available-FARA-Public-Office | ||
9451 | 9451 | 1990-01-31 | BOZELL SAWYER MILLER GROUP | IPG DXTRA, Inc 3911 | Short-Form | LAMONT SILVES | Available-FARA-Public-Office | ||
9452 | 9452 | 1990-01-31 | BOZELL SAWYER MILLER GROUP | IPG DXTRA, Inc 3911 | Short-Form | MARY E. MORRISON | Available-FARA-Public-Office | ||
9454 | 9454 | 1990-01-31 | MCCANN DIRECT, INC. | McCann Direct, Inc. 3922 | Short-Form | ALYSON KOKIN GRACI | Available-FARA-Public-Office | ||
9455 | 9455 | 1990-01-31 | MCCANN DIRECT, INC. | McCann Direct, Inc. 3922 | Short-Form | ALYSON KOKIN GRACI | Available-FARA-Public-Office | ||
9456 | 9456 | 1990-01-31 | MCCANN DIRECT, INC. | McCann Direct, Inc. 3922 | Short-Form | LYNWOOD I. POWELL, JR. | Available-FARA-Public-Office | ||
9457 | 9457 | 1990-01-31 | MCCANN DIRECT, INC. | McCann Direct, Inc. 3922 | Short-Form | LYNWOOD I. POWELL, JR. | Available-FARA-Public-Office | ||
9458 | 9458 | 1990-01-31 | MCCANN DIRECT, INC. | McCann Direct, Inc. 3922 | Short-Form | ROBIN ANDERSON | Available-FARA-Public-Office | ||
9459 | 9459 | 1990-01-31 | MCCANN DIRECT, INC. | McCann Direct, Inc. 3922 | Short-Form | ROBIN ANDERSON | Available-FARA-Public-Office | ||
9460 | 9460 | 1990-01-31 | MCCANN DIRECT, INC. | McCann Direct, Inc. 3922 | Short-Form | VINCENT J. WILSON | Available-FARA-Public-Office | ||
9462 | 9462 | 1990-01-31 | SHAW, PITTMAN, POTTS & TROWBRIDGE | Shaw, Pittman, Potts & Trowbridge 2580 | Short-Form | JAMES H. BURNLEY, IV | Available-FARA-Public-Office | ||
9463 | 9463 | 1990-01-31 | SHAW, PITTMAN, POTTS & TROWBRIDGE | Shaw, Pittman, Potts & Trowbridge 2580 | Short-Form | LAWRENCE W. BIERLEIN | Available-FARA-Public-Office | ||
9468 | 9468 | 1990-01-31 | WORLD TRADE LINK | World Trade Link 4317 | Short-Form | JEROME LINK | Available-FARA-Public-Office | ||
9472 | 9472 | 1991-01-31 | GCI Group Inc. | GCI Group, Inc. 3856 | Short-Form | Davison, Jaymi | Available-FARA-Public-Office | ||
9473 | 9473 | 1991-01-31 | GCI Group Inc. | GCI Group, Inc. 3856 | Short-Form | Gorden, Nicole | Available-FARA-Public-Office | ||
9474 | 9474 | 1991-01-31 | GCI Group Inc. | GCI Group, Inc. 3856 | Short-Form | Mejia-Cabral, Lydia | Available-FARA-Public-Office | ||
9475 | 9475 | 1991-01-31 | GCI Group Inc. | GCI Group, Inc. 3856 | Short-Form | Perez, Maria Isabel | Available-FARA-Public-Office | ||
9476 | 9476 | 1991-01-31 | GCI Group Inc. | GCI Group, Inc. 3856 | Short-Form | Remmert, Michael J. | Available-FARA-Public-Office | ||
9477 | 9477 | 1991-01-31 | GCI Group Inc. | GCI Group, Inc. 3856 | Short-Form | Siegmann, Robert J. | Available-FARA-Public-Office | ||
9478 | 9478 | 1991-01-31 | GCI Group Inc. | GCI Group, Inc. 3856 | Short-Form | Taranto, Delphin | Available-FARA-Public-Office | ||
9480 | 9480 | 1991-01-31 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | HERB STONE | Available-FARA-Public-Office | ||
9481 | 9481 | 1991-01-31 | JASCULCA/TERMAN & ASSOCIATES, INC. | Jasculca/Terman & Associates, Inc. 4289 | Short-Form | JANICE CAIN | Available-FARA-Public-Office | ||
9482 | 9482 | 1991-01-31 | JASCULCA/TERMAN & ASSOCIATES, INC. | Jasculca/Terman & Associates, Inc. 4289 | Short-Form | JULIA MERETTA | Available-FARA-Public-Office | ||
9483 | 9483 | 1991-01-31 | JASCULCA/TERMAN & ASSOCIATES, INC. | Jasculca/Terman & Associates, Inc. 4289 | Short-Form | LISA VONDERSCHMIDT | Available-FARA-Public-Office | ||
9484 | 9484 | 1991-01-31 | JASCULCA/TERMAN & ASSOCIATES, INC. | Jasculca/Terman & Associates, Inc. 4289 | Short-Form | LIZ NEWSTEAD | Available-FARA-Public-Office | ||
9485 | 9485 | 1991-01-31 | JASCULCA/TERMAN & ASSOCIATES, INC. | Jasculca/Terman & Associates, Inc. 4289 | Short-Form | MARY PATRICK | Available-FARA-Public-Office | ||
9487 | 9487 | 1992-01-31 | ITALIAN GOVERNMENT TOURIST BOARD, NEW YORK | Italian Government Tourist Board, New York 568 | Short-Form | DENNIS MANASSERO | Available-FARA-Public-Office | ||
9488 | 9488 | 1992-01-31 | ITALIAN GOVERNMENT TOURIST BOARD, NEW YORK | Italian Government Tourist Board, New York 568 | Short-Form | FRANCO SPAGNOL | Available-FARA-Public-Office | ||
9489 | 9489 | 1992-01-31 | ITALIAN GOVERNMENT TOURIST BOARD, NEW YORK | Italian Government Tourist Board, New York 568 | Short-Form | GIOVANNI CENZUALES | Available-FARA-Public-Office | ||
9490 | 9490 | 1992-01-31 | ITALIAN GOVERNMENT TOURIST BOARD, NEW YORK | Italian Government Tourist Board, New York 568 | Short-Form | MARIA C. SCALDAFERRI | Available-FARA-Public-Office | ||
9491 | 9491 | 1992-01-31 | ITALIAN GOVERNMENT TOURIST BOARD, NEW YORK | Italian Government Tourist Board, New York 568 | Short-Form | TERESA G. MARINO | Available-FARA-Public-Office | ||
9494 | 9494 | 1992-01-31 | WELSH DEVELOPMENT INTERNATIONAL | Welsh Development Agency 3819 | Short-Form | CLAIRE T. SINGLETON | Available-FARA-Public-Office | ||
9495 | 9495 | 1992-01-31 | WELSH DEVELOPMENT INTERNATIONAL | Welsh Development Agency 3819 | Short-Form | ROBERT IVOR SIMPSON | Available-FARA-Public-Office | ||
9510 | 9510 | 1994-01-31 | HECHT, SPENCER & ASSOCIATES, INC. | Hecht, Spencer & Associates, Inc. 4884 | Short-Form | WALTER D. HUDDLESTON | Available-FARA-Public-Office | ||
9570 | 9570 | 1995-01-31 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | ANNE LEGARE | Available-FARA-Public-Office | ||
9571 | 9571 | 1995-01-31 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | DAUPHIN, CLAUDE | Available-FARA-Public-Office | ||
9572 | 9572 | 1995-01-31 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | LEBLANC, GUY | Available-FARA-Public-Office | ||
9573 | 9573 | 1995-01-31 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | MARC T. BOUCHER | Available-FARA-Public-Office | ||
9574 | 9574 | 1995-01-31 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | NADEAU, PIERRE | Available-FARA-Public-Office | ||
9592 | 9592 | 1996-01-31 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | CRAIG S. KONICOFF | Available-FARA-Public-Office | ||
9613 | 9613 | 1996-01-31 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | KIMBERLY A. LYNCH | Available-FARA-Public-Office | ||
9620 | 9620 | 1996-01-31 | PEKAO TRADING CORPORATION | Pekao Trading Corporation 817 | Short-Form | ANNA HOLLAND-WAJS | Available-FARA-Public-Office | ||
9630 | 9630 | 1996-01-31 | SWIDLER BERLIN SHEREFF FRIEDMAN, LLP | Swidler Berlin Shereff Friedman, LLP 4079 | Short-Form | HELEN E. DISENHAUS | Available-FARA-Public-Office | ||
9657 | 9657 | 1997-01-31 | KELLEY SWOFFORD ROY, INC. | Kelley Swofford Roy, Inc. 5104 | Short-Form | CLEMENCIA I. DE TOBON | Available-FARA-Public-Office | ||
9662 | 9662 | 1997-01-31 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | CAROLYN P. OSOLINIK | Available-FARA-Public-Office | ||
9663 | 9663 | 1997-01-31 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | DAVID C. CRANE | 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]) );