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), 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
2900 2900 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
2903 2903 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
3105 3105 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
3379 3379 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
3538 3538 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
3635 3635 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
3677 3677 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
3678 3678 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
3986 3986 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
4291 4291 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
4769 4769 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
5459 5459 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
5469 5469 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
5483 5483 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
5877 5877 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
6131 6131 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
6428 6428 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
6485 6485 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
6595 6595 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
6596 6596 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
6703 6703 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
6876 6876 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
6986 6986 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
7255 7255 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
7353 7353 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
7405 7405 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
7407 7407 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
7556 7556 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
8266 8266 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
8567 8567 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
8888 8888 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
8889 8889 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
9068 9068 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
9070 9070 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
9071 9071 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
9191 9191 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
9192 9192 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
9193 9193 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
9194 9194 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
9254 9254 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
9257 9257 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
9531 9531 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
9853 9853 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
9992 9992 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
9994 9994 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
10090 10090 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
10174 10174 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
10175 10175 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
10398 10398 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
10401 10401 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
10768 10768 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
11091 11091 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
12112 12112 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
12113 12113 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
12114 12114 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
12115 12115 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
12116 12116 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
12117 12117 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
12118 12118 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
12123 12123 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
12127 12127 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
12128 12128 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
12129 12129 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
12130 12130 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
12131 12131 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
12132 12132 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
12133 12133 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
12134 12134 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
12135 12135 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
12147 12147 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
12148 12148 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
12149 12149 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
12150 12150 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
12151 12151 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
12152 12152 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
12153 12153 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
12154 12154 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
12155 12155 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
12550 12550 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
12804 12804 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
12854 12854 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
12911 12911 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
13113 13113 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
13248 13248 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
13591 13591 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
14114 14114 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
15015 15015 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
15021 15021 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
15485 15485 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
15486 15486 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
15489 15489 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
15490 15490 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
15491 15491 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
15492 15492 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
15495 15495 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
15496 15496 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
15497 15497 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
15608 15608 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
15721 15721 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
16075 16075 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])
);