# What are the "score" and "percent\_rank" fields on the topics table?
**URL:** https://meta.discourse.org/t/what-are-the-score-and-percent-rank-fields-on-the-topics-table/87597
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [5월 16, 2018, 6:07오전 UTC](https://meta.discourse.org/t/what-are-the-score-and-percent-rank-fields-on-the-topics-table/87597 "2018-05-16T06:07:14Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@mcwumbly](https://meta.discourse.org/u/mcwumbly)
#### Post date: [5월 16, 2018, 6:07오전 UTC](https://meta.discourse.org/t/what-are-the-score-and-percent-rank-fields-on-the-topics-table/87597/1 "2018-05-16T06:07:14Z")
I was exploring some data this evening and came across the `score` and `percent_rank` fields in the `topics` table. But it wasn’t immediately obvious to me what these fields are, how they are calculated and what they are used for. I can spelunk through the source code if necessary, but I thought I’d ask if anyone has the TL;DR; on that info close at hand first.
---
### Author:  [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [5월 16, 2018, 6:41오전 UTC](https://meta.discourse.org/t/what-are-the-score-and-percent-rank-fields-on-the-topics-table/87597/2 "2018-05-16T06:41:57Z")
AFAIK, those have to do with the Top page and the summary emails.
Factors include, Likes, views, activity etc.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [11월 1, 2020, 6:15오후 UTC](https://meta.discourse.org/t/what-are-the-score-and-percent-rank-fields-on-the-topics-table/87597/3 "2020-11-01T18:15:16Z")