musiccaps_details (view)
3 rows where musiccaps_aspects contains "distortion guitars" and musiccaps_aspects contains "fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- distortion guitars · 3 ✖
- fast tempo · 3 ✖
- aggressive percussion 1
- angry voice 1
- bass 1
- cartoon voices 1
- cartoon whistles 1
- chimes 1
- dance music 1
- fast paced drumming 1
- female voices 1
- happy mood 1
- heavy metal song 1
- low quality recording 1
- male voice 1
- percussion 1
- pop song 1
- punk rock 1
- quirky sounds 1
- shrieking voice 1
- sped up song 1
- upbeat song 1
musiccaps_names (array) 7 ✖
- Music 3
- Angry music 1
- Buzz 1
- Dubstep 1
- Exciting music 1
- House music 1
- Pop music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mouse Skull | This is a low quality recording of a sped up song. The song features voices that have reached a high pitch of singing due to the sped up tempo. This is accompanied by percussion playing at a fast tempo. Distortion guitars are playing power chords but are now at a higher pitch due to speeding up the song. The bass plays the root notes of the chords. The song has a quirky mood. It can be used in a comedy movie. | 2006-08-29T23:23:21Z | FeindFactory | this is was our first fully animated project that we drew ourselves, our experiment, we only used paint and windows movie maker, the bottom of the barrel, to see if we could. The Song: Skulls by The Misfits. hope you enjoy it! | ["House music", "Music", "Buzz", "Dubstep"] | ["punk rock", "sped up song", "cartoon voices", "distortion guitars", "low quality recording", "fast paced drumming", "fast tempo"] | 0 | UoGXR3V5Mro | 2944 | |
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 | ||
Killing Me Inside LYRIC - DIARY OF PAST AWAY | This heavy metal song features a male voice singing the main melody. This voice sings in an angry tone. The voice is shrieking. This is accompanied by percussion playing an aggressive rock beat. The distortion guitar plays a riff which starts off on the root note and then plays higher notes in the scale descending back to the root note. The bass plays the root notes of the chords. The mood of this song is anger. This song can be played in an action sequence in a movie. | 2008-12-22T20:38:06Z | dieartproduction | KILLMS NEW Song FRom THeir New ALBUM DIARY Of PASt AWAY | ["Music", "Angry music"] | ["heavy metal song", "shrieking voice", "male voice", "angry voice", "distortion guitars", "aggressive percussion", "bass", "fast tempo"] | 0 | s7VkXHiULz8 | 4927 |
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;