musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "pop" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- passionate · 2 ✖
- pop · 2 ✖
- youthful · 2 ✖
- break the tension 1
- building anticipation 1
- buzz 1
- classic pop 1
- distorted amplified guitar 1
- drum roll 1
- electric guitar 1
- electrostatic sounds 1
- emotional 1
- enthusiastic 1
- enthusiastic drumming 1
- exciting 1
- female vocalist 1
- first love 1
- get tones 1
- groovy bass line 1
- guitar strumming 1
- heart beat melody 1
- indonesian pop 1
- k-pop 1
- keyboard harmony 1
- korean rock band 1
- love song 1
- male singer 1
- medium fast tempo 1
- melodious 1
- percussive bass line 1
- pop dance rhythm 1
- pop dance song 1
- rhythmic acoustic guitar 1
- romantic 1
- sentimental 1
- signal tempo 1
- spirited 1
- storm cloud noises 1
- straight drumming 1
- synthesiser 1
- tambourine beats 1
- teen spirit 1
- vivacious 1
- vivid 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LG톤플러스 CF 국카스텐 하현우 'Sound change music video' 편 | A male singer sings this youthful k-pop song. The tempo is fast with a heartbeat rhythm, electro static sounds, electric buzz, followed by a fast paced drum rhythm, guitar accompaniment and a groovy bass line. The song is groovy and very youthful. | 2016-07-13T23:02:19Z | LG전자 Library | 복면가왕 음악대장 국카스텐 하현우가 들려주는 톤플러스의 블루투스 세계최초 24비트 놀라운 사운드를 뮤직비디오형식으로 표현 | ["Music", "Exciting music"] | ["heart beat melody", "male singer", "k-pop", "storm cloud noises", "electrostatic sounds", "buzz", "signal tempo", "drum roll", "enthusiastic drumming", "guitar strumming", "distorted amplified guitar", "percussive bass line", "pop", "pop dance rhythm", "pop dance song", "get tones", "korean rock band", "exciting", "building anticipation", "break the tension", "youthful", "exciting", "teen spirit", "enthusiastic", "spirited", "passionate"] | 1 | OhZmxS5DUKU | 2458 | |
Ten2Five - My World Is Full With You | A female vocalist sings this beautiful pop melody. The tempo is medium fast with rhythmic acoustic guitar, keyboard harmony, electric guitar melody, straight drumming;steady bass and tambourine beats. The song is mellow, sweet, passionate,emotional, youthful, romantic, simple and tender. This song is a hit Indonesian Pop. | 2012-10-13T23:03:56Z | Xily Gina | Indonesian indie band | ["Christmas music", "Music", "Happy music"] | ["female vocalist", "medium fast tempo", "pop", "straight drumming", "classic pop", "passionate", "emotional", "romantic", "first love", "indonesian pop", "melodious", "rhythmic acoustic guitar", "electric guitar", "groovy bass line", "keyboard harmony", "tambourine beats", "synthesiser", "vivid", "vivacious", "youthful", "love song", "emotional", "sentimental"] | 7 | zTtZH-Q61Ik | 5480 |
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;