INSERT INTO movies JSON '{ "id": "movie:1", "title": "Vertigo", "year": 1958, "genre": "drama", "country": "DE", "director": { "id": "artist:3", "last_name": "Hitchcock", "first_name": "Alfred", "birth_date": "1899" }, "actors": [ { "id": "artist:15", "first_name": "James", "last_name": "Stewart", "birth_date": "1908", "role": "John Ferguson" }, { "id": "artist:16", "first_name": "Kim", "last_name": "Novak", "birth_date": "1925", "role": "Madeleine Elster" }, { "id": "artist:282", "first_name": "Arthur", "last_name": "Pierre", "birth_date": null, "role": null } ] }'; INSERT INTO movies JSON '{ "id": "movie:2", "title": "Alien", "year": 1979, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:4", "last_name": "Scott", "first_name": "Ridley", "birth_date": "1937" }, "actors": [ { "id": "artist:5", "first_name": "Sigourney", "last_name": "Weaver", "birth_date": "1949", "role": "Ripley" } ] }'; INSERT INTO movies JSON '{ "id": "movie:3", "title": "Titanic", "year": 1997, "genre": "drama", "country": "USA", "director": { "id": "artist:6", "last_name": "Cameron", "first_name": "James", "birth_date": "1954" }, "actors": [ { "id": "artist:109", "first_name": "Kate", "last_name": "Winslet", "birth_date": "1975", "role": "Rose DeWitt Bukater" }, { "id": "artist:110", "first_name": "Leonardo", "last_name": "DiCaprio", "birth_date": "1974", "role": "Jack Dawson" } ] }'; INSERT INTO movies JSON '{ "id": "movie:4", "title": "Sacrifice", "year": 1986, "genre": "drama", "country": "FR", "director": { "id": "artist:9", "last_name": "Tarkovski", "first_name": "Andrei", "birth_date": "1932" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:5", "title": "Volte/Face", "year": 1997, "genre": "Action", "country": "USA", "director": { "id": "artist:10", "last_name": "Woo", "first_name": "John", "birth_date": "1946" }, "actors": [ { "id": "artist:11", "first_name": "John", "last_name": "Travolta", "birth_date": "1954", "role": "Sean Archer/Castor Troy" }, { "id": "artist:12", "first_name": "Nicolas", "last_name": "Cage", "birth_date": "1964", "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", "last_name": "Burton", "first_name": "Tim", "birth_date": "1958" }, "actors": [ { "id": "artist:14", "first_name": "Johnny", "last_name": "Depp", "birth_date": "1964", "role": "Constable Ichabod Crane" }, { "id": "artist:96", "first_name": "Christina", "last_name": "Ricci", "birth_date": "1980", "role": "Katrina Anne Van Tassel" }, { "id": "artist:97", "first_name": "Christopher", "last_name": "Walken", "birth_date": "1943", "role": "Le cavalier" } ] }'; INSERT INTO movies JSON '{ "id": "movie:7", "title": "American Beauty", "year": 1999, "genre": "Comédie", "country": "USA", "director": { "id": "artist:17", "last_name": "Mendes", "first_name": "Sam", "birth_date": "1965" }, "actors": [ { "id": "artist:18", "first_name": "Kevin", "last_name": "Spacey", "birth_date": "1959", "role": "Lester Burnham" }, { "id": "artist:19", "first_name": "Anette", "last_name": "Bening", "birth_date": "1958", "role": "Carolyn Burnham" } ] }'; INSERT INTO movies JSON '{ "id": "movie:8", "title": "Impitoyable", "year": 1992, "genre": "Western", "country": "USA", "director": { "id": "artist:20", "last_name": "Eastwood", "first_name": "Clint", "birth_date": "1930" }, "actors": [ { "id": "artist:20", "first_name": "Clint", "last_name": "Eastwood", "birth_date": "1930", "role": "William Munny" }, { "id": "artist:21", "first_name": "Gene", "last_name": "Hackman", "birth_date": "1930", "role": "Little Bill Dagget" }, { "id": "artist:22", "first_name": "Morgan", "last_name": "Freeman", "birth_date": "1937", "role": "Ned Logan" } ] }'; INSERT INTO movies JSON '{ "id": "movie:9", "title": "Gladiator", "year": 2000, "genre": "drama", "country": "USA", "director": { "id": "artist:4", "last_name": "Scott", "first_name": "Ridley", "birth_date": "1937" }, "actors": [ { "id": "artist:23", "first_name": "Russell", "last_name": "Crowe", "birth_date": "1964", "role": "Maximus" }, { "id": "artist:147", "first_name": "Adam", "last_name": "Baldwin", "birth_date": "1962", "role": "Commode" }, { "id": "artist:148", "first_name": "Ryan", "last_name": "ONeal", "birth_date": "1941", "role": "Lucilla" }, { "id": "artist:149", "first_name": "Marisa", "last_name": "Berenson", "birth_date": "1946", "role": "Marc Aurele" } ] }'; INSERT INTO movies JSON '{ "id": "movie:10", "title": "Blade Runner", "year": 1982, "genre": "Action", "country": "USA", "director": { "id": "artist:4", "last_name": "Scott", "first_name": "Ridley", "birth_date": "1937" }, "actors": [ { "id": "artist:24", "first_name": "Harrison", "last_name": "Ford", "birth_date": "1942", "role": "Deckard" }, { "id": "artist:25", "first_name": "Rutger", "last_name": "Hauer", "birth_date": "1944", "role": "Batty" } ] }'; INSERT INTO movies JSON '{ "id": "movie:11", "title": "Piège de cristal", "year": 1988, "genre": "Action", "country": "USA", "director": { "id": "artist:26", "last_name": "McTierman", "first_name": "John", "birth_date": "1951" }, "actors": [ { "id": "artist:27", "first_name": "Bruce", "last_name": "Willis", "birth_date": "1955", "role": "McClane" } ] }'; INSERT INTO movies JSON '{ "id": "movie:12", "title": "58 minutes pour vivre", "year": 1990, "genre": "Action", "country": "USA", "director": { "id": "artist:28", "last_name": "Harlin", "first_name": "Renny", "birth_date": "1959" }, "actors": [ { "id": "artist:27", "first_name": "Bruce", "last_name": "Willis", "birth_date": "1955", "role": "McClane" } ] }'; INSERT INTO movies JSON '{ "id": "movie:13", "title": "Van Gogh", "year": 1990, "genre": "drama", "country": "FR", "director": { "id": "artist:29", "last_name": "Pialat", "first_name": "Maurice", "birth_date": "1925" }, "actors": [ { "id": "artist:30", "first_name": "Jacques", "last_name": "Dutronc", "birth_date": "1943", "role": "Van Gogh" } ] }'; INSERT INTO movies JSON '{ "id": "movie:14", "title": "Seven", "year": 1995, "genre": "crime", "country": "USA", "director": { "id": "artist:31", "last_name": "Fincher", "first_name": "David", "birth_date": "1962" }, "actors": [ { "id": "artist:18", "first_name": "Kevin", "last_name": "Spacey", "birth_date": "1959", "role": "Doe" }, { "id": "artist:22", "first_name": "Morgan", "last_name": "Freeman", "birth_date": "1937", "role": "Somerset" }, { "id": "artist:32", "first_name": "Brad", "last_name": "Pitt", "birth_date": "1963", "role": "Mills" } ] }'; INSERT INTO movies JSON '{ "id": "movie:15", "title": "Twelve Monkeys", "year": 1995, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:33", "last_name": "Gilliam", "first_name": "Terry", "birth_date": "1940" }, "actors": [ { "id": "artist:27", "first_name": "Bruce", "last_name": "Willis", "birth_date": "1955", "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", "last_name": "Annaud", "first_name": "Jean-Jacques", "birth_date": "1943" }, "actors": [ { "id": "artist:35", "first_name": "Sean", "last_name": "Connery", "birth_date": "1930", "role": "Baskerville" }, { "id": "artist:36", "first_name": "Christian", "last_name": "Slater", "birth_date": "1969", "role": "de Melk" } ] }'; INSERT INTO movies JSON '{ "id": "movie:17", "title": "Pulp fiction", "year": 1994, "genre": "Action", "country": "USA", "director": { "id": "artist:37", "last_name": "Tarantino", "first_name": "Quentin", "birth_date": "1963" }, "actors": [ { "id": "artist:11", "first_name": "John", "last_name": "Travolta", "birth_date": "1954", "role": "Vincent Vega" }, { "id": "artist:27", "first_name": "Bruce", "last_name": "Willis", "birth_date": "1955", "role": "Butch Coolidge" }, { "id": "artist:37", "first_name": "Quentin", "last_name": "Tarantino", "birth_date": "1963", "role": "Jimmy Dimmick" }, { "id": "artist:38", "first_name": "Samuel L.", "last_name": "Jackson", "birth_date": "1948", "role": "Jules Winnfield" }, { "id": "artist:39", "first_name": "Rosanna", "last_name": "Arquette", "birth_date": "1959", "role": "Jody" }, { "id": "artist:40", "first_name": "Uma", "last_name": "Thurman", "birth_date": "1970", "role": "Mia Wallace" }, { "id": "artist:97", "first_name": "Christopher", "last_name": "Walken", "birth_date": "1943", "role": "Capt. Koons" }, { "id": "artist:98", "first_name": "Harvey", "last_name": "Keitel", "birth_date": "1939", "role": "Winston \"The Wolf\" Wolfe" }, { "id": "artist:99", "first_name": "Tim", "last_name": "Roth", "birth_date": "1961", "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", "last_name": "Farrelly", "first_name": "Bobby", "birth_date": "1958" }, "actors": [ { "id": "artist:42", "first_name": "Cameron", "last_name": "Diaz", "birth_date": "1972", "role": "Mary Jensen Matthews" }, { "id": "artist:43", "first_name": "Mat", "last_name": "Dillon", "birth_date": "1964", "role": "Pat Healy" } ] }'; INSERT INTO movies JSON '{ "id": "movie:19", "title": "Terminator", "year": 1984, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:6", "last_name": "Cameron", "first_name": "James", "birth_date": "1954" }, "actors": [ { "id": "artist:44", "first_name": "Arnold", "last_name": "Schwartzenegger", "birth_date": "1947", "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", "last_name": "Spielberg", "first_name": "Steven", "birth_date": "1946" }, "actors": [ { "id": "artist:46", "first_name": "Roy", "last_name": "Scheider", "birth_date": "1932", "role": "Martin Brody" }, { "id": "artist:47", "first_name": "Robert", "last_name": "Shaw", "birth_date": "1927", "role": "Quint" }, { "id": "artist:48", "first_name": "Richard", "last_name": "Dreyfus", "birth_date": "1947", "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", "last_name": "Demme", "first_name": "Jonathan", "birth_date": "1944" }, "actors": [ { "id": "artist:50", "first_name": "Anthony", "last_name": "Hopkins", "birth_date": "1937", "role": "Dr. Hannibal Lecter" }, { "id": "artist:51", "first_name": "Jodie", "last_name": "Foster", "birth_date": null, "role": "Clarice Starling" } ] }'; INSERT INTO movies JSON '{ "id": "movie:22", "title": "Godzilla", "year": 1998, "genre": "Action", "country": "USA", "director": { "id": "artist:58", "last_name": "Emmerich", "first_name": "Roland", "birth_date": "1955" }, "actors": [ { "id": "artist:59", "first_name": "Matthew", "last_name": "Broderick", "birth_date": "1962", "role": "Dr. Nikos Tatopoulos" }, { "id": "artist:60", "first_name": "Jean", "last_name": "Reno", "birth_date": "1948", "role": "Philippe Roaché" } ] }'; INSERT INTO movies JSON '{ "id": "movie:23", "title": "Matrix", "year": 1999, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:61", "last_name": "Wachowski", "first_name": "Andy", "birth_date": "1967" }, "actors": [ { "id": "artist:62", "first_name": "Keanu", "last_name": "Reeves", "birth_date": "1964", "role": "Neo" }, { "id": "artist:63", "first_name": "Laurence", "last_name": "Fishburne", "birth_date": "1961", "role": "Morpheus" } ] }'; INSERT INTO movies JSON '{ "id": "movie:24", "title": "Mission: Impossible", "year": 1996, "genre": "Action", "country": "USA", "director": { "id": "artist:64", "last_name": "De Palma", "first_name": "Brian", "birth_date": "1940" }, "actors": [ { "id": "artist:60", "first_name": "Jean", "last_name": "Reno", "birth_date": "1948", "role": "Franz Krieger" }, { "id": "artist:65", "first_name": "Tom", "last_name": "Cruise", "birth_date": "1962", "role": "Ethan Hunt" }, { "id": "artist:66", "first_name": "John", "last_name": "Voight", "birth_date": "1938", "role": "Jim Phelps" }, { "id": "artist:67", "first_name": "Emmanuelle", "last_name": "Bart", "birth_date": "1965", "role": "Claire Phelps" } ] }'; INSERT INTO movies JSON '{ "id": "movie:25", "title": "Kagemusha", "year": 1980, "genre": "Guerre", "country": "JP", "director": { "id": "artist:68", "last_name": "Kurozawa", "first_name": "Akira", "birth_date": "1910" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:26", "title": "Les pleins pouvoirs", "year": 1997, "genre": "crime", "country": "USA", "director": { "id": "artist:20", "last_name": "Eastwood", "first_name": "Clint", "birth_date": "1930" }, "actors": [ { "id": "artist:20", "first_name": "Clint", "last_name": "Eastwood", "birth_date": "1930", "role": "Luther Whitney" }, { "id": "artist:21", "first_name": "Gene", "last_name": "Hackman", "birth_date": "1930", "role": "Le président Richmond" }, { "id": "artist:69", "first_name": "Ed", "last_name": "Harris", "birth_date": "1950", "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", "last_name": "Girault", "first_name": "Jean", "birth_date": "1924" }, "actors": [ { "id": "artist:72", "first_name": "Louis", "last_name": "De Funs", "birth_date": "1914", "role": "Inspecteur Cruchot" }, { "id": "artist:73", "first_name": "Michel", "last_name": "Galabru", "birth_date": "1922", "role": "Adjudant Gerber" } ] }'; INSERT INTO movies JSON '{ "id": "movie:28", "title": "Le monde perdu", "year": 1997, "genre": "Horreur", "country": "USA", "director": { "id": "artist:45", "last_name": "Spielberg", "first_name": "Steven", "birth_date": "1946" }, "actors": [ { "id": "artist:57", "first_name": "Jeff", "last_name": "Goldblum", "birth_date": "1952", "role": "Dr. Ian Malcolm" } ] }'; INSERT INTO movies JSON '{ "id": "movie:29", "title": "Rain Man", "year": 1988, "genre": "drama", "country": "USA", "director": { "id": "artist:79", "last_name": "Levinson", "first_name": "Barry", "birth_date": "1942" }, "actors": [ { "id": "artist:65", "first_name": "Tom", "last_name": "Cruise", "birth_date": "1962", "role": "Charlie Babbitt" }, { "id": "artist:80", "first_name": "Dustin", "last_name": "Hoffman", "birth_date": "1937", "role": "Raymond Babbitt" } ] }'; INSERT INTO movies JSON '{ "id": "movie:30", "title": "Top Gun", "year": 1986, "genre": "Action", "country": "USA", "director": { "id": "artist:81", "last_name": "Scott", "first_name": "Tony", "birth_date": "1944" }, "actors": [ { "id": "artist:53", "first_name": "Val", "last_name": "Kilmer", "birth_date": "1959", "role": "Iceman" }, { "id": "artist:65", "first_name": "Tom", "last_name": "Cruise", "birth_date": "1962", "role": "Lt. Pete Maverick Mitchell" }, { "id": "artist:82", "first_name": "Kelly", "last_name": "McGillis", "birth_date": "1957", "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", "last_name": "Leconte", "first_name": "Patrice", "birth_date": "1947" }, "actors": [ { "id": "artist:75", "first_name": "Josiane", "last_name": "Balasko", "birth_date": "1950", "role": "Nathalie Morin" }, { "id": "artist:76", "first_name": "Dominique", "last_name": "Lavanant", "birth_date": "1944", "role": "Christiane" }, { "id": "artist:84", "first_name": "Michel", "last_name": "Blanc", "birth_date": "1952", "role": "Jean-Claude Dus" }, { "id": "artist:85", "first_name": "Christian", "last_name": "Clavier", "birth_date": "1952", "role": "Jérôme" }, { "id": "artist:86", "first_name": "Thierry", "last_name": "Lhermite", "birth_date": "1952", "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", "last_name": "Leone", "first_name": "Sergio", "birth_date": "1929" }, "actors": [ { "id": "artist:20", "first_name": "Clint", "last_name": "Eastwood", "birth_date": "1930", "role": null } ] }'; INSERT INTO movies JSON '{ "id": "movie:33", "title": "Psychose", "year": 1960, "genre": "Thriller", "country": "USA", "director": { "id": "artist:3", "last_name": "Hitchcock", "first_name": "Alfred", "birth_date": "1899" }, "actors": [ { "id": "artist:88", "first_name": "Anthony", "last_name": "Perkins", "birth_date": "1932", "role": "Bates" }, { "id": "artist:89", "first_name": "Vera", "last_name": "Miles", "birth_date": "1929", "role": "Lila Crane" }, { "id": "artist:90", "first_name": "Janet", "last_name": "Leigh", "birth_date": "1927", "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", "last_name": "Marquand", "first_name": "Richard", "birth_date": "1938" }, "actors": [ { "id": "artist:24", "first_name": "Harrison", "last_name": "Ford", "birth_date": "1942", "role": "Han Solo" }, { "id": "artist:92", "first_name": "Mark", "last_name": "Hamill", "birth_date": "1951", "role": "Luke Skywalker" }, { "id": "artist:93", "first_name": "Carrie", "last_name": "Fisher", "birth_date": "1956", "role": "Princesse Leia" } ] }'; INSERT INTO movies JSON '{ "id": "movie:35", "title": "Les oiseaux", "year": 1963, "genre": "Horreur", "country": "USA", "director": { "id": "artist:3", "last_name": "Hitchcock", "first_name": "Alfred", "birth_date": "1899" }, "actors": [ { "id": "artist:94", "first_name": "Rod", "last_name": "Taylor", "birth_date": "1930", "role": "Mitch Brenner" }, { "id": "artist:95", "first_name": "Tippi", "last_name": "Hedren", "birth_date": "1931", "role": "Melanie Daniels" } ] }'; INSERT INTO movies JSON '{ "id": "movie:36", "title": "Reservoir dogs", "year": 1992, "genre": "crime", "country": "USA", "director": { "id": "artist:37", "last_name": "Tarantino", "first_name": "Quentin", "birth_date": "1963" }, "actors": [ { "id": "artist:37", "first_name": "Quentin", "last_name": "Tarantino", "birth_date": "1963", "role": "Mr. Brown" }, { "id": "artist:98", "first_name": "Harvey", "last_name": "Keitel", "birth_date": "1939", "role": "Mr. White/Larry" }, { "id": "artist:99", "first_name": "Tim", "last_name": "Roth", "birth_date": "1961", "role": "Freddy Newendyke/Mr. Orange" }, { "id": "artist:100", "first_name": "Chris", "last_name": "Penn", "birth_date": "1966", "role": "Nice Guy Eddie" }, { "id": "artist:215", "first_name": "Michael", "last_name": "Madsen", "birth_date": "1958", "role": "Mr Blonde" }, { "id": "artist:217", "first_name": "Steve", "last_name": "Buscemi", "birth_date": "1957", "role": "Mr Pink" }, { "id": "artist:218", "first_name": "Edward", "last_name": "Bunker", "birth_date": "1933", "role": "Mr Blue" } ] }'; INSERT INTO movies JSON '{ "id": "movie:37", "title": "Eyes Wide Shut", "year": 1999, "genre": "Thriller", "country": "USA", "director": { "id": "artist:101", "last_name": "Kubrick", "first_name": "Stanley", "birth_date": "1928" }, "actors": [ { "id": "artist:65", "first_name": "Tom", "last_name": "Cruise", "birth_date": "1962", "role": "Docteur William \"Bill\" Harford" }, { "id": "artist:102", "first_name": "Nicole", "last_name": "Kidman", "birth_date": "1967", "role": "Alice Harford" } ] }'; INSERT INTO movies JSON '{ "id": "movie:38", "title": "Shining", "year": 1980, "genre": "Horreur", "country": "FR", "director": { "id": "artist:101", "last_name": "Kubrick", "first_name": "Stanley", "birth_date": "1928" }, "actors": [ { "id": "artist:103", "first_name": "Jack", "last_name": "Nicholson", "birth_date": "1937", "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", "last_name": "Hitchcock", "first_name": "Alfred", "birth_date": "1899" }, "actors": [ { "id": "artist:35", "first_name": "Sean", "last_name": "Connery", "birth_date": "1930", "role": "\n Mark R" }, { "id": "artist:95", "first_name": "Tippi", "last_name": "Hedren", "birth_date": "1931", "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", "last_name": "Hitchcock", "first_name": "Alfred", "birth_date": "1899" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:41", "title": "La mort aux trousses", "year": 1959, "genre": "Suspense", "country": "USA", "director": { "id": "artist:3", "last_name": "Hitchcock", "first_name": "Alfred", "birth_date": "1899" }, "actors": [ { "id": "artist:105", "first_name": "Cary", "last_name": "Grant", "birth_date": "1904", "role": "Roger O. Thornhill" }, { "id": "artist:106", "first_name": "Eva Marie", "last_name": "Saint", "birth_date": "1924", "role": "Eve Kendall" }, { "id": "artist:107", "first_name": "James", "last_name": "Mason", "birth_date": "1909", "role": "Philipp Vandamm" } ] }'; INSERT INTO movies JSON '{ "id": "movie:42", "title": "Jeanne d''Arc", "year": 1999, "genre": "Guerre", "country": "FR", "director": { "id": "artist:111", "last_name": "Besson", "first_name": "Luc", "birth_date": "1959" }, "actors": [ { "id": "artist:80", "first_name": "Dustin", "last_name": "Hoffman", "birth_date": "1937", "role": null }, { "id": "artist:112", "first_name": "Milla", "last_name": "Jovovich", "birth_date": "1975", "role": "Jeanne d''Arc" }, { "id": "artist:113", "first_name": "Fane", "last_name": "Dunaway", "birth_date": "1941", "role": "Yolande d''Aragon" }, { "id": "artist:114", "first_name": "John", "last_name": "Malkovitch", "birth_date": "1953", "role": "Charles VII" }, { "id": "artist:115", "first_name": "Tchky", "last_name": "Karyo", "birth_date": "1953", "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", "last_name": "Besson", "first_name": "Luc", "birth_date": "1959" }, "actors": [ { "id": "artist:27", "first_name": "Bruce", "last_name": "Willis", "birth_date": "1955", "role": "Major Korben Dalla" }, { "id": "artist:112", "first_name": "Milla", "last_name": "Jovovich", "birth_date": "1975", "role": "Leeloo" }, { "id": "artist:116", "first_name": "Gary", "last_name": "Oldman", "birth_date": "1958", "role": "Jean-Baptiste Emmanuel Zorg" }, { "id": "artist:117", "first_name": "Ian", "last_name": "Holm", "birth_date": "1931", "role": "Vito Cornelius" } ] }'; INSERT INTO movies JSON '{ "id": "movie:44", "title": "Léon", "year": 1994, "genre": "Action", "country": "FR", "director": { "id": "artist:111", "last_name": "Besson", "first_name": "Luc", "birth_date": "1959" }, "actors": [ { "id": "artist:60", "first_name": "Jean", "last_name": "Reno", "birth_date": "1948", "role": "Léon" }, { "id": "artist:116", "first_name": "Gary", "last_name": "Oldman", "birth_date": "1958", "role": "Norman Stansfield" }, { "id": "artist:118", "first_name": "Natalie", "last_name": "Portman", "birth_date": "1981", "role": "Mathilda" } ] }'; INSERT INTO movies JSON '{ "id": "movie:45", "title": "Nikita", "year": 1990, "genre": "Thriller", "country": "FR", "director": { "id": "artist:111", "last_name": "Besson", "first_name": "Luc", "birth_date": "1959" }, "actors": [ { "id": "artist:115", "first_name": "Tchky", "last_name": "Karyo", "birth_date": "1953", "role": "Bob" }, { "id": "artist:119", "first_name": "Anne", "last_name": "Parillaud", "birth_date": "1960", "role": "Nikita" }, { "id": "artist:120", "first_name": "Jean-Hughes", "last_name": "Anglade", "birth_date": "1955", "role": "Marco" } ] }'; INSERT INTO movies JSON '{ "id": "movie:46", "title": "Le grand bleu", "year": 1988, "genre": "drama", "country": "FR", "director": { "id": "artist:111", "last_name": "Besson", "first_name": "Luc", "birth_date": "1959" }, "actors": [ { "id": "artist:39", "first_name": "Rosanna", "last_name": "Arquette", "birth_date": "1959", "role": "Johanna" }, { "id": "artist:60", "first_name": "Jean", "last_name": "Reno", "birth_date": "1948", "role": "Enzo Molinari" }, { "id": "artist:121", "first_name": "Jean-Marc", "last_name": "Barr", "birth_date": "1960", "role": "Jacques Mayol" } ] }'; INSERT INTO movies JSON '{ "id": "movie:47", "title": "Spider-Man", "year": 2002, "genre": "Action", "country": "USA", "director": { "id": "artist:187", "last_name": "Raimi", "first_name": "Sam", "birth_date": "1959" }, "actors": [ { "id": "artist:124", "first_name": "Wesley", "last_name": "Snipes", "birth_date": "1962", "role": "Spider-Man" }, { "id": "artist:125", "first_name": "Annabella", "last_name": "Sciora", "birth_date": "1964", "role": "Norman Osborn" }, { "id": "artist:126", "first_name": "Isabella", "last_name": "Rosselini", "birth_date": "1952", "role": "Mary Jane Watson" }, { "id": "artist:127", "first_name": "Vincent", "last_name": "Gallo", "birth_date": "1961", "role": "Oncle Ben" }, { "id": "artist:128", "first_name": "Lars", "last_name": "von Trier", "birth_date": "1956", "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", "last_name": "Ferrara", "first_name": "Abel", "birth_date": "1951" }, "actors": [ { "id": "artist:63", "first_name": "Laurence", "last_name": "Fishburne", "birth_date": "1961", "role": "Jimmy Jump" }, { "id": "artist:97", "first_name": "Christopher", "last_name": "Walken", "birth_date": "1943", "role": "Frank White" }, { "id": "artist:124", "first_name": "Wesley", "last_name": "Snipes", "birth_date": "1962", "role": "Thomas Flanigan" }, { "id": "artist:131", "first_name": "Matthieu", "last_name": "Kassowitz", "birth_date": "1967", "role": "Dennis Gilley" }, { "id": "artist:132", "first_name": "Vincent", "last_name": "Cassel", "birth_date": "1966", "role": "Thomas Flanigan" }, { "id": "artist:217", "first_name": "Steve", "last_name": "Buscemi", "birth_date": "1957", "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", "last_name": "Wachowski", "first_name": "Andy", "birth_date": "1967" }, "actors": [ { "id": "artist:62", "first_name": "Keanu", "last_name": "Reeves", "birth_date": "1964", "role": "Neo" }, { "id": "artist:63", "first_name": "Laurence", "last_name": "Fishburne", "birth_date": "1961", "role": "Morpheus" }, { "id": "artist:210", "first_name": "Carrie-Anne", "last_name": "Moss", "birth_date": "1967", "role": "Trinity" }, { "id": "artist:211", "first_name": "Hugo", "last_name": "Weaving", "birth_date": "1960", "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", "last_name": "Phoenix", "first_name": "Joaquin", "birth_date": "1974" }, "actors": [ { "id": "artist:62", "first_name": "Keanu", "last_name": "Reeves", "birth_date": "1964", "role": "Neo" }, { "id": "artist:63", "first_name": "Laurence", "last_name": "Fishburne", "birth_date": "1961", "role": "Morpheus" }, { "id": "artist:134", "first_name": "Mark", "last_name": "Wahlberg", "birth_date": "1971", "role": "Agent Smith" }, { "id": "artist:136", "first_name": "Charlize", "last_name": "Theron", "birth_date": "1975", "role": "Trinity" }, { "id": "artist:137", "first_name": "James", "last_name": "Caan", "birth_date": "1940", "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", "last_name": "Chabrol", "first_name": "Claude", "birth_date": "1930" }, "actors": [ { "id": "artist:139", "first_name": "Isabelle", "last_name": "Huppert", "birth_date": "1953", "role": "Marcel" }, { "id": "artist:140", "first_name": "Anna", "last_name": "Mouglalis", "birth_date": "1978", "role": "Enseignante" }, { "id": "artist:141", "first_name": "Kevin", "last_name": "Costner", "birth_date": "1955", "role": "Bruno" } ] }'; INSERT INTO movies JSON '{ "id": "movie:52", "title": "Usual suspects", "year": 1995, "genre": "Thriller", "country": "USA", "director": { "id": "artist:142", "last_name": "Dern", "first_name": "Laura", "birth_date": "1967" }, "actors": [ { "id": "artist:18", "first_name": "Kevin", "last_name": "Spacey", "birth_date": "1959", "role": "Roger \"Verbal\" Kint" }, { "id": "artist:143", "first_name": "Tom", "last_name": "Hanks", "birth_date": "1956", "role": "Micheal McManus" }, { "id": "artist:144", "first_name": "Tom", "last_name": "Sizemore", "birth_date": "1964", "role": "Dean Keaton" }, { "id": "artist:145", "first_name": "Matt", "last_name": "Damon", "birth_date": "1970", "role": "Fred Fenster" }, { "id": "artist:146", "first_name": "Matthew", "last_name": "Modine", "birth_date": "1959", "role": "Todd Hockney" } ] }'; INSERT INTO movies JSON '{ "id": "movie:53", "title": "Bad Lieutenant", "year": 1992, "genre": "drama", "country": "USA", "director": { "id": "artist:122", "last_name": "Ferrara", "first_name": "Abel", "birth_date": "1951" }, "actors": [ { "id": "artist:98", "first_name": "Harvey", "last_name": "Keitel", "birth_date": "1939", "role": "Le lieutenant" } ] }'; INSERT INTO movies JSON '{ "id": "movie:54", "title": "Le parrain", "year": 1972, "genre": "drama", "country": "USA", "director": { "id": "artist:181", "last_name": "Coppola", "first_name": "Francis Ford", "birth_date": "1940" }, "actors": [ { "id": "artist:137", "first_name": "James", "last_name": "Caan", "birth_date": "1940", "role": "Sonny Corleone" }, { "id": "artist:155", "first_name": "Sterling", "last_name": "Hayden", "birth_date": "1916", "role": "Capt. McCluskey" }, { "id": "artist:176", "first_name": "Al", "last_name": "Pacino", "birth_date": "1940", "role": "Michael Corleone" }, { "id": "artist:182", "first_name": "Marlon", "last_name": "Brando", "birth_date": "1924", "role": "Do Vito Corleone" }, { "id": "artist:183", "first_name": "Diane", "last_name": "Keaton", "birth_date": "1946", "role": "Kay Adams" }, { "id": "artist:184", "first_name": "Robert", "last_name": "Duvall", "birth_date": "1931", "role": "Tom Hagen" } ] }'; INSERT INTO movies JSON '{ "id": "movie:55", "title": "Le parrain II", "year": 1974, "genre": "drama", "country": "USA", "director": { "id": "artist:181", "last_name": "Coppola", "first_name": "Francis Ford", "birth_date": "1940" }, "actors": [ { "id": "artist:167", "first_name": "Robert", "last_name": "De Niro", "birth_date": "1943", "role": "Don Vito Corleone" }, { "id": "artist:176", "first_name": "Al", "last_name": "Pacino", "birth_date": "1940", "role": "Michael Corleone" }, { "id": "artist:183", "first_name": "Diane", "last_name": "Keaton", "birth_date": "1946", "role": "Kay Adams" }, { "id": "artist:184", "first_name": "Robert", "last_name": "Duvall", "birth_date": "1931", "role": "Tom Hagen" } ] }'; INSERT INTO movies JSON '{ "id": "movie:56", "title": "Le parrain III", "year": 1990, "genre": "drama", "country": "USA", "director": { "id": "artist:181", "last_name": "Coppola", "first_name": "Francis Ford", "birth_date": "1940" }, "actors": [ { "id": "artist:1", "first_name": "Sofia", "last_name": "Coppola", "birth_date": "1971", "role": "Mary Corleone" }, { "id": "artist:176", "first_name": "Al", "last_name": "Pacino", "birth_date": "1940", "role": "Michael Corleone" }, { "id": "artist:183", "first_name": "Diane", "last_name": "Keaton", "birth_date": "1946", "role": "Kay Adams" }, { "id": "artist:186", "first_name": "Andy", "last_name": "Garcia", "birth_date": "1956", "role": "Vincent Mancini" } ] }'; INSERT INTO movies JSON '{ "id": "movie:57", "title": "Jackie Brown", "year": 1997, "genre": "crime", "country": "USA", "director": { "id": "artist:37", "last_name": "Tarantino", "first_name": "Quentin", "birth_date": "1963" }, "actors": [ { "id": "artist:167", "first_name": "Robert", "last_name": "De Niro", "birth_date": "1943", "role": "Luis Gara" }, { "id": "artist:168", "first_name": "Pam", "last_name": "Grier", "birth_date": "1949", "role": "Jackie Brown" }, { "id": "artist:169", "first_name": "Bridget", "last_name": "Fonda", "birth_date": "1964", "role": "Melanie" }, { "id": "artist:170", "first_name": "Michael", "last_name": "Keaton", "birth_date": "1951", "role": "Ray Nicolette" }, { "id": "artist:212", "first_name": "Samuel", "last_name": "Jackson", "birth_date": "1948", "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", "last_name": "Grier", "first_name": "Pam", "birth_date": "1949" }, "actors": [ { "id": "artist:27", "first_name": "Bruce", "last_name": "Willis", "birth_date": "1955", "role": "McClane" }, { "id": "artist:38", "first_name": "Samuel L.", "last_name": "Jackson", "birth_date": "1948", "role": "Zeus Carver" }, { "id": "artist:169", "first_name": "Bridget", "last_name": "Fonda", "birth_date": "1964", "role": "Simon Gruber" } ] }'; INSERT INTO movies JSON '{ "id": "movie:59", "title": "Sixième sens", "year": 1999, "genre": "Fantastique", "country": "USA", "director": { "id": "artist:170", "last_name": "Keaton", "first_name": "Michael", "birth_date": "1951" }, "actors": [ { "id": "artist:27", "first_name": "Bruce", "last_name": "Willis", "birth_date": "1955", "role": "Malcom Crowe" }, { "id": "artist:171", "first_name": "M. Night", "last_name": "Shyamalan", "birth_date": "1970", "role": "Cole Sear" } ] }'; INSERT INTO movies JSON '{ "id": "movie:60", "title": "Lost in Translation", "year": 2003, "genre": "romance", "country": "USA", "director": { "id": "artist:172", "last_name": "Osment", "first_name": "Haley Joel", "birth_date": "1988" }, "actors": [ { "id": "artist:173", "first_name": "Tony", "last_name": "Collette", "birth_date": "1972", "role": "Bob Harris" }, { "id": "artist:174", "first_name": "Eric", "last_name": "Leighton", "birth_date": "1962", "role": "Charlotte" }, { "id": "artist:175", "first_name": "Michael", "last_name": "Mann", "birth_date": "1943", "role": "John" }, { "id": "artist:176", "first_name": "Al", "last_name": "Pacino", "birth_date": "1940", "role": "Kelly" }, { "id": "artist:177", "first_name": "Russel", "last_name": "Crowe", "birth_date": "1964", "role": "Patron Nightclub" } ] }'; INSERT INTO movies JSON '{ "id": "movie:61", "title": "Kill Bill", "year": 2003, "genre": "drama", "country": "USA", "director": { "id": "artist:37", "last_name": "Tarantino", "first_name": "Quentin", "birth_date": "1963" }, "actors": [ { "id": "artist:40", "first_name": "Uma", "last_name": "Thurman", "birth_date": "1970", "role": "La mariée, alias \"Black Mamba\"" }, { "id": "artist:213", "first_name": "Lucy", "last_name": "Liu", "birth_date": "1968", "role": "O-Ren Ishii" }, { "id": "artist:214", "first_name": "David", "last_name": "Carradine", "birth_date": "1936", "role": "Bill" }, { "id": "artist:215", "first_name": "Michael", "last_name": "Madsen", "birth_date": "1958", "role": "Budd / Sidewinder" }, { "id": "artist:216", "first_name": "Daryl", "last_name": "Hannah", "birth_date": "1960", "role": "Elle Driver" } ] }'; INSERT INTO movies JSON '{ "id": "movie:62", "title": "Stalingrad", "year": 2001, "genre": "drama", "country": "USA", "director": { "id": "artist:34", "last_name": "Annaud", "first_name": "Jean-Jacques", "birth_date": "1943" }, "actors": [ { "id": "artist:182", "first_name": "Marlon", "last_name": "Brando", "birth_date": "1924", "role": "Vassili Zaïtzev" }, { "id": "artist:183", "first_name": "Diane", "last_name": "Keaton", "birth_date": "1946", "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", "last_name": "Eastwood", "first_name": "Clint", "birth_date": "1930" }, "actors": [ { "id": "artist:20", "first_name": "Clint", "last_name": "Eastwood", "birth_date": "1930", "role": "Frankie Dunn" }, { "id": "artist:22", "first_name": "Morgan", "last_name": "Freeman", "birth_date": "1937", "role": "Eddie Scrap-Iron Dupris" }, { "id": "artist:224", "first_name": "Hillary", "last_name": "Swank", "birth_date": "1974", "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", "last_name": "Leone", "first_name": "Sergio", "birth_date": "1929" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:67", "title": "Marie Antoinette", "year": 2006, "genre": "drama", "country": "USA", "director": { "id": "artist:1", "last_name": "Coppola", "first_name": "Sofia", "birth_date": "1971" }, "actors": [ { "id": "artist:2", "first_name": "Kirsten", "last_name": "Dunst", "birth_date": null, "role": "Marie Antoinette" } ] }'; INSERT INTO movies JSON '{ "id": "movie:68", "title": "Soleil vert", "year": 1973, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:7", "last_name": "Fleischer", "first_name": "Richard ", "birth_date": "1973" }, "actors": [ { "id": "artist:8", "first_name": "Charlton ", "last_name": "Hestone", "birth_date": "1923", "role": "sol" } ] }'; INSERT INTO movies JSON '{ "id": "movie:69", "title": "Heat", "year": 1995, "genre": "crime", "country": "USA", "director": { "id": "artist:175", "last_name": "Mann", "first_name": "Michael", "birth_date": "1943" }, "actors": [ { "id": "artist:167", "first_name": "Robert", "last_name": "De Niro", "birth_date": "1943", "role": null } ] }'; INSERT INTO movies JSON '{ "id": "movie:70", "title": "Taxi driver", "year": 1976, "genre": "drama", "country": "USA", "director": { "id": "artist:241", "last_name": "Scorcese", "first_name": "Martin", "birth_date": "1962" }, "actors": [ { "id": "artist:51", "first_name": "Jodie", "last_name": "Foster", "birth_date": null, "role": "1962" }, { "id": "artist:167", "first_name": "Robert", "last_name": "De Niro", "birth_date": "1943", "role": "Travis Bickle " } ] }'; INSERT INTO movies JSON '{ "id": "movie:71", "title": "Les affranchis", "year": 1990, "genre": "crime", "country": "USA", "director": { "id": "artist:241", "last_name": "Scorcese", "first_name": "Martin", "birth_date": "1962" }, "actors": [ { "id": "artist:167", "first_name": "Robert", "last_name": "De Niro", "birth_date": "1943", "role": "James Conway" }, { "id": "artist:242", "first_name": "Ray", "last_name": "Liotta", "birth_date": "1954", "role": "Henry Hill" }, { "id": "artist:243", "first_name": "Joe", "last_name": "Pesci", "birth_date": "1943", "role": "Tommy DeVito" }, { "id": "artist:244", "first_name": "Lorraine", "last_name": "Bracco", "birth_date": "1954", "role": "Karen Hill" } ] }'; INSERT INTO movies JSON '{ "id": "movie:72", "title": "Casino", "year": 1995, "genre": "crime", "country": "USA", "director": { "id": "artist:241", "last_name": "Scorcese", "first_name": "Martin", "birth_date": "1962" }, "actors": [ { "id": "artist:167", "first_name": "Robert", "last_name": "De Niro", "birth_date": "1943", "role": "Sam ''Ace'' Rothstein" }, { "id": "artist:243", "first_name": "Joe", "last_name": "Pesci", "birth_date": "1943", "role": " Nicky Santoro " }, { "id": "artist:245", "first_name": "Sharon", "last_name": "Stone", "birth_date": "1958", "role": "Ginger McKenna" } ] }'; INSERT INTO movies JSON '{ "id": "movie:73", "title": "Casino Royale", "year": 2006, "genre": "Action", "country": "USA", "director": { "id": "artist:246", "last_name": "Campbell", "first_name": "Martin", "birth_date": "1943" }, "actors": [ { "id": "artist:247", "first_name": "Daniel", "last_name": "Craig", "birth_date": "1968", "role": "James Bond" }, { "id": "artist:248", "first_name": "Eva", "last_name": "Green", "birth_date": "1980", "role": "Vesper Lynd" } ] }'; INSERT INTO movies JSON '{ "id": "movie:74", "title": "Skyfall", "year": 1012, "genre": "Action", "country": "USA", "director": { "id": "artist:17", "last_name": "Mendes", "first_name": "Sam", "birth_date": "1965" }, "actors": [ { "id": "artist:247", "first_name": "Daniel", "last_name": "Craig", "birth_date": "1968", "role": "James Bond" }, { "id": "artist:249", "first_name": "Judi", "last_name": "Bench", "birth_date": "1934", "role": "M" }, { "id": "artist:250", "first_name": "Javier", "last_name": "Bardem", "birth_date": "1969", "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", "last_name": "Coen", "first_name": "Ethan", "birth_date": "1957" }, "actors": [ { "id": "artist:250", "first_name": "Javier", "last_name": "Bardem", "birth_date": "1969", "role": "Anton Chigurh" }, { "id": "artist:252", "first_name": "Tommy Lee", "last_name": "Jones", "birth_date": "1946", "role": "Ed Tom Bell" }, { "id": "artist:253", "first_name": "Josh", "last_name": "Brolin", "birth_date": "1968", "role": "Llewelyn Moss" } ] }'; INSERT INTO movies JSON '{ "id": "movie:77", "title": "Fargo", "year": 1996, "genre": "crime", "country": "USA", "director": { "id": "artist:251", "last_name": "Coen", "first_name": "Ethan", "birth_date": "1957" }, "actors": [ { "id": "artist:217", "first_name": "Steve", "last_name": "Buscemi", "birth_date": "1957", "role": "Carl Showalter" }, { "id": "artist:254", "first_name": "William", "last_name": "Macy", "birth_date": "1950", "role": " Jerry Lundegaard " } ] }'; INSERT INTO movies JSON '{ "id": "movie:78", "title": "Django unchained", "year": 2012, "genre": "Western", "country": "USA", "director": { "id": "artist:37", "last_name": "Tarantino", "first_name": "Quentin", "birth_date": "1963" }, "actors": [ { "id": "artist:110", "first_name": "Leonardo", "last_name": "DiCaprio", "birth_date": "1974", "role": "Calvin Candie" }, { "id": "artist:212", "first_name": "Samuel", "last_name": "Jackson", "birth_date": "1948", "role": "Stephen" }, { "id": "artist:255", "first_name": "Jamie", "last_name": "Foxx", "birth_date": "1967", "role": "Django" }, { "id": "artist:256", "first_name": "Christoph", "last_name": "Waltz", "birth_date": "1956", "role": "Dr. King Schultz" } ] }'; INSERT INTO movies JSON '{ "id": "movie:79", "title": "Inglourious Basterds", "year": 209, "genre": "Guerre", "country": "USA", "director": { "id": "artist:37", "last_name": "Tarantino", "first_name": "Quentin", "birth_date": "1963" }, "actors": [ ] }'; INSERT INTO movies JSON '{ "id": "movie:80", "title": "Inglourious Basterds", "year": 2009, "genre": "Guerre", "country": "USA", "director": { "id": "artist:37", "last_name": "Tarantino", "first_name": "Quentin", "birth_date": "1963" }, "actors": [ { "id": "artist:32", "first_name": "Brad", "last_name": "Pitt", "birth_date": "1963", "role": "Lt. Aldo Raine" }, { "id": "artist:256", "first_name": "Christoph", "last_name": "Waltz", "birth_date": "1956", "role": "Col. Hans Landa" }, { "id": "artist:257", "first_name": "Mélanie", "last_name": "Laurent", "birth_date": "1983", "role": "Shoshana" }, { "id": "artist:258", "first_name": "Michael", "last_name": "Fassbender", "birth_date": "1977", "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", "last_name": "Truffaut", "first_name": "François", "birth_date": null }, "actors": [ { "id": "artist:260", "first_name": "Jean-Pierre", "last_name": "Léaud", "birth_date": "1944", "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", "last_name": "Truffaut", "first_name": "François", "birth_date": null }, "actors": [ { "id": "artist:130", "first_name": "Catherine", "last_name": "Deneuve", "birth_date": "1943", "role": "Marion Steiner" }, { "id": "artist:261", "first_name": "Gérard", "last_name": "Departieu", "birth_date": null, "role": "Bernard Granger" }, { "id": "artist:262", "first_name": "Jean", "last_name": "Poiret", "birth_date": "1926", "role": "Jean-Loup Cottins" } ] }'; INSERT INTO movies JSON '{ "id": "movie:84", "title": "Rio Grande", "year": 1950, "genre": "Western", "country": "USA", "director": { "id": "artist:263", "last_name": "Ford", "first_name": "John", "birth_date": "1894" }, "actors": [ { "id": "artist:264", "first_name": "John", "last_name": "Wayne", "birth_date": "1907", "role": "Lt. Col. Kirby Yorke" }, { "id": "artist:265", "first_name": "Maureen", "last_name": "O''Hara", "birth_date": "1920", "role": "Mrs. Kathleen Yorke" } ] }'; INSERT INTO movies JSON '{ "id": "movie:85", "title": "Interstellar", "year": 2014, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:266", "last_name": "Nolan", "first_name": "Christopher", "birth_date": "1970" }, "actors": [ { "id": "artist:267", "first_name": "Mathew", "last_name": "McConaughey", "birth_date": "1969", "role": "Cooper" }, { "id": "artist:268", "first_name": "Anne", "last_name": "Hathaway", "birth_date": "1982", "role": " Brand " }, { "id": "artist:269", "first_name": "Michael", "last_name": "Caine", "birth_date": "1933", "role": "Professor Brand" } ] }'; INSERT INTO movies JSON '{ "id": "movie:86", "title": "Inception", "year": 2010, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:266", "last_name": "Nolan", "first_name": "Christopher", "birth_date": "1970" }, "actors": [ { "id": "artist:110", "first_name": "Leonardo", "last_name": "DiCaprio", "birth_date": "1974", "role": "Cobb" }, { "id": "artist:269", "first_name": "Michael", "last_name": "Caine", "birth_date": "1933", "role": "Miles" }, { "id": "artist:270", "first_name": "Elen", "last_name": "Page", "birth_date": null, "role": "Ariadne" }, { "id": "artist:271", "first_name": "Marion", "last_name": "Cotillard", "birth_date": "1975", "role": "Mal" } ] }'; INSERT INTO movies JSON '{ "id": "movie:87", "title": "Memento", "year": 2000, "genre": "Thriller", "country": "USA", "director": { "id": "artist:266", "last_name": "Nolan", "first_name": "Christopher", "birth_date": "1970" }, "actors": [ { "id": "artist:272", "first_name": "Guy", "last_name": "Pearce", "birth_date": "1967", "role": "Leonard" }, { "id": "artist:273", "first_name": "Carie-Anne", "last_name": "Moss", "birth_date": "1967", "role": "Natalie" } ] }'; INSERT INTO movies JSON '{ "id": "movie:88", "title": "Batman begins", "year": 2005, "genre": "Thriller", "country": "USA", "director": { "id": "artist:266", "last_name": "Nolan", "first_name": "Christopher", "birth_date": "1970" }, "actors": [ { "id": "artist:22", "first_name": "Morgan", "last_name": "Freeman", "birth_date": "1937", "role": "Lucius Fox " }, { "id": "artist:116", "first_name": "Gary", "last_name": "Oldman", "birth_date": "1958", "role": " Jim Gordon " }, { "id": "artist:269", "first_name": "Michael", "last_name": "Caine", "birth_date": "1933", "role": "Alfred" }, { "id": "artist:274", "first_name": "Christian", "last_name": "Bale", "birth_date": "1974", "role": " Bruce Wayne / Batman " }, { "id": "artist:275", "first_name": "Liam", "last_name": "Neeson", "birth_date": "1952", "role": "Ducard" } ] }'; INSERT INTO movies JSON '{ "id": "movie:89", "title": "The Dark Knight", "year": 2008, "genre": "Science-fiction", "country": "USA", "director": { "id": "artist:266", "last_name": "Nolan", "first_name": "Christopher", "birth_date": "1970" }, "actors": [ { "id": "artist:22", "first_name": "Morgan", "last_name": "Freeman", "birth_date": "1937", "role": "Lucius Fox" }, { "id": "artist:116", "first_name": "Gary", "last_name": "Oldman", "birth_date": "1958", "role": "Gordon" }, { "id": "artist:269", "first_name": "Michael", "last_name": "Caine", "birth_date": "1933", "role": "Alfred" }, { "id": "artist:274", "first_name": "Christian", "last_name": "Bale", "birth_date": "1974", "role": "Bruce Wayne / Batman" }, { "id": "artist:276", "first_name": "Heath", "last_name": "Ledger", "birth_date": "1979", "role": "Joker" }, { "id": "artist:277", "first_name": "Maggie", "last_name": "Gyllenhaal", "birth_date": "1977", "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", "last_name": "Nolan", "first_name": "Christopher", "birth_date": "1970" }, "actors": [ { "id": "artist:22", "first_name": "Morgan", "last_name": "Freeman", "birth_date": "1937", "role": "Lucius Fox" }, { "id": "artist:116", "first_name": "Gary", "last_name": "Oldman", "birth_date": "1958", "role": "Commissioner Gordon" }, { "id": "artist:268", "first_name": "Anne", "last_name": "Hathaway", "birth_date": "1982", "role": "Selina" }, { "id": "artist:269", "first_name": "Michael", "last_name": "Caine", "birth_date": "1933", "role": "Alfred" }, { "id": "artist:271", "first_name": "Marion", "last_name": "Cotillard", "birth_date": "1975", "role": "Miranda" }, { "id": "artist:274", "first_name": "Christian", "last_name": "Bale", "birth_date": "1974", "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", "last_name": "Audiard", "first_name": "Jacques", "birth_date": "1952" }, "actors": [ { "id": "artist:279", "first_name": "Tahar", "last_name": "Rahim", "birth_date": "1981", "role": "Malik El Djebena " }, { "id": "artist:280", "first_name": "Niels", "last_name": "Arestrup", "birth_date": "1949", "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", "last_name": " Kheiron", "first_name": "Tabib", "birth_date": null }, "actors": [ ] }';