musiccaps_details (view)
3 rows where musiccaps_aspects contains "bassline" and musiccaps_aspects contains "low quality recording"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- bassline · 3 ✖
- low quality recording · 3 ✖
- male voice 2
- moderate tempo 2
- amateur recording 1
- chorus effect on guitar 1
- cymbals 1
- distortion guitar 1
- guitar arpeggios 1
- instrumental 1
- metal song 1
- multiple guitars 1
- no voices 1
- out of time guitar 1
- power drumming 1
- romantic theme 1
- simple percussion 1
- slow rock 1
- slow tempo 1
- soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Barry White - My first my last my everything (traduzione italiano) | This song features a male voice singing the main melody. The quality of recording is low. The musical instruments are not clearly distinguishable. The voice is accompanied by simple percussion playing in common time. The bass plays a soul type groovy bassline. This song is romantic. This song can be used in a romantic movie. | 2012-10-27T12:30:14Z | OffLimits27 | ["Music", "Pop music", "Rhythm and blues"] | ["low quality recording", "male voice", "bassline", "simple percussion", "soul music", "romantic theme", "moderate tempo"] | 0 | 75_dMqpSM4o | 810 | ||
Guitar Hero | This clip features 2 distortion guitars playing a metal song. A high pitched male voice sings the main melody. This is accompanied by percussion playing a simple rock beat in common time. A bass guitar plays a bassline with a descending run. The distortion guitars play power chords followed by a guitar lick. One of the guitars plays one chord a little after the other guitar making it sound dissonant. This song can be played in an action movie. | 2006-04-25T16:32:40Z | Kim Burkart | Two Dudes Playing Guitar Hero | ["Guitar", "Music", "Musical instrument", "Roll", "Plucked string instrument"] | ["low quality recording", "metal song", "distortion guitar", "multiple guitars", "bassline", "power drumming", "male voice", "out of time guitar", "moderate tempo"] | 0 | dVUgd8ot6BE | 3794 | |
LIQUID SKY PART 1 | This slow rock song features a guitar playing arpeggiated chords. The guitar has added effects of chorus and reverb. The bass plays a descending run in the scale of the chords. The percussion plays the different cymbals one after the other. The recording quality is low. There are no voices in this song. This song can be played in a dreamy sequence of a movie. | 2006-09-22T14:19:13Z | SGGURU | Gary Skopick on guitar, Victor Salazar on drums, and Trace Cronin on bass guitar. Another original song recorded in our studio, while practicing for the Synergy II gig July 27, 2006. | ["Music", "Squish"] | ["slow rock", "amateur recording", "low quality recording", "cymbals", "guitar arpeggios", "bassline", "instrumental", "no voices", "slow tempo", "chorus effect on guitar"] | 0 | wL4HaT8rEVU | 5256 |
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;