FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
70 rows where Registration_Number = 2740
This data as json, CSV (advanced)
State 1
- NY 54
Registration_Number 1
- Hill & Knowlton, Inc. · 54 ✖
Registrant_Name 1
City 1
- New York 54
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29713 | 29713 | 1984-09-14 | 1982-01-28 | Murphy | Martha | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
29714 | 29714 | 1984-09-14 | 1979-02-22 | Claes | Michael | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33363 | 33363 | 1986-10-22 | 1984-01-03 | Goldberg | Albert N. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33364 | 33364 | 1986-10-22 | 1984-01-03 | Hartwig | Myron A. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33365 | 33365 | 1986-10-22 | 1984-01-03 | Zingman | Ben | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33366 | 33366 | 1986-10-22 | 1984-01-06 | Gregory | Chellis O. , Jr. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33367 | 33367 | 1986-10-22 | 1986-01-09 | Smith | Herbert J. , III | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33368 | 33368 | 1986-10-22 | 1982-01-28 | Chancellor | Andrew | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33369 | 33369 | 1986-10-22 | 1982-01-28 | Durante | Sheila | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33370 | 33370 | 1986-10-22 | 1982-01-28 | Resnick | Mayer | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33371 | 33371 | 1986-10-22 | 1982-01-28 | Wattel | Jerome V. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33372 | 33372 | 1986-10-22 | 1983-02-24 | Grayson | Mark E. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33373 | 33373 | 1986-10-22 | 1983-02-24 | Narsavage | David A. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33374 | 33374 | 1986-10-22 | 1981-03-05 | Lindenmann | Walter K. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33375 | 33375 | 1986-10-22 | 1981-03-05 | Nasatir | Eugene David | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33376 | 33376 | 1986-10-22 | 1981-03-05 | Reinle | Elizabeth Blair | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33377 | 33377 | 1986-10-22 | 1981-03-05 | Sporborg | Alison Lapetina | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33379 | 33379 | 1986-10-22 | 1984-04-13 | Colon | William | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33380 | 33380 | 1986-10-22 | 1984-04-13 | McCarthy | Mary Sue | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33381 | 33381 | 1986-10-22 | 1984-05-14 | McCabe | Ian | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33382 | 33382 | 1986-10-22 | 1984-05-25 | Ferri | James | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33383 | 33383 | 1986-10-22 | 1979-06-12 | Worth | Steven Merrow | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33384 | 33384 | 1986-10-22 | 1977-07-08 | Houriet | Jean Bernard | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33386 | 33386 | 1986-10-22 | 1982-07-23 | Moriber | Jeffrey M. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33387 | 33387 | 1986-10-22 | 1978-08-03 | Kelly | Jean Parker | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33388 | 33388 | 1986-10-22 | 1978-08-03 | Reed | William E. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33389 | 33389 | 1986-10-22 | 1986-08-11 | McElheny | Richard | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33390 | 33390 | 1986-10-22 | 1986-08-11 | Murphy | Daniel J. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33391 | 33391 | 1986-10-22 | 1980-08-20 | Berger | Frederick G. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33392 | 33392 | 1986-10-22 | 1980-08-20 | Glazer | George | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33393 | 33393 | 1986-10-22 | 1980-08-20 | McDonnell | Joyce Martin | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33394 | 33394 | 1986-10-22 | 1980-08-20 | Winks | Donald | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33395 | 33395 | 1986-10-22 | 1986-09-15 | Fix | Donald J. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33396 | 33396 | 1986-10-22 | 1986-09-15 | Massey | Donald F. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33397 | 33397 | 1986-10-22 | 1986-09-19 | O'Sullivan | David | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33398 | 33398 | 1986-10-22 | 1986-09-19 | Smith | Alan | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33399 | 33399 | 1986-10-22 | 1986-09-24 | O'Neil | Joseph | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33400 | 33400 | 1986-10-22 | 1978-10-11 | Dresden | Anthony V. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33401 | 33401 | 1986-10-22 | 1984-10-12 | Johnson | Helen A. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33402 | 33402 | 1986-10-22 | 1984-10-12 | Strong | Barbara | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33403 | 33403 | 1986-10-22 | 1986-11-03 | Hymel | Gary | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33404 | 33404 | 1986-10-22 | 1978-11-07 | Reinsberg | John | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33405 | 33405 | 1986-10-22 | 1982-11-29 | Hayes | Julian L. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33406 | 33406 | 1986-10-22 | 1983-12-02 | Olson | Martha | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33407 | 33407 | 1986-10-22 | 1976-12-17 | Billing | Terence | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33408 | 33408 | 1986-10-22 | 1976-12-17 | Velmans | Loet A. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33409 | 33409 | 1986-10-22 | 1977-12-21 | Hein | Steven M. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33410 | 33410 | 1986-10-22 | 1982-12-30 | Flint | Jane H. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33411 | 33411 | 1986-10-22 | 1982-12-30 | Moran | Michael J. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33412 | 33412 | 1986-10-22 | 1982-12-30 | Smith | Edmond C. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33413 | 33413 | 1986-10-22 | 1982-12-30 | Sonnenfeldt | Marjorie H. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
33414 | 33414 | 1986-10-22 | 1982-12-30 | Worden | George M. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
34252 | 34252 | 1984-10-31 | 1983-12-02 | Boland | John | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 | |
40207 | 40207 | 1981-12-31 | 1979-11-23 | Puzzo | Charles J. | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | 420 Lexington Avenue | New York | NY | 10017 |
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]) );