FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
80 rows where Short_Form_First_Name = "Jonathan" sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date), Registration_Date (date)
Registration_Number >30
- Daniel J. Edelman, Inc. 4
- Singapore Economic Development Board 3
- White & Case, LLP 3
- Hill and Knowlton Strategies, LLC 3
- Quebec Government Office 2
- Bahamas Tourist Office 2
- APCO Worldwide, Inc. 2
- QORVIS LLC 2
- FGS Global (US) LLC (FKA FGH Holdings LLC) 2
- Ogilvy Public Relations Worldwide 2
- Baron Public Affairs, LLC 2
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- VisitBritain 1
- Netherlands Board of Tourism and Conventions (NBTC) 1
- Arnold & Porter Kaye Scholer LLP 1
- FCB New York 1
- New Zealand Milk Products, Inc. 1
- Enterprise Ireland 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Arent Fox Kintner Plotkin & Kahn, PLLC 1
- DWJ Associates, Inc. 1
- Weil, Gotshal & Manges, L.L.P. 1
- Kaplan, Russin & Vecchi 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Biederman & Company, Inc. 1
- Black, Kelly, Scruggs & Healey 1
- Daniel J. Edelman, Inc. 1
- Tourism Queensland 1
- Morrison & Foerster 1
- Capital International Information Services, Inc. 1
- …
Registrant_Name >30
- Daniel J. Edelman, Inc. 5
- APCO Worldwide, Inc. 3
- Hill and Knowlton Strategies, LLC 3
- MWW Group 3
- Singapore Economic Development Board 3
- White & Case, LLP 3
- Bahamas Tourist Office 2
- Baron Public Affairs, LLC 2
- FGS Global (US) LLC (FKA FGH Holdings LLC) 2
- Ogilvy Public Relations Worldwide 2
- QORVIS LLC 2
- Quebec Government Office 2
- APCO Worldwide LLC 1
- Abernathy/MacGregor Group, Inc. 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Arent Fox Kintner Plotkin & Kahn, PLLC 1
- Arnold & Porter Kaye Scholer LLP 1
- BGR Government Affairs, LLC 1
- Biederman & Company, Inc. 1
- Black, Kelly, Scruggs & Healey 1
- BlackBear Communications 1
- Boston Consulting Group International, Inc. 1
- Capital International Information Services, Inc. 1
- Conover + Gould Strategic Communications, Inc. 1
- Covington & Burling LLP 1
- Covington & Burling, LLP 1
- DWJ Associates, Inc. 1
- Daimler-Benz Washington, Inc. 1
- Davidoff Hutcher & Citron, LLP 1
- Enterprise Ireland 1
- …
City 14
- Washington 39
- New York 26
- St. Louis 3
- Nassau 2
- Bethesda 1
- Boston 1
- Chicago 1
- London 1
- Los Angeles 1
- New Haven 1
- Overland Park 1
- Petaluma 1
- Seattle 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29828 | 29828 | 1986-09-15 | 1986-07-28 | Holasek | Jonathan | Biederman & Company, Inc. 3540 | 1983-12-06 | Biederman & Company, Inc. | 100 Fifth Avenue | 4th Floor | New York | NY | 10011 |
38059 | 38059 | 2005-12-10 | 2000-10-10 | Spitz | Jonathan | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
8880 | 8880 | 2010-03-01 | 2010-01-11 | Eva | Jonathan | Fenton Communications 5945 | 2009-06-26 | Fenton Communications | 1010 Vermont Avenue, NW | Suite 1100 | Washington | DC | 20005 |
1793 | 1793 | 2022-09-15 | Sadlier | Jonathan | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 | |
23688 | 23688 | 2016-07-20 | 2013-10-18 | Kopp | Jonathan | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
5070 | 5070 | 1991-01-31 | 1989-03-22 | Miller | Jonathan | Arent Fox Kintner Plotkin & Kahn, PLLC 2661 | 1976-02-18 | Arent Fox Kintner Plotkin & Kahn, PLLC | 1050 Connecticut Ave., NW #500 | Washington | DC | 20036-5339 | |
8593 | 8593 | 2020-02-29 | 2019-09-17 | Lee | Jonathan | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
5991 | 5991 | 2007-02-02 | 2006-01-30 | Capehart | Jonathan | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
23010 | 23010 | 1991-07-12 | 1990-05-23 | Harris | Jonathan | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
38416 | 38416 | 2004-12-15 | 2004-06-10 | Drobis | Jonathan | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 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 |
24225 | 24225 | 2007-07-27 | 2007-05-07 | Mairs | Jonathan | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
15853 | 15853 | 2004-05-07 | 2003-06-03 | Clark | Jonathan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32014 | 32014 | 2006-10-01 | 2003-12-02 | Hamilton | Jonathan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32020 | 32020 | 2006-10-01 | 2005-12-07 | Kass | Jonathan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
25381 | 25381 | 2020-07-31 | 2019-04-30 | Warschawski | Jonathan | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
35043 | 35043 | 2019-11-01 | 2018-07-25 | Ewing | Jonathan | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
37969 | 37969 | 1987-12-09 | 1982-07-20 | Russin | Jonathan | Kaplan, Russin & Vecchi 3368 | 1982-05-10 | Kaplan, Russin & Vecchi | 1215 - 17th Street, N.W. | Washington | DC | 20036 | |
1843 | 1843 | 2013-09-25 | Leibowitz | Jonathan | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | 122 East 42nd Street | Suite 2005 | New York | NY | 10168 | |
4537 | 4537 | 1989-01-26 | 1986-07-23 | Lloyd | Jonathan | New Zealand Milk Products, Inc. 2463 | 1973-10-01 | New Zealand Milk Products, Inc. | 1269 North McDowell Boulevard | Petaluma | CA | 94952 | |
17524 | 17524 | 2015-05-30 | 2015-04-28 | Gregory | Jonathan | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
7026 | 7026 | 2020-02-15 | 2018-10-26 | Solomon | Jonathan | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
40807 | 40807 | 1995-12-31 | 1996-01-05 | Atkin | Jonathan | Daimler-Benz Washington, Inc. 4485 | 1991-03-14 | Daimler-Benz Washington, Inc. | 1350 I Street, N.W. | Suite 800 | Washington | DC | 20005-3305 |
9237 | 9237 | 1995-03-06 | 1993-05-13 | Potter | Jonathan | Weil, Gotshal & Manges, L.L.P. 3317 | 1981-12-29 | Weil, Gotshal & Manges, L.L.P. | 1615 L Street, N.W. | Suite 700 | Washington | DC | 20036 |
8474 | 8474 | 2000-02-29 | 1999-02-08 | Blank | Jonathan | Preston Gates Ellis & Rouvelas Meeds, LLP 5300 | 1999-02-08 | Preston Gates Ellis & Rouvelas Meeds, LLP | 1735 New York Avenue, N.W. | Suite 500 | Washington | DC | 20006 |
24903 | 24903 | 1998-07-31 | 1998-01-16 | Slade | Jonathan | MWW Group 5230 | 1998-01-16 | MWW Group | 1747 Pennsylvania Avenue | Suite 1150 | Washington | DC | 20036 |
34466 | 34466 | 2002-10-31 | 2000-11-02 | Slade | Jonathan | MWW Group 5389 | 2000-10-03 | MWW Group | 1747 Pennsylvania Avenue, N.W. | Suite 1150 | Washington | DC | 20006 |
41146 | 41146 | 1999-12-31 | 1999-06-29 | Slade | Jonathan | MWW Group 5353 | 1999-06-29 | MWW Group | 1747 Pennsylvania Avenue, N.W. | Suite 1150 | Washington | DC | 20006 |
23122 | 23122 | 1994-07-14 | 1986-03-11 | Keyserling | Jonathan | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | 1801 K Street, N.W. | Suite 901-L | Washington | DC | 20006 |
23034 | 23034 | 2020-07-12 | 2019-07-12 | Hawker | Jonathan | FTI Consulting LLP 6569 | 2018-07-09 | FTI Consulting LLP | 200 Aldersgate, Aldersgate Street | London | |||
25389 | 25389 | 2020-07-31 | 2019-10-03 | Hendl | Jonathan | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
27815 | 27815 | 2012-08-30 | 2012-11-29 | Struthers | Jonathan | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
26408 | 26408 | 2020-08-10 | 2020-08-10 | Croog | Jonathan | Boston Consulting Group International, Inc. 6851 | 2020-08-10 | Boston Consulting Group International, Inc. | 200 Pier 4 Boulevard | Boston | MA | 02210 | |
8045 | 8045 | 1996-02-28 | 1991-02-12 | Band | Jonathan | Capital International Information Services, Inc. 4472 | 1991-02-12 | Capital International Information Services, Inc. | 2000 Pennsylvania Avenue, N.W. | Suite 5500 | Washington | DC | 20006 |
28165 | 28165 | 1990-08-31 | 1989-08-23 | Band | Jonathan | Morrison & Foerster 4282 | 1989-08-23 | Morrison & Foerster | 2000 Pennsylvania Avenue, N.W. | Suite 5500 | Washington | DC | 20006 |
42352 | 42352 | 2020-12-31 | 2017-11-16 | Poling | Jonathan | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
31592 | 31592 | 2016-09-30 | 2016-04-02 | Harsch | Jonathan | Witt Global Partners, LLC 6348 | 2016-04-02 | Witt Global Partners, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
27237 | 27237 | 2018-08-22 | 2018-02-02 | Stember | Jonathan | Gunster Strategies Worldwide, Inc. 6520 | 2018-02-02 | Gunster Strategies Worldwide, Inc. | 2121 K Street, NW | #850 | Washington | DC | 20037 |
20394 | 20394 | 2003-06-27 | 2003-02-13 | Solomons | Jonathan | Netherlands Board of Tourism and Conventions (NBTC) 619 | 1950-03-20 | Netherlands Board of Tourism and Conventions (NBTC) | 215 Park Avenue South | Suite 1302 | New York | NY | 10003 |
28536 | 28536 | 2009-08-31 | 2008-04-22 | Woods | Jonathan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31436 | 31436 | 2009-09-30 | 2009-03-19 | Robinson | Jonathan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31440 | 31440 | 2009-09-30 | 2008-04-22 | Adashek | Jonathan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31459 | 31459 | 2009-09-30 | 2009-05-07 | Netek | Jonathan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
3005 | 3005 | 2019-01-01 | 2018-04-24 | Sabol | Jonathan | Tusk Ventures LLC 6543 | 2018-04-24 | Tusk Ventures LLC | 251 Park Avenue South | 8th Floor | New York | NY | 10010 |
1058 | 1058 | 2021-05-19 | Freiman | Jonathan | Wiggin and Dana LLP 6878 | 2020-10-14 | Wiggin and Dana LLP | 265 Church Street | One Century Tower | New Haven | CT | 06510 | |
30193 | 30193 | 1987-09-21 | 1978-08-18 | Braun | Jonathan | DWJ Associates, Inc. 2947 | 1978-08-18 | DWJ Associates, Inc. | 295 Madison Avenue | New York | NY | 10017 | |
12573 | 12573 | 2016-04-01 | 2015-06-02 | Lowe | Jonathan | Finsbury, LLC 6293 | 2015-05-12 | Finsbury, LLC | 3 Columbus Circle, Floor 9 | New York | NY | 10019 | |
536 | 536 | 2021-03-09 | Jackson | Jonathan | Williams Group 6790 | 2020-02-06 | Williams Group | 302 3rd Street, SE | Washington | DC | 20003 | ||
2745 | 2745 | 1996-01-01 | 1991-03-19 | Rinehart | Jonathan | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | 309 West 49th Street | Worldwide Plaza | New York | NY | 10019-7399 |
9856 | 9856 | 2016-03-14 | 2014-09-05 | Soohoo | Jonathan | Conover + Gould Strategic Communications, Inc. 6205 | 2014-01-21 | Conover + Gould Strategic Communications, Inc. | 3520 Connecticut Avenue, NW | #41 | Washington | DC | 20008 |
31186 | 31186 | 1997-09-30 | 1992-12-11 | Smith | Jonathan | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | 501 Madison Avenue | Suite 1300 | New York | NY | 10022 |
8226 | 8226 | 2007-02-28 | 2004-12-22 | Kua | Jonathan | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
25057 | 25057 | 2005-07-31 | 2003-01-10 | Lim | Jonathan | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
33070 | 33070 | 1994-10-17 | 1984-04-09 | Yuen | Jonathan | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
23442 | 23442 | 2020-07-17 | 2019-08-29 | Bench | Jonathan | Harris Bricken Sliwoski LLP 6712 | 2019-08-29 | Harris Bricken Sliwoski LLP | 600 Stewart Street | Suite 1200 | Seattle | WA | 98101 |
19129 | 19129 | 2021-06-09 | 2020-12-20 | Gregory | Jonathan | Yorktown Solutions, LLC 6491 | 2017-11-19 | Yorktown Solutions, LLC | 601 13th Street, NW | Suite 900 South | Washington | DC | 20005 |
33717 | 33717 | 1995-10-27 | 1991-04-23 | Ratner | Jonathan | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
37094 | 37094 | 2017-11-30 | 2012-10-01 | Mantz | Jonathan | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 601 Thirteenth Street, NW | Eleventh Floor South | Washington | DC | 20005 |
37054 | 37054 | 2014-11-30 | 2013-05-13 | McCollum | Jonathan | Davidoff Hutcher & Citron, LLP 6169 | 2013-05-13 | Davidoff Hutcher & Citron, LLP | 605 Third Avenue | 34th Floor | New York | NY | 10158 |
21611 | 21611 | 2008-06-30 | 1996-08-22 | Day | Jonathan | Tourism Queensland 4146 | 1988-05-31 | Tourism Queensland | 6100 Center Drive | Suite 1150 | Los Angeles | CA | 90045 |
36497 | 36497 | 2019-11-27 | 2019-08-19 | Kimsey | Jonathan | LGND, LLC 6570 | 2018-07-10 | LGND, LLC | 6701 Democracy Blvd | Suite 300 | Bethesda | MD | 20817 |
41781 | 41781 | 2011-12-31 | 2009-08-14 | Winer | Jonathan | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41794 | 41794 | 2011-12-31 | 2011-10-25 | Gregory | Jonathan | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
32032 | 32032 | 2009-10-01 | 2009-09-24 | Stember | Jonathan | BlackBear Communications 5952 | 2009-09-24 | BlackBear Communications | 701 8th Street, NW | Suite 400 | Washington | DC | 20001 |
25384 | 25384 | 2020-07-31 | 2019-05-22 | Hernandez | Jonathan | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
25295 | 25295 | 2017-07-31 | 2017-04-16 | Baron | Jonathan | Baron Public Affairs, LLC 6418 | 2017-04-16 | Baron Public Affairs, LLC | 7777 Bonhomme Avenue | Suite 1800 | St. Louis | MO | 63105 |
25296 | 25296 | 2017-07-31 | 2017-04-16 | Fluger | Jonathan | Baron Public Affairs, LLC 6418 | 2017-04-16 | Baron Public Affairs, LLC | 7777 Bonhomme Avenue | Suite 1800 | St. Louis | MO | 63105 |
123 | 123 | 2023-01-13 | Slade | Jonathan | The Cormac Group LLC 7219 | 2023-01-13 | The Cormac Group LLC | 800 Connecticut Avenue NW, Suite 300 | Washington | DC | 20006 | ||
1899 | 1899 | 2022-10-05 | Lowy | Jonathan | Global Action on Gun Violence (GAGV) Inc. 7175 | 2022-10-05 | Global Action on Gun Violence (GAGV) Inc. | 805 15th Street NW | #601 | Washington | DC | 20005 | |
1187 | 1187 | 2022-06-03 | Gimblett | Jonathan | Covington & Burling LLP 6876 | 2020-10-13 | Covington & Burling LLP | 850 10th Street | Washington | DC | 20001 | ||
41892 | 41892 | 2013-12-31 | 2012-11-15 | Wakely | Jonathan | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
963 | 963 | 2021-05-05 | Heasman | Jonathan | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 | |
28479 | 28479 | 2006-08-31 | 2003-08-20 | Howe | Jonathan | Zuckert, Scoutt & Rasenberger, L.L.P. 4933 | 1994-08-01 | Zuckert, Scoutt & Rasenberger, L.L.P. | 888 - 17th Street, N.W. | Suite 700 | Washington | DC | 20006-3309 |
26771 | 26771 | 2006-08-15 | 2006-04-05 | Sumrell | Jonathan | Harff Communications Incorporated 5744 | 2006-04-05 | Harff Communications Incorporated | 901 15th Street, NW | Suite 250 | Washington | DC | 20005 |
31362 | 31362 | 2006-09-30 | 2006-06-09 | Loughran | Jonathan | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
517 | 517 | 2021-03-06 | Lord | Jonathan | Bahamas Tourist Office 2310 | 1972-01-27 | Bahamas Tourist Office | Ministry of Tourism | Post Office Box N-3701 | Nassau | |||
2216 | 2216 | 2022-11-22 | Lockhart | Jonathan | Bahamas Tourist Office 2310 | 1972-01-27 | Bahamas Tourist Office | Ministry of Tourism | Post Office Box N-3701 | Nassau | |||
14173 | 14173 | 1966-04-27 | 1964-05-18 | Eldridge | Jonathan | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
18100 | 18100 | 2013-05-31 | 2006-02-15 | Becker | Jonathan | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
24105 | 24105 | 2000-07-26 | 2000-03-07 | Huneke | Jonathan | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );