musiccaps_details (view)
2 rows where search matches "guitar" and "youtube_published" is on date 2009-09-11
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- acoustic drums 1
- addictive 1
- e-bass 1
- electric guitar chords 1
- groovy 1
- guitar 1
- high register voice 1
- low quality 1
- medium to uptempo 1
- mood elevating 1
- passionate 1
- piano 1
- pop 1
- punchy snare 1
- reverberant passionate female vocal 1
- smooth bass guitar 1
- straight piano melody 1
- wide brass melody 1
- wide harmonizing male vocals 1
- wide shimmering hi hats 1
- yodel/folkmusic 1
- yodeling 1
musiccaps_names (array) 4 ✖
- Music 2
- Country 1
- Vocal music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cry Baby Soundtrack - Teardrops Are Falling | The low quality recording features a pop song that contains a passionate female vocal, alongside wide harmonizing male vocals, singing over wide brass melody, electric guitar chords, straight piano melody, punchy snare and smooth bass guitar. It sounds groovy, addictive and passionate. | 2009-09-11T13:34:33Z | MortRaineyFan | Cry Baby Soundtrack - Teardrops Are Falling. :) | ["Music", "Vocal music"] | ["low quality", "pop", "wide harmonizing male vocals", "wide shimmering hi hats", "wide brass melody", "electric guitar chords", "straight piano melody", "reverberant passionate female vocal", "punchy snare", "smooth bass guitar", "groovy", "addictive", "passionate"] | 4 | 46WpyRUqwXU | 539 | |
TechnoNeotorand - He taught me to yodel with lyrics (Full version) | The e-bass is playing an almost walking line along with a guitar playing a melody on top. The acoustic drums are playing a constant rhythm along with a piano playing one chord on the offbeat. The yodeling voice sings in a higher pitch and sounds amused. This song may be playing at a local folk festival. | 2009-09-11T13:35:43Z | TechnoNeotorand | full version with the fast part ! | ["Country", "Yodeling", "Music"] | ["yodel/folkmusic", "e-bass", "piano", "acoustic drums", "yodeling", "high register voice", "guitar", "mood elevating", "medium to uptempo"] | 6 | L_fWnna7Np0 | 2199 |
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;