musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "drums", musiccaps_aspects contains "piano" and musiccaps_author = 2
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- drums · 3 ✖
- piano · 3 ✖
- bass guitar 2
- broadway musical vibes 1
- distorted sound 1
- electronic sound 1
- male backing vocal 1
- male voice 1
- medium-fast tempo 1
- no melody 1
- saxophone 1
- ska genre 1
- strings 1
- theatrical female voice 1
musiccaps_names (array) 5 ✖
- Music 3
- Happy music 1
- Independent music 1
- Ska 1
- Tender music 1
youtube_published (date) 3 ✖
- 2011-01-05 1
- 2013-03-18 1
- 2013-07-12 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ska music band Skalingrad United Skajana | The ska music features a male voice singing and being accompanied by another male backing vocal. The tempo is medium-fast, specific to the ska genre. The drums play a somewhat busy rhythm and the bass guitar plays a simple repeating bass line. In the background a piano accompanies the singer. Towards the end of the music excerpt a saxophone can be heard. | 2013-07-12T17:09:02Z | tunapavel | Skalingrad United - original ska music from The Czech republic. Moreover - www.skajana.cz | ["Music", "Ska"] | ["male voice", "male backing vocal", "piano", "bass guitar", "drums", "ska genre", "medium-fast tempo", "saxophone"] | 2 | WPguqXCBQCI | 3092 | |
I Can Hear the Bells | The music features a female voice that sings in a theatrical style, similar to Broadway musicals. The bass guitar and drums blend together and play a light accompaniment. A piano can also be heard contributing to the overall accompaniment. A string section plays a long note melody that transitions into playing in unison with the singer's melody. | 2011-01-05T13:59:15Z | Hairsprayhome | "I Can Hear the Bells" - Nikki Blonsky From the movie "Hairspray" from 2007 See the other songs from the movie at my chanel Pleas note: I OWNS NO RIGHTS FOR THE PICTURS OR THE SOUNDTRACK OF THE VIDEO! | ["Music", "Happy music"] | ["theatrical female voice", "strings", "bass guitar", "drums", "piano", "broadway musical vibes"] | 2 | ZbdmiykoJm8 | 3396 | |
Karaoke DJ SOUND MUSIC - LES ENFOIRES : Attention Au Départ | The music features a melody-less section, just the accompaniment. A piano is playing chords at the beginning of every measure. The kick drum plays on beats one and three and the snare drum, which seems to have some beads on its membrane, on beats two and four. An electronic sound is playing the same harmonies that the piano is playing. Two distorted sounds can be heard in the background, one of them most probably coming from an electric guitar and the other from a synth bass. | 2013-03-18T04:19:15Z | DJ SOUND MUSIC | ["Music", "Independent music", "Tender music"] | ["drums", "piano", "distorted sound", "electronic sound", "no melody"] | 2 | y0w7FyJcZ8w | 5376 |
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;