FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where City = "New York" and Short_Form_First_Name = "Charles"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 22
- Quebec Government Office 4
- Recht, Charles 1
- French Government Tourist Office 1
- Belgian Government Information Center 1
- Paul Guillumette, Inc. 1
- Bermuda Tourism Authority 1
- Republic of Indonesia Office 1
- Israel Information Services 1
- Smith, Edwin S. 1
- Charles Snitow Organization, Inc. 1
- Ruder Finn, Inc. 1
- International Public Relations Company, Ltd. 1
- Government of Ontario, Canada 1
- Allen/Van Slyck Group 1
- Dewey, Ballantine, Bushby, Palmer & Wood 1
- Singapore Tourism Board 1
- N.W. Ayer & Son, Inc. 1
- Agendas International, Inc. 1
- Dublirer, Haydon, Straci & Victor 1
- JMC Associates, Inc. 1
- Ruder Finn, Inc. 1
- High Lantern Group LLC 1
Registrant_Name 21
- Quebec Government Office 4
- Ruder Finn, Inc. 2
- Agendas International, Inc. 1
- Allen/Van Slyck Group 1
- Belgian Government Information Center 1
- Bermuda Tourism Authority 1
- Charles Snitow Organization, Inc. 1
- Dewey, Ballantine, Bushby, Palmer & Wood 1
- Dublirer, Haydon, Straci & Victor 1
- French Government Tourist Office 1
- Government of Ontario, Canada 1
- High Lantern Group LLC 1
- International Public Relations Company, Ltd. 1
- Israel Information Services 1
- JMC Associates, Inc. 1
- N.W. Ayer & Son, Inc. 1
- Paul Guillumette, Inc. 1
- Recht, Charles 1
- Republic of Indonesia Office 1
- Singapore Tourism Board 1
- Smith, Edwin S. 1
State 1
- NY 25
City 1
- New York · 25 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1840 | 1840 | 2021-09-24 | Jeffers II | Charles | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 | |
2846 | 2846 | 2007-01-01 | 1979-07-16 | Lipton | Charles | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
4076 | 4076 | 2022-01-18 | 2021-05-14 | Gould | Charles | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | |
8915 | 8915 | 2019-03-01 | 2016-07-27 | Girard | Charles | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
9681 | 9681 | 1954-03-12 | 1947-01-23 | Rado | Charles | Paul Guillumette, Inc. 429 | 1947-01-23 | Paul Guillumette, Inc. | 475 Fifth Avenue | New York | NY | ||
13813 | 13813 | 2015-04-20 | 1996-11-29 | Orlowek | Charles | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
14477 | 14477 | 1970-04-30 | 1964-12-07 | Duprat | Charles | French Government Tourist Office 364 | 1946-07-25 | French Government Tourist Office | 610 Fifth Avenue | New York | NY | 10020 | |
16544 | 16544 | 1971-05-17 | 1970-03-03 | Allen | Charles | Allen/Van Slyck Group 2191 | 1970-03-03 | Allen/Van Slyck Group | 1041 Third Avenue | New York | NY | 10021 | |
17115 | 17115 | 1955-05-26 | 1943-04-10 | Recht | Charles | Recht, Charles 101 | 1942-08-20 | Recht, Charles | 10 East 40th Street | New York | NY | 10012 | |
17595 | 17595 | 1964-05-31 | 1956-03-21 | Rikon | Charles | Smith, Edwin S. 723 | 1952-05-05 | Smith, Edwin S. | 24 West 45th Street | New York | NY | ||
17656 | 17656 | 1978-05-31 | 1968-12-03 | De Lorme | Charles | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
18233 | 18233 | 2021-05-31 | 2021-05-31 | McGinnis | Charles | High Lantern Group LLC 6967 | 2021-05-31 | High Lantern Group LLC | 685 3rd Avenue | 22nd Floor | New York | NY | 10017 |
25879 | 25879 | 1993-08-03 | 1990-11-26 | Dehn | Charles | JMC Associates, Inc. 4441 | 1990-11-26 | JMC Associates, Inc. | 437 Madison Avenue | 17th Floor | New York | NY | 10022 |
26567 | 26567 | 2012-08-13 | 2008-10-20 | Gauthier | Charles | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
27762 | 27762 | 1987-08-30 | 1984-05-25 | Rooney | Charles | Agendas International, Inc. 3524 | 1983-09-30 | Agendas International, Inc. | 820 Second Avenue | Suite 600 | New York | NY | 10017 |
29301 | 29301 | 1973-09-07 | 1973-03-14 | Jurrist | Charles | Dewey, Ballantine, Bushby, Palmer & Wood 2412 | 1973-03-14 | Dewey, Ballantine, Bushby, Palmer & Wood | 140 Broadway | New York | NY | 10005 | |
29320 | 29320 | 1989-09-07 | 1983-05-20 | Meding | Charles | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
29606 | 29606 | 1969-09-12 | 1964-09-02 | Chartier | Charles | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
30614 | 30614 | 1999-09-27 | 1990-07-10 | Leong | Charles | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 |
31779 | 31779 | 1959-10-01 | 1959-08-04 | Snitow | Charles | Charles Snitow Organization, Inc. 1251 | 1959-08-04 | Charles Snitow Organization, Inc. | 331 Madison Avenue | New York | NY | ||
31878 | 31878 | 1983-10-01 | 1971-06-28 | Butler | Charles | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | 352 Park Avenue, South | Suite 705 | New York | NY | 10010 |
32906 | 32906 | 1991-10-15 | 1987-08-27 | Haydon | Charles | Dublirer, Haydon, Straci & Victor 3961 | 1987-04-15 | Dublirer, Haydon, Straci & Victor | 17 Battery Place | New York | NY | 10004 | |
36354 | 36354 | 1969-11-25 | 1949-02-23 | Leirens | Charles | Belgian Government Information Center 405 | 1946-12-02 | Belgian Government Information Center | 50 Rockefeller Plaza | New York | NY | 10020 | |
39147 | 39147 | 1949-12-27 | 1947-11-04 | Thamboe | Charles | Republic of Indonesia Office 484 | 1947-08-01 | Republic of Indonesia Office | 53-63 Park Row | New York | NY | 10012 | |
39665 | 39665 | 1959-12-31 | 1956-01-20 | Tenenbaum | Charles | Israel Information Services 543 | 1948-10-12 | Israel Information Services | 11 East 70th Street | New York | NY | 10021 |
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]) );