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_Last_Name descending
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
14370 | 14370 | 1999-04-29 | 1998-03-24 | Yang | Vivian | Weber Group 5250 | 1998-03-24 | Weber Group | 101 Main Street | 8th Floor | Cambridge | MA | 02142 |
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 | |
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 |
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 |
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 | ||
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 | |
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 | ||
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 | |
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 | |
10607 | 10607 | 1987-03-23 | 1987-03-23 | Uek | Kathleen C. | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
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 | ||
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 |
15441 | 15441 | 1995-05-01 | 1992-02-27 | Togneri | Martin P. | 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 |
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 | ||
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 | |
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 | |
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 |
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 | ||
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 | ||
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 | ||
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 | |
35171 | 35171 | 1994-11-03 | 1990-10-05 | Stevenson | Marie C. | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
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 | ||
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 |
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 | ||
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 | |
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 | ||
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 | ||
10606 | 10606 | 1987-03-23 | 1987-03-23 | Soderberg | Karen Elsa | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
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 |
10605 | 10605 | 1987-03-23 | 1987-03-23 | Smith | Perry C. | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
22343 | 22343 | 2011-07-01 | 2011-05-17 | Singh-Molares | Rajeev | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 | |
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 | |
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 | ||
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 |
12968 | 12968 | 1999-04-08 | 1998-03-24 | Schaefer | Kristine | Weber Group 5250 | 1998-03-24 | Weber Group | 101 Main Street | 8th Floor | Cambridge | MA | 02142 |
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 | ||
10604 | 10604 | 1987-03-23 | 1987-03-23 | Sagarino | Robert F. | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
16433 | 16433 | 2000-05-15 | 1995-09-21 | Rutherford | Marissa | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | |
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 | ||
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 | ||
10603 | 10603 | 1987-03-23 | 1987-03-23 | Reinfeld | William | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
30924 | 30924 | 1977-09-30 | 1977-08-15 | Reinfeld | William | Arthur D. Little, Inc. 2822 | 1977-08-15 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
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 |
13333 | 13333 | 2000-04-14 | 1995-11-22 | Reekie | John Campbell | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
30923 | 30923 | 1977-09-30 | 1977-08-15 | Reedy | John H. | Arthur D. Little, Inc. 2822 | 1977-08-15 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
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 |
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 | ||
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 | ||
21327 | 21327 | 1999-06-30 | 1998-03-24 | Prior | Paige M. | Weber Group 5250 | 1998-03-24 | Weber Group | 101 Main Street | 8th Floor | Cambridge | MA | 02142 |
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 | ||
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 | ||
14740 | 14740 | 1998-04-30 | 1998-03-24 | Polivka | John M. | Weber Group 5250 | 1998-03-24 | Weber Group | 101 Main Street | 8th Floor | Cambridge | MA | 02142 |
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 |
17689 | 17689 | 1985-05-31 | 1981-08-24 | Peters | Richard A. | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
10602 | 10602 | 1987-03-23 | 1987-03-23 | Perkins | Rufus M. | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
13335 | 13335 | 2006-04-14 | 2004-10-14 | Pearson | Lance | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 | ||
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 | |
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 |
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 | ||
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 | ||
10600 | 10600 | 1987-03-23 | 1987-03-23 | Ong | Joo Hooi | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
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 | ||
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 | ||
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 | ||
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 | |
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 |
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 | ||
22340 | 22340 | 2011-07-01 | 2011-05-06 | Miracky | William F. | Monitor Company Group LP 6037 | 2011-05-06 | Monitor Company Group LP | Two Canal Park | Cambridge | MA | 02141 | |
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 | |
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 |
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 | |
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 |
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 | ||
35170 | 35170 | 1994-11-03 | 1993-06-17 | McGregor | Peter James | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
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 |
10596 | 10596 | 1987-03-23 | 1987-03-23 | McCarthy | Kathleen M. | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
18776 | 18776 | 2016-06-03 | 2012-06-15 | McArthur | Michael Charles | 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 | ||
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 |
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 |
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 | ||
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 | ||
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 | |
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 | ||
38871 | 38871 | 1990-12-21 | 1988-11-22 | MacKenzie | Robert | 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 |
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 | ||
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 |
35148 | 35148 | 1967-11-03 | 1967-06-26 | Lewinson | Victor A. | Arthur D. Little, Inc. 2032 | 1967-06-26 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140 | |
26559 | 26559 | 1999-08-13 | 1994-11-21 | Lennox | Peter | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
10595 | 10595 | 1987-03-23 | 1987-03-23 | Lee | Robert E. | Arthur D. Little, Inc. 3804 | 1986-03-31 | Arthur D. Little, Inc. | Acorn Park | Cambridge | MA | 02140-2390 | |
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 | ||
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 |
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]) );