video8: releases: 1 row where audio_format = "Stereo" and title

Data license: CC0 · Data source: github.com/rikker/video8

id: ID
title_id: Title
title_release: Release Title
title_release_lang: Release Title Language
catalog_number: Catalog No.
release_date: Release Date
country_release: Country of Release
encoding: Encoding
runtime_mins: Runtime (mins)
list_price: List Price
upc: UPC
isbn: ISBN
audio_format: Audio Format
audio_language: Audio Language
audio_dubbed: Dubbed
subtitle_language: Subtitles / CC
promo: Promo
notes: Notes

1 row where audio_format = "Stereo" and title_id = 806

descending

id ▼	title_id	title_release	title_release_lang	catalog_number	release_date	country_release	encoding	runtime_mins	list_price	upc	isbn	audio_format	audio_language	audio_dubbed	subtitle_language	promo	notes
894	Ghostbusters 806			A-10488	1985	Japan	NTSC	105.0	¥13,800	n/a		Stereo			Japanese		In Sony.1986.8 and Sony.1986.11 (Aug & Nov 1986) fliers, this title is listed with its 00HS- catalog number but original ¥13,800 price. Typically the A- series had the full price, but I had thought the switch to 00HS- numbers happened at the same time as the price drops (with factory sticker added to the outer shrink). This seems to indicate that the catalog number change preceded the price drop, as this is listed as ¥12,950 price soon after.

Advanced export

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

CREATE TABLE releases (
            id INTEGER PRIMARY KEY,
            title_id INTEGER REFERENCES titles(id),
            title_release TEXT,
            title_release_lang TEXT,
            catalog_number TEXT,
            release_date TEXT,
            country_release TEXT,
            encoding TEXT,
            runtime_mins REAL,
            list_price TEXT,
            upc TEXT,
            isbn TEXT,
            audio_format TEXT,
            audio_language TEXT,
            audio_dubbed TEXT,
            subtitle_language TEXT,
            promo TEXT,
            notes TEXT
        );