var dbLookup = {};

dbLookup["platform"] = (function(){
    var rawData = [{"id": 2, "name": "Twitter"}, {"id": 1, "name": "Facebook"}];
    return {
        getRaw : function(){ return rawData; },
        getIdToNameLookup : function(){ return rawData.reduce((acc, item) => { acc[item.id] = item.name; return acc; }, {}) },
        get_by_id : function(id){ return rawData.filter(x => { return x.id === id; }).shift(); }
    }
})();

dbLookup["party"] = (function(){
    var rawData = [{"id": "I", "name": "Independent"}, {"id": "G", "name": "Green"}, {"id": "R", "name": "Republican"}, {"id": "L", "name": "Libertarian"}, {"id": "D", "name": "Democratic"}];
    return {
        getRaw : function(){ return rawData; },
        getIdToNameLookup : function(){ return rawData.reduce((acc, item) => { acc[item.id] = item.name; return acc; }, {}) },
        get_by_id : function(id){ return rawData.filter(x => { return x.id === id; }).shift(); }
    }
})();

dbLookup["topic"] = (function(){
    var rawData = [{"id": "economic", "name": "Economic"}, {"id": "social_programs", "name": "Social Programs"}, {"id": "environment", "name": "Environment"}, {"id": "military", "name": "Military"}, {"id": "immigration", "name": "Immigration"}, {"id": "foreign_policy", "name": "Foreign Policy"}, {"id": "safety", "name": "Safety"}, {"id": "social_and_cultural", "name": "Social Cultural"}];
    return {
        getRaw : function(){ return rawData; },
        getIdToNameLookup : function(){ return rawData.reduce((acc, item) => { acc[item.id] = item.name; return acc; }, {}) },
        get_by_id : function(id){ return rawData.filter(x => { return x.id === id; }).shift(); }
    }
})();

dbLookup["message_type"] = (function(){
    var rawData = [{"id": "endorsement", "name": "Endorsement"}, {"id": "conversational", "name": "Conversational"}, {"id": "issue", "name": "Issue"}, {"id": "image", "name": "Image"}, {"id": "informative", "name": "Campaign Info"}, {"id": "ceremonial", "name": "Ceremonial"}, {"id": "attack", "name": "Attack"}, {"id": "call_to_action", "name": "Call to Action"}, {"id": "advocacy", "name": "Advocacy"}];
    return {
        getRaw : function(){ return rawData; },
        getIdToNameLookup : function(){ return rawData.reduce((acc, item) => { acc[item.id] = item.name; return acc; }, {}) },
        get_by_id : function(id){ return rawData.filter(x => { return x.id === id; }).shift(); }
    }
})();

dbLookup["candidate"] = (function(){
    var rawData = [{"id": 25, "runningmate_id": null, "name": "Rick Santorum", "website": "http://www.ricksantorum.com/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1958, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-05-27", "primary_campaign_end": "2016-02-04", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "44746457369", "facebook_name": "RickSantorum", "facebook_category": "Politician", "twitter_id": "58379000", "twitter_name": "RickSantorum"}, {"id": 27, "runningmate_id": 3, "name": "Ted Cruz", "website": "https://www.tedcruz.org/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1970, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-03-23", "primary_campaign_end": "2016-05-03", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "69983322463", "facebook_name": "tedcruzpage", "facebook_category": "Politician", "twitter_id": "23022687", "twitter_name": "tedcruz"}, {"id": 11, "runningmate_id": null, "name": "Jeb Bush", "website": "https://Jeb2016.com", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1953, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-06-15", "primary_campaign_end": "2016-02-20", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "210257445769973", "facebook_name": "jebbush", "facebook_category": "Public Figure", "twitter_id": "113047940", "twitter_name": "JebBush"}, {"id": 17, "runningmate_id": null, "name": "Lincoln Chafee", "website": "http://www.chafee2016.com", "party_id": "D", "gender_id": "M", "is_white": true, "born_in": 1953, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-06-03", "primary_campaign_end": "2015-10-23", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "567712886701894", "facebook_name": "chafee2016", "facebook_category": "Politician", "twitter_id": "89781370", "twitter_name": "LincolnChafee"}, {"id": 33, "runningmate_id": 28, "name": "Ajamu Baraka", "website": "https://www.ajamubaraka.com", "party_id": "G", "gender_id": "M", "is_white": false, "born_in": 1953, "primary_campaign_id": null, "primary_campaign_start": null, "primary_campaign_end": null, "general_campaign_id": "2016_3", "general_campaign_start": "2016-08-01", "general_campaign_end": "2016-11-09", "facebook_id": "544311182270733", "facebook_name": "AjamuBarakaVP", "facebook_category": "News Personality", "twitter_id": "4303298356", "twitter_name": "ajamubaraka"}, {"id": 31, "runningmate_id": null, "name": "Lawrence Lessig", "website": "http://lessig2016.us", "party_id": "D", "gender_id": "M", "is_white": true, "born_in": 1961, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-09-09", "primary_campaign_end": "2015-11-02", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "832686670149581", "facebook_name": "Lessig2016", "facebook_category": null, "twitter_id": "11388132", "twitter_name": "lessig"}, {"id": 34, "runningmate_id": 30, "name": "Bill Weld", "website": "https://johnsonweld.com", "party_id": "L", "gender_id": "M", "is_white": true, "born_in": 1945, "primary_campaign_id": null, "primary_campaign_start": null, "primary_campaign_end": null, "general_campaign_id": "2016_3", "general_campaign_start": "2016-05-17", "general_campaign_end": "2016-11-09", "facebook_id": "1742663025978076", "facebook_name": "GovBillWeld", "facebook_category": "Politician", "twitter_id": "734783792502575105", "twitter_name": "GovBillWeld"}, {"id": 12, "runningmate_id": null, "name": "Jim Gilmore", "website": "http://www.gilmoreforamerica.com", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1949, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-07-30", "primary_campaign_end": "2016-02-12", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "1053902791317272", "facebook_name": "gilmoreforamerica", "facebook_category": "Politician", "twitter_id": "3021632183", "twitter_name": "gov_gilmore"}, {"id": 10, "runningmate_id": 36, "name": "Hillary Clinton", "website": "https://www.hillaryclinton.com/", "party_id": "D", "gender_id": "F", "is_white": true, "born_in": 1947, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-04-12", "primary_campaign_end": "2016-06-07", "general_campaign_id": "2016_2", "general_campaign_start": "2016-06-08", "general_campaign_end": "2016-11-09", "facebook_id": "889307941125736", "facebook_name": "hillaryclinton", "facebook_category": "Politician", "twitter_id": "1339835893", "twitter_name": "HillaryClinton"}, {"id": 18, "runningmate_id": null, "name": "Lindsey Graham", "website": "https://www.lindseygraham.com/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1955, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-06-01", "primary_campaign_end": "2015-12-21", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "165987503528599", "facebook_name": "LindseyGrahamSC", "facebook_category": "Politician", "twitter_id": "432895323", "twitter_name": "LindseyGrahamSC"}, {"id": 2, "runningmate_id": null, "name": "Bobby Jindal", "website": "https://www.bobbyjindal.com", "party_id": "R", "gender_id": "M", "is_white": false, "born_in": 1971, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-06-24", "primary_campaign_end": "2015-11-17", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "51275855094", "facebook_name": "bobbyjindal", "facebook_category": "Politician", "twitter_id": "17078632", "twitter_name": "BobbyJindal"}, {"id": 15, "runningmate_id": null, "name": "John Kasich", "website": "https://www.johnkasich.com/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1952, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-07-21", "primary_campaign_end": "2016-05-04", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "77590795932", "facebook_name": "JohnKasich", "facebook_category": "Politician", "twitter_id": "18020081", "twitter_name": "JohnKasich"}, {"id": 13, "runningmate_id": null, "name": "Jim Webb", "website": "http://www.jameswebb.com/", "party_id": "D", "gender_id": "M", "is_white": true, "born_in": 1946, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-07-02", "primary_campaign_end": "2015-10-20", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "232634213593172", "facebook_name": "IHeardMyCountryCalling", "facebook_category": "Public Figure", "twitter_id": "2746932876", "twitter_name": "JimWebbUSA"}, {"id": 21, "runningmate_id": null, "name": "Martin O\u2019Malley", "website": "https://martinomalley.com/", "party_id": "D", "gender_id": "M", "is_white": true, "born_in": 1963, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-05-30", "primary_campaign_end": "2016-02-01", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "28684115392", "facebook_name": "MartinOMalley", "facebook_category": "Politician", "twitter_id": "15824288", "twitter_name": "MartinOMalley"}, {"id": 5, "runningmate_id": 35, "name": "Donald Trump", "website": "https://www.donaldjtrump.com", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1946, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-06-16", "primary_campaign_end": "2016-05-03", "general_campaign_id": "2016_2", "general_campaign_start": "2017-05-03", "general_campaign_end": "2016-11-09", "facebook_id": "153080620724", "facebook_name": "DonaldTrump", "facebook_category": "Public Figure", "twitter_id": "25073877", "twitter_name": "realDonaldTrump"}, {"id": 19, "runningmate_id": null, "name": "Marco Rubio", "website": "https://marcorubio.com/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1971, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-04-13", "primary_campaign_end": "2016-03-15", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "58736997707", "facebook_name": "MarcoRubio", "facebook_category": "Politician", "twitter_id": "15745368", "twitter_name": "marcorubio"}, {"id": 37, "runningmate_id": null, "name": "Scott Walker", "website": "https://www.scottwalker.com/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1967, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-07-13", "primary_campaign_end": "2015-09-21", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "175220979161820", "facebook_name": "governorscottwalker", "facebook_category": "Government Official", "twitter_id": "33750798", "twitter_name": "ScottWalker"}, {"id": 32, "runningmate_id": null, "name": "Mark Everson", "website": "http://www.markforamerica.com/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1954, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-05-05", "primary_campaign_end": "2015-11-05", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "1526434477644076", "facebook_name": "MarkForAmerica", "facebook_category": "Politician", "twitter_id": "2998799499", "twitter_name": "MarkForAmerica"}, {"id": 24, "runningmate_id": null, "name": "Rick Perry", "website": "http://www.rickperry.org", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1950, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-06-04", "primary_campaign_end": "2015-09-12", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "22269950408", "facebook_name": "GovernorPerry", "facebook_category": "Politician", "twitter_id": "18906561", "twitter_name": "GovernorPerry"}, {"id": 8, "runningmate_id": null, "name": "George Pataki", "website": "https://www.georgepataki.com", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1945, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-05-28", "primary_campaign_end": "2015-12-29", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "180698708704667", "facebook_name": "GovGeorgePataki", "facebook_category": "Politician", "twitter_id": "2865560724", "twitter_name": "GovernorPataki"}, {"id": 28, "runningmate_id": 33, "name": "Jill Stein", "website": "https://www.jill2016.com", "party_id": "G", "gender_id": "F", "is_white": true, "born_in": 1950, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-02-06", "primary_campaign_end": "2016-06-22", "general_campaign_id": "2016_2", "general_campaign_start": "2016-06-22", "general_campaign_end": "2016-11-09", "facebook_id": "240944029279128", "facebook_name": "drjillstein", "facebook_category": "Public Figure", "twitter_id": "111216929", "twitter_name": "DrJillStein"}, {"id": 30, "runningmate_id": 34, "name": "Gary Johnson", "website": "https://garyjohnson2016.com", "party_id": "L", "gender_id": "M", "is_white": true, "born_in": 1953, "primary_campaign_id": "2016_1", "primary_campaign_start": "2016-01-06", "primary_campaign_end": "2016-05-30", "general_campaign_id": "2016_2", "general_campaign_start": "2016-05-30", "general_campaign_end": "2016-11-09", "facebook_id": "165297924363", "facebook_name": "govgaryjohnson", "facebook_category": "Politician", "twitter_id": "95713333", "twitter_name": "GovGaryJohnson"}, {"id": 6, "runningmate_id": null, "name": "Ben Carson", "website": "http://www.bencarson.com", "party_id": "R", "gender_id": "M", "is_white": false, "born_in": 1951, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-05-04", "primary_campaign_end": "2016-03-04", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "138691142964027", "facebook_name": "realbencarson", "facebook_category": "Public Figure", "twitter_id": "1180379185", "twitter_name": "RealBenCarson"}, {"id": 29, "runningmate_id": null, "name": "Evan McMullin", "website": "https://www.evanmcmullin.com", "party_id": "I", "gender_id": "M", "is_white": true, "born_in": 1976, "primary_campaign_id": null, "primary_campaign_start": null, "primary_campaign_end": null, "general_campaign_id": "2016_2", "general_campaign_start": "2016-08-08", "general_campaign_end": "2016-11-09", "facebook_id": "1604371783193820", "facebook_name": "mcmullinforpresident", "facebook_category": null, "twitter_id": "1051396218", "twitter_name": "Evan_McMullin"}, {"id": 36, "runningmate_id": 10, "name": "Tim Kaine", "website": "https://kaine.senate.gov/", "party_id": "D", "gender_id": "M", "is_white": true, "born_in": 1958, "primary_campaign_id": null, "primary_campaign_start": null, "primary_campaign_end": null, "general_campaign_id": "2016_3", "general_campaign_start": "2016-07-22", "general_campaign_end": "2016-11-09", "facebook_id": "7656215652", "facebook_name": "timkaine", "facebook_category": "Politician", "twitter_id": "172858784", "twitter_name": "timkaine"}, {"id": 4, "runningmate_id": null, "name": "Chris Christie", "website": "https://www.chrischristie.com/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1962, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-06-30", "primary_campaign_end": "2016-02-10", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "180381489134", "facebook_name": "govchristie", "facebook_category": "Politician", "twitter_id": "1347285918", "twitter_name": "ChrisChristie"}, {"id": 23, "runningmate_id": null, "name": "Rand Paul", "website": "https://www.randpaul.com/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1963, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-04-07", "primary_campaign_end": "2016-02-03", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "54172246106", "facebook_name": "RandPaul", "facebook_category": "Politician", "twitter_id": "216881337", "twitter_name": "RandPaul"}, {"id": 1, "runningmate_id": null, "name": "Bernie Sanders", "website": "https://berniesanders.com", "party_id": "D", "gender_id": "M", "is_white": true, "born_in": 1941, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-04-30", "primary_campaign_end": "2016-06-07", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "124955570892789", "facebook_name": "berniesanders", "facebook_category": "Politician", "twitter_id": "216776631", "twitter_name": "BernieSanders"}, {"id": 22, "runningmate_id": null, "name": "Mike Huckabee", "website": "https://www.mikehuckabee.com/", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1955, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-01-03", "primary_campaign_end": "2016-02-01", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "6934857868", "facebook_name": "mikehuckabee", "facebook_category": "Politician", "twitter_id": "15416505", "twitter_name": "GovMikeHuckabee"}, {"id": 3, "runningmate_id": 27, "name": "Carly Fiorina", "website": "https://www.carlyforpresident.com", "party_id": "R", "gender_id": "F", "is_white": true, "born_in": 1954, "primary_campaign_id": "2016_1", "primary_campaign_start": "2015-05-04", "primary_campaign_end": "2016-02-10", "general_campaign_id": null, "general_campaign_start": null, "general_campaign_end": null, "facebook_id": "261624820205", "facebook_name": "CarlyFiorina", "facebook_category": "Politician", "twitter_id": "3048252359", "twitter_name": "CARLYforAmerica"}, {"id": 35, "runningmate_id": 5, "name": "Mike Pence", "website": "https://www.mikepence.com", "party_id": "R", "gender_id": "M", "is_white": true, "born_in": 1959, "primary_campaign_id": null, "primary_campaign_start": null, "primary_campaign_end": null, "general_campaign_id": "2016_3", "general_campaign_start": "2016-07-15", "general_campaign_end": "2016-11-09", "facebook_id": "6726182861", "facebook_name": "mikepence", "facebook_category": "Politician", "twitter_id": "22203756", "twitter_name": "mike_pence"}];
    return {
        getRaw : function(){ return rawData; },
        getIdToNameLookup : function(){ return rawData.reduce((acc, item) => { acc[item.id] = item.name; return acc; }, {}) },
        get_by_id : function(id){ return rawData.filter(x => { return x.id === id; }).shift(); },
        get_by_facebook_id : function(id){ return rawData.filter(x => { return x.facebook_id === id; }).shift(); },
        get_by_twitter_id : function(id){ return rawData.filter(x => { return x.twitter_id === id; }).shift(); }
    }
})();