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, atom, 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
3421 3421 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
3583 3583 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
4260 4260 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
4261 4261 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
4262 4262 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
4263 4263 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
4264 4264 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
4265 4265 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
4266 4266 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
4267 4267 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
4268 4268 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
4269 4269 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
4270 4270 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
4271 4271 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
4272 4272 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
4273 4273 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
4274 4274 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
4275 4275 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
4276 4276 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
4277 4277 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
4278 4278 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
4279 4279 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
4280 4280 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
4281 4281 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
4282 4282 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
4283 4283 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
4284 4284 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
4285 4285 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
4286 4286 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
4287 4287 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
4288 4288 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
4289 4289 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
4290 4290 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
4291 4291 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
4292 4292 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
4293 4293 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
4680 4680 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
5399 5399 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
5803 5803 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
6814 6814 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
7397 7397 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
8390 8390 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
9152 9152 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
10042 10042 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
10792 10792 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
13205 13205 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
15225 15225 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
16451 16451 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
17937 17937 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
18271 18271 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
21030 21030 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
21994 21994 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
24533 24533 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
26229 26229 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
26247 26247 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
26894 26894 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
28959 28959 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
28961 28961 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
28968 28968 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
28978 28978 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
28992 28992 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
29844 29844 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
32667 32667 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
34958 34958 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
36487 36487 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
37401 37401 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
37615 37615 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 325.633ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history