List of all short form registrants (active and terminated)

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

92 rows where Registration_Number = 579

View and edit SQL

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

State

Registration_Number

  • 579 · 92

Registrant_Name

City

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
43     Wylie Sheelagh 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
611   2016-03-30 Kroon-Fiorita Brigitta 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
613   2016-03-30 Ruttle Courtney 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
702   2014-04-14 O'Malley Dana 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
774   2011-04-26 Clarkson Karen 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
788   2017-04-27 Barnes Tara 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
789   2017-04-27 Gauger Paul 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
871   2018-05-03 Berry Cait 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
872   2018-05-03 Landry Gavin 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
879   2021-05-05 Bailey Elyse 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
880   2021-05-05 Davary Leila 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
881   2021-05-05 Didi Tara 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
882   2021-05-05 Easley Callie 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
883   2021-05-05 Gordin Julia 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
884   2021-05-05 Heasman Jonathan 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
885   2021-05-05 Jungkurth Allison 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
888   2021-05-05 McKay Tiffany 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
889   2021-05-05 Roney Erica 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1713   2013-10-09 Early Katrina 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1714   2013-10-09 Nase Stephen 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1715   2013-10-09 Paone Helen 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1716   2013-10-09 Scott Kirsteen 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1717   2013-10-09 Sjolund Lisa 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1718   2013-10-09 Walsh Carl 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
3192 2019-01-08 2017-04-27 Gonzalez Diana 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
4298 2018-01-26 2013-10-09 Pearson Meredith 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
4684 1984-01-31 1953-02-06 Newman Helen Gertrude Doris 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
4693 1985-01-31 1984-05-17 Samson Donna L. 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
4743 1990-01-31 1989-03-28 Spain David 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
5335 1967-02-01 1964-04-28 Houlton Frank William 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
6621 2019-02-15 2018-05-03 Nemeth Erin 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
6877 2016-02-19 2015-04-27 Brow Nicole 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
7450 1967-02-28 1965-12-27 Jackson Humphry Archard 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
7784 2005-02-28 1990-04-05 Rahaman John Peter 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
8194 1954-03-01 1953-02-06 Booty Stanley Clifford Harold 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
8243 1970-03-01 1967-05-01 Wardle John 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
8492 2019-03-01 2017-04-27 Sklencar John 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
9260 2015-03-12 2014-04-14 Medway Kellen 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
10940 1975-03-31 1973-05-01 Serritello Daniel J. 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
13507 1975-04-26 1954-08-03 Bassett Helen Marjory Jessup 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
13893 1982-04-30 1953-02-06 Harmshaw Dorothy Lilian 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
13895 1982-04-30 1973-05-01 Glaze Andrew L. 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
14401 2011-04-30 2007-09-28 Orme Christopher 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
14641 1973-05-01 1970-11-16 Batchelor Richard 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
14682 1985-05-01 1981-10-30 Kelly Clement Frank 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
15728 2020-05-15 2018-05-03 Grillo Jeffrey 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
16576 2000-05-29 1986-10-28 Younger Julian William Richard 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
16600 2018-05-29 2013-10-09 Summers Lauren 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
16743 2017-05-30 2016-03-30 Rogoz Ellen 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
16801 1961-05-31 1956-08-01 Spooner Alexander Patrick 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
16855 1978-05-31 1953-03-06 Antrobus Edmund 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
16862 1978-05-31 1949-07-07 Clark Kenneth William Frank 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
17361 2015-05-31 2013-10-09 De Vadder Emma 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
17567 1972-06-01 1969-09-22 Gover Peter William 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
19679 2018-06-29 2017-04-27 Johnson Caitlin 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
21044 1951-07-01 1949-07-07 Boulton Harold 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
21049 1955-07-01 1954-08-03 Marsh Anthony George 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
21262 1994-07-01 1988-05-10 Franklin Robert Keyworth 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
21265 1994-07-01 1989-12-13 Walsh Jane 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
22658 1955-07-21 1954-08-03 Read Lawrence Vaughan 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
22659 1955-07-21 1954-08-03 White Anthony John Frith 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
23263 1953-07-29 1953-02-06 Fifield Flora 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
23366 1962-07-30 1958-06-16 Koyen Kenneth Albert 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
24193 2015-07-31 2013-10-09 Simmons Joanne 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
24328 1958-08-01 1955-07-21 Roberts Douglas Charles 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
24829 2015-08-04 2013-10-09 Mennella Jennifer 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
25328 2017-08-11 2014-03-06 Harrison Kelly 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
26694 1972-08-31 1956-01-31 Priesack Laurence Emile 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
26940 1988-08-31 1986-11-21 Montgomery Melvyn Grantham 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
27080 1995-08-31 1978-10-31 Pace Bedford 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
27297 2006-08-31 2005-10-04 Reid Justin 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
27446 2018-08-31 2014-03-06 Novick Joshua 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
28075 2019-09-06 2018-08-14 Pitchley Caroline 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
28192 1983-09-08 1967-05-01 Leahy Kenneth Edward 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
28424 2019-09-12 2018-05-03 Lynn Chris 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
28942 1981-09-21 1949-07-07 Turbayne James Terris 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
29035 2015-09-22 2013-10-09 Scott Laurie 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
29073 2017-09-23 2016-03-30 Levy Rachel 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
29589 1964-09-30 1961-07-17 Borley Lester 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
29604 1965-09-30 1964-11-04 Harding Peter Beverley 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
29777 1989-09-30 1985-05-28 McCormick Jeri 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
29779 1989-09-30 1986-11-12 Smith David Martin 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
30052 2003-09-30 1990-05-22 Braganza Christine 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
30295 2013-09-30 2013-10-09 O'Connell Kathleen 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
30462 1956-10-01 1951-03-05 Martin Donald Neil 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
33559 1993-11-01 1988-05-10 Lovell Timothy Shaw 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
33560 1993-11-01 1985-05-28 Ford Donald Leslie 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
35721 1949-12-01 1949-07-07 Plimmer Florence Louise 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
38264 1966-12-31 1960-08-11 Crabb Donald Frederick 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
38775 1985-12-31 1982-11-23 Spain David Andrew 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
38794 1986-12-31 1974-05-07 Roberts R. Lewis 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
40554 2017-12-31 2017-04-27 Kamm Jennifer 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017

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