FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_Last_Name = "Ball"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Registration_Date, Address_2, Short_Form_Termination_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4606 | 4606 | 1961-01-27 | 1948-01-19 | Ball | George Wildman | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
7162 | 7162 | 1984-02-17 | 1983-07-25 | Ball | Tom | Schiappa, Gerard F. 3502 | 1983-07-25 | Schiappa, Gerard F. | 2550 M Street, N.W. | Suite 300 | Washington | DC | 20037 |
8154 | 8154 | 2002-02-28 | 1999-08-16 | Ball | Markham | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
8155 | 8155 | 2002-02-28 | 2001-08-29 | Ball | Jennifer L. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
19396 | 19396 | 1976-06-14 | 1975-12-16 | Ball | Nancy L. | Daniel J. Edelman, Inc. 2640 | 1975-12-15 | Daniel J. Edelman, Inc. | 1730 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
21037 | 21037 | 1985-06-30 | 1985-03-12 | Ball | Thomas J. | Snyder, Ball, Kriser & Associates, Inc. 3655 | 1985-03-08 | Snyder, Ball, Kriser & Associates, Inc. | 499 South Capitol Street, S.W. | Suite 520 | Washington | DC | 20003 |
35684 | 35684 | 1973-11-13 | 1955-03-24 | Ball | Ralph K. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
35694 | 35694 | 1973-11-13 | 1953-05-25 | Ball | Stuart S. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
36954 | 36954 | 2006-11-30 | 2006-07-11 | Ball | William L. | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | 1801 K Street, NW | Suite 340 | Washington | DC | 20006 |
37265 | 37265 | 1964-12-01 | 1961-10-11 | Ball | Robert Markham | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 888 - 16th Street, N.W. | Washington | DC | 20006 | |
39309 | 39309 | 1966-12-30 | 1966-11-16 | Ball | Joseph H. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
39351 | 39351 | 1982-12-30 | 1975-11-25 | Ball | Nancy L. | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | 1730 Pennsylvania Avenue, N.W. | Room 460 | 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]) );