musiccaps_details (view)
3 rows where musiccaps_aspects contains "no voices", musiccaps_aspects contains "percussion" and musiccaps_names contains "Percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- no voices · 3 ✖
- percussion · 3 ✖
- instrumental 2
- low quality audio 2
- moderate tempo 2
- big band jazz 1
- double bass 1
- easy listening 1
- fantasy mood 1
- fast tempo 1
- guitar 1
- lead guitar 1
- marimba melody 1
- piano 1
- reed instrument 1
- rock and roll 1
- timpani 1
musiccaps_names (array) 12 ✖
- Percussion · 3 ✖
- Music 2
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Musical instrument 1
- Pop music 1
- Pulse 1
- Rimshot 1
- Snare drum 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Pulse Percussion 2014 - That Which Confines Us | This is low quality audio and all instruments are not heard clearly. The main melody is played on a marimba. This is accompanied by a timpani. Another drum set is used to play percussion with the focus on the snare and hi-hat. After the marimbas pause, one marimba plays a soft melody. This song does not feature any vocals. This song can be played in a fantasy sequence in a movie. | 2014-04-14T02:57:52Z | Jason Choo | All credit goes to Pulse Percussion and WGI. This video is for educational purposes only. This video is covered for copyright infringement under the Fair Use Act. | ["Traditional music", "Music", "Percussion"] | ["low quality audio", "marimba melody", "timpani", "percussion", "no voices", "moderate tempo", "fantasy mood"] | 0 | 2kY_ZG78V-g | 403 | |
Masonics - Outside Looking In | This low quality audio features an electric guitar playing a solo. The sounds of the instruments are not clear due to the low audio quality. The percussion plays a fast beat in the background. There are no voices in this song. This song can be played in a car chase sequence in a movie. | 2006-12-12T13:44:19Z | beatsvillerecords | The Masonics perform "I'm on the Outside Looking In" at "The Cluny" in Newcastle-Upon-Tyne. | ["Music", "Musical instrument", "Pop music", "Pulse", "Percussion"] | ["rock and roll", "low quality audio", "percussion", "lead guitar", "no voices", "instrumental", "fast tempo"] | 0 | YqAsph_ouRM | 3314 | |
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 |
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;