musiccaps_details (view)
5 rows where "youtube_published" is on date 2010-11-11
This data as json, CSV (advanced)
Suggested facets: musiccaps_author, youtube_published (date)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Hinder - 2 Sides of Me | The song is an instrumental. The song is slow tempo with a keyboard harmony, grunge tone, guitar playing lead , screaming vocals and no percussion. The song is psychedelic and very sci-fi like in nature. The song audio quality is average. | 2010-11-11T01:37:20Z | ArenaGames2010 | 2 Sides of Me from the new album All American Nightmare coming out December 7th this year. | ["Music", "Angry music"] | ["instrumental music", "sci-fi", "screaming tones", "distorted guitar lead", "average audio quality", "futuristic", "doomsday", "apocalypse", "song introduction", "building tension", "gripping", "adrenaline rush", "nightmarish landscape", "electronic dance music", "psychedelic", "mind games", "slow tempo", "building anticipation", "low pitched harmony", "grunge low tones", "emotional", "scary", "eerie", "alien landscape", "keyboard harmony", "tense"] | 1 | Dk7ziLlNfeM | 1507 | |
| Worship Central // Guitar Tutorial // Atmosphere | This is an ambient jam performed on an electric guitar. The electric guitar is being played with an effect applied to it. There is a male voice describing the sound. The parts where he is not speaking could be sampled for use in beat-making. | 2010-11-11T11:56:30Z | Worship Central | ["Guitar", "Music", "Musical instrument", "Theremin", "Speech", "Plucked string instrument", "Inside, small room"] | ["jam", "ambient", "electric guitar", "male voice", "instructive speaking"] | 9 | NoB_4XaZYVs | 2367 | ||
| jodee frawlee melodic shredding in A harmonic minor/ Aminor | The excerpt features an electric guitar with a distortion effect on playing what sounds to be an improvised passage. The style comes closest to the rock genre. The lower quality of the audio recording coupled with string noises makes me think this is an amateur recording, most probably recorded with a phone. | 2010-11-11T00:32:32Z | jodee Frawlee | Just some shredding w/ an idea I have for a future song | ["Tapping (guitar technique)", "Effects unit", "Electric guitar", "Guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "distortion effect", "improvisation", "rock genre", "string noise", "low quality audio recording"] | 2 | XrjkzI6TVwc | 3229 | |
| Alessandra Belloni LESSON 1: Tarentella, Pizzica Tarantata | This audio contains someone playing a complex and fast rhythm on the tambourine. Also playing percussive. This song may be playing at a traditional ceremony. | 2010-11-11T00:31:24Z | BrooklynBikeBeat | Alessandra Belloni teaches and plays the healing trance dance known as Pizzica Tarantata | ["Music", "Musical instrument", "Tambourine", "Percussion"] | ["amateur recording", "tambourine", "fast tempo"] | 6 | lfCWGQ6URds | 4414 | |
| 요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel _ 목장주인김원섭 _ 박진아 | A male singer sings with a female backup singer in vocal harmony. The song is medium tempo with a yodelling medley and guitar strumming rhythm and no other instrumentation. The song is exciting and passionate. The song has poor audio quality. | 2010-11-11T11:53:45Z | 목장주인tv | 요들송 _ 키스 요들 _ Kuss Jodle _ Kiss Yodel 2009.5.7. 성남아트센터 김원섭(010-4061-6404)의 '나눔의 열린 음악회'중에서 kmwonseop@hanmail.net | ["Singing", "Chant", "Music", "Vocal music"] | ["male and female singer", "yodelling melody", "poor audio quality", "clapping percussions", "dance rhythm", "spirited", "traditional music", "guitar accompaniment", "acoustic song", "traditional folk song", "folk singers", "live performance", "live audience", "ambient room noises", "hissing sounds", "exciting", "emotional", "medium tempo", "people clapping"] | 1 | m9MQdg0k1t0 | 4448 |
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;