FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

62 rows where Registration_Number = 3076

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Mayer, Brown & Platt · 62 ✖

Registrant_Name 1

City 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
3181 3181 1994-01-04 1992-12-23 Kriesberg Simeon M. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5063 5063 1990-01-31 1979-12-13 Bloom David I. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5064 5064 1990-01-31 1979-12-13 Fread Joan P. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5078 5078 1991-01-31 1989-07-12 Fahner Tyrone C. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5091 5091 1991-01-31 1989-09-18 Nathan Amy L. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5098 5098 1992-01-31 1991-02-05 Gould Arthur I. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5132 5132 1994-01-31 1986-09-16 Breakstone Donald S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5172 5172 1997-01-31 1997-01-31 Crane David C. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5173 5173 1997-01-31 1997-01-31 Osolinik Carolyn P. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5174 5174 1997-01-31 1997-01-31 Walden Gregory S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5175 5175 1997-01-31 1997-01-31 Williamson Richard S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5789 5789 1994-02-01 1986-09-16 Berens Mark H. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5791 5791 1994-02-01 1979-12-13 Helman Robert A. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
5792 5792 1994-02-01 1992-12-23 Bock Paul S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
6178 6178 1993-02-05 1988-03-29 Swart Robert H. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
13705 13705 1996-04-18 1996-01-31 Lynch Kimberly A. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
13798 13798 1992-04-20 1989-07-12 Williamson Richard S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
13875 13875 1995-04-21 1994-11-16 Bock Paul S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
14083 14083 1980-04-25 1979-12-13 Hermes Steven W. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
16057 16057 1990-05-11 1989-09-19 Biel Eric R. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
18983 18983 1990-06-06 1989-09-19 Levy Charles S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
21148 21148 1991-06-30 1990-04-13 Stevenson Adlai E. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
24371 24371 1994-07-29 1994-02-01 Roshanian Tamineh Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
24720 24720 1981-07-31 1979-12-13 Henderson James R. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
24833 24833 1991-07-31 1989-09-18 Barton Gregory L. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
24834 24834 1991-07-31 1989-09-18 Goeke Joseph R. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
24835 24835 1991-07-31 1989-09-18 Jones Erika Z. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
24836 24836 1991-07-31 1989-09-18 Williamson Joel V. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
24837 24837 1991-07-31 1989-09-19 Kriesberg Simeon M. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
24856 24856 1992-07-31 1979-12-13 Gordon Jeffrey I. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
27520 27520 1992-08-27 1989-09-18 Gitenstein Mark H. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
28206 28206 1991-08-31 1989-09-08 Massey William L. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
29410 29410 1987-09-08 1984-02-10 Chu Charles Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
29986 29986 1990-09-17 1988-02-22 Daley William M. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
32858 32858 1984-10-15 1979-12-13 Mitchell James L. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
33022 33022 1996-10-16 1989-07-12 Hanbury Marshall E. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
34218 34218 1980-10-31 1979-12-13 Petty Charles W. , Jr. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
35951 35951 1994-11-16 1994-11-16 Pincus Andrew J. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
35992 35992 1989-11-17 1989-09-18 Weinberg Hillel Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
36376 36376 1994-11-25 1990-04-13 Madara Edward S. , III Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
37444 37444 1995-12-01 1990-04-13 Capatides Michael G. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
38111 38111 1987-12-11 1980-04-29 Levy Charles S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
38165 38165 1986-12-12 1986-09-16 Mangefrida David J. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
38550 38550 1992-12-17 1992-08-17 Nathan Amy L. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40730 40730 1991-12-31 1979-12-13 Smith Richard M. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40821 40821 1995-12-31 1994-02-14 Schmitz John P. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40824 40824 1995-12-31 1995-02-27 Walden Gregory S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40907 40907 1995-12-31 1986-09-16 Oppenheimer Jerry L. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40925 40925 1995-12-31 1994-11-16 Daley William M. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40926 40926 1995-12-31 1994-11-16 Favretto Richard J. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40927 40927 1995-12-31 1994-11-16 Hein Werner J. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40928 40928 1995-12-31 1994-11-16 Larsen Kim D. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40932 40932 1995-12-31 1995-11-22 Morris Donald C. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40935 40935 1995-12-31 1993-11-30 Gilman Michael I. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40936 40936 1995-12-31 1993-11-30 Kaplan Wayne S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40937 40937 1995-12-31 1993-11-30 Knox James Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40939 40939 1995-12-31 1993-11-30 Smith Brian Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40958 40958 1996-12-31 1996-02-09 Ahn Nelson K. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
41008 41008 1997-12-31 1996-02-09 Chan Jean S. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
41048 41048 1997-12-31 1996-08-12 Greene David Christopher Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
41056 41056 1997-12-31 1986-09-16 McKee Harold E. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
41057 41057 1997-12-31 1986-09-16 Whitney Karen L. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882

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])
);