BigQuery Release Notes

select feed.id as feed_id, feed.title as feed_title, feed.link."@_href" as feed_url, feed.author.name as feed_author, cast(feed.updated as date) as feed_date, entry.title as entry_title, entry.id as entry_id, cast(entry.updated as date) as entry_date, entry.link."@_href" as entry_link, unnest(regexp_split_to_array(entry.content."#text", '<h3')) as entry, from __release_notes

select * , regexp_extract(entry, '([^<]*)</h3') as type, from _release_notes where entry != ''