FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
26 rows where City = "Montreal, Quebec" sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Address_1, Address_2, Short_Form_Date (date)
Registration_Number 5
Registration_Date 5 ✖
- 1942-08-25 16
- 1999-12-09 6
- 1992-07-17 2
- 1992-12-08 1
- 2007-01-10 1
Registrant_Name 5
State 1
- - 26
City 1
- Montreal, Quebec · 26 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27374 | 27374 | 1946-08-25 | 1942-08-25 | Cooper | Thomas Harold | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27375 | 27375 | 1946-08-25 | 1942-08-25 | Cowie | Charles Durno | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27376 | 27376 | 1946-08-25 | 1942-08-25 | Daly | Brenton Leo | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27377 | 27377 | 1946-08-25 | 1942-08-25 | Ford | David McKechnie | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27378 | 27378 | 1946-08-25 | 1942-08-25 | Fraser | Alistair | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27379 | 27379 | 1946-08-25 | 1942-08-25 | Gagnon | Wilfrid | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27380 | 27380 | 1946-08-25 | 1942-08-25 | Grant | Duncan Campbell | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27381 | 27381 | 1946-08-25 | 1942-08-25 | Hobbs | William Henry | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27382 | 27382 | 1946-08-25 | 1942-08-25 | Hungerford | Samuel James | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27383 | 27383 | 1946-08-25 | 1942-08-25 | Northey | James Alexander | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27384 | 27384 | 1946-08-25 | 1942-08-25 | Symington | Herbert James | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27385 | 27385 | 1946-08-25 | 1942-08-25 | Vaughan | Robert Charles | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27386 | 27386 | 1946-08-25 | 1942-08-25 | Walton | Norman Burdett | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27387 | 27387 | 1946-08-25 | 1942-08-25 | Young | Edward James | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
27388 | 27388 | 1946-08-25 | 1943-09-20 | Thompson | Walter Scott | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
34122 | 34122 | 1944-10-31 | 1942-08-25 | Read | Charles Herbert | Canadian National Railways 105 | 1942-08-25 | Canadian National Railways | 360 McGill Street | Montreal, Quebec | |||
34383 | 34383 | 1997-10-31 | 1998-03-02 | Church | David W. | McClay, Brian 4693 | 1992-07-17 | McClay, Brian | 1155 Metcalfe Street | Montreal, Quebec | |||
34397 | 34397 | 1997-10-31 | 1997-07-21 | Davis | Christopher | McClay, Brian 4693 | 1992-07-17 | McClay, Brian | 1155 Metcalfe Street | Montreal, Quebec | |||
36324 | 36324 | 1993-11-24 | 1992-12-08 | Salehabadi | Amelia | Nolisair International, Inc. 4737 | 1992-12-08 | Nolisair International, Inc. | C/O Richter & Associates, Inc. | 2 Place Alexis-Nihon, 22nd Fl. | Montreal, Quebec | ||
11851 | 11851 | 2000-03-31 | 1999-12-16 | Hooper | Peter | Carlington Sales Canada Corporation 5347 | 1999-12-09 | Carlington Sales Canada Corporation | 1260 Crescent, | Suite 201 | Montreal, Quebec | ||
41184 | 41184 | 2000-12-31 | 2000-04-06 | Legault | Alexandre | Carlington Sales Canada Corporation 5347 | 1999-12-09 | Carlington Sales Canada Corporation | 1260 Crescent, | Suite 201 | Montreal, Quebec | ||
41194 | 41194 | 2000-12-31 | 2000-07-28 | Goupil | Stephane | Carlington Sales Canada Corporation 5347 | 1999-12-09 | Carlington Sales Canada Corporation | 1260 Crescent, | Suite 201 | Montreal, Quebec | ||
41205 | 41205 | 2000-12-31 | 1999-12-09 | Fraser | Herbert | Carlington Sales Canada Corporation 5347 | 1999-12-09 | Carlington Sales Canada Corporation | 1260 Crescent, | Suite 201 | Montreal, Quebec | ||
41206 | 41206 | 2000-12-31 | 1999-12-16 | Ben-Menashe | Ari | Carlington Sales Canada Corporation 5347 | 1999-12-09 | Carlington Sales Canada Corporation | 1260 Crescent, | Suite 201 | Montreal, Quebec | ||
41207 | 41207 | 2000-12-31 | 1999-12-16 | Damiron | Olivier Frederic | Carlington Sales Canada Corporation 5347 | 1999-12-09 | Carlington Sales Canada Corporation | 1260 Crescent, | Suite 201 | Montreal, Quebec | ||
5412 | 5412 | 2009-01-31 | 2007-01-10 | Ben-Menashe | Ari | Dickens & Madson Canada, Inc. 5784 | 2007-01-10 | Dickens & Madson Canada, Inc. | 740 Notre Dame Ouest | Suite 1250 | Montreal, Quebec |
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]) );