FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1,461 rows where Zip = "" sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Registration_Date (date), Termination_Date (date)
State >30
City >30
- New York 540
- Washington 298
- Miami 46
- London 41
- Chicago 26
- Los Angeles 18
- San Juan 15
- Brooklyn 14
- San Francisco 14
- Hamilton, Ontario 13
- Boston 11
- Ontario 11
- Toronto, Ontario 11
- New Orleans 8
- Long Island 7
- Tokyo 7
- - 6
- Cleveland 6
- Dhahran 6
- Havana 6
- Philadelphia 6
- Detroit 5
- Hollywood 5
- London, England 5
- Milwaukee 5
- Montreal, Quebec 5
- Phnom Penh 5
- Port-au-Prince 5
- Santurce 5
- Bronx 4
- …
Address_1 >30
- 503 Queen Street, East 8
- Corporation of Lloyd's 8
- 1330 Burlington Street, East 7
- 247 Park Avenue 7
- 45 East 17th Street 6
- 50 Rockefeller Plaza 6
- Embassy of Japan 6
- - 5
- 1028 Connecticut Avenue, N.W. 5
- 11 Riverside Drive 5
- 1706 - 18th Street, N.W. 5
- 2112 Massachusetts Avenue, NW 5
- 225 West 34th Street 5
- 30 Fifth Avenue 5
- 30 Rockefeller Plaza 5
- 316 West 79th Street 5
- 39 Broadway 5
- 551 Fifth Avenue 5
- 575 Lexington Avenue 5
- Lloyd's 5
- 1025 Connecticut Avenue, N.W. 4
- 120 East 56th Street 4
- 17 Battery Place 4
- 250 West 57th Street 4
- 29 Broadway 4
- 44 Whitehall Street 4
- 477 Madison Avenue 4
- 55 Liberty Street 4
- 55 West 42nd Street 4
- 60 East 42nd Street 4
- …
Registration_Number | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 ▼ | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
2 | 1942-07-03 | 1945-07-01 | Garcia-Rubiera, Marcelino | 17 Battery Place | New York | NY | |||
3 | 1942-07-03 | 1942-07-03 | Lawrence, William S. | 1438 Midland Building | Cleveland | OH | |||
4 | 1942-07-03 | 1943-07-03 | Auten, Harold | 152 West 42nd Street | New York | NY | |||
5 | 1942-07-06 | 1946-07-06 | De La Sota y Aburto, Manuel | 30 Fifth Avenue | New York | NY | |||
6 | 1942-07-06 | 1951-09-11 | Black, Helen | 15 West 44th Street | New York | NY | |||
8 | 1942-07-07 | 1942-07-07 | French National Railroads, New York | 610 Fifth Avenue | New York | NY | |||
9 | 1942-07-07 | 1943-01-15 | Finnish Information Center | Finnish Travel Information Bureau | 44 Whitehall Street | New York | NY | ||
11 | 1942-07-07 | 1949-01-07 | Pouschine, Ivan | 101 Downing Avenue | Long Island | NY | |||
12 | 1942-07-07 | 1942-07-07 | De La Sota y Macmahon, Ramon | 30 Fifth Avenue | New York | NY | |||
14 | 1942-07-08 | 1943-07-08 | Lipsett, Alexander S. | 18 East 41st Street | New York | NY | |||
16 | 1942-07-08 | 1946-01-08 | Garcia & Diaz | 17 Battery Place | New York | NY | |||
17 | 1942-07-08 | 1950-12-11 | Gotham Advertising Company | 2 West 46th Street | New York | NY | |||
18 | 1942-07-08 | 1942-07-08 | Marx, Karl T. | 215 West 23rd Street | New York | NY | |||
19 | 1942-07-08 | 1943-01-08 | H.A. Bruno & Associates | 30 Rockefeller Plaza | New York | NY | |||
20 | 1942-07-08 | 1946-02-28 | Haberman, Roberto | 1 East 42nd Street | New York | NY | |||
23 | 1942-07-09 | 1946-07-09 | Haan, Kilsoo Kenneth | 101 D Street, N.E. | Washington | DC | |||
25 | 1942-07-09 | 1943-03-30 | Arroyo, Julian Avelino | 220 Fifth Avenue | New York | NY | |||
26 | 1942-07-09 | 1942-07-09 | Chang, Kee Young | 1766 Hobart Street, N.W. | Washington | DC | |||
28 | 1942-07-09 | 1942-07-09 | Spanish Library of Information | 2 East 34th Street | New York | NY | |||
29 | 1942-07-09 | 1943-07-26 | Carpenter, Charles M. | 60 Broadway | New York | NY | |||
32 | 1942-07-24 | 1946-12-07 | Syrian National Party in the U.S. | 216 Harrison Avenue | Boston | MA | |||
33 | 1942-07-10 | 1945-01-10 | Luehne Jr., John H. | 7743 South Colfax Avenue | Chicago | IL | |||
34 | 1943-03-03 | 1961-02-03 | Caples Company | 216 East Ontario Street | Chicago | IL | |||
35 | 1942-07-10 | 1943-07-10 | Franklin, Emilio | 19 Rector Street | New York | NY | |||
37 | 1942-07-11 | 1946-12-01 | Newfoundland Government Information Bureau | 620 Fifth Avenue | New York | NY | |||
38 | 1942-07-11 | 1945-05-23 | Arnaz y Alberni, Desiderio | 338 East Flagler Street | Miami | FL | |||
40 | 1942-07-11 | 1942-07-11 | Ardois, Luis Fernandez | 336 East Flagler Street | Miami | FL | |||
43 | 1942-07-13 | 1943-03-16 | Gassner, Josef Hieronymus | St. Gregory's College | Shawnee | OK | |||
44 | 1942-07-13 | 1943-04-01 | Ploechl, Willibald Maria | 1915 Kalorama Road, N.W. | Washington | DC | |||
46 | 1942-07-15 | 1963-09-18 | Law Jr., Robert H. | 450 North Broadway | White Plains | NY | |||
49 | 1942-07-15 | 1946-01-15 | Dutch Central Transport Workers' Union | (See Reg. No. 48) | 5 Beekman Street | New York | NY | ||
50 | 1942-07-16 | 1942-07-16 | Musa, John L. | 112 West 59th Street | New York | NY | |||
51 | 1942-07-16 | 1943-03-15 | Jules-Bois, Henri Antoine | 1580 Amsterdam Avenue | New York | NY | |||
52 | 1942-07-16 | 1946-06-15 | Glesinger, Egon | 3816 - 49th Street, N.W. | Washington | DC | |||
56 | 1942-07-20 | 1946-07-27 | Haight, Griffin, Deming & Gardner | 80 Broad Street | New York | NY | |||
58 | 1942-07-21 | 1943-07-21 | Olaussen, Alf M. | 44 Whitehall Street | Manhattan | NY | |||
62 | 1942-07-27 | 1960-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | |||
63 | 1942-07-27 | 1943-07-27 | Chung, Woonsoo | 1766 Hobart Street, N.W. | Washington | DC | |||
64 | 1942-07-27 | 1942-12-31 | Brown, Howard C. | 6404 Sunset Boulevard | Hollywood | CA | |||
66 | 1942-07-27 | 1942-07-27 | Anchor Line, Ltd. | 12-14 St. Vincent Place | Glasgow | ||||
67 | 1942-07-27 | 1942-07-27 | French Information Center, Inc. | 610 Fifth Avenue | New York | NY | |||
69 | 1942-07-28 | 1946-06-30 | Swedish Industries Fund, Inc. | 630 Fifth Avenue | New York | NY | |||
71 | 1942-07-30 | 1975-07-30 | Kelly, Nason, Inc. | 247 Park Avenue | New York | NY | |||
72 | 1942-07-30 | 1943-01-30 | Kelly, John C. | 247 Park Avenue | New York | NY | |||
73 | 1942-07-30 | 1947-01-30 | Koren, Louis | 515-1/2 East 118th Street | New York | NY | |||
74 | 1942-08-01 | 1942-08-01 | Ramsay, Johan V.V. | 230 Park Avenue | New York | NY | |||
76 | 1942-08-01 | 1943-07-31 | Nagorski, Bohdan | British Ministry of War Transport | 25 Broadway | New York | NY | ||
77 | 1942-08-01 | 1943-02-01 | Pan-American Associated Enterprises | 505 Fifth Avenue | New York | NY | |||
79 | 1942-08-03 | 1952-02-03 | China Institute in America, Inc. | 125 East 65th Street | New York | NY | |||
82 | 1942-08-05 | 1943-02-15 | Krier-Becker, Lily | 235 West End Avenue | New York | NY | |||
83 | 1942-08-07 | 1945-09-15 | Catalan National Council (U.S. Delegation) | 239 West 14th Street | New York | NY | |||
84 | 1942-08-07 | 1946-08-07 | British Empire Chamber of Commerce in the U.S.A., Inc. | 587 Fifth Avenue | New York | NY | |||
85 | 1942-08-07 | 1944-03-31 | Lazell, Reverend J. Arthur | 55 West 42nd Street | New York | NY | |||
86 | 1942-08-07 | 1945-11-14 | American Friends of Polish Democracy | 55 West Street | New York | NY | |||
88 | 1942-08-11 | 1946-08-11 | Ratzer & Bridge | 311 South Spring Street | Los Angeles | CA | |||
95 | 1942-08-14 | 1943-03-11 | Jordan, H.A. | 2 Rector Street | New York | NY | |||
96 | 1942-08-14 | 1945-02-14 | Bernard Preyer Company | 17 John Street | New York | NY | |||
98 | 1942-08-17 | 1953-05-17 | Powers, Horace H. | Railroad Terminal Building | St. Albans | VT | |||
99 | 1942-08-17 | 1943-02-17 | Ryan, Askren & Mathewson | 545 Henry Building | Seattle | WA | |||
105 | 1942-08-25 | 1946-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | ||||
106 | 1942-08-25 | 1949-02-25 | Gross Jr., Frank J. | 779 North Water Street | Milwaukee | WI | |||
108 | 1942-08-26 | 1947-02-26 | Drucker, David | 6 East 45th Street | New York | NY | |||
109 | 1942-08-28 | 1945-03-25 | De Bisschop, Eric | 158 Dowsett Avenue | Honolulu | HI | |||
111 | 1942-09-01 | 1943-10-07 | American Chapter of the Religious Emergency Council | 55 Leonard Street | New York | NY | |||
112 | 1942-08-20 | 1943-02-20 | Ghiloni, Alfred R. | 7 Park Square | Boston | MA | |||
113 | 1942-08-20 | 1943-02-20 | Ghiloni, Alfred R. | 7 Park Square | Boston | MA | |||
114 | 1942-08-20 | 1942-08-20 | Ghiloni, Alfred R. | 7 Park Square | Boston | MA | |||
115 | 1942-09-09 | 1942-09-09 | Mendez, Cristina | 2 East 34th Street | New York | NY | |||
117 | 1942-09-09 | 1942-09-09 | Orta, Pilar | 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 | |||
123 | 1942-09-14 | 1964-02-26 | Union Nacional Sinarquista | 7245 -1/2 Dale Road #15 | El Paso | ||||
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 | |||
131 | 1942-09-14 | 1947-03-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | |||
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 | |||
141 | 1942-10-15 | 1942-10-15 | D'Aumale, Claude | 50 Rockefeller Plaza | New York | NY | |||
144 | 1942-10-19 | 1946-04-19 | Shands, Richard E. | Shoreham Building | Washington | DC | |||
147 | 1942-10-23 | 1944-10-23 | Goldfinger, William | 55 East Mosholu Parkway, North | Bronx | NY | |||
152 | 1942-11-04 | 1943-05-04 | Moraru, Glicherie | 2734 Holly Avenue | Dearborn | MI | |||
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 | |||
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 | |||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]) );