I'm not entirely clear on what you want, but interpreting "how to retrieve the value of 'checkin'" literally, you can do this:
"checkin" /. j
or
Query["checkin"][j]
So, to get the json,
ImportString[Query["checkin"][j], "RawJSON"]
Also, it would help if you formatted your code to be copy-paste-able.