RE: Where are the Votes (SP) going?

[arcange]

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.

Comments

[buggedout]

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.

[arcange]

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

_{Posted with}

[buggedout]

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

[abh12345]

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 :)

[arcange]

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