musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "male vocal sample"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- amateur recording · 2 ✖
- male vocal sample · 2 ✖
- bass 1
- child female voice 1
- dj performance 1
- electronic drums 1
- house 1
- riser 1
- scratching 1
- turntable 1
- uptempo 1
- urban sound 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Next Generation Dj's | This is an amateur recording of a little girl performing on a turntable. The girl can be heard talking to the person behind the camera. There is a repeating male vocal sample and an electronic drum beat in the piece that is playing. There is an urban atmosphere to the track. | 2007-09-25T18:48:01Z | Masta Hanksta | Time coded vinyl $20.00 bucks. Needles Stanton's $30 bucks a pair. Numark Mixer $99.99 Watching my daughters scratch priceless. | ["Scratching (performance technique)", "Music", "Scratch", "Speech"] | ["amateur recording", "child female voice", "dj performance", "male vocal sample", "turntable", "scratching", "electronic drums", "urban sound"] | 9 | DQzg3cZeYSw | 1476 | |
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;