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

13 rows where State = "AR"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_1, Address_2, Zip

State 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
6989 6989 2017-02-15 2016-08-11 Benham Terrell E. Impact Management Group 6369 2016-08-11 Impact Management Group 124 W Capitol Avenue Suite 1886 Little Rock AR 72201
9642 9642 1994-03-11 1994-03-11 Johns Michael R. Dover & Dixon, P.A. 4824 1993-06-29 Dover & Dixon, P.A. 425 West Capitol Suite 3700 Little Rock AR 72201
9643 9643 1994-03-11 1994-03-11 Peace John B. Dover & Dixon, P.A. 4824 1993-06-29 Dover & Dixon, P.A. 425 West Capitol Suite 3700 Little Rock AR 72201
9644 9644 1994-03-11 1994-03-11 Purvis Joseph H. Dover & Dixon, P.A. 4824 1993-06-29 Dover & Dixon, P.A. 425 West Capitol Suite 3700 Little Rock AR 72201
9645 9645 1994-03-11 1994-03-11 Stone Thomas S. Dover & Dixon, P.A. 4824 1993-06-29 Dover & Dixon, P.A. 425 West Capitol Suite 3700 Little Rock AR 72201
13291 13291 1993-04-13 1992-10-19 Ford Russell Sanyo Manufacturing Corporation 4722 1992-10-19 Sanyo Manufacturing Corporation 333 Sanyo Road   Forrest City AR 72335
15700 15700 1993-05-04 1992-05-11 Monroe Ark , III Mitchell, Williams, Selig, Gates & Woodyard 4663 1992-05-11 Mitchell, Williams, Selig, Gates & Woodyard 320 West Capitol Street Suite 1000 Little Rock AR 72201-3525
15701 15701 1993-05-04 1992-05-20 Campbell Frederick K. Mitchell, Williams, Selig, Gates & Woodyard 4663 1992-05-11 Mitchell, Williams, Selig, Gates & Woodyard 320 West Capitol Street Suite 1000 Little Rock AR 72201-3525
26452 26452 1992-08-11 1989-08-28 Weaver A. Vernon Stephens Overseas Services, Inc. 4283 1989-08-28 Stephens Overseas Services, Inc. 111 Center Street Post Office Box 3507 Little Rock AR 72203
28545 28545 2010-08-31 2009-02-04 Martin David Cranford Johnson Robinson Woods, Inc. 5905 2009-02-04 Cranford Johnson Robinson Woods, Inc. 303 W. Capitol Center Capitol Avenue Little Rock AR 72201
36773 36773 1994-11-30 1994-05-17 Catlett S. Graham Catlett & Yancey, PLC 4914 1994-05-17 Catlett & Yancey, PLC 1800 Tower Building 323 Center Street Little Rock AR 72201
36774 36774 1994-11-30 1994-05-17 Yancey H. Lawrence Catlett & Yancey, PLC 4914 1994-05-17 Catlett & Yancey, PLC 1800 Tower Building 323 Center Street Little Rock AR 72201
40738 40738 1992-12-31 1992-05-11 Narey Sally B. Mitchell, Williams, Selig, Gates & Woodyard 4663 1992-05-11 Mitchell, Williams, Selig, Gates & Woodyard 320 West Capitol Street Suite 1000 Little Rock AR 72201-3525

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