FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
136 rows where City = "New York" and Registrant_Name = "Government of Ontario, Canada" sorted by rowid descending
This data as json, CSV (advanced)
State 1
- NY 36
Registration_Number 1
Registrant_Name 1
- Government of Ontario, Canada · 36 ✖
City 1
- New York · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16110 | 16110 | 1989-05-12 | 1981-04-23 | Smith | Terri Lynn | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
16108 | 16108 | 1989-05-12 | 1983-04-19 | Geppert | John G. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
16107 | 16107 | 1989-05-12 | 1971-04-16 | Sweetlove | Norman J. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
16106 | 16106 | 1989-05-12 | 1968-04-11 | Mitchell | Robert Alexander | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
16105 | 16105 | 1989-05-12 | 1984-03-27 | Ritchie | Donald Gordon | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
16103 | 16103 | 1989-05-12 | 1983-03-02 | Rotenberg | Meta | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
16102 | 16102 | 1989-05-12 | 1983-03-02 | Purchase | Bryne B. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
16100 | 16100 | 1989-05-12 | 1985-01-31 | Vita-Finzi | Ennio | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
16099 | 16099 | 1989-05-12 | 1972-01-11 | Clark | Bowcher Theodore Senhouse | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
15312 | 15312 | 1968-05-01 | 1968-04-11 | Hassell | Lloyd A. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
14611 | 14611 | 1990-04-30 | 1984-11-13 | MacDonald | Susan J. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
14499 | 14499 | 1974-04-30 | 1969-11-10 | Bolan | John Francis | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
14462 | 14462 | 1968-04-30 | 1968-04-11 | Denton | John Paul | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
12452 | 12452 | 1985-04-01 | 1980-07-22 | Dombroski | James S. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
12451 | 12451 | 1985-04-01 | 1982-04-30 | Oxley | Jack L. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
12435 | 12435 | 1982-04-01 | 1980-10-31 | MacDonald | Susan J. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11649 | 11649 | 1991-03-31 | 1985-10-03 | Hopkinson | John | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11643 | 11643 | 1991-03-31 | 1985-07-19 | Gray | James H. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11571 | 11571 | 1987-03-31 | 1983-10-06 | Dunlap | John G. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11521 | 11521 | 1982-03-31 | 1979-12-27 | Crowell | Albert Warren | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11513 | 11513 | 1982-03-31 | 1980-07-22 | Wozencraft | William E. , Jr. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11512 | 11512 | 1982-03-31 | 1980-07-22 | Fedor | Judith K. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11511 | 11511 | 1982-03-31 | 1977-05-24 | Fitschen | John David | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11156 | 11156 | 1990-03-30 | 1988-12-12 | Mansdorf | Arnold David | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
11140 | 11140 | 1990-03-30 | 1984-03-27 | Counsell | D'Arcy Robinette | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
8779 | 8779 | 1990-03-01 | 1985-11-18 | Benfield | Desmond | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
7957 | 7957 | 1990-02-28 | 1988-05-16 | Stothers | Walter | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
7897 | 7897 | 1982-02-28 | 1981-04-23 | Morgan | Hilary A. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
6716 | 6716 | 1970-02-13 | 1968-04-11 | Holloway | G. N. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
5072 | 5072 | 1991-01-31 | 1980-05-19 | McCluskey | Eugene J. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
5055 | 5055 | 1990-01-31 | 1990-06-12 | Dickson | Catherine M. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
4931 | 4931 | 1971-01-31 | 1968-04-11 | Cranston | Lawrence MacLean | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
3404 | 3404 | 1982-01-08 | 1980-10-31 | Newman | David | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
3279 | 3279 | 1992-01-06 | 1990-05-11 | Long | Walter G. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
2619 | 2619 | 1984-01-01 | 1983-03-02 | Callaghan | Beth | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
2594 | 2594 | 1981-01-01 | 1980-10-31 | Plant | Paul David | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
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]) );