musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- groovy bass · 2 ✖
- punchy kick · 2 ✖
- alternative/indie 1
- brass section progression 1
- electric guitar licks 1
- energetic 1
- energetic crash cymbal 1
- euphoric 1
- excited 1
- flat male lead vocal 1
- fun 1
- halloween 1
- happy 1
- haunting 1
- muffled bells melody 1
- nostalgic 1
- seasonal 1
- shimmering shaker bells 1
- simple piano chord progression 1
- soft snare 1
- staccato strings melody 1
- synth keys chords 1
- wide harmonizing male vocals 1
musiccaps_names (array) 5 ✖
- Music 2
- Soul music · 2 ✖
- Christmas music 1
- Rhythm and blues 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
José Cid- Mellotron - O Planeta Fantástico | The Alternative/Indie song features layered punchy kicks, energetic crash cymbals, groovy bass and synth key chords, followed by electric guitar licks. It sounds haunting and energetic, almost like a halloween themed song. | 2010-09-24T02:02:36Z | jerudoriginal91 | ["Music", "Rhythm and blues", "Ska", "Soul music"] | ["alternative/indie", "punchy kick", "groovy bass", "synth keys chords", "electric guitar licks", "energetic crash cymbal", "energetic", "haunting", "halloween"] | 4 | 1Xtkou9dtyA | 285 | ||
Brian Lexus - The Christmas Song | This seasonal song features a flat male vocal, supported by wide harmonizing male vocals, singing over punchy kick, soft snare, groovy bass, shimmering shaker bells, muffled bells melody, staccato strings melody, brass section progression and simple piano chord progression. It sounds fun and happy, leaving the listener with the feelings of euphoria, nostalgia and excitement. | 2014-06-29T21:08:11Z | Grzegorz Burzyński | Lyrics and Music by Sebastian Kwiatkowski Brian Lexus - The Christmas Song | ["Christmas music", "Music", "Soul music"] | ["seasonal", "wide harmonizing male vocals", "flat male lead vocal", "soft snare", "groovy bass", "punchy kick", "simple piano chord progression", "muffled bells melody", "brass section progression", "staccato strings melody", "fun", "happy", "nostalgic", "euphoric", "excited", "shimmering shaker bells"] | 4 | BS2ZnUhmHj4 | 1239 |
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;