musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "reverberant" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality 3
- noisy · 3 ✖
- reverberant · 3 ✖
- uptempo · 3 ✖
- alternative/indie 1
- crowd chattering 1
- didgeridoo melody 1
- electric guitar chords 1
- groovy 1
- groovy repetitive bass guitar 1
- harsh 1
- harsh electric guitar solo melody 1
- hip hop 1
- manic dj scratching sound effect 1
- mono 1
- muffled 1
- percussive toms 1
- shimmering shaker 1
- shimmering shakers 1
- wooden percussion 1
musiccaps_names (array) 8 ✖
- Music 3
- Didgeridoo 1
- Drum machine 1
- Funk 1
- Psychedelic rock 1
- Rock music 1
- Scratch 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ SKRIBE SCRATCH PRACTICE!!!! | The low quality recording features a DJ manically scratching a hip hop song. It is a bit reverberant, noisy and in mono, as it was probably recorded with a poor quality microphone. | 2010-04-08T01:53:49Z | Brandon Young | ["Music", "Scratch", "Drum machine"] | ["low quality", "manic dj scratching sound effect", "uptempo", "hip hop", "reverberant", "noisy", "mono"] | 4 | SDTsifbpGMM | 2748 | ||
Richard Bridge - Didjeridu Reading Didje club | The low quality recording features a didgeridoo melody played over wooden percussion and shimmering shaker. There are some crowd chattering noises in the background. It is reverberant, due to the fact that it was performed in a medium size room, uptempo and the recording is noisy. | 2007-12-19T09:15:09Z | didjedude | This is Richard Bridge a good friend of mine playing at the Reading Didje club (UK).... Enjoy! Richards album is available from Anticearthworks.co.uk under sales, £10 but well worth it. Added 16th August 2012: Rich has a spanking new website of his own now www.richardbridgemusic.com check it out, it's all peace, love and happiness :0) | ["Didgeridoo", "Music"] | ["wooden percussion", "shimmering shaker", "didgeridoo melody", "reverberant", "crowd chattering", "uptempo", "low quality", "noisy"] | 4 | U0sjbOT6hY4 | 2882 | |
Old file.........new knife | The low quality recording features an alternative/indie song that consists of electric guitar chords, groovy repetitive bass guitar, harsh electric guitar solo, percussive toms and shimmering shakers. It sounds muffled, harsh, groovy and it is uptempo and noisy. | 2013-08-16T09:47:12Z | Toothbeard knives | A start to finish slideshow of my last 2 knives aug 2013 | ["Swing music", "Funk", "Music", "Psychedelic rock", "Rock music"] | ["low quality", "alternative/indie", "muffled", "harsh", "noisy", "electric guitar chords", "groovy repetitive bass guitar", "harsh electric guitar solo melody", "percussive toms", "shimmering shakers", "reverberant", "uptempo", "groovy"] | 4 | xrqDoBor2dk | 5356 |
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;