musiccaps_details (view)
4 rows where musiccaps_aspects contains "intense" and musiccaps_aspects contains "lively"
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- instrumental 4
- intense · 4 ✖
- lively · 4 ✖
- fast tempo 2
- rich 2
- ambient 1
- art music 1
- atmospheric synthesiser 1
- baroque 1
- bass drum 1
- blues 1
- bongos 1
- bow stringed instrument 1
- catchy 1
- cello 1
- cello harmony 1
- classical 1
- coke studio 1
- compelling 1
- congas 1
- contemporary indian pop 1
- creative 1
- cymbal ride 1
- dense layers 1
- drum battle 1
- drum routine 1
- electric guitar solo 1
- elegant 1
- emphatic 1
- engaging 1
- exquisite 1
- groovy 1
- harpsichord accompaniment 1
- heavy bass line 1
- improvisation 1
- indian music 1
- infectious 1
- italian music 1
- italian composer 1
- italian composition 1
- jazz 1
- jazz drumming 1
- layers building gradually 1
- loud 1
- oud 1
- oud riff 1
- percussion instrument 1
- percussive instrumental 1
- percusssion 1
- polyrhythms 1
- pulsating 1
- rhythmic 1
- rising tempo 1
- saxophone 1
- slow tempo 1
- sonic delight 1
- swing 1
- syncopated melody 1
- synthesiser arrangements 1
- trombone 1
- trumpets 1
- western classical 1
musiccaps_names (array) 11 ✖
- Brass instrument 1
- Drum 1
- Drum roll 1
- Harpsichord 1
- Jazz 1
- Keyboard (musical) 1
- Music 1
- Percussion 1
- Rimshot 1
- Saxophone 1
- Snare drum 1
youtube_published (date) 4 ✖
- 2008-03-09 1
- 2010-08-30 1
- 2014-01-04 1
- 2014-10-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Locatelli, Pietro,Sonata in D-dur.For cello and hapsichord | This music is instrumental. The tempo is fast with a spirited cello and harpsichord accompaniment. The music is lively, intense, rich, complex , exquisite and engaging. This music a Western Classical. | 2008-03-09T17:40:55Z | Levon Mouradian | Levon Mouradian,cello Jenny Silvestre, Hapsichord 24.02.2008,Portugal | ["Harpsichord", "Keyboard (musical)"] | ["instrumental", "fast tempo", "cello harmony", "exquisite", "creative", "art music", "italian music", "italian composition", "italian composer", "bow stringed instrument", "lively", "intense", "rich", "classical", "western classical", "baroque", "harpsichord accompaniment"] | 7 | 0AGHo8V8HpM | 130 | |
Moray Naina | Zara Madani | Season 6 | Coke Studio Pakistan | This music is an electric guitar solo. The tempo is medium fast with rhythmic bongo , atmospheric synthesiser, soft drumming with Cymbal rides, oud riff and keyboard harmony. The music is densely layered. It is soothing, engaging, compelling, mesmerising and building up gradually. This music is Contemporary Indian Pop. | 2014-01-04T18:56:21Z | Rohail Hyatt | Produced by Rohail Hyatt https://www.facebook.com/rohail.hyatt.public | ["Jazz", "Music"] | ["instrumental", "electric guitar solo", "oud riff", "indian music", "contemporary indian pop", "coke studio", "oud", "congas", "bongos", "cymbal ride", "synthesiser arrangements", "atmospheric synthesiser", "pulsating", "rising tempo", "layers building gradually", "intense", "dense layers", "rich", "sonic delight", "percusssion", "lively", "engaging", "compelling"] | 7 | OjEG808MfF4 | 2462 | |
Thats All Me Bro! | This music is a Jazz instrumental. The tempo is slow with emphatic brass and wind instrumentation, with cello and jazz drumming. The trumpets are emphatic with a lively trombone riff. The other instruments add a rich, dense layer to the music. It is intense, complex, ambient, groovy and pleasant. This music is a Jazz instrumental.5. | 2014-10-25T07:37:25Z | CharlesAlatorre | VLOG CHANNEL: https://www.youtube.com/user/CharlesAlatorre2 Christina (Girl In the Video): https://twitter.com/xtinnnnna http://instagram.com/xtinnnnna Travis's Channel: https://www.youtube.com/user/TravieBASED TWITTER: http://twitter.com/CharlesAlatorre INSTAGRAM: CharlesAlatorre LIKE MY FACEBOOK PAGE: http://www.facebook.com/CharlesAlatorreTV FACEBOOK: http://www.facebook.com/CharlesAlatorre Royalty Free Music By: http://www.audiomicro.com/royalty-free-music | ["Brass instrument", "Saxophone"] | ["instrumental", "slow tempo", "trumpets", "saxophone", "emphatic", "groovy", "ambient", "jazz", "intense", "elegant", "jazz drumming", "lively", "polyrhythms", "blues", "swing", "bass drum", "trombone", "cello", "heavy bass line", "syncopated melody", "improvisation"] | 7 | p1-07VdP__Q | 4676 | |
Epic Drum Battle | This music is a lively drum instrumental. The tempo is fast with an enthusiastic drum routine. It is loud, rhythmic, catchy and intense. | 2010-08-30T04:29:18Z | FreeTimeFeats | SMHS Drumline members get ruthless with agressive competition... | ["Drum", "Drum roll", "Rimshot", "Snare drum", "Percussion"] | ["instrumental", "fast tempo", "intense", "loud", "rhythmic", "drum battle", "catchy", "infectious", "lively", "drum routine", "percussion instrument", "percussive instrumental", "loud", "rhythmic"] | 7 | xmaVWayBvaY | 5353 |
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;