musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "passionate", musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- emotional 2
- medium tempo 2
- passionate · 2 ✖
- piano accompaniment · 2 ✖
- romantic · 2 ✖
- comfort 1
- cymbal strikes 1
- dance groove 1
- dance rhythm 1
- double bass 1
- drum brushes 1
- entertaining 1
- guiro percussions 1
- guitar accompaniment 1
- guitar rhythm 1
- instrumental music 1
- jazz hits 1
- jazz music 1
- latin dance band 1
- latin folk singer 1
- latin percussions 1
- lounge jazz hits 1
- love song 1
- male latin singer 1
- movie soundtrack 1
- muted trumpet solo 1
- people dancing 1
- percussive bass line 1
- poor audio quality 1
- relaxing playlists 1
- sentimental 1
- smooth 1
- soaring vocals 1
- spirited 1
- story telling 1
- tv show theme 1
- walking bass line 1
- warmth 1
musiccaps_names (array) 5 ✖
- Music 2
- Dance music 1
- Jazz 1
- Music of Africa 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 |
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;