musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy piano melody" and musiccaps_aspects contains "snappy rimshots"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- groovy piano melody · 2 ✖
- happy 2
- snappy rimshots · 2 ✖
- background music 1
- easygoing 1
- euphoric 1
- flat male vocal 1
- fun 1
- live performance 1
- low quality 1
- mellow bells melody 1
- nostalgic 1
- passionate female vocal 1
- pop 1
- saxophone melody 1
- shimmering hi hats 1
- simple bass 1
- smooth bass 1
- snaps 1
- sustained strings melody 1
- wide shimmering shakers 1
musiccaps_names (array) 6 ✖
- Music 2
- Music for children 1
- Music of Asia 1
- Plop 1
- Song 1
- Speech 1
youtube_published (date) 2 ✖
- 2011-01-13 1
- 2012-12-19 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
3 ohin jingle bell | The recording features a live performance of a pop song that consists of passionate female vocal singing over groovy piano melody, sustained strings melody, smooth bass, widely spread shimmering shaker, snaps and snappy rimshots. It sounds euphoric, as it brings a Christmassy vibe, and is also happy and nostalgic. | 2012-12-19T10:33:32Z | Ganaa Jigee | ["Music of Asia", "Music", "Song"] | ["live performance", "pop", "passionate female vocal", "sustained strings melody", "groovy piano melody", "smooth bass", "wide shimmering shakers", "snaps", "snappy rimshots", "euphoric", "happy", "nostalgic"] | 4 | 20Vh6z6Ie0E | 325 | ||
ZAAC L03 | The low quality recording features a flat male talking over background music that consists of a saxophone melody played over shimmering hi hats, snappy rimshots, groovy piano melody, mellow bells melody and simple bass. It sounds happy, fun and easygoing - like something kids would listen to. | 2011-01-13T14:18:30Z | MynameisZaac | Corso di lingua inglese per bambini | ["Music", "Music for children", "Plop", "Speech"] | ["low quality", "flat male vocal", "background music", "saxophone melody", "snappy rimshots", "shimmering hi hats", "groovy piano melody", "mellow bells melody", "simple bass", "happy", "fun", "easygoing"] | 4 | bciw4Tqp6h4 | 3639 |
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;