musiccaps_details (view)
2 rows where musiccaps_aspects contains "easygoing" and musiccaps_aspects contains "energetic" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- easygoing · 2 ✖
- energetic · 2 ✖
- jazz 2
- low quality 2
- camera shuttering sound effect 1
- cool saxophone solo melody 1
- easygoing electric guitar chords 1
- energetic drums 1
- groovy bass 1
- groovy drums 1
- muddy 1
- muffled 1
- reverberant 1
- saxophone solo melody 1
- unbalanced stereo 1
musiccaps_names (array) 4 ✖
- Brass instrument 1
- Carnatic music 1
- Music 1
- Saxophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Carnatic Music Idol #4 Final Instrumental Part 2 | The low quality recording features a jazz song being played in a big room and it consists of a saxophone solo melody over groovy drums. Due to frequency clashing, it sounds muddy and muffled and it has an unbalanced stereo image, as it was probably recorded with a poor quality microphone. It is still energetic and easygoing at the same time - thanks to that saxophone. | 2015-10-21T12:58:14Z | nsushma | ["Carnatic music", "Music"] | ["unbalanced stereo", "low quality", "jazz", "groovy drums", "muffled", "reverberant", "muddy", "saxophone solo melody", "energetic", "easygoing"] | 4 | ciJOulWFhfA | 3734 | ||
Making the Mclaren P1 - Lego StopMotion | The low quality recording features some camera shuttering sound effects and a jazz song playing in the background. The song consists of a cool saxophone solo melody over groovy bass, easygoing electric guitar chords in the left channel of the stereo image and energetic drums. It sounds easygoing and energetic at the same time. | 2015-09-03T19:10:35Z | Eton | Used 5042 Pictures! *21 FPS Thanks for Watching! Music _ Get Back(Youtube Audio library) | ["Brass instrument", "Saxophone"] | ["low quality", "camera shuttering sound effect", "jazz", "energetic drums", "groovy bass", "easygoing electric guitar chords", "cool saxophone solo melody", "easygoing", "energetic"] | 4 | eSsadT6mh7g | 3864 |
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;