home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

207 rows where City = "Cambridge"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 10

  • University Travel Company 70
  • Scottish Enterprise 67
  • Arthur D. Little, Inc. 25
  • Monitor Company Group LP 16
  • Arthur D. Little, Inc. 15
  • Weber Group 6
  • Arthur D. Little, Inc. 4
  • National Computer Board of Singapore 2
  • Cambridge Reports, Inc. 1
  • Stewart, Ann Haslam 1

Registrant_Name 8

  • University Travel Company 70
  • Scottish Enterprise 67
  • Arthur D. Little, Inc. 44
  • Monitor Company Group LP 16
  • Weber Group 6
  • National Computer Board of Singapore 2
  • Cambridge Reports, Inc. 1
  • Stewart, Ann Haslam 1

State 1

  • MA 207

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
906 906   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
1884 1884   2015-10-05 Sim Michelle Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
2452 2452   1999-12-27 Tepfer Kathleen Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
2786 2786 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
4631 4631 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
4759 4759 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
4967 4967 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
6190 6190 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
6353 6353 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
6862 6862 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
7237 7237 1999-02-19 1998-03-24 Sun John Weber Group 5250 1998-03-24 Weber Group 101 Main Street 8th Floor Cambridge MA 02142
7538 7538 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
7927 7927 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
7930 7930 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
8089 8089 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
8726 8726 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
8963 8963 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
8964 8964 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
8965 8965 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
8966 8966 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
8967 8967 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
9282 9282 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  
9283 9283 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  
9284 9284 1960-03-07 1959-04-16 Anderson William University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9285 9285 1960-03-07 1959-04-16 Barrow Dympna University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9286 9286 1960-03-07 1959-04-16 Benedetto Gilda A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9287 9287 1960-03-07 1959-04-16 Benedetto Katherine University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9288 9288 1960-03-07 1959-04-16 Board Gregory Richmond University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9289 9289 1960-03-07 1959-04-16 Boire Dorothy G. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9290 9290 1960-03-07 1959-04-16 Brennan Francis F. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9291 9291 1960-03-07 1959-04-16 Brogan Priscilla Ruth University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9292 9292 1960-03-07 1959-04-16 Carter Marion H. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9293 9293 1960-03-07 1959-04-16 Cogan Rose University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9294 9294 1960-03-07 1959-04-16 Cone Evelyn Jean University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9295 9295 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  
9296 9296 1960-03-07 1959-04-16 Coulombe Alice A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9297 9297 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  
9298 9298 1960-03-07 1959-04-16 Dollin Rose University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9299 9299 1960-03-07 1959-04-16 Fine Mildred University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9300 9300 1960-03-07 1959-04-16 Flanagan Helen G. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9301 9301 1960-03-07 1959-04-16 Foss Janet F. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9302 9302 1960-03-07 1959-04-16 Geddes Mabel S. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9303 9303 1960-03-07 1959-04-16 Gleason Thomas Daniel University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9304 9304 1960-03-07 1959-04-16 Goodwin Mary Ellen University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9305 9305 1960-03-07 1959-04-16 Granese Michael Vincent University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9306 9306 1960-03-07 1959-04-16 Guerra Virginia University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9307 9307 1960-03-07 1959-04-16 Haskell Audrey L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9308 9308 1960-03-07 1959-04-16 Hedtler Irving University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9309 9309 1960-03-07 1959-04-16 Hegner Ernest A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9310 9310 1960-03-07 1959-04-16 Higgins Mary V. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9311 9311 1960-03-07 1959-04-16 Johns Cyril J. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9312 9312 1960-03-07 1959-04-16 Johnson George A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9313 9313 1960-03-07 1959-04-16 Kehoe William A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9314 9314 1960-03-07 1959-04-16 King Catherine G. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9315 9315 1960-03-07 1959-04-16 Kingsley Harold R. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9316 9316 1960-03-07 1959-04-16 Kirsten Mark University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9317 9317 1960-03-07 1959-04-16 Knudson Judith Ann University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9318 9318 1960-03-07 1959-04-16 Leckley George R. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9319 9319 1960-03-07 1959-04-16 Loomer Doris J. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9320 9320 1960-03-07 1959-04-16 MacLean Francis X. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9321 9321 1960-03-07 1959-04-16 Maltz Lucy C. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9322 9322 1960-03-07 1959-04-16 Martinelli Josephine University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9323 9323 1960-03-07 1959-04-16 Maylor Elizabeth Ann University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9324 9324 1960-03-07 1959-04-16 McKenzie George University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9325 9325 1960-03-07 1959-04-16 Moccia Michaela University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9326 9326 1960-03-07 1959-04-16 Mueller Hans University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9327 9327 1960-03-07 1959-04-16 Nielsen Alice L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9328 9328 1960-03-07 1959-04-16 Oppedisano Frances University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9329 9329 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  
9330 9330 1960-03-07 1959-04-16 Paula Ann Elizabeth University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9331 9331 1960-03-07 1959-04-16 Pratt Irene University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9332 9332 1960-03-07 1959-04-16 Price Sara A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9333 9333 1960-03-07 1959-04-16 Rabideau Katherine University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9334 9334 1960-03-07 1959-04-16 Raczynski Thaddeus S. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9335 9335 1960-03-07 1959-04-16 Reslow Ann University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9336 9336 1960-03-07 1959-04-16 Reynolds Donald James University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9337 9337 1960-03-07 1959-04-16 Saltiel Anna L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9338 9338 1960-03-07 1959-04-16 Shaw Mary P. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9339 9339 1960-03-07 1959-04-16 Soper Barbara A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9340 9340 1960-03-07 1959-04-16 Spano Petrina V. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9341 9341 1960-03-07 1959-04-16 Spears Mary E. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9342 9342 1960-03-07 1959-04-16 Stauffer Cynthia Warren University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9343 9343 1960-03-07 1959-04-16 Steinberg Eva L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9344 9344 1960-03-07 1959-04-16 Stocker Anne Margaret University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9345 9345 1960-03-07 1959-04-16 Suermondt Robert K. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9346 9346 1960-03-07 1959-04-16 Summerfield Doris A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9347 9347 1960-03-07 1959-04-16 Tesson Anne University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9348 9348 1960-03-07 1959-04-16 Trodden Agnes F. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9349 9349 1960-03-07 1959-04-16 Wellins Shelley University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9350 9350 1960-03-07 1959-04-16 Whitehead Donald D. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9351 9351 1960-03-07 1959-07-14 Bloomberg Edward University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
10572 10572 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
10573 10573 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
10574 10574 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
10575 10575 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
10576 10576 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
10577 10577 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
10578 10578 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
10579 10579 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
10580 10580 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])
);
Powered by Datasette · Queries took 574.772ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history