Peter W techieshark

## fb-event-attendees.html
<html>
<head>
    <title>Facebook Evevt Attendees</title>
    <script type="text/javascript" src="http://code.jquery.com/jquery-latest.js"></script>

    <script type="text/javascript" src="yes.js"></script>
    <script type="text/javascript" src="maybe.js"></script>

    <script type="text/javascript">
        // code modified from http://www.zachhunter.com/2011/06/json-to-csv/

## fix_vancouver.csv

          
            Name
            Lat
            Lon
            Parent

            
              Vancouver
              45.63
              -122.60
              United States

## find.us.sh
for i in `cat more.words.us`; do
 if [ -z "`dig $i +short`" ]; then
   echo $i; echo $i | sed 's/\.//' | xargs dict;
 fi;
done;

## drupal_vocabs_nodecounts.sql
SELECT v.vid, v.name AS Vocabulary, td.tid, td.name AS Term, (SELECT count(*) FROM drupal_node n JOIN drupal_term_node tn2 ON n.nid = tn2.nid WHERE tn2.tid = td.tid) AS Count FROM drupal_vocabulary v JOIN drupal_term_data td ON v.vid = td.vid ORDER BY Count DESC;

## .bash.git.aliases
# Git
alias ga='git add'
alias gbs='git bisect'
alias gbl='git blame'
alias gb='git branch'
alias gco='git checkout'
alias gc='git commit'
alias gcl='git clone'
alias gcp='git cherry-pick'
alias gd='git diff'

## gist:67891cae67e44db0483a
Some questions that could be answered by the campaign finance database:

- How much money has been raised in Oregon in 2014? (In state? Out of state?)
- How much money has been spent in Oregon in 2014? (In state? Out of state?)
- Where is the money being spent on? (ex: bar chart, or maybe a wordle of the descriptions)
- How many unique donors are there in Oregon politics (in 2014)?
- What are the three most grass roots PACs? (most unique donations)
- What are the three least grass roots PACs? (fewest unique donations)
- What are the five PACs who have the highest % of their funding from out of state? (And what is that %?)

## 2013-Oregon-PACs-by-cash-raised.txt
campaign_finance=# SELECT filer, ceil(SUM(amount))::text::money as total FROM raw_committee_transactions WHERE tran_date >= '2013-01-01' AND tran_date <= '2013-11-05' AND sub_type LIKE 'Cash Contribution' GROUP BY filer ORDER BY total;

                                        filer                                        |    total
-------------------------------------------------------------------------------------+-------------
 Friends of LaVonne Griffin-Valade                                                   |       $2.00
 Voter Approval of Urban Renewal                                                     |       $5.00
 Limit City Debt                                                                     |       $5.00
 Jeremy Ferguson for Mayor                                                           |       $5.00
 Friends of Sal Peralta                                                              |       $9.00
 New Covenant PAC                                                                    |

## political-spenders.txt
# Biggest spenders in Oregon Politics, in 2013.

# spender: the candidate or PAC
# freq: the number of times they gave to another candidate or PAC
# total: the sum of all contributions the spender made to another candidate or PAC
# using the database found here: https://github.com/hackoregon/backend

campaign_finance=# SELECT contributor_payee AS spender, COUNT(amount) as Freq, ceil(SUM(amount))::text::money as Total FROM raw_committee_transactions WHERE sub_type LIKE 'Cash Contribution' AND contributor_payee_committee_id IS NOT NULL AND tran_date >= '2013-01-01' AND tran_date <= '2013-12-31' GROUP BY spender ORDER BY total DESC;
                                     spender                                     | freq |    total
---------------------------------------------------------------------------------+------+-------------

## 14-0561.geojson

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                techieshark
                / 14-0561.geojson
            
            
              Created
              June 13, 2014 06:06
            
              
                map bits
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## designer.html
<link rel="import" href="../paper-radio-group/paper-radio-group.html">
<link rel="import" href="../paper-radio-button/paper-radio-button.html">

<polymer-element name="my-element">

  <template>
    <style>
      :host {
        position: absolute;
        width: 50%;
	<html>
	<head>
	<title>Facebook Evevt Attendees</title>
	<script type="text/javascript" src="http://code.jquery.com/jquery-latest.js"></script>

	<script type="text/javascript" src="yes.js"></script>
	<script type="text/javascript" src="maybe.js"></script>

	<script type="text/javascript">
	// code modified from http://www.zachhunter.com/2011/06/json-to-csv/
	for i in `cat more.words.us`; do
	if [ -z "`dig $i +short`" ]; then
	echo $i; echo $i \| sed 's/\.//' \| xargs dict;
	fi;
	done;
	# Git
	alias ga='git add'
	alias gbs='git bisect'
	alias gbl='git blame'
	alias gb='git branch'
	alias gco='git checkout'
	alias gc='git commit'
	alias gcl='git clone'
	alias gcp='git cherry-pick'
	alias gd='git diff'
	Some questions that could be answered by the campaign finance database:

	- How much money has been raised in Oregon in 2014? (In state? Out of state?)
	- How much money has been spent in Oregon in 2014? (In state? Out of state?)
	- Where is the money being spent on? (ex: bar chart, or maybe a wordle of the descriptions)
	- How many unique donors are there in Oregon politics (in 2014)?
	- What are the three most grass roots PACs? (most unique donations)
	- What are the three least grass roots PACs? (fewest unique donations)
	- What are the five PACs who have the highest % of their funding from out of state? (And what is that %?)
	campaign_finance=# SELECT filer, ceil(SUM(amount))::text::money as total FROM raw_committee_transactions WHERE tran_date >= '2013-01-01' AND tran_date <= '2013-11-05' AND sub_type LIKE 'Cash Contribution' GROUP BY filer ORDER BY total;

	filer \| total
	-------------------------------------------------------------------------------------+-------------
	Friends of LaVonne Griffin-Valade \| $2.00
	Voter Approval of Urban Renewal \| $5.00
	Limit City Debt \| $5.00
	Jeremy Ferguson for Mayor \| $5.00
	Friends of Sal Peralta \| $9.00
	New Covenant PAC \|
	# Biggest spenders in Oregon Politics, in 2013.

	# spender: the candidate or PAC
	# freq: the number of times they gave to another candidate or PAC
	# total: the sum of all contributions the spender made to another candidate or PAC
	# using the database found here: https://github.com/hackoregon/backend

	campaign_finance=# SELECT contributor_payee AS spender, COUNT(amount) as Freq, ceil(SUM(amount))::text::money as Total FROM raw_committee_transactions WHERE sub_type LIKE 'Cash Contribution' AND contributor_payee_committee_id IS NOT NULL AND tran_date >= '2013-01-01' AND tran_date <= '2013-12-31' GROUP BY spender ORDER BY total DESC;
	spender \| freq \| total
	---------------------------------------------------------------------------------+------+-------------
	<link rel="import" href="../paper-radio-group/paper-radio-group.html">
	<link rel="import" href="../paper-radio-button/paper-radio-button.html">

	<polymer-element name="my-element">

	<template>
	<style>
	:host {
	position: absolute;
	width: 50%;