musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental music" and musiccaps_names contains "/t/dd00032"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- instrumental music · 2 ✖
- acoustic guitar lead 1
- adventurous 1
- arcade game music 1
- bass line 1
- children playing games 1
- chords played percussively 1
- computer music 1
- dance hits 1
- emotional 1
- energetic 1
- game music track 1
- groovy bass line 1
- handheld game 1
- high on adrenaline 1
- keyboard accompaniment 1
- keyboard harmony 1
- medium tempo 1
- midi music 1
- new age 1
- no drums 1
- passionate 1
- poor audio quality 1
- poor quality audio 1
- retro game tracks 1
- show intro music 1
- song intro 1
- subtle medium tempo 1
- theme song 1
- tv show tune 1
- workout music 1
musiccaps_names (array) 3 ✖
- /t/dd00032 · 2 ✖
- Music 2
- Background music 1
youtube_published (date) 2 ✖
- 2009-08-01 1
- 2011-04-21 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 | |
Mabinogi Music Playing- Kuroshitsuji Ending 2: Lacrimosa | The song is an instrumental. The song is medium tempo with a groovy bass line and a guitar synth tone playing melody. The song is exciting and adventurous in nature. The song is a video game song track. | 2011-04-21T22:37:24Z | CatnipMafia | For this score by me and more, please visit: [ http://reo12.webs.com/mmlscript.htm ] | ["Background music", "Music", "/t/dd00032"] | ["acoustic guitar lead", "midi music", "groovy bass line", "children playing games", "handheld game", "arcade game music", "retro game tracks", "poor quality audio", "instrumental music", "computer music", "medium tempo", "game music track", "emotional", "adventurous"] | 1 | uT-S_JC_GzU | 5116 |
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;