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

49 rows where City = "Sacramento"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Zip, Short_Form_Termination_Date (date), Registration_Date (date)

State 1

City 1

  • Sacramento · 49 ✖
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
1382 1382   2009-07-10 Ficker Jared California Strategies & Advocacy, LLC 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1383 1383   2009-07-10 Kinney Jason California Strategies & Advocacy, LLC 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1384 1384   2009-07-10 White Robert California Strategies & Advocacy, LLC 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
3595 3595 2017-01-11 2014-09-09 Murrell Laura KP Public Affairs, LLC 6248 2014-09-09 KP Public Affairs, LLC 1201 K Street Suite 800 Sacramento CA 95814
3680 3680 2017-01-13 2016-02-09 Hayes Gregory KP Public Affairs, LLC 6248 2014-09-09 KP Public Affairs, LLC 1201 K Street Suite 800 Sacramento CA 95814
3681 3681 2017-01-13 2014-09-09 Burns Michael KP Public Affairs, LLC 6248 2014-09-09 KP Public Affairs, LLC 1201 K Street Suite 800 Sacramento CA 95814
3682 3682 2017-01-13 2014-09-09 MacLeod Alison KP Public Affairs, LLC 6248 2014-09-09 KP Public Affairs, LLC 1201 K Street Suite 800 Sacramento CA 95814
3683 3683 2017-01-13 2014-09-09 Yarbrough Lisa KP Public Affairs, LLC 6248 2014-09-09 KP Public Affairs, LLC 1201 K Street Suite 800 Sacramento CA 95814
4865 4865 2015-01-30 2014-09-09 Minor Chelsea KP Public Affairs, LLC 6248 2014-09-09 KP Public Affairs, LLC 1201 K Street Suite 800 Sacramento CA 95814
6573 6573 1993-02-10 1989-01-13 Macpherson Donald J.A. Revell Communications 4204 1989-01-11 Revell Communications 1121 L Street Suite 806 Sacramento CA 95814-3926
8777 8777 1990-03-01 1989-08-30 Speer Leesa B. Burns, Donald Carlton 3990 1987-05-29 Burns, Donald Carlton 1107 Ninth Street Suite 660 Sacramento CA 95814
12256 12256 2020-03-31 2016-01-20 Larson Stephen California Strategies, LLC 6337 2016-01-20 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
12257 12257 2020-03-31 2016-01-20 McEfee Camden S. California Strategies, LLC 6337 2016-01-20 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
12482 12482 1989-04-01 1988-07-29 Treat Paula Greve, Clifford, Diepenbrock & Paras 4163 1988-07-29 Greve, Clifford, Diepenbrock & Paras 1000 G Street, Suite 400 Post Office Box 2469 Sacramento CA 95812-2469
15827 15827 2006-05-06 2005-05-10 Afghari Kelley Russo Marsh & Rogers 5682 2005-05-10 Russo Marsh & Rogers 770 L Street # 950 Sacramento CA 95814
16078 16078 2016-05-11 2015-02-27 Smith Emily Lynn KP Public Affairs, LLC 6248 2014-09-09 KP Public Affairs, LLC 1201 K Street Suite 800 Sacramento CA 95814
16596 16596 1989-05-17 1989-01-13 Weigt Jill Revell Communications 4204 1989-01-11 Revell Communications 1121 L Street Suite 806 Sacramento CA 95814-3926
17057 17057 2006-05-24 2005-05-10 Callahan Shawn Russo Marsh & Rogers 5682 2005-05-10 Russo Marsh & Rogers 770 L Street # 950 Sacramento CA 95814
17448 17448 1989-05-30 1988-07-29 Keene Scott R. Greve, Clifford, Diepenbrock & Paras 4163 1988-07-29 Greve, Clifford, Diepenbrock & Paras 1000 G Street, Suite 400 Post Office Box 2469 Sacramento CA 95812-2469
18003 18003 2006-05-31 2005-05-10 Lorenz Douglas Russo Marsh & Rogers 5682 2005-05-10 Russo Marsh & Rogers 770 L Street # 950 Sacramento CA 95814
18004 18004 2006-05-31 2005-05-10 Russo Salvatore B. Russo Marsh & Rogers 5682 2005-05-10 Russo Marsh & Rogers 770 L Street # 950 Sacramento CA 95814
18005 18005 2006-05-31 2005-05-10 Wierzbicki Joe Russo Marsh & Rogers 5682 2005-05-10 Russo Marsh & Rogers 770 L Street # 950 Sacramento CA 95814
21123 21123 1989-06-30 1988-07-29 Gray Joe S. Greve, Clifford, Diepenbrock & Paras 4163 1988-07-29 Greve, Clifford, Diepenbrock & Paras 1000 G Street, Suite 400 Post Office Box 2469 Sacramento CA 95812-2469
25157 25157 2009-07-31 2009-06-30 South Garry California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
26311 26311 1993-08-09 1989-01-11 Revell Dennis C. Revell Communications 4204 1989-01-11 Revell Communications 1121 L Street Suite 806 Sacramento CA 95814-3926
26569 26569 2022-08-13 2021-12-18 Bustamante Michael California Strategies, LLC 7061 2021-12-18 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
26570 26570 2022-08-13 2021-12-18 Klink Matthew California Strategies, LLC 7061 2021-12-18 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
26571 26571 2022-08-13 2021-12-18 Kozberg Joanne California Strategies, LLC 7061 2021-12-18 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
26644 26644 2015-08-14 2015-06-17 Plummer Timothy KP Public Affairs, LLC 6248 2014-09-09 KP Public Affairs, LLC 1201 K Street Suite 800 Sacramento CA 95814
28540 28540 2009-08-31 2009-06-30 Emerson Ed California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
28936 28936 2005-09-01 2006-03-02 Dohn Kari GCG Rose & Kindel 5694 2005-07-07 GCG Rose & Kindel 915 L Street Suite 1210 Sacramento CA 95814
28937 28937 2005-09-01 2006-03-02 London Carl E. GCG Rose & Kindel 5694 2005-07-07 GCG Rose & Kindel 915 L Street Suite 1210 Sacramento CA 95814
28938 28938 2005-09-01 2006-03-02 Martin Rand GCG Rose & Kindel 5694 2005-07-07 GCG Rose & Kindel 915 L Street Suite 1210 Sacramento CA 95814
28939 28939 2005-09-01 2006-03-02 Rose Cristina GCG Rose & Kindel 5694 2005-07-07 GCG Rose & Kindel 915 L Street Suite 1210 Sacramento CA 95814
29416 29416 1989-09-08 1989-01-13 Gaylord Susannah Revell Communications 4204 1989-01-11 Revell Communications 1121 L Street Suite 806 Sacramento CA 95814-3926
31466 31466 2009-09-30 1991-05-14 Keene Scott R. Keene & Associates 4511 1991-05-14 Keene & Associates P.O. Box 161840 1400 N Street, Suite 8 Sacramento CA 95816
34610 34610 2011-10-31 2010-02-18 Hale Greg California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
34612 34612 2011-10-31 2010-03-05 McLarty Robert California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
34626 34626 2011-10-31 2009-06-30 Bustamante Michael California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
34627 34627 2011-10-31 2009-06-30 Fabiani Mark California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
34628 34628 2011-10-31 2009-06-30 Ford Devon California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
34629 34629 2011-10-31 2009-06-30 Kinney Jason California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
34630 34630 2011-10-31 2009-06-30 Lehane Christopher S. California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
34631 34631 2011-10-31 2009-07-10 Ragone Peter California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
34633 34633 2011-10-31 2010-09-07 Ignazio Glenn California Strategies, LLC 5889 2008-10-14 California Strategies, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
40606 40606 1990-12-31 1990-02-09 Defenbaugh J. Lyle Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe 555 Capitol Mall Suite 1200 Sacramento CA 95814
40626 40626 1990-12-31 1989-06-12 Bruner James W. , Jr. Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe 555 Capitol Mall Suite 1200 Sacramento CA 95814
40636 40636 1990-12-31 1989-07-28 Keene Scott R. Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe 555 Capitol Mall Suite 1200 Sacramento CA 95814
40637 40637 1990-12-31 1989-07-28 Nelson Robert P. , Jr. Orrick, Herrington & Sutcliffe 4266 1989-06-12 Orrick, Herrington & Sutcliffe 555 Capitol Mall Suite 1200 Sacramento CA 95814

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