PHPMem v2.0.1

Version
1.6.45
Uptime
15 days 8 hours 19 minutes 12 seconds

Memory

Total
512MB
Used
24,01MB (4.69%)
Free
487,99MB

Keys

Current
27 650
Total (since start)
33 978
Evictions
0
Reclaimed
160
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
11 / 1 024 max
Total
170 057
Rejected
0
llm:af9f753b705d24803982a8b17951d2ef0900173225ae50a031ef7f8561abcb44
TTL 6 days 22 hours 2 minutes 32 seconds Size 10,64KB Export
Edit
{
    "sentences": [
        {
            "sid": 1,
            "non_factual": null,
            "claims": [
                {
                    "quote": "Thirteen columns",
                    "occurrence": 0,
                    "sids": [
                        1
                    ],
                    "kind": "count",
                    "labels": [],
                    "measure": null,
                    "aggregation": "count",
                    "value_literal": "Thirteen",
                    "unit": "columns",
                    "comparator": "eq",
                    "rank": null,
                    "filter": "null_count > 0",
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "column_name"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 2,
            "non_factual": null,
            "claims": [
                {
                    "quote": "The other columns in those tables, and the two player tables, were not flagged.",
                    "occurrence": 0,
                    "sids": [
                        2
                    ],
                    "kind": "existence",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "table_name",
                            "column_name"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 3,
            "non_factual": null,
            "claims": [
                {
                    "quote": "13 matches",
                    "occurrence": 0,
                    "sids": [
                        3
                    ],
                    "kind": "count",
                    "labels": [],
                    "measure": null,
                    "aggregation": "count",
                    "value_literal": "13",
                    "unit": "matches",
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "column_name"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 4,
            "non_factual": null,
            "claims": [
                {
                    "quote": "237,205 rows",
                    "occurrence": 0,
                    "sids": [
                        4
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 4
                        }
                    ],
                    "measure": "row_count",
                    "aggregation": "none",
                    "value_literal": "237,205",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "row_count"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 5,
            "non_factual": null,
            "claims": [
                {
                    "quote": "86,799 rows",
                    "occurrence": 0,
                    "sids": [
                        5
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 4
                        }
                    ],
                    "measure": "null_count",
                    "aggregation": "none",
                    "value_literal": "86,799",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                },
                {
                    "quote": "36.59%",
                    "occurrence": 0,
                    "sids": [
                        5
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 4
                        }
                    ],
                    "measure": "null_count",
                    "aggregation": "percent",
                    "value_literal": "36.59%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 6,
            "non_factual": null,
            "claims": [
                {
                    "quote": "The counts are identical across all seven columns.",
                    "occurrence": 0,
                    "sids": [
                        6
                    ],
                    "kind": "comparison",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 4
                        }
                    ],
                    "measure": "null_count",
                    "aggregation": "none",
                    "value_literal": null,
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 7,
            "non_factual": null,
            "claims": [
                {
                    "quote": "That suggests these stats are absent together for the same matches (probably matches with no detailed stats recorded), not scattered gaps.",
                    "occurrence": 0,
                    "sids": [
                        7
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 8,
            "non_factual": null,
            "claims": [
                {
                    "quote": "10,394 rows",
                    "occurrence": 0,
                    "sids": [
                        8
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 4
                        }
                    ],
                    "measure": "vRk",
                    "aggregation": "none",
                    "value_literal": "10,394",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": "null_count",
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                },
                {
                    "quote": "4.38%",
                    "occurrence": 0,
                    "sids": [
                        8
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 4
                        }
                    ],
                    "measure": "vRk",
                    "aggregation": "percent",
                    "value_literal": "4.38%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 9,
            "non_factual": null,
            "claims": [
                {
                    "quote": "4,388 rows",
                    "occurrence": 0,
                    "sids": [
                        9
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 4
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "none",
                    "value_literal": "4,388",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": "null_count",
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                },
                {
                    "quote": "1.85%",
                    "occurrence": 0,
                    "sids": [
                        9
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 4
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "percent",
                    "value_literal": "1.85%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 10,
            "non_factual": null,
            "claims": [
                {
                    "quote": "237,185 rows",
                    "occurrence": 0,
                    "sids": [
                        10
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "serve_kaggle",
                            "sid": 10
                        }
                    ],
                    "measure": "row_count",
                    "aggregation": "none",
                    "value_literal": "237,185",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "row_count"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 11,
            "non_factual": null,
            "claims": [
                {
                    "quote": "10,394 rows",
                    "occurrence": 0,
                    "sids": [
                        11
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "serve_kaggle",
                            "sid": 10
                        }
                    ],
                    "measure": "vRk",
                    "aggregation": "none",
                    "value_literal": "10,394",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": "null_count",
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                },
                {
                    "quote": "4.38%",
                    "occurrence": 0,
                    "sids": [
                        11
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "serve_kaggle",
                            "sid": 10
                        }
                    ],
                    "measure": "vRk",
                    "aggregation": "percent",
                    "value_literal": "4.38%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 12,
            "non_factual": null,
            "claims": [
                {
                    "quote": "4,388 rows",
                    "occurrence": 0,
                    "sids": [
                        12
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "serve_kaggle",
                            "sid": 10
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "none",
                    "value_literal": "4,388",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": "null_count",
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                },
                {
                    "quote": "1.85%",
                    "occurrence": 0,
                    "sids": [
                        12
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "serve_kaggle",
                            "sid": 10
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "percent",
                    "value_literal": "1.85%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 13,
            "non_factual": null,
            "claims": [
                {
                    "quote": "237,196 rows",
                    "occurrence": 0,
                    "sids": [
                        13
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "return_kaggle",
                            "sid": 13
                        }
                    ],
                    "measure": "row_count",
                    "aggregation": "none",
                    "value_literal": "237,196",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "row_count"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 14,
            "non_factual": null,
            "claims": [
                {
                    "quote": "10,394 rows",
                    "occurrence": 0,
                    "sids": [
                        14
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "return_kaggle",
                            "sid": 13
                        }
                    ],
                    "measure": "vRk",
                    "aggregation": "none",
                    "value_literal": "10,394",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": "null_count",
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                },
                {
                    "quote": "4.38%",
                    "occurrence": 0,
                    "sids": [
                        14
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "return_kaggle",
                            "sid": 13
                        }
                    ],
                    "measure": "vRk",
                    "aggregation": "percent",
                    "value_literal": "4.38%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 15,
            "non_factual": null,
            "claims": [
                {
                    "quote": "4,388 rows",
                    "occurrence": 0,
                    "sids": [
                        15
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "return_kaggle",
                            "sid": 13
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "none",
                    "value_literal": "4,388",
                    "unit": "rows",
                    "comparator": null,
                    "rank": null,
                    "filter": "null_count",
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                },
                {
                    "quote": "1.85%",
                    "occurrence": 0,
                    "sids": [
                        15
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "return_kaggle",
                            "sid": 13
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "percent",
                    "value_literal": "1.85%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 16,
            "non_factual": "heading",
            "claims": []
        },
        {
            "sid": 17,
            "non_factual": null,
            "claims": [
                {
                    "quote": "The biggest gap is the block of seven serve and point stats",
                    "occurrence": 0,
                    "sids": [
                        17
                    ],
                    "kind": "rank",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 17
                        }
                    ],
                    "measure": "null_count",
                    "aggregation": "max",
                    "value_literal": null,
                    "unit": null,
                    "comparator": "rank",
                    "rank": 1,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "column_name",
                            "pct_missing"
                        ]
                    }
                },
                {
                    "quote": "36.59%",
                    "occurrence": 0,
                    "sids": [
                        17
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "table_name",
                            "quote": "raw_kaggle",
                            "sid": 17
                        }
                    ],
                    "measure": "null_count",
                    "aggregation": "percent",
                    "value_literal": "36.59%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 18,
            "non_factual": null,
            "claims": [
                {
                    "quote": "will lose about a third of the rows unless you filter or impute",
                    "occurrence": 0,
                    "sids": [
                        18
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 19,
            "non_factual": null,
            "claims": [
                {
                    "quote": "identical missing counts in all three tables",
                    "occurrence": 0,
                    "sids": [
                        19
                    ],
                    "kind": "comparison",
                    "labels": [],
                    "measure": "null_count",
                    "aggregation": "none",
                    "value_literal": null,
                    "unit": null,
                    "comparator": "eq",
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                },
                {
                    "quote": "4,388",
                    "occurrence": 0,
                    "sids": [
                        19
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "column_name",
                            "quote": "`Rk`",
                            "sid": 19
                        }
                    ],
                    "measure": "Rk",
                    "aggregation": "none",
                    "value_literal": "4,388",
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": "null_count",
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                },
                {
                    "quote": "10,394",
                    "occurrence": 0,
                    "sids": [
                        19
                    ],
                    "kind": "value",
                    "labels": [
                        {
                            "column": "column_name",
                            "quote": "`vRk`",
                            "sid": 19
                        }
                    ],
                    "measure": "vRk",
                    "aggregation": "none",
                    "value_literal": "10,394",
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": "null_count",
                    "denominator": null,
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "null_count"
                        ]
                    }
                }
            ]
        },
        {
            "sid": 20,
            "non_factual": null,
            "claims": [
                {
                    "quote": "They are likely missing for the same player-matches, for example unranked players.",
                    "occurrence": 0,
                    "sids": [
                        20
                    ],
                    "kind": "interpretation",
                    "labels": [],
                    "measure": null,
                    "aggregation": null,
                    "value_literal": null,
                    "unit": null,
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": null,
                    "binding": null
                }
            ]
        },
        {
            "sid": 21,
            "non_factual": null,
            "claims": [
                {
                    "quote": "1.85%",
                    "occurrence": 0,
                    "sids": [
                        21
                    ],
                    "kind": "value",
                    "labels": [],
                    "measure": "Rk",
                    "aggregation": "percent",
                    "value_literal": "1.85%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                },
                {
                    "quote": "4.38%",
                    "occurrence": 0,
                    "sids": [
                        21
                    ],
                    "kind": "value",
                    "labels": [],
                    "measure": "vRk",
                    "aggregation": "percent",
                    "value_literal": "4.38%",
                    "unit": "%",
                    "comparator": null,
                    "rank": null,
                    "filter": null,
                    "denominator": "row_count",
                    "binding": {
                        "ref": "E1",
                        "columns": [
                            "pct_missing"
                        ]
                    }
                }
            ]
        }
    ]
}