FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
44 rows where Document_Type = "Short-Form" and Registrant_Name = "SAWYER MILLER GROUP"
This data as json, CSV (advanced)
Registrant_Name 1
- SAWYER MILLER GROUP · 44 ✖
Foreign_Principal_Name 1
- - 44
Foreign_Principal_Country 1
- - 44
Document_Type 1
- Short-Form · 44 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
1329 | 1329 | 1988-01-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | G. MARK MALLOCH BROWN | Available-FARA-Public-Office | ||
6703 | 6703 | 1993-01-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | C.C. CASE | Available-FARA-Public-Office | ||
6704 | 6704 | 1993-01-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | ELLEN S. SULLIVAN | Available-FARA-Public-Office | ||
6705 | 6705 | 1993-01-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | ULRIKE SZALAY | Available-FARA-Public-Office | ||
14531 | 14531 | 1986-02-06 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DAVID E. MOREY | Available-FARA-Public-Office | ||
15398 | 15398 | 1986-02-10 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOEL MCCLEARY | Available-FARA-Public-Office | ||
15807 | 15807 | 1986-02-12 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DAVID HASKELL SAWYER | Available-FARA-Public-Office | ||
19539 | 19539 | 1992-02-28 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | HEATHER HAMILTON LANE | Available-FARA-Public-Office | ||
19540 | 19540 | 1992-02-28 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOHN BASKIND | Available-FARA-Public-Office | ||
24781 | 24781 | 1992-03-03 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | LENNY STERN | Available-FARA-Public-Office | ||
24782 | 24782 | 1992-03-03 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | MICHAEL R. EGGER | Available-FARA-Public-Office | ||
25058 | 25058 | 1992-03-04 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | BASIL S. TSAPALAS | Available-FARA-Public-Office | ||
25059 | 25059 | 1992-03-04 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | RICK JOHN BEAULIEU | Available-FARA-Public-Office | ||
25060 | 25060 | 1992-03-04 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | WILLIAM B. TAYLOR | Available-FARA-Public-Office | ||
34817 | 34817 | 1987-04-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | PETER SCHECTER | Available-FARA-Public-Office | ||
37152 | 37152 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | GINA CHRISTENSEN | Available-FARA-Public-Office | ||
37153 | 37153 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | HARRIS DIAMOND | Available-FARA-Public-Office | ||
37154 | 37154 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | LYNN GUGGENHEIMER | Available-FARA-Public-Office | ||
37155 | 37155 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | MARK R. JOHNSON | Available-FARA-Public-Office | ||
37156 | 37156 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | MARY F. MASELLI | Available-FARA-Public-Office | ||
46725 | 46725 | 1988-05-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOEL MCCLEARY | Available-FARA-Public-Office | ||
60373 | 60373 | 1991-06-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOHN P. SCANLON | Available-FARA-Public-Office | ||
63017 | 63017 | 1991-06-06 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | ROBERT SHEPARDSON | Available-FARA-Public-Office | ||
64034 | 64034 | 1991-06-10 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | KELLY A. MCBRIDE | Available-FARA-Public-Office | ||
64301 | 64301 | 1991-06-11 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | MARK P. LONGABAUGH | Available-FARA-Public-Office | ||
66364 | 66364 | 1986-06-21 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DAVID HASKELL SAWYER | Available-FARA-Public-Office | ||
67090 | 67090 | 1986-06-24 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOEL MCCLEARY | Available-FARA-Public-Office | ||
67091 | 67091 | 1986-06-24 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | WILLIAM SCOTT MILLER | Available-FARA-Public-Office | ||
72354 | 72354 | 1991-07-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JILL WILKINS | Available-FARA-Public-Office | ||
92979 | 92979 | 1987-09-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | G. MARK MALLOCH BROWN | Available-FARA-Public-Office | ||
97878 | 97878 | 1986-09-15 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DAVID E. MOREY | Available-FARA-Public-Office | ||
97879 | 97879 | 1986-09-15 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | G. MARK MALLOCH BROWN | Available-FARA-Public-Office | ||
99502 | 99502 | 1992-09-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | CAROLINE MCCALL | Available-FARA-Public-Office | ||
99503 | 99503 | 1992-09-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | THOMAS BRUCE | Available-FARA-Public-Office | ||
100506 | 100506 | 1990-09-26 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | BARRY HALL FRENCH | Available-FARA-Public-Office | ||
100507 | 100507 | 1990-09-26 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JAMES A. MESZAROS | Available-FARA-Public-Office | ||
104025 | 104025 | 1986-10-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOHN W. LESLIE, JR. | Available-FARA-Public-Office | ||
104306 | 104306 | 1988-10-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | LIONEL A. ROSENBLATT | Available-FARA-Public-Office | ||
107448 | 107448 | 1991-10-08 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DEIRDRE COHEN | Available-FARA-Public-Office | ||
109252 | 109252 | 1991-10-17 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOHN ROBERTS | Available-FARA-Public-Office | ||
110180 | 110180 | 1991-10-21 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | ROBIN SCHEPPER | Available-FARA-Public-Office | ||
122686 | 122686 | 1987-11-30 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | AIMEE H. LAUREL | Available-FARA-Public-Office | ||
122687 | 122687 | 1987-11-30 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DAVID FRANK | Available-FARA-Public-Office | ||
122688 | 122688 | 1987-11-30 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | G. MARK MALLOCH BROWN | 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]) );