{"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":"3609574","name":"Palmer"},"operator":{"type":"operator","id":"0109368","name":"Three Rivers Aggregates LLC"},"controller":{"type":"controller","id":"0174681","name":"Sweet Water Quarries LLC; Three River Agg Holding LLC"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M11926","name":"Ennstone PLC"},"object":{"type":"mine","id":"3609574","name":"Palmer"},"validFrom":"1997-07-29","validTo":"2009-06-10","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|M11926|1997-07-29|2009-06-10"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L16200","name":"Three Rivers Aggregates"},"object":{"type":"mine","id":"3609574","name":"Palmer"},"validFrom":"2007-12-11","validTo":"2010-04-18","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|L16200|2007-12-11|2010-04-18"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M11926","name":"Ennstone PLC"},"object":{"type":"operator","id":"L16200","name":"Three Rivers Aggregates"},"validFrom":"2007-12-11","validTo":"2009-06-10","current":false,"derived":true,"evidenceMineId":"3609574","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|L16200|2007-12-11|M11926|1997-07-29|152703"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0085833","name":"Mark  Elliott"},"object":{"type":"mine","id":"3609574","name":"Palmer"},"validFrom":"2009-06-11","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|0085833|2009-06-11|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0085833","name":"Mark  Elliott"},"object":{"type":"operator","id":"L16200","name":"Three Rivers Aggregates"},"validFrom":"2009-06-11","validTo":"2010-04-18","current":false,"derived":true,"evidenceMineId":"3609574","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|L16200|2007-12-11|0085833|2009-06-11|13781"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0109368","name":"Three Rivers Aggregates LLC"},"object":{"type":"mine","id":"3609574","name":"Palmer"},"validFrom":"2010-04-19","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|0109368|2010-04-19|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0092499","name":"Lindy Paving Incorporated et al"},"object":{"type":"mine","id":"3609574","name":"Palmer"},"validFrom":"2010-04-19","validTo":"2021-12-31","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|0092499|2010-04-19|2021-12-31"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0092499","name":"Lindy Paving Incorporated et al"},"object":{"type":"operator","id":"0109368","name":"Three Rivers Aggregates LLC"},"validFrom":"2010-04-19","validTo":"2021-12-31","current":false,"derived":true,"evidenceMineId":"3609574","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|0109368|2010-04-19|0092499|2010-04-19|15176"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0092499","name":"Sweet Water Quarries LLC et al"},"object":{"type":"operator","id":"0109368","name":"Three Rivers Aggregates LLC"},"validFrom":"2010-04-19","validTo":"2021-12-31","current":false,"derived":true,"evidenceMineId":"3609574","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|0109368|2010-04-19|0092499|2010-04-19|15177"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0174681","name":"Three River Agg Holding LLC et al"},"object":{"type":"mine","id":"3609574","name":"Palmer"},"validFrom":"2022-01-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|0174681|2022-01-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0174681","name":"Three River Agg Holding LLC et al"},"object":{"type":"operator","id":"0109368","name":"Three Rivers Aggregates LLC"},"validFrom":"2022-01-01","validTo":null,"current":true,"derived":true,"evidenceMineId":"3609574","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|0109368|2010-04-19|0174681|2022-01-01|37161"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0174681","name":"Sweet Water Quarries LLC et al"},"object":{"type":"operator","id":"0109368","name":"Three Rivers Aggregates LLC"},"validFrom":"2022-01-01","validTo":null,"current":true,"derived":true,"evidenceMineId":"3609574","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"3609574|0109368|2010-04-19|0174681|2022-01-01|37162"}}],"coverage":{"historyRecords":6,"edgeCount":12,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"3609574","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"}}