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, atom, 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
2366 2366 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
2367 2367 1950-01-01 1947-07-25 Watson Francis Leslie 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
2423 2423 1971-01-01 1950-08-28 Schoenfeld Lester Alvin 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
2957 2957 1963-01-03 1951-03-02 Ross Mary Alison 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
3859 3859 1950-01-20 1947-07-25 Hodge Thomas 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4031 4031 1966-01-23 1964-01-23 Trout Thomas John 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4121 4121 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
4122 4122 1990-01-25 1949-01-07 Sanders Harold George 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4123 4123 1990-01-25 1955-01-08 Monkhouse Patrick James 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4124 4124 1990-01-25 1950-01-20 Jones Robert Walter 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4125 4125 1990-01-25 1961-01-23 Thomson George Paget 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4126 4126 1990-01-25 1948-01-30 Homan Margaret Furnival 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4127 4127 1990-01-25 1949-01-31 Marples Alfred Ernest 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4128 4128 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
4129 4129 1990-01-25 1950-02-01 Mackie Maitland 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4130 4130 1990-01-25 1955-02-01 Miller Maurice Verner 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4131 4131 1990-01-25 1981-02-03 Gale Margaret Jean 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4132 4132 1990-01-25 1975-02-04 Kydd Ian 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4133 4133 1990-01-25 1975-02-04 Wood Marilyn 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4134 4134 1990-01-25 1986-02-04 Hopkinson Mark 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4135 4135 1990-01-25 1949-02-07 Morrah Gertrude Ruth 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4136 4136 1990-01-25 1949-02-08 Hinton Wilfred John 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4137 4137 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
4138 4138 1990-01-25 1954-02-16 Johnston Lily Emily 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4139 4139 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
4140 4140 1990-01-25 1949-02-21 Grenfell David Rhys 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4141 4141 1990-01-25 1967-02-21 MacGinnis Francis Robert 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4142 4142 1990-01-25 1948-02-25 Dunbabin Thomas 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4143 4143 1990-01-25 1949-03-14 Beswick Frank 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4144 4144 1990-01-25 1948-03-23 Charlesworth Lilian Edith 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4145 4145 1990-01-25 1951-03-26 Shonfield Akiba 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4146 4146 1990-01-25 1951-04-09 Morgan William Duthie 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4147 4147 1990-01-25 1951-04-09 Wight Ian Lyttleton 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4148 4148 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
4149 4149 1990-01-25 1961-04-21 Weaver Tobias Rushton 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4150 4150 1990-01-25 1958-04-29 MacDona Brian Fraser 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4151 4151 1990-01-25 1962-05-07 Barker William Alan 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4152 4152 1990-01-25 1950-05-09 Williams Gertrude 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4153 4153 1990-01-25 1950-05-10 Tebbitt Grete Z. 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4154 4154 1990-01-25 1955-05-11 Stephens Peter John 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4155 4155 1990-01-25 1954-05-20 Bannister Roger 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4156 4156 1990-01-25 1977-07-01 Anderson Maureen 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4157 4157 1990-01-25 1965-07-08 Slover Patricia Margaret 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4158 4158 1990-01-25 1971-07-16 Houlton John Ogilvy 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4159 4159 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
4160 4160 1990-01-25 1947-07-25 Glemser Bernard 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4161 4161 1990-01-25 1947-07-25 Herrington Margaret Eleanor 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4162 4162 1990-01-25 1947-07-25 Kinghorn Arthur 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4163 4163 1990-01-25 1947-07-25 Littlefield Doris Joan 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4164 4164 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
4165 4165 1990-01-25 1947-07-25 Raphael Chaim 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4166 4166 1990-01-25 1947-07-25 Sanderson Ivan Terence 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4167 4167 1990-01-25 1947-07-25 Stokes Donald Hubert 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4168 4168 1990-01-25 1947-07-25 Whittlemore Marjorie Bragonier 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4169 4169 1990-01-25 1985-07-25 Raymond Raymond James 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4175 4175 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
4176 4176 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
4177 4177 1990-01-25 1947-10-08 Haire John Edwin 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4178 4178 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
4179 4179 1990-01-25 1961-10-16 Shortt Arthur Charles 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4180 4180 1990-01-25 1949-10-17 Skeffington Arthur Massey 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4181 4181 1990-01-25 1951-10-22 Bradley Kathleen Isabel 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4182 4182 1990-01-25 1947-10-29 Father Paul Crane 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4183 4183 1990-01-25 1949-11-02 Axon Gordon Vose 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4184 4184 1990-01-25 1949-11-09 Marsden Arthur 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4185 4185 1990-01-25 1949-11-09 Morris Rhys Hopkin 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4186 4186 1990-01-25 1948-11-12 Amory Derick Heathcoat 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4187 4187 1990-01-25 1959-11-12 Shenfield Arthur Asher 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4188 4188 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
4189 4189 1990-01-25 1950-11-29 Wright Barbara Frances 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4190 4190 1990-01-25 1949-11-30 Banks Arthur Leslie 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4191 4191 1990-01-25 1948-12-02 Bondfield Margaret Grace 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4193 4193 1990-01-25 1987-12-23 Grainger Stewart 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4487 4487 1950-01-30 1947-07-25 Jones Philip Suttill 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4488 4488 1951-01-30 1950-10-27 McHugh James Noel 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
4612 4612 1961-01-31 1952-05-02 Strachan Mary Dundas 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
5277 5277 1956-02-01 1949-09-27 Ross James Stirling 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
5278 5278 1956-02-01 1953-09-30 Russell John Wriothesley 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
5588 5588 1973-02-02 1970-02-09 Smith P.J. 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
5635 5635 1950-02-03 1947-07-25 Lazarus Jeanne Marks 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
6034 6034 1953-02-09 1947-07-25 Rolls Muriel Goodwin 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
6995 6995 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
7063 7063 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
7304 7304 1950-02-28 1947-07-25 Chadburn John Douglas 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7305 7305 1950-02-28 1947-07-25 Chippani Frank O. 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7318 7318 1959-02-28 1951-01-17 Wright Joyce Agnes 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7320 7320 1961-02-28 1960-01-21 Martin John Reginald 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
7846 7846 1952-02-29 1947-07-25 Donohue Ruth Katharine 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
8124 8124 1981-03-01 1977-02-14 Borisovich Vladislav 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
8493 8493 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
8494 8494 1948-03-05 1947-07-25 Scott Georgina Mary 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
8557 8557 1953-03-06 1953-03-09 Pike Victor Joseph 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9194 9194 1955-03-15 1955-01-21 King Horace Maybray 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9326 9326 1955-03-16 1955-01-21 Wood Richard Frederick 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9416 9416 1961-03-17 1947-07-25 Mitchell Frank 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9639 9639 1948-03-20 1948-01-30 Burton Elaine Frances 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
9654 9654 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
9719 9719 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
10121 10121 1948-03-27 1948-02-27 Wallace Harry Wright 481 481 1947-07-25 British Information Services 845 Third Avenue   New York NY 10022
10197 10197 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 972.289ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history