Early TimesColonist Transcripts Database

The goal of this project is to take a collection of transcripts of new stories from early editions of the Times Colonist and other Victoria newspapers which are currently in text files containing special codes for various bits of information, normalize the records, put them into an SQL database and then write a querying front-end to allow students, researchers and the general public to have access to this information on the history of colonial Vancouver Island.

You can read the Early TimesColonist transcripts development blog.