musiccaps_details (view)
4 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "percussion" and musiccaps_author = 0
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- fast tempo · 4 ✖
- percussion · 4 ✖
- low quality audio 2
- rock and roll 2
- bass 1
- call and response style 1
- cartoon whistles 1
- chimes 1
- cowbell sound 1
- crowd singing 1
- dance music 1
- distortion guitars 1
- drum solo 1
- female voices 1
- gospel style 1
- guitars 1
- happy mood 1
- instrumental 1
- lead guitar 1
- male voice 1
- no other instruments 1
- no vocal melody 1
- no voices 1
- pop song 1
- quirky sounds 1
- upbeat song 1
musiccaps_names (array) 13 ✖
- Music 3
- Percussion 2
- Pop music 2
- Bass drum 1
- Cowbell 1
- Drum 1
- Drum kit 1
- Exciting music 1
- Musical instrument 1
- Pulse 1
- Rimshot 1
- Snare drum 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bon Jovi - Shout. 6 November 2010 Madrid | This rock and roll song features a male voice singing the main melody. This is accompanied by percussion playing a fast tempo beat. Guitars play chords. The bass plays the root notes of the chords. The vocal melody follows a gospel style call and response theme. The main voice sings one line and the crowd responds by singing another line. The tempo of this song is fast. This is a low quality audio and other instruments cannot be identified. | 2010-11-07T12:53:34Z | Christian Gamdek | Bon Jovi - Shout. 6 November 2010 Madrid Recorded by The Red Scarf Girl PHOTOS: http://www.facebook.com/album.php?aid=243743&id=574951338&l=9986f2817b | ["Music", "Yell"] | ["rock and roll", "low quality audio", "male voice", "bass", "percussion", "gospel style", "crowd singing", "guitars", "call and response style", "fast tempo"] | 0 | SGcjdZ19R1k | 2755 | |
World Cup Twinkles 2009 Music | This pop song features female voices singing the main melody. This is accompanied by fast paced drumming. The percussion plays a simple fast paced beat in common time. Distortion guitars play power chords. The bass plays the root notes of the chords. There are quirky sounds played in the background. A cartoon whistle is played in the background. A triangle is also heard in the background. There is the sound of a cartoon laser blast in the background. The mood of the song is happy. This song can be played during the end credits of a college comedy movie. | 2013-11-01T20:57:11Z | WorldCupAllstarCheer | ["Music", "Pop music", "Exciting music"] | ["pop song", "female voices", "quirky sounds", "chimes", "fast tempo", "cartoon whistles", "percussion", "distortion guitars", "upbeat song", "dance music", "happy mood"] | 0 | UvCY9FHpKC8 | 2955 | ||
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 | |
rodney holmes amazing cowbell groove slo-mo | This song features a drum solo. The drum solo has the accents on the cowbell. The tempo of this song is fast. The hi-hat accentuates the counts and is played in eighth note pattern. There are no other instruments in this song. This song can be played in an instructional video. | 2012-01-15T11:53:43Z | Jannes Oosterwijk | rodney holmes doin' this amazing groove cowbell groove. Includes the slo-mo credits go to drummerworld dot com | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["percussion", "cowbell sound", "drum solo", "no other instruments", "no vocal melody", "fast tempo"] | 0 | pdOskdFwRPg | 4729 |
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;