FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
413 rows where "Registration_Date" is on date 1977-03-09, Registration_Number = 2759 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date)
State 1
- NY · 413 ✖
Registration_Number 1
- White & Case, LLP · 413 ✖
Registrant_Name 1
City 1
- New York 413
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2663 | 2663 | 1988-01-01 | 1977-03-09 | Fales | Haliburton , II | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
2714 | 2714 | 1992-01-01 | 1980-03-28 | Hopkins | Thomas A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
2747 | 2747 | 1996-01-01 | 1980-04-16 | Barist | Jeffrey | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
2784 | 2784 | 1999-01-01 | 1980-01-21 | Madden | Donald P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
2803 | 2803 | 2002-01-01 | 1989-04-07 | Grodin | Jay Howard | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3246 | 3246 | 2007-01-05 | 2004-04-16 | Martinez | Lucy | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3365 | 3365 | 1994-01-07 | 1983-10-07 | Jump | Alice | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3405 | 3405 | 1988-01-08 | 1980-04-16 | Buck | Bruce M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3522 | 3522 | 1986-01-10 | 1983-04-08 | Neckles | Peter J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3666 | 3666 | 1995-01-13 | 1990-10-10 | Redfern | William A. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3776 | 3776 | 1981-01-15 | 1980-03-28 | Sollis | Todd B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3781 | 3781 | 1984-01-15 | 1977-03-09 | Brower | Charles N. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3783 | 3783 | 1985-01-15 | 1980-03-28 | Pinkham | Francis H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3970 | 3970 | 1994-01-17 | 1986-04-09 | Hober | Kaj | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3985 | 3985 | 2010-01-17 | 2006-05-31 | Al-Louzi | Sami | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4025 | 4025 | 1988-01-18 | 1984-09-18 | Rose | Joanne W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4111 | 4111 | 2007-01-19 | 2005-12-07 | Al-Sudairi | Salman | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4112 | 4112 | 2007-01-19 | 2005-12-07 | Levine | Judith | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4222 | 4222 | 1994-01-21 | 1992-04-09 | Foster | Eric L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4466 | 4466 | 1990-01-25 | 1987-12-08 | Ambrose | Kathleen A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4518 | 4518 | 1986-01-26 | 1983-10-28 | Armour | Carolyn M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4620 | 4620 | 1984-01-27 | 1982-04-09 | Risenfeld | Kenneth B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4624 | 4624 | 1984-01-27 | 1981-10-13 | Bartolotta | Frank J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4749 | 4749 | 1988-01-29 | 1985-03-01 | Brizzi | Barbara C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4755 | 4755 | 1992-01-29 | 1990-04-09 | Wang | Danchi | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4813 | 4813 | 1982-01-30 | 1980-03-28 | Khoury | Kenneth F. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4994 | 4994 | 1984-01-31 | 1983-04-08 | Loo | Ernest J. T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5000 | 5000 | 1985-01-31 | 1984-04-09 | Chan | Jean S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5013 | 5013 | 1986-01-31 | 1983-10-07 | Cassidy | Kevin J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5040 | 5040 | 1989-01-31 | 1985-10-09 | Hackney | James V. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5094 | 5094 | 1991-01-31 | 1983-10-07 | Zeifer | F. Ellen | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5116 | 5116 | 1992-01-31 | 1987-10-13 | Kreindler | Richard H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5378 | 5378 | 2007-01-31 | 2003-06-03 | Weinacht | Felix | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5748 | 5748 | 1985-02-01 | 1984-09-18 | Shaffer | Stefan L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5967 | 5967 | 1985-02-02 | 1983-10-07 | Peisch | Christopher Lyons | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5990 | 5990 | 2006-02-02 | 2005-12-07 | Gay | Faith | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6170 | 6170 | 1982-02-05 | 1980-04-16 | Rohn | Frederick R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6223 | 6223 | 1981-02-06 | 1980-01-21 | Schmults | Edward C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6593 | 6593 | 2007-02-10 | 2005-07-20 | Crosby | Daniel C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6723 | 6723 | 1981-02-13 | 1980-01-21 | Kunz | Diane B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6840 | 6840 | 1996-02-14 | 1990-04-09 | Kaplan | David J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6859 | 6859 | 1996-02-14 | 1987-12-08 | Currier | G. William | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6940 | 6940 | 1985-02-15 | 1984-09-18 | Berger | Robert Glenn | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6941 | 6941 | 1985-02-15 | 1983-10-07 | Buley | John M. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6946 | 6946 | 1990-02-15 | 1988-10-07 | Boisseuain | Benjamin M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
7059 | 7059 | 1982-02-16 | 1981-10-13 | Kavanagh | J. Hayes | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
7292 | 7292 | 1987-02-20 | 1984-09-18 | Clarke | Jennifer R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
7388 | 7388 | 1995-02-22 | 1989-04-07 | Varanese | James B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
7437 | 7437 | 1982-02-23 | 1981-04-09 | Kaminer | Stevenson S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
7542 | 7542 | 1995-02-24 | 1990-04-09 | Haft | William S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8018 | 8018 | 1995-02-28 | 1984-04-09 | Sypher | Richard B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8019 | 8019 | 1995-02-28 | 1980-04-16 | Davis | Ronald W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8039 | 8039 | 1995-02-28 | 1983-10-07 | Bschorr | Paul J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8040 | 8040 | 1995-02-28 | 1985-10-09 | Badini | Aldo A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8075 | 8075 | 1997-02-28 | 1992-04-09 | Drumm | Gerard T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8454 | 8454 | 1984-02-29 | 1983-05-31 | Evler | Ewa Maria | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9028 | 9028 | 1989-03-03 | 1987-12-08 | Fiszer | George A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9066 | 9066 | 2006-03-03 | 2004-10-13 | Dickson | Natalie | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9114 | 9114 | 1982-03-04 | 1980-03-28 | Ascher | Mark L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9156 | 9156 | 1980-03-05 | 1980-01-21 | Gillespie | Thomas E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9161 | 9161 | 1986-03-05 | 1983-10-07 | Mullin | Monica H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9520 | 9520 | 1990-03-09 | 1988-10-07 | Seaver | Christopher B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9583 | 9583 | 2006-03-10 | 2005-04-14 | Yap | Justin | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9625 | 9625 | 1983-03-11 | 1978-04-10 | Steingold | Stuart G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9823 | 9823 | 1981-03-14 | 1980-03-28 | Knox | William C. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9829 | 9829 | 1988-03-14 | 1982-04-09 | Dodson | Mary Jane | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9837 | 9837 | 1995-03-14 | 1987-12-08 | Tavares | Helena M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10123 | 10123 | 1980-03-17 | 1980-01-21 | Berman | Helen A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10268 | 10268 | 2011-03-18 | 2008-10-31 | Delelle | Claire | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10503 | 10503 | 1982-03-22 | 1980-04-16 | Page | Patti R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10508 | 10508 | 1985-03-22 | 1982-04-09 | Hurst | Philip Allan Desmond | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10532 | 10532 | 2006-03-22 | 2005-12-07 | Zeidan | Isabelle | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10871 | 10871 | 1987-03-27 | 1980-03-28 | Sullivan | Jennifer A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10872 | 10872 | 1987-03-27 | 1983-04-08 | Young | Christopher N. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10873 | 10873 | 1987-03-27 | 1984-04-09 | Wilson | Craig Alan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11059 | 11059 | 1994-03-29 | 1992-04-09 | Bahlke | Conrad G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11067 | 11067 | 1996-03-29 | 1991-10-09 | Landon | Kimberley R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11141 | 11141 | 1990-03-30 | 1984-04-09 | Richardson | George O. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11150 | 11150 | 1990-03-30 | 1984-09-18 | Dunetz | Jeffrey L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11523 | 11523 | 1983-03-31 | 1980-01-21 | Paradise | David T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11572 | 11572 | 1987-03-31 | 1986-10-09 | Arango | Ricardo M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11717 | 11717 | 1995-03-31 | 1992-04-09 | Lee | Patricia Y. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11721 | 11721 | 1995-03-31 | 1992-06-17 | Gastinel | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11764 | 11764 | 1997-03-31 | 1980-03-28 | Patrick | Casimir C. , II | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11777 | 11777 | 1997-03-31 | 1988-10-07 | Perkins | James W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11961 | 11961 | 2006-03-31 | 1985-03-01 | Zettermarck | Claes G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11966 | 11966 | 2006-03-31 | 1980-03-28 | Boussard | Jean-Luc M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11968 | 11968 | 2006-03-31 | 1986-04-09 | Lillis | John T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11970 | 11970 | 2006-03-31 | 2005-04-14 | Katcherian | Amy L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11977 | 11977 | 2006-03-31 | 2006-05-31 | Eriksson | Andreas | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11978 | 11978 | 2006-03-31 | 2006-05-31 | Escuder | Jeffrey | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11979 | 11979 | 2006-03-31 | 2003-06-03 | Von Oppen | Matthias | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11980 | 11980 | 2006-03-31 | 1992-06-17 | Bond | Stephen R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11989 | 11989 | 2006-03-31 | 1984-09-18 | Hayden | James F. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11990 | 11990 | 2006-03-31 | 1988-10-07 | Alexander | Troy | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11991 | 11991 | 2006-03-31 | 1988-10-07 | Stillwaggon | James M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11992 | 11992 | 2006-03-31 | 1986-10-09 | DeSantis | Victor J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12004 | 12004 | 2006-03-31 | 2005-11-15 | Marx | Joseph | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12006 | 12006 | 2006-03-31 | 2003-12-02 | Le Corre | Jean-Francois | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12007 | 12007 | 2006-03-31 | 2005-12-07 | Johnsson | Bengt Ake | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 |
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]) );