PHPMem v2.0.1

Version
1.6.45
Uptime
16 days 5 hours 21 minutes 52 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 671
Rejected
0
llm:6631b3b9434d99e7568dd7ad36b6868902969ed06aa3ad246c4d48a31beb8959
TTL 6 days 21 hours 43 minutes 38 seconds Size 9,11KB Export
Edit
{
    "slots": [
        {
            "scope": "dataset",
            "slot": "nature",
            "value": {
                "nature": "observational"
            },
            "evidence": {
                "reasoning": "Funding rounds of Indian startups scraped from public listings (Kaggle export). Nobody here operates the funding process; it records externally observed events."
            }
        },
        {
            "scope": "dataset",
            "slot": "decisions_served",
            "value": {
                "decisions": [
                    "Which sectors and cities are attracting the most venture funding, so an investor can decide where to look for deals",
                    "Which investors are active at which funding stage, so a founder can decide whom to approach",
                    "How large typical rounds are at each stage, so a startup can benchmark a fundraising target",
                    "Whether funding activity is rising or falling month to month in early 2022, so an analyst can judge market momentum"
                ]
            },
            "evidence": {
                "reasoning": "Each monthly table lists company, sector, location, investor, stage and amount for rounds announced January to May 2022."
            }
        },
        {
            "scope": "dataset",
            "slot": "levers",
            "value": {
                "levers": []
            },
            "evidence": {
                "reasoning": "The data records funding rounds announced by third parties. No operator controls the measured amounts, stages or investor choices, so there is no lever."
            }
        },
        {
            "scope": "dataset",
            "slot": "audience",
            "value": {
                "audience": [
                    "venture capital analyst",
                    "startup founder",
                    "market researcher",
                    "ecosystem or policy analyst"
                ]
            },
            "evidence": {
                "reasoning": "The content is a funding and investor directory for the Indian startup ecosystem."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data April 2022",
            "slot": "role",
            "value": {
                "role": "fact"
            },
            "evidence": {
                "reasoning": "Each row is one funding round with an Amount measure, even though the classifier labelled it a dimension."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data April 2022",
            "slot": "grain",
            "value": {
                "unit": "one row per funding round announced in April 2022 (company)",
                "key_columns": [
                    "Company Name"
                ]
            },
            "evidence": {
                "reasoning": "Company Name is 98.95% unique with 94 values in 95 rows, so it is near-unique. A repeated company would be a separate round."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data April 2022",
            "slot": "column_bindings",
            "value": {
                "bindings": [
                    {
                        "column": "Company Name",
                        "binding": "identifier"
                    },
                    {
                        "column": "Founded",
                        "binding": "temporal"
                    },
                    {
                        "column": "Location",
                        "binding": "category"
                    },
                    {
                        "column": "Sector",
                        "binding": "category"
                    },
                    {
                        "column": "What it does",
                        "binding": "category"
                    },
                    {
                        "column": "Founders",
                        "binding": "category"
                    },
                    {
                        "column": "Investor",
                        "binding": "category"
                    },
                    {
                        "column": "Amount",
                        "binding": "measure"
                    },
                    {
                        "column": "Stage",
                        "binding": "category"
                    },
                    {
                        "column": "_ingestion_timestamp",
                        "binding": "temporal"
                    },
                    {
                        "column": "_batch_id",
                        "binding": "category"
                    },
                    {
                        "column": "_source_file",
                        "binding": "category"
                    },
                    {
                        "column": "_source_system",
                        "binding": "category"
                    }
                ]
            },
            "evidence": {
                "reasoning": "Amount is a currency string such as '$15,300,000' and is a measure, not an identifier. Some values lack the '$' prefix and need cleaning."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data April 2022",
            "slot": "derived_measures",
            "value": {
                "measures": [
                    {
                        "column": "Amount",
                        "derived_from": [
                            "Amount"
                        ],
                        "rule": "Strip '$' and commas and cast to a number to get the funding amount in USD. Some rows are blank or lack the '$' prefix."
                    }
                ]
            },
            "evidence": {
                "reasoning": "Amount is stored as text with currency formatting."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data February 2022",
            "slot": "column_bindings",
            "value": {
                "bindings": [
                    {
                        "column": "Company Name",
                        "binding": "identifier"
                    },
                    {
                        "column": "Founded",
                        "binding": "temporal"
                    },
                    {
                        "column": "Location",
                        "binding": "category"
                    },
                    {
                        "column": "Sector",
                        "binding": "category"
                    },
                    {
                        "column": "What it does",
                        "binding": "category"
                    },
                    {
                        "column": "Founders",
                        "binding": "category"
                    },
                    {
                        "column": "Investor",
                        "binding": "category"
                    },
                    {
                        "column": "Amount",
                        "binding": "measure"
                    },
                    {
                        "column": "Stage",
                        "binding": "category"
                    },
                    {
                        "column": "_ingestion_timestamp",
                        "binding": "temporal"
                    },
                    {
                        "column": "_batch_id",
                        "binding": "category"
                    },
                    {
                        "column": "_source_file",
                        "binding": "category"
                    },
                    {
                        "column": "_source_system",
                        "binding": "category"
                    }
                ]
            },
            "evidence": {
                "reasoning": "The free-text description and founder names are descriptive attributes, not keys, even though they are unique."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data February 2022",
            "slot": "derived_measures",
            "value": {
                "measures": [
                    {
                        "column": "Amount",
                        "derived_from": [
                            "Amount"
                        ],
                        "rule": "Strip '$' and commas and cast to a number to get the funding amount in USD. Blank values mean the amount was not disclosed."
                    }
                ]
            },
            "evidence": {
                "reasoning": "Amount is stored as a currency-formatted string."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data January 2022",
            "slot": "grain",
            "value": {
                "unit": "one row per funding round announced in January 2022 (company)",
                "key_columns": [
                    "Company Name"
                ]
            },
            "evidence": {
                "reasoning": "Company Name is 99.1% unique, so it is a better grain than Founders, which is unique only because every founder string differs. Founders is a descriptive attribute."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data January 2022",
            "slot": "column_bindings",
            "value": {
                "bindings": [
                    {
                        "column": "Company Name",
                        "binding": "identifier"
                    },
                    {
                        "column": "Founded",
                        "binding": "temporal"
                    },
                    {
                        "column": "Location",
                        "binding": "category"
                    },
                    {
                        "column": "Sector",
                        "binding": "category"
                    },
                    {
                        "column": "What it does",
                        "binding": "category"
                    },
                    {
                        "column": "Founders",
                        "binding": "category"
                    },
                    {
                        "column": "Investor",
                        "binding": "category"
                    },
                    {
                        "column": "Amount",
                        "binding": "measure"
                    },
                    {
                        "column": "Stage",
                        "binding": "category"
                    },
                    {
                        "column": "_ingestion_timestamp",
                        "binding": "temporal"
                    },
                    {
                        "column": "_batch_id",
                        "binding": "category"
                    },
                    {
                        "column": "_source_file",
                        "binding": "category"
                    },
                    {
                        "column": "_source_system",
                        "binding": "category"
                    }
                ]
            },
            "evidence": {
                "reasoning": "Only Company Name identifies the entity. Founders and description are descriptive text."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data January 2022",
            "slot": "derived_measures",
            "value": {
                "measures": [
                    {
                        "column": "Amount",
                        "derived_from": [
                            "Amount"
                        ],
                        "rule": "Strip '$' and commas and cast to a number to get the funding amount in USD. Some values use Indian digit grouping, e.g. '$1,40,000', so parse carefully."
                    }
                ]
            },
            "evidence": {
                "reasoning": "Amount is currency text with inconsistent grouping."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data March 2022",
            "slot": "column_bindings",
            "value": {
                "bindings": [
                    {
                        "column": "Company Name",
                        "binding": "identifier"
                    },
                    {
                        "column": "Founded",
                        "binding": "temporal"
                    },
                    {
                        "column": "Location",
                        "binding": "category"
                    },
                    {
                        "column": "Sector",
                        "binding": "category"
                    },
                    {
                        "column": "What it does",
                        "binding": "category"
                    },
                    {
                        "column": "Founders",
                        "binding": "category"
                    },
                    {
                        "column": "Investor",
                        "binding": "category"
                    },
                    {
                        "column": "Amount",
                        "binding": "measure"
                    },
                    {
                        "column": "Stage",
                        "binding": "category"
                    },
                    {
                        "column": "_ingestion_timestamp",
                        "binding": "temporal"
                    },
                    {
                        "column": "_batch_id",
                        "binding": "category"
                    },
                    {
                        "column": "_source_file",
                        "binding": "category"
                    },
                    {
                        "column": "_source_system",
                        "binding": "category"
                    }
                ]
            },
            "evidence": {
                "reasoning": "The description and founder text are descriptive, not identifiers."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data March 2022",
            "slot": "derived_measures",
            "value": {
                "measures": [
                    {
                        "column": "Amount",
                        "derived_from": [
                            "Amount"
                        ],
                        "rule": "Strip '$' and commas and cast to a number to get the funding amount in USD. Blank values mean the amount was not disclosed."
                    }
                ]
            },
            "evidence": {
                "reasoning": "Amount is stored as currency text."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data May 2022",
            "slot": "grain",
            "value": {
                "unit": "one row per funding round announced in May 2022 (company); some rows are misaligned or blank",
                "key_columns": [
                    "Company Name"
                ]
            },
            "evidence": {
                "reasoning": "Company Name has 24 distinct values in 42 rows, so there are blanks. At least one sample row has its columns shifted, e.g. Founded='Noida' and What it does='$3,500,000'."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data May 2022",
            "slot": "temporal_posture",
            "value": {
                "posture": "mixed: Founded is text because of misaligned rows, plus an ingestion timestamp",
                "columns": [
                    "Founded",
                    "_ingestion_timestamp"
                ]
            },
            "evidence": {
                "reasoning": "Founded has type text with blank and non-year values, unlike the other months where it is an integer."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data May 2022",
            "slot": "column_bindings",
            "value": {
                "bindings": [
                    {
                        "column": "Company Name",
                        "binding": "identifier"
                    },
                    {
                        "column": "Founded",
                        "binding": "temporal"
                    },
                    {
                        "column": "Location",
                        "binding": "category"
                    },
                    {
                        "column": "Sector",
                        "binding": "category"
                    },
                    {
                        "column": "What it does",
                        "binding": "category"
                    },
                    {
                        "column": "Founders",
                        "binding": "category"
                    },
                    {
                        "column": "Investor",
                        "binding": "category"
                    },
                    {
                        "column": "Amount",
                        "binding": "measure"
                    },
                    {
                        "column": "Stage",
                        "binding": "category"
                    },
                    {
                        "column": "_ingestion_timestamp",
                        "binding": "temporal"
                    },
                    {
                        "column": "_batch_id",
                        "binding": "category"
                    },
                    {
                        "column": "_source_file",
                        "binding": "category"
                    },
                    {
                        "column": "_source_system",
                        "binding": "category"
                    }
                ]
            },
            "evidence": {
                "reasoning": "Company Name is an identifier despite blanks. Misaligned rows shift values across columns."
            }
        },
        {
            "scope": "table:Indian Startups _ Funding  Investors Data May 2022",
            "slot": "derived_measures",
            "value": {
                "measures": [
                    {
                        "column": "Amount",
                        "derived_from": [
                            "Amount"
                        ],
                        "rule": "Strip '$' and commas and cast to a number to get the funding amount in USD. Skip blank and misaligned rows."
                    }
                ]
            },
            "evidence": {
                "reasoning": "Amount is currency text with blanks."
            }
        }
    ]
}