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

92 rows where City = "New York" and Registrant_Name = "VisitBritain"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date (date)

State 1

Registration_Number 1

Registrant_Name 1

  • VisitBritain · 92 ✖

City 1

  • New York · 92 ✖
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
692 692   2016-03-30 Ruttle Courtney VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
889 889   2017-04-27 Gauger Paul VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
955 955   2018-05-03 Berry Cait VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
956 956   2018-05-03 Landry Gavin VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
960 960   2021-05-05 Bailey Elyse VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
961 961   2021-05-05 Didi Tara VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
962 962   2021-05-05 Gordin Julia VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
963 963   2021-05-05 Heasman Jonathan VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
964 964   2021-05-05 Heller Leila VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
965 965   2021-05-05 Jungkurth Allison VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
968 968   2021-05-05 McKay Tiffany VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
970 970   2021-05-05 Wylie Sheelagh VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1922 1922   2013-10-09 Nase Stephen VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1923 1923   2013-10-09 Paone Helen VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1924 1924   2013-10-09 Sjolund Lisa VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
1925 1925   2013-10-09 Walsh Carl VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
3458 3458 2019-01-08 2017-04-27 Gonzalez Diana VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
4593 4593 2018-01-26 2013-10-09 Pearson Meredith VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
4992 4992 1984-01-31 1953-02-06 Newman Helen Gertrude Doris VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
5001 5001 1985-01-31 1984-05-17 Samson Donna L. VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
5051 5051 1990-01-31 1989-03-28 Spain David VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
5664 5664 1967-02-01 1964-04-28 Houlton Frank William VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
6994 6994 2019-02-15 2018-05-03 Nemeth Erin VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
7258 7258 2016-02-19 2015-04-27 Brow Nicole VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
7845 7845 1967-02-28 1965-12-27 Jackson Humphry Archard VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
8179 8179 2005-02-28 1990-04-05 Rahaman John Peter VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
8616 8616 1954-03-01 1953-02-06 Booty Stanley Clifford Harold VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
8665 8665 1970-03-01 1967-05-01 Wardle John VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
8914 8914 2019-03-01 2017-04-27 Sklencar John VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
9747 9747 2015-03-12 2014-04-14 Medway Kellen VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
11449 11449 1975-03-31 1973-05-01 Serritello Daniel J. VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
12191 12191 2016-03-31 2013-10-09 Early Katrina VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
12978 12978 2022-04-08 2017-04-27 Barnes Tara VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
13594 13594 2016-04-16 2016-03-30 Kroon-Fiorita Brigitta VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
13764 13764 2016-04-19 2014-04-14 O'Malley Dana VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
14134 14134 1975-04-26 1954-08-03 Bassett Helen Marjory Jessup VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
14530 14530 1982-04-30 1953-02-06 Harmshaw Dorothy Lilian VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
14532 14532 1982-04-30 1973-05-01 Glaze Andrew L. VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
15038 15038 2011-04-30 2007-09-28 Orme Christopher VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
15268 15268 2022-04-30 2021-05-05 Easley Callie VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
15331 15331 1973-05-01 1970-11-16 Batchelor Richard VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
15372 15372 1985-05-01 1981-10-30 Kelly Clement Frank VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
16490 16490 2020-05-15 2018-05-03 Grillo Jeffrey VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
17106 17106 2022-05-25 2021-05-05 Roney Erica VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
17359 17359 2000-05-29 1986-10-28 Younger Julian William Richard VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
17383 17383 2018-05-29 2013-10-09 Summers Lauren VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
17528 17528 2017-05-30 2016-03-30 Rogoz Ellen VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
17589 17589 1961-05-31 1956-08-01 Spooner Alexander Patrick VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
17643 17643 1978-05-31 1953-03-06 Antrobus Edmund VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
17650 17650 1978-05-31 1949-07-07 Clark Kenneth William Frank VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
18149 18149 2015-05-31 2013-10-09 De Vadder Emma VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
18410 18410 1972-06-01 1969-09-22 Gover Peter William VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
20594 20594 2018-06-29 2017-04-27 Johnson Caitlin VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
21850 21850 2016-06-30 2011-04-26 Clarkson Karen VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
22028 22028 1951-07-01 1949-07-07 Boulton Harold VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
22033 22033 1955-07-01 1954-08-03 Marsh Anthony George VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
22246 22246 1994-07-01 1988-05-10 Franklin Robert Keyworth VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
22249 22249 1994-07-01 1989-12-13 Walsh Jane VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
23702 23702 1955-07-21 1954-08-03 Read Lawrence Vaughan VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
23703 23703 1955-07-21 1954-08-03 White Anthony John Frith VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
24343 24343 1953-07-29 1953-02-06 Fifield Flora VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
24448 24448 1962-07-30 1958-06-16 Koyen Kenneth Albert VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
25277 25277 2015-07-31 2013-10-09 Simmons Joanne VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
25442 25442 1958-08-01 1955-07-21 Roberts Douglas Charles VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
25964 25964 2015-08-04 2013-10-09 Mennella Jennifer VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
26466 26466 2017-08-11 2014-03-06 Harrison Kelly VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
27883 27883 1972-08-31 1956-01-31 Priesack Laurence Emile VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
28129 28129 1988-08-31 1986-11-21 Montgomery Melvyn Grantham VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
28269 28269 1995-08-31 1978-10-31 Pace Bedford VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
28486 28486 2006-08-31 2005-10-04 Reid Justin VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
28634 28634 2018-08-31 2014-03-06 Novick Joshua VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
29292 29292 2019-09-06 2018-08-14 Pitchley Caroline VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
29409 29409 1983-09-08 1967-05-01 Leahy Kenneth Edward VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
29656 29656 2019-09-12 2018-05-03 Lynn Chris VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
30191 30191 1981-09-21 1949-07-07 Turbayne James Terris VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
30285 30285 2015-09-22 2013-10-09 Scott Laurie VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
30325 30325 2017-09-23 2016-03-30 Levy Rachel VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
30848 30848 1964-09-30 1961-07-17 Borley Lester VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
30863 30863 1965-09-30 1964-11-04 Harding Peter Beverley VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
31036 31036 1989-09-30 1985-05-28 McCormick Jeri VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
31038 31038 1989-09-30 1986-11-12 Smith David Martin VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
31311 31311 2003-09-30 1990-05-22 Braganza Christine VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
31553 31553 2013-09-30 2013-10-09 O'Connell Kathleen VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
31767 31767 1956-10-01 1951-03-05 Martin Donald Neil VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
34953 34953 1993-11-01 1988-05-10 Lovell Timothy Shaw VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
34954 34954 1993-11-01 1985-05-28 Ford Donald Leslie VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
37216 37216 1949-12-01 1949-07-07 Plimmer Florence Louise VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
38131 38131 2015-12-11 2013-10-09 Scott Kirsteen VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
39830 39830 1966-12-31 1960-08-11 Crabb Donald Frederick VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
40341 40341 1985-12-31 1982-11-23 Spain David Andrew VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
40360 40360 1986-12-31 1974-05-07 Roberts R. Lewis VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
42120 42120 2017-12-31 2017-04-27 Kamm Jennifer VisitBritain 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])
);