Use the gear icon to select map parameters

Click on a district for further details

Given Parameters, Distribution of Districts with Respect to:
Trend over Time for the Same Parameters:
Data compiled from Census Digital Library by Sean Angiolillo (2018).


In creating this visualization, my objective was to provide a much-needed spatial, temporal, and social context to accompany key development indicators in India (access to electricity, latrines and water). A single-number summary, for example one describing household access to electricity, falls far short in adequately describing the reality for most Indians. In a country as diverse as India, defining what is “typical” is quite challenging.

For example, if told that, according to the 2011 census, 67% of Indian households have access to electricity, a few questions should accompany that metric. First, what is the distribution behind that summary statistic? What are the corresponding figures if we instead aggregate at sub-national levels– such as the state, district, or even sub-district levels? Moreover, how does this distribution vary in geographic space? What are the regional trends?

In addition to spatial context, we would also want to have a sense of the accompanying temporal context. What is the pace of progress? An absolute figure of 67% will assume a completely different connotation if the previous census figure was 65% as opposed to 55%.

Finally, we would want to cross-tabulate this figure of 67% from as many sub-societal filters as possible. How do urban households differ from rural households? How do SC or ST households differ from the total population? How might water access be related to electricity or latrine access?

As users explore this visualization, I hope it can provide a greater level of context than is often readily available and perhaps spark further investigation into the relationships underpinning these metrics.

Data Source

All of the raw data for this visualisation comes from the Government of India's Census Digital Library. To find the original tables, navigate to the Tables tab, select a Census Year, and choose “Tables on Houses, Household Amenities and Assets”. Then for each State/UT, download the file regarding “Households Classified by Source and Location of Drinking Water and Availablity of Electricity and Latrine” and the corresponding SC and ST files where present.

Spatial Units

The spatial unit mapped here is the district level. The number of districts grows from 466 in 1991, to 593 in 2001, to 640 in 2011. The changing composition of these districts poses two challenges.

One challenge is that a given district's population and area both vary widely. This can be problematic for a choropleth because the area of the spatial unit can be misleading (See Kieran Healy, Data Visualization: A Practical Introduction). For example, large districts like Ladakh (JK) stand out prominently on the map, but hold relatively few households. Metros like Mumbai (MH) on the other hand, are hardly visible without increasing the map's zoom, yet hold far more people.

I have tried to address this challenge in two ways. The first is that clicking on a district provides the raw district household counts. The second is that “Household Count” appears as a separate data type. Selecting it plots, on a logarithmic scale, the distribution of household counts per district. Particularly if one is unfamiliar with India's population density, it would be beneficial to first observe the household count distribution.

A second challenge is that districts change frequently over time, complicating time series analysis across decades. Rather than try to plot a district-level time series, clicking on a district adds the district point and the associate state trend. States do change, but much less frequently than districts. Also, All-India and State/UT averages are reported as provided in the raw data, rather than explicitly calculated by summing districts.

Missing Data

In 1991 and 2011, these tables report on a given geographic unit's performance with simultaneous regards to Electricity and Latrine status. Accordingly, it is possible to determine all combinations of electricity and latrine status. In 2001 however, figures are only reported with respect to the presence or absence of electricity and the presence or absence of a latrine. Although the data for this year is entirely missing, I have kept those levels as an option so that it becomes easier to scan across years where it is present.

In 1991, violence in Jammu and Kashmir prevented the census from being conducted according to the 1991 Census Handbook. Hence, you will find those districts appear gray on the map.

Lastly, I was unable to successfully read in the 1991 SC and ST files for Bihar. There seems to be an error in them.

R Packages

Huge thanks to the authors and maintainers of all of the R packages used to make this visualisation, especially the tidyverse, shiny, sf, leaflet, leaflet.extras, shinyWidgets, shinythemes, and shinycssloaders.

Further Information

The R scripts wrangling the data and creating the visualisation can be found on Github.

An exploration into the key findings, visualisation choices, and challenges can be found in a blog post for Social Cops.

Other data projects by the author can be found at his web site.

Any project feedback is greatly appreciated. The author can be contacted on Twitter or via the email address on his web page.