FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where Short_Form_Termination_Date = "2009-03-31"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 12
- Washington Group 8
- Sidley Austin LLP 6
- Daniel J. Edelman, Inc. 4
- Supporters of Fine Gael, Inc. 3
- Steptoe & Johnson, LLP 3
- JETRO, Chicago 2
- Korea International Trade Association, Inc. 1
- Jones Day 1
- Saudi Refining, Inc. 1
- Caparso, Anne Smith 1
- McGuireWoods Consulting, LLC 1
- GoodWorks International, LLC 1
Registrant_Name 12
- Washington Group 8
- Sidley Austin LLP 6
- Daniel J. Edelman, Inc. 4
- Steptoe & Johnson, LLP 3
- Supporters of Fine Gael, Inc. 3
- JETRO, Chicago 2
- Caparso, Anne Smith 1
- GoodWorks International, LLC 1
- Jones Day 1
- Korea International Trade Association, Inc. 1
- McGuireWoods Consulting, LLC 1
- Saudi Refining, Inc. 1
City 5
- Washington 20
- New York 8
- Chicago 2
- Houston 1
- Stratham 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12033 | 12033 | 2009-03-31 | 2009-01-23 | Zimmerman | Bruce V. | Saudi Refining, Inc. 4184 | 1988-10-13 | Saudi Refining, Inc. | One Allen Center | 500 Dallas Street | Houston | TX | 77002 |
12034 | 12034 | 2009-03-31 | 2008-02-25 | O'Hanlon | John | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12035 | 12035 | 2009-03-31 | 1987-04-24 | Brown | Robert M. , Jr. | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
12036 | 12036 | 2009-03-31 | 2008-04-29 | Rutledge | Colleen Theresa | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12037 | 12037 | 2009-03-31 | 2006-05-10 | McNicholas | Edward R. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12038 | 12038 | 2009-03-31 | 2006-05-10 | Stillabower | Erika L. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12039 | 12039 | 2009-03-31 | 2006-05-10 | Tatel | Jennifer | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12040 | 12040 | 2009-03-31 | 2008-05-14 | Ford | Wallace | GoodWorks International, LLC 5414 | 2001-03-02 | GoodWorks International, LLC | 1700 K Street NW | Suite 430 | Washington | DC | 20006-3806 |
12041 | 12041 | 2009-03-31 | 2009-05-26 | Varma | Amanda | Steptoe & Johnson, LLP 5848 | 2008-01-25 | Steptoe & Johnson, LLP | 1330 Connecticut Avenue, NW | Washington | DC | 20036 | |
12042 | 12042 | 2009-03-31 | 2008-06-13 | Johnston | Hunter | Steptoe & Johnson, LLP 5848 | 2008-01-25 | Steptoe & Johnson, LLP | 1330 Connecticut Avenue, NW | Washington | DC | 20036 | |
12043 | 12043 | 2009-03-31 | 2008-06-30 | Lee | Woo Won | Korea International Trade Association, Inc. 2686 | 1976-04-23 | Korea International Trade Association, Inc. | 460 Park Avenue | Suite 400 | New York | NY | 10022 |
12044 | 12044 | 2009-03-31 | 2008-07-10 | O'Dwyer | Patricia | Supporters of Fine Gael, Inc. 5798 | 2007-03-08 | Supporters of Fine Gael, Inc. | 52 Duane Street | 5th Floor | New York | NY | 10007 |
12045 | 12045 | 2009-03-31 | 2008-07-10 | Higgins | Laura | Supporters of Fine Gael, Inc. 5798 | 2007-03-08 | Supporters of Fine Gael, Inc. | 52 Duane Street | 5th Floor | New York | NY | 10007 |
12046 | 12046 | 2009-03-31 | 2008-07-10 | McGettrick | Patrick | Supporters of Fine Gael, Inc. 5798 | 2007-03-08 | Supporters of Fine Gael, Inc. | 52 Duane Street | 5th Floor | New York | NY | 10007 |
12047 | 12047 | 2009-03-31 | 2008-08-28 | West | Phil | Steptoe & Johnson, LLP 5848 | 2008-01-25 | Steptoe & Johnson, LLP | 1330 Connecticut Avenue, NW | Washington | DC | 20036 | |
12048 | 12048 | 2009-03-31 | 2008-09-26 | Busch | Madison H. | McGuireWoods Consulting, LLC 5408 | 2001-02-05 | McGuireWoods Consulting, LLC | 2001 K Street, NW | Suite 400 | Washington | DC | 20006 |
12049 | 12049 | 2009-03-31 | 2005-09-30 | Allen | Kevin D. | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12050 | 12050 | 2009-03-31 | 2005-09-30 | Edwards | Melissa | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12051 | 12051 | 2009-03-31 | 2005-09-30 | Farmer | Kimberley | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12052 | 12052 | 2009-03-31 | 2005-09-30 | Lobo | Paul | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12053 | 12053 | 2009-03-31 | 2005-09-30 | Noone | James | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12054 | 12054 | 2009-03-31 | 2005-09-30 | Saunders (Speed) | Tonya | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12055 | 12055 | 2009-03-31 | 2005-09-30 | West | Fowler | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
12056 | 12056 | 2009-03-31 | 2006-10-26 | Akiyama | Kazuhiko | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
12057 | 12057 | 2009-03-31 | 2006-10-26 | Takahara | Yoshio | JETRO, Chicago 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 |
12058 | 12058 | 2009-03-31 | 2002-10-30 | Caparso | Anne Smith | Caparso, Anne Smith 5331 | 1999-09-27 | Caparso, Anne Smith | 4 Evergreen Way | Stratham | NH | 03885 | |
12059 | 12059 | 2009-03-31 | 2008-10-30 | Raul | Alan Charles | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12060 | 12060 | 2009-03-31 | 2008-10-31 | Estevez | Michael A. | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
12061 | 12061 | 2009-03-31 | 2008-10-31 | McCabe III | Richard James | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
12062 | 12062 | 2009-03-31 | 2008-10-31 | Saran | Smita | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
12063 | 12063 | 2009-03-31 | 2008-11-05 | Strenio, Jr. | Andrew J. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
12064 | 12064 | 2009-03-31 | 2000-12-18 | Walrath | Bret | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 |
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]) );