FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where "Short_Form_Date" is on date 2007-12-28
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_1, Registration_Date (date)
Registration_Number 6
Registrant_Name 6
City 5
- Bethesda 11
- Houston 5
- Washington 3
- Los Angeles 1
- New York 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4502 | 4502 | 2008-01-25 | 2007-12-28 | Blanton | Dewey | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
8227 | 8227 | 2007-02-28 | 2007-12-28 | McNabb | Stephen M. | Fulbright & Jaworski, LLP 5842 | 2007-12-28 | Fulbright & Jaworski, LLP | 1301 McKinney #5100 | Fulbright Tower | Houston | TX | 77010-3095 |
12536 | 12536 | 2008-04-01 | 2007-12-28 | Theoharis | Chris | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
17202 | 17202 | 2010-05-26 | 2007-12-28 | Heuer | Jennifer S. | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | 1875 I Street, NW | Suite 500 | Washington | DC | 20006 |
17509 | 17509 | 2008-05-30 | 2007-12-28 | DiFranco | Adriana V. | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
19467 | 19467 | 2019-06-14 | 2007-12-28 | Masters | Richard | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
19725 | 19725 | 2010-06-16 | 2007-12-28 | Pichs | Ana | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
33154 | 33154 | 2010-10-18 | 2007-12-28 | Burgoyne | Robert Anthony | Fulbright & Jaworski, LLP 5842 | 2007-12-28 | Fulbright & Jaworski, LLP | 1301 McKinney #5100 | Fulbright Tower | Houston | TX | 77010-3095 |
33155 | 33155 | 2010-10-18 | 2007-12-28 | Franklin | Jonathan S. | Fulbright & Jaworski, LLP 5842 | 2007-12-28 | Fulbright & Jaworski, LLP | 1301 McKinney #5100 | Fulbright Tower | Houston | TX | 77010-3095 |
33156 | 33156 | 2010-10-18 | 2007-12-28 | Lonsberg | John | Fulbright & Jaworski, LLP 5842 | 2007-12-28 | Fulbright & Jaworski, LLP | 1301 McKinney #5100 | Fulbright Tower | Houston | TX | 77010-3095 |
33439 | 33439 | 2008-10-22 | 2007-12-28 | Drake | Ashley J. | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | 1875 I Street, NW | Suite 500 | Washington | DC | 20006 |
39096 | 39096 | 2007-12-24 | 2007-12-28 | Pfeiffer | Steven B. | Fulbright & Jaworski, LLP 5842 | 2007-12-28 | Fulbright & Jaworski, LLP | 1301 McKinney #5100 | Fulbright Tower | Houston | TX | 77010-3095 |
39097 | 39097 | 2007-12-24 | 2007-12-28 | Silvermintz | William | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | 5901 W CENTURY BLVD. | SUITE 650 | Los Angeles | CA | 90045 |
41639 | 41639 | 2008-12-31 | 2007-12-28 | August | Michael L. | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
41640 | 41640 | 2008-12-31 | 2007-12-28 | Ctvrtnik | Wayne Edward | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
41641 | 41641 | 2008-12-31 | 2007-12-28 | Dreyer | Erik | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
41642 | 41642 | 2008-12-31 | 2007-12-28 | Hopskins | Kandi K. | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
41643 | 41643 | 2008-12-31 | 2007-12-28 | Husak Jr. | Charles A. | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
41644 | 41644 | 2008-12-31 | 2007-12-28 | Lang | William I. | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
41645 | 41645 | 2008-12-31 | 2007-12-28 | Onufrychuk | Brian | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
41646 | 41646 | 2008-12-31 | 2007-12-28 | Weaver | Bonnie | August, Lang & Husak 5843 | 2007-12-28 | August, Lang & Husak | 4630 Montgomery Avenue | Suite 400 | Bethesda | MD | 20814 |
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]) );