FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
48 rows where Address_2 = "Suite 1600" sorted by Short_Form_Date
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 6
Registrant_Name 6
City 5
- New York 25
- Jacksonville 17
- Chicago 3
- Atlanta 2
- Los Angeles 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6032 | 6032 | 1966-02-03 | 1965-04-05 | Vander Zee | Rein John | Brown, Charles H. 1470 | 1961-08-03 | Brown, Charles H. | 10100 Santa Monica Boulevard | Suite 1600 | Los Angeles | CA | 90067 |
14531 | 14531 | 1982-04-30 | 1975-02-28 | Moody | Clarence Osment | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
26705 | 26705 | 1981-08-15 | 1975-02-28 | Hough | Barry Lee | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
34913 | 34913 | 1988-11-01 | 1975-02-28 | Boyle | Zoe Ann | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
36359 | 36359 | 1977-11-25 | 1975-02-28 | Kielley | Pamela | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
36468 | 36468 | 1977-11-27 | 1977-11-15 | Freeman | David | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
11123 | 11123 | 1979-03-30 | 1978-11-15 | Bohannon | Jo Ann | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
13784 | 13784 | 1980-04-20 | 1978-11-15 | Ludwig | Anita | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
32202 | 32202 | 1980-10-03 | 1978-11-15 | Overman | Glenn | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
34299 | 34299 | 1989-10-31 | 1978-11-15 | Smith | Nancy | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
34915 | 34915 | 1988-11-01 | 1980-05-12 | Haddad | Jeanne K. | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
34919 | 34919 | 1988-11-01 | 1980-12-16 | Schillig | Roger E. | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
36156 | 36156 | 1980-11-21 | 1980-12-16 | Heller | Stephen John | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
34293 | 34293 | 1989-10-31 | 1981-03-03 | Heller | Stephen John | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
28123 | 28123 | 1988-08-31 | 1981-06-08 | Peters | Carol Gay | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
32356 | 32356 | 1982-10-06 | 1982-03-26 | Rose | Patricia B. | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
11612 | 11612 | 1989-03-31 | 1988-11-01 | Ruiz | Antonio | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
34298 | 34298 | 1989-10-31 | 1988-11-01 | Hough | Barry | William Cook Agency, Inc. 2567 | 1975-03-28 | William Cook Agency, Inc. | 225 Water Street | Suite 1600 | Jacksonville | FL | 32202 |
27426 | 27426 | 1992-08-25 | 1990-11-05 | Cabrera | Carroll | Ruder Finn, Inc. 4430 | 1990-11-05 | Ruder Finn, Inc. | 444 North Michigan Avenue | Suite 1600 | Chicago | IL | 60611 |
27427 | 27427 | 1992-08-25 | 1990-11-05 | Leaf | Gregory D. | Ruder Finn, Inc. 4430 | 1990-11-05 | Ruder Finn, Inc. | 444 North Michigan Avenue | Suite 1600 | Chicago | IL | 60611 |
27428 | 27428 | 1992-08-25 | 1990-11-05 | Maloney | John | Ruder Finn, Inc. 4430 | 1990-11-05 | Ruder Finn, Inc. | 444 North Michigan Avenue | Suite 1600 | Chicago | IL | 60611 |
15102 | 15102 | 2018-04-30 | 2018-03-07 | Giostra | Lindsey Marie | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
18586 | 18586 | 2018-06-01 | 2018-03-07 | Patterson | Leslie | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
20592 | 20592 | 2018-06-29 | 2018-03-07 | Ermanni | Kayla | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
20593 | 20593 | 2018-06-29 | 2018-03-07 | Monday | Lincoln Cornell | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30563 | 30563 | 2018-09-26 | 2018-03-07 | Field | Alexander | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30564 | 30564 | 2018-09-26 | 2018-03-07 | McDonald | Andrew | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30565 | 30565 | 2018-09-26 | 2018-03-07 | Mueller | Stephanie Chapman | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30566 | 30566 | 2018-09-26 | 2018-03-07 | Susman | Shantha Laura | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30567 | 30567 | 2018-09-26 | 2018-04-02 | Scott | Haley | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30568 | 30568 | 2018-09-26 | 2018-04-02 | Toscano | Nicholas | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30569 | 30569 | 2018-09-26 | 2018-04-03 | Navarro-McKay | Alex | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30570 | 30570 | 2018-09-26 | 2018-04-20 | Kauzlarich | Nicholas | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30571 | 30571 | 2018-09-26 | 2018-05-15 | Chen | Amy | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30572 | 30572 | 2018-09-26 | 2018-05-22 | Beyersdorf | Mark | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30573 | 30573 | 2018-09-26 | 2018-06-07 | Schwartz | Laurel | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30574 | 30574 | 2018-09-26 | 2018-07-03 | Blenner | Michael | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30575 | 30575 | 2018-09-26 | 2018-07-10 | Rose | Rebecca | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
30576 | 30576 | 2018-09-26 | 2018-07-20 | Lebowitz | Amy | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
15261 | 15261 | 2021-04-30 | 2018-10-15 | Satcher | Daraka | Freeman Mathis Decisions 6600 | 2018-10-15 | Freeman Mathis Decisions | 100 Galleria Parkway | Suite 1600 | Atlanta | GA | 30339 |
6260 | 6260 | 2020-02-06 | 2020-02-06 | Borg | Christina | BerlinRosen, Ltd. 6791 | 2020-02-06 | BerlinRosen, Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
6261 | 6261 | 2020-02-06 | 2020-02-06 | Brandon | Laura | BerlinRosen, Ltd. 6791 | 2020-02-06 | BerlinRosen, Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
6262 | 6262 | 2020-02-06 | 2020-02-06 | Cadambi | Anjali | BerlinRosen, Ltd. 6791 | 2020-02-06 | BerlinRosen, Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
6263 | 6263 | 2020-02-06 | 2020-02-06 | Massey | Daniel | BerlinRosen, Ltd. 6791 | 2020-02-06 | BerlinRosen, Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
6264 | 6264 | 2020-02-06 | 2020-02-06 | McDonough | Alejandra Manuela | BerlinRosen, Ltd. 6791 | 2020-02-06 | BerlinRosen, Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
6265 | 6265 | 2020-02-06 | 2020-02-06 | Mehta | Shreema | BerlinRosen, Ltd. 6791 | 2020-02-06 | BerlinRosen, Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
6266 | 6266 | 2020-02-06 | 2020-02-06 | PiSierra | Zoe | BerlinRosen, Ltd. 6791 | 2020-02-06 | BerlinRosen, Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
1105 | 1105 | 2021-05-25 | Riordan | Sandy | Freeman Mathis Decisions 6600 | 2018-10-15 | Freeman Mathis Decisions | 100 Galleria Parkway | Suite 1600 | Atlanta | GA | 30339 |
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]) );