musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental music" and musiccaps_names contains "Dance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- instrumental music · 2 ✖
- medium tempo 2
- booming bass line 1
- comfort 1
- cymbal strikes 1
- dj 1
- double bass 1
- drum brushes 1
- emotional 1
- energetic 1
- exciting 1
- groovy dance music 1
- guitar accompaniment 1
- house mix 1
- jazz hits 1
- jazz music 1
- keyboard harmony 1
- lounge jazz hits 1
- love song 1
- movie soundtrack 1
- muted trumpet solo 1
- party all night 1
- party mix 1
- passionate 1
- percussive bass line 1
- piano accompaniment 1
- ping pong shot tones 1
- poor audio quality 1
- relaxing playlists 1
- romantic 1
- sentimental 1
- smooth 1
- spirited 1
- sweeping keyboard harmony 1
- techno dance rhythm 1
- trance music 1
- tv show theme 1
- underground music scene 1
- various percussion hits 1
- warmth 1
- youthful 1
musiccaps_names (array) 9 ✖
- Dance music · 2 ✖
- Music 2
- Disco 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Jazz 1
- Techno 1
youtube_published (date) 2 ✖
- 2009-12-20 1
- 2010-12-11 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 | |
Polycarpus - Ping Pong | The song is an instrumental. The tempo is medium with a booming bass line, grooving drum rhythm, sweeping keyboard harmony, sonic sound effects, and pin pong ball sound effects. The song has trance vibes and is very groovy. The song has poor audio quality. | 2009-12-20T21:38:12Z | Harder_Stylezz89 | Polycarpus - Ping Pong | ["Disco", "Drum and bass", "House music", "Music", "Techno", "Dubstep", "Electronic dance music", "Dance music"] | ["techno dance rhythm", "keyboard harmony", "poor audio quality", "trance music", "dj", "house mix", "party mix", "medium tempo", "instrumental music", "ping pong shot tones", "booming bass line", "various percussion hits", "groovy dance music", "exciting", "youthful", "energetic", "spirited", "party all night", "underground music scene", "sweeping keyboard harmony"] | 1 | hgGCfJoYDUU | 4124 |
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;