Report not found

There was a problem finding this report.
Westworld - curse rate
November 18, 2016 · Refreshed over 2 years ago

Collaborators

Run History
WITH episodes AS( SELECT e.id, e.name FROM modeanalytics.westworld_episodes e JOIN modeanalytics.westworld_lines l ON e.id = l.episode_id ), words AS( SELECT episode_id, SUM(frequency) AS total FROM( SELECT episode_id, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COALESCE(COUNT(*),0) AS frequency FROM modeanalytics.westworld_lines l WHERE l.character_id = 9 GROUP BY 1,2 ) a GROUP BY 1 ) SELECT DISTINCT episodes.id AS episode_id, COALESCE(sum.count,0) AS total, COALESCE(ROUND((100*sum.count / words.total::float8)::numeric,2),0) AS rate FROM episodes LEFT JOIN words ON episodes.id = words.episode_id LEFT JOIN( SELECT episode_id, SUM(frequency) AS count FROM( SELECT episode_id, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l WHERE l.character_id = 9 GROUP BY 1,2 ) a WHERE LOWER(keyword) IN ( 'shit', 'shitting', 'fuck', 'fucking', 'fucked', 'fucker', 'cock', 'ass', 'asshole', 'damn', 'bitch', 'bitching', 'motherfucker', 'motherfucking', 'hell', 'whore', 'whorehouse', 'slut', 'jesus') GROUP BY 1 ) sum ON sum.episode_id = words.episode_id ORDER BY 1 DESC
WITH episodes AS( SELECT e.id, e.name FROM modeanalytics.westworld_episodes e JOIN modeanalytics.westworld_lines l ON e.id = l.episode_id ), words AS( SELECT episode_id, SUM(frequency) AS total FROM( SELECT episode_id, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COALESCE(COUNT(*),0) AS frequency FROM modeanalytics.westworld_lines l WHERE l.character_id = 9 GROUP BY 1,2 ) a GROUP BY 1 ) SELECT DISTINCT episodes.id AS episode_id, COALESCE(sum.count,0) AS total, COALESCE(ROUND((100*sum.count / words.total::float8)::numeric,2),0) AS rate FROM episodes LEFT JOIN words ON episodes.id = words.episode_id LEFT JOIN( SELECT episode_id, SUM(frequency) AS count FROM( SELECT episode_id, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l WHERE l.character_id = 9 GROUP BY 1,2 ) a WHERE LOWER(keyword) IN ( 'shit', 'shitting', 'fuck', 'fucking', 'fucked', 'fucker', 'cock', 'ass', 'asshole', 'damn', 'bitch', 'bitching', 'motherfucker', 'motherfucking', 'hell', 'whore', 'whorehouse', 'slut', 'jesus') GROUP BY 1 ) sum ON sum.episode_id = words.episode_id ORDER BY 1 DESC
WITH words AS( SELECT name, SUM(frequency) AS total FROM( SELECT c.name, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a GROUP BY 1 ) SELECT words.name, sum.count AS total, ROUND((100*sum.count / words.total::float8)::numeric,2) AS rate FROM words JOIN( SELECT name, SUM(frequency) AS count FROM( SELECT c.name, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a WHERE LOWER(keyword) IN ( 'shit', 'shitting', 'fuck', 'fucking', 'fucked', 'fucker', 'cock', 'ass', 'asshole', 'damn', 'bitch', 'bitching', 'motherfucker', 'motherfucking', 'hell', 'whore', 'whorehouse', 'slut', 'jesus') GROUP BY 1 ) sum ON sum.name = words.name ORDER BY 2 DESC LIMIT 10
WITH words AS( SELECT name, SUM(frequency) AS total FROM( SELECT c.name, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a GROUP BY 1 ) SELECT words.name, sum.count AS total, ROUND((100*sum.count / words.total::float8)::numeric,2) AS rate FROM words JOIN( SELECT name, SUM(frequency) AS count FROM( SELECT c.name, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a WHERE LOWER(keyword) IN ( 'shit', 'shitting', 'fuck', 'fucking', 'fucked', 'fucker', 'cock', 'ass', 'asshole', 'damn', 'bitch', 'bitching', 'motherfucker', 'motherfucking', 'hell', 'whore', 'whorehouse', 'slut', 'jesus') GROUP BY 1 ) sum ON sum.name = words.name ORDER BY 2 DESC LIMIT 10
WITH words AS( SELECT tribe, SUM(frequency) AS total FROM( SELECT CASE WHEN c.is_human is TRUE THEN 'Human' ELSE 'Host' END AS tribe, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a GROUP BY 1 ) SELECT words.tribe AS class, sum.count AS total, ROUND((100*sum.count / words.total::float8)::numeric,2) AS rate FROM words JOIN( SELECT tribe, SUM(frequency) AS count FROM( SELECT CASE WHEN c.is_human is TRUE THEN 'Human' ELSE 'Host' END AS tribe, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a WHERE LOWER(keyword) IN ( 'shit', 'shitting', 'fuck', 'fucking', 'fucked', 'fucker', 'cock', 'ass', 'asshole', 'damn', 'bitch', 'bitching', 'motherfucker', 'motherfucking', 'hell', 'whore', 'whorehouse', 'slut', 'jesus') GROUP BY 1 ) sum ON sum.tribe = words.tribe ORDER BY 2 DESC
WITH words AS( SELECT tribe, SUM(frequency) AS total FROM( SELECT CASE WHEN c.is_human is TRUE THEN 'Human' ELSE 'Host' END AS tribe, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a GROUP BY 1 ) SELECT words.tribe AS class, sum.count AS total, ROUND((100*sum.count / words.total::float8)::numeric,2) AS rate FROM words JOIN( SELECT tribe, SUM(frequency) AS count FROM( SELECT CASE WHEN c.is_human is TRUE THEN 'Human' ELSE 'Host' END AS tribe, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a WHERE LOWER(keyword) IN ( 'shit', 'shitting', 'fuck', 'fucking', 'fucked', 'fucker', 'cock', 'ass', 'asshole', 'damn', 'bitch', 'bitching', 'motherfucker', 'motherfucking', 'hell', 'whore', 'whorehouse', 'slut', 'jesus') GROUP BY 1 ) sum ON sum.tribe = words.tribe ORDER BY 2 DESC
WITH words AS( SELECT sex, SUM(frequency) AS total FROM( SELECT c.sex, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a GROUP BY 1 ) SELECT CASE WHEN words.sex = 'male' THEN 'Male' WHEN words.sex = 'female' THEN 'Female' END AS sex, sum.count AS total, ROUND((100*sum.count / words.total::float8)::numeric,2) AS rate FROM words JOIN( SELECT sex, SUM(frequency) AS count FROM( SELECT c.sex, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a WHERE LOWER(keyword) IN ( 'shit', 'shitting', 'fuck', 'fucking', 'fucked', 'fucker', 'cock', 'ass', 'asshole', 'damn', 'bitch', 'bitching', 'motherfucker', 'motherfucking', 'hell', 'whore', 'whorehouse', 'slut', 'jesus') GROUP BY 1 ) sum ON sum.sex = words.sex ORDER BY 2 DESC
WITH words AS( SELECT sex, SUM(frequency) AS total FROM( SELECT c.sex, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a GROUP BY 1 ) SELECT CASE WHEN words.sex = 'male' THEN 'Male' WHEN words.sex = 'female' THEN 'Female' END AS sex, sum.count AS total, ROUND((100*sum.count / words.total::float8)::numeric,2) AS rate FROM words JOIN( SELECT sex, SUM(frequency) AS count FROM( SELECT c.sex, LOWER(REGEXP_SPLIT_TO_TABLE( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( line, '(',' '),')',' '),'[',' '),']',' '),'.',' '),'?',' '),'!',' '),',',' ') , E'\\s+')) AS keyword, COUNT(*) AS frequency FROM modeanalytics.westworld_lines l JOIN modeanalytics.westworld_characters c ON l.character_id = c.id GROUP BY 1,2 ) a WHERE LOWER(keyword) IN ( 'shit', 'shitting', 'fuck', 'fucking', 'fucked', 'fucker', 'cock', 'ass', 'asshole', 'damn', 'bitch', 'bitching', 'motherfucker', 'motherfucking', 'hell', 'whore', 'whorehouse', 'slut', 'jesus') GROUP BY 1 ) sum ON sum.sex = words.sex ORDER BY 2 DESC
<link rel="stylesheet" href="https://mode.github.io/alamode/alamode.min.css"> <script src="https://mode.github.io/alamode/alamode.min.js"></script> <style> body { background: #f0f0f0 !important; } .chart { background-color: #f0f0f0; border: none; } .mode-embed .mode-object { border: none; background: #f0f0f0; } .js-table-container { background-color: #f0f0f0; } </style> <div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="mode-grid container"> <div class="row"> <div class="col-md-7"> <mode-python id="python_4d57df345901" options="python_options"></mode-python> </div> <div class="col-md-5"> </div> </div> <div class="row"> <div class="col-md-8"> <mode-python id="python_8cd51291dcea" options="python_options"></mode-python> </div> <div class="col-md-4"></div> </div> <div class="row"> <div class="col-md-12"> <mode-python id="python_43f1de537e5e" options="python_options"></mode-python> </div> </div> <div class="row"> <div class="col-md-12"> <mode-python id="python_9c841ce8026e" options="python_options"></mode-python> </div> </div> </div> <script> alamode.resizeChartHeight({ chart: "python_8cd51291dcea", height: 650 }) alamode.resizeChartHeight({ chart: "python_4d57df345901", height: 650 }) alamode.resizeChartHeight({ chart: "python_43f1de537e5e", height: 650 }) alamode.resizeChartHeight({ chart: "python_9c841ce8026e", height: 650 }) </script>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled