musiccaps_details (view)
2 rows where musiccaps_aspects contains "boomy", musiccaps_aspects contains "muffled" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- boomy · 2 ✖
- low quality 2
- muffled · 2 ✖
- punchy snare 2
- energetic 1
- groovy bass 1
- hard 808 bass 1
- high pitched female vocals 1
- hip hop 1
- jungle 1
- mono 1
- noisy 1
- percussive shoe tapping 1
- reverberant 1
- shimmering hi hats 1
- shimmering shakers 1
- upbeat 1
musiccaps_names (array) 5 ✖
- Music 2
- Electronic music 1
- House music 1
- Pulse 1
- Tap 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Solo Thomas Marek Tap Dance | The low quality recording features a percussive shoe tapping over hip hop beat playing in the background. The beat consists of shimmering shakers, hard 808 bass and punchy snare. At one point the shoe tapper gets a little bit sloppy. It sounds a bit muffled, boomy and reverberant. | 2008-06-20T10:12:27Z | Thomas Marek | Thomas Marek´s Solo in his production "about_tap vol no 2" live at Kampnagel Hamburg, Germany 2006 | ["Music", "Tap"] | ["low quality", "hip hop", "shimmering shakers", "hard 808 bass", "punchy snare", "percussive shoe tapping", "reverberant", "muffled", "boomy"] | 4 | We-bFXFjWaM | 3117 | |
DJ Princess @ Pulse | The low quality recording features an electro song being played in a club and it consists of high pitched, repetitive, female vocals singing over groovy bass, punchy snare hits and shimmering hi hats. It sounds upbeat and energetic, even though the sound is muffled, noisy and in mono. | 2007-09-10T06:28:59Z | Shannon Wood | spinnin' at our (dubbz, me) bday party 8/31/07 | ["Electronic music", "House music", "Music", "Pulse"] | ["low quality", "boomy", "muffled", "high pitched female vocals", "jungle", "groovy bass", "punchy snare", "shimmering hi hats", "upbeat", "noisy", "mono", "energetic"] | 4 | XI9CNsX6JSE | 3173 |
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;