musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "enthusiastic drumming" and musiccaps_aspects contains "spirited" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- enthusiastic 2
- enthusiastic drumming · 2 ✖
- spirited · 2 ✖
- youthful 2
- auto harp 1
- banjo 1
- break the tension 1
- building anticipation 1
- buzz 1
- catchy 1
- country music 1
- country pop 1
- country side 1
- cowboys 1
- distorted amplified guitar 1
- drum roll 1
- electrostatic sounds 1
- exciting 1
- fast tempo 1
- female singer 1
- fiddle 1
- folk music 1
- get tones 1
- girl singing 1
- guitar strumming 1
- happy 1
- heart beat melody 1
- k-pop 1
- keyboard harmony 1
- korean rock band 1
- male singer 1
- mandolin 1
- march like beat 1
- passionate 1
- people clapping 1
- peppy 1
- percussive bass line 1
- pop 1
- pop dance rhythm 1
- pop dance song 1
- powerful vocals 1
- powerfully voice 1
- regional music 1
- resonator 1
- sentimental 1
- signal tempo 1
- storm cloud noises 1
- story telling 1
- tambourine beats 1
- teen spirit 1
- vibrant 1
- vocal emphasis 1
- young vocalist 1
musiccaps_names (array) 4 ✖
- Music 2
- Exciting music 1
- Song 1
- Yodeling 1
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 | |
cutie girl singing (11 years old) | A young female vocalist sings this upbeat country song. The tempo is fast with keyboard harmony,enthusiastic drumming , rhythmic accompaniment of acoustic guitar, mandolin, fiddle, resonator, auto harp and dobro and tambourine beats. The song is fresh, youthful, energetic, vivacious, catchy, upbeat, simple and peppy. This song is Country Pop. | 2006-07-16T08:08:14Z | Trofimo | El origen de la Humanidad (la infancia) puede descubrirnos el origen de la música... | ["Yodeling", "Music", "Song"] | ["female singer", "fast tempo", "girl singing", "young vocalist", "peppy", "enthusiastic", "auto harp", "folk music", "regional music", "country side", "cowboys", "catchy", "country music", "country pop", "march like beat", "powerfully voice", "people clapping", "enthusiastic drumming", "fiddle", "mandolin", "resonator", "banjo", "tambourine beats", "youthful", "happy", "sentimental", "story telling", "powerful vocals", "vocal emphasis", "keyboard harmony", "spirited", "vibrant"] | 7 | hdlnugbWjKA | 4122 |
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;