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

956 rows where State = "VA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number >30

  • International Registries, Inc. 65
  • Jellinek, Schwartz & Connolly, Inc. 36
  • Alcalde & Fay 26
  • Bannerman & Associates, Inc. 25
  • National Union for the Total Independence of Angola (UNITA) 16
  • Keene, Shirley & Associates, Inc. 16
  • American Trade & Finance Company 15
  • Beef + Lamb New Zealand, Ltd. 14
  • Urenco, Inc. 13
  • Richard L. Collins & Company, Inc. 13
  • McGuireWoods Consulting, LLC 13
  • Marshall Islands Maritime & Corporate Administrators, Inc. 11
  • Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 11
  • Black, Manafort & Stone, Inc. 10
  • Thales, Inc. 10
  • MITA Group, Inc. 10
  • KRL International, LLC 10
  • Potomac International Partners, Inc. 10
  • McGuireWoods Consulting, LLC 9
  • Piper Pacific International 8
  • Bronz & Farrell 7
  • Reese Communications Companies, Inc. 7
  • Hawthorn Group, L.C. 7
  • LISCR, LLC 7
  • Alcalde & Fay, Ltd. 7
  • Corallo Media Strategies, Inc 7
  • IPAC, Inc. 6
  • Rollins International, Ltd. 6
  • Pierson & Burnett, L.L.P. 6
  • LeClairRyan, A Professional Corporation 6
  • …

Registrant_Name >30

  • International Registries, Inc. 65
  • Jellinek, Schwartz & Connolly, Inc. 36
  • Alcalde & Fay 32
  • Bannerman & Associates, Inc. 25
  • McGuireWoods Consulting, LLC 22
  • Keene, Shirley & Associates, Inc. 16
  • National Union for the Total Independence of Angola (UNITA) 16
  • American Trade & Finance Company 15
  • Beef + Lamb New Zealand, Ltd. 14
  • Richard L. Collins & Company, Inc. 13
  • Urenco, Inc. 13
  • Marshall Islands Maritime & Corporate Administrators, Inc. 11
  • Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 11
  • Black, Manafort & Stone, Inc. 10
  • KRL International, LLC 10
  • MITA Group, Inc. 10
  • Potomac International Partners, Inc. 10
  • Stafford, Burke & Hecker, Inc. 10
  • Thales, Inc. 10
  • FitzGibbon Media, Inc. 8
  • Piper Pacific International 8
  • Smith & Harroff, Inc. 8
  • Alcalde & Fay, Ltd. 7
  • Bronz & Farrell 7
  • Corallo Media Strategies, Inc 7
  • Hawthorn Group, L.C. 7
  • LISCR, LLC 7
  • Reese Communications Companies, Inc. 7
  • Alexandria Group International LLC 6
  • IPAC, Inc. 6
  • …

City >30

  • Arlington 296
  • Alexandria 283
  • Reston 94
  • McLean 60
  • Falls Church 48
  • Vienna 46
  • Richmond 28
  • Great Falls 16
  • Fairfax 12
  • Lawrenceville 9
  • Richmond 9
  • Annandale 8
  • Burke 6
  • Woodbridge 6
  • Bailey's Cross Roads 4
  • Leesburg 4
  • Flint Hill 3
  • Alexandira 2
  • Alexandria 2
  • Kilmarnock 2
  • Lake Ridge 2
  • Oak Hill 2
  • Spotsylvania 2
  • Winchester 2
  • Ashburn 1
  • Chantilly 1
  • Fairfax Station 1
  • Lexington 1
  • Lorton 1
  • Manassas 1
  • …

State 1

  • VA · 956 ✖
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
7 7     Nurnberger Ralh D Nurnberger & Associates, Inc. 6907 2021-01-13 Nurnberger & Associates, Inc. 4870-F Old Dominion Drive   Arlington VA 22207
31 31   2022-01-04 Lewis Jr. Robert The Van Aucker Group 7066 2022-01-04 The Van Aucker Group 5500 Layne Estates Court   Alexandria VA 22310
121 121   2022-01-18 Chiimbwe Spencer K. Ambessa Solutions LLC 6962 2021-05-17 Ambessa Solutions LLC 1707 Pleasantdale Road Apartment 103 Vienna VA 22180
123 123   2022-01-18 Orth Richard Kevin Ambessa Solutions LLC 6962 2021-05-17 Ambessa Solutions LLC 1707 Pleasantdale Road Apartment 103 Vienna VA 22180
130 130   2020-01-21 Mengna LI Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
152 152   2021-01-24 Jackson Robert Porter Jackson, Robert Porter 6915 2021-01-24 Jackson, Robert Porter 9723 Spring Ridge Lane   Vienna VA 22182-1451
165 165   2017-01-26 Zhao Zhenge Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
286 286   2019-02-07 Chwat John McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
378 378   2016-02-23 Greer Lauren C. McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
406 406   2013-02-26 Meikle Terry J. Beef + Lamb New Zealand, Ltd. 2526 1974-07-08 Beef + Lamb New Zealand, Ltd. 6841 Elm Street #7401 McLean VA 22106
416 416   1992-02-28 Gallagher William R. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
430 430   2022-03-01 Rodriguez Carlos Daniel RJI Capital Corporation 6768 2019-12-12 RJI Capital Corporation 1001 19th Street N Suite 2000 Arlington VA 22209
463 463   2020-03-05 Goth Bashir Somaliland Mission USA, LLC 6798 2020-03-05 Somaliland Mission USA, LLC 6019 Tower Court   Alexandria VA 22304
464 464   2020-03-05 Meri Yassin Mohamed Somaliland Mission USA, LLC 6798 2020-03-05 Somaliland Mission USA, LLC 6019 Tower Court   Alexandria VA 22304
506 506   2022-03-10 Karchmer Clifford Alexandria Group International LLC 6707 2019-08-15 Alexandria Group International LLC 4115 S Hicks Street   Lawrenceville VA 23868
513 513   2020-03-11 Humphrey Calvin R. RJI Capital Corporation 6768 2019-12-12 RJI Capital Corporation 1001 19th Street N Suite 2000 Arlington VA 22209
548 548   2003-03-17 Fay Robert A. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
559 559   2020-03-18 Faucheux Ronald Certus Insights, LLC 6801 2020-03-18 Certus Insights, LLC 1418 N. Rhodes Street   Arlington VA 22209
560 560   2020-03-18 Rugg Andrew Certus Insights, LLC 6801 2020-03-18 Certus Insights, LLC 1418 N. Rhodes Street   Arlington VA 22209
582 582   2018-03-22 Hertenstein Christian Bullpen Strategy Group, Inc.  6504 2017-12-29 Bullpen Strategy Group, Inc. 1500 Wilson Boulevard, 5th Floor   Arlington VA 22209
613 613   2021-03-25 Makar Nicholas International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
641 641   2018-03-29 Bonnett Simon Christopher International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
642 642   2018-03-29 Bouchard Elizabeth S. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
643 643   2018-03-29 Diaz-Bonilla Rebecca Lumen8 Advisors, LLC 6537 2018-03-29 Lumen8 Advisors, LLC 9924 Browns Mill Road   Vienna VA 22182
644 644   2018-03-29 Feild Peter M. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
645 645   2018-03-29 Kirby Meredith A. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
646 646   2018-03-29 Poskiatis Brian F. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
647 647   2018-03-29 Wilson Alison Y. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
665 665   2000-03-30 Maitland Guy Edison Clay International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
668 668   2018-03-30 Puls Daniel P. PASS LLC 6538 2018-03-30 PASS LLC 1101 King Street #360 Alexandria VA 22314
726 726   2019-04-08 Jacobs Brenda A. Jacobs Global Trade & Compliance LLC 6656 2019-04-08 Jacobs Global Trade & Compliance LLC 4134 N. River Street   McLean VA 22101
747 747   2022-04-11 Sutton Eric PLUS Communications, LLC 7107 2022-04-11 PLUS Communications, LLC 3001 Washington Boulevard 7th Floor Arlington VA 22201
927 927   2018-05-04 Kong Zhiqiang Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
954 954   2018-05-08 Atef Ahmed Southern Transitional Council (US), Ltd. 6552 2018-05-08 Southern Transitional Council (US), Ltd. 6107 Harvester Court   Burke VA 22015
1003 1003   2021-05-15 Lintner Thomas Michael Aloft Group, LLC 6961 2021-05-15 Aloft Group, LLC P.O. Box 107   Kilmarnock VA 22482
1024 1024   2015-05-19 Bowles Mark T. McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
1076 1076   2021-05-26 Reeves Mark Aloft Group, LLC 6961 2021-05-15 Aloft Group, LLC P.O. Box 107   Kilmarnock VA 22482
1275 1275   1991-07-01 Guida Florigio Antonio International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
1290 1290   2012-07-06 Zhang Chunsheng Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
1333 1333   2020-07-15 Kolton Chad M Blueprint Communications, LLC 6844 2020-07-15 Blueprint Communications, LLC 2111 Eisenhower Avenue Suite 400 Alexandria VA 22314
1375 1375   2021-07-26 Castro Alfonso Castillero LISCR, LLC 5490 2002-04-02 LISCR, LLC 8619 Westwood Center Drive Suite 300 Vienna VA 22182
1376 1376   2021-07-26 Cohen Adam Isaac LISCR, LLC 5490 2002-04-02 LISCR, LLC 8619 Westwood Center Drive Suite 300 Vienna VA 22182
1377 1377   2021-07-26 Cohen Elan Aaron LISCR, LLC 5490 2002-04-02 LISCR, LLC 8619 Westwood Center Drive Suite 300 Vienna VA 22182
1379 1379   2021-07-26 Nossova Irina LISCR, LLC 5490 2002-04-02 LISCR, LLC 8619 Westwood Center Drive Suite 300 Vienna VA 22182
1380 1380   2021-07-26 Smith Dallas Duane LISCR, LLC 5490 2002-04-02 LISCR, LLC 8619 Westwood Center Drive Suite 300 Vienna VA 22182
1486 1486   2019-08-15 Harris Marshall Alexandria Group International LLC 6707 2019-08-15 Alexandria Group International LLC 4115 S Hicks Street   Lawrenceville VA 23868
1511 1511   2021-08-20 Nurnberger Ralph D Nurnberger & Associates, Inc. 6907 2021-01-13 Nurnberger & Associates, Inc. 4870-F Old Dominion Drive   Arlington VA 22207
1523 1523   2018-08-22 Keysor David McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
1535 1535   2020-08-27 Patel Vasudev Overseas Friends of BJP-USA 6861 2020-08-27 Overseas Friends of BJP-USA 12310 Pinecrest Road Suite 206 Reston VA 20191
1536 1536   2020-08-27 Prasad Adapa V. Overseas Friends of BJP-USA 6861 2020-08-27 Overseas Friends of BJP-USA 12310 Pinecrest Road Suite 206 Reston VA 20191
1571 1571   2021-08-31 Curt Evan International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
1573 1573   2021-08-31 Molver Hans International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
1633 1633   2006-09-12 Boddie Richard F. Slocum & Boddie, PLLC 5765 2006-09-12 Slocum & Boddie, PLLC 5400 Shanee Rd. Suite 300 Alexandria VA 22312
1634 1634   2006-09-12 Slocum J. Michael Slocum & Boddie, PLLC 5765 2006-09-12 Slocum & Boddie, PLLC 5400 Shanee Rd. Suite 300 Alexandria VA 22312
1640 1640   2017-09-14 Lockhart Elizabeth Beef + Lamb New Zealand, Ltd. 2526 1974-07-08 Beef + Lamb New Zealand, Ltd. 6841 Elm Street #7401 McLean VA 22106
1809 1809   2018-10-19 Corallo Mark Corallo Media Strategies, Inc 6602 2018-10-19 Corallo Media Strategies, Inc 520 North Washington Street   Alexandria VA 22314
1810 1810   2018-10-19 DeAngelis Bryan Corallo Media Strategies, Inc 6602 2018-10-19 Corallo Media Strategies, Inc 520 North Washington Street   Alexandria VA 22314
1811 1811   2018-10-19 Hainline Ian Corallo Media Strategies, Inc 6602 2018-10-19 Corallo Media Strategies, Inc 520 North Washington Street   Alexandria VA 22314
1812 1812   2018-10-19 Johnston Michael Corallo Media Strategies, Inc 6602 2018-10-19 Corallo Media Strategies, Inc 520 North Washington Street   Alexandria VA 22314
1813 1813   2018-10-19 Kisling Alexander Corallo Media Strategies, Inc 6602 2018-10-19 Corallo Media Strategies, Inc 520 North Washington Street   Alexandria VA 22314
1814 1814   2018-10-19 Schmaler Tracy Corallo Media Strategies, Inc 6602 2018-10-19 Corallo Media Strategies, Inc 520 North Washington Street   Alexandria VA 22314
1815 1815   2018-10-19 Weller Gerald (Jerry) Corallo Media Strategies, Inc 6602 2018-10-19 Corallo Media Strategies, Inc 520 North Washington Street   Alexandria VA 22314
1899 1899   2019-10-29 Perticone Joseph Warren Bullpen Strategy Group, Inc.  6504 2017-12-29 Bullpen Strategy Group, Inc. 1500 Wilson Boulevard, 5th Floor   Arlington VA 22209
1926 1926   2018-10-31 Holly Josh Holly Strategies Incorporated 6605 2018-10-31 Holly Strategies Incorporated 825 South Monroe Street   Arlington VA 22204
1971 1971   2002-11-04 Sherman (Colbert) Laura M. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
1977 1977   2021-11-04 Velitchkov Angel Alexandria Group International LLC 6707 2019-08-15 Alexandria Group International LLC 4115 S Hicks Street   Lawrenceville VA 23868
2015 2015   2020-11-12 Maric Zorica Alexandria Group International LLC 6707 2019-08-15 Alexandria Group International LLC 4115 S Hicks Street   Lawrenceville VA 23868
2028 2028   2020-11-13 Baird III Frederick A. Off Hill Strategies LLC 6889 2020-11-13 Off Hill Strategies LLC 637 25th Street South   Arlington VA 22202
2029 2029   2020-11-13 Baird Jennifer Off Hill Strategies LLC 6889 2020-11-13 Off Hill Strategies LLC 637 25th Street South   Arlington VA 22202
2036 2036   2017-11-15 Garziglia John F. Reston Translator, LLC 6490 2017-11-15 Reston Translator, LLC 11140 Glade Drive   Reston VA 20191
2041 2041   2021-11-15 Gallagher James P. The Gallagher Group, LLC 7046 2021-11-15 The Gallagher Group, LLC 2503 Hayes Street   Alexandria VA 22302
2042 2042   2016-11-16 McKeon Howard D. McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
2043 2043   2016-11-16 McKeon Howard P. McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
2232 2232   2021-12-06 Schultz Eric Todd ETS Consulting 7052 2021-12-06 ETS Consulting 2800 Flagmaker Drive   Falls Church VA 22042
2236 2236   2017-12-08 Berardini Chris Iron Bridge Strategies LLC 6497 2017-12-08 Iron Bridge Strategies LLC 5573 Seminary Road Unit 106 Falls Church VA 22041
2261 2261   2019-12-12 Cuevas Steven RJI Capital Corporation 6768 2019-12-12 RJI Capital Corporation 1001 19th Street N Suite 2000 Arlington VA 22209
2262 2262   2019-12-12 Laughlin Bradford RJI Capital Corporation 6768 2019-12-12 RJI Capital Corporation 1001 19th Street N Suite 2000 Arlington VA 22209
2265 2265   2017-12-13 Brunts Laura KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
2266 2266   2017-12-13 Johnson Danielle KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
2269 2269   2019-12-13 Thompson Danica McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 800 East Canal Street   Richmond VA 23219
2537 2537 1988-01-01 1974-07-30 Treat Mark G. Taussig-Tomb & Associates 2217 1970-11-05 Taussig-Tomb & Associates 1655 North Fort Myer Drive Suite 1100 Arlington VA 22209
2585 2585 1992-01-01 1991-04-03 Klein William Francis Capital Partnerships, Inc. 4495 1991-04-03 Capital Partnerships, Inc. 11350 Random Hills Road Suite 800 Fairfax VA 22030
2595 2595 1992-01-01 1986-12-10 Gemma Frances Griffin Griffin Communications 3913 1986-06-10 Griffin Communications 713 Park Street, S.E.   Vienna VA 22180
2618 2618 1996-01-01 1988-07-13 Viets Richard N. Aspen Hill Enterprises, Ltd. 4158 1988-07-13 Aspen Hill Enterprises, Ltd. Over the Grass Farm Post Office Box 398 The Plains VA 22171
2656 2656 1999-01-01 1996-11-08 Lenders Maurice Urenco, Inc. 5137 1996-11-08 Urenco, Inc. 1560 Wilson Boulevard Suite 300 Arlington VA 22209-2463
2663 2663 2001-01-01 1993-02-23 Callahan Daniel J. , III International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
2713 2713 2007-01-01 2001-03-23 Egelston Phillip International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
2718 2718 2007-01-01 2005-08-15 Kohler Nancy L. Richard L. Collins & Company, Inc. 5537 2003-01-22 Richard L. Collins & Company, Inc. 2111 Wilson Boulevard Suite 700 Arlington VA 22201
2721 2721 2007-01-01 2001-10-03 Plankl Kurt B. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
2738 2738 2009-01-01 2000-10-19 Solarz Stephen Solarz Associates 5358 2000-02-14 Solarz Associates 1120 Bellview Road   McLean VA 22102
2742 2742 2010-01-01 2006-03-24 Osborne Jason MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
2753 2753 2010-01-01 2009-11-04 Galloway Michael MITA Group, Inc. 5741 2006-03-24 MITA Group, Inc. 8320 Old Courthouse Road Suite 200 Vienna VA 22182
2861 2861 2017-01-01 2015-02-08 Frazee Elizabeth W. TwinLogic Strategies, LLP 6276 2015-02-08 TwinLogic Strategies, LLP 6313 Evermay Drive   McLean VA 22101
2862 2862 2017-01-01 2015-02-08 Wolbers Rachel TwinLogic Strategies, LLP 6276 2015-02-08 TwinLogic Strategies, LLP 6313 Evermay Drive   McLean VA 22101
3095 3095 1998-01-05 1994-10-12 Narayanan Ram Indo-American Chamber of Commerce 4489 1991-03-19 Indo-American Chamber of Commerce 1240 Daleview Drive   McLean VA 22102
3096 3096 1998-01-05 1994-10-12 Shah Ramesh Indo-American Chamber of Commerce 4489 1991-03-19 Indo-American Chamber of Commerce 1240 Daleview Drive   McLean VA 22102
3097 3097 1998-01-05 1994-10-12 Sidhaye Ram Indo-American Chamber of Commerce 4489 1991-03-19 Indo-American Chamber of Commerce 1240 Daleview Drive   McLean VA 22102
3189 3189 1997-01-07 1996-08-28 Petchel Charles T. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
3203 3203 2013-01-07 2012-12-14 Goldstein Dana Webster Hudson Just Consulting LLC 6137 2012-09-25 Just Consulting LLC 950 N. Washington St.   Alexandria VA 22314
3325 3325 2015-01-09 2014-11-25 Blum Daniel Mair Strategies, LLC 6257 2014-10-09 Mair Strategies, LLC 1401 N. Oak Street, G-4   Arlington VA 22209

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