blob: 203120a215e04ad476e4e54022e052fef789b9f3 [file] [log] [blame]
select flatten(d.events), flatten(d.map.rm[0].rptd), flatten(d.features) from `data.json` d where features[0].type='Feature' and d.events[0].type='cmpgn1';