Haroen Viaene Haroenv

Compares the amount of posts uploaded via imgur vs those via reddit

SELECT USEC_TO_TIMESTAMP(UTC_USEC_TO_Day(TIMESTAMP_TO_USEC(created_utc))) as utc_day,
  SUM(domain CONTAINS 'imgur.com')/COUNT(*) as perc_imgur_submissions,
  SUM(domain CONTAINS 'reddituploads.com' OR domain CONTAINS 'i.redd.it')/COUNT(*) as perc_reddit_submissions,
  COUNT(*) as num_submissions
FROM [pushshift:rt_reddit.submissions]
WHERE created_utc > '2016-05-22 07:00:00'
AND lower(subreddit) IN ('getmotivated', 'earthporn', 'gaming', 'space', 'oldschoolcool', 'sports', 'art', 'aww', 'dataisbeautiful', 'food', 'funny', 'gifs', 'mildlyinteresting', 'movies', 'photoshopbattles', 'pics')

time	year	medal	name	country
12.6	1896	BRONZE	Francis Lane	USA
12.6	1896	BRONZE	Alajos Szokolyi	HUN
12.2	1896	SILVER	Fritz Hofmann	DEU
12.0	1896	GOLD	Tom Burke	USA
11.3	1906	SILVER	Fay Moulton	USA
11.3	1906	BRONZE	Nigel Barker	AUS
11.2	1906	GOLD	Archie Hahn	USA
11.2	1904	SILVER	Nate Cartmell	USA
11.2	1904	BRONZE	Bill Hogenson	USA

	{
	"@context": {
	"@vocab": "http://schema.org/",
	"in": "https://haroen.me/terms/interests#",
	"ac": "https://haroen.me/terms/accessibility#",
	"cn": "https://haroen.me/terms/constraints#",
	"ageRange": "cn:ageRange",
	"heightRange": "cn:heightRange",
	"accessible": "ac:accessible",
	"foaf": "http://xmlns.com/foaf/0.1/",

	// get user agents out of json
	// CCO
	const data = require('./occupancy.json');

	function count(acc, curr) {
	if (typeof acc[curr] == 'undefined') {
	acc[curr] = 1;
	} else {
	acc[curr] += 1;
	}

	<html>
	<head>
	<meta charset="UTF-8">
	<title>ISS PubNub demo</title>
	<script src="https://cdn.pubnub.com/pubnub-3.7.13.min.js"></script>
	<script src="jquery.js" charset="utf-8"></script>
	<!-- mapbox CDN -->
	<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
	<script src='https://api.mapbox.com/mapbox.js/v2.2.3/mapbox.js'></script>
	<link href='https://api.mapbox.com/mapbox.js/v2.2.3/mapbox.css' rel='stylesheet' />

	The Bug Lebowski
	A Bug's Life
	The Bug
	My Bug Fat Greek Wedding
	Bug Hero 6
	Bugman Rising
	Bug (1988)
	Pee-wee's Bug Holiday
	The Bug Short
	Lord of the Bugs: The Two Bugs