prelib_editionprix
Data license: Licence Ouverte version 2.0
3 rows where prix_id = 24 sorted by prix_id descending
This data as json, CSV (advanced)
id | edition_id | prix_id ▲ | annee |
---|---|---|---|
24 | La Basse-Bretagne 2178 | Prix Broquette-Gonin 24 | 1940 |
301 | Les Marins de l’an II 3081 | Prix Broquette-Gonin 24 | 1975 |
345 | Georges Cadoudal ou la liberté 2827 | Prix Broquette-Gonin 24 | 1971 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "prelib_editionprix" ( "id" INTEGER, "edition_id" INTEGER, "prix_id" INTEGER, "annee" INTEGER ,PRIMARY KEY ([id]), FOREIGN KEY(edition_id) REFERENCES prelib_edition(id), FOREIGN KEY(prix_id) REFERENCES prelib_prix(id) );