musiccaps_details (view)
15 rows where musiccaps_aspects contains "no instruments"
This data as json
musiccaps_aspects (array) 80 ✖
- no instruments · 15 ✖
- slow tempo 5
- amateur recording 4
- male voices 4
- moderate tempo 4
- acapella 3
- female voices 3
- alto 2
- beat boxing song 2
- choir 2
- male vocal 2
- vocal harmony 2
- vocal track 2
- angelic 1
- bass 1
- beatbox 1
- bored 1
- celestial 1
- chanting song 1
- chiming sound 1
- choir song 1
- choral arrangement 1
- choral harmony 1
- christian hymn 1
- dramatic 1
- effects processors 1
- ethereal 1
- female singer 1
- female vocal harmony 1
- gospel hymn 1
- harmonious 1
- high notes 1
- high pitch melody 1
- humming 1
- idle 1
- indian song 1
- inferior audio quality 1
- low voice 1
- low-to-medium pitch singing 1
- male vocal harmony 1
- mediocre sound recording 1
- meditation music 1
- melodic 1
- modulated noises 1
- monotonous 1
- no lyrical melody 1
- no lyrics 1
- no vocal melody 1
- no voice 1
- no voices 1
- overdubbing 1
- passionate singing 1
- quality of 1
- relaxation song 1
- relaxing song 1
- relaxing voices 1
- religious chanting 1
- religious song 1
- reverb effect 1
- reverb effect on voice 1
- rock opera 1
- romantic theme 1
- rustling 1
- scuffling 1
- seconds 1
- simple melody 1
- soprano 1
- soprano voices 1
- sound of chatter 1
- synth noises 1
- tenor 1
- uplifting 1
- vibrant 1
- video game music 1
- vocables 1
- vocal vibrations 1
- vocoder 1
- voices in harmony 1
- whirring sound 1
- wireless doorbell sound 1
musiccaps_names (array) 20 ✖
- Music 8
- Vocal music 6
- Beatboxing 4
- Chant 4
- A capella 3
- Choir 2
- Mantra 2
- /t/dd00003 1
- /t/dd00004 1
- Bell 1
- Christian music 1
- Ding-dong 1
- Doorbell 1
- Effects unit 1
- Gospel music 1
- Humming 1
- Noise 1
- Singing 1
- Speech 1
- Synthesizer 1
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;