musiccaps_details (view)
1 row where musiccaps_aspects contains "hypnotic", musiccaps_aspects contains "wide soft dark synth pad" and "youtube_published" is on date 2011-11-22
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Power Nap Guided Relaxation and Self Hypnosis by Empowered Within | The low quality recording features a mellow female vocal narrating over a wide soft dark synth pad. There is a constant buzzy noise in the background. It sounds suspenseful, calming and hypnotic. | 2011-11-22T00:09:15Z | Empowered Within Hypnosis | http://www.empoweredwithin.com Free power nap audio recording by Kerie Logan at Empowered Within. For more information at Kerie Logan and Empowered Within, check us out online at www.empoweredwithin.com. We have several FREE stuff, money saving coupons and a monthly newsletter. | ["Singing bowl"] | ["low quality", "mellow female vocal", "narrating", "wide soft dark synth pad", "noisy", "suspenseful", "calming", "hypnotic", "buzzy"] | 4 | vQcB6NI7cMo | 5183 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;