FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Registration_Number = 3942
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31934 | 31934 | 1993-10-01 | 1993-06-29 | Allbee | Ronald A. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
33018 | 33018 | 1992-10-16 | 1990-06-20 | Kruchko | Phyllis Elisabeth | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
33019 | 33019 | 1992-10-16 | 1992-06-30 | Moos | Gene | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
33066 | 33066 | 1990-10-17 | 1987-05-12 | Burke | Georgia H. | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
34303 | 34303 | 1990-10-31 | 1988-03-03 | Matsumoto | Tokuo | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
34304 | 34304 | 1990-10-31 | 1988-03-31 | Horiuchi | Mitsugu | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
34305 | 34305 | 1990-10-31 | 1987-05-12 | McDonald | Tom | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
34312 | 34312 | 1990-10-31 | 1988-10-12 | Murayama | Shiji | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
38122 | 38122 | 1992-12-11 | 1992-12-11 | Komaguchi | Sakari | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
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]) );