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

179 rows where City = "Philadelphia"

✎ 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)

State 1

City 1

  • Philadelphia · 179 ✖
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
331 331   2011-02-15 Bokhari Raza Bokhari, Raza 6018 2011-02-15 Bokhari, Raza 1717 Arch Street 39th Floor Philadelphia PA 19103
3007 3007 1967-01-04 1960-01-07 Friedmann Rochelle Friedmann Radio Broadcasting & Advertising Company 1304 1959-12-07 Friedmann Radio Broadcasting & Advertising Company 1105 Friendship Street   Philadelphia PA 19111
3008 3008 1967-01-04 1964-09-21 Berensmann Hanns-Peter Friedmann Radio Broadcasting & Advertising Company 1304 1959-12-07 Friedmann Radio Broadcasting & Advertising Company 1105 Friendship Street   Philadelphia PA 19111
3045 3045 1999-01-04 1989-02-17 Heath Charles S. Government of Dubai, Dept. of Tourism & Commerce Marketing 4217 1989-02-17 Government of Dubai, Dept. of Tourism & Commerce Marketing Eight Penn Center 19th Floor, Suite 1950 Philadelphia PA 19103
3081 3081 1983-01-05 1978-07-06 Gray Jerome Compton Advertising, Inc. 2925 1978-07-06 Compton Advertising, Inc. 1819 John F. Kennedy Boulevard   Philadelphia PA 19103
3082 3082 1983-01-05 1978-07-06 Gray Thelma Compton Advertising, Inc. 2925 1978-07-06 Compton Advertising, Inc. 1819 John F. Kennedy Boulevard   Philadelphia PA 19103
3083 3083 1983-01-05 1978-07-06 Gruver C. Robert Compton Advertising, Inc. 2925 1978-07-06 Compton Advertising, Inc. 1819 John F. Kennedy Boulevard   Philadelphia PA 19103
3629 3629 1999-01-15 1996-07-01 Milano Karen J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
3901 3901 1973-01-19 1972-04-13 Richmond Curt Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
4713 4713 1962-01-31 1958-08-25 Freedman Jean Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
6824 6824 1983-02-16 1981-09-23 Sommers Allen Sommers/Rosen, Inc. 3276 1981-09-23 Sommers/Rosen, Inc. 1405 Locust Street   Philadelphia PA 19102
7232 7232 1995-02-23 1994-05-06 Helfrich Jacqueline Anne Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
7330 7330 1960-02-25 1959-10-14 Graczyk Ludwik Polish-American Travel Service 1262 1959-08-28 Polish-American Travel Service 2714 East Allegheny Avenue   Philadelphia PA  
7480 7480 1999-02-26 1997-01-16 Horan Michael F. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
7902 7902 2001-02-28 1998-10-30 Berge Pauline C. Government of Dubai, Dept. of Tourism & Commerce Marketing 4217 1989-02-17 Government of Dubai, Dept. of Tourism & Commerce Marketing Eight Penn Center 19th Floor, Suite 1950 Philadelphia PA 19103
8039 8039 2015-02-28 2015-02-09 Feldman Dennis Ceisler Media & Issue Advocacy, LLC 6266 2014-12-19 Ceisler Media & Issue Advocacy, LLC 1525 Locust Street, 6th Floor   Philadelphia PA 19102
8551 8551 1996-03-01 1995-06-19 Ryan M. Martha Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
8709 8709 2000-03-02 1997-07-11 Butler R. Mark Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
8982 8982 1998-03-06 1994-12-22 Zartarian Stephen K. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
9225 9225 1981-03-09 1979-03-30 Berger Danierl David Berger, P.A. 3009 1979-03-30 David Berger, P.A. 1622 Locust Street   Philadelphia PA 19103
9226 9226 1981-03-09 1979-03-30 Berger David David Berger, P.A. 3009 1979-03-30 David Berger, P.A. 1622 Locust Street   Philadelphia PA 19103
9602 9602 1964-03-15 1959-12-07 Schmitt Albert Richard Friedmann Radio Broadcasting & Advertising Company 1304 1959-12-07 Friedmann Radio Broadcasting & Advertising Company 1105 Friendship Street   Philadelphia PA 19111
10097 10097 2008-03-20 2005-10-28 Persia Dana Al Paul Lefton Company Inc. 5614 2004-03-25 Al Paul Lefton Company Inc. 100 Independence Mall West   Philadelphia PA 19106-2399
10177 10177 2005-03-21 2004-03-25 Allmayer Bernard Al Paul Lefton Company Inc. 5614 2004-03-25 Al Paul Lefton Company Inc. 100 Independence Mall West   Philadelphia PA 19106-2399
10228 10228 2001-03-22 2000-12-18 Myers Laurence Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
10247 10247 1960-03-23 1948-02-16 Bellia Harry J. Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10248 10248 1960-03-23 1948-02-16 Freedman David Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10249 10249 1960-03-23 1948-02-16 Rifkin Maurice Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10250 10250 1960-03-23 1958-03-20 Kachnykewych Taras Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10251 10251 1960-03-23 1958-04-16 Freedman Jean Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10252 10252 1960-03-23 1958-04-16 Rifkin Lillian Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10253 10253 1960-03-23 1958-04-16 Rohatynskyj Peter Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10254 10254 1960-03-23 1958-04-16 Rosenberg Israel Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10255 10255 1960-03-23 1957-06-24 Adomonis John Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10256 10256 1960-03-23 1957-06-24 Biloskursky Mike Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10257 10257 1960-03-23 1957-06-24 Juodvalkis Anastasia Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10258 10258 1960-03-23 1957-06-24 Juodvalkis S.P. Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10259 10259 1960-03-23 1957-06-24 Kuczewski Thaddeus Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10260 10260 1960-03-23 1957-06-24 Lyons Norman Globe Travel Service 512 1948-02-16 Globe Travel Service 716 Walnut Street   Philadelphia PA  
10402 10402 2000-03-24 1997-07-07 Finamore Andrea J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
10552 10552 1978-03-27 1975-01-29 Daccarett Edward Jamaica Tourist Board, Philadelphia 2556 1975-01-29 Jamaica Tourist Board, Philadelphia 2 Penn Center Plaza Suite 1604 Philadelphia PA 19102
14425 14425 1999-04-30 1995-06-19 Cohen Barry Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
15339 15339 1995-05-05 1994-05-06 Vittolino Salvatore P. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
16085 16085 2008-05-16 2003-05-02 Rancourt Karolyn T. Rancourt, Karolyn T. 5559 2003-05-02 Rancourt, Karolyn T. 1648 South Orkney Street   Philadelphia PA 19148
16393 16393 2014-05-21 2013-12-12 Brandsdorfer Louis AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
17066 17066 2014-05-30 2013-06-20 Yarrow Steven AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
17924 17924 1976-06-01 1976-01-17 Adams Wayne W. Public Relations, Ltd. 2709 1976-07-17 Public Relations, Ltd. 3 Parkway   Philadelphia PA 19102
17925 17925 1976-06-01 1976-01-17 Rubin Lawrence D. Public Relations, Ltd. 2709 1976-07-17 Public Relations, Ltd. 3 Parkway   Philadelphia PA 19102
17926 17926 1976-06-01 1976-01-17 Weiner Warren Public Relations, Ltd. 2709 1976-07-17 Public Relations, Ltd. 3 Parkway   Philadelphia PA 19102
18273 18273 2010-06-03 2004-03-25 Peretz Michael Al Paul Lefton Company Inc. 5614 2004-03-25 Al Paul Lefton Company Inc. 100 Independence Mall West   Philadelphia PA 19106-2399
18808 18808 2009-06-12 2009-03-13 Hill James Duane Morris Government Affairs, LLC 5918 2009-03-13 Duane Morris Government Affairs, LLC 30 South 17th Street   Philadelphia PA 19103
18982 18982 1966-06-15 1958-08-25 Weresh Wasyl Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
18995 18995 1971-06-15 1958-08-25 Kuczewski Thaddeus Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19168 19168 2000-06-16 1999-06-29 Dzwill Eileen Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
19217 19217 1977-06-17 1975-06-06 Lawrence Gordon G. Spiro & Associates, Inc. 2545 1974-11-04 Spiro & Associates, Inc. Chestnut East Building 841 Chestnut Street Philadelphia PA 19107
19218 19218 1977-06-17 1974-11-04 Sherman Martin Spiro & Associates, Inc. 2545 1974-11-04 Spiro & Associates, Inc. Chestnut East Building 841 Chestnut Street Philadelphia PA 19107
19290 19290 1999-06-18 1994-12-22 Vaughan-Gowen Deborah Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
19417 19417 2014-06-20 2013-12-12 Gentieu Valerie AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
19436 19436 1988-06-21 1971-05-20 Yamanov Peter Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19437 19437 1988-06-21 1978-08-21 Yamonov Elisabeth Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19438 19438 1988-06-21 1958-08-25 Rifkin Lillian K. Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19439 19439 1988-06-21 1958-08-25 Rifkin Maurice Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19440 19440 1988-06-21 1958-08-25 Rohatynskyj Peter Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19441 19441 1988-06-21 1973-11-01 Schmidt Mary M. Globe Parcel Service, Inc. 1164 1958-08-25 Globe Parcel Service, Inc. 716 Walnut Street   Philadelphia PA 19106
19800 19800 2015-06-26 2015-05-18 Moga Katelyn M. Ceisler Media & Issue Advocacy, LLC 6266 2014-12-19 Ceisler Media & Issue Advocacy, LLC 1525 Locust Street, 6th Floor   Philadelphia PA 19102
20829 20829 2000-06-30 1999-06-29 Masse Jennifer J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20842 20842 2001-06-30 1996-01-02 Cintron Ana M. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20843 20843 2001-06-30 2000-01-10 Spratlin Jon Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20844 20844 2001-06-30 1997-01-16 Placido Peter A. , Jr. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20851 20851 2001-06-30 1994-05-06 Brandsdorfer Louis Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20852 20852 2001-06-30 1994-05-06 Evans John M. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20853 20853 2001-06-30 1994-05-06 Hennessy Brian J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20854 20854 2001-06-30 1994-05-06 Kneisel William J. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20855 20855 2001-06-30 1994-05-06 Lefton Al Paul , Jr. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20856 20856 2001-06-30 1994-05-06 Nunez Nurisell Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20857 20857 2001-06-30 1994-05-06 Orr John H. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20858 20858 2001-06-30 1994-05-06 Peretz Michael Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20859 20859 2001-06-30 1994-05-06 Russakoff Claire C. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20860 20860 2001-06-30 1994-05-06 Scanlon Raymond D. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20861 20861 2001-06-30 1994-05-06 Sharkey Darlene M. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20862 20862 2001-06-30 1994-05-06 Spross Theresa Marie Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20863 20863 2001-06-30 1994-05-06 Waters David Bruce Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20864 20864 2001-06-30 1994-05-06 Yarrow Steven E. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20867 20867 2001-06-30 2001-06-12 Fong Mary Ann Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20868 20868 2001-06-30 1995-06-19 Talbot James E. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
20887 20887 2001-06-30 1998-12-21 Ditton Jill Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
22720 22720 2005-07-15 2004-03-25 Kneisel William J. Al Paul Lefton Company Inc. 5614 2004-03-25 Al Paul Lefton Company Inc. 100 Independence Mall West   Philadelphia PA 19106-2399
23154 23154 1998-07-21 1994-10-04 Coote Marian K. Florence Government of Dubai, Dept. of Tourism & Commerce Marketing 4217 1989-02-17 Government of Dubai, Dept. of Tourism & Commerce Marketing Eight Penn Center 19th Floor, Suite 1950 Philadelphia PA 19103
23245 23245 1965-07-23 1964-07-24 Dilks Walter Howard , Jr. Dilworth, Paxson, Kalish, Kohn & Dilks 1775 1964-07-24 Dilworth, Paxson, Kalish, Kohn & Dilks 2635 Fidelity-Philadelphia Trust Building Philadelphia PA 19109
23347 23347 1999-07-23 1997-01-16 Michaud Anne E. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
24375 24375 2001-07-31 1999-10-28 Muldowney Laura C. Gallagher, John J. 5336 1999-10-28 Gallagher, John J. 1760 Market Street Suite 1100 Philadelphia PA 19103
24598 24598 2014-07-31 2011-05-24 Orr John H. AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
24611 24611 2014-07-31 2013-06-20 Foster Stephanie A. AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
24612 24612 2014-07-31 2013-06-20 Talbot James B. AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
24635 24635 2014-07-31 2013-12-12 Waters D. Bruce AB&C Philadelphia, LLC 6043 2011-05-24 AB&C Philadelphia, LLC 125 South 9th Street Suite 801 Philadelphia PA 19107
25127 25127 1966-08-02 1965-12-06 Rosenfeld Lawrence Mark Kenneth G. Smith & Associates, Inc. 1943 1965-12-06 Kenneth G. Smith & Associates, Inc. 1428 South Penn Square   Philadelphia PA 19102
25128 25128 1966-08-02 1965-12-06 Smith Kenneth G. , Sr. Kenneth G. Smith & Associates, Inc. 1943 1965-12-06 Kenneth G. Smith & Associates, Inc. 1428 South Penn Square   Philadelphia PA 19102
26897 26897 1996-08-28 1995-06-19 LaBranche Angelique Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399
27678 27678 2000-08-31 1999-10-28 Leventant Williams Gallagher, John J. 5336 1999-10-28 Gallagher, John J. 1760 Market Street Suite 1100 Philadelphia PA 19103
27684 27684 2001-08-31 1997-01-16 Buckman Judith G. Al Paul Lefton Company, Inc. 4912 1994-05-06 Al Paul Lefton Company, Inc. 100 Independence Mall, West Rohm & Haas Building Philadelphia PA 19106-2399

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])
);