Skip to content

Instantly share code, notes, and snippets.

Back in Black

Alyson La alysonla

Back in Black
View GitHub Profile
alysonla /
Created Mar 28, 2018 — forked from alizauf/
Data Storytelling with Coördinator
alysonla / index.html
Last active Mar 28, 2018 — forked from alizauf/index.html
Marquee Marq - Made with Coördinator
View index.html
<!DOCTYPE html>
<meta charset="utf-8">
<div id='marquee'>
<script src=""></script>
alysonla /
Last active Mar 28, 2018 — forked from alizauf/
Shivering Snowman - Made with Coördinator
alysonla / .block
Created Mar 28, 2018 — forked from pbeshai/.block
Animate thousands of points with canvas and D3
View .block
license: mit
height: 620
border: no
alysonla / .block
Last active Mar 28, 2018 — forked from alizauf/.block
Coördinator Transitions
View .block
height: 800
alysonla / active-issues.sql
Last active Nov 28, 2019
Queries that power the open source section of the 2016 Octoverse report
View active-issues.sql
-- Active issues
-- Count of total active issues in the specified time frame
-- Source: githubarchive public data set via Google BigQuery
COUNT(DISTINCT JSON_EXTRACT_SCALAR(events.payload, '$')) AS events_issue_count
FROM (SELECT * FROM TABLE_DATE_RANGE([githubarchive:day.],TIMESTAMP('2015-09-01'),TIMESTAMP('2016-08-31')))
AS events
-- 10,723,492 active issues
View gist:bb42e3982e8ea59dbb3936e90a967975
SELECT license, count(*) FROM [bigquery-public-data:github_repos.licenses] GROUP BY 1 ORDER BY 2 DESC LIMIT 10
View growth_accounting_and_ltv.sql
dau as (
-- This part of the query can be pretty much anything.
-- The only requirement is that it have three columns:
-- dt, user_id, inc_amt
-- Where dt is a date and user_id is some unique identifier for a user.
-- Each dt-user_id pair should be unique in this table.
-- inc_amt represents the amount of value that this user created on dt.
-- The most common case is
-- inc_amt = incremental revenue from the user on dt
alysonla /
Last active Sep 15, 2015
GH Pages Cheatsheet

How to gh-pages

  1. Create a front-end project & name index.html
  2. cd into the project in terminal
  3. Run git init to initialize the git repo in the project
  4. Create & switch to branch called gh-pages - git checkout -b gh-pages
  5. Go to the website and create a new repo
  6. Do not add a readme..
  7. Use the cheatsheat to add the remote - git add remote....
  8. Run git add . to add & stage all your files
View HTML Cheatsheet
<!DOCTYPE html>
<html> </html>
Making Comments:
<--! Make me into a comment -->
Font Size:
<p style = "font-size: 12px">
Font Color:
<h2 style="color:red">
Font Color & Size:
<h2 style="color: green; font-size:12px">
You can’t perform that action at this time.