FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

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

6,717 rows

✎ View and edit SQL

This data as json, CSV (advanced)

State >30

Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
116 1942-09-09 1942-09-09 Mezquita, Teresa   Spanish Library of Information 2 East 34th Street New York NY  
117 1942-09-09 1942-09-09 Orta, Pilar   2 East 34th Street   New York NY  
118 1942-09-09 1942-09-09 Mezquita, Manuel   Spanish Library of Information 2 East 34th Street New York NY  
119 1942-09-05 1942-09-05 Edmiston, Homer   56 West 95th Street   New York NY  
120 1942-09-10 1943-03-06 Goepel, C.P.   165 Broadway   New York NY  
121 1942-09-11 1942-09-11 Braik, Douglas Gordon   C/O British Consulate General 12 South 12th Street Philadelphia PA  
122 1942-09-14 1943-03-14 Furudera, Robert H.   Morimura Brothers, Inc. 53 West 23rd Street New York NY  
123 1942-09-14 1964-02-26 Union Nacional Sinarquista   7245 -1/2 Dale Road #15   El Paso    
125 1942-09-18 1943-03-18 Ekis, Ludvigs   4704 - 17th Street, N.E.   Washington DC 20005
126 1942-09-21 1945-07-02 American Spice Trade Association, Inc.   82 Wall Street   New York NY  
127 1942-09-23 1942-09-23 Pallos, Steven   729 Seventh Avenue   New York NY  
129 1942-09-29 1946-02-08 Austrian Labor Committee   19 West 44th Street Room 1018 New York NY  
130 1942-09-29 1942-09-29 Fernier, Rene   50 Rockefeller Plaza Room 523 New York NY  
131 1942-09-14 1947-03-14 Comite France Amerique   Jones & McAllister Streets   San Francisco CA  
132 1942-09-24 1943-10-24 LeRoy & Denslow   412-418 Colorado Building   Washington DC xxxxx
133 1942-10-01 1944-04-01 Granich, Grace   207 Fourth Avenue Room 902 New York NY  
134 1942-10-05 1944-10-05 Doremus & Company   120 Broadway   New York NY  
135 1942-10-05 1945-11-05 Polish Catholic Press Agency   27 Grosvenor Street   London, England    
136 1942-10-07 1942-10-07 De Longfief, Henri Villieras   National Press Building   Washington DC  
137 1942-10-07 1942-10-07 Sweinhart, Henry L.   1374 National Press Building   Washington DC  
138 1942-10-10 1943-05-31 Austin, Clyde   1706 K Street, N.W.   Washington DC  
139 1942-10-08 1968-03-04 Comite Regional Sinarquista en Los Angeles   727 Camulos Street   Los Angeles CA  
140 1942-10-14 1942-10-14 Peron, Andre Antoine   50 Rockefeller Plaza Room 523 New York NY  
141 1942-10-15 1942-10-15 D'Aumale, Claude   50 Rockefeller Plaza   New York NY  
142 1942-10-15 1942-10-15 De Arrieta, Juan   Teleradio News Agency 50 Rockefeller Plaza New York NY  
143 1942-10-15 1942-10-15 De Arrieta, Henriette Jauny   Teleradio News Agency 50 Rockefeller Plaza New York NY  
144 1942-10-19 1946-04-19 Shands, Richard E.   Shoreham Building   Washington DC  
145 1942-10-21 1942-10-21 Finley, Blanche   C/O French Info. Center, Inc. 610 Fifth Avenue, Room 401 New York NY  
147 1942-10-23 1944-10-23 Goldfinger, William   55 East Mosholu Parkway, North   Bronx NY  
148 1942-10-23 1942-10-23 Le Branchu, Jean-Yves   C/O French Info. Center, Inc. 610 Fifth Avenue, Room 401 New York NY  
150 1942-10-29 1942-10-02 Cartier, Pierre C.   Cartier, Inc. Fifth Avenue & 52nd Street New York NY  
151 1942-10-29 1945-04-29 Koenig, Harry D.   111 West Washington Street Room 1701 Chicago IL 60290
152 1942-11-04 1943-05-04 Moraru, Glicherie   2734 Holly Avenue   Dearborn MI  
153 1942-11-05 1942-11-05 Minor, Gatley & Drury   312 Colorado Building 1341 G Street, N.W. Washington DC  
155 1942-11-13 1948-11-15 Korean Commission   1766 Hobart Street, N.W.   Washington DC  
157 1942-11-13 1945-05-13 Bossowick, Irving   1440 Broadway   New York NY  
158 1942-11-14 1946-05-14 Norwegian Seamens' Assocation   Norsk Sjomannsforbund Grev Wedels Plass 5 Oslo    
159 1942-11-20 1945-05-20 Gallia Laboratories, Inc.   254-256 West 31st Street   New York NY  
161 1942-12-07 1946-12-07 Korean-American Council   1700 I Street, N.W.   Washington DC  
162 1942-12-09 1943-03-25 Maurois, Andre'   465 Park Avenue   New York NY  
163 1942-12-11 1942-12-11 Polk, Frank L. Davis, Polk, Wardwell, Gardiner & Reed 15 Broad Street   New York NY  
164 1942-12-17 1942-12-17 Sansoni, Guido   210 East 73rd Street   New York NY  
165 1942-12-23 1945-09-23 Martial, Jean   21 East 87th Street   New York NY  
166 1943-12-30 1946-12-30 Lucientes, Francisco J.   1270 Boston Post Road   Rye NY  
167 1943-01-01 1966-12-31 French Chamber of Commerce of the U.S., Inc.   1350 Avenue of the Americas   New York NY 10019
168 1943-01-01 1944-12-31 Aladren, Jose M.   Hotel Lafayette   Washington DC  
169 1943-01-02 1943-07-02 Nunnemacher, Emilie   3453 North Hackett Avenue   Milwaukee WI  
170 1943-01-02 1943-07-02 Quarles, Louis   411 East Mason Street   Milwaukee WI  
171 1943-01-06 1943-01-06 Longin-Spindler, Emanuel Mary Paul   2318 Broadway   New Orleans LA  
172 1943-01-23 1992-12-31 Portuguese National Tourist Office   570 Fifth Avenue   New York NY 10036
173 1943-01-06 1944-10-18 American National Pan-Epirotic League   303 West 42nd Street Room 302 New York NY  
174 1943-01-19 1944-07-19 Franzen, Knut Gosta   64 Pine Street   San Franciso CA  
175 1943-01-22 1949-01-22 Dong, Ji Hoi   351 Wadsworth Avenue   New York NY  
176 1943-01-27 1943-01-27 Gauthier, Donat A.   7408 Pog Street   Detroit MI  
177 1943-02-02 1945-02-02 Boyer, Maurice   57 William Street   New York NY  
179 1943-02-12 1947-08-13 J.M. Dent & Sons (Canada), Ltd.   224 Bloor Street, West   Toronto, Ontario    
180 1943-03-06 1943-03-06 Danielson, Walter G.   836 Title Insurance Building 433 South Spring Street Los Angeles CA  
182 1943-04-01 1967-10-13 Shallna, Anthony O.   395 West Broadway Post Office Box 54 South Boston MA 02127
183 1943-03-31 1943-03-31 Gastreich, Hermann   1400 Walnut Street   Kansas City MO  
184 1943-04-03 1945-04-03 Comite Municipal Sinarquista   822 South 16th Street   McAllen TX  
185 1943-08-05 1944-10-05 Bavarian Council   C/O Dr. Frederick W. Proewig De Mott Place Long Island NY  
188 1943-04-08 1943-10-01 Prelacy of the Armenian Apostolic Church in America, Inc.   156 Fifth Avenue   New York NY 10010
189 1943-04-23 1945-12-31 United Korean Committee in America   1719 K Street, N.W.   Washington DC  
191 1943-05-14 1943-05-14 Beck, P.A.   39 Cortlandt Street   New York NY  
192 1943-05-14 1943-05-14 Lie, Haakon Steen   Norwegian Seamens' Union 156 Montague Street Brooklyn NY  
193 1943-05-19 1943-06-19 De Chambrier, Therese   160 East 48th Street   New York NY  
194 1943-05-24 1944-12-08 Matuszewski, Ignacy   224 Riverside Drive   New York NY  
195 1943-06-09 1947-06-09 Free Austrian Movement   165 West 46th Street   New York NY  
196 1943-06-11 1943-06-11 Davies, Harry   701 Seventh Avenue   New York NY  
197 1943-06-11 1961-12-11 Dominican Chamber of Commerce of the U.S., Inc.   1270 Avenue of the Americas   New York NY  
199 1943-07-22 1945-07-22 Goetz, Carlos Cudell   25 Central Park, West   New York NY  
200 1943-07-03 1943-09-11 Redfield, Roy A.   919 Paulsen Building   Spokane WA 00000
202 1943-08-03 1944-02-03 Barres, Philippe   16 East 54th Street   New York NY  
204 1943-08-26 1945-08-26 Norwegian Masters' Association Overseas Branch   44 Whitehall Street   New York NY  
205 1943-08-27 1945-02-17 Riddick, Floyd M.   U.S. Chamber of Commerce   Washington DC 20005
206 1943-08-30 1948-03-01 Kutylowski, Roman Marius   Gdynia America Line, Inc. 32 Pearl Street New York NY  
207 1943-09-13 1946-05-05 Korean National Revolutionary Party, Los Angeles   955 West Jefferson Street   Los Angeles CA  
208 1943-09-14 1971-10-29 American Section of the Jewish Agency for Israel   515 Park Avenue   New York NY 10022
209 1943-09-17 1946-03-17 Swedish Seamens' Union   156 Montague Street   Brooklyn NY  
210 1943-09-23 1943-09-23 Malo, Jesus Gonzalez   70 Middagh Street   Brooklyn NY  
211 1943-09-28 1948-03-28 French Line, Inc.   17 State Street   New York NY  
213 1943-10-02 1945-10-02 Kaskel, Joseph   39 Broadway   New York NY  
215 1943-10-14 1947-06-30 Polish Labor Group Poland Fights" " 29 East 7th Street   New York NY  
216 1943-10-15 1945-07-31 Malinowski, Wladyslaw R.   55 West 42nd Street   New York NY  
217 1943-10-23 1946-10-31 Adamczyk, Alojzy   50 Broad Street Room 1711 New York NY 11552
218 1943-10-25 1946-05-01 France Amerique Corporation   730 Fifth Avenue   New York NY  
219 1943-10-29 1943-10-29 Min Joong Dai Hoi Korean People's Convention 1415 West 37th Street   Los Angeles CA  
220 1943-11-01 1944-11-01 Birdwell, Russell J.   30 Rockefeller Plaza   New York NY  
221 1943-10-30 1944-04-30 Haagens, Gerard E.   597 Fifth Avenue   New York NY  
222 1943-12-01 1944-06-01 Derso & Kelen   144 East 24th Street   New York NY  
223 1943-12-02 1957-12-31 Agence France-Presse (France-Presse News Agency)   50 Rockefeller Plaza   New York NY 10020
224 1943-12-11 1945-10-01 Baker, Harold G.   44 Whitehall Street   New York NY  
226 1943-12-18 1945-06-18 Kolonia, Peter V.   1530 - 16th Street, N.W.   Washington DC  
227 1943-12-23 1946-09-30 Super, Paul   Room 705 347 Madison Avenue New York NY 10012
228 1944-01-01 1944-01-01 Auersperg, Hilda Heriot   1 East 57th Street   New York NY  
229 1944-01-08 1944-06-30 Netherland-American Foundation, Inc.   10 Rockefeller Plaza   New York NY  
230 1944-01-29 1944-01-29 De Lozada, Enrique S.   Bolivian Embassy Investment Building (1119) Washington DC  
232 1944-01-29 1949-07-29 De Irala, Antonio   30 Fifth Avenue   New York NY  
233 1944-02-07 1944-03-03 Chinel, Fernando Iturralde   Invest. Bldg./Bolivian Embassy 15th & K Streets, Room 1119 Washington DC  
234 1944-07-06 1950-07-06 Mexican Chamber of Commerce of the U.S., Inc.   60 Wall Street   New York NY  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);