Database

Download posts.csv

Written 2026-10-21 00:03 UTC, 1.0 KB. A new copy is written once a day, soon after midnight UTC.

What's in it

A line for each post with votes or a ruling, under this header:

post,platform,creator,label,ai,looks_real,ruling,ruled

• post is the post's hash, the same one the list uses. The API page says how to work it out from a post's id.
• platform is the site, like tiktok or youtube.
• creator is a hash of the account that posted it. It stays empty until reports from enough networks agree on who that is.
• label is the code the list gives the post on its own: 1, 2, 3, 5 or 7, or 0 when it isn't listed. A creator ruled AI-made doesn't change it, so look for code 6 on the creator in the list.
• ai and looks_real are its vote counts, as the list has them.
• ruling is ai or real when the owner of this server looked at the post, and ruled is the day they did, in UTC.

Nothing in it says who reported a post. Install IDs, the network codes and everything sent with an appeal stay on the server. A post leaves the file 30 days after its last vote, as it leaves the list, unless the owner ruled on it.

The vote log has every vote behind these numbers, if you'd rather work out the counts yourself.

License

The database is under CC BY-NC-SA 4.0, the same as the list and the log. Credit it with Uses SecondLook data licensed under CC BY-NC-SA 4.0 and a link to this server. Using it in something you charge for needs a separate license, as the license page says.