mattdsteele · March 14, 2017 22:31 · Mar 14, 2017 · Mar 14, 2017 · Mar 14, 2017 · Mar 14, 2017
diff --git a/README.md b/README.md
@@ -1,5 +1,17 @@
 Bracketology based on the 2016 presidential election.
 
-Schools advance based on whichever county had the higher Hillary Clinton vote percentage.
+Schools advance based on whichever county had the higher Hillary Clinton vote percentage. Maryland is going to take it all with 85%, apparently.
 
-# Methodology
+# [View bracket](http://games.espn.com/tournament-challenge-bracket/2017/en/entry?entryID=9675904)
+
+# Methodology
+
+* Grabbed schools from [FiveThirtyEight](https://projects.fivethirtyeight.com/march-madness-api/2017/fivethirtyeight_ncaa_forecasts.csv)
+* Found which city each school was in by tapping into [Peterson's search](https://www.petersons.com/)
+* Found each county/FIPS number by screen-scraping [this site](http://gis.pongworld.com/lookup.php?searchtype=usfips)
+* Cross-referencing FIPS numbers against this [unofficial presidential results dataset](https://raw.githubusercontent.com/mkearney/presidential_election_county_results_2016/master/pres.elect16.results.dec9.csv)
+
+## Other notes
+
+* Play-in teams advanced based on the lower Clinton vote percentage. I blame the superdelegates.
+* The final score will be 48-47, with Maryland winning the popular score, due to the millions of illegal points scored in California.
diff --git a/electoral-college-results.csv b/electoral-college-results.csv
@@ -1,69 +1,69 @@
 team,city,state,fip,hillaryPct,trumpPct
-Arizona,Flagstaff,arizona,4005,56.33,36.89
-Arkansas,Magnolia,arkansas,5027,35.33,61.39
+Oklahoma State,Durant,oklahoma,40013,20.28,75.85
+West Virginia Institute,Raleigh,west virginia,54081,21.71,74.49
+Vanderbilt,Nashville,tennessee,37057,24.06,73.42
+East Tennessee State,Johnson City,tennessee,47179,26.32,69.17
+Jacksonville State,Jacksonville,alabama,1015,27.86,69.24
+Middle Tennessee,Murfreesboro,tennessee,47149,34.39,60.49
+Northern Kentucky,Highland Heights,kentucky,21037,34.5,58.96
 Baylor,Waco,texas,48309,34.56,61.65
 Bucknell,Lewisburg,pennsylvania,42119,35.28,60.95
-Butler,Indianapolis,indiana,18097,58.9,36.07
-Cincinnati,Cincinnati,ohio,39061,52.55,43.03
-Creighton,Omaha,nebraska,31055,47.92,46.53
-Dayton,Dayton,ohio,39113,47.15,48.39
-Duke,Durham,north carolina,37063,78.9,18.52
-East Tennessee State,Johnson City,tennessee,47179,26.32,69.17
-Florida,Hialeah,florida,12086,63.66,34.09
+Arkansas,Magnolia,arkansas,5027,35.33,61.39
+Winthrop,Rock Hill,south carolina,45091,36.35,58.4
+North Dakota,Grand Forks,north dakota,38035,36.44,54.95
+Wichita State,Wichita,kansas,20173,36.91,56.05
+Wisconsin,Mequon,wisconsin,55089,37.79,57.07
 Florida Gulf Coast,Fort Myers,florida,12071,38.28,58.67
-Florida State,Tallahassee,florida,12073,60.51,35.4
+South Dakota State,Brookings,south dakota,46011,38.48,53.22
+Troy,Troy,alabama,1109,38.69,58.97
 Gonzaga,Spokane,washington,53063,41.61,49.91
-Iona,New Rochelle,new york,36119,64.91,32.14
-Iowa State,Ames,iowa,19169,51.29,39.07
-Jacksonville State,Jacksonville,alabama,1015,27.86,69.24
-Kansas,Lawrence,kansas,20045,62.39,29.67
-Kansas State,Manhattan,kansas,20161,43.43,47.95
 Kent State,Kent,ohio,39133,42.54,52.7
-Kentucky,Lexington,kentucky,21067,51.22,41.76
-Louisville,Louisville,kentucky,21111,54.07,40.73
-Marquette,Milwaukee,wisconsin,55079,66.44,28.99
-Maryland,Baltimore,maryland,24510,85.44,10.87
-Miami (FL),Coral Gables,florida,12086,63.66,34.09
-Michigan,Mount Pleasant,michigan,26073,45,48.68
-Michigan State,East Lansing,michigan,26065,60.88,33.23
-Middle Tennessee,Murfreesboro,tennessee,47149,34.39,60.49
+Kansas State,Manhattan,kansas,20161,43.43,47.95
+Purdue,West Lafayette,indiana,18157,43.94,49.6
 Minnesota,Moorhead,minnesota,27027,44.57,46.55
+Michigan,Mount Pleasant,michigan,26073,45,48.68
 Mount St. Mary's,Emmitsburg,maryland,24021,45.14,49.12
-Nevada,Henderson,nevada,32003,52.4,41.75
-New Mexico State,Las Cruces,new mexico,35013,53.73,35.91
-New Orleans,New Orleans,louisiana,22071,80.81,14.65
-North Carolina,Chapel Hill,north carolina,37135,74.03,23.01
-North Carolina Central,Durham,north carolina,37063,78.9,18.52
 North Carolina-Wilmington,Wilmington,north carolina,37129,46.18,50.27
-North Dakota,Grand Forks,north dakota,38035,36.44,54.95
-Northern Kentucky,Highland Heights,kentucky,21037,34.5,58.96
-Northwestern,Evanston,illinois,17031,74.38,21.42
+Virginia Tech,Blacksburg,virginia,51121,46.88,45.57
+Dayton,Dayton,ohio,39113,47.15,48.39
 Notre Dame,Notre Dame,indiana,18141,47.74,47.53
-Oklahoma State,Durant,oklahoma,40013,20.28,75.85
+Creighton,Omaha,nebraska,31055,47.92,46.53
+Kentucky,Lexington,kentucky,21067,51.22,41.76
+Iowa State,Ames,iowa,19169,51.29,39.07
+Rhode Island,Kingston,rhode island,44009,52.16,42.14
+Nevada,Henderson,nevada,32003,52.4,41.75
+Cincinnati,Cincinnati,ohio,39061,52.55,43.03
+Xavier,Cincinnati,ohio,39061,52.55,43.03
+Wake Forest,Winston-Salem,north carolina,37067,53.61,43.36
+New Mexico State,Las Cruces,new mexico,35013,53.73,35.91
+Louisville,Louisville,kentucky,21111,54.07,40.73
+Texas Southern,Houston,texas,48201,54.22,41.83
 Oregon,Eugene,oregon,41039,55.5,36.57
-Princeton,Princeton,new jersey,34021,66.31,30.14
+Arizona,Flagstaff,arizona,4005,56.33,36.89
 Providence,Providence,rhode island,44007,58.47,37.3
-Purdue,West Lafayette,indiana,18157,43.94,49.6
-Rhode Island,Kingston,rhode island,44009,52.16,42.14
-Saint Mary's (CA),Contra Costa,california,6013,68.91,25.44
-Seton Hall,South Orange,new jersey,34013,77.06,20.7
-South Carolina,Orangeburg,south carolina,45075,67.63,30.67
-South Dakota State,Brookings,south dakota,46011,38.48,53.22
-Southern California,Los Angeles,california,6037,71.41,23.39
+Butler,Indianapolis,indiana,18097,58.9,36.07
+Villanova,Villanova,pennsylvania,42045,59.39,37.41
+Florida State,Tallahassee,florida,12073,60.51,35.4
+Michigan State,East Lansing,michigan,26065,60.88,33.23
 Southern Methodist,Dallas,texas,48113,61.13,34.89
-Texas Southern,Houston,texas,48201,54.22,41.83
-Troy,Troy,alabama,1109,38.69,58.97
+Kansas,Lawrence,kansas,20045,62.39,29.67
+Florida,Hialeah,florida,12086,63.66,34.09
+Miami (FL),Coral Gables,florida,12086,63.66,34.09
+Iona,New Rochelle,new york,36119,64.91,32.14
+Princeton,Princeton,new jersey,34021,66.31,30.14
+Marquette,Milwaukee,wisconsin,55079,66.44,28.99
+South Carolina,Orangeburg,south carolina,45075,67.63,30.67
 UC-Davis,Davis,california,6113,68.07,26.03
-UCLA,Los Angeles,california,6037,71.41,23.39
-Vanderbilt,Nashville,tennessee,37057,24.06,73.42
+Saint Mary's (CA),Contra Costa,california,6013,68.91,25.44
 Vermont,Burlington,vermont,50007,70.49,23.68
-Villanova,Villanova,pennsylvania,42045,59.39,37.41
-Virginia,Petersburg,virginia,51730,87.52,10.56
+Southern California,Los Angeles,california,6037,71.41,23.39
+UCLA,Los Angeles,california,6037,71.41,23.39
+North Carolina,Chapel Hill,north carolina,37135,74.03,23.01
+Northwestern,Evanston,illinois,17031,74.38,21.42
+Seton Hall,South Orange,new jersey,34013,77.06,20.7
 Virginia Commonwealth,Richmond,virginia,51760,78.8,15.05
-Virginia Tech,Blacksburg,virginia,51121,46.88,45.57
-Wake Forest,Winston-Salem,north carolina,37067,53.61,43.36
-West Virginia Institute,Raleigh,west virginia,54081,21.71,74.49
-Wichita State,Wichita,kansas,20173,36.91,56.05
-Winthrop,Rock Hill,south carolina,45091,36.35,58.4
-Wisconsin,Mequon,wisconsin,55089,37.79,57.07
-Xavier,Cincinnati,ohio,39061,52.55,43.03
+Duke,Durham,north carolina,37063,78.9,18.52
+North Carolina Central,Durham,north carolina,37063,78.9,18.52
+Virginia,Petersburg,virginia,51540,80.43,13.28
+New Orleans,New Orleans,louisiana,22071,80.81,14.65
+Maryland,Baltimore,maryland,24510,85.44,10.87
diff --git a/README.md b/README.md
@@ -1,10 +1,17 @@
 Bracketology based on the 2016 presidential election.
 
-Schools advance based on whichever county had the higher Hillary Clinton vote percentage. UVA is going to take it all, apparently.
+Schools advance based on whichever county had the higher Hillary Clinton vote percentage. Maryland is going to take it all with 85%, apparently.
+
+# [View bracket](http://games.espn.com/tournament-challenge-bracket/2017/en/entry?entryID=9675904)
 
 # Methodology
 
 * Grabbed schools from [FiveThirtyEight](https://projects.fivethirtyeight.com/march-madness-api/2017/fivethirtyeight_ncaa_forecasts.csv)
 * Found which city each school was in by tapping into [Peterson's search](https://www.petersons.com/)
 * Found each county/FIPS number by screen-scraping [this site](http://gis.pongworld.com/lookup.php?searchtype=usfips)
-* Cross-referencing FIPS numbers against this [unofficial presidential results dataset](https://raw.githubusercontent.com/mkearney/presidential_election_county_results_2016/master/pres.elect16.results.dec9.csv)
+* Cross-referencing FIPS numbers against this [unofficial presidential results dataset](https://raw.githubusercontent.com/mkearney/presidential_election_county_results_2016/master/pres.elect16.results.dec9.csv)
+
+## Other notes
+
+* Play-in teams advanced based on the lower Clinton vote percentage. I blame the superdelegates.
+* The final score will be 48-47, with Maryland winning the popular score, due to the millions of illegal points scored in California.
diff --git a/README.md b/README.md
@@ -1,5 +1,10 @@
 Bracketology based on the 2016 presidential election.
 
-Schools advance based on whichever county had the higher Hillary Clinton vote percentage.
+Schools advance based on whichever county had the higher Hillary Clinton vote percentage. UVA is going to take it all, apparently.
 
-# Methodology
+# Methodology
+
+* Grabbed schools from [FiveThirtyEight](https://projects.fivethirtyeight.com/march-madness-api/2017/fivethirtyeight_ncaa_forecasts.csv)
+* Found which city each school was in by tapping into [Peterson's search](https://www.petersons.com/)
+* Found each county/FIPS number by screen-scraping [this site](http://gis.pongworld.com/lookup.php?searchtype=usfips)
+* Cross-referencing FIPS numbers against this [unofficial presidential results dataset](https://raw.githubusercontent.com/mkearney/presidential_election_county_results_2016/master/pres.elect16.results.dec9.csv)
diff --git a/electoral-college-results.csv b/electoral-college-results.csv
@@ -0,0 +1,69 @@
+team,city,state,fip,hillaryPct,trumpPct
+Arizona,Flagstaff,arizona,4005,56.33,36.89
+Arkansas,Magnolia,arkansas,5027,35.33,61.39
+Baylor,Waco,texas,48309,34.56,61.65
+Bucknell,Lewisburg,pennsylvania,42119,35.28,60.95
+Butler,Indianapolis,indiana,18097,58.9,36.07
+Cincinnati,Cincinnati,ohio,39061,52.55,43.03
+Creighton,Omaha,nebraska,31055,47.92,46.53
+Dayton,Dayton,ohio,39113,47.15,48.39
+Duke,Durham,north carolina,37063,78.9,18.52
+East Tennessee State,Johnson City,tennessee,47179,26.32,69.17
+Florida,Hialeah,florida,12086,63.66,34.09
+Florida Gulf Coast,Fort Myers,florida,12071,38.28,58.67
+Florida State,Tallahassee,florida,12073,60.51,35.4
+Gonzaga,Spokane,washington,53063,41.61,49.91
+Iona,New Rochelle,new york,36119,64.91,32.14
+Iowa State,Ames,iowa,19169,51.29,39.07
+Jacksonville State,Jacksonville,alabama,1015,27.86,69.24
+Kansas,Lawrence,kansas,20045,62.39,29.67
+Kansas State,Manhattan,kansas,20161,43.43,47.95
+Kent State,Kent,ohio,39133,42.54,52.7
+Kentucky,Lexington,kentucky,21067,51.22,41.76
+Louisville,Louisville,kentucky,21111,54.07,40.73
+Marquette,Milwaukee,wisconsin,55079,66.44,28.99
+Maryland,Baltimore,maryland,24510,85.44,10.87
+Miami (FL),Coral Gables,florida,12086,63.66,34.09
+Michigan,Mount Pleasant,michigan,26073,45,48.68
+Michigan State,East Lansing,michigan,26065,60.88,33.23
+Middle Tennessee,Murfreesboro,tennessee,47149,34.39,60.49
+Minnesota,Moorhead,minnesota,27027,44.57,46.55
+Mount St. Mary's,Emmitsburg,maryland,24021,45.14,49.12
+Nevada,Henderson,nevada,32003,52.4,41.75
+New Mexico State,Las Cruces,new mexico,35013,53.73,35.91
+New Orleans,New Orleans,louisiana,22071,80.81,14.65
+North Carolina,Chapel Hill,north carolina,37135,74.03,23.01
+North Carolina Central,Durham,north carolina,37063,78.9,18.52
+North Carolina-Wilmington,Wilmington,north carolina,37129,46.18,50.27
+North Dakota,Grand Forks,north dakota,38035,36.44,54.95
+Northern Kentucky,Highland Heights,kentucky,21037,34.5,58.96
+Northwestern,Evanston,illinois,17031,74.38,21.42
+Notre Dame,Notre Dame,indiana,18141,47.74,47.53
+Oklahoma State,Durant,oklahoma,40013,20.28,75.85
+Oregon,Eugene,oregon,41039,55.5,36.57
+Princeton,Princeton,new jersey,34021,66.31,30.14
+Providence,Providence,rhode island,44007,58.47,37.3
+Purdue,West Lafayette,indiana,18157,43.94,49.6
+Rhode Island,Kingston,rhode island,44009,52.16,42.14
+Saint Mary's (CA),Contra Costa,california,6013,68.91,25.44
+Seton Hall,South Orange,new jersey,34013,77.06,20.7
+South Carolina,Orangeburg,south carolina,45075,67.63,30.67
+South Dakota State,Brookings,south dakota,46011,38.48,53.22
+Southern California,Los Angeles,california,6037,71.41,23.39
+Southern Methodist,Dallas,texas,48113,61.13,34.89
+Texas Southern,Houston,texas,48201,54.22,41.83
+Troy,Troy,alabama,1109,38.69,58.97
+UC-Davis,Davis,california,6113,68.07,26.03
+UCLA,Los Angeles,california,6037,71.41,23.39
+Vanderbilt,Nashville,tennessee,37057,24.06,73.42
+Vermont,Burlington,vermont,50007,70.49,23.68
+Villanova,Villanova,pennsylvania,42045,59.39,37.41
+Virginia,Petersburg,virginia,51730,87.52,10.56
+Virginia Commonwealth,Richmond,virginia,51760,78.8,15.05
+Virginia Tech,Blacksburg,virginia,51121,46.88,45.57
+Wake Forest,Winston-Salem,north carolina,37067,53.61,43.36
+West Virginia Institute,Raleigh,west virginia,54081,21.71,74.49
+Wichita State,Wichita,kansas,20173,36.91,56.05
+Winthrop,Rock Hill,south carolina,45091,36.35,58.4
+Wisconsin,Mequon,wisconsin,55089,37.79,57.07
+Xavier,Cincinnati,ohio,39061,52.55,43.03
diff --git a/get-election-results.js b/get-election-results.js
@@ -0,0 +1,72 @@
+const csv = require('fast-csv');
+const getSchools = () => {
+  const { readFileSync } = require('fs');
+
+  const input = readFileSync('schools-with-fips-cleaned.csv', 'utf8');
+  const schoolsAsZip = [];
+
+  return new Promise(res => {
+    csv.fromString(input, { headers: true })
+      .on('data', d => {
+        schoolsAsZip.push({
+          team: d.team,
+          city: d.city,
+          state: d.state,
+          fip: d.fips
+        });
+      })
+      .on('end', () => {
+        res(schoolsAsZip)
+      });
+  });
+};
+
+const getElectionResults = async () => {
+  const fetch = require('node-fetch');
+
+  const data = 'https://raw.githubusercontent.com/mkearney/presidential_election_county_results_2016/master/pres.elect16.results.dec9.csv';
+  const result = await fetch(data);
+  const results = await result.text();
+  const fipsResults = [];
+
+  return new Promise(res => {
+    csv.fromString(results, { headers: true })
+    .on('data', d => {
+      if (d.county !== 'NA') {
+        fipsResults.push({
+          fip: d.fips,
+          candidate: d.cand,
+          pct: d.pct * 100
+        })
+      }
+    })
+    .on('end', () => res(fipsResults));
+  });
+};
+
+
+const run = async () => {
+  const schools = await getSchools();
+  const electionResults = await getElectionResults();
+
+  for (const school of schools) {
+    const { fip } = school;
+    const resultsForFip = electionResults.filter(e => e.fip === fip);
+    if (resultsForFip.length === 0) {
+      console.error('no FIPs', fip, school);
+    }
+    const hillaryPct = resultsForFip.filter(e => e.candidate === 'Hillary Clinton')[0].pct;
+    const trumpPct = resultsForFip.filter(e => e.candidate === 'Donald Trump')[0].pct;
+    school.hillaryPct = Math.round(hillaryPct * 100) / 100;
+    school.trumpPct = Math.round(trumpPct * 100) / 100;
+  }
+
+  const sortedSchools =schools.sort((a, b) => a < b);
+
+  csv.writeToPath('electoral-college-results.csv', sortedSchools, { headers: true })
+    .on('finish', () => {
+      console.log('done');
+    });
+};
+
+run();
diff --git a/package.json b/package.json
@@ -0,0 +1,21 @@
+{
+  "name": "electoral-college-basketball",
+  "version": "1.0.0",
+  "description": "",
+  "main": "index.js",
+  "scripts": {
+    "test": "echo \"Error: no test specified\" && exit 1"
+  },
+  "keywords": [],
+  "author": "",
+  "license": "ISC",
+  "devDependencies": {
+    "fast-csv": "^2.4.0"
+  },
+  "dependencies": {
+    "cheerio": "^0.22.0",
+    "form-data": "^2.1.2",
+    "left-pad": "^1.1.3",
+    "node-fetch": "^1.6.3"
+  }
+}
diff --git a/parse-teams.js b/parse-teams.js
@@ -0,0 +1,190 @@
+const getSchools = () => {
+  const { readFileSync } = require('fs');
+
+  const input = readFileSync('teams.csv', 'utf8');
+  const schoolsAsZip = [];
+
+  return new Promise(res => {
+    const csv = require('fast-csv');
+    csv.fromString(input, { headers: true })
+      .on('data', d => {
+        schoolsAsZip.push({
+          team: d.team_name
+        });
+      })
+      .on('end', () => {
+        res(schoolsAsZip)
+      });
+  });
+};
+
+const addCity = async () => {
+  const searchUrl = 'https://mapi.petersons.com/api/v2/School';
+  const fetch = require('node-fetch');
+
+  const result = await fetch(searchUrl, {
+    headers: { 
+      'Content-Type': 'application/json' ,
+      'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36',
+      'Referrer': 'https://www.petersons.com/search/schools?searchtype=12&page=1&result=15&searchterm=creighton',
+      'Petersons-Subscription-key': 'rZYXDqtcS2fkdItzl4o0eVNjunxQpZLPiZ8+LcFNi//OJVljl2pYsFx9gflQMURGNfhh4UwzoNokWX9ETjm/TuAGiUPJBCX+l/rgOtXvG2WUYRkfXFOYGZNYHkgndGC8zYszcSw5VRnzyqnAN7BidfmjsenSe/TdgboBo6EqWE+dzLQHd42ovQv3GxQGieAj'
+    },
+    method: 'POST', 
+    body: JSON.stringify({
+      pageNumber: 1,
+      resultsPerPage: 15,
+      criteria: [],
+      searchTerm: null,
+      enhancedProfilesOnly: false,
+      checkSpelling: false,
+      userIpAddress: '174.70.57.3',
+      searchterm: 'creighton',
+      sessionId: 'fkaryk2ku2tiq3ndsxdrubcz',
+      searchType: 12
+    })
+    //  {"pageNumber":1,"resultsPerPage":15,"criteria":[],"searchTerm":null,"enhancedProfilesOnly":false,"checkSpelling":false,"searchType":"12","userEmail":"","userIpAddress":"174.70.57.3","sessionId":"fkaryk2ku2tiq3ndsxdrubcz","searchterm":"creighton"}
+  });
+  console.log(result);
+  //const asJson = result.json();
+}
+
+
+const getCity = async (college) => {
+  const collegeAsUri = college.replace('\'', '').replace('(', '').replace(')', '');
+  console.log('getting college', collegeAsUri);
+  const cmd = `curl 'https://mapi.petersons.com/api/v2/School' -H 'Pragma: no-cache' -H 'Origin: https://www.petersons.com' -H 'Accept-Encoding: gzip, deflate, br' -H 'Accept-Language: en-US,en;q=0.8' -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36' -H 'Content-Type: application/json' -H 'Accept: application/json, text/plain, */*' -H 'Cache-Control: no-cache' -H 'Referer: https://www.petersons.com/search/schools?searchtype=12&page=1&result=15&searchterm=vermont&criteria=1-collegeTypes:traditional;2-degreeTypes:bachelors;6-studentPopulation:large,verylarge,midsize,small' -H 'Connection: keep-alive' -H 'Petersons-Subscription-key: rZYXDqtcS2fkdItzl4o0eVNjunxQpZLPiZ8+LcFNi//OJVljl2pYsFx9gflQMURGNfhh4UwzoNokWX9ETjm/TuAGiUPJBCX+l/rgOtXvG2WUYRkfXFOYGZNYHkgndGC8zYszcSw5VRnzyqnAN7BidfmjsenSe/TdgboBo6EqWE+dzLQHd42ovQv3GxQGieAj' --data-binary '{"pageNumber":1,"resultsPerPage":15,"criteria":[{"filterType":1,"searchCriteria":"includeMissing:false|collegeTypes:traditional"},{"filterType":2,"searchCriteria":"includeMissing:false|degreeTypes:bachelors"},{"filterType":6,"searchCriteria":"includeMissing:false|studentPopulation:large,verylarge,midsize,small"}],"searchTerm":null,"enhancedProfilesOnly":false,"checkSpelling":false,"searchType":"12","userEmail":"","userIpAddress":"174.70.57.3","sessionId":"fkaryk2ku2tiq3ndsxdrubcz","searchterm":"${collegeAsUri}"}' --compressed`
+  const { exec } = require('child_process');
+  return new Promise((res, rej) => {
+    exec(cmd, {}, (err, stdout) => {
+      if (err) {
+        rej(err);
+      } else {
+        const results = JSON.parse(stdout);
+        if (results.Results.length > 0) {
+          const firstResult = results.Results[0];
+          const geoData = {
+            id: college,
+            fullSchoolName: firstResult.SchoolName,
+            city: firstResult.SchoolCity,
+            state: firstResult.StateCode,
+            stateName: firstResult.StateName,
+            zip: firstResult.ZipCode
+          };
+          res(geoData);
+        } else {
+          res({ id: college });
+        }
+      }
+    });
+  });
+};
+
+const getFips = async({ city, stateName, zip }) => {
+  const mappings = {
+    'alabama': 'US01',
+    'alaska': 'US02',
+    'arizona': 'US04',
+    'arkansas': 'US05',
+    'california': 'US06',
+    'colorado': 'US08',
+    'connecticut': 'US09',
+    'delaware': 'US10',
+    'district of columbia': 'US11',
+    'florida': 'US12',
+    'georgia': 'US13',
+    'guantanamo bay': 'US',
+    'hawaii': 'US15',
+    'idaho': 'US16',
+    'illinois': 'US17',
+    'indiana': 'US18',
+    'iowa': 'US19',
+    'kansas': 'US20',
+    'kentucky': 'US21',
+    'louisiana': 'US22',
+    'maine': 'US23',
+    'maryland': 'US24',
+    'massachusetts': 'US25',
+    'michigan': 'US26',
+    'minnesota': 'US27',
+    'mississippi': 'US28',
+    'missouri': 'US29',
+    'montana': 'US30',
+    'nebraska': 'US31',
+    'nevada': 'US32',
+    'new hampshire': 'US33',
+    'new jersey': 'US34',
+    'new mexico': 'US35',
+    'new york': 'US36',
+    'north carolina': 'US37',
+    'north dakota': 'US38',
+    'ohio': 'US39',
+    'oklahoma': 'US40',
+    'oregon': 'US41',
+    'pennsylvania': 'US42',
+    'rhode island': 'US44',
+    'south carolina': 'US45',
+    'south dakota': 'US46',
+    'tennessee': 'US47',
+    'texas': 'US48',
+    'utah': 'US49',
+    'vermont': 'US50',
+    'virginia': 'US51',
+    'washington': 'US53',
+    'west virginia': 'US54',
+    'wisconsin': 'US55',
+    'wyoming': 'US56'
+  };
+
+  if (!city) { return null; }
+
+  const fetch = require('node-fetch');
+  const FormData = require('form-data');
+  const fipsSearchUrl = 'http://gis.pongworld.com/lookup.php?searchtype=usfips';
+  const form = new FormData();
+  const stateKey = mappings[stateName.toLowerCase()];
+  console.log('state key', stateKey);
+  form.append('searchtype', 'usplace');
+  form.append('search', 'Go');
+  form.append('placename', city);
+  form.append('admin', stateKey);
+  const result = await fetch(fipsSearchUrl, { method: 'POST', body: form});
+  const txt = await result.text();
+
+  const cheerio = require('cheerio');
+  const $ = cheerio.load(txt);
+  const fips = $('table[align] tr:nth-of-type(2) td:nth-of-type(2)');
+  if (fips.length == 1) {
+    const leftPad = require('left-pad');
+    const paddedFips = `${stateKey.substring(2)}${leftPad(fips.text(), 3, '0')}`;
+    return paddedFips;
+  } else {
+    return null;
+  }
+};
+
+
+const run = async() => {
+  const schools = await getSchools();
+  const schoolsWithFips = [];
+  for (const school of schools) {
+    const city = await getCity(school.team);
+    const fips = await getFips(city);
+    console.log(school.team, fips)
+    schoolsWithFips.push({
+      team: school.team,
+      city: city.city,
+      state: city.stateName,
+      fips
+    });
+  }
+
+  const csv = require('fast-csv');
+  return new Promise(res => {
+    csv.writeToPath('schools-with-fips.csv', schoolsWithFips, { headers: true })
+      .on('finish', () => {
+        res();
+      });
+  });
+};
+
+run();
diff --git a/schools-with-fips-cleaned.csv b/schools-with-fips-cleaned.csv
@@ -0,0 +1,69 @@
+team,city,state,fips
+Villanova,Villanova,pennsylvania,42045
+Gonzaga,Spokane,washington,53063
+Kansas,Lawrence,kansas,20045
+Kentucky,Lexington,kentucky,21067
+North Carolina,Wilmington,north carolina,37129
+Duke,Durham,north carolina,37063
+Louisville,Louisville,kentucky,21111
+Arizona,Flagstaff,arizona,4005
+West Virginia Institute,Raleigh,west virginia,54081
+UCLA,Los Angeles,california,6037
+Virginia,Petersburg,virginia,51730
+Saint Mary's (CA),Contra Costa,california,6013
+Purdue,West Lafayette,indiana,18157
+Wichita State,Wichita,kansas,20173
+Southern Methodist,Dallas,texas,48113
+Iowa State,Ames,iowa,19169
+Baylor,Waco,texas,48309
+Oregon,Eugene,oregon,41039
+Butler,Indianapolis,indiana,18097
+Florida,Hialeah,florida,12086
+Florida State,Tallahassee,florida,12073
+Cincinnati,Cincinnati,ohio,39061
+Wisconsin,Mequon,wisconsin,55089
+Michigan,Mount Pleasant,michigan,26073
+Notre Dame,Notre Dame,indiana,18141
+Creighton,Omaha,nebraska,31055
+Oklahoma State,Durant,oklahoma,40013
+Miami (FL),Coral Gables,florida,12086
+Arkansas,Magnolia,arkansas,5027
+Vanderbilt,Nashville,tennessee,37057
+Rhode Island,Kingston,rhode island,44009
+Kansas State,Manhattan,kansas,20161
+South Carolina,Orangeburg,south carolina,45075
+Seton Hall,South Orange,new jersey,34013
+Dayton,Dayton,ohio,39113
+Marquette,Milwaukee,wisconsin,55079
+Michigan State,East Lansing,michigan,26065
+Wake Forest,Winston-Salem,north carolina,37067
+Xavier,Cincinnati,ohio,39061
+Virginia Commonwealth,Richmond,virginia,51760
+Middle Tennessee,Murfreesboro,tennessee,47149
+Maryland,Baltimore,maryland,24510
+Northwestern,Evanston,illinois,17031
+Minnesota,Moorhead,minnesota,27027
+Providence,Providence,rhode island,44007
+Southern California,Los Angeles,california,6037
+Nevada,Henderson,nevada,32003
+Princeton,Princeton,new jersey,34021
+North Carolina-Wilmington,Wilmington,north carolina,37129
+Virginia Tech,Blacksburg,virginia,51121
+Vermont,Burlington,vermont,50007
+Bucknell,Lewisburg,pennsylvania,42119
+East Tennessee State,Johnson City,tennessee,47179
+Winthrop,Rock Hill,south carolina,45091
+Florida Gulf Coast,Fort Myers,florida,12071
+New Mexico State,Las Cruces,new mexico,35013
+Iona,New Rochelle,new york,36119
+Kent State,Kent,ohio,39133
+Troy,Troy,alabama,1109
+Northern Kentucky,Highland Heights,kentucky,21037
+South Dakota State,Brookings,south dakota,46011
+North Dakota,Grand Forks,north dakota,38035
+Texas Southern,Houston,texas,48201
+Jacksonville State,Jacksonville,alabama,1015
+North Carolina Central,Durham,north carolina,37063
+UC-Davis,Davis,california,6113
+Mount St. Mary's,Emmitsburg,maryland,24021
+New Orleans,New Orleans,louisiana,22071
diff --git a/schools-with-fips.csv b/schools-with-fips.csv
@@ -0,0 +1,69 @@
+team,city,state,fips
+Villanova,Villanova,pennsylvania,
+Gonzaga,Spokane,washington,53063
+Kansas,Lawrence,kansas,20045
+Kentucky,Lexington,kentucky,21067
+North Carolina,Wilmington,north carolina,37129
+Duke,Durham,north carolina,37063
+Louisville,Louisville,kentucky,21111
+Arizona,Flagstaff,arizona,04005
+West Virginia,Institute,west virginia,
+UCLA,Los Angeles,california,06037
+Virginia,Petersburg,virginia,51730
+"Saint Mary's (CA)",,,
+Purdue,West Lafayette,indiana,18157
+Wichita State,Wichita,kansas,20173
+Southern Methodist,Dallas,texas,48113
+Iowa State,Ames,iowa,19169
+Baylor,Waco,texas,48309
+Oregon,Eugene,oregon,41039
+Butler,Indianapolis,indiana,
+Florida,Hialeah,florida,12025
+Florida State,Tallahassee,florida,12073
+Cincinnati,Cincinnati,ohio,39061
+Wisconsin,Mequon,wisconsin,55089
+Michigan,Mount Pleasant,michigan,26073
+Notre Dame,Notre Dame,indiana,
+Creighton,Omaha,nebraska,31055
+Oklahoma State,Durant,oklahoma,40013
+Miami (FL),Coral Gables,florida,12025
+Arkansas,Magnolia,arkansas,05027
+Vanderbilt,Nashville,tennessee,
+Rhode Island,Kingston,rhode island,44009
+Kansas State,Manhattan,kansas,20161
+South Carolina,Orangeburg,south carolina,45075
+Seton Hall,South Orange,new jersey,
+Dayton,Dayton,ohio,39113
+Marquette,Milwaukee,wisconsin,55079
+Michigan State,East Lansing,michigan,26065
+Wake Forest,Winston-Salem,north carolina,37067
+Xavier,Cincinnati,ohio,39061
+Virginia Commonwealth,Richmond,virginia,51760
+Middle Tennessee,Murfreesboro,tennessee,47149
+Maryland,Baltimore,maryland,24510
+Northwestern,Evanston,illinois,17031
+Minnesota,Moorhead,minnesota,27027
+Providence,Providence,rhode island,44007
+Southern California,Los Angeles,california,06037
+Nevada,Henderson,nevada,32003
+Princeton,Princeton,new jersey,34021
+North Carolina-Wilmington,Wilmington,north carolina,37129
+Virginia Tech,,,
+Vermont,Burlington,vermont,50007
+Bucknell,Lewisburg,pennsylvania,42119
+East Tennessee State,Johnson City,tennessee,47179
+Winthrop,Rock Hill,south carolina,45091
+Florida Gulf Coast,Fort Myers,florida,12071
+New Mexico State,Las Cruces,new mexico,35013
+Iona,New Rochelle,new york,36119
+Kent State,Kent,ohio,39133
+Troy,Troy,alabama,01109
+Northern Kentucky,Highland Heights,kentucky,21037
+South Dakota State,Brookings,south dakota,46011
+North Dakota,Grand Forks,north dakota,38035
+Texas Southern,Houston,texas,48201
+Jacksonville State,Jacksonville,alabama,01015
+North Carolina Central,Durham,north carolina,37063
+UC-Davis,,,
+"Mount St. Mary's",,,
+New Orleans,New Orleans,louisiana,22071
diff --git a/teams.csv b/teams.csv
@@ -0,0 +1,69 @@
+gender,forecast_date,playin_flag,rd1_win,rd2_win,rd3_win,rd4_win,rd5_win,rd6_win,rd7_win,team_alive,team_id,team_name,team_rating,team_region,team_seed
+mens,2017-03-12,False,1.0,0.987632001748,0.803221306689,0.589206003986,0.401737091759,0.241125213558,0.149953842962,True,222,Villanova,95.18,East,1
+mens,2017-03-12,False,1.0,0.976795630681,0.840203278311,0.595332929001,0.414664016514,0.229399633456,0.13847996946,True,2250,Gonzaga,93.71,West,1
+mens,2017-03-12,False,1.0,0.979612036046,0.80557280142,0.556596438875,0.380299150087,0.212211901047,0.103890499091,True,2305,Kansas,92.18,Midwest,1
+mens,2017-03-12,False,1.0,0.966806378802,0.68192340728,0.474828915467,0.302249842676,0.168237626264,0.081807350751,True,96,Kentucky,92.28,South,2
+mens,2017-03-12,False,1.0,0.979275339496,0.798724712655,0.579841979626,0.298548915726,0.154792229795,0.069972957665,True,153,North Carolina,91.74,South,1
+mens,2017-03-12,False,1.0,0.966903494344,0.77986968716,0.510116107073,0.236574933872,0.12211405819,0.066660797638,True,150,Duke,92.26,East,2
+mens,2017-03-12,False,1.0,0.973818118503,0.668185522471,0.465179386547,0.216097350359,0.110822048062,0.049736747758,True,97,Louisville,90.8,Midwest,2
+mens,2017-03-12,False,1.0,0.952501634965,0.568275077644,0.392453361664,0.161012216087,0.079675081501,0.043955030744,True,12,Arizona,88.99,West,2
+mens,2017-03-12,False,1.0,0.901829515036,0.645600990468,0.25600598144,0.146890204241,0.067773822183,0.03533303494,True,277,West Virginia,90.8,West,4
+mens,2017-03-12,False,1.0,0.941723642576,0.61453888774,0.208319786583,0.097548959503,0.052713170727,0.02485954293,True,26,UCLA,88.02,South,3
+mens,2017-03-12,False,1.0,0.844766911501,0.49157769056,0.178718248947,0.095957030872,0.047313097802,0.024829884468,True,258,Virginia,90.02,East,5
+mens,2017-03-12,False,1.0,0.737770787658,0.350551671732,0.257520481904,0.117770504604,0.046161800817,0.021078897482,True,2608,Saint Mary's (CA),87.39,West,7
+mens,2017-03-12,False,1.0,0.859696311013,0.506128913056,0.196615653959,0.106255355754,0.049423484122,0.020099202582,True,2509,Purdue,88.61,Midwest,4
+mens,2017-03-12,False,1.0,0.692358309471,0.244216762846,0.149894118977,0.083845937222,0.04374801393,0.019903767737,True,2724,Wichita State,88.86,South,10
+mens,2017-03-12,False,1.0,0.789641696307,0.456299666333,0.19790373503,0.071711275903,0.03362927079,0.016904120247,True,2567,Southern Methodist,88.43,East,6
+mens,2017-03-12,False,1.0,0.83087963062,0.419265450409,0.165322582089,0.090313293305,0.041477263396,0.016654491228,True,66,Iowa State,87.92,Midwest,5
+mens,2017-03-12,False,1.0,0.903498884911,0.460614314735,0.188426522511,0.064282634939,0.028869538874,0.013981917848,True,239,Baylor,87.66,East,3
+mens,2017-03-12,False,1.0,0.922453144793,0.612530910515,0.210819509714,0.065982422402,0.029510769901,0.011540625553,True,2483,Oregon,87.3,Midwest,3
+mens,2017-03-12,False,1.0,0.890205906066,0.620125611105,0.231390822307,0.086281939129,0.03298443953,0.011023811185,True,2086,Butler,86.52,South,4
+mens,2017-03-12,False,1.0,0.874918052377,0.443570125101,0.126505910179,0.057340558778,0.023554631132,0.010564921073,True,57,Florida,87.84,East,4
+mens,2017-03-12,False,1.0,0.875459337424,0.619948031905,0.22357992729,0.069806578734,0.024619697152,0.010309221563,True,52,Florida State,87.22,West,3
+mens,2017-03-12,False,1.0,0.627992312948,0.258161872287,0.101708915376,0.053018996819,0.023916960307,0.009401519555,True,2132,Cincinnati,87.35,South,6
+mens,2017-03-12,False,1.0,0.789798040939,0.176214196887,0.091755651982,0.044102419263,0.019314220584,0.009153820938,True,275,Wisconsin,87.84,East,8
+mens,2017-03-12,False,1.0,0.633435389742,0.229701754006,0.136026185555,0.05006435897,0.02132403061,0.007944688185,True,130,Michigan,86.86,Midwest,7
+mens,2017-03-12,False,1.0,0.754708167214,0.276810125446,0.082734021215,0.038876176976,0.014374156817,0.006257399573,True,87,Notre Dame,86.68,West,5
+mens,2017-03-12,False,1.0,0.560859158665,0.219366215263,0.082632247491,0.028122710754,0.010679373557,0.003554227056,True,156,Creighton,84.43,Midwest,6
+mens,2017-03-12,False,1.0,0.366564610258,0.09996370017,0.057101230454,0.020032276899,0.008217015256,0.002949715924,True,197,Oklahoma State,84.71,Midwest,10
+mens,2017-03-12,False,1.0,0.551241404307,0.111588464088,0.040975026465,0.015984554481,0.005821238964,0.001859809763,True,2390,Miami (FL),84.56,Midwest,8
+mens,2017-03-12,False,1.0,0.505738239006,0.101191930091,0.053221267147,0.017318660989,0.005918175836,0.001774559915,True,8,Arkansas,83.19,South,8
+mens,2017-03-12,False,1.0,0.545707184069,0.089275728202,0.032689651797,0.012532032674,0.003773357545,0.00138565857,True,238,Vanderbilt,83.79,West,9
+mens,2017-03-12,False,1.0,0.439140841335,0.153258665386,0.046331760938,0.012863550512,0.00447323601,0.001366309429,True,227,Rhode Island,84.02,Midwest,11
+mens,2017-03-12,True,0.476091175108,0.187298816901,0.063258468563,0.019092152503,0.008213585615,0.003287543793,0.001148989896,True,2306,Kansas State,83.08,South,11a
+mens,2017-03-12,False,1.0,0.567264572844,0.12788435314,0.046432448692,0.010826562453,0.003178218256,0.001064459181,True,2579,South Carolina,83.08,East,7
+mens,2017-03-12,False,1.0,0.494261760994,0.097550713421,0.045016707606,0.012438020197,0.003803672652,0.001025090597,True,2550,Seton Hall,82.95,South,9
+mens,2017-03-12,False,1.0,0.307641690529,0.07009654386,0.028488468994,0.010813929867,0.003539775209,0.001018350194,True,2168,Dayton,82.84,South,7
+mens,2017-03-12,False,1.0,0.432735427156,0.086480328392,0.034046864364,0.008658089906,0.0027747141,0.00100354284,True,269,Marquette,83.01,East,10
+mens,2017-03-12,False,1.0,0.448758595693,0.080259936463,0.027907106531,0.010376899402,0.003360842366,0.000958077274,True,127,Michigan State,82.79,Midwest,9
+mens,2017-03-12,True,0.523908824892,0.18470887015,0.056508128199,0.016560447912,0.00697118243,0.002540491816,0.000810580661,True,154,Wake Forest,82.96,South,11b
+mens,2017-03-12,False,1.0,0.494281725361,0.167199602047,0.0423734949,0.009472802949,0.002451708864,0.000792492824,True,2752,Xavier,82.34,West,11
+mens,2017-03-12,False,1.0,0.262229212342,0.076255128254,0.036011588151,0.0085286792,0.002317090225,0.000780417821,True,2670,Virginia Commonwealth,82.93,West,10
+mens,2017-03-12,False,1.0,0.480437759474,0.164411499669,0.043759257843,0.011922664868,0.003240088977,0.000779884627,True,2393,Middle Tennessee,81.28,South,12
+mens,2017-03-12,False,1.0,0.505718274639,0.172976794701,0.042858486997,0.009379023543,0.002365913402,0.000748237926,True,120,Maryland,82.48,West,6
+mens,2017-03-12,False,1.0,0.454292815931,0.066373981917,0.022163655145,0.007824092234,0.002139142037,0.000724341309,True,77,Northwestern,82.6,West,8
+mens,2017-03-12,False,1.0,0.519562240526,0.184583116675,0.042529634298,0.010122564752,0.002831157322,0.000700461249,True,135,Minnesota,81.23,South,5
+mens,2017-03-12,True,0.582211116433,0.123028397137,0.040913089093,0.012438687038,0.003137787071,0.000915610712,0.000305046777,True,2507,Providence,81.75,East,11a
+mens,2017-03-12,True,0.417788883567,0.087329906556,0.028813693554,0.008298096714,0.001981911693,0.000735993165,0.000302564161,True,30,Southern California,81.18,East,11b
+mens,2017-03-12,False,1.0,0.16912036938,0.038797278455,0.00687363904,0.00198600633,0.000661835825,0.000193962041,True,2440,Nevada,80.73,Midwest,12
+mens,2017-03-12,False,1.0,0.245291832786,0.049146791543,0.007350411388,0.001982721266,0.000409038123,0.000108797491,True,163,Princeton,80.0,West,12
+mens,2017-03-12,False,1.0,0.155233088499,0.042110696367,0.005987617471,0.001578643986,0.0003736028,0.0001033947,True,350,North Carolina-Wilmington,80.19,East,12
+mens,2017-03-12,False,1.0,0.210201959061,0.019472191078,0.005276095318,0.001366767145,0.000321385246,0.000088433903,True,259,Virginia Tech,80.02,East,9
+mens,2017-03-12,False,1.0,0.140303688987,0.03580835808,0.005502939477,0.001404734306,0.000332617909,0.000070069399,True,261,Vermont,79.49,Midwest,13
+mens,2017-03-12,False,1.0,0.098170484964,0.028442092542,0.003276056528,0.000703305804,0.000115270637,0.000025042199,True,2083,Bucknell,77.93,West,13
+mens,2017-03-12,False,1.0,0.125081947623,0.022741487972,0.002467301527,0.000516806894,0.000100943835,0.000023507114,True,2193,East Tennessee State,78.05,East,13
+mens,2017-03-12,False,1.0,0.109794093934,0.03087977255,0.003895310877,0.000522190787,0.000078059028,0.000010602074,True,2737,Winthrop,75.53,South,13
+mens,2017-03-12,False,1.0,0.124540662576,0.039875571347,0.004390241339,0.00044342743,0.000055080776,0.000009323274,True,526,Florida Gulf Coast,75.81,West,14
+mens,2017-03-12,False,1.0,0.096501115089,0.013359236284,0.001667678121,0.000172057783,0.000032634423,0.000007400083,True,166,New Mexico State,75.6,East,14
+mens,2017-03-12,False,1.0,0.077546855207,0.014844208835,0.001650843228,0.000180558859,0.000027325321,0.000003735142,True,314,Iona,75.49,Midwest,14
+mens,2017-03-12,False,1.0,0.058276357424,0.00753264321,0.00063485288,0.000095967627,0.000012897036,0.000001581086,True,2309,Kent State,74.27,South,14
+mens,2017-03-12,False,1.0,0.033096505656,0.005765631309,0.000669860458,0.000049033071,0.000005266558,7.05748E-7,True,2653,Troy,73.28,East,15
+mens,2017-03-12,False,1.0,0.033193621198,0.003763286015,0.000472341308,0.000061523435,0.000006851955,7.00612E-7,True,94,Northern Kentucky,72.83,South,15
+mens,2017-03-12,False,1.0,0.023204369319,0.00414701157,0.000447293487,0.000055355855,0.000005225237,6.87039E-7,True,2571,South Dakota State,72.79,West,16
+mens,2017-03-12,False,1.0,0.047498365035,0.004918122371,0.000812417756,0.000058861889,0.000005111259,6.21795E-7,True,155,North Dakota,72.33,West,15
+mens,2017-03-12,False,1.0,0.020724660504,0.002532643833,0.000345020296,0.000025118358,0.000002344799,2.02034E-7,True,2640,Texas Southern,70.99,South,16
+mens,2017-03-12,False,1.0,0.026181881497,0.002149023352,0.000258836074,0.000016908122,0.000001540458,1.2846E-7,True,55,Jacksonville State,71.17,Midwest,15
+mens,2017-03-12,True,0.629059916282,0.013628353268,0.001809113897,0.000152018074,0.000015225362,0.00000145912,1.27847E-7,True,2428,North Carolina Central,71.04,Midwest,16a
+mens,2017-03-12,True,0.370940083718,0.006759610686,0.000769684133,0.00005459549,0.000004644096,5.191E-7,5.2854E-8,True,302,UC-Davis,69.94,Midwest,16b
+mens,2017-03-12,True,0.555249525225,0.007791272305,0.000756286162,0.000058984082,0.000004636532,3.34888E-7,3.0784E-8,True,116,Mount St. Mary's,69.78,East,16a
+mens,2017-03-12,True,0.444750474775,0.004576725946,0.000336019184,0.000024186507,0.000001758081,1.35056E-7,1.3169E-8,True,2443,New Orleans,69.24,East,16b
diff --git a/README.md b/README.md
@@ -0,0 +1,5 @@
+Bracketology based on the 2016 presidential election.
+
+Schools advance based on whichever county had the higher Hillary Clinton vote percentage.
+
+# Methodology
No results found