Merge branch 'achievements' into testing
diff --git a/.gitignore b/.gitignore
index fb556cf..4b8a3bf 100755
--- a/.gitignore
+++ b/.gitignore
@@ -15,4 +15,5 @@
developer/migrations/*
uploads/migrations/*
secret.py
+static/results/*
diff --git a/exp_portal/email.py b/exp_portal/email.py
index 6f46de6..d8b38c1 100644
--- a/exp_portal/email.py
+++ b/exp_portal/email.py
@@ -3,6 +3,7 @@
from django.core import mail
from django.conf import settings
from tasks import user_authorized
+
from django.contrib.auth.decorators import login_required
@@ -28,4 +29,4 @@
def printme(string):
- print string
\ No newline at end of file
+ print string
diff --git a/exp_portal/products.py b/exp_portal/products.py
index 7ef4286..1985241 100644
--- a/exp_portal/products.py
+++ b/exp_portal/products.py
@@ -1,5 +1,6 @@
from django.shortcuts import render, redirect
from op_tasks.models import Product, Dataset
+from django.contrib.auth.decorators import login_required
from tasks import user_authorized
from django.contrib.auth.decorators import login_required
from xdata.settings import LOGIN_URL
@@ -20,6 +21,7 @@
return render(request, 'product_details.html', {'product': product, 'datasets': datasets})
+
@login_required(login_url=LOGIN_URL)
def edit_product(request, productpk):
if user_authorized(request):
diff --git a/exp_portal/tasks.py b/exp_portal/tasks.py
index 8ed2dd7..2c27577 100644
--- a/exp_portal/tasks.py
+++ b/exp_portal/tasks.py
@@ -24,6 +24,7 @@
return render(request, 'completed.html', {'completed_tasks': completed_tasks})
+
@login_required(login_url=LOGIN_URL)
def view_incomplete(request):
if user_authorized(request):
diff --git a/exp_portal/templates/status.html b/exp_portal/templates/status.html
index 6e33615..4c0da8c 100644
--- a/exp_portal/templates/status.html
+++ b/exp_portal/templates/status.html
@@ -322,12 +322,12 @@
</div>
<div id="metrics" class="expTraySection">
<div id="metricsNav">
- <div id="loadBtn" class="metricsNavBtn active">Load</div>
- <div id="difficultyBtn" class="metricsNavBtn">Difficulty</div>
- <div id="performanceBtn" class="metricsNavBtn">Performance</div>
- <div id="confidenceBtn" class="metricsNavBtn">Confidence</div>
- <div id="activityBtn" class="metricsNavBtn">Activity</div>
- <div id="timeBtn" class="metricsNavBtn">Time</div>
+ <div id="{{ experimentName }}LoadBtn" class="metricsNavBtn active">Load</div>
+ <div id="{{ experimentName }}DifficultyBtn" class="metricsNavBtn">Difficulty</div>
+ <div id="{{ experimentName }}PerformanceBtn" class="metricsNavBtn">Performance</div>
+ <div id="{{ experimentName }}ConfidenceBtn" class="metricsNavBtn">Confidence</div>
+ <!-- <div id="{{ experimentName }}ActivityBtn" class="metricsNavBtn">Activity</div> -->
+ <div id="{{ experimentName }}TimeBtn" class="metricsNavBtn">Time</div>
</div>
<div class="metricsBody">
<div class="metricsDropdowns">
@@ -337,18 +337,10 @@
{% for expObjKey, expObjVal in experimentVal.items %}
{% if 'products' in expObjKey %}
{% for product in expObjVal %}
- <!-- <option value="{{ product.name }}"> -->{{ product.name }}</option>
+ <!-- <option value="{{ product.name }}">{{ product.name }}</option> -->
{% endfor %}
{% endif %}
{% endfor %}
- <option value="APERTURE">APERTURE</option>
- <option value="GeoMap">GeoMap</option>
- <option value="GeoMen">GeoMen</option>
- <option value="Influent">Influent</option>
- <option value="LineUP">LineUP</option>
- <option value="NEON">NEON</option>
- <option value="NEWMAN">NEWMAN</option>
- <option value="TrackCom">TrackCom</option>
</select>
<div class="selectTitle">Task</div>
<select name="tasks" id="tasksSelect">
@@ -362,23 +354,23 @@
{% endfor %}
</select>
</div>
- <div id="load" class="metricsSection active">
- <svg id="loadChart" class="chart"></svg>
+ <div id="{{ experimentName }}Load" class="metricsSection active">
+ <svg id="{{ experimentName }}LoadChart" class="chart"></svg>
</div>
- <div id="difficulty" class="metricsSection">
- <svg id="difficultyChart" class="chart"></svg>
+ <div id="{{ experimentName }}Difficulty" class="metricsSection">
+ <svg id="{{ experimentName }}DifficultyChart" class="chart"></svg>
</div>
- <div id="performance" class="metricsSection">
- <svg id="performanceChart" class="chart"></svg>
+ <div id="{{ experimentName }}Performance" class="metricsSection">
+ <svg id="{{ experimentName }}PerformanceChart" class="chart"></svg>
</div>
- <div id="confidence" class="metricsSection">
- <svg id="confidenceChart" class="chart"></svg>
+ <div id="{{ experimentName }}Confidence" class="metricsSection">
+ <svg id="{{ experimentName }}ConfidenceChart" class="chart"></svg>
</div>
- <div id="activity" class="metricsSection">
- <svg id="activityChart" class="chart"></svg>
- </div>
- <div id="time" class="metricsSection">
- <svg id="timeChart" class="chart"></svg>
+ <!-- <div id="activity" class="metricsSection">
+ <svg id="{{ experimentName }}ActivityChart" class="chart"></svg>
+ </div> -->
+ <div id="{{ experimentName }}Time" class="metricsSection">
+ <svg id="{{ experimentName }}TimeChart" class="chart"></svg>
</div>
</div>
</div>
diff --git a/exp_portal/views.py b/exp_portal/views.py
index b055b6a..681b709 100644
--- a/exp_portal/views.py
+++ b/exp_portal/views.py
@@ -108,7 +108,6 @@
experiment.timed = request.POST.get('exp_timed', False)
experiment.save()
-
return redirect('exp_portal:manage_exps')
diff --git a/op_tasks/views.py b/op_tasks/views.py
index 626991e..f556b33 100755
--- a/op_tasks/views.py
+++ b/op_tasks/views.py
@@ -9,7 +9,11 @@
from django.contrib.auth.models import User
from django.utils import timezone
from elasticsearch import Elasticsearch
+<<<<<<< HEAD
+from Crypto.Cipher import AES
+=======
import achievements
+>>>>>>> achievements
import exp_portal
import datetime
@@ -17,6 +21,14 @@
from op_tasks.models import Product, UserProfile, TaskListItem, Experiment
+import exceptions
+import hashlib
+import logging
+#import zlib
+#import sqlite
+
+from op_tasks.models import Dataset, Product, OpTask, UserProfile, TaskListItem, Experiment
+logger = logging.getLogger('op_tasks')
def set_cookie(response, key, value, days_expire = 7):
if days_expire is None:
@@ -46,6 +58,7 @@
return len(timestamps)
# manages which prodct is delivered to the current user
+@login_required(login_url='/tasking/login')
def product(request, task_pk):
if request.method == 'POST':
user = request.user
@@ -157,8 +170,46 @@
return render(request, 'task_launch.html', {'tasklistitem': tasklistitem})
+# Get unencrypted username
+def decryptUsername(request):
+ user = request.user
+ return aesDecryptor(user.username)
+
+# decrypt the text passed in
+def aesDecryptor(encryptedText):
+ key = readInKey('fileLocation') #'0123456789abcdef0123456789abcdef'
+ IV = 16 * '\x00' # Initialization vector: discussed later
+ mode = AES.MODE_CBC
+ decryptor = AES.new(key, mode, IV=IV)
+ plainText = decryptor.decrypt(ciphertext)
+ return plainText
+
+# encrypt the text passed in
+def aesEncryptor(plainText):
+ key = readInKey('fileLocation') #'0123456789abcdef0123456789abcdef'
+ IV = 16 * '\x00' # Initialization vector: discussed later
+ mode = AES.MODE_CBC
+ encryptor = AES.new(key, mode, IV=IV)
+ if len(plainText) % 16 != 0:
+ plainText += ' ' * (16 - len(plainText) % 16)
+ cipherText = encryptor.encrypt(plainText)
+ return cipherText;
+
+def readInKey(fileLocation):
+ # Open file and read in key (TODO)
+ # For now, create a 32-bit key from a phrase
+ key = createKeyFromPhrase("WouldYouLike12Muffins?")
+ return key
+
+# Will not need this function when key is read in from file while running operationally
+def createKeyFromPhrase(phrase):
+ key = hashlib.sha256(phrase).digest()
+ return key
+
# cretaes a new user and assigns tasks
def register(request):
+ logging.basicConfig(filename='/home/ubuntu/logs/log.txt', level=logging.DEBUG, format='%(asctime)s - %(levelname)s - %(message)s')
+ logger.debug("Logging is working.")
# Like before, get the request's context.
context = RequestContext(request)
@@ -173,6 +224,10 @@
# Once hashed, we can update the user object.
user = User(username=request.POST['username'])
user.set_password(request.POST['password'])
+ logger.debug("This is the username: ", user.username, " and password, before encryption: ", user.password)
+ user.username = aesEncryptor(user.username).decode('utf-16')
+ #user.username = sqlite3.Binary(zlib.compress(aesEncryptor(user.username)))
+ logger.debug("This is the username: ", user.username, " and password, after encryption: ", user.password)
user.email = user.username
user.save()
@@ -188,6 +243,7 @@
# Now we save the UserProfile model instance.
userprofile.save()
+ logger.debug("Saved the user profile successfully")
# Finally we assign tasks to the new user
# Get a random product, get a random order of tasks
@@ -244,6 +300,8 @@
# Gather the username and password provided by the user.
# This information is obtained from the login form.
username = request.POST['username']
+ #username = sqlite3.Binary(zlib.compress(aesEncryptor(username)))
+ username = aesEncryptor(username).decode('utf-16')
password = request.POST['password']
# print "Login attempt by " + username + " at " + datetime
@@ -358,4 +416,4 @@
def view_profile(request):
- return render(request, 'user_profile.html', {'user': request.user})
\ No newline at end of file
+ return render(request, 'user_profile.html', {'user': request.user})
diff --git a/static/css/styles.css b/static/css/styles.css
index ce93aee..d68eb76 100644
--- a/static/css/styles.css
+++ b/static/css/styles.css
@@ -408,6 +408,7 @@
.trayTableHeader {
background: #333;
color: #fff;
+ height: 40px;
padding: 10px 2%;
}
@@ -416,14 +417,21 @@
}
.trayTableBody {
- padding: 18px 2%;
+ margin: 0;
+ padding: 0;
+ max-height: 410px;
+ overflow: auto;
}
.trayTableBody li {
- margin-bottom: 20px;
+ padding: 12px 2%;
width: 100%;
}
+ .trayTableBody li:nth-child(even) {
+ background: #555;
+ }
+
.trayTableBody>li>div {
float: left;
}
diff --git a/static/javascript/base.js b/static/javascript/base.js
index c5b4abd..cd91d3f 100644
--- a/static/javascript/base.js
+++ b/static/javascript/base.js
@@ -49,13 +49,15 @@
$(".metricsNavBtn").click(function(){
$(this).parent().find(".metricsNavBtn").removeClass("active");
$(this).addClass("active");
- $(".metricsSection").removeClass("active");
+ var rowId = $(this).parents(".experimentStatusRow").attr("id");
+ $("#" + rowId + " .metricsSection").removeClass("active");
var id = $(this).attr("id");
id = id.slice(0, -3);
$("#" + id).addClass("active");
})
$(".expShelf").click(function(){
+ if ($(this).parents(".experimentStatusRow").is(":animated")) return false;
var $thisTray = $(this).parents(".experimentStatusRow").find(".expTray");
if ($(this).hasClass("active")) {
$thisTray.fadeOut(300);
@@ -75,16 +77,37 @@
$("#toolsSelect, #tasksSelect").change(function(){
start = false;
var id = $(this).parents(".experimentStatusRow").attr("id");
+ $(".chart").empty();
loopCharts(start, id);
-})
+});
function loopCharts(start, id) {
if (start==true) {
- chartsToLoad = ".chart";
- } else {
- chartsToLoad = "#" + id + " .chart";
+ startChartBuildwithToolLists();
+ } else if (start==false) {
+ buildCharts();
}
- $(chartsToLoad).each(function(){
+}
+
+function startChartBuildwithToolLists() {
+ $(".experimentStatusRow").each(function(){
+ var expName = $(this).find(".expName").html();
+ $.ajax({
+ url: "../static/results/" + expName + "/tools.json",
+ dataType: "json"
+ }).done(function(data){
+ var tools = data.Tools;
+ for (i in tools) {
+ var html = '<option value="' + tools[i] + '">' + tools[i] + '</option>';
+ $("#" + expName + " #toolsSelect").append(html);
+ }
+ buildCharts();
+ })
+ })
+}
+
+function buildCharts(){
+ $(".chart").each(function(){
var chartId = $(this).attr("id");
var range;
var metric;
@@ -96,6 +119,8 @@
}
})
+ var expName = $(this).parents(".experimentStatusRow").attr("id");
+
var tool = $(this).parents(".metricsBody").find("#toolsSelect").val();
if (tool == "All") {
@@ -112,37 +137,36 @@
task = "OT2"
};
- console.log("metric = " + metric);
- console.log("tool = " + tool);
- console.log("task = " + task);
+ var dataPath = "";
+ // paths are based on location of d3.js file...
switch (chartId) {
- case "loadChart":
- dataPath = "load" + task + ".csv"
+ case expName + "LoadChart":
+ dataPath = "../../results/" + expName + "/load" + task + ".csv";
break;
- case "difficultyChart":
- dataPath = "difficulty" + task + ".csv"
+ case expName + "DifficultyChart":
+ dataPath = "../../results/" + expName + "/difficulty" + task + ".csv";
break;
- case "performanceChart":
- dataPath = "performance" + task + ".csv"
+ case expName + "PerformanceChart":
+ dataPath = "../../results/" + expName + "/performance" + task + ".csv";
break;
- case "confidenceChart":
- dataPath = "confidence" + task + ".csv"
+ case expName + "ConfidenceChart":
+ dataPath = "../../results/" + expName + "/confidence" + task + ".csv";
break;
- case "activityChart":
- dataPath = "activity" + task + ".csv"
- break;
- case "timeChart":
- dataPath = "time" + task + ".csv"
+ // case expName + "ActivityChart":
+ // dataPath = "../../results/" + expName + "/activity" + task + ".csv";
+ // break;
+ case expName + "TimeChart":
+ dataPath = "../../results/" + expName + "/time" + task + ".csv";
break;
}
- $(this).empty();
- buildChart(dataPath, chartId, tool)
+ // $(this).empty();
+ buildD3Chart(dataPath, chartId, tool)
})
-}
+};
-function buildChart(dataPath, chartId, tool) {
- var margin = {top: 20, right: 30, bottom: 30, left: 40},
+function buildD3Chart(dataPath, chartId, tool) {
+ var margin = {top: 20, right: 30, bottom: 40, left: 50},
width = 535 - margin.left - margin.right,
height = 350 - margin.top - margin.bottom;
@@ -181,17 +205,23 @@
chart.append("g")
.attr("class", "x axis")
.attr("transform", "translate(0," + height + ")")
- .call(xAxis);
+ .call(xAxis)
+ .append("text")
+ .attr("y", 25)
+ .attr("x", 230)
+ .attr("dy", "1em")
+ .style("text-anchor", "end")
+ .text("Value");
chart.append("g")
.attr("class", "y axis")
.call(yAxis)
.append("text")
.attr("transform", "rotate(-90)")
- .attr("y", 6)
- .attr("dy", ".71em")
+ .attr("y", -50)
+ .attr("dy", "1em")
.style("text-anchor", "end")
- .text("Frequency");
+ .text("Count");
chart.selectAll(".bar")
.data(data)
diff --git a/static/javascript/data/MASTER_LEVEL 2_Year_2_For R DEV_RAW__forkyle2.csv b/static/javascript/data/MASTER_LEVEL 2_Year_2_For R DEV_RAW__forkyle2.csv
deleted file mode 100644
index f759646..0000000
--- a/static/javascript/data/MASTER_LEVEL 2_Year_2_For R DEV_RAW__forkyle2.csv
+++ /dev/null
@@ -1,34 +0,0 @@
-SYS.IND.SID.,SYS.FIL.ANA.,SYS.FIL.APP.,SYS.FIL.DAT.,SYS.FIL.ORD.,INT.FIL.STD.,INT.FIL.END.,IND.PID.EML.,INT.FIL.CON.,INT.DEM.AGE.,INT.DEM.GEN.,INT.DEM.ETN.,INT.DEM.ETH.FRE.,INT.EDU.DEG.,INT.APT.SAT.MAT.,INT.APT.SAT.VER.,INT.APT.GRE.MAT.,INT.APT.GRE.VER.,INT.EDU.CON.MED.,INT.EDU.CON.BIO.,INT.EDU.CON.PHY.,INT.EDU.CON.BEH.,INT.EDU.CON.CpS.,INT.EDU.CON.MAT.,INT.EDU.CON.HUM.,INT.EDU.CON.LIN.,INT.EDU.CON.ART.,INT.EDU.CON.MEn.,INT.EDU.CON.EEn.,INT.EDU.CON.CVE.,INT.EDU.CON.Cen.,INT.EDU.CON.Sen.,INT.EDU.CON.BUS.,INT.EDU.PRI.CON.FRE.,INT.EDU.SEC.CON.FRE.,INT.EDU.TER.CON.FRE.,INT.EMP.POS.DSc.,INT.EMP.POS.InT.,INT.EMP.POS.MOD.,INT.EMP.POS.ANA.,INT.EMP.POS.Sci.,INT.EMP.POS.FOR.,INT.EMP.POS.STS.,INT.EMP.POS.NA.,INT.EMP.POS.BST.,INT.EMP.POS.DoD.,INT.EMP.POS.DoJ.,INT.EMP.POS.ODNI.,INT.EMP.POS.DoI.,INT.EMP.POS.DHHS.,INT.EMP.POS.DEC.,INT.EDU.INT.ANA.,INT.EMP.INTS.HUMINT.,INT.EMP.INTS.SIGINT.,INT.EMP.INTS.IMINT.,INT.EMP.INTS.GEOINT.,INT.EMP.INTS.MASINT.,INT.EMP.INTS.OSINT.,INT.EDU.IND.ANA.,INT.EMP.IND.ANA,INT.EMP.IND.ANA.FRE.,INT.EMP.JOB.YRS.,INT.EMP.JOB.TTL.,INT.EMP.CURR.JOB.,INT.EMP.CURR.TITLE.,INT.EMP.CURR.IND.,INT.APT.SNS.001.,INT.APT.SNS.002.,INT.APT.SNS.003.,INT.APT.SNS.004.,INT.APT.SNS.005.,INT.APT.CRT.001.,INT.APT.CRT.002.,INT.APT.CRT.003.,INT.APT.GRE.ANL.001.,INT.APT.GRE.ANL.002.,INT.APT.GRE.ANL.003.,INT.APT.GRE.ANL.004.,INT.APT.GRE.ANL.005.,INT.APT.GRE.ANL.006.,INT.PSY.PSI.IMP.001.,INT.PSY.PSI.IMP.002.,INT.PSY.PSI.AVD.003.,INT.PSY.PSI.CON.004.,INT.PSY.PSI.MON.005.,INT.PSY.PSI.PLN.006.,INT.PSY.PSI.AVD.007.,INT.PSY.PSI.RFL.008.,INT.PSY.PSI.CON.009.,INT.PSY.PSI.RFL.010.,INT.PSY.PSI.IMP.011.,INT.PSY.PSI.RFL.012.,INT.PSY.PSI.MON.013.,INT.PSY.PSI.PLN.014.,INT.PSY.PSI.AVD.015.,INT.PSY.PSI.RFL.016.,INT.PSY.PSI.CON.017.,INT.PSY.PSI.IMP.018.,INT.PSY.PSI.RFL.019.,INT.PSY.PSI.AVD.020.,INT.PSY.PSI.PLN.021.,INT.PSY.PSI.MON.022.,INT.PSY.PSI.IMP.023.,INT.PSY.PSI.IMP.024.,INT.PSY.PSI.PLN.025.,INT.PSY.PSI.IMP.026.,INT.PSY.PSI.CON.027.,INT.PSY.PSI.IMP.028.,INT.PSY.PSI.CON.029.,INT.PSY.PSI.IMP.030.,INT.PSY.REI.RAS.001.,INT.PSY.REI.RAS.008.,INT.PSY.NFC.007.,INT.PSY.REI.EXS.002.,INT.PSY.REI.NFC.017.,INT.PSY.REI.RAS.003.,INT.PSY.REI.RAS.004.,INT.PSY.NFC.018.,INT.PSY.REI.RAS.010.,INT.PSY.REI.RAS.002.,INT.PSY.NFC.010,INT.PSY.REI.EXS.003.,INT.PSY.NFC.003.,INT.PSY.NFC.011.,INT.PSY.NFC.005.,INT.PSY.REI.EXS.001. ,INT.PSY.NFC.008.,INT.PSY.REI.RAS.006.,INT.PSY.NFC.016.,INT.PSY.REI.EXS.008.,INT.PSY.NFC.015.,INT.PSY.NFC.001.,INT.PSY.REI.EXS.004.,INT.PSY.NFC.013.,INT.PSY.REI.EXS.010.,INT.PSY.REI.EXS.007.,INT.PSY.NFC.006.,INT.PSY.NFC.014.,INT.PSY.REI.EXS.006.,INT.PSY.NFC.004.,INT.PSY.REI.RAS.005.,INT.PSY.REI.RAS.009.,INT.PSY.REI.EXS.005.,INT.PSY.NFC.EXS.012.,INT.PSY.NFC.EXS.002.,INT.PSY.REI.RAS.007.,INT.PSY.REI.EXS.009.,INT.PSY.NFC.009.,INT.PSY.MAX.001.,INT.PSY.MAX.002.,INT.PSY.MAX.003.,INT.PSY.MAX.004.,INT.PSY.MAX.005.,INT.PSY.MAX.006.,INT.PSY.MAX.007.,INT.PSY.NCL.001.,INT.PSY.NCL.002.,INT.PSY.NCL.003.,INT.PSY.NCL.004.,INT.PSY.NCL.005.,INT.PSY.NCL.006.,INT.PSY.NCL.007.,INT.PSY.NCL.008.,INT.PSY.NCL.009.,INT.PSY.NCL.010.,INT.PSY.NCL.011.,INT.PSY.NCL.012.,INT.PSY.NCL.013.,INT.PSY.NCL.014.,INT.PSY.NCL.015.,INT.FIL.SOL.,TSK.FIL.OT1.001.STD.,TSK.FIL.OT1.001.END.,TSK.PRB.OT1.001.,TSK.CON.OT1.001.,TSK.FIL.OT1.002.STD.,TSK.FIL.OT1.002.END.,TSK.PRB.OT1.002.,TSK.CON.OT1.002.,TSK.FIL.OT1.003.STD.,TSK.FIL.OT1.003.END.,TSK.PRB.OT1.003.,TSK.CON.OT1.003.,TSK.FIL.OT1.004.STD.,TSK.FIL.OT1.004.END.,TSK.PRB.OT1.004.,TSK.CON.OT1.004.,TSK.FIL.OT1.005.STD.,TSK.FIL.OT1.005.END.,TSK.PRB.OT1.005.,TSK.CON.OT1.005.,PST.FIL.OT1.STD.,PST.FIL.OT1.END.,PST.EXP.CLD.CP1.OT1.001.EFF.,PST.EXP.CLD.CP1.OT1.001.EAS.,PST.EXP.CLD.CP1.OT1.001.INT.,PST.EXP.CLD.CP1.OT1.001.FRU.,PST.EXP.CLD.CP1.OT1.001.MEF.,PST.EXP.CLD.CP1.OT1.002.EFF.,PST.EXP.CLD.CP1.OT1.002.EAS.,PST.EXP.CLD.CP1.OT1.002.INT.,PST.EXP.CLD.CP1.OT1.002.FRU.,PST.EXP.CLD.CP1.OT1.002.MEF.,PST.EXP.CLD.CP1.OT1.003.EFF.,PST.EXP.CLD.CP1.OT1.003.EAS.,PST.EXP.CLD.CP1.OT1.003.INT.,PST.EXP.CLD.CP1.OT1.003.FRU.,PST.EXP.CLD.CP1.OT1.003.MEF.,PST.EXP.CLD.CP1.OT1.004.EFF.,PST.EXP.CLD.CP1.OT1.004.EAS.,PST.EXP.CLD.CP1.OT1.004.INT.,PST.EXP.CLD.CP1.OT1.004.FRU.,PST.EXP.CLD.CP1.OT1.004.MEF.,PST.EXP.CLD.CP1.OT1.005.EFF.,PST.EXP.CLD.CP1.OT1.005.EAS.,PST.EXP.CLD.CP1.OT1.005.INT.,PST.EXP.CLD.CP1.OT1.005.FRU.,PST.EXP.CLD.CP1.OT1.005.MEF.,PST.EXP.BED.CP1.OT1.DIFF.,PST.EXP.BED.CP1.OT1.MEF.,PST.EXP.BED.CP1.OT1.SKL.,PST.EXP.OT1.ENJ.,PST.EXP.OT1.ENG.001.,PST.EXP.OT1.ENG.002.,PST.EXP.OT1.ENG.006.,PST.EXP.OT1.ENG.008.,PST.EXP.OT1.ENG.009.,PST.EXP.OT1.ENG.010.,PST.EXP.OT1.ENG.011.,PST.EXP.OT1.ENG.013.,TSK.FIL.OT2.001.STD.,TSK.FIL.OT2.001.END.,TSK.PRB.OT2.005.,TSK.CON.OT2.005.,TSK.FIL.OT2.005.STD.,TSK.FIL.OT2.005.END.,TSK.PRB.OT2.001.,TSK.CON.OT2.001.,TSK.FIL.OT2.001.STD.,TSK.FIL.OT2.001.END.,TSK.PRB.OT2.004.,TSK.CON.OT2.004.,TSK.FIL.OT2.004.STD.,TSK.FIL.OT2.004.END.,TSK.PRB.OT2.002.,TSK.CON.OT2.002.,TSK.FIL.OT2.002.STD.,TSK.FIL.OT2.002.END.,TSK.PRB.OT2.003.,TSK.CON.OT2.003.,PST.FIL.OT2.STD.003.,PST.FIL.OT2.END.003.,PST.EXP.CLD.CP1.OT2.005.EFF.,PST.EXP.CLD.CP1.OT2.005.EAS.,PST.EXP.CLD.CP1.OT2.005.INT.,PST.EXP.CLD.CP1.OT2.005.FRU.,PST.EXP.CLD.CP1.OT2.005.MEF.,PST.EXP.CLD.CP1.OT2.001.EFF.,PST.EXP.CLD.CP1.OT2.001.EAS.,PST.EXP.CLD.CP1.OT2.001.INT.,PST.EXP.CLD.CP1.OT2.001.FRU.,PST.EXP.CLD.CP1.OT2.001.MEF.,PST.EXP.CLD.CP1.OT2.004.EFF.,PST.EXP.CLD.CP1.OT2.004.EAS.,PST.EXP.CLD.CP1.OT2.004.INT.,PST.EXP.CLD.CP1.OT2.004.FRU.,PST.EXP.CLD.CP1.OT2.004.MEF.,PST.EXP.CLD.CP1.OT2.002.EFF.,PST.EXP.CLD.CP1.OT2.002.EAS.,PST.EXP.CLD.CP1.OT2.002.INT.,PST.EXP.CLD.CP1.OT2.002.FRU.,PST.EXP.CLD.CP1.OT2.002.MEF.,PST.EXP.CLD.CP1.OT2.003.EFF.,PST.EXP.CLD.CP1.OT2.003.EAS.,PST.EXP.CLD.CP1.OT2.003.INT.,PST.EXP.CLD.CP1.OT2.003.FRU.,PST.EXP.CLD.CP1.OT2.003.MEF.,PST.EXP.BED.CP1.OT2.DIFF.,PST.EXP.BED.CP1.OT2.MEF.,PST.EXP.BED.CP1.OT2.SKL.,PST.EXP.OT2.ENJ.,PST.EXP.OT2.ENG.001.,PST.EXP.OT2.ENG.002.,PST.EXP.OT2.ENG.006.,PST.EXP.OT2.ENG.008.,PST.EXP.OT2.ENG.009.,PST.EXP.OT2.ENG.010.,PST.EXP.OT2.ENG.011.,PST.EXP.OT2.ENG.013.,INT.APT.CRT.001.ANS.,INT.APT.CRT.002.ANS.,INT.APT.CRT.003.ANS.,INT.APT.GRE.ANL.001.ANS.,INT.APT.GRE.ANL.002.ANS.,INT.APT.GRE.ANL.003.ANS.,INT.APT.GRE.ANL.004.ANS.,INT.APT.GRE.ANL.005.ANS.,INT.APT.GRE.ANL.006.ANS.,PST.EXP.CLD.CP1.OT1.001.,PST.EXP.CLD.CP1.OT1.002.,PST.EXP.CLD.CP1.OT1.003.,PST.EXP.CLD.CP1.OT1.004.,PST.EXP.CLD.CP1.OT1.005.,PST.EXP.CLD.CP1.OT2.001.,PST.EXP.CLD.CP1.OT2.002.,PST.EXP.CLD.CP1.OT2.003.,PST.EXP.CLD.CP1.OT2.004.,PST.EXP.CLD.CP1.OT2.005.,PST.EXP.CLD.CP1.OT1.,PST.EXP.CLD.CP1.OT2.,PST.EXP.CLD.,PST.EXP.BED.CP1.OT1.,PST.EXP.BED.CP1.OT2.,PST.EXP.BED.
-2001,1,GeoMap,TWITTERSA,2,6/17/2014 20:33,6/17/2014 21:16, ,1,51,2,4, ,9,700,600, , , , , , ,1, , , , , , , , , , ,Information and Computer Science, , , ,1,1, , , , , ,2,1, , , , , ,2, , , , , , ,2, , ,25,"CTO, Intelligence SME, Cloud Standards Engineer, Software Developer",R2AD,CTO,"Defense Contracting, Computer Science",4,4,4,3,4,10,1,24,2,5,3,5,1,4,1,1,2,7,5,5,3,6,7,5,3,4,2,4,1,6,3,1,6,3,6,1,2,1,6,3,6,2,2,3,1,6,4,2,2,1,7,3,6,1,3,5,2,7,4,2,1,1,1,1,6,6,6,4,5,5,3,1,5,1,1,1,2,2,6,1,5,6,5,2,6,4,5,2,5,5,2,2,6,1,5,2,5,1,2,2,4,3,2,3,1,10:58:43,11:01:30, ,90,11:01:30,11:05:24, ,80,11:05:25,11:08:42, ,60,11:08:42,11:14:01, ,70,11:14:02,11:17:57, ,70, , ,2,2,2,1,2,3,3,2,3,3,3,3,2,2,4,3,2,3,3,3,2,3,4, ,3,3,3,4,4,2,3,2,4,3,2,4,4,10:20:22,10:32:38, ,60,10:32:39,10:42:43, ,60,10:42:45,10:45:42, ,90, , , , , , , , , , ,4,4,5,3,4,3,2,4,3,3,4,4,4,1,3, , , , , , , , , , ,4,6,5,4,4,3,4,4,4,3,4,4,0,0,0,1,1,1,1,1,1,1.8,2.8,2.8,2.8,3,3,NA,NA,3.2,4,2.64,3.4,2.944,3.333333333,5,4.166666667
-2002,1,GeoMap,TWITTERSA,1,6/23/2014 17:41,6/23/2014 18:38, ,1, ,2,4, ,12, , , , , , , ,3,1,2,3, , , , , , ,3, ,Computer Science,Industrial Engineering, ,1,1,1,1,1,1, , ,2,1, , , , , ,2, , , , , , ,2, , ,20,Chief Scientist,Advisor,Science Advisor,Gov,3,4,5,3,4,5,5,47,2,4,3,5,1,3,4,2,5,5,5,3,5, ,4,6,5,4,2,5,2,5,4,3,5,2,4,3,3,5,4,3,5,5,3,4,2,6,1,3,3,2,7,7,6,1,2,5,3,7,6,2,1,2,2,2,6,7,6,4,3,5,3,2,5,2,1,1,2,2,6,1,5,4,4,7,4,4,6,5,3,4,2,1,2,2,5,5,2,2,1,4,2,3,5,3,1,13:16:56,13:22:28, ,70,13:22:28,13:29:05,1,70,13:29:06,13:32:09, ,90,13:32:09,13:38:36, ,50,13:38:37,13:44:36, ,90, , ,5,4,3,3,4,4,2,3,4,4,3,3,3,4,4,5,5,3,4,4,3,3,3,2,4,5,2, ,2,1,1,1,2,2,2,2,4,14:00:05,14:10:29, ,70,14:10:30,14:15:59, ,60,14:15:59,14:20:51, ,60,14:20:51,14:26:30, ,30,14:26:30,14:29:21, ,50, , ,4,4,4,2,2,2,2,3,4,4,2,2,3,4,4,1,1,3,4,4,1,1,3,4,4,7,5,5,2,2,1,1,1,2,2,2,4,1,1,1,1,0,1,1,1,0,3.8,3.4,3.4,4.2,3,3,2.6,2.6,3,3.2,3.56,2.88,3.22,3.5,5.666666667,4.583333333
-2003,1,TrackCom,AIS,2,6/17/2014 12:11,6/17/2014 13:05, ,1,39,2,4, ,11,600,660, , , , , , , , ,2,1, , , , , , ,3,Law,English Literature, ,1, ,1,1, ,1, , ,4,1, , , , , ,1,1,1,1,1, ,1,1,7,Legal Analyst,4,Intelligence Officer,Department of Defense,Intelligence Officer,Defense Intelligence,4,4,5,5,5,10,500,24,2,4,3,3,4,5,4,3,2,6,5,5,3,6,6,6,2,6,5,5,3,7,6,3,7,3,5,4,2,1,6,3,6,3,2,2,1,2,3,1,1,2,6,5,6,2,2,4,2,6,6,3,1,2,2,1,6,5,6,4,4,4,2,2,4,2,2,1,4,1,4,2,3,6,7,4,7,6,5,7,6,4,4,6,4,3,2,4,3,2,5,4,5,5,2,2,1,9:22:09,9:32:32,1,90, , , , , , , , , , , , , , , , , , ,1,2,1,1,3, , , , , , , , , , , , , , , , , , , , ,5,6,5,4,4,2,3,3,4,2,3,4,8:57:19,9:08:41, ,80,9:08:41,9:13:28,1,80, , , , , , , , , , , , , , ,4,3,5,2,3,5,3,5,1,3, , , , , , , , , , , , , , , ,6,6,5,5,4,2,3,3,4,3,3,5,0,0,0,1,0,1,0,0,0,1.6,NA,NA,NA,NA,3.4,NA,NA,NA,3.4,1.6,3.4,2.68,5.333333333,5.666666667,5.5
-2004,0,Influent,KIVA,1,6/17/2014 4:01,6/17/2014 4:36, ,1,35,2,4, ,10,720,720,720,720, , ,1,1,2, , , , , , , , , , ,Geography,Psychology,Human Computer Interaction,1,1,1,1,1,1,1, ,4,1, ,1, , , ,1,1,1,1,1, ,1,2, , ,12,Senior Intel Officer,DIA,Senior Intelligence Officer,Defense,4,4,5,5,5,5,5,47,2,5,4,5,5,1,5,5,1,7,6,7,5,4,7,5,5,6,3,4,3,5,4,5,7,5,6,3,4,3,5,2,5,3,1,5,2,5,1,2,3,2,7,5,7,2,2,6,2,7,3,3,1,2,2,1,7,5,4,6,6,6,2,2,7,1,3,1,5,2,6,5,5,6,7,1,7,4,1,2,5,3,5,3,3,3,3,2,5,3,2,5,3,2,4,3,1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,1,4,3,1,1,1,3,1,1,5,1,1,11:01:48,11:09:19, ,60,11:09:19,11:20:04, ,60,11:20:04,11:30:32, ,60, , , , , , , , , , ,1,1,1,5,5,1,1,1,5,5,1,1,2,5,5, , , , , , , , , , ,2,2,3,1, , , , , , , , ,1,1,1,1,1,0,1,0,0,NA,NA,NA,NA,NA,2.6,NA,NA,2.8,2.6,NA,2.666666667,2.666666667,2.666666667,2.333333333,2.5
-2005,1,Influent,KIVA,2,6/18/2014 13:58,6/18/2014 14:55, ,1,32,1,4, ,9, , , , , , , ,2,1, , , , , , , , , ,3,"Information, Sciences and Technology",Cognitive Psychology,Business/Management,1,1,1,1,1,1,1, ,2,1, , , , , ,2, , , , , , ,2, , ,11,Information Technology Specialist/IT Program Manager,Defense Intelligence Agency (DIA),IT Program Manager,Government: IT/Analysis,4,4,4,4,4,5,5,47,2,5,3,5,1,4,3,2,2,5,6,5,2,5,6,5,4,5,4,6,5,6,4,3,7,3,5,7,3,5,6,3,6,4,3,3,1,6,2,1,1,2,6,7,6,2,2,7,2,6,6,1,2,2,2,1,7,6,7,5,7,7,1,2,6,1,2,2,6,2,6,2,6,5,6,4,7,6,3,6,7,2,2,1,5,3,3,5,3,3,3,5,3,3,5,2,1,10:13:51,10:23:36, ,20,10:23:38,10:33:01,1,0,10:33:01,10:42:09, ,0, , , , , , , , , , ,3,3,2,3,3,5,5,2,4,4,5,5,2,4,4, , , , , , , , , , ,2,2,5,4,2,2,2,2,4,4,2,4,9:23:47,9:33:24, ,80,9:33:25,9:46:07, ,0, , , , , , , , , , , , , , ,5,4,4,2,2,2,2,4,4,4, , , , , , , , , , , , , , , ,2,2,5,4,2,2,2,2,4,2,2,5,1,1,1,1,1,1,1,1,1,2.8,4,4,NA,NA,3.2,NA,NA,NA,3.4,3.6,3.3,3.471428571,3,3,3
-2006,1,GeoMen,TWITTERSA,1,6/17/2014 13:35,6/17/2014 14:35, ,1,60,2,4, ,9, , , , , , , , , , ,2, , , , , , , ,1,public administration,criminal justice,political science, ,1, ,1, , , , ,4,1,1, , , , ,2, , , , , , ,2, , ,4,investigative analyst,Special Inspector General for Afghanistan Reconstruction,Investigative Analyst,US Government,3,3,4,3,4,5,20,47,2,4,3,5,5,4,2,4,5,6,5,5,4,6,7,5,5,5,2,6,1,6,5,6,7,6,5,4,3,2,3,1,6,5,2,2,2,5,2,6,1,2,6,6,5,2,3,2,2,2,5,2,1,3,1,2,6,5,4,2,3,5,2,2,1,2,3,2,2,1,2,2,6,6,6,1,5,2,6,3,6,3,2,2,1,1,1,5,5,3,3,6,1,3,2,2,1,9:45:08,9:55:44,1,80,9:55:44,10:03:27, ,100, , , , , , , , , , , , , , ,3,1,3,1,1,4,4,2,3,4, , , , , , , , , , , , , , , , , , , , , , , , , , , ,10:27:53,10:54:16, ,60,10:54:16,10:56:36, ,100, , , , , , , , , , , , , , ,4,4,3,1,2,3, ,4,4,3, , , , , , , , , , , , , , , , , , , , , , , , , , , ,1,0,1,1,0,1,1,0,1,1.8,3.4,NA,NA,NA,3.5,NA,NA,NA,2.8,2.6,3.15,2.875,NA,NA,NA
-2007,1,APERTURE,TWITTERSA,2,6/18/2014 17:08,6/18/2014 20:26, ,1,37,2,4,latin american,7, , , , ,1, , , , , , , , , , , , , , , , , , , , ,1, , , , ,4,1,1, , , , ,1, ,1, , , ,1,2, , ,11,Intel Research Specialist,Intelligence research,Sergeant First Class,DOJ/DOD,2,2,2,2,2,10,100,47,2,5,1,5,1,3,4,6,2,6,5,6,1,6,6,6,2,6,6,6,3,6,6,5,5,1,6,6,3,2,5,5,6,2,2,2,2,4,4,1,1,3,6,5,5,2,2,6,2,7,5,1,2,2,4,1,3,6,7,4,6,6,2,1,6,2,1,1,6,1,6,2,6,4,3,5,5,5,6,6,6,3,3,4,5,1,2,5,3,2,4,2,5,5,4,3,1,8:58:53,9:16:56, ,90, , , , , , , , , , , , , , , , , , ,2,3,2,2,4, , , , , , , , , , , , , , , , , , , , ,6,4,5,4,3,4,2,4,4,3,2,5,9:11:56,9:28:55,1,90, , , , , , , , , , , , , , , , , , ,5,3,4,2,3, , , , , , , , , , , , , , , , , , , , ,4,7,5,4,4,3,2,3,4,2,4,4,0,0,1,1,1,0,1,1,0,2.6,NA,NA,NA,NA,NA,NA,NA,NA,3.4,2.6,3.4,3,5,5.333333333,5.166666667
-2008,1,NEON,TWITTERSA,2,6/18/2014 17:09,6/18/2014 18:53, ,1,35,2,4, ,7, , , , , , , , , , , , , , , , , , , , , , , ,1, ,1, , , , ,4,1,1, , , , ,1, ,1, , , ,1,2, , ,16,Intelligence Analyst,DEA,Intelligence Analyst,Defence,3,3,5,4,4,10,100,47,2,4,4,5,1,3,5,5,2,6,4,5,3,6,6,5,5,5,3,5,4,6,3,5,5,3,4,4,4,3,5,4,5,4,2,3,2,3,3,3,3,3,4,3,5,4,3,4,4,5,2,3,3,3,3,3,4,5,5,3,4,5,3,4,3,3,2,3,5,2,5,3,5,5,6,6,6,5,5,5,5,4,5,3,4,2,3,4,5,3,3,3,3,3,2,3, ,9:49:54,9:56:34, ,90,9:56:34,10:03:32, , ,10:03:33,10:03:47, , ,10:03:48,10:05:54, ,90,10:05:54,10:12:51, ,100, , ,1,1,2,1,3, , , , , , , , , , ,1,1,2,3,3,2,1,2,3,3,7,6,4,3,4,3,2,4,5,2,4,4,9:04:10,9:27:08,1,100,9:27:09,9:30:52,1,80, , , , , , , , , , , , , , ,4,3,4,3,2,4,4,3,3,3, , , , , , , , , , , , , , , ,7,6,4,3,4,3,2,3,5,2,2,4,0,0,1,1,0,0,1,1,0,1.6,NA,NA,2,2.2,3.4,NA,NA,NA,3.2,1.933333333,3.3,2.519047619,5.666666667,5.666666667,5.666666667
-2009,1,GeoMen,TWITTERSA,1,6/18/2014 16:49,6/18/2014 18:57, ,1,53,1,4, ,10, , , , , , , , , , , , , , , , , , ,1,Accounting, , , , , ,1, , , , ,4, ,1, , , , ,1,1, , , , ,1,2, , ,19,Intelligence Research Specialist,Law Enforcement,Intelligence Research Specialist,US Government,4,4,5,4,5,5,5,47,2,4,3,5,1,4,2,4,2,6,4,6,2,6,6,6,4,6,4,6,2,6,6,4,6,4,4,2,4,2,6,2,6,5,2,2,2,4,4,4,2,2,7,4,7,2,2,6,2,6,6,3,2,2,2,3,6,4,6,6,4,6,2,2,5,2,2,2,4,2,4,2,5,4,4,4,6,4,5,2,6,4,4,5,4,4,2,4,2,2,5,5,5,4,3,4,1,13:37:23,13:43:10,1,90,13:43:10,13:48:51, ,80,13:48:51,13:56:11,1,90, , , , , , , , , , ,2,2,2,3,3,2,2,2,3,3,2,3,2,3,3, , , , , , , , , , ,5,7,7,4,4,3,3,4,3,3,2,4,14:18:23,14:36:36, ,70,14:36:36,14:42:50, ,70,14:42:50,14:48:21, ,80, , , , , , , , , , ,4,4,5,2,3,4,4,5,2,3,4,4,5,2,3, , , , , , , , , , , , , , , , , , , , , , ,1,1,1,1,0,1,1,1,1,2.4,2.4,2.6,NA,NA,3.6,NA,NA,3.6,3.6,2.466666667,3.6,3.033333333,6.333333333,NA,6.333333333
-2010,0,Influent,KIVA,2,6/18/2014 19:06,6/18/2014 19:47, ,1,59,2,4, ,10, , , , , , , , , ,3,1, , , , , , , ,2,Political Science,Public Administration,Statistics, , , ,1, , , , ,4,1,1, , , , ,1,1, ,1, , ,1,2, , ,25,Intelligence Research Specialist,Analyst,Research Specialsit,U.S. Government,3,3,3,3,4,10,100,47,2,4,3,5,4,3,5,5,2,5,5,5,2,6,4,5,4,4,5,5,5,3,4,4,5,5,5,4,4,2,5,3,5,5,5,2,5,3,3,3,5,3,5,3,3,3,3,5,5,4,2,3,5,3,4,3,3,3,5,3,5,5,5,3,5,4,3,3,3,3,4,3,4,5,3,6,4,3,5,1,5,5,5,5,5,5,5,5,3,3,5, ,5,5,3,5,1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,0,0,1,1,0,1,1,0,0,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA
-2011.1,1,Influent,KIVA,2,6/17/2014 20:13,6/17/2014 20:41, ,1,47,2,2, ,9,660,540, , , , , , , ,2,3,1, , , , , , , ,English Literature,Mathematics,Asian History, ,1, ,1, ,1, , ,4, ,1, , , , ,1, ,1, , , ,1,2, , ,18,Intelligence Research Specialist,Supervisory Intelligence Research Specialist,Unit Chief,Government,4,4,4,3,4,5,5,47,2,4,3,5,1,4,5,4,2,5,5,4,3,5,5,4,5,5,3,5,5,6,4,5,6,3,5,5,3,3,5,5,5,4,3,5,3,5,3,3,3,3,5,6,5,2,2,6,2,5,4,3,2,3,3,2,5,5,6,4,5,5,3,2,5,2,2,2,5,2,6,2,5,4,3,5,6,5,5,3,5,6,6,3,5,3,5,5,3,3,4,5,3,3,2,3,1,13:56:24,14:03:56, ,20,14:03:56,14:11:22, ,20, , , , , , , , , , , , , , ,2,2,1,2,2,2,2,2,1,1, , , , , , , , , , , , , , , ,7,6,6,4,4,4,3,4,4,2,3,4,13:17:26,13:44:27, ,0, , , , , , , , , , , , , , , , , , ,4,3,4,3,2, , , , , , , , , , , , , , , , , , , , ,4,6,6,4,4,3,3,4,4,3,4,4,1,1,1,1,0,1,1,1,1,1.8,1.6,NA,NA,NA,NA,NA,NA,NA,3.2,1.7,3.2,2.3,6.333333333,5.333333333,5.833333333
-2011.2,1,NEON,TWITTERSA,2,6/17/2014 20:13,6/17/2014 20:41, ,1,47,2,2, ,9,660,540, , , , , , , ,2,3,1, , , , , , , ,English Literature,Mathematics,Asian History, ,1, ,1, ,1, , ,4, ,1, , , , ,1, ,1, , , ,1,2, , ,18,Intelligence Research Specialist,Supervisory Intelligence Research Specialist,Unit Chief,Government,4,4,4,3,4,5,5,47,2,4,3,5,1,4,5,4,2,5,5,4,3,5,5,4,5,5,3,5,5,6,4,5,6,3,5,5,3,3,5,5,5,4,3,5,3,5,3,3,3,3,5,6,5,2,2,6,2,5,4,3,2,3,3,2,5,5,6,4,5,5,3,2,5,2,2,2,5,2,6,2,5,4,3,5,6,5,5,3,5,6,6,3,5,3,5,5,3,3,4,5,3,3,2,3,1,13:35:05,13:38:46,1,50,13:38:46,13:39:50, ,50,13:39:50,13:43:31, ,50, , , , , , , , , , ,2,2,3,2,3,1,1, ,1,1,2,2,2,1,2, , , , , , , , , , ,5,4,4,4,4,4,2,4,4,2,4,4,13:02:21,13:17:58,1,10,13:17:58,13:19:16, ,10,13:19:16,13:21:39,1,30,13:21:39,13:26:38, ,20,13:26:38,13:26:51,1,80, , ,4,4,5,2,3,4,3,4,2,3,4,4,4,1,3,4,4,4,2,3,4,4,4,1,3,6,6,6,4,4,4,3,4,4,2,4,4,1,1,1,1,0,1,1,1,1,2.4,1,1.8,NA,NA,3.2,3.4,3.2,3.2,3.6,1.733333333,3.32,2.685333333,4.333333333,6,5.166666667
-2011.3,1,APERTURE,TWITTERSA,1,6/17/2014 20:13,6/17/2014 20:41, ,1,47,2,2, ,9,660,540, , , , , , , ,2,3,1, , , , , , , ,English Literature,Mathematics,Asian History, ,1, ,1, ,1, , ,4, ,1, , , , ,1, ,1, , , ,1,2, , ,18,Intelligence Research Specialist,Supervisory Intelligence Research Specialist,Unit Chief,Government,4,4,4,3,4,5,5,47,2,4,3,5,1,4,5,4,2,5,5,4,3,5,5,4,5,5,3,5,5,6,4,5,6,3,5,5,3,3,5,5,5,4,3,5,3,5,3,3,3,3,5,6,5,2,2,6,2,5,4,3,2,3,3,2,5,5,6,4,5,5,3,2,5,2,2,2,5,2,6,2,5,4,3,5,6,5,5,3,5,6,6,3,5,3,5,5,3,3,4,5,3,3,2,3,1,12:16:20,12:22:14, ,40,12:22:14,12:24:30, ,20,12:24:30,12:26:27, ,30,12:26:28,12:27:07, ,40,12:27:07,12:29:07,1,40, , ,3,2,2,2,2,2,2,2,1,2,2,2,2,1,2,1,2,1,1,2,1,1,2,1,1,4,4,4,4,2,3,4,4,4,3,4,4,13:35:03,13:38:57,1,100,13:38:57,13:49:38, ,0,13:49:38,13:55:08, ,10,13:55:08,13:57:00, ,10,13:57:00,13:58:38, ,10, , ,5,5,4,1,2,3,2,4,3,3,2,2,3,4,4,2,2,2,4,4,4,3,4,2,3,7,7,6,4,4,2,3,4,4,3,4,4,1,1,1,1,0,1,1,1,1,2.2,1.8,1.8,1.4,1.2,3,2.8,3.2,3,3.4,1.68,3.08,2.38,4,6.666666667,5.333333333
-2012,1,GeoMap,TWITTERSA,1,6/17/2014 10:42,6/17/2014 11:38, ,1,38,2,4, ,10,700,500, , ,3,3,1,3,2,1,3,3,3,2,2,2,1,1,2,"Engineering, Science","Computers, Math, Chemistry",Humanities/Arts, ,1,1,1,1, , , ,1,1, , , , , ,2, , , , , , ,1,4,Defect Analysis,10,Engineer,Defense Information Systems Agency,Chief Engineer Cloud Computing; GS-15 Electronics Engineer,Government,4,4,5,4,5,5,5,47,2,4,3,5,1,4,2,4,2,7,6,6,7,6,7,5,2,5,2,2,1,7,6,4,7,2,6,2,2,2,4,2,7,3,2,6,1,7,4,2,3,1,7,5,7,1,1,6,2,7,7,2,2,2,1,2,7,7,5,6,5,6,2,2,6,1,2,2,5,1,7,2,5,6,5,7,6,5,7,5,4,2,2,2,2,2,3,3,2,2,4,3,2,2,2,2,1,8:51:28,9:07:04, ,90, , , , , , , , , , , , , , , , , , ,3,3,2,3,4, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,9:23:18,9:31:28, ,80,9:31:28,9:37:14, ,90,9:37:15,9:41:42, ,90,9:41:42,9:48:55, ,90,9:48:55,9:52:24, ,90, , ,4,3,4,3,4,4,3,4,4,4,4,4,4,2,2,3,3,4,4,4,4,4,4,2,2,1,2,2,4,4,2,2,2,5,2,4,5,1,1,1,1,0,1,1,1,1,3,NA,NA,NA,NA,3.8,3.6,3.2,3.2,3.6,3,3.48,3.36,NA,1.666666667,1.666666667
-2014,1,APERTURE,TWITTERSA,2,6/18/2014 17:57,6/23/2014 19:11, ,1,43,1,4, ,12, , , , , , , , , ,1, , , , , , , , , ,Statistics,Mathematics, , , , ,1,1, ,1, ,7, , , , ,1, ,2, , , , , , ,2, , ,17,Mathematical Statistician,Food and Drug Administration,Mathematical Statistician,Biostatistics - Government,5,5,5,4,5,5,5,47,2,4,3,5,5,4,3,5,2,6,6,5,2,7,6,6,4,6,2,6,3,6,6,5,7,3,6,6,5,2,5,2,6,4,3,2,2,5,5,3,2,1,7,5,6,2,2,6,2,5,5,4,3,1,6,2,6,6,6,7,4,5,2,4,3,2,2,2,4,3,6,2,4,6,3,5,6,4,5,3,5,6,5,6,6,3,6,5,5,3,3,5,5,5,2,6,1,9:22:10,9:36:20, ,30,9:36:21,9:42:26, ,80,9:42:27,9:48:23, ,80,9:48:23,9:50:20,1,100, , , , , , ,4,4,3,5,3,2,2,2,2,2,3,3,3,2,2,2,3,2,3,3, , , , , ,7,6,6,3,2,2,3,2,3,2,3,3,9:38:52,9:47:26,1,100,9:47:26,10:07:36, ,60, , , , , , , , , , , , , , ,4,4,4,1,1,2,3,4,4,3, , , , , , , , , , , , , , , ,5,7,5,4,4,3,4,3,2,3,2,4,1,1,1,1,0,1,1,0,1,3.8,2,2.6,2.6,NA,3.2,NA,NA,NA,2.8,2.75,3,2.84375,6.333333333,5.666666667,6
-2015,0,TrackCom,AIS,1,6/25/2014 19:53,6/25/2014 20:55, ,1,32,2,4, ,10,680,680, , , ,3, , ,1,2, , , , , , , , , ,Computer Science,Mathematics,Biology, ,1,1, , , , , ,2,1, , , , , ,2, , , , , , ,2, , ,8,Software Engineer,Software Engineer,Systems Architect,Information Technology,4,4,4,2,4,5,5,47,2,5,3,5,1,2,2,1,2,7,7,6,4,5,6,7,2,6,5,5,2,6,5,2,5,2,6,2,2,2,5,4,5,5,3,1,1,6,3,6,1,1,7,5,6,2,1,3,1,6,4,3,1,2,2,4,2,6,3,6,2,5,1,1,2,1,2,1,2,1,6,1,2,6,5,5,6,2,6,1,3,6,5,3,3,2,3,4,2,1,2,4,3,3,2,3,1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,7, , ,2,4,2,3,2,2,4,1,2,13:57:09,14:09:36,1,20,14:09:37,14:12:30, ,30,14:12:30,14:14:50, ,70,14:14:50,14:17:09, ,80,14:17:11,14:22:40, ,0, , ,1,1,1,5,5,4,3,2,3,4,4,4,2,2,2,2,2,2,5,4, ,1, ,5, ,8,7,3,1,4,1,2,1,2,4,1,4,1,1,1,1,1,1,1,1,0,NA,NA,NA,NA,NA,3.2,3,3,2.8,2.6,NA,2.92,2.92,7,6,6.5
-2017,1,TrackCom,AIS,1,6/25/2014 19:28,6/25/2014 20:02, ,1,47,2,4, ,12,670,560,660,560, , , ,1,3,2, , , , , , , , , ,Experimental Psychology,Statistics,Programming, , , , ,1, ,1, ,5,1, , , , , ,2, , , , , , ,2, , ,17,Technical Advisor Battlespace Visualization Branch,Air Force Research Laboratory,Technical Advisor Battlespace Visualization Branch,Department of Defense,5,5,5,5,5,10,20,47,4,5,3,5,1,3,5,5,2,6,4,5,3,5,3,6,3,5,5,5,5,5,6,5,5,5,5,2,3,3,5,3,5,2,2,2,2,6,2,5,2,2,6,2,6,1,1,6,1,7,7,2,2,3,3,3,6,6,6,6,5,5,2,1,5,1,2,2,4,1,6,2,5,5,2,5,7,7,5,1,6,1,1,5,6,6,5,4,4,3,6,6,5,5,6,6,1,9:13:13,9:25:18, ,50,9:25:18,9:32:36, ,20,9:32:36,9:37:32,1,60,9:37:32,9:41:08, ,10,9:41:08,9:41:17, , , , ,4,5,2,5,5,4,5,2,4,4,4,5,2,4,4,2,2,1,4,3, , , , , ,9,9,9,5,4,2,1,1,1,4,4,4,9:53:09,10:03:52,1,70,10:03:52,10:13:30, ,20,10:13:30,10:14:47, ,30,10:14:47,10:15:58, ,60, , , , , , ,3,3,5,4,4,2,2,4,4,4,4,2,4,4,3,3,3,4,4,4, , , , , ,6,6,7,5,4,2,2,2,2,3,1,5,0,0,1,0,1,1,1,1,0,4.2,3.8,3.8,2.4,NA,3.2,3.6,NA,3.4,3.8,3.55,3.5,3.525,9,6.333333333,7.666666667
-2020,1,GeoMap,TWITTERSA,1,6/24/2014 14:37,6/24/2014 15:04, ,1,35,1, ,Mixed,9, , , , , , , , ,1, , , , , , , , , , ,Computer Science, , , ,1, ,1, , , , ,4, , ,1, , , ,1,1,1, , , ,1,2, , ,13,Technical Analyst, ,Analyst, ,4,4,5,3,5,5,5,47,3,2,5,5,1,4,2,2,1,6,5,5,2,6,6,6,3,4,5,5,3,5,5,3,7,2,5,4,3,2,5,3,5,3,3,3,1,6,3,3,6,2,6,6,6,2,3,5,3,7,3,3,3,2,6,3,5,5,5,6,5,5,2,3,4,2,2,2,4,2,5,2,5,5,5,5,5,3,6,3,3,3,3,4,5,6,5,5,3,3,3,5,5,5,2,3,1,13:32:05,13:36:08, ,60,13:36:08,13:39:25, ,70,13:39:25,13:41:40, ,60,13:41:41,13:46:17, ,90,13:46:18,13:50:08, ,60, , ,3,3,2,2,3,3,2,3,3,3,4,4,3,2,2,2,4,2,2,2,4,4,2,2,2,5,4,4,2,4,2,2,3,2,4,1,3,13:57:11,14:01:05, ,90,14:01:06,14:04:57, ,40,14:04:57,14:08:22, ,80,14:08:22,14:15:29, ,90,14:15:29,14:18:58, ,60, , ,5,4,4,3,3,4,3,4,2,3,2,2,3,2,3,3,3,4,2,3,1,2,2,1,3,5,5,4,2,4,2,2,2,2,2,3,2,1,1,1,0,0,0,1,1,1,2.6,2.8,3,2.4,2.8,3.2,3,1.8,2.4,3.8,2.72,2.84,2.78,4.333333333,4.666666667,4.5
-2021,1,TrackCom,AIS,1,6/26/2014 1:17,6/26/2014 1:46, ,1,60,2,4, ,12, , , , , ,1, , , , , , , , , , , , , ,Biology (Marine Biology), , ,1,1,1,1,1, ,1, ,5, , ,1, , , ,1,1, , , , , ,2, , ,11,Research Scientist,Systems Integrator,Data Scientist,U.S. Government,4,4,4,4,4,5,5,47,2,5,3,5,1,4,2,4,2,5,6,6,2,5,6,5,3,4,3,5,4,6,5,4,5,5,5,4,4,3,5,3,5,3,3,3,1,5,4,4,2,3,7,4,6,2,2,5,2,5,5,4,4,2,3,3,6,4,5,4,4,4,4,2,4,2,2,2,3,3,4,2,3,5,2,5,5,3,4,2,5,4,3,6,5,4,4,5,4,3,5,4,6,5,6,4,1,10:29:41,10:38:44, ,70,10:38:44,10:51:15, ,70,10:51:14,10:56:41,1,70, , , , , , , , , , ,3,3,3,4,4,3,4,3,4,4,3,4,3,3,4, , , , , , , , , , , , , , , , , , , , , , ,11:09:28,11:15:18,1,70,11:15:18,11:19:25, ,70,11:19:25,11:22:02, ,70,11:22:02,11:22:52, ,80,11:22:53,11:28:39,1,70, , ,3,3,4,3,4,3,3,4,4,4,3,2,3,3,4,3,3,3,4,4,3,3,3,3,4,7,7,5,3,4,2,3,2,2,3,2,3,1,1,1,1,1,1,1,1,1,3.4,3.6,3.4,NA,NA,3.6,3.4,3.2,3,3.4,3.466666667,3.32,3.378666667,NA,6.333333333,6.333333333
-2022,1,GeoMap,TWITTERSA,1,6/21/2014 15:10,6/21/2014 15:51, ,1,36,2,4, ,8, , , , , , , , , , , , , , , , , , , ,Intelligence Studies,Intelligence Operations,Network Intelligence Analysis,1, ,1,1, , ,1, ,4,1,1,1, , , ,1,1,1, , , ,1,2, , ,13,Intelligence Analyst,Active Duty USAF,Intelligence Analyst,Federal Law Enforcement,2,2,4,3,4,5,100,47,2,5,3,3,5,5,5,4,5,6,5,6,3,6,6,6,5,5,4,5,3,3,4,3,5,3,5,6,3,2,4,2,5,5,3,2,3,4,3,2,3,4,5,5,5,2,1,6,2,6,4,3,3,3,2,1,2,4,5,4,6,6,3,3,4,2,2,2,6,2,5,3,6,5,5,5,4,4,6,6,6,3,2,2,6,3,4,4,3,3,3,3,3,3,2,3,1,13:28:35,13:33:32, ,80,13:33:32,13:39:04, ,70,13:39:05,13:42:49, ,60,13:42:50,13:56:22, ,60, , , , , , ,2,4,2,4,3,1,1,1,2,2,2,2,2,3,3,3,3,2,3,3, , , , , ,6,4,5,4,5,3,2,4,4,2,3,3,14:08:44,14:17:16, ,70,14:17:17,14:21:43, ,70,14:21:43,14:23:55, ,60,14:23:55,14:32:01, ,60,14:32:00,14:35:03, ,70, , ,4,4,4,2,3,3,3,4,3,3,3,3,4,4,3,2,2,4,3,3,4,3,4,3,3,5,6,5,3,4,3,3,3,2,2,2,4,1,0,1,1,1,1,0,0,0,3,1.4,2.4,2.8,NA,3.2,2.8,3.4,3.4,3.4,2.4,3.24,2.858181818,5,5.333333333,5.166666667
-2023,1,Influent,KIVA,1,7/3/2014 12:57,7/3/2014 13:26, ,1,48,2,4, ,12, , , , , , , ,1, , ,3, , , , , , , , ,Economics,Psychology,Religious Studies,1,1,1,1,1,1,1, ,3,1,1, , , , ,2, , , , , , ,1,2, ,12,Management,"Giant Oak, Inc",President and CEO,Information Technology,4,4,5,5,5,10,100,47,2,4,1,5,1,4,5,5,1,7,7,6,2,6,7,5,3,5,4,5,1,6,5,5,7,2,7,4,1,1,6,2,7,2,1,1,1,4,2,5,4,1,7,3,6,1, ,7,2,7,4,1,5,3,2,1,6,6,7,5,7,7,6,1,6,1,2,1,5,1,6,6,6,6,5,5,7,6,7,6,6,2,6,1,5,3,5,6,2,2,1,4,2,2,1,2,1,9:39:38,9:59:16, ,70,9:59:15,10:10:09, ,20, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,15:47:59,16:04:07, ,20,16:04:09,16:12:59, ,0,16:12:59,16:13:33, ,0,16:13:33,16:17:14, ,0, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,0,0,1,1,0,0,1,1,1,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA
-2024,1,GeoMap,TWITTERSA,2,7/3/2014 18:06,7/3/2014 18:34, ,1,26,2,4, ,9,780,700, , , , , ,1, ,2, ,3, , , , , , , ,Economics,Math,Arabic,1, ,1,1,1, , , ,1,1, , , , , ,2, , , , , , ,1,3, ,1,Senior Analyst,Data Science,Senior Analyst,Research,5,5,5,5,5,5,5,47,2,2,3,5,1,4,4,4,1,7,7,5,1,7,7,7,5,4,7,7,1,7,5,4,6,5,6,4,1,1,1,1,7,4,1,4,1,4,1,3,4,2,7,4,5,1,4,5,1,1,7,4,3,1,4,3,4,4,5,5,5,5,4,3,5,1,4,1,4,1,7,1,4,7,6,4,7,6,5,1,3,1,1,1,4,4,4,4,4,4,4,4,4,4,4,4,2,13:48:25,13:53:11, ,80,13:53:12,13:55:42, ,100,13:55:41,13:58:34, ,100,13:58:34,14:02:19, ,100,14:02:19,14:03:57, ,70, , ,5,5,5,5,1,5,5,5,3,1,5,4,5,3,1,5,5,1,2,1,5,5,5,1,1, , , , , , , , , , , , ,13:22:24,13:29:39, ,100,13:29:39,13:32:01, ,100,13:32:02,13:35:36, ,90,13:35:36,13:39:07, ,90,13:39:07,13:40:49, ,100, , ,5,5,5,2,3,3,4,4,1,3,4,4,4,2,2,1,1,3,3,2,2,4,4,1,2, , , , , , , , , , , , ,1,1,1,1,0,1,1,1,1,4.2,3.8,3.6,2.8,3.4,3,2,2.6,3.2,4,3.56,2.96,3.26,NA,NA,NA
-2025,1,GeoMen,TWITTERSA,1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,999,999,999,999,999,999, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,10:15:42,10:25:44,1,100,10:25:44,10:29:24, ,100,10:29:24,10:33:28, , , , , , , , , , , , ,2,3,1,4,4,4,5,1,2,5, , , , , , , , , , , , , , , ,3,8,1,5,5,2,2,4,5,2,2,5,10:47:13,10:56:31, ,30,10:56:30,11:01:41, ,70,11:01:41,11:03:23, ,90,11:03:23,11:06:23, ,70,11:06:23,11:08:52, ,80, , ,5,5,5,2,3,4,3,5,4,5,2,2,5,5,5,3,3,4,3,5,1,1,2,4,4,3,9,3,4,5,2,2,2,4,5,1,5,,,,0,0,0,0,0,0,2.8,3.4,NA,NA,NA,4.2,3.6,2.4,3.8,4,3.1,3.6,3.433333333,4,5,4.5
-2026,1,NEON,TWITTERSA,1,7/2/2014 16:44,7/2/2014 17:09, ,1,36,2,4, ,10,800,800, , , , , , ,1,3, , , , , , , ,3,2,Computer Science,Business, ,1,1,1,1,1, ,1, ,3, , , , , , ,2, , , , , , ,2, , ,15,Senior Principal Software Engineer, ,Senior Scientist,Government R&D,4,4,4,3,4,10,5,47,2,5,3,5,5,3,2,1,1,2,6,1,1,5,7,7,5,5,5,5,3,6,5,2,6,2,7,5,2,3,5,2,7,3,2,1,1,3,3,3,1,1,7,7,7,1,1,2,2,5,5,4,2,1,3,2,7,6,3,7,3,5,2,1,2,1,1,1,2,1,7,1,2,7,7,7,6,6,6,7,4,4,2,2,6,5,5,5,3,2,2,2,2,2,2,3,1,13:28:30,13:33:27,1,50,13:33:27,13:38:05, ,50,13:38:05,13:43:44, ,50,13:43:44,13:47:13,1,90,13:47:13,13:48:51, ,50, , ,2,3,4,1,2,2,3,4,1,2,2,3,4,3,2,2,2,4,1,2,2,3,4,1,2, , , , , , , , , , , , ,13:59:44,14:11:57,1,80,14:11:56,14:16:29, ,60,14:16:30,14:22:54, ,60, , , , , , , , , , ,5,5,2,2,2,3,3,2,3,2,3,2,2,3,2, , , , , , , , , , ,3,3,1,3,3,2,2,2,2,2,3,4,0,1,1,1,1,1,1,0,0,2.4,2.4,2.8,2.2,2.4,2.6,NA,NA,2.4,3.2,2.44,2.733333333,2.557333333,NA,2.333333333,2.333333333
-2027,1,APERTURE,TWITTERSA,2,7/1/2014 17:12,7/1/2014 18:46, ,1,45,2,4, ,9,670,710, , , , , , ,2, , ,3, ,1, , , , , ,mechanical engineering,computer science,foreign languages, ,1,1,1, , ,1, ,4,1, , , , , ,1,1, , , , ,1,2, , ,13,intelligence analyst,job!=employment,intelligence analyst,government,5,5,5,5,5,5,5,47,2,5,4,5,1,4,4,3,1,6,6,6,6,7,6,6,6,5,6,7,1,6,6,5,7,1,6,7,4,6,6,1,6,6,4,2,1,7,3,4,5,2,7,3,7,1,1,4,1,7,3,4,1,1,4,4,4,6,4,1,4,6,2,1,4,1,1,1,5,1,6,1,6,4,6,7,6,6,6,2,5,2,2,2,2,1,2,2,2,2,2,5,2,4,7,4,1,9:58:42,10:08:43, ,50,10:08:43,10:14:41, ,50,10:14:42,10:19:50, ,50,10:19:50,10:23:41,1,90,10:23:41,10:26:28, ,50, , ,5,3,2,3,4,5,3,2,3,4,5,3,2,3,4,5,3,3,3,3,4,2,3,3,4,1,2,1,3,2,3,2,4,3,2,1,2,10:11:37,10:19:22, ,70, , , , , , , , , , , , , , , , , , ,2,3,2,1,2, , , , , , , , , , , , , , , , , , , , ,1,1,1,3,1,1,1,4,3,1,2,2,1,1,1,1,1,0,1,1,1,3.4,3.4,3.4,3.4,3.2,NA,NA,NA,NA,2,3.36,2,3.02,1.333333333,1,1.166666667
-2028,0,TrackCom,AIS,1,7/10/2014 15:12,7/10/2014 16:34, ,1, ,1,4, ,12, , , , , ,3,3,1,2, , ,2, , , , , , , ,Anthropology,Computational Modeling,Information Technology,1,1,1,1,1,1,1, ,3,1, , , , , ,2, , , , , , ,2, , ,14,Program Officer,Office of Naval Research,Program Officer,Department of Defense,3,3,3,3,3,5,5,47,2,4,3,4,1,4,5,2,1,6,5,5,2,6,6,6,4,5,4,5,3,6,5,3,5,2,5,5,2,3,5,1,5,4,3,3,1,4,3,3,3,1,7,5,5,1,1,3,3,3,3,4,4,3,3,2,3,3,5,4,4,4,1,2,3,1,1,1,3,1,3,2,4,5,7,7,5,4,5,4,5,4,4,2,5,3,3,5,4,2,2,2,5,5,2,3,1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,11:16:31,11:28:37, ,60,11:28:37,11:34:50,1,0,11:34:49,11:35:13, ,0,11:35:13,11:35:30,1,0,11:35:30,11:40:59, ,0, , ,3,3,4,5,4,1,1,3,5,4,3,3,3,5,4,1,1,1,5,5,1,1,5,5,4, , , , , , , , , , , , ,1,1,1,1,0,1,0,1,1,NA,NA,NA,NA,NA,2.8,2.6,3.2,3.6,3.8,NA,3.2,3.2,NA,NA,NA
-2030,1,GeoMen,TWITTERSA,2,7/14/2014 15:34,7/14/2014 16:52, ,1,37,2,4, ,12, , ,600,680, , , ,1,2, ,1,2, , , , , , , ,Near Eastern Archaeology,Modern & Ancient Languages, , , ,1,1,1, , , ,3, , , , , ,1,2, , , , , , ,2, , ,1,Project Scientist, , , ,5,5,5,5,5,5,5,47,2,4,5,3,1,4,3,2,6,5,6,6,2,2,3,5,5,5,6,7,2,5,4,2,5,3,3,7,2,1,5,2,6,4,4,2,2,2,1,2,3,2,6,7,7,1,4,3,1,6,6,2,3,2,2,2,5,5,5,5,3,5,2,1,3,3,1,1,3,1,5,2,3,5,5,6,7,6,6,3,6,2,2,5,6,2,3,5,2,1,3,1,5,5,2,3,2,14:16:33,14:21:14,1,90,14:21:14,14:26:26, ,100,0:-38:-35,0:-38:-34, , ,14:27:54,14:37:02, ,50,14:37:03,14:43:19,1,100, , ,4,4,4,4,3,2,2,3,2,3, , , , , ,4,4,3,5,5,4,4,2,4,5,2,3,3,2,4,4,4,3,4,3,4,3,13:39:18,13:48:03, ,90, , , , , , , , , , , , , , , , , , ,5,5,3,1,1, , , , , , , , , , , , , , , , , , , , ,2,2,2,3,3,2,3,2,4,1,2,4,1,1,1,1,0,0,0,1,1,3.8,2.4,NA,4.2,3.8,NA,NA,NA,NA,3,3.55,3,3.392857143,2.666666667,2,2.333333333
-2031,1,TrackCom,AIS,1,7/14/2014 14:29,7/14/2014 14:59, ,1,39,2,4, ,9,620,620, , , , , , , , , , , , , , , ,1, ,Industrial Management Engineering,Military Science, , ,1, ,1, ,1, , ,4, ,1, , , , ,1,1,1, , , ,1,2, , ,17,Special Agent and Military Officer,DEA,Special Agent, ,3,3,3,3,3,10,100,24,2,5,3,5,5,4,2,3,2,7,7,6,7,7,7,7,5,7,4,5,2,7,7,2,7,1,7,2,1,1,7,6,7,2,2,3,1,7,4,4,2,7,7,1,7,2,1,4,2,7,4,5,3,1,4,1,2,4,3,4,3,2,2,2,2,1,1,1,1,1,7,1,4,7,7,6,7,7,7,7,1,1,1,3,2,3,1,5,1,1,2,4,4,4,2,1,1,9:39:20,9:51:47, ,70,9:51:46,9:59:36, ,30, , , , , , , , , , , , , , ,5,5,5,1,3,5,5,5,1,2, , , , , , , , , , , , , , , , , , , , , , , , , , , ,10:20:45,10:27:24, ,50,10:27:24,10:33:08, ,0,10:33:08,10:37:16, ,20,10:37:16,10:38:52, ,20,10:38:52,10:43:34, ,20, , ,1,1,1,1,3,1,1,1,1,3,1,1,1,1,3,1,1,1,1,3,1,1,1,1,3, , , , , , , , , , , , ,0,0,0,1,1,1,1,0,1,3.8,3.6,NA,NA,NA,1.4,1.4,1.4,1.4,1.4,3.7,1.4,2.166666667,NA,NA,NA
-2033,1,GeoMen,TWITTERSA,1,7/14/2014 14:09,7/14/2014 15:20, ,1,37,2,4, ,9,550,550, , , , , , , , , , , , , , , , ,1,Marine Transportation,Logistics, ,1,1,1,1, , , , ,4,1,1,1, , , ,1,1, ,1, , ,1,1,6, ,9,Special Agent,Drug Enforcement Admnistration,Special Agent,Drug Trafficking,5,5,5,5,5,5,5,47,2,5,5,5,5,4,4,4,1,7,7,7,1,7,7,7,4,7,7,7,1,7,4,7,7,1,7,1,1,1,7,1,7,1,1,1,1,1,4,1,1,1,7,1,7,1,1,7,1,7,7,1,1,1,1,1,7,7,7,7,7,7,7,4,7,1,1,1,7,1,7,1,7,4,4,1,7,7,7,1,7,4,1,7,7,1,1,7,1,1,7,7,7,7,4,7,1,10:58:10,11:03:49, ,60,11:03:49,11:06:36, ,60,11:06:36,11:08:46,1,100,11:08:47,11:16:19, ,0, , , , , , ,3,5,5,5,5,3,5,5,5,5,5,5,5,5,5,5,5,5,5,5, , , , , ,7,7,5,2,5,1,1,2,1,1,1,1,10:18:55,10:31:39, ,70,10:31:39,10:42:24, ,90,10:42:24,10:46:16, ,100, , , , , , , , , , ,3,3,5,4,1,5,4,5,3,3,5,5,5,5,1, , , , , , , , , , , , , , , , , , , , , , ,1,1,1,1,1,0,1,0,1,4.6,4.6,5,5,NA,4,NA,NA,4.2,3.2,4.8,3.8,4.355555556,6.333333333,NA,6.333333333
-2034,0,GeoMen,TWITTERSA,2,7/10/2014 15:10,7/10/2014 21:20, ,1,40,2,4, ,9,750,490, , , , , , ,2, , , ,1, , , , , , ,Dual Major - Art Education and Fine Arts,Dual Minor - Computer Technology and Computer Education, ,1,1,1,1, , ,1, ,2,1, , , , , ,2, , , , , , ,2, , ,22,Information Technology Director (Assistant Chief of Staff G-6),Department of the Navy,Information Technology Specialist,"Government, Military",5,5,5,5,5,5,5,47,2,5,3,5,5,5,5,5,1,7,6,7,4,6,6,6,5,6,4,5,2,6,6,2,6,2,5,3,3,2,6,3,6,5,2,2,2,5,3,4,3,2,6,3,6,2,2,6,2,6,6,2,2,2,2,2,6,6,5,5,5,4,2,2,4,2,2,2,3,2,5,2,5,6,3,3,6,6,6,1,4,4,4,4,5,5,5,4,4,2,5,5,4,5,3,5,1,13:56:26,14:09:28,1,90,14:09:28,14:15:44, ,90,14:15:44,14:17:06,1,100,14:17:06,14:23:47, ,0,14:23:47,14:27:10, ,0, , ,2,2,2,5,4,2,2,3,3,4,2,2,3,3,3,5,5,5,5,4,5,5,5,5,4,6,6,4,1,2,2,2,1,1,2,2,2, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,5,5,3,3,3,3,3,3,3,4,4,3,1,1,1,1,1,1,1,0,0,3,2.8,2.6,4.8,4.8,NA,NA,NA,NA,NA,3.6,NA,3.6,5.333333333,4.333333333,4.833333333
-2035,1,NEWMAN,SWEMAIL,1,7/14/2014 13:58,7/14/2014 14:38, ,1,34,2,4, ,9, , , , , , , , ,1,2, , , , ,3, , ,3, ,Computer Science / Systems,Mathematics, , ,1, ,1,1, , , ,4, , , , , , ,2, , , , , , ,1, ,Cyber Security Analyst,1,Cyber Security Analyst,Argonne National Laboratory,Cyber Security Analyst,Government,4,4,5,4,4,5,5,47,2,4,3,5,1,4,3,2,1,6,6,5,1,6,6,6,2,5,4,5,2,5,5,2,5,3,5,4,2,2,4,2,5,3,2,5,1,7,3,2,3,2,7,6,6,1,2,6,1,6,6,2,2,1,2,1,7,7,7,7,7,7,1,1,6,1,1,1,5,1,6,1,6,6,5,5,6,6,4,4,5,3,2,3,3,1,1,5,2,1,1,1,3,3,3,1,1,9:42:43,9:47:52, ,80,9:47:52,9:55:21, ,70,9:55:22,10:06:30, ,70,10:06:30,10:06:39, ,60,10:06:39,10:10:33, ,60, , ,4,4,1,4,4,4,4,1,4,4,4,4,1,4,4,4,4,1,4,4,4,4,1,4,4,5,7,5,4,2,2,2,2,2,2,2,4,10:19:23,10:46:08,1,70,10:46:08,10:47:05, , ,17:53:38,17:53:45, , ,17:53:46,17:53:52, , ,17:53:53,17:53:53, , , , ,3,3,5,2,4, , , , , , , , , , , , , , , , , , , , ,6,6,5,4,4,2,2,3,2,2,2,4,1,1,1,1,0,1,1,1,1,3.4,3.4,3.4,3.4,3.4,NA,NA,NA,NA,3.4,3.4,3.4,3.4,5.666666667,5.666666667,5.666666667
-2036,1,LineUP,NBA,2,7/22/2014 18:24,7/22/2014 19:25, ,1,19,2, ,Hispanic,7, , , , , , , , , , , , , , , , , , , ,Computer Engineering, , ,1,1, , , , , , ,2, , , , , , ,2, , , , , , ,2, , ,1,Intern, ,Intern,Data Analysis,4,4,3,3,3,10,100,24,2,5,3,5,5,4,3,2,1,4,5,6,1,6,4,5,2,5,4,5,3,5,5,2,5,3,4,2,4,1,6,2,5,3,3,2,3,5,5,6,2,4,6,6,5,2,3,5,3,5,4,2,5,2,3,3,4,5,5,5,3,3,5,2,3,2,2,2,3,2,5,2,3,6,4,5,5,4,5,2,5,1,1,6,2,3,5,5,5,2,6,2,6,6,2,2,1,13:40:06,13:41:07, ,90,13:41:08,13:45:01, ,70,13:45:01,13:52:44, ,90,13:52:44,13:54:18, ,80,13:54:19,13:56:24, ,60, , ,2,2,3,2,2,2,2,3,2,2,2,3,3,2,2,2,3,3,2,2,3,3,3,3,2,5,4,5,3,4,2,2,4,4,2,3,3,13:17:48,13:20:32, ,90,13:20:33,13:23:59,1,80,13:23:59,13:26:52, ,80,13:26:52,13:29:44, ,80,13:29:45,13:33:03, ,70, , ,4,4,3,2,2,4,3,3,2,2,4,3,3,2,2,3,3,3,2,2,3,4,3,2,2,4,4,5,3,4,3,2,4,4,2,3,2,0,0,0,1,1,1,1,0,1,2.2,2.2,2.4,2.4,2.8,2.8,2.6,2.8,2.8,3,2.4,2.8,2.6,4.666666667,4.333333333,4.5
-4000,0,TrackCom,AIS,1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,999,999,999,999,999,999, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,13:15:51,13:19:00,1,90,13:19:00,13:28:17, ,70,13:28:17,13:40:41, ,50,13:40:42,13:43:20, ,80, , , , , , ,3,2,3,1,2,3,3,3,1,3,5,5,3,4,4,3,3,3,3,3, , , , , ,6,6,5,4,5,2,1,4,4,2,3,4,14:06:42,14:09:33,1,100,14:09:33,14:13:20, ,80,14:13:21,14:15:58, ,80,14:15:58,14:17:15,1,90,14:17:15,14:27:18, ,70, , ,4,4,5,1,2,4,4,4,1,2,3,3,4,1,4,3,3,5,1,3,4,4,4,1,1,3,4,5,4,2,4,3,4,4,2,4,4,,,,0,0,0,0,0,0,2.2,2.6,4.2,3,NA,3,3,2.8,3,3.2,3,3,3,5.666666667,4,4.833333333
diff --git a/static/javascript/data/difficulty.csv b/static/javascript/data/difficulty.csv
deleted file mode 100644
index 906df9a..0000000
--- a/static/javascript/data/difficulty.csv
+++ /dev/null
@@ -1,81 +0,0 @@
-Tool,Range,Count
-APERTURE,1.0,1.0
-APERTURE,2.0,0
-APERTURE,3.0,0
-APERTURE,4.0,0
-APERTURE,5.0,2.0
-APERTURE,6.0,1.0
-APERTURE,7.0,0
-APERTURE,8.0,0
-APERTURE,9.0,0
-APERTURE,10.0,0
-GeoMap,1.0,0
-GeoMap,2.0,1.0
-GeoMap,3.0,0
-GeoMap,4.0,2.0
-GeoMap,5.0,2.0
-GeoMap,6.0,0
-GeoMap,7.0,0
-GeoMap,8.0,0
-GeoMap,9.0,0
-GeoMap,10.0,0
-GeoMen,1.0,0
-GeoMen,2.0,1.0
-GeoMen,3.0,0
-GeoMen,4.0,1.0
-GeoMen,5.0,1.0
-GeoMen,6.0,2.0
-GeoMen,7.0,0
-GeoMen,8.0,0
-GeoMen,9.0,0
-GeoMen,10.0,0
-Influent,1.0,0
-Influent,2.0,1.0
-Influent,3.0,1.0
-Influent,4.0,0
-Influent,5.0,0
-Influent,6.0,1.0
-Influent,7.0,0
-Influent,8.0,0
-Influent,9.0,0
-Influent,10.0,0
-LineUP,1.0,0
-LineUP,2.0,0
-LineUP,3.0,0
-LineUP,4.0,1.0
-LineUP,5.0,0
-LineUP,6.0,0
-LineUP,7.0,0
-LineUP,8.0,0
-LineUP,9.0,0
-LineUP,10.0,0
-NEON,1.0,0
-NEON,2.0,1.0
-NEON,3.0,0
-NEON,4.0,0
-NEON,5.0,1.0
-NEON,6.0,1.0
-NEON,7.0,0
-NEON,8.0,0
-NEON,9.0,0
-NEON,10.0,0
-NEWMAN,1.0,0
-NEWMAN,2.0,0
-NEWMAN,3.0,0
-NEWMAN,4.0,0
-NEWMAN,5.0,0
-NEWMAN,6.0,1.0
-NEWMAN,7.0,0
-NEWMAN,8.0,0
-NEWMAN,9.0,0
-NEWMAN,10.0,0
-TrackCom,1.0,0
-TrackCom,2.0,0
-TrackCom,3.0,0
-TrackCom,4.0,0
-TrackCom,5.0,1.0
-TrackCom,6.0,3.0
-TrackCom,7.0,0
-TrackCom,8.0,1.0
-TrackCom,9.0,0
-TrackCom,10.0,0
diff --git a/static/javascript/data/difficultyOT1.csv b/static/javascript/data/difficultyOT1.csv
deleted file mode 100644
index f38a7ac..0000000
--- a/static/javascript/data/difficultyOT1.csv
+++ /dev/null
@@ -1,81 +0,0 @@
-Tool,Range,Count
-APERTURE,1.0,1.0
-APERTURE,2.0,0
-APERTURE,3.0,0
-APERTURE,4.0,1.0
-APERTURE,5.0,1.0
-APERTURE,6.0,1.0
-APERTURE,7.0,0
-APERTURE,8.0,0
-APERTURE,9.0,0
-APERTURE,10.0,0
-GeoMap,1.0,0
-GeoMap,2.0,0
-GeoMap,3.0,1.0
-GeoMap,4.0,2.0
-GeoMap,5.0,1.0
-GeoMap,6.0,0
-GeoMap,7.0,0
-GeoMap,8.0,0
-GeoMap,9.0,0
-GeoMap,10.0,0
-GeoMen,1.0,0
-GeoMen,2.0,0
-GeoMen,3.0,1.0
-GeoMen,4.0,1.0
-GeoMen,5.0,1.0
-GeoMen,6.0,2.0
-GeoMen,7.0,0
-GeoMen,8.0,0
-GeoMen,9.0,0
-GeoMen,10.0,0
-Influent,1.0,0
-Influent,2.0,0
-Influent,3.0,2.0
-Influent,4.0,0
-Influent,5.0,0
-Influent,6.0,1.0
-Influent,7.0,0
-Influent,8.0,0
-Influent,9.0,0
-Influent,10.0,0
-LineUP,1.0,0
-LineUP,2.0,0
-LineUP,3.0,0
-LineUP,4.0,0
-LineUP,5.0,1.0
-LineUP,6.0,0
-LineUP,7.0,0
-LineUP,8.0,0
-LineUP,9.0,0
-LineUP,10.0,0
-NEON,1.0,0
-NEON,2.0,0
-NEON,3.0,0
-NEON,4.0,1.0
-NEON,5.0,0
-NEON,6.0,1.0
-NEON,7.0,0
-NEON,8.0,0
-NEON,9.0,0
-NEON,10.0,0
-NEWMAN,1.0,0
-NEWMAN,2.0,0
-NEWMAN,3.0,0
-NEWMAN,4.0,0
-NEWMAN,5.0,0
-NEWMAN,6.0,1.0
-NEWMAN,7.0,0
-NEWMAN,8.0,0
-NEWMAN,9.0,0
-NEWMAN,10.0,0
-TrackCom,1.0,0
-TrackCom,2.0,0
-TrackCom,3.0,0
-TrackCom,4.0,0
-TrackCom,5.0,1.0
-TrackCom,6.0,1.0
-TrackCom,7.0,1.0
-TrackCom,8.0,0
-TrackCom,9.0,1.0
-TrackCom,10.0,0
diff --git a/static/javascript/data/difficultyOT2.csv b/static/javascript/data/difficultyOT2.csv
deleted file mode 100644
index f921a24..0000000
--- a/static/javascript/data/difficultyOT2.csv
+++ /dev/null
@@ -1,81 +0,0 @@
-Tool,Range,Count
-APERTURE,1.0,1.0
-APERTURE,2.0,0
-APERTURE,3.0,0
-APERTURE,4.0,0
-APERTURE,5.0,1.0
-APERTURE,6.0,1.0
-APERTURE,7.0,1.0
-APERTURE,8.0,0
-APERTURE,9.0,0
-APERTURE,10.0,0
-GeoMap,1.0,0
-GeoMap,2.0,1.0
-GeoMap,3.0,0
-GeoMap,4.0,0
-GeoMap,5.0,3.0
-GeoMap,6.0,1.0
-GeoMap,7.0,0
-GeoMap,8.0,0
-GeoMap,9.0,0
-GeoMap,10.0,0
-GeoMen,1.0,0
-GeoMen,2.0,1.0
-GeoMen,3.0,0
-GeoMen,4.0,1.0
-GeoMen,5.0,1.0
-GeoMen,6.0,0
-GeoMen,7.0,0
-GeoMen,8.0,0
-GeoMen,9.0,0
-GeoMen,10.0,0
-Influent,1.0,0
-Influent,2.0,1.0
-Influent,3.0,1.0
-Influent,4.0,0
-Influent,5.0,1.0
-Influent,6.0,0
-Influent,7.0,0
-Influent,8.0,0
-Influent,9.0,0
-Influent,10.0,0
-LineUP,1.0,0
-LineUP,2.0,0
-LineUP,3.0,0
-LineUP,4.0,1.0
-LineUP,5.0,0
-LineUP,6.0,0
-LineUP,7.0,0
-LineUP,8.0,0
-LineUP,9.0,0
-LineUP,10.0,0
-NEON,1.0,0
-NEON,2.0,1.0
-NEON,3.0,0
-NEON,4.0,0
-NEON,5.0,0
-NEON,6.0,2.0
-NEON,7.0,0
-NEON,8.0,0
-NEON,9.0,0
-NEON,10.0,0
-NEWMAN,1.0,0
-NEWMAN,2.0,0
-NEWMAN,3.0,0
-NEWMAN,4.0,0
-NEWMAN,5.0,0
-NEWMAN,6.0,1.0
-NEWMAN,7.0,0
-NEWMAN,8.0,0
-NEWMAN,9.0,0
-NEWMAN,10.0,0
-TrackCom,1.0,0
-TrackCom,2.0,0
-TrackCom,3.0,0
-TrackCom,4.0,1.0
-TrackCom,5.0,0
-TrackCom,6.0,4.0
-TrackCom,7.0,0
-TrackCom,8.0,0
-TrackCom,9.0,0
-TrackCom,10.0,0
diff --git a/static/javascript/data/load.csv b/static/javascript/data/load.csv
deleted file mode 100644
index bf5f649..0000000
--- a/static/javascript/data/load.csv
+++ /dev/null
@@ -1,41 +0,0 @@
-Tool,Range,Count
-APERTURE,1.0,0
-APERTURE,2.0,1.0
-APERTURE,3.0,3.0
-APERTURE,4.0,0
-APERTURE,5.0,0
-GeoMap,1.0,0
-GeoMap,2.0,0
-GeoMap,3.0,6.0
-GeoMap,4.0,0
-GeoMap,5.0,0
-GeoMen,1.0,0
-GeoMen,2.0,0
-GeoMen,3.0,4.0
-GeoMen,4.0,2.0
-GeoMen,5.0,0
-Influent,1.0,0
-Influent,2.0,1.0
-Influent,3.0,2.0
-Influent,4.0,0
-Influent,5.0,0
-LineUP,1.0,0
-LineUP,2.0,0
-LineUP,3.0,1.0
-LineUP,4.0,0
-LineUP,5.0,0
-NEON,1.0,0
-NEON,2.0,0
-NEON,3.0,3.0
-NEON,4.0,0
-NEON,5.0,0
-NEWMAN,1.0,0
-NEWMAN,2.0,0
-NEWMAN,3.0,1.0
-NEWMAN,4.0,0
-NEWMAN,5.0,0
-TrackCom,1.0,0
-TrackCom,2.0,1.0
-TrackCom,3.0,5.0
-TrackCom,4.0,1.0
-TrackCom,5.0,0
diff --git a/static/javascript/data/loadOT1.csv b/static/javascript/data/loadOT1.csv
deleted file mode 100644
index 8947e30..0000000
--- a/static/javascript/data/loadOT1.csv
+++ /dev/null
@@ -1,41 +0,0 @@
-Tool,Range,Count
-APERTURE,1.0,0
-APERTURE,2.0,1.0
-APERTURE,3.0,3.0
-APERTURE,4.0,0
-APERTURE,5.0,0
-GeoMap,1.0,0
-GeoMap,2.0,1.0
-GeoMap,3.0,3.0
-GeoMap,4.0,2.0
-GeoMap,5.0,0
-GeoMen,1.0,0
-GeoMen,2.0,1.0
-GeoMen,3.0,2.0
-GeoMen,4.0,2.0
-GeoMen,5.0,1.0
-Influent,1.0,0
-Influent,2.0,1.0
-Influent,3.0,0
-Influent,4.0,1.0
-Influent,5.0,0
-LineUP,1.0,0
-LineUP,2.0,1.0
-LineUP,3.0,0
-LineUP,4.0,0
-LineUP,5.0,0
-NEON,1.0,0
-NEON,2.0,3.0
-NEON,3.0,0
-NEON,4.0,0
-NEON,5.0,0
-NEWMAN,1.0,0
-NEWMAN,2.0,0
-NEWMAN,3.0,1.0
-NEWMAN,4.0,0
-NEWMAN,5.0,0
-TrackCom,1.0,0
-TrackCom,2.0,1.0
-TrackCom,3.0,2.0
-TrackCom,4.0,2.0
-TrackCom,5.0,0
diff --git a/static/javascript/data/loadOT2.csv b/static/javascript/data/loadOT2.csv
deleted file mode 100644
index 3d45554..0000000
--- a/static/javascript/data/loadOT2.csv
+++ /dev/null
@@ -1,41 +0,0 @@
-Tool,Range,Count
-APERTURE,1.0,0
-APERTURE,2.0,1.0
-APERTURE,3.0,3.0
-APERTURE,4.0,0
-APERTURE,5.0,0
-GeoMap,1.0,0
-GeoMap,2.0,0
-GeoMap,3.0,6.0
-GeoMap,4.0,0
-GeoMap,5.0,0
-GeoMen,1.0,0
-GeoMen,2.0,0
-GeoMen,3.0,2.0
-GeoMen,4.0,3.0
-GeoMen,5.0,0
-Influent,1.0,0
-Influent,2.0,0
-Influent,3.0,3.0
-Influent,4.0,0
-Influent,5.0,0
-LineUP,1.0,0
-LineUP,2.0,0
-LineUP,3.0,1.0
-LineUP,4.0,0
-LineUP,5.0,0
-NEON,1.0,0
-NEON,2.0,0
-NEON,3.0,3.0
-NEON,4.0,0
-NEON,5.0,0
-NEWMAN,1.0,0
-NEWMAN,2.0,0
-NEWMAN,3.0,1.0
-NEWMAN,4.0,0
-NEWMAN,5.0,0
-TrackCom,1.0,1.0
-TrackCom,2.0,0
-TrackCom,3.0,5.0
-TrackCom,4.0,1.0
-TrackCom,5.0,0
diff --git a/static/javascript/data/sortedYear2.csv b/static/javascript/data/sortedYear2.csv
deleted file mode 100644
index 72d12a7..0000000
--- a/static/javascript/data/sortedYear2.csv
+++ /dev/null
@@ -1,34 +0,0 @@
-Tool,Load,LoadOT1,LoadOT2,Difficulty,DifficultyOT1,DifficultyOT2
-GeoMap,2.944,2.64,3.4,4.166666667,3.333333333,5
-GeoMap,3.22,3.56,2.88,4.583333333,3.5,5.666666667
-TrackCom,2.68,1.6,3.4,5.5,5.333333333,5.666666667
-Influent,2.666666667,NA,2.666666667,2.5,2.666666667,2.333333333
-Influent,3.471428571,3.6,3.3,3,3,3
-GeoMen,2.875,2.6,3.15,NA,NA,NA
-APERTURE,3,2.6,3.4,5.166666667,5,5.333333333
-NEON,2.519047619,1.933333333,3.3,5.666666667,5.666666667,5.666666667
-GeoMen,3.033333333,2.466666667,3.6,6.333333333,6.333333333,NA
-Influent,NA,NA,NA,NA,NA,NA
-Influent,2.3,1.7,3.2,5.833333333,6.333333333,5.333333333
-NEON,2.685333333,1.733333333,3.32,5.166666667,4.333333333,6
-APERTURE,2.38,1.68,3.08,5.333333333,4,6.666666667
-GeoMap,3.36,3,3.48,1.666666667,NA,1.666666667
-APERTURE,2.84375,2.75,3,6,6.333333333,5.666666667
-TrackCom,2.92,NA,2.92,6.5,7,6
-TrackCom,3.525,3.55,3.5,7.666666667,9,6.333333333
-GeoMap,2.78,2.72,2.84,4.5,4.333333333,4.666666667
-TrackCom,3.378666667,3.466666667,3.32,6.333333333,NA,6.333333333
-GeoMap,2.858181818,2.4,3.24,5.166666667,5,5.333333333
-Influent,NA,NA,NA,NA,NA,NA
-GeoMap,3.26,3.56,2.96,NA,NA,NA
-GeoMen,3.433333333,3.1,3.6,4.5,4,5
-NEON,2.557333333,2.44,2.733333333,2.333333333,NA,2.333333333
-APERTURE,3.02,3.36,2,1.166666667,1.333333333,1
-TrackCom,3.2,NA,3.2,NA,NA,NA
-GeoMen,3.392857143,3.55,3,2.333333333,2.666666667,2
-TrackCom,2.166666667,3.7,1.4,NA,NA,NA
-GeoMen,4.355555556,4.8,3.8,6.333333333,6.333333333,NA
-GeoMen,3.6,3.6,NA,4.833333333,5.333333333,4.333333333
-NEWMAN,3.4,3.4,3.4,5.666666667,5.666666667,5.666666667
-LineUP,2.6,2.4,2.8,4.5,4.666666667,4.333333333
-TrackCom,3,3,3,4.833333333,5.666666667,4
diff --git a/static/javascript/data/sortedYear2.xlsx b/static/javascript/data/sortedYear2.xlsx
deleted file mode 100644
index 5a80919..0000000
--- a/static/javascript/data/sortedYear2.xlsx
+++ /dev/null
Binary files differ
diff --git a/static/javascript/data/year2.csv b/static/javascript/data/year2.csv
deleted file mode 100644
index b435bf2..0000000
--- a/static/javascript/data/year2.csv
+++ /dev/null
@@ -1,43 +0,0 @@
-Tool,Range,load,loadOT1,loadOT2,difficulty,difficultyOT1,difficultyOT2
-APERTURE,1.0,0,0,0,1.0,1.0,1.0
-APERTURE,2.0,1.0,1.0,1.0,0,0,0
-APERTURE,3.0,3.0,3.0,3.0,0,0,0
-APERTURE,4.0,0,0,0,0,1.0,0
-APERTURE,5.0,0,0,0,2.0,1.0,1.0
-APERTURE,6.0,0,0,0,1.0,1.0,1.0
-APERTURE,7.0,0,0,0,0,0,1.0
-GeoMap,2.0,0,1.0,0,1.0,0,1.0
-GeoMap,3.0,6.0,3.0,6.0,0,1.0,0
-GeoMap,4.0,0,2.0,0,2.0,2.0,0
-GeoMap,5.0,0,0,0,2.0,1.0,3.0
-GeoMap,6.0,0,0,0,0,0,1.0
-GeoMen,2.0,0,1.0,0,1.0,0,1.0
-GeoMen,3.0,4.0,2.0,2.0,0,1.0,0
-GeoMen,4.0,2.0,2.0,3.0,1.0,1.0,1.0
-GeoMen,5.0,0,1.0,0,1.0,1.0,1.0
-GeoMen,6.0,0,0,0,2.0,2.0,0
-Influent,2.0,1.0,1.0,0,1.0,0,1.0
-Influent,3.0,2.0,0,3.0,1.0,2.0,1.0
-Influent,4.0,0,1.0,0,0,0,0
-Influent,5.0,0,0,0,0,0,1.0
-Influent,6.0,0,0,0,1.0,1.0,0
-LineUP,2.0,0,1.0,0,0,0,0
-LineUP,3.0,1.0,0,1.0,0,0,0
-LineUP,4.0,0,0,0,1.0,0,1.0
-LineUP,5.0,0,0,0,0,1.0,0
-NEON,2.0,0,3.0,0,1.0,0,1.0
-NEON,3.0,3.0,0,3.0,0,0,0
-NEON,4.0,0,0,0,0,1.0,0
-NEON,5.0,0,0,0,1.0,0,0
-NEON,6.0,0,0,0,1.0,1.0,2.0
-NEWMAN,3.0,1.0,1.0,1.0,0,0,0
-NEWMAN,6.0,0,0,0,1.0,1.0,1.0
-TrackCom,1.0,0,0,1.0,0,0,0
-TrackCom,2.0,1.0,1.0,0,0,0,0
-TrackCom,3.0,5.0,2.0,5.0,0,0,0
-TrackCom,4.0,1.0,2.0,1.0,0,0,1.0
-TrackCom,5.0,0,0,0,1.0,1.0,0
-TrackCom,6.0,0,0,0,3.0,1.0,4.0
-TrackCom,7.0,0,0,0,0,1.0,0
-TrackCom,8.0,0,0,0,1.0,0,0
-TrackCom,9.0,0,0,0,0,1.0,0
diff --git a/static/javascript/fakeData/activityData.tsv b/static/javascript/fakeData/activityData.tsv
deleted file mode 100644
index 2bbfdc8..0000000
--- a/static/javascript/fakeData/activityData.tsv
+++ /dev/null
@@ -1,27 +0,0 @@
-letter frequency
-A .08167
-B .01492
-C .02782
-D .04253
-E .12702
-F .02288
-G .02015
-H .06094
-I .06966
-J .00153
-K .00772
-L .04025
-M .02406
-N .06749
-O .07507
-P .01929
-Q .00095
-R .05987
-S .06327
-T .09056
-U .02758
-V .00978
-W .02360
-X .00150
-Y .01974
-Z .00074
\ No newline at end of file
diff --git a/static/javascript/fakeData/confidenceData.tsv b/static/javascript/fakeData/confidenceData.tsv
deleted file mode 100644
index 2bbfdc8..0000000
--- a/static/javascript/fakeData/confidenceData.tsv
+++ /dev/null
@@ -1,27 +0,0 @@
-letter frequency
-A .08167
-B .01492
-C .02782
-D .04253
-E .12702
-F .02288
-G .02015
-H .06094
-I .06966
-J .00153
-K .00772
-L .04025
-M .02406
-N .06749
-O .07507
-P .01929
-Q .00095
-R .05987
-S .06327
-T .09056
-U .02758
-V .00978
-W .02360
-X .00150
-Y .01974
-Z .00074
\ No newline at end of file
diff --git a/static/javascript/fakeData/difficultyData.tsv b/static/javascript/fakeData/difficultyData.tsv
deleted file mode 100644
index 2bbfdc8..0000000
--- a/static/javascript/fakeData/difficultyData.tsv
+++ /dev/null
@@ -1,27 +0,0 @@
-letter frequency
-A .08167
-B .01492
-C .02782
-D .04253
-E .12702
-F .02288
-G .02015
-H .06094
-I .06966
-J .00153
-K .00772
-L .04025
-M .02406
-N .06749
-O .07507
-P .01929
-Q .00095
-R .05987
-S .06327
-T .09056
-U .02758
-V .00978
-W .02360
-X .00150
-Y .01974
-Z .00074
\ No newline at end of file
diff --git a/static/javascript/fakeData/loadData.tsv b/static/javascript/fakeData/loadData.tsv
deleted file mode 100644
index 7124dad..0000000
--- a/static/javascript/fakeData/loadData.tsv
+++ /dev/null
@@ -1,27 +0,0 @@
-letter frequency
-A .02568
-B .01492
-C .05642
-D .04253
-E .03564
-F .02288
-G .02015
-H .06094
-I .06966
-J .00153
-K .00772
-L .04025
-M .02406
-N .06749
-O .07507
-P .01929
-Q .00095
-R .05987
-S .06327
-T .09056
-U .02758
-V .00978
-W .02360
-X .00150
-Y .01974
-Z .00074
\ No newline at end of file
diff --git a/static/javascript/fakeData/performanceData.tsv b/static/javascript/fakeData/performanceData.tsv
deleted file mode 100644
index 2bbfdc8..0000000
--- a/static/javascript/fakeData/performanceData.tsv
+++ /dev/null
@@ -1,27 +0,0 @@
-letter frequency
-A .08167
-B .01492
-C .02782
-D .04253
-E .12702
-F .02288
-G .02015
-H .06094
-I .06966
-J .00153
-K .00772
-L .04025
-M .02406
-N .06749
-O .07507
-P .01929
-Q .00095
-R .05987
-S .06327
-T .09056
-U .02758
-V .00978
-W .02360
-X .00150
-Y .01974
-Z .00074
\ No newline at end of file
diff --git a/static/javascript/fakeData/timeData.tsv b/static/javascript/fakeData/timeData.tsv
deleted file mode 100644
index 2bbfdc8..0000000
--- a/static/javascript/fakeData/timeData.tsv
+++ /dev/null
@@ -1,27 +0,0 @@
-letter frequency
-A .08167
-B .01492
-C .02782
-D .04253
-E .12702
-F .02288
-G .02015
-H .06094
-I .06966
-J .00153
-K .00772
-L .04025
-M .02406
-N .06749
-O .07507
-P .01929
-Q .00095
-R .05987
-S .06327
-T .09056
-U .02758
-V .00978
-W .02360
-X .00150
-Y .01974
-Z .00074
\ No newline at end of file
diff --git a/static/javascript/uploads.js b/static/javascript/uploads.js
new file mode 100644
index 0000000..e9fb077
--- /dev/null
+++ b/static/javascript/uploads.js
@@ -0,0 +1,5 @@
+$("#existingExpNames").change(function(){
+ var val = $("#existingExpNames").val();
+ console.log(val);
+ $("#dirName").val(val);
+})
\ No newline at end of file
diff --git a/uploads/templates/expuploads.html b/uploads/templates/expuploads.html
new file mode 100644
index 0000000..bef9318
--- /dev/null
+++ b/uploads/templates/expuploads.html
@@ -0,0 +1,34 @@
+{% load staticfiles %}
+<!DOCTYPE html>
+<html>
+ <head>
+ <meta charset="utf-8">
+ <title>Master Answer Sheet Uploader</title>
+ <script src="//cdnjs.cloudflare.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
+ </head>
+ <body>
+
+ <!-- Upload form. Note enctype attribute! -->
+ <form action="{% url 'expuploads' %}" method="POST" enctype="multipart/form-data">
+ {% csrf_token %}
+ <div>
+ <h3>Folder:</h3>
+ <label for="dirName">Experiment Name:</label>
+ <input type="text" id="dirName" name="dirName">
+ <select id="existingExpNames">
+ <option></option>
+ {% for experiment in experiments %}
+ <option value="{{ experiment }}">{{ experiment }}</option>
+ {% endfor %}
+ </select>
+ </div>
+ <p>{{ form.non_field_errors }}</p>
+ <p>
+ {{ form.docfile.errors }}
+ {{ form.docfile }}
+ </p>
+ <p><input type="submit" value="Upload" /></p>
+ </form>
+ <script type="text/javascript" src="{% static "javascript/uploads.js" %}"></script>
+ </body>
+</html>
\ No newline at end of file
diff --git a/uploads/templates/list.html b/uploads/templates/list.html
deleted file mode 100644
index 3ecc8b7..0000000
--- a/uploads/templates/list.html
+++ /dev/null
@@ -1,32 +0,0 @@
-<!DOCTYPE html>
-<html>
- <head>
- <meta charset="utf-8">
- <title>Master Answer Sheet Uploader</title>
- </head>
- <body>
-
- <!-- Upload form. Note enctype attribute! -->
- <form action="{% url 'list' %}" method="POST" enctype="multipart/form-data">
- {% csrf_token %}
- <div>
- <h3>Folder:</h3>
- <label for="dirName">Exp Name:</label>
- <input type="text" name="dirName">
- <select id="existingExpNames">
- <option></option>
- {% for experiment in experiments %}
- <option>{{ experiment }}</option>
- }
- {% endfor %}
- </select>
- </div>
- <p>{{ form.non_field_errors }}</p>
- <p>
- {{ form.docfile.errors }}
- {{ form.docfile }}
- </p>
- <p><input type="submit" value="Upload" /></p>
- </form>
- </body>
-</html>
\ No newline at end of file
diff --git a/uploads/urls.py b/uploads/urls.py
index 88745b1..cdbfd83 100644
--- a/uploads/urls.py
+++ b/uploads/urls.py
@@ -3,5 +3,5 @@
from django.conf.urls.static import static
urlpatterns = patterns('uploads.views',
- url(r'^list/$', 'list', name='list'),
+ url(r'^expuploads/$', 'expuploads', name='expuploads'),
)
\ No newline at end of file
diff --git a/uploads/views.py b/uploads/views.py
index e994373..dbbc93d 100644
--- a/uploads/views.py
+++ b/uploads/views.py
@@ -3,37 +3,89 @@
from django.http import HttpResponseRedirect
from django.core.urlresolvers import reverse
from django.contrib.auth.decorators import login_required
-
+import pandas
+import numpy as np
import os
from models import Document
from forms import DocumentForm
@login_required(login_url='/tasking/login')
-def list(request):
- if request.user.is_staff:
- # Handle file uploads
- if request.method == 'POST':
- form = DocumentForm(request.POST, request.FILES)
- if form.is_valid():
- handle_uploaded_file(request.FILES, request.POST.get('dirName', 'error'))
+def expuploads(request):
+ # Handle file uploads
+ if request.method == 'POST':
+ form = DocumentForm(request.POST, request.FILES)
+ if form.is_valid():
+ handle_uploaded_file(request.FILES, request.POST.get('dirName', 'error'))
- # redirect to the document after POST
- return HttpResponseRedirect(reverse('uploads.views.list'))
+ # redirect to the document after POST
+ return HttpResponseRedirect(reverse('uploads.views.expuploads'))
- else:
- form = DocumentForm() # An empty, unbound form
- experiments = Experiment.objects.all()
- # Render list page with the documents and the form
- return render(request, 'list.html', {'form': form, 'experiments': experiments})
+ else:
+ form = DocumentForm() # An empty, unbound form
+ experiments = Experiment.objects.all()
+ # Render list page with the documents and the form
+ return render(request, 'expuploads.html', {'form': form, 'experiments': experiments})
+
def handle_uploaded_file(f, dirname):
- path = os.path.join('../', dirname)
+ path = os.path.join('../static/results', dirname)
try:
- os.mkdir(path)
- except:
- pass
+ os.makedirs(path)
+ except OSError as e:
+ print e
+ print 'unable to create directory ' + path
file = f['docfile']
- with open(path + '/' + file.name, 'wb+') as destination:
+ with open(path + '/' + file.name, 'wb+') as destination:
for chunk in file.chunks():
- destination.write(chunk)
\ No newline at end of file
+ destination.write(chunk)
+
+ # new code for parsing
+ data = pandas.read_csv(path + '/' + file.name)
+ cols = ['SYS.FIL.APP.','PST.EXP.CLD.CP.','PST.EXP.CLD.OT1.','PST.EXP.CLD.OT2.','PST.EXP.BED.CP.','PST.EXP.BED.OT1.',
+ 'PST.EXP.BED.OT2.','TSK.PRB.ANS.CP.','TSK.PRB.ANS.OT1.','TSK.PRB.ANS.OT2.','TSK.CON.CP.','TSK.CON.OT1.',
+ 'TSK.CON.OT2.','TSK.TIME.DIFF.CP.','TSK.TIME.DIFF.OT1.','TSK.TIME.DIFF.OT2.']
+ workingData = data[cols]
+ workingDataDF = pandas.DataFrame(workingData)
+ workingDataDF[['PST.EXP.CLD.CP.','PST.EXP.CLD.OT1.','PST.EXP.CLD.OT2.','PST.EXP.BED.CP.','PST.EXP.BED.OT1.',
+ 'PST.EXP.BED.OT2.','TSK.PRB.ANS.CP.','TSK.PRB.ANS.OT1.','TSK.PRB.ANS.OT2.','TSK.CON.CP.','TSK.CON.OT1.',
+ 'TSK.CON.OT2.','TSK.TIME.DIFF.CP.','TSK.TIME.DIFF.OT1.','TSK.TIME.DIFF.OT2.']] = np.around(workingDataDF[['PST.EXP.CLD.CP.','PST.EXP.CLD.OT1.','PST.EXP.CLD.OT2.','PST.EXP.BED.CP.','PST.EXP.BED.OT1.',
+ 'PST.EXP.BED.OT2.','TSK.PRB.ANS.CP.','TSK.PRB.ANS.OT1.','TSK.PRB.ANS.OT2.','TSK.CON.CP.','TSK.CON.OT1.',
+ 'TSK.CON.OT2.','TSK.TIME.DIFF.CP.','TSK.TIME.DIFF.OT1.','TSK.TIME.DIFF.OT2.']], 0)
+
+ tools = pandas.DataFrame(workingData['SYS.FIL.APP.']).drop_duplicates().sort('SYS.FIL.APP.').reset_index();
+ del tools['index']
+ tools.columns = ['Tools']
+ tools.to_json(path_or_buf=path + '/' + "tools.json")
+
+
+ metrics = {'load':{'col':'PST.EXP.CLD.CP.','max':5},
+ 'loadOT1':{'col':'PST.EXP.CLD.OT1.','max':5},
+ 'loadOT2':{'col':'PST.EXP.CLD.OT2.','max':5},
+ 'difficulty':{'col':'PST.EXP.BED.CP.','max':10},
+ 'difficultyOT1':{'col':'PST.EXP.BED.OT1.','max':10},
+ 'difficultyOT2':{'col':'PST.EXP.BED.OT2.','max':10},
+ 'performance':{'col':'TSK.PRB.ANS.CP.','max':10},
+ 'performanceOT1':{'col':'TSK.PRB.ANS.OT1.','max':10},
+ 'performanceOT2':{'col':'TSK.PRB.ANS.OT2.','max':10},
+ 'confidence':{'col':'TSK.CON.CP.','max':10},
+ 'confidenceOT1':{'col':'TSK.CON.OT1.','max':10},
+ 'confidenceOT2':{'col':'TSK.CON.OT2.','max':10},
+ 'time':{'col':'TSK.TIME.DIFF.CP.','max':10},
+ 'timeOT1':{'col':'TSK.TIME.DIFF.OT1.','max':10},
+ 'timeOT2':{'col':'TSK.TIME.DIFF.OT2.','max':10}}
+
+ for key, value in metrics.items():
+ df = pandas.DataFrame({key: workingDataDF.groupby(['SYS.FIL.APP.', value['col']], sort=0, as_index=False).size()}).reset_index()
+ df.columns = ['Tool', 'Range', 'Count']
+ df = df.sort(['Tool', 'Range'], ascending=[1, 1])
+ array = []
+ min = 1
+ for i in tools.Tools:
+ maxVal = int(value['max']) + 1
+ for j in range(1,maxVal):
+ subarray = [i, j]
+ array.append(subarray)
+ d = pandas.DataFrame(array, columns=('Tool', 'Range'))
+ result = pandas.ordered_merge(df,d)
+ result.to_csv(path_or_buf=path + '/' + str(key) + '.csv', sep=',',na_rep='0',index=False)
\ No newline at end of file
diff --git a/xdata/settings.py b/xdata/settings.py
index 776bfe7..4773429 100755
--- a/xdata/settings.py
+++ b/xdata/settings.py
@@ -48,6 +48,7 @@
'exp_portal',
'developer',
'uploads',
+ 'axes',
)
MIDDLEWARE_CLASSES = (
@@ -57,6 +58,7 @@
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
+ 'axes.middleware.FailedLoginMiddleware',
)
ROOT_URLCONF = 'xdata.urls'
@@ -74,9 +76,17 @@
# https://docs.djangoproject.com/en/1.6/ref/settings/#databases
DATABASES = {
+# 'default': {
+# 'ENGINE': 'django.db.backends.sqlite3',
+# 'NAME': os.path.join(BASE_DIR, '../db', 'db.sqlite3'),
+# }
'default': {
- 'ENGINE': 'django.db.backends.sqlite3',
- 'NAME': os.path.join(BASE_DIR, '../db', 'db.sqlite3'),
+ 'ENGINE': 'django.db.backends.postgresql_psycopg2',
+ 'NAME': 'xdatadb',
+ 'USER': 'xdatauser',
+ 'PASSWORD': 'xd@t@!',
+ 'HOST': '127.0.0.1',
+ 'PORT': '',
}
}
@@ -120,4 +130,9 @@
EMAIL_HOST = 'smtp.gmail.com'
EMAIL_HOST_USER = 'xdataonline@gmail.com'
EMAIL_HOST_PASSWORD = MY_EMAIL_PASSWORD
-EMAIL_PORT = 587
\ No newline at end of file
+EMAIL_PORT = 587
+
+# After three failed logins, require users to wait 5 minutes before they can attempt to log in again
+AXES_LOGIN_FAILURE_LIMIT = 3
+from datetime import timedelta
+AXES_COOLOFF_TIME=timedelta(seconds = 300)
diff --git a/xdata/urls.py b/xdata/urls.py
index b9feb46..6b8c79a 100755
--- a/xdata/urls.py
+++ b/xdata/urls.py
@@ -10,7 +10,7 @@
# include urls for op_tasks and administration pages
url(r'^tasking/', include('op_tasks.urls', namespace="op_tasks")),
url(r'^experiment/', include('exp_portal.urls', namespace="exp_portal")),
- url(r'^developer/', include('developer.urls', namespace="developer")),
+ # url(r'^developer/', include('developer.urls', namespace="developer")),
url(r'^user_feedback/', views.user_feedback_home, name='user_feedback_home'),
url(r'^admin/', include(admin.site.urls)),
url(r'^', include('uploads.urls')),
