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

21 rows where Registration_Number = 810

Search:

descending

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	City	State	Zip
3080	3080	1955-01-05	1954-01-05	Bowman	Betty Lucille	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
3963	3963	1974-01-21	1955-08-15	Eckhardt	George Henry , Jr.	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
4267	4267	1955-01-26	1954-01-05	DiMarco	Frank	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
5336	5336	1965-02-01	1961-02-03	Creveling	Gray	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
5676	5676	1960-02-03	1956-09-21	Brossy	Susan Charlotte	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
5763	5763	1958-02-04	1954-01-05	Hagemeister	Jane True	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
5764	5764	1958-02-04	1956-09-21	Nogavica	Maehelena	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
21063	21063	1968-07-03	1960-02-15	Diespecker	Richard Alan	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
21128	21128	1955-07-05	1954-05-03	Dowell	Emery Bevington	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
21129	21129	1956-07-05	1956-01-20	Mercereau	Stuart Curtis	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
21130	21130	1956-07-05	1955-03-31	Ireland	Barbara Eugene	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
21165	21165	1995-07-05	1994-08-30	Crosier	Susan	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
22835	22835	1994-07-29	1954-01-05	von Loewenfeldt	Charles	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
24776	24776	1964-08-11	1961-01-27	Hayasaka	Johnny Kiyoshi	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
24777	24777	1964-08-11	1961-01-27	Joyce	Robert Nelson	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
24778	24778	1964-08-11	1961-01-27	Langley	Donald Channing	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
24779	24779	1964-08-11	1962-02-06	Brossy	Susan Charlotte	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
24780	24780	1964-08-11	1963-02-07	Eisley	Richard Steven	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
24783	24783	1964-08-11	1956-08-03	Laverty	Helen	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
29922	29922	1974-10-01	1973-02-01	Crosier	Susan Brossy	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941
37653	37653	1975-12-31	1972-07-11	Berger	Michael	810 810	1954-01-05	Charles von Loewenfeldt, Inc.	17 Eagle Rock Road	Mill Valley	CA	94941

Advanced export

JSON shape: default, array, newline-delimited

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)
);