{"data":{"schemaVersion":"realm.temporal-relationships.v1","temporalSemantics":{"validTime":{"granularity":"date","bounds":"inclusive","nullStart":"start date not published in the upstream history row","nullEnd":"open-ended in the upstream history row; not independent proof of present control"},"transactionTime":{"observedAt":"2026-10-17T05:35:58.500035+00:00","meaning":"time the checksum-addressed MDRS artifacts were observed by the PostgreSQL ingestion"},"derivation":{"controllerControlsOperator":"intersection of controller and operator valid-time intervals evidenced through this mine","currentIdentity":"current controller and operator are asserted only by the MDRS Mines snapshot"}},"current":{"mine":{"type":"mine","id":"4300113","name":"GUILDHALL SAND & GRAVEL"},"operator":{"type":"operator","id":"L10129","name":"Pike Industries"},"controller":{"type":"controller","id":"M06183","name":"CRH PLC"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-17T05:35:58.500035+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L06165","name":"Lawrence Sangravco Inc"},"object":{"type":"mine","id":"4300113","name":"GUILDHALL SAND & GRAVEL"},"validFrom":"1950-01-01","validTo":"1983-05-03","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|L06165|1950-01-01|1983-05-03"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M04919","name":"F Ray  Lawrence"},"object":{"type":"mine","id":"4300113","name":"GUILDHALL SAND & GRAVEL"},"validFrom":"1950-01-01","validTo":"1983-05-03","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|M04919|1950-01-01|1983-05-03"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M04919","name":"F Ray  Lawrence"},"object":{"type":"operator","id":"L06165","name":"Lawrence Sangravco Inc"},"validFrom":"1950-01-01","validTo":"1983-05-03","current":false,"derived":true,"evidenceMineId":"4300113","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|L06165|1950-01-01|M04919|1950-01-01|133266"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L06166","name":"Lawrence Sangravco Inc"},"object":{"type":"mine","id":"4300113","name":"GUILDHALL SAND & GRAVEL"},"validFrom":"1983-05-04","validTo":"1995-09-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|L06166|1983-05-04|1995-09-30"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M03846","name":"Rita M  Calkins"},"object":{"type":"mine","id":"4300113","name":"GUILDHALL SAND & GRAVEL"},"validFrom":"1983-05-04","validTo":"1995-09-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|M03846|1983-05-04|1995-09-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M03846","name":"Rita M  Calkins"},"object":{"type":"operator","id":"L06166","name":"Lawrence Sangravco Inc"},"validFrom":"1983-05-04","validTo":"1995-09-30","current":false,"derived":true,"evidenceMineId":"4300113","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|L06166|1983-05-04|M03846|1983-05-04|130274"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M06183","name":"CRH PLC"},"object":{"type":"mine","id":"4300113","name":"GUILDHALL SAND & GRAVEL"},"validFrom":"1988-06-02","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|M06183|1988-06-02|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L14787","name":"Newport Sand & Gravel Co/Carroll Concrete"},"object":{"type":"mine","id":"4300113","name":"GUILDHALL SAND & GRAVEL"},"validFrom":"1995-10-01","validTo":"2026-02-08","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|L14787|1995-10-01|2026-02-08"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M05738","name":"Shaun P  Carroll"},"object":{"type":"mine","id":"4300113","name":"GUILDHALL SAND & GRAVEL"},"validFrom":"1995-10-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|M05738|1995-10-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M05738","name":"Shaun P  Carroll"},"object":{"type":"operator","id":"L14787","name":"Newport Sand & Gravel Co/Carroll Concrete"},"validFrom":"1995-10-01","validTo":"2026-02-08","current":false,"derived":true,"evidenceMineId":"4300113","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|L14787|1995-10-01|M05738|1995-10-01|135316"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L10129","name":"Pike Industries"},"object":{"type":"mine","id":"4300113","name":"GUILDHALL SAND & GRAVEL"},"validFrom":"2026-02-09","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|L10129|2026-02-09|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M06183","name":"CRH PLC"},"object":{"type":"operator","id":"L10129","name":"Pike Industries"},"validFrom":"2026-02-09","validTo":null,"current":true,"derived":true,"evidenceMineId":"4300113","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-17T05:35:58.500035+00:00","recordKey":"4300113|L10129|2026-02-09|M06183|1988-06-02|136624"}}],"coverage":{"historyRecords":4,"edgeCount":12,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"4300113","dataSource":"postgres","snapshotId":"2026-10-17T05:35:58.500035+00:00","completedAt":"2026-10-17T06:17:15.228Z","sourceCount":20,"totalRows":15450873,"relationshipSemantics":"valid time; null validTo means current or open-ended in the source"}}