#635121 (Stack Overflow #52961250)

Visit post

Initially received about 2 months ago.

{"action":"155-questions-active","data":"{\"siteBaseHostAddress\":\"stackoverflow.com\",\"id\":52961250,\"titleEncodedFancy\":\"How to transpose a table in SQLite?\",\"bodySummary\":\"Hello so I have a table as such in SQlite:\\n\\n   User    |  Group  |   Role    \\nJohn Smith |   A     |   admin\\nJohn Smith |   B     |   user\\nJane Doe   |   A     |   user\\nJane Doe   |   B     |   limit\\n...\",\"tags\":[\"sql\",\"sqlite\",\"transpose\"],\"lastActivityDate\":1540357574,\"url\":\"https://stackoverflow.com/questions/52961250/how-to-transpose-a-table-in-sqlite\",\"ownerUrl\":\"https://stackoverflow.com/users/4438012/harcot\",\"ownerDisplayName\":\"harcot\",\"apiSiteParameter\":\"stackoverflow\"}"}
{"iota.stackexchange.com":["2187"],"korean.stackexchange.com":["4855"],"esperanto.stackexchange.com":["5030"],"expressionengine.stackexchange.com":["40780"],"languagelearning.stackexchange.com":["2673"],"augur.stackexchange.com":["754"],"opendata.stackexchange.com":["12134"],"sustainability.stackexchange.com":["6914"],"italian.stackexchange.com":["9978"],"chess.stackexchange.com":["22722"],"opensource.stackexchange.com":["7522"],"literature.stackexchange.com":["8668"],"spanish.stackexchange.com":["27686"],"tridion.stackexchange.com":["17198"],"hardwarerecs.stackexchange.com":["9906"],"craftcms.stackexchange.com":["28191"],"hermeneutics.stackexchange.com":["35252"],"retrocomputing.stackexchange.com":["8040"],"quant.stackexchange.com":["42349"],"stellar.stackexchange.com":["1809"],"bioinformatics.stackexchange.com":["5060"],"cstheory.stackexchange.com":["41782"],"hsm.stackexchange.com":["7850"],"sitecore.stackexchange.com":["8907"],"rus.stackexchange.com":["444866"],"economics.stackexchange.com":["25166"],"matheducators.stackexchange.com":["14593"],"space.stackexchange.com":["31556"],"philosophy.stackexchange.com":["56450"],"japanese.stackexchange.com":["62381"],"earthscience.stackexchange.com":["8385"],"vi.stackexchange.com":["17717"],"pt.stackoverflow.com":["338498","338492","338499","338488","159917","152029"],"blender.stackexchange.com":["121123","102540"],"puzzling.stackexchange.com":["74323"],"photo.stackexchange.com":["62202"],"scifi.stackexchange.com":["197251"],"law.stackexchange.com":["32873"],"politics.stackexchange.com":["34699"],"french.stackexchange.com":["32135"],"music.stackexchange.com":["75723"],"codereview.stackexchange.com":["206152"],"stats.stackexchange.com":["373461","215144"],"mathematica.stackexchange.com":["184512"],"rpg.stackexchange.com":["134208"],"sqa.stackexchange.com":["36140"],"bicycles.stackexchange.com":["57636"],"cs.stackexchange.com":["99011"],"elementaryos.stackexchange.com":["11339"],"diy.stackexchange.com":["127583"],"es.stackoverflow.com":["91203"],"video.stackexchange.com":["20022"],"sharepoint.stackexchange.com":["200285"],"gardening.stackexchange.com":["41641"],"scicomp.stackexchange.com":["24613"],"datascience.stackexchange.com":["30868"],"tex.stackexchange.com":["452179"],"ethereum.stackexchange.com":["45895"],"emacs.stackexchange.com":["30877"],"ai.stackexchange.com":["7624"],"ell.stackexchange.com":["143273"],"robotics.stackexchange.com":["16591"],"worldbuilding.stackexchange.com":["127452"],"electronics.stackexchange.com":["402869"],"ru.stackoverflow.com":["897091"],"magento.stackexchange.com":["247582"],"stackoverflow.com":["52961250"]}
{"site":"stackoverflow.com","posts":["52961250","52939285","21243690"]}
{"post":{"owner":{"reputation":8,"display_name":"harcot","link":"https://stackoverflow.com/users/4438012/harcot"},"down_vote_count":0,"up_vote_count":0,"score":0,"last_activity_date":1540357574,"creation_date":1540356357,"last_edit_date":1540357574,"question_id":52961250,"link":"https://stackoverflow.com/questions/52961250/how-to-transpose-a-table-in-sqlite","title":"How to transpose a table in SQLite?","body":"Present, but truncated"},"check_if_spam":[false,null,""]}