INSERT INTO movies JSON '{ "id": "movie:1", "title": "Vertigo", "year": 1958, "genre": "drama", "country": "DE", "director": { "id": "artist:3" }, "actors": [ { "id": "artist:15", "role": "John Ferguson" }, { "id": "artist:16", "role": "Madeleine Elster" }, { "id": "artist:282", "role": null } ] }'; INSERT INTO movies JSON '{ "id": "movie:2", "title": "Alien", "year": 1979, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:4" }, "actors": [ { "id": "artist:5", "role": "Ripley" } ] }'; INSERT INTO movies JSON '{ "id": "movie:3", "title": "Titanic", "year": 1997, "genre": "drama", "country": "USA", "director": { "id": "artist:6" }, "actors": [ { "id": "artist:109", "role": "Rose DeWitt Bukater" }, { "id": "artist:110", "role": "Jack Dawson" } ] }'; INSERT INTO movies JSON '{ "id": "movie:4", "title": "Sacrifice", "year": 1986, "genre": "drama", "country": "FR", "director": { "id": "artist:9" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:5", "title": "Volte/Face", "year": 1997, "genre": "Action", "country": "USA", "director": { "id": "artist:10" }, "actors": [ { "id": "artist:11", "role": "Sean Archer/Castor Troy" }, { "id": "artist:12", "role": "Castor Troy/Sean Archer" } ] }'; INSERT INTO movies JSON '{ "id": "movie:6", "title": "Sleepy Hollow", "year": 1999, "genre": "Fantastique", "country": "USA", "director": { "id": "artist:13" }, "actors": [ { "id": "artist:14", "role": "Constable Ichabod Crane" }, { "id": "artist:96", "role": "Katrina Anne Van Tassel" }, { "id": "artist:97", "role": "Le cavalier" } ] }'; INSERT INTO movies JSON '{ "id": "movie:7", "title": "American Beauty", "year": 1999, "genre": "Comédie", "country": "USA", "director": { "id": "artist:17" }, "actors": [ { "id": "artist:18", "role": "Lester Burnham" }, { "id": "artist:19", "role": "Carolyn Burnham" } ] }'; INSERT INTO movies JSON '{ "id": "movie:8", "title": "Impitoyable", "year": 1992, "genre": "Western", "country": "USA", "director": { "id": "artist:20" }, "actors": [ { "id": "artist:20", "role": "William Munny" }, { "id": "artist:21", "role": "Little Bill Dagget" }, { "id": "artist:22", "role": "Ned Logan" } ] }'; INSERT INTO movies JSON '{ "id": "movie:9", "title": "Gladiator", "year": 2000, "genre": "drama", "country": "USA", "director": { "id": "artist:4" }, "actors": [ { "id": "artist:23", "role": "Maximus" }, { "id": "artist:147", "role": "Commode" }, { "id": "artist:148", "role": "Lucilla" }, { "id": "artist:149", "role": "Marc Aurele" } ] }'; INSERT INTO movies JSON '{ "id": "movie:10", "title": "Blade Runner", "year": 1982, "genre": "Action", "country": "USA", "director": { "id": "artist:4" }, "actors": [ { "id": "artist:24", "role": "Deckard" }, { "id": "artist:25", "role": "Batty" } ] }'; INSERT INTO movies JSON '{ "id": "movie:11", "title": "Piège de cristal", "year": 1988, "genre": "Action", "country": "USA", "director": { "id": "artist:26" }, "actors": [ { "id": "artist:27", "role": "McClane" } ] }'; INSERT INTO movies JSON '{ "id": "movie:12", "title": "58 minutes pour vivre", "year": 1990, "genre": "Action", "country": "USA", "director": { "id": "artist:28" }, "actors": [ { "id": "artist:27", "role": "McClane" } ] }'; INSERT INTO movies JSON '{ "id": "movie:13", "title": "Van Gogh", "year": 1990, "genre": "drama", "country": "FR", "director": { "id": "artist:29" }, "actors": [ { "id": "artist:30", "role": "Van Gogh" } ] }'; INSERT INTO movies JSON '{ "id": "movie:14", "title": "Seven", "year": 1995, "genre": "crime", "country": "USA", "director": { "id": "artist:31" }, "actors": [ { "id": "artist:18", "role": "Doe" }, { "id": "artist:22", "role": "Somerset" }, { "id": "artist:32", "role": "Mills" } ] }'; INSERT INTO movies JSON '{ "id": "movie:15", "title": "Twelve Monkeys", "year": 1995, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:33" }, "actors": [ { "id": "artist:27", "role": "Cole" } ] }'; INSERT INTO movies JSON '{ "id": "movie:16", "title": "Le last_name de la rose", "year": 1986, "genre": "crime", "country": "FR", "director": { "id": "artist:34" }, "actors": [ { "id": "artist:35", "role": "Baskerville" }, { "id": "artist:36", "role": "de Melk" } ] }'; INSERT INTO movies JSON '{ "id": "movie:17", "title": "Pulp fiction", "year": 1994, "genre": "Action", "country": "USA", "director": { "id": "artist:37" }, "actors": [ { "id": "artist:11", "role": "Vincent Vega" }, { "id": "artist:27", "role": "Butch Coolidge" }, { "id": "artist:37", "role": "Jimmy Dimmick" }, { "id": "artist:38", "role": "Jules Winnfield" }, { "id": "artist:39", "role": "Jody" }, { "id": "artist:40", "role": "Mia Wallace" }, { "id": "artist:97", "role": "Capt. Koons" }, { "id": "artist:98", "role": "Winston \"The Wolf\" Wolfe" }, { "id": "artist:99", "role": "Pumpkin (Ringo)" } ] }'; INSERT INTO movies JSON '{ "id": "movie:18", "title": "Mary à tout prix", "year": 1998, "genre": "Comédie", "country": "USA", "director": { "id": "artist:41" }, "actors": [ { "id": "artist:42", "role": "Mary Jensen Matthews" }, { "id": "artist:43", "role": "Pat Healy" } ] }'; INSERT INTO movies JSON '{ "id": "movie:19", "title": "Terminator", "year": 1984, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:6" }, "actors": [ { "id": "artist:44", "role": "Terminator" } ] }'; INSERT INTO movies JSON '{ "id": "movie:20", "title": "Les dents de la mer", "year": 1975, "genre": "Horreur", "country": "FR", "director": { "id": "artist:45" }, "actors": [ { "id": "artist:46", "role": "Martin Brody" }, { "id": "artist:47", "role": "Quint" }, { "id": "artist:48", "role": "Matt Hooper" } ] }'; INSERT INTO movies JSON '{ "id": "movie:21", "title": "Le silence des agneaux", "year": 1990, "genre": "crime", "country": "USA", "director": { "id": "artist:49" }, "actors": [ { "id": "artist:50", "role": "Dr. Hannibal Lecter" }, { "id": "artist:51", "role": "Clarice Starling" } ] }'; INSERT INTO movies JSON '{ "id": "movie:22", "title": "Godzilla", "year": 1998, "genre": "Action", "country": "USA", "director": { "id": "artist:58" }, "actors": [ { "id": "artist:59", "role": "Dr. Nikos Tatopoulos" }, { "id": "artist:60", "role": "Philippe Roaché" } ] }'; INSERT INTO movies JSON '{ "id": "movie:23", "title": "Matrix", "year": 1999, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:61" }, "actors": [ { "id": "artist:62", "role": "Neo" }, { "id": "artist:63", "role": "Morpheus" } ] }'; INSERT INTO movies JSON '{ "id": "movie:24", "title": "Mission: Impossible", "year": 1996, "genre": "Action", "country": "USA", "director": { "id": "artist:64" }, "actors": [ { "id": "artist:60", "role": "Franz Krieger" }, { "id": "artist:65", "role": "Ethan Hunt" }, { "id": "artist:66", "role": "Jim Phelps" }, { "id": "artist:67", "role": "Claire Phelps" } ] }'; INSERT INTO movies JSON '{ "id": "movie:25", "title": "Kagemusha", "year": 1980, "genre": "Guerre", "country": "JP", "director": { "id": "artist:68" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:26", "title": "Les pleins pouvoirs", "year": 1997, "genre": "crime", "country": "USA", "director": { "id": "artist:20" }, "actors": [ { "id": "artist:20", "role": "Luther Whitney" }, { "id": "artist:21", "role": "Le président Richmond" }, { "id": "artist:69", "role": "Seth Frank" } ] }'; INSERT INTO movies JSON '{ "id": "movie:27", "title": "Le gendarme et les extra-terrestres", "year": 1978, "genre": "Comédie", "country": "FR", "director": { "id": "artist:71" }, "actors": [ { "id": "artist:72", "role": "Inspecteur Cruchot" }, { "id": "artist:73", "role": "Adjudant Gerber" } ] }'; INSERT INTO movies JSON '{ "id": "movie:28", "title": "Le monde perdu", "year": 1997, "genre": "Horreur", "country": "USA", "director": { "id": "artist:45" }, "actors": [ { "id": "artist:57", "role": "Dr. Ian Malcolm" } ] }'; INSERT INTO movies JSON '{ "id": "movie:29", "title": "Rain Man", "year": 1988, "genre": "drama", "country": "USA", "director": { "id": "artist:79" }, "actors": [ { "id": "artist:65", "role": "Charlie Babbitt" }, { "id": "artist:80", "role": "Raymond Babbitt" } ] }'; INSERT INTO movies JSON '{ "id": "movie:30", "title": "Top Gun", "year": 1986, "genre": "Action", "country": "USA", "director": { "id": "artist:81" }, "actors": [ { "id": "artist:53", "role": "Iceman" }, { "id": "artist:65", "role": "Lt. Pete Maverick Mitchell" }, { "id": "artist:82", "role": "Charlotte Blackwood" } ] }'; INSERT INTO movies JSON '{ "id": "movie:31", "title": "Les bronzés font du ski", "year": 1979, "genre": "Comédie", "country": "FR", "director": { "id": "artist:83" }, "actors": [ { "id": "artist:75", "role": "Nathalie Morin" }, { "id": "artist:76", "role": "Christiane" }, { "id": "artist:84", "role": "Jean-Claude Dus" }, { "id": "artist:85", "role": "Jérôme" }, { "id": "artist:86", "role": "Popeye" } ] }'; INSERT INTO movies JSON '{ "id": "movie:32", "title": "Le bon, la brute et le truand", "year": 1966, "genre": "Western", "country": "IT", "director": { "id": "artist:219" }, "actors": [ { "id": "artist:20", "role": null } ] }'; INSERT INTO movies JSON '{ "id": "movie:33", "title": "Psychose", "year": 1960, "genre": "Thriller", "country": "USA", "director": { "id": "artist:3" }, "actors": [ { "id": "artist:88", "role": "Bates" }, { "id": "artist:89", "role": "Lila Crane" }, { "id": "artist:90", "role": "Marion Crane" } ] }'; INSERT INTO movies JSON '{ "id": "movie:34", "title": "Le retour du Jedi", "year": 1983, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:91" }, "actors": [ { "id": "artist:24", "role": "Han Solo" }, { "id": "artist:92", "role": "Luke Skywalker" }, { "id": "artist:93", "role": "Princesse Leia" } ] }'; INSERT INTO movies JSON '{ "id": "movie:35", "title": "Les oiseaux", "year": 1963, "genre": "Horreur", "country": "USA", "director": { "id": "artist:3" }, "actors": [ { "id": "artist:94", "role": "Mitch Brenner" }, { "id": "artist:95", "role": "Melanie Daniels" } ] }'; INSERT INTO movies JSON '{ "id": "movie:36", "title": "Reservoir dogs", "year": 1992, "genre": "crime", "country": "USA", "director": { "id": "artist:37" }, "actors": [ { "id": "artist:37", "role": "Mr. Brown" }, { "id": "artist:98", "role": "Mr. White/Larry" }, { "id": "artist:99", "role": "Freddy Newendyke/Mr. Orange" }, { "id": "artist:100", "role": "Nice Guy Eddie" }, { "id": "artist:215", "role": "Mr Blonde" }, { "id": "artist:217", "role": "Mr Pink" }, { "id": "artist:218", "role": "Mr Blue" } ] }'; INSERT INTO movies JSON '{ "id": "movie:37", "title": "Eyes Wide Shut", "year": 1999, "genre": "Thriller", "country": "USA", "director": { "id": "artist:101" }, "actors": [ { "id": "artist:65", "role": "Docteur William \"Bill\" Harford" }, { "id": "artist:102", "role": "Alice Harford" } ] }'; INSERT INTO movies JSON '{ "id": "movie:38", "title": "Shining", "year": 1980, "genre": "Horreur", "country": "FR", "director": { "id": "artist:101" }, "actors": [ { "id": "artist:103", "role": "Jack Torrance" } ] }'; INSERT INTO movies JSON '{ "id": "movie:39", "title": "Pas de printemps pour Marnie", "year": 1964, "genre": "Thriller", "country": "USA", "director": { "id": "artist:3" }, "actors": [ { "id": "artist:35", "role": "\n Mark R" }, { "id": "artist:95", "role": "Marnie Edgar" } ] }'; INSERT INTO movies JSON '{ "id": "movie:40", "title": "Fenêtre sur cour", "year": 1954, "genre": "Suspense", "country": "USA", "director": { "id": "artist:3" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:41", "title": "La mort aux trousses", "year": 1959, "genre": "Suspense", "country": "USA", "director": { "id": "artist:3" }, "actors": [ { "id": "artist:105", "role": "Roger O. Thornhill" }, { "id": "artist:106", "role": "Eve Kendall" }, { "id": "artist:107", "role": "Philipp Vandamm" } ] }'; INSERT INTO movies JSON '{ "id": "movie:42", "title": "Jeanne d''Arc", "year": 1999, "genre": "Guerre", "country": "FR", "director": { "id": "artist:111" }, "actors": [ { "id": "artist:80", "role": null }, { "id": "artist:112", "role": "Jeanne d''Arc" }, { "id": "artist:113", "role": "Yolande d''Aragon" }, { "id": "artist:114", "role": "Charles VII" }, { "id": "artist:115", "role": "Dunois" } ] }'; INSERT INTO movies JSON '{ "id": "movie:43", "title": "Le cinquième élément", "year": 1997, "genre": "Science-fiction", "country": "FR", "director": { "id": "artist:111" }, "actors": [ { "id": "artist:27", "role": "Major Korben Dalla" }, { "id": "artist:112", "role": "Leeloo" }, { "id": "artist:116", "role": "Jean-Baptiste Emmanuel Zorg" }, { "id": "artist:117", "role": "Vito Cornelius" } ] }'; INSERT INTO movies JSON '{ "id": "movie:44", "title": "Léon", "year": 1994, "genre": "Action", "country": "FR", "director": { "id": "artist:111" }, "actors": [ { "id": "artist:60", "role": "Léon" }, { "id": "artist:116", "role": "Norman Stansfield" }, { "id": "artist:118", "role": "Mathilda" } ] }'; INSERT INTO movies JSON '{ "id": "movie:45", "title": "Nikita", "year": 1990, "genre": "Thriller", "country": "FR", "director": { "id": "artist:111" }, "actors": [ { "id": "artist:115", "role": "Bob" }, { "id": "artist:119", "role": "Nikita" }, { "id": "artist:120", "role": "Marco" } ] }'; INSERT INTO movies JSON '{ "id": "movie:46", "title": "Le grand bleu", "year": 1988, "genre": "drama", "country": "FR", "director": { "id": "artist:111" }, "actors": [ { "id": "artist:39", "role": "Johanna" }, { "id": "artist:60", "role": "Enzo Molinari" }, { "id": "artist:121", "role": "Jacques Mayol" } ] }'; INSERT INTO movies JSON '{ "id": "movie:47", "title": "Spider-Man", "year": 2002, "genre": "Action", "country": "USA", "director": { "id": "artist:187" }, "actors": [ { "id": "artist:124", "role": "Spider-Man" }, { "id": "artist:125", "role": "Norman Osborn" }, { "id": "artist:126", "role": "Mary Jane Watson" }, { "id": "artist:127", "role": "Oncle Ben" }, { "id": "artist:128", "role": "Tante May" } ] }'; INSERT INTO movies JSON '{ "id": "movie:48", "title": "King of New York", "year": 1990, "genre": "drama", "country": "USA", "director": { "id": "artist:122" }, "actors": [ { "id": "artist:63", "role": "Jimmy Jump" }, { "id": "artist:97", "role": "Frank White" }, { "id": "artist:124", "role": "Thomas Flanigan" }, { "id": "artist:131", "role": "Dennis Gilley" }, { "id": "artist:132", "role": "Thomas Flanigan" }, { "id": "artist:217", "role": "Test tube" } ] }'; INSERT INTO movies JSON '{ "id": "movie:49", "title": "The Matrix reloaded", "year": 2003, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:61" }, "actors": [ { "id": "artist:62", "role": "Neo" }, { "id": "artist:63", "role": "Morpheus" }, { "id": "artist:210", "role": "Trinity" }, { "id": "artist:211", "role": "Agent Smith" } ] }'; INSERT INTO movies JSON '{ "id": "movie:50", "title": "The Matrix Revolutions", "year": 2003, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:135" }, "actors": [ { "id": "artist:62", "role": "Neo" }, { "id": "artist:63", "role": "Morpheus" }, { "id": "artist:134", "role": "Agent Smith" }, { "id": "artist:136", "role": "Trinity" }, { "id": "artist:137", "role": "L''Oracle" } ] }'; INSERT INTO movies JSON '{ "id": "movie:51", "title": "De bruit et de fureur", "year": 1988, "genre": "drama", "country": "FR", "director": { "id": "artist:138" }, "actors": [ { "id": "artist:139", "role": "Marcel" }, { "id": "artist:140", "role": "Enseignante" }, { "id": "artist:141", "role": "Bruno" } ] }'; INSERT INTO movies JSON '{ "id": "movie:52", "title": "Usual suspects", "year": 1995, "genre": "Thriller", "country": "USA", "director": { "id": "artist:142" }, "actors": [ { "id": "artist:18", "role": "Roger \"Verbal\" Kint" }, { "id": "artist:143", "role": "Micheal McManus" }, { "id": "artist:144", "role": "Dean Keaton" }, { "id": "artist:145", "role": "Fred Fenster" }, { "id": "artist:146", "role": "Todd Hockney" } ] }'; INSERT INTO movies JSON '{ "id": "movie:53", "title": "Bad Lieutenant", "year": 1992, "genre": "drama", "country": "USA", "director": { "id": "artist:122" }, "actors": [ { "id": "artist:98", "role": "Le lieutenant" } ] }'; INSERT INTO movies JSON '{ "id": "movie:54", "title": "Le parrain", "year": 1972, "genre": "drama", "country": "USA", "director": { "id": "artist:181" }, "actors": [ { "id": "artist:137", "role": "Sonny Corleone" }, { "id": "artist:155", "role": "Capt. McCluskey" }, { "id": "artist:176", "role": "Michael Corleone" }, { "id": "artist:182", "role": "Do Vito Corleone" }, { "id": "artist:183", "role": "Kay Adams" }, { "id": "artist:184", "role": "Tom Hagen" } ] }'; INSERT INTO movies JSON '{ "id": "movie:55", "title": "Le parrain II", "year": 1974, "genre": "drama", "country": "USA", "director": { "id": "artist:181" }, "actors": [ { "id": "artist:167", "role": "Don Vito Corleone" }, { "id": "artist:176", "role": "Michael Corleone" }, { "id": "artist:183", "role": "Kay Adams" }, { "id": "artist:184", "role": "Tom Hagen" } ] }'; INSERT INTO movies JSON '{ "id": "movie:56", "title": "Le parrain III", "year": 1990, "genre": "drama", "country": "USA", "director": { "id": "artist:181" }, "actors": [ { "id": "artist:1", "role": "Mary Corleone" }, { "id": "artist:176", "role": "Michael Corleone" }, { "id": "artist:183", "role": "Kay Adams" }, { "id": "artist:186", "role": "Vincent Mancini" } ] }'; INSERT INTO movies JSON '{ "id": "movie:57", "title": "Jackie Brown", "year": 1997, "genre": "crime", "country": "USA", "director": { "id": "artist:37" }, "actors": [ { "id": "artist:167", "role": "Luis Gara" }, { "id": "artist:168", "role": "Jackie Brown" }, { "id": "artist:169", "role": "Melanie" }, { "id": "artist:170", "role": "Ray Nicolette" }, { "id": "artist:212", "role": "Ordell Robbie" } ] }'; INSERT INTO movies JSON '{ "id": "movie:58", "title": "Une journée en enfer", "year": 1995, "genre": "Action", "country": "USA", "director": { "id": "artist:168" }, "actors": [ { "id": "artist:27", "role": "McClane" }, { "id": "artist:38", "role": "Zeus Carver" }, { "id": "artist:169", "role": "Simon Gruber" } ] }'; INSERT INTO movies JSON '{ "id": "movie:59", "title": "Sixième sens", "year": 1999, "genre": "Fantastique", "country": "USA", "director": { "id": "artist:170" }, "actors": [ { "id": "artist:27", "role": "Malcom Crowe" }, { "id": "artist:171", "role": "Cole Sear" } ] }'; INSERT INTO movies JSON '{ "id": "movie:60", "title": "Lost in Translation", "year": 2003, "genre": "romance", "country": "USA", "director": { "id": "artist:172" }, "actors": [ { "id": "artist:173", "role": "Bob Harris" }, { "id": "artist:174", "role": "Charlotte" }, { "id": "artist:175", "role": "John" }, { "id": "artist:176", "role": "Kelly" }, { "id": "artist:177", "role": "Patron Nightclub" } ] }'; INSERT INTO movies JSON '{ "id": "movie:61", "title": "Kill Bill", "year": 2003, "genre": "drama", "country": "USA", "director": { "id": "artist:37" }, "actors": [ { "id": "artist:40", "role": "La mariée, alias \"Black Mamba\"" }, { "id": "artist:213", "role": "O-Ren Ishii" }, { "id": "artist:214", "role": "Bill" }, { "id": "artist:215", "role": "Budd / Sidewinder" }, { "id": "artist:216", "role": "Elle Driver" } ] }'; INSERT INTO movies JSON '{ "id": "movie:62", "title": "Stalingrad", "year": 2001, "genre": "drama", "country": "USA", "director": { "id": "artist:34" }, "actors": [ { "id": "artist:182", "role": "Vassili Zaïtzev" }, { "id": "artist:183", "role": "major König" } ] }'; INSERT INTO movies JSON '{ "id": "movie:63", "title": "Million Dollar Baby", "year": 2005, "genre": "drama", "country": "USA", "director": { "id": "artist:20" }, "actors": [ { "id": "artist:20", "role": "Frankie Dunn" }, { "id": "artist:22", "role": "Eddie Scrap-Iron Dupris" }, { "id": "artist:224", "role": "Maggie Fitzerald" } ] }'; INSERT INTO movies JSON '{ "id": "movie:64", "title": "Pour quelques dollars de plus", "year": 1965, "genre": "Western", "country": "IT", "director": { "id": "artist:219" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:67", "title": "Marie Antoinette", "year": 2006, "genre": "drama", "country": "USA", "director": { "id": "artist:1" }, "actors": [ { "id": "artist:2", "role": "Marie Antoinette" } ] }'; INSERT INTO movies JSON '{ "id": "movie:68", "title": "Soleil vert", "year": 1973, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:7" }, "actors": [ { "id": "artist:8", "role": "sol" } ] }'; INSERT INTO movies JSON '{ "id": "movie:69", "title": "Heat", "year": 1995, "genre": "crime", "country": "USA", "director": { "id": "artist:175" }, "actors": [ { "id": "artist:167", "role": null } ] }'; INSERT INTO movies JSON '{ "id": "movie:70", "title": "Taxi driver", "year": 1976, "genre": "drama", "country": "USA", "director": { "id": "artist:241" }, "actors": [ { "id": "artist:51", "role": "1962" }, { "id": "artist:167", "role": "Travis Bickle " } ] }'; INSERT INTO movies JSON '{ "id": "movie:71", "title": "Les affranchis", "year": 1990, "genre": "crime", "country": "USA", "director": { "id": "artist:241" }, "actors": [ { "id": "artist:167", "role": "James Conway" }, { "id": "artist:242", "role": "Henry Hill" }, { "id": "artist:243", "role": "Tommy DeVito" }, { "id": "artist:244", "role": "Karen Hill" } ] }'; INSERT INTO movies JSON '{ "id": "movie:72", "title": "Casino", "year": 1995, "genre": "crime", "country": "USA", "director": { "id": "artist:241" }, "actors": [ { "id": "artist:167", "role": "Sam ''Ace'' Rothstein" }, { "id": "artist:243", "role": " Nicky Santoro " }, { "id": "artist:245", "role": "Ginger McKenna" } ] }'; INSERT INTO movies JSON '{ "id": "movie:73", "title": "Casino Royale", "year": 2006, "genre": "Action", "country": "USA", "director": { "id": "artist:246" }, "actors": [ { "id": "artist:247", "role": "James Bond" }, { "id": "artist:248", "role": "Vesper Lynd" } ] }'; INSERT INTO movies JSON '{ "id": "movie:74", "title": "Skyfall", "year": 1012, "genre": "Action", "country": "USA", "director": { "id": "artist:17" }, "actors": [ { "id": "artist:247", "role": "James Bond" }, { "id": "artist:249", "role": "M" }, { "id": "artist:250", "role": "Silva" } ] }'; INSERT INTO movies JSON '{ "id": "movie:76", "title": "No country for old men", "year": 2007, "genre": "crime", "country": "USA", "director": { "id": "artist:251" }, "actors": [ { "id": "artist:250", "role": "Anton Chigurh" }, { "id": "artist:252", "role": "Ed Tom Bell" }, { "id": "artist:253", "role": "Llewelyn Moss" } ] }'; INSERT INTO movies JSON '{ "id": "movie:77", "title": "Fargo", "year": 1996, "genre": "crime", "country": "USA", "director": { "id": "artist:251" }, "actors": [ { "id": "artist:217", "role": "Carl Showalter" }, { "id": "artist:254", "role": " Jerry Lundegaard " } ] }'; INSERT INTO movies JSON '{ "id": "movie:78", "title": "Django unchained", "year": 2012, "genre": "Western", "country": "USA", "director": { "id": "artist:37" }, "actors": [ { "id": "artist:110", "role": "Calvin Candie" }, { "id": "artist:212", "role": "Stephen" }, { "id": "artist:255", "role": "Django" }, { "id": "artist:256", "role": "Dr. King Schultz" } ] }'; INSERT INTO movies JSON '{ "id": "movie:79", "title": "Inglourious Basterds", "year": 209, "genre": "Guerre", "country": "USA", "director": { "id": "artist:37" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:80", "title": "Inglourious Basterds", "year": 2009, "genre": "Guerre", "country": "USA", "director": { "id": "artist:37" }, "actors": [ { "id": "artist:32", "role": "Lt. Aldo Raine" }, { "id": "artist:256", "role": "Col. Hans Landa" }, { "id": "artist:257", "role": "Shoshana" }, { "id": "artist:258", "role": "Lt. Archie Hicox" } ] }'; INSERT INTO movies JSON '{ "id": "movie:81", "title": "Les quatre cents coups", "year": 1959, "genre": "drama", "country": "FR", "director": { "id": "artist:259" }, "actors": [ { "id": "artist:260", "role": "Antoine Doinel" } ] }'; INSERT INTO movies JSON '{ "id": "movie:82", "title": "Le dernier métro", "year": 1980, "genre": "drama", "country": "FR", "director": { "id": "artist:259" }, "actors": [ { "id": "artist:130", "role": "Marion Steiner" }, { "id": "artist:261", "role": "Bernard Granger" }, { "id": "artist:262", "role": "Jean-Loup Cottins" } ] }'; INSERT INTO movies JSON '{ "id": "movie:84", "title": "Rio Grande", "year": 1950, "genre": "Western", "country": "USA", "director": { "id": "artist:263" }, "actors": [ { "id": "artist:264", "role": "Lt. Col. Kirby Yorke" }, { "id": "artist:265", "role": "Mrs. Kathleen Yorke" } ] }'; INSERT INTO movies JSON '{ "id": "movie:85", "title": "Interstellar", "year": 2014, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:266" }, "actors": [ { "id": "artist:267", "role": "Cooper" }, { "id": "artist:268", "role": " Brand " }, { "id": "artist:269", "role": "Professor Brand" } ] }'; INSERT INTO movies JSON '{ "id": "movie:86", "title": "Inception", "year": 2010, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:266" }, "actors": [ { "id": "artist:110", "role": "Cobb" }, { "id": "artist:269", "role": "Miles" }, { "id": "artist:270", "role": "Ariadne" }, { "id": "artist:271", "role": "Mal" } ] }'; INSERT INTO movies JSON '{ "id": "movie:87", "title": "Memento", "year": 2000, "genre": "Thriller", "country": "USA", "director": { "id": "artist:266" }, "actors": [ { "id": "artist:272", "role": "Leonard" }, { "id": "artist:273", "role": "Natalie" } ] }'; INSERT INTO movies JSON '{ "id": "movie:88", "title": "Batman begins", "year": 2005, "genre": "Thriller", "country": "USA", "director": { "id": "artist:266" }, "actors": [ { "id": "artist:22", "role": "Lucius Fox " }, { "id": "artist:116", "role": " Jim Gordon " }, { "id": "artist:269", "role": "Alfred" }, { "id": "artist:274", "role": " Bruce Wayne / Batman " }, { "id": "artist:275", "role": "Ducard" } ] }'; INSERT INTO movies JSON '{ "id": "movie:89", "title": "The Dark Knight", "year": 2008, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:266" }, "actors": [ { "id": "artist:22", "role": "Lucius Fox" }, { "id": "artist:116", "role": "Gordon" }, { "id": "artist:269", "role": "Alfred" }, { "id": "artist:274", "role": "Bruce Wayne / Batman" }, { "id": "artist:276", "role": "Joker" }, { "id": "artist:277", "role": "Rachel" } ] }'; INSERT INTO movies JSON '{ "id": "movie:90", "title": "The Dark Knight Rises", "year": 2012, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:266" }, "actors": [ { "id": "artist:22", "role": "Lucius Fox" }, { "id": "artist:116", "role": "Commissioner Gordon" }, { "id": "artist:268", "role": "Selina" }, { "id": "artist:269", "role": "Alfred" }, { "id": "artist:271", "role": "Miranda" }, { "id": "artist:274", "role": "Bruce Wayne / Batman" } ] }'; INSERT INTO movies JSON '{ "id": "movie:91", "title": "Un prophète", "year": 2009, "genre": "drama", "country": "FR", "director": { "id": "artist:278" }, "actors": [ { "id": "artist:279", "role": "Malik El Djebena " }, { "id": "artist:280", "role": "César Luciani" } ] }'; INSERT INTO movies JSON '{ "id": "movie:92", "title": "Nous trois ou rien", "year": 2015, "genre": "drama", "country": "FR", "director": { "id": "artist:281" }, "actors": [ ] }';