FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where "Short_Form_Termination_Date" is on date 2006-10-31
This data as json, CSV (advanced)
Registration_Number 10
- Zemi Communications, LLC 7
- Burson-Marsteller 3
- Hill and Knowlton Strategies, LLC 2
- QORVIS LLC 2
- Alsace Development International, Inc. 1
- Debevoise & Plimpton 1
- North of England 1
- Korea Local Government Center (KLAFIR, America) 1
- Republic of Montenegro Trade Mission to the U.S. of America 1
- Loeffler Group, LLP 1
Registrant_Name 10
- Zemi Communications, LLC 7
- Burson-Marsteller 3
- Hill and Knowlton Strategies, LLC 2
- QORVIS LLC 2
- Alsace Development International, Inc. 1
- Debevoise & Plimpton 1
- Korea Local Government Center (KLAFIR, America) 1
- Loeffler Group, LLP 1
- North of England 1
- Republic of Montenegro Trade Mission to the U.S. of America 1
City 4
- New York 9
- Washington 9
- 68000 Colmar 1
- Chicago 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34532 | 34532 | 2006-10-31 | 2004-01-16 | Roberts | Michael Frederick | North of England 3844 | 1986-06-16 | North of England | 444 N. Michigan Avenue | Suite 411 | Chicago | IL | 60611 |
34533 | 34533 | 2006-10-31 | 2006-05-23 | Campero | Mariana | Zemi Communications, LLC 5714 | 2005-10-20 | Zemi Communications, LLC | 10 East 40th Street | Suite 1900 | New York | NY | 10016 |
34534 | 34534 | 2006-10-31 | 2006-05-23 | Rangel | Beatrice | Zemi Communications, LLC 5714 | 2005-10-20 | Zemi Communications, LLC | 10 East 40th Street | Suite 1900 | New York | NY | 10016 |
34535 | 34535 | 2006-10-31 | 2004-05-25 | Bedolla | Leon F. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
34536 | 34536 | 2006-10-31 | 2004-05-25 | Murfin | Cecilia | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
34537 | 34537 | 2006-10-31 | 2004-05-25 | Olguin | Adhemir | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
34538 | 34538 | 2006-10-31 | 2005-06-10 | Bradshaw | Kimberlee M. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
34539 | 34539 | 2006-10-31 | 2006-08-02 | Saunders | Katherine | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
34540 | 34540 | 2006-10-31 | 2006-09-05 | Roh | Jong Woo | Korea Local Government Center (KLAFIR, America) 5080 | 1995-11-24 | Korea Local Government Center (KLAFIR, America) | 150 East 58th Street | 14th Floor | New York | NY | 10155-0002 |
34541 | 34541 | 2006-10-31 | 2004-09-08 | Alsterlind | Tammy A. | Alsace Development International, Inc. 3506 | 1983-08-10 | Alsace Development International, Inc. | Chateau Kiener - 24 rue de Verdum | 68000 Colmar | |||
34542 | 34542 | 2006-10-31 | 2004-09-28 | Maric | Zorica | Republic of Montenegro Trade Mission to the U.S. of America 5199 | 1997-08-04 | Republic of Montenegro Trade Mission to the U.S. of America | 1610 New Hampshire Avenue, NW | Washington | DC | 20009 | |
34543 | 34543 | 2006-10-31 | 1983-10-05 | Cunard | Jeffrey P. | Debevoise & Plimpton 3527 | 1983-10-05 | Debevoise & Plimpton | 919 Third Avenue | New York | NY | 10022 | |
34544 | 34544 | 2006-10-31 | 2005-10-20 | Shturman | Goldie | Zemi Communications, LLC 5714 | 2005-10-20 | Zemi Communications, LLC | 10 East 40th Street | Suite 1900 | New York | NY | 10016 |
34545 | 34545 | 2006-10-31 | 2005-10-20 | Stoga | Alan J. | Zemi Communications, LLC 5714 | 2005-10-20 | Zemi Communications, LLC | 10 East 40th Street | Suite 1900 | New York | NY | 10016 |
34546 | 34546 | 2006-10-31 | 2005-10-20 | Toro | Liliana | Zemi Communications, LLC 5714 | 2005-10-20 | Zemi Communications, LLC | 10 East 40th Street | Suite 1900 | New York | NY | 10016 |
34547 | 34547 | 2006-10-31 | 2005-10-20 | Wilson | Daniel | Zemi Communications, LLC 5714 | 2005-10-20 | Zemi Communications, LLC | 10 East 40th Street | Suite 1900 | New York | NY | 10016 |
34548 | 34548 | 2006-10-31 | 2005-10-21 | Meeter | Stephen | Zemi Communications, LLC 5714 | 2005-10-20 | Zemi Communications, LLC | 10 East 40th Street | Suite 1900 | New York | NY | 10016 |
34549 | 34549 | 2006-10-31 | 2005-10-28 | Merola | Barbara F. | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | 1801 K Street, NW | Suite 340 | Washington | DC | 20006 |
34550 | 34550 | 2006-10-31 | 2006-10-31 | Bentkowski | David Anthony | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
34551 | 34551 | 2006-10-31 | 2006-10-31 | Bickford | Frank | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | 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]) );