select id, data::json->'some_key' as some_key
from my_table
where (data::json->'some_key'->'some_od')::text::int != 0