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

211 rows where City = "Boston"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number >30

  • Rasky Baerlein Strategic Communications, Inc. 19
  • Clarke & Company, Inc. 18
  • Racepoint Global, Inc. 18
  • Fish & Richardson P.C. 14
  • ClarkeGowardFittsMatteson, Inc. 12
  • Newsome & Company, Inc. 11
  • Rasky Baerlein Strategic Communications, Inc. 10
  • Rasky Baerlein Strategic Communications, Inc. 8
  • Rasky Partners 8
  • Boston Consulting Group International, Inc. 8
  • Goodman Group, Ltd. 7
  • Friends of Fine Gael, Inc. 7
  • National Travel Company, Inc. 6
  • Culver International, Inc. 5
  • Widett, Slater & Goldman, P.C. 5
  • Hill, Holliday, Connors, Cosmopulos, Inc. 5
  • Gadsby & Hannah 4
  • Ropes and Gray 4
  • Hill & Barlow, P.C. 4
  • Syrian National Party in the U.S. 3
  • Mysore Company 3
  • Ingalls Associates, Inc. 3
  • Publicity, Inc. 3
  • J.R. Bechtle & Company 3
  • International Strategies, Inc. 3
  • O'Neill and Associates 3
  • Bernstone, Lawrence Jesse 2
  • Portuguese-American Committee on Foreign Affairs 2
  • Robert A. Weaver, Jr. & Associates, Inc. 2
  • Harron & Associates 2
  • …

Registrant_Name >30

  • Rasky Baerlein Strategic Communications, Inc. 37
  • Clarke & Company, Inc. 18
  • Racepoint Global, Inc. 18
  • Fish & Richardson P.C. 14
  • ClarkeGowardFittsMatteson, Inc. 12
  • Newsome & Company, Inc. 11
  • Boston Consulting Group International, Inc. 8
  • Rasky Partners 8
  • Friends of Fine Gael, Inc. 7
  • Goodman Group, Ltd. 7
  • National Travel Company, Inc. 6
  • Culver International, Inc. 5
  • Hill, Holliday, Connors, Cosmopulos, Inc. 5
  • Widett, Slater & Goldman, P.C. 5
  • Gadsby & Hannah 4
  • Hill & Barlow, P.C. 4
  • Ropes and Gray 4
  • Ingalls Associates, Inc. 3
  • International Strategies, Inc. 3
  • J.R. Bechtle & Company 3
  • Mysore Company 3
  • O'Neill and Associates 3
  • Publicity, Inc. 3
  • Syrian National Party in the U.S. 3
  • Agnew, Carter, McCarthy, Inc. 2
  • Bernstone, Lawrence Jesse 2
  • Ghiloni, Alfred R. 2
  • Harron & Associates 2
  • O'Neill and Associates, LLC 2
  • Portuguese-American Committee on Foreign Affairs 2
  • …

State 1

  • MA 211

City 1

  • Boston · 211 ✖
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
1094 1094   2020-05-28 Adkisson John Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1095 1095   2020-05-28 Ballanco Michael John Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1097 1097   2020-05-28 Cheng Vivian Chiwing Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1098 1098   2020-05-28 Degnan Lauren Ann Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1099 1099   2020-05-28 Farrell John Michael Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1100 1100   2020-05-28 McCallion Kristen Ann Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1101 1101   2020-05-28 McCormick Madelyn Sara Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1103 1103   2020-05-28 Reiter Tiffany Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1104 1104   2020-05-28 Schmuel Jenny Anne Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1106 1106   2020-05-28 Shear William Chad Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1107 1107   2020-05-28 Warden Joseph Barlow Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1108 1108   2020-05-28 Whelan Dorothy Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
1109 1109   2020-05-28 Zoppo Michael Theodore Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
2543 2543 1988-01-01 1987-12-11 Kiltonic Stephen Clarke & Company, Inc. 4074 1987-12-11 Clarke & Company, Inc. 535 Boylston Street   Boston MA 02135
3288 3288 1949-01-09 1948-01-09 Felton George Eugene Mysore Company 507 1948-01-09 Mysore Company 75 Federal Street   Boston MA  
3289 3289 1949-01-09 1948-01-09 Magel Theodore Tellmann Mysore Company 507 1948-01-09 Mysore Company 75 Federal Street   Boston MA  
3290 3290 1949-01-09 1948-01-09 Webb Elizabeth Mysore Company 507 1948-01-09 Mysore Company 75 Federal Street   Boston MA  
3447 3447 1992-01-12 1991-04-25 Long Alan Goodman Group, Ltd. 4505 1991-04-25 Goodman Group, Ltd. 303 Congress Street   Boston MA 02210
4044 4044 2013-01-21 2012-05-07 Sullivan Shawn F. Rasky Baerlein Strategic Communications, Inc. 6100 2012-05-07 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
4613 4613 1980-01-30 1977-11-01 Taliaferro Henry B. Widett, Slater & Goldman, P.C. 2841 1977-11-01 Widett, Slater & Goldman, P.C. 60 State Street   Boston MA 02109
4787 4787 1983-01-31 1982-03-30 Quinn Arthur Lee Gadsby & Hannah 2914 1978-06-12 Gadsby & Hannah 1 Post Office Square   Boston MA 02109
5592 5592 1996-02-01 1995-11-08 Browne Aidan F. Friends of Fine Gael, Inc. 5068 1995-11-08 Friends of Fine Gael, Inc. 55 Union Street Suite 200 Boston MA 02108-2400
5593 5593 1996-02-01 1995-11-08 Hern Joseph L. Friends of Fine Gael, Inc. 5068 1995-11-08 Friends of Fine Gael, Inc. 55 Union Street Suite 200 Boston MA 02108-2400
6010 6010 1987-02-06 1986-04-10 Warner Jack Hill, Holliday, Connors, Cosmopulos, Inc. 3810 1986-04-10 Hill, Holliday, Connors, Cosmopulos, Inc. 200 Clarendon Street   Boston MA 02116
6025 6025 1995-02-06 1993-09-27 Carter Lewis A. , Jr. Agnew, Carter, McCarthy, Inc. 4915 1993-09-27 Agnew, Carter, McCarthy, Inc. 222 Berkeley Street   Boston MA 02116
6026 6026 1995-02-06 1993-09-27 Rizzo Cynthia C. Agnew, Carter, McCarthy, Inc. 4915 1993-09-27 Agnew, Carter, McCarthy, Inc. 222 Berkeley Street   Boston MA 02116
6831 6831 1989-02-16 1978-06-09 Amon Thomas G. Gadsby & Hannah 2914 1978-06-12 Gadsby & Hannah 1 Post Office Square   Boston MA 02109
6832 6832 1989-02-16 1980-06-11 Rosenthal Gerald A. Gadsby & Hannah 2914 1978-06-12 Gadsby & Hannah 1 Post Office Square   Boston MA 02109
6833 6833 1989-02-16 1978-06-12 Hauser Harry R. Gadsby & Hannah 2914 1978-06-12 Gadsby & Hannah 1 Post Office Square   Boston MA 02109
6990 6990 2011-02-18 2011-02-18 Cahill John O'Neill and Associates, LLC 6020 2011-02-18 O'Neill and Associates, LLC 31 New Chardon Street   Boston MA 02114
6991 6991 2011-02-18 2011-02-18 Paven Andrew O'Neill and Associates, LLC 6020 2011-02-18 O'Neill and Associates, LLC 31 New Chardon Street   Boston MA 02114
7028 7028 1943-02-20 1943-03-20 Ghiloni Alfred R. Ghiloni, Alfred R. 113 1942-08-20 Ghiloni, Alfred R. 7 Park Square   Boston MA  
7029 7029 1943-02-20 1943-11-13 Cowie Kay Ghiloni, Alfred R. 112 1942-08-20 Ghiloni, Alfred R. 7 Park Square   Boston MA  
7352 7352 1985-02-25 1981-03-09 Cray Douglas W. Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
7353 7353 1985-02-25 1981-03-09 Farwell Peter Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
7354 7354 1985-02-25 1981-03-09 Funk Sally J. Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
7355 7355 1985-02-25 1981-03-09 Galvin William W. , III Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
7356 7356 1985-02-25 1981-03-09 Gloudemans Philip B. Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
7357 7357 1985-02-25 1981-03-09 Van Lenten Howard Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
7358 7358 1985-02-25 1982-09-13 Hann Morag Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
7359 7359 1985-02-25 1982-09-13 Ng Agnes Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
7360 7360 1985-02-25 1982-09-13 Saltzman Mark Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
7699 7699 1989-02-28 1988-07-13 Elfe Constantin J.R. Bechtle & Company 4019 1987-08-03 J.R. Bechtle & Company 185 Devonshire Street Suite 350 Boston MA 02110
9339 9339 1983-03-11 1982-09-13 Gabbe Jill Sullivan Newsome & Company, Inc. 3189 1981-01-09 Newsome & Company, Inc. 225 Franklin Street   Boston MA 02110
9764 9764 1995-03-16 1989-10-24 Dougherty Brian J.R. Bechtle & Company 4019 1987-08-03 J.R. Bechtle & Company 185 Devonshire Street Suite 350 Boston MA 02110
9810 9810 1960-03-17 1959-11-02 Comito Vincenzo National Travel Company, Inc. 1271 1959-09-17 National Travel Company, Inc. 90 State Street   Boston MA  
9811 9811 1960-03-17 1959-11-02 Iacuzio Nicola Ciriaco National Travel Company, Inc. 1271 1959-09-17 National Travel Company, Inc. 90 State Street   Boston MA  
9812 9812 1960-03-17 1959-11-02 Olivito John S. National Travel Company, Inc. 1271 1959-09-17 National Travel Company, Inc. 90 State Street   Boston MA  
9813 9813 1960-03-17 1959-11-02 Pedrelli Bruno National Travel Company, Inc. 1271 1959-09-17 National Travel Company, Inc. 90 State Street   Boston MA  
9814 9814 1960-03-17 1959-11-02 Peirano James John National Travel Company, Inc. 1271 1959-09-17 National Travel Company, Inc. 90 State Street   Boston MA  
9815 9815 1960-03-17 1959-11-02 de Rensis Pardo National Travel Company, Inc. 1271 1959-09-17 National Travel Company, Inc. 90 State Street   Boston MA  
11535 11535 2000-03-31 1999-09-15 Baron David R. Ropes and Gray 5328 1999-09-15 Ropes and Gray One International Place   Boston MA 02110-2624
11582 11582 2002-03-31 1999-09-15 Fee Michael K. Ropes and Gray 5328 1999-09-15 Ropes and Gray One International Place   Boston MA 02110-2624
11583 11583 2002-03-31 1999-09-15 Shay Stephen E. Ropes and Gray 5328 1999-09-15 Ropes and Gray One International Place   Boston MA 02110-2624
11584 11584 2002-03-31 1999-09-15 Susman Thomas M. Ropes and Gray 5328 1999-09-15 Ropes and Gray One International Place   Boston MA 02110-2624
11972 11972 2021-03-31 2020-05-28 Lavoie Teresa Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. One Marina Park Drive   Boston MA 02210
12733 12733 1992-04-10 1986-04-10 Jones Frederick Macy Hill, Holliday, Connors, Cosmopulos, Inc. 3810 1986-04-10 Hill, Holliday, Connors, Cosmopulos, Inc. 200 Clarendon Street   Boston MA 02116
12735 12735 1992-04-10 1990-10-16 Fitzpatrick Mary Jean Hill, Holliday, Connors, Cosmopulos, Inc. 3810 1986-04-10 Hill, Holliday, Connors, Cosmopulos, Inc. 200 Clarendon Street   Boston MA 02116
12935 12935 2021-04-13 2019-03-15 Drouin Jenna Racepoint Global, Inc. 6650 2019-03-15 Racepoint Global, Inc. 46 Waltham Street   Boston MA 02118
12936 12936 2021-04-13 2019-03-15 Kane Jacqueline F. Racepoint Global, Inc. 6650 2019-03-15 Racepoint Global, Inc. 46 Waltham Street   Boston MA 02118
12978 12978 2020-04-14 2019-03-15 Brown Kristin Racepoint Global, Inc. 6650 2019-03-15 Racepoint Global, Inc. 46 Waltham Street   Boston MA 02118
14054 14054 1964-04-30 1963-01-04 Cardozo Antonio Jesus Portuguese-American Committee on Foreign Affairs 1588 1963-01-04 Portuguese-American Committee on Foreign Affairs 20 Pemberton Square Suite 909 Boston MA  
14058 14058 1964-04-30 1963-04-01 Camacho Martin Thomas Portuguese-American Committee on Foreign Affairs 1588 1963-01-04 Portuguese-American Committee on Foreign Affairs 20 Pemberton Square Suite 909 Boston MA  
14235 14235 1991-04-30 1988-11-18 Fitts James ClarkeGowardFittsMatteson, Inc. 4123 1988-04-20 ClarkeGowardFittsMatteson, Inc. 535 Boylston Street   Boston MA 02116
14236 14236 1991-04-30 1988-11-18 Goward Jonathan M. ClarkeGowardFittsMatteson, Inc. 4123 1988-04-20 ClarkeGowardFittsMatteson, Inc. 535 Boylston Street   Boston MA 02116
14278 14278 1995-04-30 1992-02-18 Miringoff Traci Ann Harron & Associates 4431 1990-08-07 Harron & Associates 229 Berkeley Street   Boston MA 02116
14940 14940 1975-05-01 1974-08-02 Becker John Williams Culver International, Inc. 2466 1973-10-12 Culver International, Inc. 535 Boylston Street   Boston MA 02116
14999 14999 1988-05-01 1987-12-11 Robak Lori Clarke & Company, Inc. 4074 1987-12-11 Clarke & Company, Inc. 535 Boylston Street   Boston MA 02135
15941 15941 1980-05-15 1977-11-01 Cinnamond William G. Widett, Slater & Goldman, P.C. 2841 1977-11-01 Widett, Slater & Goldman, P.C. 60 State Street   Boston MA 02109
15942 15942 1980-05-15 1977-11-01 Patterson Martha Priddy Widett, Slater & Goldman, P.C. 2841 1977-11-01 Widett, Slater & Goldman, P.C. 60 State Street   Boston MA 02109
15943 15943 1980-05-15 1977-11-01 Woody Robert J. Widett, Slater & Goldman, P.C. 2841 1977-11-01 Widett, Slater & Goldman, P.C. 60 State Street   Boston MA 02109
16580 16580 1993-05-24 1991-04-25 Clark Matthew Goodman Group, Ltd. 4505 1991-04-25 Goodman Group, Ltd. 303 Congress Street   Boston MA 02210
16582 16582 1993-05-24 1992-06-01 Titus Elizabeth Goodman Group, Ltd. 4505 1991-04-25 Goodman Group, Ltd. 303 Congress Street   Boston MA 02210
16583 16583 1993-05-24 1991-12-10 Anthony Michael Ray Goodman Group, Ltd. 4505 1991-04-25 Goodman Group, Ltd. 303 Congress Street   Boston MA 02210
17976 17976 1988-06-01 1987-12-11 Dimond Arthur Clarke & Company, Inc. 4074 1987-12-11 Clarke & Company, Inc. 535 Boylston Street   Boston MA 02135
18359 18359 2019-06-04 2019-03-15 Rechichi Paul Racepoint Global, Inc. 6650 2019-03-15 Racepoint Global, Inc. 46 Waltham Street   Boston MA 02118
18578 18578 1960-06-09 1960-03-29 Barkin Alan Solomon Bernstone, Lawrence Jesse 1347 1960-03-29 Bernstone, Lawrence Jesse 11 Beacon Street   Boston MA  
18579 18579 1960-06-09 1960-03-29 Swartz Herbert Stanley Bernstone, Lawrence Jesse 1347 1960-03-29 Bernstone, Lawrence Jesse 11 Beacon Street   Boston MA  
19086 19086 2013-06-15 2013-01-31 Eckstein Ronald F. Rasky Baerlein Strategic Communications, Inc. 6100 2012-05-07 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
19087 19087 2013-06-15 2013-04-03 Baerlein Joseph T. Rasky Baerlein Strategic Communications, Inc. 6100 2012-05-07 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
19088 19088 2013-06-15 2013-04-03 Wexler Benjamin Rasky Baerlein Strategic Communications, Inc. 6100 2012-05-07 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
19089 19089 2013-06-15 2012-05-07 O'Connell Emily Rasky Baerlein Strategic Communications, Inc. 6100 2012-05-07 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
19090 19090 2013-06-15 2012-05-07 Shalgian Graham Rasky Baerlein Strategic Communications, Inc. 6100 2012-05-07 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
19091 19091 2013-06-15 2012-05-07 Tamasi David Rasky Baerlein Strategic Communications, Inc. 6100 2012-05-07 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
19092 19092 2013-06-15 2012-05-07 Tocco (Beeson) Jessica Rasky Baerlein Strategic Communications, Inc. 6100 2012-05-07 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
19227 19227 1986-06-17 1981-10-28 Perta Joseph M. Robert A. Weaver, Jr. & Associates, Inc. 3298 1981-10-28 Robert A. Weaver, Jr. & Associates, Inc. Pilot House at Lewis Wharf   Boston MA 02110
19228 19228 1986-06-17 1981-11-25 Weaver Robert A. , Jr. Robert A. Weaver, Jr. & Associates, Inc. 3298 1981-10-28 Robert A. Weaver, Jr. & Associates, Inc. Pilot House at Lewis Wharf   Boston MA 02110
20597 20597 1989-06-30 1988-11-18 O'Brien Michael E. ClarkeGowardFittsMatteson, Inc. 4123 1988-04-20 ClarkeGowardFittsMatteson, Inc. 535 Boylston Street   Boston MA 02116
21319 21319 2016-06-30 2014-06-26 Poston Elizabeth L. Rasky Baerlein Strategic Communications, Inc. 6222 2014-05-16 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
21621 21621 1988-07-01 1987-12-11 Steidler Paul Clarke & Company, Inc. 4074 1987-12-11 Clarke & Company, Inc. 535 Boylston Street   Boston MA 02135
23077 23077 1991-07-20 1989-03-20 Bousquet Carol Clarke & Company, Inc. 4074 1987-12-11 Clarke & Company, Inc. 535 Boylston Street   Boston MA 02135
23121 23121 1975-07-21 1975-05-06 von Freymann Jeffrey W. Culver International, Inc. 2466 1973-10-12 Culver International, Inc. 535 Boylston Street   Boston MA 02116
23122 23122 1975-07-21 1973-10-12 Jackson Clifton P. Culver International, Inc. 2466 1973-10-12 Culver International, Inc. 535 Boylston Street   Boston MA 02116
24636 24636 2015-07-31 2015-02-02 Granum Rex Lars Rasky Baerlein Strategic Communications, Inc. 6222 2014-05-16 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
24649 24649 2015-07-31 2014-06-26 Leibach Dale William Rasky Baerlein Strategic Communications, Inc. 6222 2014-05-16 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
25207 25207 1976-08-03 1973-10-12 Buckley James G. Culver International, Inc. 2466 1973-10-12 Culver International, Inc. 535 Boylston Street   Boston MA 02116
25747 25747 2020-08-10 2020-08-10 Avasarala Govinda Boston Consulting Group International, Inc. 6851 2020-08-10 Boston Consulting Group International, Inc. 200 Pier 4 Boulevard   Boston MA 02210
25748 25748 2020-08-10 2020-08-10 Croog Jonathan Boston Consulting Group International, Inc. 6851 2020-08-10 Boston Consulting Group International, Inc. 200 Pier 4 Boulevard   Boston MA 02210
25751 25751 2020-08-10 2020-08-10 Hu Boxiao Boston Consulting Group International, Inc. 6851 2020-08-10 Boston Consulting Group International, Inc. 200 Pier 4 Boulevard   Boston MA 02210
25753 25753 2020-08-10 2020-08-10 Khalil Ihab Boston Consulting Group International, Inc. 6851 2020-08-10 Boston Consulting Group International, Inc. 200 Pier 4 Boulevard   Boston MA 02210

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 296.043ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history