Radial Organization Chart

README.md

Hover shows employee details, dims more recent hires, and tallies office distribution of similarly senior staff. Adapted from Radial Tidy Tree by M. Bostock. block

index.html

<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.4.13/d3.js"></script>
<link rel="icon" href="/favicon.png">
<style>

.node circle {
  fill: #fff;
  stroke: steelblue;
  stroke-width: 1.5px;
}

.node text {
  font: 10px sans-serif;
}

.link {
  fill: none;
  stroke: #ccc;
  stroke-opacity: 0.4;
  stroke-width: 1.5px;
}

th {
  text-align: right;
  padding-right: 10px;
}

#person_detail {
  margin-bottom: 16px;
}

#corner_tip {
  position: fixed;
  background-color: white;
  opacity: 0.9;
  padding: 10px;
}

</style>

<div id="d" style="position: relative; border: 0px solid green; width: <%= @diameter %>px; height: 900px; margin: 0px auto !important;">
  <div id="corner_tip">
    <div id="person_detail"></div>
    <table id="people_count_table"></table>
  </div>
</div>

<script>

  var diameter = 1200

  var tree = d3.layout.tree()
      .size([360, diameter / 2 - 120])
      .separation(function(a, b) { return (a.parent == b.parent ? 1 : 2) / a.depth; });

  var colorOrdinal = d3.scale.category20();

  var diagonal = d3.svg.diagonal.radial()
      .projection(function(d) { return [d.y, d.x / 180 * Math.PI]; });

  var svg = d3.select("#d").append("svg")
      .attr("width", diameter)
      .attr("height", diameter - 10)
    .append("g")
      .attr("transform", "translate(" + ((diameter/2)-60) + "," + ((diameter / 2) - 65) + ")");

  // python -m SimpleHTTPServer 8000
  d3.json( "organization.json" , function(error, people) {

    var this_start = null

    function lastName (name) { return name.replace(/\b[A-Z]\. /g,'') }

    function startsFirst (a,b) { return string_to_date(a.start) - string_to_date(b.start) }
    people.sort(startsFirst)

    var root
    function isManager (who) { return who.email == person.manager }
    for (var person of people) {
      var manager = people.find(isManager)
      if (!manager || person.email == manager.email) {
        root = person
      } else {
        manager.children = manager.children || []
        manager.children.push(person)
      }
    }

    var nodes = tree.nodes(root),
        links = tree.links(nodes)

    var link = svg.selectAll(".link")
        .data(links)
      .enter().append("path")
        .attr("class", "link")
        .attr("d", diagonal);

    var node = svg.selectAll(".node")
        .data(nodes)
        .attr("opacity",1)
        .enter().append("g")
        .attr("class", "node")
        .attr("transform", function(d) { return "rotate(" + (d.x - 90) + ")translate(" + d.y + ")"; })

    node.append("circle")
        .attr("r", 4)
        .attr("opacity",1)
        .style("fill", function(d) { return colorOrdinal(d.office) } )
        .on('click', find)

    function update_person (d) {
      d3.select("#person_detail")
        .html(
          "<table>"+
          "<tr><th>Name<td>"+d.name+
          "<tr><th>Office<td>"+d.office+
          "<tr><th>Start<td>"+d.start+
          "</table>")
    }
    function update_counts () {
      var peopleCount = {}
      var total = 0
      for (var person of people) {
        if (!this_start || string_to_date(person.start) <= this_start) {
          var office = person.office
          peopleCount[office] = peopleCount[office] || 0
          peopleCount[office]++
          total++
        }
      }
      var officeTuples = [];
      for (var office in peopleCount) {
        officeTuples.push([office, peopleCount[office]])
      }
      officeTuples.sort(function(a,b) {
        return a[0] > b[0] ? 1 : -1
      })
      var table = d3.select("#people_count_table")
      function row(tuple) {
        var tr = table.append("tr")
        var th = tr.append("th")
        var td = tr.append("td")
        var span = td.append("span")
        th.text(tuple[0]);
        span.html(tuple[1])
      }
      table.selectAll("*").remove()
      for (var tuple of officeTuples) {
        row(tuple)
      }
      row(['Total', total])
    }
    update_counts()

    node.append("text")
        .attr("dy", ".31em")
        .attr("opacity",1)
        .attr("text-anchor", function(d) { return d.x < 180 ? "start" : "end"; })
        .attr("transform", function(d) { return d.x < 180 ? "translate(8)" : "rotate(180)translate(-8)"; })
        .text(function(d) { return lastName(d.name) });

    node.selectAll("circle")
      .on("mouseover", function(d, i) {
        this_start = string_to_date(d.start);

        d3.transition().duration(300).selectAll(".node").attr("opacity",
          function(d){
            return string_to_date(d.start) > this_start ? .2 : 1;
          }
         )

        d3.transition().duration(300).selectAll(".circle").attr("opacity",
          function(d){
            if(string_to_date(d.start) > this_start){
              return .2
            } else {
              // Count people here
              return 1;
            }
          }
         )

        d3.select(this).attr("r", 7)

        update_person(d)
        update_counts()
      })

     node.selectAll("circle")
      .on("mouseout", function(d, i) {
        this_start = null

        d3.select(this).attr("r", 4)

        var d3Scale = d3.time.scale().domain([string_to_date(d.start), new Date() ]).range([0,2000]);

        d3.selectAll(".node").transition().attr("opacity",1).duration(0).delay(function(d,i) {
          return d3Scale(string_to_date(d.start));
         })

        d3.selectAll(".circle").transition().attr("opacity",1).duration(0).delay(function(d,i) {
          return d3Scale(string_to_date(d.start));
         })

        update_counts()
      })

  });

  function string_to_date(string_date){
    return new Date(string_date);
  }

  function find(person) {
    window.location = '//google.com?q=' + person.name
  }

</script>

organization.json

[
  {
    "name": "K. T. Richardson",
    "email": "ktrichardson@email.com",
    "manager": null,
    "start": "2007-10-26",
    "office": "PDX"
  },
  {
    "name": "F. A. Baker",
    "email": "fabaker@email.com",
    "manager": "ktrichardson@email.com",
    "start": "2002-10-9",
    "office": "PDX"
  },
  {
    "name": "K. D. Flores",
    "email": "kdflores@email.com",
    "manager": "fabaker@email.com",
    "start": "2014-2-9",
    "office": "PDX"
  },
  {
    "name": "B. F. Harris",
    "email": "bfharris@email.com",
    "manager": "fabaker@email.com",
    "start": "2000-4-3",
    "office": "ORD"
  },
  {
    "name": "O. C. Parker",
    "email": "ocparker@email.com",
    "manager": "fabaker@email.com",
    "start": "2003-5-12",
    "office": "PDX"
  },
  {
    "name": "S. M. Perry",
    "email": "smperry@email.com",
    "manager": "ocparker@email.com",
    "start": "2007-5-9",
    "office": "SFO"
  },
  {
    "name": "A. S. Jackson",
    "email": "asjackson@email.com",
    "manager": "ocparker@email.com",
    "start": "2007-3-5",
    "office": "PDX"
  },
  {
    "name": "H. A. Perry",
    "email": "haperry@email.com",
    "manager": "asjackson@email.com",
    "start": "2007-3-5",
    "office": "ORD"
  },
  {
    "name": "H. P. Collins",
    "email": "hpcollins@email.com",
    "manager": "asjackson@email.com",
    "start": "2015-6-13",
    "office": "PDX"
  },
  {
    "name": "A. O. Baker",
    "email": "aobaker@email.com",
    "manager": "asjackson@email.com",
    "start": "2003-8-5",
    "office": "PDX"
  },
  {
    "name": "C. I. Nguyen",
    "email": "cinguyen@email.com",
    "manager": "asjackson@email.com",
    "start": "2005-12-24",
    "office": "PDX"
  },
  {
    "name": "D. H. Martinez",
    "email": "dhmartinez@email.com",
    "manager": "asjackson@email.com",
    "start": "2014-4-15",
    "office": "ORD"
  },
  {
    "name": "C. H. Gonzalez",
    "email": "chgonzalez@email.com",
    "manager": "asjackson@email.com",
    "start": "2001-5-26",
    "office": "ORD"
  },
  {
    "name": "F. S. Anderson",
    "email": "fsanderson@email.com",
    "manager": "asjackson@email.com",
    "start": "2006-2-25",
    "office": "PDX"
  },
  {
    "name": "T. O. Price",
    "email": "toprice@email.com",
    "manager": "asjackson@email.com",
    "start": "2014-10-25",
    "office": "PDX"
  },
  {
    "name": "S. O. Gonzalez",
    "email": "sogonzalez@email.com",
    "manager": "asjackson@email.com",
    "start": "2005-3-23",
    "office": "PDX"
  },
  {
    "name": "R. D. Barnes",
    "email": "rdbarnes@email.com",
    "manager": "ocparker@email.com",
    "start": "2005-8-12",
    "office": "SFO"
  },
  {
    "name": "O. H. Ramirez",
    "email": "ohramirez@email.com",
    "manager": "rdbarnes@email.com",
    "start": "2007-9-25",
    "office": "SFO"
  },
  {
    "name": "T. D. Perry",
    "email": "tdperry@email.com",
    "manager": "rdbarnes@email.com",
    "start": "2006-9-16",
    "office": "SFO"
  },
  {
    "name": "N. N. Ramirez",
    "email": "nnramirez@email.com",
    "manager": "rdbarnes@email.com",
    "start": "2015-5-2",
    "office": "PDX"
  },
  {
    "name": "T. E. Cox",
    "email": "tecox@email.com",
    "manager": "rdbarnes@email.com",
    "start": "2012-12-14",
    "office": "SFO"
  },
  {
    "name": "G. N. Gomez",
    "email": "gngomez@email.com",
    "manager": "rdbarnes@email.com",
    "start": "2009-10-24",
    "office": "PDX"
  },
  {
    "name": "I. M. Ortiz",
    "email": "imortiz@email.com",
    "manager": "rdbarnes@email.com",
    "start": "2011-7-22",
    "office": "PDX"
  },
  {
    "name": "F. R. Wood",
    "email": "frwood@email.com",
    "manager": "rdbarnes@email.com",
    "start": "2006-5-6",
    "office": "SFO"
  },
  {
    "name": "H. B. Gray",
    "email": "hbgray@email.com",
    "manager": "rdbarnes@email.com",
    "start": "2010-12-3",
    "office": "PDX"
  },
  {
    "name": "W. I. Rogers",
    "email": "wirogers@email.com",
    "manager": "ocparker@email.com",
    "start": "2009-6-24",
    "office": "PDX"
  },
  {
    "name": "M. J. Hall",
    "email": "mjhall@email.com",
    "manager": "fabaker@email.com",
    "start": "2000-6-23",
    "office": "PDX"
  },
  {
    "name": "M. O. Foster",
    "email": "mofoster@email.com",
    "manager": "fabaker@email.com",
    "start": "2014-3-15",
    "office": "PDX"
  },
  {
    "name": "B. L. Bailey",
    "email": "blbailey@email.com",
    "manager": "fabaker@email.com",
    "start": "2013-12-26",
    "office": "PDX"
  },
  {
    "name": "T. D. Perez",
    "email": "tdperez@email.com",
    "manager": "ktrichardson@email.com",
    "start": "2003-7-9",
    "office": "SFO"
  },
  {
    "name": "L. E. Sullivan",
    "email": "lesullivan@email.com",
    "manager": "ktrichardson@email.com",
    "start": "2015-4-12",
    "office": "SFO"
  },
  {
    "name": "H. A. Cox",
    "email": "hacox@email.com",
    "manager": "lesullivan@email.com",
    "start": "2013-2-2",
    "office": "PDX"
  },
  {
    "name": "N. N. Brooks",
    "email": "nnbrooks@email.com",
    "manager": "hacox@email.com",
    "start": "2016-1-25",
    "office": "PDX"
  },
  {
    "name": "A. C. Torres",
    "email": "actorres@email.com",
    "manager": "nnbrooks@email.com",
    "start": "2001-5-7",
    "office": "SFO"
  },
  {
    "name": "R. O. Reyes",
    "email": "roreyes@email.com",
    "manager": "nnbrooks@email.com",
    "start": "2011-7-22",
    "office": "PDX"
  },
  {
    "name": "O. K. Cook",
    "email": "okcook@email.com",
    "manager": "nnbrooks@email.com",
    "start": "2001-2-26",
    "office": "SFO"
  },
  {
    "name": "K. I. Ortiz",
    "email": "kiortiz@email.com",
    "manager": "hacox@email.com",
    "start": "2009-11-5",
    "office": "PDX"
  },
  {
    "name": "N. P. Robinson",
    "email": "nprobinson@email.com",
    "manager": "kiortiz@email.com",
    "start": "2002-11-24",
    "office": "PDX"
  },
  {
    "name": "G. K. Richardson",
    "email": "gkrichardson@email.com",
    "manager": "kiortiz@email.com",
    "start": "2015-7-5",
    "office": "SFO"
  },
  {
    "name": "K. G. Cox",
    "email": "kgcox@email.com",
    "manager": "hacox@email.com",
    "start": "2000-10-12",
    "office": "PDX"
  },
  {
    "name": "G. I. Cox",
    "email": "gicox@email.com",
    "manager": "hacox@email.com",
    "start": "2006-8-19",
    "office": "PDX"
  },
  {
    "name": "T. M. Cox",
    "email": "tmcox@email.com",
    "manager": "hacox@email.com",
    "start": "2009-10-2",
    "office": "PDX"
  },
  {
    "name": "P. L. Flores",
    "email": "plflores@email.com",
    "manager": "tmcox@email.com",
    "start": "2007-3-2",
    "office": "PDX"
  },
  {
    "name": "D. S. Campbell",
    "email": "dscampbell@email.com",
    "manager": "tmcox@email.com",
    "start": "2005-4-10",
    "office": "SFO"
  },
  {
    "name": "C. C. Fisher",
    "email": "ccfisher@email.com",
    "manager": "tmcox@email.com",
    "start": "2001-1-7",
    "office": "PDX"
  },
  {
    "name": "A. J. Clark",
    "email": "ajclark@email.com",
    "manager": "tmcox@email.com",
    "start": "2004-1-19",
    "office": "SFO"
  },
  {
    "name": "W. O. Sanchez",
    "email": "wosanchez@email.com",
    "manager": "tmcox@email.com",
    "start": "2016-1-21",
    "office": "ORD"
  },
  {
    "name": "K. E. Walker",
    "email": "kewalker@email.com",
    "manager": "hacox@email.com",
    "start": "2013-10-21",
    "office": "PDX"
  },
  {
    "name": "G. J. Miller",
    "email": "gjmiller@email.com",
    "manager": "kewalker@email.com",
    "start": "2015-1-27",
    "office": "PDX"
  },
  {
    "name": "J. D. Morris",
    "email": "jdmorris@email.com",
    "manager": "kewalker@email.com",
    "start": "2016-2-29",
    "office": "SFO"
  },
  {
    "name": "T. P. Price",
    "email": "tpprice@email.com",
    "manager": "kewalker@email.com",
    "start": "2014-7-9",
    "office": "PDX"
  },
  {
    "name": "N. C. Stewart",
    "email": "ncstewart@email.com",
    "manager": "kewalker@email.com",
    "start": "2000-10-8",
    "office": "SFO"
  },
  {
    "name": "A. B. Parker",
    "email": "abparker@email.com",
    "manager": "kewalker@email.com",
    "start": "2003-5-16",
    "office": "SFO"
  },
  {
    "name": "F. K. Gomez",
    "email": "fkgomez@email.com",
    "manager": "kewalker@email.com",
    "start": "2005-1-3",
    "office": "PDX"
  },
  {
    "name": "G. L. Davis",
    "email": "gldavis@email.com",
    "manager": "kewalker@email.com",
    "start": "2000-12-13",
    "office": "SFO"
  },
  {
    "name": "C. L. Ross",
    "email": "clross@email.com",
    "manager": "kewalker@email.com",
    "start": "2016-5-4",
    "office": "SFO"
  },
  {
    "name": "E. K. Nelson",
    "email": "eknelson@email.com",
    "manager": "kewalker@email.com",
    "start": "2001-8-23",
    "office": "SFO"
  },
  {
    "name": "A. O. Cook",
    "email": "aocook@email.com",
    "manager": "kewalker@email.com",
    "start": "2007-5-21",
    "office": "SFO"
  },
  {
    "name": "O. F. Gonzalez",
    "email": "ofgonzalez@email.com",
    "manager": "hacox@email.com",
    "start": "2012-9-12",
    "office": "PDX"
  },
  {
    "name": "M. S. Morris",
    "email": "msmorris@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2001-10-19",
    "office": "PDX"
  },
  {
    "name": "D. S. Garcia",
    "email": "dsgarcia@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2012-2-4",
    "office": "SFO"
  },
  {
    "name": "H. E. Phillips",
    "email": "hephillips@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2003-2-7",
    "office": "PDX"
  },
  {
    "name": "R. L. Cruz",
    "email": "rlcruz@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2007-9-17",
    "office": "SFO"
  },
  {
    "name": "H. E. Torres",
    "email": "hetorres@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2009-3-26",
    "office": "PDX"
  },
  {
    "name": "T. P. Jackson",
    "email": "tpjackson@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2015-9-14",
    "office": "SFO"
  },
  {
    "name": "J. T. Ramirez",
    "email": "jtramirez@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2005-6-10",
    "office": "PDX"
  },
  {
    "name": "I. P. Rogers",
    "email": "iprogers@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2013-11-7",
    "office": "PDX"
  },
  {
    "name": "H. M. Collins",
    "email": "hmcollins@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2010-4-26",
    "office": "PDX"
  },
  {
    "name": "E. C. Wood",
    "email": "ecwood@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2013-2-8",
    "office": "PDX"
  },
  {
    "name": "F. I. Collins",
    "email": "ficollins@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2001-8-25",
    "office": "SFO"
  },
  {
    "name": "N. D. Harris",
    "email": "ndharris@email.com",
    "manager": "ofgonzalez@email.com",
    "start": "2015-7-14",
    "office": "SFO"
  },
  {
    "name": "L. O. Mitchell",
    "email": "lomitchell@email.com",
    "manager": "hacox@email.com",
    "start": "2016-10-29",
    "office": "PDX"
  },
  {
    "name": "W. R. Parker",
    "email": "wrparker@email.com",
    "manager": "hacox@email.com",
    "start": "2004-10-3",
    "office": "PDX"
  },
  {
    "name": "P. W. Carter",
    "email": "pwcarter@email.com",
    "manager": "hacox@email.com",
    "start": "2006-6-28",
    "office": "SFO"
  },
  {
    "name": "E. R. Torres",
    "email": "ertorres@email.com",
    "manager": "lesullivan@email.com",
    "start": "2006-5-25",
    "office": "ORD"
  },
  {
    "name": "C. M. Kelly",
    "email": "cmkelly@email.com",
    "manager": "ertorres@email.com",
    "start": "2002-10-14",
    "office": "SFO"
  },
  {
    "name": "J. J. Cooper",
    "email": "jjcooper@email.com",
    "manager": "cmkelly@email.com",
    "start": "2010-3-3",
    "office": "SFO"
  },
  {
    "name": "O. T. Richardson",
    "email": "otrichardson@email.com",
    "manager": "cmkelly@email.com",
    "start": "2009-9-26",
    "office": "PDX"
  },
  {
    "name": "P. M. Nguyen",
    "email": "pmnguyen@email.com",
    "manager": "cmkelly@email.com",
    "start": "2009-10-6",
    "office": "PDX"
  },
  {
    "name": "P. R. Wilson",
    "email": "prwilson@email.com",
    "manager": "cmkelly@email.com",
    "start": "2013-10-4",
    "office": "ORD"
  },
  {
    "name": "G. G. Powell",
    "email": "ggpowell@email.com",
    "manager": "cmkelly@email.com",
    "start": "2004-5-15",
    "office": "PDX"
  },
  {
    "name": "W. B. Fisher",
    "email": "wbfisher@email.com",
    "manager": "cmkelly@email.com",
    "start": "2010-5-21",
    "office": "PDX"
  },
  {
    "name": "F. A. Russell",
    "email": "farussell@email.com",
    "manager": "cmkelly@email.com",
    "start": "2002-4-6",
    "office": "SFO"
  },
  {
    "name": "A. D. Perez",
    "email": "adperez@email.com",
    "manager": "cmkelly@email.com",
    "start": "2009-3-4",
    "office": "SFO"
  },
  {
    "name": "M. W. Diaz",
    "email": "mwdiaz@email.com",
    "manager": "cmkelly@email.com",
    "start": "2009-12-9",
    "office": "PDX"
  },
  {
    "name": "F. O. Collins",
    "email": "focollins@email.com",
    "manager": "cmkelly@email.com",
    "start": "2000-11-2",
    "office": "SFO"
  },
  {
    "name": "M. A. Torres",
    "email": "matorres@email.com",
    "manager": "cmkelly@email.com",
    "start": "2010-5-6",
    "office": "PDX"
  },
  {
    "name": "I. O. Anderson",
    "email": "ioanderson@email.com",
    "manager": "cmkelly@email.com",
    "start": "2008-1-13",
    "office": "SFO"
  },
  {
    "name": "E. C. Perez",
    "email": "ecperez@email.com",
    "manager": "cmkelly@email.com",
    "start": "2011-1-12",
    "office": "PDX"
  },
  {
    "name": "N. L. Ward",
    "email": "nlward@email.com",
    "manager": "cmkelly@email.com",
    "start": "2006-9-10",
    "office": "PDX"
  },
  {
    "name": "F. L. Powell",
    "email": "flpowell@email.com",
    "manager": "ertorres@email.com",
    "start": "2016-3-19",
    "office": "PDX"
  },
  {
    "name": "B. G. Baker",
    "email": "bgbaker@email.com",
    "manager": "ertorres@email.com",
    "start": "2001-12-23",
    "office": "SFO"
  },
  {
    "name": "J. M. Ramirez",
    "email": "jmramirez@email.com",
    "manager": "ertorres@email.com",
    "start": "2015-7-12",
    "office": "SFO"
  },
  {
    "name": "F. F. Ward",
    "email": "ffward@email.com",
    "manager": "ertorres@email.com",
    "start": "2004-10-4",
    "office": "SFO"
  },
  {
    "name": "W. S. Nelson",
    "email": "wsnelson@email.com",
    "manager": "ffward@email.com",
    "start": "2003-12-26",
    "office": "SFO"
  },
  {
    "name": "G. P. Martin",
    "email": "gpmartin@email.com",
    "manager": "ffward@email.com",
    "start": "2009-1-18",
    "office": "PDX"
  },
  {
    "name": "D. W. Powell",
    "email": "dwpowell@email.com",
    "manager": "ertorres@email.com",
    "start": "2012-5-23",
    "office": "SFO"
  },
  {
    "name": "D. E. Wood",
    "email": "dewood@email.com",
    "manager": "ertorres@email.com",
    "start": "2015-8-28",
    "office": "PDX"
  },
  {
    "name": "N. D. Parker",
    "email": "ndparker@email.com",
    "manager": "dewood@email.com",
    "start": "2015-8-14",
    "office": "PDX"
  },
  {
    "name": "B. O. Phillips",
    "email": "bophillips@email.com",
    "manager": "dewood@email.com",
    "start": "2007-3-2",
    "office": "SFO"
  },
  {
    "name": "M. G. Rogers",
    "email": "mgrogers@email.com",
    "manager": "dewood@email.com",
    "start": "2007-9-13",
    "office": "PDX"
  },
  {
    "name": "T. P. Gomez",
    "email": "tpgomez@email.com",
    "manager": "dewood@email.com",
    "start": "2011-11-8",
    "office": "ORD"
  },
  {
    "name": "I. L. Bennett",
    "email": "ilbennett@email.com",
    "manager": "ertorres@email.com",
    "start": "2014-3-19",
    "office": "PDX"
  },
  {
    "name": "P. H. Ortiz",
    "email": "phortiz@email.com",
    "manager": "ertorres@email.com",
    "start": "2008-4-28",
    "office": "ORD"
  },
  {
    "name": "J. M. Wright",
    "email": "jmwright@email.com",
    "manager": "ertorres@email.com",
    "start": "2002-9-17",
    "office": "PDX"
  },
  {
    "name": "P. P. Morris",
    "email": "ppmorris@email.com",
    "manager": "jmwright@email.com",
    "start": "2001-1-8",
    "office": "SFO"
  },
  {
    "name": "N. S. Diaz",
    "email": "nsdiaz@email.com",
    "manager": "jmwright@email.com",
    "start": "2008-2-16",
    "office": "PDX"
  },
  {
    "name": "W. F. Williams",
    "email": "wfwilliams@email.com",
    "manager": "jmwright@email.com",
    "start": "2000-1-13",
    "office": "ORD"
  },
  {
    "name": "R. R. Powell",
    "email": "rrpowell@email.com",
    "manager": "jmwright@email.com",
    "start": "2016-2-9",
    "office": "PDX"
  },
  {
    "name": "O. K. Gonzalez",
    "email": "okgonzalez@email.com",
    "manager": "jmwright@email.com",
    "start": "2007-2-8",
    "office": "PDX"
  },
  {
    "name": "S. J. Morris",
    "email": "sjmorris@email.com",
    "manager": "ertorres@email.com",
    "start": "2016-8-21",
    "office": "SFO"
  },
  {
    "name": "T. J. Robinson",
    "email": "tjrobinson@email.com",
    "manager": "lesullivan@email.com",
    "start": "2002-12-24",
    "office": "SFO"
  },
  {
    "name": "I. A. Scott",
    "email": "iascott@email.com",
    "manager": "lesullivan@email.com",
    "start": "2013-9-8",
    "office": "SFO"
  },
  {
    "name": "F. E. Hall",
    "email": "fehall@email.com",
    "manager": "iascott@email.com",
    "start": "2014-3-11",
    "office": "SFO"
  },
  {
    "name": "M. R. Bennett",
    "email": "mrbennett@email.com",
    "manager": "fehall@email.com",
    "start": "2008-5-11",
    "office": "SFO"
  },
  {
    "name": "R. B. Hill",
    "email": "rbhill@email.com",
    "manager": "fehall@email.com",
    "start": "2008-8-26",
    "office": "PDX"
  },
  {
    "name": "S. E. Morgan",
    "email": "semorgan@email.com",
    "manager": "fehall@email.com",
    "start": "2014-11-28",
    "office": "ORD"
  },
  {
    "name": "C. T. Baker",
    "email": "ctbaker@email.com",
    "manager": "fehall@email.com",
    "start": "2004-10-26",
    "office": "SFO"
  },
  {
    "name": "K. W. Gonzalez",
    "email": "kwgonzalez@email.com",
    "manager": "fehall@email.com",
    "start": "2015-1-26",
    "office": "PDX"
  },
  {
    "name": "N. L. Wright",
    "email": "nlwright@email.com",
    "manager": "iascott@email.com",
    "start": "2007-10-3",
    "office": "PDX"
  },
  {
    "name": "K. B. Brown",
    "email": "kbbrown@email.com",
    "manager": "nlwright@email.com",
    "start": "2016-12-13",
    "office": "PDX"
  },
  {
    "name": "S. F. Richardson",
    "email": "sfrichardson@email.com",
    "manager": "nlwright@email.com",
    "start": "2000-7-28",
    "office": "PDX"
  },
  {
    "name": "R. S. Perry",
    "email": "rsperry@email.com",
    "manager": "nlwright@email.com",
    "start": "2003-8-1",
    "office": "PDX"
  },
  {
    "name": "G. S. Moore",
    "email": "gsmoore@email.com",
    "manager": "nlwright@email.com",
    "start": "2000-9-5",
    "office": "SFO"
  },
  {
    "name": "J. D. Brooks",
    "email": "jdbrooks@email.com",
    "manager": "nlwright@email.com",
    "start": "2005-8-22",
    "office": "PDX"
  },
  {
    "name": "S. A. Cruz",
    "email": "sacruz@email.com",
    "manager": "nlwright@email.com",
    "start": "2014-10-18",
    "office": "ORD"
  },
  {
    "name": "R. D. Bailey",
    "email": "rdbailey@email.com",
    "manager": "nlwright@email.com",
    "start": "2012-3-19",
    "office": "PDX"
  },
  {
    "name": "W. R. Lopez",
    "email": "wrlopez@email.com",
    "manager": "nlwright@email.com",
    "start": "2010-5-1",
    "office": "PDX"
  },
  {
    "name": "T. K. Rogers",
    "email": "tkrogers@email.com",
    "manager": "nlwright@email.com",
    "start": "2005-7-13",
    "office": "SFO"
  },
  {
    "name": "N. H. Baker",
    "email": "nhbaker@email.com",
    "manager": "nlwright@email.com",
    "start": "2002-9-7",
    "office": "SFO"
  },
  {
    "name": "W. S. Williams",
    "email": "wswilliams@email.com",
    "manager": "iascott@email.com",
    "start": "2014-2-21",
    "office": "SFO"
  },
  {
    "name": "C. O. Clark",
    "email": "coclark@email.com",
    "manager": "wswilliams@email.com",
    "start": "2013-2-19",
    "office": "PDX"
  },
  {
    "name": "H. K. Johnson",
    "email": "hkjohnson@email.com",
    "manager": "wswilliams@email.com",
    "start": "2012-2-9",
    "office": "PDX"
  },
  {
    "name": "R. G. Cruz",
    "email": "rgcruz@email.com",
    "manager": "wswilliams@email.com",
    "start": "2009-7-10",
    "office": "SFO"
  },
  {
    "name": "K. E. Brown",
    "email": "kebrown@email.com",
    "manager": "wswilliams@email.com",
    "start": "2009-1-13",
    "office": "PDX"
  },
  {
    "name": "E. G. Jackson",
    "email": "egjackson@email.com",
    "manager": "wswilliams@email.com",
    "start": "2008-5-4",
    "office": "PDX"
  },
  {
    "name": "H. T. Bennett",
    "email": "htbennett@email.com",
    "manager": "wswilliams@email.com",
    "start": "2008-9-17",
    "office": "PDX"
  },
  {
    "name": "G. T. Watson",
    "email": "gtwatson@email.com",
    "manager": "iascott@email.com",
    "start": "2006-4-20",
    "office": "PDX"
  },
  {
    "name": "R. A. Ward",
    "email": "raward@email.com",
    "manager": "lesullivan@email.com",
    "start": "2003-10-18",
    "office": "PDX"
  },
  {
    "name": "D. G. Peterson",
    "email": "dgpeterson@email.com",
    "manager": "lesullivan@email.com",
    "start": "2010-11-9",
    "office": "PDX"
  },
  {
    "name": "F. H. Walker",
    "email": "fhwalker@email.com",
    "manager": "lesullivan@email.com",
    "start": "2006-7-19",
    "office": "ORD"
  },
  {
    "name": "M. C. Gutierrez",
    "email": "mcgutierrez@email.com",
    "manager": "ktrichardson@email.com",
    "start": "2002-8-22",
    "office": "ORD"
  },
  {
    "name": "P. D. Nguyen",
    "email": "pdnguyen@email.com",
    "manager": "ktrichardson@email.com",
    "start": "2009-2-12",
    "office": "PDX"
  },
  {
    "name": "N. P. Lopez",
    "email": "nplopez@email.com",
    "manager": "pdnguyen@email.com",
    "start": "2005-8-6",
    "office": "SFO"
  },
  {
    "name": "P. P. Ramirez",
    "email": "ppramirez@email.com",
    "manager": "pdnguyen@email.com",
    "start": "2015-12-17",
    "office": "SFO"
  },
  {
    "name": "P. O. Green",
    "email": "pogreen@email.com",
    "manager": "pdnguyen@email.com",
    "start": "2016-12-11",
    "office": "ORD"
  },
  {
    "name": "S. A. Gray",
    "email": "sagray@email.com",
    "manager": "pdnguyen@email.com",
    "start": "2005-5-5",
    "office": "PDX"
  },
  {
    "name": "K. M. Collins",
    "email": "kmcollins@email.com",
    "manager": "pdnguyen@email.com",
    "start": "2014-6-11",
    "office": "PDX"
  },
  {
    "name": "J. T. Watson",
    "email": "jtwatson@email.com",
    "manager": "kmcollins@email.com",
    "start": "2001-3-27",
    "office": "PDX"
  },
  {
    "name": "K. E. Peterson",
    "email": "kepeterson@email.com",
    "manager": "kmcollins@email.com",
    "start": "2002-10-4",
    "office": "SFO"
  },
  {
    "name": "S. C. Gray",
    "email": "scgray@email.com",
    "manager": "kmcollins@email.com",
    "start": "2009-12-18",
    "office": "PDX"
  },
  {
    "name": "A. E. Gray",
    "email": "aegray@email.com",
    "manager": "kmcollins@email.com",
    "start": "2004-3-26",
    "office": "PDX"
  },
  {
    "name": "R. T. Rogers",
    "email": "rtrogers@email.com",
    "manager": "kmcollins@email.com",
    "start": "2001-5-1",
    "office": "ORD"
  },
  {
    "name": "W. J. Johnson",
    "email": "wjjohnson@email.com",
    "manager": "rtrogers@email.com",
    "start": "2011-6-19",
    "office": "PDX"
  },
  {
    "name": "R. H. Phillips",
    "email": "rhphillips@email.com",
    "manager": "rtrogers@email.com",
    "start": "2009-1-10",
    "office": "SFO"
  },
  {
    "name": "G. T. Reed",
    "email": "gtreed@email.com",
    "manager": "rtrogers@email.com",
    "start": "2014-9-19",
    "office": "SFO"
  },
  {
    "name": "E. T. Harris",
    "email": "etharris@email.com",
    "manager": "rtrogers@email.com",
    "start": "2011-6-8",
    "office": "PDX"
  },
  {
    "name": "F. K. Jones",
    "email": "fkjones@email.com",
    "manager": "rtrogers@email.com",
    "start": "2004-4-11",
    "office": "PDX"
  },
  {
    "name": "J. S. Barnes",
    "email": "jsbarnes@email.com",
    "manager": "rtrogers@email.com",
    "start": "2004-6-23",
    "office": "SFO"
  },
  {
    "name": "B. P. Ramirez",
    "email": "bpramirez@email.com",
    "manager": "rtrogers@email.com",
    "start": "2002-1-10",
    "office": "PDX"
  },
  {
    "name": "G. P. Baker",
    "email": "gpbaker@email.com",
    "manager": "rtrogers@email.com",
    "start": "2012-3-2",
    "office": "ORD"
  },
  {
    "name": "E. O. Sullivan",
    "email": "eosullivan@email.com",
    "manager": "rtrogers@email.com",
    "start": "2005-12-7",
    "office": "SFO"
  },
  {
    "name": "L. I. Scott",
    "email": "liscott@email.com",
    "manager": "rtrogers@email.com",
    "start": "2004-8-3",
    "office": "PDX"
  },
  {
    "name": "H. F. Sullivan",
    "email": "hfsullivan@email.com",
    "manager": "rtrogers@email.com",
    "start": "2004-11-3",
    "office": "SFO"
  },
  {
    "name": "F. B. Russell",
    "email": "fbrussell@email.com",
    "manager": "kmcollins@email.com",
    "start": "2002-11-18",
    "office": "PDX"
  },
  {
    "name": "I. S. Gomez",
    "email": "isgomez@email.com",
    "manager": "fbrussell@email.com",
    "start": "2012-6-18",
    "office": "SFO"
  },
  {
    "name": "I. J. Brown",
    "email": "ijbrown@email.com",
    "manager": "fbrussell@email.com",
    "start": "2004-6-19",
    "office": "SFO"
  },
  {
    "name": "N. F. Lewis",
    "email": "nflewis@email.com",
    "manager": "fbrussell@email.com",
    "start": "2004-10-5",
    "office": "SFO"
  },
  {
    "name": "P. O. Reyes",
    "email": "poreyes@email.com",
    "manager": "fbrussell@email.com",
    "start": "2006-1-4",
    "office": "PDX"
  },
  {
    "name": "L. F. Morgan",
    "email": "lfmorgan@email.com",
    "manager": "fbrussell@email.com",
    "start": "2014-9-16",
    "office": "SFO"
  },
  {
    "name": "A. P. Ortiz",
    "email": "aportiz@email.com",
    "manager": "fbrussell@email.com",
    "start": "2005-8-28",
    "office": "SFO"
  },
  {
    "name": "L. F. Young",
    "email": "lfyoung@email.com",
    "manager": "fbrussell@email.com",
    "start": "2006-12-25",
    "office": "PDX"
  },
  {
    "name": "S. K. Hernandez",
    "email": "skhernandez@email.com",
    "manager": "fbrussell@email.com",
    "start": "2009-11-5",
    "office": "PDX"
  },
  {
    "name": "G. N. Davis",
    "email": "gndavis@email.com",
    "manager": "kmcollins@email.com",
    "start": "2015-9-8",
    "office": "PDX"
  },
  {
    "name": "O. I. Thomas",
    "email": "oithomas@email.com",
    "manager": "gndavis@email.com",
    "start": "2014-10-13",
    "office": "PDX"
  },
  {
    "name": "I. N. Moore",
    "email": "inmoore@email.com",
    "manager": "gndavis@email.com",
    "start": "2011-7-22",
    "office": "SFO"
  },
  {
    "name": "D. D. Garcia",
    "email": "ddgarcia@email.com",
    "manager": "gndavis@email.com",
    "start": "2003-1-29",
    "office": "PDX"
  },
  {
    "name": "O. J. Williams",
    "email": "ojwilliams@email.com",
    "manager": "gndavis@email.com",
    "start": "2007-1-1",
    "office": "SFO"
  },
  {
    "name": "A. E. Jackson",
    "email": "aejackson@email.com",
    "manager": "gndavis@email.com",
    "start": "2000-3-6",
    "office": "SFO"
  },
  {
    "name": "K. M. Hall",
    "email": "kmhall@email.com",
    "manager": "gndavis@email.com",
    "start": "2013-10-29",
    "office": "SFO"
  },
  {
    "name": "N. I. Ramirez",
    "email": "niramirez@email.com",
    "manager": "kmcollins@email.com",
    "start": "2016-3-24",
    "office": "SFO"
  },
  {
    "name": "O. F. Nguyen",
    "email": "ofnguyen@email.com",
    "manager": "kmcollins@email.com",
    "start": "2009-6-20",
    "office": "ORD"
  },
  {
    "name": "J. I. Murphy",
    "email": "jimurphy@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2006-9-9",
    "office": "SFO"
  },
  {
    "name": "F. B. Adams",
    "email": "fbadams@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2008-9-13",
    "office": "SFO"
  },
  {
    "name": "H. T. Scott",
    "email": "htscott@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2005-9-4",
    "office": "PDX"
  },
  {
    "name": "G. H. Sanchez",
    "email": "ghsanchez@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2004-7-13",
    "office": "PDX"
  },
  {
    "name": "H. H. Moore",
    "email": "hhmoore@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2011-3-4",
    "office": "PDX"
  },
  {
    "name": "J. P. Edwards",
    "email": "jpedwards@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2012-2-5",
    "office": "PDX"
  },
  {
    "name": "S. A. Gomez",
    "email": "sagomez@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2006-3-2",
    "office": "PDX"
  },
  {
    "name": "R. B. Nelson",
    "email": "rbnelson@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2008-5-1",
    "office": "SFO"
  },
  {
    "name": "K. R. Martin",
    "email": "krmartin@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2009-7-13",
    "office": "PDX"
  },
  {
    "name": "P. I. Gonzalez",
    "email": "pigonzalez@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2005-7-3",
    "office": "PDX"
  },
  {
    "name": "G. W. Cruz",
    "email": "gwcruz@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2012-8-19",
    "office": "SFO"
  },
  {
    "name": "C. F. Clark",
    "email": "cfclark@email.com",
    "manager": "ofnguyen@email.com",
    "start": "2006-6-10",
    "office": "SFO"
  },
  {
    "name": "N. B. Hernandez",
    "email": "nbhernandez@email.com",
    "manager": "pdnguyen@email.com",
    "start": "2009-11-7",
    "office": "PDX"
  },
  {
    "name": "H. F. Powell",
    "email": "hfpowell@email.com",
    "manager": "pdnguyen@email.com",
    "start": "2000-5-11",
    "office": "ORD"
  },
  {
    "name": "W. E. Clark",
    "email": "weclark@email.com",
    "manager": "hfpowell@email.com",
    "start": "2007-2-14",
    "office": "PDX"
  },
  {
    "name": "S. A. Peterson",
    "email": "sapeterson@email.com",
    "manager": "weclark@email.com",
    "start": "2000-5-18",
    "office": "PDX"
  },
  {
    "name": "A. M. Peterson",
    "email": "ampeterson@email.com",
    "manager": "weclark@email.com",
    "start": "2015-4-18",
    "office": "PDX"
  },
  {
    "name": "H. S. Sanchez",
    "email": "hssanchez@email.com",
    "manager": "weclark@email.com",
    "start": "2010-11-4",
    "office": "PDX"
  },
  {
    "name": "F. D. Campbell",
    "email": "fdcampbell@email.com",
    "manager": "weclark@email.com",
    "start": "2006-6-15",
    "office": "PDX"
  },
  {
    "name": "O. S. Edwards",
    "email": "osedwards@email.com",
    "manager": "weclark@email.com",
    "start": "2012-8-5",
    "office": "PDX"
  },
  {
    "name": "D. M. Brooks",
    "email": "dmbrooks@email.com",
    "manager": "weclark@email.com",
    "start": "2015-9-20",
    "office": "PDX"
  },
  {
    "name": "F. T. Hall",
    "email": "fthall@email.com",
    "manager": "hfpowell@email.com",
    "start": "2008-10-3",
    "office": "PDX"
  },
  {
    "name": "L. B. Butler",
    "email": "lbbutler@email.com",
    "manager": "fthall@email.com",
    "start": "2011-12-11",
    "office": "ORD"
  },
  {
    "name": "A. E. Gomez",
    "email": "aegomez@email.com",
    "manager": "hfpowell@email.com",
    "start": "2010-6-23",
    "office": "SFO"
  },
  {
    "name": "D. T. Evans",
    "email": "dtevans@email.com",
    "manager": "hfpowell@email.com",
    "start": "2008-9-11",
    "office": "SFO"
  },
  {
    "name": "B. D. Thompson",
    "email": "bdthompson@email.com",
    "manager": "dtevans@email.com",
    "start": "2011-11-15",
    "office": "PDX"
  },
  {
    "name": "D. M. Thompson",
    "email": "dmthompson@email.com",
    "manager": "dtevans@email.com",
    "start": "2008-8-20",
    "office": "PDX"
  },
  {
    "name": "J. O. Green",
    "email": "jogreen@email.com",
    "manager": "dtevans@email.com",
    "start": "2007-12-5",
    "office": "PDX"
  },
  {
    "name": "I. A. Morris",
    "email": "iamorris@email.com",
    "manager": "dtevans@email.com",
    "start": "2008-7-26",
    "office": "PDX"
  },
  {
    "name": "H. C. Ward",
    "email": "hcward@email.com",
    "manager": "pdnguyen@email.com",
    "start": "2010-7-16",
    "office": "ORD"
  },
  {
    "name": "D. I. Johnson",
    "email": "dijohnson@email.com",
    "manager": "hcward@email.com",
    "start": "2006-10-7",
    "office": "PDX"
  },
  {
    "name": "H. E. Collins",
    "email": "hecollins@email.com",
    "manager": "dijohnson@email.com",
    "start": "2013-3-18",
    "office": "SFO"
  },
  {
    "name": "L. O. Johnson",
    "email": "lojohnson@email.com",
    "manager": "dijohnson@email.com",
    "start": "2012-11-23",
    "office": "PDX"
  },
  {
    "name": "D. D. White",
    "email": "ddwhite@email.com",
    "manager": "dijohnson@email.com",
    "start": "2008-2-9",
    "office": "SFO"
  },
  {
    "name": "W. E. Perry",
    "email": "weperry@email.com",
    "manager": "dijohnson@email.com",
    "start": "2007-10-19",
    "office": "PDX"
  },
  {
    "name": "I. H. Robinson",
    "email": "ihrobinson@email.com",
    "manager": "dijohnson@email.com",
    "start": "2004-3-23",
    "office": "SFO"
  },
  {
    "name": "B. E. Martin",
    "email": "bemartin@email.com",
    "manager": "dijohnson@email.com",
    "start": "2015-6-20",
    "office": "PDX"
  },
  {
    "name": "G. J. Gonzalez",
    "email": "gjgonzalez@email.com",
    "manager": "dijohnson@email.com",
    "start": "2001-8-13",
    "office": "SFO"
  },
  {
    "name": "E. O. Richardson",
    "email": "eorichardson@email.com",
    "manager": "dijohnson@email.com",
    "start": "2005-6-27",
    "office": "SFO"
  },
  {
    "name": "N. K. Robinson",
    "email": "nkrobinson@email.com",
    "manager": "dijohnson@email.com",
    "start": "2013-10-20",
    "office": "SFO"
  },
  {
    "name": "E. S. Cooper",
    "email": "escooper@email.com",
    "manager": "hcward@email.com",
    "start": "2008-1-6",
    "office": "PDX"
  },
  {
    "name": "S. K. Brown",
    "email": "skbrown@email.com",
    "manager": "hcward@email.com",
    "start": "2005-6-12",
    "office": "PDX"
  },
  {
    "name": "B. G. Green",
    "email": "bggreen@email.com",
    "manager": "skbrown@email.com",
    "start": "2005-3-20",
    "office": "PDX"
  },
  {
    "name": "J. A. Thomas",
    "email": "jathomas@email.com",
    "manager": "skbrown@email.com",
    "start": "2008-2-21",
    "office": "SFO"
  },
  {
    "name": "N. O. Lopez",
    "email": "nolopez@email.com",
    "manager": "skbrown@email.com",
    "start": "2006-5-6",
    "office": "PDX"
  },
  {
    "name": "N. B. Murphy",
    "email": "nbmurphy@email.com",
    "manager": "skbrown@email.com",
    "start": "2004-7-3",
    "office": "SFO"
  },
  {
    "name": "E. T. Morris",
    "email": "etmorris@email.com",
    "manager": "hcward@email.com",
    "start": "2013-8-21",
    "office": "PDX"
  },
  {
    "name": "B. R. Parker",
    "email": "brparker@email.com",
    "manager": "etmorris@email.com",
    "start": "2007-2-5",
    "office": "ORD"
  },
  {
    "name": "B. J. Davis",
    "email": "bjdavis@email.com",
    "manager": "etmorris@email.com",
    "start": "2002-12-27",
    "office": "SFO"
  },
  {
    "name": "C. L. Smith",
    "email": "clsmith@email.com",
    "manager": "etmorris@email.com",
    "start": "2004-12-29",
    "office": "PDX"
  },
  {
    "name": "G. F. Lewis",
    "email": "gflewis@email.com",
    "manager": "etmorris@email.com",
    "start": "2010-7-6",
    "office": "PDX"
  },
  {
    "name": "M. S. Roberts",
    "email": "msroberts@email.com",
    "manager": "etmorris@email.com",
    "start": "2002-10-28",
    "office": "SFO"
  },
  {
    "name": "S. D. Jenkins",
    "email": "sdjenkins@email.com",
    "manager": "etmorris@email.com",
    "start": "2002-1-6",
    "office": "PDX"
  },
  {
    "name": "L. R. Rivera",
    "email": "lrrivera@email.com",
    "manager": "etmorris@email.com",
    "start": "2000-2-17",
    "office": "PDX"
  },
  {
    "name": "G. O. Anderson",
    "email": "goanderson@email.com",
    "manager": "etmorris@email.com",
    "start": "2001-2-17",
    "office": "PDX"
  },
  {
    "name": "C. S. Evans",
    "email": "csevans@email.com",
    "manager": "hcward@email.com",
    "start": "2008-6-24",
    "office": "SFO"
  },
  {
    "name": "H. O. Gomez",
    "email": "hogomez@email.com",
    "manager": "csevans@email.com",
    "start": "2004-7-17",
    "office": "PDX"
  },
  {
    "name": "P. O. Perez",
    "email": "poperez@email.com",
    "manager": "csevans@email.com",
    "start": "2002-11-20",
    "office": "PDX"
  },
  {
    "name": "K. T. Hughes",
    "email": "kthughes@email.com",
    "manager": "csevans@email.com",
    "start": "2000-2-21",
    "office": "SFO"
  },
  {
    "name": "I. R. Perez",
    "email": "irperez@email.com",
    "manager": "csevans@email.com",
    "start": "2003-9-1",
    "office": "SFO"
  },
  {
    "name": "W. O. Miller",
    "email": "womiller@email.com",
    "manager": "hcward@email.com",
    "start": "2005-7-27",
    "office": "PDX"
  },
  {
    "name": "G. R. Anderson",
    "email": "granderson@email.com",
    "manager": "womiller@email.com",
    "start": "2006-6-16",
    "office": "SFO"
  },
  {
    "name": "P. R. Johnson",
    "email": "prjohnson@email.com",
    "manager": "womiller@email.com",
    "start": "2002-10-22",
    "office": "ORD"
  },
  {
    "name": "M. I. Johnson",
    "email": "mijohnson@email.com",
    "manager": "womiller@email.com",
    "start": "2004-7-2",
    "office": "PDX"
  },
  {
    "name": "C. E. Stewart",
    "email": "cestewart@email.com",
    "manager": "womiller@email.com",
    "start": "2012-12-17",
    "office": "ORD"
  },
  {
    "name": "I. O. Rogers",
    "email": "iorogers@email.com",
    "manager": "womiller@email.com",
    "start": "2008-8-24",
    "office": "SFO"
  },
  {
    "name": "T. M. Cook",
    "email": "tmcook@email.com",
    "manager": "womiller@email.com",
    "start": "2016-4-3",
    "office": "PDX"
  },
  {
    "name": "E. G. Morris",
    "email": "egmorris@email.com",
    "manager": "womiller@email.com",
    "start": "2016-6-8",
    "office": "SFO"
  },
  {
    "name": "R. T. Carter",
    "email": "rtcarter@email.com",
    "manager": "womiller@email.com",
    "start": "2004-12-12",
    "office": "SFO"
  },
  {
    "name": "A. G. Gomez",
    "email": "aggomez@email.com",
    "manager": "hcward@email.com",
    "start": "2004-3-22",
    "office": "PDX"
  },
  {
    "name": "N. A. Cox",
    "email": "nacox@email.com",
    "manager": "hcward@email.com",
    "start": "2003-8-10",
    "office": "ORD"
  },
  {
    "name": "E. F. Richardson",
    "email": "efrichardson@email.com",
    "manager": "hcward@email.com",
    "start": "2004-2-3",
    "office": "PDX"
  },
  {
    "name": "A. J. Powell",
    "email": "ajpowell@email.com",
    "manager": "efrichardson@email.com",
    "start": "2006-9-17",
    "office": "SFO"
  },
  {
    "name": "G. T. Johnson",
    "email": "gtjohnson@email.com",
    "manager": "hcward@email.com",
    "start": "2016-8-18",
    "office": "SFO"
  },
  {
    "name": "A. D. Hernandez",
    "email": "adhernandez@email.com",
    "manager": "hcward@email.com",
    "start": "2002-4-29",
    "office": "PDX"
  },
  {
    "name": "S. E. Evans",
    "email": "seevans@email.com",
    "manager": "pdnguyen@email.com",
    "start": "2011-12-19",
    "office": "PDX"
  },
  {
    "name": "I. S. Adams",
    "email": "isadams@email.com",
    "manager": "seevans@email.com",
    "start": "2013-9-10",
    "office": "SFO"
  },
  {
    "name": "L. I. Robinson",
    "email": "lirobinson@email.com",
    "manager": "isadams@email.com",
    "start": "2009-10-17",
    "office": "PDX"
  },
  {
    "name": "G. F. Cruz",
    "email": "gfcruz@email.com",
    "manager": "isadams@email.com",
    "start": "2016-6-16",
    "office": "PDX"
  },
  {
    "name": "S. H. Myers",
    "email": "shmyers@email.com",
    "manager": "isadams@email.com",
    "start": "2014-5-15",
    "office": "SFO"
  },
  {
    "name": "J. C. Miller",
    "email": "jcmiller@email.com",
    "manager": "isadams@email.com",
    "start": "2010-5-29",
    "office": "SFO"
  },
  {
    "name": "I. G. Gutierrez",
    "email": "iggutierrez@email.com",
    "manager": "isadams@email.com",
    "start": "2004-10-2",
    "office": "PDX"
  },
  {
    "name": "K. N. Williams",
    "email": "knwilliams@email.com",
    "manager": "isadams@email.com",
    "start": "2012-8-2",
    "office": "PDX"
  },
  {
    "name": "L. P. Clark",
    "email": "lpclark@email.com",
    "manager": "isadams@email.com",
    "start": "2015-10-13",
    "office": "PDX"
  },
  {
    "name": "L. A. Carter",
    "email": "lacarter@email.com",
    "manager": "seevans@email.com",
    "start": "2008-6-27",
    "office": "PDX"
  },
  {
    "name": "L. B. Rogers",
    "email": "lbrogers@email.com",
    "manager": "seevans@email.com",
    "start": "2006-5-19",
    "office": "PDX"
  },
  {
    "name": "G. A. Jenkins",
    "email": "gajenkins@email.com",
    "manager": "lbrogers@email.com",
    "start": "2015-4-8",
    "office": "SFO"
  },
  {
    "name": "O. A. Torres",
    "email": "oatorres@email.com",
    "manager": "lbrogers@email.com",
    "start": "2004-6-21",
    "office": "SFO"
  },
  {
    "name": "R. S. Foster",
    "email": "rsfoster@email.com",
    "manager": "lbrogers@email.com",
    "start": "2001-6-17",
    "office": "ORD"
  },
  {
    "name": "D. F. Ward",
    "email": "dfward@email.com",
    "manager": "lbrogers@email.com",
    "start": "2007-12-11",
    "office": "ORD"
  },
  {
    "name": "M. E. Barnes",
    "email": "mebarnes@email.com",
    "manager": "lbrogers@email.com",
    "start": "2005-4-25",
    "office": "PDX"
  },
  {
    "name": "P. D. Lee",
    "email": "pdlee@email.com",
    "manager": "lbrogers@email.com",
    "start": "2009-3-22",
    "office": "PDX"
  },
  {
    "name": "K. E. Carter",
    "email": "kecarter@email.com",
    "manager": "lbrogers@email.com",
    "start": "2007-12-17",
    "office": "PDX"
  },
  {
    "name": "K. K. Ortiz",
    "email": "kkortiz@email.com",
    "manager": "lbrogers@email.com",
    "start": "2012-7-11",
    "office": "SFO"
  },
  {
    "name": "O. W. Green",
    "email": "owgreen@email.com",
    "manager": "seevans@email.com",
    "start": "2000-6-11",
    "office": "PDX"
  },
  {
    "name": "N. H. Campbell",
    "email": "nhcampbell@email.com",
    "manager": "owgreen@email.com",
    "start": "2014-6-22",
    "office": "PDX"
  },
  {
    "name": "O. W. Wilson",
    "email": "owwilson@email.com",
    "manager": "owgreen@email.com",
    "start": "2014-6-17",
    "office": "SFO"
  },
  {
    "name": "C. W. Perry",
    "email": "cwperry@email.com",
    "manager": "owgreen@email.com",
    "start": "2007-3-8",
    "office": "PDX"
  },
  {
    "name": "P. E. Clark",
    "email": "peclark@email.com",
    "manager": "owgreen@email.com",
    "start": "2015-5-14",
    "office": "ORD"
  },
  {
    "name": "K. M. Jackson",
    "email": "kmjackson@email.com",
    "manager": "owgreen@email.com",
    "start": "2007-1-16",
    "office": "PDX"
  },
  {
    "name": "P. W. Garcia",
    "email": "pwgarcia@email.com",
    "manager": "owgreen@email.com",
    "start": "2009-10-19",
    "office": "PDX"
  },
  {
    "name": "N. S. Miller",
    "email": "nsmiller@email.com",
    "manager": "owgreen@email.com",
    "start": "2003-4-19",
    "office": "SFO"
  },
  {
    "name": "I. R. Mitchell",
    "email": "irmitchell@email.com",
    "manager": "owgreen@email.com",
    "start": "2012-1-18",
    "office": "PDX"
  },
  {
    "name": "T. J. Adams",
    "email": "tjadams@email.com",
    "manager": "seevans@email.com",
    "start": "2012-5-8",
    "office": "PDX"
  },
  {
    "name": "B. T. Gray",
    "email": "btgray@email.com",
    "manager": "seevans@email.com",
    "start": "2000-11-7",
    "office": "PDX"
  },
  {
    "name": "N. N. Watson",
    "email": "nnwatson@email.com",
    "manager": "ktrichardson@email.com",
    "start": "2015-3-11",
    "office": "PDX"
  },
  {
    "name": "O. J. White",
    "email": "ojwhite@email.com",
    "manager": "nnwatson@email.com",
    "start": "2009-10-18",
    "office": "SFO"
  },
  {
    "name": "K. W. Ortiz",
    "email": "kwortiz@email.com",
    "manager": "ojwhite@email.com",
    "start": "2012-1-18",
    "office": "ORD"
  },
  {
    "name": "L. H. Foster",
    "email": "lhfoster@email.com",
    "manager": "ojwhite@email.com",
    "start": "2005-5-12",
    "office": "PDX"
  },
  {
    "name": "C. M. Reyes",
    "email": "cmreyes@email.com",
    "manager": "ojwhite@email.com",
    "start": "2015-1-18",
    "office": "PDX"
  },
  {
    "name": "N. F. Ward",
    "email": "nfward@email.com",
    "manager": "cmreyes@email.com",
    "start": "2007-10-27",
    "office": "PDX"
  },
  {
    "name": "L. L. Evans",
    "email": "llevans@email.com",
    "manager": "ojwhite@email.com",
    "start": "2011-12-9",
    "office": "SFO"
  },
  {
    "name": "N. L. Price",
    "email": "nlprice@email.com",
    "manager": "llevans@email.com",
    "start": "2016-1-18",
    "office": "SFO"
  },
  {
    "name": "S. J. Lee",
    "email": "sjlee@email.com",
    "manager": "llevans@email.com",
    "start": "2008-9-9",
    "office": "SFO"
  },
  {
    "name": "P. K. Rodriguez",
    "email": "pkrodriguez@email.com",
    "manager": "llevans@email.com",
    "start": "2006-1-16",
    "office": "ORD"
  },
  {
    "name": "J. F. Perry",
    "email": "jfperry@email.com",
    "manager": "llevans@email.com",
    "start": "2013-12-20",
    "office": "PDX"
  },
  {
    "name": "S. C. Turner",
    "email": "scturner@email.com",
    "manager": "llevans@email.com",
    "start": "2012-10-18",
    "office": "PDX"
  },
  {
    "name": "T. N. Jones",
    "email": "tnjones@email.com",
    "manager": "llevans@email.com",
    "start": "2015-9-3",
    "office": "SFO"
  },
  {
    "name": "P. C. Jackson",
    "email": "pcjackson@email.com",
    "manager": "llevans@email.com",
    "start": "2016-6-27",
    "office": "PDX"
  },
  {
    "name": "B. L. Stewart",
    "email": "blstewart@email.com",
    "manager": "ojwhite@email.com",
    "start": "2012-10-4",
    "office": "SFO"
  },
  {
    "name": "R. P. Lopez",
    "email": "rplopez@email.com",
    "manager": "nnwatson@email.com",
    "start": "2001-8-13",
    "office": "PDX"
  },
  {
    "name": "T. I. Wilson",
    "email": "tiwilson@email.com",
    "manager": "rplopez@email.com",
    "start": "2002-6-27",
    "office": "PDX"
  },
  {
    "name": "I. L. Morris",
    "email": "ilmorris@email.com",
    "manager": "rplopez@email.com",
    "start": "2016-5-2",
    "office": "PDX"
  },
  {
    "name": "W. I. Lopez",
    "email": "wilopez@email.com",
    "manager": "rplopez@email.com",
    "start": "2012-6-5",
    "office": "ORD"
  },
  {
    "name": "L. A. Gonzalez",
    "email": "lagonzalez@email.com",
    "manager": "wilopez@email.com",
    "start": "2008-11-1",
    "office": "PDX"
  },
  {
    "name": "M. G. Roberts",
    "email": "mgroberts@email.com",
    "manager": "wilopez@email.com",
    "start": "2013-3-9",
    "office": "SFO"
  },
  {
    "name": "D. I. Lopez",
    "email": "dilopez@email.com",
    "manager": "wilopez@email.com",
    "start": "2011-11-19",
    "office": "ORD"
  },
  {
    "name": "R. F. Martin",
    "email": "rfmartin@email.com",
    "manager": "wilopez@email.com",
    "start": "2006-8-14",
    "office": "SFO"
  },
  {
    "name": "O. J. Myers",
    "email": "ojmyers@email.com",
    "manager": "wilopez@email.com",
    "start": "2002-3-5",
    "office": "SFO"
  },
  {
    "name": "J. D. Morris",
    "email": "jdmorris@email.com",
    "manager": "wilopez@email.com",
    "start": "2014-2-17",
    "office": "PDX"
  },
  {
    "name": "N. L. Brooks",
    "email": "nlbrooks@email.com",
    "manager": "wilopez@email.com",
    "start": "2009-7-27",
    "office": "PDX"
  },
  {
    "name": "T. N. Lewis",
    "email": "tnlewis@email.com",
    "manager": "wilopez@email.com",
    "start": "2014-4-3",
    "office": "PDX"
  },
  {
    "name": "N. E. Edwards",
    "email": "needwards@email.com",
    "manager": "wilopez@email.com",
    "start": "2015-11-6",
    "office": "SFO"
  },
  {
    "name": "D. O. Hall",
    "email": "dohall@email.com",
    "manager": "rplopez@email.com",
    "start": "2015-3-15",
    "office": "PDX"
  },
  {
    "name": "S. I. Cook",
    "email": "sicook@email.com",
    "manager": "dohall@email.com",
    "start": "2002-10-21",
    "office": "PDX"
  },
  {
    "name": "N. B. Lewis",
    "email": "nblewis@email.com",
    "manager": "dohall@email.com",
    "start": "2014-6-7",
    "office": "PDX"
  },
  {
    "name": "B. O. Nelson",
    "email": "bonelson@email.com",
    "manager": "dohall@email.com",
    "start": "2011-1-8",
    "office": "PDX"
  },
  {
    "name": "D. A. Lewis",
    "email": "dalewis@email.com",
    "manager": "dohall@email.com",
    "start": "2001-3-3",
    "office": "SFO"
  },
  {
    "name": "S. K. Martin",
    "email": "skmartin@email.com",
    "manager": "dohall@email.com",
    "start": "2004-12-15",
    "office": "SFO"
  },
  {
    "name": "L. K. Reyes",
    "email": "lkreyes@email.com",
    "manager": "dohall@email.com",
    "start": "2011-9-25",
    "office": "ORD"
  },
  {
    "name": "H. T. Carter",
    "email": "htcarter@email.com",
    "manager": "nnwatson@email.com",
    "start": "2002-7-11",
    "office": "SFO"
  },
  {
    "name": "J. T. Jackson",
    "email": "jtjackson@email.com",
    "manager": "ktrichardson@email.com",
    "start": "2000-7-1",
    "office": "PDX"
  }
]

preview.png

thumbnail.png