video8: releases: 1 row where country_release = "Japan" 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 country_release = "Japan" and title_id = 794

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
880	From Here to Eternity 794			CSWF-8010	1988 (on insert); 1989.10.21 (in databook)	Japan	NTSC	118.0	¥3,800	4-988009-801070		Hi-Fi/Digital Mono			Japanese		RCA "Classic Series" release; Note: This might be the smoking gun that the earliest CSWF numbers (and the transition from 00HS to CSWF) started in 1988, not 1989, as I previously thought. It's unclear whether this title had a 1988 release with 00HS (and simply didn't update the copyright date, like other early CSWF titles), or whether this was its first release on 8mm in Japan

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