FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Document_Type = "Short-Form" and Registrant_Name = "Schmeltzer, Aptaker & Shepard, P.C."
This data as json, CSV (advanced)
Registrant_Name 1
- Schmeltzer, Aptaker & Shepard, P.C. · 14 ✖
Foreign_Principal_Name 1
- - 14
Foreign_Principal_Country 1
- - 14
Document_Type 1
- Short-Form · 14 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
37389 | 37389 | 2002-04-03 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Smith,J. Anthony Tony"" | Available-FARA-Public-Office | ||
52956 | 52956 | 2004-05-18 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Lee,Tony S. | Available-FARA-Public-Office | ||
52957 | 52957 | 2004-05-18 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Paz-Soldan,Carlos Mateo | Available-FARA-Public-Office | ||
52958 | 52958 | 2004-05-18 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Schmeltzer,Edward | Available-FARA-Public-Office | ||
52959 | 52959 | 2004-05-18 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Smith,J. Anthony Tony"" | Available-FARA-Public-Office | ||
67386 | 67386 | 2002-06-25 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Buechner,Jack W. | Available-FARA-Public-Office | ||
75502 | 75502 | 2001-07-12 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Smith,J. Anthony Tony"" | Available-FARA-Public-Office | ||
111803 | 111803 | 2005-10-28 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Ulman, Joshua A. | Available-FARA-Public-Office | ||
112520 | 112520 | 2002-10-30 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Lee,Tony S. | Available-FARA-Public-Office | ||
121220 | 121220 | 2000-11-22 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Smith,J. Anthony Tony"" | Available-FARA-Public-Office | ||
130169 | 130169 | 2004-12-10 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Ferreira,Marisa Borba | Available-FARA-Public-Office | ||
130170 | 130170 | 2004-12-10 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Lee,Tony S. | Available-FARA-Public-Office | ||
130171 | 130171 | 2004-12-10 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Paz-Soldan,Carlos Mateo | Available-FARA-Public-Office | ||
130172 | 130172 | 2004-12-10 | Schmeltzer, Aptaker & Shepard, P.C. | Schmeltzer, Aptaker & Shepard, P.C. 5304 | Short-Form | Smith,J. Anthony Tony"" | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );