video8: publishers: 1 row where parent

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

id: ID
name: Publisher Name
country: Country
parent_id: Parent Entity
notes: Notes

1 row where parent_id = 98

descending

id ▼	name	country	parent_id	notes
97	Pony (ポニー)		Pony Canyon 98

Advanced export

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

CREATE TABLE publishers (
            id INTEGER PRIMARY KEY,
            name TEXT NOT NULL,
            country TEXT,
            parent_id INTEGER REFERENCES publishers(id),
            notes TEXT
        );