FARA_All_Registrants_fts
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6,717 rows
This data as json, CSV (advanced)
Link | rowid ▼ | Name | Address_1 | Address_2 | FARA_All_Registrants_fts | rank |
---|---|---|---|---|---|---|
1 | 1 | Estrangin, Gustave Fritsch | 50 Rockefeller Plaza | Room 523 | 80162 | |
2 | 2 | Garcia-Rubiera, Marcelino | 17 Battery Place | 80162 | ||
3 | 3 | Lawrence, William S. | 1438 Midland Building | 80162 | ||
4 | 4 | Auten, Harold | 152 West 42nd Street | 80162 | ||
5 | 5 | De La Sota y Aburto, Manuel | 30 Fifth Avenue | 80162 | ||
6 | 6 | Black, Helen | 15 West 44th Street | 80162 | ||
7 | 7 | Christensen, Valdemar Emil | 116 Broad Street | Room 71 | 80162 | |
8 | 8 | French National Railroads, New York | 610 Fifth Avenue | 80162 | ||
9 | 9 | Finnish Information Center | 44 Whitehall Street | 80162 | ||
10 | 10 | Ramo, Herman Rudolf Kristian | Finnish Information Center | 44 Whitehall Street | 80162 | |
11 | 11 | Pouschine, Ivan | 101 Downing Avenue | 80162 | ||
12 | 12 | De La Sota y Macmahon, Ramon | 30 Fifth Avenue | 80162 | ||
13 | 13 | Swedish-American Chamber of Commerce, Inc. | 250 Park Avenue | 80162 | ||
14 | 14 | Lipsett, Alexander S. | 18 East 41st Street | 80162 | ||
16 | 16 | Garcia & Diaz | 17 Battery Place | 80162 | ||
17 | 17 | Gotham Advertising Company | 2 West 46th Street | 80162 | ||
18 | 18 | Marx, Karl T. | 215 West 23rd Street | 80162 | ||
19 | 19 | H.A. Bruno & Associates | 30 Rockefeller Plaza | 80162 | ||
20 | 20 | Haberman, Roberto | 1 East 42nd Street | 80162 | ||
23 | 23 | Haan, Kilsoo Kenneth | 101 D Street, N.E. | 80162 | ||
24 | 24 | Jarvinen, Vilho Olavi | 751 Walton Avenue | Apartment 51A | 80162 | |
25 | 25 | Arroyo, Julian Avelino | 220 Fifth Avenue | 80162 | ||
26 | 26 | Chang, Kee Young | 1766 Hobart Street, N.W. | 80162 | ||
27 | 27 | LeRoy & Denslow | 530 Washington Building | 80162 | ||
28 | 28 | Spanish Library of Information | 2 East 34th Street | 80162 | ||
29 | 29 | Carpenter, Charles M. | 60 Broadway | 80162 | ||
30 | 30 | Blumenfeld, Kurt | 41 East 42nd Street | Room 2100 | 80162 | |
31 | 31 | Rosenbluth, Martin (Michael) | c/o United Palestine Appeal | 41 East 42nd Street | 80162 | |
32 | 32 | Syrian National Party in the U.S. | 216 Harrison Avenue | 80162 | ||
33 | 33 | Luehne Jr., John H. | 7743 South Colfax Avenue | 80162 | ||
34 | 34 | Caples Company | 216 East Ontario Street | 80162 | ||
35 | 35 | Franklin, Emilio | 19 Rector Street | 80162 | ||
37 | 37 | Newfoundland Government Information Bureau | 620 Fifth Avenue | 80162 | ||
38 | 38 | Arnaz y Alberni, Desiderio | 338 East Flagler Street | 80162 | ||
40 | 40 | Ardois, Luis Fernandez | 336 East Flagler Street | 80162 | ||
41 | 41 | Asensio, Jose' | Post Office Box 41 | Station North | 80162 | |
42 | 42 | Larsen-Heltborg, Arthur E. | 787 Lydia Street | Apartment #106 | 80162 | |
43 | 43 | Gassner, Josef Hieronymus | St. Gregory's College | 80162 | ||
44 | 44 | Ploechl, Willibald Maria | 1915 Kalorama Road, N.W. | 80162 | ||
45 | 45 | Knauth, Arnold Whitman | 60 East 42nd Street | Room 665 | 80162 | |
46 | 46 | Law Jr., Robert H. | 450 North Broadway | 80162 | ||
47 | 47 | De Agustin, Don Manuel | Hotel La Salle | 30 East 60th Street | 80162 | |
48 | 48 | Van Den Berge, Petrus Jacobus | Branch Office 21 | Pearl Street | 80162 | |
49 | 49 | Dutch Central Transport Workers' Union | 5 Beekman Street | 80162 | ||
50 | 50 | Musa, John L. | 112 West 59th Street | 80162 | ||
51 | 51 | Jules-Bois, Henri Antoine | 1580 Amsterdam Avenue | 80162 | ||
52 | 52 | Glesinger, Egon | 3816 - 49th Street, N.W. | 80162 | ||
53 | 53 | Lielnors, Harry W. | 92 Liberty Street | 80162 | ||
55 | 55 | Switzerland Tourism | 608 Fifth Avenue | 80162 | ||
56 | 56 | Haight, Griffin, Deming & Gardner | 80 Broad Street | 80162 | ||
57 | 57 | Banach, Francis-Louis Edward | Station West | Box 20 | 80162 | |
58 | 58 | Olaussen, Alf M. | 44 Whitehall Street | 80162 | ||
62 | 62 | Compagnie Generale Transatlantique (French Line) | 17 State Street | 80162 | ||
63 | 63 | Chung, Woonsoo | 1766 Hobart Street, N.W. | 80162 | ||
64 | 64 | Brown, Howard C. | 6404 Sunset Boulevard | 80162 | ||
66 | 66 | Anchor Line, Ltd. | 12-14 St. Vincent Place | 80162 | ||
67 | 67 | French Information Center, Inc. | 610 Fifth Avenue | 80162 | ||
68 | 68 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | 80162 | |
69 | 69 | Swedish Industries Fund, Inc. | 630 Fifth Avenue | 80162 | ||
70 | 70 | Swedish Information Service | 825 Third Avenue | 80162 | ||
71 | 71 | Kelly, Nason, Inc. | 247 Park Avenue | 80162 | ||
72 | 72 | Kelly, John C. | 247 Park Avenue | 80162 | ||
73 | 73 | Koren, Louis | 515-1/2 East 118th Street | 80162 | ||
74 | 74 | Ramsay, Johan V.V. | 230 Park Avenue | 80162 | ||
76 | 76 | Nagorski, Bohdan | 25 Broadway | 80162 | ||
77 | 77 | Pan-American Associated Enterprises | 505 Fifth Avenue | 80162 | ||
79 | 79 | China Institute in America, Inc. | 125 East 65th Street | 80162 | ||
80 | 80 | Larcegui, Francisco de S. | Hotel Lincoln | 8th Avenue & 44th Street | 80162 | |
81 | 81 | Gdynia American Line, Inc. | 115 Broadway | 80162 | ||
82 | 82 | Krier-Becker, Lily | 235 West End Avenue | 80162 | ||
83 | 83 | Catalan National Council (U.S. Delegation) | 239 West 14th Street | 80162 | ||
84 | 84 | British Empire Chamber of Commerce in the U.S.A., Inc. | 587 Fifth Avenue | 80162 | ||
85 | 85 | Lazell, Reverend J. Arthur | 55 West 42nd Street | 80162 | ||
86 | 86 | American Friends of Polish Democracy | 55 West Street | 80162 | ||
88 | 88 | Ratzer & Bridge | 311 South Spring Street | 80162 | ||
89 | 89 | Davis, Gerhold O. | C/O Di Tella Corporation | 40 Wall Street, Room 1439 | 80162 | |
90 | 90 | Markus, Johannes Ernst | Consulate General of Estonia | 9 Rockefeller Plaza | 80162 | |
91 | 91 | Jaakson, Ernst Rudolf | Consulate General of Estonia | 9 Rockefeller Plaza | 80162 | |
92 | 92 | Palcor Agency | C/O Henry Montor | 50 Union Square | 80162 | |
93 | 93 | Fountain, Joseph H. | Canadian National Railways | 673 Fifth Avenue | 80162 | |
94 | 94 | Four Continent Book Corporation | 149 Fifth Avenue | 80162 | ||
95 | 95 | Jordan, H.A. | 2 Rector Street | 80162 | ||
96 | 96 | Bernard Preyer Company | 17 John Street | 80162 | ||
97 | 97 | Gebhardt, H.A. | 705 Financial Center Building | 704 South Spring Street | 80162 | |
98 | 98 | Powers, Horace H. | Railroad Terminal Building | 80162 | ||
99 | 99 | Ryan, Askren & Mathewson | 545 Henry Building | 80162 | ||
101 | 101 | Recht, Charles | 10 East 40th Street | 80162 | ||
102 | 102 | Lu, David | National Press Building | Room 1151 | 80162 | |
103 | 103 | Artkino Pictures, Inc. | 410 East 62nd Street | 80162 | ||
105 | 105 | Canadian National Railways | 360 McGill Street | 80162 | ||
106 | 106 | Gross Jr., Frank J. | 779 North Water Street | 80162 | ||
107 | 107 | Latvian World Alliance | 92 Liberty Street | 80162 | ||
108 | 108 | Drucker, David | 6 East 45th Street | 80162 | ||
109 | 109 | De Bisschop, Eric | 158 Dowsett Avenue | 80162 | ||
110 | 110 | Arai, Yoneo | Yale University | Foreign Area Studies | 80162 | |
111 | 111 | American Chapter of the Religious Emergency Council | 55 Leonard Street | 80162 | ||
112 | 112 | Ghiloni, Alfred R. | 7 Park Square | 80162 | ||
113 | 113 | Ghiloni, Alfred R. | 7 Park Square | 80162 | ||
114 | 114 | Ghiloni, Alfred R. | 7 Park Square | 80162 | ||
115 | 115 | Mendez, Cristina | 2 East 34th Street | 80162 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [FARA_All_Registrants_fts] USING FTS5 ( [Name], [Address_1], [Address_2], content=[FARA_All_Registrants] );