musiccaps_details (view)
78 rows where musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Musical instrument"
This data as json
musiccaps_names (array) >30 ✖
- Musical instrument · 78 ✖
- Music 76
- Guitar 52
- Plucked string instrument 51
- Electric guitar 19
- Effects unit 13
- Distortion 12
- Acoustic guitar 11
- Reverberation 10
- Speech 10
- Chorus effect 8
- Classical music 7
- Electronic tuner 6
- Strum 6
- Bass guitar 5
- Singing 5
- Tapping (guitar technique) 5
- Ukulele 5
- Banjo 4
- Bowed string instrument 4
- Country 4
- Flamenco 4
- Blues 3
- Echo 3
- Inside, small room 3
- Orchestra 3
- Percussion 3
- Steel guitar, slide guitar 3
- Synthesizer 3
- Carnatic music 2
- …
musiccaps_aspects (array) >30 ✖
- medium tempo · 78 ✖
- instrumental music 25
- amateur recording 18
- emotional 17
- passionate 16
- instrumental 15
- spirited 14
- e-guitar 11
- electric guitar 11
- poor audio quality 11
- soloist 10
- bad audio quality 8
- energetic 7
- exciting 7
- groovy music 7
- live performance 7
- rock 7
- stringed instrument 7
- acoustic guitar 6
- dance rhythm 6
- e-bass 6
- acoustic drums 5
- country music 5
- e-guitars 5
- groovy 5
- groovy bass line 5
- groovy rhythm 5
- guitar solo 5
- guitar strumming 5
- male singer 5
- …
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;