home / xpn_countdown

countdown_genres

15 rows where genre_id = 129

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
322,129 322 322 outlaw country 129
411,129 411 411 outlaw country 129
439,129 439 439 outlaw country 129
502,129 502 502 outlaw country 129
504,129 504 504 outlaw country 129
545,129 545 545 outlaw country 129
550,129 550 550 outlaw country 129
596,129 596 596 outlaw country 129
672,129 672 672 outlaw country 129
695,129 695 695 outlaw country 129
699,129 699 699 outlaw country 129
724,129 724 724 outlaw country 129
792,129 792 792 outlaw country 129
846,129 846 846 outlaw country 129
870,129 870 870 outlaw country 129

Advanced export

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

CSV options:

CREATE TABLE countdown_genres (
            rank INTEGER,
            genre_id INTEGER,
            FOREIGN KEY (rank) REFERENCES countdown(rank),
            FOREIGN KEY (genre_id) REFERENCES genres(id),
            PRIMARY KEY (rank, genre_id)
        );
CREATE INDEX idx_countdown_genres_genre ON countdown_genres(genre_id);
Powered by Datasette · Queries took 3.538ms