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

981 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. 67
  • 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
  • Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 13
  • McGuireWoods Consulting, LLC 13
  • Marshall Islands Maritime & Corporate Administrators, Inc. 11
  • KRL International, LLC 11
  • Black, Manafort & Stone, Inc. 10
  • Thales, Inc. 10
  • LISCR, LLC 10
  • MITA Group, Inc. 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
  • 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. 67
  • 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
  • Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 13
  • Richard L. Collins & Company, Inc. 13
  • Urenco, Inc. 13
  • KRL International, LLC 11
  • Marshall Islands Maritime & Corporate Administrators, Inc. 11
  • Black, Manafort & Stone, Inc. 10
  • LISCR, 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
  • Reese Communications Companies, Inc. 7
  • Alexandria Group International LLC 6
  • IPAC, Inc. 6
  • …

City >30

  • Arlington 302
  • Alexandria 286
  • Reston 96
  • McLean 63
  • Falls Church 50
  • Vienna 40
  • Richmond 29
  • Great Falls 16
  • Fairfax 12
  • Dulles 10
  • Lawrenceville 9
  • Richmond 9
  • Annandale 8
  • Burke 8
  • 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
  • McLean 1
  • Ashburn 1
  • Chantilly 1
  • Fairfax Station 1
  • Hamilton 1
  • …

State 1

  • VA · 981 ✖
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
39 39     Simpkins Gregory BW GLOBAL GROUP, LLC. 6935 2021-03-10 BW GLOBAL GROUP, LLC. 1239 Beverly Road   McLean VA 22101
65 65   2023-01-06 Dempsey Allison Hope Kurdish Protection Action Committee 7213 2023-01-06 Kurdish Protection Action Committee 6062 Burnside Landing Drive   Burke VA 22015
66 66   2023-01-06 Qanbar Entifadh Kamal Kurdish Protection Action Committee 7213 2023-01-06 Kurdish Protection Action Committee 6062 Burnside Landing Drive   Burke VA 22015
142 142   2022-01-18 Chiimbwe Spencer K. Ambessa Solutions LLC 6962 2021-05-17 Ambessa Solutions LLC 1707 Pleasantdale Road Apartment 103 Vienna VA 22180
143 143   2022-01-18 Orth Richard Kevin Ambessa Solutions LLC 6962 2021-05-17 Ambessa Solutions LLC 1707 Pleasantdale Road Apartment 103 Vienna VA 22180
179 179   2021-01-24 Jackson Robert Porter Jackson, Robert Porter 6915 2021-01-24 Jackson, Robert Porter 9723 Spring Ridge Lane   Vienna VA 22182-1451
245 245   2023-01-30 Lapetina Christopher Isaiah King 7224 2023-01-30 Isaiah King 1489 Northern Neck Drive   Vienna VA 22182
317 317   2023-02-04 Cao Yongping 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
333 333   2019-02-07 Chwat John McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
438 438   2023-02-22 Xenakoudis Theofilos International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
465 465   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
476 476   1992-02-28 Gallagher William R. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
521 521   2020-03-05 Goth Bashir Somaliland Mission USA, LLC 6798 2020-03-05 Somaliland Mission USA, LLC 6019 Tower Court   Alexandria VA 22304
522 522   2020-03-05 Meri Yassin Mohamed Somaliland Mission USA, LLC 6798 2020-03-05 Somaliland Mission USA, LLC 6019 Tower Court   Alexandria VA 22304
556 556   2021-03-10 Birrell Jeffrey C. BW GLOBAL GROUP, LLC. 6935 2021-03-10 BW GLOBAL GROUP, LLC. 1239 Beverly Road   McLean VA 22101
560 560   2021-03-10 White Alan W. BW GLOBAL GROUP, LLC. 6935 2021-03-10 BW GLOBAL GROUP, LLC. 1239 Beverly Road   McLean VA 22101
562 562   2022-03-10 Karchmer Clifford Alexandria Group International LLC 6707 2019-08-15 Alexandria Group International LLC 4115 S Hicks Street   Lawrenceville VA 23868
597 597   2023-03-16 Harris Marshall The Marshall Harris Group 7245 2023-03-16 The Marshall Harris Group 703 Norfolk Lane   Alexandria VA 22314
598 598   2003-03-17 Fay Robert A. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
606 606   2020-03-18 Faucheux Ronald Certus Insights, LLC 6801 2020-03-18 Certus Insights, LLC 1418 N. Rhodes Street   Arlington VA 22209
607 607   2020-03-18 Rugg Andrew Certus Insights, LLC 6801 2020-03-18 Certus Insights, LLC 1418 N. Rhodes Street   Arlington VA 22209
633 633   2018-03-22 Hertenstein Christian Bullpen Strategy Group, LLC 6504 2017-12-29 Bullpen Strategy Group, LLC 1500 Wilson Boulevard, 5th Floor   Arlington VA 22209
662 662   2021-03-25 Makar Nicholas International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
682 682   2018-03-29 Bonnett Simon Christopher International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
683 683   2018-03-29 Bouchard Elizabeth S. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
684 684   2018-03-29 Diaz-Bonilla Rebecca Lumen8 Advisors, LLC 6537 2018-03-29 Lumen8 Advisors, LLC 9924 Browns Mill Road   Vienna VA 22182
685 685   2018-03-29 Kirby Meredith A. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
686 686   2018-03-29 Poskiatis Brian F. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
687 687   2018-03-29 Wilson Alison Y. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
705 705   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
708 708   2018-03-30 Puls Daniel P. PASS LLC 6538 2018-03-30 PASS LLC 1101 King Street #360 Alexandria VA 22314
742 742   2022-04-05 Burke Elizabeth Crestview Strategy USA LLC 6858 2020-08-21 Crestview Strategy USA LLC 2409 Ottawa St.,   Arlington VA 22205
758 758   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
781 781   2022-04-11 Sutton Eric PLUS Communications, LLC 7107 2022-04-11 PLUS Communications, LLC 3001 Washington Boulevard 7th Floor Arlington VA 22201
847 847   2023-04-18 Lewis Jr. Robert The Van Aucker Group 7260 2023-04-18 The Van Aucker Group 5500 Layne Estates Court   Alexandria VA 22310
1019 1019   2023-05-10 Bohannon Robert Trask Hunton Andrews Kurth LLP 7268 2023-05-10 Hunton Andrews Kurth LLP 951 East Byrd Street Riverfront Plaza, East Tower Richmond VA 23219
1087 1087   2023-05-19 Fogarty Kevin Ambrose Partners LLC 7276 2023-05-19 Ambrose Partners LLC 1803 Olive Court   Alexandria VA 22308
1197 1197   2022-05-31 Ivanenko Marina LISCR, LLC 5490 2002-04-02 LISCR, LLC 22980 Indian Creek Drive Suite 200 Dulles VA 20166
1350 1350   1991-07-01 Guida Florigio Antonio International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
1365 1365   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
1378 1378   2022-07-08 Levinson K Riva KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
1457 1457   2021-07-26 Castro Alfonso Castillero LISCR, LLC 5490 2002-04-02 LISCR, LLC 22980 Indian Creek Drive Suite 200 Dulles VA 20166
1458 1458   2021-07-26 Cohen Adam Isaac LISCR, LLC 5490 2002-04-02 LISCR, LLC 22980 Indian Creek Drive Suite 200 Dulles VA 20166
1459 1459   2021-07-26 Cohen Elan Aaron LISCR, LLC 5490 2002-04-02 LISCR, LLC 22980 Indian Creek Drive Suite 200 Dulles VA 20166
1461 1461   2021-07-26 Nossova Irina LISCR, LLC 5490 2002-04-02 LISCR, LLC 22980 Indian Creek Drive Suite 200 Dulles VA 20166
1575 1575   2019-08-15 Harris Marshall Alexandria Group International LLC 6707 2019-08-15 Alexandria Group International LLC 4115 S Hicks Street   Lawrenceville VA 23868
1614 1614   2020-08-21 Greenwood Maryscott Crestview Strategy USA LLC 6858 2020-08-21 Crestview Strategy USA LLC 2409 Ottawa St.,   Arlington VA 22205
1616 1616   2018-08-22 Keysor David McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 675 North Washington Street Suite 340 Alexandria VA 22314
1638 1638   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
1639 1639   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
1657 1657   2022-08-30 Ng Annie International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
1670 1670   2021-08-31 Curt Evan International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
1672 1672   2021-08-31 Molver Hans International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
1730 1730   2006-09-12 Boddie Richard F. Slocum & Boddie, PLLC 5765 2006-09-12 Slocum & Boddie, PLLC 5400 Shanee Rd. Suite 300 Alexandria VA 22312
1731 1731   2006-09-12 Slocum J. Michael Slocum & Boddie, PLLC 5765 2006-09-12 Slocum & Boddie, PLLC 5400 Shanee Rd. Suite 300 Alexandria VA 22312
1738 1738   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
1906 1906   2022-10-10 Garibaldi Reynaldo LISCR, LLC 5490 2002-04-02 LISCR, LLC 22980 Indian Creek Drive Suite 200 Dulles VA 20166
1908 1908   2022-10-10 Sidifall Ruphene LISCR, LLC 5490 2002-04-02 LISCR, LLC 22980 Indian Creek Drive Suite 200 Dulles VA 20166
2049 2049   2018-10-31 Holly Josh Holly Strategies Incorporated 6605 2018-10-31 Holly Strategies Incorporated 825 South Monroe Street   Arlington VA 22204
2082 2082   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
2141 2141   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
2142 2142   2020-11-13 Baird Jennifer Off Hill Strategies LLC 6889 2020-11-13 Off Hill Strategies LLC 637 25th Street South   Arlington VA 22202
2147 2147   2017-11-15 Garziglia John F. Reston Translator, LLC 6490 2017-11-15 Reston Translator, LLC 11140 Glade Drive   Reston VA 20191
2151 2151   2021-11-15 Gallagher James P. The Gallagher Group, LLC 7046 2021-11-15 The Gallagher Group, LLC 2503 Hayes Street   Alexandria VA 22302
2153 2153   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
2337 2337   2022-12-05 Jirari Tahra Bullpen Strategy Group, LLC 6504 2017-12-29 Bullpen Strategy Group, LLC 1500 Wilson Boulevard, 5th Floor   Arlington VA 22209
2344 2344   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
2367 2367   2022-12-10 Kwemo Angelle B. Astrategik Group 7201 2022-12-10 Astrategik Group 1644 Anderson Road, #3   McLean VA 22102
2374 2374   2017-12-13 Brunts Laura KRL International, LLC 5788 2007-01-26 KRL International, LLC 6682 Van Winkle Drive   Falls Church VA 22044
2661 2661 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
2709 2709 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
2719 2719 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
2742 2742 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
2780 2780 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
2787 2787 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
2837 2837 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
2842 2842 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
2845 2845 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
2862 2862 2009-01-01 2000-10-19 Solarz Stephen Solarz Associates 5358 2000-02-14 Solarz Associates 1120 Bellview Road   McLean VA 22102
2866 2866 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
2877 2877 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
2985 2985 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
2986 2986 2017-01-01 2015-02-08 Wolbers Rachel TwinLogic Strategies, LLP 6276 2015-02-08 TwinLogic Strategies, LLP 6313 Evermay Drive   McLean VA 22101
3017 3017 2023-01-01 2022-07-09 Planty Matthew Dominic Planty & Associates LLC 7136 2022-07-09 Planty & Associates LLC 107 Levenbury Place   Hamilton VA 20158
3228 3228 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
3229 3229 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
3230 3230 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
3355 3355 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
3369 3369 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
3490 3490 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
3491 3491 2015-01-09 2014-11-25 LeCounte Anthony Mair Strategies, LLC 6257 2014-10-09 Mair Strategies, LLC 1401 N. Oak Street, G-4   Arlington VA 22209
3492 3492 2015-01-09 2014-11-25 Mair Elizabeth A. Mair Strategies, LLC 6257 2014-10-09 Mair Strategies, LLC 1401 N. Oak Street, G-4   Arlington VA 22209
3494 3494 2017-01-09 2016-06-13 McCoy Tidal W. McMark, LLC 6359 2016-06-13 McMark, LLC 330 Chesapeake Drive   Great Falls VA 22066
3512 3512 1991-01-10 1987-01-09 Weintraub Michael P. Ann E.W. Stone & Associates 3914 1986-12-11 Ann E.W. Stone & Associates 1315 Duke Street   Alexandria VA 22314
3521 3521 2001-01-10 1992-09-22 Geier-Smith Hope Whitmore, Judith M. 4336 1990-02-05 Whitmore, Judith M. 9504 Carterwood Road   Richmond VA 23229-7608
3580 3580 2013-01-11 2012-10-03 Grieboski Joseph K Just Consulting LLC 6137 2012-09-25 Just Consulting LLC 950 N. Washington St.   Alexandria VA 22314
3581 3581 2013-01-11 2012-10-03 Hengesbach Kelly Just Consulting LLC 6137 2012-09-25 Just Consulting LLC 950 N. Washington St.   Alexandria VA 22314
3803 3803 2002-01-15 1998-10-23 Gagliano John E. Cohen Gettings, P.C. 5283 1998-10-23 Cohen Gettings, P.C. 2200 Wilson Boulevard Suite 800 Arlington VA 22201
3890 3890 1995-01-16 1992-02-28 Gilner Diane M. Peterson International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
3924 3924 2023-01-16 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

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