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 = "HAWTHORN GROUP, L.C."
This data as json, CSV (advanced)
These facets timed out: Foreign_Principal_Name
Registrant_Name 1
- HAWTHORN GROUP, L.C. · 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 |
---|---|---|---|---|---|---|---|---|---|
36858 | 36858 | 1994-04-01 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | JOHN ASHFORD | Available-FARA-Public-Office | ||
43533 | 43533 | 1994-04-28 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | CHRISTIANA FIGUERES | Available-FARA-Public-Office | ||
43534 | 43534 | 1994-04-28 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | DONALD AUCOIN | Available-FARA-Public-Office | ||
43535 | 43535 | 1994-04-28 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | JACK BUECHNER | Available-FARA-Public-Office | ||
43536 | 43536 | 1994-04-28 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | KATHERINE MATTOS | Available-FARA-Public-Office | ||
43537 | 43537 | 1994-04-28 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | MICHAEL MCADAMS | Available-FARA-Public-Office | ||
43538 | 43538 | 1994-04-28 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | SUZANNE HAMMELMAN | Available-FARA-Public-Office | ||
62091 | 62091 | 1994-06-02 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | CHRISTIANA FIGUERES | Available-FARA-Public-Office | ||
62092 | 62092 | 1994-06-02 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | DONALD AUCOIN | Available-FARA-Public-Office | ||
62093 | 62093 | 1994-06-02 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | JACK BUECHNER | Available-FARA-Public-Office | ||
62094 | 62094 | 1994-06-02 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | JOHN ASHFORD | Available-FARA-Public-Office | ||
62095 | 62095 | 1994-06-02 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | KATHERINE MATTOS | Available-FARA-Public-Office | ||
62096 | 62096 | 1994-06-02 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | MICHAEL MCADAMS | Available-FARA-Public-Office | ||
62097 | 62097 | 1994-06-02 | HAWTHORN GROUP, L.C. | Hawthorn Group, L.C. 4910 | Short-Form | SUZANNE HAMMELMAN | 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]) );