Thanks, Gary. I've tried this
echo "SELECT * FROM archive WHERE (RainRate > 13);" | sqlite3 /home/pi/ weewxcopy.sdb 1581284100|1|5|28.994532150147|||29.005||||||||||||4.72|43.3322839672562|| 0.0|||||||||||||||||||||46.1|||||||50.0|69.5||-88.0|-90.0|2.0|8.0 ||||||||||||90.0|46.1||||||28.8686683318007||0.11811023625||13.3385826805|| 99.9375|||||||||||||||2.0|8.0|2.0|8.0|-88.0|-90.0|-88.0|-90.0||0.0||||46.1| 202.5|10.0|337.5||2.0 1581284400|1|5|28.9915092022014|||29.002||||||||||||4.72|41.9497362666115|| 0.0|||||||||||||||||||||44.7|||||||50.0|69.5||-88.0|-90.0|2.0|8.0 ||||||||||||90.0|44.7||||||28.8656567623561||0.18110236225||13.3385826805|| 99.9375|||||||||||||||2.0|8.0|2.0|8.0|-88.0|-90.0|-88.0|-90.0||0.0||||44.7| 45.0|14.0|112.5||3.0 but I can't see which data is bad. Is it possible that *Highest Daily RainRate* is a calculated value? If so what will be the right way to fix my 13107 mm/hr highest daily rainrate on 4 July 2020 09:33? Am Montag, 6. Juli 2020 12:33:07 UTC+2 schrieb gjr80: > > Hi, > > The wiki article “Cleaning up old ‘bad’ data” ( > https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data) would be > a good starting point. > > Gary -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/d5bf5928-6ddc-4bb3-9c5a-97d2ec7f8ddao%40googlegroups.com.