[{"_id":"5eae9f1846261b75f8bba5d5","created_at":"Fri Apr 24 13:57:14 +0000 2020","id":1253684429198934016,"id_str":"1253684429198934016","text":"Several #EUPHW events have been submitted this week. We look forward to receiving yours 😊 #thisispublichealth https://t.co/Hf1BUpFyzk","truncated":false,"entities":{"hashtags":[{"text":"EUPHW","indices":[8,14]},{"text":"thisispublichealth","indices":[90,109]}],"symbols":[],"user_mentions":[],"urls":[],"media":[{"id":1253684089527447552,"id_str":"1253684089527447552","indices":[110,133],"media_url":"http://pbs.twimg.com/media/EWX7CYDXsAAF1U-.png","media_url_https":"https://pbs.twimg.com/media/EWX7CYDXsAAF1U-.png","url":"https://t.co/Hf1BUpFyzk","display_url":"pic.twitter.com/Hf1BUpFyzk","expanded_url":"https://twitter.com/EUPHActs/status/1253684429198934016/photo/1","type":"photo","sizes":{"medium":{"w":440,"h":220,"resize":"fit"},"thumb":{"w":150,"h":150,"resize":"crop"},"large":{"w":440,"h":220,"resize":"fit"},"small":{"w":440,"h":220,"resize":"fit"}}}]},"extended_entities":{"media":[{"id":1253684089527447552,"id_str":"1253684089527447552","indices":[110,133],"media_url":"http://pbs.twimg.com/media/EWX7CYDXsAAF1U-.png","media_url_https":"https://pbs.twimg.com/media/EWX7CYDXsAAF1U-.png","url":"https://t.co/Hf1BUpFyzk","display_url":"pic.twitter.com/Hf1BUpFyzk","expanded_url":"https://twitter.com/EUPHActs/status/1253684429198934016/photo/1","type":"photo","sizes":{"medium":{"w":440,"h":220,"resize":"fit"},"thumb":{"w":150,"h":150,"resize":"crop"},"large":{"w":440,"h":220,"resize":"fit"},"small":{"w":440,"h":220,"resize":"fit"}}}]},"source":"<a href=\"https://about.twitter.com/products/tweetdeck\" rel=\"nofollow\">TweetDeck</a>","in_reply_to_status_id":null,"in_reply_to_status_id_str":null,"in_reply_to_user_id":null,"in_reply_to_user_id_str":null,"in_reply_to_screen_name":null,"user":{"id":212205321,"id_str":"212205321","name":"EUPHA","screen_name":"EUPHActs","location":"Europe","description":"The European Public Health Association, or EUPHA in short, is an umbrella organisation for public health associations and institutes in Europe.","url":"https://t.co/Xs6pVh8kLp","entities":{"url":{"urls":[{"url":"https://t.co/Xs6pVh8kLp","expanded_url":"http://www.eupha.org","display_url":"eupha.org","indices":[0,23]}]},"description":{"urls":[]}},"protected":false,"followers_count":4981,"friends_count":544,"listed_count":97,"created_at":"Fri Nov 05 12:36:37 +0000 2010","favourites_count":225,"utc_offset":null,"time_zone":null,"geo_enabled":true,"verified":false,"statuses_count":1981,"lang":null,"contributors_enabled":false,"is_translator":false,"is_translation_enabled":false,"profile_background_color":"000000","profile_background_image_url":"http://abs.twimg.com/images/themes/theme1/bg.png","profile_background_image_url_https":"https://abs.twimg.com/images/themes/theme1/bg.png","profile_background_tile":false,"profile_image_url":"http://pbs.twimg.com/profile_images/572023499510661120/sCmqsqCB_normal.png","profile_image_url_https":"https://pbs.twimg.com/profile_images/572023499510661120/sCmqsqCB_normal.png","profile_banner_url":"https://pbs.twimg.com/profile_banners/212205321/1584445502","profile_link_color":"2561A3","profile_sidebar_border_color":"000000","profile_sidebar_fill_color":"000000","profile_text_color":"000000","profile_use_background_image":false,"has_extended_profile":false,"default_profile":false,"default_profile_image":false,"following":false,"follow_request_sent":false,"notifications":false,"translator_type":"none"},"geo":null,"coordinates":null,"place":null,"contributors":null,"is_quote_status":false,"retweet_count":4,"favorite_count":4,"favorited":false,"retweeted":false,"possibly_sensitive":false,"lang":"en","local_time_stamp":"2020-05-03 12:38:16","alumno":"Mohamed Eshra"}]

db.collection.aggregate([{$unwind:"$entities.media"},{$group:{_id:"$entities.media.type",count:{$sum:1}}}])