FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where City = "Washington" and Short_Form_Last_Name = "Green"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 18
- Sidley Austin LLP 3
- Arnold & Porter Kaye Scholer LLP 2
- Korea Economic Institute 2
- Robert R. Nathan Associates, Inc. 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Japan Economic Institute of America 1
- O'Connor, Green, Thomas & Walters 1
- Prather, Seeger, Doolittle & Farmer 1
- Newman & Holtzinger, P.C. 1
- Hill and Knowlton Strategies, LLC 1
- Marks, Murase & White 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Kelley, Drye & Warren 1
- DLA Piper US LLP 1
- Hitachi, Ltd. 1
- International Technology & Trade Associates, Inc. 1
- Ogilvy Public Relations Worldwide 1
- New Partners Consulting, Inc. 1
Registrant_Name 18
- Sidley Austin LLP 3
- Arnold & Porter Kaye Scholer LLP 2
- Korea Economic Institute 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- DLA Piper US LLP 1
- Hill and Knowlton Strategies, LLC 1
- Hitachi, Ltd. 1
- International Technology & Trade Associates, Inc. 1
- Japan Economic Institute of America 1
- Kelley, Drye & Warren 1
- Marks, Murase & White 1
- New Partners Consulting, Inc. 1
- Newman & Holtzinger, P.C. 1
- O'Connor, Green, Thomas & Walters 1
- Ogilvy Public Relations Worldwide 1
- Prather, Seeger, Doolittle & Farmer 1
- Robert R. Nathan Associates, Inc. 1
State 1
- DC 22
City 1
- Washington · 22 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2147 | 2147 | 2012-11-12 | Green | Karen Goldmeier | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | ||
4059 | 4059 | 1997-01-18 | 1997-02-18 | Green | Carl J. | Hitachi, Ltd. 3855 | 1986-07-18 | Hitachi, Ltd. | 1900 K Street, N.W. | Suite 800 | Washington | DC | 20006 |
5510 | 5510 | 2016-01-31 | 2015-12-17 | Green | Kathryn | New Partners Consulting, Inc. 6330 | 2015-12-17 | New Partners Consulting, Inc. | 1250 I Street, NW | Suite 200 | Washington | DC | 20005 |
6131 | 6131 | 2011-02-04 | 2008-07-01 | Green | Brian | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
7058 | 7058 | 1982-02-16 | 1980-02-26 | Green | Pamela K. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
8370 | 8370 | 2020-02-28 | 2019-04-04 | Green | Mindy | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
9132 | 9132 | 2010-03-04 | 2004-08-16 | Green | Thomas C. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
9224 | 9224 | 1987-03-06 | 1986-05-28 | Green | David | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
11690 | 11690 | 1993-03-31 | 1983-02-03 | Green | Douglas Gustave | Newman & Holtzinger, P.C. 2895 | 1978-05-04 | Newman & Holtzinger, P.C. | 1615 L Street, N.W. | Suite 1000 | Washington | DC | 20036 |
13639 | 13639 | 1992-04-17 | 1992-03-10 | Green | Thomas C. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
14608 | 14608 | 1990-04-30 | 1988-07-25 | Green | Gretchen | Japan Economic Institute of America 929 | 1956-01-25 | Japan Economic Institute of America | P.O.Box 65780 | Washington | DC | 20035-5780 | |
16096 | 16096 | 1986-05-12 | 1982-11-04 | Green | Carl J. | Marks, Murase & White 3419 | 1982-11-04 | Marks, Murase & White | 2001 L Street, N.W. | Suite 750 | Washington | DC | 20036 |
16240 | 16240 | 1982-05-13 | 1963-10-28 | Green | Donald Stanley | Robert R. Nathan Associates, Inc. 352 | 1946-04-22 | Robert R. Nathan Associates, Inc. | 3 Thomas Circle | Washington | DC | 20530 | |
20101 | 20101 | 1992-06-23 | 1988-11-07 | Green | Benjamin H. | Kelley, Drye & Warren 3681 | 1985-05-23 | Kelley, Drye & Warren | 2300 M Street, N.W. | Washington | DC | 20037 | |
22584 | 22584 | 1968-07-05 | 1964-08-06 | Green | Sedwick William | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
25650 | 25650 | 2006-08-01 | 2005-07-07 | Green | Douglas Haber | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
26442 | 26442 | 1987-08-11 | 1982-02-01 | Green | Carl | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
27271 | 27271 | 2002-08-23 | 2002-02-19 | Green | Marina | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
30743 | 30743 | 1993-09-29 | 1990-09-27 | Green | Gretchen L. | International Technology & Trade Associates, Inc. 4341 | 1990-02-21 | International Technology & Trade Associates, Inc. | 1330 Connecticut Avenue, N.W. | Suite 210 | Washington | DC | 20036-1704 |
36051 | 36051 | 1964-11-19 | 1964-06-05 | Green | Kenneth Wright | O'Connor, Green, Thomas & Walters 1738 | 1964-05-19 | O'Connor, Green, Thomas & Walters | 508 Federal Bar Building | 1815 H Street, N.W. | Washington | DC | |
38388 | 38388 | 1983-12-15 | 1981-03-10 | Green | Therese M. | Prather, Seeger, Doolittle & Farmer 1815 | 1964-11-13 | Prather, Seeger, Doolittle & Farmer | 1600 M Street, N.W. | 7th Floor | Washington | DC | 20036 |
41915 | 41915 | 2014-12-31 | 2011-03-08 | Green | Thomas C. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
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]) );