musiccaps_details (view)
3 rows where musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Music of Bollywood"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- moderate tempo · 3 ✖
- female voice 2
- folk song 2
- no percussion 2
- accordion song 1
- flutes 1
- foreign language 1
- guitar 1
- hand claps 1
- happy feel 1
- indian song 1
- low quality recording 1
- minimal instruments 1
- no voices 1
- pop song 1
- romantic theme 1
- story-telling mood 1
- tabla 1
- two chord song 1
- violins 1
musiccaps_names (array) 6 ✖
- Music 3
- Music of Bollywood · 3 ✖
- Folk music 1
- Middle Eastern music 1
- New-age music 1
- Traditional music 1
youtube_published (date) 3 ✖
- 2010-05-19 1
- 2012-03-12 1
- 2014-06-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rehana Mirza - Anjan Ki Siti (Rajasthani Folk) | This folk song features a female voice singing the main melody. This is accompanied by a tabla playing the percussion. A guitar strums chords. For most parts of the song, only one chord is played. At the last bar, a different chord is played. This song has minimal instruments. This song has a story-telling mood. This song can be played in a village scene in an Indian movie. | 2012-03-12T14:37:32Z | Dr. Kumar Amit | Anjan Ki Siti (Engine Ki Siti) melodiously puts out the expression of a woman who is quite scared to travel through the train and is requesting "Dalever" (Driver) to go slow on it ... Lyrics : Chuk chuk chuk chuk anjan ki sittti mein maharo , anjan ki sitti mein maharo mun dole -2 Anjan ki sitti mein maharo munn dole -2 bijli ki punkho chale, gunj rio jane bhoro, baith rail mein gaba lagayo o jata ro choro............. challa challa re dariver gaadi houle houle .........anjan ki sittti mein maharo mann dole-2 doongar bhaage nandi bhaage -2 or bhaage re khet , dandha ki t oh toil bhagge ude ret hi ret.... Challa challa re dariver gaddi houle houle .......... anjan ki sittti mein maharo mann dole-2 Badi zor ko chale engine -2 , dewe zor ki sitti, dabba dabba ghum rio che dholpur aalo TT challa challa re dariver gaadi houle houle .........anjan ki sittti mein maharo mann dole-2 jaipur se jad gaadi chali main baithi ri seedhi, ghani zor ko dhakko lagyo main padgi re undiiiiiii............ challa challa re dariver gaadi houle houle .........anjan ki sittti mein maharo mann dole-2 Visit me at : http://www.amitwrites.com Like me at : https://www.facebook.com/amitwritesdotcom Also, subscribe to my channel to receive various upload notifications ! | ["Folk music", "Music", "Music of Bollywood"] | ["folk song", "indian song", "tabla", "guitar", "two chord song", "female voice", "moderate tempo", "story-telling mood"] | 0 | HHZGjS4g-w4 | 1788 | |
Irish traditional music : "Altan" [ with Frankie Kennedy ] play a medley | This clip features a melody played by violins and flutes. This is a low quality recording. There is no percussion in this song. Hand claps are played on every count. This is a folk song which has a happy mood. There is no voice in this song. This song can be used in a movie scene where somebody enters a castle to meet medieval royalty. | 2014-06-17T20:58:48Z | DOUGLAS HADDEN | "Altan" play a set of "highlands" and reels. The reels are "The Monaghan Twig" and the Scottish reel "The High Road To Linton". | ["Traditional music", "Music", "Middle Eastern music", "Music of Bollywood"] | ["low quality recording", "hand claps", "violins", "flutes", "no percussion", "no voices", "moderate tempo", "folk song", "happy feel"] | 0 | a2Wuroc8DQU | 3513 | |
New-Age Korean traditional music group IS - MBC drama, HyangDanJeon | This pop song features a female voice singing the main melody in a foreign language. This is accompanied by an accordion playing a harmonized melody in the background. There is no percussion in this song. Minimal instruments are used in this song. The theme of this song feels romantic. | 2010-05-19T12:42:41Z | InfinityofSound | MBC drama, HyangDanJeon | ["New-age music", "Music", "Music of Bollywood"] | ["pop song", "romantic theme", "female voice", "foreign language", "accordion song", "moderate tempo", "no percussion", "minimal instruments"] | 0 | aJHv6TV7JpY | 3528 |
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;