musiccaps_details (view)
2 rows where musiccaps_aspects contains "comfort" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- comfort · 2 ✖
- instrumental music 2
- medium tempo · 2 ✖
- accordion accompaniment 1
- bad audio quality 1
- calming 1
- cymbal strikes 1
- double bass 1
- drum brushes 1
- emotional 1
- european instruments 1
- flute melody 1
- folk music 1
- folk musicians 1
- forgotten traditional 1
- good old days 1
- guitar accompaniment 1
- guitar rhythm 1
- gypsy music 1
- jazz hits 1
- jazz music 1
- lounge jazz hits 1
- love song 1
- memdium tempo 1
- movie soundtrack 1
- muted trumpet solo 1
- nostalgic 1
- olden days 1
- passionate 1
- percussive bass line 1
- piano accompaniment 1
- poor audio quality 1
- relaxing playlists 1
- romantic 1
- sentimental 1
- smooth 1
- soothing 1
- traditional instruments 1
- tv show theme 1
- warmth 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tam w Gorlyciach - Lemko ( Лемко) ( Carpatho-Rusyn NOT Ukrainian!) | The song is an instrumental. The song is medium tempo with an accordion accompaniment, violin solo and a flute melody. The song is beautiful and nostalgic. The audio quality is poor. The song has an old gypsy soul to it. | 2009-12-12T22:29:21Z | kayetanowicz | Lemko soldier's song A lot of Lemko (Carpatho-Rusyn) people form an independent nation and we are officially recognized as one of the national minorities in some countries where we live ( Poland, Slovakia, Serbia). | ["Wind instrument, woodwind instrument", "Flute"] | ["instrumental music", "gypsy music", "medium tempo", "poor audio quality", "accordion accompaniment", "flute melody", "guitar rhythm", "european instruments", "memdium tempo", "bad audio quality", "folk music", "folk musicians", "nostalgic", "olden days", "forgotten traditional", "traditional instruments", "calming", "soothing", "good old days", "comfort"] | 1 | 0Wdh45yt7tY | 178 | |
Dr.House Jazz Music season1 ep.9 "DNR" | The song is an instrumental jazz tune. The tempo is medium with steady drumming with drum brushes and other percussive hits, piano accompaniment, guitar accompaniment, groovy bass line and a muted trumpet playing a cool solo. The song is a jazz improvisation of a romantic melody. | 2010-12-11T17:42:03Z | manonfio | hi here s the jazz song of the oldest episode of house ep9 season 1 "DNR" I DUNNO the album or compositor, simply found it in the web enjoy P.S. if my english is bad sorry about that need study more lol p.s.2.-If someone knows the compositor or album song plz share ur knowledge with the world i want more of this. | ["Jazz", "Music", "Dance music"] | ["jazz music", "instrumental music", "medium tempo", "relaxing playlists", "comfort", "movie soundtrack", "warmth", "drum brushes", "piano accompaniment", "guitar accompaniment", "percussive bass line", "smooth", "jazz hits", "tv show theme", "jazz hits", "lounge jazz hits", "cymbal strikes", "instrumental music", "emotional", "sentimental", "romantic", "passionate", "love song", "muted trumpet solo", "double bass"] | 1 | 1ypKEH2kd7g | 322 |
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;