FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
90 rows where City = "Washington" and Registration_Number = 3718 sorted by Short_Form_First_Name
This data as json, CSV (advanced)
State 1
- DC 45
Registration_Number 1
- Holland & Knight · 45 ✖
Registrant_Name 1
City 1
- Washington · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8271 | 8271 | 2014-02-28 | 2010-03-29 | Lehman | Kathryn | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
1024 | 1024 | 2014-05-14 | Lehman | Kathryn Hazeem | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
20333 | 20333 | 2020-06-26 | 2015-04-30 | Feehery | Kerry F. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
6133 | 6133 | 2021-02-04 | 2021-02-04 | Fresco | Leon | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
879 | 879 | 2022-04-26 | Barkovic | Lisa Ann | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
6253 | 6253 | 2003-02-06 | 1997-01-29 | Cobbs | Louise B. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
23293 | 23293 | 2001-07-15 | 2001-07-18 | Cutler | Lynn | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
14565 | 14565 | 1986-04-30 | 1985-08-07 | Dunaway | Mac S. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
6134 | 6134 | 2021-02-04 | 2021-02-04 | Serafino | Marissa C. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
28975 | 28975 | 2014-09-01 | 2014-02-06 | Meissner | Mark | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
8154 | 8154 | 2002-02-28 | 1999-08-16 | Ball | Markham | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
7951 | 7951 | 1990-02-28 | 1986-01-16 | Steinberg | Marty | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
85 | 85 | 2019-01-09 | Stavinsky | Meital | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
310 | 310 | 2022-02-04 | Burbanks-Ivey | Micah J. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
321 | 321 | 2014-02-06 | Galano | Michael | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
7136 | 7136 | 2001-02-16 | 1999-02-24 | McQuerry | Michael | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
8881 | 8881 | 2010-03-01 | 2010-03-29 | Galano | Michael | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
880 | 880 | 2022-04-26 | Lehrer | Misha | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
8440 | 8440 | 2023-02-28 | 2021-09-30 | Fussell | Nasim D. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
42279 | 42279 | 2019-12-31 | 2016-08-23 | Mastrangelo | Paolo | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
28687 | 28687 | 2020-08-31 | 2015-04-30 | Bock | Paul S. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
33318 | 33318 | 2021-10-21 | 2021-04-07 | Gold | Rich | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
30551 | 30551 | 2014-09-26 | 2014-02-06 | Gold | Richard M. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
23294 | 23294 | 2001-07-15 | 2001-07-18 | Woodson | Roderic L. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
445 | 445 | 1999-02-24 | Oleynik | Ronald A. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
3598 | 3598 | 2020-01-11 | 2019-07-26 | Vastola | Sally A. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
785 | 785 | 2017-04-14 | Mason | Scott D. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
3601 | 3601 | 2020-01-11 | 2019-10-04 | Watley | Shawna F. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
409 | 409 | 2022-02-15 | Watley | Shawna Francis | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
9650 | 9650 | 1998-03-11 | 1996-09-12 | Childs | Stephanie | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
30552 | 30552 | 2014-09-26 | 2014-02-06 | Gordon | Stewart | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
33319 | 33319 | 2021-10-21 | 2021-04-14 | Gordon | Stewart | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
26280 | 26280 | 1998-08-08 | 1998-04-15 | Dye | Stuart S. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
41213 | 41213 | 2001-12-31 | 2000-01-07 | Railsback | Thomas | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
428 | 428 | 2020-02-20 | Davis III | Thomas M. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
1482 | 1482 | 2019-07-26 | Reynolds | Thomas M. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
32787 | 32787 | 2020-10-14 | 2020-03-13 | Smith | Tim | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
315 | 315 | 2022-02-04 | Wooten | Todd | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
3599 | 3599 | 2020-01-11 | 2019-10-04 | Davis | Tom | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
26892 | 26892 | 2006-08-17 | 2003-12-05 | Sciarra | Vanessa P. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
8472 | 8472 | 1996-02-29 | 1993-12-17 | Assevero | Vicki | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
9232 | 9232 | 1992-03-06 | 1985-08-07 | Glass | W. Reeder | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
1133 | 1133 | 2021-05-28 | Gluck | Warren E. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 | |
7950 | 7950 | 1990-02-28 | 1986-01-16 | Bell | William G. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
9230 | 9230 | 1992-03-06 | 1990-03-07 | Schroeder | Yvonne C. | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
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]) );