{"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":"4105525","name":"Lappe Sand and Gravel"},"operator":{"type":"operator","id":"0191153","name":"Lappe Sand and Gravel"},"controller":{"type":"controller","id":"0179361","name":"Brett  Lappe"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-18T09:31:49.615908+00:00"}},"edges":[{"type":"operator_operates_mine","subject":{"type":"operator","id":"0174233","name":"Bushwackers Land Services, LLC"},"object":{"type":"mine","id":"4105525","name":"Lappe Sand and Gravel"},"validFrom":"2020-11-05","validTo":"2023-06-30","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"4105525|0174233|2020-11-05|2023-06-30"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0159161","name":"Rick  Sandberg"},"object":{"type":"mine","id":"4105525","name":"Lappe Sand and Gravel"},"validFrom":"2020-11-05","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"4105525|0159161|2020-11-05|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0159161","name":"Rick  Sandberg"},"object":{"type":"operator","id":"0174233","name":"Bushwackers Land Services, LLC"},"validFrom":"2020-11-05","validTo":"2023-06-30","current":false,"derived":true,"evidenceMineId":"4105525","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"4105525|0174233|2020-11-05|0159161|2020-11-05|33075"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0191153","name":"Lappe Sand and Gravel"},"object":{"type":"mine","id":"4105525","name":"Lappe Sand and Gravel"},"validFrom":"2023-07-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"4105525|0191153|2023-07-01|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0179361","name":"Brett  Lappe"},"object":{"type":"mine","id":"4105525","name":"Lappe Sand and Gravel"},"validFrom":"2023-07-01","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"4105525|0179361|2023-07-01|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0179361","name":"Brett  Lappe"},"object":{"type":"operator","id":"0191153","name":"Lappe Sand and Gravel"},"validFrom":"2023-07-01","validTo":null,"current":true,"derived":true,"evidenceMineId":"4105525","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-18T09:31:49.615908+00:00","recordKey":"4105525|0191153|2023-07-01|0179361|2023-07-01|38379"}}],"coverage":{"historyRecords":2,"edgeCount":6,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"4105525","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"}}