musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental music" and musiccaps_names contains "Sitar" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- instrumental music · 2 ✖
- medium tempo 2
- ancient traditional music 1
- building tension 1
- dance rhythm 1
- deep bass line 1
- didgeridoo harmony 1
- ethereal harmony tones 1
- exciting 1
- fusion music 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar lead 1
- harmonium solo 1
- hindustaani music 1
- hindustani music 1
- indian classical music 1
- instruments in unison 1
- live audience 1
- live concert 1
- love song 1
- modern pop fusion 1
- movie soundtrack 1
- new age 1
- passionate 1
- piano accompaniment 1
- romantic 1
- sitar accompaniment 1
- slick techno tones 1
- tabla playing percussively 1
- techno drumming music 1
- tollywood music 1
- traditional indian instruments 1
- y traditional indian instruments 1
musiccaps_names (array) 6 ✖
- Music 2
- Sitar · 2 ✖
- Bowed string instrument 1
- Music of Asia 1
- Musical instrument 1
- Tabla 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kendasampige - Juke box | V Harikrishna | Vikky, Manvitha Harish | The song is an instrumental. The tempo is medium with an interesting fusion of old and new age Indian instruments like sitar playing, guitar lead, deep techno bass, slick drumming rhythm, piano accompaniment and groovy bassline. The song is emotional and new age in style. | 2015-07-26T12:30:00Z | DBeatsMusicWorld | Listen to all the soulful tracks of 'Kendasampige' starring Vikky, Manvitha Harish. Movie directed by Suri, V Harikrishna has scored music. Movie - Kendasampige Starring - Vikky, Manvitha Harish Director - Suri Music - V Harikrishna Singers - Karthik, Shweta Mohan, Vijay Prakash, Balram. Lyrics - Jayant Kaikini, Yogaraj Bhat Producer - Parimala film factory Banner - Parimala film factory Music Label - D BEATS Copyright - DBEATS Subscribe: YouTube - https://www.youtube.com/user/dbeatsmusicworld?sub_confirmation=1 Like us: Facebook: https://www.facebook.com/pages/D-Beats/785224534852515?ref=hl Follow us: Twitter: https://twitter.com/Dbeatsmusik G+: https://plus.google.com/u/0/b/103612476138863903249/+DBeatsMusicWorld/posts | ["Music", "Sitar"] | ["instrumental music", "fusion music", "didgeridoo harmony", "piano accompaniment", "love song", "hindustani music", "guitar accompaniment", "slick techno tones", "ethereal harmony tones", "modern pop fusion", "tollywood music", "movie soundtrack", "building tension", "romantic", "new age", "medium tempo", "guitar lead", "deep bass line", "techno drumming music"] | 1 | TA-O_bVnvLY | 2818 | |
Young Afghan Traditional Ensemble: Naghmadokhana; Kabul 2013 | The song is instrumental. The tempo is medium with sitars and other stringed instruments playing in unison, tabla percussions and a harmonium playing the lead. The song is a classic hindustaani instrumental. | 2015-03-11T17:09:41Z | Safar Hochschule | Comp: Ustad Mohammad Omar, Rag Bahari, Tal Dadra FazilaZamir, Rohullah Baqizada, Samihullah Sarwari, Ahmadullah Nabizada, Ahmad Samim Zafar, Mostafa Darwishi, Eraj Khorasani | ["Tabla", "Music of Asia", "Music", "Musical instrument", "Sitar", "Bowed string instrument"] | ["instrumental music", "harmonium solo", "traditional indian instruments", "indian classical music", "tabla playing percussively", "sitar accompaniment", "y traditional indian instruments", "groovy rhythm", "exciting", "instruments in unison", "dance rhythm", "ancient traditional music", "passionate", "live concert", "live audience", "medium tempo", "hindustaani music"] | 1 | qsFfUzErXqw | 4829 |
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;