PHPMem v2.0.1
Version
1.6.45
Uptime
15 days 9 hours 30 minutes 17 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 536
Rejected
0
llm:9bdbd79e02a972084982cec41fcf8102dc5b6786f4c36540fb45e2aa43617d1f
Edit
{
"sentences": [
{
"sid": 1,
"non_factual": null,
"claims": [
{
"quote": "there are very few exact duplicates, but a noticeable set of repeated keys (near-duplicates) in the three match-level fact tables",
"occurrence": 0,
"sids": [
1
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 2,
"non_factual": "heading",
"claims": []
},
{
"sid": 3,
"non_factual": null,
"claims": [
{
"quote": "237,205 rows",
"occurrence": 0,
"sids": [
3
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "raw_kaggle",
"sid": 3
}
],
"measure": null,
"aggregation": "count",
"value_literal": "237,205",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows"
]
}
},
{
"quote": "237,203 distinct",
"occurrence": 0,
"sids": [
3
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "raw_kaggle",
"sid": 3
}
],
"measure": null,
"aggregation": "count_distinct",
"value_literal": "237,203",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"distinct_rows"
]
}
},
{
"quote": "2 fully duplicated rows",
"occurrence": 0,
"sids": [
3
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "raw_kaggle",
"sid": 3
}
],
"measure": null,
"aggregation": "count",
"value_literal": "2",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows",
"distinct_rows"
]
}
}
]
},
{
"sid": 4,
"non_factual": null,
"claims": [
{
"quote": "237,196 rows",
"occurrence": 0,
"sids": [
4
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "return_kaggle",
"sid": 4
}
],
"measure": null,
"aggregation": "count",
"value_literal": "237,196",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows"
]
}
},
{
"quote": "237,194 distinct",
"occurrence": 0,
"sids": [
4
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "return_kaggle",
"sid": 4
}
],
"measure": null,
"aggregation": "count_distinct",
"value_literal": "237,194",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"distinct_rows"
]
}
},
{
"quote": "2 duplicates",
"occurrence": 0,
"sids": [
4
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "return_kaggle",
"sid": 4
}
],
"measure": null,
"aggregation": "count",
"value_literal": "2",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows",
"distinct_rows"
]
}
}
]
},
{
"sid": 5,
"non_factual": null,
"claims": [
{
"quote": "237,185 rows",
"occurrence": 0,
"sids": [
5
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "serve_kaggle",
"sid": 5
}
],
"measure": null,
"aggregation": "count",
"value_literal": "237,185",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows"
]
}
},
{
"quote": "237,183 distinct",
"occurrence": 0,
"sids": [
5
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "serve_kaggle",
"sid": 5
}
],
"measure": null,
"aggregation": "count_distinct",
"value_literal": "237,183",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"distinct_rows"
]
}
},
{
"quote": "2 duplicates",
"occurrence": 0,
"sids": [
5
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "serve_kaggle",
"sid": 5
}
],
"measure": null,
"aggregation": "count",
"value_literal": "2",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows",
"distinct_rows"
]
}
}
]
},
{
"sid": 6,
"non_factual": null,
"claims": [
{
"quote": "6,422 rows",
"occurrence": 0,
"sids": [
6
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "players_tournament_man_",
"sid": 6
}
],
"measure": null,
"aggregation": "count",
"value_literal": "6,422",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows"
]
}
},
{
"quote": "462 rows",
"occurrence": 0,
"sids": [
6
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "players_man_",
"sid": 6
}
],
"measure": null,
"aggregation": "count",
"value_literal": "462",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows"
]
}
},
{
"quote": "have no duplicates; every row is distinct",
"occurrence": 0,
"sids": [
6
],
"kind": "existence",
"labels": [
{
"column": "tbl",
"quote": "players_tournament_man_",
"sid": 6
},
{
"column": "tbl",
"quote": "players_man_",
"sid": 6
}
],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows",
"distinct_rows"
]
}
}
]
},
{
"sid": 7,
"non_factual": null,
"claims": [
{
"quote": "about 0.001% of each table",
"occurrence": 0,
"sids": [
7
],
"kind": "value",
"labels": [],
"measure": null,
"aggregation": "percent",
"value_literal": "0.001%",
"unit": "%",
"comparator": null,
"rank": null,
"filter": null,
"denominator": "rows in each table",
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows",
"distinct_rows"
]
}
}
]
},
{
"sid": 8,
"non_factual": null,
"claims": [
{
"quote": "one row per player per match (Name, Date, Tournament, Rd)",
"occurrence": 0,
"sids": [
8
],
"kind": "structural",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 9,
"non_factual": "lead_in",
"claims": []
},
{
"sid": 10,
"non_factual": null,
"claims": [
{
"quote": "1,250 extra rows",
"occurrence": 0,
"sids": [
10
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "raw_kaggle",
"sid": 10
}
],
"measure": null,
"aggregation": "count",
"value_literal": "1,250",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"tbl",
"extra_rows_on_key"
]
}
}
]
},
{
"sid": 11,
"non_factual": null,
"claims": [
{
"quote": "1,251 extra rows",
"occurrence": 0,
"sids": [
11
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "return_kaggle",
"sid": 11
}
],
"measure": null,
"aggregation": "count",
"value_literal": "1,251",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"tbl",
"extra_rows_on_key"
]
}
}
]
},
{
"sid": 12,
"non_factual": null,
"claims": [
{
"quote": "1,250 extra rows",
"occurrence": 0,
"sids": [
12
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "serve_kaggle",
"sid": 12
}
],
"measure": null,
"aggregation": "count",
"value_literal": "1,250",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"tbl",
"extra_rows_on_key"
]
}
}
]
},
{
"sid": 13,
"non_factual": null,
"claims": [
{
"quote": "0 extra rows",
"occurrence": 0,
"sids": [
13
],
"kind": "count",
"labels": [
{
"column": "tbl",
"quote": "players_tournament_man_",
"sid": 13
}
],
"measure": null,
"aggregation": "count",
"value_literal": "0",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"tbl",
"extra_rows_on_key"
]
}
}
]
},
{
"sid": 14,
"non_factual": null,
"claims": [
{
"quote": "Most of these 1,250 extra rows are not exact copies",
"occurrence": 0,
"sids": [
14
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"tbl",
"extra_rows_on_key"
]
}
},
{
"quote": "only 2 rows per table are fully identical",
"occurrence": 0,
"sids": [
14
],
"kind": "count",
"labels": [],
"measure": null,
"aggregation": "count",
"value_literal": "2",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows",
"distinct_rows"
]
}
}
]
},
{
"sid": 15,
"non_factual": null,
"claims": [
{
"quote": "They share a key but differ in at least one value.",
"occurrence": 0,
"sids": [
15
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 16,
"non_factual": "lead_in",
"claims": []
},
{
"sid": 17,
"non_factual": null,
"claims": [
{
"quote": "the same player meeting the same opponent twice in the same round of a tournament on the same date",
"occurrence": 0,
"sids": [
17
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 18,
"non_factual": null,
"claims": [
{
"quote": "a data-entry or scrape variant of the same match",
"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": null
}
]
},
{
"sid": 19,
"non_factual": null,
"claims": [
{
"quote": "I did not inspect these rows to tell which cause applies, so that remains unconfirmed.",
"occurrence": 0,
"sids": [
19
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 20,
"non_factual": null,
"claims": [
{
"quote": "The dimension tables are clean.",
"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": {
"ref": "E2",
"columns": [
"tbl",
"total_rows",
"distinct_rows"
]
}
}
]
},
{
"sid": 21,
"non_factual": null,
"claims": [
{
"quote": "only about 2 exact duplicate rows each",
"occurrence": 0,
"sids": [
21
],
"kind": "count",
"labels": [],
"measure": null,
"aggregation": "count",
"value_literal": "2",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"tbl",
"total_rows",
"distinct_rows"
]
}
},
{
"quote": "can be safely dropped",
"occurrence": 0,
"sids": [
21
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 22,
"non_factual": null,
"claims": [
{
"quote": "About 1,250 rows per table",
"occurrence": 0,
"sids": [
22
],
"kind": "count",
"labels": [],
"measure": null,
"aggregation": "count",
"value_literal": "1,250",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"tbl",
"extra_rows_on_key"
]
}
},
{
"quote": "roughly 0.5%",
"occurrence": 0,
"sids": [
22
],
"kind": "value",
"labels": [],
"measure": null,
"aggregation": "percent",
"value_literal": "0.5%",
"unit": "%",
"comparator": null,
"rank": null,
"filter": null,
"denominator": "rows in each table",
"binding": {
"ref": "E1",
"columns": [
"total_rows",
"extra_rows_on_key"
]
}
}
]
},
{
"sid": 23,
"non_factual": null,
"claims": [
{
"quote": "review them and either deduplicate or add a disambiguating field",
"occurrence": 0,
"sids": [
23
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 24,
"non_factual": null,
"claims": [
{
"quote": "The three tables are consistent with each other, with nearly identical counts of extra rows.",
"occurrence": 0,
"sids": [
24
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"tbl",
"extra_rows_on_key"
]
}
}
]
}
]
}