musiccaps_details (view)
5 rows where musiccaps_aspects contains "mono", musiccaps_aspects contains "phone recording" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- low quality 5
- mono · 5 ✖
- phone recording · 5 ✖
- noisy 4
- electro 2
- energetic 2
- 4 on the floor kick 1
- 4 on the floor kick pattern 1
- addictive violin melody 1
- buzzy 1
- clapping 1
- claps 1
- crowd harmonizing singing 1
- exciting 1
- flat male vocal 1
- fun 1
- happy 1
- joyful 1
- loud wooden percussion 1
- low didgeridoo tone 1
- low frequencies 1
- papery sound effect 1
- repetitive didgeridoo melody 1
- repetitive synth melody 1
- reverberant background music 1
- shimmering hi hats 1
- thin 1
musiccaps_names (array) 5 ✖
- Music 5
- Didgeridoo 2
- Heart murmur 1
- Printer 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Heartbeat of home audition - Ceili Moore | The low quality recording features a reverberant background electro music that consists of claps, "4 on the floor" kick pattern and addictive violin melody. It is in mono and it sounds like it was recorded with a phone in a medium size room, as the music is playing through a speaker. | 2013-04-15T11:22:24Z | ceili moore | ["Heart murmur", "Music"] | ["low quality", "mono", "phone recording", "reverberant background music", "electro", "energetic", "clapping", "4 on the floor kick", "addictive violin melody"] | 4 | GcnLApOeCh0 | 1743 | ||
The Travel digeridoo - it's spiral !! | The low quality recording features a repetitive didgeridoo melody. The recording is noisy and in mono, since it was probably recorded with a phone, and it sounds really low in frequency. | 2010-11-01T15:42:25Z | Sound For Health / Jonny Cope | New travel didgeridoo, hand-carved wood and great sound! http://www.soundforhealth.com/collections/didgeridoos/products/travel-didgeridoo-fantastic-sound-hand-carved-plain-wood-spiral | ["Didgeridoo", "Music"] | ["repetitive didgeridoo melody", "low frequencies", "noisy", "low quality", "phone recording", "mono"] | 4 | NPXZIqxKvXA | 2335 | |
Debra Wilson of MadTV plays Didgeridoo | The low recording features a low, buzzy didgeridoo tone. It is mono and noisy, as it was probably recorded with a phone. | 2011-08-22T23:57:02Z | Barry Martin | This great sounding eucalyptus didgeridoo, hand-crafted and Aboriginal-made in Australia, is available in our California didgeridoo shop at http://www.laoutback.com Debra Wilson is a wonderful friend, actor, comedian, spiritualist and animal rights activist. | ["Didgeridoo", "Music"] | ["low didgeridoo tone", "low quality", "mono", "noisy", "buzzy", "phone recording"] | 4 | _cg_IfaD1C0 | 3479 | |
HP c 5280 RESET | The low quality recording features an electro song played on a small device that reproduces thin, mono sounds, especially since it was recorded with a phone. The song consists of a repetitive synth melody, flat male vocal, "4 on the floor" kick pattern, claps and shimmering shakers. There are some papery sound effects too. Overall it is noisy and it sounds fun and happy. | 2010-07-14T07:10:54Z | xbalbyx | how to reset your hp c5280 | ["Printer", "Music"] | ["low quality", "electro", "thin", "noisy", "mono", "phone recording", "papery sound effect", "repetitive synth melody", "flat male vocal", "4 on the floor kick pattern", "claps", "shimmering hi hats", "fun", "happy"] | 4 | iHYOaGNdweo | 4176 | |
AIESEC Turkey shout at NATCO before the Opening | The low quality recording features a crowd harmonized singing over loud wooden percussion. The recording is noisy, in mono and it sounds energetic, joyful and exciting. | 2011-05-24T08:40:49Z | Tatish | NATCO 2011 | ["Music", "Whoop"] | ["low quality", "noisy", "mono", "phone recording", "loud wooden percussion", "crowd harmonizing singing", "energetic", "exciting", "joyful"] | 4 | nf3LGAL1LZc | 4568 |
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;