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

2 rows where bought = 0 and "done_date" is on date 2021-06-03 sorted by added descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: added (date), done_date (date)

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
  );