musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance hits", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- dance hits · 2 ✖
- instrumental music · 2 ✖
- poor audio quality · 2 ✖
- adrenaline rush 1
- bass line 1
- chords played percussively 1
- dance floor 1
- dance remix 1
- dance rhythm 1
- dancing all night 1
- dj 1
- electronic dance music 1
- energetic 1
- fashion party mix 1
- high on adrenaline 1
- ibiza party 1
- keyboard accompaniment 1
- keyboard harmony 1
- medium fast tempo 1
- new age 1
- no drums 1
- party nights 1
- passionate 1
- show intro music 1
- song intro 1
- spirited 1
- subtle medium tempo 1
- techno dance music 1
- theme song 1
- trance hits 1
- trance nights 1
- tv show tune 1
- workout music 1
musiccaps_names (array) 6 ✖
- Music 2
- /t/dd00032 1
- Drum and bass 1
- Electronica 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Try To Love Me (Let The Music Move You) - Manix featuring Marie | The song is an instrumental. The song is medium fast tempo with a keyboard playing chords percussively and a lower register bass line that is in harmony. The song is energetic and exciting. The song is of poor audio quality and sounds like the intro section. | 2009-08-01T20:20:23Z | Emperor Palpatine | Try To Love Me (Let The Music Move You) - Manix featuring Marie | ["Music", "/t/dd00032"] | ["instrumental music", "keyboard accompaniment", "chords played percussively", "subtle medium tempo", "tv show tune", "show intro music", "theme song", "energetic", "new age", "poor audio quality", "song intro", "dance hits", "workout music", "high on adrenaline", "passionate", "no drums", "bass line", "keyboard harmony"] | 1 | VL6uF-XeE_A | 2991 | |
Nord Sound Project - Dreams | The song is an instrumental. The song is medium fast tempo with a strong techno drum rhythm, groovy bass line, keyboard harmony and percussion hits. The song is exciting and groovy for dance. The audio quality is poor. | 2009-02-11T13:56:05Z | GTAreal5 | aus dem Album Tunnel Trance Force Vol.12 CD2 | ["Drum and bass", "Music", "Techno", "Trance music", "Electronica"] | ["techno dance music", "electronic dance music", "dance remix", "trance nights", "dancing all night", "ibiza party", "fashion party mix", "trance hits", "medium fast tempo", "instrumental music", "dance hits", "poor audio quality", "adrenaline rush", "spirited", "dance rhythm", "dance floor", "dj", "party nights"] | 1 | u3pYqyLM0f4 | 5087 |
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;