musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality", musiccaps_aspects contains "mellow wide bells" and "youtube_published" is on date 2011-09-09
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 |
---|---|---|---|---|---|---|---|---|---|---|
432hz Lazu Ra Oh | The low quality recording features an ambient song that consists of mellow wide bells and wide low synth pad playing in the background. It sounds calming, relaxing and hypnotic, like something you would hear in a hypnotic therapy session. | 2011-09-09T21:35:44Z | nutstar13 | Music Lazu Ra Oh 432hz is by Stellar www.starsistrum.com. and produced by Marc Mitchell www.marcmitchell.com Painting Loving oneness is by Katrina Vrebalovich www.magicaleye.net 2011 sept | ["Singing bowl"] | ["ambient", "mellow wide bells", "wide low synth pad", "calming", "relaxing", "hypnotic", "low quality"] | 4 | EN_FOFkxAEw | 1549 |
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;