PHPMem v2.0.1
Version
1.6.45
Uptime
16 days 5 hours 21 minutes 2 seconds
Memory
Total
512MB
Used
11,10MB (2.17%)
Free
500,90MB
Keys
Current
12 504
Total (since start)
39 318
Evictions
0
Reclaimed
758
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
13 / 1 024 max
Total
185 651
Rejected
0
llm:d0ec8d102cbf478f5c6134c6fbaa6c32de60f25e0aee82a3181d38f735cffcf3
Edit
{
"sentences": [
{
"sid": 1,
"non_factual": null,
"claims": [
{
"quote": "62,496 rows",
"occurrence": 0,
"sids": [
1
],
"kind": "count",
"labels": [],
"measure": null,
"aggregation": "count",
"value_literal": "62,496",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E6",
"columns": [
"n_rows"
]
}
},
{
"quote": "11 websites",
"occurrence": 0,
"sids": [
1
],
"kind": "count",
"labels": [],
"measure": "WEBSITE",
"aggregation": "count_distinct",
"value_literal": "11",
"unit": "websites",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"sites"
]
}
},
{
"quote": "2014–2024",
"occurrence": 0,
"sids": [
1
],
"kind": "structural",
"labels": [],
"measure": "YEAR",
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"ymin",
"ymax"
]
}
},
{
"quote": "no nulls or negative values",
"occurrence": 0,
"sids": [
1
],
"kind": "existence",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E6",
"columns": [
"n_rows",
"nn_pv",
"nn_uv",
"nn_ent",
"nn_bounce",
"nn_exit",
"negatives"
]
}
}
]
},
{
"sid": 2,
"non_factual": null,
"claims": [
{
"quote": "The main problems are impossible metric relationships, extreme outliers, zeros that look like placeholders, and a small number of duplicates and format oddities.",
"occurrence": 0,
"sids": [
2
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 3,
"non_factual": "heading",
"claims": []
},
{
"sid": 4,
"non_factual": null,
"claims": [
{
"quote": "There are no nulls in page path, URL, bounce rate, exit rate, page views, unique views or entrances.",
"occurrence": 0,
"sids": [
4
],
"kind": "existence",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"null_path",
"null_url",
"null_bounce",
"null_exit"
]
}
}
]
},
{
"sid": 5,
"non_factual": null,
"claims": [
{
"quote": "Every column checked has 62,496 non-null values",
"occurrence": 0,
"sids": [
5
],
"kind": "count",
"labels": [],
"measure": null,
"aggregation": "count",
"value_literal": "62,496",
"unit": "values",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E6",
"columns": [
"n_rows",
"nn_pv",
"nn_uv",
"nn_ent",
"nn_bounce",
"nn_exit"
]
}
}
]
},
{
"sid": 6,
"non_factual": null,
"claims": [
{
"quote": "There are no negative values, and bounce and exit rates are never outside the valid range",
"occurrence": 0,
"sids": [
6
],
"kind": "existence",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E6",
"columns": [
"negatives",
"rate_out_of_range"
]
}
}
]
},
{
"sid": 7,
"non_factual": null,
"claims": [
{
"quote": "Unique views never exceed page views",
"occurrence": 0,
"sids": [
7
],
"kind": "value",
"labels": [],
"measure": "UNIQUE VIEWS",
"aggregation": "count",
"value_literal": "0",
"unit": null,
"comparator": null,
"rank": null,
"filter": "UNIQUE VIEWS > PAGE VIEWS",
"denominator": null,
"binding": {
"ref": "E6",
"columns": [
"uv_gt_pv"
]
}
}
]
},
{
"sid": 8,
"non_factual": null,
"claims": [
{
"quote": "That is the expected relationship.",
"occurrence": 0,
"sids": [
8
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 9,
"non_factual": "heading",
"claims": []
},
{
"sid": 10,
"non_factual": "heading",
"claims": []
},
{
"sid": 11,
"non_factual": null,
"claims": [
{
"quote": "24,648 of 62,496 rows",
"occurrence": 0,
"sids": [
11
],
"kind": "count",
"labels": [],
"measure": "ENTRANCES",
"aggregation": "count",
"value_literal": "24,648",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "ENTRANCES > PAGE VIEWS",
"denominator": null,
"binding": {
"ref": "E6",
"columns": [
"ent_gt_pv"
]
}
},
{
"quote": "about 39%",
"occurrence": 0,
"sids": [
11
],
"kind": "value",
"labels": [],
"measure": "ENTRANCES",
"aggregation": "percent",
"value_literal": "39%",
"unit": "%",
"comparator": null,
"rank": null,
"filter": "ENTRANCES > PAGE VIEWS",
"denominator": "all rows",
"binding": {
"ref": "E6",
"columns": [
"ent_gt_pv",
"n_rows"
]
}
}
]
},
{
"sid": 12,
"non_factual": null,
"claims": [
{
"quote": "An entrance is itself a page view, so this cannot be true.",
"occurrence": 0,
"sids": [
12
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 13,
"non_factual": null,
"claims": [
{
"quote": "11,830 rows",
"occurrence": 0,
"sids": [
13
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "www.brla.gov",
"sid": 13
}
],
"measure": "ENTRANCES",
"aggregation": "count",
"value_literal": "11,830",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "ENTRANCES > PAGE VIEWS",
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"entrances_gt_views"
]
}
},
{
"quote": "9,211",
"occurrence": 0,
"sids": [
13
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "brgov.com",
"sid": 13
}
],
"measure": "ENTRANCES",
"aggregation": "count",
"value_literal": "9,211",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "ENTRANCES > PAGE VIEWS",
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"entrances_gt_views"
]
}
},
{
"quote": "2,958",
"occurrence": 0,
"sids": [
13
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "data.brla.gov",
"sid": 13
}
],
"measure": "ENTRANCES",
"aggregation": "count",
"value_literal": "2,958",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "ENTRANCES > PAGE VIEWS",
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"entrances_gt_views"
]
}
},
{
"quote": "243",
"occurrence": 0,
"sids": [
13
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "city.brla.gov",
"sid": 13
}
],
"measure": "ENTRANCES",
"aggregation": "count",
"value_literal": "243",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "ENTRANCES > PAGE VIEWS",
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"entrances_gt_views"
]
}
},
{
"quote": "404 rows",
"occurrence": 0,
"sids": [
13
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "city.brla.gov",
"sid": 13
}
],
"measure": null,
"aggregation": "count",
"value_literal": "404",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"n_rows"
]
}
},
{
"quote": "87",
"occurrence": 0,
"sids": [
13
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "gis.brla.gov",
"sid": 13
}
],
"measure": "ENTRANCES",
"aggregation": "count",
"value_literal": "87",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "ENTRANCES > PAGE VIEWS",
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"entrances_gt_views"
]
}
},
{
"quote": "147",
"occurrence": 0,
"sids": [
13
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "gis.brla.gov",
"sid": 13
}
],
"measure": null,
"aggregation": "count",
"value_literal": "147",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"n_rows"
]
}
}
]
},
{
"sid": 14,
"non_factual": "lead_in",
"claims": []
},
{
"sid": 15,
"non_factual": null,
"claims": [
{
"quote": "Likely causes are sampling, or entrances and views being aggregated differently, for example by page path versus URL, or by session versus hit.",
"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": null,
"claims": [
{
"quote": "The source system would need to confirm.",
"occurrence": 0,
"sids": [
16
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 17,
"non_factual": null,
"claims": [
{
"quote": "Treat entrance-based metrics, such as entry-page rankings, as unreliable until this is understood.",
"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": "heading",
"claims": []
},
{
"sid": 19,
"non_factual": "heading",
"claims": []
},
{
"sid": 20,
"non_factual": null,
"claims": [
{
"quote": "8",
"occurrence": 0,
"sids": [
20
],
"kind": "value",
"labels": [],
"measure": "PAGE VIEWS",
"aggregation": "median",
"value_literal": "8",
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E6",
"columns": [
"median_pv"
]
}
},
{
"quote": "about 64.5k",
"occurrence": 0,
"sids": [
20
],
"kind": "value",
"labels": [],
"measure": "PAGE VIEWS",
"aggregation": "percentile",
"value_literal": "64.5k",
"unit": null,
"comparator": null,
"rank": null,
"filter": "99th percentile",
"denominator": null,
"binding": {
"ref": "E6",
"columns": [
"p99_pv"
]
}
},
{
"quote": "228,326,194",
"occurrence": 0,
"sids": [
20
],
"kind": "value",
"labels": [],
"measure": "PAGE VIEWS",
"aggregation": "max",
"value_literal": "228,326,194",
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E6",
"columns": [
"max_pv"
]
}
}
]
},
{
"sid": 21,
"non_factual": null,
"claims": [
{
"quote": "That maximum sits in city.brla.gov",
"occurrence": 0,
"sids": [
21
],
"kind": "categorical",
"labels": [
{
"column": "WEBSITE",
"quote": "city.brla.gov",
"sid": 21
}
],
"measure": "PAGE VIEWS",
"aggregation": "max",
"value_literal": "city.brla.gov",
"unit": null,
"comparator": "eq",
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"max_page_views"
]
}
},
{
"quote": "227,064,076",
"occurrence": 0,
"sids": [
21
],
"kind": "value",
"labels": [
{
"column": "WEBSITE",
"quote": "city.brla.gov",
"sid": 21
}
],
"measure": "ENTRANCES",
"aggregation": "max",
"value_literal": "227,064,076",
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"max_entrances"
]
}
}
]
},
{
"sid": 22,
"non_factual": null,
"claims": [
{
"quote": "only 404 rows",
"occurrence": 0,
"sids": [
22
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "city.brla.gov",
"sid": 22
}
],
"measure": null,
"aggregation": "count",
"value_literal": "404",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"n_rows"
]
}
},
{
"quote": "2,088",
"occurrence": 0,
"sids": [
22
],
"kind": "value",
"labels": [
{
"column": "WEBSITE",
"quote": "city.brla.gov",
"sid": 22
}
],
"measure": "PAGE VIEWS",
"aggregation": "median",
"value_literal": "2,088",
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"median_page_views"
]
}
}
]
},
{
"sid": 23,
"non_factual": null,
"claims": [
{
"quote": "One row there dwarfs everything else and will distort any sum or average.",
"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": "It looks like a site-level total, a root-page aggregate, or a bad load.",
"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": null
}
]
},
{
"sid": 25,
"non_factual": null,
"claims": [
{
"quote": "much smaller",
"occurrence": 0,
"sids": [
25
],
"kind": "comparison",
"labels": [
{
"column": "WEBSITE",
"quote": "www.brla.gov",
"sid": 25
},
{
"column": "WEBSITE",
"quote": "city.brla.gov",
"sid": 21
}
],
"measure": "PAGE VIEWS",
"aggregation": "max",
"value_literal": null,
"unit": null,
"comparator": "lt",
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"max_page_views"
]
}
},
{
"quote": "17.6M views",
"occurrence": 0,
"sids": [
25
],
"kind": "value",
"labels": [
{
"column": "WEBSITE",
"quote": "www.brla.gov",
"sid": 25
}
],
"measure": "PAGE VIEWS",
"aggregation": "max",
"value_literal": "17.6M",
"unit": "views",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"max_page_views"
]
}
},
{
"quote": "16.5M entrances",
"occurrence": 0,
"sids": [
25
],
"kind": "value",
"labels": [
{
"column": "WEBSITE",
"quote": "www.brla.gov",
"sid": 25
}
],
"measure": "ENTRANCES",
"aggregation": "max",
"value_literal": "16.5M",
"unit": "entrances",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"max_entrances"
]
}
},
{
"quote": "2.36M views",
"occurrence": 0,
"sids": [
25
],
"kind": "value",
"labels": [
{
"column": "WEBSITE",
"quote": "my.brla.gov",
"sid": 25
}
],
"measure": "PAGE VIEWS",
"aggregation": "max",
"value_literal": "2.36M",
"unit": "views",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"max_page_views"
]
}
}
]
},
{
"sid": 26,
"non_factual": null,
"claims": [
{
"quote": "1,680,247 entrances",
"occurrence": 0,
"sids": [
26
],
"kind": "value",
"labels": [
{
"column": "WEBSITE",
"quote": "gis.brla.gov",
"sid": 26
}
],
"measure": "ENTRANCES",
"aggregation": "max",
"value_literal": "1,680,247",
"unit": "entrances",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"max_entrances"
]
}
},
{
"quote": "110,198 maximum page views",
"occurrence": 0,
"sids": [
26
],
"kind": "value",
"labels": [
{
"column": "WEBSITE",
"quote": "gis.brla.gov",
"sid": 26
}
],
"measure": "PAGE VIEWS",
"aggregation": "max",
"value_literal": "110,198",
"unit": "page views",
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": {
"ref": "E1",
"columns": [
"WEBSITE",
"max_page_views"
]
}
}
]
},
{
"sid": 27,
"non_factual": null,
"claims": [
{
"quote": "That is another case of entrances exceeding views.",
"occurrence": 0,
"sids": [
27
],
"kind": "interpretation",
"labels": [
{
"column": "WEBSITE",
"quote": "gis.brla.gov",
"sid": 26
}
],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 28,
"non_factual": null,
"claims": [
{
"quote": "Use medians or trimmed sums instead of raw totals.",
"occurrence": 0,
"sids": [
28
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 29,
"non_factual": "heading",
"claims": []
},
{
"sid": 30,
"non_factual": "heading",
"claims": []
},
{
"sid": 31,
"non_factual": null,
"claims": [
{
"quote": "7,319 rows",
"occurrence": 0,
"sids": [
31
],
"kind": "count",
"labels": [],
"measure": "AVERAGE TIME ON PAGE (SECONDS)",
"aggregation": "count",
"value_literal": "7,319",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "AVERAGE TIME ON PAGE (SECONDS) = 0",
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"zero_time"
]
}
}
]
},
{
"sid": 32,
"non_factual": null,
"claims": [
{
"quote": "That is plausible for single-page or bounced visits, but it may also mean the value was not captured.",
"occurrence": 0,
"sids": [
32
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
},
{
"sid": 33,
"non_factual": null,
"claims": [
{
"quote": "2,675",
"occurrence": 0,
"sids": [
33
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "brgov.com",
"sid": 33
}
],
"measure": "AVERAGE TIME ON PAGE (SECONDS)",
"aggregation": "count",
"value_literal": "2,675",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "AVERAGE TIME ON PAGE (SECONDS) = 0",
"denominator": null,
"binding": {
"ref": "E3",
"columns": [
"WEBSITE",
"zero_time"
]
}
},
{
"quote": "2,531",
"occurrence": 0,
"sids": [
33
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "www.brla.gov",
"sid": 33
}
],
"measure": "AVERAGE TIME ON PAGE (SECONDS)",
"aggregation": "count",
"value_literal": "2,531",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "AVERAGE TIME ON PAGE (SECONDS) = 0",
"denominator": null,
"binding": {
"ref": "E3",
"columns": [
"WEBSITE",
"zero_time"
]
}
}
]
},
{
"sid": 34,
"non_factual": null,
"claims": [
{
"quote": "6 rows have zero page views",
"occurrence": 0,
"sids": [
34
],
"kind": "count",
"labels": [],
"measure": "PAGE VIEWS",
"aggregation": "count",
"value_literal": "6",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "PAGE VIEWS = 0",
"denominator": null,
"binding": {
"ref": "E2",
"columns": [
"zero_pv"
]
}
},
{
"quote": "4 in budget.brla.gov",
"occurrence": 0,
"sids": [
34
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "budget.brla.gov",
"sid": 34
}
],
"measure": "PAGE VIEWS",
"aggregation": "count",
"value_literal": "4",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "PAGE VIEWS = 0",
"denominator": null,
"binding": {
"ref": "E4",
"columns": [
"WEBSITE",
"zero_pv"
]
}
},
{
"quote": "2 in my.brla.gov",
"occurrence": 0,
"sids": [
34
],
"kind": "count",
"labels": [
{
"column": "WEBSITE",
"quote": "my.brla.gov",
"sid": 34
}
],
"measure": "PAGE VIEWS",
"aggregation": "count",
"value_literal": "2",
"unit": "rows",
"comparator": null,
"rank": null,
"filter": "PAGE VIEWS = 0",
"denominator": null,
"binding": {
"ref": "E4",
"columns": [
"WEBSITE",
"zero_pv"
]
}
}
]
},
{
"sid": 35,
"non_factual": null,
"claims": [
{
"quote": "A page listed with no views is odd and may be a leftover record.",
"occurrence": 0,
"sids": [
35
],
"kind": "interpretation",
"labels": [],
"measure": null,
"aggregation": null,
"value_literal": null,
"unit": null,
"comparator": null,
"rank": null,
"filter": null,
"denominator": null,
"binding": null
}
]
}
]
}