Post

JoSAA SQL Interface

JoSAA (Joint Seat Allocation Authority) publishes the opening and closing ranks for all IITs, NITs, Government funded technical institutes and IIITs - for the current as well as previous years.

I created a browser based SQL interface to access and explore this data at: https://pardhavmaradani.github.io/josaa-sql-interface/

I initially created a Chrome Extension to export JoSAA opening and closing rank data as CSV files. To make it easier for anyone, I put together all that data in a sqlite db and exposed it as a SQL Web Interface using sql.js. This requires familiarity with SQL, but allows all kinds of analysis and exploration of data using a standard interface.

All the code can be found in my josaa-sql-interface repository.

This post is licensed under CC BY 4.0 by the author.