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
2818 2818 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
2821 2821 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
3014 3014 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
3255 3255 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
3415 3415 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
3511 3511 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
3553 3553 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
3554 3554 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
3859 3859 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
4161 4161 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
4628 4628 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
5318 5318 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
5328 5328 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
5342 5342 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
5727 5727 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
5975 5975 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
6268 6268 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
6325 6325 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
6434 6434 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
6435 6435 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
6542 6542 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
6702 6702 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
6811 6811 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
7079 7079 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
7176 7176 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
7227 7227 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
7229 7229 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
7373 7373 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
8084 8084 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
8376 8376 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
8697 8697 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
8698 8698 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
8867 8867 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
8869 8869 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
8870 8870 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
8990 8990 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
8991 8991 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
8992 8992 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
8993 8993 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
9053 9053 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
9056 9056 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
9314 9314 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
9631 9631 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
9768 9768 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
9770 9770 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
9863 9863 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
9947 9947 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
9948 9948 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
10170 10170 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
10173 10173 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
10537 10537 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
10858 10858 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
11877 11877 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
11878 11878 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
11879 11879 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
11880 11880 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
11881 11881 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
11882 11882 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
11883 11883 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
11888 11888 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
11892 11892 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
11893 11893 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
11894 11894 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
11895 11895 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
11896 11896 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
11897 11897 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
11898 11898 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
11899 11899 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
11900 11900 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
11912 11912 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
11913 11913 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
11914 11914 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
11915 11915 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
11916 11916 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
11917 11917 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
11918 11918 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
11919 11919 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
11920 11920 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
12276 12276 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
12521 12521 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
12571 12571 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
12627 12627 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
12828 12828 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
12959 12959 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
13297 13297 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
13813 13813 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
14706 14706 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
14712 14712 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
15173 15173 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
15174 15174 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
15177 15177 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
15178 15178 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
15179 15179 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
15180 15180 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
15183 15183 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
15184 15184 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
15185 15185 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
15271 15271 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
15383 15383 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
15733 15733 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])
);