2018 and 2009 Court Data — And Some Duplicates Removed

Removing Duplicates

My first mistake was not creating a unique index on FIPS code and Case Number. The Case Number is a unique identifier in each court. Since Case Numbers are not unique to all courts, the FIPS code of the court needs to be taken into account too. Since I didn’t create this constraint on my database, it was possible to scrape the same case twice and to create a duplicate database entry.

--

--

I make Virginia court case information available, in bulk. Twitter: @oilytheotter

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
VirginiaCourtData.org

VirginiaCourtData.org

I make Virginia court case information available, in bulk. Twitter: @oilytheotter