FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Document_Type = "Short-Form" and Registrant_Name = "NEW ZEALAND GOVERNMENT TOURIST OFFICE"
This data as json, CSV (advanced)
Registrant_Name 1
- NEW ZEALAND GOVERNMENT TOURIST OFFICE · 7 ✖
Foreign_Principal_Name 1
- - 7
Foreign_Principal_Country 1
- - 7
Document_Type 1
- Short-Form · 7 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
20798 | 20798 | 1974-03-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | R.J. STANTON | Available-FARA-Public-Office | ||
34071 | 34071 | 1979-04-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | JOHN D. RASMUSSEN | Available-FARA-Public-Office | ||
45700 | 45700 | 1976-05-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | OWEN J. EAGLES | Available-FARA-Public-Office | ||
58022 | 58022 | 1975-06-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | JOHN J. HANNING | Available-FARA-Public-Office | ||
58272 | 58272 | 1978-06-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | BRUCE R. CLARKE | Available-FARA-Public-Office | ||
82137 | 82137 | 1980-08-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | BARRY CRAIG EDDINGTON | Available-FARA-Public-Office | ||
103506 | 103506 | 1981-10-01 | NEW ZEALAND GOVERNMENT TOURIST OFFICE | New Zealand Government Tourist Office 2307 | Short-Form | NICHOLAS C. MARKS | 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]) );