musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "emotional" and musiccaps_author = 6
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 15 ✖
- acoustic guitar · 3 ✖
- emotional · 3 ✖
- acoustic drums 1
- country/pop/singersongwriter 1
- female voice singing 1
- flamenco 1
- higher register 1
- male singer 1
- male voice singing 1
- medium tempo 1
- melancholic 1
- piano 1
- pop/rock/ singer-songwriter 1
- sensual 1
- soulful 1
musiccaps_names (array) 9 ✖
- Music 3
- /t/dd00003 1
- Guitar 1
- Independent music 1
- Musical instrument 1
- Opera 1
- Plucked string instrument 1
- Song 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Robert Pattinson singing live " I was broken" | The male mid to high range voice sings loudly and full of emotions pouring out of his soul while strumming some minor chords on the guitar. This recording is of poor quality. This song may be played in an open mic, poetry bar. | 2009-06-22T02:39:38Z | pinkstarvero08 | Robert Pattinson singing live " I was broken"this song it by far my fav song from rob..LOVE IT..and PLZ sub,rate and comment!! | ["Music", "/t/dd00003"] | ["country/pop/singersongwriter", "acoustic guitar", "male singer", "emotional", "soulful"] | 6 | 0cNYPgD6cEA | 192 | |
BOLEROS CON GUITARRA FLAMENCA | Someone is playing an acoustic guitar flamenco style finger-picking while a female voice sings loud and emotionally. This song may be playing live in a restaurant. This is an amateur recording. | 2012-10-31T16:51:52Z | Olga Chito | NANI CANTANDO, Y JONI A LA GUITARRA | ["Guitar", "Music", "Musical instrument", "Opera", "Strum", "Plucked string instrument"] | ["flamenco", "acoustic guitar", "female voice singing", "sensual", "emotional"] | 6 | OjoDuBkPDM8 | 2463 | |
Hästpojken Gitarrer & Bas, Trummor & Hat | The male voice singing sounds emotional and sad while a piano is playing a minor chord progression along with an acoustic guitar strumming chords. Then a fat sounding acoustic drum comes in with a simple groove along with an e-bass. This song may be playing on headphones while sitting in the bus riding downtown being lost in thoughts. | 2009-11-26T17:51:55Z | TussilagoSwe | Hästpojken Gitarrer & Bas, Trummor & Hat. Musikvideo: Tussilago, Theo Gabay Skivbolag: Roxy Recordings | ["Music", "Independent music", "Song"] | ["pop/rock/ singer-songwriter", "piano", "acoustic guitar", "acoustic drums", "male voice singing", "higher register", "emotional", "melancholic", "medium tempo"] | 6 | qRCjs90-1RQ | 4784 |
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;