FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where "Short_Form_Termination_Date" is on date 2001-08-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date)
Registration_Number 13
- Hogan Lovells US LLP 4
- Strategy XXI Group, Ltd. 4
- Al Paul Lefton Company, Inc. 3
- Holland & Knight 2
- Ross-Robinson & Associates 2
- Burson-Marsteller 1
- Korea National Tourism Organization, Chicago 1
- Korea Economic Institute 1
- Welsh Development Agency 1
- GCI Group, Inc. 1
- JFCC, Washington Office 1
- International Registries, Inc. 1
- Patrice Tanaka & Company, Inc. 1
Registrant_Name 13
- Hogan Lovells US LLP 4
- Strategy XXI Group, Ltd. 4
- Al Paul Lefton Company, Inc. 3
- Holland & Knight 2
- Ross-Robinson & Associates 2
- Burson-Marsteller 1
- GCI Group, Inc. 1
- International Registries, Inc. 1
- JFCC, Washington Office 1
- Korea Economic Institute 1
- Korea National Tourism Organization, Chicago 1
- Patrice Tanaka & Company, Inc. 1
- Welsh Development Agency 1
City 6
- Washington 9
- New York 6
- Philadelphia 3
- Basseterre 2
- Chicago 2
- Reston 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28379 | 28379 | 2001-08-31 | 1997-01-16 | Buckman | Judith G. | 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 |
28380 | 28380 | 2001-08-31 | 1995-02-07 | Ross-Robinson | Hazel | Ross-Robinson & Associates 4992 | 1995-02-07 | Ross-Robinson & Associates | P.O. Box 417 | Basseterre | |||
28381 | 28381 | 2001-08-31 | 2002-02-11 | Che | Wei aka Alfred Che | Strategy XXI Group, Ltd. 5273 | 1998-09-01 | Strategy XXI Group, Ltd. | 515 Madison Avenue | 34th Floor | New York | NY | 10022 |
28382 | 28382 | 2001-08-31 | 2002-02-11 | Clarke | Frank | Strategy XXI Group, Ltd. 5273 | 1998-09-01 | Strategy XXI Group, Ltd. | 515 Madison Avenue | 34th Floor | New York | NY | 10022 |
28383 | 28383 | 2001-08-31 | 1999-02-24 | Sikorski | Gerry | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
28384 | 28384 | 2001-08-31 | 2000-02-29 | Bryant | Emily T. | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
28385 | 28385 | 2001-08-31 | 2000-03-14 | Wall | Harry | Strategy XXI Group, Ltd. 5273 | 1998-09-01 | Strategy XXI Group, Ltd. | 515 Madison Avenue | 34th Floor | New York | NY | 10022 |
28386 | 28386 | 2001-08-31 | 2001-03-23 | Berger | Susan Gail | International Registries, Inc. 4533 | 1991-07-01 | International Registries, Inc. | 11495 Commerce Park Drive | Reston | VA | 20191-1506 | |
28387 | 28387 | 2001-08-31 | 2001-04-13 | Noble | Sally | Patrice Tanaka & Company, Inc. 5426 | 2001-04-13 | Patrice Tanaka & Company, Inc. | 320 West 13th Street | 7th Floor | New York | NY | 10016 |
28388 | 28388 | 2001-08-31 | 1997-05-30 | Lowen | Theodore W. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
28389 | 28389 | 2001-08-31 | 2001-05-30 | Ruzbasan | Debra | Korea National Tourism Organization, Chicago 3069 | 1979-11-23 | Korea National Tourism Organization, Chicago | 737 North Michigan Avenue | Suite 910 | Chicago | IL | 60611 |
28390 | 28390 | 2001-08-31 | 2000-06-02 | Marquez | Jim J. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
28391 | 28391 | 2001-08-31 | 2001-06-12 | Rossi | Richard A. | 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 |
28392 | 28392 | 2001-08-31 | 2000-06-21 | Smith | J. Gregory | 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 |
28393 | 28393 | 2001-08-31 | 2000-07-20 | Simcox | J.A. | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
28394 | 28394 | 2001-08-31 | 2001-07-27 | Giancarlo | Angela | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28395 | 28395 | 2001-08-31 | 2001-07-27 | Klein | Douglas Abraham | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28396 | 28396 | 2001-08-31 | 2001-07-27 | Sieradzki | David L. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28397 | 28397 | 2001-08-31 | 2001-07-31 | Bultena | Lance D. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28398 | 28398 | 2001-08-31 | 2001-08-10 | Miller | Hayley | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
28399 | 28399 | 2001-08-31 | 1998-09-01 | Frank | Andrew | Strategy XXI Group, Ltd. 5273 | 1998-09-01 | Strategy XXI Group, Ltd. | 515 Madison Avenue | 34th Floor | New York | NY | 10022 |
28400 | 28400 | 2001-08-31 | 1995-10-30 | Blahey | Cecelie Counts | Ross-Robinson & Associates 4992 | 1995-02-07 | Ross-Robinson & Associates | P.O. Box 417 | Basseterre | |||
28401 | 28401 | 2001-08-31 | 1999-12-22 | Ikuta | Yukio | JFCC, Washington Office 4440 | 1990-11-21 | JFCC, Washington Office | 1120 Connecticut Avenue, NW | Suite 440 | 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]) );