FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where "Short_Form_Termination_Date" is on date 1989-01-01
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 13
- Wilmer, Cutler & Pickering 2
- Mexican Tourism Board 1
- Tourism Authority of Thailand, New York 1
- Malaysia Tourism Promotion Board 1
- Clifford & Warnke 1
- Film Comm, Inc. 1
- Anderson, Hibey & Blair 1
- Sutherland, Asbill & Brennan 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Collier Shannon Scott, PLLC 1
- Coudert Brothers 1
- Levine & Company 1
- McKenna, Conner & Cuneo 1
Registrant_Name 13
- Wilmer, Cutler & Pickering 2
- Anderson, Hibey & Blair 1
- Clifford & Warnke 1
- Collier Shannon Scott, PLLC 1
- Coudert Brothers 1
- Film Comm, Inc. 1
- Levine & Company 1
- Malaysia Tourism Promotion Board 1
- McKenna, Conner & Cuneo 1
- Mexican Tourism Board 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Sutherland, Asbill & Brennan 1
- Tourism Authority of Thailand, New York 1
City 6
- Washington 7
- New York 3
- Bethesda 1
- Glendale Heights 1
- Los Angeles 1
- Washington, 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2674 | 2674 | 1989-01-01 | 1989-03-16 | Marmorstein | Vicki E. | Coudert Brothers 3743 | 1985-10-02 | Coudert Brothers | 1627 I Street, N. W. | Suite 1200 | Washington, | DC | 20006 |
2675 | 2675 | 1989-01-01 | 1982-04-08 | Clark | Reuben | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 | |
2676 | 2676 | 1989-01-01 | 1979-05-03 | Warnke | Paul C. | Clifford & Warnke 2564 | 1975-03-26 | Clifford & Warnke | 815 Connecticut Avenue, N.W. | Washington | DC | 20006 | |
2677 | 2677 | 1989-01-01 | 1983-06-20 | Juliano | Robert E. | Anderson, Hibey & Blair 3208 | 1981-03-09 | Anderson, Hibey & Blair | 1708 New Hampshire Ave., N.W. | Washington | DC | 20009 | |
2678 | 2678 | 1989-01-01 | 1987-07-13 | Dennin | Joseph F. | McKenna, Conner & Cuneo 4011 | 1987-07-13 | McKenna, Conner & Cuneo | 1575 I Street, N.W. | Washington | DC | 20005 | |
2679 | 2679 | 1989-01-01 | 1985-07-17 | Pongsakitch | Chaiyasith | Tourism Authority of Thailand, New York 1897 | 1965-06-01 | Tourism Authority of Thailand, New York | 61 Broadway | Suite 2810 | New York | NY | 10006 |
2680 | 2680 | 1989-01-01 | 1988-08-11 | Diefenderfer | William M. , III | Levine & Company 3971 | 1987-04-29 | Levine & Company | 7100 Millwood Road | Bethesda | MD | 20817 | |
2681 | 2681 | 1989-01-01 | 1989-08-16 | Hamid | Noor Ahmad | Malaysia Tourism Promotion Board 2510 | 1974-04-17 | Malaysia Tourism Promotion Board | 818 West Seventh Street | Suite 970 | Los Angeles | CA | 90017-3432 |
2682 | 2682 | 1989-01-01 | 1985-10-22 | Lombardo | Jorge Diaz | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
2683 | 2683 | 1989-01-01 | 1988-10-25 | Pickering | John H. | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 | |
2684 | 2684 | 1989-01-01 | 1987-11-03 | Laufman | David H. | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | 3050 K Street N.W. | Suite 400 | Washington | DC | 20007-5108 |
2685 | 2685 | 1989-01-01 | 1981-11-20 | Rosenthal | Douglas E. | Sutherland, Asbill & Brennan 3307 | 1981-11-20 | Sutherland, Asbill & Brennan | 1275 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2404 | |
2686 | 2686 | 1989-01-01 | 1987-12-07 | Itzkowitz | Jay | Paul, Weiss, Rifkind, Wharton & Garrison 3647 | 1985-02-04 | Paul, Weiss, Rifkind, Wharton & Garrison | 1285 Avenue of the Americas | New York | NY | 10019 | |
2687 | 2687 | 1989-01-01 | 1975-12-10 | Hempel | Gordon J. | Film Comm, Inc. 2638 | 1975-12-10 | Film Comm, Inc. | 641 North Avenue | Glendale Heights | IL | 60139 |
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]) );