musiccaps_details (view)
5 rows where musiccaps_aspects contains "male voice", musiccaps_aspects contains "tabla" and musiccaps_author = 0
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| #Best_gondi_song @_all | This Indian folk song features a male voice singing the main melody. This is accompanied by tablas playing the percussion. A flute and another wind instrument voice are played on a synthesizer. The synth repeats the melody which is sung by the voice. A tambourine plays on every count of each bar. This folk song can be played in a village scene in an Indian movie. | 2015-07-25T18:05:02Z | Dhanvant singh Uikey | thiS SONG iS SUNG by_#RAVI@ MAA TV ...WAtCh it | ["Tabla", "Drum", "Percussion"] | ["folk song", "indian song", "tabla", "flute", "male voice", "tambourine", "synth sounds", "moderate tempo"] | 0 | E2v025Ilsqo | 1527 | |
| Entertainment | Rajasthan Folk Music | India Folk Dance | Banjara | Banjaran | This amateur recording features a folk song played in India. The main melody is sung by a male voice. This is accompanied by a tabla and dhol playing the percussion parts in an Indian beat. A sarangi plays the same melody as the main voice. The sitar plays the rhythm parts. Cymbals are played at every count of each bar. This song can be played for a cultural dance programme. | 2012-02-23T07:57:26Z | Pooja Sharma | Banjara tribe of Indian state of Rajasthan nomadic people and also known as "Gypsies of India". Their colourful dresses, traditional jewellery, folk dance and folk music is world famous. The male members of Banjara tribe are called "Banjara" and the female members are called "Banjaran". In this video, you can see the traditional folk dance of a "Banjaran" on the beats of a folk music of Rajasthan. Join me at Facebook : http://www.facebook.com/profile.php?id=100003591671951 Join me at Twitter : https://twitter.com/#!/Pooja1186 | ["Folk music", "Music", "Song", "Maraca"] | ["amateur recording", "indian folk song", "tabla", "sarangi", "moderate tempo", "male voice"] | 0 | OoyxPPoPmt0 | 2472 | |
| Koi Kahe Kehta Rahe Full Song | Dil Chahta Hai | Aamir Khan, Akshaye Khanna, Saif Ali Khan | This pop song features a male voice singing the main melody. Other voices sing backing vocals using the same melody. This is accompanied by programmed percussion playing a dance beat. A wave synth plays a repetitive melody. The bass plays the root notes of the chords. Toward the end of the song, a tabla is played. The mood of this song is happy. This song can be played in a club as a dance song. | 2011-05-25T01:24:21Z | T-Series | Song - Koi Kahe Kehta Rahe Film - Dil Chahta Hai Singer - Shankar Mahadevan, Shaan, K K Lyricist - Javed Akhtar Music Director - Shanker, Ehsaan, Loy Artist - Aamir Khan, Akshaye Khanna, Saif Ali Khan Music On - T-Series | ["Singing", "Music of Asia", "Music"] | ["pop song", "bollywood song", "male voice", "backing voices", "dance song", "synth music", "programmed percussion", "bass", "club song", "tabla", "moderate tempo", "happy mood"] | 0 | ctJI7pCbxAo | 3751 | |
| Paak Rooh Hum by Ernest Mall | This song features a male voice singing the main melody. The instruments lend an Indian tonality to the song. The song starts with a flute solo backed by a tabla and a stringed instrument that sounds like a santoor. This is followed by a violin solo backed by the tabla as percussion. The bass plays the root notes of the chords. The male voice starts singing after the violin solo. This song has a gospel feel. The voice is mellow and carries emotion. | 2009-01-06T09:17:52Z | Deans care | Paak Rooh Hum by Ernest Mall | ["Traditional music", "Music"] | ["indian song", "orchestra song", "flute", "tabla", "male voice", "string section", "moderate tempo", "romantic mood", "easy listening", "gospel theme"] | 0 | m1ov6te6jK8 | 4441 | |
| ishardan gadhvi.. hind ki rajputaniya thi... | This folk song features a male voice singing the main melody. This is accompanied by a tabla and dhol playing the percussion. A keyboard plays fills after the voice pauses. The other instruments are not audible due to the low audio quality. This song can be played at a Hindu religious gathering. | 2013-07-18T09:13:25Z | SV Shezaada | ishardan gadhvi.. sing hind ki rajputaniya thi on lok dayro like this song ever.. | ["Tabla", "Drum", "Percussion"] | ["low quality audio", "indian folk song", "tabla", "dhol", "male voice", "keyboard", "moderate tempo", "religious function"] | 0 | vZ9IanI59gE | 5191 |
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;