[{"_id":{"$oid":"52cdef7c4bab8bd675297da7"},"name":"AddThis","permalink":"addthis","crunchbase_url":"http://www.crunchbase.com/company/addthis","homepage_url":"http://www.addthis.com","blog_url":"http://addthis.com/blog","blog_feed_url":"http://addthis.com/blog/feed","twitter_username":"addthis","category_code":"advertising","number_of_employees":{"$numberInt":"120"},"founded_year":{"$numberInt":"2004"},"founded_month":null,"founded_day":null,"deadpooled_year":null,"deadpooled_month":null,"deadpooled_day":null,"deadpooled_url":null,"tag_list":"sharing, social-applications, social-media, analytics, audience-targeting, advertising-solutions, web-plugins, consumer-engagement-tools, big-data","alias_list":"Clearspring,Clearspring Technologies","email_address":"info@addthis.com","phone_number":"703-677-3999","description":"Content Engagement","created_at":"Wed Jun 13 09:00:07 UTC 2007","updated_at":"Thu Dec 05 23:54:22 UTC 2013","overview":"<p>AddThis personalizes the web with powerful, easy-to-use social engagement tools, APIs and services. Reaching 1.5 billion unique users monthly, AddThis’ data-driven solutions boost traffic, engagement, intelligence and monetization for publishers and advertisers. With a massive web-wide footprint of more than 14 million domains, AddThis processes more than 300 terabytes of data daily allowing AddThis to provide brands with sophisticated audience models, data-driven engagement tools and web-wide audience insights that enhance paid, earned and owned media strategies.</p>","image":{"available_sizes":[[[{"$numberInt":"150"},{"$numberInt":"42"}],"assets/images/resized/0000/4135/4135v5-max-150x150.jpg"],[[{"$numberInt":"250"},{"$numberInt":"70"}],"assets/images/resized/0000/4135/4135v5-max-250x250.jpg"],[[{"$numberInt":"450"},{"$numberInt":"127"}],"assets/images/resized/0000/4135/4135v5-max-450x450.jpg"]],"attribution":null},"products":[{"name":"Publisher Solutions","permalink":"addthis"},{"name":"Advertiser Solutions","permalink":"add-this"},{"name":"Data Solutions","permalink":"audience-platform"}],"relationships":[{"is_past":false,"title":"CEO","person":{"first_name":"Richard","last_name":"Harris","permalink":"richard-harris-5"}},{"is_past":false,"title":"Founder","person":{"first_name":"Dom","last_name":"Vonarburg","permalink":"dom-vonarburg"}},{"is_past":false,"title":"Co-Founder and Chairman","person":{"first_name":"Hooman","last_name":"Radfar","permalink":"hooman-radfar"}},{"is_past":false,"title":"Chief Product Officer","person":{"first_name":"Andy","last_name":"Spillane","permalink":"andy-spillane"}},{"is_past":false,"title":"Vice President of Client Solutions","person":{"first_name":"Greg","last_name":"Cypes","permalink":"greg-cypes"}},{"is_past":false,"title":"Vice President of User Experience","person":{"first_name":"Jim","last_name":"Lane","permalink":"jim-lane"}},{"is_past":false,"title":"President of Advertiser and Publisher Solutions","person":{"first_name":"Peggy","last_name":"Fry","permalink":"peggy-fry"}},{"is_past":false,"title":"Board Member","person":{"first_name":"Ted","last_name":"Leonsis","permalink":"ted-leonsis"}},{"is_past":false,"title":"Board Member","person":{"first_name":"Harry","last_name":"Weller","permalink":"harry-weller"}},{"is_past":false,"title":"Board Member","person":{"first_name":"Bill","last_name":"Wise","permalink":"bill-wire"}},{"is_past":false,"title":"Board Observer","person":{"first_name":"Sandy","last_name":"Miller","permalink":"sandy-miller"}},{"is_past":false,"title":"General Counsel","person":{"first_name":"Mike","last_name":"McGowan","permalink":"mike-mcgowan"}},{"is_past":false,"title":"Board Member","person":{"first_name":"Steve","last_name":"Case","permalink":"steve-case"}},{"is_past":false,"title":"Investor","person":{"first_name":"Pejman","last_name":"Nozad","permalink":"pejman-nozad"}},{"is_past":false,"title":"Vice President of Product","person":{"first_name":"Rich","last_name":"Labarca","permalink":"rich-labarca"}},{"is_past":false,"title":"","person":{"first_name":"Theodore","last_name":"Nguyen-Cao","permalink":"theodore-nguyen-cao"}},{"is_past":false,"title":"Board Member","person":{"first_name":"Gar","last_name":"Richlin","permalink":"gar-richlin"}},{"is_past":false,"title":"Chief Marketing Officer","person":{"first_name":"Scott","last_name":"Allan","permalink":"scott-allan-2"}},{"is_past":false,"title":"Board Observer","person":{"first_name":"Hugh","last_name":"Browne","permalink":"hugh-browne"}},{"is_past":true,"title":"President & CEO","person":{"first_name":"Ramsey","last_name":"McGrory","permalink":"ramsey-mcgrory"}},{"is_past":true,"title":"President & COO","person":{"first_name":"Jay","last_name":"Rappaport","permalink":"jay-rappaport"}},{"is_past":true,"title":"CFO","person":{"first_name":"Robert","last_name":"Van Niman","permalink":"robert-van-niman"}},{"is_past":true,"title":"President, COO","person":{"first_name":"Jay","last_name":"Rappaport","permalink":"jay-rappaport"}},{"is_past":true,"title":"Senior Vice President","person":{"first_name":"Kent","last_name":"Wakeford","permalink":"kent-wakeford"}},{"is_past":true,"title":"SVP, Marketing","person":{"first_name":"Allison","last_name":"Tepley","permalink":"allison-tepley"}},{"is_past":true,"title":"Senior Vice President, Publisher Products","person":{"first_name":"Will","last_name":"Meyer","permalink":"will-meyer"}},{"is_past":true,"title":"Founding CTO, EVP Products","person":{"first_name":"Stewart","last_name":"Allen","permalink":"stewart-allen"}},{"is_past":true,"title":"VP, Product Development","person":{"first_name":"Joel","last_name":"Pulliam","permalink":"joel-pulliam"}},{"is_past":true,"title":"President & Chief Operating Officer","person":{"first_name":"Gar","last_name":"Richlin","permalink":"gar-richlin"}},{"is_past":true,"title":"Director of Sales, West","person":{"first_name":"Jacque","last_name":"Graham","permalink":"jacque-graham"}},{"is_past":true,"title":"Director of Business Development","person":{"first_name":"Kurt","last_name":"Collins","permalink":"kurt-collins"}},{"is_past":true,"title":"President of Data & Distribution","person":{"first_name":"Key","last_name":"Compton","permalink":"key-compton"}}],"competitions":[{"competitor":{"name":"Gigya","permalink":"gigya"}},{"competitor":{"name":"ShareThis","permalink":"sharethis"}},{"competitor":{"name":"Gigya","permalink":"gigya"}},{"competitor":{"name":"Meebo","permalink":"meebo"}},{"competitor":{"name":"Shareaholic","permalink":"shareaholic"}},{"competitor":{"name":"Prooflink","permalink":"prooflink"}},{"competitor":{"name":"LoginRadius","permalink":"loginradius"}}],"providerships":[{"title":"","is_past":false,"provider":{"name":"NuCoPro","permalink":"nucopro"}}],"total_money_raised":"$73M","funding_rounds":[{"id":{"$numberInt":"27"},"round_code":"a","source_url":"http://venturebeat.com/2007/03/06/widget-company-clearspring-says-it-leads-market-and-raises-55m/","source_description":"Widget company, Clearspring, says it leads market, and raises $5.5M","raised_amount":{"$numberInt":"2500000"},"raised_currency_code":"USD","funded_year":{"$numberInt":"2006"},"funded_month":{"$numberInt":"5"},"funded_day":{"$numberInt":"1"},"investments":[{"company":null,"financial_org":{"name":"Novak Biddle Venture Partners","permalink":"novak-biddle-venture-partners"},"person":null},{"company":null,"financial_org":{"name":"ZG Ventures","permalink":"zg-ventures"},"person":null}]},{"id":{"$numberInt":"28"},"round_code":"b","source_url":"http://venturebeat.com/2007/03/06/widget-company-clearspring-says-it-leads-market-and-raises-55m/","source_description":"Widget company, Clearspring, says it leads market, and raises $5.5M","raised_amount":{"$numberInt":"5500000"},"raised_currency_code":"USD","funded_year":{"$numberInt":"2007"},"funded_month":{"$numberInt":"2"},"funded_day":{"$numberInt":"1"},"investments":[{"company":null,"financial_org":{"name":"Novak Biddle Venture Partners","permalink":"novak-biddle-venture-partners"},"person":null},{"company":null,"financial_org":{"name":"ZG Ventures","permalink":"zg-ventures"},"person":null},{"company":null,"financial_org":null,"person":{"first_name":"Mark","last_name":"Jung","permalink":"mark-jung"}},{"company":null,"financial_org":null,"person":{"first_name":"Steve","last_name":"Case","permalink":"steve-case"}},{"company":null,"financial_org":null,"person":{"first_name":"Ted","last_name":"Leonsis","permalink":"ted-leonsis"}},{"company":{"name":"Revolution LLC","permalink":"revolution"},"financial_org":null,"person":null}]},{"id":{"$numberInt":"2348"},"round_code":"c","source_url":"http://www.paidcontent.org/entry/419-widgeteer-clearspring-raises-18-million-third-round/","source_description":"Paidcontent article","raised_amount":{"$numberInt":"18000000"},"raised_currency_code":"USD","funded_year":{"$numberInt":"2008"},"funded_month":{"$numberInt":"5"},"funded_day":{"$numberInt":"20"},"investments":[{"company":null,"financial_org":{"name":"New Enterprise Associates","permalink":"new-enterprise-associates"},"person":null},{"company":null,"financial_org":{"name":"Novak Biddle Venture Partners","permalink":"novak-biddle-venture-partners"},"person":null},{"company":null,"financial_org":{"name":"QED Investors","permalink":"qed-investors"},"person":null}]},{"id":{"$numberInt":"2350"},"round_code":"b","source_url":"http://www.paidcontent.org/entry/419-widget-firm-clearspring-receives-additional-10-million-in-funding","source_description":"Paidcontent article","raised_amount":{"$numberInt":"10000000"},"raised_currency_code":"USD","funded_year":{"$numberInt":"2007"},"funded_month":{"$numberInt":"7"},"funded_day":{"$numberInt":"27"},"investments":[{"company":null,"financial_org":{"name":"SV Angel","permalink":"sv-angel"},"person":null}]},{"id":{"$numberInt":"22906"},"round_code":"d","source_url":"http://techcrunch.com/2011/05/10/addthis-indeed-clearspring-raises-20-million-as-it-rides-social-sharing-boom/","source_description":"AddThis Indeed: Clearspring Raises $20 Million As It Rides Social Sharing Boom","raised_amount":{"$numberInt":"20000000"},"raised_currency_code":"USD","funded_year":{"$numberInt":"2011"},"funded_month":{"$numberInt":"5"},"funded_day":{"$numberInt":"10"},"investments":[{"company":null,"financial_org":{"name":"Institutional Venture Partners","permalink":"institutional-venture-partners"},"person":null},{"company":null,"financial_org":{"name":"New Enterprise Associates","permalink":"new-enterprise-associates"},"person":null},{"company":null,"financial_org":{"name":"Novak Biddle Venture Partners","permalink":"novak-biddle-venture-partners"},"person":null},{"company":null,"financial_org":null,"person":{"first_name":"Ted","last_name":"Leonsis","permalink":"ted-leonsis"}},{"company":null,"financial_org":null,"person":{"first_name":"Steve","last_name":"Case","permalink":"steve-case"}},{"company":null,"financial_org":null,"person":{"first_name":"Nigel","last_name":"Morris","permalink":"nigel-morris"}},{"company":null,"financial_org":null,"person":{"first_name":"Ron","last_name":"Conway","permalink":"ron-conway"}},{"company":{"name":"Revolution LLC","permalink":"revolution"},"financial_org":null,"person":null},{"company":null,"financial_org":{"name":"QED Investors","permalink":"qed-investors"},"person":null}]},{"id":{"$numberInt":"48111"},"round_code":"private_equity","source_url":"http://www.sec.gov/Archives/edgar/data/1363055/000136305512000001/xslFormDX01/primary_doc.xml","source_description":"SEC","raised_amount":{"$numberInt":"17000000"},"raised_currency_code":"USD","funded_year":{"$numberInt":"2011"},"funded_month":{"$numberInt":"10"},"funded_day":{"$numberInt":"31"},"investments":[]}],"investments":[],"acquisition":null,"acquisitions":[{"price_amount":null,"price_currency_code":"USD","term_code":null,"source_url":"http://paidcontent.org/article/419-clearspring-acquires-social-data-tool-xgraph-/","source_description":"Clearspring Acquires Social Data Tool XGraph","acquired_year":{"$numberInt":"2011"},"acquired_month":{"$numberInt":"11"},"acquired_day":{"$numberInt":"1"},"company":{"name":"XGraph","permalink":"xgraph"}}],"offices":[{"description":"HQ - Virginia","address1":"1595 Spring Hill Road","address2":"Suite 300","zip_code":"22182","city":"Vienna","state_code":"VA","country_code":"USA","latitude":{"$numberDouble":"38.926172"},"longitude":{"$numberDouble":"-77.245195"}},{"description":"New York Office","address1":"568 Broadway","address2":"11th Floor, Suite 1105","zip_code":"10012","city":"New York","state_code":"NY","country_code":"USA","latitude":{"$numberDouble":"40.724604"},"longitude":{"$numberDouble":"-73.996876"}},{"description":"Los Angeles Office","address1":"10555-A Jefferson Blvd.","address2":"","zip_code":"90232","city":"Culver City","state_code":"CA","country_code":"USA","latitude":{"$numberDouble":"34.0263021"},"longitude":{"$numberDouble":"-118.380954"}},{"description":"Chicago Office","address1":"225 West Washington","address2":"Ste. 2200","zip_code":"60606","city":"Chicago","state_code":"IL","country_code":"USA","latitude":null,"longitude":null},{"description":"San Francisco Office","address1":"505 Montgomery Street","address2":"10th Floor, Suite 42","zip_code":"94111","city":"San Francisco","state_code":"CA","country_code":"USA","latitude":null,"longitude":null},{"description":"Michigan Office","address1":"2605 Crooks Road","address2":"Unit A","zip_code":"48084","city":"Troy","state_code":"MI","country_code":"USA","latitude":{"$numberDouble":"42.557958"},"longitude":{"$numberDouble":"-83.167884"}}],"milestones":[{"id":{"$numberInt":"19071"},"description":"Acquired XGraph","stoned_year":{"$numberInt":"2011"},"stoned_month":{"$numberInt":"11"},"stoned_day":null,"source_url":"http://allthingsd.com/20111101/clearspring-buys-data-science-start-up-xgraph/?refcat=news","source_text":null,"source_description":"AllThingsD","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"23153"},"description":"Changes brand to AddThis","stoned_year":{"$numberInt":"2012"},"stoned_month":{"$numberInt":"5"},"stoned_day":{"$numberInt":"10"},"source_url":"http://www.businessinsider.com/clearspring-now-addthis-and-has-13-billion-monthly-uniques-2012-5","source_text":null,"source_description":"BusinessInsider","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37156"},"description":"AddThis Makes Big Social Data More Actionable for Publishers, Advertisers with Suite of New Tools and Analytics","stoned_year":{"$numberInt":"2011"},"stoned_month":{"$numberInt":"5"},"stoned_day":{"$numberInt":"10"},"source_url":"http://www.addthis.com/press/addthis-makes-big-social-data-more-actionable-with-new-tools#.UfA6kGRATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37157"},"description":"AddThis Launches Improved Pinterest Sharing Support and Additional Pinterest Growth Insights","stoned_year":{"$numberInt":"2011"},"stoned_month":{"$numberInt":"6"},"stoned_day":{"$numberInt":"26"},"source_url":"http://www.addthis.com/press/addthis-launches-improved-pinterest-sharing-support#.UfA7lmRATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37158"},"description":"AddThis Recognized as a Top Innovator By Leading U.S. Data Conference","stoned_year":{"$numberInt":"2012"},"stoned_month":{"$numberInt":"8"},"stoned_day":{"$numberInt":"21"},"source_url":"http://www.addthis.com/press/addthis-recognized-as-a-top-innovator-by-leading-u.s.-data-conference#.UfA70WRATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37159"},"description":"AddThis Introduces Social Sign-in to its Suite of Social Plugins","stoned_year":{"$numberInt":"2012"},"stoned_month":{"$numberInt":"8"},"stoned_day":{"$numberInt":"21"},"source_url":"http://www.addthis.com/press/addthis-introduces-social-sign-in-to-its-suite-of-social-plug-ins#.UfA8D2RATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37160"},"description":"AddThis Updates Sharing Tools to Drive Traffic and Consumer Engagement Across 14 Million Sites","stoned_year":{"$numberInt":"2012"},"stoned_month":{"$numberInt":"9"},"stoned_day":{"$numberInt":"13"},"source_url":"http://www.addthis.com/press/addthis-updates-sharing-tools-to-drive-engagement-across-14-million-sites#.UfA8OmRATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37161"},"description":"AddThis Launches Global Audience Segments","stoned_year":{"$numberInt":"2012"},"stoned_month":{"$numberInt":"9"},"stoned_day":{"$numberInt":"17"},"source_url":"http://www.addthis.com/press/addthis-launches-global-audience-segments#.UfA8j2RATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37162"},"description":"AddThis Launches Purchase-Based Audiences for Targeting and Site Optimization","stoned_year":{"$numberInt":"2012"},"stoned_month":{"$numberInt":"9"},"stoned_day":{"$numberInt":"19"},"source_url":"http://www.addthis.com/press/addthis-launches-purchase-based-audiences-for-targeting-and-optimization#.UfA8z2RATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37163"},"description":"AddThis Recognized for Technology Innovation in Digital Entertainment Advertising and Marketing","stoned_year":{"$numberInt":"2012"},"stoned_month":{"$numberInt":"10"},"stoned_day":{"$numberInt":"16"},"source_url":"http://www.addthis.com/press/addthis-recognized-for-technology-innovation-in-digital-entertainment#.UfA9A2RATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37164"},"description":"AddThis Introduces Social Brand Advocates","stoned_year":{"$numberInt":"2013"},"stoned_month":{"$numberInt":"6"},"stoned_day":{"$numberInt":"11"},"source_url":"http://www.addthis.com/press/addthis-introduces-social-brand-advocates#.UfA9N2RATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37165"},"description":"AddThis Launches Smart Layers","stoned_year":{"$numberInt":"2013"},"stoned_month":{"$numberInt":"7"},"stoned_day":{"$numberInt":"11"},"source_url":"http://www.addthis.com/press/addthis-launches-smart-layers#.UfA9VmRATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}},{"id":{"$numberInt":"37532"},"description":"AddThis Appoints Scott Allan as Chief Marketing Officer","stoned_year":{"$numberInt":"2013"},"stoned_month":{"$numberInt":"7"},"stoned_day":{"$numberInt":"30"},"source_url":"http://www.addthis.com/press/addthis-appoints-scott-allan-as-chief-marketing-officer#.UfkgNmRATT0","source_text":null,"source_description":"Press Release","stoneable_type":"Company","stoned_value":null,"stoned_value_type":null,"stoned_acquirer":null,"stoneable":{"name":"AddThis","permalink":"addthis"}}],"ipo":null,"video_embeds":[],"screenshots":[{"available_sizes":[[[{"$numberInt":"150"},{"$numberInt":"140"}],"assets/images/resized/0029/5815/295815v2-max-150x150.png"],[[{"$numberInt":"250"},{"$numberInt":"234"}],"assets/images/resized/0029/5815/295815v2-max-250x250.png"],[[{"$numberInt":"450"},{"$numberInt":"421"}],"assets/images/resized/0029/5815/295815v2-max-450x450.png"]],"attribution":null},{"available_sizes":[[[{"$numberInt":"150"},{"$numberInt":"117"}],"assets/images/resized/0029/5817/295817v2-max-150x150.png"],[[{"$numberInt":"250"},{"$numberInt":"196"}],"assets/images/resized/0029/5817/295817v2-max-250x250.png"],[[{"$numberInt":"450"},{"$numberInt":"352"}],"assets/images/resized/0029/5817/295817v2-max-450x450.png"]],"attribution":null},{"available_sizes":[[[{"$numberInt":"150"},{"$numberInt":"74"}],"assets/images/resized/0029/5819/295819v2-max-150x150.png"],[[{"$numberInt":"250"},{"$numberInt":"124"}],"assets/images/resized/0029/5819/295819v2-max-250x250.png"],[[{"$numberInt":"450"},{"$numberInt":"224"}],"assets/images/resized/0029/5819/295819v2-max-450x450.png"]],"attribution":null}],"external_links":[{"external_url":"http://www.washingtonian.com/articles/people/19168.html","title":"Tech Titans 2011"},{"external_url":"http://www.bloomberg.com/news/2011-04-15/livingsocial-is-next-bet-for-steve-case-after-zipcar-payoff.html","title":"LivingSocial Is Next Bet for Steve Case After Zipcar Payoff"},{"external_url":"http://abcnews.go.com/GMA/video/unemployment-lowest-years-jobs-report-economy-business-13281027?tab=9482931&section=1206833","title":"Unemployment at Lowest in Two Years"},{"external_url":"http://siliconangle.com/blog/2011/04/28/clearspring-serious-about-big-data-makes-audience-platform-portable/","title":"Clearspring Serious About Big Data, Makes Audience Platform \"Portable\""},{"external_url":"http://www.adexchanger.com/one-question/what-is-the-biggest-misconception-about-the-use-of-data-for-ad-targeting/","title":"What Is The Biggest Misconception About The Use Of Data For Ad Targeting?"},{"external_url":"http://blogs.imediaconnection.com/blog/2011/03/08/3-things-advertisers-shouldn%E2%80%99t-like-about-%E2%80%98likes%E2%80%99/","title":"3 Things Advertisers Should Dislike About ‘Likes’"},{"external_url":"http://www.adexchanger.com/one-question/do-you-think-an-agency-trading-desk-can-be-successful/","title":"One Question: Do You Think An Agency Trading Desk Can Be Successful?"}],"partners":[]}]

db.collection.aggregate([{$project:{number_of_employees:1,offices:{$filter:{input:"$offices",cond:{$eq:["$$this.country_code","USA"]}}},states:{$reduce:{input:"$offices",initialValue:[],in:{$concatArrays:["$$value",{$cond:[{$and:[{$eq:["$$this.country_code","USA"]},{$not:{$in:["$$this.state_code","$$value"]}}]},["$$this.state_code"],[]]}]}}}}}])