musiccaps_details (view)
1 row where musiccaps_aspects contains "eerie", musiccaps_aspects contains "violin" and musiccaps_names contains "Electronic music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Best Relaxing Sounds For Your Android | This is an electronic music piece. There is a repeated piano theme in the melody. There are various eerie sound effects. Then, a violin starts playing. The atmosphere is unsettling. This piece would fit well in the soundtrack of a mystery video game. | 2013-03-04T13:23:40Z | Milan Jankovic | Download App at http://bit.ly/relaxingsoundsapp If you have any unwanted stress in your life, take a deep breath and relax now, we have some self-help audios in the form of relax ringtones that will help you detach from your busy life. Whether you`re at home, at the office, resting or studying, you will forget all your worries and refresh your mood. If you want a good drug-free alternative, chill-out music will help you create soothing atmosphere. Chillout is relaxing, motivational, inspirational, perfect for home listening as background music. If you prefer subtle instruments that create peaceful state of mind, ambient music is the right choice. If you want soothing and calming experience and need something to fill in the silence, mood music will elevate your mood. | ["Background music", "Electronic music", "Music", "Ambient music"] | ["electronic music", "instrumental", "piano", "repeated theme", "sound effects", "violin", "unsettling", "eerie", "bizarre"] | 9 | XgLUXNAC7b8 | 3210 |
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;