FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
207 rows where City = "Cambridge" sorted by Short_Form_First_Name
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
30922 | 30922 | 1977-09-30 | 1977-08-15 | Gols | A. George | Arthur D. Little, Inc. 2822 | 1977-08-15 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
22336 | 22336 | 2011-07-01 | 2011-05-06 | Gossen | Adam Nicholas | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 | |
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 | ||
21047 | 21047 | 1985-06-30 | 1982-11-17 | Shaw | Alexander T. | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
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 | ||
22342 | 22342 | 2011-07-01 | 2011-05-06 | Wenban | Andrew Michael | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 | |
13106 | 13106 | 2002-04-10 | 1993-10-28 | McDonald | Andrew Ronald | 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 |
21497 | 21497 | 2004-06-30 | 2001-03-06 | Boyle | Angela | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
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 | ||
34373 | 34373 | 1996-10-31 | 1992-03-13 | Stewart | Ann Haslam | Stewart, Ann Haslam 4632 | 1992-03-13 | Stewart, Ann Haslam | Post Office Box 391161 | Cambridge | MA | 02139-0012 | |
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 | ||
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 | ||
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 | ||
22335 | 22335 | 2011-07-01 | 2011-05-06 | Goldner | Anthony | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 | |
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 | ||
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 | ||
26272 | 26272 | 1993-08-08 | 1991-08-26 | Rankin | Brenda M. | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
35147 | 35147 | 1967-11-03 | 1967-06-26 | Lane | Bruce M. | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
22349 | 22349 | 2011-07-01 | 2006-08-17 | Lancastle | Calum | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
10599 | 10599 | 1987-03-23 | 1987-03-23 | Morrill | Carolyn S. | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
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 | ||
22339 | 22339 | 2011-07-01 | 2011-05-06 | Malone | Christopher | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 | |
18649 | 18649 | 1987-06-02 | 1985-06-12 | Williamson | Colin | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
21131 | 21131 | 1989-06-30 | 1986-12-15 | MacAlister-Hall | Colin W. | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
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 | ||
11534 | 11534 | 1984-03-31 | 1982-11-17 | Christie | David | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
26829 | 26829 | 1991-08-16 | 1988-04-27 | Lightbody | David | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
33724 | 33724 | 2016-10-27 | 2011-03-07 | Anderson | David | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
34279 | 34279 | 1988-10-31 | 1986-01-31 | Brown | David John Alexander | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
10597 | 10597 | 1987-03-23 | 1987-03-23 | Menegakis | Demosthenes | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
18759 | 18759 | 1987-06-03 | 1984-05-30 | Harrison | Donald | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
35149 | 35149 | 1967-11-03 | 1967-06-26 | Sparrow | Donald B. | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
35138 | 35138 | 1967-11-03 | 1967-06-26 | Allen | Dr. Frank L. | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
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 | ||
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 | ||
35151 | 35151 | 1967-11-03 | 1967-06-26 | Wygard | Edward J. | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
27812 | 27812 | 2010-08-30 | 2006-03-01 | Hovey | Elaine | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
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 |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
30991 | 30991 | 1986-09-30 | 1984-07-19 | Gow | Frank | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
36715 | 36715 | 1988-11-30 | 1985-12-10 | Heffernan | Garth James | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
23107 | 23107 | 1987-07-14 | 1982-01-19 | Yates | Geoffrey Galloway | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
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 | ||
35150 | 35150 | 1967-11-03 | 1967-06-26 | Sweeney | George C. , Jr. | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
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 | ||
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 | ||
10598 | 10598 | 1987-03-23 | 1987-03-23 | Michael | Gerald J. | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
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 | ||
30921 | 30921 | 1977-09-30 | 1977-08-15 | DeSouza | Glenn | Arthur D. Little, Inc. 2822 | 1977-08-15 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
15449 | 15449 | 1995-05-01 | 1992-05-05 | Cook | Graham | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
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 | ||
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 | ||
35144 | 35144 | 1967-11-03 | 1967-06-26 | Flood | Harold William | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
22333 | 22333 | 2011-07-01 | 2011-05-06 | Edmonds | Harriet | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 | |
33312 | 33312 | 1998-10-21 | 1998-03-24 | Pforzheimer | Harry III | Weber Group 5250 | 1998-03-24 | Weber Group | 101 Main Street | 8th Floor | Cambridge | MA | 02142 |
10601 | 10601 | 1987-03-23 | 1987-03-23 | Pastan | Harvey L. | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
23128 | 23128 | 2000-07-14 | 1997-04-30 | Jones | Heather Anne | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
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 |
12445 | 12445 | 1984-04-01 | 1979-04-17 | Gray | Ian | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
12525 | 12525 | 2005-04-01 | 2000-11-24 | McMahon | Ian Gerhard | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
28079 | 28079 | 1984-08-31 | 1982-11-17 | Gordon | Ian Scott | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
10817 | 10817 | 1998-03-26 | 1992-10-22 | Merry | Irene | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
30611 | 30611 | 1996-09-27 | 1985-05-24 | Haggarty | J.L.D. | 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 |
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 |
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 | |
35152 | 35152 | 1967-11-03 | 1967-06-26 | Zeigler | James Louis | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
35146 | 35146 | 1967-11-03 | 1967-06-26 | Jensen | James T. | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
35140 | 35140 | 1967-11-03 | 1967-06-26 | Bradley | James W. | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
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 | ||
24795 | 24795 | 1990-07-31 | 1988-04-27 | Johnston | Jean | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
26103 | 26103 | 1991-08-06 | 1987-07-22 | Thornton | Jeffrey | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 |
10608 | 10608 | 1987-03-23 | 1987-03-23 | Wasserman | Jerry | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
22341 | 22341 | 2011-07-01 | 2011-05-06 | Watson | Jessica | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 | |
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 |
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 |
22345 | 22345 | 2011-07-01 | 2011-07-01 | Burleson | Joanna | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );