FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
41 rows where "Short_Form_Termination_Date" is on date 2013-12-31 sorted by State
This data as json, CSV (advanced)
Suggested facets: Registration_Date
Short_Form_Date (date) 29 ✖
- 2012-02-17 4
- 2013-08-07 3
- 2013-08-09 3
- 2009-05-15 2
- 2010-02-02 2
- 2011-08-16 2
- 2013-08-29 2
- 2013-09-16 2
- 1995-06-02 1
- 2003-10-29 1
- 2005-05-19 1
- 2007-07-05 1
- 2008-02-05 1
- 2008-10-10 1
- 2008-12-01 1
- 2009-10-08 1
- 2009-12-16 1
- 2010-05-06 1
- 2011-06-23 1
- 2011-06-29 1
- 2011-09-08 1
- 2011-09-15 1
- 2011-10-31 1
- 2011-12-21 1
- 2012-06-06 1
- 2012-06-25 1
- 2012-11-15 1
- 2012-12-20 1
- 2013-07-10 1
Registration_Number 26
- Command Consulting Group, LLC (CCG) 4
- Covington & Burling, LLP 3
- Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) 3
- HL Group Partners, LLC 3
- Cassidy & Associates, Inc. 3
- Office of Tibet 2
- Quebec Government Office 2
- West Wing Writers, LLC 2
- Carmen Group, Inc. 2
- Bermuda Tourism Authority 1
- JETRO, San Francisco 1
- Singapore Economic Development Board 1
- Squire Patton Boggs, LLP 1
- Singapore Tourism Board 1
- White & Case, LLP 1
- Dickstein Shapiro, LLP 1
- British Virgin Islands Tourist Board 1
- Deutsche Telekom, Inc. 1
- Malaysian Palm Oil Council (f/k/a American Palm Oil Council) 1
- Urenco, Inc. 1
- BGR Government Affairs, LLC 1
- Kurdistan Regional Government - Liaison Office - USA 1
- BLJ Worldwide LTD 1
- HDMK, LLC 1
- LTL Strategies 1
- Hillenby, LLC 1
Registrant_Name 26
- Command Consulting Group, LLC (CCG) 4
- Cassidy & Associates, Inc. 3
- Covington & Burling, LLP 3
- HL Group Partners, LLC 3
- Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) 3
- Carmen Group, Inc. 2
- Office of Tibet 2
- Quebec Government Office 2
- West Wing Writers, LLC 2
- BGR Government Affairs, LLC 1
- BLJ Worldwide LTD 1
- Bermuda Tourism Authority 1
- British Virgin Islands Tourist Board 1
- Deutsche Telekom, Inc. 1
- Dickstein Shapiro, LLP 1
- HDMK, LLC 1
- Hillenby, LLC 1
- JETRO, San Francisco 1
- Kurdistan Regional Government - Liaison Office - USA 1
- LTL Strategies 1
- Malaysian Palm Oil Council (f/k/a American Palm Oil Council) 1
- Singapore Economic Development Board 1
- Singapore Tourism Board 1
- Squire Patton Boggs, LLP 1
- Urenco, Inc. 1
- White & Case, LLP 1
City 5
- Washington 26
- New York 12
- Alexandria 1
- Arlington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41863 | 41863 | 2013-12-31 | 2010-05-06 | Lampe | Sean | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
41856 | 41856 | 2013-12-31 | 2010-02-02 | Clifton | Curt | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
41858 | 41858 | 2013-12-31 | 2008-02-05 | Larson | Alan | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
41859 | 41859 | 2013-12-31 | 2012-02-17 | Atkiss | Steven A. | Command Consulting Group, LLC (CCG) 6090 | 2012-02-17 | Command Consulting Group, LLC (CCG) | 1501 M Street, NW | Fifth Floor | Washington | DC | 20005 |
41860 | 41860 | 2013-12-31 | 2012-02-17 | Basham | W. Ralph | Command Consulting Group, LLC (CCG) 6090 | 2012-02-17 | Command Consulting Group, LLC (CCG) | 1501 M Street, NW | Fifth Floor | Washington | DC | 20005 |
41861 | 41861 | 2013-12-31 | 2012-02-17 | Bingel | Thaddeus M. | Command Consulting Group, LLC (CCG) 6090 | 2012-02-17 | Command Consulting Group, LLC (CCG) | 1501 M Street, NW | Fifth Floor | Washington | DC | 20005 |
41862 | 41862 | 2013-12-31 | 2012-02-17 | Turner | Heather | Command Consulting Group, LLC (CCG) 6090 | 2012-02-17 | Command Consulting Group, LLC (CCG) | 1501 M Street, NW | Fifth Floor | Washington | DC | 20005 |
41864 | 41864 | 2013-12-31 | 2009-05-15 | Abaye | Abrahim | Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) 5895 | 2008-12-01 | Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) | P.O. Box 21762 | Washington | DC | 20009 | |
41865 | 41865 | 2013-12-31 | 2009-05-15 | Kurfeessaa | Leenjiso Horo | Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) 5895 | 2008-12-01 | Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) | P.O. Box 21762 | Washington | DC | 20009 | |
41867 | 41867 | 2013-12-31 | 1995-06-02 | Kassim | Mohamed Salleh Bin Mohd | Malaysian Palm Oil Council (f/k/a American Palm Oil Council) 4575 | 1991-10-04 | Malaysian Palm Oil Council (f/k/a American Palm Oil Council) | 1010 Wisconsin Avenue, NW | Suite 307 | Washington | DC | 20007 |
41868 | 41868 | 2013-12-31 | 2012-06-06 | Shesol | Jeffrey | West Wing Writers, LLC 6107 | 2012-06-06 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
41869 | 41869 | 2013-12-31 | 2011-06-23 | Grajek | Michelle | Kurdistan Regional Government - Liaison Office - USA 5783 | 2006-12-28 | Kurdistan Regional Government - Liaison Office - USA | 1532 16th Street, NW | Washington | DC | 20036-1402 | |
41870 | 41870 | 2013-12-31 | 2012-06-25 | Karlin-Neumann | Zev | West Wing Writers, LLC 6107 | 2012-06-06 | West Wing Writers, LLC | 1150 Connecticut Avenue, NW | Suite 505 | Washington | DC | 20036 |
41873 | 41873 | 2013-12-31 | 2013-07-10 | Lukawski | Jennifer Larkin | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 601 Thirteenth Street, NW | Eleventh Floor South | Washington | DC | 20005 |
41877 | 41877 | 2013-12-31 | 2013-08-09 | Alsalih | Mark | Cassidy & Associates, Inc. 6179 | 2013-08-09 | Cassidy & Associates, Inc. | 733 10th Street, NW | Suite 400 | Washington | DC | 20001 |
41878 | 41878 | 2013-12-31 | 2013-08-09 | Clark | Mark | Cassidy & Associates, Inc. 6179 | 2013-08-09 | Cassidy & Associates, Inc. | 733 10th Street, NW | Suite 400 | Washington | DC | 20001 |
41879 | 41879 | 2013-12-31 | 2013-08-09 | Mark | Molly | Cassidy & Associates, Inc. 6179 | 2013-08-09 | Cassidy & Associates, Inc. | 733 10th Street, NW | Suite 400 | Washington | DC | 20001 |
41880 | 41880 | 2013-12-31 | 2011-08-16 | Thonden | Yodon | Office of Tibet 1699 | 1964-03-14 | Office of Tibet | 1228 17th Street, NW | Washington | DC | 20036 | |
41881 | 41881 | 2013-12-31 | 2011-08-16 | Toner | Kevin Christopher Alan | Office of Tibet 1699 | 1964-03-14 | Office of Tibet | 1228 17th Street, NW | Washington | DC | 20036 | |
41884 | 41884 | 2013-12-31 | 2011-09-08 | Waltz | Daniel E. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41886 | 41886 | 2013-12-31 | 2013-09-16 | Carmen | David | Carmen Group, Inc. 6188 | 2013-09-16 | Carmen Group, Inc. | 505 9th Street, NW | 7th Floor | Washington | DC | 20004 |
41887 | 41887 | 2013-12-31 | 2013-09-16 | Harper | Dal | Carmen Group, Inc. 6188 | 2013-09-16 | Carmen Group, Inc. | 505 9th Street, NW | 7th Floor | Washington | DC | 20004 |
41889 | 41889 | 2013-12-31 | 2008-10-10 | Han | Allegra | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
41892 | 41892 | 2013-12-31 | 2012-11-15 | Wakely | Jonathan | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
41893 | 41893 | 2013-12-31 | 2008-12-01 | Djaleta | Tefera | Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) 5895 | 2008-12-01 | Oromo Liberation Front Foreign Relations Office in North America (OLF-FRONA) | P.O. Box 21762 | Washington | DC | 20009 | |
41894 | 41894 | 2013-12-31 | 2009-12-16 | Holt | Terry | HDMK, LLC 5966 | 2009-12-16 | HDMK, LLC | 1000 Vermont Avenue, NW | Suite 800 | Washington | DC | 20005 |
41896 | 41896 | 2013-12-31 | 2011-12-21 | Thomas-Lake | Hillary | LTL Strategies 6082 | 2011-12-21 | LTL Strategies | 4545 42nd Street, NW | Suite 306 | Washington | DC | 20016 |
41857 | 41857 | 2013-12-31 | 2010-02-02 | Shutte | Caroline Ann | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
41866 | 41866 | 2013-12-31 | 2005-05-19 | Statz | Klaus-Peter | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
41871 | 41871 | 2013-12-31 | 2011-06-29 | Ng | Chew Wee | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
41874 | 41874 | 2013-12-31 | 2013-08-07 | Hund | Maggie | HL Group Partners, LLC 6178 | 2013-08-07 | HL Group Partners, LLC | 853 Broadway | 18th Floor | New York | NY | 10003 |
41875 | 41875 | 2013-12-31 | 2013-08-07 | Mahaney | Sarah | HL Group Partners, LLC 6178 | 2013-08-07 | HL Group Partners, LLC | 853 Broadway | 18th Floor | New York | NY | 10003 |
41876 | 41876 | 2013-12-31 | 2013-08-07 | McNamee | Dave | HL Group Partners, LLC 6178 | 2013-08-07 | HL Group Partners, LLC | 853 Broadway | 18th Floor | New York | NY | 10003 |
41882 | 41882 | 2013-12-31 | 2013-08-29 | Boisclair | Andre | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
41883 | 41883 | 2013-12-31 | 2013-08-29 | Saintonge | Jean | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
41885 | 41885 | 2013-12-31 | 2011-09-15 | Hill | Katie | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | 1359 Broadway | Suite 1102 | New York | NY | 10018 |
41888 | 41888 | 2013-12-31 | 2009-10-08 | Tan | Serene | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 |
41890 | 41890 | 2013-12-31 | 2003-10-29 | Smith | Malcia | British Virgin Islands Tourist Board 3354 | 1982-04-08 | British Virgin Islands Tourist Board | 1 West 34th Street | Suite 302 | New York | NY | 10001-3011 |
41891 | 41891 | 2013-12-31 | 2011-10-31 | Carlisle | Linda E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41872 | 41872 | 2013-12-31 | 2007-07-05 | Mann | Melissa C. | Urenco, Inc. 5137 | 1996-11-08 | Urenco, Inc. | 1560 Wilson Boulevard | Suite 300 | Arlington | VA | 22209-2463 |
41895 | 41895 | 2013-12-31 | 2012-12-20 | Hoppin | Robert C. | Hillenby, LLC 6146 | 2012-12-20 | Hillenby, LLC | 1216 King Street | Suite 200 | Alexandria | VA | 22314 |
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]) );