musiccaps_details (view)
76 rows where musiccaps_aspects contains "energetic" and musiccaps_aspects contains "live performance"
This data as json
musiccaps_names (array) >30 ✖
- Music 64
- Singing 20
- Rock music 12
- Musical instrument 9
- Guitar 6
- Percussion 6
- Pop music 6
- Rock and roll 6
- Drum 5
- Exciting music 5
- Music of Asia 5
- Bang 4
- Drum kit 4
- Music of Latin America 4
- Plucked string instrument 4
- Roll 4
- Applause 3
- Banjo 3
- Burst, pop 3
- Electronic music 3
- Heavy metal 3
- Independent music 3
- Psychedelic rock 3
- Punk rock 3
- Salsa music 3
- Song 3
- Wind instrument, woodwind instrument 3
- Yell 3
- Bagpipes 2
- Bluegrass 2
- …
musiccaps_aspects (array) >30 ✖
- energetic · 76 ✖
- live performance · 76 ✖
- low quality 40
- passionate 19
- exciting 18
- punchy snare 17
- noisy 16
- crowd cheering 14
- live audience 14
- groovy bass 13
- shimmering hi hats 12
- loud 11
- punchy kick 11
- spirited 11
- enthusiastic 10
- rock 10
- mono 9
- pop 9
- energetic drums 8
- flat male vocal 8
- groovy bass guitar 8
- medium tempo 8
- youthful 8
- electric guitar melody 7
- gig 7
- groovy bass line 7
- instrumental music 7
- medium fast tempo 7
- passionate male vocal 7
- poor audio quality 7
- …
0 records
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;