musiccaps_details (view)
2 rows where musiccaps_aspects contains "e-bass", musiccaps_aspects contains "positive energy" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- acoustic drums 2
- e-bass · 2 ✖
- positive energy · 2 ✖
- uptempo 2
- accordion 1
- acoustic guitar 1
- background-noises 1
- country/folk 1
- e-guitar 1
- harmonica 1
- male voice singing 1
- rock/ska 1
musiccaps_names (array) 7 ✖
- Music 2
- Ska · 2 ✖
- Funk 1
- Independent music 1
- Music of Africa 1
- Music of Latin America 1
- Reggae 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Casar Hum Hum Gino e Geno Part Felipe Borges 2013 | A male voice is singing/shouting phrases while an acoustic drum is playing a dance groove along with an e-bass. On top of that a acoustic guitar is playing a melody and another one is strumming chords while an accordion is playing a loud melody that seems to be the lead. The drum fill-ins are panned to the left and right side of the speakers. This song sounds like the people are having fun. This song may be playing at a dance event in the countryside. | 2013-05-16T00:23:52Z | W Comunicação | Nova Música do Gino e Geno Lançamento | ["Music of Africa", "Music", "Ska", "Music of Latin America"] | ["country/folk", "acoustic drums", "e-bass", "accordion", "acoustic guitar", "male voice singing", "uptempo", "positive energy"] | 6 | Fv9swdLA-lo | 1674 | |
Bad Manners - Don't Knock The Bald Head (Live) Part 3 | An acoustic drum is playing a faster groove along with a bassline and a harmonica playing a chord on the offbeat and in a lower key. A e-guitar is playing a melody in the mid range. There are some background noises that remind me of someone brushing his/her teeth. This song may be playing live at a bar. | 2009-04-09T13:42:52Z | OxBlood66 | 3 tracks from Don't Knock The Bald Head. Skaville UK, Walking In The Sunshine, King Ska/FA. | ["Funk", "Music", "Independent music", "Reggae", "Ska"] | ["rock/ska", "e-bass", "acoustic drums", "e-guitar", "harmonica", "background-noises", "uptempo", "positive energy"] | 6 | KdNhYvN4Xoo | 2101 |
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;