video8: releases: 20 rows where audio_format = "Mono", country

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

20 rows where audio_format = "Mono", country_release = "Japan" and encoding = "NTSC"

descending

id ▼	title_id	catalog_number	release_date	country_release	encoding	runtime_mins	list_price	upc	audio_format	audio_language	audio_dubbed	subtitle_language	notes
672	And Then There Were None [Ten Little Indians] 634	CSWW-8356 (in databook); 8F-5002 (on insert spine)	1989.10.21	Japan	NTSC	90.0	¥4,700	4-988117-500230	Mono	Japanese	Y
681	Au Revoir Mon Amour 641	SRWF-9913		Japan	NTSC		¥4,700		Mono
841	Easy Rider 764	A-10005	1984	Japan	NTSC	95.0	¥13,800	n/a	Mono			Japanese
851	Eyes of Laura Mars 771	A-10016	1984	Japan	NTSC	103.0	¥13,800	n/a	Mono			Japanese
870	Fort Apache The Bronx 786	DV-0067	1989.10.21	Japan	NTSC	120.0	¥3,800		Mono			Japanese
902	Gloria 812	A-?????	1984	Japan	NTSC	121.0	¥13,800	n/a	Mono			Japanese	new catalog# sticker over insert spine; fuzzy in pic
921	Guess Who's Coming to Dinner 825	00HS-80058		Japan	NTSC	103.0	¥12,950	n/a	Mono			Japanese	00HS sticker on spine
973	Jason and the Argonauts 861	A-????? (sticker over top)		Japan	NTSC		¥13,800		Mono
1067	Midnight Express 928	A-?????? (beneath sticker)	1984	Japan	NTSC	120.0	¥13,800	n/a	Mono			Japanese
1068	Midnight Express 928	00HS-80022 (sticker on spine)	1984	Japan	NTSC	120.0	¥13,800/¥12,950	n/a	Mono			Japanese	Older release with alternate cover
1218	Spider-Man 1039	A-??107??		Japan	NTSC		¥13,800	n/a	Mono
1251	Taxi Driver 1063	00HS-80010 (sticker over spine)		Japan	NTSC	114.0	¥12,950	n/a	Mono			Japanese	Sticker over insert spine
1258	The 7th Voyage of Sinbad 1069	A-10214		Japan	NTSC	88.0	¥13,800	n/a	Mono			Japanese
1288	The China Syndrome 1088	00HS-80061	1984	Japan	NTSC	122.0	¥12,950		Mono			Japanese
1307	The Drunken Master II 1102	SRWF-9964	1994	Japan	NTSC	101.0	¥4,700	4-988009-996479	Mono			Japanese
1333	The Incredible Melting Man 1124	A-?????? (fuzzy in pic)		Japan	NTSC	82.0	¥13,800		Mono			Japanese
1334	The Incredible Melting Man 1124	00HS-80059	1986.09.21	Japan	NTSC	82.0	¥12,950		Mono			Japanese
1336	The Inspector General 1126	CSWW-8358 (in databook); 8F-5111 (on insert spine)	1989.10.21	Japan	NTSC	102.0	¥3,800	4-988117-511137	Mono			Japanese
2059	Various - Music in Monk Time 1777	78HM-14	1985.12.21	Japan	NTSC	60.0	¥7,800		Mono
2087	Duke Ellington - Memories of the Duke 1805	EN-501		Japan	NTSC	81.0	¥10,800		Mono

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