FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Short_Form_Last_Name = "Schultz"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 15
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Purcell & Nelson 1
- J.B. Rundle, Inc., Advertising 1
- Purcell & Nelson 1
- Sonatrach, Inc. 1
- AC&R Public Relations 1
- Holland & Knight 1
- Bannerman & Associates, Inc. 1
- Saudi Refining, Inc. 1
- Portland PR Inc. 1
- Finsbury, LLC 1
- MMGY Global, LLC 1
- Bridgeway Advocacy, LLC 1
- ArentFox Schiff LLP 1
- ETS Consulting 1
Registrant_Name 14
- Purcell & Nelson 2
- AC&R Public Relations 1
- ArentFox Schiff LLP 1
- Bannerman & Associates, Inc. 1
- Bridgeway Advocacy, LLC 1
- ETS Consulting 1
- Finsbury, LLC 1
- Holland & Knight 1
- J.B. Rundle, Inc., Advertising 1
- MMGY Global, LLC 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Portland PR Inc. 1
- Saudi Refining, Inc. 1
- Sonatrach, Inc. 1
City 6
- Washington 6
- New York 4
- Houston 2
- Alexandria 1
- Falls Church 1
- Overland Park 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
313 | 313 | 2022-02-04 | Schultz | Jim | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
2238 | 2238 | 2017-11-27 | Schultz | Jessica | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 | |
10562 | 10562 | 1964-03-23 | 1960-02-25 | Schultz | Franklin M. | Purcell & Nelson 1332 | 1960-02-25 | Purcell & Nelson | 910 - 17th Street, N.W. | Washington | DC | ||
11611 | 11611 | 1989-03-31 | 1988-10-13 | Schultz | Thomas Q. | Saudi Refining, Inc. 4184 | 1988-10-13 | Saudi Refining, Inc. | One Allen Center | 500 Dallas Street | Houston | TX | 77002 |
12670 | 12670 | 1968-04-03 | 1964-03-23 | Schultz | Franklin M. | Purcell & Nelson 1702 | 1964-03-23 | Purcell & Nelson | 888 - 17th Street, N.W. | Washington | DC | 20006 | |
14914 | 14914 | 2004-04-30 | 1996-07-31 | Schultz | Valerie Anne | Bannerman & Associates, Inc. 3964 | 1987-04-28 | Bannerman & Associates, Inc. | 3 Wilkes Street | Alexandria | VA | 22314 | |
15094 | 15094 | 2017-04-30 | 2015-06-02 | Schultz | Amy | Finsbury, LLC 6293 | 2015-05-12 | Finsbury, LLC | 3 Columbus Circle, Floor 9 | New York | NY | 10019 | |
21882 | 21882 | 2017-06-30 | 2015-10-01 | Schultz | Eric | Portland PR Inc. 6064 | 2011-09-19 | Portland PR Inc. | 805 15th St NW | Floor 3 | Washington | DC | 20005 |
21948 | 21948 | 2020-06-30 | 2020-03-13 | Schultz | Eric | Bridgeway Advocacy, LLC 6799 | 2020-03-13 | Bridgeway Advocacy, LLC | C/O The Yard | 700 Pennsylvania Avenue, SE, 2nd Floor | Washington | DC | 20003 |
24524 | 24524 | 1993-07-30 | 1987-01-21 | Schultz | Jack Randall | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
32962 | 32962 | 2021-10-15 | 2021-09-14 | Schultz | Eric | ArentFox Schiff LLP 6952 | 2021-04-30 | ArentFox Schiff LLP | 1717 K Street, NW | Washington | DC | 20006 | |
37660 | 37660 | 1965-12-03 | 1964-03-06 | Schultz | Warren David | J.B. Rundle, Inc., Advertising 1698 | 1964-03-06 | J.B. Rundle, Inc., Advertising | 21 East 26th Street | New York | NY | ||
38493 | 38493 | 1974-12-16 | 1971-12-17 | Schultz | Frank A. | Sonatrach, Inc. 2298 | 1971-12-17 | Sonatrach, Inc. | Post Office Box 27041 | Houston | TX | 77027 | |
39170 | 39170 | 1985-12-27 | 1977-09-13 | Schultz | Terri | AC&R Public Relations 2431 | 1973-06-12 | AC&R Public Relations | 136 Madison Avenue | New York | NY | 10016 | |
42458 | 42458 | 2022-12-31 | 2021-12-06 | Schultz | Eric Todd | ETS Consulting 7052 | 2021-12-06 | ETS Consulting | 2800 Flagmaker Drive | Falls Church | VA | 22042 |
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]) );