FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where Short_Form_Termination_Date = "2000-06-30"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Termination_Date (date)
Registration_Number 16
- Smith, Dawson & Andrews, Inc. 6
- Shandwick Public Affairs, Inc. 4
- White & Case, LLP 2
- DLA Piper US LLP 2
- Gibney, Anthony & Flaherty, L.L.P. 2
- Oldaker & Harris, LLP 2
- KOTRA 1
- JETRO, San Francisco 1
- Tourism Authority of Thailand, New York 1
- Korea National Tourism Organization, New Jersey 1
- India Trade Promotion Organization 1
- Hill and Knowlton Strategies, LLC 1
- Al Paul Lefton Company, Inc. 1
- Wexler & Walker Public Policy Associates 1
- Shandwick USA, Inc. 1
- Carmen Group, Inc. 1
Registrant_Name 16
- Smith, Dawson & Andrews, Inc. 6
- Shandwick Public Affairs, Inc. 4
- DLA Piper US LLP 2
- Gibney, Anthony & Flaherty, L.L.P. 2
- Oldaker & Harris, LLP 2
- White & Case, LLP 2
- Al Paul Lefton Company, Inc. 1
- Carmen Group, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- India Trade Promotion Organization 1
- JETRO, San Francisco 1
- KOTRA 1
- Korea National Tourism Organization, New Jersey 1
- Shandwick USA, Inc. 1
- Tourism Authority of Thailand, New York 1
- Wexler & Walker Public Policy Associates 1
City 6
- Washington 17
- New York 7
- Bloomington 1
- Fort Lee 1
- Philadelphia 1
- San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21347 | 21347 | 2000-06-30 | 1999-01-12 | Feldman | Steven | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
21348 | 21348 | 2000-06-30 | 1980-01-21 | Wales | Gwynne H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21349 | 21349 | 2000-06-30 | 1997-01-30 | Boonchim | Manit | Tourism Authority of Thailand, New York 1897 | 1965-06-01 | Tourism Authority of Thailand, New York | 61 Broadway | Suite 2810 | New York | NY | 10006 |
21350 | 21350 | 2000-06-30 | 2001-02-14 | Kondes | Leah | Shandwick USA, Inc. 5315 | 1999-05-11 | Shandwick USA, Inc. | 8000 Norman Center Drive | Suite 400 | Bloomington | MN | 55437 |
21351 | 21351 | 2000-06-30 | 1998-03-26 | McLean | Charles D. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
21352 | 21352 | 2000-06-30 | 1980-03-28 | Lorotte | Rosine | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21353 | 21353 | 2000-06-30 | 1998-04-10 | Petrovich | Michelle Dietz | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
21354 | 21354 | 2000-06-30 | 2000-04-27 | Francis | Barbara Lynn | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
21355 | 21355 | 2000-06-30 | 1993-05-19 | Weintraub | Alan M. | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
21356 | 21356 | 2000-06-30 | 1993-05-19 | Zalaznick | Barry | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
21357 | 21357 | 2000-06-30 | 1999-05-21 | Chung | Won-Seo | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
21358 | 21358 | 2000-06-30 | 1995-06-02 | Jorge | Maria Fabiana | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
21359 | 21359 | 2000-06-30 | 1999-06-15 | Dodd | Abaigeal G. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
21360 | 21360 | 2000-06-30 | 2002-06-19 | Reed | Morgan | Oldaker & Harris, LLP 5406 | 2001-01-10 | Oldaker & Harris, LLP | 818 Connecticut Avenue, N.W. | Suite 1100 | Washington | DC | 20006 |
21361 | 21361 | 2000-06-30 | 2002-06-19 | Springer | David E. | Oldaker & Harris, LLP 5406 | 2001-01-10 | Oldaker & Harris, LLP | 818 Connecticut Avenue, N.W. | Suite 1100 | Washington | DC | 20006 |
21362 | 21362 | 2000-06-30 | 1999-06-29 | Masse | Jennifer J. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
21363 | 21363 | 2000-06-30 | 1998-07-15 | Saliba | Karl G. | Wexler & Walker Public Policy Associates 5265 | 1998-07-15 | Wexler & Walker Public Policy Associates | 1317 F Street, N.W. | Suite 600 | Washington | DC | 20004 |
21364 | 21364 | 2000-06-30 | 1999-08-18 | Hannaford | Peter D. | Carmen Group, Inc. 5320 | 1999-07-21 | Carmen Group, Inc. | 1299 Pennsylvania Avenue, N.W. | Suite 800 West | Washington | DC | 20004 |
21365 | 21365 | 2000-06-30 | 1997-10-27 | Chalmers | Walton M. | Smith, Dawson & Andrews, Inc. 5085 | 1995-12-12 | Smith, Dawson & Andrews, Inc. | 1000 Connecticut Avenue, N.W. | Suite 302 | Washington | DC | 20036 |
21366 | 21366 | 2000-06-30 | 1996-11-20 | Agrawal | Shyam Sunder | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
21367 | 21367 | 2000-06-30 | 1998-11-30 | Sang-Yong | Zhu | Korea National Tourism Organization, New Jersey 2614 | 1975-10-04 | Korea National Tourism Organization, New Jersey | 400 Kelby Street | Suite 1602 | Fort Lee | NJ | 07024 |
21368 | 21368 | 2000-06-30 | 1991-12-03 | Bray | Patrick | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
21369 | 21369 | 2000-06-30 | 1995-12-12 | Andrews | Gregory B. | Smith, Dawson & Andrews, Inc. 5085 | 1995-12-12 | Smith, Dawson & Andrews, Inc. | 1000 Connecticut Avenue, N.W. | Suite 302 | Washington | DC | 20036 |
21370 | 21370 | 2000-06-30 | 1995-12-12 | Smith | James P. | Smith, Dawson & Andrews, Inc. 5085 | 1995-12-12 | Smith, Dawson & Andrews, Inc. | 1000 Connecticut Avenue, N.W. | Suite 302 | Washington | DC | 20036 |
21371 | 21371 | 2000-06-30 | 1995-12-12 | Weiss | Paul D. | Smith, Dawson & Andrews, Inc. 5085 | 1995-12-12 | Smith, Dawson & Andrews, Inc. | 1000 Connecticut Avenue, N.W. | Suite 302 | Washington | DC | 20036 |
21372 | 21372 | 2000-06-30 | 1997-12-17 | Dietz-Petrovich | Michelle | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
21373 | 21373 | 2000-06-30 | 1997-12-18 | Gaines | Robert A. | Smith, Dawson & Andrews, Inc. 5085 | 1995-12-12 | Smith, Dawson & Andrews, Inc. | 1000 Connecticut Avenue, N.W. | Suite 302 | Washington | DC | 20036 |
21374 | 21374 | 2000-06-30 | 1997-12-18 | Riley | Susan Mary | Smith, Dawson & Andrews, Inc. 5085 | 1995-12-12 | Smith, Dawson & Andrews, Inc. | 1000 Connecticut Avenue, N.W. | Suite 302 | Washington | DC | 20036 |
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]) );