FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where "Short_Form_Termination_Date" is on date 2000-08-31 sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Address_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28378 | 28378 | 2000-08-31 | 2000-11-21 | Katayama | Patricia | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
28373 | 28373 | 2000-08-31 | 1999-10-28 | Leventant | Williams | Gallagher, John J. 5336 | 1999-10-28 | Gallagher, John J. | 1760 Market Street | Suite 1100 | Philadelphia | PA | 19103 |
28359 | 28359 | 2000-08-31 | 1999-04-29 | Smith | Michael B. | Global USA, Inc. 5292 | 1998-12-16 | Global USA, Inc. | 1990 M Street, NW | #200 | Washington | DC | 20036 |
28360 | 28360 | 2000-08-31 | 1998-07-07 | Ceremugova | Katerina | Czech Center, New York 5115 | 1996-06-21 | Czech Center, New York | 321 E 73rd Street | New York | NY | 10021 | |
28355 | 28355 | 2000-08-31 | 2000-03-06 | Maloni | Jason | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28356 | 28356 | 2000-08-31 | 2000-03-06 | Wagner | Joseph | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28363 | 28363 | 2000-08-31 | 1998-08-13 | Dougherty | Melanie Heltne | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28364 | 28364 | 2000-08-31 | 1998-08-13 | Duggan | Joseph Patrick | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28365 | 28365 | 2000-08-31 | 1998-08-13 | Madison | Alan | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28367 | 28367 | 2000-08-31 | 1998-10-05 | Bond | Hannah Harrison | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28368 | 28368 | 2000-08-31 | 1998-10-05 | Urbanski | Tina | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28369 | 28369 | 2000-08-31 | 1998-10-05 | Watkins | Venus N. | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28370 | 28370 | 2000-08-31 | 1998-10-06 | Bonilla | Margaret Donlin | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28374 | 28374 | 2000-08-31 | 1999-11-05 | Budd | Anitra Grace | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28375 | 28375 | 2000-08-31 | 1996-11-08 | Beh | Swan Gin | 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 |
28376 | 28376 | 2000-08-31 | 1996-11-08 | Quek | Swee Kuan | 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 |
28358 | 28358 | 2000-08-31 | 1990-03-27 | Winnik | Joel S. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28361 | 28361 | 2000-08-31 | 1999-07-09 | Warnke | Christine | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28362 | 28362 | 2000-08-31 | 1999-07-14 | Munk | Jeffrey W. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28366 | 28366 | 2000-08-31 | 1998-09-30 | Archibald | Jeanne S. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
28357 | 28357 | 2000-08-31 | 2000-03-07 | Rittenour | Maralyn | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28371 | 28371 | 2000-08-31 | 1997-10-10 | Brisson | Michel | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28372 | 28372 | 2000-08-31 | 1997-10-10 | Brousseau | Fancois | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28377 | 28377 | 2000-08-31 | 1999-11-12 | Harvey | Gaston | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
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]) );