Simple query shows empty result

[Anaisdg]

Hello @EDsteve,
Welcome! do you mind sharing the line protocol you used to write this data? I would first make sure that your idx is an int.
Secondly you need to query with quotes like this:
select * from train_speed where "location"='wewatta' limit 5