musiccaps_details (view)
2 rows where musiccaps_aspects contains "crowd cheering" and musiccaps_aspects contains "whistling" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- crowd cheering · 2 ✖
- low quality 2
- whistling · 2 ✖
- acoustic guitar melody 1
- echoing passionate male vocal 1
- emotional 1
- folk 1
- joyful 1
- live performance 1
- loud clapping 1
- orchestra 1
- passionate 1
- reverberant 1
- sustained strings melody 1
musiccaps_names (array) 6 ✖
- Music 2
- Applause 1
- Crackle 1
- Exciting music 1
- Music of Asia 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Toshi - Piya Re (UKU) | The low quality recording features a live performance of a folk song that consists of an echoing passionate male vocal singing over sustained strings melody, acoustic guitar melody and some crowd cheering and whistling sounds in the background. It sounds joyful, passionate and emotional overall. | 2009-04-12T19:01:17Z | MariumSaeed | ["Singing", "Music of Asia", "Music"] | ["low quality", "folk", "live performance", "echoing passionate male vocal", "sustained strings melody", "acoustic guitar melody", "crowd cheering", "whistling", "joyful", "passionate", "emotional"] | 4 | e1PG31QlQmc | 3836 |
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;