musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "flat female vocal" and musiccaps_aspects contains "smooth bass guitar" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 23 ✖
- flat female vocal · 2 ✖
- low quality 2
- punchy snare 2
- smooth bass guitar · 2 ✖
- drums break 1
- energetic 1
- energetic crash 1
- groovy 1
- groovy electric guitar chords progression 1
- mono 1
- noisy ambience 1
- organ keys glissando 1
- pigs oink sound effects 1
- punchy kick 1
- rock 1
- shimmering cymbals 1
- shimmering hi hats 1
- short snare roll 1
- simple kick pattern 1
- soft rock 1
- vintage 1
- warm 1
- wide acoustic rhythm guitar 1
musiccaps_names (array) 4 ✖
- Music 2
- Oink 1
- Rock and roll 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Iron Eagle - Old Enough to Rock and Roll.flv | The low quality recording features a rock song that consists of groovy electric guitar chord progression, smooth bass guitar, punchy snare and kick hits, shimmering hi hats and flat female vocals singing over it. At the end of the first half of the loop, there is a short snare roll alongside glissando organ keys melody, sliding perfectly into the next section, which begins with the energetic crash hit. It sounds energetic, groovy, and kind of vintage and warm, since it really sounds old - especially because the song is in mono. | 2010-06-21T07:13:17Z | 2kgt | ["Music", "Roll", "Rock and roll"] | ["low quality", "mono", "groovy electric guitar chords progression", "smooth bass guitar", "punchy snare", "punchy kick", "short snare roll", "flat female vocal", "rock", "shimmering hi hats", "organ keys glissando", "energetic", "groovy", "energetic crash", "vintage", "warm"] | 4 | lOIzOWKd47E | 4393 |
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;