musiccaps_details (view)
1 row where search matches "guitar", musiccaps_author = 2 and musiccaps_names contains "Yell" sorted by musiccaps_rowid
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 8 ✖
musiccaps_names (array) 3 ✖
- Inside, large room or hall 1
- Music 1
- Yell · 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988) | The rock music features a screaming male voice singing a melody. One of the electric guitars accompanies the singer with strummed chords while the other, for the second part of the music excerpt, plays a melody. Both guitars have a distortion effect on. The drums play a well grounded rhythm and together with the bass guitar drive the pulse of the music. The quality of the audio recording is not that good, most probably this is an old live recording. | 2009-02-27T12:49:06Z | Christo Toupa | Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988). | ["Music", "Yell", "Inside, large room or hall"] | ["low quality audio recording", "rock genre", "screaming male voice", "electric guitars", "distortion effect", "drums", "bass guitar", "live recording"] | 2 | qie2k2gZ7wA | 4809 |
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;