{"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":"1401757","name":"Waterwell"},"operator":{"type":"operator","id":"0164513","name":"American Sand & Gravel, LLC"},"controller":{"type":"controller","id":"0148781","name":"Tod  Roberg"},"source":{"datasetId":"msha-mines","observedAt":"2026-10-13T11:19:05.459773+00:00"}},"edges":[{"type":"controller_controls_mine","subject":{"type":"controller","id":"M01709","name":"Dane Q  Barclay et al"},"object":{"type":"mine","id":"1401757","name":"Waterwell"},"validFrom":"1950-01-01","validTo":"2017-05-10","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401757|M01709|1950-01-01|2017-05-10"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"L01897","name":"Alsop Sand Co., Inc."},"object":{"type":"mine","id":"1401757","name":"Waterwell"},"validFrom":"2013-03-08","validTo":"2019-06-12","current":false,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401757|L01897|2013-03-08|2019-06-12"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M01709","name":"Dane Q  Barclay et al"},"object":{"type":"operator","id":"L01897","name":"Alsop Sand Co., Inc."},"validFrom":"2013-03-08","validTo":"2017-05-10","current":false,"derived":true,"evidenceMineId":"1401757","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401757|L01897|2013-03-08|M01709|1950-01-01|120500"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"M01709","name":"David H  Barclay et al"},"object":{"type":"operator","id":"L01897","name":"Alsop Sand Co., Inc."},"validFrom":"2013-03-08","validTo":"2017-05-10","current":false,"derived":true,"evidenceMineId":"1401757","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401757|L01897|2013-03-08|M01709|1950-01-01|120501"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0133547","name":"Dane Q Barclay"},"object":{"type":"mine","id":"1401757","name":"Waterwell"},"validFrom":"2017-05-11","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401757|0133547|2017-05-11|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0133547","name":"Dane Q Barclay"},"object":{"type":"operator","id":"L01897","name":"Alsop Sand Co., Inc."},"validFrom":"2017-05-11","validTo":"2019-06-12","current":false,"derived":true,"evidenceMineId":"1401757","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401757|L01897|2013-03-08|0133547|2017-05-11|26899"}},{"type":"operator_operates_mine","subject":{"type":"operator","id":"0164513","name":"American Sand & Gravel, LLC"},"object":{"type":"mine","id":"1401757","name":"Waterwell"},"validFrom":"2019-06-13","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401757|0164513|2019-06-13|"}},{"type":"controller_controls_mine","subject":{"type":"controller","id":"0148781","name":"Tod  Roberg"},"object":{"type":"mine","id":"1401757","name":"Waterwell"},"validFrom":"2019-06-13","validTo":null,"current":true,"derived":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401757|0148781|2019-06-13|"}},{"type":"controller_controls_operator","subject":{"type":"controller","id":"0148781","name":"Tod  Roberg"},"object":{"type":"operator","id":"0164513","name":"American Sand & Gravel, LLC"},"validFrom":"2019-06-13","validTo":null,"current":true,"derived":true,"evidenceMineId":"1401757","intervalAnomaly":false,"source":{"datasetId":"msha-controller-operator-history","observedAt":"2026-10-13T11:19:05.459773+00:00","recordKey":"1401757|0164513|2019-06-13|0148781|2019-06-13|30426"}}],"coverage":{"historyRecords":4,"edgeCount":9,"intervalAnomalies":0,"sourceDatasetId":"msha-controller-operator-history"}},"meta":{"mineId":"1401757","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"}}