musiccaps_details (view)
2 rows where musiccaps_aspects contains "pop/backgroundmusic" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- pop/backgroundmusic · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- amateur recording 1
- e-bass 1
- female voices singing 1
- gargling 1
- keys 1
- machine noises 1
- recording noises 1
musiccaps_names (array) 5 ✖
- Music 2
- /m/02zsn 1
- Gargling 1
- Inside, small room 1
- Sewing machine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Princess Cut Blouse Stitching Part -2 ( DIY ) | The song is an acoustic pop song with acoustic guitar strumming chords, a drumset playing a simple steady groove accompanied by a bassline. At every end of a phrase some keys are playing a chord in the middle to higher register. In the foreground are some noises made by a machine. This song may be playing as background music. | 2015-07-12T02:11:44Z | Sew with me | From this video you can learn how to stitch the Princess Cut Blouse.(DIY) To view the the Cutting of the princess cut blouse click on the link below : https://www.youtube.com/watch?v=72Tgol-Tc-4 FACEBOOK :https://www.facebook.com/profile.php?id=100007610296549 TWITTER :https://twitter.com/sohaa1309 YOUTUBE : www.youtube.com/c/sewwithme | ["Music", "Sewing machine", "Inside, small room"] | ["pop/backgroundmusic", "acoustic guitar", "acoustic drums", "e-bass", "keys", "machine noises"] | 6 | 92k_81uqMSM | 973 | |
GARGLING CHALLENGE | This recording contains gargling noises to which a lot of female voices sing along. In the background you can hear a full pop song that serves as background music. The recording is full of fast popping noises. This seems to be an amateur recording. | 2014-10-08T19:30:12Z | free souls | Thanks for watching! Don't forget to Subscribe! Thumbs up if we should do more videos like this! Click below for our social media links. The free souls: https://twitter.com/freesoulsrules Berta's links: https://twitter.com/MarinBerta Judith's links: https://twitter.com/EatFuckGrier https://www.youtube.com/user/JuDiith1999 http://instagram.com/hamloveu Claudia's links: https://twitter.com/dumbgrier https://www.youtube.com/user/clgamo Mireia's links: https://twitter.com/sweetdallasx http://instagram.com/sweetdallasx?mod... https://www.youtube.com/channel/UC-4K_NnHnLq1WBEHXNiRjUQ Yolanda's links: https://twitter.com/14Yolanda_ | ["/m/02zsn", "Music", "Gargling"] | ["pop/backgroundmusic", "gargling", "female voices singing", "recording noises", "amateur recording"] | 6 | nSBDyxxscks | 4537 |
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;