{"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":"0403366","name":"Aguanga Plant"},"operator":{"type":"operator","id":"0051471","name":"Shamrock Sand & Rock  LLC"},"controller":{"type":"controller","id":"M08191","name":"J Brouwer Investments Inc"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"L08388","name":"Shamrock Sand & Rock Corp"},"object":{"type":"mine","id":"0403366","name":"Aguanga Plant"},"validFrom":"1950-01-01","validTo":"1985-03-05","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|L08388|1950-01-01|1985-03-05"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M06666","name":"John L  Marana"},"object":{"type":"mine","id":"0403366","name":"Aguanga Plant"},"validFrom":"1950-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|M06666|1950-01-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M06666","name":"John L  Marana"},"object":{"type":"operator","id":"L08388","name":"Shamrock Sand & Rock Corp"},"validFrom":"1950-01-01","validTo":"1985-03-05","current":false,"derived":true,"evidenceMineId":"0403366","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|L08388|1950-01-01|M06666|1950-01-01|139032"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M06667","name":"Ronald W Pharris"},"object":{"type":"mine","id":"0403366","name":"Aguanga Plant"},"validFrom":"1950-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|M06667|1950-01-01|"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L08389","name":"C L Pharris Sand & Gravel Inc"},"object":{"type":"mine","id":"0403366","name":"Aguanga Plant"},"validFrom":"1985-03-06","validTo":"1992-01-17","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|L08389|1985-03-06|1992-01-17"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M06667","name":"Ronald W Pharris"},"object":{"type":"operator","id":"L08389","name":"C L Pharris Sand & Gravel Inc"},"validFrom":"1985-03-06","validTo":"1992-01-17","current":false,"derived":true,"evidenceMineId":"0403366","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|L08389|1985-03-06|M06667|1950-01-01|139035"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L13202","name":"Sunwest Materials"},"object":{"type":"mine","id":"0403366","name":"Aguanga Plant"},"validFrom":"1992-01-18","validTo":"1995-06-12","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|L13202|1992-01-18|1995-06-12"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M09149","name":"Cemex S A"},"object":{"type":"mine","id":"0403366","name":"Aguanga Plant"},"validFrom":"1992-01-18","validTo":"1995-06-12","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|M09149|1992-01-18|1995-06-12"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M09149","name":"Cemex S A"},"object":{"type":"operator","id":"L13202","name":"Sunwest Materials"},"validFrom":"1992-01-18","validTo":"1995-06-12","current":false,"derived":true,"evidenceMineId":"0403366","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|L13202|1992-01-18|M09149|1992-01-18|145251"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L08388","name":"Shamrock Sand & Rock Corp"},"object":{"type":"mine","id":"0403366","name":"Aguanga Plant"},"validFrom":"1995-06-13","validTo":"2003-04-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|L08388|1995-06-13|2003-04-30"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M06666","name":"John L  Marana"},"object":{"type":"operator","id":"L08388","name":"Shamrock Sand & Rock Corp"},"validFrom":"1995-06-13","validTo":"2003-04-30","current":false,"derived":true,"evidenceMineId":"0403366","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|L08388|1995-06-13|M06666|1950-01-01|139033"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0051471","name":"Shamrock Sand & Rock  LLC"},"object":{"type":"mine","id":"0403366","name":"Aguanga Plant"},"validFrom":"2003-05-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|0051471|2003-05-01|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"M08191","name":"J Brouwer Investments Inc Et Al"},"object":{"type":"mine","id":"0403366","name":"Aguanga Plant"},"validFrom":"2003-05-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|M08191|2003-05-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M08191","name":"J Brouwer Investments Inc Et Al"},"object":{"type":"operator","id":"0051471","name":"Shamrock Sand & Rock  LLC"},"validFrom":"2003-05-01","validTo":null,"current":true,"derived":true,"evidenceMineId":"0403366","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"0403366|0051471|2003-05-01|M08191|2003-05-01|142883"}}],"coverage":{"historyRecords":5,"edgeCount":14,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"0403366","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"}}