Skip to content

Instantly share code, notes, and snippets.

@padak

padak/hash_over_films.csv

Last active March 12, 2018 19:45
Show Gist options
  • Save padak/278b5ce3e13afbf941d2504b80b09796 to your computer and use it in GitHub Desktop.
Save padak/278b5ce3e13afbf941d2504b80b09796 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hash_over_films.csv
TITLE COUNTRY DURATION TITLE_COUNTRY_DURATION HASH(TITLE) HASH(COUNTRY) HASH(DURATION) HASH(TITLE||'-'||COUNTRY||'-'||DURATION)
Cannibal Holocaust New Zealand 98 Cannibal Holocaust-New Zealand-98 -1601204309656643272 2036112869232829833 7338918106602415339 5288839991858621185
I Spit on Your Grave Ireland 122 I Spit on Your Grave-Ireland-122 3014945125397368830 -6971372092926158838 3392492876407035749 -8150979255504859178
I Spit on Your Grave Ireland 77 I Spit on Your Grave-Ireland-77 3014945125397368830 -6971372092926158838 -5980709635818720242 -8258666183221233039
Sweetness of Spirit - Halawet Rooh Egypt 121 Sweetness of Spirit - Halawet Rooh-Egypt-121 8164173066761965620 1751424115462514396 5726818838546094492 -8073959077440497528
Noah Indonesia 109 Noah-Indonesia-109 1092035266774786189 -1921382501271571452 -6314821653280887795 -8083143972931148564
The Raid 2: Berandal Malaysia 151 The Raid 2: Berandal-Malaysia-151 -303945063906681582 -6022003878452176079 8419243739902537123 6573197503826478207
High School DxD New Zealand 125 High School DxD-New Zealand-125 7043142047850018960 2036112869232829833 6391859513626326051 737200017562771846
To Singapore, With Love Singapore 97 To Singapore, With Love-Singapore-97 2279234971327200246 -933526088111425509 -7105246604456360595 865511367189922408
Maniac New Zealand 134 Maniac-New Zealand-134 -5812737803045517489 2036112869232829833 -7568371362339014818 -3619825462213924478
The Wolf of Wall Street Kenya 146 The Wolf of Wall Street-Kenya-146 6744866546923898668 4442564511111359439 8087341791497220192 -3654048574509140078
Raw
hash_over_films.sql
SELECT
TITLE,
COUNTRY,
DURATION,
TITLE||'-'||COUNTRY||'-'||DURATION AS TITLE_COUNTRY_DURATION,
HASH(TITLE),
HASH(COUNTRY),
HASH(DURATION),
HASH(TITLE||'-'||COUNTRY||'-'||DURATION)
FROM FILMS
LIMIT 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment