musiccaps_details (view)
1 row where musiccaps_aspects contains "ball bouncing sound" and musiccaps_aspects contains "movie soundtrack"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- ad jingle 1
- animation 1
- ball bouncing sound · 1 ✖
- cellos 1
- funny video 1
- instrumental music 1
- medium tempo 1
- movie soundtrack · 1 ✖
- philharmonic orchestra 1
- poor audio quality 1
- retro ad 1
- string section harmony 1
- timpani’s playing loud 1
- tutorial video soundtrack 1
- violins playing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Bouncing Ball Animation | The song is an instrumental. The song is medium tempo with a string section accompaniment, timpani playing and other percussion instruments. There are other funny sounds like ball bouncing and other percussion tones. The song is an ad jingle soundtrack. The audio track is of poor quality. | 2011-07-16T15:38:32Z | M PROJECT FILMS OFFICIAL | This bouncing ball animation is created using 7 Basic Principles of Animation. | ["Music", "Bouncing"] | ["ball bouncing sound", "string section harmony", "tutorial video soundtrack", "animation", "poor audio quality", "timpani’s playing loud", "violins playing", "cellos", "philharmonic orchestra", "medium tempo", "movie soundtrack", "instrumental music", "retro ad", "ad jingle", "funny video"] | 1 | 40vmsGsFBsw | 533 |
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;