musiccaps_details (view)
5 rows where musiccaps_aspects contains "quiet", musiccaps_author = 4 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Van Canto - Battery (Official) | The Metal song features wide harmonizing hums in the background and repetitive harmonized mixed vocals singing over them. It sounds quiet and low quality as the mix is not very clean. | 2008-05-28T19:09:21Z | vancanto | Preorder the New Album "Break the Silence" now: http://goo.gl/09gSx Van Canto's incredible a capella cover version of Metallica's Battery. | ["Singing", "Music", "A capella"] | ["metal", "wide harmonizing hums", "repetitive harmonized mixed vocals", "low quality", "quiet"] | 4 | BEwNrjvNiYs | 1222 | |
| HT HAYKO VS MISHO (FULL)-(2:2) | The low quality recording features a trap song that consists flat male vocal, alongside widely spread male ad libs, rapping over arpeggiated, echoing synth melody, sustained and distorted synth melody, boomy 808 bass, punchy snare, soft kick hits, bouncy hi hats and shimmering open hats. There is a short snare roll at the end of the first part of the loop. It sounds quiet, but still energetic and exciting. | 2013-09-23T08:55:25Z | B Ⓡⓔⓚ | HT HAYKO-QUANSH 2 MISHO-ES EM MEXAVOR HT HAYKO-PROFESOR MARGARYAN MISHO-ENTATEQST | ["Music", "Rapping"] | ["low quality", "trap", "wide male ad libs", "arpeggiated echoing synth melody", "boomy 808 bass", "white noise down sweep", "flat male vocal", "punchy snare", "bouncy hi hats", "shimmering open hats", "soft kick hits", "quiet", "sustained distorted synth melody", "energetic", "exciting"] | 4 | BeFjxrUwAC4 | 1270 | |
| BOLERO fantasy [ Music: Maurice Ravel - Bolero / 10 min. version ] | The low quality recording features a synth key melody played over simple bass and snare rolls. It sounds happy and fun, while the recording is quiet, dull and muffled. | 2008-11-23T10:19:12Z | M. Laurens Bullstar | BOLERO-FANTASY 10min version [Music: Maurice Ravel - Bolero] | ["Music", "Sad music"] | ["low quality", "muffled", "snare rolls", "synth keys melody", "simple bass", "dull", "happy", "fun", "quiet"] | 4 | HOkuea1wExA | 1798 | |
| Aleko - Aria Of Zemfira | The low quality recording features a female opera vocalist singing over sustained strings. There is tinny metallic percussive foley at one point in the loop. It is a bit quiet, but it also sounds dynamic, emotional and passionate. | 2010-12-11T22:14:16Z | Joe Fenech | ["Music", "Opera"] | ["low quality", "orchestra", "opera", "female opera vocal", "sustained strings section", "quiet", "metallic percussive foley", "passionate", "emotional", "dynamic"] | 4 | bxoJOfGx3hM | 3668 | ||
| WAKE, RATTLE & ROLL Episode 2 part 1 | The low quality recording features a song that consists of harmonized children vocals singing over bouncy snare, saxophone solo melody, groovy bass, shimmering open hats and "4 on the floor" kick pattern. There are some laughing, high pitched tire screeches and car engine sound effects in the background. The recording is very noisy and the song is quiet and thin, as it lacks bass frequencies, but it still sounds fun and happy - like something you would hear in TV shows for kids. | 2008-10-08T19:05:34Z | Jack Box | A new episode! | ["Music", "Rattle (instrument)"] | ["low quality", "quiet", "noisy", "fun", "happy", "harmonized children vocals", "bouncy snare", "thin", "laughing", "car engine sound effects", "static tv sound effect", "high pitched tire screech", "saxophone solo melody", "groovy bass", "shimmering open hat", "4 on the floor kick"] | 4 | mQM3Fd3eN9E | 4470 |
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;