RE: Where are the Votes (SP) going?

avatar

You are viewing a single comment's thread:

Nice one Asher. What you ideally want is the rshares on the votes, but SteemSQL doesn't seem to provide that. I've had to pull apart API responses to get that info.

I think this is pretty indicative of where the big "relationships" are though.

0
0
0.000
8 comments
avatar

yeah rshares would be the gold, a total nightmare for average scripters though!

vests is possible but just don't make sense to most (including me) with the numbers being so big.

It's good enough to see where the money is I think, cheers :)

0
0
0.000
Reply
avatar

rshares are available in SteemSQL! You will find them in Comments..active_votes.

Unfortunately, it's a big JSON string you have to parse. Not very handy nor resource-friendly for big queries.

0
0
0.000
Reply
avatar

Yes, I have seen it there in JSON though if I have to write a script to extract it I may as well use the API. I should have been more accurate - the data is there but not really SQL extractable / queryable.

0
0
0.000
Reply
avatar

It's extractable/queryable, but you will have to play with SQL JSON functions. Challenging, isn't it? 😉

Posted with

0
0
0.000
Reply
avatar
(Edited)

The short answer is 'yes'.

A look at that column for my depth=0 posts shows some empty fields, some text starting with

[{"voter":"bleepcoin","weight":462,"rshares":3874889785,"percent":100,"reputation":0,"time":"2019-02-13T15:19:00"} ......

and some starting with

[{"percent":1900,"reputation":"90169188750593","rshares":"91937688256","time":"2019-02-14T20:29:45","voter":"mammasitta","weight":9617},{"percent":3300,"reputation":"90455657914116","rshares ......

One for when I have a weekend spare :)

0
0
0.000
Reply
avatar

Oh, you have some weekend spare. You lucky boy! ;)

0
0
0.000
Reply
avatar

Perhaps I will try it if I ever decide to pay for the access again. Unlikely, but never say never ;)

0
0
0.000
Reply