musiccaps_details (view)
4 rows where musiccaps_aspects contains "low quality" and musiccaps_names contains "Radio" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- low quality · 4 ✖
- noisy 4
- distorted 3
- crushed 2
- mono 2
- rock 2
- aggressive 1
- camera shuttering sound effects 1
- chill 1
- cover 1
- crowd yelling crowd effect 1
- crushed audio 1
- distorted bass guitar 1
- easygoing 1
- electric guitar solo melody 1
- electro 1
- energetic 1
- funky electric guitar chords 1
- groovy 1
- groovy bass 1
- harsh 1
- muffled instrumental 1
- outdoor atmosphere 1
- passionate male vocal 1
- relaxing 1
- resonating 1
- subwoofer 1
- vintage 1
musiccaps_names (array) 6 ✖
- Music 4
- Radio · 4 ✖
- Bass guitar 1
- Microwave oven 1
- Plucked string instrument 1
- Rock and roll 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1kw am dds pwm transmitter broadcast class d | The low quality recording features funky electric guitar chords, electric guitar solo melody and groovy bass playing in the background. The recording is very noisy, distorted and harsh, but it is still easygoing and chill - like something you would listen to when you are trying to relax. | 2014-04-26T14:11:17Z | amhercules | High quality broadcast transmitter 1kw ,class D ,PWM,DDS | ["Music", "Radio", "Rock and roll", "Plucked string instrument"] | ["low quality", "noisy", "mono", "funky electric guitar chords", "electric guitar solo melody", "groovy bass", "easygoing", "distorted", "harsh", "chill", "relaxing"] | 4 | AVuh8-CucrE | 1130 | |
Drift Sound Car Astra do deomar triton 500 rms. | The low quality recording features a resonating, distorted, crushed electro song being played on a car subwoofer. It sounds very aggressive and energetic too. There are some outdoor atmosphere sounds, since it was recorded outside. | 2013-11-06T14:35:52Z | EDER CARTES GONÇALVES | Drift Sound Car Astra do deomar triton 500 rms | ["Music", "Radio", "Microwave oven"] | ["electro", "distorted", "resonating", "noisy", "low quality", "outdoor atmosphere", "aggressive", "energetic", "crushed", "subwoofer"] | 4 | aYrjw3gjGuk | 3554 | |
Radio Syd | The low quality recording features a rock song sung by passionate male vocalists, after which there are camera shuttering and crowd yelling sound effects. The recording is in mono and overall it sounds distorted, crushed, noisy and vintage. | 2007-03-29T18:15:40Z | completeoutdoors | Offshore Swedish Pirate Radio Syd from 1962/64.The ship Cheeta 11 became home of Radio Caroline after their Mi Amigo ship was grounded in storm.Radio Syd broadcast on the VHF/FM band. | ["Music", "Radio"] | ["low quality", "mono", "noisy", "camera shuttering sound effects", "crowd yelling crowd effect", "rock", "passionate male vocal", "distorted", "crushed", "vintage"] | 4 | VpikuLP_9qQ | 3034 | |
Rats - Pearl Jam | The low quality recording features a cover of a rock song and it consists of distorted bass guitar playing over muffled audio. The recording is distorted and very noisy, almost crushed, but it still sounds groovy. | 2009-11-05T15:21:32Z | frschone | I like this song very much, so I thought, lets cover it. There is much improvisation in it. In the solo itself I did my own thing :P | ["Bass guitar", "Music", "Radio"] | ["distorted bass guitar", "crushed audio", "muffled instrumental", "noisy", "low quality", "cover", "rock", "groovy"] | 4 | R3urUtvSgkU | 2662 |
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;