Skip to content

Instantly share code, notes, and snippets.

View alysonla's full-sized avatar
back in black

Alyson La alysonla

back in black
View GitHub Profile
@alysonla
alysonla / README.md
Created March 28, 2018 06:16 — forked from alizauf/README.md
Data Storytelling with Coördinator
@alysonla
alysonla / index.html
Last active March 28, 2018 05:32 — forked from alizauf/index.html
Marquee Marq - Made with Coördinator
<!DOCTYPE html>
<meta charset="utf-8">
<style>
</style>
<div id='marquee'>
</div>
<script src="https://d3js.org/d3.v4.min.js"></script>
<script>
@alysonla
alysonla / README.md
Last active March 28, 2018 05:26 — forked from alizauf/README.md
Shivering Snowman - Made with Coördinator
@alysonla
alysonla / .block
Created March 28, 2018 05:08 — forked from pbeshai/.block
Animate thousands of points with canvas and D3
license: mit
height: 620
border: no
@alysonla
alysonla / .block
Last active March 28, 2018 05:45 — forked from alizauf/.block
Coördinator Transitions
height: 800
@alysonla
alysonla / active-issues.sql
Last active September 19, 2023 11:21
Queries that power the open source section of the 2016 Octoverse report https://octoverse.github.com/2016/
-- Active issues
-- Count of total active issues in the specified time frame
-- Source: githubarchive public data set via Google BigQuery http://githubarchive.org/
SELECT
COUNT(DISTINCT JSON_EXTRACT_SCALAR(events.payload, '$.issue.id')) 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
SELECT license, count(*) FROM [bigquery-public-data:github_repos.licenses] GROUP BY 1 ORDER BY 2 DESC LIMIT 10
with
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
alysonla / pages.md
Last active September 15, 2015 01:07
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 github.com 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
@alysonla
alysonla / HTML Cheatsheet
Created April 6, 2013 06:48
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">