musiccaps_details (view)
4 rows where musiccaps_author = 7 and musiccaps_names contains "Shofar"
This data as json
musiccaps_aspects (array) 62 ✖
- instrumental 3
- shell trumpet 2
- slow tempo 2
- wind instrument 2
- ambient outdoor sounds 1
- animated movie 1
- animated voice 1
- announcement 1
- bengali 1
- bengali pujo 1
- birds chirping 1
- buddhism 1
- buffalo horn 1
- c shaped instrument 1
- cartoon 1
- celebr 1
- celebration 1
- ceremonial 1
- chanting 1
- children cheering in unison 1
- children’s movie 1
- children’s show 1
- conch shell 1
- conch shell sound 1
- conical bore 1
- cymbal riff 1
- dramatic music playing 1
- exaltation 1
- festive horn 1
- hindu puja 1
- hindu rituals 1
- hinduism 1
- indian blow horn 1
- indian instrument 1
- indian language 1
- intense music 1
- keyboard harmony 1
- maharashtrian instrument 1
- male dialogue 1
- male voice 1
- male voice speaking 1
- male voice talking 1
- meditation 1
- minimalist 1
- om chant 1
- phone dial tone 1
- phone ringing 1
- playful 1
- puja 1
- reverence 1
- royal 1
- sacred 1
- sinister music 1
- superimposed male voice 1
- synthesiser harmony 1
- the sringa 1
- tutari sound 1
- victory 1
- vocalisation 1
- western india instrument 1
- women chanting 1
- worship 1
musiccaps_names (array) 2 ✖
- Shofar · 4 ✖
- Wind instrument, woodwind instrument 4
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;