Skip to content

Instantly share code, notes, and snippets.

View figital's full-sized avatar
🎯
Focusing

figital figital

🎯
Focusing
49 followers · 100 following
View GitHub Profile
@figital
figital / amazing-fantasy.json
Created June 14, 2017 17:13
https://gateway.marvel.com:443/v1/public/comics?series=2987&apikey=24eb53b1f20564fdc12fd0a1185540a1
{
"code": 200,
"status": "Ok",
"copyright": "© 2017 MARVEL",
"attributionText": "Data provided by Marvel. © 2017 MARVEL",
"attributionHTML": "<a href=\"http://marvel.com\">Data provided by Marvel. © 2017 MARVEL</a>",
"etag": "f7ae8704ea32cc99319512387ca51853185ff50b",
"data": {
"offset": 0,
"limit": 20,
@figital
figital / example.sql
Created April 18, 2017 20:06 — forked from wolever/example.sql
A simple Postgres aggregate function for calculating a trimmed mean, excluding values outside N standard deviations from the mean: `tmean(v, standard_deviations)` (for example: `tmean(rating, 1.75)`).
DROP TABLE IF EXISTS foo;
CREATE TEMPORARY TABLE foo (x FLOAT);
INSERT INTO foo VALUES (1);
INSERT INTO foo VALUES (2);
INSERT INTO foo VALUES (3);
INSERT INTO foo VALUES (4);
INSERT INTO foo VALUES (100);
SELECT avg(x), tmean(x, 2.0), tmean(x, 1.5) FROM foo;
@figital
figital / game7-ws.csv
Created November 11, 2016 23:15
starter data from initial view
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 8.
side,inning,out,home_team_runs,away_team_runs,pitcher_name,batter_name,atbat_des,event,bpos,bbats,team_abbrev,bid,pid
TOP,1.0,0.0,0,1,"Corey Kluber","Dexter Fowler","Dexter Fowler homers (2) on a fly ball to center field. ","Home Run",CF,S,CHC,451594,446372
TOP,1.0,0.0,0,1,"Corey Kluber","Kyle Schwarber","Kyle Schwarber singles on a soft ground ball to shortstop Francisco Lindor. ",Single,LF,L,CHC,656941,446372
TOP,1.0,1.0,0,1,"Corey Kluber","Kris Bryant","Kris Bryant flies out to right fielder Lonnie Chisenhall. ",Flyout,3B,R,CHC,592178,446372
TOP,1.0,2.0,0,1,"Corey Kluber","Anthony Rizzo","Anthony Rizzo flies out to center fielder Rajai Davis. ",Flyout,1B,L,CHC,519203,446372
TOP,1.0,3.0,0,1,"Corey Kluber","Ben Zobrist","Ben Zobrist flies out to right fielder Lonnie Chisenhall. ",Flyout,2B,S,CHC,450314,446372
BOTTOM,1.0,1.0,0,1,"Kyle Hendricks","Carlos Santana","Carlos Santana lines out sharply to right fielder Jason Heyward. ",Lineout,D,S,CLE,467793,543294
BOTTOM,1.0,2.0,0,1,"Kyle Hendricks","Jason Ki
@figital
figital / calibration-test.ino
Created September 24, 2016 23:06
void setup() {
Serial.begin(9600);
}
void loop() {
float average = 0.00;
float c = analogRead(A5);
int sampleSize = 1000;
for (int i = 1; i <= sampleSize; i++ ) {
average = average + (0.0445 * c - 22.8) / 1000;
//average = .04 * c;
@figital
figital / mini-board.svg
Last active August 27, 2016 14:03
mini board svg test
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@figital
figital / sensors.json
Created February 13, 2016 01:15
voltage sensor format
{
"sensors": {
"V0": "12.28",
"V1": "0.00",
"V2": "0.00"
}
}
@figital
figital / screen-serial.txt
Created August 8, 2015 21:08
screen /dev/tty.usbserial 9600
@figital
figital / monitor-ssids.txt
Created June 13, 2015 22:04
monitor detected ssids on wlan0 (requires moreutils)
watch -n 5 "iwlist wlan0 scan | egrep 'Cell|Quality|ESSID' | pee cat 'wc -l'"
@figital
figital / routing-stuff.txt
Created April 24, 2015 03:26
sudo iptables -t nat -A POSTROUTING -o wlan1 -j MASQUERADE
sudo iptables -A FORWARD -i wlan1 -o wlan0 -m state --state RELATED,ESTABLISHED -j ACCEPT
sudo iptables -A FORWARD -i wlan0 -o wlan1 -j ACCEPT
@figital
figital / bigquery-shakespeare-z.sql
Created April 16, 2015 15:26
select
word,
sum(word_count) as num
from
publicdata:samples.shakespeare
where
lower(word) like 'z%'
group by
word
order by