musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_names contains "Pop music" and musiccaps_names contains "Yell" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 40 ✖
- adventurous 1
- amateur recording 1
- ambient crowd noises 1
- background cheering and screaming 1
- bad audio quality 1
- breakup song 1
- crowd whistles 1
- distortion guitar 1
- diva 1
- e-bass 1
- e-guitar 1
- electric rhythm guitar playing 1
- exciting 1
- female guitarist 1
- female voice 1
- guitar solo 1
- hard rock 1
- harmony 1
- home video 1
- instrumental music 1
- live concert video 1
- live performance 1
- male voices singing 1
- medium fast tempo 1
- medium fats tempo 1
- moderate tempo 1
- people cheering 1
- people screaming 1
- percussion 1
- percussive bass line 1
- poor audio recording 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- rock song 1
- rock&roll 1
- testosterone driven 1
- upbeat melody 1
- uplifting mood 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 3
- Pop music · 3 ✖
- Yell · 3 ✖
- Guitar 1
- Inside, large room or hall 1
- Music of Asia 1
- Singing 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
The Beatles - Twist and Shout, Live manchester 1963 | Two male voices are singing loudly together: One backing the other one. A e-guitar can be heard at the end of the phrase. In the background a e-bass and an acoustic drum can be heard but they get overthrown by the sound of the cheering and Screaming crowd. This song may be playing at a live concert. | 2014-05-27T15:54:55Z | Tesla Academy | Twist and Shout in HD | ["Music of Asia", "Music", "Pop music", "Yell"] | ["rock&roll", "male voices singing", "harmony", "background cheering and screaming", "e-bass", "e-guitar", "moderate tempo", "uplifting mood"] | 6 | kjcXM60HrRA | 4349 | |
Joan Jett----I Hate Myself For Loving You | This song is an amateur recording of a live performance. This features a female voice singing the main melody. This is accompanied by a distortion guitar playing power chords. The percussion plays a simple rock beat. The sound of crowd whistles are heard in this clip. Other instruments are not audible as the quality of the audio is low. This song can be played in a romantic comedy movie. | 2007-05-13T16:08:35Z | rro003 | Joan Jett concert May 2007 | ["Singing", "Music", "Pop music", "Yell"] | ["amateur recording", "female voice", "crowd whistles", "distortion guitar", "percussion", "rock song", "breakup song", "upbeat melody"] | 0 | naZE-MvNpaI | 4558 |
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;