musiccaps_details (view)
2 rows where musiccaps_aspects contains "crowd noise" and musiccaps_author = 4 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- crowd noise · 2 ✖
- low quality 2
- noisy 2
- digital bell 1
- emotional 1
- energetic 1
- energetic drums 1
- groovy bass 1
- live performance 1
- mellow synth keys melody 1
- mono 1
- muffled male vocal 1
- passionate 1
- r&b 1
musiccaps_names (array) 5 ✖
- Bell 1
- Doorbell 1
- Electric piano 1
- Keyboard (musical) 1
- Piano 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Meritline Wireless Door Bell, with 1 Remote 1 Chime 38 Sounds, V003A (item# 600-860) | The low quality recording features a sound of a digital bell, followed by crowd noises in the background. The recording is noisy and in mono. | 2010-09-23T06:25:40Z | Ivy Gu | Wireless Door Bell, with 1 Remote 1 Chime 38 Sounds, V003A Features: DIY designing, you don't need to seek help from professionals or set line or excavate a hole on the wall. You can install it anywhere you like in your apartment. 38 sound types to choose from 'Up' & 'Down'switch, including many popular songs. 3 levels volume control. Working distance: approx. 50 meters or 164 feet . Powered by: Remote 1 12V 23A battery (MN21/MS21 V23GAL L1028), Chime 110V . Attention: Please use the good quality alkaline battery for doorbells. Don't use the bad quality battery Don't install this product in the sunny or rainy place. http://www.meritline.com/wireless-door-bell-with-1-remote-1-chime-38-sounds-v003a---p-55406.aspx?source=youtube | ["Bell", "Doorbell"] | ["low quality", "noisy", "mono", "crowd noise", "digital bell"] | 4 | Vbx6TFxSPYY | 3012 | |
Rehearsal Part IV - Urban R&B Worship Flowing and Worshiping | The low quality recording features a live performance of a R&B song that consists of muffled male vocal singing over groovy bass guitar, mellow synth keys melody and energetic drums. There are some crowd noises in the background. The recording is noisy, as it was probably recorded with a phone, but it sounds energetic, passionate and emotional. | 2010-06-12T04:53:53Z | Gospel Musicians | http://gospelmusicians.com/ - Jamal Hartwell, Lydell on bass Tate, Cash on Drums. Worshipping during rehearsal to some Urban Worship | ["Electric piano", "Keyboard (musical)", "Piano"] | ["low quality", "noisy", "crowd noise", "live performance", "r&b", "energetic drums", "muffled male vocal", "groovy bass", "mellow synth keys melody", "energetic", "passionate", "emotional"] | 4 | 2I6pPRWKsCQ | 348 |
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;