musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "shakers"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- amateur recording · 2 ✖
- live performance · 2 ✖
- shakers · 2 ✖
- acordion harmony 1
- ambient sounds 1
- animated piano 1
- bass drums 1
- bustling 1
- cello 1
- devotional song 1
- enthusiastic vocals 1
- fast tempo 1
- female vocalisation 1
- female vocals 1
- funky bass lines 1
- gig 1
- hand percussion 1
- hard hitting drums 1
- high notes 1
- high pitch 1
- hindi movie song 1
- hindi song 1
- hindu devotion music 1
- indian classical 1
- indian devotion music 1
- indian music 1
- inferior audio quality 1
- keyboard 1
- keyboard harmony 1
- people cheering 1
- people talking 1
- poor audio quality 1
- slow tempo 1
- song introduction 1
- tambourine 1
- tanpura 1
- violin harmony 1
- xylophone 1
musiccaps_names (array) 8 ✖
- Music 2
- Jazz 1
- Music of Asia 1
- Musical instrument 1
- Rattle (instrument) 1
- Singing 1
- Synthetic singing 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
nitin chakrdhari katra ( jk ) satyam shivam | A female vocalist sings this Hindi Devotion song. The tempo is slow with keyboard harmony,tambourine beats, violin melody and rhythmic tanpura accompaniment. This clip is the song introduction with slow chants like singing. The song is a Hindu Devotion song to the God Shiva. It is emotional, sentimental, devotional, prayerful praise and worship. There are ambient sounds of people talking and cheering, indicating that this is a live performance. | 2012-03-20T04:43:45Z | NCRC STUDIO | nitin chakrdhari enterainmant perfomer | ["Music of Asia", "Music", "Synthetic singing"] | ["female vocals", "slow tempo", "high pitch", "high notes", "tambourine", "indian classical", "indian devotion music", "hindu devotion music", "indian music", "keyboard harmony", "hindi song", "hindi movie song", "devotional song", "song introduction", "amateur recording", "inferior audio quality", "live performance", "people cheering", "violin harmony", "keyboard", "shakers", "tanpura", "ambient sounds"] | 7 | HdRPdh-cSTw | 1821 | |
HESTER GOODMAN...HAT SONG.. | This song is an animated vocalisation. The tempo is fast with a lively piano accompaniment, accordion harmony, cello rhythm, hard hitting drums, groovy bass lines, hand percussion beats and xylophone. The music is upbeat, energetic,enthusiastic, high-spirited and vivacious. This is a live performance with ambient sounds of people talking and general bustling. The audio quality is inferior. This song is a live Pop. | 2010-10-21T17:54:37Z | spaceritual72 | ...HAT SONG.....from "you could at least smile" album launch night...by HESTER GOODMAN..available at.......www.ukuleleorchestra.com | ["Singing", "Jazz", "Music", "Musical instrument", "Rattle (instrument)", "Ukulele"] | ["female vocalisation", "fast tempo", "cello", "hand percussion", "bass drums", "xylophone", "hard hitting drums", "animated piano", "shakers", "funky bass lines", "amateur recording", "live performance", "gig", "poor audio quality", "people talking", "bustling", "acordion harmony", "enthusiastic vocals"] | 7 | qXSG2uq2tNw | 4795 |
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;