musiccaps_details (view)
3 rows where musiccaps_aspects contains "guitar", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- guitar · 3 ✖
- instrumental · 3 ✖
- percussion · 3 ✖
- moderate tempo 2
- no voices 2
- accordion song 1
- bass 1
- big band jazz 1
- double bass 1
- easy listening 1
- latin rhythm song 1
- low quality audio 1
- no voice 1
- piano 1
- pop rock 1
- reed instrument 1
- upbeat song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Los Paraguayos | This low quality audio features an accordion playing the main melody. This is accompanied by percussion playing a simple beat. A tambourine is played with the percussion. This is a Latin style song. The guitar plays groups of three ascending and one descending note per bar. The bass plays a Latin rhythm. There are no voices in this song. This song is an instrumental. This song can be played at a house party. | 2008-07-24T14:35:37Z | Spiciu | Performing their tune MANANTIAL - The Spring. | ["Accordion"] | ["latin rhythm song", "accordion song", "guitar", "percussion", "no voice", "instrumental", "bass", "low quality audio"] | 0 | QNQ3sAMxZPY | 2616 | |
Lunch an Animated Parable in HD (VeggieTales) | This jazz song features the main melody played on a reed instrument and a guitar in unison. The melody is an ascending pattern of three notes per beat. This is accompanied by percussion playing a simple beat ending on an extended drum roll. The bass plays a descending run followed by an ascending run. The piano plays jazz chords in the background. There are no voices in this instrumental song. This song can be played in a luxury bar. | 2011-01-19T20:35:07Z | Carlos Gonzalez | This Video is NOT made by me it was made by BigIdea Productions. Copyright BigIdea Productions. | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["big band jazz", "percussion", "no voices", "instrumental", "piano", "reed instrument", "guitar", "double bass", "moderate tempo", "easy listening"] | 0 | _miAGxDX5FM | 3489 | |
akira's fixed gear DVD called 'street life' teaser! | This pop rock song features a guitar riff being played. This guitar has a chorus effect added to the sound. Another guitar plays one chord in a three stroke grouping. The bass plays only one note throughout the song. This is accompanied by percussion playing a simple beat in common time. There are no voices in this song. This is an instrumental song. This song can be played in a movie with sports as the focus. | 2007-01-23T05:43:17Z | Kennicam | top leading skateboarders of T19 made a fixed gear DVD last year('06) its coming out this Feb. 07 check it out and witeness with your own eyes what its really like in tokyo bike scene that you probably dont know much about!!! | ["Funk", "Music"] | ["pop rock", "guitar", "percussion", "no voices", "instrumental", "moderate tempo", "upbeat song"] | 0 | lePP2BaZhJU | 4412 |
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;