musiccaps_details (view)
1 row where musiccaps_aspects contains "noisy", musiccaps_names contains "Rock music" 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_names (array), musiccaps_aspects (array)
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;