musiccaps_details (view)
1 row where musiccaps_author = 6 and youtube_description = "Baby Scratch is a free App available at Apple AppStore. Made a little try out as handling is pretty amazing with awesome sample sound. App has 3 build in beat loops and some samples and voice recording to scratch. Latency of scratch sounds is noticeable but still best of all checked scratch Apps."
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Scratching with iPhone App "Baby Scratch" | This audio contains someone scratching to a backing drumtrack. This song may be playing at home demonstrating an app to someone. | 2010-03-03T14:03:57Z | MarcFloat | Baby Scratch is a free App available at Apple AppStore. Made a little try out as handling is pretty amazing with awesome sample sound. App has 3 build in beat loops and some samples and voice recording to scratch. Latency of scratch sounds is noticeable but still best of all checked scratch Apps. | ["Scratching (performance technique)", "Music"] | ["amateur recording", "scratching", "backing drums", "medium tempo"] | 6 | 1LA64TXatWk | 262 |
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;