Add date column to locations table

Adding a new 'date' column to locations table

cc: @jjmerino, @kmeurer, @jamesongamble, @suprbh