video8: releases: 3 rows where country_release = "Japan", encoding = "NTSC" 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

3 rows where country_release = "Japan", encoding = "NTSC" and title_id = 806

descending

id ▼	title_id	catalog_number	release_date	country_release	encoding	runtime_mins	list_price	upc	audio_format	subtitle_language	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.
895	Ghostbusters 806	CSWF-8001	1989.10.21	Japan	NTSC	105.0	¥3,800	4-988009-800172	Hi-Fi Mono/Digital Stereo Dolby Surround	Japanese	This release has a new lower price and CSWF catalog no, but the same copyright date as the earlier release is retained for artwork; actual release date is most likely 1989, due to being one of the first CSWF cat#. The earliest releases after RCA switched from 00HS to CSWF-800X apparently didn't update the copyright date to 1989 until later numbers in the series.
896	Ghostbusters 806	00HS-80008		Japan	NTSC	105.0	¥12,950			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
        );