musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "crowd cheering", musiccaps_names contains "Music" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- crowd cheering · 4 ✖
- live performance 3
- amateur recording 2
- energetic 2
- 4 on the floor kick pattern 1
- acoustic drums 1
- bass 1
- boy band 1
- clapping 1
- concert 1
- crowd screaming 1
- electric guitar 1
- electric guitar melody 1
- engaging 1
- enthusiastic 1
- exciting 1
- falsetto voice 1
- fans 1
- fans going berserk 1
- fans going crazy 1
- fast paced percussion 1
- flat female vocal 1
- flat male vocal 1
- foreign language 1
- groovy bass line 1
- guitar sounds 1
- hit song 1
- k-pop 1
- live audience 1
- lively piano 1
- …
musiccaps_names (array) 10 ✖
- Music · 4 ✖
- Pop music · 4 ✖
- Music of Asia 2
- Singing 2
- Bang 1
- Crowd 1
- Funk 1
- Independent music 1
- Rapping 1
- Thump, thud 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
101.9 For Life launches new radio station jingle | The low quality recording features a live performance of a pop song and it consists of flat female and male vocal rapping over "4 on the floor" kick pattern and electric guitar melody. There are some crowd clapping and cheering noises in the background. It sounds exciting and energetic. | 2013-07-07T07:39:40Z | ABS-CBN News | FM radio station M.O.R. 101.9 For Life! Manila launched its official station jingle on "ASAP 18" on Sunday ahead of its launch on Monday, July 8, starting at 5 a.m. | ["Singing", "Music of Asia", "Music", "Pop music"] | ["low quality", "clapping", "crowd cheering", "pop", "live performance", "flat male vocal", "flat female vocal", "4 on the floor kick pattern", "electric guitar melody", "exciting", "energetic"] | 4 | HEhogaw0vUg | 1782 | |
Matt Hetherington's "Michael Jackson & Luciano Pavarotti" Act | This amateur recording starts off with the sound of the crowd at a live show. This is followed by a male voice mouthing four blasting sounds over the mic. This is followed by a guitar playing a funk riff and another guitar playing a lower register melody. The percussion plays a fast beat. The bass plays only one note in a continuous pattern following the percussion. The mood of this song is upbeat. This song can be played in a retro club. | 2008-01-23T08:34:42Z | Matty Heth | Matt Hetherington devised this as part of his live act. It's being performed at Melbourne's Forum Theatre. | ["Music", "Pop music", "Thump, thud"] | ["amateur recording", "crowd cheering", "falsetto voice", "vocables", "guitar sounds", "fast paced percussion", "bass", "moderate tempo", "upbeat song"] | 0 | MMGAKKhqxKg | 2259 | |
BTOB - Beep Beep (Feb 20, 2014) | A male vocalist sings this melodious pop song. The tempo is medium with piano accompaniment, rhythmic acoustic guitar, groovy bass line ,steady drumming and energetic vocal backup. The song is spirited, youthful, vivacious, popular, bright and engaging. The song is a live performance and there are sounds of people cheering, hooting hysterically and singing along. This song is a hit in K-Pop. | 2014-02-21T07:07:36Z | Minhyuk ครับผม | 140220 BTOB - Beep Beep @ M Countdown Comeback Stage | ["Music of Asia", "Funk", "Music", "Independent music", "Pop music", "Rapping"] | ["male singer", "foreign language", "medium tempo", "youthful", "engaging", "energetic", "enthusiastic", "vibrant vivacious", "concert", "teen pop", "k-pop", "live performance", "concert", "live audience", "enthusiastic", "crowd cheering", "crowd screaming", "fans", "fans going crazy", "fans going berserk", "popularity", "hit song", "boy band", "melodious", "steady drumming", "lively piano", "groovy bass line"] | 7 | cADT8fUucLQ | 3686 | |
Burning Up - Jonas Brothers - Jingle Ball 2012 | This is the live performance of a pop music piece. It is an amateur recording. There are male vocals singing melodically. An electric guitar strums a chord for the ending of a song while the sounds of the cymbals can be heard from the acoustic drums. The cheers of the crowd can be heard even more than the music itself. This recording could be sampled for use in beat-making. | 2012-12-03T00:47:17Z | Marielle Bravo-Saltzman | Last song performed by Jonas Brothers at Jingle Ball 2012 | ["Singing", "Crowd", "Music", "Pop music", "Bang"] | ["pop music", "live performance", "amateur recording", "male vocals", "melodic singing", "electric guitar", "acoustic drums", "crowd cheering"] | 9 | qxWVr67g6yY | 4839 |
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;