FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where City = "Washington" and Short_Form_Termination_Date = "1987-12-31"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_1, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 19
- O'Connor & Hannan, L.L.P. 2
- Bishop, Cook, Purcell & Reynolds 2
- A.I.T. Corporation 2
- Hill and Knowlton Strategies, LLC 2
- Merren, Orren 2
- Jones Day 2
- Braun & Company 2
- Morgan, Lewis & Bockius, L.L.P. 2
- Tanaka, Michele N. 1
- Modern Education Services, Inc. 1
- IBTT Consultants, Inc. 1
- Alenia of U.S.A., Inc. 1
- Law Offices of John P. Sears 1
- Black, Kelly, Scruggs & Healey 1
- Whalen Company, Inc. 1
- St. Maxens & Company 1
- R. Duffy Wall & Associates, Inc. 1
- Goodwin Procter, LLP 1
- Spriggs & Hollingsworth 1
Registrant_Name 19
- A.I.T. Corporation 2
- Bishop, Cook, Purcell & Reynolds 2
- Braun & Company 2
- Hill and Knowlton Strategies, LLC 2
- Jones Day 2
- Merren, Orren 2
- Morgan, Lewis & Bockius, L.L.P. 2
- O'Connor & Hannan, L.L.P. 2
- Alenia of U.S.A., Inc. 1
- Black, Kelly, Scruggs & Healey 1
- Goodwin Procter, LLP 1
- IBTT Consultants, Inc. 1
- Law Offices of John P. Sears 1
- Modern Education Services, Inc. 1
- R. Duffy Wall & Associates, Inc. 1
- Spriggs & Hollingsworth 1
- St. Maxens & Company 1
- Tanaka, Michele N. 1
- Whalen Company, Inc. 1
State 1
- DC 27
City 1
- Washington · 27 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40387 | 40387 | 1987-12-31 | 1987-01-28 | Wyatt | Joseph Paul | Whalen Company, Inc. 3637 | 1985-01-09 | Whalen Company, Inc. | 1717 K Street, N.W. | Suite 706 | Washington | DC | 20006 |
40388 | 40388 | 1987-12-31 | 1980-01-29 | Goldsmith | Judy R. | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | 1015 - 18th Street, N.W. | Suite 704 | Washington | DC | 20036 |
40394 | 40394 | 1987-12-31 | 1986-02-24 | Demory | Will | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
40396 | 40396 | 1987-12-31 | 1987-03-16 | Woolsey | R. James | Goodwin Procter, LLP 3901 | 1986-10-30 | Goodwin Procter, LLP | 901 New York Avenue, N.W. | Washington | DC | 20001 | |
40397 | 40397 | 1987-12-31 | 1987-03-23 | Riedy | Mark J. | Spriggs & Hollingsworth 3951 | 1987-03-23 | Spriggs & Hollingsworth | 1015 - 15th Street, N.W. | Suite 1100 | Washington | DC | 20005 |
40400 | 40400 | 1987-12-31 | 1981-05-04 | Chow | Anthony S. | A.I.T. Corporation 3228 | 1981-04-15 | A.I.T. Corporation | 15 - 3rd Street, N.E. | Washington | DC | 20002 | |
40401 | 40401 | 1987-12-31 | 1981-05-04 | Lin | Gen Yee | A.I.T. Corporation 3228 | 1981-04-15 | A.I.T. Corporation | 15 - 3rd Street, N.E. | Washington | DC | 20002 | |
40402 | 40402 | 1987-12-31 | 1976-05-05 | Ritger | Donald L.E. | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | 655 - 15th Street, N.W. | Suite 800 | Washington | DC | 20005 |
40403 | 40403 | 1987-12-31 | 1984-05-09 | Ward | John S. | Law Offices of John P. Sears 3584 | 1984-05-09 | Law Offices of John P. Sears | 2021 K Street, N.W. | Suite 750 | Washington | DC | 20006 |
40407 | 40407 | 1987-12-31 | 1986-06-10 | Kelly | Michael S. | Morgan, Lewis & Bockius, L.L.P. 3794 | 1986-03-12 | Morgan, Lewis & Bockius, L.L.P. | 1111 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
40408 | 40408 | 1987-12-31 | 1986-06-10 | Schlossberg | Robert S. | Morgan, Lewis & Bockius, L.L.P. 3794 | 1986-03-12 | Morgan, Lewis & Bockius, L.L.P. | 1111 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
40411 | 40411 | 1987-12-31 | 1985-06-21 | Yarborough | William Glenn , Jr. | Alenia of U.S.A., Inc. 3399 | 1982-08-11 | Alenia of U.S.A., Inc. | 1101 - 15th Street, N.W. | Suite 610 | Washington | DC | 20005 |
40413 | 40413 | 1987-12-31 | 1986-07-03 | Fix | Donald J. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
40415 | 40415 | 1987-12-31 | 1983-07-20 | Parsons | Richard Michael | Merren, Orren 3412 | 1982-09-29 | Merren, Orren | Post Office Box 53356 | Washington | DC | 20009 | |
40419 | 40419 | 1987-12-31 | 1986-08-01 | Buderi | Charles L.O. | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
40426 | 40426 | 1987-12-31 | 1979-08-17 | Wirwahn | F. Eugene | Bishop, Cook, Purcell & Reynolds 3050 | 1979-08-17 | Bishop, Cook, Purcell & Reynolds | 1400 L Street, N.W. | Washington | DC | 20005-3502 | |
40427 | 40427 | 1987-12-31 | 1985-08-23 | Maxens | Thomas F. St. , II | St. Maxens & Company 3726 | 1985-08-23 | St. Maxens & Company | 1140 Connecticut Avenue, N.W. | Suite 201 | Washington | DC | 20036 |
40428 | 40428 | 1987-12-31 | 1984-08-28 | Miller | Clifford A. | Braun & Company 3609 | 1984-08-28 | Braun & Company | 1250 Connecticut Avenue, N.W. | Suite 318 | Washington | DC | 20036 |
40429 | 40429 | 1987-12-31 | 1984-08-28 | Miller | Judy | Braun & Company 3609 | 1984-08-28 | Braun & Company | 1250 Connecticut Avenue, N.W. | Suite 318 | Washington | DC | 20036 |
40433 | 40433 | 1987-12-31 | 1986-09-05 | Rosenauer | David B. | R. Duffy Wall & Associates, Inc. 3737 | 1985-09-25 | R. Duffy Wall & Associates, Inc. | 601 - 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
40434 | 40434 | 1987-12-31 | 1984-09-07 | Ambrose | Myles J. | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006 |
40435 | 40435 | 1987-12-31 | 1984-09-07 | Coursen | Christopher D. | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006 |
40436 | 40436 | 1987-12-31 | 1981-09-17 | Satterfield | David E. | Bishop, Cook, Purcell & Reynolds 3050 | 1979-08-17 | Bishop, Cook, Purcell & Reynolds | 1400 L Street, N.W. | Washington | DC | 20005-3502 | |
40438 | 40438 | 1987-12-31 | 1985-09-26 | Lehman | Christopher M. | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
40439 | 40439 | 1987-12-31 | 1982-09-29 | Boynton | Stephen S. | Merren, Orren 3412 | 1982-09-29 | Merren, Orren | Post Office Box 53356 | Washington | DC | 20009 | |
40440 | 40440 | 1987-12-31 | 1981-10-06 | McGiffert | Enud | IBTT Consultants, Inc. 3281 | 1981-10-06 | IBTT Consultants, Inc. | 1701 K Street, N.W. | Suite 603 | Washington | DC | 20006 |
40448 | 40448 | 1987-12-31 | 1982-12-10 | Bell | James Frederick | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 |
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]) );