musiccaps_details (view)
2 rows where musiccaps_author = 4 and "youtube_published" is on date 2014-06-29
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- brass section progression 1
- euphoric 1
- excited 1
- flat male lead vocal 1
- fun 1
- groovy bass 1
- happy 1
- low quality 1
- mono 1
- muffled bells melody 1
- noisy 1
- nostalgic 1
- punchy kick 1
- seasonal 1
- shimmering shaker bells 1
- simple piano chord progression 1
- soft snare 1
- staccato strings melody 1
- synchronized wooden percussions 1
- ubeat 1
- wide harmonizing male vocals 1
musiccaps_names (array) 7 ✖
- Christmas music 1
- Drum 1
- Drum roll 1
- Music 1
- Percussion 1
- Soul music 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
目指せDCI マーチングスネア・ドラム兄弟! 「Bluecoats」 | The low quality recording features synchronized wooden percussion. It is noisy, in mono and it sounds upbeat. | 2014-06-29T01:32:09Z | たまドラちゃんねる | DCIを夢みる兄弟! 西原高校マーチング卒の兄と現役普天間高校打楽器同好会の弟! | ["Wood block", "Drum", "Drum roll", "Percussion"] | ["low quality", "noisy", "mono", "synchronized wooden percussions", "ubeat"] | 4 | w09XinexaIY | 5227 |
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;