musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "high on adrenaline" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- energetic · 2 ✖
- high on adrenaline · 2 ✖
- instrumental music 2
- passionate 2
- poor audio quality · 2 ✖
- bass line 1
- cheerleaders 1
- chords played percussively 1
- college band 1
- dance hits 1
- dance rhythm 1
- drum sticks 1
- drums 1
- enthusiastic 1
- groovy rhythm 1
- keyboard accompaniment 1
- keyboard harmony 1
- marching band 1
- medium tempo 1
- new age 1
- no drums 1
- samba 1
- show intro music 1
- snares 1
- song intro 1
- steady drum rhythm 1
- subtle medium tempo 1
- theme song 1
- tv show tune 1
- various percussion hits 1
- various percussion instruments 1
- workout music 1
musiccaps_names (array) 3 ✖
- Music 2
- /t/dd00032 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Drumline Final Battle By Hicham (High Sound Quality) | The song is an instrumental. The song is medium tempo with various marching band drums playing in sync. The song is highly energetic and spirited. The song is bad in audio quality. The song is a college marching band playing enthusiastically. | 2009-04-12T21:32:52Z | oferighe | Drumline Soundtrack | ["Music", "Roll"] | ["poor audio quality", "medium tempo", "instrumental music", "groovy rhythm", "various percussion instruments", "steady drum rhythm", "various percussion hits", "snares", "drums", "drum sticks", "dance rhythm", "samba", "cheerleaders", "college band", "marching band", "enthusiastic", "passionate", "energetic", "high on adrenaline"] | 1 | 0pewITE1550 | 211 | |
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 |
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;