FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Short_Form_Termination_Date" is on date 2000-08-31 and State = "DC"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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]) );