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

299 rows where Registration_Number = 5807

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Ogilvy Public Relations Worldwide · 299 ✖

Registrant_Name 1

City 1

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
2892 2892 2012-01-01 2009-12-22 Urquiola Claudia Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
2895 2895 2013-01-01 2011-10-17 Rojas Felipe Carlos Benitez Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
3093 3093 2008-01-02 2007-05-07 Huang Patricia Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
3367 3367 2011-01-07 2008-12-23 Gunn Graham Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
3526 3526 2012-01-10 2012-06-29 Cortes Rose Mary Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
3623 3623 2016-01-12 2015-06-30 Softness Nicole Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
3665 3665 2012-01-13 2012-06-29 Pearlman Jason Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
3666 3666 2012-01-13 2012-06-29 Swedowsky Maya Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
3974 3974 2013-01-17 2011-04-05 Redlingshafer Ramona Rosemary Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
4279 4279 2010-01-22 2008-12-23 Cetera Joan Catherine Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
4757 4757 2010-01-29 2009-07-02 Langdon Alison Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
5447 5447 2011-01-31 2008-12-23 Campbell Sean A. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
5457 5457 2013-01-31 2007-05-07 Law Michael A. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
5471 5471 2013-01-31 2009-12-22 Turner Lauren Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
5864 5864 2013-02-01 2012-06-29 Steinberg Janel Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
6118 6118 2011-02-04 2008-07-01 Green Brian Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
6415 6415 2012-02-08 2007-12-31 Greene Imani Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
6472 6472 2016-02-09 2016-01-13 Greco Kristen Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
6582 6582 2012-02-10 2012-06-29 Weiss Erin Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
6583 6583 2012-02-10 2012-06-29 Welch Latoya Guishard Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
6690 6690 2010-02-12 2008-12-23 Mazur Jane Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
6863 6863 2011-02-14 2007-12-31 Connell William V. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
6973 6973 2013-02-15 2012-06-29 Fletcher Kathleen Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
7242 7242 2010-02-19 2008-07-01 Reynolds Jenny E. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
7340 7340 2011-02-21 2009-12-22 Hammerman Rachel E. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
7392 7392 2013-02-22 2011-10-17 Garvey Kelsey Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
7394 7394 2013-02-22 2009-12-22 Thomas Alyson Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
7543 7543 2015-02-24 2014-12-30 Pogoff Sophia Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
8253 8253 2013-02-28 2011-10-17 Winokur Matthew Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
8554 8554 2012-02-29 2012-06-29 Rodriguez Veronica Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
8875 8875 2013-03-01 2012-06-29 Simpson Lauren Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
8876 8876 2013-03-01 2010-06-30 Musat Grace Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9055 9055 2009-03-03 2007-05-07 Arthur Holly Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9057 9057 2009-03-03 2008-12-23 Jackson Ayana N. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9058 9058 2009-03-03 2008-12-23 Schacht Andrew Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9178 9178 2012-03-05 2012-06-29 Coyle Mary E. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9179 9179 2012-03-05 2012-06-29 Higbie Heliana Veronica Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9180 9180 2012-03-05 2008-07-01 Boorstein Tamara Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9181 9181 2012-03-05 2011-10-17 Mordkowski Debora Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9241 9241 2009-03-06 2008-12-23 Knol Molly Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9244 9244 2015-03-06 2014-12-30 Radecki Shannon Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9518 9518 2012-03-09 2012-06-29 Shenoy Chetan Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9840 9840 2012-03-14 2012-06-29 Bruce Sean B. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9979 9979 2010-03-15 2008-12-23 Gamburg Zachary Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
9981 9981 2012-03-15 2008-07-01 Shoval Leah P.L. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
10077 10077 2012-03-16 2011-10-17 Daly Brendan Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
10161 10161 2013-03-17 2012-06-29 Tansill Charlotte Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
10162 10162 2013-03-17 2008-07-01 Dodson-Thompson Juanita Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
10385 10385 2013-03-20 2007-05-07 Sherer Paul Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
10388 10388 2013-03-20 2012-12-21 Corns Stephanie Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
10755 10755 2014-03-25 2014-06-30 Gianni Pasquale Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
11078 11078 2013-03-29 2007-12-31 Douglas Tim Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12099 12099 2013-03-31 2012-01-03 Davis Rebecca Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12100 12100 2013-03-31 2012-01-03 Hummel Allyson Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12101 12101 2013-03-31 2012-01-03 Jennings Lauren Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12102 12102 2013-03-31 2012-01-03 Kotlanger Meghan Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12103 12103 2013-03-31 2012-01-03 Lowe Jerry Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12104 12104 2013-03-31 2012-01-03 Lukstat Richard Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12105 12105 2013-03-31 2012-01-03 Santos Robert Bauzon Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12110 12110 2013-03-31 2011-04-05 Graves Christopher J Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12114 12114 2013-03-31 2007-05-07 Bullock Stanton (Tony) Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12115 12115 2013-03-31 2007-05-07 Caggiano Rachel E. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12116 12116 2013-03-31 2007-05-07 Davenport Rory Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12117 12117 2013-03-31 2007-05-07 Lee Edison Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12118 12118 2013-03-31 2012-06-29 Simpson Kendra Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12119 12119 2013-03-31 2010-06-30 Fillip Chris Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12120 12120 2013-03-31 2008-07-01 Linden Maggie Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12121 12121 2013-03-31 2008-07-01 Moeller James Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12122 12122 2013-03-31 2008-07-01 Stacey Jill M. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12134 12134 2013-03-31 2010-12-20 Coursen Cameron Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12135 12135 2013-03-31 2010-12-20 Rosenbloom Randi Appelbaum Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12136 12136 2013-03-31 2009-12-22 Ling Margaret R. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12137 12137 2013-03-31 2007-12-31 Hardeman Rajene Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12138 12138 2013-03-31 2007-12-31 Hardy Laura W. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12139 12139 2013-03-31 2007-12-31 Kehoe Louise Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12140 12140 2013-03-31 2007-12-31 Mullen Kellie Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12141 12141 2013-03-31 2007-12-31 Rangel Nicholas Salvador Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12142 12142 2013-03-31 2007-12-31 Smith Thomas Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12536 12536 2012-04-01 2011-10-17 Lear Robert Neil Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12790 12790 2012-04-05 2012-06-29 Cloutier Kevin Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12840 12840 2012-04-06 2012-06-29 Yacker Lauren Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
12897 12897 2010-04-07 2009-07-02 Purdy Erin Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
13099 13099 2013-04-10 2012-06-29 Choi Mina Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
13234 13234 2012-04-12 2012-06-29 Boyer Emily Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
13577 13577 2013-04-16 2011-10-17 Miller Kimberly Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
14100 14100 2012-04-25 2009-12-22 Nitta Lindsey Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15000 15000 2009-04-30 2008-12-23 Hirshon Russell Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15006 15006 2010-04-30 2009-07-02 Morrow Jonathan Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15470 15470 2013-05-01 2012-01-03 Light Meredith Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15471 15471 2013-05-01 2012-01-03 McConnaughey David T. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15474 15474 2013-05-01 2007-05-07 Stanko Gregory Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15475 15475 2013-05-01 2012-06-29 Manning Marie Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15476 15476 2013-05-01 2012-06-29 Wuebker Andrea Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15477 15477 2013-05-01 2008-07-01 Rosenberg Eric Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15480 15480 2013-05-01 2010-12-20 Essif Mason L. Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15481 15481 2013-05-01 2010-12-20 Henderson Rachel Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15482 15482 2013-05-01 2010-12-20 Omer Amal Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15592 15592 2016-05-02 2015-06-30 Barnetche Andrea Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
15705 15705 2015-05-04 2014-12-30 Schenck Dwain Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
16058 16058 2012-05-11 2012-06-29 Florez Elsa Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036

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