title: Filter HTML Table Values with Dropdown Using JQuery
body: <p>I am new to coding and have had trouble finding the answer to this question.  I think my lack of industry vocabulary is limiting my ability to properly search for the solution.. I've searched for two days.</p>
  
  <p>I have a simple HTML table displaying data from my firebase database.  The table looks something like this:</p>
  
  <pre><code>Date       Google   Yelp   Bing
  -----------------------------------
  Mar 2015     1       3      2
  Feb 2015     4       0      2
  Jan 2015     0       6      1
  </code></pre>
  
  <p>The above table is representative of where our medical practice receives its patients each month.  We are an office of four doctors.</p>
  
  <p>QUESTION: I'd like to create a dropdown at the top of the table with a list of each doc's name.  When I choose the doctor, the table updates automatically with only the stats for that doctor.</p>
  
  <p>How do I solve this?  How do I filter my data?  I'd be super happy if someone could point me in the right direction.</p>
  
  <p>LIMITATIONS: I am learning  HTML, CSS, JAVASCRIPT, and JQUERY and would like to limit my answer using only those languages.</p>
  
  <p>FIREBASE DATABASE: Below is a snippet of the firebase export... notice how each patient is entered into the db as a unique object (ie. "-JlItUSK...").</p>
  
  <p>Then what I do is query the db like this: If the date is march 2015, and the channel is 'Internet', display it in this table cell.</p>
  
  <p>But when I showed this amazing referral tracker to the doctors, their immediate response was: "can I filter by my name?" and "what if I only want to see the female patients - can I filter by gender?"</p>
  
  <p>So, to reiterate my question: how do I create a dropdown that will re-query the database and show the new data based upon the doctor's filter choice?</p>
  
  <pre><code>{
    "entries" : {
      "-JlItUSK9n-GD70XAyGz" : {
        "age" : "22",
        "channel" : "null",
        "country" : "USA",
        "date" : "2010-02-26",
        "doctor" : "bh",
        "gender" : "female",
        "initials" : "OW",
        "source" : "Insurance",
        "zip" : "90047"
      },
      "-JlIy5378hYrzPpIw0Ll" : {
        "age" : "12",
        "channel" : "Google",
        "country" : "USA",
        "date" : "2014-05-26",
        "doctor" : "lc",
        "gender" : "male",
        "initials" : "FN",
        "source" : "Internet",
        "zip" : "90029"
      },
      "-JlIzkfSxx9XdVzC74x7" : {
        "age" : "12",
        "channel" : "Bing",
        "country" : "USA",
        "date" : "2011-11-26",
        "doctor" : "bh",
        "gender" : "male",
        "initials" : "SI",
        "source" : "Internet",
        "zip" : "90021"
      }
    }
  }
  </code></pre>