FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
42 rows where "Short_Form_Termination_Date" is on date 1985-09-26 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30494 | 30494 | 1985-09-26 | 1978-01-04 | Duome | Joseph J. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30495 | 30495 | 1985-09-26 | 1978-01-30 | Cromer | Harry | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30496 | 30496 | 1985-09-26 | 1978-01-30 | McDonald | Jack H. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30497 | 30497 | 1985-09-26 | 1978-01-30 | McDonald | James P. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30498 | 30498 | 1985-09-26 | 1978-02-07 | Gillespie | Rodger W. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30499 | 30499 | 1985-09-26 | 1978-02-14 | Wakeman | Robin E. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30500 | 30500 | 1985-09-26 | 1972-02-18 | McMennamin | G. Barry | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30501 | 30501 | 1985-09-26 | 1972-02-18 | Truesdell | Wesley E. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30502 | 30502 | 1985-09-26 | 1978-03-01 | Shane | Corinne | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30503 | 30503 | 1985-09-26 | 1985-03-12 | Goodfader | Alan L. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30504 | 30504 | 1985-09-26 | 1977-03-24 | Allen | Patricia | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30505 | 30505 | 1985-09-26 | 1977-03-24 | Bardsley | Joseph F. , Jr. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30506 | 30506 | 1985-09-26 | 1977-03-24 | Fitzgerald | Gerald L. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30507 | 30507 | 1985-09-26 | 1977-03-24 | Gialleonardo | Victor | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30508 | 30508 | 1985-09-26 | 1977-03-24 | Guinther | Fred E. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30509 | 30509 | 1985-09-26 | 1977-03-24 | Nunzio | Paula Del | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30510 | 30510 | 1985-09-26 | 1978-03-27 | Wiener | Walter F. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30511 | 30511 | 1985-09-26 | 1976-03-29 | Carlin | James J. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30512 | 30512 | 1985-09-26 | 1975-04-11 | Carroll | James P. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30513 | 30513 | 1985-09-26 | 1975-04-11 | Schaffer | Franklin E. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30514 | 30514 | 1985-09-26 | 1975-04-18 | Henry | John C. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30515 | 30515 | 1985-09-26 | 1977-04-18 | Sheils | Marylou | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30516 | 30516 | 1985-09-26 | 1981-04-29 | Pomerantz | Joel | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30517 | 30517 | 1985-09-26 | 1982-05-15 | Pitman | Theodore B. , Jr. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30518 | 30518 | 1985-09-26 | 1981-05-21 | Dekker | J. J. | 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 | |
30519 | 30519 | 1985-09-26 | 1981-05-21 | van Steenbergen | J. J. | 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 | |
30520 | 30520 | 1985-09-26 | 1974-06-03 | Kata | Stanley H. | LKP International, Ltd. 2514 | 1974-06-03 | LKP International, Ltd. | 767 Fifth Avenue | New York | NY | 10152 | |
30521 | 30521 | 1985-09-26 | 1974-06-03 | Silverstein | Lawrence | LKP International, Ltd. 2514 | 1974-06-03 | LKP International, Ltd. | 767 Fifth Avenue | New York | NY | 10152 | |
30522 | 30522 | 1985-09-26 | 1974-06-03 | Tipton | Judith O. | LKP International, Ltd. 2514 | 1974-06-03 | LKP International, Ltd. | 767 Fifth Avenue | New York | NY | 10152 | |
30523 | 30523 | 1985-09-26 | 1978-07-11 | Monfort | Don L. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30524 | 30524 | 1985-09-26 | 1978-07-11 | Pratt | David Thomas | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30525 | 30525 | 1985-09-26 | 1976-07-12 | Ekren | Parker | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30526 | 30526 | 1985-09-26 | 1976-07-23 | Collier | Norma J. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30527 | 30527 | 1985-09-26 | 1976-07-23 | Salvaryn | Dennis Lee | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30528 | 30528 | 1985-09-26 | 1982-07-26 | Martin | Yolanda C. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30529 | 30529 | 1985-09-26 | 1976-09-15 | O'Connell | John W. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30530 | 30530 | 1985-09-26 | 1974-09-19 | Quinby | Alan R. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30531 | 30531 | 1985-09-26 | 1984-10-02 | Trujillo | Tony Albert , Jr. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30532 | 30532 | 1985-09-26 | 1978-10-20 | Howells | Elizabeth J. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30533 | 30533 | 1985-09-26 | 1980-12-16 | Gordon | Arnold B. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30534 | 30534 | 1985-09-26 | 1981-12-28 | Melk | Ron | LKP International, Ltd. 2514 | 1974-06-03 | LKP International, Ltd. | 767 Fifth Avenue | New York | NY | 10152 | |
30535 | 30535 | 1985-09-26 | 1981-12-28 | Spino | Louis R. | LKP International, Ltd. 2514 | 1974-06-03 | LKP International, Ltd. | 767 Fifth Avenue | New York | NY | 10152 |
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]) );