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

48 rows where Registration_Number = 3694

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Collier Shannon Scott, PLLC · 48 ✖

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
2684 2684 1989-01-01 1987-11-03 Laufman David H. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
3531 3531 2000-01-10 1987-04-07 Columbus R. Timothy Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
4274 4274 1993-01-22 1988-06-28 Black Robert Randal Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
7516 7516 1989-02-24 1986-11-10 Rubiner Laurie Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
9246 9246 1997-03-06 1985-06-24 Cullen Paul Damien Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
9248 9248 1997-03-06 1987-08-25 O'Connell Kevin Michael Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
9249 9249 1998-03-06 1995-06-06 Raffaniello Patrick J. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
10700 10700 2000-03-24 1999-05-10 Brewster Mary Sue Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
10701 10701 2000-03-24 1996-05-16 Conway Janice E. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
10702 10702 2000-03-24 1985-06-24 Kies Kathleen B. Clark Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
10704 10704 2000-03-24 1985-09-16 Sherman Michael D. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
10706 10706 2000-03-24 1986-11-25 Schneeberger Dana S. Wood Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
16769 16769 2002-05-20 2000-09-25 Koszorus Frank Jr. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
17238 17238 1997-05-27 1996-05-16 Farley Brian P. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
17849 17849 1995-05-31 1990-09-06 Charnas Douglas W. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
20091 20091 1988-06-23 1987-06-25 Coffey Anne Mundell Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
20224 20224 1986-06-25 1985-06-24 Fitz-Simons Daniel W. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
20225 20225 1987-06-25 1986-12-15 Cohn Steven D. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
20246 20246 1999-06-25 1998-07-06 Lopez Daniel Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
22854 22854 1999-07-09 1986-01-09 Villafranco John E. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
23929 23929 1996-07-23 1986-04-21 Ausbrook J. Keith Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
24841 24841 1991-07-31 1986-10-28 Payne Ana Abigail Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
26607 26607 1986-08-14 1985-06-24 Schuyler Christopher J. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
27346 27346 1993-08-24 1990-02-20 Lenrow Gerald I. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
27348 27348 1993-08-24 1990-04-20 Allen Pamela J. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
27349 27349 1993-08-24 1992-05-27 McIntosh Joanna K. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
27350 27350 1993-08-24 1985-06-24 Weaver Kathleen T. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
27351 27351 1993-08-24 1985-06-25 Stehl Carol B. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
27352 27352 1993-08-24 1987-06-25 Harrold Daniel J. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
27353 27353 1993-08-24 1987-06-25 Jankowski Thomas Michael Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
27354 27354 1993-08-24 1987-06-25 Shortley Elizabeth G. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
29174 29174 2002-09-04 1996-08-23 Freeman Helen Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
30382 30382 1999-09-24 1985-09-19 Fazzone Patrick Brock Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
30602 30602 1991-09-27 1989-01-05 Giordano Nicholas D. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
36790 36790 1995-11-30 1990-08-14 Rider Amy R. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
37727 37727 1987-12-04 1987-07-14 Harman Charles E. , Jr. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
38567 38567 1999-12-17 1992-06-22 Kershow Michael R. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
38867 38867 1989-12-21 1986-02-04 Mitchell Christopher Howard Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
38932 38932 1987-12-22 1985-06-24 Dansky Michael J. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
39054 39054 1986-12-24 1985-06-24 O'Connell K. Michael Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
39055 39055 1986-12-24 1985-06-24 Lasoff Laurence J. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
39056 39056 1986-12-24 1985-06-24 Meuser Robert L. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
39057 39057 1986-12-24 1985-08-02 Forch Jeanne M. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
39093 39093 2003-12-24 1990-04-20 Hartquist David Alan Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
39094 39094 2003-12-24 1990-04-20 Porter Robert William , Jr. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
40689 40689 1991-12-31 1985-06-24 Allen Pamela Joyce Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
40789 40789 1994-12-31 1985-06-24 Shannon Thomas F. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
41232 41232 2001-12-31 1985-06-24 Scott William W. Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108

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