musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "rock&roll" and musiccaps_names contains "Independent music" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- rock&roll · 2 ✖
- acoustic drum 1
- bouncy melody 1
- clean electric guitar strumms 1
- danceable 1
- e-bass 1
- e-guitar 1
- happy 1
- male voice singing 1
- nasal male vocals 1
- organ 1
- positive 1
- positive vibes 1
- upbeat drum kit 1
- uptempo 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 | |
Ticking of the Clock | The rock music features a nasal male voice. The voice follows a strummed electric guitar with a clean sound. The bass is backing the guitar strumms. The beat is made first with ticking sounds but then it's played by a drum kit. | 2011-12-07T15:49:23Z | Amygdalaindiemusic | Song about time pressures | ["Music", "Independent music", "Song", "Tick-tock"] | ["rock&roll", "nasal male vocals", "clean electric guitar strumms", "upbeat drum kit", "bouncy melody", "danceable", "happy", "positive"] | 5 | fsTVRca31nI | 3983 |
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;