musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and musiccaps_names contains "Scissors"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
【攻略】Bottuns and Scissors walkthrough 6×6Levels 161~180 | The low quality recording features mono sounds of beeping sound effects, scissors sound effects and some wooden foley effects. It is obviously a video game sound effect, but the sound quality is low since it does not have much depth to it. | 2014-03-07T14:18:16Z | カプセル(゜д゜) | 【NEXT】・・https://www.youtube.com/watch?v=G2ofDmg_t7Q stage165・・・2:58 stage170・・・6:41 stage175・・・10:10 良いと思ったら、チャンネル登録よろしくお願いします! | ["Scissors", "Music"] | ["scissors sound effects", "mono", "low quality", "beeping sound effects", "wooden foley effects", "video game"] | 4 | D_QEW1Lnl2Q | 1495 | |
Soppa 365 esittää - Sakset | This clip features a percussion based song with no other instruments. The focus is on the kick drum and snare with minimal use of cymbals. Hand claps are played along with the snare. The percussion beat is random. Sounds of snipping are played. Crunchy sounds are played in this clip. There is the sound of sizzling in this clip. | 2015-01-14T12:08:49Z | Soppa365 | Sakset ovat oiva apuväline keittiössä. Mihin kaikkeen niitä voi oikein hyödyntää myös ruoanlaitossa? Tsekkaa parhaat reseptit, kuumimmat ruokailmiöt ja kiinnostavimmat kokit Soppa 365:stä, Suomen herkullisimmasta ruokayhteisöstä. Lisää vinkkejä löydät täältä: https://www.soppa365.fi/reseptit/ https://www.facebook.com/soppa365 https://twitter.com/soppa365 http://instagram.com/soppa365 | ["Scissors", "Music"] | ["percussion focused song", "sound of cutting", "crunchy sounds", "sizzling sound", "hand claps", "snipping sound"] | 0 | ITYv4126yhk | 1909 |
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;