musiccaps_details (view)

2 rows where musiccaps_names contains "Scissors"

✎ View and edit SQL

This data as json, CSV (advanced)

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

CSV options: 

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;