releases: release: 1 row where "added" is on date 2021-08-10 and bought = 0 sorted by added descending

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 2021-08-10 and bought = 0 sorted by added descending

descending

Link	source	label	album	artist	title	comment	url	email_id	added ▲	done	done_date	bought
bcrel,https://choongum.bandcamp.com/album/biomorphism	bcrel	choongum	Biomorphism			“Biomorphism models artistic design elements on naturally occurring patterns or shapes reminiscent of nature and living organisms. Taken to its extreme it attempts to force naturally occurring shapes onto functional devices.	https://choongum.bandcamp.com/album/biomorphism	X0z2kwAhS9aEBycbWIXvTA@geopod-ismtpd-1-0	2021-08-10 17:23:21	1	2021-08-10 17:23:21	0

Advanced export

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

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