Insert historical data into statistics | Home Assistant | Page 1

sand agate Jun 13, 2025, 5:40 PM

#

How do I insert historical external data into statistics?

#

Insert historical data into statistics

rose salmon Jun 13, 2025, 5:41 PM

#

You don't, really. Integrations have a way of adding historical data, but it's not a general capability for end users

sand agate Jun 13, 2025, 6:45 PM

#

It's a one time thing, would inserting it into sqlite directly be possible? are there multiple tables that index the data which would need to be changed?

rose salmon Jun 13, 2025, 6:53 PM

#

Technically, yes

#

You can review the statistics table contents

#

https://www.home-assistant.io/docs/backend/database/

sand agate Jun 13, 2025, 7:03 PM

#

Thanks for the link

rose salmon Jun 13, 2025, 7:05 PM

#

I've deleted bad data from there, but I've never tried to add any

#Insert historical data into statistics