musiccaps_details (view)
7 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "melodic singing" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- acoustic drums · 7 ✖
- melodic singing · 7 ✖
- bass guitar 6
- electric guitar 5
- acoustic guitar 3
- easygoing 3
- female vocal 3
- live performance 2
- male vocal 2
- male vocals 2
- pop music 2
- simple tune 2
- albanian pop music 1
- alternative rock 1
- amateur recording 1
- banjo 1
- boy band 1
- christian pop 1
- clarinet 1
- compilation 1
- country pop 1
- crowd cheering 1
- crowd singing 1
- electric guitat 1
- emotional 1
- energetic 1
- gentle 1
- harmonica 1
- korean indie rock 1
- lively 1
- major key 1
- mellow 1
- normal tempo 1
- poor quality 1
- positive 1
- religious 1
- rock music 1
- slow tempo 1
- sound effects 1
- teen male vocal 1
- thai 1
- uplifting 1
musiccaps_names (array) 16 ✖
- Pop music · 7 ✖
- Music 6
- Singing 5
- Bang 2
- Independent music 2
- Song 2
- Banjo 1
- Christian music 1
- Crowd 1
- Guitar 1
- Heavy metal 1
- Mandolin 1
- Musical instrument 1
- Progressive rock 1
- Swing music 1
- Tick-tock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SHeDAISY - Don't Worry Bout a Thing - Official Video | This is a country pop music piece. There is a female vocalist singing melodically as the lead. The melody comprises various elements such as the electric guitar, the bass guitar, the harmonica and the banjo. There is a rock acoustic drum beat in the rhythmic background. The atmosphere is easygoing. This piece could be the opening theme of a teenage sit-com. | 2007-10-13T01:18:33Z | shedaisymusic | Music video. | ["Singing", "Banjo", "Music", "Mandolin", "Pop music"] | ["country pop", "female vocal", "melodic singing", "harmonica", "electric guitar", "bass guitar", "acoustic drums", "banjo", "simple tune", "easygoing"] | 9 | A8CJ4YSsUgs | 1071 | |
7 o'clock Teaser นี่เธอไม่รู้หรือแกล้งไม่รู้ | This is a rock music piece. It starts with a clock. There is a female vocalist singing melodically in the Thai language. The overdriven electric guitar is strumming the chords of the main tune while the bass guitar is supporting it in the background. The acoustic drum is playing a simple but powerful beat. The general atmosphere is energetic. The piece can be used as a soundtrack in a coming-of-age drama taking place in Thailand. | 2009-09-03T06:40:52Z | Chanin Yanyong | The complete teaser of 7 o'clock นี่เธอไม่รู้หรือแกล้งไม่รู้ | ["Heavy metal", "Music", "Independent music", "Pop music", "Tick-tock", "Progressive rock"] | ["rock music", "thai", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "normal tempo", "sound effects", "energetic"] | 9 | B1beLwV4yzw | 1193 | |
Harry + Louis || OTRA Tour PART 10 || Larry Stylinson | This is the compilation of live performances from a pop music boy band. There are teen male vocalists singing melodically. The melody is being played by an acoustic guitar and a bass guitar while an acoustic drum beat is playing in the rhythmic background. There are sounds of a crowd singing and cheering. The recording quality is poor. | 2015-06-17T11:19:42Z | TheVickylove90 | Watch in HD!! Sometimes I have the doubt that they're not a couple, but then they look at each other, they're not just friend ;) Hope you like the video !! xoxo PART 1 https://www.youtube.com/watch?v=lg1nF... PART 2 https://www.youtube.com/watch?v=JORQM... PART 3 https://www.youtube.com/watch?v=KZLGl... PART 4 https://www.youtube.com/watch?v=1AwHQ... PART 5 https://www.youtube.com/watch?v=knHl-... PART 6 https://www.youtube.com/watch?v=Blu_R... PART 7 https://www.youtube.com/watch?v=Zb8YN... PART 8 https://www.youtube.com/watch?v=zvILN... PART 9 https://www.youtube.com/watch?v=4iio1oYeQI0 PART 11 https://www.youtube.com/watch?v=098Fv2j-c2M PART 12 https://www.youtube.com/watch?v=3VIM2e5TP0A&feature=youtu.be PART 13 https://www.youtube.com/watch?v=uw9fjCNrbx0 PART 14 https://www.youtube.com/watch?v=jTGQAklkr4M Harry Styles + Louis Tomlinson Larry Stylinson One Direction Program Sony Vegas Pro 13 | ["Singing", "Music", "Pop music", "Bang"] | ["live performance", "pop music", "boy band", "teen male vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "crowd singing", "emotional"] | 9 | OvjmfGU4y_M | 2481 | |
Christian Music Mix #2, 19 songs!! | This is a poor quality Christian pop music compilation. There are many pieces sung by male and female voices melodically. The usual theme of the instrumental backing consists of a tune played in major key by an electric guitar and a bass guitar alongside a simple acoustic drum beat. The overall atmosphere is uplifting. This mix could be used in a movie to imply the sounds coming from a gospel radio station in passing. | 2009-04-13T01:50:06Z | AudioMan62 | This is The second installment of my christian music mix. be sure to listen my first one! enjoy! Made about 2002. | ["Christian music", "Guitar", "Music", "Musical instrument", "Pop music", "Song"] | ["compilation", "poor quality", "christian pop", "male vocal", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "major key", "positive", "uplifting", "religious"] | 9 | RPqz3vJYMLQ | 2697 | |
ROSE N FLY after MV (korea indie band) | This is a Korean indie rock piece. There is a male vocalist in the lead singing melodically. The main tune is being played by an acoustic guitar with an electric guitar and a bass guitar backing. There is a 4/4 slow tempo acoustic drum beat playing in the rhythmic background. The atmosphere is easygoing. This piece could be used in the soundtrack of a drama movie or TV series that takes place in Korea. | 2010-12-19T12:14:19Z | ROSE N FLY LAUS DEO | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["korean indie rock", "alternative rock", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "gentle", "mellow", "easygoing", "simple tune", "slow tempo"] | 9 | cnvmLwFZr28 | 3742 | ||
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 | |
Klajdi Haruni - O bo bo (Kenga Magjike 2015) | This is an Albanian pop music piece. There are male vocals singing melodically in the Albanian language. The main theme is being played on the clarinet while there is a melodic backing composed of the acoustic guitar, the electric guitar and the bass guitar. The rhythm is provided by a laid-back acoustic drum beat. The atmosphere is lively. This piece could be used as an opening theme for an Albanian sit-com. | 2015-11-17T17:00:02Z | KlajdiHaruniVEVO | Music video for O bo bo (Kenga Magjike 2015) performed by Klajdi Haruni. Site: http://www.threedots.al Facebook: https://www.facebook.com/klajdiharunithreedots?fref=ts Copyright (C) 2015 Threedots Production. http://vevo.ly/fQQQYu | ["Singing", "Swing music", "Pop music"] | ["albanian pop music", "male vocals", "melodic singing", "clarinet", "acoustic guitar", "electric guitat", "bass guitar", "acoustic drums", "easygoing", "lively"] | 9 | t5fW1-6iXZY | 5004 |
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;