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: Address_1, Zip, Short_Form_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
907 907   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
1893 1893   2015-10-05 Sim Michelle Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
2460 2460   1999-12-27 Tepfer Kathleen Scottish Enterprise 3013 1979-04-17 Scottish Enterprise SCTR Ltd British Consulate One Broadway 7th Floor Cambridge MA 02109
2794 2794 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
4643 4643 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
4771 4771 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
4979 4979 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
6203 6203 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
6366 6366 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
6875 6875 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
7250 7250 1999-02-19 1998-03-24 Sun John Weber Group 5250 1998-03-24 Weber Group 101 Main Street 8th Floor Cambridge MA 02142
7551 7551 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
7940 7940 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
7943 7943 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
8102 8102 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
8739 8739 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
8976 8976 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
8977 8977 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
8978 8978 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
8979 8979 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
8980 8980 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
9295 9295 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  
9296 9296 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  
9297 9297 1960-03-07 1959-04-16 Anderson William University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9298 9298 1960-03-07 1959-04-16 Barrow Dympna University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9299 9299 1960-03-07 1959-04-16 Benedetto Gilda A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9300 9300 1960-03-07 1959-04-16 Benedetto Katherine University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9301 9301 1960-03-07 1959-04-16 Board Gregory Richmond University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9302 9302 1960-03-07 1959-04-16 Boire Dorothy G. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9303 9303 1960-03-07 1959-04-16 Brennan Francis F. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9304 9304 1960-03-07 1959-04-16 Brogan Priscilla Ruth University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9305 9305 1960-03-07 1959-04-16 Carter Marion H. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9306 9306 1960-03-07 1959-04-16 Cogan Rose University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9307 9307 1960-03-07 1959-04-16 Cone Evelyn Jean University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9308 9308 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  
9309 9309 1960-03-07 1959-04-16 Coulombe Alice A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9310 9310 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  
9311 9311 1960-03-07 1959-04-16 Dollin Rose University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9312 9312 1960-03-07 1959-04-16 Fine Mildred University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9313 9313 1960-03-07 1959-04-16 Flanagan Helen G. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9314 9314 1960-03-07 1959-04-16 Foss Janet F. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9315 9315 1960-03-07 1959-04-16 Geddes Mabel S. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9316 9316 1960-03-07 1959-04-16 Gleason Thomas Daniel University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9317 9317 1960-03-07 1959-04-16 Goodwin Mary Ellen University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9318 9318 1960-03-07 1959-04-16 Granese Michael Vincent University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9319 9319 1960-03-07 1959-04-16 Guerra Virginia University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9320 9320 1960-03-07 1959-04-16 Haskell Audrey L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9321 9321 1960-03-07 1959-04-16 Hedtler Irving University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9322 9322 1960-03-07 1959-04-16 Hegner Ernest A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9323 9323 1960-03-07 1959-04-16 Higgins Mary V. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9324 9324 1960-03-07 1959-04-16 Johns Cyril J. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9325 9325 1960-03-07 1959-04-16 Johnson George A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9326 9326 1960-03-07 1959-04-16 Kehoe William A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9327 9327 1960-03-07 1959-04-16 King Catherine G. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9328 9328 1960-03-07 1959-04-16 Kingsley Harold R. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9329 9329 1960-03-07 1959-04-16 Kirsten Mark University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9330 9330 1960-03-07 1959-04-16 Knudson Judith Ann University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9331 9331 1960-03-07 1959-04-16 Leckley George R. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9332 9332 1960-03-07 1959-04-16 Loomer Doris J. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9333 9333 1960-03-07 1959-04-16 MacLean Francis X. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9334 9334 1960-03-07 1959-04-16 Maltz Lucy C. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9335 9335 1960-03-07 1959-04-16 Martinelli Josephine University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9336 9336 1960-03-07 1959-04-16 Maylor Elizabeth Ann University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9337 9337 1960-03-07 1959-04-16 McKenzie George University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9338 9338 1960-03-07 1959-04-16 Moccia Michaela University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9339 9339 1960-03-07 1959-04-16 Mueller Hans University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9340 9340 1960-03-07 1959-04-16 Nielsen Alice L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9341 9341 1960-03-07 1959-04-16 Oppedisano Frances University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9342 9342 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  
9343 9343 1960-03-07 1959-04-16 Paula Ann Elizabeth University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9344 9344 1960-03-07 1959-04-16 Pratt Irene University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9345 9345 1960-03-07 1959-04-16 Price Sara A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9346 9346 1960-03-07 1959-04-16 Rabideau Katherine University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9347 9347 1960-03-07 1959-04-16 Raczynski Thaddeus S. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9348 9348 1960-03-07 1959-04-16 Reslow Ann University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9349 9349 1960-03-07 1959-04-16 Reynolds Donald James University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9350 9350 1960-03-07 1959-04-16 Saltiel Anna L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9351 9351 1960-03-07 1959-04-16 Shaw Mary P. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9352 9352 1960-03-07 1959-04-16 Soper Barbara A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9353 9353 1960-03-07 1959-04-16 Spano Petrina V. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9354 9354 1960-03-07 1959-04-16 Spears Mary E. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9355 9355 1960-03-07 1959-04-16 Stauffer Cynthia Warren University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9356 9356 1960-03-07 1959-04-16 Steinberg Eva L. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9357 9357 1960-03-07 1959-04-16 Stocker Anne Margaret University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9358 9358 1960-03-07 1959-04-16 Suermondt Robert K. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9359 9359 1960-03-07 1959-04-16 Summerfield Doris A. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9360 9360 1960-03-07 1959-04-16 Tesson Anne University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9361 9361 1960-03-07 1959-04-16 Trodden Agnes F. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9362 9362 1960-03-07 1959-04-16 Wellins Shelley University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9363 9363 1960-03-07 1959-04-16 Whitehead Donald D. University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
9364 9364 1960-03-07 1959-07-14 Bloomberg Edward University Travel Company 1218 1959-04-16 University Travel Company 18 Brattle Street   Cambridge MA  
10585 10585 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
10586 10586 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
10587 10587 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
10588 10588 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
10589 10589 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
10590 10590 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
10591 10591 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
10592 10592 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
10593 10593 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])
);