Independent MPs in the LokSabha

In the last 60 years, India has seen 4,665 MPs being elected to the Lok Sabha from over 140 political parties.  4242 of them were men and 316  women.
Information about our Members of the Parliament both in the Lok Sabha and the Rajya Sabha, was recently uploaded in the Data Portal of India.  I consolidated all the basic information of the Members of the Parliament into one single .CSV file and converted it into a Mysql database (both of them can be found here).  I then ran specific queries to get the data I wanted to analyse and used google fusion tables to visualise them. Below are the first three visualisations.
1) Independent Members of the Parliament in the Lok Sabha from different states.
2) Independent Members of the Parliament organised by the sessions of Lok Sabha
3) Male/Female ratio in the Lok Sabha
*Some constituencies have changed and now are in different states as compared to their original state. I’ve counted them according to the present state where the constituency falls.
I plan to create more such visulaisations out of this dataset and add more data to this dataset too. If you want a specific visulaisation or data to be added, let me know and I will try to do it.
Independent Members of the Parliament – Statewise

Independent Members of the Parliament – Lok Sabha wise

Members of the Parliament – Male/Female



Is the world population growing?

Is the world population growing? If yes, how long will it grow like this and does religion have a role to play in this?
In this amazing video (posted a year ago), Hans Rosling explains where the world population is headed and what role does religion play in it. This is a fantasitic example of what we can do with open/public data and how it can give insights unlike never before.

You can find more about Hans Rosling and his work here

3 reasons why a video goes viral on Youtube

Kevin Allocca, YouTube's trends manager, shares the 3 reasons why a video goes viral. In this video he takes the example of three videos and goes on to explain how, tastemakers, communities of participation and unexpectedness are the reasons on why the videos went viral online.

Another interesting thing to note in his talk is the role played by twitter. Some of these videos were quite old by the time they went viral and how a tweet from a tastemaker resulted in the video going viral. Do watch this interesting talk.

So how many people in India use Facebook ?

 As of March 2016, Facebook has over 142 million users in India, of which approximately 133 million (93.66%) accessed the site from their mobile phones.
Nearly 69 million people in India use Facebook daily, of which 64 million access the platform through their mobile devices. Source: Vijay Shankar, Facebook Head of Products (Facebook Lite)
Below is a city wise breakdown.

Estimated monthly active users according to adverts  : 29 Nov 2015
All India –¬†137,000,000
Delhi/NCR –¬†14,000,000
Mumbai –¬†¬†8,300,000
Bangalore –¬†9,100,000
Chennai –¬†11,000,000
Kolkata –¬†13,000,000

As of today, about 108,000,000 people use Facebook in India making it the third largest user base for Facebook after USA and Brazil. Roughly 8.9% of Indians use Facebook. As of 2011, there were about 121 million people accessing internet in India. Here is the breakdown of the usage in the top 5 cities in India.

Can social media shape Governance ?

Technology can help interconnect networks and institutions.  Its not just policing governance but actually create new forms of Governance.
In this highly informative talk, Beth Noveck, the former deputy CTO at the White House, shares a vision of practical openness — connecting bureaucracies to citizens, sharing data, creating a truly participatory democracy.
Its also worth nothing that the Government of India has just launched the National Data Portal based, a platform for supporting the open data initiative of Government of India. The portal aims to provide single-point-access to datasets published by various Ministries/Departments of Government of India.  For more, visit