musiccaps_details (view)
2 rows where musiccaps_aspects contains "e-bass" and musiccaps_aspects contains "positive vibes"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- e-bass · 2 ✖
- positive vibes · 2 ✖
- acoustic drum 1
- acoustic drums 1
- amateur recording 1
- bongos 1
- crowd cheering 1
- e-guitar 1
- female singer 1
- latin 1
- male backing voices 1
- male voice singing 1
- medium tempo 1
- organ 1
- rock&roll 1
- steel drum 1
- uptempo 1
musiccaps_names (array) 4 ✖
- Music 2
- Independent music 1
- Singing 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Strawberry Alarm Clock - California Day | This song contains acoustic drums playing a steady groove with an uplifting bassline that repeats itself. An e-guitar is playing a single note melody while strings and an organ are elevating the energy with long higher register chords. Some backing vocals are singing along to the strings while the male voice is singing his melody. This song may be playing on a sunny day at the park having a picnic. | 2010-06-27T08:13:10Z | Optinon | Genre: Pop/Psychedelic Pop Released: 1970 Release: California Day / Three | ["Music", "Independent music"] | ["rock&roll", "acoustic drum", "e-bass", "organ", "e-guitar", "male voice singing", "uptempo", "positive vibes"] | 6 | BHu95Y_kVQA | 1225 | |
Elida Reyna y Avante - "Me Gustas" | An acoustic drum is playing a latin groove with a cowbell sound and bongos playing along with a bassline underlining. Someone is playing a melody on a steeldrum. The female voice starts singing the same melody. Male voices are supporting her with shouting sounds. The crowd is cheering and clapping along. This song may be playing at a summer festival. | 2010-05-05T13:45:38Z | gcarmona66 | Elida Reyna y Avante "Me Gustas" April 22, 2010 Cattleman's Square - Tejano Explosion San Antonio, Texas | ["Singing", "Music", "Steelpan"] | ["latin", "bongos", "acoustic drums", "female singer", "male backing voices", "e-bass", "steel drum", "crowd cheering", "amateur recording", "medium tempo", "positive vibes"] | 6 | s4PN7iTLdVM | 4921 |
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;