FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

34 rows where City = "Petaluma", "Short_Form_Termination_Date" is on date 1989-01-26 and State = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date)

State 1

Registration_Number 1

Registrant_Name 1

City 1

  • Petaluma · 34 ✖
Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
4523 4523 1989-01-26 1981-01-21 Norton Stephen Leonard New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4524 4524 1989-01-26 1981-01-21 Perkins Marsha S. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4525 4525 1989-01-26 1985-02-06 Brinn-Young Lynda New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4526 4526 1989-01-26 1980-02-29 Bigelow David K. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4527 4527 1989-01-26 1980-02-29 Chase Duane W. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4528 4528 1989-01-26 1985-04-09 Childs Terence L. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4529 4529 1989-01-26 1980-04-25 Frey Kurt L. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4530 4530 1989-01-26 1979-04-27 Johns Ronald D. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4531 4531 1989-01-26 1979-04-27 Squire Edwin F. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4532 4532 1989-01-26 1979-04-27 Twieg William Charles New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4533 4533 1989-01-26 1983-04-27 Kemp Deborah A. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4534 4534 1989-01-26 1982-04-28 Huang I-Lo New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4535 4535 1989-01-26 1977-05-31 Walker Neil J. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4536 4536 1989-01-26 1986-07-23 Jones Thomas New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4537 4537 1989-01-26 1986-07-23 Lloyd Jonathan New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4538 4538 1989-01-26 1986-07-23 MacGregor Cathy New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4539 4539 1989-01-26 1986-07-23 Schifsky Ronald New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4540 4540 1989-01-26 1986-07-23 Service Brian K. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4541 4541 1989-01-26 1986-07-23 Stewart Lanny New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4542 4542 1989-01-26 1984-08-06 Hunter Helen E. Hoyer New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4543 4543 1989-01-26 1983-11-03 Arender Ronald H. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4544 4544 1989-01-26 1983-11-03 Hart John , III New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4545 4545 1989-01-26 1986-11-04 Holtz Brian New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4546 4546 1989-01-26 1986-11-04 McNaughton Neville New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4547 4547 1989-01-26 1986-11-04 Saforek Jaffrey A. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4548 4548 1989-01-26 1982-11-15 Glaser John F. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4549 4549 1989-01-26 1982-12-01 Wong Carleen J. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4550 4550 1989-01-26 1984-12-11 Chien Catherine New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4551 4551 1989-01-26 1984-12-11 Stevens Richard C. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4552 4552 1989-01-26 1984-12-11 Stiefer David L. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4553 4553 1989-01-26 1984-12-11 Williams Donald E. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4554 4554 1989-01-26 1982-12-22 Jackson Keith C. New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4555 4555 1989-01-26 1982-12-22 Shubert Janet Marie New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4556 4556 1989-01-26 1984-12-28 Massara William Edward New Zealand Milk Products, Inc. 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);