FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Document_Type = "Short-Form" and Registrant_Name = "J.C. Watts Companies"
This data as json, CSV (advanced)
Registrant_Name 1
- J.C. Watts Companies · 15 ✖
Foreign_Principal_Name 1
- - 15
Foreign_Principal_Country 1
- - 15
Document_Type 1
- Short-Form · 15 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
32140 | 32140 | 2006-03-30 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Gillette, Robert | Available-FARA-Public-Office | ||
50492 | 50492 | 2006-05-09 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Pruitt, Steven | Available-FARA-Public-Office | ||
89966 | 89966 | 2004-08-27 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Egge,Rob | Available-FARA-Public-Office | ||
89967 | 89967 | 2004-08-27 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Humphrey,Calvin | Available-FARA-Public-Office | ||
89968 | 89968 | 2004-08-27 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Pruitt,Steve | Available-FARA-Public-Office | ||
89969 | 89969 | 2004-08-27 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Sailor,Elroy | Available-FARA-Public-Office | ||
89970 | 89970 | 2004-08-27 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Watts,J.C. Jr., | Available-FARA-Public-Office | ||
108714 | 108714 | 2005-10-14 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Alion, Christopher M. | Available-FARA-Public-Office | ||
108715 | 108715 | 2005-10-14 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Mitchell, Lindsey | Available-FARA-Public-Office | ||
108716 | 108716 | 2005-10-14 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Omar, Cheik | Available-FARA-Public-Office | ||
108717 | 108717 | 2005-10-14 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Park, Andrew J. | Available-FARA-Public-Office | ||
108718 | 108718 | 2005-10-14 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Pruitt, Steven Lawrence | Available-FARA-Public-Office | ||
108719 | 108719 | 2005-10-14 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Sailor, Elroy | Available-FARA-Public-Office | ||
108720 | 108720 | 2005-10-14 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Thomas, Doug | Available-FARA-Public-Office | ||
108721 | 108721 | 2005-10-14 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Short-Form | Watts, J.C. | 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]) );