Parse Oscar movies.

omgc-may-16-1.cypher

WITH "https://www.hollywoodreporter.com/lists/oscar-nominations-2019-complete-list-nominees-1172407/item/best-director-1172474" as url
CALL apoc.load.html(url, { movie: "ul.list--unordered__items li div.list-item__body a" }) YIELD value
WITH collect(value) as data
WITH { movies: data[0].movie } as root
WITH [x IN range(0, length(root.movies) - 1) | { title: root.movies[x].text, url: root.movies[x].attributes.href }] as result
WITH filter(x IN result WHERE x.title <> "" AND apoc.text.indexOf(x.url, "/review/") > -1) as titled
UNWIND titled as item
MERGE (m:Movie { title: item.title })
ON CREATE SET m.url = apoc.text.replace(item.url, "edit.", "www.")
ON MATCH SET m.url = apoc.text.replace(item.url, "edit.", "www.")