musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "bass guitar" and musiccaps_names contains "Yell" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- bass guitar · 2 ✖
- acoustic drums 1
- amateur recording 1
- crowd cheering 1
- distorted electric guitar 1
- distortion effect 1
- drums 1
- electric guitars 1
- heavy metal 1
- live performance 1
- live recording 1
- low quality audio recording 1
- poor quality 1
- rock genre 1
- screaming 1
- screaming male voice 1
musiccaps_names (array) 4 ✖
- Music 2
- Yell · 2 ✖
- Inside, large room or hall 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Metallica - For Whom The Bell Tolls @ Foro Sol Mexico DF 6 Junio 2009 | This is an amateur recording of heavy metal music being performed live. The audio quality is quite poor. There is a distorted electric guitar playing the main tune while the bass guitar is playing in the background. There is a simple metal acoustic drum beat in the rhythmic background. Sounds from the crowd cheering and screaming can be heard. | 2009-06-07T19:08:34Z | shinjiayanami | Metallica interpretando la cancion de For Whom The Bell Tolls el pasado 6 de Junio de 2009 en la ciudad de Mexico DF en el Foro Sol | ["Music", "Rock music", "Yell"] | ["amateur recording", "poor quality", "heavy metal", "live performance", "distorted electric guitar", "bass guitar", "acoustic drums", "crowd cheering", "screaming"] | 9 | AaUZb-iRStE | 1138 |
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;