Donald Trump Financial Disclosure - June 14, 2017
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
This is the unedited copy of Donald Trump's OGE 278e Filing from June 14, 2017, in a structured format (Google Spreadsheet) vs a PDF.
3
https://oge.app.box.com/s/kz4qvbdsbcfrzq16msuo4zmth6rerh1c
4
5
We needed to extract the data to put into our database here
https://factba.se/topic/assets
6
7
Please see the appropriately labeled tabs for the data.
8
It has been swept pretty carefully for errors and typos, but please double check if you plan to use the data for publication.
9
10
The content is unedited, but formatting has been adjusted to better work in spreadsheets as follows:
11
Part 1
From and to dates split up to be in separate columns. When no day is indicated (e.g. December 96) it is formatted to the first of the month
12
Part 2
Underlying assets, licensee and location split into separate columns. Low and high values for income and value split into columns for numeric.
13
Part 2
When multiple sources of revenue for a single line item, the first row has the value and income and subsequent rows have just the income with the value as null
14
Part 6
Value and income split into separate columns
15
Part 6
The heading (e.g. Oppenheimer) is attached to each row as appropriate
16
Part 6
The last columns are enhanced data mapping the company name to a clean name (per Google Finance), the category, industry, market exchange and ticker symbol
17
Part 8
Liabilities split the liability value into low and high ranges
18
19
Noticed From Uploading
20
In Part 6, a Cash account (Checking and Savings) in excess of $50,000,000 was opened at Capital One Bank on April 12, 2017, under the Donald J Trump Revocable Trust
21
In Part 8, Liabilities are the same as his previous filings, except for a refinance of #11 as noted. All other terms are identical to the 2016 filing
22
It appears, between the 2016 and 2017 filings, the ownership assets under "Donald J. Trump" are all now under "DJT Holdings LLC", "DJT Holdings Managing Member, LLC" or "The Donald J Trump Revocable Trust" with no change in % ownership.
23
The nesting of those three organizations is as follows:
24
DJT Holdings->1% Owned by->
DJT Holdings Managing Member, LLC
25
99% Owned By->
The Donald J Trump Revocable Trust
26
DJT Holdings Managing Member, LLC->
100% Owned By
->
The Donald J Trump Revocable Trust
27
The Donald J Trump Revocable Trust
28
The Trust, in turn, is managed by JP Morgan without input from Trump, per the disclosure.
29
Amending the above, International Operations seem to have all shifted to "DTTM Operations LLC" or "DTTM Operations Managing Member LLC" in the same pattern
30
31
32
https://factba.se
33
Attribution 3.0 United States (CC BY 3.0 US)
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu