FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "Montreal, Quebec" and Registrant_Name = "Canadian National Railways" sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- - 16
Registration_Number 1
Registrant_Name 1
- Canadian National Railways · 16 ✖
City 1
- Montreal, Quebec · 16 ✖
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 |
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]) );