musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "amateur recording" and youtube_description = "Marco e Roberto unem-se a Joao Cassio e Benedito em sua banda para tocar "Floyd The Barber", do Nirvana. Marco and Roberto unite with Joao Cassio and Benedito on their band to play "Floyd The Barber", of Nirvana."
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 12 ✖
- acoustic drums 1
- aggressive 1
- amateur recording · 1 ✖
- bass guitar 1
- cover 1
- distorted electric guitar 1
- grunge rock 1
- grunt-like singing 1
- male vocal 1
- noisy 1
- poor quality 1
- rebellious 1
musiccaps_names (array) 4 ✖
- Music 1
- Musical instrument 1
- Pulse 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Banda - Floyd The Barber (Nirvana) | This is an amateur cover of a grunge rock music piece. Both the recording and the playing are of poor quality. There is a male vocalist singing in a grunt-like manner as the lead. A crunchy riff is being played by the distorted electric guitar and the bass guitar while the acoustic drums are playing a simple rock beat. The atmosphere is rebellious and noisy. | 2006-12-04T17:57:48Z | drugstoremarc | Marco e Roberto unem-se a Joao Cassio e Benedito em sua banda para tocar "Floyd The Barber", do Nirvana. Marco and Roberto unite with Joao Cassio and Benedito on their band to play "Floyd The Barber", of Nirvana. | ["Music", "Musical instrument", "Rock music", "Pulse"] | ["cover", "amateur recording", "poor quality", "grunge rock", "male vocal", "grunt-like singing", "distorted electric guitar", "bass guitar", "acoustic drums", "rebellious", "aggressive", "noisy"] | 9 | oPiyXhxRGe4 | 4626 |
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;