Skip to content

Instantly share code, notes, and snippets.

View bawbgale's full-sized avatar

Bob Gale bawbgale

7 followers · 16 following
View GitHub Profile
@bawbgale
bawbgale / gist:2bb60bec9154e6b49d8e
Last active August 29, 2015 14:22
Convert a set of flat JSON objects with consistent key order to CSV
cat part-00000 | jq -s -r '.[0] | to_entries | map(.key) | @csv' > all.csv | cat part-* | jq -s -r '.[] | to_entries | map(.value) | @csv' >> all.csv
@bawbgale
bawbgale / index.html
Last active July 26, 2017 16:48 — forked from d3noob/.block
d3.js tree from csv
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Collapsible Tree Example</title>
<style>
.node circle {
@bawbgale
bawbgale / faa_2018_aircraft_year_counts_with_totals.json
Last active November 27, 2018 01:10
Counts of registered aircraft by year built from FAA aircraft registry. https://www.faa.gov/licenses_certificates/aircraft_certification/aircraft_registry/
[{"has_year":"true","count":254741,"data":[{"year":"1990","count":1412},{"year":"1981","count":4366},{"year":"1967","count":5548},{"year":"1978","count":7821},{"year":"1984","count":1742},{"year":"1998","count":3133},{"year":"1999","count":3447},{"year":"1983","count":1626},{"year":"1980","count":4408},{"year":"1987","count":1045},{"year":"1979","count":7333},{"year":"1994","count":1692},{"year":"1965","count":5119},{"year":"1992","count":1655},{"year":"1976","count":7219},{"year":"1997","count":2395},{"year":"1993","count":1643},{"year":"1973","count":5439},{"year":"1982","count":2312},{"year":"1989","count":1375},{"year":"1985","count":1515},{"year":"1968","count":5782},{"year":"1975","count":6124},{"year":"1991","count":1690},{"year":"1995","count":1806},{"year":"2007","count":5304},{"year":"2001","count":3889},{"year":"1977","count":7235},{"year":"1974","count":5568},{"year":"2006","count":4833},{"year":"1970","count":2699},{"year":"2002","count":3685},{"year":"1969","count":4940},{"year":"1966","count":6
@bawbgale
bawbgale / faa_2018_top_1946_manuf_group_year_counts.json
Last active September 22, 2018 23:13
Counts of registered aircraft by manufacturer and year built for top 1946 manufacturers. From FAA aircraft registry. https://www.faa.gov/licenses_certificates/aircraft_certification/aircraft_registry/
[{"manufacturer":"Aeronca","year":"1948","count":170},{"manufacturer":"Aeronca","year":"1946","count":2352},{"manufacturer":"Aeronca","year":"1947","count":400},{"manufacturer":"Aeronca","year":"1945","count":139},{"manufacturer":"Aeronca","year":"1955","count":12},{"manufacturer":"Aeronca","year":"1943","count":72},{"manufacturer":"Aeronca","year":"1942","count":94},{"manufacturer":"Aeronca","year":"1959","count":5},{"manufacturer":"Aeronca","year":"1941","count":204},{"manufacturer":"Aeronca","year":"1930","count":5},{"manufacturer":"Aeronca","year":"1944","count":22},{"manufacturer":"Aeronca","year":"1949","count":78},{"manufacturer":"Aeronca","year":"1933","count":3},{"manufacturer":"Aeronca","year":"1952","count":4},{"manufacturer":"Aeronca","year":"1950","count":52},{"manufacturer":"Aeronca","year":"1932","count":6},{"manufacturer":"Aeronca","year":"1939","count":85},{"manufacturer":"Aeronca","year":"1940","count":92},{"manufacturer":"Aeronca","year":"1956","count":23},{"manufacturer":"Aeronca","year":"
@bawbgale
bawbgale / faa_2018_aircraft_manuf_year_counts.json
Last active November 27, 2018 01:12
Counts of registered aircraft by manufacturer and year built from FAA aircraft registry. https://www.faa.gov/licenses_certificates/aircraft_certification/aircraft_registry/
This file has been truncated, but you can view the full file.
[{"manufacturer":"BEECH","year":"1990","count":231},{"manufacturer":"BEECH","year":"1967","count":535},{"manufacturer":"BEECH","year":"1983","count":216},{"manufacturer":"BEECH","year":"1994","count":165},{"manufacturer":"BEECH","year":"1965","count":527},{"manufacturer":"BEECH","year":"1992","count":155},{"manufacturer":"BEECH","year":"1976","count":612},{"manufacturer":"BEECH","year":"1978","count":750},{"manufacturer":"BEECH","year":"1979","count":809},{"manufacturer":"BEECH","year":"1993","count":152},{"manufacturer":"BEECH","year":"1973","count":505},{"manufacturer":"BEECH","year":"1982","count":340},{"manufacturer":"BEECH","year":"1989","count":178},{"manufacturer":"BEECH","year":"1985","count":191},{"manufacturer":"BEECH","year":"1968","count":586},{"manufacturer":"BEECH","year":"1991","count":219},{"manufacturer":"BEECH","year":"1995","count":125},{"manufacturer":"BEECH","year":"1975","count":575},{"manufacturer":"BEECH","year":"1977","count":675},{"manufacturer":"BEECH","year":"1970","count":306},{"m
@bawbgale
bawbgale / faa_2018_top_1946_manuf_group_year_model_counts.json
Last active November 6, 2018 19:58
This file has been truncated, but you can view the full file.
[{"manuf":"Aeronca","year":"1948","model":"15AC","count":86},{"manuf":"Aeronca","year":"1948","model":"S15AC","count":7},{"manuf":"Aeronca","year":"1948","model":"7DC","count":33},{"manuf":"Aeronca","year":"1948","model":"7CCM","count":12},{"manuf":"Aeronca","year":"1948","model":"7AC","count":9},{"manuf":"Aeronca","year":"1948","model":"L-16B","count":1},{"manuf":"Aeronca","year":"1948","model":"11CC","count":18},{"manuf":"Aeronca","year":"1948","model":"7EC CONV","count":1},{"manuf":"Aeronca","year":"1948","model":"7AC-CONV","count":1},{"manuf":"Aeronca","year":"1948","model":"11AC","count":1},{"manuf":"Aeronca","year":"1948","model":"S7CCM","count":1},{"manuf":"Aeronca","year":"1946","model":"7AC","count":1643},{"manuf":"Aeronca","year":"1946","model":"11AC","count":496},{"manuf":"Aeronca","year":"1946","model":"7DC","count":63},{"manuf":"Aeronca","year":"1946","model":"7BCM","count":58},{"manuf":"Aeronca","year":"1946","model":"11BC","count":16},{"manuf":"Aeronca","year":"1946","model":"7CCM","count":33},
@bawbgale
bawbgale / photos_urls.csv
Last active November 22, 2018 21:26
tailNum photoUrl
N86378 //cdn.jetphotos.com/400/6/85230_1512186300.jpg
N86331 //cdn.jetphotos.com/400/6/42028_1413830362.jpg
N86219 //cdn.jetphotos.com/400/6/65017_1520475851.jpg
N86122 //cdn.jetphotos.com/400/5/30081_1405120979.jpg
N86090 //cdn.jetphotos.com/400/6/95818_1537528588.jpg
N86033 //cdn.jetphotos.com/400/6/60952_1537655194.jpg
N85942 //cdn.jetphotos.com/400/3/71187_1327847704.jpg
N85920 //cdn.jetphotos.com/400/2/88084_1171131037.jpg
N85835 //cdn.jetphotos.com/400/5/46326_1515234663.jpg
@bawbgale
bawbgale / faa_2018_top_10_1946_manuf_group_year_model_counts.json
Created November 23, 2018 19:20
This file has been truncated, but you can view the full file.
[{"manuf":"Aeronca","year":"1948","model":"15AC","count":86},{"manuf":"Aeronca","year":"1948","model":"S15AC","count":7},{"manuf":"Aeronca","year":"1948","model":"7DC","count":34},{"manuf":"Aeronca","year":"1948","model":"7CCM","count":13},{"manuf":"Aeronca","year":"1948","model":"7AC","count":9},{"manuf":"Aeronca","year":"1948","model":"L-16B","count":1},{"manuf":"Aeronca","year":"1948","model":"AERONCA 7CCM","count":1},{"manuf":"Aeronca","year":"1948","model":"11CC","count":18},{"manuf":"Aeronca","year":"1948","model":"7EC CONV","count":1},{"manuf":"Aeronca","year":"1948","model":"7AC-CONV","count":1},{"manuf":"Aeronca","year":"1948","model":"11AC","count":1},{"manuf":"Aeronca","year":"1948","model":"AERONCA 7DC","count":1},{"manuf":"Aeronca","year":"1948","model":"S7CCM","count":1},{"manuf":"Aeronca","year":"1946","model":"7AC","count":1763},{"manuf":"Aeronca","year":"1946","model":"AERONCA 7BCM","count":8},{"manuf":"Aeronca","year":"1946","model":"11AC","count":496},{"manuf":"Aeronca","year":"1946","model
@bawbgale
bawbgale / top_1946_manuf_group_year_model_details.json
Created November 25, 2018 17:26
This file has been truncated, but you can view the full file.
[{"manuf":"Aeronca","year":"0","model":"7AC","count":166,"seats":2,"engines":1,"horsepower":140,"speed":90,"photos":[]},{"manuf":"Aeronca","year":"0","model":"7EC","count":31,"seats":2,"engines":1,"horsepower":115,"speed":90,"photos":[]},{"manuf":"Aeronca","year":"0","model":"7ECA","count":48,"seats":2,"engines":1,"horsepower":180,"speed":90,"photos":[]},{"manuf":"Aeronca","year":"0","model":"11BC","count":8,"seats":2,"engines":1,"horsepower":115,"speed":75,"photos":[]},{"manuf":"Aeronca","year":"0","model":"7BCM","count":67,"seats":2,"engines":1,"horsepower":100,"speed":90,"photos":[]},{"manuf":"Aeronca","year":"0","model":"7GCBC","count":20,"seats":2,"engines":1,"horsepower":180,"speed":90,"photos":[]},{"manuf":"Aeronca","year":"0","model":"AERONCA 7AC","count":7,"seats":2,"engines":1,"horsepower":115,"speed":90,"photos":[]},{"manuf":"Aeronca","year":"0","model":"50-C","count":2,"seats":2,"engines":1,"horsepower":50,"speed":75,"photos":[]},{"manuf":"Aeronca","year":"0","model":"7FC","count":21,"seats":2,"en
@bawbgale
bawbgale / faa_2018_aircraft_count_by_year_manuf.csv
Last active November 27, 2018 19:32
We can't make this file beautiful and searchable because it's too large.
Aircraft Count,Year,Manuf
1,2007,SWANSON CL JR
1,2005,FOSTER STEVE L
1,,KUKLO ROBERT M
1,2000,STEVENS JAMES JR
1,2001,OBRIEN PATRICK K
2,2000,AEROTRIKE
1,1994,TROMPETER MARK STEVEN
1,1999,OLDENKAMP D J/OLDENKAMP M L
1,1991,SPINK ROBERT M