Exploratory Analysis Shows World of Opportunity with JSON and STEEM by paulag

View this thread on: hive.blog | peakd.com | ecency.com

utopian-io · @paulag · Jan 9 '19

$53.85

Exploratory Analysis Shows World of Opportunity with JSON and STEEM

<html>
<p>The use of Custom JSON field on the STEEM Blockchain is becoming more and more popular. &nbsp;From discussion I have read, this field can do almost anything from creating Tokens to holding game information.</p>
<p>JSON data is a way of representing objects or arrays. &nbsp;It is easy to read, and it is easy to parse. &nbsp;Many API calls will return JSON format and many web apps use JSON to easily move information around the internet.</p>
<p>Its is therefore no surprise that developers are now using the JSON filed on steem to move data between an app and the blockchain.</p>
<p>Initially the Custom JSON field was used for holding follow information, where one account on the blockchain follows another. &nbsp;However, over time, this has expanded to holding information from multiple sources for multiple reasons.</p>
<p>https://cdn.steemitimages.com/DQmWuF5qnRbyQog6Rrkjf14KeF5J4ycuFGPMaxQniesoBiU/11.png</p>
<p>With that in mind I wanted to take a quick look at the Txcustoms table in the STEEMSQL database to just get an idea of what and who is using this JSON field. &nbsp;This type of analysis is commonly called exploratory analysis.</p>
<h2>Repository</h2>
<p>https://github.com/steemit/steem</p>
<h2>Aim of Exploratory Analysis</h2>
<p>- Get a feel for the Txcustoms table in STEEMSQL.</p>
<p>- Establish if there was growth in the use of this field from 2018 to 2019</p>
<p>- Establish what app is using this most</p>
<p>- Get an idea of the type of data held&nbsp;</p>
<h2>Analysis</h2>
<p>The table below shows the custom JSONs for the first week of January 2018. None of the Custom JSONs required additional posting or other authorities. &nbsp;As we can see, most of the transitions using this field were Follows, however there were a few others too.</p>
<p>https://cdn.steemitimages.com/DQmXFXXqpRJKpFHL4JFG3JXEkEpym3JoUVRsFz4EHa8LJGU/3.png &nbsp;</p>
<p>Pacman-live seems to be one of the first games to host data on the blockchain. &nbsp;Looking at this further the data sent to the blockchain was the username, the score, the game level and a timestamp.</p>
<p>&nbsp;https://cdn.steemitimages.com/DQmTJakW7xST84xHCSrdyaQfy8mASHZeL2DBEJacLfmYc8J/4.png&nbsp;</p>
<p>Chainbb seem to have been using the JSON field to store details of Forum objects, such as forum configurations and forum posts.</p>
<p>&nbsp;https://cdn.steemitimages.com/DQmVgzxL1C4dPDKrmcAoCcZa31MRJqrKoNo9c8i6ns1uxf7/5.png&nbsp;</p>
<p>Distribution is an interesting one and seems to be holding information about distributions from randowhale</p>
<p>&nbsp;https://cdn.steemitimages.com/DQmNXmE4HyL3ufaxGJsi1WNxF9Ur7jNKoUrnpxPnQ6zHCSX/6.png&nbsp;</p>
<p>&nbsp;And we can also see some testing of STEEMMonsters under TEST_sm_pre_sale_packs</p>
<p>&nbsp;https://cdn.steemitimages.com/DQmcwQiuqDf24ZYNJrtKyD679srxz84oGDaXZvxfHNADw7C/7.png&nbsp;</p>
<p>Jumping on now to the first week of January 2019 and things are looking rather different. 980162 custom JSON fields were used, down 58% on the same time last year. &nbsp;However, this is not bad news because in 2018 99.8% of these related to follows and unfollows. &nbsp;With the downturn in activity on the blockchain, for the same period in 2019 follows and unfollows make up only 9.8% of the custom JSON transactions. &nbsp;The was a reduction of 95% in the actual number of follows and unfollows.</p>
<p>&nbsp;https://cdn.steemitimages.com/DQmQ51hNeayP6zrkbr1yX8wpDQtPnnVsfDXiY9wun5bCNqs/8.png&nbsp;</p>
<p>The table above shows the number of transitions of each time with custom JSONS. I have split this list in two. &nbsp;On the right we have all the STEEMMonsters custom JSONS. &nbsp;This makes up 88% of all custom JSONs. &nbsp;On the left we have others such as Follows, DiceHash and Dlux.</p>
<p>The table below shows a sample of the data contained within some of the JSONs.</p>
<p>https://cdn.steemitimages.com/DQmebZia6NFqhrXTJQxGMtnBN49wyK1wjVjUnRYF2wckFb2/9.png&nbsp;</p>
<p>Also changed considerably since 2018 is the user of authority to post and this is also recorded in the blockchain and the SQL database. &nbsp;Looking at this for STEEMMonsters in the table below, by doing a count of the required_posting_auths we can see that for this period there were 366,192 find match and by carrying out a distinct count of the same field, we can establish this was by 2379 different accounts.</p>
<p>&nbsp;https://cdn.steemitimages.com/DQmewa4WUfLjYbvm6nLkwZ5UqNZ1Qgtv3Na9NBXRnU86ycx/10.png&nbsp;</p>
<h2>Conclusion</h2>
<p>Although there was a reduction in the number of custom JSONs used from Jan 18 to Jan 19, this is a reflection on the downturn in social activity on the block and not development activity.</p>
<p>The social activity, follows and unfollows is down 95%. &nbsp;However, in 2018 non-social activity recorded in JSON was only 0.02%, in 2018 this was 90.2%. &nbsp;This is an indication of development on the block and a sign in the shift of the platform from being a content/social platform to something more.</p>
<p>By looking at the data contained within the JSONs my eyes have been opened on how simple it can be to really make ‘ANY’ app a DApp on the STEEM Blockchain and I hope it gives you that sense too. &nbsp;</p>
<p>Obviously STEEMMonsters are well out there in terms of usage compared to other apps using JSONs but many apps are only being to test this feature. &nbsp;Some of this comes from the shift away from Steemit.Inc as the only developers on the block. &nbsp;STEEM is coded in C++ which is a skill many do not have. &nbsp;However, there is no shortage of App developers with JSON knowledge.</p>
<p>Now that I have a better understanding of how this table in the SQL database is kept and what data it contains, it opens up a new world of analysis.</p>
<h2>So, who will be first to have a D+ site ready to replace G+ communities using our new friend JSON?</h2>
<h2>Data and Query</h2>
<p>The data for this post was taken from the STEEMSQL database held and managed by @arcange.</p>
<p>The query used for 2019 was</p>
<pre><code>select *</code></pre>
<pre><code>from Txcustoms</code></pre>
<pre><code>where CONVERT(DATE,timestamp) BETWEEN '2019-01-01' AND '2019-01-07'</code></pre>
<p>and for 2018 was</p>
<pre><code>select *</code></pre>
<pre><code>from Txcustoms</code></pre>
<pre><code>where CONVERT(DATE,timestamp) BETWEEN '2018-01-01' AND '2018-01-07'</code></pre>
<p>As always, I used PowerBI to</p>
<p>- Connect to the data</p>
<p>- Transform the data</p>
<p>- Carry out calculations</p>
<p>- Visualise the data</p>
<p>If you want to learn more about using PowerBI or Excel do follow @theexcelclub</p>
<p><br></p>
</html>

👍 utopian-io, oracle-d, kpine, aggroed, tombstone, realcleaner, inertia, krnel, followbtcnews, contestkings, therealwolf, timcliff, mangos, holger80, proboards3, proboards1, proboards, dcooperation, sbi2, steem-ua, clixmoney, abh12345, mattclarke, protegeaa, kerrywolf, edicted, scorer, znnuksfe, amosbastian, fulltimebot8, fulltimebot2, fulltimebot, fulltimebot6, fulltimebot12, fulltimebot15, fulltimebot14, fulltimebot18, fulltimebot22, fulltimebot27, fulltimebot52, fulltimebot26, fulltimebot24, fulltimebot13, fulltimebot51, fulltimebot30, fulltimebot21, boxcarblue, steemchiller, bluesniper, jaff8, crokkon, fredrikaa, bafi, clumsysilverdad, steemchoose, newageinv, espoem, jasonbu, we-are, revisesociology, themanny, ulockblock, mariusjuk, make-a-whale, and 157 others

properties (23)vote details (221)

voter	rshares	pct
tombstone	2,341,444,319,007	9.12%
teamsteem	34,029,846,557	20%
hitmeasap	11,894,236,419	33%
inertia	1,474,630,701,138	100%
arcange	35,315,724,614	4%
raphaelle	2,004,940,057	4%
akipponn	19,808,746,305	100%
timcliff	795,452,276,006	86%
kpine	7,481,110,723,583	30%
johnhtims	1,313,345,382	100%
protegeaa	261,127,868,935	50%
mada	31,974,363,210	100%
mattclarke	287,855,255,027	50%
etcmike	20,568,515,869	10%
runridefly	1,217,730,372	5%
krnel	1,438,147,754,939	100%
aggroed	2,644,043,600,697	100%
phusionphil	140,877,751	1.9%
abh12345	290,382,030,430	50%
boxcarblue	118,202,113,425	50%
mangos	758,661,305,606	21%
felix.herrmann	9,150,026,887	100%
j3dy	21,543,898,564	100%
cardboard	2,695,906,312	100%
anthonyadavisii	38,352,696,310	50%
danielsaori	36,746,211,026	100%
anarcotech	11,155,974,917	18%
freebornsociety	5,672,926,589	10%
cryptocurator	16,992,333,439	7.2%
steemchiller	115,757,552,375	100%
followbtcnews	1,071,502,100,402	100%
rt395	3,204,584,104	15%
oscarcc89	4,241,342,923	12%
clixmoney	324,840,316,645	100%
jakipatryk	29,155,640,254	100%
fredrikaa	91,913,998,655	100%
nuagnorab	11,481,273,335	100%
crimsonclad	35,025,290,646	8%
pennsif	21,590,038,132	10%
gokulnk	26,171,042,051	100%
mcoinz79	3,936,845,275	1%
discordiant	1,942,116,344	8%
jacekw	7,805,271,578	50%
codingdefined	16,565,910,696	15%
steemitbc	7,578,869,138	100%
fates	3,713,137,893	100%
inquiringtimes	15,431,159,049	50%
fararizky	524,293,226	12%
steemik	9,653,219,066	100%
clumsysilverdad	82,642,035,329	50%
jasonbu	62,045,159,423	75%
steemitph	24,884,710,855	50%
monash	263,795,778	52%
make-a-whale	40,832,441,767	6.4%
niallon11	7,989,781,673	5%
aneukpineung78	3,861,132,641	100%
aidarojaswriter	690,707,430	10%
crokkon	93,265,994,528	100%
eastmael	25,615,183,967	100%
jamesbarraclough	617,229,169	100%
june0620	13,413,790,332	10%
therealwolf	814,083,456,338	100%
roleerob	15,134,487,345	10%
scorer	158,501,360,234	100%
revisesociology	51,280,713,542	15%
espoem	68,406,776,247	37.97%
steemitbaby	925,667,353	100%
mcfarhat	32,845,118,150	21.7%
loshcat	3,112,896,836	100%
veganroma	6,102,347,651	30%
izge	215,113,238	12%
utopian-io	57,370,321,696,411	45.64%
jaff8	100,148,341,173	54.25%
steemflow	38,853,779,758	50%
amriadits	792,073,007	100%
seanlloyd	302,982,031	1%
familytree	1,362,786,281	95%
mariska.lubis	33,979,469,609	100%
scipio	5,512,697,354	5.55%
wallacecarranza	345,613,871	100%
steeminer4up	892,775,869	100%
josephsavage	2,069,178,954	10%
greenorange	550,011,693	100%
ravenruis	16,489,920,650	75%
geekpowered	40,336,159,238	90%
lextenebris	23,423,597,188	100%
ekonugraha	3,205,067,883	16.8%
fulltimeangel	27,376,952,568	100%
amosbastian	125,072,796,597	54.25%
beautifuldata	10,165,661	30%
znnuksfe	148,511,053,097	100%
plloi	428,282,035	100%
pirsamads	9,597,731,817	100%
edicted	196,247,017,084	100%
mattockfs	40,286,627,837	100%
soufiani	5,662,105,822	5%
cfminer	2,363,855,227	100%
damahsyari	542,859,591	100%
khusairi	345,359,632	12%
newageinv	74,335,397,761	19%
holger80	550,338,429,618	100%
alexabsolute	6,183,933,985	10%
celmor	552,776,032	100%
east.autovote	959,342,138	100%
ameliabartlett	125,526,150	1%
siatteuk	2,219,689,423	50%
putu300	7,883,406,803	10%
fego	34,903,887,571	100%
djoi	2,106,998,500	24%
reazuliqbal	26,942,594,771	20%
lauchmelder	14,302,968,177	25%
scottshots	2,527,748,897	4%
cicisaja	7,950,963,534	55%
mariusjuk	42,903,229,568	100%
adamada	14,719,083,635	50%
musmui	553,709,992	100%
sbi2	387,511,729,571	44.91%
semperenglish	1,047,395,262	100%
zcool	183,902,017	10%
tfq86	17,760,646,816	44%
ladiesofsteemit	342,200,906	10%
bobaphet	6,672,739,843	10%
vegan4theanimals	1,846,410,976	50%
peekbit	8,568,286,339	100%
angelinafx	3,664,994,301	1.5%
brainpod	581,982,686	25%
saracampero	3,034,717,385	12%
el-nailul	9,075,164,454	100%
we-are	51,457,024,016	10.41%
bafi	91,510,432,595	100%
cryptospa	7,259,024,589	10%
edgarbevens	183,955,780	50%
gandalfthebrown	4,582,945,590	100%
pinkwonder	10,481,970,186	100%
reality-variance	70,864,905	20%
vincy	23,612,231,803	15%
akbarsanjani	708,738,626	12%
mrshev	9,159,545,615	40%
hazard10	555,443,218	100%
smartmeme	1,408,608,699	25%
ziapase	6,460,671,335	100%
gormogon	8,367,383,877	10%
blewitt	15,910,989,845	4%
kafupraise	124,001,291	36%
romafedorov	11,513,466,334	20%
jayboi	4,626,876,713	12%
yomismosoy	79,041,815	24%
gamer86	552,751,311	100%
ulockblock	44,608,778,350	16.41%
herznactvifor	448,765,455	100%
gorraudechan	520,469,610	100%
oracle-d	19,366,579,945,438	24%
hebetseves	522,588,821	100%
themanny	47,916,215,228	100%
nieloagranca	6,702,205,688	8%
katherine98	456,160,741	100%
steemchoose	76,790,141,266	3.5%
mareng	497,513,743	100%
dcooperation	459,480,587,954	100%
inoobgamer	1,484,590,877	20%
mops2e	436,935,792	30.37%
lizardslayer	3,842,406,576	100%
fulltimebot	124,438,067,468	100%
fulltimebot2	124,463,208,726	100%
fulltimebot6	124,395,380,516	100%
fulltimebot8	124,536,582,892	100%
fulltimebot12	124,389,724,810	100%
theexcelclub	13,673,048,926	100%
exterminator	1,595,504,999	100%
goldenchild	1,644,518,761	100%
townmayor	1,447,003,913	100%
downrighthustle	636,463,021	50%
behelen	15,946,456,928	50%
sydneyb	436,903,300	100%
poisoncontrol	1,649,155,461	100%
dramaking	1,275,347,820	100%
fulltimebot13	124,218,323,051	100%
fulltimebot14	124,321,780,357	100%
fulltimebot15	124,334,633,085	100%
fulltimebot18	124,313,727,760	100%
fulltimebot21	124,180,814,139	100%
fulltimebot22	124,276,795,558	100%
fulltimebot24	124,230,626,474	100%
fulltimebot26	124,248,270,489	100%
fulltimebot27	124,273,162,034	100%
fulltimebot30	124,199,030,918	100%
jacekw.dev	2,697,666,598	40%
fulltimebot51	124,203,841,748	100%
fulltimebot52	124,258,056,855	100%
paololuffy91	470,880,940	20%
itskyle	251,568,156	25%
nieracilock	522,592,437	100%
wicatennewp	531,205,547	100%
vieletporid	480,214,408	100%
essivinmaps	533,909,580	100%
balticbadger	2,546,668,525	5%
steem-ua	353,751,556,082	3.06%
tebarsuara	552,822,595	100%
kaczynski	100,415,351	100%
contestkings	815,707,918,955	100%
teamcr	801,703,598	100%
cinema613	247,455,661	50%
gouji	457,691,729	100%
realcleaner	2,013,830,019,800	100%
aeiou00	131,887,295	30%
bluesniper	104,449,689,631	8.68%
morningshine	3,657,853,687	100%
ascorphat	923,865,933	2.5%
princessamber	4,088,640,975	100%
geekoverdose	319,135,801	50%
sumon054	0	5%
circa	27,596,890,314	100%
tipu.curator	16,802,312,116	50%
ghostdylan	17,196,566,763	100%
we-are-steemians	20,655,271,039	5.28%
aerial-italy	423,644,098	100%
kerrywolf	255,015,843,502	100%
we-are-welcoming	8,134,179,575	50%
proboards	466,502,683,128	100%
proboards3	484,076,018,463	100%
proboards1	483,984,139,314	100%

@arcange · Jan 9 '19 (edited)

$0.07

Hello Paula,

Sorry to say it, but your analysis is (partially) invalid :/

> The table below shows the custom JSONs for the first week of January 2018. None of the Custom JSONs required additional posting or other authorities.

There was a bug in SteemSQL Database Injector, which was not processing `required_auths` and `required_posting_auths`.
This problem was fixed in December 2018 and only new custom_json operations issued after the fix were recorded correctly.

Unfortunately, SteemSQL need to reprocess all blocks from the beginning of the blockchain, something I plan to do this month.

_(upvoted for visibility)_

👍 arcange, paulag, pinkwonder, lextenebris, raphaelle, celmor

`author`	arcange
`permlink`	re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t153102993z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-09 15:31:03
`last_update`	2019-01-09 15:32:15
`depth`	1
`children`	3
`last_payout`	2019-01-16 15:31:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.066 HBD
`curator_payout_value`	0.003 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	624
`author_reputation`	1,148,349,221,690,653
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,135,606
`net_rshares`	168,241,949,147
`author_curate_reward`	""

properties (23)vote details (6)

voter	rshares	pct
arcange	89,685,544,256	10%
raphaelle	5,321,664,186	10%
paulag	54,455,184,478	18%
lextenebris	7,542,222,030	33%
celmor	540,774,929	100%
pinkwonder	10,696,559,268	100%

@paulag · Jan 9 '19

Okay, thanks for letting us know.  Good luck reprocessing, that will take ages.

properties (22)

`author`	paulag
`permlink`	re-arcange-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t154034869z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-09 15:40:36
`last_update`	2019-01-09 15:40:36
`depth`	2
`children`	2
`last_payout`	2019-01-16 15:40:36
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	79
`author_reputation`	274,264,287,951,003
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,136,068
`net_rshares`	0

@arcange · Jan 9 '19

$0.02

![](https://cdn.steemitimages.com/DQmURDgvywcEcnZnMSLC5QpPEFB4MV9DSU98VEsCfERe1hu/image.png)

👍 haphazard-hstead

`author`	arcange
`permlink`	re-paulag-re-arcange-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t202046215z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"image":["https://cdn.steemitimages.com/DQmURDgvywcEcnZnMSLC5QpPEFB4MV9DSU98VEsCfERe1hu/image.png"],"app":"steemit/0.1"}
`created`	2019-01-09 20:20:45
`last_update`	2019-01-09 20:20:45
`depth`	3
`children`	1
`last_payout`	2019-01-16 20:20:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.016 HBD
`curator_payout_value`	0.005 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	92
`author_reputation`	1,148,349,221,690,653
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,146,731
`net_rshares`	42,379,879,754
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
haphazard-hstead	0 B		42,379,879,754	20%

1 reply

@crokkon · Sep 18 '22 (edited)

$6.94

👍 utopian-io, mightypanda, amosbastian, espoem, codingdefined, ulockblock, organicgardener, statsexpert, reazuliqbal, interfecto, yff, fastandcurious, hakancelik, monster-inc, linknotfound, ascorphat, emrebeyler

`author`	crokkon
`permlink`	re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190112t114800867z
`category`	utopian-io
`json_metadata`	"{"app": ""}"
`created`	2019-01-12 11:48:00
`last_update`	2022-09-18 09:59:45
`depth`	1
`children`	1
`last_payout`	2019-01-19 11:48:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	5.263 HBD
`curator_payout_value`	1.676 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1
`author_reputation`	81,214,366,861,104
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,271,642
`net_rshares`	13,493,026,573,135
`author_curate_reward`	""

properties (23)vote details (17)

voter	rshares	pct
codingdefined	16,945,262,230	15%
espoem	27,032,233,455	15%
utopian-io	13,242,258,237,606	9.52%
emrebeyler	41,577,773	0.01%
amosbastian	44,153,167,762	19.68%
interfecto	6,042,898,460	18%
organicgardener	7,088,763,746	25%
reazuliqbal	6,273,325,221	5%
hakancelik	2,102,723,249	30%
statsexpert	6,902,690,722	100%
mightypanda	112,371,243,234	65%
ulockblock	13,045,688,216	4.94%
fastandcurious	2,338,657,413	60%
linknotfound	1,256,232,084	100%
ascorphat	952,235,622	2.5%
monster-inc	1,303,630,055	100%
yff	2,918,006,287	100%

@utopian-io · Jan 14 '19

Thank you for your review, @crokkon! Keep up the good work!

properties (22)

`author`	utopian-io
`permlink`	re-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190112t114800867z-20190114t135426z
`category`	utopian-io
`json_metadata`	"{"app": "beem/0.20.9"}"
`created`	2019-01-14 13:54:27
`last_update`	2019-01-14 13:54:27
`depth`	2
`children`	0
`last_payout`	2019-01-21 13:54:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	59
`author_reputation`	152,955,367,999,756
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,364,617
`net_rshares`	0

@el-nailul · Jan 9 '19

Hi @paulag, happy new year and wish you and your family all the best, sorry it is too late to say it and celebrate it.

properties (22)

`author`	el-nailul
`permlink`	re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t171828018z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"users":["paulag"],"app":"steemit/0.1"}
`created`	2019-01-09 17:18:42
`last_update`	2019-01-09 17:18:42
`depth`	1
`children`	2
`last_payout`	2019-01-16 17:18:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	118
`author_reputation`	9,588,203,965,396
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,140,177
`net_rshares`	0

@paulag · Jan 9 '19

hay, how are you.  Happy new year to you and your loved ones too xx

properties (22)

`author`	paulag
`permlink`	re-el-nailul-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t205002671z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-09 20:50:03
`last_update`	2019-01-09 20:50:03
`depth`	2
`children`	1
`last_payout`	2019-01-16 20:50:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	67
`author_reputation`	274,264,287,951,003
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,147,744
`net_rshares`	0

@el-nailul · Jan 10 '19

I am good, but not have more time online during this farming season, I am working in the farming land, planting veggies now. Thank you @paulag

properties (22)

`author`	el-nailul
`permlink`	re-paulag-re-el-nailul-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190110t160009169z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"users":["paulag"],"app":"steemit/0.1"}
`created`	2019-01-10 16:00:12
`last_update`	2019-01-10 16:00:12
`depth`	3
`children`	0
`last_payout`	2019-01-17 16:00:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	142
`author_reputation`	9,588,203,965,396
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,186,449
`net_rshares`	0

@krnel · Jan 9 '19 (edited)

Cool.
Is there a record of who adds the custom JSON?
Any authorization to add a field that already exists and is being pulled for data?
Can anyone add anything, like any account add info for any JSON data and imitate an app, such as adding bogus data?
Could I just add followers to people who didn't really follow?
Can I add SM data just by adding a custom JSON object?

Thanks!

properties (22)

`author`	krnel
`permlink`	re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t152649703z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-09 15:26:48
`last_update`	2019-01-09 15:27:39
`depth`	1
`children`	15
`last_payout`	2019-01-16 15:26:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	378
`author_reputation`	1,343,547,270,297,082
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	0
`post_id`	78,135,351
`net_rshares`	0

@arcange · Jan 9 '19

$0.03

> Can I add SM data just by adding a custom JSON object?

Yes and No. You can add any custom_json content, including similar objects as SM, but the author of the transaction won't match.

Check my comment to @paulag

👍 krnel

`author`	arcange
`permlink`	re-krnel-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t153615697z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"users":["paulag"],"app":"steemit/0.1"}
`created`	2019-01-09 15:36:15
`last_update`	2019-01-09 15:36:15
`depth`	2
`children`	11
`last_payout`	2019-01-16 15:36:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.022 HBD
`curator_payout_value`	0.007 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	215
`author_reputation`	1,148,349,221,690,653
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,135,850
`net_rshares`	56,438,794,096
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
krnel	0 B		56,438,794,096	4%

@krnel · Jan 9 '19

Thanks. So if someone makes an app, they can just look for custom json where their app (or another) is the author of the data and only use that?

properties (22)

`author`	krnel
`permlink`	re-arcange-re-krnel-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t154419203z
`category`	utopian-io
`json_metadata`	{"community":"busy","app":"busy/2.5.6","format":"markdown","tags":["utopian-io"],"users":[],"links":[],"image":[]}
`created`	2019-01-09 15:44:24
`last_update`	2019-01-09 15:44:24
`depth`	3
`children`	10
`last_payout`	2019-01-16 15:44:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	144
`author_reputation`	1,343,547,270,297,082
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,136,261
`net_rshares`	0

10 replies

@paulag · Jan 9 '19

$0.03

Great questions

"Is there a record of who adds the custom JSON?"
In that table, not really, but there is posting auth recorded for apps that needs it.  But it doesnt say which app it came from.  Im sure if I mix this table with another one I could get the results.  But I havent looked.

"Any authorization to add a field that already exists and is being pulled for data?"
Not sure I understand this question

Can anyone add anything, like any account add info for any JSON data and imitate an app, such as adding bogus data?
Hmm great question.  I'm not a dev so I might not answer that correctly.  But I am sure it requires some sort of conscious and authority, if not then it would be possible.  

"Could I just add followers to people who didn't really follow?  "
not unless you have the posting authority

Can I add SM data just by adding a custom JSON object? again you would need posting authority

👍 krnel

`author`	paulag
`permlink`	re-krnel-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t154724262z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-09 15:47:24
`last_update`	2019-01-09 15:47:24
`depth`	2
`children`	2
`last_payout`	2019-01-16 15:47:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.022 HBD
`curator_payout_value`	0.007 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	905
`author_reputation`	274,264,287,951,003
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,136,407
`net_rshares`	56,417,394,810
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
krnel	0 B		56,417,394,810	4%

@arcange · Jan 9 '19

> Can anyone add anything, like any account add info for any JSON data and imitate an app, such as adding bogus data?

Yes, that's why there are lot of invalid "follow" json in the blockchain and apps should double check both the author and the content

properties (22)

`author`	arcange
`permlink`	re-paulag-re-krnel-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t155829425z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-09 15:58:30
`last_update`	2019-01-09 15:58:30
`depth`	3
`children`	0
`last_payout`	2019-01-16 15:58:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	252
`author_reputation`	1,148,349,221,690,653
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,136,898
`net_rshares`	0

@krnel · Jan 9 '19

So when a new field is created, it is associated to the original posting authority that created it, and no other account can add to that field? I thought anyone can add a `follow` to the custom JSON. Similarly, anyone could add any field, and fabricate data. One needs to always check the author of the data added to a field I would think.

properties (22)

`author`	krnel
`permlink`	re-paulag-re-krnel-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t162542464z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-09 16:25:42
`last_update`	2019-01-09 16:25:42
`depth`	3
`children`	0
`last_payout`	2019-01-16 16:25:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	339
`author_reputation`	1,343,547,270,297,082
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	0
`post_id`	78,138,060
`net_rshares`	0

@newageinv · Jan 9 '19

As a non technical person I see this as a demonstration of the flexibility the blockchain has to use available resources to develop more on the ecosystem.  All this activity while have the capacity to grow without impacting the spped or cost to transact!  Seems like a powerful blockchain to me!

Posted using [Partiko iOS](https://steemit.com/@partiko-ios)

properties (22)

`author`	newageinv
`permlink`	newageinv-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t154357677z
`category`	utopian-io
`json_metadata`	{"app":"partiko","client":"ios"}
`created`	2019-01-09 15:44:15
`last_update`	2019-01-09 15:44:15
`depth`	1
`children`	1
`last_payout`	2019-01-16 15:44:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	357
`author_reputation`	265,103,654,583,177
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,136,252
`net_rshares`	0

@paulag · Jan 9 '19

I'm not so technical myself.  Most of the stuff I learned about the block I did so by exploring the data, I cant read code :-)  so I too see this as a demonstration of the flexibility

properties (22)

`author`	paulag
`permlink`	re-newageinv-newageinv-re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190109t204943043z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2019-01-09 20:49:42
`last_update`	2019-01-09 20:49:42
`depth`	2
`children`	0
`last_payout`	2019-01-16 20:49:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	183
`author_reputation`	274,264,287,951,003
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,147,736
`net_rshares`	0

@pennsif · Jan 10 '19

This post has been included in the latest edition of  [**SOS Daily News**](https://steemit.com/steem/@pennsif/sosdailynewsnewsaboutthestateofsteem9january2019-csus4vv1m9) - a digest of all you need to know about the State of Steem.

***

* *Editor of the [**The State of Steem SoS Daily News**](https://steemit.com/steem/@pennsif/sosdailynewsnewsaboutthestateofsteem9january2019-csus4vv1m9).*

* *Promoter of [**The State of Steem SoS Weekly Forums**](https://steemit.com/steem/@pennsif/the-state-of-steem-forum-3-supported-by-dsound-thursday-10-january-8pm-11pm-utc-msp-waves).*

* *Editor of the [**weekly listing of steem radio shows, podcasts & social broadcasts**](https://steemit.com/mspwaves/@pennsif/schedule-of-radio-shows-podcasts-and-social-broadcasts-supported-by-dsound-week-beginning-7-january-2019).*

* *Founder of the [**A Dollar A Day**](https://steemit.com/adollaraday/@adollaraday/a-dollar-a-day-charitable-giving-project-ususd-5000-donated-in-8-months-we-made-it) charitable giving project.*

***

properties (22)

`author`	pennsif
`permlink`	re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190110t161712957z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"links":["https://steemit.com/steem/@pennsif/sosdailynewsnewsaboutthestateofsteem9january2019-csus4vv1m9","https://steemit.com/steem/@pennsif/the-state-of-steem-forum-3-supported-by-dsound-thursday-10-january-8pm-11pm-utc-msp-waves","https://steemit.com/mspwaves/@pennsif/schedule-of-radio-shows-podcasts-and-social-broadcasts-supported-by-dsound-week-beginning-7-january-2019","https://steemit.com/adollaraday/@adollaraday/a-dollar-a-day-charitable-giving-project-ususd-5000-donated-in-8-months-we-made-it"],"app":"steemit/0.1"}
`created`	2019-01-10 16:17:15
`last_update`	2019-01-10 16:17:15
`depth`	1
`children`	0
`last_payout`	2019-01-17 16:17:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,017
`author_reputation`	636,410,097,572,565
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,187,198
`net_rshares`	0

@steem-ua · Jan 10 '19

#### Hi @paulag!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your **UA** account score is currently 7.014 which ranks you at **#90** across all Steem accounts.
Your rank has not changed in the last three days.

In our last Algorithmic Curation Round, consisting of 233 contributions, your post is ranked at **#2**. Congratulations! 
##### Evaluation of your UA score:

* Your follower network is great!
* The readers appreciate your great work!
* Great user engagement! You rock!


**Feel free to join our [@steem-ua Discord server](https://discord.gg/KpBNYGz)**

properties (22)

`author`	steem-ua
`permlink`	re-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190110t031446z
`category`	utopian-io
`json_metadata`	"{"app": "beem/0.20.14"}"
`created`	2019-01-10 03:14:48
`last_update`	2019-01-10 03:14:48
`depth`	1
`children`	0
`last_payout`	2019-01-17 03:14:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	622
`author_reputation`	23,214,230,978,060
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,160,461
`net_rshares`	0

@utopian-io · Jan 12 '19

Hey, @paulag!

**Thanks for contributing on Utopian**.
We’re already looking forward to your next contribution!

**Get higher incentives and support Utopian.io!**
 Simply set @utopian.pay as a 5% (or higher) payout beneficiary on your contribution post (via [SteemPlus](https://chrome.google.com/webstore/detail/steemplus/mjbkjgcplmaneajhcbegoffkedeankaj?hl=en) or [Steeditor](https://steeditor.app)).

**Want to chat? Join us on Discord https://discord.gg/h52nFrV.**

<a href='https://steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1'>Vote for Utopian Witness!</a>

properties (22)

`author`	utopian-io
`permlink`	re-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190112t200048z
`category`	utopian-io
`json_metadata`	"{"app": "beem/0.20.9"}"
`created`	2019-01-12 20:00:51
`last_update`	2019-01-12 20:00:51
`depth`	1
`children`	0
`last_payout`	2019-01-19 20:00:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	588
`author_reputation`	152,955,367,999,756
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,288,398
`net_rshares`	0

@wehmoen · Jun 3 '20 (edited)

properties (22)

`author`	wehmoen
`permlink`	re-paulag-exploratory-analysis-shows-world-of-opportunity-with-json-and-steem-1547046761713-20190110t030913498z
`category`	utopian-io
`json_metadata`	{}
`created`	2019-01-10 03:09:12
`last_update`	2020-06-03 06:51:27
`depth`	1
`children`	1
`last_payout`	2019-01-17 03:09:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1
`author_reputation`	86,504,380,503,125
`root_title`	"Exploratory Analysis Shows World of Opportunity with JSON and STEEM"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	78,160,299
`net_rshares`	0

@paulag · Jan 10 '19

really, thats rather interesting @wehmoen, thanks for sharing :-)

properties (22)