home / releases

release

Data license: ODbL

email_id
Email that contains the release
added
When was the email received
source
bcrel: 'New release from {label} ...' email bcblurb: '... new music for you on Bandcamp' email <user-handle>: Usernames from the '... and {num} others bought new music on Bandcamp' email
album/artist/label/title
Release details
url
Release URL, which may contain the user handle who bought the release
comment
All bcblurb and some bcrel releases come with comments - they would be found here
done
Signifies a release that has been reviewed / listened to
done_date
The datetime the above happened
bought
Signifies a release that has also been bought

1 row where "added" is on date 2022-04-26 and label = "alyosen" sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: added (date)

Link source label album artist title comment url email_id added ▲ done done_date bought
abem_ea,https://alyosen.bandcamp.com/track/space-desert?from=fanactv-abem_ea abem_ea alyosen Space Desert Alyosen Space Desert   https://alyosen.bandcamp.com/track/space-desert?from=fanactv-abem_ea dHBmmQV4TAGS3j4vOX9MpQ@geopod-ismtpd-1-2 2022-04-26 05:32:01 0   0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE 'release' (
    source TEXT,
    label TEXT,
    album TEXT,
    artist TEXT,
    title TEXT,
    comment TEXT,
    url TEXT,
    email_id TEXT,
    added TEXT,
    done INTEGER DEFAULT 0,
    done_date TEXT,
    bought INTEGER DEFAULT 0,
    PRIMARY KEY(source, url) ON CONFLICT IGNORE
  );
Powered by Datasette · Queries took 371.141ms · Data license: ODbL