Skip to content

Instantly share code, notes, and snippets.

View jhannah's full-sized avatar

Jay Hannah jhannah

View GitHub Profile
@jhannah
jhannah / gist:4659532da44743a01a6926ce914efb61
Last active January 28, 2023 21:13
Nebraska Bills Introduced after Jan 25th
Repo / HOWTO: https://github.com/jhannah/legislature_calendar/tree/main/experiments/CSV_dumps
So here are all the Nebraska Bills (LB)
NOT Resolutions (LR)
NOT Appropriation Bills (LB#####A)
introduced after Jan 25th of any year
sqlite> select h.date, b.bill_number, b.title, b.state_link
from bills b, history h
where b.bill_id = h.bill_id
@jhannah
jhannah / gist:c7dc48c532b1b3929143d4815639662b
Created January 12, 2023 21:41
Am I taking too much / too little time off?
With our "unlimited PTO" policy, I was curious if I've been, roughly, taking too much or too little time off.
So I dumped all my worked hours out of Tempo (Jira) since 2018.
Here's my source code:
https://github.com/jhannah/sandbox/blob/main/jhannah/hours.pl
And here's the result of running the program:
✗ perl hours.pl
Per year: 4 weeks off (PTO + sick) + 11 holidays
@jhannah
jhannah / git_flux.md
Last active December 15, 2022 18:35
git flux
curl -w "@curl-format.txt" -o /dev/null -s https://www.google.com
time_namelookup: 0.010029s
time_connect: 0.043444s
time_appconnect: 0.099994s
time_pretransfer: 0.100094s
time_redirect: 0.000000s
time_starttransfer: 0.184069s
----------
time_total: 0.189819s
@jhannah
jhannah / gist:4c74c240ba987edea6e5f0f72a342ab3
Created December 16, 2021 20:42
Amortization schedule w/ principle-only payments
Here's a little Perl script I wrote:
https://github.com/jhannah/sandbox/blob/main/amortize.pl
✗ ./amortize.pl
Usage:
amortize.pl --principle=176000 --periods=180 --interest_rate=2.13 \
--principle_payment=12:2000 \
--principle_payment=24:2000
Take out a $176,000 loan over 15 years at 2.13% APR.
@jhannah
jhannah / gist:7896346
Created December 10, 2013 19:11
My podcast list in OPML
Here are the podcasts I'm rotating through currently. A couple of these I've not yet listened to.
Many of them I've been listening to for years. :)
#moodswings
iTunes File | Library | Export Playlist | OPML
<?xml version="1.0" encoding="UTF-8"?>
<opml version="1.0">
<head>
@jhannah
jhannah / omaha_code_schools.md
Last active June 6, 2022 20:29
Omaha Nebraska "code schools"
@jhannah
jhannah / gist:e1cda1d53f2ebb04a7204976a1477762
Created December 22, 2021 02:41
2021 Nebraska Legislature
https://legiscan.com/NE/datasets 107th Legislature CSV
#! env perl
use Modern::Perl;
use Text::CSV_XS;
no warnings "experimental";
my (%dates, $actions);
my $csv = Text::CSV_XS->new ({ binary => 1, auto_diag => 1 });
open my $fh, "<:encoding(utf8)", "history.csv" or die $!;
@jhannah
jhannah / gist:9541cadd3081ddd1d8ba146173d0775a
Last active March 10, 2021 03:14
Google Civic Information API example
A random house I chose from Google Maps:
4215 S 28th St, Omaha, NE 68107
https://developers.google.com/civic-information/docs/v2/representatives/representativeInfoByAddress?apix_params=%7B%22address%22%3A%224215%20S%2028th%20St%2C%20Omaha%2C%20NE%2068107%22%7D
Here's a collapsible tool of this same data: https://jsoneditoronline.org/#left=cloud.fc62383d0a2d4d8d9fcc8a8cc1f54d06
{
"normalizedInput": {
"line1": "4215 South 28th Street",
@jhannah
jhannah / omaha_streamers.md
Last active April 24, 2020 15:25
~Omaha Twitch streamers