The Lemmyverse dataset has some non-intuitive fields. Here are some sample values from an arbitrary community:

published = 1732921065000
time = 1751969706903
score = 215906.1

The first two look like they could be seconds past epoch (1970-01-01 UTC), but they are not:

$ date --date=@1732921065000
Sun Jan 30 07:30:00 PM CET 56884
$ date --date=@1751969706903
Sat Sep 17 05:55:03 AM CEST 57487

And what is score?

From the instances DB, there are also some mysterious fields:

counts.site_id = 1
date = 2024-11-08T17:31:45.872091Z
published = 1731087105000
time = 1752302963566
score =
isSuspicious = 0
metrics.totalActivity = 2335
metrics.averageUsers = 7.5
metrics.biggestJump = 1
metrics.averagePerMinute = 9.0e-05
metrics.userActivityScore = 0.00385438972162741
metrics.activityUserScore = 259.444444444444
metrics.userActiveMonthScore = 9.0
trust.lastCrawled = 1752302963566
trust.*
blocks.*