{"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-18T09:31:49.615908+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":"2700492","name":"Rodrigue's Gravel and Excavation Inc."},"operator":{"type":"operator","id":"0183733","name":"Rodrigue's Gravel and Excavation Inc"},"controller":{"type":"controller","id":"0170340","name":"Michel  Rodrigue; Ronny  Rodrigue"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-18T09:31:49.615908+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"0140293","name":"Daniel Ouimette"},"object":{"type":"mine","id":"2700492","name":"Rodrigue's Gravel and Excavation Inc."},"validFrom":"2015-07-29","validTo":"2022-06-29","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"2700492|0140293|2015-07-29|2022-06-29"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0119481","name":"Daniel  Ouimette"},"object":{"type":"mine","id":"2700492","name":"Rodrigue's Gravel and Excavation Inc."},"validFrom":"2015-07-29","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"2700492|0119481|2015-07-29|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0119481","name":"Daniel  Ouimette"},"object":{"type":"operator","id":"0140293","name":"Daniel Ouimette"},"validFrom":"2015-07-29","validTo":"2022-06-29","current":false,"derived":true,"evidenceMineId":"2700492","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"2700492|0140293|2015-07-29|0119481|2015-07-29|22846"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0183733","name":"Rodrigue's Gravel and Excavation Inc"},"object":{"type":"mine","id":"2700492","name":"Rodrigue's Gravel and Excavation Inc."},"validFrom":"2022-06-30","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"2700492|0183733|2022-06-30|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0170340","name":"Ronny  Rodrigue et al"},"object":{"type":"mine","id":"2700492","name":"Rodrigue's Gravel and Excavation Inc."},"validFrom":"2022-06-30","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"2700492|0170340|2022-06-30|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0170340","name":"Ronny  Rodrigue et al"},"object":{"type":"operator","id":"0183733","name":"Rodrigue's Gravel and Excavation Inc"},"validFrom":"2022-06-30","validTo":null,"current":true,"derived":true,"evidenceMineId":"2700492","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"2700492|0183733|2022-06-30|0170340|2022-06-30|36096"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0170340","name":"Michel  Rodrigue et al"},"object":{"type":"operator","id":"0183733","name":"Rodrigue's Gravel and Excavation Inc"},"validFrom":"2022-06-30","validTo":null,"current":true,"derived":true,"evidenceMineId":"2700492","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"2700492|0183733|2022-06-30|0170340|2022-06-30|36097"}}],"coverage":{"historyRecords":3,"edgeCount":7,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"2700492","dataSource":"postgres","snapshotId":"2026-10-18T09:31:49.615908+00:00","completedAt":"2026-10-18T09:31:49.615Z","sourceCount":20,"totalRows":17915666,"relationshipSemantics":"valid time; null validTo means current or open-ended in the source"}}