{"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-13T11:19:05.459773+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":"4103476","name":"Sand Supply #3"},"operator":{"type":"operator","id":"L15191","name":"Campbell Concrete & Materials LP Sand Supply Div"},"controller":{"type":"controller","id":"M00004","name":"Heidelberg Materials AG"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M07589","name":"Campbell Sand LLC  et al"},"object":{"type":"mine","id":"4103476","name":"Sand Supply #3"},"validFrom":"1983-10-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4103476|M07589|1983-10-01|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L09685","name":"Aggresource Ltd"},"object":{"type":"mine","id":"4103476","name":"Sand Supply #3"},"validFrom":"1987-06-01","validTo":"2007-12-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4103476|L09685|1987-06-01|2007-12-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M07589","name":"Campbell Sand LLC  et al"},"object":{"type":"operator","id":"L09685","name":"Aggresource Ltd"},"validFrom":"1987-06-01","validTo":"2007-12-30","current":false,"derived":true,"evidenceMineId":"4103476","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4103476|L09685|1987-06-01|M07589|1983-10-01|141566"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M07589","name":"Morris Sand & Gravel LLC  et al"},"object":{"type":"operator","id":"L09685","name":"Aggresource Ltd"},"validFrom":"1987-06-01","validTo":"2007-12-30","current":false,"derived":true,"evidenceMineId":"4103476","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4103476|L09685|1987-06-01|M07589|1983-10-01|141567"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M11580","name":"Constar Inc  et al"},"object":{"type":"mine","id":"4103476","name":"Sand Supply #3"},"validFrom":"1997-03-17","validTo":"2012-01-09","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4103476|M11580|1997-03-17|2012-01-09"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L15191","name":"Campbell Concrete & Materials LP Sand Supply Div"},"object":{"type":"mine","id":"4103476","name":"Sand Supply #3"},"validFrom":"2007-12-31","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4103476|L15191|2007-12-31|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M11580","name":"Constar Inc  et al"},"object":{"type":"operator","id":"L15191","name":"Campbell Concrete & Materials LP Sand Supply Div"},"validFrom":"2007-12-31","validTo":"2012-01-09","current":false,"derived":true,"evidenceMineId":"4103476","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4103476|L15191|2007-12-31|M11580|1997-03-17|151772"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M00004","name":"Heidelberg Materials AG"},"object":{"type":"mine","id":"4103476","name":"Sand Supply #3"},"validFrom":"2012-01-10","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4103476|M00004|2012-01-10|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M00004","name":"Heidelberg Materials AG"},"object":{"type":"operator","id":"L15191","name":"Campbell Concrete & Materials LP Sand Supply Div"},"validFrom":"2012-01-10","validTo":null,"current":true,"derived":true,"evidenceMineId":"4103476","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"4103476|L15191|2007-12-31|M00004|2012-01-10|101013"}}],"coverage":{"historyRecords":4,"edgeCount":9,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"4103476","dataSource":"postgres","snapshotId":"2026-10-13T11:19:05.459773+00:00","completedAt":"2026-10-13T11:26:59.401Z","sourceCount":20,"totalRows":17906804,"relationshipSemantics":"valid time; null validTo means current or open-ended in the source"}}