musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "soft rock" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- punchy snare · 2 ✖
- soft rock · 2 ✖
- drums break 1
- emotional 1
- flat female vocal 1
- groovy bass guitar 1
- low quality 1
- noisy ambience 1
- passionate 1
- passionate female vocal 1
- pigs oink sound effects 1
- sad 1
- shimmering cymbals 1
- shimmering hi hats 1
- simple kick pattern 1
- smooth bass guitar 1
- soft kick hits 1
- wide acoustic rhythm guitar 1
- wide electric guitar melody 1
musiccaps_names (array) 3 ✖
- Music 2
- Oink 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Miley Cyrus - I hope you find it official music video | The Soft Rock song features a passionate female vocalist singing over a wide electric guitar melody, punchy snare, soft kick hits, groovy bass guitar and shimmering hi-hats. It sounds sad, emotional and passionate - like something you would listen to on a day you are feeling down. | 2010-12-25T16:59:54Z | Misslill15 | Fanmade music video. | ["Music", "Tender music"] | ["soft rock", "passionate female vocal", "wide electric guitar melody", "punchy snare", "shimmering hi hats", "soft kick hits", "groovy bass guitar", "sad", "emotional", "passionate"] | 4 | -v5hgCh3M2w | 100 | |
The Pig Files: Episode 1 | The low quality recording features a soft rock song playing over pigs oinks sound effects. The song contains a short drum break at the beginning, punchy snare, simple kick pattern, smooth bass guitar, wide acoustic rhythm guitar, shimmering cymbals and flat female vocals singing over it. Sounds like it is some kind of documentary about pigs, as the song is playing in the background. | 2007-04-01T11:50:05Z | miffywickham | National Sit-In at Wasleys Piggery, South Australia. Music by Mel Watson. | ["Music", "Oink"] | ["low quality", "pigs oink sound effects", "soft rock", "noisy ambience", "drums break", "flat female vocal", "wide acoustic rhythm guitar", "smooth bass guitar", "punchy snare", "simple kick pattern", "shimmering cymbals"] | 4 | kvIt_9P79Ro | 4366 |
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;