Tracking Trinidad and Tobago murders

I’ve blogged before about the open data journalism project called Bullet Points. Now I need your collective experience/expertise to help me with the project.

Bullet Points tracks murders in Trinidad and Tobago. The murders are tracked on this Google doc.

The fatal incidents are listed chronologically and are numbered by victim (murder toll). The victims are announced on Twitter by their toll number. This system has some serious limitations.

PROBLEM
Firstly, it is geared toward tracking the murder victims but is an inadequate way of tracking the actual killings themselves. For example, when there is a double murder, the toll goes up by two but the number of incidents goes up by only one.

Secondly, killings do not always occur in the same chronological order that the victims’ bodies are discovered. Sometimes bodies of murder victims are discovered after several days. When this happens, the relevant killing must be inserted somewhere in the middle of the existing chronological list, which obviously changes the toll count of all subsequent victims. Unfortunately, because our current system relies on the toll count to identify the victim, it has now run into this serious limitation.

PROPOSED SOLUTION
I think that what I need to do is add another column that contains a unique reference number for each incident. The unique reference number can follow a standard protocol such as [DATE][INTEGER]. For example, the most recent murder, which was discovered today, would have a reference number 2014013001. I think this will deal with the problem but I am not sure it is the best solution.

Thanks for taking the time to read this. If you think you can help, leave a comment below to share your perspective on this problem and proposed solution.

Advertisements

Please share your thoughts here.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s