musiccaps_details (view)
3 rows where musiccaps_names contains "Crackle"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- amateur singing 1
- bad audio quality 1
- cameras clicking 1
- club music 1
- crowd cheering 1
- crowds clapping 1
- crowds whistling 1
- dance music 1
- dealing with depression 1
- dj 1
- drum machine 1
- electronic music 1
- emotional 1
- encouraging crowd 1
- energetic 1
- fast tempo 1
- female singer 1
- guitar accompaniment 1
- home video 1
- inspiring 1
- instrumental 1
- intense drumming 1
- live performance 1
- loneliness 1
- loud 1
- loud clapping 1
- low quality 1
- motivational 1
- music concert 1
- orchestra 1
- passionate 1
- poor audio quality 1
- reverberant 1
- romantic 1
- screeching 1
- song cover 1
- spirited 1
- static 1
- strong bass line 1
- thumping 1
- turntable 1
- vibrations 1
- vocalisation 1
- whistling 1
musiccaps_names (array) 4 ✖
- Crackle · 3 ✖
- Music 3
- Applause 2
- Exciting music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Alizee - Sound Of Silence, Moscow, 18-05-2008 | A female singer sings this live cover version of a famous song. The song is medium tempo with guitar accompaniment, crowds cheering and whistling and cameras clicking. The song has a poor audio quality and has a lot of ambient crowd noises, | 2008-05-24T21:54:38Z | mazarakis | Alizee - Sound Of Silence, Moscow, 18-05-2008 thanks to Didevil, ikm, pavel zubarev links to big files is here http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#028 http://alizeeforum.fastbb.ru/?1-0-0-00001519-000-0-0#029.001 | ["Applause", "Music", "Crackle"] | ["female singer", "live performance", "song cover", "romantic", "loneliness", "dealing with depression", "crowds whistling", "crowds clapping", "poor audio quality", "song cover", "guitar accompaniment", "encouraging crowd", "emotional", "spirited", "passionate", "inspiring", "motivational", "amateur singing", "strong bass line", "home video", "music concert", "cameras clicking"] | 1 | 69oU6LfyQ_4 | 731 | |
Battle of Sounds in Lapu-Lapu City Mactan,Cebu... | This song is an instrumental. The tempo is fast but as the audio quality is bad it is hard to hear the song well. The song is electronic music with a boomy, thumping drum beats, rhythmic vocalisation and electrical wave disturbance causing a screechy ,static sound. This song is an Electro Pop song. | 2014-06-16T22:09:35Z | jim earl | Category: 4pcs.Compression Driver Tweeter, 4pcs.15inches Mid-Speakers, 4pcs.18inches Sub-Speakers,3pcs.Power Amplifier unlimited wattage of Amps.,Speakers & Processors Quantity... | ["Music", "Crackle"] | ["instrumental", "loud", "thumping", "vocalisation", "energetic", "dance music", "dj", "turntable", "drum machine", "static", "fast tempo", "bad audio quality", "screeching", "thumping", "vibrations", "electronic music", "intense drumming", "dj", "club music"] | 7 | TKSFbf-wQ8I | 2831 | |
The Sound of Music Closing Night Curtain Call | The low quality recording features a wide crowd sound effects that include loud clapping, whistling and cheering, while the orchestra is playing in the background. It sounds reverberant and like it was recorded with a better quality phone. | 2011-05-06T05:34:25Z | Steve Wiles | Glacier Peak High School Spring Musical The Sound of Music http://glacierpeakdrama.org/ | ["Applause", "Music", "Crackle", "Exciting music"] | ["low quality", "loud clapping", "crowd cheering", "whistling", "orchestra", "reverberant"] | 4 | X96v9LlsjJM | 3164 |
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;