FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
42,460 rows sorted by Short_Form_Date
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Zip >30 ✖
- 20036 4,031
- - 3,820
- 10022 2,689
- 10017 2,685
- 20006 2,561
- 20005 1,887
- 20004 1,080
- 10020 912
- 60606 626
- 20037 607
- 10019 571
- 20001 485
- 10018 480
- 20001-3743 462
- 20007 433
- 10020-2102 417
- 10036-2787 413
- 20005-3544 411
- 10013 405
- 60601 400
- 10016 355
- 10036 352
- 20037-1350 335
- 20003 332
- 20044-0407 327
- 10010 286
- 10005 280
- 66204 274
- 22314 234
- 10021 222
- …
State >30
Short_Form_Termination_Date >30 ✖
- - 2,494
- 1995-12-31 145
- 1971-10-29 122
- 2005-12-31 105
- 2014-12-31 97
- 1988-12-31 95
- 2017-12-31 95
- 2013-06-30 90
- 1957-12-31 87
- 2009-09-30 85
- 1977-08-31 81
- 1995-05-31 81
- 1991-12-31 80
- 2017-03-30 78
- 2007-12-31 77
- 2016-01-01 77
- 1990-11-09 76
- 2019-12-31 75
- 1990-01-25 73
- 1960-03-07 72
- 1972-08-29 70
- 1992-07-23 70
- 1998-04-30 70
- 2016-12-31 68
- 2020-12-31 67
- 1980-12-31 62
- 1987-12-31 62
- 1997-12-31 61
- 2021-12-31 60
- 2011-12-31 59
- …
Registration_Number >30
- Hill and Knowlton Strategies, LLC 990
- Daniel J. Edelman, Inc. 573
- JETRO, New York 490
- Arnold & Porter Kaye Scholer LLP 462
- Quebec Government Office 417
- White & Case, LLP 413
- Burson-Marsteller 411
- KOTRA 358
- Squire Patton Boggs, LLP 335
- Amtorg Trading Corporation 331
- Squire, Sanders & Dempsey, L.L.P. 327
- QORVIS LLC 305
- Ruder Finn, Inc. 300
- Ogilvy Public Relations Worldwide 299
- Daniel J. Edelman, Inc. 297
- DLA Piper US LLP 273
- Akin, Gump, Strauss, Hauer & Feld, LLP 271
- Netherlands Chamber of Commerce in the U.S., Inc. 238
- Commonwealth of Dominica Maritime Registry, Inc. 213
- British Information Services 211
- Bahamas Tourist Office 205
- Singapore Economic Development Board 199
- JETRO, Chicago 196
- Fleishman-Hillard, Inc. 191
- GCI Group, Inc. 186
- JETRO, Los Angeles 184
- MMGY Global, LLC 182
- Ketchum Inc. NY 175
- IPG DXTRA, Inc 156
- Cleary, Gottlieb, Steen & Hamilton, LLP 155
- …
Registrant_Name >30
- Hill and Knowlton Strategies, LLC 990
- Daniel J. Edelman, Inc. 886
- JETRO, New York 490
- Arnold & Porter Kaye Scholer LLP 462
- Burson-Marsteller 417
- Quebec Government Office 417
- White & Case, LLP 413
- Ruder Finn, Inc. 375
- KOTRA 358
- Squire Patton Boggs, LLP 335
- Amtorg Trading Corporation 331
- Squire, Sanders & Dempsey, L.L.P. 327
- Fleishman-Hillard, Inc. 311
- QORVIS LLC 305
- Ogilvy Public Relations Worldwide 299
- DLA Piper US LLP 273
- Akin, Gump, Strauss, Hauer & Feld, LLP 271
- Netherlands Chamber of Commerce in the U.S., Inc. 238
- Commonwealth of Dominica Maritime Registry, Inc. 213
- British Information Services 211
- Bahamas Tourist Office 205
- Singapore Economic Development Board 199
- JETRO, Chicago 196
- APCO Worldwide, Inc. 188
- GCI Group, Inc. 186
- JETRO, Los Angeles 184
- MMGY Global, LLC 182
- Ketchum Inc. NY 175
- IPG DXTRA, Inc 156
- Cleary, Gottlieb, Steen & Hamilton, LLP 155
- …
City >30
- Washington 16,070
- New York 14,948
- Chicago 1,478
- Los Angeles 1,153
- San Francisco 514
- Miami 450
- St. Louis 381
- Houston 338
- Arlington 303
- Alexandria 287
- Overland Park 274
- Boston 216
- Fairhaven 213
- Cambridge 207
- Nassau 205
- New York 190
- Seattle 190
- Philadelphia 180
- Atlanta 165
- London 119
- Silver Spring 112
- Bethesda 111
- Denver 102
- Jamaica 98
- Reston 96
- Bannockburn 95
- Austin 89
- Dallas 76
- Petaluma 67
- Detroit 66
- …
Address_1 >30 ✖
- 1111 19th Street NW 990
- One Rockefeller Plaza 679
- 111 North Canal Street 575
- 565 Fifth Avenue 508
- 601 Massachusetts Avenue, NW 462
- 1155 Avenue of the Americas 413
- 1110 Vermont Avenue, NW, 12th Floor 411
- 460 Park Avenue 401
- 1201 Pennsylvania Avenue, N.W. 364
- 2550 M Street, NW 355
- 15 West 36th Street 331
- 200 North Broadway 311
- 1201 Connecticut Avenue, NW 307
- 1111 19th Street, NW 303
- 2001 K Street, NW 300
- 301 East 57th Street 300
- 250 Hudson Street 297
- 50 Rockefeller Plaza 274
- 7309 W. 80th Street 274
- 500 8th Street, NW 273
- 825 Third Avenue 237
- 630 Fifth Avenue 230
- 32 Washington Street 213
- 845 Third Avenue 213
- 1285 Avenue of the Americas 211
- Ministry of Tourism 205
- 55 East 59th Street 199
- 1 East Wacker Drive 196
- 700 - 13th Street, N.W. 185
- 777 South Figueroa Street 184
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 | ||||
2 | 2 | DEACERO S.A.P.I. de C.V. (DEACERO) 7013 | 2021-09-07 | DEACERO S.A.P.I. de C.V. (DEACERO) | Lazaro Cardenas 2333, Zona Loma Larga Oriente | San Pedro Garza Garcia | San Pedro | ||||||
3 | 3 | Hyperfocal Communications, LLC 7267 | 2023-05-05 | Hyperfocal Communications, LLC | 633 Pennsylvania Avenue, NW | Washington | DC | 20004 | |||||
4 | 4 | Amores | Laura | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
5 | 5 | Amores | Laura | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
6 | 6 | Borsting | Elizabeth | Development Counsellors International 4777 | 1993-03-12 | Development Counsellors International | 215 Park Avenue South | 14th Floor | New York | NY | 10003 | ||
7 | 7 | Chiang | Yu-Jung | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
8 | 8 | Cornacchio | Steven | Scribe Strategies & Advisors, Inc. 6305 | 2015-07-20 | Scribe Strategies & Advisors, Inc. | 1050 Connecticut Avenue, NW | Suite 500 | Washington | DC | 20036 | ||
9 | 9 | Cornacchio | Steven | Scribe Strategies & Advisors, Inc. 6305 | 2015-07-20 | Scribe Strategies & Advisors, Inc. | 1050 Connecticut Avenue, NW | Suite 500 | Washington | DC | 20036 | ||
10 | 10 | Cushman | Deborah | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | 1100 G Street, NW | Suite 750 | Washington | DC | 20005 | ||
11 | 11 | Davis | Paige | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | 1100 G Street, NW | Suite 750 | Washington | DC | 20005 | ||
12 | 12 | Ferguson | Jacob J | Ott, Bielitzki & O'Neill PLLC 6573 | 2018-07-20 | Ott, Bielitzki & O'Neill PLLC | 1629 K Street, NW | Suite 300 | Washington | DC | 20006 | ||
13 | 13 | Foote | Melvin P. | Musolino and Dessel, PLLC 7101 | 2022-03-21 | Musolino and Dessel, PLLC | 1615 L Street Northwest | Suite 440 | Washington | DC | 20036 | ||
14 | 14 | Gross | Hannah | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | 1100 G Street, NW | Suite 750 | Washington | DC | 20005 | ||
15 | 15 | Hanover | Kurt | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
16 | 16 | Hanover | Kurt | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
17 | 17 | Harwood | Stephanie Romina | Representative of German Industry and Trade 4274 | 1989-07-21 | Representative of German Industry and Trade | 1130 Connecticut Avenue, NW | Suite 1200 | Washington | DC | 20036 | ||
18 | 18 | Jones | Laura | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
19 | 19 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
20 | 20 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
21 | 21 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
22 | 22 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
23 | 23 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
24 | 24 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
25 | 25 | Kramer | Steve | Friedlander Consulting Group LLC 7009 | 2021-09-03 | Friedlander Consulting Group LLC | 1227 44th Street | Brooklyn | NY | 11219 | |||
26 | 26 | Lycos | Jessica | Friedlander Consulting Group LLC 7009 | 2021-09-03 | Friedlander Consulting Group LLC | 1227 44th Street | Brooklyn | NY | 11219 | |||
27 | 27 | Magnus | Laura | Friedlander Consulting Group LLC 7009 | 2021-09-03 | Friedlander Consulting Group LLC | 1227 44th Street | Brooklyn | NY | 11219 | |||
28 | 28 | Maponyane | Sebolaishim Lisbeth | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 | ||
29 | 29 | McAtee | Brett | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
30 | 30 | McAtee | Brett | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
31 | 31 | McConaha | Joshua | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | 1100 G Street, NW | Suite 750 | Washington | DC | 20005 | ||
32 | 32 | McMahon | Thomas | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | 1100 G Street, NW | Suite 750 | Washington | DC | 20005 | ||
33 | 33 | Musolino | Philip M. | Musolino and Dessel, PLLC 7101 | 2022-03-21 | Musolino and Dessel, PLLC | 1615 L Street Northwest | Suite 440 | Washington | DC | 20036 | ||
34 | 34 | Nehrin | Ranziba | Nuclear Waste Management Organization 7186 | 2022-10-14 | Nuclear Waste Management Organization | 22 St. Clair Avenue East, 4th Floor | Toronto | Ontario | ||||
35 | 35 | Newton | Sienna | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
36 | 36 | Newton | Sienna | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
37 | 37 | Prendergast | Olivia | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | |||
38 | 38 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
39 | 39 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
40 | 40 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
41 | 41 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
42 | 42 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
43 | 43 | Raffaelli | John D. | Mohamed, Koshin A. 5653 | 2004-10-26 | Mohamed, Koshin A. | 1215 Central Avenue South | Suite 215 | Kent | WA | 98032-7437 | ||
44 | 44 | Segebre | Nicole Zaidan | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | 1100 G Street, NW | Suite 750 | Washington | DC | 20005 | ||
45 | 45 | Sewton | Sienna | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
46 | 46 | Simpkins | Gregory | BW GLOBAL GROUP, LLC. 6935 | 2021-03-10 | BW GLOBAL GROUP, LLC. | 1239 Beverly Road | McLean | VA | 22101 | |||
47 | 47 | Stern | Cara Morris | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | 1100 G Street, NW | Suite 750 | Washington | DC | 20005 | ||
48 | 48 | Szlavik | Joseph | Musolino and Dessel, PLLC 7101 | 2022-03-21 | Musolino and Dessel, PLLC | 1615 L Street Northwest | Suite 440 | Washington | DC | 20036 | ||
49 | 49 | Vale | Edward | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | 1100 G Street, NW | Suite 750 | Washington | DC | 20005 | ||
50 | 50 | Vega | Rebecca | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
51 | 51 | Vitolo | Alvaro | Visit Mexico USA, LLC 7184 | 2022-10-12 | Visit Mexico USA, LLC | 444 Madison Avenue | Suite 300 | New York | NY | 10022 | ||
3500 | 3500 | 2015-01-09 | Foley | Joe | Foley Federal & International Affairs 6239 | 2014-08-05 | Foley Federal & International Affairs | P.O. Box 61303 | Potomac | MD | 20859 | ||
9532 | 9532 | 2014-03-09 | Echeverri | Olga Lucia Lopez | Mira Movimiento Politico Inc. 5676 | 2005-03-23 | Mira Movimiento Politico Inc. | 1440 Coral Ridge Drive | #102 | Coral Springs | FL | 33071 | |
13490 | 13490 | 2015-04-15 | Duncan III | James Robert | Cadwalader, Wickersham & Taft, LLP 6221 | 2014-05-15 | Cadwalader, Wickersham & Taft, LLP | 200 Liberty Street | New York | NY | 10281 | ||
13491 | 13491 | 2015-04-15 | Gerver | Keith | Cadwalader, Wickersham & Taft, LLP 6221 | 2014-05-15 | Cadwalader, Wickersham & Taft, LLP | 200 Liberty Street | New York | NY | 10281 | ||
18153 | 18153 | 2016-05-31 | Telson | Natalie | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 | |
26120 | 26120 | 2015-08-06 | Brown | Paul | Prime Policy Group 6263 | 2014-11-14 | Prime Policy Group | 1110 Vermont Avenue, NW | Suite 1000 | Washington | DC | 20005 | |
26121 | 26121 | 2015-08-06 | Cosar | Yagmur | Prime Policy Group 6263 | 2014-11-14 | Prime Policy Group | 1110 Vermont Avenue, NW | Suite 1000 | Washington | DC | 20005 | |
26122 | 26122 | 2015-08-06 | Posner | Ralph | Prime Policy Group 6263 | 2014-11-14 | Prime Policy Group | 1110 Vermont Avenue, NW | Suite 1000 | Washington | DC | 20005 | |
26123 | 26123 | 2015-08-06 | Taylor | Owen | Prime Policy Group 6263 | 2014-11-14 | Prime Policy Group | 1110 Vermont Avenue, NW | Suite 1000 | Washington | DC | 20005 | |
34098 | 34098 | 2012-10-30 | Johnson | Lester | Washington Avenue International LLC 6135 | 2012-10-09 | Washington Avenue International LLC | 1701 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 | |
41738 | 41738 | 2011-12-31 | Williams | Salvatore A. | Salvatore Services, LLC 6012 | 2010-12-23 | Salvatore Services, LLC | 1641 Fifth Avenue | Pittsburgh | PA | 15219 | ||
42014 | 42014 | 2016-12-31 | Hawkins | Carly | Information Management Services, Inc. 6361 | 2016-06-17 | Information Management Services, Inc. | 1201 16th Street, NW | Suite 414 | Washington | DC | 20036 | |
25011 | 25011 | 2003-07-31 | 1900-01-07 | Lonie | David M. | Livingston-Solomon Group, L.L.C. 5352 | 2000-01-07 | Livingston-Solomon Group, L.L.C. | 499 South Capitol Street, S.W. | Suite 600 | Washington | DC | 20003 |
5739 | 5739 | 1984-02-01 | 1937-01-01 | de Pombo | Augusto | Colombian Government Tourist Office 1285 | 1959-10-12 | Colombian Government Tourist Office | 140 East 57th Street | New York | NY | 10022 | |
6184 | 6184 | 2002-02-05 | 1937-01-01 | Monegro | Oscar | Partido Reformista Social Cristiano 1687 | 1964-02-05 | Partido Reformista Social Cristiano | 3736 10th Avenue | Suite 9A | New York | NY | 10034 |
7896 | 7896 | 1982-02-28 | 1937-01-01 | Muchimba | Muuka L.M. | Zambia National Tourist Board 2293 | 1971-12-06 | Zambia National Tourist Board | 800 Second Avenue | Ninth Floor | New York | NY | 10017 |
10224 | 10224 | 1988-03-18 | 1937-01-01 | Dawson | John H. | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
13907 | 13907 | 1988-04-22 | 1937-01-01 | Riordan | John H. | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
19558 | 19558 | 1990-06-15 | 1937-01-01 | Fankell | Michael | Alsace Development International, Inc. 3506 | 1983-08-10 | Alsace Development International, Inc. | Chateau Kiener - 24 rue de Verdum | 68000 Colmar | |||
20629 | 20629 | 1949-06-30 | 1937-01-01 | Stubbs | Caro R. | Netherlands Information Service, New York 447 | 1947-03-14 | Netherlands Information Service, New York | 711 Third Avenue | New York | NY | 10017 | |
21078 | 21078 | 1988-06-30 | 1937-01-01 | III | Edgar F. Heiskell | Rose, Schmidt, Hasley, & DiSalle 2275 | 1971-08-24 | Rose, Schmidt, Hasley, & DiSalle | 1701 Pennsylvania Avenue, N.W. | Suite 1040 | Washington | DC | 20006-5808 |
25549 | 25549 | 1988-08-01 | 1937-01-01 | Zaprianov | Z. | Bulgarian Tourist Office 2148 | 1969-07-18 | Bulgarian Tourist Office | 161 East 86th Street | New York | NY | 10028 | |
34313 | 34313 | 1991-10-31 | 1937-01-01 | Chapman | David R. | New Zealand Government Tourist Office 2307 | 1972-01-17 | New Zealand Government Tourist Office | 10960 Wilshire Boulevard | Suite 1530 | Los Angeles | CA | 90024 |
36633 | 36633 | 1977-11-30 | 1937-01-01 | Prag | Per | Swedish Tourist Office 68 | 1942-07-27 | Swedish Tourist Office | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
39102 | 39102 | 1988-12-25 | 1937-01-01 | Essa | Aniis A. | Somaliland Republic Office 3640 | 1985-01-18 | Somaliland Republic Office | P.O. Box 90917 | Washington | DC | 20090 | |
39103 | 39103 | 1988-12-25 | 1937-01-01 | Hussein | Ahmed M. | Somaliland Republic Office 3640 | 1985-01-18 | Somaliland Republic Office | P.O. Box 90917 | Washington | DC | 20090 | |
39356 | 39356 | 1983-12-30 | 1937-01-01 | Sand | Levar | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
39362 | 39362 | 1985-12-30 | 1937-01-01 | Conradi | Trond | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
40305 | 40305 | 1985-12-31 | 1937-01-01 | Mulayantanda | Tasker B. | Zambia National Tourist Board 2293 | 1971-12-06 | Zambia National Tourist Board | 800 Second Avenue | Ninth Floor | New York | NY | 10017 |
40345 | 40345 | 1986-12-31 | 1937-01-01 | Kabemba | John T. | Zambia National Tourist Board 2293 | 1971-12-06 | Zambia National Tourist Board | 800 Second Avenue | Ninth Floor | New York | NY | 10017 |
9869 | 9869 | 1943-03-15 | 1942-01-16 | Jules-Bois | Henri Antoine | Jules-Bois, Henri Antoine 51 | 1942-07-16 | Jules-Bois, Henri Antoine | 1580 Amsterdam Avenue | New York | NY | ||
22661 | 22661 | 1942-07-07 | 1942-07-07 | Lejeune | Hubert | French National Railroads, New York 8 | 1942-07-07 | French National Railroads, New York | 610 Fifth Avenue | New York | NY | ||
3383 | 3383 | 1943-01-08 | 1942-07-08 | Bruno | Harry A. | H.A. Bruno & Associates 19 | 1942-07-08 | H.A. Bruno & Associates | 30 Rockefeller Plaza | New York | NY | ||
3384 | 3384 | 1943-01-08 | 1942-07-08 | Gudgeon | Russell D. | H.A. Bruno & Associates 19 | 1942-07-08 | H.A. Bruno & Associates | 30 Rockefeller Plaza | New York | NY | ||
32428 | 32428 | 1946-10-08 | 1942-07-08 | Alvarez | Victor | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | 17 Battery Place | New York | NY | ||
32429 | 32429 | 1946-10-08 | 1942-07-08 | Diaz | Manuel | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | 17 Battery Place | New York | NY | ||
32430 | 32430 | 1946-10-08 | 1942-07-08 | Garcia | Marcelino | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | 17 Battery Place | New York | NY | ||
38068 | 38068 | 1950-12-11 | 1942-07-08 | Harris | George Ellsworth | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | 2 West 46th Street | New York | NY | ||
38069 | 38069 | 1950-12-11 | 1942-07-08 | Hildebrant | W.G. | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | 2 West 46th Street | New York | NY | ||
38070 | 38070 | 1950-12-11 | 1942-07-08 | Kron | Arthur Adam | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | 2 West 46th Street | New York | NY | ||
38071 | 38071 | 1950-12-11 | 1942-07-08 | Menkel | William | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | 2 West 46th Street | New York | NY | ||
38072 | 38072 | 1950-12-11 | 1942-07-08 | Myers | Frank C. | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | 2 West 46th Street | New York | NY | ||
38073 | 38073 | 1950-12-11 | 1942-07-08 | Sutphen | Duncan Dunbar , Jr. | Gotham Advertising Company 17 | 1942-07-08 | Gotham Advertising Company | 2 West 46th Street | New York | NY | ||
22804 | 22804 | 1942-07-09 | 1942-07-09 | de Ayala | Javier Gaytan | Spanish Library of Information 28 | 1942-07-09 | Spanish Library of Information | 2 East 34th Street | New York | NY | ||
8605 | 8605 | 1946-03-01 | 1942-07-27 | Rousselle | Pierre | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
9675 | 9675 | 1945-03-12 | 1942-07-27 | de Linclays | Henri Morin | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
19262 | 19262 | 1945-06-12 | 1942-07-27 | Simon | Georges C. | Compagnie Generale Transatlantique (French Line) 62 | 1942-07-27 | Compagnie Generale Transatlantique (French Line) | 17 State Street | New York | NY | ||
24122 | 24122 | 1942-07-27 | 1942-07-27 | Atkins | Leslie C. | Anchor Line, Ltd. 66 | 1942-07-27 | Anchor Line, Ltd. | 12-14 St. Vincent Place | Glasgow | |||
24123 | 24123 | 1942-07-27 | 1942-07-27 | Hanssler | John A. | Anchor Line, Ltd. 66 | 1942-07-27 | Anchor Line, Ltd. | 12-14 St. Vincent Place | Glasgow |
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]) );