I have a table similar to this, where I need to pull the value out of each JSON field that has an id equal to 2. I’ve tried multiple examples, but cannot manage to wrap my head around how to manipulate json_tuples / lateral views / explodes into my scenario.

I have a sql table to read and to filter rows where the timestamp is within open hours of a place and then write the filtered rows to a new table.