Donald Trump Financial Disclosure - June 14, 2017

	A	B	C	E	F	G	H
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