home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

31 rows where Registration_Number = 2868

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Date (date), Registration_Date (date)

State 1

  • DC 31

Registration_Number 1

  • LeBoeuf, Lamb, Greene & MacRae, L.L.P. · 31 ✖

Registrant_Name 1

  • LeBoeuf, Lamb, Greene & MacRae, L.L.P. 31

City 1

  • Washington 31
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
3156 3156 1980-01-04 1978-04-04 Pulis Gregory M. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
9457 9457 1985-03-08 1984-10-16 Viehe-Naess Brenda R. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
11158 11158 1992-03-30 1988-12-07 Shoss Cynthia R. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
11559 11559 1987-03-31 1978-03-17 Hawes Douglas W. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
12777 12777 1985-04-05 1978-03-17 Paradis Margaret R. A. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
15690 15690 1984-05-04 1982-01-22 Conway Daniel J. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
21000 21000 1983-06-30 1978-03-17 McGranery James P. , Jr. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
22437 22437 1982-07-02 1978-04-07 Faron Robert S. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
28009 28009 1979-08-31 1978-10-06 Baughman Beverly A. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
32362 32362 1989-10-06 1982-01-02 Buren Mindy Ann LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
33189 33189 1984-10-19 1978-03-17 Smedresman Peter S. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
33968 33968 1993-10-29 1991-04-10 Eastwood James A. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
33970 33970 1993-10-29 1990-07-17 Robinson Davis R. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
33974 33974 1993-10-29 1990-10-19 Dietz Robert S. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
34958 34958 1994-11-01 1990-03-30 Meagher John K. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
35812 35812 1979-11-15 1978-10-06 Doane E. David LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
35859 35859 1988-11-15 1984-10-16 Richardson John C. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40653 40653 1990-12-31 1983-12-06 Pearson James B. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40810 40810 1995-12-31 1982-01-22 Olney Austin P. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40845 40845 1995-12-31 1991-04-02 Alexander Donna K. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40851 40851 1995-12-31 1994-05-02 Woody Robert W. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40870 40870 1995-12-31 1994-06-22 Michel Mary Patricia LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40884 40884 1995-12-31 1995-07-13 Breggin Linda K. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40885 40885 1995-12-31 1990-07-17 Greene Donald J. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40886 40886 1995-12-31 1990-07-17 Marcoux William C. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40901 40901 1995-12-31 1994-08-31 Hageman Andrea J. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40910 40910 1995-12-31 1995-09-21 Krey James Matthew LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40920 40920 1995-12-31 1993-11-05 Woodward David R. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40923 40923 1995-12-31 1987-11-10 III Charles W. Havens LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40924 40924 1995-12-31 1987-11-10 Landgraf L. Charles LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
40940 40940 1995-12-31 1988-12-01 Mace Jeffrey H. LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 1978-03-17 LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 683.335ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows