musiccaps_details (view)
5 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "bass" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- amateur recording · 5 ✖
- bass · 5 ✖
- uptempo · 5 ✖
- digital drums 3
- pop 2
- background laughter 1
- backround music 1
- crowd cheering and singing 1
- drums 1
- electronic/rock 1
- guitar 1
- guitar melody 1
- house 1
- male vocal sample 1
- male voice rapping/singing 1
- male voices singing 1
- motor racing sounds 1
- reggaeton 1
- riser 1
- synth pad 1
- synthesizer 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Elite car show Golf sound system | Someone is playing a song out of a speaker. The song contains a guitar melody and a digital drum hitting the bass drum on every beat along with a bass-melody. This is an amateur recording. The song is in very poor audio-quality. | 2010-07-04T23:20:07Z | Guillermo Leal | ["Music", "Burst, pop"] | ["pop", "amateur recording", "digital drums", "guitar melody", "bass", "uptempo"] | 6 | Qz8hNRg-7G0 | 2655 | ||
PASAME LA BOTELLA | A low sounding male voice is rapping over a fast paced drums playing a reggaeton beat along with a bass. Something like a guitar is playing the melody along. This recording is of poor audio-quality. In the background a laughter can be noticed. This song may be playing in a bar. | 2006-06-19T08:12:15Z | jaimikow | el spike y yo | ["Scratching (performance technique)", "Music"] | ["reggaeton", "drums", "bass", "background laughter", "guitar", "male voice rapping/singing", "amateur recording", "uptempo"] | 6 | aUvHaURNgY8 | 3546 | |
[HD Fancam] 121027 GD&TOP Stage - Big Bang ALIVE Tour in Malaysia | This song contains digital drums with a kick on every beat and an open hi hat on the backbeat. A synth bass is playing a melody along with an e-bass. A male voice is singing along with a male backing singer. The crowd is cheering and singing along. This is an amateur recording and of poor audio-quality. This song may be playing at a live concert. | 2012-10-28T10:36:56Z | Choi Rain | Song - High High and Knock Out Credit to Me | ["Crowd", "Music", "Pop music", "Bellow"] | ["pop", "amateur recording", "digital drums", "synthesizer", "bass", "male voices singing", "crowd cheering and singing", "uptempo"] | 6 | cabjr3xtcR4 | 3722 | |
FIA ERC GEKO Ypres Rally 2014 - Sound & Music | This audio contains a song with a bass playing a repeating melody along with a digital drums being in the background and a synth pad sound in the higher register. Towards the end the song is getting louder. In the foreground you can hear motor racing sounds. This song may be playing for a youtube video. | 2014-06-20T21:05:28Z | FIA European Rally Championship | ["Music", "Accelerating, revving, vroom", "Race car, auto racing", "Exciting music"] | ["backround music", "amateur recording", "electronic/rock", "synth pad", "bass", "digital drums", "motor racing sounds", "uptempo"] | 6 | pIE-3sIPlvY | 4698 | ||
House music MIX 2011 | A synthesizer is playing a rhythmic, simple bassline. A male vocal sample that seems to be processed and pitched down is being played with a delay. Then a riser noise comes in sounding like wind that is getting stronger. This song may be playing while playing at a play-station with your friends. | 2010-08-20T01:41:48Z | RetroBlitz | _____________________________ That there, my first Top 10 Electro House music Comment, rate and join in my channel soon be posting the link to download 10 songs and Mix (Top 10 Electro House Music) I hope you like 10º Paris - Deluxe (Original Mix) 09º Daman-R - Close my Eyes (Boom&Base Radio Mix) 08º Fawni - Serious (In Styles Remix) 07º Megara vs DJ Lee - I Want You (Mikkas Remix) 06º Disco Reason - Hey Girl (Lokko Freakz Remix) 05º Stanhide - Model Game (Cherry Coke Remix) 04º Fast Foot - Toy Killer 03º Phantom Project - Super Girl 02º Eiffel 65 - I'm Blue (Fend Brothers Remix) 01º Max Furtado - Mensage From My Heart (Original Mix) | ["Electronic music", "House music", "Music", "Techno"] | ["house", "amateur recording", "bass", "male vocal sample", "riser", "uptempo"] | 6 | xuepy6SFOf8 | 5362 |
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;