FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

211 rows where Registration_Number = 481

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registration_Number

  • 481 · 211 ✖

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
2424 2424 1949-01-01 1947-07-25 Ware Margaret Amy Jessica 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
2425 2425 1950-01-01 1947-07-25 Watson Francis Leslie 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
2481 2481 1971-01-01 1950-08-28 Schoenfeld Lester Alvin 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
3017 3017 1963-01-03 1951-03-02 Ross Mary Alison 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
3926 3926 1950-01-20 1947-07-25 Hodge Thomas 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4099 4099 1966-01-23 1964-01-23 Trout Thomas John 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4190 4190 1990-01-25 1967-01-06 Seymour Gerard Bernard Aidan 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4191 4191 1990-01-25 1949-01-07 Sanders Harold George 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4192 4192 1990-01-25 1955-01-08 Monkhouse Patrick James 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4193 4193 1990-01-25 1950-01-20 Jones Robert Walter 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4194 4194 1990-01-25 1961-01-23 Thomson George Paget 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4195 4195 1990-01-25 1948-01-30 Homan Margaret Furnival 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4196 4196 1990-01-25 1949-01-31 Marples Alfred Ernest 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4197 4197 1990-01-25 1949-01-31 Skeffington-Lodge Thomas Cecil 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4198 4198 1990-01-25 1950-02-01 Mackie Maitland 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4199 4199 1990-01-25 1955-02-01 Miller Maurice Verner 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4200 4200 1990-01-25 1981-02-03 Gale Margaret Jean 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4201 4201 1990-01-25 1975-02-04 Kydd Ian 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4202 4202 1990-01-25 1975-02-04 Wood Marilyn 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4203 4203 1990-01-25 1986-02-04 Hopkinson Mark 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4204 4204 1990-01-25 1949-02-07 Morrah Gertrude Ruth 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4205 4205 1990-01-25 1949-02-08 Hinton Wilfred John 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4206 4206 1990-01-25 1948-02-10 Colonel J.R.H. Hutchinson 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4207 4207 1990-01-25 1954-02-16 Johnston Lily Emily 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4208 4208 1990-01-25 1950-02-20 Jones Violet May Creech 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4209 4209 1990-01-25 1949-02-21 Grenfell David Rhys 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4210 4210 1990-01-25 1967-02-21 MacGinnis Francis Robert 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4211 4211 1990-01-25 1948-02-25 Dunbabin Thomas 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4212 4212 1990-01-25 1949-03-14 Beswick Frank 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4213 4213 1990-01-25 1948-03-23 Charlesworth Lilian Edith 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4214 4214 1990-01-25 1951-03-26 Shonfield Akiba 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4215 4215 1990-01-25 1951-04-09 Morgan William Duthie 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4216 4216 1990-01-25 1951-04-09 Wight Ian Lyttleton 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4217 4217 1990-01-25 1959-04-20 Boyle Edward Charles Burney 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4218 4218 1990-01-25 1961-04-21 Weaver Tobias Rushton 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4219 4219 1990-01-25 1958-04-29 MacDona Brian Fraser 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4220 4220 1990-01-25 1962-05-07 Barker William Alan 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4221 4221 1990-01-25 1950-05-09 Williams Gertrude 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4222 4222 1990-01-25 1950-05-10 Tebbitt Grete Z. 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4223 4223 1990-01-25 1955-05-11 Stephens Peter John 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4224 4224 1990-01-25 1954-05-20 Bannister Roger 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4225 4225 1990-01-25 1977-07-01 Anderson Maureen 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4226 4226 1990-01-25 1965-07-08 Slover Patricia Margaret 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4227 4227 1990-01-25 1971-07-16 Houlton John Ogilvy 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4228 4228 1990-01-25 1947-07-25 Cohen Emmeline Nora Waley 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4229 4229 1990-01-25 1947-07-25 Glemser Bernard 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4230 4230 1990-01-25 1947-07-25 Herrington Margaret Eleanor 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4231 4231 1990-01-25 1947-07-25 Kinghorn Arthur 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4232 4232 1990-01-25 1947-07-25 Littlefield Doris Joan 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4233 4233 1990-01-25 1947-07-25 McOstrich Norman Hector Morris 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4234 4234 1990-01-25 1947-07-25 Raphael Chaim 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4235 4235 1990-01-25 1947-07-25 Sanderson Ivan Terence 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4236 4236 1990-01-25 1947-07-25 Stokes Donald Hubert 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4237 4237 1990-01-25 1947-07-25 Whittlemore Marjorie Bragonier 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4238 4238 1990-01-25 1985-07-25 Raymond Raymond James 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4244 4244 1990-01-25 1950-10-04 King Wilfred Thomas Cousins 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4245 4245 1990-01-25 1947-10-08 Crosthwaite-Eyre Oliver Eyre 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4246 4246 1990-01-25 1947-10-08 Haire John Edwin 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4247 4247 1990-01-25 1989-10-10 Arikian Sarah Catherine Gray 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4248 4248 1990-01-25 1961-10-16 Shortt Arthur Charles 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4249 4249 1990-01-25 1949-10-17 Skeffington Arthur Massey 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4250 4250 1990-01-25 1951-10-22 Bradley Kathleen Isabel 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4251 4251 1990-01-25 1947-10-29 Father Paul Crane 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4252 4252 1990-01-25 1949-11-02 Axon Gordon Vose 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4253 4253 1990-01-25 1949-11-09 Marsden Arthur 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4254 4254 1990-01-25 1949-11-09 Morris Rhys Hopkin 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4255 4255 1990-01-25 1948-11-12 Amory Derick Heathcoat 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4256 4256 1990-01-25 1959-11-12 Shenfield Arthur Asher 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4257 4257 1990-01-25 1950-11-29 Wootton Barbara Frances Wright 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4258 4258 1990-01-25 1950-11-29 Wright Barbara Frances 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4259 4259 1990-01-25 1949-11-30 Banks Arthur Leslie 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4260 4260 1990-01-25 1948-12-02 Bondfield Margaret Grace 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4262 4262 1990-01-25 1987-12-23 Grainger Stewart 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4558 4558 1950-01-30 1947-07-25 Jones Philip Suttill 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4559 4559 1951-01-30 1950-10-27 McHugh James Noel 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4687 4687 1961-01-31 1952-05-02 Strachan Mary Dundas 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
5365 5365 1956-02-01 1949-09-27 Ross James Stirling 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
5366 5366 1956-02-01 1953-09-30 Russell John Wriothesley 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
5676 5676 1973-02-02 1970-02-09 Smith P.J. 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
5723 5723 1950-02-03 1947-07-25 Lazarus Jeanne Marks 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
6129 6129 1953-02-09 1947-07-25 Rolls Muriel Goodwin 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7101 7101 1956-02-24 1956-01-10 Henriques Basil Lucas Quixano 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7169 7169 1955-02-25 1950-07-24 Thompson Charles Robert Lacy 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7413 7413 1950-02-28 1947-07-25 Chadburn John Douglas 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7414 7414 1950-02-28 1947-07-25 Chippani Frank O. 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7427 7427 1959-02-28 1951-01-17 Wright Joyce Agnes 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7429 7429 1961-02-28 1960-01-21 Martin John Reginald 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7961 7961 1952-02-29 1947-07-25 Donohue Ruth Katharine 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
8250 8250 1981-03-01 1977-02-14 Borisovich Vladislav 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
8622 8622 1948-03-05 1948-01-30 Shackleton Edward Arthur Alexander 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
8623 8623 1948-03-05 1947-07-25 Scott Georgina Mary 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
8686 8686 1953-03-06 1953-03-09 Pike Victor Joseph 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9325 9325 1955-03-15 1955-01-21 King Horace Maybray 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9457 9457 1955-03-16 1955-01-21 Wood Richard Frederick 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9547 9547 1961-03-17 1947-07-25 Mitchell Frank 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9770 9770 1948-03-20 1948-01-30 Burton Elaine Frances 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9785 9785 1954-03-20 1954-02-05 Simpson Frank E. W. 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9851 9851 1962-03-21 1947-07-25 Barff Stafford Edward Douglas 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
10255 10255 1948-03-27 1948-02-27 Wallace Harry Wright 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
10336 10336 1953-03-28 1953-02-17 Milner Lord of Leeds 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022

Next page

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)
);
Powered by Datasette · Query took 357.663ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history