FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where Short_Form_Last_Name = "Shaw"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 23
- Bermuda Tourism Authority 2
- Junta Nacional De Turismo De Panama E Informacion 1
- Express Trading Corporation 1
- University Travel Company 1
- Shaw, Pittman, Potts & Trowbridge 1
- Selvage & Lee, Inc. 1
- Unicorp International, Inc. 1
- Peter Martin Associates, Inc. 1
- Christian League of Southern Africa 1
- Scottish Enterprise 1
- Jamaica National Investment Promotion, Ltd. 1
- Hill and Knowlton Strategies, LLC 1
- Neill, Mullenholz, Shaw & Seeger 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- IPG DXTRA, Inc 1
- Miner, Fraser & Gabriel Public Affairs, Inc. 1
- Dyer, Ellis & Joseph, P.C. 1
- CMG Communications, L.L.C. 1
- Fonte, Michael Joseph 1
- McKenna Long & Aldridge, LLP 1
- Fleishman-Hillard, Inc. 1
- Taiwan Democratic Progressive Party Mission in the U.S. 1
- BCW LLC 1
Registrant_Name 23
- Bermuda Tourism Authority 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- BCW LLC 1
- CMG Communications, L.L.C. 1
- Christian League of Southern Africa 1
- Dyer, Ellis & Joseph, P.C. 1
- Express Trading Corporation 1
- Fleishman-Hillard, Inc. 1
- Fonte, Michael Joseph 1
- Hill and Knowlton Strategies, LLC 1
- IPG DXTRA, Inc 1
- Jamaica National Investment Promotion, Ltd. 1
- Junta Nacional De Turismo De Panama E Informacion 1
- McKenna Long & Aldridge, LLP 1
- Miner, Fraser & Gabriel Public Affairs, Inc. 1
- Neill, Mullenholz, Shaw & Seeger 1
- Peter Martin Associates, Inc. 1
- Scottish Enterprise 1
- Selvage & Lee, Inc. 1
- Shaw, Pittman, Potts & Trowbridge 1
- Taiwan Democratic Progressive Party Mission in the U.S. 1
- Unicorp International, Inc. 1
- University Travel Company 1
City 9
- Washington 9
- New York 7
- Cambridge 2
- Dallas 1
- Darien 1
- Long Island City 1
- Silver Spring 1
- St. Louis 1
- Sunnyside 0132 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
405 | 405 | 2022-02-15 | Shaw | Eliza | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
3448 | 3448 | 1996-01-08 | 1994-10-18 | Shaw | Jennifer Gay | Dyer, Ellis & Joseph, P.C. 4121 | 1988-03-21 | Dyer, Ellis & Joseph, P.C. | 600 New Hampshire Avenue, N.W. | Suite 1000 | Washington | DC | 20037 |
6698 | 6698 | 2010-02-12 | 2008-07-23 | Shaw | Lauren | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
7243 | 7243 | 1993-02-19 | 1947-07-03 | Shaw | Margaret Ackman | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
7690 | 7690 | 1973-02-26 | 1947-05-21 | Shaw | Margaret Ackman | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
8381 | 8381 | 2020-02-28 | 2019-04-10 | Shaw | Simon | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
9351 | 9351 | 1960-03-07 | 1959-04-16 | Shaw | Mary P. | University Travel Company 1218 | 1959-04-16 | University Travel Company | 18 Brattle Street | Cambridge | MA | ||
9508 | 9508 | 1979-03-09 | 1977-11-29 | Shaw | John F. | Unicorp International, Inc. 2818 | 1977-08-03 | Unicorp International, Inc. | 4835 LBJ Freeway | Suite 630 | Dallas | TX | 75234 |
12142 | 12142 | 2013-03-31 | 2011-11-23 | Shaw | Andrew R. | McKenna Long & Aldridge, LLP 5772 | 2006-10-03 | McKenna Long & Aldridge, LLP | 1900 K Street, NW | Washington | DC | 20006 | |
13116 | 13116 | 2021-04-10 | 2020-06-26 | Shaw | Steven | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
13616 | 13616 | 1975-04-17 | 1959-05-12 | Shaw | Brackley | Shaw, Pittman, Potts & Trowbridge 1226 | 1959-05-12 | Shaw, Pittman, Potts & Trowbridge | 910 - 17th Street, N.W. | Washington | DC | 20006 | |
17331 | 17331 | 1963-05-29 | 1961-12-29 | Shaw | Frederick W. , Jr. | Selvage & Lee, Inc. 1454 | 1961-05-29 | Selvage & Lee, Inc. | 500 Fifth Avenue | New York | NY | ||
19695 | 19695 | 2003-06-16 | 2001-04-26 | Shaw | Timothy C. | CMG Communications, L.L.C. 5129 | 1996-06-24 | CMG Communications, L.L.C. | 22 Thorndal Circle | 1st Floor | Darien | CT | 06820 |
20206 | 20206 | 1953-06-25 | 1951-07-30 | Shaw | Ernest L. | Express Trading Corporation 678 | 1951-06-25 | Express Trading Corporation | 27-18 - 40th Avenue | Long Island City | NY | ||
21047 | 21047 | 1985-06-30 | 1982-11-17 | Shaw | Alexander T. | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
27206 | 27206 | 1988-08-22 | 1988-03-11 | Shaw | Daniel A. | Miner, Fraser & Gabriel Public Affairs, Inc. 4022 | 1987-08-11 | Miner, Fraser & Gabriel Public Affairs, Inc. | 1025 Connecticut Avenue, N.W. | Suite 700 | Washington | DC | 20036 |
28585 | 28585 | 2013-08-31 | 2013-03-14 | Shaw | Sun-wen | Fonte, Michael Joseph 5514 | 2002-08-08 | Fonte, Michael Joseph | 8 Belmont Court | Silver Spring | MD | 20910 | |
31614 | 31614 | 2017-09-30 | 2013-09-06 | Shaw | Sun-wen | Taiwan Democratic Progressive Party Mission in the U.S. 6187 | 2013-09-06 | Taiwan Democratic Progressive Party Mission in the U.S. | 1455 Pennsylvania Avenue NW #439 | Washington | DC | 20004 | |
32574 | 32574 | 1986-10-10 | 1983-11-08 | Shaw | Audley F. | Jamaica National Investment Promotion, Ltd. 3216 | 1981-03-26 | Jamaica National Investment Promotion, Ltd. | 866 Second Avenue | 6th Floor | New York | NY | 10017 |
35210 | 35210 | 1985-11-04 | 1982-06-18 | Shaw | G. Jerry | Neill, Mullenholz, Shaw & Seeger 3384 | 1982-06-18 | Neill, Mullenholz, Shaw & Seeger | 900 - 17th Street, N.W. | 4th Floor | Washington | DC | 20006 |
37367 | 37367 | 1982-12-01 | 1977-11-15 | Shaw | Jill | Peter Martin Associates, Inc. 2846 | 1977-11-15 | Peter Martin Associates, Inc. | 770 Lexington Avenue | New York | NY | 10021 | |
39061 | 39061 | 1990-12-24 | 1988-04-11 | Shaw | Neil M. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
39546 | 39546 | 1956-12-31 | 1952-02-18 | Shaw | Stanley Frank | Junta Nacional De Turismo De Panama E Informacion 451 | 1947-04-09 | Junta Nacional De Turismo De Panama E Informacion | Empire State Building | 350 Fifth Avenue, Room 6304 | New York | NY | |
40196 | 40196 | 1981-12-31 | 1978-09-15 | Shaw | Frederick R. E. | Christian League of Southern Africa 2957 | 1978-09-15 | Christian League of Southern Africa | Post Office 28507 | Sunnyside 0132 |
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]) );