FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

67 rows where City = "Petaluma"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registration_Number

Registrant_Name

City

  • Petaluma · 67 ✖
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
3471 3471 1984-01-12 1980-10-28 Pilkington David Alan 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
3635 3635 1988-01-15 1981-05-07 Henley Michael H. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4316 4316 1989-01-26 1981-01-21 Norton Stephen Leonard 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4317 4317 1989-01-26 1981-01-21 Perkins Marsha S. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4318 4318 1989-01-26 1985-02-06 Brinn-Young Lynda 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4319 4319 1989-01-26 1980-02-29 Bigelow David K. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4320 4320 1989-01-26 1980-02-29 Chase Duane W. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4321 4321 1989-01-26 1985-04-09 Childs Terence L. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4322 4322 1989-01-26 1980-04-25 Frey Kurt L. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4323 4323 1989-01-26 1979-04-27 Johns Ronald D. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4324 4324 1989-01-26 1979-04-27 Squire Edwin F. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4325 4325 1989-01-26 1979-04-27 Twieg William Charles 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4326 4326 1989-01-26 1983-04-27 Kemp Deborah A. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4327 4327 1989-01-26 1982-04-28 Huang I-Lo 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4328 4328 1989-01-26 1977-05-31 Walker Neil J. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4329 4329 1989-01-26 1986-07-23 Jones Thomas 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4330 4330 1989-01-26 1986-07-23 Lloyd Jonathan 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4331 4331 1989-01-26 1986-07-23 MacGregor Cathy 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4332 4332 1989-01-26 1986-07-23 Schifsky Ronald 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4333 4333 1989-01-26 1986-07-23 Service Brian K. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4334 4334 1989-01-26 1986-07-23 Stewart Lanny 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4335 4335 1989-01-26 1984-08-06 Hunter Helen E. Hoyer 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4336 4336 1989-01-26 1983-11-03 Arender Ronald H. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4337 4337 1989-01-26 1983-11-03 Hart John , III 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4338 4338 1989-01-26 1986-11-04 Holtz Brian 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4339 4339 1989-01-26 1986-11-04 McNaughton Neville 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4340 4340 1989-01-26 1986-11-04 Saforek Jaffrey A. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4341 4341 1989-01-26 1982-11-15 Glaser John F. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4342 4342 1989-01-26 1982-12-01 Wong Carleen J. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4343 4343 1989-01-26 1984-12-11 Chien Catherine 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4344 4344 1989-01-26 1984-12-11 Stevens Richard C. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4345 4345 1989-01-26 1984-12-11 Stiefer David L. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4346 4346 1989-01-26 1984-12-11 Williams Donald E. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4347 4347 1989-01-26 1982-12-22 Jackson Keith C. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4348 4348 1989-01-26 1982-12-22 Shubert Janet Marie 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4349 4349 1989-01-26 1984-12-28 Massara William Edward 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
4744 4744 1979-01-31 1973-10-01 Foin Theodore C. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
5482 5482 1986-02-01 1984-12-11 Jones Neville Owen 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
5886 5886 1988-02-05 1986-04-14 Lilley David 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
6915 6915 1976-02-20 1973-10-01 Patterson Aylwyn C. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
7503 7503 1982-02-28 1979-04-27 Eastin William C. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
8517 8517 1983-03-03 1982-11-17 Giles Dennis M. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
9282 9282 1986-03-14 1975-07-08 Reece Edward C. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
10175 10175 1976-03-25 1973-10-01 Jones Neville O. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
10933 10933 1982-03-31 1979-04-27 Connolly Philip Bruce 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
13377 13377 1974-04-26 1974-06-28 Mertens Michael H. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
15461 15461 1984-05-15 1977-05-31 Stuart Bruce L. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
16707 16707 1985-05-31 1981-05-07 Marsden James L. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
18209 18209 1987-06-12 1985-02-06 Fleming Karen Lynn 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
18545 18545 1982-06-16 1979-04-27 Garrell Joe C. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
21330 21330 1984-07-05 1982-08-05 Sanders William Roy 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
22297 22297 1983-07-19 1982-10-26 Miller Linda M. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
24862 24862 1978-08-09 1977-05-31 Weatherley Roger D. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
26582 26582 1986-08-31 1982-10-18 Williams Daniel P. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
26600 26600 1987-08-31 1984-12-11 Mackie Larry E. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
27252 27252 1980-09-01 1979-02-14 McPherson Kevin Robert 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
29329 29329 1981-09-30 1979-10-26 Fenwick R. M. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
29331 29331 1982-09-30 1982-01-27 Christiansen Anthony J. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
29338 29338 1983-09-30 1981-01-21 Rowe Peter James 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
29348 29348 1984-09-30 1982-11-17 Gundersheim Jackson C. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
29362 29362 1986-09-30 1983-04-27 Nishikawa Russell K. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
30219 30219 1986-10-01 1983-04-27 LaFrance Roberta L. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
33069 33069 1985-11-01 1983-04-27 Hutchison Joseph C. , Jr. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
35379 35379 1985-12-01 1980-02-29 Sheehe Carol L. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
36924 36924 1987-12-23 1984-12-11 Flower Tullie E. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
37841 37841 1972-12-31 1973-10-01 Kirkpatrick Kenneth J. 2463 2463 1973-10-01 New Zealand Milk Products, Inc. 1269 North McDowell Boulevard   Petaluma CA 94952
38055 38055 1980-12-31 1980-06-10 Bellanca Nicolo 2463 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)
);
Powered by Datasette · Query took 390.097ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history