musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_author = 6 and musiccaps_names = "["Music", "Exciting music"]"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 20 ✖
- e-guitar 2
- acoustic drums 1
- digital drums 1
- e-bass 1
- e-guitars 1
- fast tempo 1
- female singer 1
- female voice singing 1
- high pitch 1
- hindi/pop/rock 1
- male backing voices 1
- male voice singing 1
- medium to uptempo 1
- percussive hits 1
- pop/synth-pop 1
- poprock 1
- synth bass 1
- synth lead sound 1
- synth pluck 1
- uptempo 1
musiccaps_names (array) 2 ✖
- Exciting music 3
- Music 3
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rowdy Rathore Music Box | This audio contains very strong deep percussive hits and a e-guitar sound also serving as bass. A male voice is singing with a little bit of reverb on his voice. In-between the breaks male voices are singing a melody. This song may be playing in an action movie. | 2012-07-02T05:58:42Z | Sony Music India | The official songs from Rowdy Rathore, starring Akshay Kumar and Sonakshi Sinha | ["Music", "Exciting music"] | ["hindi/pop/rock", "e-guitar", "percussive hits", "male voice singing", "male backing voices", "medium to uptempo"] | 6 | 05OJDYeHLMc | 118 | |
Sonic Adventure DX Music: BELIEVE IN MYSELF | The female voice sings in the mid range. The drums is playing a fast rock/hiphop groove along with an acoustic bass breaking along with it into another part of the song. One of the e-guitars is playing some chords running through a strong tremolo effect. While the other guitar sounds distorted and takes the lead. One is panned to the left, the other to the right side of the speakers. This song may be playing at a birthday party. | 2007-02-09T02:50:55Z | sonicKAI | This is Miles "Tails" Prower's theme tune in Sonic Adventure DX. The song is "Believe In Myself" by Karen Brake. | ["Music", "Exciting music"] | ["poprock", "e-bass", "e-guitars", "acoustic drums", "female singer", "uptempo"] | 6 | 0DizopdPMBw | 134 | |
Aikatsu! Music Video "Growing for A Dreams" ♪ | This audio contains fast paced digital drums changing the beat from halftime into a four on the floor with a kick on every beat along with a synth bassline. Other synth sounds are playing a lead sound and an arpeggiolike melody along with a distorted e-guitar. A female voice is singing in a high pitch accompanied by another female backing voice creating a harmony. This song may be playing as an entry for a fast paced action series. | 2015-03-04T08:33:25Z | Aikatsu Indonesia Card Game | Untuk merayakan perilisan seri ke-2, music video ini dirilis☆ Stage Ichigo bernuansa cokelat dengan lagunya, "Growing for a dreams"♪ Cek juga info terkini Aikatsu! Indonesia di website resmi↓ http://id.aikatsu.com | ["Music", "Exciting music"] | ["pop/synth-pop", "synth lead sound", "synth bass", "e-guitar", "synth pluck", "female voice singing", "high pitch", "digital drums", "fast tempo"] | 6 | 2SQxfaWAJJg | 365 |
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;