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

207 rows where City = "Cambridge"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

City 1

  • Cambridge · 207 ✖
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
867 867   2016-04-29 Reynolds Kevin John Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
1741 1741   2015-10-05 Sim Michelle Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
2332 2332   1999-12-27 Tepfer Kathleen Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
2664 2664 2001-01-01 1998-02-24 Farrell Jill M. Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
4449 4449 2006-01-27 2000-07-24 Mason Jaclyn Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
4573 4573 2010-01-29 2006-12-28 Flanagan Raymond Hugh Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
4781 4781 1981-01-31 1979-12-27 Reid James Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
5987 5987 2013-02-05 2006-10-31 Boyle Angela Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
6146 6146 1977-02-08 1976-03-23 Gorman John W. Cambridge Reports, Inc. 2670 1976-03-23 Cambridge Reports, Inc. 12-14 Mifflin Place   Cambridge MA 02138
6640 6640 2009-02-14 2007-06-26 Paice Jennifer Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
7012 7012 1999-02-19 1998-03-24 Sun John Weber Group 5250 1998-03-24 Weber Group 101 Main Street 8th Floor Cambridge MA 02142
7305 7305 2006-02-24 2003-10-23 Clarkson Jim Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
7695 7695 1989-02-28 1987-04-17 Togneri Martin Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
7698 7698 1989-02-28 1987-06-11 Moody Howard J. Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
7857 7857 1999-02-28 1989-06-09 Bennett Steven MacKellar Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
8484 8484 1982-03-01 1979-04-17 Woodman John M. Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
8710 8710 2001-03-02 1999-02-18 Del Favero Jr. John Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
8711 8711 2002-03-02 2000-01-05 Mathieu Valerie J. Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
8712 8712 2002-03-02 1998-05-21 Smith Lisa Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
8713 8713 2002-03-02 1998-05-21 Stallins Ellen Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
8714 8714 2002-03-02 1998-07-21 Ketterer Kirk A. Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
9026 9026 1960-03-07 1959-04-16 D'Angeli Josephine S. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9027 9027 1960-03-07 1959-04-16 O'Leary Florence D. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9028 9028 1960-03-07 1959-04-16 Anderson William University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9029 9029 1960-03-07 1959-04-16 Barrow Dympna University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9030 9030 1960-03-07 1959-04-16 Benedetto Gilda A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9031 9031 1960-03-07 1959-04-16 Benedetto Katherine University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9032 9032 1960-03-07 1959-04-16 Board Gregory Richmond University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9033 9033 1960-03-07 1959-04-16 Boire Dorothy G. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9034 9034 1960-03-07 1959-04-16 Brennan Francis F. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9035 9035 1960-03-07 1959-04-16 Brogan Priscilla Ruth University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9036 9036 1960-03-07 1959-04-16 Carter Marion H. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9037 9037 1960-03-07 1959-04-16 Cogan Rose University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9038 9038 1960-03-07 1959-04-16 Cone Evelyn Jean University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9039 9039 1960-03-07 1959-04-16 Cotton William D. , Jr. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9040 9040 1960-03-07 1959-04-16 Coulombe Alice A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9041 9041 1960-03-07 1959-04-16 De Mare Lorraine Marie University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9042 9042 1960-03-07 1959-04-16 Dollin Rose University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9043 9043 1960-03-07 1959-04-16 Fine Mildred University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9044 9044 1960-03-07 1959-04-16 Flanagan Helen G. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9045 9045 1960-03-07 1959-04-16 Foss Janet F. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9046 9046 1960-03-07 1959-04-16 Geddes Mabel S. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9047 9047 1960-03-07 1959-04-16 Gleason Thomas Daniel University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9048 9048 1960-03-07 1959-04-16 Goodwin Mary Ellen University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9049 9049 1960-03-07 1959-04-16 Granese Michael Vincent University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9050 9050 1960-03-07 1959-04-16 Guerra Virginia University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9051 9051 1960-03-07 1959-04-16 Haskell Audrey L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9052 9052 1960-03-07 1959-04-16 Hedtler Irving University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9053 9053 1960-03-07 1959-04-16 Hegner Ernest A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9054 9054 1960-03-07 1959-04-16 Higgins Mary V. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9055 9055 1960-03-07 1959-04-16 Johns Cyril J. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9056 9056 1960-03-07 1959-04-16 Johnson George A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9057 9057 1960-03-07 1959-04-16 Kehoe William A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9058 9058 1960-03-07 1959-04-16 King Catherine G. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9059 9059 1960-03-07 1959-04-16 Kingsley Harold R. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9060 9060 1960-03-07 1959-04-16 Kirsten Mark University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9061 9061 1960-03-07 1959-04-16 Knudson Judith Ann University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9062 9062 1960-03-07 1959-04-16 Leckley George R. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9063 9063 1960-03-07 1959-04-16 Loomer Doris J. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9064 9064 1960-03-07 1959-04-16 MacLean Francis X. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9065 9065 1960-03-07 1959-04-16 Maltz Lucy C. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9066 9066 1960-03-07 1959-04-16 Martinelli Josephine University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9067 9067 1960-03-07 1959-04-16 Maylor Elizabeth Ann University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9068 9068 1960-03-07 1959-04-16 McKenzie George University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9069 9069 1960-03-07 1959-04-16 Moccia Michaela University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9070 9070 1960-03-07 1959-04-16 Mueller Hans University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9071 9071 1960-03-07 1959-04-16 Nielsen Alice L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9072 9072 1960-03-07 1959-04-16 Oppedisano Frances University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9073 9073 1960-03-07 1959-04-16 Osborn George R. , Jr. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9074 9074 1960-03-07 1959-04-16 Paula Ann Elizabeth University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9075 9075 1960-03-07 1959-04-16 Pratt Irene University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9076 9076 1960-03-07 1959-04-16 Price Sara A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9077 9077 1960-03-07 1959-04-16 Rabideau Katherine University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9078 9078 1960-03-07 1959-04-16 Raczynski Thaddeus S. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9079 9079 1960-03-07 1959-04-16 Reslow Ann University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9080 9080 1960-03-07 1959-04-16 Reynolds Donald James University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9081 9081 1960-03-07 1959-04-16 Saltiel Anna L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9082 9082 1960-03-07 1959-04-16 Shaw Mary P. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9083 9083 1960-03-07 1959-04-16 Soper Barbara A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9084 9084 1960-03-07 1959-04-16 Spano Petrina V. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9085 9085 1960-03-07 1959-04-16 Spears Mary E. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9086 9086 1960-03-07 1959-04-16 Stauffer Cynthia Warren University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9087 9087 1960-03-07 1959-04-16 Steinberg Eva L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9088 9088 1960-03-07 1959-04-16 Stocker Anne Margaret University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9089 9089 1960-03-07 1959-04-16 Suermondt Robert K. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9090 9090 1960-03-07 1959-04-16 Summerfield Doris A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9091 9091 1960-03-07 1959-04-16 Tesson Anne University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9092 9092 1960-03-07 1959-04-16 Trodden Agnes F. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9093 9093 1960-03-07 1959-04-16 Wellins Shelley University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9094 9094 1960-03-07 1959-04-16 Whitehead Donald D. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9095 9095 1960-03-07 1959-07-14 Bloomberg Edward University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
10286 10286 1987-03-23 1987-03-23 Carlson Kathleen E. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10287 10287 1987-03-23 1987-03-23 Colas Pamela Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10288 10288 1987-03-23 1987-03-23 Collins Sarah Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10289 10289 1987-03-23 1987-03-23 Concannon Lawrence J. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10290 10290 1987-03-23 1987-03-23 Edgerly James B. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10291 10291 1987-03-23 1987-03-23 Farrar Julie A. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10292 10292 1987-03-23 1987-03-23 Fothergill William R. Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10293 10293 1987-03-23 1987-03-23 Gols A. George Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390
10294 10294 1987-03-23 1987-03-23 Goulet Roger Arthur D. Little, Inc. 3804 1986-03-31 Arthur D. Little, Inc. Acorn Park   Cambridge MA 02140-2390

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