musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate" and "youtube_published" is on date 2010-02-08
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- passionate · 2 ✖
- bassoons 1
- brass section 1
- carnatic music 1
- clarinet player 1
- clarinets 1
- classical singing style 1
- composers 1
- concert hall 1
- conductor 1
- devotional 1
- emotional 1
- energetic 1
- exciting 1
- female singers 1
- flute countermelody 1
- grand 1
- guitar accompaniment 1
- heartfelt 1
- high pitched melody 1
- horn section 1
- humour 1
- instrumental music 1
- live audience 1
- live performance 1
- meditational 1
- medium tempo 1
- philharmonic orchestra 1
- pomp 1
- poor audio quality 1
- prayers 1
- spirited 1
- steady techno drumming rhythm 1
- stringed instrument countermelody 1
- stringed instrument harmony 1
- strong bass line 1
- syncopated rhythms 1
- tamil devotional songs 1
- trumpets 1
- tubas 1
- vocal duo 1
- vocal harmony 1
musiccaps_names (array) 7 ✖
- Brass instrument 1
- Carnatic music 1
- Clarinet 1
- Classical music 1
- Music 1
- Music of Asia 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Parvai ondre pothume - Carnatic Fusion Tamil Kannan Song by S. J. Jananiy | Female singers sing this vocal in Tamil harmony. The song is medium tempo with a strong techno drumming rhythm, guitar accompaniment, stringed instrument accompaniment, flute countermelody, and a strong bass line. The song is devotional and highly passionate. The song is a Carnatic Hindu devotional song sung in Tamil. | 2010-02-08T22:06:22Z | Saumi Music | Sharing another beautiful carnatic fusion sung by S.J. Jananiy. Follow us on Facebook: https://www.facebook.com/pages/Gnanalayam-Berlin/246868511997333 | ["Carnatic music", "Music of Asia", "Music", "Classical music"] | ["carnatic music", "female singers", "vocal harmony", "guitar accompaniment", "stringed instrument harmony", "emotional", "passionate", "meditational", "devotional", "heartfelt", "classical singing style", "vocal duo", "tamil devotional songs", "prayers", "flute countermelody", "guitar accompaniment", "stringed instrument countermelody", "strong bass line", "steady techno drumming rhythm"] | 1 | ROA6DMBPlNM | 2695 | |
Immer Kleiner Philips Harmonie | The song is an instrumental. The tempo is medium with a clarinet playing lead supported by a wind section, horn section, brass section and other percussion. The song is exciting and energetic. The song is a western classic tune with bad audio quality issues. | 2010-02-08T15:01:49Z | juudruud | Guido van de Ven speelt 'Immer Kleiner' tijdens het nieuwjaarsconcert 2010 van de Philips Harmonie. dirigent: Matty Cilissen special guest star: Jos de Wit Guido van de Ven plays 'Always Smaller'. Newyearconcert 2010 Philips Harmonie Eindhoven. conductor: Matty Cilissen special guest star: Jos de Wit Bekijk ook het officiële Philips Harmonie Youtube-kanaal https://www.youtube.com/channel/UCD7B2SzauFUtJ58DHheWy4w | ["Brass instrument", "Clarinet", "Trumpet"] | ["clarinet player", "horn section", "brass section", "philharmonic orchestra", "instrumental music", "trumpets", "conductor", "medium tempo", "instrumental music", "concert hall", "high pitched melody", "syncopated rhythms", "grand", "exciting", "pomp", "humour", "energetic", "passionate", "composers", "conductor", "live audience", "live performance", "poor audio quality", "spirited", "tubas", "clarinets", "bassoons"] | 1 | Z-Vb1Ay-zNA | 3333 |
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;